Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- namespace App\Controllers;
- use App\Models\VerifikasiModel;
- use App\Models\DataaxModel;
- use App\Models\BomModel;
- use App\Models\TempModel;
- use App\Models\CekModel;
- use App\Controllers\BaseController;
- class Verifikasi extends BaseController
- {
- public function __construct()
- {
- $this->verifikasi_model = new VerifikasiModel();
- $this->dataax_model = new DataaxModel();
- $this->bom_model = new BomModel();
- $this->temp_model = new TempModel();
- $this->cek_model = new CekModel();
- $this->validation = \Config\Services::validation();
- $db = \Config\Database::connect();
- }
- public function cek_ax_upload()
- {
- $product_id = $this->request->getVar('ch_item_number');
- $product_lot = $this->request->getVar('ch_lot');
- $product_side = $this->request->getVar('ch_side');
- $file_excel = $this->request->getFile('fileexcel');
- $ext = $file_excel->getClientExtension();
- if($ext == 'xls')
- {
- $render = new \PhpOffice\PhpSpreadsheet\Reader\Xls();
- }else{
- $render = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
- }
- $spreadsheet = $render->load($file_excel);
- $data = $spreadsheet->getActiveSheet()->toArray();
- foreach($data as $x => $row)
- {
- if($x == 0)
- {
- continue;
- }
- $part_code = $row[0];
- $part_name = $row[1];
- $lot_part = $row[2];
- $picking_date = $row[3];
- //cek data pada tabel 'tb_bom', apakah data excel yang akan diupload sesuai dengan data pada 'tb_bom'.?
- $CekData = $db->table('tb_bom')->getWhere(['bom_product_number' => $product_id, 'bom_part_item !=' => $part_code, 'bom_operation_number' => $product_side])->getResult();
- foreach($CekData as $key => $data)
- {
- $bom_part_item = $data->bom_part_item;
- $bom_part_name = $data->bom_part_name;
- $bom_kode_gudang = $data->bom_kode_gudang;
- }
- //jika ada data pada tabel 'tb_bom' yang tidak ada di dokumen excel akan diinsert ke tabel 'temp_hasil_cek'
- if($CekData)
- {
- $simpanData = [
- 'part_code' => $bom_part_item,
- 'part_name' => $bom_part_name,
- 'part_kode_gudang' => $bom_kode_gudang,
- 'created_by' => session()->get('user_name'),
- 'created_date' => date('Y-m-d H:i:s')
- ];
- $db->table('temp_hasil_cek')->insert($simpanData);
- }else{
- session()->setFlashdata('message', 'Data valid');
- session()->setFlashdata('alert-class', 'alert-danger toastrDefaultError');
- }
- }
- return redirect()->to('/hasil_verifikasi');
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement