API tools faq
paste
Advertisement
GWibisono

update 45541

GWibisono
Nov 27th, 2014
208
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 8.70 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. error_reporting(1);
  3. /*
  4. require_once('koneksi.php');
  5. */
  6. $mysqli=new mysqli('localhost','root','','work_fb1');
  7.  
  8. if(count($_POST)>0){
  9. //  die(print_r($_POST));
  10.     if(isset($_POST['cari'])){
  11.         //header('location:?cari='.trim($_POST['cari']) );
  12.         $url="?cari=".trim($_POST['cari']);
  13.         gotoUrl($url);
  14.         die();
  15.     }
  16. }
  17.  
  18. if(isset($_POST['checkbox'])){
  19. //print_r($_SERVER);die();
  20.     $checkbox = $_POST['checkbox'];
  21.     //sisa cuti
  22.     $sql="SELECT * FROM cuti where NIK like '$cari' and (approval is null or approval='')
  23. ORDER BY SISA_CUTI DESC limit 1";
  24.      if ($result = $mysqli->query($sql)) {
  25.             $row=$result->fetch_assoc();
  26.      }
  27.     $sql="SELECT * FROM cuti where NO='$checkbox[0]'";
  28.      if ($result = $mysqli->query($sql)) {
  29.             $row=$result->fetch_assoc();
  30.      }
  31.      
  32.     $z=$row["SISA_CUTI"]; $y=(int)$z-1;
  33.     $nik=$row['NIK'];
  34.  
  35.    
  36.     if(isset($_POST['APPROV'])?$APPROV = $_POST["APPROV"]:$NOT_APPROV = $_POST["NOT_APPROV"])
  37.     $NO = "('" . implode( "','", $checkbox ) . "');" ;
  38.     $a = date('d/m/Y');
  39.     $g = $req['NIK'];
  40.     $sql="UPDATE cuti SET
  41.         APPROVAL = '".(isset($APPROV)?'APPROV':'NOT_APPROV')."',
  42.         TANGGAL_APPROVAL = '".(isset($APPROV)?$a:$a)."',
  43.         SISA_CUTI = '".(isset($APPROV)?$y:$z)."',
  44.         NIK_ATASAN = '".(isset($APPROV)?$req[NIK]:$req[NIK])."'
  45.         WHERE NO = $NO" ;
  46.      
  47.     //$result = mysql_query($sql) or die(mysql_error());
  48.      if ($result = $mysqli->query($sql)) {
  49.         //echo $sql;
  50.         if(isset($_POST['APPROV'])){
  51.              
  52.             if($y<1)$y=0;
  53.             $sql="update cuti set sisa_cuti=$y where NIK='$nik' and ( TANGGAL_APPROVAL is NULL or TANGGAL_APPROVAL='' )";
  54.             $result = $mysqli->query($sql);
  55.              
  56.         }
  57.        
  58. //      header('location:'.$_SERVER['HTTP_REFERER']);
  59.         gotoUrl( $_SERVER['HTTP_REFERER'] );
  60.         //die($sql);
  61.     }else{
  62.         die($sql);
  63.     }
  64. }
  65.  
  66. //include('top.php');
  67. ?>
  68. <?php
  69.  
  70. ?>
  71. <?php
  72. if(isset($_POST['submit'])):
  73.     //membuat session array dengan variabel - variabel POST
  74.     $_SESSION['pos']=$_POST;
  75. endif;
  76.  
  77. if(isset($_SESSION['pos'])):
  78.     $cari   =$_SESSION['pos']['cari'];
  79. else:
  80.     $cari   ='';
  81. endif;
  82. ?>
  83. <html>
  84. <head>
  85. <title>Untitled Document</title>
  86. <script language="javascript">
  87. function submit_form(){
  88. document.form1.submit();
  89. document.frmactive.submit();
  90. }
  91. </script>
  92. </head>
  93. <script type="text/javascript">
  94. <!--
  95. function un_check(){
  96. for (var i = 0; i < document.frmactive.elements.length; i++) {
  97. var e = document.frmactive.elements[i];
  98. if ((e.name != 'allbox') && (e.type == 'checkbox')) {
  99. e.checked = document.frmactive.allbox.checked;
  100. }}}
  101. //-->
  102. </script>
  103.  
  104. <body>
  105. <table width="955" border="0">
  106.   <tr>
  107.     <td width="750"><center>
  108. <?php
  109.     /*
  110.     $a = mysql_query("SELECT * FROM data_karyawan where NAMA_LENGKAP LIKE '$username'" );
  111.       $res=mysql_fetch_array($a);
  112.     */
  113. $username ="EFFENDI PRIHARSANTO"; //09100058
  114. $sql="SELECT * FROM data_karyawan where NAMA_LENGKAP LIKE '$username%'" ;
  115. if ($result = $mysqli->query($sql)) {
  116.     $res = $result->fetch_assoc();
  117.      
  118.      
  119. }else{
  120.   die($sql);
  121. }
  122. ?>
  123.     <font face="Comic Sans MS">Pencarian Data Cuti</font>
  124.       <form id="form1" name="form1" method="post" action="">       
  125.         <?php echo "<select name='cari'>";
  126.        
  127.         /*
  128.         $tampil=mysql_query("SELECT * FROM struktur where NIK LIKE '%$res[NIK]%'" );
  129.         */
  130.         $sql="SELECT * FROM struktur where NIK LIKE '%$res[NIK]%'";
  131.  if ($result = $mysqli->query($sql)) {
  132.        
  133.        
  134.         echo "<option>- Pilih NIK -</option>";
  135.  
  136.         while($row=$result->fetch_assoc() )//$w=mysql_fetch_array($tampil))
  137.         {
  138.             echo "\n\t<option value=$row[NIK_BAWAHAN]>$row[NIK_BAWAHAN]  </option> ";        
  139.         }
  140.         echo "\n</select>";
  141.  }else{
  142.     die($sql);
  143. }
  144.         ?>
  145.         <input type="submit" name="Submit" id="Submit" value="Pencarian" />
  146.       </form>
  147.         <?php
  148.     $cari=isset($_GET['cari'])?$_GET['cari']:false;
  149.    
  150. if(!empty($cari)){
  151.       ?>
  152.       <p><font face="Comic Sans MS">Hasil Pencarian Anda:</font></p>
  153.       <?php
  154.      /*
  155.      $pencarian=mysql_query("SELECT * FROM cuti where NIK LIKE '%$cari%' " );
  156.      $totalcari=mysql_num_rows($pencarian);
  157.      */
  158.      $sql="SELECT count(NO) c  FROM cuti where NIK LIKE '%$cari%' ";
  159.     if ($result = $mysqli->query($sql)) {  
  160.         $row=$result->fetch_assoc();
  161.         $totalcari=$row['c'];
  162.       if($totalcari==0){
  163.         echo "<center><blink><font size='3'>Mohon maaf Data (NIK  <strong>$cari</strong>) tidak ada di dalam database kami";
  164.       }else{
  165.         echo "Data Cuti dengan NIK <strong>$cari</strong>  yang anda cari adalah: ";
  166.       }
  167.     }else{
  168.         die( $sql);
  169.    
  170.     }
  171.       ?>
  172.       <?php
  173.       /*
  174.       $c = mysql_query("SELECT * FROM data_karyawan where NIK LIKE '$cari'" );
  175.       $sip=mysql_fetch_array($c);
  176.       */
  177.        $sql="SELECT * FROM data_karyawan where NIK LIKE '$cari' ";
  178.  if ($result = $mysqli->query($sql)) {
  179.         $sip=$result->fetch_assoc();
  180.  }
  181.  
  182.       ?>
  183.      
  184.       <table width="750" border="0">
  185.       <tr>
  186.         <td width="83">NAMA :</td>
  187.         <td width="277"><?=$sip[NAMA_LENGKAP]?></td>
  188.         <td width="180">NIK :</td>
  189.         <td width="180"><?=$sip[NIK]?></td>
  190.       </tr>
  191.       <tr>
  192.         <td>JABATAN :</td>
  193.         <td><?=$sip[POSISI]?></td>
  194.         <td>DEPARTEMEN:</td>
  195.         <td><?=$sip[DEPARTEMEN]?></td>
  196.       </tr>
  197.     </table>
  198. <?php
  199.     if($totalcari>0){
  200. ?>
  201.     <form id="frmactive" name="frmactive" method="post" action="">
  202.     <table border="1">
  203.     <tr>
  204.     <td colspan="5"><input name="APPROV" type="submit" id="APPROV" value="APPROV" />
  205.     <input name="NOT_APPROV" type="submit" id="NOT_APPROV" value="NOT_APPROV" /></td>
  206.     <td colspan=4>&nbsp;</td>
  207.     </tr><?php $no = 1;?>
  208.       <tr align="center" valign="middle">
  209.         <td height="3"><h5>NO</h5></td>
  210.         <td height="3"><h5>JENIS CUTI</h5></td>
  211.         <td height="3"><h5>TANGGAL CUTI</h5></td>
  212.         <td height="3"><h5>TANGGAL PENGAJUAN</h5></td>
  213.         <td height="3"><h5>TANGGAL APPROVAL</h5></td>
  214.         <td height="3"><h5>KEPERLUAN</h5></td>
  215.         <td height="3"><h5>STATUS</h5></td>
  216.         <td height="3"><h5>NIK ATASAN</h5></td>
  217.         <td height="3"><h5>APPROVAL</h5></td>
  218.         </tr>
  219.         <?php
  220. $sql="SELECT * FROM cuti where NIK LIKE '%$cari%' ";
  221.     if ($result = $mysqli->query($sql)) {
  222.         //while($pencarian1=mysql_fetch_array($pencarian)){
  223.         $no=1;
  224.         while($pencarian1 = $result->fetch_assoc()){
  225.         ?>
  226.         <tr align="center" valign="middle">
  227.           <td height="2"><h5><?=$no ?></h5></td>
  228.           <td height="2"><h5><?=$pencarian1['JENIS_CUTI']; ?></h5></td>
  229.           <td height="2"><h5><?=$pencarian1['TANGGAL_CUTI']; ?></h5></td>
  230.           <td height="2"><h5><?=$pencarian1['TANGGAL_PENGAJUAN']; ?></h5></td>
  231.           <td height="2"><h5><?=$pencarian1['TANGGAL_APPROVAL']; ?></h5></td>
  232.           <td height="2"><h5><?=$pencarian1['KEPERLUAN']; ?></h5></td>
  233.           <td height="2"><h5><?=$pencarian1['APPROVAL']; ?></td>
  234.           <td height="2"><h5><?=$pencarian1['NIK_ATASAN']; ?></td>
  235.           <td align="center"><?php
  236.           if ($pencarian1['APPROVAL'] != 'APPROV' || ''==$pencarian1['APPROVAL']) {
  237.             if ($pencarian1['APPROVAL'] != 'NOT_APPROV') {
  238.                 ?><input name="checkbox[]" type="radio" id="radio<?=$no;?>" value="<? echo $pencarian1['NO']; ?>"><?php
  239.             }else {
  240.             ?>
  241.                 NOT APPROVE
  242.             <?php
  243.             }
  244.            }else{
  245.              echo '-';
  246.           }
  247.           ?>&nbsp;</td>
  248.           </tr>
  249.           <?php $no++?>
  250.         <?
  251.         }
  252.     }else{
  253.         die($sql);
  254.    
  255.     }
  256.         ?>
  257.     </table>
  258.     <?php
  259.  
  260.       ?></form>
  261. <?php
  262.     }else{
  263.         echo "<!-- no form -->";
  264.     }
  265. }else{
  266.     echo 'no data';
  267. }
  268. ?>
  269.       </center>
  270.       </td>
  271. <td align="center" valign="top"><p>
  272.       <object type="application/x-shockwave-flash"   data="images/calendar.swf"   width="200" height="200">   <param name="movie" value="images/calendar.swf" />   <param name="quality" value="high"/> </object>
  273.       <object type="application/x-shockwave-flash"   data="images/dialclock_LlRmUTNF.swf"   width="190" height="60">   <param name="movie" value="images/dialclock_LlRmUTNF.swf" />   <param name="quality" value="high"/> </object>
  274.     <p>&nbsp; </p></td>
  275.   </tr>
  276. </table>
  277. <script type="text/javascript">
  278. swfobject.registerObject("FlashID");
  279. </script>
  280. </body>
  281. </html>
  282.  
  283.  
  284. <?php
  285. /*
  286. $e = mysql_query ("SELECT SISA_CUTI FROM cuti where NIK = '$cari' ORDER BY SISA_CUTI DESC" );
  287.        $row = mysql_fetch_array($e);
  288. */
  289. $sql="SELECT * FROM cuti where NIK like '$cari' and (approval is null or approval='')
  290. ORDER BY SISA_CUTI DESC limit 1";
  291.  if ($result = $mysqli->query($sql)) {
  292.         $row=$result->fetch_assoc();
  293.  }
  294.  
  295.        $z=$row["SISA_CUTI"]; $y=(int)$z;  echo "sisa cuti:". $y;
  296.  
  297. /*
  298. $tuk = mysql_query("SELECT * FROM data_karyawan where NAMA_LENGKAP LIKE '$username'" );
  299.       $req=mysql_fetch_array($tuk);
  300. */
  301. $sql="SELECT * FROM data_karyawan where NAMA_LENGKAP LIKE '$username'";
  302.  if ($result = $mysqli->query($sql)) {
  303.         $req=$result->fetch_assoc();
  304.  }
  305.  
  306. die( );
  307.  
  308. function gotoUrl($url){
  309. ?><script>
  310. window.location.href = '<?php echo $url; ?>';
  311. </script><?php
  312. }
  313. ?>
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!