package com.app.hxqh.udpdline;

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 20240624
 */
public class FldGDZCBHNum extends MAXTableDomain {

    public FldGDZCBHNum(MboValue mbv) throws MXException,RemoteException {
        super(mbv);
        String thisAttr = getMboValue().getAttributeName();
        setRelationship("UDGDZC", "");
        String[] FromStr = { "ANLN1" };
        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();
        if(null!=ownerMbo){
            String sql = " BUKRS in(SELECT COMPANY FROM SITE WHERE SITEID='"+mbo.getString("SITEID")+"' AND ORGID='"+mbo.getString("ORGID")+"') AND KOSTL IN(SELECT COST_CENTER FROM UDCBZXYDLXYS WHERE WHS_LOCATION_CODE='"+ownerMbo.getString("DEPTNUM")+"' AND SITEID='"+mbo.getString("SITEID")+"')  AND ANLN1 NOT in(SELECT GDZCBH FROM UDPDLINE WHERE PDNUM='"+mbo.getString("PDNUM")+"')";
            setListCriteria(sql);
        }
        return super.getList();
    }
}