|
Lines 982-988
ascending order by import_batch_id.
Link Here
|
| 982 |
|
982 |
|
| 983 |
=cut |
983 |
=cut |
| 984 |
|
984 |
|
| 985 |
sub GetAllImportBatches { |
985 |
sub GetAllImportBatches { |
| 986 |
my $dbh = C4::Context->dbh; |
986 |
my $dbh = C4::Context->dbh; |
| 987 |
my $sth = $dbh->prepare_cached("SELECT * FROM import_batches |
987 |
my $sth = $dbh->prepare_cached("SELECT * FROM import_batches |
| 988 |
WHERE batch_type IN ('batch', 'webservice') |
988 |
WHERE batch_type IN ('batch', 'webservice') |
|
Lines 1011-1017
SELECT import_batch_id FROM import_batches
Link Here
|
| 1011 |
WHERE batch_type = 'webservice' |
1011 |
WHERE batch_type = 'webservice' |
| 1012 |
AND import_status = 'staged' |
1012 |
AND import_status = 'staged' |
| 1013 |
EOQ |
1013 |
EOQ |
| 1014 |
sub GetStagedWebserviceBatches { |
1014 |
sub GetStagedWebserviceBatches { |
| 1015 |
my $dbh = C4::Context->dbh; |
1015 |
my $dbh = C4::Context->dbh; |
| 1016 |
return $dbh->selectcol_arrayref($PENDING_WEBSERVICE_BATCHES_QRY); |
1016 |
return $dbh->selectcol_arrayref($PENDING_WEBSERVICE_BATCHES_QRY); |
| 1017 |
} |
1017 |
} |