directory.java

oa 源码

package cn.js.fan.module.cms;

import java.sql.*;

import javax.servlet.http.*;

import cn.js.fan.db.*;
import cn.js.fan.security.*;
import cn.js.fan.util.*;
import cn.js.fan.web.*;
import org.apache.log4j.*;
import java.util.Vector;
import java.util.Iterator;
import com.redmoon.oa.pvg.Privilege;



public class Directory implements IDirectory {
    String connname = "";
    Logger logger = Logger.getLogger(Directory.class.getName());

    public Directory() {
        connname = Global.defaultDB;
        if (connname.equals("")) {
            logger.info("Directory:默认数据库名不能为空");
        }
    }

    public boolean AddRootChild(HttpServletRequest request) throws
            ErrMsgException {
        int child_count = 0, orders = 1, parent_orders = 1,
                islocked = 0;
        String root_code = "", name = "", code = "", parent_code = "-1";
        int parent_layer = 1;
        boolean isParentRoot = false; 

        name = ParamUtil.get(request, "name", false);
        if (name == null) {
            throw new ErrMsgException("名称不能为空！");
        }
        code = ParamUtil.get(request, "code", false);
        if (code == null) {
            throw new ErrMsgException("编码不能为空！");
        }
        String description = ParamUtil.get(request, "description");

        root_code = code;

        String insertsql = "insert into directory (code,name,parent_code,description,orders,root_code,child_count,layer) values (";
        insertsql += StrUtil.sqlstr(code) + "," + StrUtil.sqlstr(name) +
                "," + StrUtil.sqlstr(parent_code) +
                "," + StrUtil.sqlstr(description) + "," +
                orders + "," + StrUtil.sqlstr(root_code) + "," +
                child_count + ",1)";

        logger.info(insertsql);
        if (!SecurityUtil.isValidSql(insertsql)) {
            throw new ErrMsgException("请勿输入非法字符如;号等！");
        }
        int r = 0;
        RMConn conn = new RMConn(connname);
        try {
            r = conn.executeUpdate(insertsql);
        } catch (SQLException e) {
            logger.error(e.getMessage());
            throw new ErrMsgException("请检查编码" + code + "是否重复！");
        }
        return r == 1 ? true : false;
    }

    public boolean AddChild(HttpServletRequest request) throws
            ErrMsgException {
        
        int child_count = 0, orders = 1, parent_orders = 1,
                islocked = 0;
        String root_code = "", name = "", code = "", parent_code = "";

        name = ParamUtil.get(request, "name").trim();
        if (name == null || name.equals("")) {
            throw new ErrMsgException("名称不能为空！");
        }
        code = ParamUtil.get(request, "code").trim();
        if (code.equals("")) {
            throw new ErrMsgException("编码不能为空！");
        }
        if (!StrUtil.isSimpleCode(code)) {
            throw new ErrMsgException("编码请使用字母、数字、-或_！");
        }

        parent_code = ParamUtil.get(request, "parent_code").trim();
        if (parent_code.equals("")) {
            throw new ErrMsgException("父结点不能为空！");
        }
        String description = ParamUtil.get(request, "description");
        int type = ParamUtil.getInt(request, "type");
        String pluginCode = ParamUtil.get(request, "pluginCode");
        boolean isSystem = ParamUtil.get(request, "isSystem").equals("1") ? true : false;
        boolean isHome = ParamUtil.get(request, "isHome").equals("true") ? true : false;
        String target = ParamUtil.get(request, "target");

        Privilege privilege = new Privilege();
        LeafPriv lp = new LeafPriv();
        lp.setDirCode(parent_code);
        if (!lp.canUserModify(privilege.getUser(request))) {
            throw new ErrMsgException(SkinUtil.LoadString(request,
                    "pvg_invalid"));
        }

        Leaf lf = new Leaf();
        lf = lf.getLeaf(code);
        if (lf != null && lf.isLoaded()) {
            throw new ErrMsgException("已存在相同编码的节点：" + lf.getName());
        }
        lf = new Leaf();
        lf.setName(name);
        lf.setCode(code);
        lf.setParentCode(parent_code);
        lf.setDescription(description);
        lf.setType(type);
        lf.setPluginCode(pluginCode);
        lf.setSystem(isSystem);
        lf.setIsHome(isHome);
        lf.setTarget(target);

        Leaf leaf = getLeaf(parent_code);
        return leaf.AddChild(lf);
    }

    public void del(HttpServletRequest request, String delcode) throws
            ErrMsgException {
        Privilege privilege = new Privilege();
        LeafPriv lp = new LeafPriv();
        lp.setDirCode(delcode);
        if (!lp.canUserModify(privilege.getUser(request))) {
            throw new ErrMsgException(SkinUtil.LoadString(request,
                    "pvg_invalid"));
        }
        Leaf lf = getLeaf(delcode);
        if (lf == null) {
            throw new ErrMsgException("节点 " + delcode + " 已被删除！");
        }
        lf.del(lf);
    }

