<?php
include "model/model.php";
class controller{
	function __construct(){
		$this->model = new model();
	}
	function index(){
		if(file_exists("view/main.php")){
			require "view/main.php";
		}else{
			echo "Fungsi Utama pada Modul View Belum Ada!!";
		}
	}
	function logout(){
		session_destroy();
		echo "<script type=\"text/javascript\">window.location.href=\"./login\";</script>";
		/* if(file_exists("view/login.php")){
			require "view/login.php";
		}else{
			echo "Fungsi Logout Belum ada Pada Modul View!!";
		} */
	}
	function login(){
		if(file_exists("view/login.php")){
			require "view/login.php";
		}else{
			echo "Fungsi login Belum ada Pada Modul View!!";
		}
	}
	function tracking(){
		if(file_exists("view/tracking.php")){
			require "view/tracking.php";
		}else{
			echo "Fungsi Tracking Belum ada Pada Modul View!!";
		}
	}
	function disposisiprint(){
		require "view/view_disposisi_print.php";
	}
	function smprint_out(){
		require "view/sm_report_print.php";
	}
	function skprint_out(){
		require "view/sk_report_print.php";
	}
	function dispoprint_out(){
		require "view/dispo_report_print.php";
	}
	function arsip_print_out(){
		require "view/arsip_report_print.php";
	}
	function memoprint(){
		require "view/view_memo_print.php";
	}
	function smprint(){
		require "view/view_sm_accept_print.php";
	}
	function print_sm(){
		require "view/view_surat_digital_print.php";
	}
	function progressprint(){
		require "view/progress_report_print.php";
	}
	
	// function get_pegawai(){
		// $unitkerjaid = "1"; // $_POST['unitkerjaid'];
		// $field = array("user.id_user", "user.nama", "(SELECT b.nama_jabatan FROM user_jabatan b WHERE b.id_jab = user.jabatan) as nama_jabatan");
		// $params = array(':unitkerjaid' => $unitkerjaid);
		// $getdata= $this->model->selectprepare("user", $field, $params, 'unitkerjaid=:unitkerjaid', $order=null);
		// if($getdata->rowCount() >= 1){
			// while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){
				// $NamaUser = $datashow->nama ." (".$datashow->nama_jabatan .")";
				// echo "<option value='".$datashow->id_user."'>".$NamaUser."</option>";
			// }
		// }
		// $test = ["1","2"];
		// foreach ($test as $key) {
			// echo "key: ".$key;
			//echo "|| value: ".$value;
			// echo "<br>";
		// }
	// }
	function get_kodemasalah(){
		$kode_masalah = $_POST['kode_masalah'];
		$params = array(':kode_masalah' => $kode_masalah);
		$getdata= $this->model->selectprepare("kode_masalah", $field=null, $params, 'kode_masalah=:kode_masalah', $order=null);
		$kodemasalah = "";
		if($getdata->rowCount() >= 1){
			while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){
				$kode = $datashow->kode_masalah.".".$datashow->primer.".".$datashow->sekunder." (".$datashow->keterangan.")";
				$kodemasalah .= "<option value='".$datashow->id."'>".$kode."</option>";
			}
		}

		$sisa = "";
		if(isset($_POST['tgl_agenda'])) {
			$UKer = $this->model->selectprepare("unit_kerja", $field=null, $params=null, $where=null, "WHERE unit_kerja.id = ".$_SESSION['unitkerjaid']." ");
			$dataUKer = $UKer->fetch(PDO::FETCH_OBJ);
			$unitkerja = $dataUKer->kode1;
			$unitkerjaid = $dataUKer->id;

			//## Cek Data di Pengaturan ##
			$params		= array(':status' => 1);
			$pengaturan	= $this->model->selectprepare("pengaturan", $field=null, $params, "status=:status", $other=null);
			$data_pengaturan = $pengaturan->fetch(PDO::FETCH_OBJ);
			$hari_backdate 	 = $data_pengaturan->hari_backdate;

			$tgl_agenda = $_POST['tgl_agenda'];
			$tgl_agenda = explode("-",$tgl_agenda);
			$tgl_agendadb = $tgl_agenda[2]."-".$tgl_agenda[1]."-".$tgl_agenda[0];
			$table		= $_POST['table'];
			$cek_sisa = $this->model->selectprepare($table, $field=null, $params=null, $where=null, "WHERE kodemasalah ='".$kode_masalah."' AND unitkerjaid ='".$unitkerjaid."' AND tgl_agenda ='".$tgl_agendadb."' AND backdate_status='1'");
			$sisa = $hari_backdate - $cek_sisa->rowCount();
		}

		$return = array(
			'kodemasalah'	=> $kodemasalah,
			'sisa'			=> $sisa
		);
		echo json_encode($return);
	}

	function get_suratkeluar(){
		$table = $_POST['table'];
		$getdata = $this->model->selectprepare($table, $field=null, $params=null, $where=null, "ORDER BY tgl_agenda DESC");
		echo "<option value=''>== Pilih No Agenda ==</option>";
		if($getdata->rowCount() >= 1){
			while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){
				$internal = ($table == 'surat_keluar_internal') ? "internal" : "";
				$kode = $this->model->noref($datashow->id_sk, $internal);
				echo "<option value='".$datashow->id_sk."'>".$kode."</option>";
			}
		}
	}

	function get_autouser(){
		$queryString = $_POST['queryString'];
		$jenis = $_POST['jenis'];
		if(isset($_POST['queryString'])) {
			$getdata = $this->model->selectprepare("user", $field=null, $params=null, $where=null, "WHERE user.nama LIKE '%".$queryString."%'");
			if($getdata->rowCount() >= 1){
				echo "<ul>";
				while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){
					if($jenis == "pembuat"){
						echo '<li onClick="fill(\''.addslashes($datashow->nama).'\'); fill1(\''.addslashes($datashow->id_user).'\');">'.$datashow->nama.'&nbsp;&nbsp;'.$datashow->nik.'</li>';
					} else {
						echo '<li onClick="fillq(\''.addslashes($datashow->nama).'\'); fillq1(\''.addslashes($datashow->id_user).'\');">'.$datashow->nama.'&nbsp;&nbsp;'.$datashow->nik.'</li>';
					}
				}
				echo "</ul>";
			} else {
				echo "Pegawai tidak ditemukan...";
			}
		}
	}
	
	// Tambahan Imam
	
	function get_title($op, $jenis){
		$title = $this->model->selectprepare("tb_title", $field=null, $params=null, $where=null, "WHERE op = '{$op}' and jenis='{$jenis}' ")->fetch(PDO::FETCH_OBJ);
		
		return $title->title;
	}
	function cutText($text, $length, $mode = 2)
	{
		if ($mode != 1)
		{
			$char = $text{$length - 1};
			switch($mode)
			{
				case 2: 
					while($char != ' ') {
						$char = $text{--$length};
					}
				case 3:
					while($char != ' ') {
						$char = $text{++$num_char};
					}
			}
		}
		return substr($text, 0, $length);
	}
	
	// function get_short_url($url){
		// $short_url=substr(md5($url.mt_rand()),0,8);
		// $sql = pg_query("INSERT INTO tbl_shorturl (short_url, long_url) VALUES ('{$short_url}','{$url}')");
		// return $short_url;  
	// }
	
	// function get_pegawai($nip){
		// $sql_d = "SELECT count(*) as count FROM tag where nip ='".$nip."'";
		// $hasil = pg_query($sql_d);
		// $row   = pg_fetch_array($hasil);
		// $count  = $row['count'];
		// return $count;
	// }
	
	// function insertUrl($short, $long){
		// $sql = "INSERT INTO tbl_shorturl (short_url, long_url) VALUES ('{$short}','{$long}')";
		// $rs = pg_query($sql);
	// }
	
	function sendSMSMasking($id, $handphone, $text, $no_surat=''){
		$usernamesmsmasking="wika_bsi";
		$passwordsmsmasking="bfdb70970ec8f41e4016f6e341c7596c";
		$sender="WIKA-SURAT";
		$drurl="103.25.196.29";#ip public hcis.wika.co.id
		$subs=substr($handphone,1);
		$depan=substr($handphone,0,1);
		if($depan=="0") $handphone="62".$subs;
		$data_xml="data=
		<bulk_sending>
			<username>".$usernamesmsmasking."</username>
			<password>".$passwordsmsmasking."</password>
			<priority>high</priority>
			<sender>".$sender."</sender>
			<dr_url>".$drurl."</dr_url>
			<allowduplicate>1</allowduplicate>
			<data_packet>
				<packet>
					<msisdn>".$handphone."</msisdn>
					<sms>".$text."</sms>
					<is_long_sms>Y</is_long_sms>
				</packet>
			</data_packet>
		</bulk_sending>
		";
		$URL = "http://webapps.promediautama.com:29003/sms_applications/smsb/api_mt_send_message.php";
		$ch = curl_init($URL);
		curl_setopt($ch, CURLOPT_MUTE, 1);
		curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
		curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
		curl_setopt($ch, CURLOPT_POST, 1);
		curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/x-www-form-urlencoded'));
		curl_setopt($ch, CURLOPT_POSTFIELDS, $data_xml);
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
		$output = curl_exec($ch);
		curl_close($ch);
		
		// $sql = "INSERT INTO tbl_sms (id_surat, no_hp, sms, no_surat) values(".$id.",'".$handphone."','".$text."','".$no_surat."')";
		// $result = pg_query($sql); 
	}


	function get_pegawais(){
		$tampilkan 	= isset($_GET['data']);
		$m_display 	= $_POST['m_display'];
		$m_cari 	= $_POST['m_cari'];

		//##mendapatkan rule tujuan kerja ##//
		$rule_unitkerja = json_decode($_SESSION['rule_unitkerja'], true);
		$txt_uker = '';
		if(count($rule_unitkerja)>0){
			foreach ($rule_unitkerja as $key => $val) {
				$txt_uker .= $val;
				if($key < count($rule_unitkerja)-1){
					$txt_uker .= ',';
				}
			}
		}
		$tampil = '';
		$tampil2 = '';
		if($tampilkan == ""){
			$tampil = "user.unitkerjaid IN (".$txt_uker.") AND";
			$tampil2 = "WHERE user.unitkerjaid IN (".$txt_uker.")";
		}

		$field = array(
			"user.id_user", 
			"user.nik", 
			"user.nama", 
			"(SELECT b.nama_jabatan FROM user_jabatan b WHERE b.id_jab = user.jabatan) as nama_jabatan");
		$getdata = $this->model->selectprepare("user", $field, $params=null, $where=null, "WHERE ".$tampil." (user.nama LIKE '%".$m_cari."%' OR (SELECT b.nama_jabatan FROM user_jabatan b WHERE b.id_jab = user.jabatan) LIKE '%".$m_cari."%') order by nama ASC LIMIT 0, ".$m_display);

		$getdata2 = $this->model->selectprepare("user", $field=null, $params=null, $where=null, $tampil2);

		$jumlahdata = $getdata2->rowCount();
		$html = "";
		$html2 = "";
		if($getdata->rowCount() >= 1){
			while($datashow = $getdata->fetch(PDO::FETCH_OBJ)){
				$html .= '<tr>
							<td class="center">
								<label class="pos-rel">
									<input type="checkbox" class="ace ace_pilih" value="'.$datashow->id_user.'" attrnama="'.$datashow->nama.' ('.$datashow->nik.')"/>
									<span class="lbl"></span>
								</label>
							</td>

							<td>'.$datashow->nik.'</td>
							<td>'.$datashow->nama.'</td>
							<td>'.$datashow->nama_jabatan.'</td>
						  </tr>';
				$html2 .= '<tr>
							<td class="center">
								<label class="pos-rel">
									<input type="checkbox" class="ace ace_pilih2" value="'.$datashow->id_user.'" attrnama="'.$datashow->nama.' ('.$datashow->nik.')"/>
									<span class="lbl"></span>
								</label>
							</td>

							<td>'.$datashow->nik.'</td>
							<td>'.$datashow->nama.'</td>
							<td>'.$datashow->nama_jabatan.'</td>
						  </tr>';
			}
		} else {
			$html .= "data kosong!!!";
			$html2 .= "data kosong!!!";
		}
		$return = array(
			'html'			=> $html,
			'html2'			=> $html2,
			'jumlahdata'	=> $jumlahdata
		);
		echo json_encode($return);
	}

	function get_users(){
		$table 	= $_POST['table'];
		$id 	= $_POST['id'];

		if($table == "surat_keluar_internal"){
			$q_where = "WHERE id_sk = '".$id."'";
			$field	= array("tujuan as tujuan", "tembusan as tembusan");
		} elseif($table == "surat_keluar"){
			$q_where = "WHERE id_sk = '".$id."'";
			$field	= array("'' as tujuan", "tembusan as tembusan");
		} elseif($table == "surat_masuk"){
			$q_where = "WHERE id_sm = '".$id."'";
			$field	= array("tujuan_surat as tujuan", "'' as tembusan");
		} elseif($table == "memo"){
			$q_where = "WHERE id_status = '".$id."'";
			$field	= array("disposisi as tujuan", "'' as tembusan");
		} else {
			$q_where = "";
			$field	= null;
		}

		$surat = $this->model->selectprepare($table, $field, $params=null, $where=null, $q_where)->fetch(PDO::FETCH_OBJ);

		$dataTujuan = json_decode($surat->tujuan, true);
		$countTujuan = count($dataTujuan);
		$dataq = "";
		if($countTujuan > 0){
			foreach($dataTujuan as $id_tujuan){
				$params = array(':id_user' => $id_tujuan);
				$userq = $this->model->selectprepare("user", $field=null, $params, "id_user=:id_user", $other=null)->fetch(PDO::FETCH_OBJ);
				$dataq .= '<p class="m_hapus_'.$userq->id_user.'"><a href="javascript:" onclick="m_hapus('.$userq->id_user.')" class="m_hapus_'.$userq->id_user.'">X </a> '.$userq->nama.' ('.$userq->nik.')</p><input type="hidden" name="m_tujuan[]" id="m_tujuan[]" class="m_tujuan m_tujuan_'.$userq->id_user.' m_hapus_'.$userq->id_user.'" value="'.$userq->id_user.'">';
			}
		}

		$dataTembusan = json_decode($surat->tembusan, true);
		$countTembusan = count($dataTembusan);
		$datav = "";
		if($countTembusan > 0){
			foreach($dataTembusan as $id_tembusan){
				$params = array(':id_user' => $id_tembusan);
				$userv = $this->model->selectprepare("user", $field=null, $params, "id_user=:id_user", $other=null)->fetch(PDO::FETCH_OBJ);
				$datav .= '<p class="v_hapus_'.$userv->id_user.'"><a href="javascript:" onclick="v_hapus('.$userv->id_user.')" class="v_hapus_'.$userv->id_user.'">X </a> '.$userv->nama.' ('.$userv->nik.')</p><input type="hidden" name="m_tembusan[]" id="m_tembusan[]" class="m_tembusan m_tembusan_'.$userv->id_user.' v_hapus_'.$userv->id_user.'" value="'.$userv->id_user.'">';
			}
		}

		$return = array(
			'countTujuan'	=> $countTujuan,
			'dataq'			=> $dataq,
			'countTembusan'	=> $countTembusan,
			'datav'			=> $datav
		);
		echo json_encode($return);
	}
	
	function login_sso ()
	{
		$portal_url = 'https://wzone.wika.co.id/';
		// print_r($portal_url);exit;
		$user_token = $_GET['token'];
		$redirect_back = $_GET['redirect_back'];
		$app_secret = '7d1707a0ad0330e728f75f2d9e2b8680';

		if (empty($user_token)) {
			header('Location: '.$redirect_back);exit;
		}

		$token_check_url = $portal_url.'app/sso/valid';
		$params = array(
			'token' => $user_token,
			'app_secret' => $app_secret,
		);
		
		list($response_raw, $error) = $this->curl_get($token_check_url, $params);
		$response = json_decode($response_raw);
		$result_code = $response->responseStatus;
		$result_msg = $response->responseMsg;
		$result_data = $response->responseData;
		
		if ($result_code) {
		
			$data=array(
				'nip'=>$result_data->nip,
				'password'=>'80331c48ba5c8dace2c367c13bf9a2f8',
				'ip'=>'10.4.0.157',
			);
			$nip=$result_data->nip;
			$params = array(':user' => $nip);
			// print_r($nip);exit;
			$cek = $this->model->selectprepare("user", $field=null, $params, "uname=:user");
			if($cek->rowCount() >= 1){
				$data = $cek->fetch(PDO::FETCH_OBJ);
				$_SESSION['id_user'] = $data->id_user;
				$_SESSION['id_user_help'] = '"'.$data->id_user.'"';
				$_SESSION['nama'] = $data->nama;
				$_SESSION['atra_id'] = $data->uname;
				$_SESSION['atra_pass'] = $data->upass;
				$_SESSION['hakakses'] = $data->level;
				$_SESSION['unitkerjaid'] = $data->unitkerjaid;
				$_SESSION['rule_unitkerja'] = $data->rule_unitkerja;
				//$_SESSION['nsalt'] = $data->salt;
				$_SESSION['picture'] = $data->picture;
				echo "<script type=\"text/javascript\">window.location.href=\"./\";</script>";
			}
			else 
			{
				// No existing user.
				header('Location: '.$redirect_back);exit;
				// return FALSE;
			}
		}
		else {
			header('Location: '.$redirect_back);exit;
		}
	}
	
	function curl_get($url, $params) {
		$ch = curl_init();
		$qs = http_build_query($params);
		$url = $url.'?'.$qs;
		
		curl_setopt($ch,CURLOPT_HTTPHEADER,array('Content-Type: application/json'));
		curl_setopt($ch, CURLOPT_URL, $url);
		curl_setopt($ch, CURLOPT_POST, TRUE);
		curl_setopt($ch, CURLOPT_POSTFIELDS, $qs);
		curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
		curl_setopt($ch, CURLOPT_SSL_VERIFYPEER,FALSE);
		$response = curl_exec($ch);
		$error = curl_error($ch);

		return array($response, $error);
	}
}?>