dimanche 11 août 2019

How to convert SQL into Laravel 5.8 Query Builder

Hello I am new to Laravel and am having a big problem converting the following MYSQL query into a Laravel Query Builder. I am using Laravel 5.8

Here is the working MYSQL query:

SELECT A.SignalID, A.AccountNo, A.Event, A.DateTimeStart, B.Subscriber, B.Address, C.Status, A.ZoneNo, D.ZoneDesc, A.UserNo, E.Fullname, C.Priority, F.EventName, A.Locked, A.LockedOn, CASE B.AccountType WHEN 'AWACS' THEN 'Network' ELSE 'Security' END AS AlarmType, A.SourceID " & _
 " FROM tblSignals A WITH(NOLOCK) " & _
 " LEFT JOIN tblAccounts B WITH(NOLOCK) ON (A.AccountNo=B.AccountNo) " & _
 " LEFT JOIN tblEventQualifier C WITH(NOLOCK) ON (A.Event=C.EventCode AND A.Qualifier=C.Qualifier) " & _
 " LEFT JOIN tblAccountZones D WITH(NOLOCK) ON (A.AccountNo=D.AccountNo AND A.ZoneNo=D.ZoneNo) " & _
 " LEFT JOIN tblAccountUsers E WITH(NOLOCK) ON (A.AccountNo=E.AccountNo AND A.UserNo=E.UserNo) " & _
 " LEFT JOIN tblEvents F WITH(NOLOCK) ON (A.Event=F.EventCode) " & _
 " WHERE ((ISNUMERIC(a.ZoneNo) = 1) OR (COALESCE(a.ZoneNo, '') = '')) AND A.Status=0 AND A.Event <> '602'



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire