dotphp

Query Custom laravel

Sep 27th, 2016
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.53 KB | None | 0 0
  1. $data = DB::select(DB::raw(
  2.         "SELECT *
  3.         FROM (
  4.             SELECT
  5.                 calls.*,
  6.                 sys_rel.rel_to_module as module_name,
  7.                 sys_rel.rel_to_id as module_id,
  8.                 ( SELECT concat( leads.leads_first_name,' ', leads.leads_last_name)
  9.                  FROM leads
  10.                  WHERE leads.leads_serial_id =  module_id ) as rel_sys_name
  11.             FROM calls
  12.             JOIN sys_rel ON sys_rel.rel_serial_id = calls.rel_serial_id
  13.             WHERE sys_rel.rel_to_module = 'leads' AND calls.rel_serial_id  > 0
  14.                
  15.                 UNION ALL
  16.                
  17.             SELECT
  18.                 calls.*,
  19.                 sys_rel.rel_to_module as module_name,
  20.                 sys_rel.rel_to_id as module_id,
  21.                 ( SELECT concat( contacts.contacts_first_name,' ', contacts.contacts_last_name)
  22.                  FROM contacts
  23.                  WHERE contacts.contacts_serial_id =  module_id ) as rel_sys_name
  24.             FROM calls
  25.             JOIN sys_rel ON sys_rel.rel_serial_id = calls.rel_serial_id
  26.             WHERE sys_rel.rel_to_module = 'contacts' AND calls.rel_serial_id  > 0
  27.                
  28.                 UNION ALL
  29.                
  30.             SELECT
  31.                 calls.*,
  32.                 sys_rel.rel_to_module as module_name,
  33.                 sys_rel.rel_to_id as module_id,
  34.                 ( SELECT org_name
  35.                  FROM org
  36.                  WHERE org.org_serial_id =  module_id ) as rel_sys_name
  37.             FROM calls
  38.             JOIN sys_rel ON sys_rel.rel_serial_id = calls.rel_serial_id
  39.             WHERE sys_rel.rel_to_module = 'org' AND calls.rel_serial_id  > 0
  40.                
  41.         ) as datatable
  42.         order by rel_sys_name DESC"));
Advertisement
Add Comment
Please, Sign In to add comment