X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;ds=sidebyside;f=SL%2FIC.pm;h=5ddf2c8625fcfed11dc0a48230e1d0b6f3bb67c8;hb=429a7c2179e2c3c4fe9bfcbb52ebb22e55c8519a;hp=a09d740eabcf46ddda8315f4af12d4ce4fc47c6a;hpb=0198a4d3018fe02b99f4e86bc9365a0f63733ac8;p=kivitendo-erp.git diff --git a/SL/IC.pm b/SL/IC.pm index a09d740ea..5ddf2c862 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -481,7 +481,7 @@ sub all_parts { my $token_builder = $make_token_builder->(\%joins_needed); - my @sort_cols = (@simple_filters, qw(id priceupdate onhand invnumber ordnumber quonumber name serialnumber soldtotal deliverydate insertdate shop)); + my @sort_cols = (@simple_filters, qw(id onhand invnumber ordnumber quonumber name serialnumber soldtotal deliverydate insertdate shop)); $form->{sort} = 'id' unless grep { $form->{"l_$_"} } grep { $form->{sort} eq $_ } @sort_cols; # sort by id if unknown or invisible column my $sort_order = ($form->{revers} ? ' DESC' : ' ASC'); my $order_clause = " ORDER BY " . $token_builder->($form->{sort}) . ($form->{revers} ? ' DESC' : ' ASC'); @@ -567,7 +567,7 @@ sub all_parts { qq|SELECT p.id, p.partnumber, p.description, a.qty AS onhand, p.unit, p.notes, p.itime::DATE as insertdate, p.sellprice, p.listprice, p.lastcost, - p.rop, p.weight, p.priceupdate, + p.rop, p.weight, p.image, p.drawing, p.microfiche, pfac.factor FROM parts p