#=====================================================================
# SQL-Ledger
# Copyright (c) DWS Systems Inc.
#
#  Author: DWS Systems Inc.
#     Web: http://www.sql-ledger.com
#
#======================================================================
#
# project/job administration
# partsgroup administration
# translation maintainance
#
#======================================================================


use SL::PE;
use SL::AA;
use SL::OE;

require "$form->{path}/cm.pl";
require "$form->{path}/sr.pl";
require "$form->{path}/js.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 add {
  
  # construct callback
  $form->{callback} = "$form->{script}?action=add&type=$form->{type}&path=$form->{path}&login=$form->{login}" 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->helpref("jobs", $myconfig{countrycode});
  
  $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$_"} .= "$ref->{accno}--$ref->{description}\n";
      }
    }
    $form->{"select$_"} = $form->escape($form->{"select$_"}, 1);
  }
  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|\n|;
    for (@{ $form->{"all_$form->{vc}"} }) { $form->{"select$form->{vc}"} .= qq|$_->{name}--$_->{id}\n| }
  }

  $form->get_partsgroup(\%myconfig, {all => 1});
  $form->{partsgroup} = $form->quote($form->{partsgroup})."--$form->{partsgroup_id}";
  if (@{ $form->{all_partsgroup} }) {
    $form->{selectpartsgroup} = qq|\n|;
    for (@{ $form->{all_partsgroup} }) { $form->{selectpartsgroup} .= qq|$_->{partsgroup}--$_->{id}\n| }
  }
  
  $form->{"select$form->{vc}"} = $form->escape($form->{"select$form->{vc}"},1);
  for (qw(partsgroup)) { $form->{"select$_"} = $form->escape($form->{"select$_"},1) }
  
  $form->{locked} = ($form->{revtrans}) ? '1' : ($form->datetonum(\%myconfig, $form->{transdate}) <= $form->{closedto});

  $form->{readonly} = 1 if $myconfig{acs} =~ /Job Costing--Add Job/;

  &all_references;

}


sub job_header {

  for (qw(partnumber partdescription description notes unit)) { $form->{$_} = $form->quote($form->{$_}) }

  for (qw(production completed weight)) { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}) }
  for (qw(listprice sellprice)) { $form->{$_} = $form->format_amount(\%myconfig, $form->{$_}, $form->{precision}) }
  
  $reference_documents = &references;
 
  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->quote($form->{partdescription}).qq|">|;
  }
  
  if (($rows = $form->numtextrows($form->{description}, 60)) < 2) {
    $rows = 1;
  }

  $description = qq|<textarea name="description" rows=$rows cols=60 style="width: 100%" wrap=soft>$form->{description}</textarea>|;
  
  if (($rows = $form->numtextrows($form->{notes}, 40)) < 2) {
    $rows = 2;
  }

  $notes = qq|<textarea name=notes rows=$rows cols=40 wrap=soft>$form->{notes}</textarea>|;

  $label = ucfirst $form->{vc};
  $vcref = qq|<a href=ct.pl?action=edit&db=$form->{vc}&id=$form->{"$form->{vc}_id"}&login=$form->{login}&path=$form->{path} target=_blank>?</a>|;

  if ($form->{"select$form->{vc}"}) {
    $name = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text($label).qq|</th>
	  <td colspan=3><select name="$form->{vc}"
          onChange="javascript:document.main.submit()">|
          .$form->select_option($form->{"select$form->{vc}"}, $form->{$form->{vc}}, 1).qq|</select>
          $vcref
	  </td>
          <input name=action type=hidden value=update>
	</tr>
|;
  } else {
    $name = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text($label).qq|</th>
	  <td colspan=3><input name="$form->{vc}" value="|.$form->quote($form->{"$form->{vc}"}).qq|" size=35> $vcref</td>
	</tr>
|;
  }
  
  if ($form->{orphaned}) {
    
    $production = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text('Production').qq|</th>
	  <td><input name=production class="inputright" size=11 value="$form->{production}"></td>
	  <th align=right nowrap>|.$locale->text('Completed').qq|</th>
	  <td>$form->{completed}</td>
	</tr>
|;
    $production .= $form->hide_form(completed);

  } else {
    
    $form->{selectIC_income} = $form->{IC_income};

    $production = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text('Production').qq|</th>
	  <td>$form->{production}</td>
	  <th align=right nowrap>|.$locale->text('Completed').qq|</th>
	  <td>$form->{completed}</td>
	</tr>
|;
    $production .= $form->hide_form(qw(production completed));

  }
  
    for (split / /, $form->{taxaccounts}) { $form->{"IC_tax_$_"} = ($form->{"IC_tax_$_"}) ? "checked" : "" }
    
    if ($form->{selectpartsgroup}) {
      $partsgroup = qq|\n<select name=partsgroup>|
      .$form->select_option($form->{selectpartsgroup}, $form->{partsgroup}, 1)
      .qq|</select>|;
      $group = $locale->text('Group');
    }

    $linkaccounts = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text('Income').qq|</th>
	  <td><select name=IC_income>|
	  .$form->select_option($form->{selectIC_income}, $form->{IC_income})
	  .qq|</select>
	  </td>
	</tr>
|;

    for (split / /, $form->{taxaccounts}) {
      $tax .= qq|
        <input class=checkbox type=checkbox name="IC_tax_$_" value=1 $form->{"IC_tax_$_"}>&nbsp;<b>$form->{"IC_tax_${_}_description"}</b>
	<br><input type=hidden name=IC_tax_${_}_description value="|.$form->quote($form->{"IC_tax_${_}_description"}).qq|">
|;
    }

    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 valign=top>
	        <td><input name=partnumber value="|.$form->quote($form->{partnumber}).qq|" 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;

  &calendar;
  
  print qq|
<body>

<form method="post" name="main" action="$form->{script}" />
|;

  for (qw(partnumber startdate enddate)) { $form->{"old$_"} = $form->{$_} }
  
  $form->hide_form(map { "select$_" } ("IC_income", "$form->{vc}", "partsgroup"));
  $form->hide_form("old$form->{vc}", "$form->{vc}_id");
  $form->hide_form(qw(id type orphaned taxaccounts vc project precision));
  
  print qq|
  
<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table>
        <tr valign=top>
          <th align=right>|.$locale->text('Number').qq|</th>
          <td><input name=projectnumber size=20 value="|.$form->quote($form->{projectnumber}).qq|"></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 class=date title="$myconfig{dateformat}" value=$form->{startdate}>|.&js_calendar("main", "startdate").qq|</td>
          <th align=right>|.$locale->text('Enddate').qq|</th>
          <td><input name=enddate size=11 class=date title="$myconfig{dateformat}" value=$form->{enddate}>|.&js_calendar("main", "enddate").qq|</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 class=date title="$myconfig{dateformat}" value=$form->{priceupdate}>|.&js_calendar("main", "priceupdate").qq|</td>
                    </tr>
                    <tr>
                      <th align="right" nowrap="true">|.$locale->text('Lot').qq|</th>
                      <td><input name=lot size=10 value="|.$form->quote($form->{lot}).qq|"></td>
                    </tr>
                    <tr>
                      <th align="right" nowrap="true">|.$locale->text('Expires').qq|</th>
                      <td><input name=expires size=11 class=date title="$myconfig{dateformat}" value=$form->{expires}>|.&js_calendar("main", "expires").qq|</td>
                    </tr>
                    <tr>
                      <th align="right" nowrap="true">|.$locale->text('List Price').qq|</th>
                      <td><input name=listprice class="inputright" size=11 value=$form->{listprice}></td>
                    </tr>
                    <tr>
                      <th align="right" nowrap="true">|.$locale->text('Sell Price').qq|</th>
                      <td><input name=sellprice class="inputright" 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 class="inputright" size=11 value=$form->{weight}>
                      </td>
                      <th>
                        &nbsp;
                        $form->{weightunit}|
                        .$form->hide_form(qw(weightunit))
                        .qq|
                      </th>
                    </tr>
                  </table>
                      </td>
                    <tr>
                      <th align="right" nowrap="true">|.$locale->text('Bin').qq|</th>
                      <td><input name=bin size=10 value="|.$form->quote($form->{bin}).qq|"></td>
                    </tr>
                    <tr>
                      <th align="right" nowrap="true">|.$locale->text('Unit').qq|</th>
                      <td><input name=unit size=5 value="|.$form->quote($form->{unit}).qq|"></td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td>
      $reference_documents
    </td>
  </tr>
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>
|;

}


sub job_footer {

  $form->hide_form(qw(reference_rows callback path login));
  
  %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') };
    }
  }

  $form->print_button(\%button);
  
  if ($form->{menubar}) {
    require "$form->{path}/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 status)) { $href .= "$_=$form->{$_}&" }

  $form->sort_order();
  
  $callback = "$form->{script}?";
  for (qw(action direction oldsort type path login 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->escape($form->{projectnumber},1);
    ($var) = split /--/, $form->{projectnumber};
    $option .= "\n<br>".$locale->text('Job Number')." : $var";
  }
  if ($form->{stockingdate}) {
    $href .= "&stockingdate=$form->{stockingdate}";
    $callback .= "&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') . "</th>";
  $column_header{completed} = "<th class=listheading>" . $locale->text('Completed') . "</th>";
  $column_header{stock} = "<th class=listheading>" . $locale->text('Add') . "</th>";
  $column_header{warehouse} = "<th class=listheading>" . $locale->text('Warehouse') . "</th>";


  $form->helpref("list_stock", $myconfig{countrycode});
  
  $form->header;
  
  if (@{ $form->{all_project} }) {
    $sameitem = $form->{all_project}->[0]->{$form->{sort}};
  }

  if (@{ $form->{all_warehouse} }) {
    push @column_index, "warehouse";
    $form->{selectwarehouse} = ($form->{forcewarehouse}) ? "" : "\n";
    for (@{ $form->{all_warehouse} }) { $form->{selectwarehouse} .= qq|$_->{description}--$_->{id}\n| }
  }

  print qq|
<body>

<form method=post action=$form->{script}>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></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);

  $i = 0;
  foreach $ref (@{ $form->{all_project} }) {

    $i++;
    
    for (qw(startdate enddate)) { $column_data{$_} = qq|<td nowrap>$ref->{$_}&nbsp;</td>| }
    for (qw(projectnumber description partnumber)) { $column_data{$_} = qq|<td>$ref->{$_}&nbsp;</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" class="inputright" size=6></td>|;
    $column_data{warehouse} = qq|<td><select name="warehouse_$i">|.$form->select_option($form->{selectwarehouse}, undef, 1).qq|</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 status stockingdate));

  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->helpref("projects", $myconfig{countrycode});
  
  $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|\n|;
    for (@{ $form->{"all_$form->{vc}"} }) { $form->{"select$form->{vc}"} .= qq|$_->{name}--$_->{id}\n| }
  }

  &all_references;

}


