@php $file_type = "vnd.ms-excel"; $file_name= "User.xls"; header("Content-Type: application/$file_type"); header("Content-Disposition: attachment; filename=$file_name"); $TodayDate=date('Y-m-d'); $oneDays=date('Y-m-d',strtotime("-1 days")); $ThreeDays=date('Y-m-d',strtotime("-3 days")); $FourDays=date('Y-m-d',strtotime("-4 days")); $SevenDays=date('Y-m-d',strtotime("-7 days")); $EightDays=date('Y-m-d',strtotime("-8 days")); $FiftenDays=date('Y-m-d',strtotime("-15 days")); $SixtenDays=date('Y-m-d',strtotime("-16 days")); $ThirtyDays=date('Y-m-d',strtotime("-30 days")); $TodayTotalCount=0; $onetoThreeDaysTotalCount=0; $ThreetosevenDaysTotalCount=0; $EighttoFiftenDaysTotalCount=0; $SixtentoThirtyDaysTotalCount=0; $belowThirtyTotalCount=0; $OverAllTotalTotalCount=0; $UserRequest=0; if($UserImplodeencode) { $UserRequest=$UserImplodeencode; } @endphp
| User Name | 0-1 Days ({{$TodayDate}}) |
1-3 Days ({{$oneDays}} - {{$ThreeDays}}) |
4-7 Days ({{$FourDays}} - {{$SevenDays}}) |
8-15 Days ({{$EightDays}} - {{$FiftenDays}}) |
16-30 Days ({{$SixtenDays}} - {{$ThirtyDays}}) |
>30 Days >({{$ThirtyDays}}) |
Grand Total |
|---|---|---|---|---|---|---|---|
| {{$UserName}} | {{$Today}} | {{$onetoThreeDays}} | {{$ThreetosevenDays}} | {{$EighttoFiftenDays}} | {{$SixtentoThirtyDays}} | {{$belowThirty}} | {{$TempTotal}} |
| Grand Total | {{$TodayTotalCount}} | {{$onetoThreeDaysTotalCount}} | {{$ThreetosevenDaysTotalCount}} | {{$EighttoFiftenDaysTotalCount}} | {{$SixtentoThirtyDaysTotalCount}} | {{$belowThirtyTotalCount}} | {{$OverAllTotalTotalCount}} |