|
Lines 265-271
sub GetImportBatch {
Link Here
|
| 265 |
my ($batch_id) = @_; |
265 |
my ($batch_id) = @_; |
| 266 |
|
266 |
|
| 267 |
my $dbh = C4::Context->dbh; |
267 |
my $dbh = C4::Context->dbh; |
| 268 |
my $sth = $dbh->prepare_cached("SELECT b.*, p.name as profile FROM import_batches b LEFT JOIN import_batches_profile p ON p.id = b.profile_id WHERE import_batch_id = ?"); |
268 |
my $sth = $dbh->prepare_cached("SELECT b.*, p.name as profile FROM import_batches b LEFT JOIN import_batch_profiles p ON p.id = b.profile_id WHERE import_batch_id = ?"); |
| 269 |
$sth->bind_param(1, $batch_id); |
269 |
$sth->bind_param(1, $batch_id); |
| 270 |
$sth->execute(); |
270 |
$sth->execute(); |
| 271 |
my $result = $sth->fetchrow_hashref; |
271 |
my $result = $sth->fetchrow_hashref; |
|
Lines 1024-1030
sub GetImportBatchRangeDesc {
Link Here
|
| 1024 |
|
1024 |
|
| 1025 |
my $dbh = C4::Context->dbh; |
1025 |
my $dbh = C4::Context->dbh; |
| 1026 |
my $query = "SELECT b.*, p.name as profile FROM import_batches b |
1026 |
my $query = "SELECT b.*, p.name as profile FROM import_batches b |
| 1027 |
LEFT JOIN import_batches_profile p |
1027 |
LEFT JOIN import_batch_profiles p |
| 1028 |
ON b.profile_id = p.id |
1028 |
ON b.profile_id = p.id |
| 1029 |
WHERE b.batch_type IN ('batch', 'webservice') |
1029 |
WHERE b.batch_type IN ('batch', 'webservice') |
| 1030 |
ORDER BY b.import_batch_id DESC"; |
1030 |
ORDER BY b.import_batch_id DESC"; |
| 1031 |
- |
|
|