X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIR.pm;h=8fb9b77753853a71e29ce5cd3d8ebb62d8ad37c9;hb=190b6dbb8c7cfe346701d89081121c244cc44b4a;hp=3ebae9653489c9e9104b09e5f121e571c45a030d;hpb=d416d4c43db74a0812d74834d078df9e0d2921a6;p=kivitendo-erp.git diff --git a/SL/IR.pm b/SL/IR.pm index 3ebae9653..8fb9b7775 100644 --- a/SL/IR.pm +++ b/SL/IR.pm @@ -35,6 +35,7 @@ package IR; use SL::AM; +use SL::DBUtils; sub post_invoice { $main::lxdebug->enter_sub(); @@ -112,7 +113,7 @@ sub post_invoice { $form->{"inventory_accno_$i"} = $form->{"expense_accno_$i"}; } - if ($form->{"qty_$i"} != 0) { + if ($form->{"id_$i"}) { # get item baseunit $query = qq|SELECT p.unit @@ -624,6 +625,8 @@ sub post_invoice { ordnumber = '$form->{ordnumber}', quonumber = '$form->{quonumber}', transdate = '$form->{invdate}', + orddate = | . conv_dateq($form->{"orddate"}) . qq|, + quodate = | . conv_dateq($form->{"quodate"}) . qq|, vendor_id = $form->{vendor_id}, amount = $amount, netamount = $netamount, @@ -845,6 +848,7 @@ sub retrieve_invoice { # retrieve invoice $query = qq|SELECT a.cp_id, a.invnumber, a.transdate AS invdate, a.duedate, + a.orddate, a.quodate, a.ordnumber, a.quonumber, a.paid, a.taxincluded, a.notes, a.taxzone_id, a.storno, a.gldate, a.intnotes, a.curr AS currency FROM ap a @@ -998,8 +1002,10 @@ sub get_vendor { my $query = qq|SELECT v.name AS vendor, v.creditlimit, v.terms, v.email, v.cc, v.bcc, v.language_id, v.payment_id, v.street, v.zipcode, v.city, v.country, v.taxzone_id, - $duedate + v.terms AS duedate + $duedate + v.terms AS duedate, + b.description AS business FROM vendor v + LEFT JOIN business b ON b.id = v.business_id WHERE v.id = $form->{vendor_id}|; my $sth = $dbh->prepare($query); $sth->execute || $form->dberror($query);