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);
}
