function cetak() { $type = $this->uri->segment(4); $rpt = $this->input->get('rpt'); $kondisi = ""; if ($rpt == 'sptpd_tr') { $wp_id = $this->input->get('w'); if (!empty($wp_id)) { $kondisi .= " AND c.id={$wp_id} "; } $type_id = $this->input->get('t'); if ($type_id != 999) { $kondisi .= " AND st.id={$type_id} "; } $usaha_id = $this->input->get('u'); if ($usaha_id != 999) { $kondisi .= " AND u.id={$usaha_id} "; } $kondisi .= " AND s.tahun=" . pad_tahun_anggaran(); $params = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), 'kondisi' => (string) $kondisi); } elseif ($rpt == 'sptpd_omset') { $rpt = 'sptpd_rincian_omset'; $sptpd_id = $this->input->get('no'); $terbilang = terbilang(pad_to_decimal($this->input->get('val')), 3) . " Rupiah"; $params = array('sptpd_id' => (int) $sptpd_id, "terbilang" => $terbilang, "alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "logobjb" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/bank-bjb.jpg"); } else { $rpt = 'sptpd_slip'; $sptpd_id = $this->input->get('no'); $terbilang = terbilang(pad_to_decimal($this->input->get('val')), 3) . " Rupiah"; $params = array('sptpd_id' => (int) $sptpd_id, "terbilang" => $terbilang, "alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/logorpt__.jpg", "logobjb" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/bank-bjb.jpg"); } $ignore_html_pg = TRUE; $rpt = 'wp/' . $rpt; $db_pad = $this->load->database('pad', TRUE); $jasper = $this->load->library('Jasper'); $jasper->db = $db_pad->database; $jasper->usr = $db_pad->username; $jasper->pwd = $db_pad->password; $jasper->port = $db_pad->port; echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $sptpd = $this->load->model('sptpd_model')->get($this->input->get('id')); $sspd = $this->load->model('sspd_model')->get_by_spt($this->input->get('id')); $cu = $this->load->model('objek_pajak_model')->get($sptpd->customer_usaha_id); $report = $this->load->model('report_model')->get_report($cu->usaha_id, $sptpd->type_id); // $bayar = $sptpd->pajak_terhutang+$sspd->bunga; // $bayar = ($sptpd->pajak_terhutang-$sptpd->bunga)+$sspd->bunga; $bayar = $sspd->jml_bayar; switch ($this->input->get('rpt')) { case 'sspd': $rpt = $report->sspdnm; $params = array('spt_id' => intval($sptpd->id)); break; case 'validasi': $rpt = 'validasi_00'; $params = array('spt_id' => intval($sptpd->id)); break; } $params = array_merge($params, array("alamat" => pad_pemda_alamat(), "telp" => pad_pemda_telp(), "fax" => pad_pemda_fax(), "website" => pad_pemda_website(), "email" => pad_pemda_email(), "alamat_lengkap" => pad_pemda_alamat_lengkap(), "terbilang" => strtoupper(terbilang($bayar)), "pad_bunga" => (double) pad_bunga(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => base_url('assets/img/logorpt__.jpg'))); $rpt = $rpt; // $rpt = $this->module.'/'.$rpt; $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, false); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $kondisi = ''; $status = $this->input->get('kondisi'); if ($status != '') { $kondisi = "AND cd.customer_status_id={$status}"; } $rpt = $this->input->get('rpt'); switch ($rpt) { case 'daf_induk_wp': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'kondisi' => $kondisi); break; case 'daf_induk_wp_perjenis': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usahaid' => (int) $this->input->get('usahaid'), 'kondisi' => $kondisi); break; case 'daf_induk_wp_perkec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'kecid' => (int) $this->input->get('kecid'), 'kondisi' => $kondisi); break; case 'daf_wp_baru': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'daf_wp_baru_jenis': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'usahaid' => (int) $this->input->get('usahaid'), 'kondisi' => $kondisi); break; case 'daf_wp_baru_kec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kecid' => (int) $this->input->get('kecid'), 'kondisi' => $kondisi); break; case 'daf_wp_jenis_perkec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usahaid' => (int) $this->input->get('usahaid'), 'kondisi' => $kondisi); break; case 'daf_wp_tutup': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'daf_wp_ijin_berakhir': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'daf_rekap_kec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak')))); break; } $tambahan = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama()); $params = array_merge($params, $tambahan); $rpt = 'pendaftaran/' . $rpt; // var_dump($params); // die; $jasper = $this->load->library('Jasper'); //IF PDF if ($type == 'pdf') { echo $jasper->cetak($rpt, $params, $type, false); } else { if ($type == 'html') { $assetpath = 'assets/file'; $tmp = $assetpath . '/tmp/report' . sipkd_user_id() . '.html'; if (is_file($tmp)) { unlink($tmp); } ob_start(); echo $jasper->cetak($rpt, $params, $type, false); echo '1'; file_put_contents($tmp, ob_get_contents()); $objPHPExcel = new PHPExcel(); $inputFileType = 'HTML'; $inputFileName = $tmp; $outputFileType = 'Excel2007'; $outputFileName = $assetpath . '/Report.xls'; $filename = $rpt . date("d-m-Y") . ".xls"; $objPHPExcelReader = IOFactory::createReader($inputFileType); $objPHPExcel = $objPHPExcelReader->load($inputFileName); ini_set('zlib.output_compression', 'Off'); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); //the folowing two lines make sure it is saved as a xls file header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $filename); //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } } }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $kondisi = $this->input->get('kondisi'); if (!empty($kondisi)) { $kondisi = 'and s.type_id=' . $this->input->get('kondisi'); } $rpt = $this->input->get('rpt'); $ignore_html_pg = TRUE; switch ($rpt) { case 'tgh_sdh_byr': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun')); break; case 'tgh_sdh_byr_perkec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'kecamatanid' => (int) $this->input->get('kecamatanid')); break; case 'tgh_sdh_byr_perkel': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'kecamatanid' => (int) $this->input->get('kecamatanid'), 'kelurahanid' => (int) $this->input->get('kelurahanid')); break; case 'tgh_sdh_byr_jnskec': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'usahaid' => (int) $this->input->get('usahaid'), 'kecamatanid' => (int) $this->input->get('kecamatanid')); break; case 'tgh_sdh_byr_jnskel': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'usahaid' => (int) $this->input->get('usahaid'), 'kecamatanid' => (int) $this->input->get('kecamatanid'), 'kelurahanid' => (int) $this->input->get('kelurahanid')); break; case 'tgh_jatuh_tempo_blm_byr': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'usahaid' => (int) $this->input->get('usahaid')); break; case 'tgh_jatuh_tempo_sdh_byr': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'usahaid' => (int) $this->input->get('usahaid')); break; case 'tgh_peringkat_byr': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'tgh_surat_teguran': $ignore_html_pg = FALSE; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'), 'usahaid' => (int) $this->input->get('usahaid')); break; } $tambahan = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama()); $params = array_merge($params, $tambahan); $ignore_html_pg = FALSE; //paging aja semua $rpt = 'penagihan/' . $rpt; // var_dump($params); // die; $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $cu = $this->load->model('objek_pajak_model')->get($this->input->get('id')); $report = $this->load->model('report_model')->get_report($cu->usaha_id, 0); //untuk reklame niy $sptpd = $this->load->model('sptpd_model')->get($this->input->get('sid')); switch ($this->input->get('rpt')) { case 'kartudt': $rpt = $report->kartudtnm; $params = array('cuid' => intval($cu->id), 'terbilang' => strtoupper(terbilang($sptpd->pajak_terhutang)), 'sptid' => intval($this->input->get('sid'))); break; } $params = array_merge($params, array("tahun" => pad_tahun_anggaran(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => base_url('assets/img/logorpt__.jpg'))); $rpt = $rpt; // $rpt = $this->module.'/'.$rpt; $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, false); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $rpt = $this->input->get('rpt'); switch ($rpt) { case 'wpkartu': case 'wpkartu_backside': $params = array('id' => $this->input->get('id'), 'parametercode' => $this->input->get('npwpd'), "img" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/kartuwp.jpg", "ttd" => $_SERVER["DOCUMENT_ROOT"] . "/assets/img/ttd_cap.gif", "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama()); break; case 'wpkukuh': $params = array('id' => $this->input->get('id'), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama()); break; } $rpt = $rpt; $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, false); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $rpt = $this->input->get('rpt'); $ignore_html_pg = TRUE; switch ($rpt) { case 'dat_sptpd_masuk': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cd.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'dat_sptpd_masuk_masa': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cd.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_sptpd_masuk_tgl_all': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'dat_sptpd_masuk_masa_all': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun')); break; case 'dat_sptpd_blm_masuk_masa': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cu.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_sptpd_blm_masuk_masa_all': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun')); break; case 'dat_srt_pemberitahuan': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cu.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_srt_teguran': $usahaid = trim($this->input->get('usahaid')); $kondisi = intval($usahaid) > 0 ? " and cu.usaha_id={$usahaid}" : ""; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'masabulan' => (int) $this->input->get('bulan'), 'masatahun' => (int) $this->input->get('tahun'), 'tahun' => (int) pad_tahun_anggaran(), 'kondisi' => $kondisi); break; case 'dat_srt_teguran_global': $ignore_html_pg = FALSE; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usahaid' => (int) $this->input->get('usahaid')); break; } $tambahan = array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "ttd" => base_url('assets/img/ttd.gif')); $params = array_merge($params, $tambahan); $ignore_html_pg = FALSE; //paging aja semua $rpt = 'pendataan/' . $rpt; $jasper = $this->load->library('Jasper'); if ($type == 'pdf') { echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); } else { if ($type == 'html') { $assetpath = 'assets/file'; $tmp = $assetpath . '/tmp/report' . sipkd_user_id() . '.html'; if (is_file($tmp)) { unlink($tmp); } ob_start(); echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); echo '1'; file_put_contents($tmp, ob_get_contents()); $objPHPExcel = new PHPExcel(); $inputFileType = 'HTML'; $inputFileName = $tmp; $outputFileType = 'Excel2007'; $outputFileName = $assetpath . '/Report.xls'; $filename = $rpt . date("d-m-Y") . ".xls"; $objPHPExcelReader = IOFactory::createReader($inputFileType); $objPHPExcel = $objPHPExcelReader->load($inputFileName); ini_set('zlib.output_compression', 'Off'); header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); //the folowing two lines make sure it is saved as a xls file header('Content-type: application/vnd.ms-excel'); header('Content-Disposition: attachment; filename=' . $filename); //simpan dalam file sample.xls $objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); } } }
function cetak() { $type = $this->uri->segment(4); $rpt = $this->input->get('rpt'); $uid = $this->input->get('uid'); $cuid = $this->input->get('cuid'); $sptid = $this->input->get('cuid'); // spt_id on skpdj $kondisi = $uid == '999' ? '' : " and cu.usaha_id={$uid}"; $kondisi .= $cuid == '' ? '' : " and cu.id={$cuid}"; if ($rpt != 'skpdj_30') { $rpt = $this->module . '/' . $rpt; $params = array("kondisi" => $kondisi, "usahaid" => $uid, "tglcetak" => date('Y-m-d'), "tahun" => pad_tahun_anggaran()); } else { $rpt = $rpt; $sptpd = $this->load->model('sptpd_model')->get($sptid); $cu = $this->load->model('objek_pajak_model')->get($sptpd->customer_usaha_id); $report = $this->load->model('report_model')->get_report($cu->usaha_id, $sptpd->type_id); $rpt = $report->sknm; $params = array('spt_id' => intval($sptid)); } $params = array_merge($params, array("daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama(), "logo" => base_url('assets/img/logorpt__.jpg'), "ttd" => base_url('assets/img/ttd.gif'))); $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, false); }
function cetak() { $type = $this->uri->segment(4); $qs = urldecode($_SERVER['QUERY_STRING']); parse_str($qs, $qs_data); $params = array(); // foreach ($qs_data as $key => $val) // $params[$key] = $val; $kondisi = $this->input->get('kondisi'); if (!empty($kondisi)) { $kondisi = 'and s.type_id=' . $this->input->get('kondisi'); } $rpt = $this->input->get('rpt'); $ignore_html_pg = TRUE; switch ($rpt) { case 'trm_tgl': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => ''); break; case 'trm_tgl_jenis': $usaha_id = $this->input->get('usaha_id'); $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'usaha_id' => (int) $usaha_id); break; case 'trm_rekap': $usaha_id = $this->input->get('usaha_id'); $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'usaha_id' => (int) $usaha_id); break; case 'trm_piutang': $usaha_id = $this->input->get('usaha_id'); $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'usaha_id' => (int) $usaha_id); break; case 'trm_masa': case 'trm_masa_jenis': case 'trm_tgl_reklame': case 'trm_tgl_air': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi); break; case 'trm_blm_dialokasikan': case 'trm_sdh_dialokasikan': $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir')))); break; case 'lra_harian': $kondisi = $this->input->get('kondisi'); $type_rpt = $kondisi; $kondisi = $kondisi == 'perobjek' ? ' and r.levelid=3 ' : ''; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tanggal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'kondisi' => $kondisi, 'type_rpt' => $type_rpt); break; case 'lra_mingguan': $kondisi = $this->input->get('kondisi'); $type_rpt = $kondisi; $kondisi = $kondisi == 'perobjek' ? ' and r.levelid=3 ' : ''; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'minggu' => $this->input->get('minggu'), 'kondisi' => $kondisi, 'type_rpt' => $type_rpt); break; case 'lra_bulanan': $kondisi = $this->input->get('kondisi'); $type_rpt = $kondisi; $kondisi = $kondisi == 'perobjek' ? ' and r.levelid=3 ' : ''; $params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => $this->input->get('bulan'), 'kondisi' => $kondisi, 'type_rpt' => $type_rpt); break; } $tambahan = array("tahun" => pad_tahun_anggaran(), "daerah" => pad_pemda_daerah(), "dinas" => pad_pemda_nama()); $params = array_merge($params, $tambahan); $ignore_html_pg = FALSE; //paging aja semua $rpt = 'penerimaan/' . $rpt; // var_dump($params); $jasper = $this->load->library('Jasper'); echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg); }