public function add()
{
$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));
}
$this->session->set_userdata('mode', 'add');
// cek apakah wp memiliki jenis pajak ini -> $this->uri->segment(4)
if (wp_login()) {
$model = $this->load->model('pad_model');
if (!$model->check_cu(wp_id(), $this->uri->segment(4))) {
$this->session->set_flashdata('msg_error', 'Anda tidak memiliki hak akses menambah data untuk jenis pajak ini.');
redirect(active_module_url());
}
}
$p_usaha_id = $this->uri->segment(4);
$p_type_id = $this->uri->segment(5);
$p_id = $this->uri->segment(6);
$p_usaha_id = $this->uri->segment(4);
$post_data = $this->fpost($p_usaha_id);
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/add/{$p_usaha_id}");
$data['dt'] = $post_data;
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
$p_usaha_id = empty($p_usaha_id) ? $this->input->post('usaha_id') : $p_usaha_id;
//kalo kosong doang (selain rek-air)
// $sptno = $this->sptpd_model->generate_sptno(pad_tahun_anggaran());
$sptno = $this->sptpd_model->generate_sptno(date('Y', strtotime($input_post['terimatgl'])), date('m', strtotime($input_post['terimatgl'])));
//cek nama wp - kalo beda bikin baru
$wp_data = $this->load->model('subjek_pajak_model')->get($input_post['customer_id']);
$wp_nama = $wp_data->nama;
$cid = $input_post['customer_id'];
$cuid = $input_post['customer_usaha_id'];
$update_data = array('sptno' => $sptno, 'customer_id' => $cid, 'customer_usaha_id' => $cuid, 'pajak_id' => $input_post['pajak_id'], 'tahun' => date('Y', strtotime($input_post['terimatgl'])), 'terimatgl' => date('Y-m-d', strtotime($input_post['terimatgl'])), 'bulan' => date('m', 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'], 'cara_bayar' => $input_post['cara_bayar'], 'pajak_terhutang' => $input_post['pajak'], '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, 'omset1' => $input_post['omset1'], 'omset6' => $input_post['omset6'], 'omset2' => $input_post['omset2'], 'omset7' => $input_post['omset7'], 'omset3' => $input_post['omset3'], 'omset8' => $input_post['omset8'], 'omset4' => $input_post['omset4'], 'omset9' => $input_post['omset9'], 'omset5' => $input_post['omset5'], 'omset10' => $input_post['omset10'], 'omset11' => $input_post['omset11'], 'omset16' => $input_post['omset16'], 'omset12' => $input_post['omset12'], 'omset17' => $input_post['omset17'], 'omset13' => $input_post['omset13'], 'omset18' => $input_post['omset18'], 'omset14' => $input_post['omset14'], 'omset19' => $input_post['omset19'], 'omset15' => $input_post['omset15'], 'omset20' => $input_post['omset20'], 'omset21' => $input_post['omset21'], 'omset26' => $input_post['omset26'], 'omset22' => $input_post['omset22'], 'omset27' => $input_post['omset27'], 'omset23' => $input_post['omset23'], 'omset28' => $input_post['omset28'], 'omset24' => $input_post['omset24'], 'omset29' => $input_post['omset29'], 'omset25' => $input_post['omset25'], 'omset30' => $input_post['omset30'], 'omset31' => $input_post['omset31'], 'omset_lain' => $input_post['omset32'], 'keterangan1' => $input_post['keterangan1'], 'keterangan6' => $input_post['keterangan6'], 'keterangan2' => $input_post['keterangan2'], 'keterangan7' => $input_post['keterangan7'], 'keterangan3' => $input_post['keterangan3'], 'keterangan8' => $input_post['keterangan8'], 'keterangan4' => $input_post['keterangan4'], 'keterangan9' => $input_post['keterangan9'], 'keterangan5' => $input_post['keterangan5'], 'keterangan10' => $input_post['keterangan10'], 'keterangan11' => $input_post['keterangan11'], 'keterangan16' => $input_post['keterangan16'], 'keterangan12' => $input_post['keterangan12'], 'keterangan17' => $input_post['keterangan17'], 'keterangan13' => $input_post['keterangan13'], 'keterangan18' => $input_post['keterangan18'], 'keterangan14' => $input_post['keterangan14'], 'keterangan19' => $input_post['keterangan19'], 'keterangan15' => $input_post['keterangan15'], 'keterangan20' => $input_post['keterangan20'], 'keterangan21' => $input_post['keterangan21'], 'keterangan26' => $input_post['keterangan26'], 'keterangan22' => $input_post['keterangan22'], 'keterangan27' => $input_post['keterangan27'], 'keterangan23' => $input_post['keterangan23'], 'keterangan28' => $input_post['keterangan28'], 'keterangan24' => $input_post['keterangan24'], 'keterangan29' => $input_post['keterangan29'], 'keterangan25' => $input_post['keterangan25'], 'keterangan30' => $input_post['keterangan30'], 'keterangan31' => $input_post['keterangan31'], 'keterangan_lain' => $input_post['keterangan32']);
$reklame_data = array();
if ($p_usaha_id == pad_reklame_id()) {
//
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
//
}
// data tambahan
$tambahan_data = array();
if (wp_login()) {
//
}
// Validasi Duplikasi Masa Pajak
if ($this->session->userdata("mode") == "add") {
if ($input_post['multiple'] == 0) {
$lastinput = date('Y-m-d', strtotime($input_post['masadari']));
$customer_usaha_id = $input_post['customer_usaha_id'];
$pajak_id = $input_post['pajak_id'];
$masapajak_bulan = $input_post['masapajak_bulan'];
$rekening_id = $input_post['rekening_id'];
$type_id = $input_post['type_id'];
$cekduplikat = $this->sptpd_model->is_multiple($customer_usaha_id, $pajak_id, $type_id, $rekening_id, $lastinput);
if ($cekduplikat == true) {
$this->session->set_flashdata('msg_warning', 'Pajak tersebut dengan Masa Pajak: ' . $masapajak_bulan . ' Sudah Ada, Harap Cek Data-data Sebelumnya');
redirect(active_module_url($this->controller . '/add'));
} else {
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
$spt_id = $this->sptpd_model->save($update_data);
}
} else {
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
$spt_id = $this->sptpd_model->save($update_data);
}
}
//$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
//$spt_id = $this->sptpd_model->save($update_data);
// data tambahan / detail
if (wp_login()) {
// uplod dokeumen
$this->unggah($spt_id);
}
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url($this->controller));
}
$data['dt'] = $post_data;
$get = (object) $post_data;
$data['dt']['tahun'] = pad_tahun_anggaran();
$data['dt']['terimatgl'] = date('d-m-Y');
$month_ini = new DateTime("first day of last month");
$data['dt']['masadari'] = $month_ini->format('d-m-Y');
$data['dt']['masapajak_bulan'] = $month_ini->format('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;
// data tambahan
$options = array();
$js = 'id="customer_usaha_id" class="input-xlarge" ';
$data['select_usaha'] = form_dropdown('customer_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();
if ($select_data) {
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']['kode'] = '';
$data['dt']['jatuhtempo'] = '';
$data['dt']['multiple'] = '';
$data['dt']['files'] = array();
if ($p_usaha_id == pad_reklame_id()) {
//
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
//
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
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 add()
{
$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));
}
// cek apakah wp memiliki jenis pajak ini -> $this->uri->segment(4)
if (wp_login()) {
$model = $this->load->model('pad_model');
if (!$model->check_cu(wp_id(), $this->uri->segment(4))) {
$this->session->set_flashdata('msg_error', 'Anda tidak memiliki hak akses menambah data untuk jenis pajak ini.');
redirect(active_module_url());
}
}
$p_usaha_id = $this->uri->segment(4);
$post_data = $this->fpost($p_usaha_id);
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/add/{$p_usaha_id}");
$data['dt'] = $post_data;
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
$p_usaha_id = empty($p_usaha_id) ? $this->input->post('usaha_id') : $p_usaha_id;
//kalo kosong doang (selain rek-air)
$sptno = $this->sptpd_model->generate_sptno(pad_tahun_anggaran());
//cek nama wp - kalo beda bikin baru
$wp_data = $this->load->model('subjek_pajak_model')->get($input_post['customer_id']);
$wp_nama = $wp_data->customernm;
$cid = $input_post['customer_id'];
$cuid = $input_post['customer_usaha_id'];
$update_data = array('sptno' => $sptno, 'customer_id' => $cid, 'customer_usaha_id' => $cuid, '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'])), 'minomset' => $input_post['minomset'], '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'], 'pajak_terhutang' => $input_post['pajak'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'create_date' => 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()) {
//
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
//
}
// data tambahan
$tambahan_data = array();
if (wp_login()) {
//
}
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
$spt_id = $this->sptpd_model->save($update_data);
// data tambahan / detail
if (wp_login()) {
// uplod dokeumen
$this->unggah($spt_id);
}
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url($this->controller));
}
$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;
// data tambahan
$options = array();
$js = 'id="customer_usaha_id" class="input-xlarge" ';
$data['select_usaha'] = form_dropdown('customer_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();
if ($select_data) {
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'] = '';
$data['dt']['files'] = array();
if ($p_usaha_id == pad_reklame_id()) {
//
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
//
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
public function add()
{
$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));
}
// cek apakah wp memiliki jenis pajak ini -> $this->uri->segment(4)
if (wp_login()) {
$model = $this->load->model('pad_model');
if (!$model->check_cu(wp_id(), $this->uri->segment(4))) {
$this->session->set_flashdata('msg_error', 'Anda tidak memiliki hak akses menambah data untuk jenis pajak ini.');
redirect(active_module_url());
}
}
$p_usaha_id = $this->uri->segment(4);
$post_data = $this->fpost($p_usaha_id);
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/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());
$sptno = $this->sptpd_model->generate_sptno(date('Y', strtotime($input_post['terimatgl'])));
//untuk spanduk dan semuaaaaaaaaaaaaa
$wp_data = $this->load->model('subjek_pajak_model')->get($input_post['customer_id']);
$wp_nama = $wp_data->nama;
if ($wp_nama != $input_post['nama']) {
$wp_nama = $input_post['nama'];
}
$wp_alamat = $wp_data->alamat;
/*
//cek nama wp - kalo beda bikin baru
if($wp_nama != $input_post['nama']) {
$ret = $this->load->model('subjek_pajak_model')->duplicate_wp(
$cid,
$cuid,
$wp_data->rp,
$wp_data->pb,
$wp_data->kecamatan_id,
$wp_data->kelurahan_id,
$input_post['nama']
);
$cid = $ret->cid;
$cuid = $ret->cuid;
}
*/
$cid = $input_post['customer_id'];
$cuid = $input_post['customer_usaha_id'];
$update_data = array('sptno' => $sptno, 'customer_id' => $cid, 'customer_usaha_id' => $cuid, 'pajak_id' => $input_post['pajak_id'], 'tahun' => date('Y', strtotime($input_post['terimatgl'])), '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'])), 'minomset' => $input_post['minomset'], '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'], 'pajak_terhutang' => $input_post['pajak'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'create_date' => 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'], 'r_nsr_id' => $input_post['r_nsr_id'], 'r_lokasi_pasang_id' => $input_post['r_lokasi_pasang_id'], 'r_lokasi_pasang_val' => $input_post['r_lokasi_pasang_val'], 'r_jalanklas_val' => $input_post['r_jalanklas_val'], 'r_sudut_pandang_id' => $input_post['r_sudut_pandang_id'], 'r_sudut_pandang_val' => $input_post['r_sudut_pandang_val'], 'r_tinggi' => $input_post['r_tinggi'], 'r_njop' => $input_post['r_njop'], 'r_status' => $input_post['r_status'], 'r_nama' => $wp_nama, 'r_alamat' => $wp_alamat);
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
$input_post = $post_data;
$air_tanah_data = array('volume' => $input_post['volume'], 'satuan' => 'M3');
}
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data);
$spt_id = $this->sptpd_model->save($update_data);
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url($this->controller));
}
$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="customer_usaha_id" class="input-xlarge" ';
$data['select_usaha'] = form_dropdown('customer_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();
if ($select_data) {
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() ? pad_dok_office_id() : $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_klas_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->kelasnm;
}
}
$js = 'id="r_jalanklas_id" class="input-xlarge" required ';
$data['select_jalan_klas'] = form_dropdown('r_jalanklas_id', $options, $get->r_jalanklas_id, $js);
$select_data = $this->load->model('jalan_model')->get_select();
$options = array();
if ($select_data) {
$options[] = "# KOSONG #";
foreach ($select_data as $row) {
$options[$row->id] = $row->jalannm;
}
}
$js = 'id="r_jalan_id" class="input-large combobox" ';
$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();
if($select_data) {
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 => 'Produk Rokok +25%', 3 => 'Reklame Pendidikan -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);
//-new
$options = array('Pasang Baru' => 'Pasang Baru', 'Perpanjangan' => 'Perpanjangan');
$js = 'id="r_status" class="input-large" required ';
$data['select_status'] = form_dropdown('r_status', $options, $get->r_status, $js);
$select_data = $this->load->model('reklame_nilai_strategis_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nsrnm;
}
}
$js = 'id="r_nsr_id" class="input-xlarge" required ';
$data['select_nsr'] = form_dropdown('r_nsr_id', $options, $get->r_nsr_id, $js);
$select_data = $this->load->model('rek_lokasi_pasang_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->lokasinm;
}
}
$js = 'id="r_lokasi_pasang_id" class="input-xlarge" required ';
$data['select_lokasi_pasang'] = form_dropdown('r_lokasi_pasang_id', $options, $get->r_lokasi_pasang_id, $js);
$select_data = $this->load->model('rek_sudut_pandang_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->sudutnm;
}
}
$js = 'id="r_sudut_pandang_id" class="input-xlarge" required ';
$data['select_sudut_pandang'] = form_dropdown('r_sudut_pandang_id', $options, $get->r_sudut_pandang_id, $js);
//-end-new
if (!wp_login()) {
$this->load->view('vsptpd_form_reklame', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/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();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->zonanm;
}
}
$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();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->manfaatnm;
}
}
$js = 'id="air_manfaat_id" class="input-medium" required ';
$data['select_manfaat'] = form_dropdown('air_manfaat_id', $options, $get->air_manfaat_id, $js);
if (!wp_login()) {
$this->load->view('vsptpd_form_at', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form_at', $data);
}
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
public function add()
{
$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}/index/{$p_usaha_id}"));
}
// cek apakah wp memiliki jenis pajak ini -> $this->uri->segment(4)
if (wp_login()) {
$model = $this->load->model('pad_model');
if (!$model->check_cu(wp_id(), $this->uri->segment(4))) {
$this->session->set_flashdata('msg_error', 'Anda tidak memiliki hak akses menambah data untuk jenis pajak ini.');
redirect(active_module_url());
}
}
$p_usaha_id = $this->uri->segment(4);
$post_data = $this->fpost($p_usaha_id);
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/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());
// $sptno = $this->sptpd_model->generate_sptno(date('Y', strtotime($input_post['terimatgl'])), date('m', strtotime($input_post['terimatgl'])));
$query = $this->db->query("select get_nospt({$p_usaha_id}) as nospt;");
foreach ($query->result() as $row) {
$sptno = $row->nospt;
}
//untuk spanduk dan semuaaaaaaaaaaaaa
/*
$wp_data = $this->load->model('subjek_pajak_model')->get($input_post['customer_id']);
$wp_nama = $wp_data->nama;
if($wp_nama != $input_post['nama']) $wp_nama = $input_post['nama'];
$wp_alamat = $wp_data->alamat;
*/
/*
//cek nama wp - kalo beda bikin baru
if($wp_nama != $input_post['nama']) {
$ret = $this->load->model('subjek_pajak_model')->duplicate_wp(
$cid,
$cuid,
$wp_data->rp,
$wp_data->pb,
$wp_data->kecamatan_id,
$wp_data->kelurahan_id,
$input_post['nama']
);
$cid = $ret->cid;
$cuid = $ret->cuid;
}
*/
$cid = $input_post['customer_id'];
$cuid = $input_post['customer_usaha_id'];
$update_data = array('sptno' => $sptno, 'customer_id' => $cid, 'customer_usaha_id' => $cuid, 'pajak_id' => $input_post['pajak_id'], 'tahun' => date('Y', strtotime($input_post['terimatgl'])), 'bulan' => date('m', strtotime($input_post['terimatgl'])), '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'], 'pajak_terhutang' => $input_post['pajak'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'doc_no' => $input_post['doc_no'], 'cara_bayar' => $input_post['cara_bayar'], 'usaha_id' => $p_usaha_id, 'multiple' => $input_post['multiple'], 'omset1' => $input_post['omset1'], 'omset6' => $input_post['omset6'], 'omset2' => $input_post['omset2'], 'omset7' => $input_post['omset7'], 'omset3' => $input_post['omset3'], 'omset8' => $input_post['omset8'], 'omset4' => $input_post['omset4'], 'omset9' => $input_post['omset9'], 'omset5' => $input_post['omset5'], 'omset10' => $input_post['omset10'], 'omset11' => $input_post['omset11'], 'omset16' => $input_post['omset16'], 'omset12' => $input_post['omset12'], 'omset17' => $input_post['omset17'], 'omset13' => $input_post['omset13'], 'omset18' => $input_post['omset18'], 'omset14' => $input_post['omset14'], 'omset19' => $input_post['omset19'], 'omset15' => $input_post['omset15'], 'omset20' => $input_post['omset20'], 'omset21' => $input_post['omset21'], 'omset26' => $input_post['omset26'], 'omset22' => $input_post['omset22'], 'omset27' => $input_post['omset27'], 'omset23' => $input_post['omset23'], 'omset28' => $input_post['omset28'], 'omset24' => $input_post['omset24'], 'omset29' => $input_post['omset29'], 'omset25' => $input_post['omset25'], 'omset30' => $input_post['omset30'], 'omset31' => $input_post['omset31'], 'omset_lain' => $input_post['omset32'], 'keterangan1' => $input_post['keterangan1'], 'keterangan6' => $input_post['keterangan6'], 'keterangan2' => $input_post['keterangan2'], 'keterangan7' => $input_post['keterangan7'], 'keterangan3' => $input_post['keterangan3'], 'keterangan8' => $input_post['keterangan8'], 'keterangan4' => $input_post['keterangan4'], 'keterangan9' => $input_post['keterangan9'], 'keterangan5' => $input_post['keterangan5'], 'keterangan10' => $input_post['keterangan10'], 'keterangan11' => $input_post['keterangan11'], 'keterangan16' => $input_post['keterangan16'], 'keterangan12' => $input_post['keterangan12'], 'keterangan17' => $input_post['keterangan17'], 'keterangan13' => $input_post['keterangan13'], 'keterangan18' => $input_post['keterangan18'], 'keterangan14' => $input_post['keterangan14'], 'keterangan19' => $input_post['keterangan19'], 'keterangan15' => $input_post['keterangan15'], 'keterangan20' => $input_post['keterangan20'], 'keterangan21' => $input_post['keterangan21'], 'keterangan26' => $input_post['keterangan26'], 'keterangan22' => $input_post['keterangan22'], 'keterangan27' => $input_post['keterangan27'], 'keterangan23' => $input_post['keterangan23'], 'keterangan28' => $input_post['keterangan28'], 'keterangan24' => $input_post['keterangan24'], 'keterangan29' => $input_post['keterangan29'], 'keterangan25' => $input_post['keterangan25'], 'keterangan30' => $input_post['keterangan30'], 'keterangan31' => $input_post['keterangan31'], 'keterangan_lain' => $input_post['keterangan32'], 'created' => date('Y-m-d h:i:s'), 'create_uid' => sipkd_user_id(), 'terimanip' => sipkd_user_id(), 'unit_id' => pad_pemda_unitid(), 'enabled' => 1, 'satuan' => NULL, 'notes' => $input_post['notes']);
$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_judul' => $input_post['r_judul'], 'r_calculated' => $input_post['r_calculated'], 'r_sudut_pandang_id' => $input_post['r_sudut_pandang_id'], 'r_sudut_pandang_val' => $input_post['r_sudut_pandang_val'], 'r_njop' => $input_post['r_njop'], 'r_status' => $input_post['r_status'], 'ijin_no' => $input_post['ijin_no'], 'jenis_masa' => $input_post['jenis_masa'], 'r_lokasi' => $input_post['r_lokasi'], 'no_telp' => $input_post['no_telp'], 'skpd_lama' => $input_post['skpd_old']);
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
$input_post = $post_data;
$air_tanah_data = array('volume' => $input_post['volume'], 'satuan' => 'M3');
}
if ($this->session->userdata("mode") == "add") {
if ($input_post['multiple'] == 0) {
$lastinput = date('Y-m-d', strtotime($input_post['masadari']));
$customer_usaha_id = $input_post['customer_usaha_id'];
$pajak_id = $input_post['pajak_id'];
$masapajak_bulan = $input_post['masapajak_ bulan'];
$rekening_id = $input_post['rekening_id'];
$type_id = $input_post['type_id'];
$cekduplikat = $this->sptpd_model->is_multiple($customer_usaha_id, $pajak_id, $type_id, $rekening_id, $lastinput, $this->session->userdata("mode"));
if ($cekduplikat == true) {
$this->session->set_flashdata('msg_warning', 'Pajak tersebut dengan Masa Pajak: ' . $masapajak_bulan . ' Sudah Ada, Harap Cek Data-data Sebelumnya');
redirect(active_module_url($this->controller . '/add/' . $p_usaha_id));
} else {
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data);
$spt_id = $this->sptpd_model->save($update_data);
}
} else {
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data);
$spt_id = $this->sptpd_model->save($update_data);
}
} else {
$this->session->set_flashdata('msg_warning', 'UNKNOWN MODE');
redirect(active_module_url($this->controller . '/index/' . $p_usaha_id));
}
//INITIALIZE LAST SPT PLUS SPT NO sebagai penguat data
$query = $this->db->query("select max(id) as id from pad_spt where sptno = {$sptno}");
foreach ($query->result() as $row) {
$spt_id = $row->id;
}
$create_uid = sipkd_user_id();
$created = date('Y-m-d h:i:s');
//SAVE SUMUR
if ($p_usaha_id == pad_air_tanah_id()) {
$end = $input_post['end_loop_sumur'];
for ($i = 1; $i <= $end; $i++) {
$m_sumur = 'sumur_ke' . $i;
$m_awal = 'meteran_awal' . $i;
$m_akhir = 'meteran_akhir' . $i;
$m_volume = 'volume' . $i;
$m_sipa = 'sipa_no' . $i;
$sumur = $input_post[$m_sumur];
$awal = $input_post[$m_awal];
$akhir = $input_post[$m_akhir];
$vol = $input_post[$m_volume];
$sipa_no = $input_post[$m_sipa];
$this->db->query("insert into pad_air_tanah (sumur_ke, spt_id, sipa_no, awal, akhir, volume, create_uid, created) \r\n values ({$sumur}, {$spt_id}, '{$sipa_no}', {$awal}, {$akhir}, {$vol}, {$create_uid}, '{$created}')");
}
$tarif = $input_post['tarif'];
for ($i = 1; $i <= $input_post['max_hit']; $i++) {
$volume = $input_post['hit_vol' . $i];
$hda = $input_post['hit_hda' . $i];
$jumlah = $input_post['hit_val' . $i];
$this->db->query("insert into pad_air_tanah_hit \r\n (spt_id, vol, hda, jumlah, tarif, create_uid, created) \r\n values ({$spt_id}, {$volume}, {$hda}, {$jumlah}, {$tarif}, {$create_uid}, '{$created}')");
}
}
//SAVE MEDIA REKLAME
if ($p_usaha_id == pad_reklame_id()) {
// data tambahan / detail
$dtKD = $this->input->post('dtKD');
$tambahan_data2 = array();
if (isset($dtKD)) {
$i = 1;
$dtKD = json_decode($dtKD, true);
if (count($dtKD['dtKD']) > 0) {
$rd_row = array();
foreach ($dtKD['dtKD'] as $rows) {
$rd_row = array('spt_id' => $spt_id, 'media_id' => $rows[0], 'kelas_jalan_id' => $rows[2], 'panjang' => $rows[4], 'lebar' => $rows[5], 'tinggi' => $rows[6], 'sisi' => $rows[8], 'banyak' => $rows[9], 'lama' => $rows[10], 'nsr' => pad_to_decimal($rows[11]), 'tambahan' => pad_to_decimal($rows[12]), 'alamat' => $rows[14], 'status_baliho' => $rows[16], 'jalan_id' => $rows[17], 'create_uid' => $create_uid, 'created' => $created);
$i++;
$tambahan_data2 = array_merge($tambahan_data2, array($rd_row));
}
$this->db->insert_batch('pad_spt_reklame', $tambahan_data2);
}
}
}
//update pad_spt set bulan = extract(month from terimatgl);
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url("{$this->controller}/index/{$p_usaha_id}"));
}
$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;
$month_ini = new DateTime("first day of last month");
$data['dt']['masadari'] = $month_ini->format('d-m-Y');
$data['dt']['masapajak_bulan'] = $month_ini->format('M-Y');
$options = array();
$js = 'id="customer_usaha_id" class="input-xlarge" readonly ';
$data['select_usaha'] = form_dropdown('customer_usaha_id', $options, null, $js);
$js = 'id="pajak_id" class="form-control" ';
$data['select_pajak'] = form_dropdown('pajak_id', $options, null, $js);
$select_data = $this->load->model('sptpd_type_model')->get_select();
$options = array();
if ($select_data) {
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() ? pad_dok_office_id() : $get->type_id;
$data['select_sptpd_type'] = form_dropdown('type_id', $options, $type_id, $js);
$data['dt']['kode'] = '';
$data['dt']['jatuhtempo'] = '';
if ($p_usaha_id == pad_reklame_id()) {
$select_data = $this->load->model('jalan_kelas_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
}
$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();
if ($select_data) {
$options[] = "# KOSONG #";
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
}
$js = 'id="r_jalan_id" class="input-large combobox" ';
$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();
if($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}}
$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 => 'Produk Rokok +25%');
$js = 'id="r_tarifid" class="input-large" required ';
$data['select_tarif'] = form_dropdown('r_tarifid', $options, $get->r_tarifid, $js);
//-new
$options = array('Pasang Baru' => 'Pasang Baru', 'Perpanjangan' => 'Perpanjangan');
$js = 'id="r_status" class="input-large" required ';
$data['select_status'] = form_dropdown('r_status', $options, $get->r_status, $js);
$select_data = $this->load->model('reklame_nilai_strategis_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
}
$js = 'id="r_nsr_id" class="input-xlarge" required ';
$data['select_nsr'] = form_dropdown('r_nsr_id', $options, $get->r_nsr_id, $js);
$select_data = $this->load->model('reklame_lokasi_pasang_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
}
$js = 'id="r_lokasi_pasang_id" class="input-xlarge" required ';
$data['select_lokasi_pasang'] = form_dropdown('r_lokasi_pasang_id', $options, $get->r_lokasi_pasang_id, $js);
//$select_data = $this->load->model('reklame_media_model')->get_select();
$options = array('0' => '-');
$js = 'id="r_media_id" class="input-xlarge" required ';
$data['select_media_reklame'] = form_dropdown('r_media_id', $options, '', $js);
$select_data = $this->load->model('reklame_sudut_pandang_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
}
$js = 'id="r_sudut_pandang_id" class="input-xlarge" required ';
$data['select_sudut_pandang'] = form_dropdown('r_sudut_pandang_id', $options, $get->r_sudut_pandang_id, $js);
//-end-new
if (!wp_login()) {
$this->load->view('vsptpd_form_reklame', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/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();
if ($select_data) {
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();
if ($select_data) {
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);
if (!wp_login()) {
$this->load->view('vsptpd_form_at', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form_at', $data);
}
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
