Advertisement
Bedhoel

Untitled

Jan 10th, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.54 KB | None | 0 0
  1. <?php
  2. include '../../config.php';
  3. $id_panggilan = base64_decode($_REQUEST['id_panggilan']);
  4.         $loket = base64_decode($_REQUEST['loket']);
  5.         $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  6.         if(!empty($ly->ID_LAYANAN_SUB)){
  7.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  8.         }
  9.         else {
  10.             $ID_LAYANAN = $ly->ID_LAYANAN;
  11.         }
  12.         mysqli_query($con,"update data_antrian set stat_pangilan='1',STATUS_CURRENT='N' where tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."' and no_urut='".$id_panggilan."'  ");
  13.  
  14.         $count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where stat_pangilan='0' and LOKET is null and  tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."'  "));
  15.         if($count->total>0){
  16.         $query="select * from data_antrian where stat_pangilan='0' and LOKET is null and tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."'  ORDER BY no_urut asc";
  17.  
  18.             $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  19.             $no_antr="";
  20.             if(empty($antrian)){
  21.                $no_antr="0";
  22.             }
  23.             else {
  24.                $no_antr=$antrian->NO_URUT;
  25.             }
  26.             $gbr = "no_data";
  27.             $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  28.             if(file_get_contents($url_foto)) {
  29.                 $gbr = $url_foto;
  30.              }
  31.             echo $no_antr."%%$$%%".$antrian->PREFIX_SUARA.$no_antr."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  32.         }
  33.         else {
  34.             echo "-";
  35.         }
  36.         mysqli_close($con);
  37.         die();
  38.        
  39.         ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement