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

(-)a/C4/Items.pm (+3 lines)
Lines 1563-1568 sub ToggleNewStatus { Link Here
1563
    my @errors;
1563
    my @errors;
1564
    my @item_columns = map { "items.$_" } Koha::Items->columns;
1564
    my @item_columns = map { "items.$_" } Koha::Items->columns;
1565
    my @biblioitem_columns = map { "biblioitems.$_" } Koha::Biblioitems->columns;
1565
    my @biblioitem_columns = map { "biblioitems.$_" } Koha::Biblioitems->columns;
1566
    my @biblio_columns = map { "biblio.$_" } Koha::Biblios->columns;
1566
    my $report;
1567
    my $report;
1567
    for my $rule ( @rules ) {
1568
    for my $rule ( @rules ) {
1568
        my $age = $rule->{age};
1569
        my $age = $rule->{age};
Lines 1580-1585 sub ToggleNewStatus { Link Here
1580
            SELECT items.*
1581
            SELECT items.*
1581
            FROM items
1582
            FROM items
1582
            LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber
1583
            LEFT JOIN biblioitems ON biblioitems.biblionumber = items.biblionumber
1584
            LEFT JOIN biblio ON biblio.biblionumber = biblioitems.biblionumber
1583
            WHERE 1
1585
            WHERE 1
1584
        |;
1586
        |;
1585
        for my $condition ( @$conditions ) {
1587
        for my $condition ( @$conditions ) {
Lines 1587-1592 sub ToggleNewStatus { Link Here
1587
            if (
1589
            if (
1588
                 grep { $_ eq $condition->{field} } @item_columns
1590
                 grep { $_ eq $condition->{field} } @item_columns
1589
              or grep { $_ eq $condition->{field} } @biblioitem_columns
1591
              or grep { $_ eq $condition->{field} } @biblioitem_columns
1592
              or grep { $_ eq $condition->{field} } @biblio_columns
1590
            ) {
1593
            ) {
1591
                if ( $condition->{value} =~ /\|/ ) {
1594
                if ( $condition->{value} =~ /\|/ ) {
1592
                    my @values = split /\|/, $condition->{value};
1595
                    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