package nccloud.web.hrwa.pubinfo.wadataexplain.action;

import nc.vo.pubapp.pattern.pub.PubAppTool;
import nccloud.framework.web.processor.IRefSqlBuilder;
import nccloud.framework.web.processor.refgrid.RefQueryInfo;
import nccloud.framework.web.ui.meta.RefMeta;
import nccloud.pubitf.platform.db.SqlParameterCollection;

public class HrwaPsndocdevFilter implements IRefSqlBuilder {

	@Override
	public String getExtraSql(RefQueryInfo para, RefMeta meta) {
		// TODO Auto-generated method stub
	
		String pk_wa_class = null==para.getQueryCondition().get("pk_wa_class")?null:para.getQueryCondition().get("pk_wa_class").toString();
		String cyearperiod = null==para.getQueryCondition().get("cyearperiod")?null:para.getQueryCondition().get("cyearperiod").toString();
		
		return " and bd_psndoc.pk_psndoc in ( SELECT pk_psndoc FROM wa_data "
				+ "where     pk_wa_class = '" + pk_wa_class + "' and cyearperiod = '"
				+ cyearperiod + "' and nvl(stopflag ,'N')='N'  )";
		//return "";
	}

	@Override
	public SqlParameterCollection getExtraSqlParameter(RefQueryInfo para, RefMeta meta) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public String getOrderSql(RefQueryInfo para, RefMeta meta) {
		// TODO Auto-generated method stub
		return null;
	}

}
