森中灵 最后提交于9月前 整理为组织方式和替换新的jar

/*
 * 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[遇见知启蒙，邂逅框架梦]
 * 
 * https://zhiqim.org/project/zhiqim_components/zhiqim_account.htm
 *
 * Zhiqim Account is licensed under Mulan PSL v2.
 * You can use this software according to the terms and conditions of the Mulan PSL v2.
 * You may obtain a copy of Mulan PSL v2 at:
 *          http://license.coscl.org.cn/MulanPSL2
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PSL v2 for more details.
 */
package org.zhiqim.manager.dao;

import java.util.ArrayList;
import java.util.List;

import org.zhiqim.kernel.annotation.AnAlias;
import org.zhiqim.kernel.util.Validates;
import org.zhiqim.manager.ZmrConstants;
import org.zhiqim.manager.ZmrSessionUser;
import org.zhiqim.manager.dbo.ZmrOrg;
import org.zhiqim.orm.ORM;
import org.zhiqim.orm.dbo.Selector;

/**
 * 组织数据访问对象
 *
 * @version v1.0.0 @author zouzhigang 2017-8-23 新建与整理
 */
@AnAlias("ZmrOrgDao")
public class ZmrOrgDao implements ZmrConstants
{
    /** 列表 */
    public static List<ZmrOrg> list() throws Exception
    {
        return ORM.table().list(ZmrOrg.class, new Selector().addOrderbyAsc("orgLevel,orgSeq,orgId"));
    }
    
    /** 列表（级别） */
    public static List<ZmrOrg> list(int orgLevel) throws Exception
    {
        return ORM.table().list(ZmrOrg.class, new Selector().addMust("orgLevel", orgLevel).addOrderbyAsc("orgSeq,orgId"));
    }
    
    /** 列表（当前会话组织的下属组织列表，0表示父组织，1表示子组织）*/
    public static List<ZmrOrg> list(ZmrSessionUser sessionUser) throws Exception
    {
        ZmrOrg org = ORM.table().item(ZmrOrg.class, sessionUser.getOperatorOrgId());
        
        if(org.getOrgLevel() == 0)
            return list();
        
        List<ZmrOrg> list = new ArrayList<ZmrOrg>();
        if(org.getOrgLevel() == 1)
            list.add(org);
        
        return list;
    }

    /** 对象 */
    public static ZmrOrg item(long orgId) throws Exception
    {
        return ORM.table().item(ZmrOrg.class, orgId);
    }
    
    /** 编号 */
    public static long id(String orgName) throws Exception
    {
        if (Validates.isEmptyBlank(orgName))
            return -1;
        
        ZmrOrg org = ORM.table().item(ZmrOrg.class, new Selector("orgName", orgName));
        return org == null?-1:org.getOrgId();
    }
    
    /** 名称 */
    public static String name(long orgId) throws Exception
    {
        ZmrOrg org = ORM.table().item(ZmrOrg.class, orgId);
        return org == null?_EMPTY_:org.getOrgName();
    }
    
    /** 存在 */
    public static boolean exists(long orgId) throws Exception
    {
        return ORM.table().count(ZmrOrg.class, orgId) > 0;
    }
    
    /** 存在 */
    public static boolean exists(String orgName) throws Exception
    {
        return ORM.table().count(ZmrOrg.class, new Selector("orgName", orgName)) > 0;
    }
    
    /** 根组织编号 */
    public static long rootOrgId()
    {
        return ORM.tabler().item(ZmrOrg.class, new Selector("orgLevel", 0)).result().getOrgId();
    }
}