Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $attendance_list = DB::table('daily_attendances')
- ->join('employees', 'employees.card_id', '=', 'daily_attendances.card_id')
- ->select('daily_attendances.*','employees.basic_salary','employees.start_time','employees.over_time_rate',
- DB::raw('SEC_TO_TIME( SUM( TIME_TO_SEC( daily_attendances.delay_time ) ) ) AS delay_time'),
- DB::raw('SEC_TO_TIME( SUM( TIME_TO_SEC( daily_attendances.extra_time ) ) ) AS extra_time'),
- DB::raw('SEC_TO_TIME( SUM( TIME_TO_SEC( daily_attendances.in_use_time ) ) ) AS duty_time'),
- DB::raw('count(daily_attendances.start_time < daily_attendances.in_time) AS delay_day'),
- DB::raw(DB::raw('count(*) as present_day')))
- ->whereRaw($where)
- ->groupBy('daily_attendances.card_id')->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement