API tools faq
paste
Advertisement
Bedhoel

ajax/antrian.php

Bedhoel
Jan 9th, 2019
189
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 20.75 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.     include '../../config.php';
  3.     include '../function/otentifikasi.php';
  4.    
  5.     $act   = $_REQUEST['act'];
  6.  
  7.     if($act=="repeat_panggilan"){
  8.         $no_antrian = base64_decode($_REQUEST['no_antrian']);
  9.         if(!empty($no_antrian)){
  10.             $loket = base64_decode($_REQUEST['loket']);
  11.             $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  12.             if(!empty($ly->ID_LAYANAN_SUB)){
  13.                 $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  14.             }
  15.             else {
  16.                 $ID_LAYANAN = $ly->ID_LAYANAN;
  17.             }
  18.  
  19.             //$count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from temp_panggilan where PANGILAN='".$loket.";".$no_antrian."' and status='0' and ID_TEMP_PANGGILAN like '".date('ymd')."%'"));
  20.             $count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from temp_panggilan where PANGILAN='".$loket.";".$no_antrian."' and ID_TEMP_PANGGILAN like '".date('ymd')."%'"));
  21.  
  22.             if($count->total >= 3){
  23.                 echo "Melebihi batas pemanggilan";
  24.             }
  25.             else {
  26.                 $numbers = preg_replace('/[^0-9]/', '',$no_antrian);
  27.                 mysqli_query($con,"insert into temp_panggilan (ID_TEMP_PANGGILAN,PANGILAN,STATUS,URUT,ID_LAYANAN) values ('".date('ymdHis')."','".$loket.";".$no_antrian."','0','".$numbers."','".$ID_LAYANAN."')");
  28.                 echo "OK";
  29.             }
  30.         }
  31.         mysqli_close($con);
  32.         die();
  33.     }
  34.     else if($act=="antrian_current"){
  35.         $loket = base64_decode($_REQUEST['loket']);
  36.         $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  37.         if(!empty($ly->ID_LAYANAN_SUB)){
  38.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  39.         }
  40.         else {
  41.             $ID_LAYANAN = $ly->ID_LAYANAN;
  42.         }
  43.         $count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where stat_pangilan='0'  and LOKET is null  and ID_LAYANAN='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' "));
  44.         $no_antr="";
  45.         if($count->total>0){
  46.             $count_current = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  47.  
  48.             if($count_current->total>0){
  49.                 $antrian = mysqli_fetch_object(mysqli_query($con,"select * from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  50.                 $antr = $antrian->NO_URUT;
  51.                 if(empty($antr)){
  52.                    $no_antr="-";
  53.                 }
  54.                 else {
  55.                 $gbr = "no_data";
  56.                 $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  57.                 if(file_get_contents($url_foto)) {
  58.                     $gbr = $url_foto;
  59.                  }
  60.  
  61.                     mysqli_query($con,"UPDATE data_antrian set STATUS_CURRENT='Y',LOKET='".$loket."' where ID_DATA_ANTRIAN='".$antrian->ID_DATA_ANTRIAN."' ");
  62.                    $no_antr= $antrian->NO_URUT."%%$$%%".$antrian->PREFIX_SUARA.$antrian->NO_URUT."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  63.                 }
  64.             }
  65.             else {
  66.                 $query="select * from data_antrian where stat_pangilan='0'  and LOKET is null and ID_LAYANAN='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%'   ORDER BY NO_URUT ASC LIMIT 0,1";
  67.                 $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  68.                 $antr = $antrian->NO_URUT;
  69.                 if(empty($antr)){
  70.                    $no_antr="-";
  71.                 }
  72.                 else {
  73.                     $gbr = "no_data";
  74.                     $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  75.                     if(file_get_contents($url_foto)) {
  76.                         $gbr = $url_foto;
  77.                      }
  78.                     mysqli_query($con,"UPDATE data_antrian set STATUS_CURRENT='Y',LOKET='".$loket."' where ID_DATA_ANTRIAN='".$antrian->ID_DATA_ANTRIAN."' ");
  79.                    $no_antr= $antrian->NO_URUT."%%$$%%".$antrian->PREFIX_SUARA.$antrian->NO_URUT."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  80.                 }
  81.             }
  82.         }
  83.         else {
  84.             $count_current = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  85.  
  86.             if($count_current->total>0){
  87.                 $antrian = mysqli_fetch_object(mysqli_query($con,"select * from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  88.                 $antr = $antrian->NO_URUT;
  89.                 if(empty($antr)){
  90.                    $no_antr="-";
  91.                 }
  92.                 else {
  93.                 $gbr = "no_data";
  94.                 $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  95.                 if(file_get_contents($url_foto)) {
  96.                     $gbr = $url_foto;
  97.                  }
  98.  
  99.                     mysqli_query($con,"UPDATE data_antrian set STATUS_CURRENT='Y',LOKET='".$loket."' where ID_DATA_ANTRIAN='".$antrian->ID_DATA_ANTRIAN."' ");
  100.                    $no_antr= $antrian->NO_URUT."%%$$%%".$antrian->PREFIX_SUARA.$antrian->NO_URUT."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  101.                 }
  102.             }
  103.             else {
  104.                  $no_antr="-";
  105.             }
  106.         }
  107.          echo $no_antr;
  108.          mysqli_close($con);
  109.          die();
  110.     }
  111.     else if($act=="check_antrian"){
  112.         $loket = base64_decode($_REQUEST['loket']);
  113.         $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  114.         if(!empty($ly->ID_LAYANAN_SUB)){
  115.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  116.         }
  117.         else {
  118.             $ID_LAYANAN = $ly->ID_LAYANAN;
  119.         }
  120.         $count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where stat_pangilan='0'  and LOKET is null  and ID_LAYANAN='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' "));
  121.         $no_antr="";
  122.         if($count->total>0){
  123.             $count_current = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  124.  
  125.             if($count_current->total>0){
  126.                 $antrian = mysqli_fetch_object(mysqli_query($con,"select * from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  127.                 $antr = $antrian->NO_URUT;
  128.                 if(empty($antr)){
  129.                    $no_antr="-";
  130.                 }
  131.                 else {
  132.                 $gbr = "no_data";
  133.                 $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  134.                 if(file_get_contents($url_foto)) {
  135.                     $gbr = $url_foto;
  136.                  }
  137.  
  138.                     mysqli_query($con,"UPDATE data_antrian set STATUS_CURRENT='Y',LOKET='".$loket."' where ID_DATA_ANTRIAN='".$antrian->ID_DATA_ANTRIAN."' ");
  139.                    $no_antr= $antrian->NO_URUT."%%$$%%".$antrian->PREFIX_SUARA.$antrian->NO_URUT."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  140.                 }
  141.             }
  142.             else {
  143.                 $query="select * from data_antrian where stat_pangilan='0'  and LOKET is null and ID_LAYANAN='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%'   ORDER BY NO_URUT ASC LIMIT 0,1";
  144.                 $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  145.                 $antr = $antrian->NO_URUT;
  146.                 if(empty($antr)){
  147.                    $no_antr="-";
  148.                 }
  149.                 else {
  150.                     $gbr = "no_data";
  151.                     $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  152.                     if(file_get_contents($url_foto)) {
  153.                         $gbr = $url_foto;
  154.                      }
  155.                     mysqli_query($con,"UPDATE data_antrian set STATUS_CURRENT='Y',LOKET='".$loket."' where ID_DATA_ANTRIAN='".$antrian->ID_DATA_ANTRIAN."' ");
  156.                    $no_antr= $antrian->NO_URUT."%%$$%%".$antrian->PREFIX_SUARA.$antrian->NO_URUT."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  157.                 }
  158.             }
  159.         }
  160.         else {
  161.             $count_current = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  162.  
  163.             if($count_current->total>0){
  164.                 $antrian = mysqli_fetch_object(mysqli_query($con,"select * from data_antrian where LOKET='".$loket."'  and ID_LAYANAN='".$ID_LAYANAN."'  and STATUS_CURRENT='Y' and tanggal like '".date('Y-m-d')."%' "));
  165.                 $antr = $antrian->NO_URUT;
  166.                 if(empty($antr)){
  167.                    $no_antr="-";
  168.                 }
  169.                 else {
  170.                 $gbr = "no_data";
  171.                 $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  172.                 if(file_get_contents($url_foto)) {
  173.                     $gbr = $url_foto;
  174.                  }
  175.  
  176.                     mysqli_query($con,"UPDATE data_antrian set STATUS_CURRENT='Y',LOKET='".$loket."' where ID_DATA_ANTRIAN='".$antrian->ID_DATA_ANTRIAN."' ");
  177.                    $no_antr= $antrian->NO_URUT."%%$$%%".$antrian->PREFIX_SUARA.$antrian->NO_URUT."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  178.                 }
  179.             }
  180.             else {
  181.                  $no_antr="-";
  182.             }
  183.         }
  184.          echo $no_antr;
  185.          mysqli_close($con);
  186.          die();
  187.     }
  188.     else if($act=="antrian_next_show"){
  189.         $loket = base64_decode($_REQUEST['loket']);
  190.         $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  191.         if(!empty($ly->ID_LAYANAN_SUB)){
  192.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  193.         }
  194.         else {
  195.             $ID_LAYANAN = $ly->ID_LAYANAN;
  196.         }
  197.         $count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from data_antrian where stat_pangilan='0' and LOKET is null and ID_LAYANAN='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' "));
  198.         if($count->total>0){
  199.         $query="select * from data_antrian where stat_pangilan='0' and LOKET is null and ID_LAYANAN='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' order by no_urut asc";
  200.        
  201.             $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  202.             $no_antr="";
  203.             if(empty($antrian)){
  204.                $no_antr="0";
  205.             }
  206.             else {
  207.                 $no_antr=$antrian->PREFIX_SUARA.$antrian->NO_URUT;
  208.             }
  209.            
  210.             echo $no_antr;
  211.         }
  212.         else {
  213.             echo "-";
  214.         }
  215.         mysqli_close($con);
  216.          die();
  217.     }
  218.     else if($act=="antrian_panggil"){
  219.         $id_panggilan = str_replace(' ','',$_REQUEST['id']);
  220.         if(empty($id_panggilan)){
  221.             die();
  222.         }
  223.         else {
  224.             if($id_panggilan=="-"){
  225.                 die();
  226.             }
  227.             else if($id_panggilan=="undefined"){
  228.                 echo "undefined";
  229.                 die();
  230.             }
  231.             else {
  232.                 $loket = $_REQUEST['loket'];
  233.                 $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  234.                 if(!empty($ly->ID_LAYANAN_SUB)){
  235.                     $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  236.                 }
  237.                 else {
  238.                     $ID_LAYANAN = $ly->ID_LAYANAN;
  239.                 }
  240.                 $antr="select * from data_antrian where TANGGAL like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."' and NO_URUT='".$id_panggilan."' ";
  241.                
  242.                 $urut = preg_replace('/[^0-9]/', '', $id_panggilan);
  243.  
  244.                  mysqli_query($con,"insert into temp_panggilan (ID_TEMP_PANGGILAN,PANGILAN,STATUS,URUT,ID_LAYANAN) values ('".date('ymdHis')."','".$loket.";".$antr->PREFIX_SUARA.$id_panggilan."','0','".$urut."','".$ID_LAYANAN."')");
  245.             }
  246.         }
  247.         mysqli_close($con);
  248.         die();
  249.     }
  250.     else if($act=="antrian_next"){
  251.         $id_panggilan = base64_decode($_REQUEST['id_panggilan']);
  252.         $loket = base64_decode($_REQUEST['loket']);
  253.         $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  254.         if(!empty($ly->ID_LAYANAN_SUB)){
  255.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  256.         }
  257.         else {
  258.             $ID_LAYANAN = $ly->ID_LAYANAN;
  259.         }
  260.  
  261.         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."'  ");
  262.  
  263.         $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."'  "));
  264.        
  265.        
  266.         if($count->total>0){
  267.         $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";
  268.  
  269.             $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  270.             $no_antr="";
  271.             if(empty($antrian)){
  272.                $no_antr="0";
  273.             }
  274.             else {
  275.                $no_antr=$antrian->NO_URUT;
  276.             }
  277.  
  278.             //mysqli_query($con,"insert into temp_panggilan (ID_TEMP_PANGGILAN,PANGILAN,STATUS,URUT,ID_LAYANAN) values ('".date('ymdHis')."','".$loket.";".$antrian->PREFIX_SUARA.$no_antr."','0','".$no_antr."','".$ID_LAYANAN."')");
  279.  
  280.             $gbr = "no_data";
  281.             $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  282.             if(file_get_contents($url_foto)) {
  283.                 $gbr = $url_foto;
  284.              }
  285.  
  286.             // $get_running = mysqli_fetch_object(mysqli_query($con,"select * from data_setting_counter_board where LOKET='".$loket."' "));
  287.             // $join = num_with_zero($loket).";".num_with_zero($no_antr);
  288.             // mysqli_query($con,"insert into running_text (ip,running_text,status,created_date) values ('".$get_running->IP_ADDRESS."','".$join."','1',now())");
  289.  
  290.             echo $no_antr."%%$$%%".$antrian->PREFIX_SUARA.$no_antr."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  291.         }
  292.         else {
  293.             echo "-";
  294.         }
  295.         mysqli_close($con);
  296.         die();
  297.     }
  298.     else if($act=="antrian_total"){
  299.          $loket = base64_decode($_REQUEST['loket']);
  300.          $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  301.         if(!empty($ly->ID_LAYANAN_SUB)){
  302.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  303.         }
  304.         else {
  305.             $ID_LAYANAN = $ly->ID_LAYANAN;
  306.         }
  307.          $query="select count(*) as total,PREFIX_SUARA from data_antrian where tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."' group by PREFIX_SUARA ";
  308.          $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  309.          if($antrian!=""){
  310.              echo $antrian->total;
  311.          }
  312.          else {
  313.              echo "-";
  314.          }
  315.         mysqli_close($con);
  316.          die();
  317.     }
  318.     else if($act=="antrian_sisa"){
  319.          $loket = base64_decode($_REQUEST['loket']);
  320.          $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  321.         if(!empty($ly->ID_LAYANAN_SUB)){
  322.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  323.         }
  324.         else {
  325.             $ID_LAYANAN = $ly->ID_LAYANAN;
  326.         }
  327.          $query="select count(*) as total_sisa,PREFIX_SUARA from data_antrian where stat_pangilan='0' and tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."' and (LOKET='".$loket."' or LOKET is null) group by PREFIX_SUARA";
  328.          $antrian = mysqli_fetch_object(mysqli_query($con,$query));
  329.          if($antrian->total_sisa==0 or empty($antrian->total_sisa)) {
  330.              $hasil =  "-";
  331.          }
  332.          else {
  333.             $ss = $antrian->total_sisa-1;
  334.             $hasil =  $ss;
  335.          }
  336.          echo $hasil;
  337.          mysqli_close($con);
  338.          die();
  339.     }
  340.     else if($act=="antrian_fast"){
  341.         $no_antrian = base64_decode($_REQUEST['no_antrian']);
  342.         $loket      = base64_decode($_REQUEST['loket']);
  343.         $ly = mysqli_fetch_object(mysqli_query($con,"select ID_LAYANAN,ID_LAYANAN_SUB from tr_layanan_loket where LOKET='".$loket."' "));
  344.         if(!empty($ly->ID_LAYANAN_SUB)){
  345.             $ID_LAYANAN = $ly->ID_LAYANAN_SUB;
  346.         }
  347.         else {
  348.             $ID_LAYANAN = $ly->ID_LAYANAN;
  349.         }
  350.  
  351.         $get_number = preg_replace('/[^0-9]/', '', $no_antrian);
  352.         $get_int = (int)$get_number;
  353.  
  354.         if(!empty($get_int)){  
  355.              
  356.                $count = mysqli_fetch_object(mysqli_query($con,"select count(*) as total,PREFIX_SUARA from data_antrian where  tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."' and NO_URUT='".$get_int."' group by PREFIX_SUARA "));
  357.  
  358.              if($count->total>0){
  359.                 $loket = base64_decode($_REQUEST['loket']);
  360.                 $count_repeat = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from temp_panggilan where PANGILAN='".$loket.";".$count->PREFIX_SUARA.$get_int."' and status='0' and ID_TEMP_PANGGILAN like '".date('ymd')."%'"));
  361.                 //$count_repeat = mysqli_fetch_object(mysqli_query($con,"select count(*) as total from temp_panggilan where PANGILAN='".$loket.";".$count->PREFIX_SUARA.$get_int."'  and ID_TEMP_PANGGILAN like '".date('ymd')."%'"));
  362.  
  363.                 if($count_repeat->total >= 3){
  364.                     echo "NOK2";
  365.                 }
  366.                 else {
  367.                      mysqli_query($con,"insert into temp_panggilan (ID_TEMP_PANGGILAN,PANGILAN,STATUS,URUT,ID_LAYANAN) values ('".date('ymdHis')."','".$loket.";".$count->PREFIX_SUARA.$get_int."','0','".$get_int."','".$ID_LAYANAN."')");
  368.                
  369.                     $no_antr =  $count->PREFIX_SUARA.$get_int;
  370.  
  371.  
  372.                     $antrian = mysqli_fetch_object(mysqli_query($con,"select * from data_antrian where  tanggal like '".date('Y-m-d')."%' and ID_LAYANAN='".$ID_LAYANAN."' and NO_URUT='".$get_int."'  "));
  373.                    
  374.                     // $get_running = mysqli_fetch_object(mysqli_query($con,"select * from data_setting_counter_board where LOKET='".$loket."' "));
  375.                     // $join = num_with_zero($loket).";".$no_antr;
  376.                     // mysqli_query($con,"insert into running_text (ip,running_text,status,created_date) values ('".$get_running->IP_ADDRESS."','".$join."','1',now())");
  377.                    
  378.                     $gbr = "no_data";
  379.                     $url_foto = $basepath_kiosk."images/people/".$antrian->ID_DATA_ANTRIAN.".jpg";
  380.                     if(file_get_contents($url_foto)) {
  381.                         $gbr = $url_foto;
  382.                      }
  383.                     echo $no_antr."%%$$%%".$gbr."%%$$%%".$antrian->ID_DATA_ANTRIAN;
  384.                 }
  385.             }
  386.             else {
  387.                 echo "NOK";
  388.             }
  389.         }
  390.         else {
  391.             echo "NOK";
  392.         }
  393.         mysqli_close($con);
  394.          die();
  395.     }
  396.     else if($act=="antrian_running"){
  397.         $rn = base64_decode($_REQUEST['rn'])."  ";
  398.         $loket = base64_decode($_REQUEST['loket']);
  399.        
  400.         $get_running = mysqli_fetch_object(mysqli_query($con,"select * from data_setting_counter_board where LOKET='".$loket."' "));
  401.         mysqli_query($con,"insert into running_text (ip,running_text,status,created_date) values ('".$get_running->IP_ADDRESS."','".$rn."','1',now())");
  402.         mysqli_close($con);
  403.          die();
  404.     }
  405.     else if($act=="check_waktu"){
  406.             $id = $_REQUEST['id_data_antrian'];
  407.             $data = mysqli_fetch_object(mysqli_query($con,"select SISA_DURASI from data_antrian where ID_DATA_ANTRIAN='".$id."' "));
  408.             if(!empty($data->SISA_DURASI)){
  409.                 echo $data->SISA_DURASI;
  410.             }
  411.             else {
  412.                 echo "no_data";
  413.             }
  414.             mysqli_close($con);
  415.              die();
  416.     }
  417.     else if($act=="save_times"){
  418.         $id     = $_REQUEST['id_data_antrian'];
  419.         $waktu  = $_REQUEST['waktu'];
  420.         mysqli_query($con,"UPDATE data_antrian set SISA_DURASI='".$waktu."' where ID_DATA_ANTRIAN='".$id."' ");
  421.         mysqli_close($con);
  422.         die(); 
  423.     }
  424.     else if($act=="save_durasi"){
  425.         $id     = $_REQUEST['id_data_antrian'];
  426.         $durasi = $_REQUEST['durasi_total'];
  427.         mysqli_query($con,"UPDATE data_antrian set DURASI='".$durasi."' where ID_DATA_ANTRIAN='".$id."' ");
  428.         mysqli_close($con);
  429.         die();
  430.     }
  431.     else if($act=="layanan_current"){
  432.          $loket = base64_decode($_REQUEST['loket']);
  433.  
  434.          $get_layanan = mysqli_fetch_object(mysqli_query($con,"select
  435.             ly.NAMA_LAYANAN,ly.ID_LAYANAN,ly.PREFIX_SUARA,ly_sb.NAMA_SUB_LAYANAN,ly_sb.ID_LAYANAN_SUB,ly_sb.PREFIX_SUARA as suara_sb,ly_sb.DURASI as durasi_sb,ly.DURASI as durasi_ly
  436.             from tr_layanan_loket as lk
  437.             inner join  ms_layanan as ly
  438.                 on ly.ID_LAYANAN=lk.ID_LAYANAN
  439.             left outer join  ms_layanan_sub as ly_sb
  440.                 on ly_sb.ID_LAYANAN_SUB = lk.ID_LAYANAN_SUB
  441.             where lk.LOKET='".$loket."'"));
  442.  
  443.          $count = 1;
  444.          if(!empty($get_layanan->NAMA_SUB_LAYANAN)){
  445.          $id_layanan = (!empty($get_layanan->ID_LAYANAN_SUB) ? $get_layanan->ID_LAYANAN_SUB : '');
  446.          $data_ly= mysqli_query($con,"select ly_lk.LOKET,ly.ID_LAYANAN_SUB,ly.PREFIX_SUARA,(select dt.NO_URUT from data_antrian as dt where dt.ID_LAYANAN=ly.ID_LAYANAN_SUB and dt.stat_pangilan='0' and dt.TANGGAL like '".date('Y-m-d')."%'  and dt.LOKET=ly_lk.LOKET  order by dt.NO_URUT asc limit 0,1) as antrian from ms_layanan_sub as ly
  447.                   inner join  tr_layanan_loket  as ly_lk
  448.                     on ly_lk.ID_LAYANAN_SUB=ly.ID_LAYANAN_SUB
  449.                 where ly.ID_LAYANAN_SUB='".$id_layanan."'
  450.              order by -antrian desc,ly_lk.LOKET asc  ");
  451.         }
  452.         else {
  453.         $id_layanan = (!empty($get_layanan->ID_LAYANAN) ? $get_layanan->ID_LAYANAN : '');
  454.         $data_ly= mysqli_query($con,"select ly_lk.LOKET,ly.ID_LAYANAN,ly.PREFIX_SUARA,(select dt.NO_URUT from data_antrian as dt where dt.ID_LAYANAN=ly.ID_LAYANAN and dt.stat_pangilan='0' and dt.TANGGAL like '".date('Y-m-d')."%'  and dt.LOKET=ly_lk.LOKET  order by dt.NO_URUT asc limit 0,1) as antrian from ms_layanan as ly
  455.                   inner join  tr_layanan_loket  as ly_lk
  456.                     on ly_lk.ID_LAYANAN=ly.ID_LAYANAN
  457.                 where ly.ID_LAYANAN='".$id_layanan."'
  458.              order by -antrian desc,ly_lk.LOKET asc  ");
  459.         }
  460.           while($ly=mysqli_fetch_object($data_ly)){
  461.             $atr = "-";
  462.             if(!empty($ly->antrian)){
  463.               $atr = $ly->PREFIX_SUARA.$ly->antrian;
  464.             }
  465.             if ($count%10 == 1) {  
  466.                   echo '<div class="col-md-6">
  467.                              <div class="table table-responsive">
  468.                                  <table class="table table-bordered table-bold">';
  469.             }
  470.              echo '<tr>
  471.                     <td style="text-align: center;">'.$atr.'</td>
  472.                     <td style="text-align: center;">LOKET '.$ly->LOKET.'</td>
  473.                   </tr>';
  474.             if ($count%10 == 0) {
  475.                   echo '</table>
  476.                         </div>
  477.                         </div>';
  478.             }
  479.  
  480.              $count++; }
  481.              if ($count%10 != 1) echo "</div>";
  482.        
  483.         mysqli_close($con);
  484.         die();
  485.      }
  486. ?>
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!