/** * 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;