$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