Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $users = DB::table('user_form_submission')
- ->join('recommend_email_send_by_cron', 'recommend_email_send_by_cron.user_id','=','user_form_submission.id')
- ->addselect('recommend_email_send_by_cron.business_id as businessId',
- 'recommend_email_send_by_cron.email as email',
- 'user_form_submission.id as userId',
- 'recommend_email_send_by_cron.name as name',
- 'recommend_email_send_by_cron.status as status',
- 'recommend_email_send_by_cron.sign_in_data as sign_in_time',
- 'recommend_email_send_by_cron.sent_time as mail_sent_time',
- 'user_form_submission.created_at as created_at',
- 'user_form_submission.form_id as formId')
- ->selectRaw(
- DB::raw("(CASE WHEN (select user_id from recommend_feedback_details where (recommend_email_send_by_cron.user_id = user_id) && (recommend_email_send_by_cron.business_id = business_id)) THEN recommend_feedback_details.feedback ELSE 'No' END) as message")
- )
- ->where('user_form_submission.business_id', '=', $businessId);
- $users = $users->get();
Add Comment
Please, Sign In to add comment