X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/2df28e2b27d5cf670da85c6cf8e91fab31874f80..98b64fe1e380c232428d63cea0eb5f44b1d1a2c3:/SL/DO.pm diff --git a/SL/DO.pm b/SL/DO.pm index 0e143192e..b087becdd 100644 --- a/SL/DO.pm +++ b/SL/DO.pm @@ -578,7 +578,8 @@ sub mark_orders_if_delivered { foreach my $oe_id (keys %ship) { do_query($form, $dbh,"UPDATE oe SET delivered = ".($ship{$oe_id}->{delivered}?"TRUE":"FALSE")." WHERE id = ?", $oe_id); } - }); + 1; + }) or do { die SL::DB->client->error }; $main::lxdebug->leave_sub(); } @@ -605,7 +606,8 @@ sub close_orders { my $query = qq|UPDATE delivery_orders SET closed = TRUE WHERE id IN (| . join(', ', ('?') x scalar(@{ $params{ids} })) . qq|)|; do_query($form, $dbh, $query, map { conv_i($_) } @{ $params{ids} }); - }); + 1; + }) or die { SL::DB->client->error }; $form->new_lastmtime('delivery_orders'); @@ -777,7 +779,7 @@ sub retrieve { # stuff different from the whole will not be overwritten, but saved with a suffix. $query = qq|SELECT doi.id AS delivery_order_items_id, - p.partnumber, p.assembly, p.listprice, doi.description, doi.qty, + p.partnumber, p.part_type, p.listprice, doi.description, doi.qty, doi.sellprice, doi.parts_id AS id, doi.unit, doi.discount, p.notes AS partnotes, doi.reqdate, doi.project_id, doi.serialnumber, doi.lastcost, doi.ordnumber, doi.transdate, doi.cusordnumber, doi.longdescription,