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">From: </TD>
  32         <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>
  33 <SCRIPT TYPE="text/javascript">
  34   Calendar.setup({
  35     inputField: "beginning_text",
  36     ifFormat:   "%m/%d/%Y",
  37     button:     "beginning_button",
  38     align:      "BR"
  39   });
  40 </SCRIPT>
  41       </TR>
  42       <TR>
  43         <TD ALIGN="right">To: </TD>
  44         <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>
  45 <SCRIPT TYPE="text/javascript">
  46   Calendar.setup({
  47     inputField: "ending_text",
  48     ifFormat:   "%m/%d/%Y",
  49     button:     "ending_button",
  50     align:      "BR"
  51   });
  52 </SCRIPT>
  53       </TR>
  54     </TABLE>
  55     <BR><INPUT TYPE="submit" VALUE="Get Report">
  56     </FORM>
  57   </BODY>
  58 </HTML>