API tools faq
paste
Advertisement
amirhusin17

add department

amirhusin17
Feb 20th, 2019
110
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.06 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3.  
  4. if(!isset($_SESSION["admin_name"])){
  5. header("location:login.php");
  6. }
  7.  
  8. include ("../connection.php");
  9.  
  10. $msg = "";
  11. $department_id = "";
  12. $customer_id = "";
  13. $department = "";
  14. $unit = "";
  15. $block = "";
  16. $level = "";
  17. $dpquota = "";
  18.  
  19. if(isset($_GET["edit_id"])){
  20. $qe = mysqli_query($con, "SELECT * FROM jabatan WHERE jabatan_id ='".mres($con, $_GET["edit_id"])."'");
  21. while($row=mysqli_fetch_array($qe,MYSQLI_ASSOC)){
  22. $department_id = $row["jabatan_id"];
  23. $customer_id = $row["customer_id"];
  24. $department = $row["jabatan"];
  25. $dpquota = $row["peruntukan_bulanan"];
  26. }
  27. }
  28.  
  29. if(isset($_POST["btn_save"])){
  30. $customer_id = mres($con, $_POST["unit"]);
  31. $department = mres($con, $_POST["department"]);
  32. $unit = mres($con, $_POST["unit"]);
  33. $block = mres($con, $_POST["block"]);
  34. $level = mres($con, $_POST["level"]);
  35. $dpquota = mres($con, $_POST["dpquota"]);
  36.  
  37. $qry = mysqli_query($con, "INSERT INTO jabatan values('','".$customer_id."','".$department."','".$block."','".$level."','".$unit."','".$dpquota."')");
  38.  
  39. if($qry){
  40. $msg = '<div id="login-alert" class="alert alert-success col-sm-12">Success! Data Is Inserted.</div>';
  41. }else{
  42. $msg = '<div id="login-alert" class="alert alert-danger col-sm-12">Fail! Data cannot inserted.</div>';
  43. }
  44.  
  45. }
  46.  
  47. if(isset($_POST["btn_edit"])){
  48. $customer_id = mres($con, $_POST["unit"]);
  49. $department = mres($con, $_POST["department"]);
  50. $unit = mres($con, $_POST["unit"]);
  51. $block = mres($con, $_POST["block"]);
  52. $level = mres($con, $_POST["level"]);
  53. $dpquota = mres($con, $_POST["dpquota"]);
  54. $department_id = mres($con, $_POST["department_id"]);
  55.  
  56. $qry = mysqli_query($con, "UPDATE jabatan SET customer_id='".$customer_id."', jabatan='".$department."', unit='".$unit."', blok='".$block."', tingkat='".$level."', peruntukan_bulanan='".$dpquota."' where jabatan_id='".$department_id."'");
  57.  
  58. if($qry){
  59. $msg = '<div id="login-alert" class="alert alert-success col-sm-12">Success! Data Is Updated.</div>';
  60. }else{
  61. $msg = '<div id="login-alert" class="alert alert-danger col-sm-12">Fail! Data cannot Updated.</div>';
  62. }
  63.  
  64. }
  65. ?>
  66.  
  67.  
  68. <?php include ("header.php"); ?>
  69. <div class="row" style="padding-left: 0px; padding-right: 0px;">
  70. <div class="col-lg-3 col-md-3 col-sm-3 col-xs-12" style="padding-left: 0px; padding-right: 0px;">
  71. <?php include ("leftmenu.php"); ?>
  72. </div>
  73. <div class="col-lg-9 col-md-9 col-sm-9 col-xs-12">
  74. <div class="panel panel-info">
  75. <div class="panel-heading">
  76. <div class="panel-title">Add PPUKM Department Unit</div>
  77. </div>
  78. <div class="panel-body">
  79. <?php echo $msg; ?>
  80. <form id="form_unit" class="form-horizontal" action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
  81. <div style="margin-bottom: 25px" class="input-group">
  82. <input type="hidden" name="department_id" value="<?php echo $department_id; ?>">
  83. <span class="input-group-addon">Department Name</span>
  84. <input type="text" class="form-control" name="department" id="department" value="<?php echo $department; ?>" />
  85. </div>
  86. <div style="margin-bottom: 25px" class="input-group">
  87. <span class="input-group-addon">Year</span>
  88. <select type="text" class="form-control" name="year" id="year">
  89. <option value="">-- Select Year --</option>
  90. <?php
  91. $qry = mysqli_query($con, "SELECT * FROM tahun");
  92. while($row=mysqli_fetch_array($qry,MYSQLI_ASSOC)){
  93. echo '<option value="'.$row["tahun_id"].'">'.$row["tahun"].'</option>';
  94. }
  95. ?>
  96. </select>
  97. </div>
  98. <div style="margin-bottom: 25px" class="input-group">
  99. <span class="input-group-addon">Month</span>
  100. <select type="text" class="form-control" name="month" id="month">
  101. <option value="">-- Select Month --</option>
  102. </select>
  103. </div>
  104. <div style="margin-bottom: 25px" class="input-group">
  105. <span class="input-group-addon">Block</span>
  106. <select type="text" class="form-control" name="block" id="block">
  107. <option value="">-- Select Block --</option>
  108. </select>
  109. </div>
  110. <div style="margin-bottom: 25px" class="input-group">
  111. <span class="input-group-addon">Level</span>
  112. <select type="text" class="form-control" name="level" id="level">
  113. <option value="">-- Select Level --</option>
  114. </select>
  115. </div>
  116. <div style="margin-bottom: 25px" class="input-group">
  117. <span class="input-group-addon">Unit</span>
  118. <select type="text" class="form-control" name="unit" id="unit">
  119. <option value="">-- Select Unit --</option>
  120. </select>
  121. </div>
  122. <div style="margin-bottom: 25px" class="input-group">
  123. <span class="input-group-addon">Department Monthly Quota</span>
  124. <input type="text" class="form-control" name="dpquota" id="dpquota" value="<?php echo $dpquota; ?>" />
  125. </div>
  126. <div style="margin-top: 10px" class="form-group">
  127. <div class="col-sm-12 controls">
  128. <?php if(!isset($_GET["edit_id"])){
  129. echo '<input type="submit" id="btn_save" name="btn_save" class="btn btn-info" value="Register"/>';
  130. }else{
  131. echo '<input type="submit" id="btn_edit" name="btn_edit" class="btn btn-info" value="Edit"/>';
  132. }
  133. ?>
  134. </div>
  135. </div>
  136. </form>
  137. </div>
  138. </div>
  139. </div>
  140. </div>
  141. <script>
  142. $(document).ready(function(){
  143. $('#year').on('change',function(){
  144. var tahun_id = $(this).val();
  145. if(tahun_id){
  146. $.ajax({
  147. type:'POST',
  148. url:'fetch.php',
  149. data:'tahun_id='+tahun_id,
  150. success:function(html){
  151. $('#month').html(html);
  152. }
  153. });
  154. }else{
  155. $('#month').html('<option value="">-- Select Month --</option>');
  156. }
  157. });
  158.  
  159. $('#month').on('change',function(){
  160. var bulan_id = $(this).val();
  161. if(bulan_id){
  162. $.ajax({
  163. type:'POST',
  164. url:'fetch.php',
  165. data:'bulan_id='+bulan_id,
  166. success:function(html){
  167. $('#block').html(html);
  168. }
  169. });
  170. }else{
  171. $('#block').html('<option value="">-- Select Block --</option>');
  172. }
  173. });
  174.  
  175. $('#block').on('change',function(){
  176. var block_id = $(this).val();
  177. if(block_id){
  178. $.ajax({
  179. type:'POST',
  180. url:'fetch.php',
  181. data:'block_id='+block_id,
  182. success:function(html){
  183. $('#level').html(html);
  184. }
  185. });
  186. }else{
  187. $('#level').html('<option value="">-- Select Level --</option>');
  188. $('#unit').html('<option value="">-- Select Unit --</option>');
  189. }
  190. });
  191.  
  192. $('#level').on('change',function(){
  193. var level_id = $(this).val();
  194. if(level_id){
  195. $.ajax({
  196. type:'POST',
  197. url:'fetch.php',
  198. data:'level_id='+level_id,
  199. success:function(html){
  200. $('#unit').html(html);
  201. }
  202. });
  203. }else{
  204. $('#unit').html('<option value="">-- Select Unit --</option>');
  205. }
  206. });
  207. $('input[class="form-control"]').focus(function() {
  208. $(this).removeAttr('style');
  209. });
  210. $("#btn_save, #btn_edit").click(function(e){
  211. if($("#level").val() == ''){
  212. $("#level").css("border-color","#DA1908");
  213. $("#level").css("background","#F2DEDE");
  214. e.preventDefault();
  215. }
  216. if($("#year").val() == ''){
  217. $("#year").css("border-color","#DA1908");
  218. $("#year").css("background","#F2DEDE");
  219. e.preventDefault();
  220. }
  221. if($("#month").val() == ''){
  222. $("#month").css("border-color","#DA1908");
  223. $("#month").css("background","#F2DEDE");
  224. e.preventDefault();
  225. }
  226. if($("#block").val() == ''){
  227. $("#block").css("border-color","#DA1908");
  228. $("#block").css("background","#F2DEDE");
  229. e.preventDefault();
  230. }else{
  231. $('form_level').unbind('submit').submit();
  232. }
  233. });
  234. });
  235. </script>
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!