package com.app.hxqh.udaqdjwz;

import psdi.mbo.MAXTableDomain;
import psdi.mbo.MboRemote;
import psdi.mbo.MboSetRemote;
import psdi.mbo.MboValue;
import psdi.util.MXException;

import java.rmi.RemoteException;

/**
 * 安全点检位置选择执行组类型
 * edit 2024-07-11
 */
public class FldUdzxzlx extends MAXTableDomain {

    public FldUdzxzlx(MboValue mbv) throws MXException,RemoteException {
        super(mbv);
        String thisAttr = getMboValue().getAttributeName();
        setRelationship("UDSAISTANDLINE", "");
        String[] FromStr = { "ZXZLX" };
        String[] ToStr = { thisAttr };
        setLookupKeyMapInOrder(ToStr, FromStr);
    }

    public void init() throws RemoteException, MXException {
        super.init();
    }
    public void action() throws RemoteException, MXException {
        super.action();
    }

    public MboSetRemote getList() throws RemoteException, MXException {
        MboRemote mbo = getMboValue().getMbo();
        MboRemote ownerMbo=mbo.getOwner();
        int udaqdjwzid=ownerMbo.getInt("UDAQDJWZID");
        String sql = " UDSAISTANDLINEID IN(SELECT max(UDSAISTANDLINEID) FROM UDSAISTANDLINE WHERE PARENTID in(SELECT UDSAISTANDID FROM UDSAISTAND WHERE UDSAISTANDNUM in(SELECT UDSAISTANDNUM FROM UDAQDJWZDJBZ WHERE PARENTID="+udaqdjwzid+") and STATUS='ACTIVE') GROUP BY ZXZLX) AND ZXZLX NOT IN(SELECT ZXZLX FROM UDAQDJWZZXZ WHERE PARENTID="+udaqdjwzid+") ";
        setListCriteria(sql);
        return super.getList();
    }
}