diff options
Diffstat (limited to 'bin/pe.pl')
| -rwxr-xr-x | bin/pe.pl | 2569 |
1 files changed, 2569 insertions, 0 deletions
diff --git a/bin/pe.pl b/bin/pe.pl new file mode 100755 index 00000000..8fdc4aae --- /dev/null +++ b/bin/pe.pl @@ -0,0 +1,2569 @@ +#===================================================================== +# LedgerSMB +# Small Medium Business Accounting software +# http://www.ledgersmb.org/ +# +# +# See COPYRIGHT file for copyright information +#====================================================================== +# +# This file has NOT undergone whitespace cleanup. +# +#====================================================================== +# +# project/job administration +# partsgroup administration +# translation maintainance +# +#====================================================================== + + +use LedgerSMB::PE; +use LedgerSMB::AA; +use LedgerSMB::OE; + +1; +# end of main + + + +sub add { + + # construct callback + $form->{callback} = "$form->{script}?action=add&type=$form->{type}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}" unless $form->{callback}; + + &{ "prepare_$form->{type}" }; + + $form->{orphaned} = 1; + &display_form; + +} + + +sub edit { + + &{ "prepare_$form->{type}" }; + &display_form; + +} + + +sub prepare_partsgroup { PE->get_partsgroup(\%myconfig, \%$form) if $form->{id} } +sub prepare_pricegroup { PE->get_pricegroup(\%myconfig, \%$form) if $form->{id} } + +sub prepare_job { + +# $locale->text('Add Job') +# $locale->text('Edit Job') + + $form->{vc} = 'customer'; + + PE->get_job(\%myconfig, \%$form); + + $form->{taxaccounts} = ""; + for (keys %{ $form->{IC_links} }) { + + $form->{"select$_"} = ""; + foreach $ref (@{ $form->{IC_links}{$_} }) { + if (/IC_tax/) { + if (/taxpart/) { + $form->{taxaccounts} .= "$ref->{accno} "; + $form->{"IC_tax_$ref->{accno}_description"} = "$ref->{accno}--$ref->{description}"; + if ($form->{id}) { + if ($form->{amount}{$ref->{accno}}) { + $form->{"IC_tax_$ref->{accno}"} = "checked"; + } + } else { + $form->{"IC_tax_$ref->{accno}"} = "checked"; + } + } + } else { + $form->{"select$_"} .= "<option>$ref->{accno}--$ref->{description}\n"; + } + } + } + chop $form->{taxaccounts}; + + $form->{selectIC_income} = $form->{selectIC_sale}; + $form->{IC_income} = $form->{IC_sale}; + + $form->{IC_income} = qq|$form->{income_accno}--$form->{income_description}|; + + delete $form->{IC_links}; + + $form->{"old$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + + if (@{ $form->{"all_$form->{vc}"} }) { + $form->{"$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + $form->{"select$form->{vc}"} = qq|<option>\n|; + for (@{ $form->{"all_$form->{vc}"} }) { $form->{"select$form->{vc}"} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n| } + } + + $form->get_partsgroup(\%myconfig, {all => 1}); + $form->{partsgroup} = $form->quote($form->{partsgroup})."--$form->{partsgroup_id}"; + if (@{ $form->{all_partsgroup} }) { + $form->{selectpartsgroup} = qq|<option>\n|; + for (@{ $form->{all_partsgroup} }) { $form->{selectpartsgroup} .= qq|<option value="|.$form->quote($_->{partsgroup}).qq|--$_->{id}">$_->{partsgroup}\n| } + } + + $form->{locked} = ($form->{revtrans}) ? '1' : ($form->datetonum(\%myconfig, $form->{transdate}) <= $form->datetonum(\%myconfig, $form->{closedto})); + + $form->{readonly} = 1 if $myconfig{acs} =~ /Job Costing--Add Job/; + +} + + +sub job_header { + + for (qw(partnumber partdescription description notes unit)) { $form->{$_} = $form->quote($form->{$_}) } + + for (qw(production weight)) { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}) } + for (qw(listprice sellprice)) { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}, 2) } + + if (($rows = $form->numtextrows($form->{partdescription}, 60)) > 1) { + $partdescription = qq|<textarea name="partdescription" rows=$rows cols=60 style="width: 100%" wrap=soft>$form->{partdescription}</textarea>|; + } else { + $partdescription = qq|<input name=partdescription size=60 value="$form->{partdescription}">|; + } + + if (($rows = $form->numtextrows($form->{description}, 60)) > 1) { + $description = qq|<textarea name="description" rows=$rows cols=60 style="width: 100%" wrap=soft>$form->{description}</textarea>|; + } else { + $description = qq|<input name=description size=60 value="$form->{description}">|; + } + + if (($rows = $form->numtextrows($form->{notes}, 40)) < 2) { + $rows = 2; + } + + $notes = qq|<textarea name=notes rows=$rows cols=40 wrap=soft>$form->{notes}</textarea>|; + + $form->{selectIC_income} = $form->unescape($form->{selectIC_income}); + $form->{"select$form->{vc}"} = $form->unescape($form->{"select$form->{vc}"}); + $form->{"select$form->{vc}"} =~ s/ selected//; + $form->{"select$form->{vc}"} =~ s/(<option value="\Q$form->{"$form->{vc}"}\E")/$1 selected/; + + + $label = ucfirst $form->{vc}; + if ($form->{"select$form->{vc}"}) { + $name = qq| + <tr> + <th align=right nowrap>|.$locale->text($label).qq|</th> + <td colspan=3><select name="$form->{vc}">$form->{"select$form->{vc}"}</select></td> + <input type=hidden name="select$form->{vc}" value="|. + $form->escape($form->{"select$form->{vc}"},1).qq|"> + </tr> +|; + } else { + $name = qq| + <tr> + <th align=right nowrap>|.$locale->text($label).qq|</th> + <td colspan=3><input name="$form->{vc}" value="$form->{"$form->{vc}"}" size=35></td> + <input type=hidden name="select$form->{vc}" value="|. + $form->escape($form->{"select$form->{vc}"},1).qq|"> + </tr> +|; + } + + if ($form->{orphaned}) { + + for (qw(income)) { + $form->{"selectIC_$_"} =~ s/ selected//; + $form->{"selectIC_$_"} =~ s/option>\Q$form->{"IC_$_"}\E/option selected>$form->{"IC_$_"}/; + } + + $production = qq| + <tr> + <th align=right nowrap>|.$locale->text('Production').qq|</th> + <td><input name=production size=10 value="$form->{production}"></td> + <th align=right nowrap>|.$locale->text('Completed').qq|</th> + <td>$form->{completed}</td> + </tr> +|; + + } else { + + $form->{selectIC_income} = qq|<option selected>$form->{IC_income}|; + + $production = qq| + <tr> + <th align=right nowrap>|.$locale->text('Production').qq|</th> + <td><input type=hidden name=production value="$form->{production}">$form->{production}</td> + <th align=right nowrap>|.$locale->text('Completed').qq|</th> + <td>$form->{completed}</td> + </tr> +|; + + } + + for (split / /, $form->{taxaccounts}) { $form->{"IC_tax_$_"} = ($form->{"IC_tax_$_"}) ? "checked" : "" } + + if ($form->{selectpartsgroup}) { + $form->{selectpartsgroup} = $form->unescape($form->{selectpartsgroup}); + + $partsgroup = qq|<input type=hidden name=selectpartsgroup value="|.$form->escape($form->{selectpartsgroup},1).qq|">|; + $form->{partsgroup} = $form->quote($form->{partsgroup}); + $form->{selectpartsgroup} =~ s/(<option value="\Q$form->{partsgroup}\E")/$1 selected/; + + $partsgroup .= qq|\n<select name=partsgroup>$form->{selectpartsgroup}</select>|; + $group = $locale->text('Group'); + } + + $linkaccounts = qq| + <tr> + <th align=right nowrap>|.$locale->text('Income').qq|</th> + <td><select name=IC_income>$form->{selectIC_income}</select></td> + </tr> +|; + + for (split / /, $form->{taxaccounts}) { + $tax .= qq| + <input class=checkbox type=checkbox name="IC_tax_$_" value=1 $form->{"IC_tax_$_"}> <b>$form->{"IC_tax_${_}_description"}</b> + <br><input type=hidden name=IC_tax_${_}_description value="$form->{"IC_tax_${_}_description"}"> +|; + } + + if ($tax) { + $linkaccounts .= qq| + <tr> + <th align=right>|.$locale->text('Tax').qq|</th> + <td>$tax</td> + </tr> +|; + } + + $partnumber = qq| + <tr> + <td> + <table> + <tr valign=top> + <th align=left>|.$locale->text('Number').qq|</th> + <th align=left>|.$locale->text('Description').qq|</th> + <th align=left>$group</th> + </tr> + <tr valign=top> + <td><input name=partnumber value="$form->{partnumber}" size=20></td> + <td>$partdescription</td> + <td>$partsgroup</td> + </tr> + </table> + </td> + </tr> +|; + + $form->{title} = ($form->{id}) ? $locale->text('Edit Job') : $locale->text('Add Job'); + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> +|; + + for (qw(partnumber startdate enddate)) { $form->{"old$_"} = $form->{$_} } + + print qq|<input type=hidden name="selectIC_income" value="|.$form->escape($form->{"selectIC_income"},1).qq|">\n|; + + $form->hide_form("id", "type", "old$form->{vc}", "$form->{vc}_id", "orphaned", "taxaccounts", "vc", "project"); + + print qq| + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table> + <tr> + <th align=right>|.$locale->text('Number').qq|</th> + <td><input name=projectnumber size=20 value="$form->{projectnumber}"></td> + <th align=right>|.$locale->text('Description').qq|</th> + <td>$description</td> + </tr> + $name + <tr> + <th align=right>|.$locale->text('Startdate').qq|</th> + <td><input name=startdate size=11 title="($myconfig{dateformat})" value=$form->{startdate}></td> + <th align=right>|.$locale->text('Enddate').qq|</th> + <td><input name=enddate size=11 title="($myconfig{dateformat})" value=$form->{enddate}></td> + </tr> + $production + </table> + </td> + </tr> + <tr class="listheading"> + <th class="listheading" align="center">|.$locale->text('Assembly').qq|</th> + </tr> + <tr> + <td> + <table width=100%> + $partnumber + <tr> + <td colspan=3> + <table width=100%> + <tr> + <td width=70%> + <table width=100%> + <tr class="listheading"> + <th class="listheading" align="center" colspan=2>|.$locale->text('Link Accounts').qq|</th> + </tr> + $linkaccounts + <tr> + <th align="left">|.$locale->text('Notes').qq|</th> + </tr> + <tr> + <td colspan=2> + $notes + </td> + </tr> + </table> + </td> + <td align=right> + <table> + <tr> + <th align="right" nowrap="true">|.$locale->text('Updated').qq|</th> + <td><input name=priceupdate size=11 title="$myconfig{dateformat}" value=$form->{priceupdate}></td> + </tr> + <tr> + <th align="right" nowrap="true">|.$locale->text('List Price').qq|</th> + <td><input name=listprice size=11 value=$form->{listprice}></td> + </tr> + <tr> + <th align="right" nowrap="true">|.$locale->text('Sell Price').qq|</th> + <td><input name=sellprice size=11 value=$form->{sellprice}></td> + </tr> + <tr> + <th align="right" nowrap="true">|.$locale->text('Weight').qq|</th> + <td> + <table> + <tr> + <td> + <input name=weight size=10 value=$form->{weight}> + </td> + <th> + + $form->{weightunit} + <input type=hidden name=weightunit value=$form->{weightunit}> + </th> + </tr> + </table> + </td> + <tr> + <th align="right" nowrap="true">|.$locale->text('Bin').qq|</th> + <td><input name=bin size=10 value="$form->{bin}"></td> + </tr> + <tr> + <th align="right" nowrap="true">|.$locale->text('Unit').qq|</th> + <td><input name=unit size=5 value="$form->{unit}"></td> + </tr> + </table> + </td> + </tr> + </table> + </td> + </tr> + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> +|; + +} + + +sub job_footer { + + $form->hide_form(qw(callback path login sessionid)); + +# type=submit $locale->text('Update') +# type=submit $locale->text('Save') +# type=submit $locale->text('Delete') + + %button = ('Update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, + ); + + if ($myconfig{acs} !~ /Job Costing--Add Job/) { + $button{'Save'} = { ndx => 3, key => 'S', value => $locale->text('Save') }; + + if ($form->{id} && $form->{orphaned}) { + $button{'Delete'} = { ndx => 16, key => 'D', value => $locale->text('Delete') }; + } + } + + for (sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button) { $form->print_button(\%button, $_) } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| +</form> + +</body> +</html> +|; + +} + + +sub list_stock { + + PE->list_stock(\%myconfig, \%$form); + + $form->{title} = $locale->text('Stock Finished Goods'); + $form->{action} = "list_stock"; + + $href = "$form->{script}?"; + for (qw(action direction oldsort type path login sessionid status)) { $href .= "$_=$form->{$_}&" } + + $form->sort_order(); + + $callback = "$form->{script}?"; + for (qw(action direction oldsort type path login sessionid status)) { $callback .= "$_=$form->{$_}&" } + + @column_index = $form->sort_columns(qw(projectnumber description startdate partnumber production completed stock)); + + if ($form->{projectnumber}) { + $href .= "&projectnumber=".$form->escape($form->{projectnumber}); + $callback .= "&projectnumber=$form->{projectnumber}"; + ($var) = split /--/, $form->{projectnumber}; + $option .= "\n<br>".$locale->text('Job Number')." : $var"; + } + if ($form->{stockingdate}) { + $href .= "&stockingdate=$form->{stockingdate}"; + $option .= "\n<br>".$locale->text('As of')." : ".$locale->date(\%myconfig, $form->{stockingdate}, 1); + } + + $column_header{projectnumber} = qq|<th width=30%><a class=listheading href=$href&sort=projectnumber>|.$locale->text('Number').qq|</a></th>|; + $column_header{description} = qq|<th width=50%><a class=listheading href=$href&sort=description>|.$locale->text('Description').qq|</a></th>|; + $column_header{startdate} = qq|<th width=10%><a class=listheading href=$href&sort=startdate>|.$locale->text('Startdate').qq|</a></th>|; + $column_header{partnumber} = "<th><a class=listheading href=$href&sort=partnumber>" . $locale->text('Assembly') . "</a></th>"; + $column_header{production} = "<th class=listheading>" . $locale->text('Production') . "</a></th>"; + $column_header{completed} = "<th class=listheading>" . $locale->text('Completed') . "</a></th>"; + $column_header{stock} = "<th class=listheading>" . $locale->text('Add') . "</a></th>"; + + + $form->header; + + if (@{ $form->{all_project} }) { + $sameitem = $form->{all_project}->[0]->{$form->{sort}}; + } + + print qq| +<body> + +<form method=post action=$form->{script}> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td>$option</td> + </tr> + <tr> + <td> + <table width=100%> + <tr class=listheading> +|; + + for (@column_index) { print "$column_header{$_}\n" } + + print qq| + </tr> +|; + + # escape callback + $form->{callback} = $callback .= "&sort=$form->{sort}"; + + # escape callback for href + $callback = $form->escape($callback); + + # flip direction + $direction = ($form->{direction} eq 'ASC') ? "ASC" : "DESC"; + $href =~ s/&direction=(\w+)&/&direction=$direction&/; + + $i = 0; + foreach $ref (@{ $form->{all_project} }) { + + $i++; + + for (qw(projectnumber description startdate enddate partnumber)) { $column_data{$_} = qq|<td>$ref->{$_} </td>| } + for (qw(production completed)) { $column_data{$_} = qq|<td align=right>|.$form->format_amount(\%myconfig, $ref->{$_}).qq|</td>| } + $column_data{stock} = qq|<td><input name="stock_$i" size=6></td>|; + + $j++; $j %= 2; + + print qq| + <tr valign=top class=listrow$j> + <input type=hidden name="id_$i" value=$ref->{id}> +|; + + for (@column_index) { print "$column_data{$_}\n" } + + print " + </tr> +"; + } + + print qq| + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> +|; + + $form->hide_form(qw(callback type path login sessionid status)); + + print qq| +<input type=hidden name=nextsub value="stock"> +<br> +<input type=submit class=submit name=action value="|.$locale->text('Continue').qq|"> +</form> + +</body> +</html> +|; + +} + + +sub stock { + + if (PE->stock_assembly(\%myconfig, \%$form)) { + $form->redirect($locale->text('Assembly stocked!')); + } else { + $form->error($locale->text('Cannot stock Assembly!')); + } + +} + + +sub prepare_project { + + $form->{vc} = 'customer'; + + PE->get_project(\%myconfig, \%$form); + + $form->{title} = ($form->{id}) ? $locale->text('Edit Project') : $locale->text('Add Project'); + + $form->{"old$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + + if (@{ $form->{"all_$form->{vc}"} }) { + $form->{"$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + $form->{"select$form->{vc}"} = qq|<option>\n|; + for (@{ $form->{"all_$form->{vc}"} }) { $form->{"select$form->{vc}"} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n| } + } + +} + + +sub search { + + # accounting years + $form->all_years(\%myconfig); + + if (@{ $form->{all_years} }) { + $form->{selectaccountingyear} = "<option>\n"; + for (@{ $form->{all_years} }) { $form->{selectaccountingyear} .= qq|<option>$_\n| } + + $form->{selectaccountingmonth} = "<option>\n"; + for (sort keys %{ $form->{all_month} }) { $form->{selectaccountingmonth} .= qq|<option value=$_>|.$locale->text($form->{all_month}{$_}).qq|\n| } + + $fromto = qq| + <tr> + <th align=right>|.$locale->text('Startdate').qq|</th> + <td>|.$locale->text('From').qq| <input name=startdatefrom size=11 title="($myconfig{'dateformat'})">|.$locale->text('To').qq| + <input name=startdateto size=11 title="($myconfig{'dateformat'})"></td> + </tr> +|; + + $selectperiod = qq| + <tr> + <th align=right>|.$locale->text('Period').qq|</th> + <td colspan=3> + <select name=month>$form->{selectaccountingmonth}</select> + <select name=year>$form->{selectaccountingyear}</select> + <input name=interval class=radio type=radio value=0 checked> |.$locale->text('Current').qq| + <input name=interval class=radio type=radio value=1> |.$locale->text('Month').qq| + <input name=interval class=radio type=radio value=3> |.$locale->text('Quarter').qq| + <input name=interval class=radio type=radio value=12> |.$locale->text('Year').qq| + </td> + </tr> +|; + } + + + $orphaned = qq| + <input name=status class=radio type=radio value=orphaned> |.$locale->text('Orphaned'); + + if ($form->{type} eq 'project') { + $report = "project_report"; + $sort = "projectnumber"; + $form->{title} = $locale->text('Projects'); + + $number = qq| + <tr> + <th align=right width=1%>|.$locale->text('Number').qq|</th> + <td><input name=projectnumber size=20></td> + </tr> + <tr> + <th align=right>|.$locale->text('Description').qq|</th> + <td><input name=description size=60></td> + </tr> +|; + } + + if ($form->{type} eq 'stock') { + $report = "list_stock"; + $form->{title} = $locale->text('Stock Finished Goods'); + PE->list_stock(\%myconfig, \%$form); + + $selectperiod = ""; + $orphaned = ""; + $fromto = qq| + <tr> + <th align=right nowrap>|.$locale->text('As of').qq|</th> + <td><input name=stockingdate size=11 title="$myconfig{dateformat}"></td> + </tr> +|; + + $number = qq| + <tr> + <th align=right width=1%>|.$locale->text('Job Number').qq|</th> + <td><input name=projectnumber size=20></td> + </tr> + <tr> + <th align=right>|.$locale->text('Description').qq|</th> + <td><input name=description size=60></td> + </tr> +|; + } + + if ($form->{type} eq 'job') { + $report = "job_report"; + $sort = "projectnumber"; + $form->{title} = $locale->text('Jobs'); + + $number = qq| + <tr> + <th align=right width=1%>|.$locale->text('Number').qq|</th> + <td><input name=projectnumber size=20></td> + </tr> + <tr> + <th align=right>|.$locale->text('Description').qq|</th> + <td><input name=description size=60></td> + </tr> +|; + } + + if ($form->{type} eq 'partsgroup') { + $report = "partsgroup_report"; + $sort = 'partsgroup'; + $form->{title} = $locale->text('Groups'); + + $fromto = ""; + $selectperiod = ""; + $number = qq| + <tr> + <th align=right width=1%>|.$locale->text('Group').qq|</th> + <td><input name=partsgroup size=20></td> + </tr> +|; + } + + if ($form->{type} eq 'pricegroup') { + $report = "pricegroup_report"; + $sort = 'pricegroup'; + $form->{title} = $locale->text('Pricegroups'); + + $fromto = ""; + $selectperiod = ""; + $number = qq| + <tr> + <th align=right width=1%>|.$locale->text('Pricegroup').qq|</th> + <td><input name=pricegroup size=20></td> + </tr> +|; + } + + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=sort value=$sort> +<input type=hidden name=type value=$form->{type}> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table width=100%> + $number + $fromto + $selectperiod + <tr> + <td></td> + <td><input name=status class=radio type=radio value=all checked> |.$locale->text('All').qq| + <input name=status class=radio type=radio value=active> |.$locale->text('Active').qq| + <input name=status class=radio type=radio value=inactive> |.$locale->text('Inactive').qq| + $orphaned</td> + </tr> + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<input type=hidden name=nextsub value=$report> +|; + + $form->hide_form(qw(path login sessionid title)); + + print qq| +<input class=submit type=submit name=action value="|.$locale->text('Continue').qq|"> +</form> +|; + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + +</body> +</html> +|; + +} + + +sub job_report { + + for (qw(projectnumber description)) { $form->{$_} = $form->unescape($form->{$_}) } + PE->jobs(\%myconfig, \%$form); + + $form->{action} = "job_report"; + &list_projects; + +} + + +sub project_report { + + for (qw(projectnumber description)) { $form->{$_} = $form->unescape($form->{$_}) } + PE->projects(\%myconfig, \%$form); + + $form->{action} = "project_report"; + &list_projects; + +} + + +sub list_projects { + + $href = "$form->{script}?"; + for (qw(action direction oldsort type path login sessionid status startdatefrom startdateto)) { $href .= "$_=$form->{$_}&" } + + $form->sort_order(); + + $callback = "$form->{script}?"; + for (qw(action direction oldsort type path login sessionid status startdatefrom startdateto)) { $callback .= "$_=$form->{$_}&" } + + @column_index = $form->sort_columns(qw(projectnumber description name startdate enddate)); + + if ($form->{status} eq 'all') { + $option = $locale->text('All'); + } + if ($form->{status} eq 'orphaned') { + $option .= $locale->text('Orphaned'); + } + if ($form->{status} eq 'active') { + $option = $locale->text('Active'); + @column_index = $form->sort_columns(qw(projectnumber description name startdate)); + } + if ($form->{status} eq 'inactive') { + $option = $locale->text('Inactive'); + } + + if ($form->{type} eq 'project') { + $label = $locale->text('Project'); + $form->{title} = $locale->text('Projects'); + } else { + $label = $locale->text('Job'); + push @column_index, qw(partnumber production completed); + $form->{title} = $locale->text('Jobs'); + } + + if ($form->{projectnumber}) { + $href .= "&projectnumber=".$form->escape($form->{projectnumber}); + $callback .= "&projectnumber=$form->{projectnumber}"; + $option .= "\n<br>$label : $form->{projectnumber}"; + } + if ($form->{description}) { + $href .= "&description=".$form->escape($form->{description}); + $callback .= "&description=$form->{description}"; + $option .= "\n<br>".$locale->text('Description')." : $form->{description}"; + } + if ($form->{startdatefrom}) { + $href .= "&startdatefrom=$form->{startdatefrom}"; + $option .= "\n<br>".$locale->text('From')." ".$locale->date(\%myconfig, $form->{startdatefrom}, 1); + } + if ($form->{startdateto}) { + $href .= "&startdateto=$form->{startdateto}"; + if ($form->{startdatefrom}) { + $option .= " "; + } else { + $option .= "\n<br>" if ($option); + } + $option .= $locale->text('To')." ".$locale->date(\%myconfig, $form->{startdateto}, 1); + } + + + $column_header{projectnumber} = qq|<th><a class=listheading href=$href&sort=projectnumber>|.$locale->text('Number').qq|</a></th>|; + $column_header{description} = qq|<th><a class=listheading href=$href&sort=description>|.$locale->text('Description').qq|</a></th>|; + $column_header{startdate} = qq|<th width=10><a class=listheading href=$href&sort=startdate>|.$locale->text('Startdate').qq|</a></th>|; + $column_header{enddate} = qq|<th width=10><a class=listheading href=$href&sort=enddate>|.$locale->text('Enddate').qq|</a></th>|; + + $column_header{partnumber} = "<th><a class=listheading href=$href&sort=partnumber>" . $locale->text('Assembly') . "</a></th>"; + $column_header{production} = "<th width=10 class=listheading>" . $locale->text('Production') . "</th>"; + $column_header{completed} = "<th width=10 class=listheading>" . $locale->text('Completed') . "</th>"; + $column_header{name} = "<th class=listheading>" . $locale->text('Customer') . "</th>"; + + + $form->header; + + if (@{ $form->{all_project} }) { + $sameitem = $form->{all_project}->[0]->{$form->{sort}}; + } + + print qq| +<body> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td>$option</td> + </tr> + <tr> + <td> + <table width=100%> + <tr class=listheading> +|; + + for (@column_index) { print "$column_header{$_}\n" } + + print qq| + </tr> +|; + + # escape callback + $form->{callback} = $callback .= "&sort=$form->{sort}"; + + # escape callback for href + $callback = $form->escape($callback); + + # flip direction + $direction = ($form->{direction} eq 'ASC') ? "ASC" : "DESC"; + $href =~ s/&direction=(\w+)&/&direction=$direction&/; + + foreach $ref (@{ $form->{all_project} }) { + + for (qw(description startdate enddate name)) { $column_data{$_} = qq|<td>$ref->{$_} </td>| } + + for (qw(production completed)) { $column_data{$_} = qq|<td align=right>|.$form->format_amount(\%myconfig, $ref->{$_}) } + + $column_data{projectnumber} = qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&project=$form->{project}&callback=$callback>$ref->{projectnumber}</td>|; + $column_data{partnumber} = qq|<td><a href=ic.pl?action=edit&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ref->{partnumber}</td>|; + + $j++; $j %= 2; + + print qq| + <tr valign=top class=listrow$j> +|; + + for (@column_index) { print "$column_data{$_}\n" } + + print " + </tr> +"; + } + + $i = 1; + if ($form->{type} eq 'project') { + if ($myconfig{acs} !~ /Projects--Projects/) { + $button{'Projects--Add Project'}{code} = qq|<input class=submit type=submit name=action value="|.$locale->text('Add Project').qq|"> |; + $button{'Projects--Add Project'}{order} = $i++; + + for (split /;/, $myconfig{acs}) { + delete $button{$_}; + } + } + } else { + if ($myconfig{acs} !~ /Job Costing--Job Costing/) { + $button{'Job Costing--Add Job'}{code} = qq|<input class=submit type=submit name=action value="|.$locale->text('Add Job').qq|"> |; + $button{'Job Costing--Add Job'}{order} = $i++; + + for (split /;/, $myconfig{acs}) { + delete $button{$_}; + } + } + } + + print qq| + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<br> +<form method=post action=$form->{script}> +|; + + $form->hide_form(qw(callback type path login sessionid)); + + foreach $item (sort { $a->{order} <=> $b->{order} } %button) { + print $item->{code}; + } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + </form> + +</body> +</html> +|; + +} + + +sub project_header { + + $form->{description} = $form->quote($form->{description}); + + if (($rows = $form->numtextrows($form->{description}, 60)) > 1) { + $description = qq|<textarea name="description" rows=$rows cols=60 style="width: 100%" wrap=soft>$form->{description}</textarea>|; + } else { + $description = qq|<input name=description size=60 value="$form->{description}">|; + } + + $form->{"select$form->{vc}"} = $form->unescape($form->{"select$form->{vc}"}); + $form->{"select$form->{vc}"} =~ s/ selected//; + $form->{"select$form->{vc}"} =~ s/(<option value="\Q$form->{"$form->{vc}"}\E")/$1 selected/; + + $label = ucfirst $form->{vc}; + if ($form->{"select$form->{vc}"}) { + $name = qq| + <tr> + <th align=right nowrap>|.$locale->text($label).qq|</th> + <td colspan=3><select name="$form->{vc}">$form->{"select$form->{vc}"}</select></td> + <input type=hidden name="select$form->{vc}" value="|. + $form->escape($form->{"select$form->{vc}"},1).qq|"> + </tr> +|; + } else { + $name = qq| + <tr> + <th align=right nowrap>|.$locale->text($label).qq|</th> + <td colspan=3><input name="$form->{vc}" value="$form->{"$form->{vc}"}" size=35></td> + <input type=hidden name="select$form->{vc}" value="|. + $form->escape($form->{"select$form->{vc}"},1).qq|"> + </tr> +|; + } + + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> +|; + + $form->hide_form("id", "type", "old$form->{vc}", "$form->{vc}_id", "orphaned","vc", "title"); + + print qq| +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table> + <tr> + <th align=right>|.$locale->text('Number').qq|</th> + <td><input name=projectnumber size=20 value="$form->{projectnumber}"></td> + <th align=right>|.$locale->text('Description').qq|</th> + <td>$description</td> + </tr> + $name + <tr> + <th align=right>|.$locale->text('Startdate').qq|</th> + <td><input name=startdate size=11 title="($myconfig{dateformat})" value=$form->{startdate}></td> + <th align=right>|.$locale->text('Enddate').qq|</th> + <td><input name=enddate size=11 title="($myconfig{dateformat})" value=$form->{enddate}></td> + </tr> + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> +|; + +} + + +sub project_footer { + + $form->hide_form(qw(callback path login sessionid)); + + %button = ('Update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, + ); + + if ($myconfig{acs} !~ /Projects--Add Project/) { + $button{'Save'} = { ndx => 3, key => 'S', value => $locale->text('Save') }; + + if ($form->{id} && $form->{orphaned}) { + $button{'Delete'} = { ndx => 16, key => 'D', value => $locale->text('Delete') }; + } + } + + for (sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button) { $form->print_button(\%button, $_) } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| +</form> + +</body> +</html> +|; + +} + + +sub save { + + if ($form->{translation}) { + PE->save_translation(\%myconfig, \%$form); + $form->redirect($locale->text('Translations saved!')); + exit; + } + + if ($form->{type} eq 'project') { + if ($form->{"select$form->{vc}"}) { + ($null, $form->{"$form->{vc}_id"}) = split /--/, $form->{"$form->{vc}"}; + } else { + if ($form->{"old$form->{vc}"} ne qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|) { + + if (($rv = $form->get_name(\%myconfig, $form->{vc}, $form->{startdate})) > 1) { + &select_name; + exit; + } + + if ($rv == 1) { + $form->{"$form->{vc}_id"} = $form->{name_list}[0]->{id}; + $form->{"$form->{vc}"} = $form->{name_list}[0]->{name}; + $form->{"old$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + } + } + } + + PE->save_project(\%myconfig, \%$form); + $form->redirect($locale->text('Project saved!')); + } + + if ($form->{type} eq 'partsgroup') { + $form->isblank("partsgroup", $locale->text('Group missing!')); + PE->save_partsgroup(\%myconfig, \%$form); + $form->redirect($locale->text('Group saved!')); + } + + if ($form->{type} eq 'pricegroup') { + $form->isblank("pricegroup", $locale->text('Pricegroup missing!')); + PE->save_pricegroup(\%myconfig, \%$form); + $form->redirect($locale->text('Pricegroup saved!')); + } + + + if ($form->{type} eq 'job') { + if ($form->{"select$form->{vc}"}) { + ($null, $form->{"$form->{vc}_id"}) = split /--/, $form->{"$form->{vc}"}; + } else { + if ($form->{"old$form->{vc}"} ne qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|) { + + if (($rv = $form->get_name(\%myconfig, $form->{vc}, $form->{startdate})) > 1) { + &select_name; + exit; + } + + if ($rv == 1) { + $form->{"$form->{vc}_id"} = $form->{name_list}[0]->{id}; + $form->{"$form->{vc}"} = $form->{name_list}[0]->{name}; + $form->{"old$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + } + } + } + + PE->save_job(\%myconfig, \%$form); + $form->redirect($locale->text('Job saved!')); + } + +} + + +sub delete { + + if ($form->{translation}) { + PE->delete_translation(\%myconfig, \%$form); + $form->redirect($locale->text('Translation deleted!')); + + } else { + + if ($form->{type} eq 'project') { + PE->delete_project(\%myconfig, \%$form); + $form->redirect($locale->text('Project deleted!')); + } + if ($form->{type} eq 'job') { + PE->delete_job(\%myconfig, \%$form); + $form->redirect($locale->text('Job deleted!')); + } + if ($form->{type} eq 'partsgroup') { + PE->delete_partsgroup(\%myconfig, \%$form); + $form->redirect($locale->text('Group deleted!')); + } + if ($form->{type} eq 'pricegroup') { + PE->delete_pricegroup(\%myconfig, \%$form); + $form->redirect($locale->text('Pricegroup deleted!')); + } + } + +} + + +sub partsgroup_report { + + $form->{partsgroup} = $form->unescape($form->{partsgroup}); + PE->partsgroups(\%myconfig, \%$form); + + $href = "$form->{script}?action=partsgroup_report&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&status=$form->{status}"; + + $form->sort_order(); + + $callback = "$form->{script}?action=partsgroup_report&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&status=$form->{status}"; + + if ($form->{status} eq 'all') { + $option = $locale->text('All'); + } + if ($form->{status} eq 'orphaned') { + $option .= $locale->text('Orphaned'); + } + if ($form->{partsgroup}) { + $callback .= "&partsgroup=$form->{partsgroup}"; + $option .= "\n<br>".$locale->text('Group')." : $form->{partsgroup}"; + } + + + @column_index = $form->sort_columns(qw(partsgroup)); + + $column_header{partsgroup} = qq|<th><a class=listheading href=$href&sort=partsgroup width=90%>|.$locale->text('Group').qq|</a></th>|; + + $form->{title} = $locale->text('Groups'); + + $form->header; + + print qq| +<body> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td>$option</td> + </tr> + <tr> + <td> + <table width=100%> + <tr class=listheading> +|; + + for (@column_index) { print "$column_header{$_}\n" } + + print qq| + </tr> +|; + + # escape callback + $form->{callback} = $callback; + + # escape callback for href + $callback = $form->escape($callback); + + foreach $ref (@{ $form->{item_list} }) { + + $i++; $i %= 2; + + print qq| + <tr valign=top class=listrow$i> +|; + + $column_data{partsgroup} = qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ref->{partsgroup}</td>|; + for (@column_index) { print "$column_data{$_}\n" } + + print " + </tr> +"; + } + + $i = 1; + if ($myconfig{acs} !~ /Goods \& Services--Goods \& Services/) { + $button{'Goods & Services--Add Group'}{code} = qq|<input class=submit type=submit name=action value="|.$locale->text('Add Group').qq|"> |; + $button{'Goods & Services--Add Group'}{order} = $i++; + + foreach $item (split /;/, $myconfig{acs}) { + delete $button{$item}; + } + } + + print qq| + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<br> +<form method=post action=$form->{script}> +|; + + $form->hide_form(qw(callback type path login sessionid)); + + foreach $item (sort { $a->{order} <=> $b->{order} } %button) { + print $item->{code}; + } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + </form> + +</body> +</html> +|; + +} + + +sub partsgroup_header { + + $form->{action} =~ s/_.*//; + $form->{title} = $locale->text(ucfirst $form->{action} . " Group"); + +# $locale->text('Add Group') +# $locale->text('Edit Group') + + $form->{partsgroup} = $form->quote($form->{partsgroup}); + + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=id value=$form->{id}> +<input type=hidden name=type value=$form->{type}> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table width=100%> + <tr> + <th align=right>|.$locale->text('Group').qq|</th> + + <td><input name=partsgroup size=30 value="$form->{partsgroup}"></td> + </tr> + </table> + </td> + </tr> + <tr> + <td colspan=2><hr size=3 noshade></td> + </tr> +</table> +|; + +} + + +sub partsgroup_footer { + + $form->hide_form(qw(callback path login sessionid)); + + if ($myconfig{acs} !~ /Goods \& Services--Add Group/) { + print qq| +<input type=submit class=submit name=action value="|.$locale->text('Save').qq|"> +|; + + if ($form->{id} && $form->{orphaned}) { + print qq| +<input type=submit class=submit name=action value="|.$locale->text('Delete').qq|">|; + } + } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| +</form> + +</body> +</html> +|; + +} + + +sub pricegroup_report { + + $form->{pricegroup} = $form->unescape($form->{pricegroup}); + PE->pricegroups(\%myconfig, \%$form); + + $href = "$form->{script}?action=pricegroup_report&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&status=$form->{status}"; + + $form->sort_order(); + + $callback = "$form->{script}?action=pricegroup_report&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&status=$form->{status}"; + + if ($form->{status} eq 'all') { + $option = $locale->text('All'); + } + if ($form->{status} eq 'orphaned') { + $option .= $locale->text('Orphaned'); + } + if ($form->{pricegroup}) { + $callback .= "&pricegroup=$form->{pricegroup}"; + $option .= "\n<br>".$locale->text('Pricegroup')." : $form->{pricegroup}"; + } + + + @column_index = $form->sort_columns(qw(pricegroup)); + + $column_header{pricegroup} = qq|<th><a class=listheading href=$href&sort=pricegroup width=90%>|.$locale->text('Pricegroup').qq|</th>|; + + $form->{title} = $locale->text('Pricegroups'); + + $form->header; + + print qq| +<body> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td>$option</td> + </tr> + <tr> + <td> + <table width=100%> + <tr class=listheading> +|; + + for (@column_index) { print "$column_header{$_}\n" } + + print qq| + </tr> +|; + + # escape callback + $form->{callback} = $callback; + + # escape callback for href + $callback = $form->escape($callback); + + foreach $ref (@{ $form->{item_list} }) { + + $i++; $i %= 2; + + print qq| + <tr valign=top class=listrow$i> +|; + + $column_data{pricegroup} = qq|<td><a href=$form->{script}?action=edit&type=$form->{type}&status=$form->{status}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ref->{pricegroup}</td>|; + for (@column_index) { print "$column_data{$_}\n" } + + print " + </tr> +"; + } + + $i = 1; + if ($myconfig{acs} !~ /Goods \& Services--Goods \& Services/) { + $button{'Goods & Services--Add Pricegroup'}{code} = qq|<input class=submit type=submit name=action value="|.$locale->text('Add Pricegroup').qq|"> |; + $button{'Goods & Services--Add Pricegroup'}{order} = $i++; + + foreach $item (split /;/, $myconfig{acs}) { + delete $button{$item}; + } + } + + print qq| + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<br> +<form method=post action=$form->{script}> +|; + + $form->hide_form(qw(callback type path login sessionid)); + + foreach $item (sort { $a->{order} <=> $b->{order} } %button) { + print $item->{code}; + } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + </form> + +</body> +</html> +|; + +} + + +sub pricegroup_header { + + $form->{title} = $locale->text(ucfirst $form->{action} ." Pricegroup"); + +# $locale->text('Add Pricegroup') +# $locale->text('Edit Pricegroup') + + $form->{pricegroup} = $form->quote($form->{pricegroup}); + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=id value=$form->{id}> +<input type=hidden name=type value=$form->{type}> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table width=100%> + <tr> + <th align=right>|.$locale->text('Pricegroup').qq|</th> + + <td><input name=pricegroup size=30 value="$form->{pricegroup}"></td> + </tr> + </table> + </td> + </tr> + <tr> + <td colspan=2><hr size=3 noshade></td> + </tr> +</table> +|; + +} + + +sub pricegroup_footer { + + $form->hide_form(qw(callback path login sessionid)); + + if ($myconfig{acs} !~ /Goods \& Services--Add Pricegroup/) { + print qq| +<input type=submit class=submit name=action value="|.$locale->text('Save').qq|"> +|; + + if ($form->{id} && $form->{orphaned}) { + print qq| +<input type=submit class=submit name=action value="|.$locale->text('Delete').qq|">|; + } + } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| +</form> + +</body> +</html> +|; + +} + + +sub translation { + + if ($form->{translation} eq 'description') { + $form->{title} = $locale->text('Description Translations'); + $sort = qq|<input type=hidden name=sort value=partnumber>|; + $form->{number} = "partnumber"; + $number = qq| + <tr> + <th align=right nowrap>|.$locale->text('Number').qq|</th> + <td><input name=partnumber size=20></td> + </tr> +|; + } + + if ($form->{translation} eq 'partsgroup') { + $form->{title} = $locale->text('Group Translations'); + $sort = qq|<input type=hidden name=sort value=partsgroup>|; + } + + if ($form->{translation} eq 'project') { + $form->{title} = $locale->text('Project Description Translations'); + $form->{number} = "projectnumber"; + $sort = qq|<input type=hidden name=sort value=projectnumber>|; + $number = qq| + <tr> + <th align=right nowrap>|.$locale->text('Project Number').qq|</th> + <td><input name=projectnumber size=20></td> + </tr> +|; + } + + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> +|; + + $form->hide_form(qw(translation title number)); + + print qq| + +<table width="100%"> + <tr><th class=listtop>$form->{title}</th></tr> + <tr height="5"></tr> + <tr valign=top> + <td> + <table> + $number + <tr> + <th align=right nowrap>|.$locale->text('Description').qq|</th> + <td colspan=3><input name=description size=40></td> + </tr> + </table> + </td> + </tr> + <tr><td><hr size=3 noshade></td></tr> +</table> + +<input type=hidden name=nextsub value=list_translations> +$sort +|; + + $form->hide_form(qw(path login sessionid)); + + print qq| + +<br> +<input class=submit type=submit name=action value="|.$locale->text('Continue').qq|"> +</form> + +</body> +</html> +|; + +} + + +sub list_translations { + + $title = $form->escape($form->{title},1); + + $callback = "$form->{script}?action=list_translations&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&translation=$form->{translation}&number=$form->{number}&title=$title"; + + if ($form->{"$form->{number}"}) { + $callback .= qq|&$form->{number}=$form->{"$form->{number}"}|; + $option .= $locale->text('Number').qq| : $form->{"$form->{number}"}<br>|; + } + if ($form->{description}) { + $callback .= "&description=$form->{description}"; + $description = $form->{description}; + $description =~ s/\r?\n/<br>/g; + $option .= $locale->text('Description').qq| : $form->{description}<br>|; + } + + if ($form->{translation} eq 'partsgroup') { + @column_index = qw(description language translation); + $form->{sort} = ""; + } else { + @column_index = $form->sort_columns("$form->{number}", "description", "language", "translation"); + } + + &{ "PE::$form->{translation}_translations" }("", \%myconfig, \%$form); + + $callback .= "&direction=$form->{direction}&oldsort=$form->{oldsort}"; + + $href = $callback; + + $form->sort_order(); + + $callback =~ s/(direction=).*\&{1}/$1$form->{direction}\&/; + + $column_header{"$form->{number}"} = qq|<th nowrap><a class=listheading href=$href&sort=$form->{number}>|.$locale->text('Number').qq|</a></th>|; + $column_header{description} = qq|<th nowrap width=40%><a class=listheading href=$href&sort=description>|.$locale->text('Description').qq|</a></th>|; + $column_header{language} = qq|<th nowrap class=listheading>|.$locale->text('Language').qq|</a></th>|; + $column_header{translation} = qq|<th nowrap width=40% class=listheading>|.$locale->text('Translation').qq|</a></th>|; + + $form->header; + + print qq| +<body> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + + <tr><td>$option</td></tr> + + <tr> + <td> + <table width=100%> + <tr class=listheading> +|; + + for (@column_index) { print "\n$column_header{$_}" } + + print qq| + </tr> + |; + + + # add order to callback + $form->{callback} = $callback .= "&sort=$form->{sort}"; + + # escape callback for href + $callback = $form->escape($callback); + + if (@{ $form->{translations} }) { + $sameitem = $form->{translations}->[0]->{$form->{sort}}; + } + + foreach $ref (@{ $form->{translations} }) { + + $ref->{description} =~ s/\r?\n/<br>/g; + + for (@column_index) { $column_data{$_} = "<td>$ref->{$_} </td>" } + + $column_data{description} = "<td><a href=$form->{script}?action=edit_translation&translation=$form->{translation}&number=$form->{number}&id=$ref->{id}&path=$form->{path}&login=$form->{login}&sessionid=$form->{sessionid}&callback=$callback>$ref->{description} </a></td>"; + + $i++; $i %= 2; + print "<tr class=listrow$i>"; + + for (@column_index) { print "\n$column_data{$_}" } + + print qq| + </tr> +|; + + } + + print qq| + </table> + </td> + </tr> + <tr><td><hr size=3 noshade></td></tr> +</table> + +|; + + print qq| + +<br> + +<form method=post action=$form->{script}> + +<input name=callback type=hidden value="$form->{callback}"> +|; + + $form->hide_form(qw(path login sessionid)); + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + </form> + +</body> +</html> +|; + +} + + +sub edit_translation { + + &{ "PE::$form->{translation}_translations" }("", \%myconfig, \%$form); + + $form->error($locale->text('Languages not defined!')) unless @{ $form->{all_language} }; + + $form->{selectlanguage} = qq|<option>\n|; + for (@{ $form->{all_language} }) { $form->{selectlanguage} .= qq|<option value="$_->{code}">$_->{description}\n| } + + $form->{"$form->{number}"} = $form->{translations}->[0]->{"$form->{number}"}; + $form->{description} = $form->{translations}->[0]->{description}; + $form->{description} =~ s/\r?\n/<br>/g; + + shift @{ $form->{translations} }; + + $i = 1; + foreach $row (@{ $form->{translations} }) { + $form->{"language_code_$i"} = $row->{code}; + $form->{"translation_$i"} = $row->{translation}; + $i++; + } + $form->{translation_rows} = $i - 1; + + $form->{title} = $locale->text('Edit Description Translations'); + + &translation_header; + &translation_footer; + +} + + +sub translation_header { + + $form->{translation_rows}++; + + $form->{selectlanguage} = $form->unescape($form->{selectlanguage}); + for $i (1 .. $form->{translation_rows}) { + $form->{"selectlanguage_$i"} = $form->{selectlanguage}; + if ($form->{"language_code_$i"}) { + $form->{"selectlanguage_$i"} =~ s/(<option value="\Q$form->{"language_code_$i"}\E")/$1 selected/; + } + } + + $form->{selectlanguage} = $form->escape($form->{selectlanguage},1); + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<input type=hidden name=$form->{number} value="|.$form->quote($form->{"$form->{number}"}).qq|"> +<input type=hidden name=description value="|.$form->quote($form->{description}).qq|"> +|; + + $form->hide_form(qw(id trans_id selectlanguage translation_rows number translation title)); + + print qq| + +<table width="100%"> + <tr><th class=listtop>$form->{title}</th></tr> + <tr height="5"></tr> + <tr valign=top> + <td> + <table width=100%> + <tr> + <td align=left>$form->{"$form->{number}"}</th> + <td align=left>$form->{description}</th> + </tr> + <tr> + <tr> + <th class=listheading>|.$locale->text('Language').qq|</th> + <th class=listheading>|.$locale->text('Translation').qq|</th> + </tr> +|; + + for $i (1 .. $form->{translation_rows}) { + + if (($rows = $form->numtextrows($form->{"translation_$i"}, 40)) > 1) { + $translation = qq|<textarea name="translation_$i" rows=$rows cols=40 wrap=soft>$form->{"translation_$i"}</textarea>|; + } else { + $translation = qq|<input name="translation_$i" size=40 value="$form->{"translation_$i"}">|; + } + + print qq| + <tr valign=top> + <td><select name="language_code_$i">$form->{"selectlanguage_$i"}</select></td> + <td>$translation</td> + </tr> +|; + } + + print qq| + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> +|; + +} + + +sub translation_footer { + + $form->hide_form(qw(path login sessionid callback)); + + %button = ('Update' => { ndx => 1, key => 'U', value => $locale->text('Update') }, + 'Save' => { ndx => 3, key => 'S', value => $locale->text('Save') }, + 'Delete' => { ndx => 16, key => 'D', value => $locale->text('Delete') }, + ); + + if (! $form->{trans_id}) { + delete $button{'Delete'}; + } + + for (sort { $button{$a}->{ndx} <=> $button{$b}->{ndx} } keys %button) { $form->print_button(\%button, $_) } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + + </form> + +</body> +</html> +|; + +} + + +sub update { + + if ($form->{translation}) { + @flds = qw(language translation); + $count = 0; + @a = (); + for $i (1 .. $form->{translation_rows}) { + if ($form->{"language_code_$i"} ne "") { + push @a, {}; + $j = $#a; + + for (@flds) { $a[$j]->{$_} = $form->{"${_}_$i"} } + $count++; + } + } + $form->redo_rows(\@flds, \@a, $count, $form->{translation_rows}); + $form->{translation_rows} = $count; + + &translation_header; + &translation_footer; + + exit; + + } + + if ($form->{type} =~ /(job|project)/) { + +# $locale->text('Customer not on file!') +# $locale->text('Vendor not on file!') + + for (qw(production listprice sellprice weight)) { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) } + + $form->{projectnumber} = $form->update_defaults(\%myconfig, "projectnumber") unless $form->{projectnumber}; + + if ($form->{"select$form->{vc}"}) { + if ($form->{startdate} ne $form->{oldstartdate} || $form->{enddate} ne $form->{oldenddate}) { + + PE->get_customer(\%myconfig, \%$form); + + if (@{ $form->{"all_$form->{vc}"} }) { + $form->{"select$form->{vc}"} = qq|<option>\n|; + for (@{ $form->{"all_$form->{vc}"} }) { $form->{"select$form->{vc}"} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n| } + } + } + + $form->{"old$form->{vc}"} = $form->{"$form->{vc}"}; + ($null, $form->{"$form->{vc}_id"}) = split /--/, $form->{"$form->{vc}"}; + + } else { + + if ($form->{"old$form->{vc}"} ne qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|) { + + if (($rv = $form->get_name(\%myconfig, $form->{vc}, $form->{startdate})) > 1) { + &select_name; + exit; + } + + if ($rv == 1) { + $form->{"$form->{vc}_id"} = $form->{name_list}[0]->{id}; + $form->{"$form->{vc}"} = $form->{name_list}[0]->{name}; + $form->{"old$form->{vc}"} = qq|$form->{"$form->{vc}"}--$form->{"$form->{vc}_id"}|; + } else { + $msg = ucfirst $form->{vc} ." not on file!"; + $form->error($locale->text($msg)); + } + } + } + } + + &display_form; + +} + + +sub select_name { + + $label = ucfirst $form->{vc}; + + @column_index = qw(ndx name address); + $column_data{ndx} = qq|<th> </th>|; + $column_data{name} = qq|<th class=listheading>|.$locale->text($label).qq|</th>|; + $column_data{address} = qq|<th class=listheading colspan=5>|.$locale->text('Address').qq|</th>|; + + $form->header; + $title = $locale->text('Select from one of the names below'); + print qq| +<body> + +<form method=post action=$form->{script}> + +<table width=100%> + <tr> + <th class=listtop>$title</th> + </tr> + <tr space=5></tr> + <tr> + <td> + <table width=100%> + <tr class=listheading>|; + + for (@column_index) { print "\n$column_data{$_}" } + + print qq| + </tr> +|; + + @column_index = qw(ndx name address city state zipcode country); + + my $i = 0; + foreach $ref (@{ $form->{name_list} }) { + $checked = ($i++) ? "" : "checked"; + + $ref->{name} = $form->quote($ref->{name}); + + $column_data{ndx} = qq|<td><input name=ndx class=radio type=radio value=$i $checked></td>|; + $column_data{name} = qq|<td><input name="new_name_$i" type=hidden value="$ref->{name}">$ref->{name}</td>|; + $column_data{address} = qq|<td>$ref->{address1} $ref->{address2}</td>|; + for (qw(city state zipcode country)) { $column_data{$_} = qq|<td>$ref->{$_} </td>| } + + $j++; $j %= 2; + print qq| + <tr class=listrow$j>|; + + for (@column_index) { print "\n$column_data{$_}" } + + print qq| + </tr> + +<input name="new_id_$i" type=hidden value=$ref->{id}> + +|; + + } + + print qq| + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<input name=lastndx type=hidden value=$i> + +|; + + # delete variables + for (qw(action nextsub name_list)) { delete $form->{$_} } + + $form->hide_form; + + print qq| +<input type=hidden name=nextsub value=name_selected> +<br> +<input class=submit type=submit name=action value="|.$locale->text('Continue').qq|"> +</form> + +</body> +</html> +|; + +} + + +sub name_selected { + + # replace the variable with the one checked + + # index for new item + $i = $form->{ndx}; + + $form->{$form->{vc}} = $form->{"new_name_$i"}; + $form->{"$form->{vc}_id"} = $form->{"new_id_$i"}; + $form->{"old$form->{vc}"} = qq|$form->{$form->{vc}}--$form->{"$form->{vc}_id"}|; + + # delete all the new_ variables + for $i (1 .. $form->{lastndx}) { + for (qw(id name)) { delete $form->{"new_${_}_$i"} } + } + + for (qw(ndx lastndx nextsub)) { delete $form->{$_} } + + &display_form; + +} + + +sub display_form { + + &{ "$form->{type}_header" }; + &{ "$form->{type}_footer" }; + +} + +sub continue { &{ $form->{nextsub} } }; + +sub add_group { &add } +sub add_project { &add } +sub add_job { &add } +sub add_pricegroup { &add } + + + +sub project_sales_order { + + PE->project_sales_order(\%myconfig, \%$form); + + if (@{ $form->{all_years} }) { + $form->{selectaccountingyear} = "<option>\n"; + for (@{ $form->{all_years} }) { $form->{selectaccountingyear} .= qq|<option>$_\n| } + + $form->{selectaccountingmonth} = "<option>\n"; + for (sort keys %{ $form->{all_month} }) { $form->{selectaccountingmonth} .= qq|<option value=$_>|.$locale->text($form->{all_month}{$_}).qq|\n| } + + $selectfrom = qq| + <tr> + <th align=right>|.$locale->text('Period').qq|</th> + <td colspan=3> + <select name=month>$form->{selectaccountingmonth}</select> + <select name=year>$form->{selectaccountingyear}</select> + <input name=interval class=radio type=radio value=0 checked> |.$locale->text('Current').qq| + <input name=interval class=radio type=radio value=1> |.$locale->text('Month').qq| + <input name=interval class=radio type=radio value=3> |.$locale->text('Quarter').qq| + <input name=interval class=radio type=radio value=12> |.$locale->text('Year').qq| + </td> + </tr> +|; + } + + $fromto = qq| + <tr> + <th align=right nowrap>|.$locale->text('Transaction Dates').qq|</th> + <td>|.$locale->text('From').qq| <input name=transdatefrom size=11 title="$myconfig{dateformat}"> + |.$locale->text('To').qq| <input name=transdateto size=11 title="$myconfig{dateformat}"></td> + </tr> + $selectfrom +|; + + if (@{ $form->{all_project} }) { + $form->{selectprojectnumber} = "<option>\n"; + for (@{ $form->{all_project} }) { $form->{selectprojectnumber} .= qq|<option value="$_->{projectnumber}--$_->{id}">$_->{projectnumber}\n| } + } else { + $form->error($locale->text('No open Projects!')); + } + + if (@{ $form->{all_employee} }) { + $form->{selectemployee} = "<option>\n"; + for (@{ $form->{all_employee} }) { $form->{selectemployee} .= qq|<option value="$_->{name}--$_->{id}">$_->{name}\n| } + + $employee = qq| + <tr> + <th align=right nowrap>|.$locale->text('Employee').qq|</th> + <td><select name=employee>$form->{selectemployee}</select></td> + </tr> +|; + } + + $form->{title} = $locale->text('Generate Sales Orders'); + $form->{vc} = "customer"; + $form->{type} = "sales_order"; + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr valign=top> + <td> + <table> + <tr> + <th align=right>|.$locale->text('Project').qq|</th> + <td colspan=3><select name=projectnumber>$form->{selectprojectnumber}</select></td> + </tr> + $employee + $fromto + <tr> + <th></th> + <td><input name=summary type=radio class=radio value=1 checked> |.$locale->text('Summary').qq| + <input name=summary type=radio class=radio value=0> |.$locale->text('Detail').qq| + </td> + </tr> + </table> + </td> + </tr> + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +|; + + $form->{nextsub} = "project_jcitems_list"; + $form->hide_form(qw(path login sessionid nextsub type vc)); + + print qq| +<input type=submit class=submit name=action value="|.$locale->text('Continue').qq|"> + +</form> +|; + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| + +</body> +</html> +|; + +} + + +sub project_jcitems_list { + + $form->{projectnumber} = $form->unescape($form->{projectnumber}); + $form->{employee} = $form->unescape($form->{employee}); + $form->{callback} = "$form->{script}?action=project_jcitems_list"; + for (qw(month year interval summary transdatefrom transdateto login path sessionid nextsub type vc)) { $form->{callback} .= "&$_=$form->{$_}" } + for (qw(employe projectnumber)) { $form->{callback} .= "&$_=".$form->escape($form->{$_},1) } + + PE->get_jcitems(\%myconfig, \%$form); + + # flatten array + $i = 1; + foreach $ref (@{ $form->{jcitems} }) { + + if ($form->{summary}) { + + $thisitem = qq|$ref->{project_id}:$ref->{"$form->{vc}_id"}:$ref->{parts_id}|; + + if ($thisitem eq $sameitem) { + + $i--; + for (qw(qty amount)) { $form->{"${_}_$i"} += $ref->{$_} } + $form->{"id_$i"} .= " $ref->{id}:$ref->{qty}"; + if ($form->{"notes_$i"}) { + $form->{"notes_$i"} .= qq|\n\n$ref->{notes}|; + } else { + $form->{"notes_$i"} = $ref->{notes}; + } + + } else { + + for (keys %$ref) { $form->{"${_}_$i"} = $ref->{$_} } + + $form->{"checked_$i"} = 1; + $form->{"$form->{vc}_$i"} = $ref->{$form->{vc}}; + $form->{"id_$i"} = "$ref->{id}:$ref->{qty}"; + + } + + $sameitem = qq|$ref->{project_id}:$ref->{"$form->{vc}_id"}:$ref->{parts_id}|; + } else { + + for (keys %$ref) { $form->{"${_}_$i"} = $ref->{$_} } + $form->{"checked_$i"} = 1; + $form->{"id_$i"} = "$ref->{id}:$ref->{qty}"; + + } + + $i++; + + } + + $form->{rowcount} = $i - 1; + + for $i (1 .. $form->{rowcount}) { + for (qw(qty allocated)) { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}) } + for (qw(amount sellprice)) { $form->{"${_}_$i"} = $form->format_amount(\%myconfig, $form->{"${_}_$i"}, 2) } + } + + &jcitems; + +} + + +sub jcitems { + +# $locale->text('Customer') +# $locale->text('Vendor') + + $vc = ucfirst $form->{vc}; + + @column_index = qw(id projectnumber name); + if (!$form->{summary}) { + push @column_index, qw(transdate); + } + push @column_index, qw(partnumber description qty amount); + + $column_header{id} = qq|<th> </th>|; + $column_header{transdate} = qq|<th class=listheading>|.$locale->text('Date').qq|</th>|; + $column_header{partnumber} = qq|<th class=listheading>|.$locale->text('Service Code').qq|<br>|.$locale->text('Part Number').qq|</th>|; + $column_header{projectnumber} = qq|<th class=listheading>|.$locale->text('Project Number').qq|</th>|; + $column_header{description} = qq|<th class=listheading>|.$locale->text('Description').qq|</th>|; + $column_header{name} = qq|<th class=listheading>$vc</th>|; + $column_header{qty} = qq|<th class=listheading>|.$locale->text('Qty').qq|</th>|; + $column_header{amount} = qq|<th class=listheading>|.$locale->text('Amount').qq|</th>|; + + if ($form->{type} eq 'sales_order') { + $form->{title} = $locale->text('Generate Sales Orders'); + } + + $form->header; + + print qq| +<body> + +<form method=post action=$form->{script}> + +<table width=100%> + <tr> + <th class=listtop>$form->{title}</th> + </tr> + <tr height="5"></tr> + <tr> + <td> + <table width=100%> + <tr class=listheading>|; + + for (@column_index) { print "\n$column_header{$_}" } + + print qq| + </tr> +|; + + for $i (1 .. $form->{rowcount}) { + + for (@column_index) { $column_data{$_} = qq|<td>$form->{"${_}_$i"}</td>| } + for (qw(qty amount)) { $column_data{$_} = qq|<td align=right>$form->{"${_}_$i"}</td>| } + + $checked = ($form->{"checked_$i"}) ? "checked" : ""; + $column_data{id} = qq|<td><input name="checked_$i" class=checkbox type=checkbox value="1" $checked></td>|; + + if ($form->{"$form->{vc}_id_$i"}) { + $column_data{name} = qq|<td>$form->{"$form->{vc}_$i"}</td>|; + $form->hide_form("$form->{vc}_id_$i", "$form->{vc}_$i"); + } else { + $column_data{name} = qq|<td><input name="ndx_$i" class=checkbox type=checkbox value="1"></td>|; + } + + for (qw(projectnumber partnumber description notes)) { $form->{"${_}_$i"} = $form->quote($form->{"${_}_$i"}) } + $form->hide_form(map {"${_}_$i"} qw(id project_id parts_id projectnumber transdate partnumber description notes qty amount taxaccounts sellprice)); + + $j++; $j %= 2; + print " + <tr class=listrow$j>"; + + for (@column_index) { print "\n$column_data{$_}" } + + print qq| + </tr> +|; + + } + + print qq| + </table> + </td> + </tr> + + <tr> + <td><hr size=3 noshade></td> + </tr> +</table> + +<br> +|; + + $form->hide_form(qw(path login sessionid vc nextsub rowcount type currency defaultcurrency taxaccounts summary callback)); + + for (split / /, $form->{taxaccounts}) { $form->hide_form("${_}_rate") } + + if ($form->{rowcount}) { + print qq| +<input class=submit type=submit name=action value="|.$locale->text('Generate Sales Orders').qq|">|; + + print qq| +<input class=submit type=submit name=action value="|.$locale->text('Select Customer').qq|">|; + + } + + if ($form->{menubar}) { + require "bin/menu.pl"; + &menubar; + } + + print qq| +</form> + +</body> +</html> +|; + +} + + +sub select_customer { + + for (1 .. $form->{rowcount}) { + last if ($ok = $form->{"ndx_$_"}); + } + + $form->error($locale->text('Nothing selected!')) unless $ok; + + $label = ($form->{vc} eq 'customer') ? $locale->text('Customer') : $locale->text('Vendor'); + + $form->header; + + print qq| +<body onLoad="document.forms[0].$form->{vc}.focus()" /> + +<form method=post action=$form->{script}> + +<b>$label</b> <input name=$form->{vc} size=40> + +|; + + $form->{nextsub} = "$form->{vc}_selected"; + $form->{action} = "$form->{vc}_selected"; + + $form->hide_form; + + print qq| +<input class=submit type=submit name=action value="|.$locale->text('Continue').qq|"> + +</form> +|; + + print qq| + +</body> +</html> +|; + +} + + +sub customer_selected { + + if (($rv = $form->get_name(\%myconfig, $form->{vc}, $form->{startdate})) > 1) { + &select_name($form->{vc}); + exit; + } + + if ($rv == 1) { + $form->{"$form->{vc}"} = $form->{name_list}[0]->{name}; + $form->{"$form->{vc}_id"} = $form->{name_list}[0]->{id}; + } else { + $msg = ($form->{vc} eq 'customer') ? $locale->text('Customer not on file!') : $locale->text('Vendor not on file!'); + $form->error($locale->text($msg)); + } + + &display_form; + +} + + +sub sales_order_header { + + for (1 .. $form->{rowcount}) { + if ($form->{"ndx_$_"}) { + $form->{"$form->{vc}_id_$_"} = $form->{"$form->{vc}_id"}; + $form->{"$form->{vc}_$_"} = $form->{"$form->{vc}"}; + } + } + +} + +sub sales_order_footer { &jcitems } + + +sub generate_sales_orders { + + for $i (1 .. $form->{rowcount}) { + $form->error($locale->text('Customer missing!')) if ($form->{"checked_$i"} && !$form->{"customer_$i"}); + } + + for $i (1 .. $form->{rowcount}) { + if ($form->{"checked_$i"}) { + push @{ $form->{order}{qq|$form->{"customer_id_$i"}|} }, { + partnumber => $form->{"partnumber_$i"}, + id => $form->{"parts_id_$i"}, + description => $form->{"description_$i"}, + qty => $form->{"qty_$i"}, + sellprice => $form->{"sellprice_$i"}, + projectnumber => qq|--$form->{"project_id_$i"}|, + reqdate => $form->{"transdate_$i"}, + taxaccounts => $form->{"taxaccounts_$i"}, + jcitems => $form->{"id_$i"}, + notes => $form->{"notes_$i"}, + } + } + } + + $order = new Form; + for (keys %{ $form->{order} }) { + + for (qw(type vc defaultcurrency login)) { $order->{$_} = $form->{$_} } + for (split / /, $form->{taxaccounts}) { $order->{"${_}_rate"} = $form->{"${_}_rate"} } + + $i = 0; + $order->{"$order->{vc}_id"} = $_; + + AA->get_name(\%myconfig, \%$order); + + foreach $ref (@ {$form->{order}{$_} }) { + $i++; + + for (keys %$ref) { $order->{"${_}_$i"} = $ref->{$_} } + + $taxaccounts = ""; + for (split / /, $order->{taxaccounts}) { $taxaccounts .= qq|$_ | if ($_ =~ /$order->{"taxaccounts_$i"}/) } + $order->{"taxaccounts_$i"} = $taxaccounts; + + } + $order->{rowcount} = $i; + + for (qw(currency)) { $order->{$_} = $form->{$_} } + + $order->{ordnumber} = $order->update_defaults(\%myconfig, 'sonumber'); + $order->{transdate} = $order->current_date(\%myconfig); + $order->{reqdate} = $order->{transdate}; + + for (qw(intnotes employee employee_id)) { delete $order->{$_} } + + if (OE->save(\%myconfig, \%$order)) { + if (! PE->allocate_projectitems(\%myconfig, \%$order)) { + OE->delete(\%myconfig, \%$order, $spool); + } + } else { + $order->error($locale->text('Failed to save order!')); + } + + for (keys %$order) { delete $order->{$_} } + + } + + $form->redirect($locale->text('Orders generated!')); + +} + + |