Level 12
What error does it gives?
I do not know where to put pagination method in the below query, I have tried to replace it with get() but it gives me error. Can anyone help me please?
$search_result= Project::join('project__reports','projects.id','=','project__reports.project_id')
->select(array('projects.*', 'project__reports.status',
'project__reports.notes','project__reports.prgs_prc','project__reports.prgs_prc_2',
'project__reports.Registered_date',
'project__reports.added_days','project__reports.added_fund',
'project__reports.final_fund','project__reports.final_date'))
->orderBy('project__reports.id','ASC')
->latest('project__reports.id')->get()->keyBy('id');
Please or to participate in this conversation.