/** * 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); }
$task->end_time = $endTime; $task->hours_worked = $hoursWorked; $task->notes = $notes; $task->task_type_id = $taskType->id; $task->time_card_hours_worked_id = $timeHoursWorkedCard->id; $task->save(); } $startTime = '12:00:00'; $endTime = '17:00:00'; $hoursWorked = 5.0; $notes = "worked defect number 127068"; if (is_null($task = Task::checkIfExists($startTime))) { // get $taskType->id $taskType = TaskType::where('type', '=', 'Code')->first(); // get $timeCard->id $timeHoursWorkedCard = TimeCardHoursWorked::where('date_worked', '=', '2015-11-12')->first(); $task = new Task(); $task->start_time = $startTime; $task->end_time = $endTime; $task->hours_worked = $hoursWorked; $task->notes = $notes; $task->task_type_id = $taskType->id; $task->time_card_hours_worked_id = $timeHoursWorkedCard->id; $task->save(); } }); Route::get('add_taskType_data', function () { $type = 'Lunch'; $description = 'Lunch break'; if (is_null($taskType = TaskType::checkIfExists($type))) { // get $client->id