|
Lines 916-922
sub GetPreviousSerialid {
Link Here
|
| 916 |
FROM serial |
916 |
FROM serial |
| 917 |
WHERE subscriptionid = ? |
917 |
WHERE subscriptionid = ? |
| 918 |
AND status = 2 |
918 |
AND status = 2 |
| 919 |
ORDER BY serialid DESC LIMIT $nth,1 |
919 |
ORDER BY serialid DESC LIMIT $nth,1 |
| 920 |
"; |
920 |
"; |
| 921 |
my $sth = $dbh->prepare($strsth); |
921 |
my $sth = $dbh->prepare($strsth); |
| 922 |
$sth->execute($subscriptionid); |
922 |
$sth->execute($subscriptionid); |
|
Lines 1463-1469
$subscriptionid = &NewSubscription($auser,branchcode,$aqbooksellerid,$cost,$aqbu
Link Here
|
| 1463 |
$lastvalue1,$innerloop1,$lastvalue2,$innerloop2,$lastvalue3,$innerloop3, |
1463 |
$lastvalue1,$innerloop1,$lastvalue2,$innerloop2,$lastvalue3,$innerloop3, |
| 1464 |
$status, $notes, $letter, $firstacquidate, $irregularity, $numberpattern, |
1464 |
$status, $notes, $letter, $firstacquidate, $irregularity, $numberpattern, |
| 1465 |
$locale, $callnumber, $manualhistory, $internalnotes, $serialsadditems, |
1465 |
$locale, $callnumber, $manualhistory, $internalnotes, $serialsadditems, |
| 1466 |
$staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, |
1466 |
$staffdisplaycount, $opacdisplaycount, $graceperiod, $location, $enddate, |
| 1467 |
$skip_serialseq, $itemtype, $previousitemtype); |
1467 |
$skip_serialseq, $itemtype, $previousitemtype); |
| 1468 |
|
1468 |
|
| 1469 |
Create a new subscription with value given on input args. |
1469 |
Create a new subscription with value given on input args. |