/** * Submit excel file to database. * * @return Response */ public function upload() { $all = Request::all(); $file = $all['file']; $table = ExcelHelper::import($file); foreach ($table as $key => $value) { foreach ($value as $j => $k) { if ($k === null) { $value[$j] = ''; } } $barang = Barang::find($value['id'])->first(); if ($barang == null) { $barang = new Barang(); /* fill tipe barang MASIH HARUS DIBENERIN*/ $tipebarang = $value['tipebarang']; // $tipebarang = TipeBarang::find($tipebarang); // if ($tipebarang == null) { // $tipebarang = ucwords(strtolower($tipebarang)); // $tipebarang = TipeBarang::firstOrCreate(['nama' => $tipebarang]); // $tipebarang = $tipebarang->id; // } $value['tipebarang'] = $tipebarang; /* fill numeric awal */ if (!is_numeric($value['nilai_persediaan_awal'])) { $value['nilai_persediaan_awal'] = 0; } if (!is_numeric($value['harga_jual1'])) { $value['harga_jual1'] = 0; } if (!is_numeric($value['harga_jual2'])) { $value['harga_jual2'] = 0; } if (!is_numeric($value['harga_jual3'])) { $value['harga_jual3'] = 0; } if (!is_numeric($value['harga_jual4'])) { $value['harga_jual4'] = 0; } if (!is_numeric($value['harga_jual5'])) { $value['harga_jual5'] = 0; } if (!is_numeric($value['saldo_minimum'])) { $value['saldo_minimum'] = 0; } /* correct status */ $status = strtolower($value['status']); if ($status != 'aktif' && $status != 'non aktif') { $status = 'aktif'; } $value['status'] = $status; /* finally */ $barang->fill($value); $barang->save(); // dd($barang); } } return redirect('barang'); }