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