sub search {

  # accounting years
  $form->all_years(\%myconfig);

  if (@{ $form->{all_years} }) {
    $selectaccountingyear = "\n";
    for (@{ $form->{all_years} }) { $selectaccountingyear .= qq|$_\n| }
    $selectaccountingmonth = "\n";
    for (sort keys %{ $form->{all_month} }) { $selectaccountingmonth .= qq|$_--|.$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 class=date title="$myconfig{'dateformat'}">|.&js_calendar("main", "startdatefrom")
	  .$locale->text('To').qq| <input name=startdateto size=11 class=date title="$myconfig{'dateformat'}">|.&js_calendar("main", "startdateto").qq|</td>
	</tr>
|;

  $selectperiod = qq|
        <tr>
          <th align=right>|.$locale->text('Period').qq|</th>
          <td colspan=3>
          <select name=month>|.$form->select_option($selectaccountingmonth, $form->{month}, 1, 1).qq|</select>
          <select name=year>|.$form->select_option($selectaccountingyear, $form->{year}).qq|</select>
          <input name=interval class=radio type=radio value=0 checked>&nbsp;|.$locale->text('Current').qq|
          <input name=interval class=radio type=radio value=1>&nbsp;|.$locale->text('Month').qq|
          <input name=interval class=radio type=radio value=3>&nbsp;|.$locale->text('Quarter').qq|
          <input name=interval class=radio type=radio value=12>&nbsp;|.$locale->text('Year').qq|
          </td>
        </tr>
|;
  }


  $orphaned = qq|
	  <input name=status class=radio type=radio value=orphaned>&nbsp;|.$locale->text('Orphaned');
	  
  if ($form->{type} eq 'project') {
    $form->{nextsub} = "project_report";
    $form->{sort} = "projectnumber";
    $form->{title} = $locale->text('Projects');

    $number = qq|
	<tr>
	  <th align=right>|.$locale->text('Project 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>
|;
  }

  $form->{reportcode} = $form->{type};
  $form->reports(\%myconfig, undef, $form->{login});
  
  if ($form->{type} eq 'stock') {
    $form->{nextsub} = "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 class=date title="$myconfig{dateformat}" value=$form->{stockingdate}>|.&js_calendar("main", "stockingdate").qq|</td>
        </tr>
|;

    $number = qq|
        <tr>
          <th align=right>|.$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>
|;

    @input = qw(projectnumber description stockingdate sort direction reportlogin);

    %radio = ( status => { all => 0, active => 1, inactive => 2 }
	     );

  }
    
  if ($form->{type} eq 'job') {
    $form->{nextsub} = "job_report";
    $form->{sort} = "projectnumber";
    $form->{title} = $locale->text('Jobs');

    $number = qq|
        <tr>
          <th align=right>|.$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>
|;

    @input = qw(projectnumber description startdatefrom startdateto month year sort direction reportlogin);

    %radio = ( interval => { 0 => 0, 1 => 1, 3 => 2, 12 => 3 },
               status => { all => 0, active => 1, inactive => 2, orphaned => 3 }
	     );

  }

  if ($form->{type} eq 'partsgroup') {
    $form->{nextsub} = "partsgroup_report";
    $form->{sort} = 'partsgroup';
    $form->{title} = $locale->text('Groups');
    
    $fromto = "";
    $selectperiod = "";
    $number = qq|
        <tr>
          <th align=right>|.$locale->text('Group').qq|</th>
          <td><input name=partsgroup size=20></td>
        </tr>
        <tr>
          <th align=right>|.$locale->text('Code').qq|</th>
          <td><input name=partsgroupcode size=20></td>
        </tr>
|;
  }

  if ($form->{type} eq 'pricegroup') {
    $form->{nextsub} = "pricegroup_report";
    $form->{sort} = 'pricegroup';
    $form->{title} = $locale->text('Pricegroups');
    
    $fromto = "";
    $selectperiod = "";
    $number = qq|
        <tr>
          <th align=right>|.$locale->text('Pricegroup').qq|</th>
          <td><input name=pricegroup size=20></td>
        </tr>
|;
  }

  if (@{ $form->{all_report} }) {
    $form->{selectreportform} = "\n";
    for (@{ $form->{all_report} }) { $form->{selectreportform} .= qq|$_->{reportdescription}--$_->{reportid}\n| }
    
    $reportform = qq|
      <tr>
        <th align=right>|.$locale->text('Report').qq|</th>
        <td>
          <select name=report onChange="ChangeReport();">|.$form->select_option($form->{selectreportform}, undef, 1)
          .qq|</select>
        </td>
      </tr>
|;
  }
  
  $form->helpref("search_$form->{type}", $myconfig{countrycode});
  
  $form->header;

  &calendar;
  
  &change_report(\%$form, \@input, \@checked, \%radio);

  print qq|
<body>

<form method=post name=main action=$form->{script}>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table width=100%>
        $reportform
        $number
        $fromto
        $selectperiod
        <tr>
          <td></td>
          <td><input name=status class=radio type=radio value=all checked>&nbsp;|.$locale->text('All').qq|
          <input name=status class=radio type=radio value=active>&nbsp;|.$locale->text('Active').qq|
          <input name=status class=radio type=radio value=inactive>&nbsp;|.$locale->text('Inactive').qq|
          $orphaned</td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>

|;

  $form->hide_form(qw(path login title sort direction type nextsub reportcode reportlogin));

  print qq|
<input class=submit type=submit name=action value="|.$locale->text('Continue').qq|">
</form>
|;

  if ($form->{menubar}) {
    require "$form->{path}/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 sort direction oldsort type path login status startdatefrom startdateto)) { $href .= "$_=$form->{$_}&" }
  chop $href;
  
  $form->sort_order();
  
  $callback = "$form->{script}?";
  for (qw(action sort direction oldsort type path login status startdatefrom startdateto)) { $callback .= "$_=$form->{$_}&" }
  chop $callback;
  
  @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')."&nbsp;".$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')."&nbsp;".$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->helpref("list_$form->{type}", $myconfig{countrycode});
 
  $form->header;
  
  if (@{ $form->{all_project} }) {
    $sameitem = $form->{all_project}->[0]->{$form->{sort}};
  }
 
  print qq|
<body>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></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);

  foreach $ref (@{ $form->{all_project} }) {
    
    for (qw(startdate enddate)) { $column_data{$_} = qq|<td nowrap>$ref->{$_}&nbsp;</td>| }
    for (qw(description name)) { $column_data{$_} = qq|<td>$ref->{$_}&nbsp;</td>| }

    if ($ref->{name}) {
      $column_data{name} = qq|<td><a href=ct.pl?action=edit&db=customer&id=$ref->{customer_id}&path=$form->{path}&login=$form->{login}&callback=$callback>$ref->{name}</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}&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}&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'} = { ndx => $i++, key => 'A',  value => $locale->text('Add Project') };
    }
  } else {
    if ($myconfig{acs} !~ /Job Costing--Job Costing/) {
      $button{'Job Costing--Add Job'} = { ndx => $i++, key => 'A',  value => $locale->text('Add Job') };
    }
  }
  
  $button{'Save Report'} = { ndx => $i++, key => 'S', value => $locale->text('Save Report') };

  if (!$form->{admin}) {
    if ($form->{reportid}) {
      $login = $form->{login};
      $login =~ s/\@.*//;
      if ($form->{reportlogin} ne $login) {
        delete $button{'Save Report'};
      }
    }
  }
  
  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}>
