public function tambahBarang(Request $request)
{
$barang = new Barang();
$barang->kodeBarang = $request->input('kodeBarang');
$barang->nama = $request->input('nama');
$barang->stok = $request->input('stok');
$barang->harga = $request->input('harga');
$barang->save();
}
/**
* 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');
}
