Trait.php

<?PHP
namespace App\Model\Table\Extra;
use Cake\ORM\Query

trait DatesTrait{
  
 public function findSeteDias(Query $query,array $options){
   $alias = $this->alias();
   $query->where([
     "{$alias}.data >"=>date('Y-m-d',strtotime("-7 days")),
     "{$alias}.data <"=>"NOW()",
   ]);
   return $query;
 } 
 
 public function findTrintaDias(Query $query,array $options){
   $alias = $this->alias();
   $query->where([
     "{$alias}.data >"=>date('Y-m-d',strtotime("-30 days")),
     "{$alias}.data <"=>"NOW()"
    ]);
 }
  
}