View | Details | Raw Unified | Return to bug 32029
Collapse All | Expand All

(-)a/C4/Items.pm (+3 lines)
Lines 1568-1573 sub ToggleNewStatus { Link Here
1568
    my @errors;
1568
    my @errors;
1569
    my @item_columns = map { "items.$_" } Koha::Items->columns;
1569
    my @item_columns = map { "items.$_" } Koha::Items->columns;
1570
    my @biblioitem_columns = map { "biblioitems.$_" } Koha::Biblioitems->columns;
1570
    my @biblioitem_columns = map { "biblioitems.$_" } Koha::Biblioitems->columns;
1571
    my @biblio_columns = map { "biblio.$_" } Koha::Biblios->columns;
1571
    my $report;
1572
    my $report;
1572
    for my $rule ( @rules ) {
1573
    for my $rule ( @rules ) {
1573
        my $age = $rule->{age};
1574
        my $age = $rule->{age};
Lines 1585-1590 sub ToggleNewStatus { Link Here
1585
            SELECT items.*
1586
            SELECT items.*
1586
            FROM items
1587
            FROM items
1587
            LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber
1588
            LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber
1589
            LEFT JOIN biblio ON biblio.biblionumber = biblioitems.biblionumber
1588
            WHERE 1
1590
            WHERE 1
1589
        |;
1591
        |;
1590
        for my $condition ( @$conditions ) {
1592
        for my $condition ( @$conditions ) {
Lines 1592-1597 sub ToggleNewStatus { Link Here
1592
            if (
1594
            if (
1593
                 grep { $_ eq $condition->{field} } @item_columns
1595
                 grep { $_ eq $condition->{field} } @item_columns
1594
              or grep { $_ eq $condition->{field} } @biblioitem_columns
1596
              or grep { $_ eq $condition->{field} } @biblioitem_columns
1597
              or grep { $_ eq $condition->{field} } @biblio_columns
1595
            ) {
1598
            ) {
1596
                if ( $condition->{value} =~ /\|/ ) {
1599
                if ( $condition->{value} =~ /\|/ ) {
1597
                    my @values = split /\|/, $condition->{value};
1600
                    my @values = split /\|/, $condition->{value};
(-)a/tools/automatic_item_modification_by_age.pl (-2 / +3 lines)
Lines 42-47 use C4::Koha; Link Here
42
42
43
use Koha::Items;
43
use Koha::Items;
44
use Koha::Biblioitems;
44
use Koha::Biblioitems;
45
use Koha::Biblios;
45
46
46
my $cgi = CGI->new;
47
my $cgi = CGI->new;
47
48
Lines 115-126 if ( $@ ) { Link Here
115
116
116
my @item_fields = map { "items.$_" } Koha::Items->columns;
117
my @item_fields = map { "items.$_" } Koha::Items->columns;
117
my @biblioitem_fields = map { "biblioitems.$_" } Koha::Biblioitems->columns;
118
my @biblioitem_fields = map { "biblioitems.$_" } Koha::Biblioitems->columns;
119
my @biblio_fields = map { "biblio.$_" } Koha::Biblios->columns;
118
my @age_fields = ('items.dateaccessioned', 'items.replacementpricedate', 'items.datelastborrowed', 'items.datelastseen', 'items.damaged_on', 'items.itemlost_on', 'items.withdrawn_on');
120
my @age_fields = ('items.dateaccessioned', 'items.replacementpricedate', 'items.datelastborrowed', 'items.datelastseen', 'items.damaged_on', 'items.itemlost_on', 'items.withdrawn_on');
119
$template->param(
121
$template->param(
120
    op => $op,
122
    op => $op,
121
    messages => \@messages,
123
    messages => \@messages,
122
    agefields => [ @age_fields ],
124
    agefields => [ @age_fields ],
123
    condition_fields => [ @item_fields, @biblioitem_fields ],
125
    condition_fields => [ @item_fields, @biblioitem_fields, @biblio_fields ],
124
    substitution_fields => \@item_fields,
126
    substitution_fields => \@item_fields,
125
    rules => $rules,
127
    rules => $rules,
126
);
128
);
127
- 

Return to bug 32029