Convert Custom Query in Laravel

select * from employeedetails as ed LEFT JOIN (SELECT * FROM `punchreports` where date="2018-12-03") as pr on ed.emp_id = pr.emp_id where ed.status="Active"

Can I convert this query in Eloquent ?

How to execute this query in Laravel Controller?

Palak27

7 years ago

Level 3

@kshitizmittal

you have to make two Eloquent model one is Employee and second is Reports

in employee model define the relationship with report

if employee has many reports than relationship will be

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

and query will be

Employee::with([    
    'punchreports' => function($query) {
          $query->where('date',"2018-12-03)
    }

])->where('status',"Active")->get();

1 like

Please or to participate in this conversation.