httemplate/search/report_cust_credit.html

   1 <HTML>
   2   <HEAD>
   3     <TITLE>Credit report criteria</TITLE>
   4     <LINK REL="stylesheet" TYPE="text/css" HREF="../elements/calendar-win2k-2.css" TITLE="win2k-2">
   5     <SCRIPT TYPE="text/javascript" SRC="../elements/calendar_stripped.js"></SCRIPT>
   6     <SCRIPT TYPE="text/javascript" SRC="../elements/calendar-en.js"></SCRIPT>
   7     <SCRIPT TYPE="text/javascript" SRC="../elements/calendar-setup.js"></SCRIPT>
   8   </HEAD>
   9   <BODY BGCOLOR="#e8e8e8">
  10     <H1>Credit report criteria</H1>
  11     <FORM ACTION="cust_credit.html" METHOD="post">
  12     <INPUT TYPE="hidden" NAME="magic" VALUE="_date">
  13     <TABLE>
  14       <TR>
  15         <TD ALIGN="right">Credits by employee: </TD>
  16 <%
  17   my $sth = dbh->prepare("SELECT DISTINCT otaker FROM cust_credit")
  18     or die dbh->errstr;
  19   $sth->execute or die $sth->errstr;
  20   my @otakers = map { $_->[0] } @{$sth->fetchall_arrayref};
  21 %>
  22         <TD><SELECT NAME="otaker">
  23               <OPTION VALUE="">all</OPTION>
  24               <% foreach my $otaker ( @otakers ) { %>
  25                 <OPTION VALUE="<%= $otaker %>"><%= $otaker %></OPTION>
  26               <% } %>
  27             </SELECT>
  28         </TD>
  29       </TR>
  30       <TR>
  31         <TD ALIGN="right">for agent: </TD>
  32         <TD><SELECT NAME="agentnum">
  33               <OPTION VALUE="">all</OPTION>
  34               <% foreach my $agent ( qsearch('agent', { disabled=>'' } ) ) { %>
  35                 <OPTION VALUE="<%= $agent->agentnum %>"<%= $cgi->param('agentnum') == $agent->agentnum ? ' SELECTED' : '' %>><%= $agent->agent %>
  36               <% } %>
  37             </SELECT>
  38         </TD>
  39       </TR>
  40       <TR>
  41         <TD ALIGN="right">From: </TD>
  42         <TD><INPUT TYPE="text" NAME="beginning" ID="beginning_text" VALUE="" SIZE=11 MAXLENGTH=10> <IMG SRC="../images/calendar.png" ID="beginning_button" STYLE="cursor: pointer" TITLE="Select date"><BR><i>m/d/y</i></TD>
  43 <SCRIPT TYPE="text/javascript">
  44   Calendar.setup({
  45     inputField: "beginning_text",
  46     ifFormat:   "%m/%d/%Y",
  47     button:     "beginning_button",
  48     align:      "BR"
  49   });
  50 </SCRIPT>
  51       </TR>
  52       <TR>
  53         <TD ALIGN="right">To: </TD>
  54         <TD><INPUT TYPE="text" NAME="ending" ID="ending_text" VALUE="" SIZE=11 MAXLENGTH=10> <IMG SRC="../images/calendar.png" ID="ending_button" STYLE="cursor: pointer" TITLE="Select date"><BR><i>m/d/y</i></TD>
  55 <SCRIPT TYPE="text/javascript">
  56   Calendar.setup({
  57     inputField: "ending_text",
  58     ifFormat:   "%m/%d/%Y",
  59     button:     "ending_button",
  60     align:      "BR"
  61   });
  62 </SCRIPT>
  63       </TR>
  64     </TABLE>
  65     <BR><INPUT TYPE="submit" VALUE="Get Report">
  66     </FORM>
  67   </BODY>
  68 </HTML>