$xls->getActiveSheet()->getStyle('B6:C6')->getFont()->setSize(10); $xls->getActiveSheet()->getRowDimension('6')->setRowHeight(20); $xls->getActiveSheet()->setCellValue('A7', "2"); $xls->getActiveSheet()->setCellValue('B7', "N I P"); $xls->getActiveSheet()->setCellValue('C7', " : " . format_nip($pegawai['nip'])); $xls->getActiveSheet()->getStyle('B7:C7')->getFont()->setSize(10); $xls->getActiveSheet()->getRowDimension('7')->setRowHeight(20); $g = $this->pegawai->get_pangkat_terakhir($pegawai['id_pegawai']); $xls->getActiveSheet()->setCellValue('A8', "3"); $xls->getActiveSheet()->setCellValue('B8', "Pangkat, Golongan/Ruang"); $xls->getActiveSheet()->setCellValue('C8', " : " . $g['pangkat'] . ' - ' . $g['golongan']); $xls->getActiveSheet()->getStyle('B8:C8')->getFont()->setSize(10); $xls->getActiveSheet()->getRowDimension('8')->setRowHeight(20); $xls->getActiveSheet()->setCellValue('A9', "4"); $xls->getActiveSheet()->setCellValue('B9', "Terhitung mulai tanggal"); $xls->getActiveSheet()->setCellValue('C9', " : " . format_tanggal_tampilan($g['TMT'])); $xls->getActiveSheet()->getStyle('B9:C9')->getFont()->setSize(10); $xls->getActiveSheet()->getRowDimension('9')->setRowHeight(20); $xls->getActiveSheet()->setCellValue('A10', "5"); $xls->getActiveSheet()->setCellValue('B10', "Tempat, tanggal lahir"); $xls->getActiveSheet()->setCellValue('C10', " : " . $pegawai['tempat_lahir'] . ', ' . tampilan_tanggal_indonesia($pegawai['tanggal_lahir'], false, true)); $xls->getActiveSheet()->getStyle('B10:C10')->getFont()->setSize(10); $xls->getActiveSheet()->getRowDimension('10')->setRowHeight(20); $jk = ""; if ($pegawai['jk'] == 'L') { $jk = "Laki-laki"; } if ($pegawai['jk'] == 'P') { $jk = "Perempuan"; } $xls->getActiveSheet()->setCellValue('A11', "6");
><?php echo $pegawai['nama']; ?> </option> <?php } ?> </select> </td> </tr> <tr> <td>Kenaikan gaji YAD</td> <td><input type="text" name="tanggal_yad" maxlength="255" class="datepicker input-medium" value="<?php if (isset($kenaikan_yad)) { echo format_tanggal_tampilan($kenaikan_yad); } ?> "/></td> </tr> </tbody> </table> </div> </div> </div> </div> </form> <script type="text/javascript">
</thead> <tbody> <?php if (count($daftar_gaji) > 0) { foreach ($daftar_gaji as $d) { ?> <tr id="t_<?php echo $d['id_gaji']; ?> "> <td align="right">Rp <?php echo format_rupiah($d['gaji']); ?> </td> <td><?php echo format_tanggal_tampilan($d['TMT']); ?> </td> <td> <a onclick="hapus(<?php echo $d['id_gaji']; ?> ); return false;" href="#">Hapus</a> </td> </tr> <?php } } else { ?> <tr> <td colspan="3"><em>Tidak ada data</em></td>
</strong></td> <td align="right"><label>TMT</label></td> <td><strong><?php echo format_tanggal_tampilan($jabatan['TMT']); ?> </strong></td> </tr> <tr> <td><label>Gaji pokok</label></td> <td><strong><?php echo $gaji['gaji']; ?> </strong></td> <td align="right"><label>TMT</label></td> <td><strong><?php echo format_tanggal_tampilan($gaji['TMT']); ?> </strong></td> </tr> <tr> <td><label>Atasan langsung</label></td> <td colspan="3"><strong><?php $p = $this->pegawai->get_pegawai_by_id($data_pegawai['id_atasan']); echo $p['nama']; ?> </strong></td> </tr> </tbody> </table> </div> </div>
echo "display:none"; } ?> "> <input type="hidden" name="bandingan" id="bandingan" value="<?php if ($p == true) { echo 1; } else { echo 0; } ?> " /> <p style="float:left" >Pilih tanggal:</p> <input type="text" style="float:left" class="datepicker" placeholder="Masukkan tanggal" name="tgl_statistik1" class="input-medium" value="<?php echo format_tanggal_tampilan($tgl1); ?> "/> <input type="submit" style="float:left" value="Tampilkan" class="submit-green" name="submit1"/> <br /> <br /> <div style="width: 48%; float: left; height: 300px;" id="grafik3"></div> <div style="width: 48%; float: right; height: 300px;" id="grafik4"></div> <div style="clear: both"></div> </div> </div> </form> </div>
?> >Tidak</option> </select> </td> </tr> <tr> <td><label>Sumber gaji</label></td> <td><input type="text" name="sumber_gaji" maxlength="255" value="<?php echo $data_pegawai['sumber_gaji']; ?> " class="input-long"/></td> </tr> <tr> <td><label>Kenaikan gaji YAD</label></td> <td><input type="text" name="kenaikan_yad" id="kenaikan_yad" maxlength="255" class="datepicker input-long" value="<?php echo format_tanggal_tampilan($data_pegawai['kenaikan_YAD']); ?> "/></td> </tr> </tbody> </table> </div> </div> </div> <div class="grid_6" style="width: 48%"> <div class="module"> <h2><span>Data kepangkatan</span></h2> <div class="module-body"> <table width="100%" class="noborder">
<td align="left"><span>( 0251 ) 832 65 40</span></td> </tr> <tr> <td height="20" align="left"><span>RIWAYAT JABATAN</span></td> <td align="left"><strong><span>:</span></strong></td> <td align="left"> <?php if (count($jabatan) > 0) { foreach ($jabatan as $j) { ?> • <?php echo $j['jabatan'] . ' (TMT ' . format_tanggal_tampilan($j['TMT']) . ')'; ?> <br/> <?php } } else { echo "-"; } ?> </td> </tr> <tr> <td height="20" align="left"><span>RIWAYAT PENDIDIKAN</span></td> <td align="left"><strong><span>:</span></strong></td>
$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 $xls->getActiveSheet()->getStyle("A{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("E{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("F{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("G{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("I{$i}")->getAlignment()->setHorizontal('center'); $xls->getActiveSheet()->getStyle("L{$i}")->getAlignment()->setHorizontal('center'); $i++; } // output it
$xls->getActiveSheet()->getStyle('B28:D28')->getFont()->setSize(12); $xls->getActiveSheet()->getRowDimension('28')->setRowHeight(20); $xls->getActiveSheet()->getRowDimension('29')->setRowHeight(12); $id_pegawai = $pegawai['id_pegawai']; $pendidikan = $this->pegawai->get_pendidikan_pegawai($id_pegawai); $pelatihan = $this->pegawai->get_pelatihan_pegawai($id_pegawai); $jabatan = $this->jabatan->get_by_id_pegawai($id_pegawai); $baris = 30; $xls->getActiveSheet()->setCellValue("A{$baris}", "12"); $xls->getActiveSheet()->getStyle("A{$baris}")->getFont()->setSize(10); $xls->getActiveSheet()->setCellValue("B{$baris}", "RIWAYAT JABATAN"); $xls->getActiveSheet()->setCellValue("C{$baris}", ":"); if (count($jabatan) > 0) { foreach ($jabatan as $j) { if (format_tanggal_tampilan($j['TMT']) != '') { $xls->getActiveSheet()->setCellValue("D{$baris}", $j['jabatan'] . ' (TMT ' . format_tanggal_tampilan($j['TMT']) . ')'); } else { $xls->getActiveSheet()->setCellValue("D{$baris}", $j['jabatan']); } $xls->getActiveSheet()->getStyle("B{$baris}:D{$baris}")->getFont()->setSize(12); $xls->getActiveSheet()->getRowDimension("{$baris}")->setRowHeight(20); $baris++; } $xls->getActiveSheet()->getRowDimension("" . ($baris + 1))->setRowHeight(12); } else { $xls->getActiveSheet()->setCellValue("D{$baris}", "-"); $xls->getActiveSheet()->getStyle("B{$baris}:D{$baris}")->getFont()->setSize(12); $xls->getActiveSheet()->getRowDimension("{$baris}")->setRowHeight(20); $xls->getActiveSheet()->getRowDimension("" . ($baris + 1))->setRowHeight(12); } $baris++;
?> <tr> <td><?php echo $i++; ?> </td> <td><?php echo $data['nama']; ?> </td> <td><?php echo format_tanggal_tampilan($data['tanggal_lahir']); ?> </td> <td><?php echo format_tanggal_tampilan($data['tanggal_nikah']); ?> </td> <td><?php echo $data['pekerjaan']; ?> </td> <td><?php if ($data['dapat_tunjangan'] == "1") { echo "Ya"; } else { echo "Tidak"; } ?> </td> <td><?php