Level 102
You will need to order by raw and manually write a case statement https://stackoverflow.com/a/39941031
But wouldn't it be easier to just remove the featured flag when the expiry date is lesser than the present date. (scheduled job)?
1 like
Sep 28, 2022
16
Level 5
list properties ordered by featured...?
I need to show listings sorted by the responses_count but need featured listings on the top. 'featured' is a field in the listings table with a date of expiry of the featured facility. So need to consider featured only if the expiry date is greater than the present date.
Controller
$listingsforsale = Listings::where('project_id', '<>', NULL)
->where('expiry_date','>' , now())
->where('listingtype', 1)
->where('dealstatus',1)
->where('status',1)
->withCount('response')
->orderBy('response_count', 'desc')
->orderBy('featured', 'DESC')->latest()
->paginate(10);
How to do that ?
Level 5
@Sinnbeck Thanks.
Or shall I create a ne model just for featured ? with expiry date ? Will it work to will it make more complicated ?
Level 102
@FounderStartup probably about the same. If it was on a different table I might try a left join on that table and restrict it to expired_at in the future (meaning it would be null otherwise). But it will still require some "custom" sql
1 like
Level 102
But setting them as no longer being featured isn't a solution?
1 like
Level 5
@Sinnbeck Yes chief... :) that will be a better idea. Can you share a link on how to use a scheduler for this type of work ? :)
Level 102
@FounderStartup first write a command that does it. Then add that command to a schedule. https://laravel.com/docs/9.x/scheduling#defining-schedules It could run every hour perhaps?
1 like
Level 5
@Sinnbeck Thanks Chief.... cheers !
Level 5
Just need a minor clarification :
What I have understood is that
- I need to create a class with artisan command like php artisan make:command sendWeeklyReport
This will have then code for the required functionality.
- Then add code in App\Console\Kernal.php.
To run on the local : the command is - php artisan schedule:work
Is it correct ? How will I run this on production server ? Do I need to create a cron ?
Level 102
@FounderStartup That can be use for sending the weekly report. My suggestion was to also make a command RemoveFeaturedFromExpiredListings that is run every hour :)
But locally you can use schedule:work, but on production you need to set up cron :)
1 like
Level 5
@Sinnbeck I just mentioned a demo name. I am doing just what you suggested. Thanks gain :)
Level 102
@FounderStartup Any time :) Happy to help
Level 5
@Sinnbeck Hey chief. Need a bit of help here.
I have configured the scheduler and its working fine on the local. What exactly I need to do on the production server ?
Do I need to run the command php artisan schedule:work through crone or what to do ?
Level 102
@FounderStartup On production you use schedule:run in a cron job :)
* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1
1 like
Level 5
are the commands php artisan schedule:run and php artisan schedule:work are same ?
Level 102
@FounderStartup Not quite
- run = check what needs to be run and exit afterwards
- work = keep running forever but check every minute (cannot be used with cron)
1 like
Level 5
@Sinnbeck OK. Thanks a lot .
Please or to participate in this conversation.