/**
* Store a newly created branch in storage.
*
* @return Response
*/
public function store()
{
$validator = Validator::make($data = Input::all(), EDeduction::$rules, EDeduction::$messages);
if ($validator->fails()) {
return Redirect::back()->withErrors($validator)->withInput();
}
$ded = new EDeduction();
$ded->employee_id = Input::get('employee');
$ded->deduction_id = Input::get('deduction');
$ded->formular = Input::get('formular');
if (Input::get('formular') == 'Instalments') {
$ded->instalments = Input::get('instalments');
} else {
$ded->instalments = '0';
}
$ded->deduction_amount = Input::get('amount');
$ded->deduction_date = Input::get('ddate');
$ded->save();
return Redirect::route('employee_deductions.index');
}
$filename = str_random(12);
$ext = Input::file('deductions')->getClientOriginalExtension();
$file = $filename . '.' . $ext;
Input::file('deductions')->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');
$deductionid = DB::table('deductions')->where('deduction_name', '=', $result->deduction_type)->pluck('id');
$deduction = new EDeduction();
$deduction->employee_id = $employeeid;
$deduction->deduction_id = $deductionid;
$deduction->deduction_amount = $result->amount;
$deduction->deduction_date = $result->date;
$deduction->save();
}
});
}
return Redirect::back()->with('notice', 'deductions have been succefully imported');
});
/*
* #####################################################################################################################
*/
/*
* banks routes
*/
Route::resource('banks', 'BanksController');
Route::post('banks/update/{id}', 'BanksController@update');
Route::get('banks/delete/{id}', 'BanksController@destroy');
Route::get('banks/edit/{id}', 'BanksController@edit');
