X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FWH.pm;h=28e836e485cd22b3a7018b93182b004025c2678f;hb=e770cd180600810fecd3554e104546236a9c9597;hp=bf850fa30a82afbe7afdecc78c876f6a42199aeb;hpb=9d14fd7e7dc33f871b4a0841f85e8f0a347e9df0;p=kivitendo-erp.git diff --git a/SL/WH.pm b/SL/WH.pm index bf850fa30..28e836e48 100644 --- a/SL/WH.pm +++ b/SL/WH.pm @@ -73,13 +73,15 @@ sub transfer { return; }; + my @trans_ids; + my $db = SL::DB::Inventory->new->db; $db->do_transaction(sub{ while (my $transfer = shift @args) { my ($trans_id) = selectrow_query($::form, $::form->get_standard_dbh, qq|SELECT nextval('id')|); my $part = $objectify->($transfer, 'parts', 'SL::DB::Part'); - my $unit = $objectify->($transfer, 'unit', 'SL::DB::Unit', unit => $transfer->{unit}); + my $unit = $objectify->($transfer, 'unit', 'SL::DB::Unit', name => $transfer->{unit}); my $qty = $transfer->{qty}; my $src_bin = $objectify->($transfer, 'src_bin', 'SL::DB::Bin'); my $dst_bin = $objectify->($transfer, 'dst_bin', 'SL::DB::Bin'); @@ -109,10 +111,11 @@ sub transfer { ); if ($unit) { - $qty *= $unit->factor; - $qty /= $part->unit_obj->factor || 1 if $part->unit; + $qty = $unit->convert_to($qty, $part->unit_obj); } + $params{chargenumber} ||= ''; + if ($direction & 1) { SL::DB::Inventory->new( %params, @@ -130,12 +133,16 @@ sub transfer { qty => $qty, )->save; } + + push @trans_ids, $trans_id; } }) or do { $::form->error("Warehouse transfer error: " . join("\n", (split(/\n/, $db->error))[0..2])); }; $::lxdebug->leave_sub; + + return @trans_ids; } sub transfer_assembly { @@ -614,6 +621,14 @@ sub get_warehouse_report { push @filter_vars, '%' . $filter{ean} . '%'; } + if ($filter{date}) { + push @filter_ary, "i.itime <= ?"; + push @filter_vars, $filter{date}; + } + if (!$filter{include_invalid_warehouses}){ + push @filter_ary, "NOT (w.invalid)"; + } + # prepare qty comparison for later filtering my ($f_qty_op, $f_qty, $f_qty_base_unit); @@ -1007,6 +1022,8 @@ An expiration date. Note that this is not by default used by C =head1 BUGS +None yet. + =head1 AUTHOR =cut