}); /* #################### IMPORT ALLOWANCES ################################## */ Route::post('import/allowances', function () { if (Input::hasFile('allowances')) { $destination = public_path() . '/migrations/'; $filename = str_random(12); $ext = Input::file('allowances')->getClientOriginalExtension(); $file = $filename . '.' . $ext; Input::file('allowances')->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'); $allowanceid = DB::table('allowances')->where('allowance_name', '=', $result->allowance_type)->pluck('id'); $allowance = new EAllowances(); $allowance->employee_id = $employeeid; $allowance->allowance_id = $allowanceid; $allowance->allowance_amount = $result->amount; $allowance->save(); } }); } return Redirect::back()->with('notice', 'allowances have been succefully imported'); }); /* #################### IMPORT DEDUCTIONS ################################## */ Route::post('import/deductions', function () { if (Input::hasFile('deductions')) { $destination = public_path() . '/migrations/'; $filename = str_random(12); $ext = Input::file('deductions')->getClientOriginalExtension();
/** * Remove the specified branch from storage. * * @param int $id * @return Response */ public function destroy($id) { $allowance = EAllowances::findOrFail($id); EAllowances::destroy($id); Audit::logaudit('Employee Allowances', 'delete', 'deleted: ' . $allowance->allowance_amount); return Redirect::route('employee_allowances.index'); }