ceklog();
$this->load->library('pdf_dpp');
$this->load->library('rhrpt');
$this->load->library('rhlib');
}
function ceklog() {
$user = $this->session->userdata("user_id1unla");
if($user==""){
redirect('user/login');
}
}
function get_bilangan($num){
return $this->rhlib->get_bilangan($num);
}
function get_par_val($table,$fieldName,$condition){
return $this->rhlib->get_par_val($table,$fieldName,$condition);
}
function get_row_pars($table,$fields,$condition){
return $this->rhlib->get_row_pars($table,$fields,$condition);
}
function get_data($semester,$jenis_kelas){
$KEDUA= $this->load->database('second', TRUE);
$query = $KEDUA->query("CALL sp_getdppallprodinew (?,?)",array($jenis_kelas,$semester));
$result = array();
if ($query->num_rows() > 0) {
$result = $query->result();
}
return $result;
}
function get_rows($semester,$jenis_kelas){
$data = $this->get_data($semester,$jenis_kelas);
$rows = "";
$fakultas='';
$kdfakultas='';
$t_tagih = 0;
$tot_tagih = 0;
$t_bayar = 0;
$tot_bayar = 0;
$t_sisa = 0;
$tot_sisa = 0;
$t_diskon = 0;
$tot_diskon = 0;
foreach($data as $item)
{
$t_tagih += $item->biaya;
$tot_tagih = number_format($t_tagih , 2 , ',' , '.' );
$t_bayar += $item->jmlbayar;
$tot_bayar = number_format($t_bayar , 2 , ',' , '.' );
$t_sisa += $item->sisa;
$tot_sisa = number_format($t_sisa , 2 , ',' , '.' );
$t_diskon += $item->diskon;
$tot_diskon = number_format($t_diskon , 2 , ',' , '.' );
if($item->kdfakultas == $kdfakultas){
$rows .= "
| ".$item->lnmprodi." |
".number_format($item->biaya , 2 , ',' , '.' )." |
".number_format($item->jmlbayar , 2 , ',' , '.' )." |
".number_format($item->persenbayar , 0 , ',' , '.' )." % |
".number_format($item->sisa , 2 , ',' , '.' )." |
".number_format($item->persensisa , 0 , ',' , '.' )." % |
".number_format($item->diskon , 2 , ',' , '.' )." |
";
} else {
$kdfakultas = $item->kdfakultas;
$fakultas = $item->fakultas;
$rows .= "
| $fakultas |
| ".$item->lnmprodi." |
".number_format($item->biaya , 2 , ',' , '.' )." |
".number_format($item->jmlbayar , 2 , ',' , '.' )." |
".number_format($item->persenbayar , 0 , ',' , '.' )." % |
".number_format($item->sisa , 2 , ',' , '.' )." |
".number_format($item->persensisa , 0 , ',' , '.' )." % |
".number_format($item->diskon , 2 , ',' , '.' )." |
";
}
}
$rows .= "
| TOTAL (Rp.) : |
$tot_tagih |
$tot_bayar |
|
$tot_sisa |
|
$tot_diskon |
";
return $rows;
}
function get_dpp($semester,$jenis_kelas,$semestershow){
$thnakademikpar = substr($semestershow,0,4);
$semesterpar = substr($semestershow,5,15);
$row_semester = $this->get_row_pars("v_tahunakademik","kdthnakademik,nmthnakademik","kdstsemester='$semester'");
$row_jnskelas = ($jenis_kelas == 4) ? 'SEMUA':$this->get_row_pars("klsmhs","concat(kdklsmhs, '-', nmklsmhs) AS nmjnskls","idklsmhs='$jenis_kelas'");
$tahun = $row_semester->kdthnakademik;
$jns_kelas = ($jenis_kelas == 4) ? 'SEMUA':$row_jnskelas->nmjnskls;
$this->pdf_dpp->SetCreator(PDF_CREATOR);
$datahead['code'] = 'LAP-DPP-HEAD';
$this->pdf_dpp->addHeaderParams($datahead);
// set default header data
$this->pdf_dpp->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,PDF_HEADER_TITLE,PDF_HEADER_STRING);
$this->pdf_dpp->setPrintHeader(true);
$this->pdf_dpp->setPrintFooter(false);
// set header and footer fonts
$this->pdf_dpp->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', 10));
$this->pdf_dpp->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$this->pdf_dpp->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
// set margins
$this->pdf_dpp->SetMargins('5', '40', '20');
$this->pdf_dpp->SetHeaderMargin('10');
$this->pdf_dpp->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$this->pdf_dpp->SetAutoPageBreak(TRUE, '10');
// set image scale factor
$this->pdf_dpp->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
// ---------------------------------------------------------
// set font
$this->pdf_dpp->SetFont('helvetica', 'B', 11);
$this->pdf_dpp->SetCellPadding(0);
// add a page
$this->pdf_dpp->AddPage('L','F4');
$this->pdf_dpp->Write(0, 'LAPORAN KEUANGAN DPP PER FAKULTAS/ PROGRAM STUDI', '', 0, 'C', true, 0, false, false, 0);
$this->pdf_dpp->Write(0, 'TAHUN AKADEMIK '.$thnakademikpar.'/'.$semesterpar, '', 0, 'C', true, 0, false, false, 0);
$this->pdf_dpp->Write(0, 'JENIS KELAS '.$jns_kelas, '', 0, 'C', true, 0, false, false, 0);
//$this->pdf_dpp->Cell(0,0,'',0,1,'L'); // untuk memberi space
$this->pdf_dpp->SetFont('helvetica', 'B', 11);
$rows_dpp = $this->get_rows($semester,$jenis_kelas);
$tbl = <<
| Fakultas / Program Studi |
Biaya Tagihan |
Bayar |
% Bayar |
Tunggakan |
% Tunggakan |
Diskon |
$rows_dpp
EOD;
$this->pdf_dpp->writeHTML($tbl,true,false,false,false);
$this->pdf_dpp->Output('rpt_dpp.pdf', 'I');
}
}
?>