###################################################################### # SQL-Ledger, Accounting # Copyright (c) 1998-2002 # # Author: Dieter Simader # Email: dsimader@sql-ledger.org # Web: http://www.sql-ledger.org # # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; either version 2 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. # ####################################################################### # # common routines used in is, ir, oe # ####################################################################### # any custom scripts for this one if (-f "$form->{path}/custom_io.pl") { eval { require "$form->{path}/custom_io.pl"; }; } if (-f "$form->{path}/$form->{login}_io.pl") { eval { require "$form->{path}/$form->{login}_io.pl"; }; } 1; # end of main # this is for our long dates # $locale->text('January') # $locale->text('February') # $locale->text('March') # $locale->text('April') # $locale->text('May ') # $locale->text('June') # $locale->text('July') # $locale->text('August') # $locale->text('September') # $locale->text('October') # $locale->text('November') # $locale->text('December') # this is for our short month # $locale->text('Jan') # $locale->text('Feb') # $locale->text('Mar') # $locale->text('Apr') # $locale->text('May') # $locale->text('Jun') # $locale->text('Jul') # $locale->text('Aug') # $locale->text('Sep') # $locale->text('Oct') # $locale->text('Nov') # $locale->text('Dec') sub display_row { my $numrows = shift; @column_index = (partnumber, description, qty); if ($form->{type} eq "sales_order") { if ($form->{id}) { push @column_index, "ship"; $column_data{ship} = qq||.$locale->text('Ship').qq||; } } if ($form->{type} eq "purchase_order") { if ($form->{id}) { push @column_index, "ship"; $column_data{ship} = qq||.$locale->text('Recd').qq||; } } push @column_index, qw(unit sellprice); if ($form->{script} eq 'is.pl' || $form->{type} eq 'sales_order') { push @column_index, qw(discount); } push @column_index, "linetotal"; my $colspan = $#column_index + 1; $form->{invsubtotal} = 0; map { $form->{"${_}_base"} = 0 } (split / /, $form->{taxaccounts}); $column_data{partnumber} = qq||.$locale->text('Number').qq||; $column_data{description} = qq||.$locale->text('Description').qq||; $column_data{qty} = qq||.$locale->text('Qty').qq||; $column_data{unit} = qq||.$locale->text('Unit').qq||; $column_data{sellprice} = qq||.$locale->text('Price').qq||; $column_data{discount} = qq|%|; $column_data{linetotal} = qq||.$locale->text('Extended').qq||; $column_data{bin} = qq||.$locale->text('Bin').qq||; print qq| |; map { print "\n$column_data{$_}" } @column_index; print qq| |; $projectnumber = $locale->text('Project'); $runningnumber = $locale->text('No.'); $partsgroup = $locale->text('Group'); if ($form->{type} =~ /_order/) { $reqdate = $locale->text('Required by'); $delvar = "reqdate"; } else { $deliverydate = $locale->text('Delivery Date'); $delvar = "deliverydate"; } for $i (1 .. $numrows) { # undo formatting map { $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) } qw(qty ship discount sellprice); ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; $discount = $form->round_amount($form->{"sellprice_$i"} * $form->{"discount_$i"}/100, $decimalplaces); $linetotal = $form->round_amount($form->{"sellprice_$i"} - $discount, $decimalplaces); $linetotal = $form->round_amount($linetotal * $form->{"qty_$i"}, 2); # convert " to " map { $form->{"${_}_$i"} =~ s/"/"/g } qw(partnumber description unit); $column_data{partnumber} = qq||; if (($rows = $form->numtextrows($form->{"description_$i"}, 30, 6)) > 1) { $column_data{description} = qq||; } else { $column_data{description} = qq||; } $column_data{qty} = qq||; $column_data{ship} = qq||; $column_data{unit} = qq||; $column_data{sellprice} = qq||; $column_data{discount} = qq||; $column_data{linetotal} = qq||; $column_data{bin} = qq||; print qq| |; map { print "\n$column_data{$_}" } @column_index; print qq| {"id_$i"}> {"inventory_accno_$i"}> {"income_accno_$i"}> {"expense_accno_$i"}> |; # print second row print qq| |; map { $form->{"${_}_base"} += $linetotal } (split / /, $form->{"taxaccounts_$i"}); $form->{invsubtotal} += $linetotal; } print qq|
format_amount(\%myconfig, $form->{"qty_$i"}).qq|>format_amount(\%myconfig, $form->{"ship_$i"}).qq|>format_amount(\%myconfig, $form->{"sellprice_$i"}, $decimalplaces).qq|>format_amount(\%myconfig, $form->{"discount_$i"}).qq|>|.$form->format_amount(\%myconfig, $linetotal, 2).qq|$form->{"bin_$i"}
$runningnumber $partsgroup ${$delvar} $projectnumber

