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');
});
