public List<String> distinctDutyDate() {

        String hql="select distinct(dutyDate) from DoctorDuty";

        Query query=getSession().createQuery(hql);

        List list= query.list();

        Iterator it= list.iterator();

        List<String> list1=new ArrayList<String>();

        while(it.hasNext()){

            String dutyDate=it.next()+"";

            list1.add(dutyDate);

        }

        return list1;

    }

public List<YearMonthDTO> getYearMonthByUserId(Integer userId, String submitType) {

        String hql="select submitYear,submitMonth from TotalBranchSubmit where userId=:userId and submitType=:submitType group by submitYear,submitMonth ";

        Query query = getSession().createQuery(hql)

                .setParameter("userId",userId)

                .setParameter("submitType",submitType);

        List list= query.list();

        Iterator it= list.iterator();

        List<YearMonthDTO> list1=new ArrayList<>();

        while(it.hasNext()){

            Object[] res=(Object[]) it.next();

            YearMonthDTO dto=new YearMonthDTO();

            String year=res[0]+"";

            String month=res[1]+"";

            dto.setYear(year);

            dto.setMonth(month);

            list1.add(dto);

        }

        return list1;

    }