/** * This function loads the Assign Tasks page for a particular event * * * @return Assign Tasks page with Quote Requests/Users table data */ public function Assign() { $input = Request::all(); //if no inputs, redirect to Task Templates page if ($input == null) { return redirect('dashboard/events/assign-tasks'); } //check with db if EventName is valid $evid = $_GET['EventID']; $quote = Quote_Requests::select('*')->where('id', $evid)->get(); //if not valid, redirect to Task Templates page if ($quote == '[]') { return redirect('dashboard/events/assign-tasks'); } foreach ($quote as $quote1) { $evetype = $quote1->EventType; } $tasks = Task_Templates::select('*')->where('EventName', $evetype)->get(); $team = Users::distinct()->select('*')->where('role', 'team-member')->get(); $alreadyassigned = Event_Tasks::select('*')->where('EventID', $evid)->get(); return view('assign_task.assign')->with(array('team' => $team, 'quote' => $quote, 'tasks' => $tasks, 'already' => $alreadyassigned)); }
</thead> <tbody> <?php use App\Models\Task_Templates; foreach ($result as $todo) { echo '<tr>'; echo '<td ><b> <font size="4"> ' . $todo->EventName . '</font> </b> <table class="table table-striped table-borderd"> <thead> <td width="300px"><b>To Do Task</b></td> <td><b>Description</b></td> </thead> <tbody>'; $result2 = Task_Templates::select('*')->where('EventName', $todo->EventName)->get(); foreach ($result2 as $todo2) { echo '<tr>'; echo '<td>' . $todo2->ToDoTask . '</td>'; echo '<td>' . $todo2->Description . '</td>'; echo '</tr>'; } echo '</tbody> </table> </td>'; echo '<td style="vertical-align:middle;" align="center" ><a href ="tasks/edit?EventName=' . $todo->EventName . '" ><i class="fa fa-edit"></i></td>'; echo '</tr>'; } ?> </tbody> </table>
/** * This function gives the Exsisting Task Template for given EventName * * @param EventName * * @return Edit Task Templates page with task_template table data */ public function GetTaskDetails() { $ename = $_POST['EvName']; $result = Task_Templates::select('ToDoTask', 'Description')->where('EventName', $ename)->get(); return $result; }