plasma/ajax_antrian.php

 <?php
 include '../config.php';
$qry = "select ly.ID_LAYANAN,ly.NAMA_LAYANAN,ly.PREFIX_SUARA
from ms_layanan as ly
  order by ly.CREATED_DATE asc";
  $data_ly = mysqli_query($con,$qry);
while($ly=mysqli_fetch_object($data_ly)){
    //check sub
    $check_sub = mysqli_fetch_object(mysqli_query($con,"select count(*) as total
              from ms_layanan_sub as ly_sb
          where ly_sb.ID_LAYANAN='".$ly->ID_LAYANAN."' "));
    if($check_sub->total>0){
        $data_sub = mysqli_query($con,"select ly_sb.ID_LAYANAN_SUB,ly_sb.NAMA_SUB_LAYANAN,ly_sb.PREFIX_SUARA
              from ms_layanan_sub as ly_sb
          where ly_sb.ID_LAYANAN='".$ly->ID_LAYANAN."'  order by ly_sb.CREATED_DATE asc");

        while($ly_sb=mysqli_fetch_object($data_sub)){


                //Antrian Saat ini
              $antrian_saat_ini ="-";
              $antrian_saat_ini_loket="-";
              $data_saat_ini = mysqli_fetch_object(mysqli_query($con,"SELECT PANGILAN from temp_panggilan where  ID_TEMP_PANGGILAN like '".date("ymd")."%' and ID_LAYANAN='".$ly_sb->ID_LAYANAN_SUB."' AND STATUS='0' order by URUT ASC LIMIT 0,1"));
              $sekarang = explode(";",$data_saat_ini->PANGILAN);
              if(!empty($data_saat_ini->PANGILAN)){
                $antrian_saat_ini = $sekarang[1];
                $antrian_saat_ini_loket = $sekarang[0];
              }
          else {
             $data_saat_ini = mysqli_fetch_object(mysqli_query($con,"SELECT PANGILAN from temp_panggilan where  ID_TEMP_PANGGILAN like '".date("ymd")."%' and ID_LAYANAN='".$ly_sb->ID_LAYANAN_SUB."'  order by URUT DESC LIMIT 0,1"));
            $sekarang = explode(";",$data_saat_ini->PANGILAN);
            if(!empty($data_saat_ini->PANGILAN)){
              $antrian_saat_ini = $sekarang[1];
              $antrian_saat_ini_loket = $sekarang[0];
            }
          }

              //Antrian Sisa
              $antrian_sisa = "-";
              //$data_sisa = mysqli_fetch_object(mysqli_query($con,"SELECT count(ID_DATA_ANTRIAN) as total_sisa from data_antrian where (DATE_FORMAT(TANGGAL,'%Y-%m-%d')='".date("Y-m-d")."') AND (ID_LAYANAN = '".$ly_sb->ID_LAYANAN_SUB."') AND (STAT_PANGILAN = '0');"));
              $data_sisa = mysqli_fetch_object(mysqli_query($con,"select count(*) as total_sisa from data_antrian where stat_pangilan='0' and tanggal like '".date("Y-m-d")."%' and ID_LAYANAN='".$ly_sb->ID_LAYANAN_SUB."' and LOKET is null"));
              if($data_sisa->total_sisa!="0"){
                $antrian_sisa = $data_sisa->total_sisa-1;
              }

         ?>
       <div class="col-md-4">
          <div class="alert alert-dark boxed" role="alert">
            <span style="font-weight: bold; display: block;"><?php echo $ly_sb->PREFIX_SUARA ?>.<?php echo $ly_sb->NAMA_SUB_LAYANAN ?></span>
            <span class="txt-wh">Sisa <?php echo $antrian_sisa ?></span>
            <span class="txt-wh">| Loket <b><?php echo $antrian_saat_ini_loket ?></b> |</span>
            <span class="txt-wh">No.Antrian</span>
            <h1 style="position: absolute; top: 14px; right: 8px; font-weight: bold;"><?php echo $antrian_saat_ini ?></h1>
          </div>
        </div>
    <?php }
    } else {

        //Antrian Saat ini
        $antrian_saat_ini ="-";
        $antrian_saat_ini_loket="-";
        $data_saat_ini = mysqli_fetch_object(mysqli_query($con,"SELECT PANGILAN from temp_panggilan where  ID_TEMP_PANGGILAN like '".date("ymd")."%' and ID_LAYANAN='".$ly->ID_LAYANAN."' AND STATUS='0' order by URUT ASC LIMIT 0,1"));
        $sekarang = explode(";",$data_saat_ini->PANGILAN);
        if(!empty($data_saat_ini->PANGILAN)){
          $antrian_saat_ini = $sekarang[1];
          $antrian_saat_ini_loket = $sekarang[0];
        }
        else {
           $data_saat_ini = mysqli_fetch_object(mysqli_query($con,"SELECT PANGILAN from temp_panggilan where  ID_TEMP_PANGGILAN like '".date("ymd")."%' and ID_LAYANAN='".$ly->ID_LAYANAN."'  order by URUT DESC LIMIT 0,1"));
            $sekarang = explode(";",$data_saat_ini->PANGILAN);
            if(!empty($data_saat_ini->PANGILAN)){
              $antrian_saat_ini = $sekarang[1];
              $antrian_saat_ini_loket = $sekarang[0];
            }
        }

        //Antrian Sisa
        $antrian_sisa = "-";
        // $data_sisa = mysqli_fetch_object(mysqli_query($con,"SELECT count(ID_DATA_ANTRIAN) as total from data_antrian where (DATE_FORMAT(TANGGAL,'%Y-%m-%d')='".date("Y-m-d")."') AND (ID_LAYANAN = '".$ly->ID_LAYANAN."') AND (STAT_PANGILAN = '0');"));
        $data_sisa = mysqli_fetch_object(mysqli_query($con,"select count(*) as total_sisa from data_antrian where stat_pangilan='0' and tanggal like '".date("Y-m-d")."%' and ID_LAYANAN='".$ly->ID_LAYANAN."' and LOKET is null"));
        if($data_sisa->total_sisa!="0"){
          $antrian_sisa = $data_sisa->total_sisa-1;
        }

     ?>
       <div class="col-md-4">
          <div class="alert alert-dark boxed" role="alert">
            <span style="font-weight: bold; display: block;"><?php echo $ly->PREFIX_SUARA ?>.<?php echo $ly->NAMA_LAYANAN ?></span>
            <span class="txt-wh">Sisa <?php echo $antrian_sisa ?></span>
            <span class="txt-wh">| Loket <b><?php echo $antrian_saat_ini_loket ?></b> |</span>
            <span class="txt-wh">No.Antrian</span>
            <h1 style="position: absolute; top: 14px; right: 8px; font-weight: bold;"><?php echo $antrian_saat_ini ?></h1>
          </div>
        </div>
<?PHP }
}
 mysqli_close($con);
 die();
 ?>