/**
* Store a newly created resource in storage.
*
* @return \Illuminate\Http\Response
*/
public function store(CompanyLeaveRequest $request)
{
if (!Auth::user()->can('edit.company')) {
return view('errors.404');
}
// Format date from daterange picker to mysql format
$leave_request = $request->all();
$leave_request['from'] = Carbon::createFromFormat('d/m/Y H:i', $request->get('from') . '00:00')->toDateTimeString();
$leave_request['to'] = Carbon::createFromFormat('d/m/Y H:i', $request->get('to') . '00:00')->toDateTimeString();
// Create Leave
CompanyLeave::create($leave_request);
Toastr::success("Created new leave", "Success");
return view('company.leave.list');
}
/**
* Migrate Company Leave
*/
public function companyleave()
{
echo "<h1>Migrating Company Leave</h1>";
$companyleave = zCompanyLeave::all();
$companyleave->each(function ($leave) {
echo "<b>" . $leave->cid . "</b> ({$leave->start_date})<br>";
$lookup = DB::table('z_lookup_company')->where('old', $leave->cid)->get();
$user = User::where('username', $leave->updated_by)->first();
$newLeave = CompanyLeave::create(array('company_id' => $lookup[0]->new, 'from' => $leave->start_date, 'to' => $leave->end_date, 'notes' => reformatOldStr($leave->notes), 'created_by' => $user->id, 'updated_by' => $user->id, 'created_at' => $leave->updated_at, 'updated_at' => $leave->updated_at));
});
echo "<h1>Completed</h1>";
}
