customersDetails.php 4.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
  1. <div class="container-fluid">
  2. <div class="row">
  3. <div class="col-sm-6">
  4. <button class="btn btn-primary" onclick="document.getElementById('addForm').style.display = 'block';document.getElementById('editForm').style.display = 'none';document.getElementById('editVForm').style.display = 'none';document.getElementById('addVForm').style.display = 'none';document.getElementById('deleteForm').style.display = 'none';"> Add Customer </button>
  5. <table id="example" class="table display table-striped table-bordered table-hover table-sm" cellspacing="0" width="100%">
  6. <thead>
  7. <tr>
  8. <th></th>
  9. <th></th>
  10. <th>Id</th>
  11. <th>Name</th>
  12. <th>Credit Sale</th>
  13. </tr>
  14. </thead>
  15. <tfoot>
  16. <tr>
  17. <th></th>
  18. <th></th>
  19. <th>Id</th>
  20. <th>Name</th>
  21. <th>Credit Sale</th>
  22. </tr>
  23. </tfoot>
  24. </table>
  25. </div>
  26. <div class="col-sm-6">
  27. <!-- <input type="number" name="" id="loadVehicles"> -->
  28. <?php include "vehiclesVw.php" ?>
  29. <?php include "vehiclesDetails.php" ?>
  30. </div>
  31. </div>
  32. </div>
  33. <?php include "addCustomer.php" ?>
  34. <?php include "Edit.php" ?>
  35. <?php include "Delete.php" ?>
  36. <?php include "editVehicle.php" ?>
  37. <?php include "addVehicle.php" ?>
  38. <?php include "deleteVehicle.php" ?>
  39. <script type="text/javascript">
  40. $(document).ready(function() {
  41. var table = $('#example').DataTable( {
  42. "buttons": true,
  43. "ajax": "api/v1/Customers/customers.txt",
  44. "columns": [
  45. {
  46. "className": 'delete',
  47. "orderable": false,
  48. "data": null,
  49. "defaultContent": 'Delete'
  50. },
  51. {
  52. "className": 'edit',
  53. "orderable": false,
  54. "data": null,
  55. "defaultContent": 'Edit'
  56. },
  57. { "data": "Customer_Id" },
  58. { "data": "Name",
  59. "className":'name'
  60. },
  61. { "data": "Credit_Sale" },
  62. //{ "data": "Id" },
  63. //{ "data": "Number" },
  64. ],
  65. "order": [[1, 'asc']],
  66. select: true
  67. } );
  68. // Add event listener for opening and closing details
  69. $('#example tbody').on('click', 'td.name', function () {
  70. var tr = $(this).closest('tr');
  71. var row = table.row( tr );
  72. var username = table.row( this ).data()['Name'];
  73. var idForVehicle = table.row( this ).data()['Customer_Id'];
  74. document.cookie = "customerId="+idForVehicle;
  75. document.cookie = "customerName="+username;
  76. //document.getElementById('loadVehicles').value = idForVehicle;
  77. //console.log( table.row( this ).data() );
  78. //alert( table.row( this ).data()['Customer_Id'] );
  79. //location.reload();
  80. window.location.href = 'index.php';
  81. } );
  82. // Add event listener for opening and closing details
  83. $('#example tbody').on('click', 'td.delete', function () {
  84. var tr = $(this).closest('tr');
  85. var row = table.row( tr );
  86. var username = table.row( this ).data()['Name'];
  87. var id = table.row( this ).data()['Customer_Id'];
  88. document.getElementById('deleteid').value = id;
  89. document.getElementById('deleteForm').style.display = 'block';
  90. document.getElementById('editForm').style.display = 'none';
  91. document.getElementById('addForm').style.display = 'none';
  92. } );
  93. // Add event listener for opening and closing details
  94. $('#example tbody').on('click', 'tr td.edit', function () {
  95. var tr = $(this).closest('tr');
  96. var row = table.row( tr );
  97. // console.log( table.row( this ).data() );
  98. // alert( table.row( this ).data()['Name'] );
  99. var username = table.row( this ).data()['Name'];
  100. var creditSale = table.row( this ).data()['Credit_Sale'];
  101. var id = table.row( this ).data()['Customer_Id'];
  102. document.getElementById('username').value = username;
  103. document.getElementById('id').value = id;
  104. //document.getElementById('vehicle_id').value = vehicle_id;
  105. //document.getElementById('number').value = number;
  106. if (creditSale=='Yes') {
  107. document.getElementById('creditSaleOn').checked = true;
  108. }else if(creditSale=='No'){
  109. document.getElementById('creditSaleOff').checked = true;
  110. }
  111. document.getElementById('editForm').style.display = 'block';
  112. document.getElementById('addForm').style.display = 'none';
  113. document.getElementById('deleteForm').style.display = 'none';
  114. } );
  115. } );
  116. </script>