<!-- 持续信息披露-公告类型 一级 --> <query id="ReportInternalProgressCtrl-reportTypeComTree"> <sql> <![CDATA[ <#if (id?exists)> select t.code as "id", t.value as "text", cast('open' as varchar(6)) as "state" from X27_ENUM t left join x27_dict d on d.dict_id = t.dict_id where d.code =:id order by t.code asc <#else> select t.code as "id", t.name as "text", cast('closed' as varchar(6)) as "state" from x27_dict t where t.code in ('9503', '9504', '9505') order by t.code asc </#if> ]]> </sql> </query>
//查询行业的树结构,默认加载一级行业,点击父类,异步加载二级
public void reportTypeComTree(HttpServletRequest req, HttpServletResponse res) {
String id = req.getParameter("id");
Map searchCondition = new HashMap();
searchCondition.put("id", id);
List<Map> list = publishReportManager.executeSql("ReportInternalProgressCtrl-reportTypeComTree", searchCondition);
CtrlUtils.putJSON(list, res);
}
$('#reportType').combotree({ url:webPath+'/reportTypeComTree.ripc', width:'250', panelHeight:'450' });