if (!empty($data['milestone']) || !empty($data['fmDateFrom']) || !empty($data['fmDateTo'])) {
                $query
                    ->leftJoin('s.milestones', 'ms');

                if ($data['milestone']) {
                    if ($data['milestone'] == 'incomplete') {
                        $query
                            ->andWhere('ms.date <= :date and ms.progress < 100');
                    } elseif ($data['milestone'] == 'complete') {
                        $query
                            ->andWhere('ms.date <= :date');
                    }
                    $query
                        ->setParameter('date', date('Y-m-d'));
                }

                if (!empty($data['fmDateFrom'])) {
                    if (empty($data['fmDateTo'])) {
                         $query
                            ->andWhere('ms.date >= :from')
                            ->setParameter('from', $data['fmDateFrom']);
                    } else {
                         $query
                            ->andWhere('ms.date >= :from and ms.date <= :to')
                            ->setParameter('to', $data['fmDateTo'])
                            ->setParameter('from', $data['fmDateFrom']);
                    }

                if (!empty($data['to_milestone']) && empty($data['from_milestone'])) {
                    $query
                        ->andWhere('ms.date <= :to')
                        ->setParameter('to', $data['fmDateTo']);
                }
            }

            if (!empty($data['status'])) {
                $statusArray = array(
                    'green' => '(a.rating <= 10 and a.rating >=8)',