TimeClockService.php

        $beg = date('Y-m-d 00:00:00', strtotime($beg)); //Fixed the bug
        $fin = date('Y-m-d 23:59:59', strtotime($fin));

        $dql = "SELECT DISTINCT(u.id) AS agent_id FROM EcsTimeclockBundle:TimeClock t
                LEFT JOIN t.noteBy u WHERE t.daydate BETWEEN :beg AND :fin AND u.employeejob = :tpe";

        $query = $this->em->createQuery($dql);
        $query->setParameters(array('beg' => $beg, 'fin' => $fin, 'tpe' => $type));