API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2017
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 11.23 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <title>
  4. Order Pad
  5. </title>
  6.  
  7. </head>
  8. <body>
  9. <a href="index.html">Home</a><br>
  10. <center>
  11.  
  12. Order Pad:
  13. <form method="post" action="">
  14. Lookup current customer:<br>
  15. <?php
  16.  
  17. //get company info
  18. $CompanyName=$_POST['CompanyName'];
  19. echo '<select name="CompanyName">';
  20. include('connect.php');
  21. $query = "SELECT DISTINCT CompanyName FROM customers ORDER BY CompanyName";
  22. $result = mysql_query($query);
  23.  
  24. while($row=mysql_fetch_array($result,MYSQL_ASSOC))
  25. {
  26. echo '<option value="'.$row['CompanyName'].'">'.$row['CompanyName'].'</option>';
  27. }
  28. echo '</select>';
  29.  
  30. if($CompanyName)
  31. {
  32. $query="SELECT * FROM customers WHERE CompanyName = '$CompanyName' ORDER BY CompanyName";
  33. $result = mysql_query($query);
  34. $row = mysql_fetch_row($result,MYSQL_ASSOC);
  35. }
  36.  
  37.  
  38. //get product info
  39. $ProdNoLookup = $_POST['ProdNoLookup'];
  40. if($ProdNoLookup)
  41. {
  42. $query2="SELECT SupProdNo FROM products WHERE ProdNo='$ProdNoLookup'";
  43. $result2 = mysql_query($query2);
  44. $row2 = mysql_fetch_row($result2);
  45. $SupProdNo = $row2['SupProdNo'];
  46. echo 'SupProdNo:'.$SupProdNo;
  47. //$SupProdNo[1] = $row['SupProdNo'];
  48. //$Desc[1] = $row['Desc'];
  49. //$Colour[1] = $row['Colour'];
  50. //$Length[1] = $row['Length'];
  51. //$PackQty[1] = $row['PackQty'];
  52. //$Price[1] = $row['Price'];
  53. }
  54.  
  55.  
  56.  
  57. include('disconnect.php');
  58.  
  59. ?><br>
  60. <input name="submit" type="submit">
  61. </form>
  62. <form method="post" action="">
  63. TP Product Number:<br>
  64. <input name="ProdNoLookup" type="text"><br>
  65. <input name="submit" type="submit" value="Lookup"><br>
  66. </form>
  67. <?php
  68. if(!$qSubmit)
  69. {
  70. echo "<form action='' method='post'>";
  71. }
  72. else
  73. {
  74. echo '<form action="output.php" method="post">';
  75. }
  76.  
  77. ?>
  78.  
  79. Company Name:<br>
  80. <input name="CompanyName" type="text" <?php echo"value='"; echo $row['CompanyName']; echo "'";?>><br>
  81. Contact Name:<br>
  82. <input name="ContactName" type="text" <?php echo"value='"; echo $row['ContactName']; echo "'";?>><br>
  83. Contact Telephone:<br>
  84. <input name="ContactTelephone" type="text" <?php echo"value='"; echo $row['ContactTelephone']; echo "'";?>><br>
  85. Contact Email Address:<br>
  86. <input name="ContactEmail" type="text" <?php echo"value='"; echo $row['ContactEmail']; echo "'";?>><br>
  87. </center>
  88. <form method="post" action="processOrder.php">
  89. <table>
  90. <tr><td>ProdNo</td><td>Supplier ProdNo</td><td>Description</td><td>Colour</td><td>Lengths</td><td>PackQty</td><td>QtyOfPacks</td><td>PricePerPack</td></tr>
  91. <tr><td><input name="ProdNo1" <?php echo'value="'.$ProdNo[1].'"'?> size="8"></td><td><input name="SupProdNo1" <?php echo'value="'.$SupProdNo[1].'"'?>></td><td><input name="Desc1" <?php echo'value="'.$Desc[1].'"'?>></td><td><input name="Colour1" <?php echo'value="'.$Colour[1].'"'?>></td><td><input name="Length1" <?php echo'value="'.$Length[1].'"'?>></td><td><input name="PackQty1" size="3" <?php echo'value="'.$PackQty[1].'"'?>></td><td><input name="QtyofPack1" size="3" <?php echo'value="'.$QtyofPack[1].'"'?>></td><td><input name="Price1" type="text" <?php echo'value="'.$Price[1].'"'?>></td></tr>
  92. <tr><td><input name="ProdNo2" <?php echo'value="'.$ProdNo[2].'"'?> size="8"></td><td><input name="SupProdNo2" <?php echo'value="'.$SupProdNo[2].'"'?>></td><td><input name="Desc2" <?php echo'value="'.$Desc[2].'"'?>></td><td><input name="Colour2" <?php echo'value="'.$Colour[2].'"'?>></td><td><input name="Length2" <?php echo'value="'.$Length[2].'"'?>></td><td><input name="PackQty2" size="3" <?php echo'value="'.$PackQty[2].'"'?>></td><td><input name="QtyofPack2" size="3" <?php echo'value="'.$QtyofPack[2].'"'?>></td><td><input name="Price2" type="text" <?php echo'value="'.$Price[2].'"'?>></td></tr>
  93. <tr><td><input name="ProdNo3" <?php echo'value="'.$ProdNo[3].'"'?> size="8"></td><td><input name="SupProdNo3" <?php echo'value="'.$SupProdNo[3].'"'?>></td><td><input name="Desc3" <?php echo'value="'.$Desc[3].'"'?>></td><td><input name="Colour3" <?php echo'value="'.$Colour[3].'"'?>></td><td><input name="Length3" <?php echo'value="'.$Length[3].'"'?>></td><td><input name="PackQty3" size="3" <?php echo'value="'.$PackQty[3].'"'?>></td><td><input name="QtyofPack3" size="3" <?php echo'value="'.$QtyofPack[3].'"'?>></td><td><input name="Price3" type="text" <?php echo'value="'.$Price[3].'"'?>></td></tr>
  94. <tr><td><input name="ProdNo4" <?php echo'value="'.$ProdNo[4].'"'?> size="8"></td><td><input name="SupProdNo4" <?php echo'value="'.$SupProdNo[4].'"'?>></td><td><input name="Desc4" <?php echo'value="'.$Desc[4].'"'?>></td><td><input name="Colour4" <?php echo'value="'.$Colour[4].'"'?>></td><td><input name="Length4" <?php echo'value="'.$Length[4].'"'?>></td><td><input name="PackQty4" size="3" <?php echo'value="'.$PackQty[4].'"'?>></td><td><input name="QtyofPack4" size="3" <?php echo'value="'.$QtyofPack[4].'"'?>></td><td><input name="Price4" type="text" <?php echo'value="'.$Price[4].'"'?>></td></tr>
  95. <tr><td><input name="ProdNo5" <?php echo'value="'.$ProdNo[5].'"'?> size="8"></td><td><input name="SupProdNo5" <?php echo'value="'.$SupProdNo[5].'"'?>></td><td><input name="Desc5" <?php echo'value="'.$Desc[5].'"'?>></td><td><input name="Colour5" <?php echo'value="'.$Colour[5].'"'?>></td><td><input name="Length5" <?php echo'value="'.$Length[5].'"'?>></td><td><input name="PackQty5" size="3" <?php echo'value="'.$PackQty[5].'"'?>></td><td><input name="QtyofPack5" size="3" <?php echo'value="'.$QtyofPack[5].'"'?>></td><td><input name="Price5" type="text" <?php echo'value="'.$Price[5].'"'?>></td></tr>
  96. <tr><td><input name="ProdNo6" <?php echo'value="'.$ProdNo[6].'"'?> size="8"></td><td><input name="SupProdNo6" <?php echo'value="'.$SupProdNo[6].'"'?>></td><td><input name="Desc6" <?php echo'value="'.$Desc[6].'"'?>></td><td><input name="Colour6" <?php echo'value="'.$Colour[6].'"'?>></td><td><input name="Length6" <?php echo'value="'.$Length[6].'"'?>></td><td><input name="PackQty6" size="3" <?php echo'value="'.$PackQty[6].'"'?>></td><td><input name="QtyofPack6" size="3" <?php echo'value="'.$QtyofPack[6].'"'?>></td><td><input name="Price6" type="text" <?php echo'value="'.$Price[6].'"'?>></td></tr>
  97. <tr><td><input name="ProdNo7" <?php echo'value="'.$ProdNo[7].'"'?> size="8"></td><td><input name="SupProdNo7" <?php echo'value="'.$SupProdNo[7].'"'?>></td><td><input name="Desc7" <?php echo'value="'.$Desc[7].'"'?>></td><td><input name="Colour7" <?php echo'value="'.$Colour[7].'"'?>></td><td><input name="Length7" <?php echo'value="'.$Length[7].'"'?>></td><td><input name="PackQty7" size="3" <?php echo'value="'.$PackQty[7].'"'?>></td><td><input name="QtyofPack7" size="3" <?php echo'value="'.$QtyofPack[7].'"'?>></td></td><td><input name="Price7" type="text" <?php echo'value="'.$Price[7].'"'?>></td></tr>
  98. <tr><td><input name="ProdNo8" <?php echo'value="'.$ProdNo[8].'"'?> size="8"></td><td><input name="SupProdNo8" <?php echo'value="'.$SupProdNo[8].'"'?>></td><td><input name="Desc8" <?php echo'value="'.$Desc[8].'"'?>></td><td><input name="Colour8" <?php echo'value="'.$Colour[8].'"'?>></td><td><input name="Length8" <?php echo'value="'.$Length[8].'"'?>></td><td><input name="PackQty8" size="3" <?php echo'value="'.$PackQty[8].'"'?>></td><td><input name="QtyofPack8" size="3" <?php echo'value="'.$QtyofPack[8].'"'?>></td><td><input name="Price8" type="text" <?php echo'value="'.$Price[8].'"'?>></td></tr>
  99. </table><center>
  100. Delivery Charge:<br>
  101. <input name="DeliCharge" type="text"><br>
  102. <input type="button" name="calculation" value="Calculate Totals" onclick="func(this.form)" /><br>
  103. Delivery Method:<br>
  104. <select name="DeliMethod">
  105. <option value="Standard Delivery">Standard Delivery</option>
  106. <option value="Next Day">Next Day</option>
  107. <option value="Noon">Noon</option>
  108. <option value="10:30AM">10:30AM</option>
  109. <option value="Saturday">Saturday</option></select><br>
  110. Delivery Date:<br>
  111. <input name="DeliDate" type="text"><br>
  112. Goods Total:<br>
  113. <input name="GoodsTotal" type="text"><br>
  114. Net Total:<br>
  115. <input name="NetTotal" type="text"><br>
  116. Vat:<br>
  117. <input name="VAT" type="text"><br>
  118. Gross Total:<br>
  119. <input name="GrossTotal" type="text"><br>
  120.  
  121.  
  122. <!----------Calculate totals---------->
  123. <script type="text/JavaScript">
  124. function func(form)
  125. {
  126.     var Qty1 = parseFloat(form.QtyofPack1.value*1);
  127.     var Qty2 = parseFloat(form.QtyofPack2.value*1);
  128.     var Qty3 = parseFloat(form.QtyofPack3.value*1);
  129.     var Qty4 = parseFloat(form.QtyofPack4.value*1);
  130.     var Qty5 = parseFloat(form.QtyofPack5.value*1);
  131.     var Qty6 = parseFloat(form.QtyofPack6.value*1);
  132.     var Qty7 = parseFloat(form.QtyofPack7.value*1);
  133.     var Qty8 = parseFloat(form.QtyofPack8.value*1);
  134.     var Price1 = parseFloat(form.Price1.value*1);
  135.     var Price2 = parseFloat(form.Price2.value*1);
  136.     var Price3 = parseFloat(form.Price3.value*1);
  137.     var Price4 = parseFloat(form.Price4.value*1);
  138.     var Price5 = parseFloat(form.Price5.value*1);
  139.     var Price6 = parseFloat(form.Price6.value*1);
  140.     var Price7 = parseFloat(form.Price7.value*1);
  141.     var Price8 = parseFloat(form.Price8.value*1);
  142.     var DeliCharge = parseFloat(form.DeliCharge.value*1);
  143.     var netTotal = parseFloat("0");
  144.     var VAT = parseFloat("0");
  145.     var GrossTotal = parseFloat("0");
  146.     var GoodsTotal = parseFloat("0");  
  147.  
  148.     GoodsTotal =(Price1*Qty1)+(Price2*Qty2)+(Price3*Qty3)+(Price4*Qty4)+(Price5*Qty5)+(Price6*Qty6)+(Price7*Qty7)+(Price8*Qty8)*1;
  149.  
  150.    
  151.     netTotal = GoodsTotal+DeliCharge*1;
  152.  
  153.  
  154.  
  155.     VAT = (netTotal/100)*20;
  156.  
  157.  
  158.     grossTotal= netTotal+VAT*1;
  159.     GoodsTotal =GoodsTotal.toFixed(2);
  160.     netTotal = netTotal.toFixed(2);
  161.     VAT = VAT.toFixed(2);
  162.     grossTotal = grossTotal.toFixed(2);
  163.     form.NetTotal.value=netTotal;
  164.     form.GrossTotal.value=grossTotal;
  165.     form.GoodsTotal.value=GoodsTotal;
  166.     form.VAT.value=VAT;
  167. }  
  168.  
  169.  
  170. </script>
  171. Supplier:<br>
  172. <input name="Supplier" type=text"><br>
  173. Who are you?<br>
  174. <select name="Sender">
  175. <option value="Graham Winterbone">Graham Winterbone</option>
  176. <option value="Hillary Bliek">Hillary Bliek</option>
  177. <option value="Daren Cooper">Daren Cooper</option>
  178. </select><br>
  179. Customer Order Number:<br>
  180. <input name="CustOrderNo" type="text"><br>
  181. TP Order Number:<br>
  182. <input name="TpOrdNo" type="text"><br>
  183. Invoice Address:<br>
  184. <input name="InvAddress1" type="text" <?php echo"value='"; echo $row['InvAddress1']; echo "'";?>><br>
  185. <input name="InvAddress2" type="text" <?php echo"value='"; echo $row['InvAddress2']; echo "'";?>><br>
  186. <input name="InvAddress3" type="text" <?php echo"value='"; echo $row['InvAddress3']; echo "'";?>><br>
  187. <input name="InvAddress4" type="text" <?php echo"value='"; echo $row['InvAddress4']; echo "'";?>><br>
  188. <input name="InvAddress5" type="text" <?php echo"value='"; echo $row['InvAddress5']; echo "'";?>><br>
  189. Delivery Address:<br>
  190. <input name="DeliAddress1" type="text" <?php echo"value='"; echo $row['DeliAddress1']; echo "'";?>><br>
  191. <input name="DeliAddress2" type="text" <?php echo"value='"; echo $row['DeliAddress2']; echo "'";?>><br>
  192. <input name="DeliAddress3" type="text" <?php echo"value='"; echo $row['DeliAddress3']; echo "'";?>><br>
  193. <input name="DeliAddress4" type="text" <?php echo"value='"; echo $row['DeliAddress4']; echo "'";?>><br>
  194. <input name="DeliAddress5" type="text" <?php echo"value='"; echo $row['DeliAddress5']; echo "'";?>><br>
  195. Consignor:<br>
  196. <input name="Consignor" type="text" value="TUFFNELLS"><br>
  197. Site Contact Name:
  198. <input name="SiteContactName"><br>
  199. Contact Telephone:
  200. <input name="SiteContactTelephone"><br>
  201. Have you taken the card details?<br>
  202. Have you checked the account on the list?<br>
  203. Date:
  204. <input name="Date" value="<?php echo date("d.m.y");?>"><br>
  205. <input name="submit" value="Submit" type="submit"></center>
  206. </body>
  207. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!