cetdz/src/com/ccgj/platform/columns/LMBAction.java

package com.ccgj.platform.columns;

import com.base.common.enums.Enums;
import com.base.common.spring.TransactionManager;
import com.ccgj.database.beans.LMB;
import com.ccgj.database.beans.YHB;
import com.ccgj.database.beans.ZDB;
import com.ccgj.database.business.LMBService;
import com.ccgj.database.business.ZDBService;
import com.ccgj.database.factory.DatabaseFactory;
import com.ccgj.database.interfaces.LMBIF;
import com.ccgj.database.interfaces.ZDBIF;
import com.ccgj.database.manager.LMBManager;
import com.ccgj.database.manager.ZDBManager;
import com.ccgj.platform.admin.WZBAction;
import com.ccgj.platform.common.CommonAction;
import com.ccgj.platform.util.DateFormat;
import com.ccgj.platform.util.JsonResult;
import com.ccgj.platform.util.Logger;
import com.ccgj.platform.util.SystemUtil;
import com.opensymphony.xwork2.ActionContext;

import java.io.PrintStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.StringTokenizer;

import javax.servlet.http.HttpServletRequest;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

public class LMBAction
        extends CommonAction {
    private Long id;
    private String lmmc;
    private String zxdz;
    private String btype;
    private String bidx;
    private String blink;
    private String bpass;
    private String glidx;
    private String bgltype;
    private String lmfp;
    private String blm;
    private String wzpx;
    private int dhlm = 0;
    private int xssx = 0;
    private String lmlx;
    private int lmzt = 0;
    private String zdbs;
    private int fwcs = 0;
    private int lmjs = 0;
    private String lmsm;
    private String flmid;
    private String jtymc;
    private String tjsj;
    private String by1;
    private String by2;
    private String by3;
    private String fjdz;
    private Object[] datas;
    private String data;
    private LMB lmb;
    private List<ZDB> zdbList;
    private String zdbId;
    private String searchLmmc;
    private static final long serialVersionUID = 1L;
    JSONArray objArray;
    private boolean extendFlag;
    LMBIF lmbIf = DatabaseFactory.getLMBIF();
    JSONObject object;

    public JSONArray getObjArray() {
        return this.objArray;
    }

    public void setObjArray(JSONArray objArray) {
        this.objArray = objArray;
    }

    public Long getId() {
        return this.id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getLmmc() {
        return this.lmmc;
    }

    public void setLmmc(String lmmc) {
        this.lmmc = lmmc;
    }

    public String getZxdz() {
        return this.zxdz;
    }

    public void setZxdz(String zxdz) {
        this.zxdz = zxdz;
    }

    public String getBtype() {
        return this.btype;
    }

    public void setBtype(String btype) {
        this.btype = btype;
    }

    public String getBidx() {
        return this.bidx;
    }

    public void setBidx(String bidx) {
        this.bidx = bidx;
    }

    public String getBlink() {
        return this.blink;
    }

    public void setBlink(String blink) {
        this.blink = blink;
    }

    public String getBpass() {
        return this.bpass;
    }

    public void setBpass(String bpass) {
        this.bpass = bpass;
    }

    public String getGlidx() {
        return this.glidx;
    }

    public void setGlidx(String glidx) {
        this.glidx = glidx;
    }

    public String getBgltype() {
        return this.bgltype;
    }

    public void setBgltype(String bgltype) {
        this.bgltype = bgltype;
    }

    public String getLmfp() {
        return this.lmfp;
    }

    public void setLmfp(String lmfp) {
        this.lmfp = lmfp;
    }

    public String getBlm() {
        return this.blm;
    }

    public void setBlm(String blm) {
        this.blm = blm;
    }

    public String getWzpx() {
        return this.wzpx;
    }

    public void setWzpx(String wzpx) {
        this.wzpx = wzpx;
    }

    public int getDhlm() {
        return this.dhlm;
    }

    public void setDhlm(int dhlm) {
        this.dhlm = dhlm;
    }

    public int getXssx() {
        return this.xssx;
    }

    public void setXssx(int xssx) {
        this.xssx = xssx;
    }

    public String getLmlx() {
        return this.lmlx;
    }

    public void setLmlx(String lmlx) {
        this.lmlx = lmlx;
    }

    public int getLmzt() {
        return this.lmzt;
    }

    public void setLmzt(int lmzt) {
        this.lmzt = lmzt;
    }

    public String getZdbs() {
        return this.zdbs;
    }

    public void setZdbs(String zdbs) {
        this.zdbs = zdbs;
    }

    public int getFwcs() {
        return this.fwcs;
    }

    public void setFwcs(int fwcs) {
        this.fwcs = fwcs;
    }

    public int getLmjs() {
        return this.lmjs;
    }

    public void setLmjs(int lmjs) {
        this.lmjs = lmjs;
    }

    public String getLmsm() {
        return this.lmsm;
    }

    public void setLmsm(String lmsm) {
        this.lmsm = lmsm;
    }

    public String getFlmid() {
        return this.flmid;
    }

    public void setFlmid(String flmid) {
        this.flmid = flmid;
    }

    public String getJtymc() {
        return this.jtymc;
    }

    public void setJtymc(String jtymc) {
        this.jtymc = jtymc;
    }

    public String getTjsj() {
        return this.tjsj;
    }

    public void setTjsj(String tjsj) {
        this.tjsj = tjsj;
    }

    public String getBy1() {
        return this.by1;
    }

    public void setBy1(String by1) {
        this.by1 = by1;
    }

    public String getBy2() {
        return this.by2;
    }

    public void setBy2(String by2) {
        this.by2 = by2;
    }

    public String getBy3() {
        return this.by3;
    }

    public void setBy3(String by3) {
        this.by3 = by3;
    }

    public String getFjdz() {
        return this.fjdz;
    }

    public void setFjdz(String fjdz) {
        this.fjdz = fjdz;
    }

    public String getZdbId() {
        return this.zdbId;
    }

    public void setZdbId(String zdbId) {
        this.zdbId = zdbId;
    }

    public String getSearchLmmc() {
        return this.searchLmmc;
    }

    public void setSearchLmmc(String searchLmmc) {
        this.searchLmmc = searchLmmc;
    }

    public Object[] getDatas() {
        return this.datas;
    }

    public void setDatas(Object[] datas) {
        this.datas = datas;
    }

    public String getData() {
        return this.data;
    }

    public void setData(String data) {
        this.data = data;
    }

    public LMB getLmb() {
        return this.lmb;
    }

    public void setLmb(LMB lmb) {
        this.lmb = lmb;
    }

    public List<ZDB> getZdbList() {
        return this.zdbList;
    }

    public void setZdbList(List<ZDB> zdbList) {
        this.zdbList = zdbList;
    }

    public String init()
            throws Exception {
        YHB yhbBean = (YHB) ActionContext.getContext().getSession().get("zfmb_user");
        List<Map> list = new ArrayList<Map>();
        if (this.extendFlag) {
            list = this.lmbIf.getLMBService().getLmbManager().toJsonByExpandLMB(yhbBean.getZdbs());
        } else {
            list = this.lmbIf.getLMBService().getLmbManager().toJsonByLMB(yhbBean.getZdbs());
        }
        this.objArray = JSONArray.fromObject(list);
        return "init";
    }

    public String columnsList() {
        YHB yhbBean = (YHB) ActionContext.getContext().getSession().get("zfmb_user");
        try {
            LMBIF lmbIF = DatabaseFactory.getLMBIF();
            LMB lmbBean = lmbIF.createLMB();
            if ((this.searchLmmc != null) && (this.searchLmmc.length() > 0)) {
                lmbBean.setLmmc(this.searchLmmc);
            }
            if ((this.flmid != null) && (this.flmid.equals("1"))) {
                lmbBean.setLmjs(1);
                lmbBean.setFlmid(this.flmid);
            } else {
                lmbBean.setFlmid(this.flmid);
            }
            lmbBean.setLmzt(3);

            lmbBean.setZdbs(yhbBean.getZdbs());
            List lists = new ArrayList();

            List listCount = lmbIF.getLMBService().getLmbManager().searchListLmbByBean(lmbBean);
            List<LMB> listData = lmbIF.getLMBService().getLmbManager().searchListLmbByBean(lmbBean);
            for (int i = 0; i < listData.size(); i++) {
                LMB lmb = (LMB) listData.get(i);
                lists.add(lmb);
            }
            setJsondata(JsonResult.listByLigerUI(lists, Integer.valueOf(listCount.isEmpty() ? 0 : listCount.size())).toString());
        } catch (Exception e) {
            e.printStackTrace();
            setJsondata(JsonResult.submit(Boolean.valueOf(false), Enums.getInstance().getDescByName("CommonMessage", "SYSTEM_ERROR")));
        }
        return "list";
    }

    /**
     * 添加保存栏目
     * */
    public String saveColumns() {
        int lmjs = 0;
        YHB yhbBean = (YHB) ActionContext.getContext().getSession().get("zfmb_user");
        try {
            Date data = new Date();
            LMBIF lmbIF = DatabaseFactory.getLMBIF();
            ZDBIF zdbIF = DatabaseFactory.getZDBIF();

            lmbIF.getLMBService().getTransactionManager().begin();
            LMB lmbBean = lmbIF.createLMB();
            if ((this.flmid != null) && (this.flmid.length() > 1)) {
//                Long flmidOrYes = lmbIF.getLMBService().getLmbManager().selectCount(this.flmid);
                Long lmbId = lmbIF.getLMBService().getLmbManager().selectMaxId();
                LMB lmb = (LMB) lmbIF.getLMBService().getLmbManager().searchByID(Long.valueOf(Long.parseLong(this.flmid)));
                if (lmb.getLmjs() > 0) {
                    lmjs = lmb.getLmjs() + 1;
                }
                lmbBean.setId(lmbId);
                lmbBean.setLmjs(lmjs);
                lmbBean.setFlmid(this.flmid);

                lmbBean.setTjsj(DateFormat.shortDate(data));
            } else {
//                Long flmidOrNo = lmbIF.getLMBService().getLmbManager().selectCount(this.flmid);
                Long lmbId = lmbIF.getLMBService().getLmbManager().selectMaxId();
                lmbBean.setId(lmbId);
                lmbBean.setLmjs(1);
                lmbBean.setFlmid("1");
            }
            lmbBean.setLmmc(this.lmmc);
            lmbBean.setDhlm(this.dhlm);
            lmbBean.setLmzt(this.lmzt);
            lmbBean.setBy1(this.by1 == null ? "" : this.by1);
            lmbBean.setBy2(this.by2 == null ? "" : this.by2);
            lmbBean.setZdbsid(yhbBean.getZdbsid());
            lmbBean.setZdbs(yhbBean.getZdbs());
            lmbBean.setFjdz(this.fjdz);
            ZDB zdbBean = zdbIF.createZDB();
            zdbBean.setId(Long.valueOf(Long.parseLong(this.zdbId)));
            List<ZDB> zdbList = zdbIF.getZDBService().getZdbManager().searchListZdbByBean(zdbBean);
            lmbBean.setLmlxid(((ZDB) zdbList.get(0)).getId().toString());
            lmbBean.setLmlx(((ZDB) zdbList.get(0)).getZdbmc());
            lmbBean.setLmsm(this.lmsm);
            lmbBean.setTjsj(DateFormat.shortDate(data));
            lmbIF.getLMBService().saveLMB(lmbBean);
            lmbIF.getLMBService().getTransactionManager().commit();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return columnsList();
    }

    public String columnsEdit() {
        try {
            if (this.id != null) {
                LMBIF lmbIF = DatabaseFactory.getLMBIF();
                ZDBIF zdbIF = DatabaseFactory.getZDBIF();
                LMB searchbean = lmbIF.getLMBService().searchLMBByID(this.id);
                if (searchbean != null) {
                    searchbean.setLmmc(this.lmmc);

                    searchbean.setDhlm(this.dhlm);
                    if (this.zdbId != null) {
                        ZDB zdbBean = zdbIF.createZDB();
                        zdbBean.setId(Long.valueOf(Long.parseLong(this.zdbId)));
                        List<ZDB> zdbList = zdbIF.getZDBService().getZdbManager().searchListZdbByBean(zdbBean);
                        searchbean.setLmlxid(((ZDB) zdbList.get(0)).getId().toString());
                        searchbean.setLmlx(((ZDB) zdbList.get(0)).getZdbmc());
                        searchbean.setBy1(this.by1 == null ? "" : this.by1);
                        searchbean.setBy2(this.by2 == null ? "" : this.by2);
                    }
                    searchbean.setLmzt(this.lmzt);
                    searchbean.setLmsm(this.lmsm);
                    searchbean.setFjdz(this.fjdz);
                    lmbIF.getLMBService().updateLMB(searchbean);
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return columnsList();
    }

    public String columnsDel() {
        try {
            LMBIF lmbIF = DatabaseFactory.getLMBIF();
            LMB lmb = lmbIF.createLMB();
            if ((this.data != null) && (this.data.length() > 0)) {
                LMB bean = lmbIF.searchLMBByID(Long.valueOf(Long.parseLong(this.data)));

                bean.setLmzt(3);
                lmbIF.getLMBService().updateLMB(bean);
            } else {
                StringTokenizer st = new StringTokenizer(SystemUtil.getStringByObject(this.datas), ",");
                while (st.hasMoreTokens()) {
                    lmbIF.getLMBService().getTransactionManager().begin();
                    String id = st.nextToken();
                    LMB bean = lmbIF.searchLMBByID(Long.valueOf(Long.parseLong(id)));

                    bean.setLmzt(3);
                    lmbIF.getLMBService().updateLMB(bean);

                    lmbIF.getLMBService().getTransactionManager().commit();
                }
            }
        } catch (Exception e) {
            logger.debug(e);
            e.printStackTrace();
            setJsondata(JsonResult.submit(Boolean.valueOf(false), Enums.getInstance().getDescByName("CommonMessage", "SYSTEM_ERROR")));
        }
        return columnsList();
    }

    public String getLmbById() {
        try {
            if (this.id != null) {
                LMBIF lmbIF = DatabaseFactory.getLMBIF();
                ZDBIF zbdIF = DatabaseFactory.getZDBIF();
                List<ZDB> listDatas = new ArrayList();
                LMB searchbean = lmbIF.getLMBService().searchLMBByID(this.id);
                if (searchbean != null) {
                    setLmb(searchbean);
                    getRequest().setAttribute("yhb", searchbean);

                    ZDB zdbBean = zbdIF.createZDB();
                    zdbBean.setFlag("1");
                    List<ZDB> listData = zbdIF.getZDBService().getZdbManager().searchListZdbByBean(zdbBean);
                    for (ZDB list : listData) {
                        listDatas.add(list);
                    }
                    setZdbList(listData);

                    getRequest().setAttribute("zdbid", searchbean.getLmlxid());
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return "columnsEdit";
    }

    public String zdbList() {
        try {
            List<ZDB> listDatas = new ArrayList();
            ZDBIF tZdbIF = DatabaseFactory.getZDBIF();
            ZDB searchbean = tZdbIF.createZDB();
            searchbean.setZdxbmc("栏目");
            searchbean.setFlag("1");
            List<ZDB> listData = tZdbIF.getZDBService().getZdbManager().searchListZdbByBean(searchbean);
            for (ZDB list : listData) {
                listDatas.add(list);
            }
            setZdbList(listDatas);
        } catch (Exception e) {
            logger.debug(e);
            e.printStackTrace();
            setJsondata(JsonResult.submit(Boolean.valueOf(false), Enums.getInstance().getDescByName("CommonMessage", "SYSTEM_ERROR")));
        }
        return "zdbList";
    }

    public String returnZTHG() {
        try {
            if (this.id != null) {
                LMBIF lmbIF = DatabaseFactory.getLMBIF();
                LMB searchbean = lmbIF.getLMBService().getLmbManager().getLMBByLmmc("专题回顾");
                if (searchbean != null) {
                    LMB lmbBean = lmbIF.getLMBService().searchLMBByID(this.id);
                    if (lmbBean != null) {
//                        Long flmidOrYes = lmbIF.getLMBService().getLmbManager().selectCount(searchbean.getId().toString());
                        Long lmId = lmbIF.getLMBService().getLmbManager().selectMaxId();
                        int lmbLmjs = 0;
                        if (lmbBean.getLmjs() > 0) {
                            lmbLmjs = lmbBean.getLmjs() + 1;
                        }
                        lmbIF.getLMBService().getLmbManager().updateLMBorHQL(lmId, searchbean.getId().toString(), this.id, lmbLmjs);
                    }
                }
            }
        } catch (Exception e) {
            logger.debug(e);
            e.printStackTrace();
            setJsondata(JsonResult.submit(Boolean.valueOf(false), Enums.getInstance().getDescByName("CommonMessage", "SYSTEM_ERROR")));
        }
        return columnsList();
    }

    private LMBManager lmbdao = new LMBManager();

    public List getMenuLmb(String zdbs, int lmzt) {
        if ((zdbs == null) || ("".equals(zdbs))) {
            return null;
        }
        return this.lmbdao.getMenuLMB(zdbs, lmzt);
    }

    public List getMenuLmb2(String zdbs, int lmzt) {
        if ((zdbs == null) || ("".equals(zdbs))) {
            return null;
        }
        return this.lmbdao.getMenuLMB2(zdbs, lmzt);
    }

    public List getMenuLmb3(String zdbs, int lmzt, String lmid) {
        if ((zdbs == null) || ("".equals(zdbs))) {
            return null;
        }
        return this.lmbdao.getMenuLMB3(zdbs, lmzt, lmid);
    }

    public List getValidSubLmb(String flmid) {
        if (("".equals(flmid)) || ("0".equals(flmid))) {
            return null;
        }
        return this.lmbdao.getValidSubLMB(flmid);
    }

    public LMB getOneValidSubLmb(String flmid) {
        if (("".equals(flmid)) || ("0".equals(flmid))) {
            return null;
        }
        return this.lmbdao.getOneValidSubLMB(flmid);
    }

    public int addLmb(LMB lmb) {
        return this.lmbdao.addLMB(lmb);
    }

    public int modifyLmb(LMB lmb) {
        return this.lmbdao.modifyLMB(lmb);
    }

    public int DirTransferr(String ylmid, String mlmid) {
        return this.lmbdao.DirTransferr(ylmid, mlmid);
    }

    public int updateLmbByFwcs(String lmid) {
        return this.lmbdao.updateLMBByFwcs(lmid);
    }

    public int DropLmbByZdbs(String zdbs) {
        int recode = 1;
        List<LMB> lmblist = getFirstLmb(zdbs);
        if (lmblist != null) {
            for (LMB flmb : lmblist) {
                recode = DropLmb(flmb);
            }
        }
        return recode;
    }

    private int DropLmb(LMB lmb) {
        int recode = 0;
        if ((lmb == null) || (lmb.getId() == null) || (lmb.getId().toString().length() == 0)) {
            return recode;
        }
        List<LMB> lmblist = this.lmbdao.getSecondLMB(lmb.getZdbs(), lmb.getId().toString());
        if (lmblist != null) {
            for (LMB zlmb : lmblist) {
                recode = DropLmb(zlmb);
            }
        }
        if (lmb.getLmlx() == "3") {
            WZBAction wzdao = new WZBAction();
            recode = wzdao.DropWZBByWzid(lmb.getId().toString().trim());
        } else {
            System.out.println("删除栏目" + lmb.getLmmc() + "; 栏目类型=" + lmb.getLmlx());
        }
        recode = this.lmbdao.removeLMB(lmb.getId().toString().trim());
        return recode;
    }

    public List getFirstLmb(String zdbs) {
        return this.lmbdao.getFirstLMB(zdbs);
    }

    public List getValidFirstLmb(String zdbs) {
        return this.lmbdao.getValidFirstLMB(zdbs);
    }

    public List getSortLmbByFwcsForPage(String zdbs, int offset, int pageSize) {
        return this.lmbdao.getSortLMBByFwcsForPage(zdbs, offset, pageSize);
    }

    public List getSecondLmb(String zdbs, String flmid) {
        return this.lmbdao.getSecondLMB(zdbs, flmid);
    }

    public List getSecondLmb2(String zdbs, String flmid) {
        return this.lmbdao.getSecondLMB2(zdbs, flmid);
    }

    public boolean isExtendFlag() {
        return this.extendFlag;
    }

    public void setExtendFlag(boolean extendFlag) {
        this.extendFlag = extendFlag;
    }
}