package com.app.hxqh.udpdplan;


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 Flddeptnum extends MAXTableDomain{

	public Flddeptnum(MboValue mbv) {
		super(mbv);
		String thisAttr = getMboValue().getAttributeName();
		setRelationship("DEPT", "");
		String[] FromStr = { "DEPTNUM" };
		String[] ToStr = { thisAttr };
		setLookupKeyMapInOrder(ToStr, FromStr);
	}

	public MboSetRemote getList() throws MXException, RemoteException {
		MboSetRemote set = super.getList();
		MboRemote mbo=getMboValue().getMbo();
		String orgid=mbo.getString("ORGID");
		String sql=" ORGID='"+orgid+"' and SITEID='"+mbo.getString("SITEID")+"' AND DEPTNUM NOT in(SELECT DEPTNUM FROM UDPDPLANLINE WHERE  UDPDPLANID="+mbo.getInt("UDPDPLANID")+" ) ";
		//20241011 盘点计划程序取部门时，快消线组织 FMCG 的取1开头的部门编码
		if("FMCG".equalsIgnoreCase(orgid)){
			sql+=" AND DEPTNUM LIKE '1%' ";
		}
		set.setWhere(sql);
		set.reset();
		return set;
	}

}