Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- else if($act=="ambil_tiket_layanan") {
- $id_layanan = base64_decode($_REQUEST['id_layanan']);
- //Check Data
- $ly = $gen_model->GetOneRow("ms_layanan",array('id_layanan'=>$id_layanan));
- //No Urut
- $query="select * from data_antrian where tanggal like '".date('Y-m-d')."%' and id_layanan='".$id_layanan."' order by no_urut desc ";
- $antrian = $db->getRow($query);
- $no_urut="";
- if(empty($antrian)){
- $no_urut="1";
- }
- else {
- $var = str_pad(++$antrian['no_urut'],4,'0',STR_PAD_LEFT);
- $no_urut = intval($var);
- }
- if($ly['status']=="0"){
- $show = array(
- 'error'=>'NOT_AVAIBLE'
- );
- echo json_encode($show);
- }
- else if($no_urut>$ly['kouta']){
- $show = array(
- 'error'=>'NOT_PRINT'
- );
- echo json_encode($show);
- }
- else if(!empty($data_ly['jam_awal']) and date("H:i") < $data_ly['jam_awal']){
- $show = array(
- 'error'=>'NOT_JAM_AWAL'
- );
- echo json_encode($show);
- }
- else if(!empty($data_ly['jam_akhir']) and date("H:i")>$data_ly['jam_akhir']){
- $show = array(
- 'error'=>'NOT_JAM_AKHIR'
- );
- echo json_encode($show);
- }
- else {
- //ID Antrian
- $query_urutan="select id_data_antrian from data_antrian where tanggal like '".date('Y-m-d')."%' order by id_data_antrian desc ";
- $antrian_urut = $db->getOne($query_urutan);
- $urut = "";
- if(empty($antrian_urut)){
- $urut = date("ymd")."0001";
- }
- else {
- $urut = $antrian_urut+1;
- }
- $insert_data = array();
- $insert_data['prefix_suara'] = $ly['prefix_suara'];
- $insert_data['id_data_antrian'] = $urut;
- $insert_data['tanggal'] = $date_now_indo_full;
- $insert_data['no_urut'] = $no_urut;
- $insert_data['status_panggilan'] = '0';
- $insert_data['id_layanan'] = $id_layanan;
- $insert_data['layanan'] = $ly['nama_layanan'];
- $insert_data['lantai'] = $ly['id_lantai'];
- $gen_model->Insert('data_antrian',$insert_data);
- $jmlAntrianSisa = 0;
- $qry_antrian_sisa = "SELECT count(id_data_antrian) as total from data_antrian where (DATE_FORMAT(tanggal,'%Y-%m-%d')='".date("Y-m-d")."') AND (id_layanan = '".$id_layanan."') AND (status_panggilan = '0')";
- $antrian_sisa = $db->getOne($qry_antrian_sisa);
- $lantai = $gen_model->GetOne("lantai","ms_lantai",array('id_lantai'=>$ly['id_lantai']));
- $show = array(
- 'layanan'=>$ly['nama_layanan'],
- 'no_urut'=>$ly['prefix_suara'].$no_urut,
- 'sisa'=>$antrian_sisa,
- 'lantai'=>$lantai,
- 'error'=>'PRINT'
- );
- echo json_encode($show);
- }
- }
- else if($act=="ambil_tiket_layanan_sub") {
- $id_layanan_sub = base64_decode($_REQUEST['id_layanan_sub']);
- //Check Data
- $ly = $gen_model->GetOneRow("ms_layanan_sub",array('id_layanan_sub'=>$id_layanan_sub));
- //No Urut
- $query="select * from data_antrian where tanggal like '".date('Y-m-d')."%' and id_layanan='".$id_layanan_sub."' order by no_urut desc ";
- $antrian = $db->getRow($query);
- $no_urut="";
- if(empty($antrian)){
- $no_urut="1";
- }
- else {
- $var = str_pad(++$antrian['no_urut'],4,'0',STR_PAD_LEFT);
- $no_urut = intval($var);
- }
- if($ly['status']=="0"){
- $show = array(
- 'error'=>'NOT_AVAIBLE'
- );
- echo json_encode($show);
- }
- else if($no_urut>$ly['kouta']){
- $show = array(
- 'error'=>'NOT_PRINT'
- );
- echo json_encode($show);
- }
- else if(!empty($data_ly['jam_awal']) and date("H:i") < $data_ly['jam_awal']){
- $show = array(
- 'error'=>'NOT_JAM_AWAL'
- );
- echo json_encode($show);
- }
- else if(!empty($data_ly['jam_akhir']) and date("H:i")>$data_ly['jam_akhir']){
- $show = array(
- 'error'=>'NOT_JAM_AKHIR'
- );
- echo json_encode($show);
- }
- else {
- //ID Antrian
- $query_urutan="select id_data_antrian from data_antrian where tanggal like '".date('Y-m-d')."%' order by id_data_antrian desc ";
- $antrian_urut = $db->getOne($query_urutan);
- $urut = "";
- if(empty($antrian_urut)){
- $urut = date("ymd")."0001";
- }
- else {
- $urut = $antrian_urut+1;
- }
- $id_lantai = $gen_model->GetOne("id_lantai","ms_layanan",array('id_layanan'=>$ly['id_layanan']));
- $lantai = $gen_model->GetOne("lantai","ms_lantai",array('id_lantai'=>$id_lantai));
- $insert_data = array();
- $insert_data['prefix_suara'] = $ly['prefix_suara'];
- $insert_data['id_data_antrian'] = $urut;
- $insert_data['tanggal'] = $date_now_indo_full;
- $insert_data['no_urut'] = $no_urut;
- $insert_data['status_panggilan'] = '0';
- $insert_data['id_layanan'] = $id_layanan_sub;
- $insert_data['layanan'] = $ly['nama_sub_layanan'];
- $insert_data['lantai'] = $lantai;
- $gen_model->Insert('data_antrian',$insert_data);
- $jmlAntrianSisa = 0;
- $qry_antrian_sisa = "SELECT count(id_data_antrian) as total from data_antrian where (DATE_FORMAT(tanggal,'%Y-%m-%d')='".date("Y-m-d")."') AND (id_layanan = '".$id_layanan_sub."') AND (status_panggilan = '0')";
- $antrian_sisa = $db->getOne($qry_antrian_sisa);
- $show = array(
- 'layanan'=>$ly['nama_sub_layanan'],
- 'no_urut'=>$ly['prefix_suara'].$no_urut,
- 'sisa'=>$antrian_sisa,
- 'lantai'=>$lantai,
- 'error'=>'PRINT'
- );
- echo json_encode($show);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement