/**
* 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();