    public synchronized boolean update(HttpServletRequest request) throws
            ErrMsgException {
        String code = ParamUtil.get(request, "code", false);
        String name = ParamUtil.get(request, "name", false);
        String description = ParamUtil.get(request, "description");
        boolean isHome = ParamUtil.get(request, "isHome").equals("true") ? true : false;
        int type = ParamUtil.getInt(request, "type");
        if (code == null || name == null) {
            throw new ErrMsgException("code与name项必填！");
        }
        int templateId = ParamUtil.getInt(request, "templateId");
        String parentCode = ParamUtil.get(request, "parentCode");
        String pluginCode = ParamUtil.get(request, "pluginCode");
        boolean isSystem = ParamUtil.get(request, "isSystem").equals("1") ? true : false;
        String target = ParamUtil.get(request, "target");

        Privilege privilege = new Privilege();
        LeafPriv lp = new LeafPriv();
        lp.setDirCode(code);
        if (!lp.canUserModify(privilege.getUser(request))) {
            throw new ErrMsgException(SkinUtil.LoadString(request,
                    "pvg_invalid"));
        }

        Leaf leaf = getLeaf(code); 
        if (!parentCode.equals(leaf.getParentCode())) {
            
            Leaf lf = getLeaf(parentCode); 
            while (lf != null && !lf.getCode().equals(lf.ROOTCODE)) {
                
                String pCode = lf.getParentCode();
                if (pCode.equals(leaf.getCode())) {
                    throw new ErrMsgException("不能将其子节点更改为父节点");
                }
                lf = getLeaf(pCode);
            }
        }

        leaf.setName(name);
        leaf.setDescription(description);
        leaf.setIsHome(isHome);
        leaf.setType(type);
        leaf.setTemplateId(templateId);
        leaf.setPluginCode(pluginCode);
        leaf.setSystem(isSystem);
        leaf.setTarget(target);
        boolean re = false;
        if (leaf.getCode().equals(leaf.ROOTCODE) || parentCode.equals(leaf.getParentCode())) {
            re = leaf.update();
        } else {
            re = leaf.update(parentCode);
        }

        return re;
    }

    public synchronized boolean move(HttpServletRequest request) throws
            ErrMsgException {
        String code = ParamUtil.get(request, "code", false);
        String direction = ParamUtil.get(request, "direction", false);
        if (code == null || direction == null) {
            throw new ErrMsgException("编码与方向项必填！");
        }

        Privilege privilege = new Privilege();
        LeafPriv lp = new LeafPriv();
        lp.setDirCode(code);
        if (!lp.canUserModify(privilege.getUser(request))) {
            throw new ErrMsgException(SkinUtil.LoadString(request,
                    "pvg_invalid"));
        }

        Leaf lf = new Leaf(code);
        return lf.move(direction);
    }


    
    public Menu getMenu(String root_code) throws ErrMsgException {
        Directory dir = new Directory();
        Leaf leaf = dir.getLeaf(root_code);

        Menu menu = new Menu();
        MenuItem mi = new MenuItem();
        menu.addItem(mi);
        mi.setHeadLeaf(leaf);

        Vector children = leaf.getChildren();
        Iterator ir = children.iterator();
        while (ir.hasNext()) {
            Leaf lf = (Leaf) ir.next();
            mi.addChildLeaf(lf);
        }

        return menu;
    }

    public Leaf getLeaf(String code) {
        Leaf leaf = new Leaf();
        return leaf.getLeaf(code);
    }

    public Leaf getBrother(String code, String direction) throws
            ErrMsgException {
        Leaf lf = getLeaf(code);
        return lf.getBrother(direction);
    }

    public Vector getChildren(String code) throws ErrMsgException {
        Leaf leaf = getLeaf(code);
        if (leaf == null || !leaf.isLoaded()) {
            return new Vector();
        }
        return leaf.getChildren();
    }

    
    public String getSubLeaves(String parentCode, int layer) {
        if (layer > 2) {
            return "";
        }

        String str = "";
        LeafChildrenCacheMgr lcc = new LeafChildrenCacheMgr(parentCode);
        Vector v = lcc.getList();
        Iterator ir = v.iterator();
        
        while (ir.hasNext()) {
            Leaf lf = (Leaf) ir.next();
            if (layer == 2) {
                
                lcc = new LeafChildrenCacheMgr(lf.getCode());
                Iterator ir2 = lcc.getList().iterator();
                while (ir2.hasNext()) {
                    lf = (Leaf) ir2.next();
                    if (str.equals("")) {
                        str = StrUtil.sqlstr(lf.getCode());
                    } else {
                        str += "," + StrUtil.sqlstr(lf.getCode());
                    }
                }
            } else {
                if (str.equals("")) {
                    str = StrUtil.sqlstr(lf.getCode());
                } else {
                    str += "," + StrUtil.sqlstr(lf.getCode());
                }
            }

        }
        return str;
    }
}