Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //General Controller
- include "../General_Controller.php";
- $gen_controller = new General_Controller();
- //Model Global
- include "../model/General_Model.php";
- $gen_model = new General_Model();
- //View
- $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=="repeat_panggilan") {
- $no_antrian = base64_decode($_REQUEST['no_antrian']);
- if(!empty($no_antrian)){
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $count = $db->GetOne("select count(*) as total from temp_panggilan where panggilan='".$loket.";".$no_antrian."' and id_temp_panggilan like '".date('ymd')."%'");
- if($count >= 3){
- echo "Melebihi batas pemanggilan";
- }
- else {
- $numbers = preg_replace('/[^0-9]/', '',$no_antrian);
- $insert_data = array();
- $insert_data['id_temp_panggilan'] = date('ymdHis');
- $insert_data['panggilan'] = $loket.";".$no_antrian;
- $insert_data['status'] = '0';
- $insert_data['urutan'] = $numbers;
- $insert_data['id_layanan'] = $ID_LAYANAN;
- $gen_model->Insert('temp_panggilan',$insert_data);
- echo "OK";
- }
- }
- $db->close();
- die();
- }
- else if($act=="antrian_current") {
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $count = $db->GetOne("select count(*) as total from data_antrian where status_panggilan='0' and loket is null and id_layanan='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' ");
- $no_antr="";
- if(!empty($count)){
- $count_current = $db->getOne("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')."%' ");
- if(!empty($count_current)){
- $antrian = $db->getRow("select * from data_antrian where loket='".$loket."' and id_layanan='".$ID_LAYANAN."' and status_current='Y' and tanggal like '".date('Y-m-d')."%' ");
- $antr = $antrian['no_urut'];
- if(empty($antr)){
- $no_antr="-";
- }
- else {
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- $update_data = array();
- $update_data['status_current'] = 'Y';
- $update_data['status_panggilan'] = '1';
- $update_data['loket'] = $loket;
- $where_data = array();
- $where_data['id_data_antrian'] = $antrian['id_data_antrian'];
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $no_antr= $antrian['no_urut']."%%$$%%".$antrian['prefix_suara'].$antrian['no_urut']."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- else {
- $query="select * from data_antrian where status_panggilan='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";
- $antrian = $db->getRow($query);
- $antr = $antrian['no_urut'];
- if(empty($antr)){
- $no_antr="-";
- }
- else {
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- $update_data = array();
- $update_data['status_current'] = 'Y';
- $update_data['status_panggilan'] = '1';
- $update_data['loket'] = $loket;
- $where_data = array();
- $where_data['id_data_antrian'] = $antrian['id_data_antrian'];
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $no_antr= $antrian['no_urut']."%%$$%%".$antrian['prefix_suara'].$antrian['no_urut']."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- }
- else {
- $count_current = $db->getOne("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')."%' ");
- if(!empty($count_current)){
- $antrian = $db->getRow("select * from data_antrian where loket='".$loket."' and id_layanan='".$ID_LAYANAN."' and status_current='Y' and tanggal like '".date('Y-m-d')."%' ");
- $antr = $antrian['no_urut'];
- if(empty($antr)){
- $no_antr="-";
- }
- else {
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- $update_data = array();
- $update_data['status_current'] = 'Y';
- $update_data['loket'] = $loket;
- $where_data = array();
- $where_data['id_data_antrian'] = $antrian['id_data_antrian'];
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $no_antr= $antrian['no_urut']."%%$$%%".$antrian['prefix_suara'].$antrian['no_urut']."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- else {
- $no_antr="-";
- }
- }
- echo $no_antr;
- $db->close();
- die();
- }
- else if($act=="antrian_check") {
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $count = $db->GetOne("select count(*) as total from data_antrian where status_panggilan='0' and loket is null and id_layanan='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' ");
- $no_antr="";
- if(!empty($count)){
- $count_current = $db->getOne("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')."%' ");
- if(!empty($count_current)){
- $antrian = $db->getRow("select * from data_antrian where loket='".$loket."' and id_layanan='".$ID_LAYANAN."' and status_current='Y' and tanggal like '".date('Y-m-d')."%' ");
- $antr = $antrian['no_urut'];
- if(empty($antr)){
- $no_antr="-";
- }
- else {
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- $update_data = array();
- $update_data['status_current'] = 'Y';
- $update_data['loket'] = $loket;
- $where_data = array();
- $where_data['id_data_antrian'] = $antrian['id_data_antrian'];
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $no_antr= $antrian['no_urut']."%%$$%%".$antrian['prefix_suara'].$antrian['no_urut']."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- else {
- $query="select * from data_antrian where status_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";
- $antrian = $db->getRow($query);
- $antr = $antrian['no_urut'];
- if(empty($antr)){
- $no_antr="-";
- }
- else {
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- $update_data = array();
- $update_data['status_current'] = 'Y';
- $update_data['loket'] = $loket;
- $where_data = array();
- $where_data['id_data_antrian'] = $antrian['id_data_antrian'];
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $no_antr= $antrian['no_urut']."%%$$%%".$antrian['prefix_suara'].$antrian['no_urut']."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- }
- else {
- $count_current = $db->getOne("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')."%' ");
- if(!empty($count_current)){
- $antrian = $db->getRow("select * from data_antrian where loket='".$loket."' and id_layanan='".$ID_LAYANAN."' and status_current='Y' and tanggal like '".date('Y-m-d')."%' ");
- $antr = $antrian['no_urut'];
- if(empty($antr)){
- $no_antr="-";
- }
- else {
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- $update_data = array();
- $update_data['status_current'] = 'Y';
- $update_data['loket'] = $loket;
- $where_data = array();
- $where_data['id_data_antrian'] = $antrian['id_data_antrian'];
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $no_antr= $antrian['no_urut']."%%$$%%".$antrian['prefix_suara'].$antrian['no_urut']."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- else {
- $no_antr="-";
- }
- }
- echo $no_antr;
- $db->close();
- die();
- }
- else if($act=="antrian_next_show") {
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $count = $db->GetOne("select count(*) as total from data_antrian where status_panggilan='0' and loket is null and id_layanan='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' ");
- if(!empty($count)){
- $query="select * from data_antrian where status_panggilan='0' and LOKET is null and id_layanan='".$ID_LAYANAN."' and tanggal like '".date('Y-m-d')."%' order by no_urut asc";
- $antrian = $db->getRow($query);
- $no_antr="";
- if(empty($antrian)){
- $no_antr="0";
- }
- else {
- $no_antr=$antrian['prefix_suara'].$antrian['no_urut'];
- }
- echo $no_antr;
- }
- else {
- echo "-";
- }
- $db->close();
- die();
- }
- else if($act=="antrian_panggil") {
- $id_panggilan = str_replace(' ','',$_REQUEST['id']);
- if(empty($id_panggilan)){
- die();
- }
- else {
- if($id_panggilan=="-"){
- die();
- }
- else if($id_panggilan=="undefined"){
- echo "undefined";
- die();
- }
- else {
- $loket = $_REQUEST['loket'];
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $antr=$db->getRow("select * from data_antrian where tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' and no_urut='".$id_panggilan."' ");
- $urut = preg_replace('/[^0-9]/', '', $id_panggilan);
- $insert_data = array();
- $insert_data['id_temp_panggilan'] = date('ymdHis');
- $insert_data['panggilan'] = $loket.";".$antr['prefix_suara'].$id_panggilan;
- $insert_data['status'] = '0';
- $insert_data['urutan'] = $urut;
- $insert_data['id_layanan'] = $ID_LAYANAN;
- $gen_model->Insert('temp_panggilan',$insert_data);
- }
- }
- $db->close();
- die();
- }
- else if($act=="antrian_next") {
- $id_panggilan = base64_decode($_REQUEST['id_panggilan']);
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- if(!empty($id_panggilan)){
- $db->execute("update data_antrian set status_panggilan='1',status_current='N' where tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' and no_urut='".$id_panggilan."' ");
- $db->execute("update data_antrian set status_current='N' where tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' ");
- }
- $count = $db->getOne("select count(*) as total from data_antrian where status_panggilan='0' and loket is null and tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' ");
- if(!empty($count)){
- $query="select * from data_antrian where status_panggilan='0' and loket is null and tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' ORDER BY no_urut asc";
- $antrian = $db->getRow($query);
- $no_antr="";
- if(empty($antrian)){
- $no_antr="0";
- }
- else {
- $no_antr=$antrian['no_urut'];
- }
- $db->execute("update data_antrian set status_current='Y' where id_data_antrian='".$antrian['id_data_antrian']."' ");
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- echo $no_antr."%%$$%%".$antrian['prefix_suara'].$no_antr."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- else {
- echo "-";
- }
- $db->close();
- die();
- }
- else if($act=="antrian_total") {
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $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 ";
- $antrian = $db->getRow($query);
- if(!empty($antrian)){
- echo $antrian['total'];
- }
- else {
- echo "-";
- }
- $db->close();
- die();
- }
- else if($act=="antrian_sisa") {
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $query="select count(*) as total_sisa,prefix_suara from data_antrian where status_panggilan='0' and tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' and (loket='".$loket."' or loket is null) group by prefix_suara";
- $antrian = $db->getRow($query);
- if(empty($antrian)) {
- $hasil = "-";
- }
- else {
- $ss = $antrian['total_sisa'];
- $hasil = $ss;
- }
- echo $hasil;
- $db->close();
- die();
- }
- else if($act=="antrian_fast") {
- $no_antrian = base64_decode($_REQUEST['no_antrian']);
- $loket = base64_decode($_REQUEST['loket']);
- $ly = $gen_model->GetOneRow("tr_layanan_loket",array('loket'=>$loket));
- if(!empty($ly['id_layanan_sub'])){
- $ID_LAYANAN = $ly['id_layanan_sub'];
- }
- else {
- $ID_LAYANAN = $ly['id_layanan'];
- }
- $get_number = preg_replace('/[^0-9]/', '', $no_antrian);
- $get_int = (int)$get_number;
- if(!empty($get_int)){
- $query= "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 ";
- $count = $db->GetRow($query);
- if(!empty($count)){
- $loket = base64_decode($_REQUEST['loket']);
- $count_repeat = $db->getOne("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')."%'");
- if($count_repeat >= 3){
- echo "NOK2";
- }
- else {
- $insert_data = array();
- $insert_data['id_temp_panggilan'] = date('ymdHis');
- $insert_data['panggilan'] = $loket.";".$count['prefix_suara'].$get_int;
- $insert_data['status'] = '0';
- $insert_data['urutan'] = $get_int;
- $insert_data['sumber'] = 'Panggilan_Cepat';
- $insert_data['keterangan'] = 'Panggilan Cepat '.$loket;
- $insert_data['id_layanan'] = $ID_LAYANAN;
- $gen_model->Insert('temp_panggilan',$insert_data);
- $no_antr = $count['prefix_suara'].$get_int;
- $antrian = $db->getRow("select * from data_antrian where tanggal like '".date('Y-m-d')."%' and id_layanan='".$ID_LAYANAN."' and no_urut='".$get_int."' ");
- $gbr = "no_data";
- $url_foto = $basepath."kiosk/assets/images/people/".$antrian['id_data_antrian'].".jpg";
- $check = file_exists($url_foto);
- if($check=="1"){
- $gbr = $url_foto;
- }
- echo $no_antr."%%$$%%".$gbr."%%$$%%".$antrian['id_data_antrian'];
- }
- }
- else {
- echo "NOK";
- }
- }
- else {
- echo "NOK";
- }
- $db->close();
- die();
- }
- else if($act=="send_to_board") {
- $board = base64_decode($_REQUEST['text']);
- $loket = base64_decode($_REQUEST['loket']);
- $gen_model->Delete('app_running_text_skp',array('LOKET'=>$loket));
- $insert_data = array();
- $insert_data['loket'] = $loket;
- $insert_data['text'] = $board;
- $gen_model->Insert('app_running_text_skp',$insert_data);
- $db->close();
- die();
- }
- else if($act=="check_waktu") {
- $id = $_REQUEST['id_data_antrian'];
- if(!empty($id)){
- $data = $gen_model->GetOneRow("data_antrian",array('id_data_antrian'=>$id));
- if(!empty($data['sisa_durasi'])){
- echo $data['sisa_durasi'];
- }
- else {
- echo "no_data";
- }
- }
- else {
- echo "no_data";
- }
- $db->close();
- die();
- }
- else if($act=="save_times") {
- $id = $_REQUEST['id_data_antrian'];
- $waktu = $_REQUEST['waktu'];
- $update_data = array();
- $update_data['sisa_durasi'] = $waktu;
- $where_data = array();
- $where_data['id_data_antrian'] = $id;
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $db->close();
- die();
- }
- else if($act=="save_durasi") {
- $id = $_REQUEST['id_data_antrian'];
- $durasi = $_REQUEST['durasi_total'];
- $update_data = array();
- $update_data['durasi'] = $durasi;
- $where_data = array();
- $where_data['id_data_antrian'] = $id;
- $gen_model->Update('data_antrian',$update_data,$where_data);
- $db->close();
- die();
- }
- else if($act=="layanan_current") {
- $loket = base64_decode($_REQUEST['loket']);
- $get_layanan = $db->getRow("select
- 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
- from tr_layanan_loket as lk
- inner join ms_layanan as ly
- on ly.id_layanan=lk.id_layanan
- left outer join ms_layanan_sub as ly_sb
- on ly_sb.id_layanan_sub = lk.id_layanan_sub
- where lk.loket='".$loket."'");
- $count = 1;
- if(!empty($get_layanan['nama_sub_layanan'])){
- $id_layanan = (!empty($get_layanan['nama_sub_layanan']) ? $get_layanan['nama_sub_layanan'] : '');
- $data_ly= $db->Execute("select ly_lk.loket,ly.nama_sub_layanan,ly.prefix_suara,(select dt.no_urut from data_antrian as dt where dt.id_layanan=ly.nama_sub_layanan and dt.status_panggilan='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
- inner join tr_layanan_loket as ly_lk
- on ly_lk.nama_sub_layanan=ly.nama_sub_layanan
- where ly.nama_sub_layanan='".$id_layanan."'
- order by -antrian desc,ly_lk.loket asc ");
- }
- else {
- $id_layanan = (!empty($get_layanan['id_layanan']) ? $get_layanan['id_layanan'] : '');
- $data_ly= $db->Execute("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.status_panggilan='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
- inner join tr_layanan_loket as ly_lk
- on ly_lk.id_layanan=ly.id_layanan
- where ly.id_layanan='".$id_layanan."'
- order by -antrian desc,ly_lk.loket asc ");
- }
- while($ly = $data_ly->FetchRow()){
- $atr = "-";
- if(!empty($ly['antrian'])){
- $atr = $ly['prefix_suara'].$ly['antrian'];
- }
- if ($count%10 == 1) {
- echo '<div class="col-md-6">
- <div class="table table-responsive">
- <table class="table table-bordered table-bold">';
- }
- echo '<tr>
- <td style="text-align: center;">'.$atr.'</td>
- <td style="text-align: center;">LOKET '.$ly['loket'].'</td>
- </tr>';
- if ($count%10 == 0) {
- echo '</table>
- </div>
- </div>';
- }
- $count++;
- }
- if ($count%10 != 1) echo "</div>";
- $db->close();
- die();
- }
- else if($act=="antrian_histori") {
- $param = $_REQUEST['param'];
- $param2 = $_REQUEST['param2'];
- include "view/histori_antrian.php";
- }
- else if($act=="antrian_histori_data") {
- //Model Histori Data
- include "model/histori_antrian.php";
- $md_hs = new histori();
- $aColumns = array('nama_layanan','no_urut','tanggal','durasi','sisa_durasi','id_data_antrian');
- // Input method (use $_GET, $_POST or $_REQUEST)
- $input =& $_POST;
- $iColumnCount = count($aColumns);
- $sLimit = $gen_controller->Paging($input);
- $sOrder = $gen_controller->Ordering($input, $aColumns );
- $sWhere = $gen_controller->Filtering($aColumns, $iColumnCount, $input);
- $aQueryColumns = array();
- foreach ($aColumns as $col) {
- if ($col != ' ') {
- $aQueryColumns[] = $col;
- }
- }
- $param = base64_decode($_REQUEST['param']);
- $param2 = base64_decode($_REQUEST['param2']);
- $rResult = $md_hs->getDataListHistori($param,$param2,$sWhere,$sOrder,$sLimit);
- $rResultFilterTotal = $md_hs->getCountListHistori($param,$param2,$sWhere);
- $output = array(
- "sEcho" => (empty($input['sEcho']) ? '0' : intval($input['sEcho'])),
- "iTotalRecords" => $rResultFilterTotal,
- "iTotalDisplayRecords" => $rResultFilterTotal,
- "aaData" => array(),
- );
- while($aRow = $rResult->FetchRow()){
- $foto = '<a title="Lihat Foto" href="#" style="cursor:pointer;text-decoration:none" onclick="detail_foto(\''.$aRow['id_data_antrian'].'\')" >Lihat Foto</a>';
- $row = array();
- $row = array("<center>".$aRow['layanan']."<center>","<center>".$aRow['no_urut']."<center>","<center>".$aRow['tanggal']."</center>","<center>".$aRow['durasi']."<center>","<center>".$aRow['sisa_durasi']."<center>","<center>".$foto."</center>");
- $output['aaData'][] = $row;
- }
- echo json_encode($output);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement