plasma_2

<?php
//General Controller
include "../General_Controller.php";
$gen_controller  = new General_Controller();

//Model Global
include "../model/General_Model.php";
$gen_model      = new General_Model();

$act="";
if(isset($_GET['do_act'])){
    $act = $_GET['do_act'];
}

$id_parameter="";
if(isset($_GET['id_parameter'])){
        $id_parameter =$_GET['id_parameter'];
}

if($act=="" or $act==null) {
   $gen_controller->response_code('404');
}
else if($act=="jam") {
    echo date("l d, F Y");
    die();
}
else if($act=="panggil") {
    $id_pg = $_REQUEST['id_pg'];

    $update_data = array();
    $update_data['status']              = '1';

     //Paramater
    $where_data = array();
    $where_data['id_panggilan']      = $id_pg;

    $gen_model->Update('temp_panggilan',$update_data,$where_data);

    $db->close();
    die();
}
else if($act=="ajax_pop_up") {

    $qry  = "select * from temp_panggilan  where  status='0' and id_temp_panggilan like '".date('ymd')."%' order by id_temp_panggilan ASC";
    $data = $db->getRow($qry);
    $mydata = "no_data";
    if(!empty($data)){
        $str_pg  = (explode(";",$data['panggilan']));
        $lkt     = $str_pg[0];
        $antrian = $str_pg[1];
        $panggil =  $str_pg[0]."%%$$%%".$str_pg[1];
        echo $panggil;
    }
    else {
        echo $mydata;
    }

    $db->close();
    die();
}
else if($act=="ajax_antrian"){
    $qry = "select ly.id_layanan,ly.nama_layanan,ly.prefix_suara
    from ms_layanan as ly
      order by ly.id_layanan asc";
      $data_ly = $db->execute($qry);
      while($ly = $data_ly->FetchRow()){
        //check sub
        $check_sub = $gen_model->getOne("count(*) as total","ms_layanan_sub",array('id_layanan'=>$ly['id_layanan']));
        if($check_sub>0){
            $sub_qry = "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.id_layanan_sub asc";
            $data_sub = $db->execute($sub_qry);
            while($ly_sb = $data_sub->FetchRow()){
                    //Antrian Saat ini
                  $antrian_saat_ini ="-";
                  $antrian_saat_ini_loket="-";
                  $saat_ini_qry = "SELECT panggilan from temp_panggilan where  id_temp_panggilan like '".date("ymd")."%' and id_layanan='".$ly_sb['id_layanan_sub']."' AND status='0' order by urutan ASC LIMIT 0,1";
                  $data_saat_ini = $db->getRow($saat_ini_qry);

                  if(!empty($data_saat_ini['panggilan'])){
                    $sekarang = explode(";",$data_saat_ini['panggilan']);
                    $antrian_saat_ini = $sekarang[1];
                    $antrian_saat_ini_loket = $sekarang[0];
                  }
              else {
                $saat_ini_qry = "SELECT panggilan from temp_panggilan where  id_temp_panggilan like '".date("ymd")."%' and id_layanan='".$ly_sb['id_layanan_sub']."'  order by urutan DESC LIMIT 0,1";
                $data_saat_ini = $db->getRow($saat_ini_qry);
                if(!empty($data_saat_ini['panggilan'])){

                  $sekarang = explode(";",$data_saat_ini['panggilan']);
                  $antrian_saat_ini = $sekarang[1];
                  $antrian_saat_ini_loket = $sekarang[0];
                }
              }

                  //Antrian Sisa
                  $antrian_sisa = "-";
                  $sisa_qry = "select count(*) as total_sisa from data_antrian where status_panggilan='0' and tanggal like '".date("Y-m-d")."%' and id_layanan='".$ly_sb['id_layanan_sub']."' and loket is null";
                   $data_sisa = $db->getOne($sisa_qry);
                  if($data_sisa!="0"){
                    $antrian_sisa = $data_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="-";
            $saat_ini_qry = "SELECT panggilan from temp_panggilan where  id_temp_panggilan like '".date("ymd")."%' and id_layanan='".$ly['id_layanan']."' AND status='0' order by urutan ASC LIMIT 0,1";
            $data_saat_ini = $db->getRow($saat_ini_qry);
            if(!empty($data_saat_ini['panggilan'])){
              $sekarang = explode(";",$data_saat_ini['panggilan']);
              $antrian_saat_ini = $sekarang[1];
              $antrian_saat_ini_loket = $sekarang[0];
            }
            else {
               $saat_ini_qry = "SELECT panggilan from temp_panggilan where  id_temp_panggilan like '".date("ymd")."%' and id_layanan='".$ly['id_layanan']."'  order by urutan DESC LIMIT 0,1";
                $data_saat_ini = $db->getRow($saat_ini_qry);
                if(!empty($data_saat_ini['panggilan'])){
                  $sekarang = explode(";",$data_saat_ini['panggilan']);
                  $antrian_saat_ini = $sekarang[1];
                  $antrian_saat_ini_loket = $sekarang[0];
                }
            }

            //Antrian Sisa
            $antrian_sisa = "-";
            $sisa_qry = "select count(*) as total_sisa from data_antrian where status_panggilan='0' and tanggal like '".date("Y-m-d")."%' and id_layanan='".$ly['id_layanan']."' and loket is null";
            $data_sisa = $db->getOne($sisa_qry);
            if($data_sisa!="0"){
              $antrian_sisa = $data_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 }
    }
     $db->close();
    die();
}
else {
    $gen_controller->response_code(http_response_code());
}
?>