|;

  if ($form->{year} && $form->{month}) {
    for (qw(startdatefrom startdateto)) { delete $form->{$_} }
  }
  $form->hide_form(qw(projectnumber description startdatefrom startdateto month year sort direction status interval));
  
  $form->hide_form(qw(callback type path login report reportcode reportlogin));

  $form->print_button(\%button);
  
  if ($form->{menubar}) {
    require "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|
  </form>
  
</body>
</html>
|;

}


sub project_header {

  $reference_documents = &references;
  
  $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->quote($form->{description}).qq|">|;
  }

  $label = ucfirst $form->{vc};
  $vcref = qq|<a href=ct.pl?action=edit&db=$form->{vc}&id=$form->{"$form->{vc}_id"}&login=$form->{login}&path=$form->{path} target=_blank>?</a>|;

  if ($form->{"select$form->{vc}"}) {
    $name = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text($label).qq|</th>
	  <td colspan=3>
          <select name="$form->{vc}"
          onChange="javascript:document.main.submit()">|
          .$form->select_option($form->{"select$form->{vc}"}, $form->{$form->{vc}}, 1).qq|</select>
          $vcref
	  </td>
          <input name=action type=hidden value=update>
	</tr>
|;
  } else {
    $name = qq|
	<tr>
	  <th align=right nowrap>|.$locale->text($label).qq|</th>
	  <td colspan=3><input name="$form->{vc}" value="|.$form->quote($form->{"$form->{vc}"}).qq|" size=35> $vcref</td>
	</tr>
|;
  }
  

  $form->header;

  &calendar;
  
  print qq|
<body>

<form method="post" name="main" action="$form->{script}" />
|;

  $form->hide_form("select$form->{vc}", "old$form->{vc}", "$form->{vc}_id");
  $form->hide_form(qw(id type orphaned vc title helpref));

  print qq|
<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></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->quote($form->{projectnumber}).qq|"></td>
        </tr>
        <tr>
          <th align=right>|.$locale->text('Description').qq|</th>
          <td>$description</td>
        </tr>
        $name
        <tr>
          <th align=right>|.$locale->text('Startdate').qq|</th>
          <td>
          <table>
            <tr>
              <td><input name=startdate size=11 class=date title="$myconfig{dateformat}" value=$form->{startdate}>|.&js_calendar("main", "startdate").qq|</td>
              <th align=right>|.$locale->text('Enddate').qq|</th>
              <td><input name=enddate size=11 class=date title="$myconfig{dateformat}" value=$form->{enddate}>|.&js_calendar("main", "enddate").qq|</td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td>
      $reference_documents
    </td>
  </tr>
  <tr>
    <td><hr size=3 noshade></td>
  </tr>
</table>
|;

}


sub project_footer {

  $form->hide_form(qw(reference_rows callback path login));
  
  %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') };
    }
  }

  $form->print_button(\%button);

  if ($form->{menubar}) {
    require "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|
</form>

</body>
</html>
|;

}


sub save {
  
  $form->{userspath} = $userspath;

  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}"}) {
      (undef, $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}"}) {
      (undef, $form->{"$form->{vc}_id"}) = split /--/, $form->{"$form->{vc}"};
      $form->error($locale->text('Customer missing!')) unless $form->{"$form->{vc}_id"};
    } 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 save_as_new {

  delete $form->{id};
  &save;

}


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 {

  for (qw(partsgroup partsgroupcode)) { $form->{$_} = $form->unescape($form->{$_}) }
  PE->partsgroups(\%myconfig, \%$form);

  $href = "$form->{script}?action=partsgroup_report&sort=$form->{sort}&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&status=$form->{status}";
  
  $form->sort_order();

  $callback = "$form->{script}?action=partsgroup_report&sort=$form->{sort}&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&status=$form->{status}";
  
  if ($form->{status} eq 'all') {
    $option = $locale->text('All');
  }
  if ($form->{status} eq 'orphaned') {
    $option .= $locale->text('Orphaned');
  }
  if ($form->{partsgroup}) {
    $href .= "&partsgroup=".$form->escape($form->{partsgroup});
    $callback .= "&partsgroup=$form->{partsgroup}";
    $option .= "\n<br>".$locale->text('Group')." : $form->{partsgroup}";
  }
  if ($form->{partsgroupcode}) {
    $href .= "&partsgroupcode=".$form->escape($form->{partsgroupcode});
    $callback .= "&partsgroupcode=$form->{partsgroupcode}";
    $option .= "\n<br>".$locale->text('Code')." : $form->{partsgroupcode}";
  }

  @column_index = $form->sort_columns(qw(partsgroup code image pos));

  $column_header{partsgroup} = qq|<th><a class=listheading href=$href&sort=partsgroup width=90%>|.$locale->text('Group').qq|</a></th>|;
  $column_header{code} = qq|<th><a class=listheading href=$href&sort=code>|.$locale->text('Code').qq|</a></th>|;
  $column_header{pos} = qq|<th class=listheading>|.$locale->text('POS').qq|</th>|;
  $column_header{image} = qq|<th class=listheading>|.$locale->text('Image').qq|</th>|;

  $form->{title} = $locale->text('Groups') . " / $form->{company}";

  $form->helpref("partsgroup_report", $myconfig{countrycode});
  
  $form->header;
 
  print qq|
<body>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></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}&callback=$callback>$ref->{partsgroup}</td>|;
    $column_data{code} = qq|<td>$ref->{code}</td>|;
    $pos = ($ref->{pos}) ? "*" : "&nbsp;";
    $column_data{pos} = qq|<td align=center>$pos</td>|;
    $column_data{image} = ($ref->{image}) ? "<td width=10%><a href=$images/$myconfig{dbname}/$ref->{image}><img src=$images/$myconfig{dbname}/$ref->{image} height=32 border=0></a></td>" : "<td>&nbsp;</td>";
    
    for (@column_index) { print "$column_data{$_}\n" }
    
    print "
        </tr>
";
  }

  if ($myconfig{acs} !~ /Goods \& Services--Goods \& Services/) {
    $button{'Goods & Services--Add Group'} = { ndx => 1, key => 'A', value => $locale->text('Add Group') };

    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->{code} = $form->{partsgroupcode};
  $form->hide_form(qw(partsgroup code callback type path login));

  $form->print_button(\%button);

  if ($form->{menubar}) {
    require "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|
  </form>

</body>
</html>
|;

}


sub partsgroup_header {

  $form->{action} =~ s/_.*//g;
  $form->{title} = $locale->text(ucfirst $form->{action}." ".$locale->text('Group'));

# $locale->text('Add Group')
# $locale->text('Edit Group')

  for (qw(partsgroup code)) { $form->{$_} = $form->quote($form->{$_}) }
  $form->{pos} = ($form->{pos}) ? "checked" : "";
  
  $form->helpref("partsgroup", $myconfig{countrycode});

  $preview = ($form->{image}) ? qq|<a href=$images/$myconfig{dbname}/$form->{image}> ?| : qq| <a href="ic.pl?action=upload_image&login=$form->{login}&path=$form->{path}" target=popup>?</a>|;

  $form->header;

  print qq|
<body>

<form method=post action=$form->{script}>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table>
        <tr>
          <th align=right nowrap>|.$locale->text('Group').qq| <font color=red>*</font></th>

          <td><input name=partsgroup size=40 value="$form->{partsgroup}"></td>
        </tr>
        <tr>
          <th align=right nowrap>|.$locale->text('Code').qq|</th>
                <td><input name=code size=10 value="$form->{code}"></td>
        </tr>
        <tr>
          <th align=right nowrap>|.$locale->text('Image').qq|</th>
          <td><input name=image size=20 value="$form->{image}">$preview</td>
        </tr>
        <tr>
          <th align=right nowrap>|.$locale->text('POS Button').qq|</th>
                <td><input name=pos class=checkbox type=checkbox value=1 $form->{pos}></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td colspan=2><hr size=3 noshade></td>
  </tr>
</table>
|;

  $form->hide_form(qw(id type));

}


sub partsgroup_footer {

  $form->hide_form(qw(callback path login));

  if ($myconfig{acs} !~ /Goods \& Services--Add Group/) {
    print qq|
<input type=submit class=submit name=action value="|.$locale->text('Save').qq|">
|;

    if ($form->{id}) {
      
      print qq|
<input type=submit class=submit name=action value="|.$locale->text('Save as new').qq|">
|;
      if ($form->{orphaned}) {
        print qq|
<input type=submit class=submit name=action value="|.$locale->text('Delete').qq|">|;
      }
    }
  }

  if ($form->{menubar}) {
    require "$form->{path}/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&sort=$form->{sort}&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&status=$form->{status}";
  
  $form->sort_order();

  $callback = "$form->{script}?action=pricegroup_report&sort=$form->{sort}&direction=$form->{direction}&oldsort=$form->{oldsort}&type=$form->{type}&path=$form->{path}&login=$form->{login}&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->{company}";

  $form->helpref("pricegroup_report", $myconfig{countrycode});
  
  $form->header;
 
  print qq|
<body>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></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}&callback=$callback>$ref->{pricegroup}</td>|;
    for (@column_index) { print "$column_data{$_}\n" }
    
    print "
        </tr>
";
  }

  if ($myconfig{acs} !~ /Goods \& Services--Goods \& Services/) {
    $button{'Goods & Services--Add Pricegroup'} = { ndx => 1, key => 'A', value => $locale->text('Add Pricegroup') };

    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));
  
  $form->print_button(\%button);

  if ($form->{menubar}) {
    require "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|
  </form>

</body>
</html>
|;

}


sub pricegroup_header {

  $form->{title} = $locale->text(ucfirst $form->{action}." ".$locale->text('Pricegroup'));

# $locale->text('Add Pricegroup')
# $locale->text('Edit Pricegroup')

  $form->{pricegroup} = $form->quote($form->{pricegroup});

  $form->helpref("pricegroup", $myconfig{countrycode});
  
  $form->header;

  print qq|
<body>

<form method=post action=$form->{script}>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></th>
  </tr>
  <tr height="5"></tr>
  <tr>
    <td>
      <table>
        <tr>
          <th align=right nowrap>|.$locale->text('Pricegroup').qq| <font color=red>*</font></th>

          <td><input name=pricegroup size=30 value="|.$form->quote($form->{pricegroup}).qq|"></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td colspan=2><hr size=3 noshade></td>
  </tr>
</table>
|;

  $form->hide_form(qw(id type));

}


sub pricegroup_footer {

  $form->hide_form(qw(callback path login));
  
  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 "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|
</form>

</body>
</html>
|;

}


sub translation {

  if ($form->{translation} eq 'description') {
    $form->{title} = $locale->text('Description Translations');
    $form->helpref("item_translation", $myconfig{countrycode});
    
    $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>|;
    $form->helpref("group_translation", $myconfig{countrycode});
  }
  
  if ($form->{translation} eq 'project') {
    $form->{title} = $locale->text('Project Description Translations');
    $form->helpref("project_translation", $myconfig{countrycode});
    $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>
|;
  }

  if ($form->{translation} eq 'chart') {
    $form->{title} = $locale->text('Chart of Accounts Translations');
    $form->helpref("coa_translation", $myconfig{countrycode});
    $form->{number} = "accno";
    $sort = qq|<input type=hidden name=sort value=accno>|;
    $number = qq|
        <tr>
          <th align=right nowrap>|.$locale->text('Account').qq|</th>
          <td><input name=accno 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->{helpref}$form->{title}</a></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));

  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}&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;

  $form->helpref("list_$form->{translation}_translations", $myconfig{countrycode});
  
  print qq|
<body>

<table width=100%>
  <tr>
    <th class=listtop>$form->{helpref}$form->{title}</a></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->{$_}&nbsp;</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}&title=$title&callback=$callback>$ref->{description}&nbsp;</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}>

