班级安排 __hGBmZIJlszexS9jEYx0 __LgZds5MVHW3o08T7UcX 培训计划 true 10 true false false false 2025-04-22T14:58:40.000+08:00 false templateForm month normal false 0 __uPJ6aSWRv6rvXtYA6Ft true __M67R55VbkQxkPEuvJgc __AaCzv6DhxXwvLTBAWW3 public = '"+format(train_time,"yyyy-MM-dd")+"' " } var submit_start_time = getItemValueAsDate("submit_start_time"); if(isNotNull(submit_start_time)){ whereStr = whereStr + " and DATE_FORMAT(p.item_submit_time, '%Y-%m-%d') >= '"+format(submit_start_time,"yyyy-MM-dd")+"' " } var submit_end_time = getItemValueAsDate("submit_end_time"); if(isNotNull(submit_end_time)){ whereStr = whereStr + " and DATE_FORMAT(p.item_submit_time, '%Y-%m-%d') <= '"+format(submit_end_time,"yyyy-MM-dd")+"' " } var sql="select domainid,id,created,formid,item_plan,item_point_type,item_train_start_time,item_train_end_time,item_domain_name,"+ "concat(DATE_FORMAT(item_train_start_time, '%Y年%m月%d日'),'~',DATE_FORMAT(item_train_end_time, '%Y年%m月%d日')) as item_train_time,"+ "item_audit_status,item_audit_info,item_submit_time "+ " from tlk_train_plan p where item_audit_status='审核通过' "+whereStr+ "order by created desc " return sql })()]]> [] 277 02 0 0