X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/a50663d89ac93112110c23caae05ed82105fd28f..47ee7483575f1029a56fe3ac10b1680d91bc1601:/SL/Dev/Record.pm diff --git a/SL/Dev/Record.pm b/SL/Dev/Record.pm index d0962ef82..ae60ade64 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_purchase_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', @@ -51,6 +52,40 @@ sub create_sales_invoice { 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; +} + sub create_sales_delivery_order { my (%params) = @_; @@ -79,6 +114,34 @@ sub create_sales_delivery_order { return $delivery_order; } +sub create_purchase_delivery_order { + my (%params) = @_; + + my $record_type = 'purchase_delivery_order'; + my $orderitems = delete $params{orderitems} // _create_two_items($record_type); + _check_items($orderitems, $record_type); + + my $vendor = $params{vendor} // SL::Dev::CustomerVendor::create_vendor(name => 'Testvendor')->save; + die "illegal customer" unless ref($vendor) eq 'SL::DB::Vendor'; + + my $delivery_order = SL::DB::DeliveryOrder->new( + 'is_sales' => 'false', + 'closed' => undef, + vendor_id => $vendor->id, + taxzone_id => $vendor->taxzone_id, + donumber => $params{donumber} // 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, + orderitems => $orderitems, + ); + $delivery_order->assign_attributes(%params) if %params; + $delivery_order->save; + return $delivery_order; +} + sub create_sales_order { my (%params) = @_; @@ -254,6 +317,21 @@ Example with params: 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: @@ -279,6 +357,15 @@ Example including creation of part and of sales order. ] ); +Example: create 100 orders with the same part for 100 new customers: + + my $part1 = SL::Dev::Part::create_part(partnumber => 'T6256')->save; + SL::Dev::Record::create_sales_order( + save => 1, + taxincluded => 0, + orderitems => [ SL::Dev::Record::create_order_item(part => $part1, qty => 1, sellprice => 9) ] + ) for 1 .. 100; + =head2 C See comments for C. @@ -296,7 +383,7 @@ Required params: record_type (sales_invoice, sales_order, sales_delivery_order) Example including creation of part and of invoice: my $part = SL::Dev::Part::create_part( partnumber => 'T4254')->save; - my $item = SL::Dev::Record::create_item(record_type => 'sales_invoice', part => $part, qty => 2.5); + my $item = SL::Dev::Record::create_invoice_item(part => $part, qty => 2.5); my $invoice = SL::Dev::Record::create_sales_invoice( taxincluded => 0, invoiceitems => [ $item ],