|;

  $form->hide_form(qw(path login callback));

  if ($form->{menubar}) {
    require "$form->{path}/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->helpref("$form->{translation}_translations", $myconfig{countrycode});
  
  $form->{selectlanguage} = qq|\n|;
  for (@{ $form->{all_language} }) { $form->{selectlanguage} .= qq|$_->{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;

# $locale->text('Edit Project Description Translations')
# $locale->text('Edit Description Translations')
# $locale->text('Edit Group Translations')

  $form->{title} = "Edit $form->{title}";
  
  $form->{selectlanguage} = $form->escape($form->{selectlanguage},1);
  
  &translation_header;
  &translation_footer;

}


sub translation_header {

  $form->{translation_rows}++;

  $form->header;
 
  print qq|
<body>

<form method=post action=$form->{script}>
|;

  $form->hide_form("$form->{number}", "description");
  $form->hide_form(qw(id trans_id selectlanguage translation_rows number translation title helpref));

  print qq|
  
<table width="100%">
  <tr><th class=listtop>$form->{helpref}$form->{title}</a></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->quote($form->{"translation_$i"}).qq|">|;
    }
   
    print qq|
	<tr valign=top>
	  <td><select name="language_code_$i">|
	  .$form->select_option($form->{selectlanguage}, $form->{"language_code_$i"}, undef, 1)
	  .qq|</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 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'};
  }

  $form->print_button(\%button);

  if ($form->{menubar}) {
    require "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|

  </form>

</body>
</html>
|;

}


sub update {

  if ($form->{translation}) {
    @flds = qw(language translation);
    $count = 0;
    @f = ();
    for $i (1 .. $form->{translation_rows}) {
      if ($form->{"language_code_$i"} ne "") {
        push @f, {};
        $j = $#f;

        for (@flds) { $f[$j]->{$_} = $form->{"${_}_$i"} }
        $count++;
      }
    }
    $form->redo_rows(\@flds, \@f, $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(listprice sellprice weight)) { $form->{$_} = $form->parse_amount(\%myconfig, $form->{$_}) }

    if ($form->{"select$form->{vc}"}) {
      
      (undef, $form->{"$form->{vc}_id"}) = split /--/, $form->{"$form->{vc}"};
      $form->{"old$form->{vc}"} = $form->{"$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|\n|;
          for (@{ $form->{"all_$form->{vc}"} }) { $form->{"select$form->{vc}"} .= qq|$_->{name}--$_->{id}\n| }
          $form->{"select$form->{vc}"} = $form->escape($form->{"select$form->{vc}"},1);
        }
      }

    } 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};
# $locale->text('Customer Number')
# $locale->text('Vendor Number')

  $labelnumber = $locale->text("$label Number");
  @column_index = (ndx, name, "$form->{vc}number", address);

  $column_data{ndx} = qq|<th class=listheading width=1%>&nbsp;</th>|;
  $column_data{name} = qq|<th class=listheading>|.$locale->text($label).qq|</th>|;
  $column_data{"$form->{vc}number"} = qq|<th class=listheading>$labelnumber</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>
|;

  push @column_index, (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="|.$form->quote($ref->{name}).qq|">$ref->{name}</td>|;

    $column_data{"$form->{vc}number"} = qq|<td><input name="new_$form->{vc}number{_}_$i" type=hidden value="|.$form->quote($ref->{"$form->{vc}number"}).qq|">$ref->{"$form->{vc}number"}</td>|;
    $column_data{address} = qq|<td>$ref->{address1} $ref->{address2}</td>|;
    for (qw(city state zipcode country)) { $column_data{$_} = qq|<td>$ref->{$_}&nbsp;</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->{"$form->{vc}number"} = $form->{"new_$form->{vc}number{_}_$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} }) {
    $selectaccountingyear = "\n";
    for (@{ $form->{all_years} }) { $selectaccountingyear .= qq|$_\n| }
    $selectaccountingmonth = "\n";
    for (sort keys %{ $form->{all_month} }) { $selectaccountingmonth .= qq|$_--|.$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->select_option($selectaccountingmonth, undef, 1, 1).qq|</select>
          <select name=year>|.$form->select_option($selectaccountingyear).qq|</select>
          <input name=interval class=radio type=radio value=0 checked>&nbsp;|.$locale->text('Current').qq|
          <input name=interval class=radio type=radio value=1>&nbsp;|.$locale->text('Month').qq|
          <input name=interval class=radio type=radio value=3>&nbsp;|.$locale->text('Quarter').qq|
          <input name=interval class=radio type=radio value=12>&nbsp;|.$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 class=date title="$myconfig{dateformat}" value=$form->{transdatefrom}>|.&js_calendar("main", "transdatefrom")
          .qq| |.$locale->text('To').qq| <input name=transdateto size=11 class=date title="$myconfig{dateformat}" value=$form->{transdateto}>|.&js_calendar("main", "transdateto").qq|</td>
        </tr>
        $selectfrom
|;

  if (@{ $form->{all_project} }) {
    $form->{selectprojectnumber} = "\n";
    $form->{projectnumber} ||= "";
    for (@{ $form->{all_project} }) { $form->{selectprojectnumber} .= qq|$_->{projectnumber}--$_->{id}\n| }
  } else {
    $form->error($locale->text('No open Projects!'));
  }

  if (@{ $form->{all_employee} }) {
    $form->{selectemployee} = "\n";
    $form->{employee} ||= "";
    for (@{ $form->{all_employee} }) { $form->{selectemployee} .= qq|$_->{name}--$_->{id}\n| }

    $employee = qq|
              <tr>
                <th align=right nowrap>|.$locale->text('Employee').qq|</th>
                <td><select name=employee>|
                .$form->select_option($form->{selectemployee}, $form->{employee}, 1)
                .qq|</select></td>
              </tr>
|;
  }
  
  $form->{title} = $locale->text('Generate Sales Orders');
  $form->{vc} = "customer";
  $form->{type} = "sales_order";

  $form->header;

  &calendar;
  
  print qq|
<body>

<form method="post" name="main" 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->select_option($form->{selectprojectnumber}, $form->{"projectnumber"}, 1)
          .qq|</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 nextsub type vc));

  print qq|
<input type=submit class=submit name=action value="|.$locale->text('Continue').qq|">

</form>
|;

  if ($form->{menubar}) {
    require "$form->{path}/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 nextsub type vc)) { $form->{callback} .= "&$_=$form->{$_}" }
  for (qw(employee projectnumber)) { $form->{callback} .= "&$_=".$form->escape($form->{$_},1) }
  
  PE->get_jcitems(\%myconfig, \%$form);

  # flatten array
  $i = 1;
  foreach $ref (@{ $form->{jcitems} }) {
    
    $form->{"employee_$i"} = $ref->{employee};
    $form->{"$form->{vc}_$i"} = $ref->{$form->{vc}};
    $form->{"$form->{vc}number{_}$i"} = $ref->{"$form->{vc}number"};

    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->{"itemnotes_$i"}) {
          $form->{"itemnotes_$i"} .= qq|\n\n$ref->{notes}|;
        } else {
          $form->{"itemnotes_$i"} = $ref->{notes};
        }

      } else {
      
        for (keys %$ref) { $form->{"${_}_$i"} = $ref->{$_} }
        
        $form->{"itemnotes_$i"} = $ref->{notes};
        $form->{"checked_$i"} = 1;
        $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->{"itemnotes_$i"} = $ref->{notes};
      $form->{"checked_$i"} = 1;
      $form->{"id_$i"} = "$ref->{id}:$ref->{qty}";
      
    }

    $i++;
    
  }

  $form->error($locale->text('Nothing to generate!')) unless $i > 1;

  $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"}, $form->{precision}) }
  }

  &jcitems;
    
}


sub jcitems {

# $locale->text('Customer')
# $locale->text('Vendor')
# $locale->text->('Customer Number')
# $locale->text('Vendor Number')

  $vc = ucfirst $form->{vc};
  $vcnumber = "$vc Number";
  
  @column_index = qw(id projectnumber name);
  push @column_index, "$form->{vc}number";

  if (!$form->{summary}) {
    push @column_index, qw(transdate);
  }
  push @column_index, qw(partnumber description);
  push @column_index, "itemnotes" if !$form->{summary};
  push @column_index, qw(employee qty amount);

  $column_header{id} = qq|<th class=listheading width=1%><input name="allbox" type=checkbox class=checkbox value="1" checked onChange="CheckAll();"></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{employee} = qq|<th class=listheading>|.$locale->text('Employee').qq|</th>|;
  $column_header{description} = qq|<th class=listheading>|.$locale->text('Description').qq|</th>|;
  $column_header{itemnotes} = qq|<th class=listheading>|.$locale->text('Notes').qq|</th>|;
  $column_header{name} = qq|<th class=listheading>$vc</th>|;
  $column_header{"$form->{vc}number"} = qq|<th class=listheading>|.$locale->text($vcnumber).qq|</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;

  &check_all(qw(allbox checked_));

  print qq|
<body>

<form method="post" name="main" 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 (qw(description itemnotes)) { $form->{"${_}_$i"} =~ s/\r?\n/<br>/g }
    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>|;
      $column_data{"$form->{vc}number"} = qq|<td>$form->{"$form->{vc}number_$i"}</td>|;
      $form->hide_form("$form->{vc}_id_$i", "$form->{vc}_$i", "$form->{vc}number_$i");
    } else {
      $column_data{name} = qq|<td><input name="ndx_$i" class=checkbox type=checkbox value="1"></td>|;
    }
    
    $form->hide_form(map {"${_}_$i"} qw(id project_id parts_id projectnumber transdate partnumber description itemnotes qty unit 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 vc nextsub rowcount type currency defaultcurrency taxaccounts summary callback));
  $form->hide_form(map { "${_}_rate" } split / /, $form->{taxaccounts});
  
  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 "$form->{path}/menu.pl";
    &menubar;
  }

  print qq|
</form>

</body>
</html>
|;

}


sub select_customer {

  for (1 .. $form->{rowcount}) {
    last if ($ok = $form->{"ndx_$_"});
  }

  $form->error($locale->text('All selected!')) unless $ok;

  $label = ($form->{vc} eq 'customer') ? $locale->text('Customer') : $locale->text('Vendor');
  
  $form->header;

  print qq|
<body onLoad="document.main.$form->{vc}.focus()" />

<form method=post name=main 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}number"} = $form->{name_list}[0]->{"$form->{vc}number"};
    $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}"};
      $form->{"$form->{vc}number_$_"} = $form->{"$form->{vc}number"};
    }
  }
  
}

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"}) {
      for (qw(description itemnotes)) { $form->{"${_}_$i"} =~ s/<br>/\r\n/g }
      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"},
      unit => $form->{"unit_$i"},
      sellprice => $form->{"sellprice_$i"},
      projectnumber => qq|--$form->{"project_id_$i"}|,
      reqdate => $form->{"transdate_$i"},
      taxaccounts => $form->{"taxaccounts_$i"},
      jcitems => $form->{"id_$i"},
      itemnotes => $form->{"itemnotes_$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;

    $order->{ordnumber} = $order->update_defaults(\%myconfig, 'sonumber');
    $order->{transdate} = $order->current_date(\%myconfig);
    $order->{reqdate} = $order->{transdate};
    $order->{exchangerate} = $order->get_exchangerate(\%myconfig, undef, $order->{currency}, $order->{transdate}) unless $order->{currency} eq $order->{defaultcurrency};
    
    for (qw(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->{$_} }

  }

  delete $form->{callback};

  $form->redirect($locale->text('Orders generated!'));

}


