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