@php
$result = DB::table('comm_tbl_smthub_ticket as ku')
->join('comm_action as ju', function ($join) {
$join->on('ku.action_id', '=', 'ju.id')
->where('ku.action_id', '!=', '')
->whereNotIn('ku.action_id', [1, 2, 3, 4]);
})
->select(
'ku.id',
'ku.keys1',
'ku.uid',
'ku.uname',
'ku.upc_id',
'ku.subject',
'ku.from_name',
'ku.from_addr',
'ku.to_name',
'ku.to_addr',
'ku.body',
'ku.action_id',
'ku.notes',
'ku.status',
'ku.request_information',
'ku.tickets_received',
'ku.assigned_to',
'ku.due_date',
'ku.instant_action',
'ku.smart_schedule',
'ku.priority',
'ku.tag_id',
'ku.completed_at',
'ku.internal_thread',
'ku.commentry_assign',
'ku.commentry_user',
'ku.conf_email',
'ku.last_cron_update',
'ku.mail_ck',
'ju.action_name'
)
->where('ku.status', '=', 'Received')
->orderBy('ku.id', 'desc')
->get();
// //select ku.id, ku.keys1, ku.uid, ku.uname, ku.upc_id,
// ku.subject,
// ku.from_name,
// ku.from_addr,
// ku.to_name,
// ku.to_addr,
// ku.body,
// ku.action_id,
// ku.notes,
// ku.status,
// ku.request_information,
// ku.tickets_received,
// ku.assigned_to,
// ku.due_date,
// ku.instant_action,
// ku.smart_schedule,
// ku.priority,
// ku.tag_id,
// ku.completed_at,
// ku.internal_thread,
// ku.commentry_assign,
// ku.commentry_user,
// ku.conf_email,
// ku.last_cron_update,
// ku.mail_ck,
// ju.action_name from comm_tbl_smthub_ticket ku JOIN comm_action ju ON ku.action_id = ju.id and ku.action_id != '' and ku.action_id in (1, 2, 3, 4) and ku.status = "Received" orderby id desc
@endphp