<?php
$params = array(':id_sk' => trim($_GET['skid']));
$sk = $this->model->selectprepare("surat_keluar a INNER JOIN user b on a.id_user=b.id_user", $field=null, $params, "a.id_sk=:id_sk", "ORDER BY tgl_agenda DESC");
if($sk->rowCount() >= 1){
	$data_sk= $sk->fetch(PDO::FETCH_OBJ);
	$idsk= $data_sk->id_sk;
	$tujuan = json_decode($data_sk->tujuan, true);
	$tembusan = json_decode($data_sk->tembusan, true);
	if(isset($_GET['act']) && $_GET['act'] == "del"){
		## Hanya Admin yang bisa menghapus ##
		if($_SESSION['id_user'] != '1' and $_SESSION['hakakses'] != 'Admin'){
			die("<script>alert('Hanya Admin yang diperbolehkan menghapus data. Terimakasih');window.history.go(-1);</script>");
		}
		@unlink('berkas/'.$data_sk->file);
		$params = array(':id_sk' => $idsk);
		$delete = $this->model->hapusprepare("surat_keluar", $params, "id_sk=:id_sk");
		if($delete){
			$cek = $this->model->selectprepare("surat_keluar", $field=null, $params=null, $where=null);
			if($cek->rowCount() <= 0){
				$delete = $this->model->truncate("surat_keluar");
			}
			echo "<script type=\"text/javascript\">alert('Data Berhasil di Hapus...!!');window.location.href=\"./index.php?op=sk\";</script>";
		}else{
			die("<script>alert('Gagal menghapus data surat keluar, Silahkan Coba Kembali..!!');window.history.go(-1);</script>");
		}
	}?>
	<div class="widget-box">
		<div class="message-header clearfix">
			<div class="pull-left" style="padding:0 9px;">
				<span class="blue bigger-125">
					<?php echo $data_sk->perihal;?>
				</span>
				<div class="space-4"></div>
				<img class="middle" alt="John's Avatar" src="assets/images/avatars/<?php echo $data_sk->picture;?>" width="32" />
				<a href="#" class="sender"><?php echo $data_sk->nama;?></a>
				<i class="ace-icon fa fa-clock-o bigger-110 orange middle"></i>
				<span class="time grey"><?php echo tgl_indo($data_sk->tgl_agenda);?></span>
			</div>
		</div>
		<div class="hr hr-double"></div>
		<div class="message-body">
			<p>
				Tgl/No Agenda: <br/><b><?php echo tgl_indo($data_sk->tgl_agenda)." | ".$this->model->noref($data_sk->id_sk);?></b>
			</p>
			<p>
				Perihal: <br/><b><?php echo $data_sk->perihal;?></b>
			</p>
			<p>
				Pembuat: <br/><b><?php echo $data_sk->pembuat;?></b>
			</p>
			<p>
				Penandatangan: <br/><b>
				<?php
					$field = array('nama_user, jabatan');
					$userttd = $this->model->selectprepare("tag", $field, $params=null, $where=null, "WHERE nip='".$data_sk->penandatangan."' ");
					if ($userttd->rowCount() > 0){
						$userttd = $userttd->fetch(PDO::FETCH_OBJ);
						echo $userttd->nama_user;
					}else{
						echo $data_sk->penandatangan;
					}
				?></b>
			</p>
			<p>
				Tujuan Surat: <br/><b><?php echo $data_sk->tujuan;?></b>
			</p>
			<p>
			<p> Tembusan: <br/><b>
				<?php 
				if(is_array($tembusan)){
					foreach($tembusan as $field => $value){
						$field = array('nama', '(SELECT nama FROM unit_kerja WHERE unit_kerja.id = user.unitkerjaid) as unit_kerja');
						$GetUserDis = $this->model->selectprepare("user", $field, $params=null, $where=null, "WHERE nik='".$value."' ")->fetch(PDO::FETCH_OBJ);
						echo '- '.$GetUserDis->nama.' ('.$GetUserDis->unit_kerja.') <br/>';
					}
				}?></b>
			</p>
			<ul class="pager"><?php
				if($data_sk->file != ''){?>
					<li class="previous">
						<a href="./berkas/<?php echo $data_sk->file;?>" target="_blank" class="btn btn-primary">Lihat Surat<i class="ace-icon fa fa-file-pdf-o align-top bigger-125 icon-on-right"></i></a>
					</li><?php
				}
				if($HakAkses->sk == "W" AND $data_sk->status_draft=='0'){?>
					<li class="next">
						<a href="./index.php?op=add_sk&skid=<?php echo $data_sk->id_sk;?>" class="btn btn-danger">Edit Surat<i class="ace-icon fa fa-pencil align-top bigger-125 icon-on-right"></i></a>
					</li><?php
				}?>
			</ul>
		</div>
	</div><?php
}else{?>
	<div class="alert alert-danger">
		<button type="button" class="close" data-dismiss="alert">
			<i class="ace-icon fa fa-times"></i>
		</button>
		<p>
			<strong><i class="ace-icon fa fa-check"></i>Perhatian!</strong>
			Data Surat keluar tidak ditemukan. Terimakasih.
		</p>
		<p>
			<a href="./index.php?op=sk"><button class="btn btn-minier btn-danger">Kembali</button></a>
		</p>
	</div><?php
}?>