function grid2()
{
$this->load->library('Datatables');
$this->datatables->select('a.id, get_rekening(r.kode) as kode, tahun, status_anggaran, target, bulan7,
bulan8, bulan9, bulan10, bulan11, bulan12, jumlah', false);
$this->datatables->from('pad_anggaran a');
$this->datatables->join('pad_rekening r', 'a.rekening_id = r.id');
$this->datatables->where('a.tahun', pad_tahun_anggaran());
$this->datatables->rupiah_column('3,4,5,6,7,8,9,10');
echo $this->datatables->generate();
}
public function proses_validasi()
{
$this->load_auth();
if (!$this->module_auth->create) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_create);
redirect(active_module_url($this->controller));
}
$spt_id = $this->uri->segment(4);
$sptpd = $this->sptpd_model->get($spt_id);
$sspd = $this->sspd_model->get_by_spt($spt_id);
if ($spt_id && $sptpd && $sspd) {
$terimano = $this->penerimaan_model->max_terimano(pad_tahun_anggaran());
if ($sspd->hitung_bunga == 1 && $sspd->bunga > 0) {
$jmlterima = (double) $sptpd->pajak_terhutang + (double) $sspd->bunga;
} else {
$jmlterima = (double) $sptpd->pajak_terhutang;
}
$update_data = array('is_validated' => 1, 'updated' => date('Y-m-d'), 'update_uid' => sipkd_user_id());
$this->sspd_model->update_by_spt($spt_id, $update_data);
// terima
$update_data = array('tahun' => pad_tahun_anggaran(), 'terimano' => $terimano, 'terimatgl' => date('Y-m-d'), 'jmlterima' => $jmlterima, 'customer_id' => $sptpd->customer_id, 'npwpd' => $this->load->model('subjek_pajak_model')->get_npwpd($sptpd->customer_id), 'nobukti' => $sspd->sspdno, 'notes' => 'Posting dari SSPD (Validasi)', 'enabled' => 1, 'created' => date('Y-m-d'), 'create_uid' => sipkd_user_id());
$new_id = $this->penerimaan_model->save($update_data);
// terima line - rek pajak
$update_data = array('terima_id' => $new_id, 'spt_id' => $spt_id, 'rekening_id' => $sptpd->rekening_id, 'pajak_id' => $sptpd->pajak_id, 'amount' => $sptpd->pajak_terhutang, 'enabled' => 1, 'created' => date('Y-m-d', strtotime($sspd->sspdtgl)), 'create_uid' => sipkd_user_id());
$this->penerimaan_model->save2($update_data);
// terima line - rek denda (bunga)
if ($sspd->hitung_bunga == 1 && $sspd->bunga > 0) {
$update_data = array('terima_id' => $new_id, 'spt_id' => $spt_id, 'rekening_id' => $this->load->model('pajak_model')->get_rek_denda($sptpd->pajak_id), 'pajak_id' => $sptpd->pajak_id, 'amount' => $sspd->bunga, 'enabled' => 1, 'created' => date('Y-m-d', strtotime($sspd->sspdtgl)), 'create_uid' => sipkd_user_id());
$this->penerimaan_model->save2($update_data);
}
echo "ok";
} else {
echo "hmm";
}
}
<div class="form-group">
<label class="control-label col-sm-2" for="rekening_id">Rekening</label>
<div class="col-sm-4">
<?php
echo $select_rekening;
?>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="tahun">Tahun Anggaran</label>
<div class="col-sm-2">
<input class="form-control" type="text" maxlength="4" name="tahun" id="tahun" value="<?php
if ($dt['tahun'] != '') {
echo $dt['tahun'];
} else {
echo pad_tahun_anggaran();
}
?>
" style="text-align:right;" required />
</div>
</div>
<div class="form-group hidden">
<label class="control-label col-sm-2" for="status_anggaran">Status Anggaran</label>
<div class="col-sm-3">
<input class="form-control" type="text" name="status_anggaranx" id="status_anggaranx" style="text-align:right;" />
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-2" for="target">Status Anggaran</label>
<div class="col-sm-3">
<select class="form-control" name="status_anggaran" id="status_anggaran">
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);
}
public function add()
{
if (!$this->module_auth->create) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_create);
redirect(active_module_url('sptpd'));
}
$p_usaha_id = $this->uri->segment(4);
$post_data = $this->fpost($p_usaha_id);
$data['current'] = 'pendataan';
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url('sptpd/add/' . $p_usaha_id);
$data['dt'] = $post_data;
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
$sptno = $this->sptpd_model->generate_sptno(pad_tahun_anggaran());
$update_data = array('sptno' => $sptno, 'customer_id' => $input_post['customer_id'], 'customer_usaha_id' => $input_post['customer_usaha_id'], 'pajak_id' => $input_post['pajak_id'], 'tahun' => $input_post['tahun'], 'terimatgl' => date('Y-m-d', strtotime($input_post['terimatgl'])), 'type_id' => $input_post['type_id'], 'so' => $input_post['so'], 'jatuhtempotgl' => date('Y-m-d', strtotime($input_post['jatuhtempotgl'])), 'masadari' => date('Y-m-d', strtotime($input_post['masadari'])), 'masasd' => date('Y-m-d', strtotime($input_post['masasd'])), 'minimal_omset' => $input_post['minimal_omset'], 'dasar' => $input_post['dasar'], 'tarif' => $input_post['tarif'], 'denda' => $input_post['denda'], 'bunga' => $input_post['bunga'], 'setoran' => $input_post['setoran'], 'kenaikan' => $input_post['kenaikan'], 'kompensasi' => $input_post['kompensasi'], 'lain2' => $input_post['lain2'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'created' => date('Y-m-d'), 'create_uid' => sipkd_user_id(), 'terimanip' => sipkd_user_id(), 'unit_id' => pad_pemda_unitid(), 'enabled' => 1, 'satuan' => NULL);
$reklame_data = array();
if ($p_usaha_id == pad_reklame_id()) {
$input_post = $post_data;
$reklame_data = array('r_nsrno' => $input_post['r_nsrno'], 'r_nsrtgl' => empty($input_post['r_nsrtgl']) ? NULL : date('Y-m-d', strtotime($input_post['r_nsrtgl'])), 'r_tarifid' => $input_post['r_tarifid'], 'r_kontrak' => $input_post['r_kontrak'], 'r_lama' => $input_post['r_lama'], 'r_jalanklas_id' => $input_post['r_jalanklas_id'], 'r_jalan_id' => $input_post['r_jalan_id'], 'r_lokasi' => $input_post['r_lokasi'], 'r_judul' => $input_post['r_judul'], 'r_panjang' => $input_post['r_panjang'], 'r_lebar' => $input_post['r_lebar'], 'r_muka' => $input_post['r_muka'], 'r_banyak' => $input_post['r_banyak'], 'r_luas' => $input_post['r_luas'], 'r_lokasi_id' => $input_post['r_lokasi_id'], 'r_calculated' => $input_post['r_calculated']);
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
$input_post = $post_data;
$air_tanah_data = array('air_manfaat_id' => $input_post['air_manfaat_id'], 'air_zona_id' => $input_post['air_zona_id'], 'meteran_awal' => $input_post['meteran_awal'], 'meteran_akhir' => $input_post['meteran_akhir'], 'volume' => $input_post['volume'], 'satuan' => 'M3');
}
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data);
$this->sptpd_model->save($update_data);
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url('sptpd'));
}
$data['dt'] = $post_data;
$get = (object) $post_data;
$data['dt']['tahun'] = pad_tahun_anggaran();
$data['dt']['terimatgl'] = date('d-m-Y');
$data['dt']['dasar'] = 0;
$data['dt']['tarif'] = 0;
$data['dt']['denda'] = 0;
$data['dt']['bunga'] = 0;
$data['dt']['setoran'] = 0;
$data['dt']['lain2'] = 0;
$data['dt']['kenaikan'] = 0;
$data['dt']['kompensasi'] = 0;
$options = array();
$js = 'id="usaha_id" class="input-xlarge"';
$data['select_usaha'] = form_dropdown('usaha_id', $options, null, $js);
$js = 'id="pajak_id" class="input-xxlarge"';
$data['select_pajak'] = form_dropdown('pajak_id', $options, null, $js);
$select_data = $this->load->model('sptpd_type_model')->get_select();
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->typenm;
}
$js = 'id="type_id" class="input-small" onChange="void(0);"';
$type_id = $p_usaha_id == pad_reklame_id() || $p_usaha_id == pad_air_tanah_id() ? 1 : $get->type_id;
$data['select_sptpd_type'] = form_dropdown('type_id', $options, $type_id, $js);
$data['dt']['rekeningkd'] = '';
$data['dt']['jatuhtempo'] = '';
if ($p_usaha_id == pad_reklame_id()) {
$select_data = $this->load->model('jalan_kelas_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->kelasnm;
}
$js = 'id="r_jalanklas_id" class="input-xlarge" required ';
$data['select_jalan_kelas'] = form_dropdown('r_jalanklas_id', $options, $get->r_jalanklas_id, $js);
$select_data = $this->load->model('jalan_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
$js = 'id="r_jalan_id" class="input-xlarge" required ';
$data['select_jalan'] = form_dropdown('r_jalan_id', $options, $get->r_jalan_id, $js);
$select_data = $this->load->model('kecamatan_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->kecamatannm;
}
$js = 'id="r_lokasi_id" class="input-medium" required ';
$data['select_lokasi'] = form_dropdown('r_lokasi_id', $options, $get->r_lokasi_id, $js);
$options = array(1 => 'Tidak ada', 2 => 'Kenaikan 25%', 3 => 'Pengurangan 25%', 4 => 'Kenaikan 25% & Pengurangan 25%');
$js = 'id="r_tarifid" class="input-large" required ';
$data['select_tarif'] = form_dropdown('r_tarifid', $options, $get->r_tarifid, $js);
$this->load->view('vsptpd_form_reklame', $data);
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
$select_data = $this->load->model('air_zona_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
$js = 'id="air_zona_id" class="input-medium" required ';
$data['select_zona'] = form_dropdown('air_zona_id', $options, $get->air_zona_id, $js);
$select_data = $this->load->model('air_manfaat_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
$js = 'id="air_manfaat_id" class="input-medium" required ';
$data['select_manfaat'] = form_dropdown('air_manfaat_id', $options, $get->air_manfaat_id, $js);
$this->load->view('vsptpd_form_at', $data);
} else {
$this->load->view('vsptpd_form', $data);
}
}
}
public function proses_skpd()
{
$this->load_auth();
if (!$this->module_auth->create) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_create);
redirect(active_module_url($this->controller));
}
$usaha_id = $this->uri->segment(4);
$spt_id = $this->uri->segment(5);
$tgl_proses = $this->uri->segment(6);
if ($usaha_id && $spt_id && ($sptpd = $this->sptpd_model->get($spt_id))) {
$kohirno = $this->skpd_model->generate_kohirno(pad_tahun_anggaran(), $usaha_id);
$update_data = array('spt_id' => $spt_id, 'kohirno' => $kohirno, 'usaha_id' => $usaha_id, 'tahun' => pad_tahun_anggaran(), 'kohirtgl' => date('Y-m-d', strtotime($tgl_proses)), 'enabled' => 1, 'create_date' => date('Y-m-d'), 'create_uid' => sipkd_user_id());
$this->skpd_model->save($update_data);
//update jth tempo
// $tgl_proses = new DateTime(Date('Y-m-d'));
$tgl_proses = new DateTime(Date('Y-m-d', strtotime($tgl_proses)));
$tgl_jtempo = new DateTime(Date('Y-m-d', strtotime($sptpd->jatuhtempotgl)));
$masadari = new DateTime(Date('Y-m-d', strtotime($sptpd->masadari)));
$new_tgl_jtempo = $tgl_jtempo;
$jth_tempo = $this->load->model('pajak_model')->get_jatuhtempo($usaha_id);
if ($jth_tempo > 0) {
$new_tgl_jtempo = $tgl_proses->modify("+30 day");
} else {
$xbln = 2;
$new_tgl_jtempo = $tgl_proses->modify("+{$xbln} month");
$new_tgl_jtempo = $new_tgl_jtempo->modify("-1 day");
}
//update jattuh tempo lagi u/ reklame
$rek = $this->load->model('rekening_model')->get($sptpd->rekening_id);
$insiden = $rek->insidentil;
if (substr($rek->rekeningkd, 0, 5) == '41104') {
if ($insiden == 1) {
// $new_tgl_jtempo = $masadari;
// berdasarkan tgl penetapan cc. om sisco
$tgl_proses = new DateTime(Date('Y-m-d'));
$new_tgl_jtempo = $tgl_proses;
} else {
$new_tgl_jtempo = $masadari->modify("+30 day");
}
//lagi
//28-08-2014 BERUBAH LAGI !! ANJRIT
/*
if($sptpd->r_status=='Pasang Baru') {
$tgl_proses = new DateTime(Date('Y-m-d'));
$new_tgl_jtempo = $tgl_proses->modify("+30 day");
}
*/
}
if (substr($rek->rekeningkd, 0, 5) == '41108') {
// dimanualkan saja, karena hitung hari kerja
/*
$tgl_proses = new DateTime(Date('Y-m-d'));
$new_tgl_jtempo = $tgl_proses->modify("+20 day");
*/
$tgl_jtempo = new DateTime(Date('Y-m-d', strtotime($sptpd->jatuhtempotgl)));
$new_tgl_jtempo = $tgl_jtempo;
}
$this->sptpd_model->update($spt_id, array('jatuhtempotgl' => date_format($new_tgl_jtempo, 'Y-m-d')));
echo "ok";
} else {
echo "hmm";
}
}
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);
$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);
$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);
}
public function post()
{
if (!$this->module_auth->create) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_create);
redirect(active_module_url('penerimaan'));
}
$spt_id = $this->uri->segment(4);
$terima_id = $this->uri->segment(5);
$sptpd = $this->sptpd_model->get($spt_id);
if ($terima_id && $spt_id && $sptpd) {
// hitung bunga (telat bayar)
$tgl_proses = new DateTime(Date('Y-m-d'));
$tgl_jtempo = new DateTime(Date('Y-m-d', strtotime($sptpd->jatuhtempotgl)));
$diff = $tgl_proses->diff($tgl_jtempo);
$nbln = $diff->format('%y') * 12 + $diff->format('%m');
$nbln = $tgl_proses <= $tgl_jtempo ? 0 : $nbln;
$nbln = $nbln > 24 ? 24 : $nbln;
$pajak = $sptpd->pajak_terhutang;
$bunga = (double) $pajak * (int) $nbln * (double) pad_bunga() + (double) $sptpd->bunga;
// end hitung bunga
$terimano = $this->penerimaan_model->max_terimano(pad_tahun_anggaran());
$jmlterima = (double) $sptpd->pajak_terhutang + (double) $bunga;
// terima line - rek pajak
$update_data = array('terima_id' => $terima_id, 'spt_id' => $spt_id, 'rekening_id' => $sptpd->rekening_id, 'pajak_id' => $sptpd->pajak_id, 'amount' => $sptpd->pajak_terhutang, 'enabled' => 1, 'created' => date('Y-m-d'), 'create_uid' => sipkd_user_id());
$this->penerimaan_model->save2($update_data);
// terima line - rek denda (bunga)
if ($bunga > 0) {
$update_data = array('terima_id' => $terima_id, 'spt_id' => $spt_id, 'rekening_id' => $this->load->model('pajak_model')->get_rek_denda($sptpd->pajak_id), 'pajak_id' => $sptpd->pajak_id, 'amount' => $bunga, 'enabled' => 1, 'created' => date('Y-m-d'), 'create_uid' => sipkd_user_id());
$this->penerimaan_model->save2($update_data);
}
// update setoran
$terima_id = $this->penerimaan_model->get_terima_id_by_spt($spt_id);
$new_setoran = $this->penerimaan_model->update_setoran($terima_id);
echo $new_setoran;
} else {
echo "hmm";
}
}
public function edit()
{
if (!$this->module_auth->update) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url('pemda'));
}
$data['current'] = 'referensi';
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("pemda/update");
if ($get = $this->pemda_model->get_one()) {
$data['dt']['id'] = empty($get->id) ? NULL : $get->id;
$data['dt']['ppkd_id'] = empty($get->ppkd_id) ? NULL : $get->ppkd_id;
$data['dt']['pemda_nama'] = empty($get->pemda_nama) ? NULL : $get->pemda_nama;
$data['dt']['pemda_nama_singkat'] = empty($get->pemda_nama_singkat) ? NULL : $get->pemda_nama_singkat;
$data['dt']['type'] = empty($get->type) ? NULL : $get->type;
$data['dt']['kepala_nama'] = empty($get->kepala_nama) ? NULL : $get->kepala_nama;
$data['dt']['jabatan'] = empty($get->jabatan) ? NULL : $get->jabatan;
$data['dt']['alamat'] = empty($get->alamat) ? NULL : $get->alamat;
$data['dt']['ibukota'] = empty($get->ibukota) ? NULL : $get->ibukota;
$data['dt']['telp'] = empty($get->telp) ? NULL : $get->telp;
$data['dt']['tmt'] = empty($get->tmt) ? NULL : date('d-m-Y', strtotime($get->tmt));
$data['dt']['alamat_lengkap'] = empty($get->alamat_lengkap) ? NULL : $get->alamat_lengkap;
$data['dt']['daerah'] = empty($get->daerah) ? NULL : $get->daerah;
$data['dt']['fax'] = empty($get->fax) ? NULL : $get->fax;
$data['dt']['website'] = empty($get->website) ? NULL : $get->website;
$data['dt']['email'] = empty($get->email) ? NULL : $get->email;
$data['dt']['reklame_id'] = $get->reklame_id;
$data['dt']['airtanah_id'] = $get->airtanah_id;
$data['dt']['parkir_id'] = $get->parkir_id;
$data['dt']['hiburan_id'] = $get->hiburan_id;
$data['dt']['ppj_id'] = $get->ppj_id;
$data['dt']['hotel_id'] = $get->hotel_id;
$data['dt']['walet_id'] = $get->walet_id;
$data['dt']['restauran_id'] = $get->restauran_id;
$data['dt']['surat_no'] = $get->surat_no;
$data['dt']['ijin_kd'] = $get->ijin_kd;
$data['dt']['reklame_kd'] = $get->reklame_kd;
$data['dt']['airtanah_kd'] = $get->airtanah_kd;
$data['dt']['parkir_kd'] = $get->parkir_kd;
$data['dt']['hiburan_kd'] = $get->hiburan_kd;
$data['dt']['ppj_kd'] = $get->ppj_kd;
$data['dt']['hotel_kd'] = $get->hotel_kd;
$data['dt']['restauran_kd'] = $get->restauran_kd;
$data['dt']['self_dok_id'] = $get->self_dok_id;
$data['dt']['office_dok_id'] = $get->office_dok_id;
$data['dt']['tgl_spt'] = $get->tgl_spt;
$data['dt']['tgl_jatuhtempo_self'] = $get->tgl_jatuhtempo_self;
$data['dt']['spt_denda'] = $get->spt_denda;
$data['dt']['pad_bunga'] = $get->pad_bunga;
$data['dt']['thn_ang'] = pad_tahun_anggaran();
$this->load->view('vpemda_form', $data);
} else {
show_404();
}
}
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);
}
public function proses_stpd()
{
$this->load_auth();
if (!$this->module_auth->create) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_create);
redirect(active_module_url($this->controller));
}
$spt_id = $this->uri->segment(4);
$petugas_id = $this->uri->segment(5);
$pejabat_id = $this->uri->segment(6);
if ($spt_id && ($sptpd = $this->sptpd_model->get($spt_id))) {
// hitung bunga (telat bayar)
$tgl_proses = new DateTime(Date('Y-m-d'));
$tgl_jtempo = new DateTime(Date('Y-m-d', strtotime($sptpd->jatuhtempotgl)));
$new_tgl_jtempo = $tgl_jtempo;
$diff = $tgl_proses->diff($tgl_jtempo);
$nbln = $diff->format('%y') * 12 + $diff->format('%m');
$nbln = $tgl_proses <= $tgl_jtempo ? 0 : $nbln;
$nbln = $nbln > 24 ? 24 : $nbln;
$pajak = $sptpd->pajak_terhutang;
$bunga = (double) $pajak * (int) $nbln * (double) pad_bunga() + (double) $sptpd->bunga;
// end hitung bunga
$usaha_id = $this->load->model('pad_model')->sptpd_get_usaha_id($sptpd->customer_usaha_id);
$jth_tempo = $this->load->model('pajak_model')->get_jatuhtempo($usaha_id);
if ($nbln > 0) {
if ($jth_tempo > 0) {
$new_tgl_jtempo = $tgl_jtempo->modify("+{$nbln} month");
} else {
$xbln = 2 + (int) $nbln;
$new_tgl_jtempo = $tgl_jtempo->modify("+{$xbln} month");
$new_tgl_jtempo = $new_tgl_jtempo->modify("-1 day");
}
} else {
if ($jth_tempo > 0) {
$new_tgl_jtempo = $tgl_jtempo->modify("+30 day");
} else {
$xbln = 2;
$new_tgl_jtempo = $tgl_jtempo->modify("+{$xbln} month");
$new_tgl_jtempo = $new_tgl_jtempo->modify("-1 day");
}
}
while ($new_tgl_jtempo <= $tgl_proses) {
if ($jth_tempo > 0) {
$new_tgl_jtempo = $tgl_jtempo->modify("+30 day");
} else {
$xbln = 2;
$new_tgl_jtempo = $tgl_jtempo->modify("+{$xbln} month");
$new_tgl_jtempo = $new_tgl_jtempo->modify("-1 day");
}
}
$stpdno = $this->stpd_model->generate_stpdno(pad_tahun_anggaran());
$update_data = array('stpdno' => $stpdno, 'tahun' => pad_tahun_anggaran(), 'stpdtgl' => date_format($tgl_proses, 'Y-m-d'), 'jatuhtempotgl' => date_format($new_tgl_jtempo, 'Y-m-d'), 'stpdcount' => $nbln + 1, 'bunga' => $this->session->userdata('denda'), 'spt_id' => $spt_id, 'petugas_id' => $petugas_id, 'pejabat_id' => $pejabat_id, 'enabled' => 1, 'created' => date('Y-m-d h:i:s'), 'create_uid' => sipkd_user_id());
$this->stpd_model->save($update_data);
//$this->db->query("update pad_invoice set status_bayar = 3 where id=$spt_id");
//$this->db->query("update pad_invoice set status_bayar = 2 where id=$spt_id");
echo "ok";
$this->session->set_userdata('denda', 0);
} else {
echo "hmm";
$this->session->set_userdata('denda', 0);
}
}
