Guest User

Untitled

a guest
Jul 16th, 2018
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.63 KB | None | 0 0
  1. <div class="form-group" >
  2. <label for="" class="col-sm-2 control-label"><h4><b>Vendor</b></h4> </label>
  3.  
  4. <div class="col-sm-3" align="right">
  5. <select class="form-control" id="vendor" name="vendor" required>
  6. <option value="">Please Select Vendor</option>
  7. </select>
  8.  
  9. </div>
  10. </div>
  11.  
  12. <div class="col-sm-3" >
  13. <div class="form-group">
  14. <label for="" class="col-sm-2 control-label">Purchase Date</label>
  15.  
  16. <input type="date" class="form-control" id="start_date" name="p_date" placeholder="Purchase Date" required>
  17. </div>
  18. </div>
  19. </div>
  20.  
  21. <div class="col-sm-4">
  22. <div class="col s12 m6 offset-m4">
  23. <div class="form-group" align="left">
  24. <label class="form-label">Total</label>
  25. <input type="text" class="form-control" placeholder="Total" id="total" name="total" size="30px" required="">
  26. </div>
  27.  
  28. <div class="form-group" align="left">
  29. <label class="form-label">Pay</label>
  30. <input type="text" class="form-control" placeholder="Balance" id="pay" name="pay" size="30px" required="">
  31. </div>
  32.  
  33. <div class="form-group" align="left">
  34. <label class="form-label">Due</label>
  35. <input type="text" class="form-control" placeholder="Due" id="due" name="due" size="30px" required="">
  36. </div>
  37. <div class="form-group" align="left">
  38. <label class="col-sm-2 control-label">Status</label>
  39.  
  40.  
  41. <select class="form-control" id="payment" name="payment"
  42. placeholder="Project Status" required>
  43. <option value="">Please Select</option>
  44. <option value="1">Cash</option>
  45.  
  46. <option value="2">Cheque</option>
  47. </select>
  48. </div>
  49.  
  50.  
  51. <div class="card" align="right">
  52.  
  53. <button type="button" id="save" class="btn btn-info" onclick="addProject()">Add
  54. </button>
  55. <button type="button" id="clear" class="btn btn-warning" onclick="reSet()">Reset</button>
  56. </div>
  57. </form>
  58.  
  59. </div>
  60. </div>
  61.  
  62. function addProject() {
  63.  
  64. if ($("#frmProject").valid())
  65. {
  66. var _url = '';
  67. var _data = '';
  68. var _method;
  69. if (isNew == true) {
  70. _url = 'add_purchase.php';
  71. _data = $('#frmProject').serialize();
  72. _method = 'POST';
  73.  
  74. }
  75. else {
  76. _url = 'update_project.php',
  77. _data = $('#frmProject').serialize() + "&project_id=" + project_id;
  78. _method = 'POST';
  79. }
  80. $.ajax({
  81. type: _method,
  82. url: _url,
  83. dataType: 'JSON',
  84. data: _data,
  85. beforeSend: function () {
  86.  
  87. $('#save').prop('disabled', true);
  88. $('#save').html('');
  89. $('#save').append('<i class="fa fa-spinner fa-spin fa-1x fa-fw"></i>Saving</i>');
  90. },
  91. success: function (data) {
  92. $('#frmProject')[0].reset();
  93. $('#save').prop('disabled', false);
  94. $('#save').html('');
  95. $('#save').append('Add');
  96. // get_all();
  97. var msg;
  98. if (isNew)
  99. {
  100. msg="Registation Successfully Created";
  101. }
  102. else{
  103. msg="Registation Successfully Updated";
  104.  
  105. }
  106. $.alert({
  107. title: 'Success!',
  108. content: msg,
  109. type: 'green',
  110. boxWidth: '400px',
  111. theme: 'light',
  112. useBootstrap: false,
  113. autoClose: 'ok|2000'
  114. });
  115. isNew = true;
  116. },
  117. error: function (xhr, status, error) {
  118. alert(xhr);
  119. console.log(xhr.responseText);
  120.  
  121. $.alert({
  122. title: 'Fail!',
  123. // content: xhr.responseJSON.errors.product_code + '<br>' + xhr.responseJSON.msg,
  124. type: 'red',
  125. autoClose: 'ok|2000'
  126.  
  127. });
  128. $('#save').prop('disabled', false);
  129. $('#save').html('');
  130. $('#save').append('Save');
  131.  
  132. }
  133. });
  134. }
  135. }
  136.  
  137. <?php
  138.  
  139. $servername = "localhost";
  140. $username = "root";
  141. $password = "";
  142. $dbname = "upos";
  143. // Create connection
  144. $conn = new mysqli($servername, $username, $password, $dbname);
  145. // Check connection
  146. if ($conn->connect_error) {
  147. die("Connection failed: " . $conn->connect_error);
  148. }
  149. if ($_SERVER['REQUEST_METHOD'] == 'POST') {
  150. $stmt = $conn->prepare("INSERT INTO purchase (vendor_id,date,barcode,total,pay,due,payment_type)
  151. VALUES (?,?,?,?,?,?,?)");
  152. $stmt->bind_param("sssssss", $vendor_id,$date,$barcode,$total,$pay,$due,$payment_type);
  153. $vendor_id = $_POST["vendor"];
  154. $date= $_POST["p_date"];
  155. $barcode = $_POST["barcode"];
  156. $total= $_POST["total"];
  157. $grand_total = $_POST["pay"];
  158. $pay= $_POST["due"];
  159. $payment_type = $_POST["payment"];
  160.  
  161. if ($stmt->execute()) {
  162.  
  163. echo 1;
  164. } else {
  165. echo 0;
  166. }
  167. $result =$stmt->get_result();
  168. $invoice_no = $result->insert_id;
  169.  
  170. $stmt->close();
  171. }
  172.  
  173. ?>
Add Comment
Please, Sign In to add comment