Lines 838-844
sub GetItemsForInventory {
Link Here
|
838 |
FROM items |
838 |
FROM items |
839 |
LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber |
839 |
LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber |
840 |
LEFT JOIN biblioitems on items.biblionumber = biblioitems.biblionumber |
840 |
LEFT JOIN biblioitems on items.biblionumber = biblioitems.biblionumber |
841 |
WHERE (items.deleted_at IS NULL AND biblio.deleted_at IS NULL AND biblioitems.deleted_at IS NULL) |
841 |
WHERE (items.deleted_on IS NULL AND biblio.deleted_on IS NULL AND biblioitems.deleted_on IS NULL) |
842 |
}; |
842 |
}; |
843 |
if ($statushash){ |
843 |
if ($statushash){ |
844 |
for my $authvfield (keys %$statushash){ |
844 |
for my $authvfield (keys %$statushash){ |
Lines 945-951
Called by C<C4::XISBN>
Link Here
|
945 |
sub GetItemsByBiblioitemnumber { |
945 |
sub GetItemsByBiblioitemnumber { |
946 |
my ( $bibitem ) = @_; |
946 |
my ( $bibitem ) = @_; |
947 |
my $dbh = C4::Context->dbh; |
947 |
my $dbh = C4::Context->dbh; |
948 |
my $sth = $dbh->prepare("SELECT * FROM items WHERE items.biblioitemnumber = ? AND items.deleted_at IS NULL") || die $dbh->errstr; |
948 |
my $sth = $dbh->prepare("SELECT * FROM items WHERE items.biblioitemnumber = ? AND items.deleted_on IS NULL") || die $dbh->errstr; |
949 |
# Get all items attached to a biblioitem |
949 |
# Get all items attached to a biblioitem |
950 |
my $i = 0; |
950 |
my $i = 0; |
951 |
my @results; |
951 |
my @results; |
Lines 1069-1075
sub GetItemsInfo {
Link Here
|
1069 |
FROM items |
1069 |
FROM items |
1070 |
LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode |
1070 |
LEFT JOIN branches AS holding ON items.holdingbranch = holding.branchcode |
1071 |
LEFT JOIN branches AS home ON items.homebranch=home.branchcode |
1071 |
LEFT JOIN branches AS home ON items.homebranch=home.branchcode |
1072 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber AND biblio.deleted_at IS NULL |
1072 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber AND biblio.deleted_on IS NULL |
1073 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
1073 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
1074 |
LEFT JOIN issues USING (itemnumber) |
1074 |
LEFT JOIN issues USING (itemnumber) |
1075 |
LEFT JOIN borrowers USING (borrowernumber) |
1075 |
LEFT JOIN borrowers USING (borrowernumber) |
Lines 1083-1089
sub GetItemsInfo {
Link Here
|
1083 |
AND localization.lang = ? |
1083 |
AND localization.lang = ? |
1084 |
|; |
1084 |
|; |
1085 |
|
1085 |
|
1086 |
$query .= " WHERE items.biblionumber = ? AND items.deleted_at IS NULL ORDER BY home.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ; |
1086 |
$query .= " WHERE items.biblionumber = ? AND items.deleted_on IS NULL ORDER BY home.branchname, items.enumchron, LPAD( items.copynumber, 8, '0' ), items.dateaccessioned DESC" ; |
1087 |
my $sth = $dbh->prepare($query); |
1087 |
my $sth = $dbh->prepare($query); |
1088 |
$sth->execute($language, $biblionumber); |
1088 |
$sth->execute($language, $biblionumber); |
1089 |
my $i = 0; |
1089 |
my $i = 0; |
Lines 1190-1196
sub GetItemsLocationInfo {
Link Here
|
1190 |
location, itemcallnumber, cn_sort |
1190 |
location, itemcallnumber, cn_sort |
1191 |
FROM items, branches as a, branches as b |
1191 |
FROM items, branches as a, branches as b |
1192 |
WHERE homebranch = a.branchcode AND holdingbranch = b.branchcode |
1192 |
WHERE homebranch = a.branchcode AND holdingbranch = b.branchcode |
1193 |
AND biblionumber = ? AND deleted_at IS NULL |
1193 |
AND biblionumber = ? AND deleted_on IS NULL |
1194 |
ORDER BY cn_sort ASC"; |
1194 |
ORDER BY cn_sort ASC"; |
1195 |
my $sth = $dbh->prepare($query); |
1195 |
my $sth = $dbh->prepare($query); |
1196 |
$sth->execute($biblionumber); |
1196 |
$sth->execute($biblionumber); |
Lines 1261-1267
sub GetLastAcquisitions {
Link Here
|
1261 |
my $number_of_branches = @{$data->{branches}}; |
1261 |
my $number_of_branches = @{$data->{branches}}; |
1262 |
my $number_of_itemtypes = @{$data->{itemtypes}}; |
1262 |
my $number_of_itemtypes = @{$data->{itemtypes}}; |
1263 |
|
1263 |
|
1264 |
my @where = ('WHERE (items.deleted_at IS NULL AND biblio.deleted_at IS NULL AND biblioitems.deleted_at IS NULL)'); |
1264 |
my @where = ('WHERE (items.deleted_on IS NULL AND biblio.deleted_on IS NULL AND biblioitems.deleted_on IS NULL)'); |
1265 |
$number_of_branches and push @where |
1265 |
$number_of_branches and push @where |
1266 |
, 'AND holdingbranch IN (' |
1266 |
, 'AND holdingbranch IN (' |
1267 |
, join(',', ('?') x $number_of_branches ) |
1267 |
, join(',', ('?') x $number_of_branches ) |
Lines 1308-1314
sub GetItemnumbersForBiblio {
Link Here
|
1308 |
my $biblionumber = shift; |
1308 |
my $biblionumber = shift; |
1309 |
my @items; |
1309 |
my @items; |
1310 |
my $dbh = C4::Context->dbh; |
1310 |
my $dbh = C4::Context->dbh; |
1311 |
my $sth = $dbh->prepare("SELECT itemnumber FROM items WHERE biblionumber = ? AND deleted_at IS NULL"); |
1311 |
my $sth = $dbh->prepare("SELECT itemnumber FROM items WHERE biblionumber = ? AND deleted_on IS NULL"); |
1312 |
$sth->execute($biblionumber); |
1312 |
$sth->execute($biblionumber); |
1313 |
while (my $result = $sth->fetchrow_hashref) { |
1313 |
while (my $result = $sth->fetchrow_hashref) { |
1314 |
push @items, $result->{'itemnumber'}; |
1314 |
push @items, $result->{'itemnumber'}; |
Lines 2084-2090
sub _koha_delete_item {
Link Here
|
2084 |
|
2084 |
|
2085 |
my $dbh = C4::Context->dbh; |
2085 |
my $dbh = C4::Context->dbh; |
2086 |
|
2086 |
|
2087 |
my $sth = $dbh->prepare("UPDATE items SET deleted_at = NOW() WHERE itemnumber = ?"); |
2087 |
my $sth = $dbh->prepare("UPDATE items SET deleted_on = NOW() WHERE itemnumber = ?"); |
2088 |
my $deleted = $sth->execute($itemnum); |
2088 |
my $deleted = $sth->execute($itemnum); |
2089 |
return ( $deleted == 1 ) ? 1 : 0; |
2089 |
return ( $deleted == 1 ) ? 1 : 0; |
2090 |
} |
2090 |
} |
Lines 2449-2455
sub SearchItems {
Link Here
|
2449 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber |
2449 |
LEFT JOIN biblio ON biblio.biblionumber = items.biblionumber |
2450 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
2450 |
LEFT JOIN biblioitems ON biblioitems.biblioitemnumber = items.biblioitemnumber |
2451 |
LEFT JOIN biblio_metadata ON biblio_metadata.biblionumber = biblio.biblionumber |
2451 |
LEFT JOIN biblio_metadata ON biblio_metadata.biblionumber = biblio.biblionumber |
2452 |
WHERE items.deleted_at IS NULL |
2452 |
WHERE items.deleted_on IS NULL |
2453 |
}; |
2453 |
}; |
2454 |
if (defined $where_str and $where_str ne '') { |
2454 |
if (defined $where_str and $where_str ne '') { |
2455 |
$query .= qq{ AND $where_str }; |
2455 |
$query .= qq{ AND $where_str }; |
Lines 2800-2806
sub ToggleNewStatus {
Link Here
|
2800 |
SELECT items.biblionumber, items.itemnumber |
2800 |
SELECT items.biblionumber, items.itemnumber |
2801 |
FROM items |
2801 |
FROM items |
2802 |
LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber |
2802 |
LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber |
2803 |
WHERE items.deleted_at IS NULL |
2803 |
WHERE items.deleted_on IS NULL |
2804 |
|; |
2804 |
|; |
2805 |
for my $condition ( @$conditions ) { |
2805 |
for my $condition ( @$conditions ) { |
2806 |
if ( |
2806 |
if ( |