public function postsitedata() { $file = Input::file('sitedata'); $destinationPath = 'importdata'; // If the uploads fail due to file system, you can try doing public_path().'/uploads' $filename = 'imported-sitedata'; //$filename = $file->getClientOriginalName(); //$extension =$file->getClientOriginalExtension(); $upload_success = Input::file('sitedata')->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['site'] != '' && $data['site_id'] != '') { $d = new Mastertp(); $d->sitelocation = $data['site']; $d->btsnameoss = $data['site_id']; $d->save(); } } }); Session::flash('success', 'Data imported to database'); return Redirect::to('/import'); } else { Session::flash('error', 'Error uploading files'); return Redirect::to('/import'); } }
function storefromajax() { $mastertp = new Mastertp(); $mastertp->sitelocation = Input::get('namasite'); $mastertp->btsname = Input::get('namabts'); $mastertp->save(); return Response::json($mastertp); }
public function edit($id) { $data['active'] = 'activity'; $data['activity'] = Activity::find($id); $data['sites'] = Mastertp::all(); return View::make(Auth::user()->role . '.activity.edit', $data); }
public function edit($id) { $data['active'] = 'st'; $data['surat'] = SuratTugas::find($id); $data['bantek'] = Bantek::all(); $data['sites'] = Mastertp::all(); $data['user_no'] = User::where('role', '=', 'no')->get(); $ids = ''; foreach ($data['surat']->activities as $key) { $ids .= $key->id . ','; } $data['activity_ids'] = $ids; return View::make('admin.surattugas.edit', $data); }
public function data() { $active = "oss"; $approvals = ApprovalPerson::all(); $sl_data = ShoppingList::all(); $dataoss = Oss::all(); $sites = Mastertp::distinct()->groupBy('sitelocation')->get(); $max = 1; $nomax = DB::table('oss')->orderBy('no_oss', 'desc')->take(1)->get(); foreach ($nomax as $nomax) { $max = $nomax->no_oss; $max = $max + 1; } return View::make('oss.list')->with('active', $active)->with('dataoss', $dataoss)->with('max', $max)->with('sites', $sites)->with('sl_data', $sl_data)->with('approvals', $approvals); }
Route::post('/submit', 'UserController@submit'); Route::get('/{id}/edit', 'UserController@edit'); Route::post('/{id}/update', 'UserController@update'); Route::get('/{id}/delete', 'UserController@delete'); }); Route::group(array('prefix' => 'oss', 'before' => 'auth'), function () { Route::get('/', 'OssController@data'); Route::post('/bantek/submit', 'OssController@submit_bantek'); Route::post('/material/submit', 'OssController@submit_material'); Route::get('/{id}/edit', 'OssController@edit'); Route::post('/{id}/update', 'OssController@update'); Route::get('/{id}/delete', 'OssController@delete'); }); Route::group(array('prefix' => 'fpl', 'before' => 'auth'), function () { Route::get('/', 'FplController@data'); Route::post('/submit', 'FplController@submit'); Route::get('/{id}', 'FplController@details'); Route::get('/{id}/edit', 'FplController@edit'); Route::post('/{id}/update', 'FplController@update'); Route::get('/{id}/delete', 'FplController@delete'); }); Route::group(array('prefix' => 'import', 'before' => 'auth'), function () { Route::get('/', 'ImportController@forms'); Route::post('submit/sitedata', 'ImportController@postsitedata'); Route::post('submit/shopdata', 'ImportController@postshopdata'); }); Route::get('/ajax/sl/{param}', 'AjaxController@list_shop'); Route::get('/json', function () { $data = Mastertp::all(); return Response::json($data); });
public function importmastertp() { $ext = Input::file('file')->getClientOriginalExtension(); $validator = Validator::make(array('ext' => $ext), array('ext' => 'in:xls,xlsx')); if ($validator->fails()) { Session::flash('error', 'File format tidak di dukung'); return Redirect::to('/admin/import/mastertp'); } else { if ($ext == 'xls') { Input::file('file')->move(public_path(), 'mastertp.xls'); if (Input::get('replace') == 'on') { DB::table('mastertp')->delete(); } else { } try { Excel::load('public/mastertp.xls', function ($r) { $res = $r->all()->toArray(); foreach ($res as $data) { $d = new Mastertp(); if ($data['site'] != '' && $data['site_id'] != '') { $d->sitelocation = $data['site']; $d->btsname = $data['site_id']; $d->save(); } } }); } catch (Exception $e) { Session::flash('error', '' . $e->getMessage()); return Redirect::to('/admin/import/mastertp'); } } elseif ($ext == 'xlsx') { Input::file('file')->move(public_path(), 'mastertp.xlsx'); if (Input::get('replace') == 'on') { DB::table('mastertp')->delete(); } else { } try { Excel::load('public/mastertp.xlsx', function ($r) { $res = $r->all()->toArray(); foreach ($res as $data) { $d = new Mastertp(); if ($data['site'] != '' && $data['site_id'] != '') { $d->sitelocation = $data['site']; $d->btsname = $data['site_id']; $d->save(); } } }); } catch (Exception $e) { Session::flash('error', '' . $e->getMessage()); return Redirect::to('/admin/import/mastertp'); } } else { } Session::flash('success', 'Data telah dibuat.'); return Redirect::to('/admin/import/mastertp'); } }