|; } sub select_item { @column_index = qw(ndx partnumber description onhand sellprice); $column_data{ndx} = qq| |; $column_data{partnumber} = qq||.$locale->text('Number').qq||; $column_data{description} = qq||.$locale->text('Description').qq||; $column_data{sellprice} = qq||.$locale->text('Price').qq||; $column_data{onhand} = qq||.$locale->text('Qty').qq||; # list items with radio button on a form $form->header; $title = $locale->text('Select from one of the items below'); $colspan = $#column_index + 1; print qq|
{script}> |; map { print "\n$column_data{$_}" } @column_index; print qq||; my $i = 0; foreach $ref (@{ $form->{item_list} }) { $checked = ($i++) ? "" : "checked"; map { $ref->{$_} =~ s/"/"/g } qw(partnumber description unit); $column_data{ndx} = qq||; $column_data{partnumber} = qq||; $column_data{description} = qq||; $column_data{sellprice} = qq||; $column_data{onhand} = qq||; $j++; $j %= 2; print qq| |; map { print "\n$column_data{$_}" } @column_index; print qq| {listprice}> {inventory_accno}> {income_accno}> {expense_accno}> {id}> |; } print qq|
$title
$ref->{partnumber}$ref->{description}{sellprice}>|.$form->format_amount(\%myconfig, $ref->{sellprice}, 2, " ").qq|{onhand}>|.$form->format_amount(\%myconfig, $ref->{onhand}, '', " ").qq|

|; # delete action variable delete $form->{action}; delete $form->{item_list}; # save all other form variables foreach $key (keys %${form}) { $form->{$key} =~ s/"/"/g; print qq|\n|; } print qq|
|; } sub item_selected { # replace the last row with the checked row $i = $form->{rowcount}; $i = $form->{assembly_rows} if ($form->{item} eq 'assembly'); # index for new item $j = $form->{ndx}; # if there was a price entered, override it $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); ($dec) = ($form->{"sellprice_$i"} =~ /\.(\d+)/); $dec = length $dec; $decimalplaces = ($dec > 2) ? $dec : 2; if ($sellprice) { $form->{"sellprice_$i"} = $sellprice; } else { # if there is an exchange rate adjust sellprice if (($form->{exchangerate} * 1) != 0) { $form->{"sellprice_$i"} /= $form->{exchangerate}; $form->{"sellprice_$i"} = $form->round_amount($form->{"sellprice_$i"}, $decimalplaces); } } map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(sellprice weight); $form->{sellprice} += ($form->{"sellprice_$i"} * $form->{"qty_$i"}); $form->{weight} += ($form->{"weight_$i"} * $form->{"qty_$i"}); $amount = $form->{"sellprice_$i"} * (1 - $form->{"discount_$i"} / 100) * $form->{"qty_$i"}; map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"}); map { $amount += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{"taxaccounts_$i"} if !$form->{taxincluded}; $form->{creditremaining} -= $amount; $form->{"runningnumber_$i"} = $i; # delete all the new_ variables for $i (1 .. $form->{lastndx}) { map { delete $form->{"new_${_}_$i"} } qw(partnumber description sellprice bin listprice inventory_accno income_accno expense_accno unit assembly taxaccounts id); } map { delete $form->{$_} } qw(ndx lastndx nextsub); if ($form->{item} eq 'assembly') { map { $form->{"qty_$_"} = $form->parse_amount(\%myconfig, $form->{"qty_$_"}) } (1 .. $i); } else { # format amounts for invoice / order map { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}, $decimalplaces) } qw(sellprice listprice); } &display_form; } sub new_item { # change callback $form->{old_callback} = $form->escape($form->{callback},1); $form->{callback} = $form->escape("$form->{script}?action=display_form",1); # delete action delete $form->{action}; # save all other form variables in a previous_form variable foreach $key (keys %$form) { # escape ampersands $form->{$key} =~ s/&/%26/g; $previous_form .= qq|$key=$form->{$key}&|; } chop $previous_form; $previous_form = $form->escape($previous_form, 1); $i = $form->{rowcount}; map { $form->{"${_}_$i"} =~ s/"/"/g } qw(partnumber description); $form->header; print qq|

|.$locale->text('Item not on file!').qq|

|.$locale->text('What type of item is this?').qq|

 |.$locale->text('Part') .qq|
 |.$locale->text('Service') .qq| {rowcount}> {path}> {login}> {password}>

|; } sub display_form { &form_header; $numrows = ++$form->{rowcount}; $subroutine = "display_row"; if ($form->{item} eq 'part') { $numrows = ++$form->{makemodel_rows}; $subroutine = "makemodel_row"; } if ($form->{item} eq 'assembly') { $numrows = ++$form->{makemodel_rows}; $subroutine = "makemodel_row"; # create makemodel rows &{ $subroutine }($numrows); $numrows = ++$form->{assembly_rows}; $subroutine = "assembly_row"; } if ($form->{item} eq 'service') { $numrows = 0; } # create rows &{ $subroutine }($numrows) if $numrows; &form_footer; } sub check_form { my @a = (); my $count = 0; my @flds = (qw(id partnumber description qty sellprice unit discount inventory_accno income_accno expense_accno listprice taxaccounts bin assembly weight projectnumber project_id oldprojectnumber runningnumber partsgroup)); # remove any makes or model rows if ($form->{item} eq 'part') { map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(listprice sellprice lastcost weight rop); @flds = (make, model); for my $i (1 .. ($form->{makemodel_rows})) { if (($form->{"make_$i"} ne "") || ($form->{"model_$i"} ne "")) { push @a, {}; my $j = $#a; map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; $count++; } } $form->redo_rows(\@flds, \@a, $count, $form->{makemodel_rows}); $form->{makemodel_rows} = $count; } elsif ($form->{item} eq 'assembly') { $form->{sellprice} = 0; $form->{weight} = 0; map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(listprice rop); @flds = qw(id qty unit bom partnumber description sellprice weight runningnumber partsgroup); for my $i (1 .. ($form->{assembly_rows} - 1)) { if ($form->{"qty_$i"}) { push @a, {}; my $j = $#a; $form->{"qty_$i"} = $form->parse_amount(\%myconfig, $form->{"qty_$i"}); map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; $form->{sellprice} += ($form->{"qty_$i"} * $form->{"sellprice_$i"}); $form->{weight} += ($form->{"qty_$i"} * $form->{"weight_$i"}); $count++; } } $form->{sellprice} = $form->round_amount($form->{sellprice}, 2); $form->redo_rows(\@flds, \@a, $count, $form->{assembly_rows}); $form->{assembly_rows} = $count; $count = 0; @flds = qw(make model); @a = (); for my $i (1 .. ($form->{makemodel_rows})) { if (($form->{"make_$i"} ne "") || ($form->{"model_$i"} ne "")) { push @a, {}; my $j = $#a; map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; $count++; } } $form->redo_rows(\@flds, \@a, $count, $form->{makemodel_rows}); $form->{makemodel_rows} = $count; } else { # this section applies to invoices and orders # remove any empty numbers if ($form->{rowcount}) { for my $i (1 .. $form->{rowcount} - 1) { if ($form->{"partnumber_$i"}) { push @a, {}; my $j = $#a; map { $a[$j]->{$_} = $form->{"${_}_$i"} } @flds; $count++; } } $form->redo_rows(\@flds, \@a, $count, $form->{rowcount}); $form->{rowcount} = $count; $form->{creditremaining} -= &invoicetotal; } } &display_form; } sub invoicetotal { $form->{oldinvtotal} = 0; # add all parts and deduct paid map { $form->{"${_}_base"} = 0 } split / /, $form->{taxaccounts}; my ($amount, $sellprice, $discount, $qty); for my $i (1 .. $form->{rowcount}) { $sellprice = $form->parse_amount(\%myconfig, $form->{"sellprice_$i"}); $discount = $form->parse_amount(\%myconfig, $form->{"discount_$i"}); $qty = $form->parse_amount(\%myconfig, $form->{"qty_$i"}); $amount = $sellprice * (1 - $discount / 100) * $qty; map { $form->{"${_}_base"} += $amount } (split / /, $form->{"taxaccounts_$i"}); $form->{oldinvtotal} += $amount; } map { $form->{oldinvtotal} += ($form->{"${_}_base"} * $form->{"${_}_rate"}) } split / /, $form->{taxaccounts} if !$form->{taxincluded}; $form->{oldtotalpaid} = 0; for $i (1 .. $form->{paidaccounts}) { $form->{oldtotalpaid} += $form->{"paid_$i"}; } # return total ($form->{oldinvtotal} - $form->{oldtotalpaid}); } sub validate_items { # check if items are valid if ($form->{rowcount} == 1) { &update; exit; } for $i (1 .. $form->{rowcount} - 1) { $form->isblank("partnumber_$i", $locale->text('Number missing in Row') . " $i"); } } sub order { $form->{ordnumber} = $form->{invnumber}; $form->{id} = ''; if ($form->{script} eq 'ir.pl') { $form->{title} = $locale->text('Add Purchase Order'); $form->{vc} = 'vendor'; $form->{type} = 'purchase_order'; $buysell = 'sell'; } if ($form->{script} eq 'is.pl') { $form->{title} = $locale->text('Add Sales Order'); $form->{vc} = 'customer'; $form->{type} = 'sales_order'; $buysell = 'buy'; } $form->{script} = 'oe.pl'; $form->{shipto} = 1; $form->{rowcount}--; require "$form->{path}/$form->{script}"; map { $form->{"select$_"} = "" } ($form->{vc}, currency); $currency = $form->{currency}; &order_links; $form->{currency} = $currency; $form->{exchangerate} = ""; $form->{forex} = ""; $form->{exchangerate} = $exchangerate if ($form->{forex} = ($exchangerate = $form->check_exchangerate(\%myconfig, $form->{currency}, $form->{orddate}, $buysell))); &prepare_order; &display_form; } sub e_mail { if ($myconfig{admin}) { $bcc = qq| |.$locale->text('Bcc').qq| |; } if ($form->{type} eq 'packing_list') { $form->{email} = $form->{shiptoemail} if $form->{shiptoemail}; } $name = $form->{$form->{vc}}; $name =~ s/--.*//g; $title = $locale->text('E-mail')." $name"; $form->{oldmedia} = $form->{media}; $form->{media} = "email"; $form->header; print qq|
{script}>
$title
$bcc
|.$locale->text('To').qq| |.$locale->text('Cc').qq|
|.$locale->text('Subject').qq|
|.$locale->text('Message').qq|
|; &print_options; map { delete $form->{$_} } qw(action email cc bcc subject message type sendmode format); # save all other variables foreach $key (keys %$form) { $form->{$key} =~ s/"/"/g; print qq|\n|; } print qq|


|; } sub send_email { $old_form = new Form; map { $old_form->{$_} = $form->{$_} } keys %$form; $old_form->{media} = $form->{oldmedia}; &print_form($old_form); } sub print_options { $form->{sendmode} = "attachment"; $form->{copies} = 3 unless $form->{copies}; $form->{PD}{$form->{type}} = "checked"; $form->{DF}{$form->{format}} = "checked"; $form->{OP}{$form->{media}} = "checked"; $form->{SM}{$form->{sendmode}} = "checked"; if ($form->{type} =~ /_order/) { $order = qq| {PD}{"$`_order"}>|.$locale->text('Order').qq| |; } else { $invoice = qq| {PD}{invoice}>|.$locale->text('Invoice').qq| {PD}{packing_list}>|.$locale->text('Packing List').qq| |; } if ($form->{media} eq 'email') { $email = qq| {SM}{attachment}> |.$locale->text('Attachment') .qq| {SM}{inline}> |.$locale->text('In-line').qq| |; } else { $screen = qq| {OP}{screen}> |.$locale->text('Screen').qq| |; } print qq| $invoice $order |; if ($latex) { print qq| |; } print qq| $screen |; if ($screen) { if ($myconfig{printer} && $latex) { print qq| |; } } $form->{groupitems} = "checked" if $form->{groupitems}; print qq| $email
{DF}{html}> html{DF}{postscript}> |.$locale->text('Postscript').qq| {DF}{pdf}> |.$locale->text('PDF').qq|{OP}{printer}> |.$locale->text('Printer') .qq| (|.$locale->text('Copies') .qq| {copies}>){groupitems}> |.$locale->text('Group Items').qq|
|; } sub print { # if this goes to the printer pass through if ($form->{media} eq 'printer') { $form->error($locale->text('Select postscript or PDF!')) if ($form->{format} !~ /(postscript|pdf)/); $old_form = new Form; map { $old_form->{$_} = $form->{$_} } keys %$form; } &print_form($old_form); } sub print_form { my $old_form = shift; $inv = "inv"; $due = "due"; if ($form->{type} eq "invoice") { $form->{label} = $locale->text('Invoice'); } if ($form->{type} eq "packing_list") { $form->{label} = $locale->text('Packing List'); } if ($form->{type} eq 'sales_order') { $inv = "ord"; $due = "req"; $form->{label} = $locale->text('Sales Order'); } if ($form->{type} eq 'purchase_order') { $inv = "ord"; $due = "req"; $form->{label} = $locale->text('Purchase Order'); } $form->isblank("email", $locale->text('E-mail address missing!')) if ($form->{media} eq 'email'); $form->isblank("${inv}number", $locale->text($form->{label} .' Number missing!')); $form->isblank("${inv}date", $locale->text($form->{label} .' Date missing!')); # $locale->text('Invoice Number missing!') # $locale->text('Invoice Date missing!') # $locale->text('Packing List Number missing!') # $locale->text('Packing List Date missing!') # $locale->text('Order Number missing!') # $locale->text('Order Date missing!') &validate_items; &{ "$form->{vc}_details" }; @a = (); map { push @a, ("partnumber_$_", "description_$_") } (1 .. $form->{rowcount}); map { push @a, "${_}_description" } split / /, $form->{taxaccounts}; $form->format_string(@a); # format payment dates map { $form->{"datepaid_$_"} = $locale->date(\%myconfig, $form->{"datepaid_$_"}) } (1 .. $form->{paidaccounts}); # create the form variables for the invoice, packing list or order if ($form->{type} =~ /order$/) { OE->order_details(\%myconfig, \%$form); } else { IS->invoice_details(\%myconfig, \%$form); } $form->{"${inv}date"} = $locale->date(\%myconfig, $form->{"${inv}date"}, 1); $form->{"${due}date"} = $locale->date(\%myconfig, $form->{"${due}date"}, 1); @a = qw(name addr1 addr2 addr3 addr4); $fillshipto = 1; # if there is no shipto fill it in from billto foreach $item (@a) { if ($form->{"shipto$item"}) { $fillshipto = 0; last; } } if ($fillshipto) { if ($form->{type} eq 'purchase_order') { $form->{shiptoname} = $myconfig{company}; $form->{shiptoaddr1} = $myconfig{address}; } else { map { $form->{"shipto$_"} = $form->{$_} } @a; } } $form->{notes} =~ s/^\s+//g; # some of the stuff could have umlauts so we translate them push @a, qw(shiptoname shiptoaddr1 shiptoaddr2 shiptoaddr3 shiptoaddr4 shippingpoint company address signature notes); push @a, ("${inv}date", "${due}date"); $form->format_string(@a); $form->{templates} = "$myconfig{templates}"; $form->{IN} = "$form->{type}.html"; if ($form->{format} eq 'postscript') { $form->{postscript} = 1; $form->{IN} =~ s/html$/tex/; } if ($form->{format} eq 'pdf') { $form->{pdf} = 1; $form->{IN} =~ s/html$/tex/; } $form->format_string(email, shiptoemail, cc, bcc) if $form->{format} =~ /(pdf|postscript)/; if ($form->{media} eq 'printer') { $form->{OUT} = "| $myconfig{printer}"; } if ($form->{media} eq 'email') { $form->{subject} = qq|$form->{label} $form->{"${inv}number"}| unless $form->{subject}; $form->{OUT} = "$sendmail"; } $form->parse_template(\%myconfig, $userspath); $form->{callback} = ""; # if we got back here restore the previous form if ($form->{media} =~ /(printer|email)/) { if ($old_form) { # restore and display form map { $form->{$_} = $old_form->{$_} } keys %$old_form; $form->{rowcount}--; map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); for $i (1 .. $form->{paidaccounts}) { map { $form->{"${_}_$i"} = $form->parse_amount(\%myconfig, $form->{"${_}_$i"}) } qw(paid exchangerate); } &display_form; exit; } $msg = ($form->{media} eq 'printer') ? $locale->text('sent to printer') : $locale->text('emailed to')." $form->{email}"; $form->redirect(qq|$form->{label} $form->{"${inv}number"} $msg|); } } sub customer_details { IS->customer_details(\%myconfig, \%$form); } sub vendor_details { IR->vendor_details(\%myconfig, \%$form); } sub post_as_new { $form->{postasnew} = 1; &post; } sub ship_to { $title = $form->{title}; $form->{title} = $locale->text('Ship to'); $form->{rowcount}--; map { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } qw(exchangerate creditlimit creditremaining); # get details for name &{ "$form->{vc}_details" }; $form->header; print qq|
{script}>
|.$locale->text('To').qq| |.$locale->text('Ship to').qq|
|.$locale->text('Number').qq| $form->{"$form->{vc}number"}
|.$locale->text('Name').qq| $form->{name}
|.$locale->text('Address').qq| $form->{addr1}
$form->{addr2}
$form->{addr3}
$form->{addr4}
|.$locale->text('Contact').qq| $form->{contact}
|.$locale->text('Phone').qq| $form->{"$form->{vc}phone"}
|.$locale->text('Fax').qq| $form->{"$form->{vc}fax"}
|.$locale->text('E-mail').qq| $form->{email}
|; # delete shipto map { delete $form->{$_} } qw(shiptoname shiptoaddr1 shiptoaddr2 shiptoaddr3 shiptoaddr4 shiptocontact shiptophone shiptofax shiptoemail); $form->{title} = $title; foreach $key (keys %$form) { $form->{$key} =~ s/"/"/g; print qq|\n|; } print qq|

|; }