-
-
Save thegarlynch/57d027e0760d679a8be16ff49303cf22 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| class PDF extends Pdftc { | |
| //Page header | |
| public function Header() { | |
| if ($this->page == 1) | |
| { | |
| $this->SetFont('times', '', 10); | |
| $this->SetXY(110,8); | |
| $this->hal='{nb}'; | |
| $this->SetX(10); | |
| } | |
| } | |
| } | |
| function initPDF($creator, $author, $title) | |
| $pdf = new PDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); | |
| $pdf->SetCreator($creator); | |
| $pdf->SetAuthor($author); | |
| $pdf->SetTitle($title); | |
| $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE, PDF_HEADER_STRING); | |
| $pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN)); | |
| $pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); | |
| $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); | |
| $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT); | |
| $pdf->SetHeaderMargin(PDF_MARGIN_HEADER); | |
| $pdf->SetFooterMargin(PDF_MARGIN_FOOTER); | |
| $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); | |
| $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO); | |
| // set some language-dependent strings (optional) | |
| if (@file_exists(dirname(__FILE__).'/lang/eng.php')) { | |
| require_once(dirname(__FILE__).'/lang/eng.php'); | |
| $pdf->setLanguageArray($l); | |
| } | |
| $pdf->SetFont('times', '', 11); | |
| $pdf->AddPage('P','A4'); | |
| $pdf->SetPrintFooter(false); | |
| return $pdf; | |
| } | |
| $pdf = initPDF( | |
| "Portal Aplikasi PKTN", | |
| 'Direktorat Metrologi, Direktorat Jenderal PKTN, Kementerian Perdagangan', | |
| 'CETAK DUPAK' | |
| ) | |
| $pendidikan = strtolower($arrHeader->pendidikan); | |
| $pdf->ln(5); | |
| $pdf->SetFont('times', '',9); | |
| $pdf->Write(0, 'DAFTAR USULAN PENETAPAN ANGKA KREDIT', '', 0, 'C', true, 0, false, false, 0); | |
| $pdf->ln(1); | |
| $pdf->SetFont('times', '',9); | |
| $pdf->Write(0, 'JABATAN FUNGSIONAL '.ucwords(strtoupper($arrHeader->nama_jabatan)), '', 0, 'C', true, 0, false, false, 0); | |
| $pdf->ln(1); | |
| $pdf->SetFont('times', '',9); | |
| $pdf->Write(0, 'NOMOR : '.$arrHeader->kode_transaksi,'', 0, 'C', true, 0, false, false, 0); | |
| $pdf->ln(7); | |
| $pdf->SetFont('times', '',10); | |
| $pdf->SetX(7); | |
| $html = '<ul style="list-style-type: none;text-align:justify;"> | |
| <li> | |
| <table border="0" style="width: 104%"> | |
| <tr> | |
| <td style="width: 55%; margin-right: 100px;"> | |
| INSTANSI : | |
| </td> | |
| <td style="width: 45%; margin-right: 100px;"> | |
| MASA PENILAIAN | |
| </td> | |
| </tr> | |
| <tr> | |
| <td style="width: 55%; margin-right: 100px;"> | |
| </td> | |
| <td style="width: 45%; margin-right: 100px;"> | |
| '.format_date_bulan($arrHeader->tgl_masa_penilaian_awal).' s/d '.format_date_bulan($arrHeader->tgl_masa_penilaian_akhir).' | |
| </td> | |
| </tr> | |
| <tr> | |
| <td style="width:0.1%; margin-right: 100px;"> | |
| </td> | |
| <td style="width: 45%; margin-right: 100px;"> | |
| '.$arrHeader->unit_kerja.' | |
| </td> | |
| </tr> | |
| </table> | |
| </li> | |
| </ul>'; | |
| $pdf->setListIndentWidth(4); | |
| $pdf->writeHTML($html, true, 0, true, true); | |
| $pdf->SetFont('times', '', 9); | |
| $html = '<ul style="list-style-type: none;text-align:justify;"> | |
| <li> | |
| <table border="1" style="width: 100%" cellpadding = "3" > | |
| <tr> | |
| <td width="5%" >NO</td> | |
| <td width="95%" align="center" >KETERANGAN PERORANGAN </td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >1.</td> | |
| <td width="50%">Nama</td> | |
| <td width="3%">:</td> | |
| <td >'.$arrHeader->nama_lengkap.'</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >2.</td> | |
| <td>NIP</td> | |
| <td>:</td> | |
| <td>'.$arrHeader->nip.'</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >3.</td> | |
| <td>Nomor seri Kartu Pegawai</td> | |
| <td>:</td> | |
| <td>'.$arrHeader->nomor_kartupegawai.'</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >4.</td> | |
| <td>Tempat dan tanggal lahir </td> | |
| <td>:</td> | |
| <td>'.$arrHeader->tempat_lahir.', '.format_date_bulan($arrHeader->tgl_lahir).' | |
| </td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >5.</td> | |
| <td>Jenis Kelamin</td> | |
| <td>:</td> | |
| <td>'.$arrHeader->jenis_kelamin.'</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >6.</td> | |
| <td>Pendidikan yang diperhitungkan angka kreditnya</td> | |
| <td>:</td> | |
| <td>'. ucwords($pendidikan).' | |
| </td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >7.</td> | |
| <td>Jabatan Fungsional / TMT</td> | |
| <td>:</td> | |
| <td>'.$arrHeader->nama_jabatan.' / '.format_date_bulan($arrHeader->tmt_jabatan).'</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >8.</td> | |
| <td>Masa kerja golongan lama</td> | |
| <td>:</td> | |
| <td>'.$arrHeader->masa_kerja_thn_lama.'Tahun '.$arrHeader->masa_kerja_bln_lama.' Bulan</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >9.</td> | |
| <td>Masa kerja golongan baru </td> | |
| <td>:</td> | |
| <td>'.$arrHeader->masa_kerja_thn_baru.'Tahun '.$arrHeader->masa_kerja_bln_baru.' Bulan</td> | |
| </tr> | |
| <tr> | |
| <td width="5%" >10.</td> | |
| <td>Unit Kerja</td> | |
| <td>:</td> | |
| <td>'.$arrHeader->unit_kerja.' <br> | |
| </td> | |
| </tr> | |
| </table></li></ul>'; | |
| $pdf->setListIndentWidth(0); | |
| $pdf->writeHTML($html, true, 0, true, true); | |
| $pdf->SetX(12); | |
| $pdf->SetFont('times', '', 9); | |
| $rowunsur2sub = ''; | |
| $rowunsur2 =''; | |
| $nodidik=1; | |
| $nounsur=1; | |
| $totalrow = 1; | |
| $totalrowsubsub = 0; | |
| $totalrowsubsubunsur = 0; | |
| $totalrowsubsubunsur2 = 0; | |
| $jumlahpaklama = 0; | |
| $jumlahpakbaru = 0; | |
| $jumlahpaklama1 = 0; | |
| $jumlahpakbaru1 = 0; | |
| $jumlahpaklama2 = 0; | |
| $jumlahpakbaru2 = 0; | |
| $totaljumlahpak = 0; | |
| $totaljumlahpak1 = 0; | |
| $totaljumlahpak2 = 0; | |
| $jumlahpenilaibaru = 0; | |
| $jumlahtotallama = 0; | |
| $jumlahtotalbaru = 0; | |
| $jumlahtotalpmb = 0; | |
| $jumlahtotalpenilai = 0; | |
| $coba = 0; | |
| $tot_row = 0; | |
| $this->db = $this->load->database('edupakdb', TRUE); | |
| foreach ($arrUnsur2 as $key => $unsur2) | |
| { | |
| $addSql = " id_transaksi_hdr IN (".$this->db->escape($iddata).") "; | |
| if($unsur2->Unsur == "Peneraan") | |
| { | |
| $sqlsubunsur1 = "SELECT b.*,a.Unsur,a.ID_Kegiatan,SUBSTR(a.ID_Kegiatan_Parent,1,16) as parent_16, | |
| SUBSTR(a.ID_Kegiatan_Parent,1,10) as parent_10,SUBSTR(a.ID_Kegiatan_Parent,1,13) as parent_13 | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(b.ID_Kegiatan,1,13) | |
| WHERE ".$addSql." AND a.Unsur = ".$this->db->escape($unsur2->Unsur)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else | |
| { | |
| $sqlsubunsur1 = "SELECT b.*,a.Unsur,a.ID_Kegiatan,SUBSTR(a.ID_Kegiatan_Parent,1,16) as parent_16, | |
| SUBSTR(a.ID_Kegiatan_Parent,1,10) as parent_10,SUBSTR(a.ID_Kegiatan_Parent,1,13) as parent_13 | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,10) = SUBSTR(b.ID_Kegiatan,1,10) | |
| WHERE ".$addSql." AND a.Unsur = ".$this->db->escape($unsur2->Unsur)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,10) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| //echo $sqlsubunsur1.'<br>'; | |
| $num_unsur1 = $this->db->query($sqlsubunsur1)->num_rows(); | |
| $data_unsur1 = $this->db->query($sqlsubunsur1)->result(); | |
| //print_r($data_unsur1); | |
| $rowunsur2sub = ""; | |
| $totalsubsub = 0; | |
| $tot =1; | |
| $abjadunsur2sub = 'A'; | |
| $totalsubbutir = 0; | |
| $totalsubbutir2 = 0; | |
| $total_abjad_A = 0; | |
| $total_no_1_1 = 0; | |
| $total_no_1_1_1 = 0; | |
| foreach ($data_unsur1 as $key => $unsur11) | |
| { | |
| //echo strlen($unsur11->ID_Kegiatan).$unsur11->Unsur.'<br>'; | |
| if(strlen($unsur11->ID_Kegiatan) == '22') | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,22) = ".$this->db->escape($unsur11->ID_Kegiatan)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else if(strlen($unsur11->ID_Kegiatan) == '19') | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,10) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(c.ID_Kegiatan,1,16) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." | |
| AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,16) = ".$this->db->escape($unsur11->parent_16)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,16) | |
| ORDER BY id_transaksi_detail"; | |
| //echo $sqlbutir1; | |
| } | |
| elseif(strlen($unsur11->ID_Kegiatan) == '16') | |
| { | |
| $addSelect = " GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama "; | |
| $addSql = " AND (LEFT(a.ID_Kegiatan,10) NOT IN ('K-02-01-01','K-01-01-01') OR a.flg_lama = 2) AND id_transaksi_hdr IN (".$this->db->escape($iddata).") "; | |
| if($unsur11->Unsur == "Pendidikan") | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,10) as ID_Kegiatan,a.total, a.Angka_Kredit_Murni,a.flg_lama, | |
| ".$addSelect." | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(c.ID_Kegiatan,1,16) | |
| WHERE a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsur11->parent_16)." | |
| ".$addSql." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,16) | |
| ORDER BY id_transaksi_detail"; | |
| //echo $sqlbutir1;exit; | |
| } | |
| else if($unsur11->Unsur == "Pengembangan Profesi") | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.total,a.Angka_Kredit_Murni,a.flg_lama, | |
| ".$addSelect." | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,10) = ".$this->db->escape($unsur11->parent_10)." | |
| ".$addSql." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,10) as ID_Kegiatan,a.total,a.Angka_Kredit_Murni,a.flg_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsur11->parent_13)." | |
| ".$addSql." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| } | |
| else | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,10) as ID_Kegiatan,a.total,a.Angka_Kredit_Murni,a.flg_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr IN (".$this->db->escape($iddata).",".$this->db->escape($idold).") | |
| AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." | |
| AND SUBSTR(a.ID_Kegiatan,1,10) = ".$this->db->escape($unsur11->parent_13)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,10) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| //echo $sqlbutir1.'<br>'; | |
| $num_unsursub1 = $this->db->query($sqlbutir1)->num_rows(); | |
| $data_unsursub1 = $this->db->query($sqlbutir1)->result(); | |
| $rowunsur2subsub = ""; | |
| $totalrowsubsub_2 = 1; | |
| $totalsubsubunsur = 0; | |
| $totalsubsubunsur2 = 0; | |
| $tot_sub_unsur = 1; | |
| $coba_total_row = 0; | |
| foreach ($data_unsursub1 as $key => $unsursubsub) | |
| { | |
| //// untuk abjad a) //// | |
| if(strlen($unsursubsub->ID_Kegiatan) == '13') | |
| { | |
| if($unsursubsub->Unsur == "Peneraan") | |
| { | |
| $addwhere = " AND b.KD_Kegiatan = '' "; | |
| } | |
| else | |
| { | |
| $addwhere = ''; | |
| } | |
| $sqlbutir2 = "SELECT b.*,a.ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(b.ID_Kegiatan,1,16) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsursubsub->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsursubsub->ID_Kegiatan)." | |
| AND LENGTH(a.ID_Kegiatan) != 13 | |
| ".$addwhere." | |
| GROUP BY a.ID_Kegiatan | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else | |
| { | |
| $sqlbutir2 = "SELECT b.*,a.ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama,GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(b.ID_Kegiatan,1,16) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsursubsub->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,10) = ".$this->db->escape($unsursubsub->ID_Kegiatan)." and a.Unsur != 'Pendidikan' | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,10) | |
| ORDER BY id_transaksi_detail"; | |
| // var_dump($sqlbutir2);exit(); | |
| } | |
| //echo $sqlbutir2;exit; | |
| $num_unsursub2 = $this->db->query($sqlbutir2)->num_rows(); | |
| $data_unsursub2 = $this->db->query($sqlbutir2)->result(); | |
| $rowunsur2subsub1 =''; | |
| $dupakbarupenunjang = 0; | |
| $abjadunsur2sub2 = "a"; | |
| foreach ($data_unsursub2 as $key => $unsursubsub2) | |
| { | |
| ///// untuk abjad (1) ///// | |
| if(strlen($unsursubsub2->ID_Kegiatan) > '13') | |
| { | |
| $sqlbutir3 = "SELECT b.*,GROUP_CONCAT(a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,19) = SUBSTR(b.ID_Kegiatan,1,19) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsursubsub2->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,19) = ".$this->db->escape($unsursubsub2->ID_Kegiatan)." and a.Unsur = 'Peneraan' | |
| GROUP BY a.ID_Kegiatan | |
| ORDER BY id_transaksi_detail"; | |
| $num_unsursub3 = $this->db->query($sqlbutir3)->num_rows(); | |
| // var_dump($num_unsursub3).'<br>'; | |
| $data_unsursub3 = $this->db->query($sqlbutir3)->result(); | |
| } | |
| $rowunsur2subsub2 =''; | |
| $dupakbarupenunjang2 = 0; | |
| $abjadunsur2sub3 = "1"; | |
| //print_r($data_unsursub3);exit; | |
| foreach ($data_unsursub3 as $key => $unsursubsub3) | |
| { | |
| $dupak_lama = ''; | |
| $dupak_baru = ''; | |
| $jumlahtotal = ''; | |
| $hapus_koma = explode(',', $unsursubsub3->pak_lama); | |
| $explode_strip_1 = explode('_', $hapus_koma[0]); | |
| $explode_strip_2 = explode('_', $hapus_koma[1]); | |
| if($explode_strip_1[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_1[1]; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_1[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_1[1]; | |
| $dupak_lama = 0; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| if($explode_strip_2[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_2[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| $jumlahtotal = $dupak_lama+$dupak_baru; | |
| if($unsur2->Unsur != 'Pendidikan') | |
| $pakLama = ''; | |
| else | |
| $pakLama = $dupak_lama; | |
| $rowunsur2subsub2 .= '<tr> | |
| <td width="5%" align="center" >('.$abjadunsur2sub3.')</td> | |
| <td width="20%" >'.$unsursubsub3->Kegiatan.' </td> | |
| <td width="8%" align="center" >'.$pakLama.'</td> | |
| <td width="8.3%" align="center" >'.$dupak_baru.' </td> | |
| <td width="8.7%" align="center" >'.$jumlahtotal.'</td> | |
| <td width="8%" align="center" ></td> | |
| <td width="8.3%" align="center" ></td> | |
| <td width="8.6%" align="center" ></td> | |
| </tr>'; | |
| $totalsubsubunsur2 = $totalsubsubunsur2 + 1; | |
| $jumlahpaklama2 = $jumlahpaklama2 + $dupak_lama; | |
| $jumlahpakbaru2 = $jumlahpakbaru2 + $dupak_baru; | |
| $totaljumlahpak2 = $totaljumlahpak2 + $jumlahtotal; | |
| $totalrowsubsubunsur2++; | |
| $abjadunsur2sub3++; | |
| $totalsubbutir2 ++; | |
| $total_no_1_1_1++; | |
| $coba_total_row++; | |
| } | |
| ///// untuk abjad (1) ///// | |
| $dupak_lama = ''; | |
| $dupak_baru = ''; | |
| $jumlahtotal = ''; | |
| if($num_unsursub3 == 0) | |
| { | |
| $hapus_koma = explode(',', $unsursubsub2->pak_lama); | |
| $explode_strip_1 = explode('_', $hapus_koma[0]); | |
| $explode_strip_2 = explode('_', $hapus_koma[1]); | |
| if($explode_strip_1[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_1[1]; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_1[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_1[1]; | |
| $dupak_lama = 0; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| if($explode_strip_2[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_2[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| $jumlahtotal = $dupak_lama+$dupak_baru; | |
| } | |
| // $pakbaru = isset($unsursubsub2->total) ? $unsursubsub2->total : '0'; | |
| if($unsur2->Unsur != 'Pendidikan') | |
| $pakLama = ''; | |
| else | |
| $pakLama = $dupak_lama; | |
| $pakLama = ''; | |
| $rowunsur2subsub1 .= '<tr> | |
| <td width="5%" align="center" rowspan = "'.($num_unsursub3+1).'" >'.$abjadunsur2sub2.')</td> | |
| <td width="25%" >'.$unsursubsub2->Kegiatan.' </td> | |
| <td width="8%" align="center" >'.$pakLama.'</td> | |
| <td width="8.3%" align="center" >'.$dupak_baru.' </td> | |
| <td width="8.7%" align="center" >'.$jumlahtotal.'</td> | |
| <td width="8%" align="center" ></td> | |
| <td width="8.3%" align="center" ></td> | |
| <td width="8.6%" align="center" ></td> | |
| </tr>'.$rowunsur2subsub2;; | |
| $totalsubsubunsur = $totalsubsubunsur + 1; | |
| $jumlahpaklama1 = $jumlahpaklama1 + $dupak_lama; | |
| $jumlahpakbaru1 = $jumlahpakbaru1 + $dupak_baru; | |
| $totaljumlahpak1 = $totaljumlahpak1 + $jumlahtotal; | |
| $totalrowsubsubunsur++; | |
| $abjadunsur2sub2++; | |
| $totalsubbutir ++; | |
| $total_no_1_1++; | |
| } | |
| //// end untuk abjad a) //// | |
| $dupak_lama = ''; | |
| $dupak_baru = ''; | |
| $jumlahtotal = ''; | |
| if($num_unsursub2 == 0) | |
| { | |
| $hapus_koma = explode(',', $unsursubsub->pak_lama); | |
| $explode_strip_1 = explode('_', $hapus_koma[0]); | |
| $explode_strip_2 = explode('_', $hapus_koma[1]); | |
| if($explode_strip_1[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_1[1]; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_1[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_1[1]; | |
| $dupak_lama = 0; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| if($explode_strip_2[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_2[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| $jumlahtotal = $dupak_lama+$dupak_baru; | |
| } | |
| // level 4 | |
| // if($unsur2->Unsur != 'Pendidikan') | |
| // $pakLama = ''; | |
| // else | |
| // $pakLama = $dupak_lama; | |
| $pakLama = ''; | |
| $rowunsur2subsub .= | |
| '<tr> | |
| <td width="5%" align="left" rowspan = "'.($num_unsursub2+1+$coba_total_row).'">'.($totalrowsubsub_2).')</td> | |
| <td width="30%" align="left">'.$unsursubsub->Kegiatan.'</td> | |
| <td width="8%" align="center" >'.$pakLama.'</td> | |
| <td width="8.3%" align="center" >'.$dupak_baru.' </td> | |
| <td width="8.7%" align="center" >'.$jumlahtotal.'</td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.6%" align="center" > </td> | |
| </tr>'.$rowunsur2subsub1; | |
| $totalsubsub++; | |
| $total_abjad_A++; | |
| $totalrowsubsub++; | |
| $jumlahpaklama = $jumlahpaklama + $dupak_lama; | |
| $jumlahpakbaru = $jumlahpakbaru + $dupak_baru; | |
| $totaljumlahpak = $totaljumlahpak + $jumlahtotal; | |
| $totalrowsubsub_2 = $totalrowsubsub_2 + 1; | |
| } | |
| /// end nomor 1) /// | |
| //print_r($unsur11);exit; | |
| if($unsur2->Unsur == 'Pendidikan') | |
| { | |
| if($idold == '') | |
| { | |
| $iddataPend = $arrHeader->id; | |
| $flg = '1'; | |
| } | |
| else | |
| { | |
| $iddataPend = $idold; | |
| $flg = '2'; | |
| } | |
| $sqlGetNilaiPendidikan = "SELECT SUM(a.nilai_pak) as nilaiPendidikan | |
| FROM tr_transaksi_detail a | |
| WHERE a.id_transaksi_hdr = ".$this->db->escape($iddataPend)." | |
| AND left(a.ID_Kegiatan,10) = LEFT(".$this->db->escape($unsur11->ID_Kegiatan).",10) | |
| AND a.flg_lama = ".$this->db->escape($flg)." | |
| AND a.Unsur = 'Pendidikan'"; | |
| //echo $sqlGetNilaiPendidikan; | |
| $nilaiPendidikan = $this->db->query($sqlGetNilaiPendidikan)->row()->nilaiPendidikan; | |
| } | |
| else | |
| { | |
| $nilaiPendidikan = ''; | |
| } | |
| $nilaiPendidikan = ''; | |
| $rowunsur2sub .= | |
| '<tr> | |
| <td width="5%" align="center" rowspan = "'.($totalrowsubsub_2+$totalsubsubunsur+$totalsubsubunsur2).'" >'.$abjadunsur2sub.'</td> | |
| <td width="35%" align="left" >'.$unsur11->Kegiatan.'</td> | |
| <td width="8%" align="center" >'.$nilaiPendidikan.'</td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.7%" align="center" > </td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.6%" align="center" > </td> | |
| </tr>'.$rowunsur2subsub; | |
| $tot++; | |
| $tot_row++; | |
| $abjadunsur2sub++; | |
| } | |
| // end abjad A // | |
| $coba = $tot+$total_abjad_A+$total_no_1_1+$total_no_1_1_1; | |
| if($idold == '') | |
| { | |
| $iddataGet = $arrHeader->id; | |
| $flgLama = '1'; | |
| } | |
| else | |
| { | |
| $iddataGet = $idold; | |
| $flgLama = '2'; | |
| } | |
| $sql = "SELECT SUM(a.nilai_pak) AS nilailama | |
| FROM tr_transaksi_detail a | |
| WHERE a.Unsur = ".$this->db->escape($unsur2->Unsur)." AND a.id_transaksi_hdr = ".$this->db->escape($iddataGet)." | |
| AND a.flg_lama = ".$this->db->escape($flgLama); | |
| $pakLama = $this->db->query($sql)->row()->nilailama; | |
| if($unsur2->Unsur == 'Pendidikan') | |
| $pakLama = ''; | |
| $rowunsur2 .= '<tr> | |
| <td width="5%" align="center" rowspan = "'.$coba.'" >'.$nounsur.'</td> | |
| <td width="40%" align="center" >'.$unsur2->Unsur.'</td> | |
| <td width="8%" align="center" >'.$pakLama.'</td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.7%" align="center" > </td> | |
| <td width="8%" align="center" ></td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.6%" align="center" > </td> | |
| </tr>'.$rowunsur2sub; | |
| $nounsur++; | |
| $totalrow = $nounsur+$tot_row+$totalrowsubsub+$totalrowsubsubunsur+$totalrowsubsubunsur2; | |
| } | |
| // exit(); | |
| $html = '<ul style="list-style-type: none;text-align:justify;"> | |
| <li> | |
| <table border="1" style="width: 100%" cellpadding = "3" > | |
| <tr> | |
| <td width="5%" rowspan = "4" >NO</td> | |
| <td width="95%" align="center" >UNSUR YANG DINILAI </td> | |
| </tr> | |
| <tr> | |
| <td width="45%" align="center" rowspan = "3" >UNSUR, SUB UNSUR DAN BUTIR KEGIATAN</td> | |
| <td width="50%" align="center" >ANGKA KREDIT MENURUT </td> | |
| </tr> | |
| <tr> | |
| <td width="25%" align="center" >INSTANSI PENGUSUL </td> | |
| <td width="25%" align="center" >TIM PENILAI </td> | |
| </tr> | |
| <tr> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.7%" align="center" >JUMLAH </td> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.6%" align="center" >JUMLAH </td> | |
| </tr> | |
| <tr> | |
| <td width="5%" align="center" rowspan = "'.($totalrow+1).'" >I</td> | |
| <td width="45%" align="center" >UNSUR UTAMA </td> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.7%" align="center" >JUMLAH </td> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.6%" align="center" >JUMLAH </td> | |
| </tr> | |
| '.$rowunsur2.' | |
| <tr>'; | |
| // if($totalrow== 4) | |
| // { | |
| // $html .= '<td width="5%" align="center" rowspan = "'.($totalrow+1).'"></td>'; | |
| // } | |
| $html .= '<td width="45%" align="center"><b>Jumlah Unsur Utama</b></td> | |
| <td width="8%" align="center" ><b>'.($jumlahpaklama+$jumlahpaklama1+$jumlahpaklama2+$get_unsurlama->nilai_pak_lama).'</b></td> | |
| <td width="8.3%" align="center" ><b>'.($jumlahpakbaru+$jumlahpakbaru1+$jumlahpakbaru2).'</b></td> | |
| <td width="8.7%" align="center" ><b>'.($totaljumlahpak+$totaljumlahpak1+$$totaljumlahpak2+$get_unsurlama->nilai_pak_lama).'</b></td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" ><b>'.$jumlahpenilaibaru.'</b></td> | |
| <td width="8.6%" align="center" ><b>'.$jumlahpenilaibaru.'</b></td> | |
| </tr> | |
| </table></li></ul>'; | |
| $pdf->setListIndentWidth(3); | |
| $pdf->writeHTML($html, true, 0, true, true); | |
| // var_dump($get_unsurlama->nilai_pak_lama);exit(); | |
| /////////////////////////////////////////////////// UNTUK UNSUR PENUNJANG ///////////////////////////////////////////////////// | |
| $pdf->ln(-4); | |
| $pdf->SetX(12); | |
| $rowunsur2sub = ''; | |
| $rowunsur2 =''; | |
| $nodidik=1; | |
| $nounsur=1; | |
| $totalrow = 1; | |
| $totalrowsubsub = 0; | |
| $totalrowsubsubunsur = 0; | |
| $totalrowsubsubunsur2 = 0; | |
| $jumlahpaklama = 0; | |
| $jumlahpakbaru = 0; | |
| $jumlahpaklama1 = 0; | |
| $jumlahpakbaru1 = 0; | |
| $jumlahpaklama2 = 0; | |
| $jumlahpakbaru2 = 0; | |
| $totaljumlahpak = 0; | |
| $totaljumlahpak1 = 0; | |
| $totaljumlahpak2 = 0; | |
| $jumlahpenilaibaru = 0; | |
| $jumlahtotallama = 0; | |
| $jumlahtotalbaru = 0; | |
| $jumlahtotalpmb = 0; | |
| $jumlahtotalpenilai = 0; | |
| $coba = 0; | |
| $tot_row = 0; | |
| $this->db = $this->load->database('edupakdb', TRUE); | |
| foreach ($arrUnsur3 as $key => $unsur2) | |
| { | |
| // untuk abjad A // | |
| if($unsur2->Unsur == "Peneraan") | |
| { | |
| $sqlsubunsur1 = "SELECT b.*,a.Unsur,a.ID_Kegiatan,SUBSTR(a.ID_Kegiatan_Parent,1,16) as parent_16, | |
| SUBSTR(a.ID_Kegiatan_Parent,1,10) as parent_10,SUBSTR(a.ID_Kegiatan_Parent,1,13) as parent_13 | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(b.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur2->Unsur)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else | |
| { | |
| $sqlsubunsur1 = "SELECT b.*,a.Unsur,a.ID_Kegiatan,SUBSTR(a.ID_Kegiatan_Parent,1,16) as parent_16, | |
| SUBSTR(a.ID_Kegiatan_Parent,1,10) as parent_10,SUBSTR(a.ID_Kegiatan_Parent,1,13) as parent_13 | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,10) = SUBSTR(b.ID_Kegiatan,1,10) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur2->Unsur)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,10) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| $num_unsur1 = $this->db->query($sqlsubunsur1)->num_rows(); | |
| $data_unsur1 = $this->db->query($sqlsubunsur1)->result(); | |
| $rowunsur2sub = ""; | |
| $totalsubsub = 0; | |
| $tot =1; | |
| $abjadunsur2sub = 'A'; | |
| $totalsubbutir = 0; | |
| $totalsubbutir2 = 0; | |
| $total_abjad_A = 0; | |
| $total_no_1_1 = 0; | |
| $total_no_1_1_1 = 0; | |
| foreach ($data_unsur1 as $key => $unsur11) | |
| { | |
| /// untuk nomor 1) /// | |
| if(strlen($unsur11->ID_Kegiatan) == '22') | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,22) = ".$this->db->escape($unsur11->ID_Kegiatan)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else if(strlen($unsur11->ID_Kegiatan) == '19') | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,19) = ".$this->db->escape($unsur11->ID_Kegiatan)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| elseif(strlen($unsur11->ID_Kegiatan) == '16') | |
| { | |
| if($unsur11->Unsur == "Pendidikan") | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,10) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(c.ID_Kegiatan,1,16) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsur11->parent_16)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,16) | |
| ORDER BY id_transaksi_detail"; | |
| // echo($sqlbutir1).';<br>'; | |
| } | |
| else if($unsur11->Unsur == "Pengembangan Profesi") | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,10) = ".$this->db->escape($unsur11->parent_10)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| else | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsur11->parent_13)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| } | |
| else | |
| { | |
| $sqlbutir1 = "SELECT c.*,a.Unsur,SUBSTR(a.ID_Kegiatan,1,13) as ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS c ON SUBSTR(a.ID_Kegiatan,1,13) = SUBSTR(c.ID_Kegiatan,1,13) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsur11->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,10) = ".$this->db->escape($unsur11->parent_13)." | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,10) | |
| ORDER BY id_transaksi_detail"; | |
| } | |
| $num_unsursub1 = $this->db->query($sqlbutir1)->num_rows(); | |
| $data_unsursub1 = $this->db->query($sqlbutir1)->result(); | |
| $rowunsur2subsub = ""; | |
| $totalrowsubsub_2 = 1; | |
| $totalsubsubunsur = 0; | |
| $totalsubsubunsur2 = 0; | |
| $tot_sub_unsur = 1; | |
| $coba_total_row = 0; | |
| foreach ($data_unsursub1 as $key => $unsursubsub) | |
| { | |
| //// untuk abjad a) //// | |
| if(strlen($unsursubsub->ID_Kegiatan) == '13') | |
| { | |
| if($unsursubsub->Unsur == "Peneraan") | |
| { | |
| $addwhere = " AND b.KD_Kegiatan = '' "; | |
| } | |
| else | |
| { | |
| $addwhere = ''; | |
| } | |
| $sqlbutir2 = "SELECT b.*,a.ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama, | |
| GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(b.ID_Kegiatan,1,16) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsursubsub->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsursubsub->ID_Kegiatan)." | |
| AND LENGTH(a.ID_Kegiatan) != 13 | |
| ".$addwhere." | |
| GROUP BY a.ID_Kegiatan | |
| ORDER BY id_transaksi_detail"; | |
| // if($unsursubsub->Unsur == "Peneraan") | |
| // { | |
| // echo $sqlbutir2.';<br>'; | |
| // } | |
| } | |
| else | |
| { | |
| $sqlbutir2 = "SELECT b.*,a.ID_Kegiatan,a.Angka_Kredit_Murni,a.flg_lama,GROUP_CONCAT(DISTINCT a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,16) = SUBSTR(b.ID_Kegiatan,1,16) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsursubsub->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,13) = ".$this->db->escape($unsursubsub->ID_Kegiatan)." and a.Unsur != 'Pendidikan' | |
| GROUP BY SUBSTR(a.ID_Kegiatan,1,13) | |
| ORDER BY id_transaksi_detail"; | |
| // var_dump($sqlbutir2);exit(); | |
| } | |
| $num_unsursub2 = $this->db->query($sqlbutir2)->num_rows(); | |
| $data_unsursub2 = $this->db->query($sqlbutir2)->result(); | |
| $rowunsur2subsub1 =''; | |
| $dupakbarupenunjang = 0; | |
| $abjadunsur2sub2 = "a"; | |
| foreach ($data_unsursub2 as $key => $unsursubsub2) | |
| { | |
| ///// untuk abjad (1) ///// | |
| if(strlen($unsursubsub2->ID_Kegiatan) > '13') | |
| { | |
| $sqlbutir3 = "SELECT b.*,GROUP_CONCAT(a.flg_lama,'_',a.total SEPARATOR ',') AS pak_lama | |
| FROM tr_transaksi_detail AS a | |
| LEFT JOIN tbk_kegiatan_jabatan_fungsional AS b ON SUBSTR(a.ID_Kegiatan,1,19) = SUBSTR(b.ID_Kegiatan,1,19) | |
| WHERE id_transaksi_hdr = ".$this->db->escape($iddata)." AND a.Unsur = ".$this->db->escape($unsursubsub2->Unsur)." AND SUBSTR(a.ID_Kegiatan,1,19) = ".$this->db->escape($unsursubsub2->ID_Kegiatan)." and a.Unsur = 'Peneraan' | |
| GROUP BY a.ID_Kegiatan | |
| ORDER BY id_transaksi_detail"; | |
| $num_unsursub3 = $this->db->query($sqlbutir3)->num_rows(); | |
| // var_dump($num_unsursub3).'<br>'; | |
| $data_unsursub3 = $this->db->query($sqlbutir3)->result(); | |
| } | |
| $rowunsur2subsub2 =''; | |
| $dupakbarupenunjang2 = 0; | |
| $abjadunsur2sub3 = "1"; | |
| foreach ($data_unsursub3 as $key => $unsursubsub3) | |
| { | |
| $dupak_lama = ''; | |
| $dupak_baru = ''; | |
| $jumlahtotal = ''; | |
| $hapus_koma = explode(',', $unsursubsub3->pak_lama); | |
| $explode_strip_1 = explode('_', $hapus_koma[0]); | |
| $explode_strip_2 = explode('_', $hapus_koma[1]); | |
| if($explode_strip_1[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_1[1]; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_1[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_1[1]; | |
| $dupak_lama = 0; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| if($explode_strip_2[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_2[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| $jumlahtotal = $dupak_lama+$dupak_baru; | |
| $rowunsur2subsub2 .= '<tr> | |
| <td width="5%" align="center" >('.$abjadunsur2sub3.')</td> | |
| <td width="20%" >'.$unsursubsub3->Kegiatan.' </td> | |
| <td width="8%" align="center" >'.$dupak_lama.'</td> | |
| <td width="8.3%" align="center" >'.$dupak_baru.' </td> | |
| <td width="8.7%" align="center" >'.$jumlahtotal.'</td> | |
| <td width="8%" align="center" ></td> | |
| <td width="8.3%" align="center" ></td> | |
| <td width="8.6%" align="center" ></td> | |
| </tr>'; | |
| $totalsubsubunsur2 = $totalsubsubunsur2 + 1; | |
| $jumlahpaklama2 = $jumlahpaklama2 + $dupak_lama; | |
| $jumlahpakbaru2 = $jumlahpakbaru2 + $dupak_baru; | |
| $totaljumlahpak2 = $totaljumlahpak2 + $jumlahtotal; | |
| $totalrowsubsubunsur2++; | |
| $abjadunsur2sub3++; | |
| $totalsubbutir2 ++; | |
| $total_no_1_1_1++; | |
| $coba_total_row++; | |
| } | |
| ///// untuk abjad (1) ///// | |
| $dupak_lama = ''; | |
| $dupak_baru = ''; | |
| $jumlahtotal = ''; | |
| if($num_unsursub3 == 0) | |
| { | |
| $hapus_koma = explode(',', $unsursubsub2->pak_lama); | |
| $explode_strip_1 = explode('_', $hapus_koma[0]); | |
| $explode_strip_2 = explode('_', $hapus_koma[1]); | |
| if($explode_strip_1[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_1[1]; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_1[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_1[1]; | |
| $dupak_lama = 0; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| if($explode_strip_2[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_2[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| $jumlahtotal = $dupak_lama+$dupak_baru; | |
| } | |
| // $pakbaru = isset($unsursubsub2->total) ? $unsursubsub2->total : '0'; | |
| $rowunsur2subsub1 .= '<tr> | |
| <td width="5%" align="center" rowspan = "'.($num_unsursub3+1).'" >'.$abjadunsur2sub2.')</td> | |
| <td width="25%" >'.$unsursubsub2->Kegiatan.' </td> | |
| <td width="8%" align="center" >'.$dupak_lama.'</td> | |
| <td width="8.3%" align="center" >'.$dupak_baru.' </td> | |
| <td width="8.7%" align="center" >'.$jumlahtotal.'</td> | |
| <td width="8%" align="center" ></td> | |
| <td width="8.3%" align="center" ></td> | |
| <td width="8.6%" align="center" ></td> | |
| </tr>'.$rowunsur2subsub2;; | |
| $totalsubsubunsur = $totalsubsubunsur + 1; | |
| $jumlahpaklama1 = $jumlahpaklama1 + $dupak_lama; | |
| $jumlahpakbaru1 = $jumlahpakbaru1 + $dupak_baru; | |
| $totaljumlahpak1 = $totaljumlahpak1 + $jumlahtotal; | |
| $totalrowsubsubunsur++; | |
| $abjadunsur2sub2++; | |
| $totalsubbutir ++; | |
| $total_no_1_1++; | |
| } | |
| //// end untuk abjad a) //// | |
| $dupak_lama = ''; | |
| $dupak_baru = ''; | |
| $jumlahtotal = ''; | |
| if($num_unsursub2 == 0) | |
| { | |
| // var_dump($unsursubsub->pak_lama).'<br>'; | |
| $hapus_koma = explode(',', $unsursubsub->pak_lama); | |
| $explode_strip_1 = explode('_', $hapus_koma[0]); | |
| $explode_strip_2 = explode('_', $hapus_koma[1]); | |
| if($explode_strip_1[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_1[1]; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_1[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_1[1]; | |
| $dupak_lama = 0; | |
| if(empty($explode_strip_2[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| if($explode_strip_2[0] == 1) | |
| { | |
| $dupak_lama = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_baru = 0; | |
| } | |
| } | |
| elseif($explode_strip_2[0] == 2) | |
| { | |
| $dupak_baru = $explode_strip_2[1]; | |
| if(empty($explode_strip_1[0])) | |
| { | |
| $dupak_lama = 0; | |
| } | |
| } | |
| $jumlahtotal = $dupak_lama+$dupak_baru; | |
| } | |
| $rowunsur2subsub .= | |
| '<tr> | |
| <td width="5%" align="left" rowspan = "'.($num_unsursub2+1+$coba_total_row).'">'.($totalrowsubsub_2).')</td> | |
| <td width="30%" align="left">'.$unsursubsub->Kegiatan.' </td> | |
| <td width="8%" align="center" >'.$dupak_lama.'</td> | |
| <td width="8.3%" align="center" >'.$dupak_baru.' </td> | |
| <td width="8.7%" align="center" >'.$jumlahtotal.'</td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.6%" align="center" > </td> | |
| </tr>'.$rowunsur2subsub1; | |
| $totalsubsub++; | |
| $total_abjad_A++; | |
| $totalrowsubsub++; | |
| $jumlahpaklama = $jumlahpaklama + $dupak_lama; | |
| $jumlahpakbaru = $jumlahpakbaru + $dupak_baru; | |
| $totaljumlahpak = $totaljumlahpak + $jumlahtotal; | |
| $totalrowsubsub_2 = $totalrowsubsub_2 + 1; | |
| } | |
| /// end nomor 1) /// | |
| $rowunsur2sub .= | |
| '<tr> | |
| <td width="5%" align="center" rowspan = "'.($totalrowsubsub_2+$totalsubsubunsur+$totalsubsubunsur2).'" >'.$abjadunsur2sub.'</td> | |
| <td width="35%" align="left" >'.$unsur11->Kegiatan.'</td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.7%" align="center" > </td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.6%" align="center" > </td> | |
| </tr>'.$rowunsur2subsub; | |
| $tot++; | |
| $tot_row++; | |
| $abjadunsur2sub++; | |
| } | |
| // end abjad A // | |
| $coba = $tot+$total_abjad_A+$total_no_1_1+$total_no_1_1_1; | |
| $tipe = ''; | |
| if($tipe == 'inisiasi') | |
| { | |
| $flgLama = '1'; | |
| } | |
| else | |
| { | |
| $flgLama = '2'; | |
| } | |
| $sql = "SELECT SUM(a.nilai_pak) AS nilailama | |
| FROM tr_transaksi_detail a | |
| WHERE a.Unsur = ".$this->db->escape($unsur2->Unsur)." AND a.id_transaksi_hdr = ".$this->db->escape($idold)." | |
| AND a.flg_lama = ".$this->db->escape($flgLama); | |
| //echo $sql;exit; | |
| $pakLama = $this->db->query($sql)->row()->nilailama; | |
| $rowunsur2 .= '<tr> | |
| <td width="5%" align="center" rowspan = "'.$coba.'" >'.$nounsur.'</td> | |
| <td width="40%" align="center" >'.$unsur2->Unsur.'</td> | |
| <td width="8%" align="center" >'.$pakLama.'</td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.7%" align="center" > </td> | |
| <td width="8%" align="center" ></td> | |
| <td width="8.3%" align="center" > </td> | |
| <td width="8.6%" align="center" > </td> | |
| </tr>'.$rowunsur2sub; | |
| $nounsur++; | |
| $totalrow = $nounsur+$tot_row+$totalrowsubsub+$totalrowsubsubunsur+$totalrowsubsubunsur2; | |
| } | |
| // exit(); | |
| $html = '<ul style="list-style-type: none;text-align:justify;"> | |
| <li> | |
| <table border="1" style="width: 100%" cellpadding = "3" > | |
| <tr> | |
| <td width="5%" rowspan = "4" >NO</td> | |
| <td width="95%" align="center" >UNSUR YANG DINILAI </td> | |
| </tr> | |
| <tr> | |
| <td width="45%" align="center" rowspan = "3" >UNSUR, SUB UNSUR DAN BUTIR KEGIATAN</td> | |
| <td width="50%" align="center" >ANGKA KREDIT MENURUT </td> | |
| </tr> | |
| <tr> | |
| <td width="25%" align="center" >INSTANSI PENGUSUL </td> | |
| <td width="25%" align="center" >TIM PENILAI </td> | |
| </tr> | |
| <tr> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.7%" align="center" >JUMLAH </td> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.6%" align="center" >JUMLAH </td> | |
| </tr> | |
| <tr> | |
| <td width="5%" align="center" rowspan = "'.($totalrow+1).'" >I</td> | |
| <td width="45%" align="center" >UNSUR UTAMA </td> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.7%" align="center" >JUMLAH </td> | |
| <td width="8%" align="center" >LAMA </td> | |
| <td width="8.3%" align="center" >BARU </td> | |
| <td width="8.6%" align="center" >JUMLAH </td> | |
| </tr> | |
| '.$rowunsur2.' | |
| <tr>'; | |
| // if($totalrow== 4) | |
| // { | |
| // $html .= '<td width="5%" align="center" rowspan = "'.($totalrow+1).'"></td>'; | |
| // } | |
| $html .= '<td width="45%" align="center"><b>Jumlah Unsur Penunjang</b></td> | |
| <td width="8%" align="center" ><b>'.($jumlahpaklama+$jumlahpaklama1+$jumlahpaklama2+$get_unsurlama_penunjang->nilai_pak_lama).'</b></td> | |
| <td width="8.3%" align="center" ><b>'.($jumlahpakbaru+$jumlahpakbaru1+$jumlahpakbaru2).'</b></td> | |
| <td width="8.7%" align="center" ><b>'.($totaljumlahpak+$totaljumlahpak1+$$totaljumlahpak2+$get_unsurlama_penunjang->nilai_pak_lama).'</b></td> | |
| <td width="8%" align="center" > </td> | |
| <td width="8.3%" align="center" ><b>'.$jumlahpenilaibaru.'</b></td> | |
| <td width="8.6%" align="center" ><b>'.$jumlahpenilaibaru.'</b></td> | |
| </tr> | |
| </table></li></ul>'; | |
| $pdf->setListIndentWidth(3); | |
| $pdf->writeHTML($html, true, 0, true, true); | |
| // var_dump($get_unsurlama_penunjang->nilai_pak_lama);exit(); | |
| /////////////////////////////////////////////////// END UNTUK UNSUR PENUNJANG ///////////////////////////////////////////////// | |
| $pdf->AddPage('P','A4'); | |
| $html = '<ul style="list-style-type: none;text-align:justify;"> | |
| <li> | |
| <table border="1" style="width: 100%"> | |
| <tr> | |
| <td width="10%"> III </td> | |
| <td width = "90%" colspan = "2"> LAMPIRAN PENDUKUNG DUPAK : </td> | |
| </tr> | |
| <tr> | |
| <td height="100"> </td> | |
| <td> </td> | |
| <td> </td> | |
| </tr> | |
| <tr> | |
| <td width="10%"> IV </td> | |
| <td width = "90%" colspan = "2"> Catatan Pejabat Pengusul : </td> | |
| </tr> | |
| <tr> | |
| <td height="100"> </td> | |
| <td> </td> | |
| <td> </td> | |
| </tr> | |
| <tr> | |
| <td width="10%"> V </td> | |
| <td width = "90%" colspan = "2"> Catatan Anggota Tim Penilai : </td> | |
| </tr> | |
| <tr> | |
| <td height="100"> </td> | |
| <td> </td> | |
| <td> </td> | |
| </tr> | |
| <tr> | |
| <td width="10%"> VI </td> | |
| <td width = "90%" colspan = "2"> CATATAN KETUA TIM PENILAI : </td> | |
| </tr> | |
| <tr> | |
| <td height="100"> </td> | |
| <td> </td> | |
| <td> </td> | |
| </tr>'; | |
| $html .=' | |
| </table></li></ul>'; | |
| $pdf->ln(); | |
| $pdf->setListIndentWidth(4); | |
| $pdf->writeHTML($html, true, 0, true, true); | |
| $pdf->Output(); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment