public function put(Request $request, $id) { //return $request->all(); if (strtolower($request->input('id')) == strtolower($id)) { $manday = Manday::find($id); if (count($manday) > 0) { //\DB::beginTransaction(); $manday->custcount = $request->input('custcount'); $manday->headspend = $request->input('headspend'); $manday->empcount = $request->input('empcount'); $manday->workhrs = $request->input('workhrs'); $manday->breakhrs = $request->input('breakhrs'); $manday->loading = $request->input('loading'); \DB::beginTransaction(); //Start transaction! try { $manday->save(); try { foreach ($request->input('manskeddtls') as $mandtl) { $n = Mandtl::find($mandtl['id']); if (count($manday) > 0) { $n->daytype = $mandtl['daytype']; $n->timestart = $mandtl['timestart']; $n->breakstart = $mandtl['breakstart']; $n->breakend = $mandtl['breakend']; $n->timeend = $mandtl['timeend']; $n->workhrs = $mandtl['workhrs']; $n->breakhrs = $mandtl['breakhrs']; $n->loading = $mandtl['loading']; $n->save(); } else { \DB::rollback(); return 'no mandtl found!'; } } } catch (\Exception $e) { \DB::rollback(); throw $e; } } catch (\Exception $e) { \DB::rollback(); throw $e; } \DB::commit(); $manday->load('manskeddtls'); return $manday; //return $request->input('manskeddtls'); } } return redirect(URL::previous()); //return ['iid' => $request->input('id'), 'rid'=>$id]; }
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; }
/** * Get all of the tasks for a given user. * * @param User $user * @return Collection */ public function countBranchMandtlByDate(User $user, $date) { return Manskedday::with('countMandtls')->select('manskedday.*')->leftJoin('manskedhdr', function ($join) { $join->on('manskedday.manskedid', '=', 'manskedhdr.id'); })->where('manskedhdr.branchid', '=', $user->branchid)->where('manskedday.date', '=', $date); }
public function put(Request $request, $id) { //return $request->all(); if (strtolower($request->input('id')) == strtolower($id)) { $manday = Manday::find($id); if (count($manday) > 0) { //\DB::beginTransaction(); $manday->custcount = $request->input('custcount'); $manday->headspend = $request->input('headspend'); $manday->empcount = $request->input('empcount'); $manday->workhrs = $request->input('workhrs'); $manday->breakhrs = $request->input('breakhrs'); $manday->overload = $request->input('overload'); $manday->underload = $request->input('underload'); \DB::beginTransaction(); //Start transaction! try { $manday->save(); try { foreach ($request->input('manskeddtls') as $mandtl) { $n = Mandtl::find($mandtl['id']); if (count($n) > 0) { //dd(count($n)); foreach ($mandtl as $key => $value) { if ($mandtl['timestart'] == 'off') { $n->breakstart = 'off'; $n->breakend = 'off'; $n->timeend = 'off'; } $n->{$key} = $value; } $n->save(); } else { //dd($mandtl); $m = new Mandtl(); foreach ($mandtl as $key => $value) { if ($key == 'id') { $m->id = $m->get_uid(); } else { $m->{$key} = $value; } } $m->mandayid = $request->input('id'); $m->save(); //\DB::rollback(); //return 'no mandtl found!'; } } } catch (\Exception $e) { \DB::rollback(); throw $e; } } catch (\Exception $e) { \DB::rollback(); throw $e; } \DB::commit(); //$manday->load('manskeddtls'); //return $manday; //return $request->input('manskeddtls'); } } return redirect('/task/manday/' . $manday->lid())->with('alert-success', 'Record saved!'); //return ['iid' => $request->input('id'), 'rid'=>$id]; }