<div class="row">
	<div class="col-xs-12">
		<!-- PAGE CONTENT BEGINS -->
		<div class="row">
			<div class="col-xs-12"> <?php
				if(isset($_GET['skid'])){
					require_once "view_sm_internal_detail.php";
				}else{
					/* PAGINATION */
					$batas = 20;
					$pg = isset( $_GET['halaman'] ) ? $_GET['halaman'] : "";
					if(empty($pg)){
						$posisi = 0;
						$pg = 1;
					}else{
						$posisi = ($pg-1) * $batas;
					}
					/* END PAGINATION */
					if(isset($_GET['keyword'])){
							$keyword = "%".$_GET['keyword']."%";
							$params = array(
								':pembuat' 	=> $keyword, 
								':noref' 	=> $keyword, 
								':perihal' 	=> $keyword
							);
							//$admins = $_SESSION['hakakses'] == "Admin" ? "" : "AND tujuan LIKE '%".$_SESSION['id_user_help']."%'";
							$arsip_sk = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "pembuat LIKE :pembuat
										OR (SELECT (CONCAT(b.kode_masalah, '.', b.primer, '.', b.sekunder, '/', c.kode1, '.', c.kode2, '.', lpad(a.no_agenda,5,'0'), '/', DATE_FORMAT(a.tgl_agenda, '%Y'))) as noref FROM surat_keluar_internal a left join kode_masalah b ON b.id = a.kodemasalahid left join unit_kerja c ON c.id = a.unitkerjaid WHERE a.id_sk = surat_keluar_internal.id_sk) LIKE :noref
										OR perihal LIKE :perihal and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or id_user = '".$_SESSION['id_user']."' )", $admins." order by tgl_agenda DESC LIMIT $posisi, $batas");
							$arsip_sk2 = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "pembuat LIKE :pembuat
										OR (SELECT (CONCAT(b.kode_masalah, '.', b.primer, '.', b.sekunder, '/', c.kode1, '.', c.kode2, '.', lpad(a.no_agenda,5,'0'), '/', DATE_FORMAT(a.tgl_agenda, '%Y'))) as noref FROM surat_keluar_internal a left join kode_masalah b ON b.id = a.kodemasalahid left join unit_kerja c ON c.id = a.unitkerjaid WHERE a.id_sk = surat_keluar_internal.id_sk) LIKE :noref
										OR perihal LIKE :perihal and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or id_user = '".$_SESSION['id_user']."' )", $admins);
					}else{
						$field = array("id_sk","DATE_FORMAT(tgl_agenda, '%Y') as thn");
						$lastData = $this->model->selectprepare("surat_keluar_internal", $field, $params=null, $where=null, "GROUP BY DATE_FORMAT(tgl_agenda, '%Y') order by DATE_FORMAT(tgl_agenda, '%Y') DESC LIMIT 1");
						$dataLast = $lastData->fetch(PDO::FETCH_OBJ);
						if(isset($_GET['yearsk'])){
							$params = array(':year' => $_GET['yearsk']);
						}else{
							$params = array(':year' => $dataLast->thn);
						}
						//$admins = $_SESSION['hakakses'] == "Admin" ? "" : "OR tujuan LIKE '%".$_SESSION['id_user_help']."%'";
						
						//$arsip_sk = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or id_user = '".$_SESSION['id_user']."' )", $admins." order by tgl_agenda DESC LIMIT $posisi, $batas");
						$arsip_sk = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "status_draft <> 0 and DATE_FORMAT(tgl_agenda, '%Y')=:year and ( id_user = '".$_SESSION['id_user']."' or tujuan like '%".$_SESSION['nip']."%' )", $admins." order by tgl_agenda DESC LIMIT $posisi, $batas");
						
						$arsip_sk2 = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year and (unitkerjaid='".$_SESSION['unitkerjaid']."' or unitkerjaid = (SELECT unitkerjaid FROM user WHERE id_user='".$_SESSION['id_user']."') or id_user = '".$_SESSION['id_user']."' )", $admins." order by tgl_agenda DESC");
						
					}
					if($arsip_sk->rowCount() >= 1){
						while($data_sk = $arsip_sk->fetch(PDO::FETCH_OBJ)){
							$dump_sk[]=$data_sk;
						}?>
						<!--Modal Preview PDF-->
						<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
							<div class="modal-dialog modal-lg">
								<div class="modal-content">
									<div class="modal-header">
										<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
										<h4 class="modal-title" id="myModalLabel">Preview Surat Keluar</h4>
									</div>
									<div class="modal-body" style="height: 450px;"></div>
									<div class="modal-footer">
										<button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
									</div>
								</div>
							</div>
						</div>
						<!--Modal Preview PDF-->
						<table id="simple-table" class="table  table-bordered table-hover">
							<thead>
								<tr>
									<th width="50">No</th>
									<th width="200">No Agenda</th>
									<th>Perihal</th>
									<th width="100">Tgl Surat</th>
									<th class="detail-col" width="40">Detail</th>
								</tr>
							</thead>
							<tbody><?php
								$no=1+$posisi;
								foreach($dump_sk as $key => $object){
									$tglsrt = explode("-", $object->tgl_agenda);
									$tglsrt = $tglsrt[2]."-".$tglsrt[1]."-".$tglsrt[0];
									$tujuan = json_decode($object->tujuan, true); ?>
									<tr>
										<td><?php echo $no;?></td>
										<td><a href="./index.php?op=sm_internal&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref($object->id_sk, "internal"); ?></a></td>
										<td><?php echo $object->perihal;?></td>
										<td><?php echo $tglsrt;?></td>
										<td class="center">
											<div class="action-buttons">
												<a href="#" class="green bigger-140 show-details-btn" title="Show Details">
													<i class="ace-icon fa fa-angle-double-down"></i>
													<span class="sr-only">Details</span>
												</a>
											</div>
										</td>
									</tr>
									<tr class="detail-row">
										<td colspan="12">
											<div class="table-detail">
												<div class="row">
													<div class="col-xs-12 col-sm-12">
														<div class="space visible-xs"></div>
														<div class="profile-user-info profile-user-info-striped">
															<div class="profile-info-row">
																<div class="profile-info-name"> No Agenda </div>
																<div class="profile-info-value"><span><a href="./index.php?op=sm_internal&skid=<?php echo $object->id_sk;?>"><?php echo $this->model->noref($object->id_sk, "internal");?></a></span></div>
															</div>
															<div class="profile-info-row">
																<div class="profile-info-name"> Tgl Surat </div>
																<div class="profile-info-value"><span><?php echo $tglsrt;?></span></div>
															</div>
															<div class="profile-info-row">
																<div class="profile-info-name"> Pembuat </div>
																<div class="profile-info-value"><span><?php echo $object->pembuat;?></span></div>
															</div>
															<div class="profile-info-row">
																<div class="profile-info-name"> Perihal </div>
																<div class="profile-info-value"><span><?php echo $object->perihal;?></span></div>
															</div>
															<div class="profile-info-row">
																<div class="profile-info-name"> Tujuan </div>
																<div class="profile-info-value"><span>
																	<?php 
																	if(is_array($tujuan)){
																		foreach($tujuan as $field => $value){
																			$field = array('nama_user', 'jabatan');
																			$GetUserDis = $this->model->selectprepare("tag", $field, $params=null, $where=null, "WHERE nip='".$value."' ")->fetch(PDO::FETCH_OBJ);
																			echo '- '.$GetUserDis->nama_user.' ('.$GetUserDis->jabatan.') <br/>';
																		}
																	}?>
																</span></div>
															</div>
															<div class="profile-info-row">
																<div class="profile-info-name"> File Surat </div>
																<div class="profile-info-value">
																	<span><?php 
																		if($object->file != ""){?>
																			<a href="./berkas/<?php echo $object->file;?>" target="_blank">Lihat File Surat</a><?php
																		}else{ ?>
																			- <?php
																		}?>
																	</span>
																</div>
															</div>
														</div>
													</div>
												</div>
											</div>
										</td>
									</tr><?php
								$no++;
								}?>
							</tbody>
						</table><?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 tidak ditemukan. Terimakasih.
							</p>
						</div><?php
					}
					/* PAGINATION */
					//hitung jumlah data
					if(isset($_GET['keyword'])){
						$jml_data = $arsip_sk2->rowCount();
						$link_order="&keyword=$_GET[keyword]";
					}else{
						if(isset($_GET['yearsk'])){
							$params = array(':year' => $_GET['yearsk']);
							$link_order="&yearsk=$_GET[yearsk]";
						}else{
							$params = array(':year' => $dataLast->thn);
							$link_order="";
						}
						//$jlhdata = $this->model->selectprepare("surat_keluar_internal", $field=null, $params, "DATE_FORMAT(tgl_agenda, '%Y')=:year", $other=null);
						$jml_data = $arsip_sk2->rowCount();
					}
					//Jumlah halaman
					$JmlHalaman = ceil($jml_data/$batas); 
					//Navigasi ke sebelumnya
					if($pg > 1){
						$link = $pg-1;
						$prev = "index.php?op=sm_internal&halaman=$link$link_order";
						$prev_disable = " ";
					}else{
						$prev = "#";
						$prev_disable = "disabled";
					}
					//Navigasi ke selanjutnya
					if($pg < $JmlHalaman){
						$link = $pg + 1;
						$next = "index.php?op=sm_internal&halaman=$link$link_order";
						$next_disable = " ";
					}else{
						$next = "#";
						$next_disable = "disabled";
					}
					if($batas < $jml_data){?>
						<ul class="pager">
							<li class="previous <?php echo $prev_disable;?>"><a href="<?php echo $prev;?>">&larr; Sebelumnya </a></li>
							<li class="next <?php echo $next_disable;?>"><a href="<?php echo $next;?>">Selanjutnya &rarr;</a></li>
						</ul>
						<span class="text-muted">Halaman <?php echo $pg;?> dari <?php echo $JmlHalaman;?> (Total : <?php echo $jml_data;?> records)</span> <?php
					}
					/* END PAGINATION */
				}?>

			</div><!-- /.span -->
		</div><!-- /.row -->
		<!-- PAGE CONTENT ENDS -->
	</div><!-- /.col -->
