Display attendance report in laravel blade file

Try something like:

       $empatts = EmpAttendance::where(function ($query) use ($request) {

            if (! empty($request->from_date))
            {
                $query->whereBetween('att_date', [$request->from_date, $request->to_date]);
            }

        })->get()->groupBy('att_date');

Then you'll have a collection grouped by the att_date. And you can do a @foreach in the blade/view to display the results as you wish.

@mstrauss thank you for your response.

i used as per your code. now when dd($empatts) gives

Collection {#1758 ▼
  #items: array:3 [▼
    "2019-07-22" => Collection {#1755 ▼
      #items: array:63 [▼
        0 => EmpAttendance {#1563 ▼
          #fillable: array:6 [ …6]
          #connection: "mysql"
          #table: null
          #primaryKey: "id"
          #keyType: "int"
          +incrementing: true
          #with: []
          #withCount: []
          #perPage: 15
          +exists: true
          +wasRecentlyCreated: false
          #attributes: array:10 [ …10]
          #original: array:10 [ …10]
          #casts: []
          #dates: []
          #dateFormat: null
          #appends: []
          #events: []
          #observables: []
          #relations: []
          #touches: []
          +timestamps: true
          #hidden: []
          #visible: []
          #guarded: array:1 [ …1]
        }
        1 => EmpAttendance {#1564 ▶}
        2 => EmpAttendance {#1565 ▶}
        3 => EmpAttendance {#1566 ▶}
        4 => EmpAttendance {#1567 ▶}
        5 => EmpAttendance {#1568 ▶}
        6 => EmpAttendance {#1569 ▶}
        7 => EmpAttendance {#1570 ▶}
        8 => EmpAttendance {#1571 ▶}
        9 => EmpAttendance {#1572 ▶}
        10 => EmpAttendance {#1573 ▶}
        11 => EmpAttendance {#1574 ▶}
        12 => EmpAttendance {#1575 ▶}
        13 => EmpAttendance {#1576 ▶}
        14 => EmpAttendance {#1577 ▶}
        15 => EmpAttendance {#1578 ▶}
        16 => EmpAttendance {#1579 ▶}
        17 => EmpAttendance {#1580 ▶}
        18 => EmpAttendance {#1581 ▶}
        19 => EmpAttendance {#1582 ▶}
        20 => EmpAttendance {#1583 ▶}
        21 => EmpAttendance {#1584 ▶}
        22 => EmpAttendance {#1585 ▶}
        23 => EmpAttendance {#1586 ▶}
        24 => EmpAttendance {#1587 ▶}
        25 => EmpAttendance {#1588 ▶}
        26 => EmpAttendance {#1589 ▶}
        27 => EmpAttendance {#1590 ▶}
        28 => EmpAttendance {#1591 ▶}
        29 => EmpAttendance {#1592 ▶}
        30 => EmpAttendance {#1593 ▶}
        31 => EmpAttendance {#1594 ▶}
        32 => EmpAttendance {#1595 ▶}
        33 => EmpAttendance {#1596 ▶}
        34 => EmpAttendance {#1597 ▶}
        35 => EmpAttendance {#1598 ▶}
        36 => EmpAttendance {#1599 ▶}
        37 => EmpAttendance {#1600 ▶}
        38 => EmpAttendance {#1601 ▶}
        39 => EmpAttendance {#1602 ▶}
        40 => EmpAttendance {#1603 ▶}
        41 => EmpAttendance {#1604 ▶}
        42 => EmpAttendance {#1605 ▶}
        43 => EmpAttendance {#1606 ▶}
        44 => EmpAttendance {#1607 ▶}
        45 => EmpAttendance {#1608 ▶}
        46 => EmpAttendance {#1609 ▶}
        47 => EmpAttendance {#1610 ▶}
        48 => EmpAttendance {#1611 ▶}
        49 => EmpAttendance {#1612 ▶}
        50 => EmpAttendance {#1613 ▶}
        51 => EmpAttendance {#1614 ▶}
        52 => EmpAttendance {#1615 ▶}
        53 => EmpAttendance {#1616 ▶}
        54 => EmpAttendance {#1617 ▶}
        55 => EmpAttendance {#1618 ▶}
        56 => EmpAttendance {#1619 ▶}
        57 => EmpAttendance {#1620 ▶}
        58 => EmpAttendance {#1621 ▶}
        59 => EmpAttendance {#1622 ▶}
        60 => EmpAttendance {#1623 ▶}
        61 => EmpAttendance {#1624 ▶}
        62 => EmpAttendance {#1625 ▶}
      ]
    }
    "2019-07-30" => Collection {#1756 ▼
      #items: array:63 [▶]
    }
    "2019-07-28" => Collection {#1757 ▼
      #items: array:63 [▶]
    }
  ]
}

the records are grouped by date wise. i have only 3 date records. it is correct. how i can use it in my blade file plz suggest me that also

How about using the @foreach directive with the $key/$value like:

@foreach ($empatts as $key => $empat)

    // contains the date
    $key; 

    // contains the other pertinent data, like emp_id, att_count, etc. 
    $empat

    // you may want to loop through the $empat to display its data. 
    @foreach ($empat as $value)
        
        // employee id
        $value['emp_id`]; 
    
    @endforeach 

@endforeach

if you feel that the inner foreach is too messy for a blade file, which I kind of do, you can handle the logic in your controller using the map method on the collection instance.

@mstrauss thank you for your response. ya i treid with your code. somewhat messy only. but i made a view llike below

 <tbody>

     @php ($s_no = 1)
     <tr>
         <th width=5%> S. No</th>
         <th width=25%> Name</th>
         @foreach ($empatts as $key => $empat)
         <th width=10%>{{ $key}} </th>
         @endforeach
     </tr>

     @foreach ($empat as $value)
     <tr>
         <td> {{ $s_no  }}</td>
         <td> {{ $value->employee->emp_name}} </td>

         @foreach ($empatts as $key => $empat)
         <td>
             {{$value->att_count }}

         </td>

         @endforeach
     </tr>
     @php ($s_no++)
     @endforeach
 </tbody>

everything is fine. the view. but mistakes are there. whats the problem can u guess

refer this: https://imgur.com/E3mCMPH

Here for the selected person "MANI MANTHIRAM" i have put half day on 2019-07-01. so it must display 0.5 but it displaying 1 and for ANAND it must be 0 on that date. but 1 is there. whats the problem.

for all 1 only displaying...

i cant guess whats the problem.

Kindly suggest please...

@abdulbazith

I think your @foreach structure may be the issue, try this:

<tbody>

     @php ($s_no = 1)
     <tr>
         <th width=5%> S. No</th>
         <th width=25%> Name</th>
         @foreach ($empatts as $key => $empat)
         <th width=10%>{{ $key}} </th>
         @endforeach
     </tr>

     @foreach ($empat as $value)
     <tr>
         <td> {{ $s_no  }}</td>
         <td> {{ $value->employee->emp_name}} </td>
    <td>  {{$value->att_count }} </td>
     </tr>
     @php ($s_no++)
     @endforeach
 </tbody>

@mstrauss

first i kept lie this only. only one record is displayed. thats y added another foreach extra below. but the foreach is mistake

Refer: https://imgur.com/r4r0kfO

@abdulbazith

I think I see the issue, try this:

 <tbody>

     @php ($s_no = 1)
     <tr>
         <th width=5%> S. No</th>
         <th width=25%> Name</th>
         @foreach ($empatts as $key => $empat)
         <th width=10%>{{ $key}} </th>
       
     </tr>

     @foreach ($empat as $value)
     <tr>
         <td> {{ $s_no  }}</td>
         <td> {{ $value->employee->emp_name}} </td>

       
         <td>
             {{$value->att_count }}

         </td>
   @php ($s_no++)
         @endforeach
     </tr>
 
     @endforeach
 </tbody>

@mstrauss same problem.

i think we are missing with a loop some where

ok.

can i have a output like this format

Sno     Name        TotalDays       Present         Absent

1       MANI        31              25          6
2       ABDUL       31              23          8

can i get a output like this `` i my db how i stored the attendance record as, present means 1 absent means 0 halfday means 0.5

like below

att_date
emp_id
att_count
reason

//like below

att_date        emp_id      att-count       reason
01/07           1           1               
01/07           2           0           Leave fever 
02/07           1           0.5         halfday fever
02/07           2           1

Hi @abdulbazith

For the new format you mentioned, the below should work:

// controller

 $employees = App\Employee::withCount([
            'emp_attendance',
            'emp_attendance as present' => function (Builder $query) {
                $query->where('att-count', 1);
            }
        ])->get();

// view

                    @foreach($employees as $employee)

                        <tr>
                            <td> {{ $s_no  }}</td>
                            <td> {{ $employee->name }} </td>
                            <td> {{ $employee->emp_attendance_count }} </td>
                            <td> {{ $employee->present_count }} </td>
                            <td> {{ $employee->emp_attendance_count - $employee->present_count }} </td>
                        </tr>

                        @php ($s_no++)

                    @endforeach

There is an assumption that you have created a relationship on the Employee and the EmployeeAttendance models like below:

// Employee model

    public function employeeAttendaces()
    {
        return $this->hasMany('App\EmployeeAttendance ');
    }

// EmployeeAttendance model

    public function employee()
    {
        return $this->belongsTo('App\Employee');
    }

Please also note this will count all employee attendance records for each given employee. If you want to filter down by a given period, you would have to update the query a bit.

@mstrauss

still getting error

this is my EmpAttendance model

public function employee()
    {
        return $this->belongsTo('App\Employee', 'emp_id');
    }

this is my Employee model

public function empattendance()
    {
        return $this->hasMany('App\EmpAttendance', 'emp_id');
    }

and this is my code

$employees = Employee::withCount([
    'empattendance',
    'empattendance as present' => function (Builder $query) {
        $query->where('att_count', 1);
    }
])->get();

dd($employees);

i got this error

Type error: Argument 1 passed to App\Http\Controllers\EmpAttendanceController::App\Http\Controllers\{closure}() must be an instance of App\Http\Controllers\Builder, instance of Illuminate\Database\Eloquent\Builder given, called in C:\xampp\htdocs\Laravel\hotel_sri_ram_prasad\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Builder.php on line 934

and one important thing i dont have multiple columns for attendance count

att_date        emp_id       att-count       reason
01/07           1            1               
01/07           2               0            Leave fever 
02/07           1               0.5             halfday fever
02/07           2               1
03/07        1          0           absent  

so in the above for employee 1

the present days is 1.5 (1+0.5)

the absentdays is 1.5 (1+0.5) (here the problem is the 0 are absent so that must be count and 0.5 is half day that must be sum and then both must be added ). so the count of 0 is 1 and the sum of 0.5 is 0.5 so adding both 1.5 is the absent days

total days are 3 (1 + 1 + 1)

@abdulbazith

Hmm.. it looks like you are using an _ instead of a - in the below line:

$query->where('att_count', 1);

Per your model properties, I think it should be:

$query->where('att-count', 1);

Can you try that just to see what the result is?

@mstrauss same error

Refer: https://imgur.com/iad4qku

whats the problem.

how can i get the total days, present and absent. kindly help please

If you comment out the new code, does the error go away? I can't see how this query would cause that error.

@mstrauss

exactly i gave like this

   $employees = Employee::withCount([
    'empattendance',
    'empattendance as present' => function (Builder $query) {
        $query->where('att-count', 1);
    }
])->get();

dd($employees);

but i dont know whats the problem.

now what should i doo

Did you include the use App\Employee; import statement at the top of the EmpAttendanceController?

@mstrauss

yes how do i will miss that.

<?php

namespace App\Http\Controllers;

use Alert;
use App\EmpAttendance;
use App\Employee;
use Auth;
use Carbon\Carbon;
use Illuminate\Http\Request;
use Input;
use Illuminate\Support\Facades\DB;

@mstrauss i have posted it as a separate thread

refer: https://laracasts.com/discuss/channels/laravel/calculating-attendance-total-present-and-absent-laravel

@abdulbazith have you got the solution?