public function post(Request $request)
{
//
$this->validate($request, ['date' => 'required|date|max:10', 'weekno' => 'required']);
// check weekno if exist
$mansked = Mansked::whereWeekno($request->input('weekno'))->get();
if (count($mansked) > 0) {
return redirect('/branch/mansked/add')->withErrors(['message' => 'Week ' . $request->input('weekno') . ' already created!'])->withInput();
}
//$mansked = array_shift($mansked);
$mansked = new Mansked();
//return $mansked->getRefno();
$mansked->refno = $mansked->getRefno();
$mansked->date = $request->input('date');
$mansked->weekno = $request->input('weekno');
$mansked->branchid = $request->input('branchid');
$mansked->managerid = $request->input('managerid');
$mansked->mancost = $request->input('mancost');
$mansked->notes = $request->input('notes');
$mansked->id = $mansked->get_uid();
$mandays = [];
foreach ($mansked->getDaysByWeekNo($request->input('weekno')) as $key => $date) {
$manday = new Manday();
$manday->date = $date;
$manday->id = $manday->get_uid();
array_push($mandays, $manday);
}
\DB::beginTransaction();
//Start transaction!
try {
$mansked->save();
try {
$mansked->manskeddays()->saveMany($mandays);
} catch (\Exception $e) {
\DB::rollback();
throw $e;
}
} catch (\Exception $e) {
\DB::rollback();
throw $e;
}
\DB::commit();
//$mansked->id
//return $id;
//return dd($mansked);
$mansked->load('manskeddays');
foreach ($mansked->manskeddays as $manskedday) {
foreach ($this->employees as $employee) {
$mandtl = new Mandtl();
$mandtl->employeeid = $employee->id;
$mandtl->id = $mandtl->get_uid();
$manskedday->manskeddtls()->save($mandtl);
}
}
return $mansked;
}
public function copyMansked(Request $request)
{
$this->validate($request, ['lweekno' => 'required', 'nweekno' => 'required', 'year' => 'required', 'lmanskedid' => 'required']);
$mansked1 = Mansked::whereWeekno($request->input('nweekno'))->where('year', $request->input('year'))->where('branchid', $request->user()->branchid)->get();
if (count($mansked1) > 0) {
return redirect('/task/mansked')->withErrors(['message' => 'Manpower Schedule Week ' . $request->input('nweekno') . ' already exist!'])->withInput();
}
$mansked = Mansked::find($request->input('lmanskedid'));
if (count($mansked) <= 0) {
return redirect('/task/mansked')->withErrors(['message' => 'Pointer Week ' . $request->input('lweekno') . ' not found!'])->withInput();
}
$mansked->load('manskeddays');
$mandays = $mansked->manskeddays;
foreach ($mandays as $manday) {
$manday->load('manskeddtls');
}
$new_mansked = new Mansked();
//return $mansked->getRefno();
$new_mansked->refno = $new_mansked->getRefno();
$new_mansked->date = $mansked->date->format('Y-m-d');
$new_mansked->weekno = $request->input('nweekno');
$new_mansked->year = $request->input('year');
$new_mansked->branchid = $mansked->branchid;
$new_mansked->managerid = $mansked->managerid;
$new_mansked->mancost = $mansked->mancost;
$new_mansked->notes = $mansked->notes;
$new_mansked->id = $mansked->get_uid();
\DB::beginTransaction();
//Start transaction!
$new_mandays = [];
foreach ($new_mansked->getDaysByWeekNo($request->input('nweekno'), $request->input('year')) as $key => $date) {
$new_manday = new Manday();
$new_manday->date = $date->format('Y-m-d');
$new_manday->custcount = $mandays[$key]->custcount;
$new_manday->headspend = $mandays[$key]->headspend;
$new_manday->empcount = $mandays[$key]->empcount;
$new_manday->workhrs = $mandays[$key]->workhrs;
$new_manday->breakhrs = $mandays[$key]->breakhrs;
$new_manday->overload = $mandays[$key]->overload;
$new_manday->underload = $mandays[$key]->underload;
$new_manday->id = $new_manday->get_uid();
$new_mandtls = [];
foreach ($mandays[$key]->manskeddtls as $mandtl) {
$new_mandtl = new Mandtl();
$new_mandtl->employeeid = $mandtl->employeeid;
$new_mandtl->daytype = $mandtl->daytype;
$new_mandtl->timestart = $mandtl->timestart;
$new_mandtl->breakstart = $mandtl->breakstart;
$new_mandtl->breakend = $mandtl->breakend;
$new_mandtl->timeend = $mandtl->timeend;
$new_mandtl->workhrs = $mandtl->workhrs;
$new_mandtl->breakhrs = $mandtl->breakhrs;
$new_mandtl->loading = $mandtl->loading;
$new_mandtl->id = $new_mandtl->get_uid();
array_push($new_mandtls, $new_mandtl);
}
try {
$new_manday->manskeddtls()->saveMany($new_mandtls);
} catch (\Exception $e) {
\DB::rollback();
throw $e;
}
array_push($new_mandays, $new_manday);
}
try {
$new_mansked->save();
try {
$new_mansked->manskeddays()->saveMany($new_mandays);
} catch (\Exception $e) {
\DB::rollback();
throw $e;
}
} catch (\Exception $e) {
\DB::rollback();
throw $e;
}
\DB::commit();
return redirect('/task/mansked')->with(['new' => true])->with('alert-success', 'Week ' . $request->input('lweekno') . ' successfully copied!');
$new_mansked->load('manskeddays');
$new_mandays = $new_mansked->manskeddays;
foreach ($new_mandays as $new_manday) {
$new_manday->load('manskeddtls');
}
return $new_mansked;
}