Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
dev:proposal:patron_statistical_categories [2012/01/17 09:26] – [Requirements] sprater | dev:proposal:patron_statistical_categories [2012/03/21 02:37] – [Objects Affected] sprater |
---|
===== Objects Affected ===== | ===== Objects Affected ===== |
| |
All modified files are available at [[https://github.com/sprater/Evergreen/tree/patcatstat|https://github.com/sprater/Evergreen/tree/patcatstat]]. | All modified files are available at [[https://github.com/sprater/Evergreen/tree/patstatcat|https://github.com/sprater/Evergreen/tree/patstatcat]]. |
| |
Comparisons: [[https://github.com/sprater/Evergreen/compare/patcatstat|https://github.com/sprater/Evergreen/compare/patcatstat]] | Comparisons: [[https://github.com/sprater/Evergreen/compare/patstatcat|https://github.com/sprater/Evergreen/compare/patstatcat]] |
| |
**Database TABLE ''actor.stat_cat''** | **Database TABLE ''actor.stat_cat''** |
| |
id SERIAL PRIMARY KEY, | id SERIAL PRIMARY KEY, |
stat_cat_entry INT NOT NULL references actor.stat_cat_entry, | stat_cat_entry INT NOT NULL REFERENCES actor.stat_cat_entry(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
stat_cat INT NOT NULL references actor.stat_cat, | stat_cat INT NOT NULL REFERENCES actor.stat_cat(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
org_unit INT NOT NULL references actor.org_unit, | owner INT NOT NULL REFERENCES actor.org_unit(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
CONSTRAINT sced_once_per_org_unit UNIQUE (stat_cat,org_unit) | CONSTRAINT sced_once_per_owner UNIQUE (stat_cat,owner) |
| |
See [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/sql/Pg/005.schema.actors.sql|005.schema.actors.sql]], [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/sql/Pg/800.fkeys.sql|800.fkeys.sql]] and [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/sql/Pg/950.data.seed-values.sql|950.data.seed-values.sql]]. | See [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/sql/Pg/005.schema.actors.sql|005.schema.actors.sql]] and [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/sql/Pg/950.data.seed-values.sql|950.data.seed-values.sql]]. |
| |
**Statistical category editor** | **Statistical category editor** |
* Add code to manage the new fields in **actor.stat_cat** and the new table **actor.stat_cat_entry_default**. | * Add code to manage the new fields in **actor.stat_cat** and the new table **actor.stat_cat_entry_default**. |
See | See |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/examples/fm_IDL.xml|Open-ILS/examples/fm_IDL.xml]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/examples/fm_IDL.xml|Open-ILS/examples/fm_IDL.xml]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/extras/ils_events.xml|Open-ILS/src/extras/ils_events.xml]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/extras/ils_events.xml|Open-ILS/src/extras/ils_events.xml]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/perlmods/lib/OpenILS/Application/AppUtils.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/AppUtils.pm]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/perlmods/lib/OpenILS/Application/AppUtils.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/AppUtils.pm]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/perlmods/lib/OpenILS/Application/Circ/StatCat.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Circ/StatCat.pm]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/perlmods/lib/OpenILS/Application/Circ/StatCat.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Circ/StatCat.pm]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI.pm]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI.pm]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/CDBI/actor.pm]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/dbi.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/dbi.pm]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/dbi.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/dbi.pm]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm|Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/web/opac/locale/en-US/lang.dtd|Open-ILS/web/opac/locale/en-US/lang.dtd]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/web/opac/locale/en-US/lang.dtd|Open-ILS/web/opac/locale/en-US/lang.dtd]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/xul/staff_client/server/admin/stat_cat_editor.xhtml|Open-ILS/xul/staff_client/server/admin/stat_cat_editor.xhtml]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/xul/staff_client/server/admin/stat_cat_editor.xhtml|Open-ILS/xul/staff_client/server/admin/stat_cat_editor.xhtml]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/xul/staff_client/server/admin/stat_cat_editor.js|Open-ILS/xul/staff_client/server/admin/stat_cat_editor.js]] | * [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/xul/staff_client/server/admin/stat_cat_editor.js|Open-ILS/xul/staff_client/server/admin/stat_cat_editor.js]] |
| |
**Patron registration** | **Patron registration** |
* If a default entry is specified for the org unit and statistical category, mark it as selected by default. | * If a default entry is specified for the org unit and statistical category, mark it as selected by default. |
| |
See | See [[https://github.com/sprater/Evergreen/blob/patstatcat/Open-ILS/web/js/ui/default/actor/user/register.js|Open-ILS/web/js/ui/default/actor/user/register.js]] |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/src/templates/actor/user/register.tt2|Open-ILS/src/templates/actor/user/register.tt2]] | |
* [[https://github.com/sprater/Evergreen/blob/patcatstat/Open-ILS/web/js/ui/default/actor/user/register.js|Open-ILS/web/js/ui/default/actor/user/register.js]] | |
===== Tests ===== | ===== Tests ===== |
| |