实习列表 __OBgNRqm1iNU27jK0rkk __OBgNRqm1iNU27jK0rkk published UTF-8 get /internship/internshipList json =6 and SUM( a.ITEM_INTERNSHIPDURATION )>=45,'已完成','进行中') as item_state,"+ "IFNULL(COUNT( a.id ),0) AS item_readyDay,ifnull(a.item_needday,6) as item_needday,ifnull(a.item_needtime,45) as item_needtime, IFNULL(SUM( a.ITEM_INTERNSHIPDURATION),0 ) AS ITEM_readyTime from tms.tlk_grade_registration b "+ " inner join tlk_lesson_auth_base_info c on b.id=c.ITEM_AUTHRECORDID and c.ITEM_PROGRESS='100' "+ "left join "+ "tlk_grade_internship a on a.item_internid=b.id and a.item_internshipRecordStatus='1' and ifnull(a.item_isdelete,'') != '1' "+whereStr+//and a.item_internshipRecordStatus='1' " GROUP BY b.id " sql += " limit 1000" var sqlDatas = queryByDSName("tms", sql); return sqlDatas; })()]]>