Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. public static function getNextInspections()
  2. {
  3. $inspection = DB::table('inspection');
  4. $inspection->select('*');
  5. $inspection ->where('next_inspection_date', DB::raw('BETWEEN NOW() AND DATE_ADD(NOW(),INTERVAL 30 DAY)'));
  6. return $inspection->get();
  7.  
  8. $inspection ->whereBetween('next_inspection_date ', array(Carbon::now(), Carbon::now()->addMonth(1)));
  9.  
  10. $inspection ->whereBetween('next_inspection_date ', array(now(), now()->addMonth(1)));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement