<?php
include "../database.php";
error_reporting(0);
mb_internal_encoding('UTF-8');
		$aColumns = array('at.TANGGAL','at.LOKET','gr.group_layanan','sb.sub_group_layanan','jn.jenis_permohonan','at.PERIHAL','pm.NAMA','pm.JENIS_KELAMIN','cp.company_name','pv.nama_prov','kb.nama_kab_kot','at.ID_DATA_ANTRIAN'); //Kolom Pada Tabel

		// Indexed column (used for fast and accurate table cardinality)
		$sIndexColumn = 'ID_DATA_ANTRIAN';

		// DB table to use
		$sTable  = 'data_antrian'; // Nama Tabel
		$sTable2 = 'data_group_layanan'; // Nama Tabel
		$sTable3 = 'data_sub_group_layanan'; // Nama Tabel
		$sTable4 = 'data_jenis_permohonan'; // Nama Tabel
		$sTable5 = 'data_biodata'; // Nama Tabel
		$sTable6 = 'data_company'; // Nama Tabel
		$sTable7 = 'ms_provinsi'; // Nama Tabel
		$sTable8 = 'ms_kabupaten_kota'; // Nama Tabel

		// Input method (use $_GET, $_POST or $_REQUEST)
		$input =& $_POST;


		$iColumnCount = count($aColumns);

		$db = mysqliConnection();
		$sLimit = Paging( $input );
		$sOrder = Ordering( $input, $aColumns );
		$sWhere = Filtering( $aColumns, $iColumnCount, $input, $db );

		$aQueryColumns = array();
		foreach ($aColumns as $col) {
			if ($col != ' ') {
				$aQueryColumns[] = $col;
			}
		}

		$jenis   = base64_decode($_REQUEST['jenis']);
		$sQuery = "SELECT SQL_CALC_FOUND_ROWS at.*,gr.group_layanan,sb.sub_group_layanan,jn.jenis_permohonan,pm.NAMA,pm.JENIS_KELAMIN,cp.company_name,pv.nama_prov,kb.nama_kab_kot
					FROM ".$sTable." as at
					inner join ".$sTable2." as gr
						on gr.id_group_layanan=at.ID_GROUP_LAYANAN
					left outer join ".$sTable3." as sb
						on sb.id_sub_group_layanan=at.ID_SUB_GROUP_LAYANAN
					left outer join ".$sTable4." as jn
						on jn.id_jenis_permohonan=at.ID_JNS_PERMOHONAN
					inner join ".$sTable5." as pm
						on pm.ID_BIODATA=at.ID_BIODATA
					inner join ".$sTable6." as cp
						on cp.company_id=at.ID_COMPANY
					left outer join ".$sTable7." as pv
						on pv.id_prov=cp.id_prov
					left outer join ".$sTable8." as kb
						on kb.id_kabkot=cp.id_kabkot
					".$sWhere." and at.jenis='".$jenis."'  ".$sOrder.$sLimit;
		//echo $sQuery;
		$rResult = $db->query( $sQuery ) or die($db->error);
		// Data set length after filtering
		$sQuery = "SELECT FOUND_ROWS()";
		$rResultFilterTotal = $db->query( $sQuery ) or die($db->error);
		list($iFilteredTotal) = $rResultFilterTotal->fetch_row();

		// Total data set length
		$sQuery = "SELECT COUNT(at.".$sIndexColumn.")
					FROM ".$sTable." as at
					inner join ".$sTable2." as gr
						on gr.id_group_layanan=at.ID_GROUP_LAYANAN
					left outer join ".$sTable3." as sb
						on sb.id_sub_group_layanan=at.ID_SUB_GROUP_LAYANAN
					left outer join ".$sTable4." as jn
						on jn.id_jenis_permohonan=at.ID_JNS_PERMOHONAN
					inner join ".$sTable5." as pm
						on pm.ID_BIODATA=at.ID_BIODATA
					inner join ".$sTable6." as cp
						on cp.company_id=at.ID_COMPANY
					left outer join ".$sTable7." as pv
						on pv.id_prov=cp.id_prov
					left outer join ".$sTable8." as kb
						on kb.id_kabkot=cp.id_kabkot
					".$sWhere." and at.jenis='".$jenis."' ";
		$rResultTotal = $db->query( $sQuery ) or die($db->error);
		list($iTotal) = $rResultTotal->fetch_row();

		/**
			* Output
		*/
		$output = array(
		"sEcho"                => intval($input['sEcho']),
		"iTotalRecords"        => $iTotal,
		"iTotalDisplayRecords" => $iFilteredTotal,
		"aaData"               => array(),
		);

		// Looping Data
		while ( $aRow = $rResult->fetch_assoc())
		{
			$row = array();
			$detail ='<button title="Detail" class="btn btn-info btn-aksi" data-toggle="modal" data-target="#myModalDetail"  style="cursor:pointer" onclick="window.parent.detail(\''.base64_encode($aRow['ID_DATA_ANTRIAN']).'\')"><i class="fa fa-file"></i></button>';
			$row = array(($aRow['TANGGAL']==null ? '<center>-</center>' : date_indo(substr($aRow['TANGGAL'], 0,-9))),$aRow['LOKET'],$aRow['group_layanan'],$aRow['sub_group_layanan'],$aRow['jenis_permohonan'],$aRow['PERIHAL'],$aRow['NAMA'],$aRow['JENIS_KELAMIN'],$aRow['company_name'],$aRow['nama_prov'],$aRow['nama_kab_kot'],"<center>".$detail."</center>");
			$output['aaData'][] = $row;
		}

		echo json_encode($output);

?>