public function postshopdata() { $file = Input::file('shopdata'); $destinationPath = 'importdata'; // If the uploads fail due to file system, you can try doing public_path().'/uploads' $filename = 'imported-shoppinglistdata'; //$filename = $file->getClientOriginalName(); //$extension =$file->getClientOriginalExtension(); $upload_success = Input::file('shopdata')->move($destinationPath, $filename . '.' . $file->getClientOriginalExtension()); if ($upload_success) { $importedFile = public_path() . '/importdata/' . $filename . '.' . $file->getClientOriginalExtension(); Excel::load($importedFile, function ($r) { $res = $r->all()->toArray(); foreach ($res as $data) { if ($data['kode'] != '' && $data['deskripsi'] != '' && $data['satuan'] != '' && $data['harga'] != '') { $d = new ShoppingList(); $d->kode_sl = $data['kode']; $d->deskripsi_pekerjaan = $data['deskripsi']; $d->satuan = $data['satuan']; $d->harga = $data['harga']; $d->save(); } } }); Session::flash('success', 'Shoppinglist Data imported to database'); return Redirect::to('/import'); } else { Session::flash('error', 'Error uploading files'); return Redirect::to('/import'); } }
| and give it the Closure to execute when that URI is requested. | */ Route::get('/', function () { return View::make('fronts.login'); }); Route::get('/sl', function () { Excel::load('importdata/sl.xls', function ($r) { $res = $r->all()->toArray(); foreach ($res as $data) { $d = new ShoppingList(); $d->kode_sl = $data['kode_sl']; $d->deskripsi_pekerjaan = $data['deskripsi_pekerjaan']; $d->satuan = $data['satuan']; $d->harga = $data['harga']; $d->save(); } }); }); Route::post('/auth', 'SessionController@auth'); Route::get('/logout', 'SessionController@logout'); Route::group(array('prefix' => 'home', 'before' => 'auth'), function () { Route::get('/', 'HomeController@dash'); }); Route::group(array('prefix' => 'users', 'before' => 'auth'), function () { Route::get('/', 'UserController@data'); Route::post('/submit', 'UserController@submit'); Route::get('/{id}/edit', 'UserController@edit'); Route::post('/{id}/update', 'UserController@update'); Route::get('/{id}/delete', 'UserController@delete'); });