API tools faq
paste
averil87

salesorder

averil87
Feb 23rd, 2012
31
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.77 KB | None | 0 0
raw download clone embed print report
  1. sales_add.php
  2.  
  3. <?php
  4. require_once 'sales.php';
  5. require_once 'function.php';
  6.  
  7. ?>
  8.  
  9. <html>
  10. <title>JUNAA TAILORING | Create Profile</title>
  11.  
  12. <body>
  13. <!--Header -->
  14. <?php include('templates/header/header.php'); ?>
  15. <!-- Navigation Bar -->
  16. <?php include('templates/navigationBar/navigationbar.php'); ?>
  17.  
  18.  
  19. <!-- Center -->
  20. <?php include('templates/leftAdmin/list.php'); ?>
  21. </table>
  22. <td width="800px" height="550px">
  23. <table width="799px" height="549px"VALIGN="top">
  24. <tr style="font-size:18px; font-weight:bold; text-align:left; color:yellow; height:25px; background:url('midbar1.jpg')">
  25. <td VALIGN="top" ALIGN="center" >Create Sales</td>
  26. </tr>
  27. <tr>
  28. <td VALIGN="top" ALIGN="left">
  29.  
  30. <form method="post" action="sales.php">
  31.  
  32. <table border="0" width="100%" cellpadding="2" cellspacing="1">
  33. <tr>
  34. <td>Ic/Passport</td>
  35. <td>: <input name="cust_ic_passport" type="text" size="20" /></td>
  36. <td>Sales Due Date</td>
  37. <td>: <input name="sales_due_date" type="text" size="20" />YYYYMMDD</td>
  38. </tr>
  39. <tr>
  40. <td>Sales Deposit</td>
  41. <td>: <input name="sales_deposit" type="text" size="20"/></td>
  42. <td>Cloth Tag</td>
  43. <td>: <input name="sales_cloth_tag" type="text" size="20"/></td>
  44. </tr>
  45. <tr>
  46. <td>Description</td>
  47. <td colspan="3">: <input name="sales_desc" type="text" size="110" /></td>
  48. </tr>
  49. </table>
  50.  
  51. <fieldset>
  52. <legend>Order Details:</legend>
  53. <table border="0" width="100%" cellpadding="2" cellspacing="1">
  54. <tr>
  55. <td>No</td>
  56. <td>Category ID</td>
  57. <td>Price</td>
  58. <td>Quantity</td>
  59. <td>Subtotal</td>
  60. </tr>
  61. <?php $i=1;
  62. while($i<=5) {?>
  63. <tr>
  64. <td><?php echo $i; ?></td>
  65. <td><input name="category_id[]" type="text" size="20" /></td>
  66. <td><input name="salesOrder_price[]" type="text" size="20" /></td>
  67. <td><input name="salesOrder_quantity[]" type="text" size="20" /></td>
  68. </tr>
  69. <?php $i++; } ?>
  70. </table>
  71. </fieldset>
  72.  
  73. <input type="hidden" name="action" value="create" />
  74. <input type="submit" value="Save" />
  75. <input type="button" value="Cancel" onClick="location.href='sales_list.php'" />
  76. </form>
  77. </td>
  78. </tr>
  79. </table>
  80. </td>
  81.  
  82. <?php include('templates/rightsidebar.php'); ?>
  83.  
  84.  
  85. <!-- Footer -->
  86. <?php include('templates/footer/footer.php'); ?>
  87.  
  88. </td>
  89. </tr>
  90. </table>
  91. </body>
  92. </html>
  93.  
  94. sales.php
  95.  
  96. <?php
  97. require_once 'database.php';
  98.  
  99. class Sales
  100. {
  101. private $db;
  102. protected $cust_ic_passport;
  103. protected $cust_name;
  104. protected $sales_date;
  105. protected $sales_due_date;
  106. protected $sales_desc;
  107. protected $sales_cloth_tag;
  108. protected $sales_deposit;
  109. protected $sales_balance;
  110. protected $sales_order_status;
  111. protected $sales_payment_status;
  112. protected $sales_total;
  113.  
  114.  
  115. public function __construct()
  116. {
  117. $this->db = new Database();
  118. $this->cust_ic_passport = addslashes($_POST['cust_ic_passport']);
  119. $this->cust_name = addslashes($_POST['cust_name']);
  120. $this->sales_date = addslashes($_POST['sales_date']);
  121. $this->sales_due_date = addslashes($_POST['sales_due_date']);
  122. $this->sales_total = addslashes($_POST['sales_desc']);
  123. $this->sales_deposit = addslashes($_POST['sales_cloth_tag']);
  124. $this->sales_deposit = addslashes($_POST['sales_deposit']);
  125. $this->sales_balance = addslashes($_POST['sales_balance']);
  126. $this->sales_order_status = addslashes($_POST['sales_order_status']);
  127. $this->sales_payment_status = addslashes($_POST['sales_payment_status']);
  128. $this->salesOrder_id = addslashes($_POST['salesOrder_id']);
  129. $this->category_id = addslashes($_POST['category_id']);
  130. $this->category_name = addslashes($_POST['category_name']);
  131. $this->salesOrder_quantity = addslashes($_POST['salesOrder_quantity']);
  132. $this->salesOrder_subtotal = addslashes($_POST['salesOrder_subtotal']);
  133. $this->salesOrder_total = addslashes($_POST['salesOrder_total']);
  134. }
  135.  
  136. public function createSales()
  137. {
  138. $default_order_status = 'pending';
  139. $default_payment_status = 'pending';
  140. $sales_balance= 'sales_total - sales_deposit';
  141. $sql = "INSERT INTO sales (cust_ic_passport, cust_name, sales_date, sales_due_date, sales_desc, sales_cloth_tag, sales_deposit, sales_balance, sales_order_status, sales_payment_status) VALUES ('$_POST[cust_ic_passport]','$_POST[cust_name]','CURDATE()','$_POST[sales_due_date]','$_POST[sales_desc]','$_POST[sales_cloth_tag]','$_POST[sales_deposit]','$_POST[sales_balance]','$default_order_status','$default_payment_status')";
  142. return $this->db->runSQL($sql);
  143.  
  144. $last_insert_sales_id = mysql_insert_id();
  145.  
  146. $subtotal= 'salesOrder_price * salesOrder_quantity';
  147.  
  148. $sql = "INSERT INTO salesOrder (salesOrder_id, category_id, category_name, salesOrder_quantity, salesOrder_price, salesOrder_subtotal, salesOrder_total, sales_id) VALUES ('', '$_POST[category_id]','$_POST[category_name]','$_POST[salesOrder_quantity]','$_POST[salesOrder_price]','$_POST[salesOrder_subtotal]','$_POST[salesOrder_total]','$last_insert_sales_id')";
  149. return $this->db->runSQL($sql);
  150.  
  151. }
  152.  
  153. public function updateSales($sales_id)
  154. {
  155. $sql = 'UPDATE sales SET ';
  156.  
  157. $sql .= 'cust_ic_passport = "'.$this->cust_ic_passport.'", ';
  158. $sql .= 'cust_name = "'.$this->cust_name.'", ';
  159. $sql .= 'sales_date = "'.$this->sales_date.'", ';
  160. $sql .= 'sales_due_date = "'.$this->sales_due_date.'", ';
  161. $sql .= 'sales_total = "'.$this->sales_total.'", ';
  162. $sql .= 'sales_deposit = "'.$this->sales_deposit.'", ';
  163. $sql .= 'sales_balance = "'.$this->sales_balance.'", ';
  164. $sql .= 'sales_order_status = "'.$this->sales_order_status.'", ';
  165. $sql .= 'sales_payment_status = "'.$this->sales_payment_status.'", ';
  166. $sql .= 'salesOrder_no = "'.$this->salesOrder_no.'" ';
  167.  
  168. $sql .= 'WHERE sales_id = "'.$_GET['sales_id'].'";';
  169. $this->db->runSQL($sql);
  170. }
  171.  
  172. public function deleteSales($sales_id)
  173. {
  174. $sql = 'DELETE FROM sales WHERE sales_id = "'.$sales_id.'";';
  175. return $this->db->runSQL($sql);
  176. }
  177.  
  178. public function getSalesList()
  179. {
  180. $sql = 'SELECT sales.*, salesOrder.salesOrder_id, salesOrder.salesOrder_quantity, salesOrder.salesOrder_subtotal, salesOrder.salesOrder_total, category.category_id, category.category_name, customer.cust_ic_passport, customer.cust_name FROM sales INNER JOIN salesOrder ON sales.sales_id = salesOrder.sales_id INNER JOIN category ON salesOrder.category_id = category.category_id INNER JOIN customer ON sales.cust_ic_passport = customer.cust_ic_passport;';
  181.  
  182. return $this->db->runSQL($sql);
  183. }
  184.  
  185. public function getSalesProfile($sales_id = '')
  186. {
  187. $sql = 'SELECT * FROM sales WHERE sales_id = "'.$sales_id.'";';
  188. $this->db->runSQL($sql);
  189. $result = mysql_query($sql);
  190. return mysql_fetch_assoc($result);
  191. }
  192.  
  193. }
  194.  
  195.  
  196. $sales = new Sales();
  197. switch ($_POST['action'])
  198. {
  199. case 'create':
  200. $sales-> createSales();
  201. header('Location: sales_list.php');
  202. exit;
  203. break;
  204.  
  205. case 'update':
  206. $sales-> updateSales($_GET['sales_id']);
  207. header('Location: sales_list.php');
  208. break;
  209.  
  210. case 'delete':
  211. foreach ($_POST['sales_id'] as $id)
  212. {
  213. $sales-> deleteSales($id);
  214. }
  215.  
  216. header('Location: sales_list.php');
  217. break;
  218. }
  219. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!