Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include '../../config.php';
- $id_panggilan = base64_decode($_REQUEST['id_panggilan']);
- $loket = base64_decode($_REQUEST['loket']);
- $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
- if(!empty($ly->ID_LAYANAN_SUB)){
- $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
- }
- else {
- $ID_LAYANAN = $ly->ID_LAYANAN;
- }
- 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."' ");
- $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."' "));
- if($count->total>0){
- $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";
- $antrian = mysqli_fetch_object(mysqli_query($con,$query));
- $no_antr="";
- if(empty($antrian)){
- $no_antr="0";
- }
- else {
- $no_antr=$antrian->NO_URUT;
- }
- $gbr = "no_data";
- $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
- if(file_get_contents($url_foto)) {
- $gbr = $url_foto;
- }
- echo $no_antr."%%$$%%".$antrian->PREFIX_SUARA.$no_antr."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
- }
- else {
- echo "-";
- }
- mysqli_close($con);
- die();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement