ceklog(); $this->load->library('pdf_tgk'); $this->load->library('rhrpt'); $this->load->library('rhlib'); } function ceklog() { $user = $this->session->userdata("user_id1unla"); if($user==""){ redirect('user/login'); } } function get_row_pars($table,$fields,$condition){ return $this->rhlib->get_row_pars($table,$fields,$condition); } function get_data($jenis_kelas,$kdprodi){ $KEDUA= $this->load->database('second', TRUE); $query = $KEDUA->query("CALL sp_getTunggakanDet (?,?)",array($jenis_kelas,$kdprodi)); $result = array(); if ($query->num_rows() > 0) { $result = $query->result(); } return $result; } function get_rows($jenis_kelas,$kdprodi){ // data table $data = $this->get_data($jenis_kelas,$kdprodi); $total = 0; $t_tagih = 0; $tot_tagih = 0; $t_bayar = 0; $tot_bayar = 0; $t_sisa = 0; $tot_sisa = 0; $rows = ""; foreach($data as $item) { $t_tagih += $item->biaya; $tot_tagih = number_format($t_tagih , 0 , ',' , '.' ); $t_bayar += $item->jmlbayar; $tot_bayar = number_format($t_bayar , 0 , ',' , '.' ); $t_sisa += $item->sisa; $tot_sisa = number_format($t_sisa , 0 , ',' , '.' ); $rows .= " ".$item->nim."   ".$item->nmmhs."    ".number_format($item->biaya , 0 , ',' , '.' )."    ".number_format($item->jmlbayar , 0 , ',' , '.' )."    ".number_format($item->persenbayar , 2 , ',' , '.' )."    ".number_format($item->sisa , 0 , ',' , '.' )."    ".number_format($item->persensisa , 2 , ',' , '.' )." ".$item->stlunas." "; } $rows .= " TOTAL   $tot_tagih   $tot_bayar   $tot_sisa "; return $rows; } function get_det_tgk($jenis_kelas,$kdprodi){ $row_jnskelas = $this->get_row_pars("jkls","nmjnskls","idjnskls='$jenis_kelas'"); $row_prodi = $this->get_row_pars("prodi","nmprodi","kdprodi='$kdprodi'"); $kelas = $row_jnskelas->nmjnskls; $prodi = $row_prodi->nmprodi; $this->pdf_tgk->SetCreator(PDF_CREATOR); //$image_file = base_url().'resources/img/report.png'; // set default header data $this->pdf_tgk->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH,PDF_HEADER_TITLE,PDF_HEADER_STRING); $this->pdf_tgk->setPrintHeader(true); $this->pdf_tgk->setPrintFooter(false); // set header and footer fonts $this->pdf_tgk->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', 10)); $this->pdf_tgk->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA)); // set default monospaced font $this->pdf_tgk->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED); // set margins $this->pdf_tgk->SetMargins('20', '40', '20'); $this->pdf_tgk->SetHeaderMargin('10'); $this->pdf_tgk->SetFooterMargin(PDF_MARGIN_FOOTER); // set auto page breaks $this->pdf_tgk->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM); // set image scale factor $this->pdf_tgk->setImageScale(PDF_IMAGE_SCALE_RATIO); // set some language-dependent strings (optional) // --------------------------------------------------------- // set font $this->pdf_tgk->SetFont('helvetica', 'B', 12); $this->pdf_tgk->SetCellPadding(0); // add a page $this->pdf_tgk->AddPage('L','F4'); $this->pdf_tgk->Write(0, 'LAPORAN DETAIL TUNGGAKAN MAHASISWA', '', 0, 'C', true, 0, false, false, 0); //$this->pdf_tgk->Write(0, 'TAHUN MASUK / ANGKATAN '.$tahun, '', 0, 'C', true, 0, false, false, 0); $this->pdf_tgk->Write(0, 'KELAS '.strtoupper($kelas), '', 0, 'C', true, 0, false, false, 0); $this->pdf_tgk->Write(0, 'PROGRAM STUDI '.$prodi, '', 0, 'C', true, 0, false, false, 0); //$this->pdf_tgk->Cell(0,12,'',0,1,'L'); // untuk memberi space $this->pdf_tgk->SetFont('helvetica', 'B', 12); $rows_get_tgk= $this->get_rows($jenis_kelas,$kdprodi); $tbl = <<
$rows_get_tgk

NPM	Nama Mahasiswa	Total Tagihan	Total Bayar	% Tot. Bayar	Tunggakan	% Tunggakan	Status

EOD; $this->pdf_tgk->writeHTML($tbl,true,false,false,false); $this->pdf_tgk->Output('rpt_detail_tunggakan_mahasiswa.pdf', 'I'); } } ?>