/** * Store a newly created branch in storage. * * @return Response */ public function store() { $validator = Validator::make($data = Input::all(), Earnings::$rules, Earnings::$messages); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $earning = new Earnings(); $earning->employee_id = Input::get('employee'); $earning->earnings_name = Input::get('earning'); $earning->narrative = Input::get('narrative'); $earning->earnings_amount = Input::get('amount'); $earning->save(); Audit::logaudit('Earnings', 'create', 'created: ' . $earning->earnings_name); return Redirect::route('other_earnings.index'); }
$destination = public_path() . '/migrations/'; $filename = str_random(12); $ext = Input::file('earnings')->getClientOriginalExtension(); $file = $filename . '.' . $ext; Input::file('earnings')->move($destination, $file); Excel::selectSheetsByIndex(0)->load(public_path() . '/migrations/' . $file, function ($reader) { $results = $reader->get(); foreach ($results as $result) { $name = explode(':', $result->employee); $employeeid = DB::table('employee')->where('personal_file_number', '=', $name[0])->pluck('id'); $earning = new Earnings(); $earning->employee_id = $employeeid; $earning->earnings_name = $result->earning_type; $earning->narrative = $result->narrative; $earning->earnings_amount = $result->amount; $earning->save(); } }); } return Redirect::back()->with('notice', 'earnings have been succeffully imported'); }); /* #################### IMPORT RELIEFS ################################## */ Route::post('import/reliefs', function () { if (Input::hasFile('reliefs')) { $destination = public_path() . '/migrations/'; $filename = str_random(12); $ext = Input::file('reliefs')->getClientOriginalExtension(); $file = $filename . '.' . $ext; Input::file('reliefs')->move($destination, $file); Excel::selectSheetsByIndex(0)->load(public_path() . '/migrations/' . $file, function ($reader) { $results = $reader->get();