组织机构树

最新推荐文章于 2024-05-09 09:20:51 发布

H_MZ

最新推荐文章于 2024-05-09 09:20:51 发布

阅读量681

点赞数

文章标签： python 数据库 java

原文链接：https://my.oschina.net/u/3053442/blog/823277

版权

2019独角兽企业重金招聘Python工程师标准>>>

实体类

public class TreeVO {

   private String id;
   private String text;
   private String state;
   private String parentId;
   private Map<String, Object> attributes;// 其他参数
   private List<TreeVO> children = new ArrayList<TreeVO>();
   private boolean checked;

Action :

   public String companyUI(){
       List list = new ArrayList();
       list = findOrgTreeList();
       JSONArray jsonArray = JSONArray.fromObject(list);
       System.out.println(list.toString()+"====="+jsonArray);
       request.setAttribute("orgTreeList", jsonArray.toString());
       return "companyUI";
   }

public List findOrgTreeList() {
       List<TreeVO> tree = new ArrayList<TreeVO>();
       try {
           String puuid = UserUtil.getPersonUuid();
           Map person = getPersonOrg(puuid);
           String unitCode = "";
           String unitName = "";
           unitCode = (String) person.get("UNIT_CODE");
           unitName = (String) person.get("UNIT_NAME");

           TreeVO vo = new TreeVO();
           vo.setId(unitCode);
           vo.setText(unitName);
           vo.setChecked(false);
           List<TreeVO> children = findOrgTreeChildList(unitCode);
           if (children!=null&&children.size() > 0) {
               vo.setState("closed");
               vo.setChildren(children);
           } else {
               vo.setState("opened");
           }
           tree.add(vo);
       } catch (Exception e) {
           LogUtil.error(e);
           e.printStackTrace();
       }
       return tree;
   }

private List<TreeVO> findOrgTreeChildList(String orgCode) {
       List<Map> list = getOrg(orgCode);
       List<TreeVO> tree = new ArrayList<TreeVO>();
       for (Map m : list) {
           String c_orgCode = m.get("ORG_CODE").toString();
           String c_orgName = m.get("ORG_NAME").toString();
           TreeVO vo = new TreeVO();
           vo.setId(c_orgCode);
           vo.setText(c_orgName);
           vo.setChecked(false);
           List<TreeVO> children = findOrgTreeChildList(c_orgCode);
           if (children!=null&&children.size() > 0) {
               vo.setState("closed");
               vo.setChildren(children);
           } else {
               vo.setState("opened");
           }
           tree.add(vo);
       }
       return tree;
   }

BaseAction:

/** 调用例子：
       List list = getOrg("10340001");
   */
   public List getOrg(String parentOrgCode){
       List list = null;
       try{
           list = sqlSessionTemplate.selectList("BaseBean.getOrg",parentOrgCode);
       }catch(Exception ex){
           LogUtil.error(ex);
       }
       return list;
   }

jsp

<textarea id="orgTreeList" style="display:none;">${orgTreeList }</textarea>
       <input type="hidden" id="orgCode" />
       <input type="hidden" id="orgName" />

/*组织结构树*/
function _initOrgTree(data) {
   //alert(data);

   var isFirst = true;
   $('#orgTree').combotree({
       panelHeight:'160',
       panelWidth:'160',
       data:data,
       onLoadSuccess:function(node, data) {
           if(isFirst){
               var root = $("#orgTree").combotree('tree').tree('getRoot');
               $('#orgTree').combotree('setValue',root.id);
               isFirst = false;

               _initDataGrid();
           }
       },
       onSelect:function(node) {
           $('#orgCode').val(node.id);
           $('#orgName').val(node.text);
       }
   });
}

function _initDataGrid(){
   //初始化datagrid数据
   $('#tt').datagrid({
       queryParams: {
           orgCode:$('#orgCode').val(),
           companyName:$('#companyName').val(),
           companyClassify:$('#companyClassify').combobox('getValue')
           //companyType:$('#companyType').combobox('getValue')
       }
   });
}

数据库

<select id="getOrg" parameterType="string" resultType="java.util.HashMap">
       select org_code,parent_org_code, org_name,org_type, org_type_name,orgLevelCode
       from n_m_org
       where parent_org_code = #{parentOrgCode} AND ORG_TYPE = '1' and org_level in ('0','1','2')
       order by org_code
   </select>

效果图：http://pan.baidu.com/s/1kVnv5pP

转载于:https://my.oschina.net/u/3053442/blog/823277