View | Details | Raw Unified | Return to bug 25624
Collapse All | Expand All

(-)a/misc/cronjobs/update_patrons_category.pl (-5 / +26 lines)
Lines 55-64 Options: Link Here
55
   -fu=X --fineunder=X      update if fines under X amount
55
   -fu=X --fineunder=X      update if fines under X amount
56
   -rb=date --regbefore     update if registration date is before given date
56
   -rb=date --regbefore     update if registration date is before given date
57
   -ra=date --regafter      update if registration date is after a given date
57
   -ra=date --regafter      update if registration date is after a given date
58
   -d --dbfield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value>
58
   -d --field name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value>
59
   -dn --notfield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value>
59
   -dn --notfield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is not equal to given <value>
60
   -dl --likefield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value>
60
   -dl --likefield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is like the given <value>
61
   -dnl --notlikefield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is equal to given <value>
61
   -dnl --notlikefield name=value  where <name> is a column in the borrowers table, patrons will be updated if the field is not like the given <value>
62
   -v -verbose              verbose mode
62
   -v -verbose              verbose mode
63
   -c --confirm             commit changes to db, no action will be taken unless this switch is included
63
   -c --confirm             commit changes to db, no action will be taken unless this switch is included
64
   -b --branch <branchname> only deal with patrons from this library/branch
64
   -b --branch <branchname> only deal with patrons from this library/branch
Lines 125-130 Enter a date in ISO format YYYY-MM-DD and only patrons registered after this dat Link Here
125
=item B<--field column=value | -d column=value>
125
=item B<--field column=value | -d column=value>
126
126
127
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column equals the value supplied (repeatable)
127
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column equals the value supplied (repeatable)
128
A value of null will check for a field that is not set.
128
129
129
e.g.
130
e.g.
130
--field dateexpiry=2016-01-01
131
--field dateexpiry=2016-01-01
Lines 133-143 will update all patrons who expired on that date, useful for schools etc. Link Here
133
=item B<--notfield column=value | -dn column=value>
134
=item B<--notfield column=value | -dn column=value>
134
135
135
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column does not equal the value supplied (repeatable)
136
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column does not equal the value supplied (repeatable)
137
A value of null will check for a field that is not set.
136
138
137
e.g.
139
e.g.
138
--notfield email=NULL
140
--notfield email=NULL
139
will update all patrons with no value for email
141
will update all patrons with no value for email
140
142
143
=item B<--likefield column=value | -dl column=value>
144
145
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column is like the value supplied (repeatable)
146
use '%' as a wildcard.
147
A value of null will check for a field that is not set.
148
149
e.g.
150
--likefield categorycode=%CHILD
151
will update all patrons with a category ending in CHILD.
152
153
=item B<--notlikefield column=value | -dnl column=value>
154
155
Use this flag to specify a column in the borrowers table and update only patrons whose value in that column is not like the value supplied (repeatable)
156
use '%' as a wildcard.
157
A value of null will check for a field that is not set.
158
159
e.g.
160
--notlikefield categorycode=RESIDENT%
161
will update all patrons whose category does not begin with RESIDENT.
162
141
=back
163
=back
142
164
143
=head1 DESCRIPTION
165
=head1 DESCRIPTION
144
- 

Return to bug 25624