maneeahrao

maneeahrao

Member Since 1 Year Ago

Experience Points 130
Experience Level 1

4,870 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed 0
Lessons
Completed
Best Reply Awards 0
Best Reply
Awards
  • Start Your Engines Achievement

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • First Thousand Achievement

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • One Year Member Achievement

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • Two Year Member Achievement

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • Three Year Member Achievement

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • Four Year Member Achievement

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • Five Year Member Achievement

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • School In Session Achievement

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • Welcome To The Community Achievement

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • Full Time Learner Achievement

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • Pay It Forward Achievement

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • Subscriber Achievement

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • Lifer Achievement

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • Laracasts Evangelist Achievement

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • Chatty Cathy Achievement

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • Laracasts Veteran Achievement

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • Ten Thousand Strong Achievement

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • Laracasts Master Achievement

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • Laracasts Tutor Achievement

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • Laracasts Sensei Achievement

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • Top 50 Achievement

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

15 Mar
1 year ago

maneeahrao left a reply on Getting Error During Laravel Raw Query Execution

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

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

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

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

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

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

I am getting error when I used selectRaw.

maneeahrao started a new conversation Getting Error During Laravel Raw Query Execution

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)