API tools faq
paste
Advertisement
Guest User

ubah

a guest
Jan 18th, 2019
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.53 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include("../../api/db_config.php");
  3. ?>
  4. <?php
  5.  
  6. if (isset($_POST['btn_simpan'])){
  7.  
  8. $id = $_POST['id_productgroup'];
  9. $name = $_POST['productgroup_name'];
  10. $info = $_POST['productgroup_info'];
  11. $status = $_POST['productgroup_status'];
  12. $indputdate = "$datetime_set";
  13.  
  14.  
  15. if(!empty($name) && !empty($info) && !empty($status)){
  16. $sql_productgroup = "INSERT INTO mproduct_group (id_productgroup, productgroup_name, productgroup_info, productgroup_status, inputdate)
  17. values('$id', '$name', '$info','$status','$inputdate')";
  18. $cek= mysqli_query($con,$sql_productgroup);
  19. if($cek && isset($_GET['aksi'])){
  20. if($_GET['aksi'] == 'create'){
  21. header('location: master_product_group.php');
  22. }
  23. }
  24. } else {
  25. $pesan = "Tidak dapat menyimpan, data belum lengkap!";
  26. }
  27. }
  28.  
  29. ?>
  30.  
  31.  
  32. <!DOCTYPE html>
  33. <html>
  34. <head>
  35.  
  36. <link rel="shortcut icon" href="../../assets/images/favicon_1.ico">
  37.  
  38. <title>Product Group</title>
  39.  
  40. <!-- DataTables -->
  41. <link href="../../assets/plugins/datatables/jquery.dataTables.min.css" rel="stylesheet" type="text/css"/>
  42. <link href="../../assets/plugins/datatables/buttons.bootstrap.min.css" rel="stylesheet" type="text/css"/>
  43. <link href="../../assets/plugins/datatables/fixedHeader.bootstrap.min.css" rel="stylesheet" type="text/css"/>
  44. <link href="../../assets/plugins/datatables/responsive.bootstrap.min.css" rel="stylesheet" type="text/css"/>
  45. <link href="../../assets/plugins/datatables/scroller.bootstrap.min.css" rel="stylesheet" type="text/css"/>
  46. <link href="../../assets/plugins/datatables/dataTables.colVis.css" rel="stylesheet" type="text/css"/>
  47. <link href="../../assets/plugins/datatables/dataTables.bootstrap.min.css" rel="stylesheet" type="text/css"/>
  48. <link href="../../assets/plugins/datatables/fixedColumns.dataTables.min.css" rel="stylesheet" type="text/css"/>
  49.  
  50.  
  51. <link href="../../assets/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
  52. <link href="../../assets/css/core.css" rel="stylesheet" type="text/css"/>
  53. <link href="../../assets/css/components.css" rel="stylesheet" type="text/css"/>
  54. <link href="../../assets/css/icons.css" rel="stylesheet" type="text/css"/>
  55. <link href="../../assets/css/pages.css" rel="stylesheet" type="text/css"/>
  56. <link href="../../assets/css/responsive.css" rel="stylesheet" type="text/css"/>
  57. <link href="../../assets/plugins/custombox/css/custombox.css" rel="stylesheet">
  58.  
  59. <script src="../../assets/js/modernizr.min.js"></script>
  60.  
  61. </head>
  62.  
  63. <body class="fixed-left">
  64.  
  65. <!-- Begin page -->
  66. <div id="wrapper">
  67.  
  68. <!-- Top Bar Start -->
  69. <?php include "part/main_header.php"; ?>
  70. <!-- Top Bar End -->
  71.  
  72.  
  73. <!-- ========== Lef t Sidebar Start ========== -->
  74. <?php include "part/main_side.php"; ?>
  75. <!-- Left Sidebar End -->
  76.  
  77.  
  78. <!-- ============================================================== -->
  79. <!-- Start right Content here -->
  80. <!-- ============================================================== -->
  81. <div class="content-page">
  82. <!-- Start content -->
  83. <div class="content">
  84. <div class="container">
  85.  
  86. <!-- Page-Title -->
  87. <div class="row">
  88. <?php
  89. $action=$_GET["actn"];
  90. if($action=="update"){
  91.  
  92.  
  93. ?>
  94. <?php
  95. if(isset($_POST['btn_ubah'])){
  96. $id = $_GET['id_productgroup'];print_r($id);die();
  97.  
  98.  
  99.  
  100. $update = mysqli_query($con,"SELECT * FROM instructor WHERE id_productgroup='$id'");
  101. $data = mysqli_fetch_array($update);
  102. if($data && isset($_GET['aksi'])){
  103. if($_GET['aksi'] == 'update'){
  104. header('location: master_product_group.php');
  105. }
  106. }
  107.  
  108. }
  109.  
  110.  
  111. ?>
  112. <!-- Update -->
  113. <div class="row">
  114. <div class="col-sm-8">
  115. <div class="card-box">
  116. <form action="#" data-parsley-validate novalidate>
  117. <div class="row">
  118. <div class="col-md-8">
  119. <div class="form-group">
  120. <label for="field-1" class="control-label">Edit Product Group</label>
  121. <input type="text" name="productgroup_name" value="<?php echo $data['productgroup_name'] ?>" class="form-control" id="field-1" placeholder="" required parsley-trigger="change">
  122. </div>
  123. </div>
  124. <div class="col-md-4">
  125. <div class="form-group">
  126. <label for="field-1" class="control-label">Active Status</label>
  127. <input type="text" name="productgroup_status" value="<?php echo $data['productgroup_status'] ?>" class="form-control" id="field-1" placeholder="" required parsley-trigger="change">
  128. </div>
  129. </div>
  130. <div class="col-md-12">
  131. <div class="form-group text-left m-b-0">
  132. <button name="btn_ubah " class="btn btn-sm w-sm btn-default waves-effect waves-light" type="submit">
  133. Save</button>
  134. <button type="button" onclick="goBack()" class="btn btn-primary btn-sm w-sm waves-effect waves-light m-l-5">
  135. Back</button>
  136. </div>
  137. </div>
  138. </div>
  139. </form>
  140. </div>
  141. </div>
  142. </div>
  143.  
  144. <?php
  145. }else{
  146. ?>
  147.  
  148.  
  149. <div class="col-sm-8">
  150. <div class="card-box">
  151. <form method="POST" action="" data-parsley-validate novalidate >
  152. <div class="row">
  153. <div class="col-md-8">
  154. <div class="form-group">
  155. <label for="field-1" class="control-label">Add Product Group</label>
  156. <input type="text" name="productgroup_name" class="form-control" id="field-1" placeholder="" required parsley-trigger="change">
  157. </div>
  158. </div>
  159.  
  160. <div class="col-md-3">
  161. <div class="form-group">
  162. <label for="field-1" class="control-label">Product Group Info</label>
  163. <input type="text" name="productgroup_info" class="form-control" id="field-1" placeholder="" required parsley-trigger="change">
  164. </div>
  165. </div>
  166. <div class="col-md-4">
  167. <div class="form-group">
  168. <label for="field-1" class="control-label">Active Status</label>
  169. <select class="form-control select2" name="productgroup_status" id="field-7" parsley-trigger="change" required>
  170. <option value="enable">Enable</option>
  171. <option value="disable">Disable</option>
  172. </select>
  173. </div>
  174. </div>
  175.  
  176. <div class="col-md-12">
  177. <div class="form-group text-left m-b-0">
  178. <button type="submit" name="btn_simpan" class="btn w-md btn-default waves-effect waves-light"> Save</button>
  179. <button type="reset" class="btn btn-sm w-sm waves-effect waves-light m-l-5">
  180. Clear</button>
  181. </div>
  182. </div>
  183. </div>
  184. </form>
  185. <p><?php echo isset($pesan) ? $pesan : "" ?></p>
  186. </div>
  187. </div>
  188.  
  189.  
  190. <?php
  191. }
  192. ?>
  193. <!-- Table Product Group -->
  194. <div class="row">
  195. <div class="col-sm-12">
  196. <div class="card-box table-responsive">
  197. <form method="GET">
  198. <table id="datatable-responsive"
  199. class="table table-striped table-bordered dt-responsive nowrap" cellspacing="0"
  200. width="100%">
  201. <thead>
  202. <tr>
  203. <th></th>
  204. <th>Product Group</th>
  205. <th>Active</th>
  206. <th class="text-center">Action</th>
  207. </tr>
  208. </thead>
  209. <tbody>
  210. <?php
  211.  
  212.  
  213. include "api/db_config.php";
  214. $data = mysqli_query($con, "SELECT * FROM mproduct_group");
  215. $number = 1;
  216. while($rowpg=mysqli_fetch_array($data))
  217. {
  218. ?>
  219. <tr>
  220. <td>
  221. <a href="formproductgroup_create.php?group=">
  222. <button type="button" class="btn btn-xs btn-purple waves-effect waves-light"> <i class="fa fa-plus-square-o m-r-5"></i> <span>
  223. Add Product</span> </button>
  224. </a>
  225. </td>
  226. <td><?php echo $rowpg['productgroup_name'] ?></td>
  227. <td><?php echo $rowpg['productgroup_info'] ?></td>
  228. <td class="text-center"><?php echo $rowpg['active'] ?>
  229.  
  230. <a href="master_product_group.php?actn=update&id=<?php echo $rowpg['id_productgroup']; ?>">
  231. <button type="button" class="btn btn-xs btn-warning waves-effect waves-light"> <i class="fa fa-edit m-r-5"></i> <span>
  232. Edit</span> </button>
  233. </a>
  234. <a href="master_product_group.php?actn=delete&id=<?php echo $rowpg['id_productgroup']; ?>">
  235. <button type="button" class="btn btn-xs btn-danger waves-effect waves-light"> <i class="fa fa-trash m-r-5"></i> <span>
  236. Delete</span> </button>
  237. </td>
  238. </a>
  239. </tr>
  240. <?php
  241. }
  242.  
  243. ?>
  244.  
  245. </tbody>
  246. </table>
  247. </form>
  248. </div>
  249. </div>
  250. </div>
  251. <!-- end row -->
  252.  
  253.  
  254.  
  255.  
  256.  
  257.  
  258.  
  259.  
  260.  
  261.  
  262.  
  263. </div> <!-- container -->
  264. </div> <!-- content -->
  265. <!-- footer -->
  266. <?php include "../../footer.php"; ?>
  267. </div>
  268. <!-- ============================================================== -->
  269. <!-- End Right content here -->
  270. <!-- ============================================================== -->
  271. </div>
  272. <!-- END wrapper -->
  273.  
  274. <script>
  275. var resizefunc = [];
  276. </script>
  277.  
  278. <!-- jQuery -->
  279. <script src="../../assets/js/jquery.min.js"></script>
  280. <script src="../../assets/js/bootstrap.min.js"></script>
  281. <script src="../../assets/js/detect.js"></script>
  282. <script src="../../assets/js/fastclick.js"></script>
  283. <script src="../../assets/js/jquery.slimscroll.js"></script>
  284. <script src="../../assets/js/jquery.blockUI.js"></script>
  285. <script src="../../assets/js/waves.js"></script>
  286. <script src="../../assets/js/wow.min.js"></script>
  287. <script src="../../assets/js/jquery.nicescroll.js"></script>
  288. <script src="../../assets/js/jquery.scrollTo.min.js"></script>
  289.  
  290. <!-- Modal-Effect -->
  291. <script src="../../assets/plugins/custombox/js/custombox.min.js"></script>
  292. <script src="../../assets/plugins/custombox/js/legacy.min.js"></script>
  293.  
  294. <script src="../../assets/plugins/datatables/jquery.dataTables.min.js"></script>
  295. <script src="../../assets/plugins/datatables/dataTables.bootstrap.js"></script>
  296.  
  297. <script src="../../assets/plugins/datatables/dataTables.buttons.min.js"></script>
  298. <script src="../../assets/plugins/datatables/buttons.bootstrap.min.js"></script>
  299. <script src="../../assets/plugins/datatables/jszip.min.js"></script>
  300. <script src="../../assets/plugins/datatables/pdfmake.min.js"></script>
  301. <script src="../../assets/plugins/datatables/vfs_fonts.js"></script>
  302. <script src="../../assets/plugins/datatables/buttons.html5.min.js"></script>
  303. <script src="../../assets/plugins/datatables/buttons.print.min.js"></script>
  304. <script src="../../assets/plugins/datatables/dataTables.fixedHeader.min.js"></script>
  305. <script src="../../assets/plugins/datatables/dataTables.keyTable.min.js"></script>
  306. <script src="../../assets/plugins/datatables/dataTables.responsive.min.js"></script>
  307. <script src="../../assets/plugins/datatables/responsive.bootstrap.min.js"></script>
  308. <script src="../../assets/plugins/datatables/dataTables.scroller.min.js"></script>
  309. <script src="../../assets/plugins/datatables/dataTables.colVis.js"></script>
  310. <script src="../../assets/plugins/datatables/dataTables.fixedColumns.min.js"></script>
  311.  
  312. <script src="../../assets/pages/datatables.init.js"></script>
  313.  
  314. <script type="text/javascript" src="../../assets/plugins/parsleyjs/parsley.min.js"></script>
  315.  
  316. <script src="../../assets/js/jquery.core.js"></script>
  317. <script src="../../assets/js/jquery.app.js"></script>
  318.  
  319. <script src="../../assets/js/function.js"></script>
  320.  
  321. <script type="text/javascript">
  322. $(document).ready(function () {
  323. $('#datatable').dataTable();
  324. $('#datatable-keytable').DataTable({keys: true});
  325. $('#datatable-responsive').DataTable();
  326. $('#datatable-colvid').DataTable({
  327. "dom": 'C<"clear">lfrtip',
  328. "colVis": {
  329. "buttonText": "Change columns"
  330. }
  331. });
  332. $('#datatable-scroller').DataTable({
  333. ajax: "../../assets/plugins/datatables/json/scroller-demo.json",
  334. deferRender: true,
  335. scrollY: 380,
  336. scrollCollapse: true,
  337. scroller: true
  338. });
  339. var table = $('#datatable-fixed-header').DataTable({fixedHeader: true});
  340. var table = $('#datatable-fixed-col').DataTable({
  341. scrollY: "300px",
  342. scrollX: true,
  343. scrollCollapse: true,
  344. paging: false,
  345. fixedColumns: {
  346. leftColumns: 1,
  347. rightColumns: 1
  348. }
  349. });
  350. });
  351. TableManageButtons.init();
  352. </script>
  353.  
  354. <script>
  355. function goBack() {
  356. window.history.back();
  357. }
  358. </script>
  359.  
  360. </body>
  361. </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!