Lines 1156-1162
sub ModSubscription {
Link Here
|
1156 |
$whenmorethan1, $setto1, $lastvalue1, $innerloop1, $add2, $every2, $whenmorethan2, $setto2, |
1156 |
$whenmorethan1, $setto1, $lastvalue1, $innerloop1, $add2, $every2, $whenmorethan2, $setto2, |
1157 |
$lastvalue2, $innerloop2, $add3, $every3, $whenmorethan3, $setto3, $lastvalue3, $innerloop3, |
1157 |
$lastvalue2, $innerloop2, $add3, $every3, $whenmorethan3, $setto3, $lastvalue3, $innerloop3, |
1158 |
$numberingmethod, $status, $biblionumber, $callnumber, $notes, $letter, $hemisphere, $manualhistory, |
1158 |
$numberingmethod, $status, $biblionumber, $callnumber, $notes, $letter, $hemisphere, $manualhistory, |
1159 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, $subscriptionid |
1159 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, $subscriptionid, |
|
|
1160 |
$seriallifespan |
1160 |
) = @_; |
1161 |
) = @_; |
1161 |
|
1162 |
|
1162 |
# warn $irregularity; |
1163 |
# warn $irregularity; |
Lines 1170-1176
sub ModSubscription {
Link Here
|
1170 |
numberingmethod=?, status=?, biblionumber=?, callnumber=?, notes=?, |
1171 |
numberingmethod=?, status=?, biblionumber=?, callnumber=?, notes=?, |
1171 |
letter=?, hemisphere=?,manualhistory=?,internalnotes=?,serialsadditems=?, |
1172 |
letter=?, hemisphere=?,manualhistory=?,internalnotes=?,serialsadditems=?, |
1172 |
staffdisplaycount = ?,opacdisplaycount = ?, graceperiod = ?, location = ? |
1173 |
staffdisplaycount = ?,opacdisplaycount = ?, graceperiod = ?, location = ? |
1173 |
,enddate=? |
1174 |
,enddate=?, seriallifespan=? |
1174 |
WHERE subscriptionid = ?"; |
1175 |
WHERE subscriptionid = ?"; |
1175 |
|
1176 |
|
1176 |
#warn "query :".$query; |
1177 |
#warn "query :".$query; |
Lines 1187-1193
sub ModSubscription {
Link Here
|
1187 |
$numberingmethod, $status, $biblionumber, $callnumber, |
1188 |
$numberingmethod, $status, $biblionumber, $callnumber, |
1188 |
$notes, $letter, $hemisphere, ( $manualhistory ? $manualhistory : 0 ), |
1189 |
$notes, $letter, $hemisphere, ( $manualhistory ? $manualhistory : 0 ), |
1189 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, |
1190 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, |
1190 |
$graceperiod, $location, $enddate, $subscriptionid |
1191 |
$graceperiod, $location, $enddate, $seriallifespan, $subscriptionid |
1191 |
); |
1192 |
); |
1192 |
my $rows = $sth->rows; |
1193 |
my $rows = $sth->rows; |
1193 |
|
1194 |
|
Lines 1213-1224
the id of this new subscription
Link Here
|
1213 |
=cut |
1214 |
=cut |
1214 |
|
1215 |
|
1215 |
sub NewSubscription { |
1216 |
sub NewSubscription { |
|
|
1217 |
|
1216 |
my ($auser, $branchcode, $aqbooksellerid, $cost, $aqbudgetid, $biblionumber, $startdate, $periodicity, |
1218 |
my ($auser, $branchcode, $aqbooksellerid, $cost, $aqbudgetid, $biblionumber, $startdate, $periodicity, |
1217 |
$dow, $numberlength, $weeklength, $monthlength, $add1, $every1, $whenmorethan1, $setto1, |
1219 |
$dow, $numberlength, $weeklength, $monthlength, $add1, $every1, $whenmorethan1, $setto1, |
1218 |
$lastvalue1, $innerloop1, $add2, $every2, $whenmorethan2, $setto2, $lastvalue2, $innerloop2, |
1220 |
$lastvalue1, $innerloop1, $add2, $every2, $whenmorethan2, $setto2, $lastvalue2, $innerloop2, |
1219 |
$add3, $every3, $whenmorethan3, $setto3, $lastvalue3, $innerloop3, $numberingmethod, $status, |
1221 |
$add3, $every3, $whenmorethan3, $setto3, $lastvalue3, $innerloop3, $numberingmethod, $status, |
1220 |
$notes, $letter, $firstacquidate, $irregularity, $numberpattern, $callnumber, $hemisphere, $manualhistory, |
1222 |
$notes, $letter, $firstacquidate, $irregularity, $numberpattern, $callnumber, $hemisphere, $manualhistory, |
1221 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate |
1223 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, $seriallifespan |
1222 |
) = @_; |
1224 |
) = @_; |
1223 |
my $dbh = C4::Context->dbh; |
1225 |
my $dbh = C4::Context->dbh; |
1224 |
|
1226 |
|
Lines 1232-1239
sub NewSubscription {
Link Here
|
1232 |
add3,every3,whenmorethan3,setto3,lastvalue3,innerloop3, |
1234 |
add3,every3,whenmorethan3,setto3,lastvalue3,innerloop3, |
1233 |
numberingmethod, status, notes, letter,firstacquidate,irregularity, |
1235 |
numberingmethod, status, notes, letter,firstacquidate,irregularity, |
1234 |
numberpattern, callnumber, hemisphere,manualhistory,internalnotes,serialsadditems, |
1236 |
numberpattern, callnumber, hemisphere,manualhistory,internalnotes,serialsadditems, |
1235 |
staffdisplaycount,opacdisplaycount,graceperiod,location,enddate) |
1237 |
staffdisplaycount,opacdisplaycount,graceperiod,location,enddate,seriallifespan) |
1236 |
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
1238 |
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
1237 |
|; |
1239 |
|; |
1238 |
my $sth = $dbh->prepare($query); |
1240 |
my $sth = $dbh->prepare($query); |
1239 |
$sth->execute( |
1241 |
$sth->execute( |
Lines 1242-1248
sub NewSubscription {
Link Here
|
1242 |
$lastvalue1, $innerloop1, $add2, $every2, $whenmorethan2, $setto2, $lastvalue2, $innerloop2, |
1244 |
$lastvalue1, $innerloop1, $add2, $every2, $whenmorethan2, $setto2, $lastvalue2, $innerloop2, |
1243 |
$add3, $every3, $whenmorethan3, $setto3, $lastvalue3, $innerloop3, $numberingmethod, "$status", |
1245 |
$add3, $every3, $whenmorethan3, $setto3, $lastvalue3, $innerloop3, $numberingmethod, "$status", |
1244 |
$notes, $letter, $firstacquidate, $irregularity, $numberpattern, $callnumber, $hemisphere, $manualhistory, |
1246 |
$notes, $letter, $firstacquidate, $irregularity, $numberpattern, $callnumber, $hemisphere, $manualhistory, |
1245 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate |
1247 |
$internalnotes, $serialsadditems, $staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, $seriallifespan |
1246 |
); |
1248 |
); |
1247 |
|
1249 |
|
1248 |
my $subscriptionid = $dbh->{'mysql_insertid'}; |
1250 |
my $subscriptionid = $dbh->{'mysql_insertid'}; |