public function proses($idquotationsales = null) { $setting_model = new Setting_model(); // /$transaksi_model = new Transaksi_model(); $this->orm->debug = true; $data = array(); $data['idquotationsales'] = $idquotationsales == null ? $setting_model->_getMaxId('idquotationsales', 'quotationsales') : $idquotationsales; $data['nomor'] = $this->input->post('nomor', true); $data['dibuat_oleh'] = $this->input->post('dibuat_oleh', true); $data['tanggal'] = Tanggal::sqlDate($this->input->post('tanggal', true)); $data['idpelanggan'] = $this->input->post('idpelanggan', true); $data['idrefjenispembayaran'] = $this->input->post('idrefjenispembayaran', true); $data['status'] = 'KIRIM'; $data['insertby'] = $_SESSION['user']['email']; $data['idrefstore'] = $_SESSION['user']['idrefstore']; if ($idquotationsales == null) { $data['idrefstatus'] = 1; $idquotationsales = $data['idquotationsales']; $quotation = $this->orm->quotationsales(); $ress = $quotation->insert($data); Message::_set(isset($ress['idquotationsales']) ? TRUE : FALSE, 'Proses Pemesanan Berhasil', 'Proses Pemesanan Barang Gagal'); $redirect = 'quotation/quotation/index/true/' . $idquotationsales; $this->orm->quotationsalesdetail->where('idquotationsales', $idquotationsales)->delete(); $idRefBarang = $this->input->post('idrefbarang'); $jumlahBarang = $this->input->post('jumlahbarang'); $keterangan = $this->input->post('keterangan'); $hargasatuan = $this->input->post('hargasatuan'); foreach ($idRefBarang as $key => $value) { $dataDetilBarang = array(); $dataDetilBarang['idquotationsalesdetail'] = $setting_model->_getMaxId('idquotationsalesdetail', 'quotationsalesdetail'); $dataDetilBarang['idquotationsales'] = $idquotationsales; $dataDetilBarang['idrefbarang'] = $idRefBarang[$key]; $dataDetilBarang['jumlahbarang'] = $jumlahBarang[$key]; $dataDetilBarang['keterangan'] = $keterangan[$key]; $dataDetilBarang['hargasatuan'] = $hargasatuan[$key]; $barang = $this->refbarang->findById($idRefBarang[$key]); $dataDetilBarang['namabarangtext'] = $barang[0]->namabarang . " - " . $barang[0]->alias . "Range Harga : {$barang[0]->harga_min} - {$barang[0]->harga_min}"; if ($dataDetilBarang['idrefbarang'] != 0) { $result = $this->orm->quotationsalesdetail->insert($dataDetilBarang); } } } else { //$data['idrefstatus'] = 2; //$quotation = $this->orm->quotationsales->where('idquotationsales', $idquotationsales); //$ress = $quotation->update($data); //$dataQuotation = $this->quotationsales->findById($idquotationsales); $dataUpdateQuotation = array('idrefstatus' => 2); $this->quotationsales->update($idquotationsales, $dataUpdateQuotation); Message::_set($idquotationsales != null ? TRUE : FALSE, 'Edit Data Quotation Berhasil', 'Edit Data Quotation Gagal'); $redirect = 'quotation/quotation'; } //$transaksi_model->batalBarangKeluar($idquotationsales); // proses barang keluar dipindah ke Purchase redirect($redirect); }
public function proses($idpengadaan = null) { Account::_valLogin(); $setting_model = new Setting_model(); $transaksi_model = new Transaksi_model(); $this->orm->debug = true; $data = array(); $data['idpengadaan'] = $idpengadaan == null ? $setting_model->_getMaxId('idpengadaan', 'pengadaan') : $idpengadaan; $data['nomorpengadaan'] = $this->input->post('nomorpengadaan', true); $data['tanggalpengadaan'] = Tanggal::sqlDate($this->input->post('tanggalpengadaan', true)); $data['nomorreff'] = $this->input->post('nomorreff', true); $data['idsupplier'] = $this->input->post('idsupplier', true); $data['insertby'] = $_SESSION['user']['email']; $data['idrefstore'] = $_SESSION['user']['idrefstore']; $data['flag_app'] = "WEB"; if ($idpengadaan == null) { $idpengadaan = $data['idpengadaan']; $pengadaan = $this->orm->pengadaan(); $ress = $pengadaan->insert($data); Message::_set(isset($ress['idpengadaan']) ? TRUE : FALSE, 'Tambah Data Barang Berhasil', 'Tambah Data Barang Gagal'); $redirect = 'transaksi/pengadaan'; } else { $pengadaan = $this->orm->pengadaan->where('idpengadaan', $idpengadaan); $ress = $pengadaan->update($data); Message::_set($idpengadaan != null ? TRUE : FALSE, 'Edit Data Barang Berhasil', 'Edit Data Barang Gagal'); $redirect = 'transaksi/pengadaan/edit/' . $idpengadaan; } $this->orm->pengadaandetail->where('idpengadaan', $idpengadaan)->delete(); $this->orm->transaksibarang->where('idpengadaan', $idpengadaan)->delete(); $idRefBarang = $this->input->post('idrefbarang'); $idRefGudang = $this->input->post('idrefgudang'); $jumlahBarang = $this->input->post('jumlahbarang'); $keterangan = $this->input->post('keterangan'); foreach ($idRefBarang as $key => $value) { $dataDetilBarang = array(); $dataDetilBarang['idpengadaandetail'] = $setting_model->_getMaxId('idpengadaandetail', 'pengadaandetail'); $dataDetilBarang['idpengadaan'] = $idpengadaan; $dataDetilBarang['idrefbarang'] = $idRefBarang[$key]; $dataDetilBarang['idrefgudang'] = $idRefGudang[$key]; $dataDetilBarang['jumlahbarang'] = $jumlahBarang[$key]; $dataDetilBarang['keterangan'] = $keterangan[$key]; if ($dataDetilBarang['idrefbarang'] != 0) { $result = $this->orm->pengadaandetail->insert($dataDetilBarang); $idPengadaanDetail = $result['idpengadaandetail']; $dataTransaksiBarang = array(); $dataTransaksiBarang['idtransaksibarang'] = $setting_model->_getMaxId('idtransaksibarang', 'transaksibarang'); $dataTransaksiBarang['transaksi'] = 'TERIMA'; $dataTransaksiBarang['tanggaltransaksi'] = Tanggal::sqlDate($this->input->post('tanggalpengadaan')); $dataTransaksiBarang['idpengadaandetail'] = $idPengadaanDetail; $dataTransaksiBarang['iddeliveryorderdetail'] = 0; $dataTransaksiBarang['idpengadaan'] = $idpengadaan; $this->orm->transaksibarang->insert($dataTransaksiBarang); } } $transaksi_model->proccessBarangMasuk($idpengadaan); redirect($redirect); }
public function proses($idpackage = null) { $setting_model = new Setting_model(); $data = array(); $data['idpackage'] = $idpackage == null ? $setting_model->_getId('package') : $idpackage; $data['namapackage'] = $this->input->post('namapackage', true); $data['keterangan'] = $this->input->post('keterangan', true); $data['idrefstore'] = $_SESSION['user']['idrefstore']; if ($idpackage == null) { $package = $this->orm->package(); $ress = $package->insert($data); $idpackage = $ress['idpackage']; Message::_set(isset($ress['idpackage']) ? TRUE : FALSE, 'Tambah Data Package Berhasil', 'Tambah Data Barang Gagal'); } else { $package = $this->orm->package->where('idpackage', $idpackage); $ress = $package->update($data); Message::_set($idpackage != null ? TRUE : FALSE, 'Edit Data Barang Berhasil', 'Edit Data Barang Gagal'); } $this->orm->packagedetail->where('idpackage', $idpackage)->delete(); $idRefBarang = $this->input->post('idrefbarang'); $jumlahBarang = $this->input->post('jumlahbarang'); $keterangan = $this->input->post('keterangan_barang'); foreach ($idRefBarang as $key => $value) { $dataDetilBarang = array(); $dataDetilBarang['idpackagedetail'] = $setting_model->_getMaxId('idpackagedetail', 'packagedetail'); $dataDetilBarang['idpackage'] = $idpackage; $dataDetilBarang['idrefbarang'] = $idRefBarang[$key]; $dataDetilBarang['jumlahbarang'] = $jumlahBarang[$key]; $dataDetilBarang['keterangan'] = $keterangan[$key]; if ($dataDetilBarang['idrefbarang'] != 0) { $result = $this->orm->packagedetail->insert($dataDetilBarang); } } if ($idpackage == null) { redirect('package/master_package'); } else { echo '<script src=' . base_url() . 'front_assets/library/gb/greybox.js"></script>' . "<script>parent.GB_hide();</script>"; } }
public function update() { Account::_valLogin(); $setting_model = new Setting_model(); //$this->orm->debug = true; $data = array(); $data['iddeliveryorder'] = $this->input->post('iddeliveryorder', true); $data['nomordo'] = $this->input->post('nomordo', true); $data['tanggaldo'] = $this->input->post('tanggaldo', true); $data['disetujui'] = $this->input->post('disetujui', true); $data['idpelanggan'] = $this->input->post('idpelanggan', true); $data['status'] = 'PROSES'; $data['insertby'] = $_SESSION['user']['email']; $data['idrefstore'] = $_SESSION['user']['idrefstore']; $data['flag_app'] = "WEB"; $this->orm->deliveryorderdetail->where('iddeliveryorder', $data['iddeliveryorder'])->delete(); $this->orm->deliveryorder->where('iddeliveryorder', $data['iddeliveryorder'])->delete(); $iddeliveryorder = $data['iddeliveryorder']; $deliveryorder = $this->orm->deliveryorder(); $ress = $deliveryorder->insert($data); $idRefBarang = $this->input->post('idrefbarang'); $jumlahBarang = $this->input->post('jumlahbarang'); $keterangan = $this->input->post('keterangan'); $idpackaging = $this->input->post('idpackaging'); $expired_date = $this->input->post('expired_date', true); // if($idRefBarang){ foreach ($idRefBarang as $key => $value) { $dataDetilBarang = array(); $dataDetilBarang['iddeliveryorderdetail'] = $setting_model->_getMaxId('iddeliveryorderdetail', 'deliveryorderdetail'); $dataDetilBarang['iddeliveryorder'] = $iddeliveryorder; $dataDetilBarang['idrefbarang'] = $idRefBarang[$key]; $dataDetilBarang['idpackaging'] = $idpackaging[$key]; @($dataDetilBarang['expired_date'] = $expired_date[$key]); $dataDetilBarang['jumlahbarang'] = $jumlahBarang[$key]; $dataDetilBarang['keterangan'] = $keterangan[$key]; // if ($dataDetilBarang['idrefbarang'] != 0) { $result = $this->orm->deliveryorderdetail->insert($dataDetilBarang); $iddeliveryorderdetail = $result['iddeliveryorderdetail']; $dataTransaksiBarang = array(); $dataTransaksiBarang['idtransaksibarang'] = $setting_model->_getMaxId('idtransaksibarang', 'transaksibarang'); $dataTransaksiBarang['transaksi'] = 'KIRIM'; @($dataTransaksiBarang['tanggaltransaksi'] = $this->input->post('tanggaldo')); $dataTransaksiBarang['idpengadaanDetail'] = 0; $dataTransaksiBarang['iddeliveryorderdetail'] = $iddeliveryorderdetail; $dataTransaksiBarang['iddeliveryorder'] = $iddeliveryorder; $this->orm->transaksibarang->insert($dataTransaksiBarang); // } // } } $idPackage = $this->input->post('idpackage'); foreach ($idPackage as $key => $row) { foreach ($this->orm->packagedetail->where('idpackage', $row) as $row_detail) { $refbarang = $this->orm->refbarang->where('idrefbarang', $row_detail['idrefbarang'])->fetch(); $dataDetilBarang = array(); $dataDetilBarang['iddeliveryorderdetail'] = $setting_model->_getMaxId('iddeliveryorderdetail', 'deliveryorderdetail'); $dataDetilBarang['iddeliveryorder'] = $iddeliveryorder; $dataDetilBarang['idrefbarang'] = $refbarang['idrefbarang']; $dataDetilBarang['idpackaging'] = $refbarang['idpackaging']; $dataDetilBarang['jumlahbarang'] = $row_detail['jumlahbarang']; $dataDetilBarang['keterangan'] = $row_detail['keterangan']; if ($dataDetilBarang['idrefbarang'] != 0) { $result = $this->orm->deliveryorderdetail->insert($dataDetilBarang); $iddeliveryorderdetail = $result['iddeliveryorderdetail']; $dataTransaksiBarang = array(); $dataTransaksiBarang['idtransaksibarang'] = $setting_model->_getMaxId('idtransaksibarang', 'transaksibarang'); $dataTransaksiBarang['transaksi'] = 'KIRIM'; @($dataTransaksiBarang['tanggaltransaksi'] = $this->input->post('tanggaldo')); $dataTransaksiBarang['idpengadaanDetail'] = 0; $dataTransaksiBarang['iddeliveryorderdetail'] = $iddeliveryorderdetail; $dataTransaksiBarang['iddeliveryorder'] = $iddeliveryorder; $this->orm->transaksibarang->insert($dataTransaksiBarang); } } } echo json_encode(array('response' => 'success', 'msg' => 'Update DO Berhasil')); }
public function pengadaan($sharingproduct) { $this->load->model('transaksi/transaksi_model'); $transaksi_model = new Transaksi_model(); $setting_model = new Setting_model(); $data = array(); $data['idpengadaan'] = $setting_model->_getMaxId('idpengadaan', 'pengadaan'); $data['nomorpengadaan'] = 'SP' . $sharingproduct['idrefstore_pengirim'] . '-' . $sharingproduct['idsharingproduct']; $data['tanggalpengadaan'] = date('Y-m-d'); $data['idsupplier'] = $this->checkSupplier($sharingproduct['idrefstore_pengirim']); // function check data store pengirim di supplier $data['insertby'] = $_SESSION['user']['email']; $data['idrefstore'] = $sharingproduct['idrefstore_pengirim']; $data['flag_app'] = "WEB"; $idpengadaan = $data['idpengadaan']; $pengadaan = $this->orm->pengadaan(); $ress = $pengadaan->insert($data); $this->orm->pengadaandetail->where('idpengadaan', $idpengadaan)->delete(); $this->orm->transaksibarang->where('idpengadaan', $idpengadaan)->delete(); $dataDetilBarang = array(); $dataDetilBarang['idpengadaandetail'] = $setting_model->_getMaxId('idpengadaandetail', 'pengadaandetail'); $dataDetilBarang['idpengadaan'] = $idpengadaan; $dataDetilBarang['idrefbarang'] = $sharingproduct['idrefbarang']; $dataDetilBarang['jumlahbarang'] = $sharingproduct['jumlah_barang']; if ($dataDetilBarang['idrefbarang'] != 0) { $result = $this->orm->pengadaandetail->insert($dataDetilBarang); $idPengadaanDetail = $result['idpengadaandetail']; $dataTransaksiBarang = array(); $dataTransaksiBarang['idtransaksibarang'] = $setting_model->_getMaxId('idtransaksibarang', 'transaksibarang'); $dataTransaksiBarang['transaksi'] = 'TERIMA'; $dataTransaksiBarang['tanggaltransaksi'] = date('Y-m-d'); $dataTransaksiBarang['idpengadaandetail'] = $idPengadaanDetail; $dataTransaksiBarang['iddeliveryorderdetail'] = 0; $dataTransaksiBarang['idpengadaan'] = $idpengadaan; $this->orm->transaksibarang->insert($dataTransaksiBarang); } $transaksi_model->proccessBarangMasuk($idpengadaan); }