/** * Run the migrations. * * @return void */ public function up() { Schema::create('tipeakuns', function (Blueprint $table) { $table->increments('id'); $table->string('nama'); $table->string('normal'); }); TipeAkun::create(['nama' => 'Ekuitas']); }
/** * Get an excel table export. * * @return Response */ public function export() { $tipeakun = new TipeAkun(); $tipeakuns = $tipeakun->get($tipeakun->getFillable()); $tipeakuns = $tipeakuns->toArray(); if ($tipeakuns == []) { return view('tipeakun.export'); } return ExcelHelper::export($tipeakuns, 'tipeakuns'); }
/** * 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'); }