gistfile1.php

$date_start = \DateTime::createFromFormat('d/m/Y', $data['date_start']);
        $date_end = \DateTime::createFromFormat('d/m/Y', $data['date_end']);
        
        $qb =  $em->createQueryBuilder();
        $params = $paramsProfiles = array('date_start' => $date_start, 'date_end' => $date_end);

        $qb->select('count(p.id) as v, c.name, p.percent')
           ->from('CodeSquad\Model\Progress', 'p')
           ->innerJoin('p.course', 'c')
           ->where('p.created > :date_start and p.created < :date_end')
           ->groupBy('c.name, p.percent')
           ->orderBy('v', 'DESC');
        
        $progressCourses = $qb->setParameters($params)->getQuery()->execute();
        $qb =  $em->createQueryBuilder();
        $qb->select('count(p.id) as v, l.name as lesson_name, c.name as course_name, p.percent')
           ->from('CodeSquad\Model\Progress', 'p')
           ->innerJoin('p.lesson', 'l')
           ->innerJoin('l.course', 'c')
           ->where('p.created > :date_start and p.created < :date_end')
           ->groupBy('lesson_name, course_name, p.percent')
           ->orderBy('v', 'DESC');
        
        $progressLessons = $qb->setParameters($params)->getQuery()->execute();