API tools faq
paste
Advertisement
gundambison

biar greget

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