$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
