/**
* Get all of the tasks for a given user.
*
* @param User $user
* @return Collection
*/
public function branchByDate(User $user, $date)
{
return Manskeddtl::with(['employee' => function ($query) {
$query->select('lastname', 'firstname', 'id');
}])->select('manskeddtl.*')->leftJoin('hr.employee', function ($join) {
$join->on('manskeddtl.employeeid', '=', 'employee.id');
})->leftJoin('manskedday', function ($join) {
$join->on('manskeddtl.mandayid', '=', 'manskedday.id');
})->where('employee.branchid', '=', $user->branchid)->where('manskedday.date', '=', $date)->orderBy('employee.lastname', 'ASC')->orderBy('employee.firstname', 'ASC')->get();
}
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;
}
private function setEmployeeMandtl($employeeid, $date)
{
$mandtl = Mandtl::employeeid($employeeid)->date($date)->first();
if (count($mandtl) <= 0) {
//echo count($mandtl).'<br>';
$this->dtr->daytype = '2';
} else {
if ($mandtl->daytype == '0') {
$this->dtr->daytype = '2';
//echo 'off<br>';
} else {
//echo 'mandtl: '.$mandtl->daytype.' - '.$mandtl->timestart.' - '.$mandtl->breakstart.' - '.$mandtl->breakend.' - '.$mandtl->timeend.'<br>';
}
$this->dtr->daytype = $mandtl->daytype;
$this->dtr->timestart = $mandtl->timestart;
$this->dtr->breakstart = $mandtl->breakstart;
$this->dtr->breakend = $mandtl->breakend;
$this->dtr->timeend = $mandtl->timeend;
//echo 'dtr dtl: '.$this->dtr->daytype.' - '.$this->dtr->timestart->format('H:i').' - '.$this->dtr->breakstart->format('H:i').' - '.$this->dtr->breakend->format('H:i').' - '.$this->dtr->timeend->format('H:i').'<br>';
}
}
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;
}
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];
}
