Time Sheet by Month

@csrf

Select Month:

Select January February March April May June July August September October November December @error('month') {{ $message }} @enderror

Select Year:

@for($i=0; $i<20; $i++) {{date('Y') - $i}} @endfor @error('year') {{ $message }} @enderror

Submit

 Download excel form

Monthly Time Sheet Reports

@if(isset($wageCalculator)) @foreach($wageCalculator as $wage) @if($wage->is_leave) @else @php($tt = explode(':', $wage->time_total)) @php($total_time = $tt[0] + ($tt[1]/60)) @php($in = strtotime($wage->time_out) - strtotime($wage->time_in)) @if($wage->time_ot) @php($otTime = explode(':', $wage->time_ot)) @php($ot = $otTime[0] + ($otTime[1]/60)) @else @php($ot = 0) @endif @endif @endforeach @endif

Name	Posted At	Date	Total Hours Clocked	Rate/Hour	Total Amount	OT Hours	OT Rate/Hour	OT Amount
{{$wage->user->name}}	{{$wage->countryBranch->branch_name}}	{{$wage->work_date}}	Leave on this day						{{$wage->time_total}}	{{$wage->rate_per_hour}} {{$wage->currency->currency}}	{{number_format(round($total_time * $wage->rate_per_hour), 2)}} {{$wage->currency->currency}}	{{$wage->time_ot}}	{{$wage->ot_rate_per_hour}}	{{number_format(round($ot * $wage->ot_rate_per_hour), 2)}} {{$wage->currency->currency}}