I have three table 1)allcasefileofuserrequest 2)allscanfileofuserrequest 3)userrequestforcasecopies
a) userrequestforcasecopies->allcasefileofuserrequest has one to many relationship
b) userrequestforcasecopies->allscanfileofuserrequest has one to many relationship c)id(primary key) in userrequestforcasecopies -> request_id(foreign key) in allcasefileofuserrequest
d)id(primary key) in userrequestforcasecopies -> request_id(foreign key) in allscanfileofuserrequest
I want to write sql query such that in where exist clause get record from allcasefileofuserrequest and allscanfileofuserrequest where approved_status is 1.Below Is my query in laravel 5.5
DB::table('userrequestforcasecopies')
->where('id',$requestId)
->where('first_approved_status',2)
->whereExists(function($query) use($requestId)
{
$query->from('allcasefileofuserrequest')
->fullJoin('allscanfileofuserrequest')
->where('request_id', $requestId)
->where('approved_status',1)
->select('request_id')
->get();
})
->update(['second_approved_status'=> 1,
'second_approved_status_done_at' => Carbon::now()->format('Y-m-d H:i:s'),
'updated_at' => Carbon::now()->format('Y-m-d H:i:s')
]);
But full join not work on laravel 5.5
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire