Laravel q- where between dates

Question

I am trying to get my cron to only get Projects that are due to recur renew in the next 7 days to send out reminder emails  I ve just found out my logic doesn t quite work   I currently have the query    projects   Project  where function  q        q- gt where  recur at     gt    date  Y-m-d H i s   time   - 604800         q- gt where  status     lt    5        q- gt where  recur cancelled        0         However  I realized what I need to do is something like   Psudo SQL   SELECT   FROM projects WHERE recur at  gt  recur at -  7 days  AND    Other status   recurr cancelled stuff       How would I do this in Laravel 4  and using the DATETIME datatype  I ve only done this sort of thing using timestamps    Update   Managed to solve this after using the following code  Stackoverflow also helps when you can pull bits of code and look at them out of context    projects   Project  where function  q        q- gt where DB  raw  recur at BETWEEN DATE SUB NOW    INTERVAL 7 DAY  AND NOW            q- gt where  status     lt    5        q- gt where  recur cancelled        0         Updated Question  Is there better way to do this in Laravel Eloquent   Update 2   The first resolution ended up not been right after further testing  I have now resolved and tested the following solution    projects   Project  where function  q        q- gt where  recur at     lt     Carbon  now  - gt addWeek          q- gt where  recur at          0000-00-00 00 00 00         q- gt where  status     lt    5        q- gt where  recur cancelled        0

User · Answer

Tom   Instead of using  now  or  addWeek  if we provide date in following format  it does not give correct records   projects   Project  whereBetween  recur at   array new DateTime  2015-10-16    new DateTime  2015-10-23     - gt where  status     lt    5  - gt where  recur cancelled        0  - gt get      it gives records having date form 2015-10-16 to less than 2015-10-23  If value of recur at is 2015-10-23 00 00 00 then only it shows that record  else if it is 2015-10-23 12 00 45 then it is not shown

User · Answer

You can chain your wheres directly  without function q   There s also a nice date handling package in laravel  called Carbon  So you could do something like    projects   Project  where  recur at     gt    Carbon  now        - gt where  recur at     lt    Carbon  now  - gt addWeek        - gt where  status     lt    5      - gt where  recur cancelled        0      - gt get      Just make sure you require Carbon in composer and you re using Carbon namespace  use Carbon Carbon   and it should work   EDIT  As Joel said  you could do    projects   Project  whereBetween  recur at   array Carbon  now    Carbon  now  - gt addWeek         - gt where  status     lt    5      - gt where  recur cancelled        0      - gt get

User · Answer

Edited  Kindly note that whereBetween  date   start date  end date  is inclusive of the first date

User · Answer

Didn t wan to mess with carbon  So here s my solution   start   new  DateTime  now     start- gt modify  first day of this month     end   new  DateTime  now     end- gt modify  last day of this month      new releases   Game  whereBetween  release   array  start   end  - gt get

[php] Laravel $q->where() between dates

Examples related to php

Examples related to mysql

Examples related to laravel

Examples related to eloquent

Examples related to datetime-format