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