dtr_sql = """SELECT name,id_number FROM `tabStudent` WHERE school_year='{0}'""".format(current_school_year())
        print dtr_sql

        for i,dtr in enumerate(frappe.db.sql(dtr_sql, as_dict=True)):
            print i
            exists_sql = """SELECT name FROM `tabDTR`
                            WHERE tabDTR.string_date_log LIKE '{0}%' AND id_number='{1}'"""\
                            .format(filters.get("date"),dtr['id_number'])
            print exists_sql
            exists_dtr = frappe.db.sql(exists_sql)
            print exists_dtr
            if exists_dtr !=():
                data.append(dtr)