maneeahrao

Experience

130

0 Best Reply Awards

  • Member Since 4 Months Ago
  • 0 Lessons Completed
  • 0 Favorites

15th March, 2018

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

If I will use the Join then firstly Query filter the data. then how can I set the value "No" if nothing will found?

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

But my requirement is not to print "Yes". I need to show the message which is saved in table. if userId exists on recommend_feedback_details table if not then leave as "No". Please help me with more solution. It would be great for me.

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

The table name and column already exists. In case I am printing the "Yes" on the place of 'recommend_feedback_details.feedback' then it is working fine, but when I goes to put row value i.e feedback. it gives me error

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

This is my current code.

https://pastebin.com/wPVkBrY0

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

Thanks for the reply.

I have made changes as you said but getting error with undefined columns.

https://pastebin.com/day9Fb8Y

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

I have pasted the error after using the selectRaw();

https://pastebin.com/1p5NeaTv

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

I have paste the SQL query as you suggest to remove the the get() and include toSql().

https://pastebin.com/mDfiRsNc

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution • 4 months ago

I am getting error when I used selectRaw.

maneeahrao started a new conversation Getting Error During Laravel Raw Query Execution • 4 months ago

I am using CASE to check the users is exists and set the value "Yes" and "No" But when I fetching the row value ie. feedback from recommend_feedback_details table getting error.

$users = DB::table('user_form_submission') ->join('recommend_email_send_by_cron', 'recommend_email_send_by_cron.user_id','=','user_form_submission.id') ->select('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', DB::raw("(CASE WHEN (select user_id from track_button_events where (recommend_email_send_by_cron.user_id = user_id) && (recommend_email_send_by_cron.business_id = business_id)) THEN 'Yes' ELSE 'No' END) as noButtonClicked"), 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 '' END) as message"), DB::raw("(CASE WHEN (select user_id from recommend_yes_button_track where (recommend_email_send_by_cron.user_id = user_id) && (recommend_email_send_by_cron.business_id = business_id)) THEN 'Yes' ELSE 'No' END) as yesButtonClicked"), DB::raw("(CASE WHEN (recommend_email_send_by_cron.status= 'sent') THEN 'Yes' ELSE '' END) as mail_sent" ) ->where('user_form_submission.business_id', '=', $businessId) ->get();

    print_r($users)
Edit Your Profile
Update

Want to change your profile photo? We pull from gravatar.com.