PHP TaskDetails::whereIn Exemples

Exemple #1

Fichier : overdue_tasks.blade.php Projet : iHunt101/procurementTrackingSystem

@extends('layouts.dashboard')

@section('content')
    <h1 class="page-header">Overdue Tasks</h1>
    <div class="list-group">

        <!-- Get all task details with id = task->id -->
        <?php 
$user_id = Auth::user()->id;
$date_today = date('Y-m-d H:i:s');
$taskDetails_row = TaskDetails::whereIn('task_id', $taskIds)->whereStatus("Active")->where("dueDate", "<", $date_today)->whereAssigneeId($user_id)->paginate(10);
?>

        @foreach($taskDetails_row as $taskDetail)
            {{Session::put('$taskDetails_row','true');}}
            <?php 
$task = Task::find($taskDetail->task_id);
$doc_id = $taskDetail->doc_id;
$document_row = Document::find($doc_id);
$purchase_id = $document_row->pr_id;
$purchase_row = Purchase::find($purchase_id);
$projectName = $purchase_row->projectPurpose;
$controlNo = $purchase_row->controlNo;
?>
                    
            <a href="/task/{{$taskDetail->id}}" class="list-group-item tasks">
                <div class="pull-left task-desc" style="margin-left: 10px;">
                    <span class="list-group-item-heading">{{ $task->taskName  }}</span> &nbsp;<small><i> </small><br/>
                    <span class="list-group-item-text">{{ $task->description }}</span> &nbsp; 
                    <br>Control No. : <small><font color="blue"><?php 
echo str_pad($controlNo, 5, '0', STR_PAD_LEFT);

Exemple #2

Fichier : new_tasks.blade.php Projet : iHunt101/procurementTrackingSystem

@extends('layouts.dashboard')

@section('content')
    <h1 class="page-header">New Tasks</h1>
    <div class="list-group">

        <!-- Get all task details with id = task->id -->
        <?php 
$user_id = Auth::user()->id;
$taskDetails_row = TaskDetails::whereIn('task_id', $taskIds)->whereStatus("New")->paginate(10);
?>

        @foreach($taskDetails_row as $taskDetail)
            {{Session::put('$taskDetails_row','true');}}
            <?php 
$task = Task::find($taskDetail->task_id);
$doc_id = $taskDetail->doc_id;
$document_row = Document::find($doc_id);
$purchase_id = $document_row->pr_id;
$purchase_row = Purchase::find($purchase_id);
$projectName = $purchase_row->projectPurpose;
$controlNo = $purchase_row->controlNo;
?>

            <a href="/task/{{$taskDetail->id}}" class="list-group-item tasks">
                <div class="pull-left task-desc" style="margin-left: 10px;">
                    <span class="list-group-item-heading">{{ $task->taskName  }}</span> &nbsp;<small><i> </small><br/>
                    <span class="list-group-item-text">{{ $task->description   }}</span> &nbsp;
                    <br>Control No. : <small><font color="blue"><?php 
echo str_pad($controlNo, 5, '0', STR_PAD_LEFT);
?>