/**
* Display the specified resource.
*
* @param $timeCardHoursWorkedId
*
* @return \Illuminate\Http\Response|\Illuminate\View\View
*/
public function show($timeCardHoursWorkedId)
{
// set appGlobal.clientId to current view, otherwise 'if (appGlobal.clientId)' in TimeCard.js causes a js load failure.
appGlobals::populateJsGlobalClient();
// used for routing.
appGlobals::setSessionVariableAppGlobalTimeCardTableName($timeCardHoursWorkedId);
// get all task for a specific time_card.date.
/* @noinspection PhpUndefinedMethodInspection */
$tasks = Task::where('time_card_hours_worked_id', '=', $timeCardHoursWorkedId)->get()->sortBy('start_time');
// derive total hours worked.
$totalHoursWorked = 0;
foreach ($tasks as $task) {
$totalHoursWorked += $task->hours_worked;
}
// eager load task_type for each task.
/* @noinspection PhpUndefinedMethodInspection */
$tasks->load('taskType');
// get time_card data.
/* @noinspection PhpUndefinedMethodInspection */
$timeCard = TimeCardHoursWorked::where('id', '=', $timeCardHoursWorkedId)->get();
// check if $timeCardHoursWorkedId exists, if not return 404 message.
if (count($timeCard) == 0) {
abort(404, 'Your Task ID does not exist.');
}
// pass the data to the view.
return view('pages.userTaskView')->with('tasks', $tasks)->with('timeCard', $timeCard)->with('timeCardHoursWorkedId', $timeCardHoursWorkedId)->with('totalHoursWorked', $totalHoursWorked);
}
public function getTimeCardHoursWorkedData($bwDate, $ewDate)
{
$timeCardHoursWorkedRows = TimeCardHoursWorked::whereBetween('date_worked', [$bwDate, $ewDate])->get();
// eager load timeCardFormat, work and workType.
$timeCardHoursWorkedRows->load('task');
$timeCardHoursWorkedRows->load('timeCard');
foreach ($timeCardHoursWorkedRows as $timeCardHoursWorkedRow) {
$timeCardHoursWorkedRow->timeCard->load('work');
$timeCardHoursWorkedRow->timeCard->work->load('workType');
}
return $timeCardHoursWorkedRows;
}
/**
* Register any other events for your application.
*
* @param \Illuminate\Contracts\Events\Dispatcher $events
* @return void
*/
public function boot(DispatcherContract $events)
{
parent::boot($events);
// register the ProjectObserver class.
Client::observe(new ClientObserver());
// register the ProjectObserver class.
Project::observe(new ProjectObserver());
// register the WorkTypeObserver class.
WorkType::observe(new WorkTypeObserver());
// register the TimeCardFormatObserver class.
TimeCardFormat::observe(new TimeCardFormatObserver());
// register the WorkObserver class.
Work::observe(new WorkObserver());
// register the TimeCardObserver class.
TimeCard::observe(new TimeCardObserver());
// register the TimeCardHoursWorkedObserver class.
TimeCardHoursWorked::observe(new TimeCardHoursWorkedObserver());
// register the TaskTypeObserver class.
TaskType::observe(new TaskTypeObserver());
// register the TaskObserver class.
Task::observe(new TaskObserver());
}
/**
* @param $timeCard
* @param $timeCardRange
* @param $i
* @param $timeCardRequestAttributes
*/
protected function saveTimeCardHoursWorked($timeCard, $timeCardRange, $i, $timeCardRequestAttributes)
{
$timeCardHoursWorked = new TimeCardHoursWorked();
$timeCardHoursWorked->setWorkId($timeCard->work_id);
$timeCardHoursWorked->setTimeCardId($timeCard->id);
$timeCardHoursWorked->setDateWorked($this->getDateWorked(appGlobals::getBeginningOfCurrentWeek($timeCardRange), $i));
$timeCardHoursWorked->setDow($this->getDOW($timeCardHoursWorked->getDateWorked()));
$timeCardHoursWorked->setHoursWorked($timeCardRequestAttributes['dow_0' . $i]);
$timeCardHoursWorked->save();
}
});
Route::get('add_timeCard_data', function () {
$date = '2015-11-09';
// get $work->id
$work = Work::where('work_type_description', '=', 'The catalog view is performing too slowly.')->first();
// get $timeCardFormat->id
$timeCardFormat = TimeCardFormat::where('description', '=', 'Day of week starts on SAT and ends on SUN')->first();
$timeCard = new TimeCard();
$timeCard->work_id = $work->id;
$timeCard->time_card_format_id = $timeCardFormat->id;
if (!is_null($timeCard = TimeCard::checkIfExists($timeCard))) {
$timeCardHoursWorked = new TimeCardHoursWorked();
$timeCardHoursWorked->work_id = $work->id;
$timeCardHoursWorked->date_worked = $date;
$timeCardHoursWorked->dow = "MON";
if (is_null(TimeCardHoursWorked::checkIfDateWorkedDowExists($timeCardHoursWorked))) {
$timeCardHoursWorked->hours_worked = 8.0;
$timeCardHoursWorked->time_card_id = $timeCard->id;
$timeCardHoursWorked->save();
}
}
});
/**
* prototyping...
*/
Route::get('play', function () {
$myArray['SUN'] = 0.0;
$myArray['MON'] = 0.0;
$myArray['TUE'] = 5.0;
$myArray['WED'] = 0.0;
$myArray['THU'] = 3.0;
