serials: copy templates need dropdown menus for age protect and circ as type fields

[Kathy Lussier]

Evergreen version 2.3

The copy templates editor for serials provides text boxes for the age protect and circ as type fields. These fields should really be dropdown menus allowing users to select the age protection options available on their system and to select circ as type options, which are difficult for the average user to remember.

[Jennifer Pringle (jpringle-u)]

I agree, our average user is not going to remember what text to put into these fields.

[Andrea Neiman (aneiman)]

Still seeing this in 2.10

[Michele Morgan (mmorgan)]

This bug still exists in 2.12 in both the xul and web clients.

[Michele Morgan (mmorgan)]

Fix pushed to:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/mmorgan/LP_1075401_Populate_age_protect_and_circ_as_type_fields_in_serials_template

This changes the fm_IDL.xml entries for age_protect and circ_as_type fields to links, which provides the dropdowns for the fields in both the web and xul clients.

Targeting to 2.12.1

[Galen Charlton (gmc)]

I've reviewed the patch. The patch itself works fine when asset.copy_template has valid values in age_protect and circ_as_type: the age protect / circ as type columns in the grid display the names, and the dialog uses drop-downs for selecting values.

However, any existing copy templates that have invalid values in either of those two columns will break the grid. In particular, once it hits a row where age_protect/circ_as_type is not null but doesn't contain the ID of a related row in the config.* table, the grid will stop rendering.

Consequently, I think there will also need an upgrade script that checks for whether data cleanup is needed, similar to commit c40982ee3a6b for bug 1552861. However, rather than deleting invalid copy templates, it should probably just set age_protect / circ_as_type to NULL as needed (and report that it has done so.)

[Michele Morgan (mmorgan)]

I added an upgrade script to nullify invalid values in existing templates as Galen suggested and forced pushed to the same branch.

[Josh Stompro (u-launchpad-stompro-org)]

I created two serial copy templates and then changed the "Age Hold protect" and "Circ as type" to invalid values.

update asset.copy_template set circ_as_type='zzz', age_protect=1000 where id=1;
update asset.copy_template set circ_as_type='blee', age_protect=1001 where id=2;

After those changes, I can see that the grid in the serial copy template editor no longer loads.

Then I ran the upgrade script and it seemed to work, with a strange requirement that I click the back link in the grid to get them to show up. I also noticed that the floating group field is displaying the id number and not the name in the editing view. And in the grid view the Owning Lib, Loan Duration, Fine Level, and Floating Group are shown as the ID numbers and not as the linked values.

I see how to fix the Owning Lib from looking at another admin interface that does it.

The upgrade script doesn't let you know which templates were updated. Adding some returning output should solve that. I'll create a new branch to share with a few changes.

Josh

[Josh Stompro (u-launchpad-stompro-org)]

Michele, I made some changes to your branch - http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/stompro/LP_1075401_Populate_age_protect_and_circ_as_type_fields_in_serials_template

1. Changed the reporter:datatype to org_unit for the owning_lib and circ_lib. That seems to trigger the autogrid to display the shortname instead of the aou.id.

2. Changed the config.floating_group cfg definition so that the reporter.selector value is set to name for the id field. This causes the autogrid to use the display name for choosing the floating group.

3. Expanded on the upgrade script so that the name and owning_lib are displayed for any templates that have their values updated.

Josh

[Galen Charlton (gmc)]

Pushed to master for inclusion in 3.0. Thanks, Michele and Josh!