X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=bin%2Fmozilla%2Fio.pl;h=6987c713661540f6c504791cd5e4cbabe14366f9;hb=a1e47d425a58b8342992daab4907591506949f07;hp=3cb1e82c4f73d3e5ae0ef92f3c55e38982872ade;hpb=7f820f8f8e6634a1a20325e21afd6971bfc85276;p=kivitendo-erp.git diff --git a/bin/mozilla/io.pl b/bin/mozilla/io.pl index 3cb1e82c4..6987c7136 100644 --- a/bin/mozilla/io.pl +++ b/bin/mozilla/io.pl @@ -33,6 +33,13 @@ # ####################################################################### +use SL::CT; +use SL::IC; +use CGI::Ajax; +use CGI; + +require "$form->{path}/common.pl"; + # any custom scripts for this one if (-f "$form->{path}/custom_io.pl") { eval { require "$form->{path}/custom_io.pl"; }; @@ -83,6 +90,7 @@ use Data::Dumper; sub display_row { $lxdebug->enter_sub(); my $numrows = shift; + if ($lizenzen && $form->{vc} eq "customer") { if ($form->{type} =~ /sales_order/) { @column_index = (runningnumber, partnumber, description, ship, qty); @@ -112,7 +120,7 @@ sub display_row { or (($form->{level} =~ /Sales/) and ($form->{type} =~ /invoice/)) or (($form->{level} eq undef) and ($form->{type} =~ /invoice/)) or ($form->{type} =~ /sales_order/)) { - push @column_index, qw(sellprice_drag); + push @column_index, qw(sellprice_pg); } push @column_index, qw(sellprice); @@ -144,10 +152,17 @@ sub display_row { qq|| . $locale->text('Part Description') . qq||; - $column_data{ship} = + if ($form->{"type"} eq "purchase_order") { + $column_data{ship} = qq|| - . $locale->text('Ship') - . qq||; + . $locale->text('Ship rcvd') + . qq||; + } else { + $column_data{ship} = + qq|| + . $locale->text('Ship') + . qq||; + } $column_data{qty} = qq|| . $locale->text('Qty') @@ -172,7 +187,7 @@ sub display_row { qq|| . $locale->text('Price') . qq||; - $column_data{sellprice_drag} = + $column_data{sellprice_pg} = qq|| . $locale->text('Pricegroup') . qq||; @@ -190,9 +205,20 @@ sub display_row { . qq||; ############## ENDE Neueintrag ################## + $myconfig{"show_form_details"} = 1 + unless (defined($myconfig{"show_form_details"})); + $form->{"show_details"} = $myconfig{"show_form_details"} + unless (defined($form->{"show_details"})); + $form->{"show_details"} = $form->{"show_details"} ? 1 : 0; + my $show_details_new = 1 - $form->{"show_details"}; + my $show_details_checked = $form->{"show_details"} ? "checked" : ""; + print qq| + + +
|; @@ -288,10 +314,10 @@ sub display_row { if (($rows = $form->numtextrows($form->{"description_$i"}, 30, 6)) > 1) { $column_data{description} = - qq||; + qq||; } else { $column_data{description} = - qq||; + qq||; } (my $qty_dec) = ($form->{"qty_$i"} =~ /\.(\d+)/); @@ -329,7 +355,7 @@ sub display_row { $is_assigned ? $form->{"unit_$i"} : undef)) . ""; - # build in dragdrop for pricesgroups + # build in drop down list for pricesgroups if ($form->{"prices_$i"}) { if ($form->{"new_pricegroup_$i"} != $form->{"old_pricegroup_$i"}) { $price_tmp = $form->format_amount(\%myconfig, $form->{"price_new_$i"}, $decimalplaces); @@ -337,33 +363,28 @@ sub display_row { $price_tmp = $form->format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces); } - $column_data{sellprice_drag} = - qq||; + $column_data{sellprice_pg} = + qq||; $column_data{sellprice} = qq||; } else { # for last row and report - # set pricegroup dragdrop from report menu + # set pricegroup drop down list from report menu if ($form->{"sellprice_$i"} != 0) { $prices = qq|\n|; $form->{"pricegroup_old_$i"} = $form->{"pricegroup_id_$i"}; - $column_data{sellprice_drag} = - qq||; + $column_data{sellprice_pg} = + qq||; } else { # for last row - $column_data{sellprice_drag} = - qq||; + $column_data{sellprice_pg} = qq||; } - print(STDERR "Sellprice vor Ausgabe: ",$form->{"sellprice_$i"},"\n"); $column_data{sellprice} = qq| + |; $column_data{partnumber} = @@ -563,7 +585,8 @@ sub select_item { qq||; $column_data{onhand} = qq||; - + $column_data{unit} = + qq||; # list items with radio button on a form $form->header; @@ -621,7 +644,8 @@ sub select_item { qq||; - + $column_data{unit} = + qq||; $j++; $j %= 2; print qq| @@ -643,11 +667,10 @@ sub select_item { - - +{id}> @@ -710,7 +733,9 @@ sub item_selected { $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); map { $form->{"${_}_$i"} = $form->{"new_${_}_$j"} } - qw(id partnumber description sellprice listprice inventory_accno income_accno expense_accno bin unit weight assembly taxaccounts partsgroup formel alu longdescription not_discountable adr_description); + qw(id partnumber description sellprice listprice inventory_accno + income_accno expense_accno bin unit weight assembly taxaccounts + partsgroup formel longdescription not_discountable partnotes); if ($form->{"part_payment_id_$i"} ne "") { $form->{payment_id} = $form->{"part_payment_id_$i"}; } @@ -853,6 +878,9 @@ sub new_item { sub display_form { $lxdebug->enter_sub(); + + relink_accounts(); + $form->language_payment(\%myconfig); # if we have a display_form @@ -947,7 +975,7 @@ sub check_form { my @a = (); my $count = 0; my @flds = ( - qw(id partnumber description qty ship sellprice unit discount inventory_accno income_accno expense_accno listprice taxaccounts bin assembly weight projectnumber project_id oldprojectnumber runningnumber serialnumber partsgroup payment_id not_discountable shop ve gv buchungsgruppen_id adr_id language_values) + qw(id partnumber description qty ship sellprice unit discount inventory_accno income_accno expense_accno listprice taxaccounts bin assembly weight projectnumber project_id oldprojectnumber runningnumber serialnumber partsgroup payment_id not_discountable shop ve gv buchungsgruppen_id language_values sellprice_pg pricegroup_old price_old price_new unit_old ordnumber transdate longdescription basefactor) ); @@ -1170,6 +1198,13 @@ sub order { \%myconfig, $form->{currency}, $form->{transdate}, $buysell ))); + for $i (1 .. $form->{rowcount}) { + map({ $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, + $form->{"${_}_${i}"}) + if ($form->{"${_}_${i}"}) } + qw(ship qty sellprice listprice basefactor)); + } + &prepare_order; &display_form; @@ -1223,12 +1258,23 @@ sub quotation { \%myconfig, $form->{currency}, $form->{transdate}, $buysell ))); + for $i (1 .. $form->{rowcount}) { + map({ $form->{"${_}_${i}"} = $form->parse_amount(\%myconfig, + $form->{"${_}_${i}"}) + if ($form->{"${_}_${i}"}) } + qw(ship qty sellprice listprice basefactor)); + } + &prepare_order; &display_form; $lxdebug->leave_sub(); } +sub request_for_quotation { + quotation(); +} + sub e_mail { $lxdebug->enter_sub(); if ($form->{second_run}) { @@ -1237,8 +1283,10 @@ sub e_mail { } if ($myconfig{role} eq 'admin') { $bcc = qq| - - + + + + |; } @@ -1246,6 +1294,11 @@ sub e_mail { $form->{email} = $form->{shiptoemail} if $form->{shiptoemail}; } + if ($form->{"cp_id"} && !$form->{"email"}) { + CT->get_contact(\%myconfig, $form); + $form->{"email"} = $form->{"cp_email"}; + } + $name = $form->{ $form->{vc} }; $name =~ s/--.*//g; $title = $locale->text('E-mail') . " $name"; @@ -1253,44 +1306,105 @@ sub e_mail { $form->{oldmedia} = $form->{media}; $form->{media} = "email"; + my %formname_translations = + ( + "bin_list" => $locale->text('Bin List'), + "credit_note" => $locale->text('Credit Note'), + "invoice" => $locale->text('Invoice'), + "packing_list" => $locale->text('Packing List'), + "pick_list" => $locale->text('Pick List'), + "proforma" => $locale->text('Proforma Invoice'), + "purchase_order" => $locale->text('Purchase Order'), + "request_quotation" => $locale->text('RFQ'), + "sales_order" => $locale->text('Confirmation'), + "sales_quotation" => $locale->text('Quotation'), + "storno_invoice" => $locale->text('Storno Invoice'), + "storno_packing_list" => $locale->text('Storno Packing List'), + ); + + my $attachment_filename = $formname_translations{$form->{"formname"}}; + my $prefix; + + if ($form->{"type"} =~ /invoice/) { + $prefix = "inv"; + } elsif ($form->{"type"} =~ /_quotation$/) { + $prefix = "quo"; + } else { + $prefix = "ord"; + } + + if ($attachment_filename && $form->{"${prefix}number"}) { + $attachment_filename .= "_" . $form->{"${prefix}number"} . + ($form->{"format"} =~ /pdf/i ? ".pdf" : + $form->{"format"} =~ /postscript/i ? ".ps" : + $form->{"format"} =~ /opendocument/i ? ".odt" : + $form->{"format"} =~ /html/i ? ".html" : ""); + $attachment_filename =~ s/ /_/g; + my %umlaute = + ( + "ä" => "ae", "ö" => "oe", "ü" => "ue", + "Ä" => "Ae", "Ö" => "Oe", "Ü" => "Ue", + "ß" => "ss" + ); + map({ $attachment_filename =~ s/$_/$umlaute{$_}/g; } keys(%umlaute)); + } else { + $attachment_filename = ""; + } + + if ($form->{"email"}) { + $form->{"fokus"} = "Form.subject"; + } else { + $form->{"fokus"} = "Form.email"; + } $form->header; print qq| - + -{script}> + -
format_amount(\%myconfig, $form->{"prices_$i"}, - $decimalplaces) - . qq|> {"pricegroup_old_$i"}> {"price_old_$i"}> - + format_amount(\%myconfig, $form->{"price_new_$i"}) . qq|> @@ -418,7 +439,7 @@ sub display_row { {"inventory_accno_$i"}> - + {"income_accno_$i"}> {"expense_accno_$i"}> @@ -427,9 +448,8 @@ sub display_row { - + - |; @@ -437,9 +457,13 @@ sub display_row { # Eintrag fuer Version 2.2.0 geaendert # # neue Optik im Rechnungsformular # ######################################## + + my $row_style_attr = + 'style="display:none;"' if (!$form->{"show_details"}); + # print second row print qq| -
|; if ($lizenzen && $form->{type} eq "invoice" && $form->{vc} eq "customer") { @@ -505,13 +529,13 @@ sub display_row { # build html-code for pricegroups in variable $form->{prices_$j} sub set_pricegroup { - my $rowcount = shift; $lxdebug->enter_sub(); + my $rowcount = shift; for $j (1 .. $rowcount) { my $pricegroup_old = $form->{"pricegroup_old_$i"}; if ($form->{PRICES}{$j}) { $len = 0; - $prices = ''; + $prices = ''; $price = 0; foreach $item (@{ $form->{PRICES}{$j} }) { @@ -521,7 +545,7 @@ sub set_pricegroup { $pricegroup_id = $item->{pricegroup_id}; $pricegroup = $item->{pricegroup}; - # build dragdrop for pricegroups + # build drop down list for pricegroups $prices .= qq|\n|; @@ -541,10 +565,8 @@ sub set_pricegroup { if ($pricegroup_id == 0) { $form->{"price_new_$j"} = $form->{"sellprice_$j"}; } - if ($len > 1) { - $form->{"prices_$j"} = $prices; - } } + $form->{"prices_$j"} = $prices; } } $lxdebug->leave_sub(); @@ -552,7 +574,7 @@ sub set_pricegroup { sub select_item { $lxdebug->enter_sub(); - @column_index = qw(ndx partnumber description onhand sellprice); + @column_index = qw(ndx partnumber description onhand unit sellprice); $column_data{ndx} = qq| | . $locale->text('Price') . qq|| . $locale->text('Qty') . qq|| . $locale->text('Unit') . qq|{onhand}>| . $form->format_amount(\%myconfig, $ref->{onhand}, '', " ") . qq|$ref->{unit} | . $locale->text('Bcc') . qq|
| . $locale->text('Bcc') . qq|
- - +
$title
+ + @@ -1306,21 +1420,21 @@ sub e_mail { # save all other variables foreach $key (keys %$form) { $form->{$key} =~ s/\"/"/g; - print qq|\n|; + print qq|\n|; } print qq| - +
$title
- - - - - - - - - - - $bcc - +
| . $locale->text('To') . qq|| . $locale->text('Cc') . qq|
| . $locale->text('Subject') . qq|
+ + + + + + + + + $bcc + + + + + + +
| . $locale->text('To') . qq|
| . $locale->text('Cc') . qq|
| . $locale->text('Subject') . qq|
| . $locale->text('Attachment name') . + qq|
- - - - - - - +
| . $locale->text('Message') . qq|
+ + + + + +
| . $locale->text('Message') . qq|


- +
- @@ -1347,7 +1461,26 @@ sub send_email { sub print_options { $lxdebug->enter_sub(); $form->{sendmode} = "attachment"; - $form->{copies} = 3 unless $form->{copies}; + + $form->{"format"} = + $form->{"format"} ? $form->{"format"} : + $myconfig{"template_format"} ? $myconfig{"template_format"} : + "pdf"; + + $form->{"copies"} = + $form->{"copies"} ? $form->{"copies"} : + $myconfig{"copies"} ? $myconfig{"copies"} : + 3; + + $form->{"media"} = + $form->{"media"} ? $form->{"media"} : + $myconfig{"default_media"} ? $myconfig{"default_media"} : + "screen"; + + $form->{"printer_id"} = + defined($form->{"printer_id"}) ? $form->{"printer_id"} : + $myconfig{"default_printer_id"} ? $myconfig{"default_printer_id"} : + ""; $form->{PD}{ $form->{formname} } = "selected"; $form->{DF}{ $form->{format} } = "selected"; @@ -1377,18 +1510,13 @@ sub print_options { }|; foreach $item (@{ $form->{languages} }) { if ($form->{language_id} eq $item->{id}) { $language_select .= qq||; @@ -1487,11 +1615,12 @@ sub print_options { } if (scalar(keys (%{ $form->{printers} })) !=0) { - - $printer_select = qq| |; foreach $item (@{ $form->{printers} }) { - $printer_select .= qq||; + $selected = $item->{"id"} == $form->{"printer_id"} ? "selected" : ""; + $printer_select .= qq||; } } @@ -1617,7 +1746,7 @@ sub print_form { # this is from an invoice $form->{label} = $locale->text('Packing List'); } - if (($form->{formname} eq 'sales_order') || ($form->{formname} eq 'agb') || ($form->{formname} eq 'bunker_receipt')) { + if ($form->{formname} eq 'sales_order') { $inv = "ord"; $due = "req"; $form->{"${inv}date"} = $form->{transdate}; @@ -1694,7 +1823,7 @@ sub print_form { $inv = "quo"; $due = "req"; $form->{"${inv}date"} = $form->{transdate}; - $form->{"invdate"} = $form->{transdate}; + $form->{"invdate"} = $form->{transdate}; $form->{label} = $locale->text('Proforma Invoice'); $numberfld = "sqnumber"; $order = 1; @@ -1712,7 +1841,9 @@ sub print_form { $form->isblank("email", $locale->text('E-mail address missing!')) if ($form->{media} eq 'email'); $form->isblank("${inv}date", - $locale->text($form->{label} . ' Date missing!')); + $locale->text($form->{label}) + . ": " + . $locale->text(' Date missing!')); # $locale->text('Invoice Number missing!') # $locale->text('Invoice Date missing!') @@ -1748,16 +1879,25 @@ sub print_form { ($form->{"email"}, $form->{"cc"}, $form->{"bcc"}); $language_saved = $form->{language_id}; - &{"$form->{vc}_details"}; + $payment_id_saved = $form->{payment_id}; + + &{"$form->{vc}_details"}(); + $form->{language_id} = $language_saved; + $form->{payment_id} = $payment_id_saved; $form->{"email"} = $saved_email if ($saved_email); $form->{"cc"} = $saved_cc if ($saved_cc); $form->{"bcc"} = $saved_bcc if ($saved_bcc); - # format payment dates - for $i (1 .. $form->{paidaccounts} - 1) { - $form->{"datepaid_$i"} = $locale->date(\%myconfig, $form->{"datepaid_$i"}); + my ($language_tc, $output_numberformat, $output_dateformat, $output_longdates); + if ($form->{"language_id"}) { + ($language_tc, $output_numberformat, $output_dateformat, $output_longdates) = + AM->get_language_details(\%myconfig, $form, $form->{language_id}); + } else { + $output_dateformat = $myconfig{"dateformat"}; + $output_numberformat = $myconfig{"numberformat"}; + $output_longdates = 1; } ($form->{employee}) = split /--/, $form->{employee}; @@ -1770,17 +1910,6 @@ sub print_form { IS->invoice_details(\%myconfig, \%$form, $locale); } - # format global dates - map { $form->{$_} = $locale->date(\%myconfig, $form->{$_}, 1) } - ("${inv}date", "${due}date", "shippingdate", "deliverydate"); - - # format item dates - for my $field (qw(transdate_oe deliverydate_oe)) { - map { - $form->{$field}[$_] = $locale->date(\%myconfig, $form->{$field}[$_], 1); - } 0 .. $#{ $form->{$field} }; - } - if ($form->{shipto_id}) { $form->get_shipto(\%myconfig); } @@ -1802,7 +1931,7 @@ sub print_form { || $form->{formname} eq 'request_quotation') { $form->{shiptoname} = $myconfig{company}; $form->{shiptostreet} = $myconfig{address}; - } else { + } else { map { $form->{"shipto$_"} = $form->{$_} } @a; } } @@ -1815,9 +1944,46 @@ sub print_form { $form->{printer_code} = $form->get_printer_code(\%myconfig); if ($form->{language} ne "") { + map({ $form->{"unit"}->[$_] = + AM->translate_units($form, $form->{"language"}, + $form->{"unit"}->[$_], $form->{"qty"}->[$_]); } + (0..scalar(@{$form->{"unit"}}) - 1)); $form->{language} = "_" . $form->{language}; } + # Format dates. + format_dates($output_dateformat, $output_longdates, + qw(invdate orddate quodate pldate duedate reqdate transdate + shippingdate deliverydate validitydate paymentdate + datepaid transdate_oe deliverydate_oe + employee_startdate employee_enddate + ), + grep({ /^datepaid_\d+$/ || + /^transdate_oe_\d+$/ || + /^deliverydate_oe_\d+$/ || + /^reqdate_\d+$/ || + /^deliverydate_\d+$/ || + /^transdate_\d+$/ + } keys(%{$form}))); + + reformat_numbers($output_numberformat, 2, + qw(invtotal ordtotal quototal subtotal linetotal + listprice sellprice netprice discount + tax taxbase), + grep({ /^linetotal_\d+$/ || + /^listprice_\d+$/ || + /^sellprice_\d+$/ || + /^netprice_\d+$/ || + /^taxbase_\d+$/ || + /^discount_\d+$/ || + /^tax_\d+$/ + } keys(%{$form}))); + + reformat_numbers($output_numberformat, undef, + qw(qty), + grep({ /^qty_\d+$/ + } keys(%{$form}))); + if ($form->{printer_code} ne "") { $form->{printer_code} = "_" . $form->{printer_code}; } @@ -1936,14 +2102,14 @@ sub print_form { sub customer_details { $lxdebug->enter_sub(); - IS->customer_details(\%myconfig, \%$form); + IS->customer_details(\%myconfig, \%$form, @_); $lxdebug->leave_sub(); } sub vendor_details { $lxdebug->enter_sub(); - IR->vendor_details(\%myconfig, \%$form); + IR->vendor_details(\%myconfig, \%$form, @_); $lxdebug->leave_sub(); } @@ -1971,8 +2137,17 @@ sub ship_to { map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); + my @shipto_vars = + qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry + shiptocontact shiptophone shiptofax shiptoemail + shiptodepartment_1 shiptodepartment_2); + + my @addr_vars = + (qw(name department_1 department_2 street zipcode city country + contact email phone fax)); + # get details for name - &{"$form->{vc}_details"}; + &{"$form->{vc}_details"}(@addr_vars); $number = ($form->{vc} eq 'customer') @@ -2016,6 +2191,16 @@ sub ship_to { $form->{name} + + | . $locale->text('Department') . qq| + $form->{department_1} + + + +   + $form->{department_2} + + | . $locale->text('Street') . qq| $form->{street} @@ -2043,12 +2228,12 @@ sub ship_to { | . $locale->text('Phone') . qq| - $form->{"$form->{vc}phone"} + $form->{phone} | . $locale->text('Fax') . qq| - $form->{"$form->{vc}fax"} + $form->{fax} @@ -2065,8 +2250,7 @@ sub ship_to { |; # delete shipto - map { delete $form->{$_} } - qw(shiptoname shiptostreet shiptozipcode shiptocity shiptocountry shiptocontact shiptophone shiptofax shiptoemail header); + map({ delete $form->{$_} } (@shipto_vars, qw(header))); $form->{title} = $title; foreach $key (keys %$form) { @@ -2128,3 +2312,36 @@ sub new_license { $lxdebug->leave_sub(); } +sub relink_accounts { + $lxdebug->enter_sub(); + + $form->{"taxaccounts"} =~ s/\s*$//; + $form->{"taxaccounts"} =~ s/^\s*//; + foreach my $accno (split(/\s*/, $form->{"taxaccounts"})) { + map({ delete($form->{"${accno}_${_}"}); } qw(rate description taxnumber)); + } + $form->{"taxaccounts"} = ""; + + for (my $i = 1; $i <= $form->{"rowcount"}; $i++) { + if ($form->{"id_$i"}) { + IC->retrieve_accounts(\%myconfig, $form, $form->{"id_$i"}, $i, 1); + } + } + + $lxdebug->leave_sub(); +} + + +sub set_duedate { + $lxdebug->enter_sub(); + + $form->get_duedate(\%myconfig); + + my $q = new CGI; + $result = "$form->{duedate}"; + print $q->header(); + print $result; + $lxdebug->leave_sub(); + +} +