package xin.glue.ui.B.B02;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.PosGenericDao;
import com.posdata.glue.dao.PosJdbcDao;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRowSet;
import xin.glue.ui.B.common.SqlTools;

public class FindCoilDec extends PosActivity {
	public String runActivity(PosContext context) {
		PosGenericDao dao  = this.getDao("mesdao");
		PosRowSet rowSet= null;
		PosParameter param = null; 
		
		String[] dec = (String[])context.get("dec");
		String[] startTime = (String[])context.get("startTime");
		String[] endTime = (String[])context.get("endTime");
		StringBuffer sql = SqlTools.getSql("UIB020250_01.SELECT", (PosJdbcDao)this.getDao("mesdao"));
	    
		if(dec[0].equals("ALL"))
	    {
			String sqlEnd = " WHERE TOT_DEC_GRD > '1' " +
					"AND (CASE WHEN (TM.BEDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) >= to_number(NVL(TM.BEDT,'1')) "+
					"AND (CASE WHEN (TM.AFDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) <= to_number(NVL(TM.AFDT,'1')) ";
			sql.append(sqlEnd);
	    }
		
		if(dec[0].equals("INGR"))
	    {
			String sqlEnd = " WHERE INGR_DEC_GRD <> '1' and TOT_DEC_GRD > '1' "+
			"AND (CASE WHEN (TM.BEDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) >= to_number(NVL(TM.BEDT,'1')) "+
			"AND (CASE WHEN (TM.AFDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) <= to_number(NVL(TM.AFDT,'1')) ";
			sql.append(sqlEnd); 
	    }
		
		if(dec[0].equals("MATLQLTY"))
	    {
			String sqlEnd = " WHERE MATLQLTY_DEC_GRD <> '1' and TOT_DEC_GRD > '1'  "+
			"AND (CASE WHEN (TM.BEDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) >= to_number(NVL(TM.BEDT,'1')) "+
			"AND (CASE WHEN (TM.AFDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) <= to_number(NVL(TM.AFDT,'1')) ";
			sql.append(sqlEnd); 
	    }
		
		if(dec[0].equals("PROC"))
	    {
			String sqlEnd = " WHERE PROC_DEC_RST <> '1' and TOT_DEC_GRD > '1'  "+
			"AND (CASE WHEN (TM.BEDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) >= to_number(NVL(TM.BEDT,'1')) "+
			"AND (CASE WHEN (TM.AFDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) <= to_number(NVL(TM.AFDT,'1')) ";
			sql.append(sqlEnd); 
	    }
		
		if(dec[0].equals("EXTSHAPE"))
	    {
			String sqlEnd = " WHERE EXTSHAPE_DEC_GRD <> '1' and TOT_DEC_GRD > '1'  "+
			"AND (CASE WHEN (TM.BEDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) >= to_number(NVL(TM.BEDT,'1')) "+
			"AND (CASE WHEN (TM.AFDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) <= to_number(NVL(TM.AFDT,'1')) ";
			sql.append(sqlEnd); 
	    }
		if(dec[0].equals("ORDFL"))
	    {
			String sqlEnd = " WHERE TOT_DEC_GRD > '1' and ORD_FL = '2'  "+
			"AND (CASE WHEN (TM.BEDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) >= to_number(NVL(TM.BEDT,'1')) "+
			"AND (CASE WHEN (TM.AFDT IS NOT NULL ) THEN to_number(substr(TOT_DEC_DTIME,1,8)) ELSE 1 END) <= to_number(NVL(TM.AFDT,'1')) ";
			sql.append(sqlEnd); 
	    }
		//
	//	String sqlothers = " AND (TBH02_COIL_COMM.SALE_TP <>'E' OR TBH02_COIL_COMM.SALE_TP IS NULL) ";
		String sqlothers = " AND (TBH02_COIL_COMM.COIL_STAT = '2') ";
		sql.append(sqlothers);
		param = new PosParameter();
		param.setWhereClauseParameter(0, startTime[0]);
		param.setWhereClauseParameter(1, endTime[0]);
		
		rowSet = this.getDao("mesdao").findByQueryStatement(sql.toString(), param);
		context.put("CoilDecResult" , rowSet);
		return PosBizControlConstants.SUCCESS;
	}
}