$xls->getActiveSheet()->setCellValue("A{$baris}", "dimuka pengadilan berdasarkan Undang-undang yang berlaku dan bersedia mengembalikan semua semua");
$baris++;
$xls->getActiveSheet()->setCellValue("A{$baris}", "uang tunjangan yang telah saya terima yang seharusnya bukan menjadi hak saya.");
$baris++;
$baris++;
$baris++;
$xls->getActiveSheet()->mergeCells("E{$baris}:F{$baris}");
$xls->getActiveSheet()->setCellValue("E{$baris}", "Bogor, " . tampilan_tanggal_indonesia(date("Y-m-d"), false, true));
$xls->getActiveSheet()->getStyle("E{$baris}")->getAlignment()->setHorizontal('center');
$baris += 3;
$xls->getActiveSheet()->mergeCells("E{$baris}:F{$baris}");
$xls->getActiveSheet()->setCellValue("E{$baris}", "Yang menerangkan,");
$xls->getActiveSheet()->getStyle("E{$baris}")->getAlignment()->setHorizontal('center');
$baris += 5;
$xls->getActiveSheet()->mergeCells("E{$baris}:F{$baris}");
$xls->getActiveSheet()->setCellValue("E{$baris}", $pegawai['nama']);
$xls->getActiveSheet()->getStyle("E{$baris}")->getAlignment()->setHorizontal('center');
$xls->getActiveSheet()->getStyle("E{$baris}")->getFont()->setBold(true);
$xls->getActiveSheet()->getStyle("E{$baris}")->getFont()->setUnderline(true);
$baris++;
$xls->getActiveSheet()->mergeCells("E{$baris}:F{$baris}");
$xls->getActiveSheet()->setCellValue("E{$baris}", "NIP. " . format_nip($pegawai['nip']));
$xls->getActiveSheet()->getStyle("E{$baris}")->getAlignment()->setHorizontal('center');
$sheet++;
}
// output it
$xls->setActiveSheetIndex(0);
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="SKUM-PTK_' . $bulan . '_' . $tahun . '.xls"');
$objWriter = IOFactory::createWriter($xls, "Excel5");
$objWriter->save("php://output");
if ($i % 2 == 0) {
echo 'class="even"';
}
?>
>
<td>
<?php
echo $i;
?>
<input type="hidden" value="<?php
echo $pegawai['id_pegawai'];
?>
" name="id_pegawai[]"/>
</td>
<td><?php
echo format_nip($pegawai['nip']);
?>
</td>
<td><?php
echo $pegawai['nama'];
?>
</td>
<td><?php
$j = $this->pegawai->get_jabatan_terakhir($pegawai['id_pegawai']);
echo $j['jabatan'];
?>
</td>
<td>
<select name="atasan[]" class="input-long">
<?php
$j = 1;
</table>
</div>
</div>
</div>
<div class="grid_6" style="width: 48%">
<div class="module">
<h2><span>Data kepegawaian</span></h2>
<div class="module-body">
<table width="100%" class="noborder">
<tbody>
<tr>
<td width="40%"><label>NIP</label></td>
<td><strong><?php
echo format_nip($data_pegawai['nip']);
?>
</strong></td>
</tr>
<tr>
<td><label>Tanggal masuk</label></td>
<td><strong><?php
echo format_tanggal_tampilan($data_pegawai['tanggal_masuk']);
?>
</strong></td>
</tr>
<tr>
<td><label>Status kepegawaian</label></td>
<td><strong><?php
echo $data_pegawai['status_kepegawaian'];
?>
<td align="left"><strong><span>:</span></strong></td>
<td align="left"><span><?php
echo $biodata['nama'];
?>
</span></td>
</tr>
<tr>
<td height="20" align="left"><span>NIP</span></td>
<td align="left"><strong><span>:</span></strong></td>
<td align="left"><span><?php
echo format_nip($biodata['nip']);
?>
</span></td>
</tr>
<tr>
<td height="20" align="left"><span>TEMPAT/TANGGAL LAHIR</span></td>
<td align="left"><strong><span>:</span></strong></td>
<td align="left"><span><?php
echo $biodata['tempat_lahir'];
?>
, <?php
echo tampilan_tanggal_indonesia($biodata['tanggal_lahir'], false, true);
?>
$xls->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('K')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('L')->setAutoSize(true);
$xls->getActiveSheet()->getColumnDimension('M')->setAutoSize(true);
$xls->getActiveSheet()->getStyle('A6:M8')->applyFromArray($styleThinBlackBorderOutline);
// print data
$i = 9;
foreach ($list as $pegawai) {
$xls->getActiveSheet()->setCellValue("A{$i}", $i - 8);
$xls->getActiveSheet()->setCellValue("B{$i}", $pegawai['nama']);
$xls->getActiveSheet()->setCellValue("C{$i}", format_nip($pegawai['nip']));
$xls->getActiveSheet()->setCellValue("D{$i}", $pegawai['pangkat'] . ' - ' . $pegawai['golongan']);
$xls->getActiveSheet()->setCellValue("E{$i}", format_tanggal_tampilan($pegawai['TMT_pangkat']));
$xls->getActiveSheet()->setCellValue("F{$i}", $pegawai['masa_kerja_tahun']);
$xls->getActiveSheet()->setCellValue("G{$i}", $pegawai['masa_kerja_bulan']);
$xls->getActiveSheet()->setCellValue("H{$i}", $pegawai['pendidikan']);
$xls->getActiveSheet()->setCellValue("I{$i}", $pegawai['tahun_ijazah']);
$xls->getActiveSheet()->setCellValue("J{$i}", $pegawai['tempat_lahir'] . ', ' . format_tanggal_tampilan($pegawai['tanggal_lahir']));
$xls->getActiveSheet()->setCellValue("K{$i}", $pegawai['jabatan']);
$xls->getActiveSheet()->setCellValue("L{$i}", format_tanggal_tampilan($pegawai['kenaikan_YAD']));
$xls->getActiveSheet()->setCellValue("M{$i}", $pegawai['bp_pemda'] == 1 ? 'BP Pemda' : '');
$xls->getActiveSheet()->getStyle("A{$i}:M{$i}")->getAlignment()->setVertical('center');
$xls->getActiveSheet()->getStyle("A{$i}:M{$i}")->getFont()->setSize(10);
$xls->getActiveSheet()->getRowDimension($i)->setRowHeight(25);
$xls->getActiveSheet()->getStyle("A{$i}:M{$i}")->applyFromArray($styleThinBlackBorderOutline);
// A,E,F,G,I,L: center
echo $data['id_pegawai'];
?>
"/>
<input type="hidden" name="id_absensi[<?php
echo $data['id_pegawai'];
?>
]" value="<?php
echo $data['id_absensi'];
?>
"/>
<?php
echo $i + 1;
?>
</td>
<td><?php
echo format_nip($data['nip']);
?>
</td>
<td><?php
echo $data['nama'];
?>
</td>
<td>
<?php
if ($is_cuti) {
?>
<em style="color: red">CUTI</em>
<?php
} else {
?>
<input id="ck<?php
