package com.app.hxqh.udjobstand;


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 2023-06-23
 */
public class FldItemnum extends MAXTableDomain{

	public FldItemnum(MboValue mbv) {
		super(mbv);
		String thisAttr = getMboValue().getAttributeName();
		setRelationship("ITEM", "");
		String[] FromStr = { "ITEMNUM"};
		String[] ToStr = { thisAttr};
		setLookupKeyMapInOrder(ToStr, FromStr);
	}

	public MboSetRemote getList() throws RemoteException, MXException {
		MboRemote mbo = getMboValue().getMbo();
//		String siteid=mbo.getString("SITEID");
//		String sql = "itemnum IN(SELECT ITEMNUM  FROM UDKC WHERE LOCATION in(SELECT LOCATION FROM LOCATIONS WHERE TYPE='STOREROOM' AND SITEID='"+siteid+"') and CURBALTOTAL>0)";
		setListCriteria("itemnum NOT IN (SELECT itemnum  FROM item WHERE SMALL_CATEGORY in(SELECT SMALLCATE FROM UDCATE WHERE SMALLCATELIMIT='Y') )");
		return super.getList();
	}

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