public function update() { if (!$this->session->userdata('logged_in')) { redirect('login', 'refresh'); } else { $session_data = $this->session->userdata('logged_in'); $idu = $session_data['id']; $idtbl = $this->input->post("idtabel"); $tabel = $this->mweb->getmanage_by_id($idtbl); switch ($tabel) { case 'invoice': $exclude = array('iduser', 'kdinv', 'produk', 'qty', 'price', 'disc', 'subtotal', 'total', 'amount', 'acc'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; case 'website': $exclude = array('iduser'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; case 'cus': $exclude = array('user'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; case 'user': $exclude = array('kdcapab', 'website'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; case 'brosur': $exclude = array('time', 'status', 'iduser'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; case 'quotation': $exclude = array('iduser', 'kdquo', 'produk', 'qty', 'price', 'disc', 'subtotal', 'total', 'amount', 'acc'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; case 'purchase': $exclude = array('idreq'); $stmt_list = create_statement($tabel, $exclude); $likol = explode(',', $stmt_list); break; default: $likol = $this->db->list_fields($tabel); break; } if (count($likol) > 0) { $fkol = array_shift(array_slice($likol, 0, 1)); $idnye = $this->input->post($fkol); if (($kunci = array_search($fkol, $likol)) !== false) { unset($likol[$kunci]); } foreach ($likol as $valkol) { switch ($valkol) { case 'time': $cekin = $this->input->post($valkol); if ($cekin) { $isi[] = $cekin; } else { $iniw = date('d-m-Y h:i:s'); $cekin = $iniw; $isi[] = $cekin; } break; case 'password': $cekpass = $this->input->post($valkol); if ($cekpass) { $isi[] = $cekpass; } else { $detuser = getdetuser($idnye); foreach ($detuser as $vdetu) { $pwd = $vdetu['password']; } $cekpass = $pwd; $isi[] = $cekpass; } break; case 'idimg': $idimgny = $this->input->post($valkol); $config['upload_path'] = FCPATH . 'uploads/'; $config['allowed_types'] = 'gif|jpg|png'; $this->upload->initialize($config); $this->upload->set_allowed_types('*'); $data['upload_data'] = ''; if (!$this->upload->do_upload('userfile')) { redirect(site_url('gudang/profile?tab=3&e=1'), 'refresh'); } else { $data = array('msg' => "Upload success!"); $dataimg = $this->upload->data(); $postkdb = $this->input->post('kdbarang'); $descc = 'brosur--' . getnamabrg($postkdb); $dtimg = array('idimg' => '', 'src' => $dataimg['full_path'], 'desc' => $descc); $set = $this->mweb->setimage($dtimg); if ($set) { $siu = getuserbrosur($idnye); $msgnot = array('from' => getid_design(), 'iduser' => $siu['iduser'], 'msg' => 'brosur kode barang <a href="' . site_url('gudang/slug/2/4/3/a?id=' . $siu['kdbarang'] . '&tbl=3') . '"><strong>' . $siu['kdbarang'] . '</strong></a> berhasil dibuat :)', 'time' => date('d-m-Y h:i:s')); $this->mweb->settable('notif', $msgnot); if ($tabel === 'brosur') { $this->db->where('id', $idnye)->update('brosur', array('status' => 's')); } $idimgny = $set; $isi[] = $idimgny; } } break; case 'iduser': $isi[] = $idu; break; case 'cust_telp': $intelp = $this->input->post($valkol); $idc = $this->input->post('idcus'); if (is_null($intelp) || strlen($intelp) === 0 || empty($intelp)) { $detcus = getdatacus($idc); $intelp = $detcus['telp']; } $isi[] = $intelp; break; default: $isi[] = $this->input->post($valkol); break; } } $larikdata = array_combine($likol, $isi); $cekupdate = $this->mweb->updatedata($tabel, $fkol, $idnye, $larikdata); if ($cekupdate) { switch ($tabel) { case 'purchase': $purc = $this->mweb->gettable_byid($fkol, $idnye, $tabel); if (count($purc) > 0) { foreach ($purc as $vpurc) { $lb = rtrim($vpurc['linkbeli']); $hb = rtrim($vpurc['hrg_beli']); } if (empty($lb) && $hb === '0') { $this->db->where('id', $idnye); $this->db->update('purchase', array('status' => 'p')); } else { if (strlen($lb) > 0 && $hb === '0') { $this->db->where('id', $idnye); $this->db->update('purchase', array('status' => 'w')); } else { $this->db->where('id', $idnye); $this->db->update('purchase', array('status' => 'wp')); } } redirect('gudang?m=success', 'refresh'); } else { redirect('gudang?ep=' . $idnye, 'refresh'); } break; default: redirect('gudang?m=success', 'refresh'); break; } } else { redirect('login', 'refresh'); } } } }
<?php include APPPATH . 'views/fields/idcus.php'; ?> <a href="<?php echo site_url('gudang/edit/' . $this->uri->segment(3) . '/' . $this->uri->segment(4) . '/' . $this->uri->segment(5)); ?> ">batal</a> <?php } else { ?> <?php if (isset($_GET['isi'])) { ?> <?php $idnec = htmlspecialchars($_GET['isi']); $datacuse = getdatacus($idnec); $cust_telp = $datacuse['telp']; $cust_address = $datacuse['alamat']; $namacuse = getnamacus($idnec); ?> <input type="hidden" name="idcus" value="<?php echo isset($_GET['isi']) ? htmlspecialchars($_GET['isi']) : $idcus; ?> "> <?php } else { ?> <?php $namacuse = getnamacus($idcus); ?> <?php