</div><!-- /.row -->
		
<script src="assets/js/jquery-2.1.4.min.js"></script>

<!-- page specific plugin scripts -->
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/jquery.dataTables.bootstrap.min.js"></script>
<script src="assets/js/dataTables.buttons.min.js"></script>
<script src="assets/js/buttons.flash.min.js"></script>
<script src="assets/js/buttons.html5.min.js"></script>
<script src="assets/js/buttons.print.min.js"></script>
<script src="assets/js/buttons.colVis.min.js"></script>
<script src="assets/js/dataTables.select.min.js"></script>

<!-- inline scripts related to this page -->
<script type="text/javascript">
	jQuery(function($) {				
		//select/deselect a row when the checkbox is checked/unchecked
		$('#simple-table').on('click', 'td input[type=checkbox]' , function(){
			var $row = $(this).closest('tr');
			if($row.is('.detail-row ')) return;
			if(this.checked) $row.addClass(active_class);
			else $row.removeClass(active_class);
		});	
		
		/***************/
		$('.show-details-btn').on('click', function(e) {
			e.preventDefault();
			$(this).closest('tr').next().toggleClass('open');
			$(this).find(ace.vars['.icon']).toggleClass('fa-angle-double-down').toggleClass('fa-angle-double-up');
		});
		/***************/			
	})
</script>