public function productIndex()
{
// Get products
$products = \Product::Find(['limit' => 9, 'featured' => 1, 'status' => 1]);
// Get collections
$collections = \Collection::Find(['status' => 1]);
// Get currencies
$currencies = \Currency::Find(['status' => 1]);
return view('example.product-index', ['products' => $products['result'], 'collections' => $collections['result'], 'currencies' => $currencies['result']]);
}
/**
* 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] = '';
}
}
$akun = Akun::find(['no_akun' => $value['no_akun']])->first();
if ($akun == null) {
$akun = new Akun();
/* fill mata_uang */
$mata_uang = Currency::find($value['mata_uang']);
if ($mata_uang == null) {
continue;
}
$value['mata_uang'] = $mata_uang->simbol;
/* fill tipe akun */
$id_tipeakun = $value['id_tipeakun'];
$tipeakun = TipeAkun::find($id_tipeakun);
if ($tipeakun == null) {
$id_tipeakun = ucwords(strtolower($id_tipeakun));
$tipeakun = TipeAkun::firstOrCreate(['nama' => $id_tipeakun]);
$id_tipeakun = $tipeakun->id;
}
$value['id_tipeakun'] = $id_tipeakun;
/* fill saldo awal */
if (!is_numeric($value['saldo_awal'])) {
$value['saldo_awal'] = 0;
}
/* fill tanggal */
if ($value['tanggal'] == null) {
$value['tanggal'] = date('Y-m-d');
} else {
$tanggal = $value['tanggal'];
$tanggal = date('Y-m-d', strtotime($tanggal));
$value['tanggal'] = $tanggal;
}
/* finally */
$akun->fill($value);
$akun->save();
// dd($akun);
}
//dd($akun);
// $akun = Akun::firstOrCreate(['no_akun' => $value['no_akun']]);
//$akun
}
return redirect('akun');
}