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 |
- |
|
|