Breaking News: Grepper is joining You.com. Read the official announcement!

convert sql query to laravel eloquent

@CodeGrepperManu answered on August 25, 2022 Popularity 10/10 Helpfulness 1/10

answer convert sql query to laravel eloquent

convert sql query to laravel eloquent

Comment

//Ref: https://jjlabajo.github.io/SQLtoEloquent/

SELECT emp.*, dep.department_name, al.emp_id, al.auth_date, min(al.auth_time) as 'check_in', 
max(al.auth_time) as 'check_out' FROM employees as emp
LEFT JOIN attendance_log as al ON emp.device_emp_id = al.emp_id
JOIN departments as dep ON emp.department_id = dep.id
WHERE al.emp_id IN $emp_id   // $emp_id is an array of employee's ID
WHERE date(al.auth_date) BETWEEN $start_date AND $end_date
GROUP BY emp.device_emp_id, date(al.auth_date_time)

After Convert:
DB::table("employees as emp")
->leftJoin("attendance_log as al", function($join){
	$join->on("emp.device_emp_id", "=", "al.emp_id");
})
->join("departments as dep", function($join){
	$join->on("emp.department_id", "=", "dep.id");
})
->select("emp.*", "dep.department_name", "al.emp_id", "al.auth_date", "min (al.auth_time) as 'check_in'", "max (al.auth_time) as 'check_out'")
->whereIn("al.emp_id", "$emp_id")
->groupBy("emp")
->get();

Popularity 10/10 Helpfulness 1/10 Language sql

Source: jjlabajo.github.io

Tags: eloquent laravel sql

Link to this answer
Share Copy Link

Contributed on Aug 25 2022

@CodeGrepperManu

0 Answers Avg Quality 2/10

convert sql query to laravel eloquent

Contents

More Related Answers

convert sql query to laravel eloquent

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.