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