<?php
$id_sk 		= htmlspecialchars($purifier->purify(trim($_GET['skid'])), ENT_QUOTES);
$field 		= array("a.id_user as userDis","a.*");
$params 	= array(':id_sk' => $id_sk);
$userLike 	= "%".$_SESSION['nip']."%";
$CekTembusan = $this->model->selectprepare("surat_keluar a", $field, $params, "a.id_sk=:id_sk", "AND a.tembusan LIKE '".$userLike."'");

if($CekTembusan->rowCount() > 0){
	$dataTembusan 	= $CekTembusan->fetch(PDO::FETCH_OBJ);
	$tembusan 		= json_decode($dataTembusan->tembusan, true);
	$tgl 			= substr($dataTembusan->tgl_agenda,0,10);
	$CekUser 		= $this->model->selectprepare("user", $field=null, $params=null, $where=null, "WHERE id_user = '$dataTembusan->userDis'");
	$DataUser 		= $CekUser->fetch(PDO::FETCH_OBJ);
	$params = array(
		':id_user' => $_SESSION['id_user'], 
		':id_sk' => $dataTembusan->id_sk, 
		':kode' => 'CC');
	$lihat_sk 		= $this->model->selectprepare("surat_read", $field=null, $params, "id_sk=:id_sk AND id_user=:id_user AND kode=:kode");
	if($lihat_sk->rowCount() <= 0){
		$field 		= array('id_user' => $_SESSION['id_user'], 'id_sk' => $dataTembusan->id_sk, 'kode' => 'CC');
		$insert2 	= $this->model->insertprepare("surat_read", $field, $params);
	}?>
	<div class="widget-box">
		<div class="message-header clearfix">
			<div class="pull-left" style="padding:0 9px;">
				<span class="blue bigger-125"> Tembusan surat dari: <?php echo $dataTembusan->pembuat;?>, Ref: <?php echo $this->model->noref($dataTembusan->id_sk);?></span>
				<div class="space-4"></div>
				<img class="middle" alt="<?php echo $DataUser->nama;?>" src="assets/images/avatars/<?php echo $DataUser->picture;?>" width="32" />
				<a href="#" class="sender"><?php echo $DataUser->nama;?></a>
				<i class="ace-icon fa fa-clock-o bigger-110 orange middle"></i>
				<span class="time grey"><?php echo tgl_indo($tgl);?>, <?php echo substr($dataTembusan->tgl,-9,-3);?> WIB</span>
			</div>
		</div>
		<div class="hr hr-double"></div>
		<div class="message-body">
			<p>
				Tgl/No agenda: <br/><b><?php echo tgl_indo($dataTembusan->tgl_agenda);?> | <?php echo "<a href='./index.php?op=sk&skid=".$dataTembusan->id_sk."' target='_blank'>".$this->model->noref($dataTembusan->id_sk)."</a>";?></b>
			</p>
			<p>
				Dari: <br/><b><?php echo $dataTembusan->pembuat;?></b>
			</p>
			<p>
				Perihal: <br/><b><?php echo $dataTembusan->perihal;?></b>
			</p>
			<p>
				Penandatangan: <br/><b><?php echo $dataTembusan->penandatangan;?></b>
			</p>
			<p>
				Tujuan Surat: <br/><b><?php echo $dataTembusan->tujuan;?></b>
			</p>
			<p>
				Tanggal Tembusan : <br/><b><?php echo tgl_indo($tgl);?></b>
			</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=null, $params=null, $where=null, "WHERE id_user='".$value."' ")->fetch(PDO::FETCH_OBJ);
						echo '- '.$GetUserDis->nama.' ('.$GetUserDis->unit_kerja.') <br/>';
					}
				}
				?> -->
				<?php echo $dataTembusan->pembuat;?>
				</b>
			</p>
			<?php if($dataTembusan->file != ""){?>
			<p>
				<a href="./berkas/<?php echo $dataTembusan->file;?>" target="_blank"><button class="btn btn-success btn-minier ">Lihat File Surat<i class="ace-icon fa fa-book align-top bigger-125 icon-on-right"></i></button></a>
			</p>
			<?php } 
			$field = array(
				'info.*',
				'(SELECT nama FROM user WHERE user.id_user = info.pengirim_info) as nama_user'
			);
			$params = array(':tujuan_info' => $dataTembusan->id_sk, ':status_info' => 'surat_keluar');
			$StatSurat = $this->model->selectprepare("info", $field, $params, "tujuan_info=:tujuan_info AND status_info=:status_info", "ORDER BY id_info DESC");

			if($StatSurat->rowCount() >= 1){?>
				<div class="widget-body">
					<div class="widget-main padding-0">
						<div id="profile-feed-1" class="profile-feed">
						
						</div>
					</div>
				</div><?php
				$no=1;
				while($dataStatSurat= $StatSurat->fetch(PDO::FETCH_OBJ)){?>
					<div class="profile-activity clearfix">

						<div>
							<a class="user" href="#"><?php echo $dataStatSurat->nama_user; ?></a>
							: <span class="text-primary">
								<?php echo $dataStatSurat->judul_info."<br>".$dataStatSurat->ket_info; ?>
							</span>
							<div class="time">
								<?php echo tgl_indo1($dataStatSurat->tgl_info);?>, <?php echo substr($dataStatSurat->tgl_info,-9,-3);?> WIB
							</div>
						</div><?php
						if($dataStatSurat->id_info == $_SESSION['id_user']){?>
							<div class="tools action-buttons">
								<a href="./index.php?op=add_memo&infoid=<?php echo $dataStatSurat->id_info;?>" class="blue">
									<i class="ace-icon fa fa-pencil bigger-125"></i>
								</a>
								<a href="./index.php?op=add_memo&infoid=<?php echo $dataStatSurat->id_info;?>&act=del" class="red">
									<i class="ace-icon fa fa-times bigger-125"></i>
								</a>
							</div><?php
						}?>
					</div>	
					<?php
				$no++;
				}
			}?>
		</div>

	</div><?php
}else{
	echo "Belum ada data";	
}
?>