repofunction.php

    public function pruneEntitiesOlderThan($cutoffTime)
    {
        return $this->createQueryBuilder('w')
            ->delete()
            ->join('w.lot', 'l')
            ->where('l.sale_date < :cutoff_time')
            ->setParameter('cutoff_time', strtotime('-'.$cutoffTime.' day'))
            ->getQuery()
            ->getResult();
    }