X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/d55cf3464d72d33f5638dd25b8c190cd71b171d0..5ce99992a783b03eca2a382fe76a6e01d7ad724f:/SL/Dev/Record.pm diff --git a/SL/Dev/Record.pm b/SL/Dev/Record.pm index dde842e36..089b65c49 100644 --- a/SL/Dev/Record.pm +++ b/SL/Dev/Record.pm @@ -2,7 +2,7 @@ package SL::Dev::Record; use strict; use base qw(Exporter); -our @EXPORT = qw(create_invoice_item create_sales_invoice create_order_item create_sales_order create_purchase_order create_delivery_order_item create_sales_delivery_order create_project); +our @EXPORT = qw(create_invoice_item create_sales_invoice create_credit_note create_order_item create_sales_order create_purchase_order create_delivery_order_item create_sales_delivery_order create_project); use SL::DB::Invoice; use SL::DB::InvoiceItem; @@ -15,6 +15,7 @@ use SL::DB::ProjectType; use DateTime; my %record_type_to_item_type = ( sales_invoice => 'SL::DB::InvoiceItem', + credit_note => 'SL::DB::InvoiceItem', sales_order => 'SL::DB::OrderItem', purchase_order => 'SL::DB::OrderItem', sales_delivery_order => 'SL::DB::DeliveryOrderItem', @@ -42,10 +43,44 @@ sub create_sales_invoice { salesman_id => $params{employee_id} // SL::DB::Manager::Employee->current->id, transdate => $params{transdate} // DateTime->today_local->to_kivitendo, payment_id => $params{payment_id} // undef, - gldate => DateTime->today_local->to_kivitendo, + gldate => DateTime->today, invoiceitems => $invoiceitems, - %params, ); + $invoice->assign_attributes(%params) if %params; + + $invoice->post; + return $invoice; +} + +sub create_credit_note { + my (%params) = @_; + + my $record_type = 'credit_note'; + my $invoiceitems = delete $params{invoiceitems} // _create_two_items($record_type); + _check_items($invoiceitems, $record_type); + + my $customer = delete $params{customer} // SL::Dev::CustomerVendor::create_customer(name => 'Testcustomer')->save; + die "illegal customer" unless defined $customer && ref($customer) eq 'SL::DB::Customer'; + + # adjust qty for credit note items + $_->qty( $_->qty * -1) foreach @{$invoiceitems}; + + my $invoice = SL::DB::Invoice->new( + invoice => 1, + type => 'credit_note', + customer_id => $customer->id, + taxzone_id => $customer->taxzone->id, + invnumber => delete $params{invnumber} // undef, + currency_id => $params{currency_id} // $::instance_conf->get_currency_id, + taxincluded => $params{taxincluded} // 0, + employee_id => $params{employee_id} // SL::DB::Manager::Employee->current->id, + salesman_id => $params{employee_id} // SL::DB::Manager::Employee->current->id, + transdate => $params{transdate} // DateTime->today_local->to_kivitendo, + payment_id => $params{payment_id} // undef, + gldate => DateTime->today, + invoiceitems => $invoiceitems, + ); + $invoice->assign_attributes(%params) if %params; $invoice->post; return $invoice; @@ -71,10 +106,10 @@ sub create_sales_delivery_order { taxincluded => $params{taxincluded} // 0, employee_id => $params{employee_id} // SL::DB::Manager::Employee->current->id, salesman_id => $params{employee_id} // SL::DB::Manager::Employee->current->id, - transdate => $params{transdate} // DateTime->today_local->to_kivitendo, + transdate => $params{transdate} // DateTime->today, orderitems => $orderitems, - %params ); + $delivery_order->assign_attributes(%params) if %params; $delivery_order->save; return $delivery_order; } @@ -96,12 +131,12 @@ sub create_sales_order { taxzone_id => delete $params{taxzone_id} // $customer->taxzone->id, currency_id => delete $params{currency_id} // $::instance_conf->get_currency_id, taxincluded => delete $params{taxincluded} // 0, - # employee_id => delete $params{employee_id} // SL::DB::Manager::Employee->current->id, - # salesman_id => delete $params{employee_id} // SL::DB::Manager::Employee->current->id, - transdate => delete $params{transdate} // DateTime->today_local->to_kivitendo, + employee_id => delete $params{employee_id} // SL::DB::Manager::Employee->current->id, + salesman_id => delete $params{employee_id} // SL::DB::Manager::Employee->current->id, + transdate => delete $params{transdate} // DateTime->today, orderitems => $orderitems, - %params ); + $order->assign_attributes(%params) if %params; if ( $save ) { $order->calculate_prices_and_taxes; @@ -127,11 +162,11 @@ sub create_purchase_order { taxzone_id => delete $params{taxzone_id} // $vendor->taxzone->id, currency_id => delete $params{currency_id} // $::instance_conf->get_currency_id, taxincluded => delete $params{taxincluded} // 0, - transdate => delete $params{transdate} // DateTime->today_local->to_kivitendo, + transdate => delete $params{transdate} // DateTime->today, 'closed' => undef, orderitems => $orderitems, - %params ); + $order->assign_attributes(%params) if %params; if ( $save ) { $order->calculate_prices_and_taxes; # not tested for purchase orders @@ -192,8 +227,8 @@ sub _create_item { description => $part->description, unit => $part->unit, qty => $params{qty} || 5, - %params, ); + $item->assign_attributes(%params) if %params; return $item; } @@ -220,8 +255,8 @@ sub create_project { valid => 1, project_status_id => SL::DB::Manager::ProjectStatus->find_by(name => "running")->id, project_type_id => SL::DB::Manager::ProjectType->find_by(description => "Standard")->id, - %params, )->save; + $project->assign_attributes(%params) if %params; return $project; } @@ -250,10 +285,25 @@ Example with params: my $invoice2 = SL::Dev::Record::create_sales_invoice( invnumber => 777, - transdate => DateTime->today_local->subtract(days => 7), + transdate => DateTime->today->subtract(days => 7), taxincluded => 1, ); +=head2 C + +Create a credit note (sales). Use positive quantities when adding items. + +Example including creation of parts and of credit_note + my $part1 = SL::Dev::Part::create_part( partnumber => 'T4254')->save; + my $part2 = SL::Dev::Part::create_service(partnumber => 'Serv1')->save; + my $credit_note = SL::Dev::Record::create_credit_note( + invnumber => '34', + taxincluded => 0, + invoiceitems => [ SL::Dev::Record::create_invoice_item(part => $part1, qty => 3, sellprice => 70), + SL::Dev::Record::create_invoice_item(part => $part2, qty => 10, sellprice => 50), + ] + ); + =head2 C Examples: