XinYu_RZMES/.svn/pristine/25/25c5e9b73e59d78d85d5c2a97dd0f4bc4e3ea92d.svn-base

package xin.glue.ui.H.H02;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.posdata.glue.biz.activity.PosActivity;
import com.posdata.glue.biz.constants.PosBizControlConstants;
import com.posdata.glue.component.layout.PosMessageLayoutIF;
import com.posdata.glue.context.PosContext;
import com.posdata.glue.dao.vo.PosParameter;
import com.posdata.glue.dao.vo.PosRow;
import com.posdata.glue.dao.vo.PosRowSet;
import com.posdata.glue.msg.PosMESMessageImpl;
import com.posdata.glue.msg.PosMessageAttributeDefinition;
import com.posdata.glue.msg.PosMessageDefinition;
import com.posdata.glue.util.log.PosLog;
import com.posdata.glue.util.log.PosLogFactory;

public class PosMillReportEdit extends PosActivity {
	private final PosLog log = PosLogFactory.getLogger(getClass());

	public String runActivity(PosContext context) {
		 
	  log.logInfo("======== PosMillReportEdit start " );
	  
	  String[]  PRD_YYYYMM = (String[])context.get("PRD_YYYYMM");     	
		
	  String[][]  EDIT_PROD = new String[2][21];
	  String[]    EDIT_SHIP = new String[10] ; 
	  String[][]  EDIT_YARD = new String[2][10] ; 
	  String[]    EDIT_YC = new String[8] ; 
	  
	  int i = 0;int j = 0;
	  
	  for ( i = 0 ; i < 2;i++) {
	    for ( j = 0 ; j < 21;j++) {
		  
		  EDIT_PROD[i][j]= null;
	    }  
	  }
	  
	  for (  i = 0 ; i < 9;i++) {
	    EDIT_SHIP[i] = null; 
	  }
	  for ( i = 0 ; i < 2;i++) {
	   for (  j = 0 ; j < 9;j++) {
		  EDIT_YARD[i][j] = null; 
	   }
	  } 
	  
	  for(i=0;i<7;i++){
		  EDIT_YC[i] = null;
	  }
	  
	  List list1 = new ArrayList();
	  List list2 = new ArrayList();
	  List list3 = new ArrayList();
	  
	  List list4 = new ArrayList();
	  
	  String SLAB_RT = null;
	  String RHF_DAY_CNT = null;
	  String RHF_DAY_WGT = null;
	  String RHF_MON_CNT = null;
	  String RHF_MON_WGT = null; 
	  String MILL_DAY_CNT = null;
	  String MILL_DAY_WGT = null;
	  String MILL_MON_CNT = null;
	  String MILL_MON_WGT = null; 
	 
	  log.logInfo("======== PosMillReportEdit PRD_YYYYMM:"+PRD_YYYYMM[0] );
	  
	  PosParameter param1 = new PosParameter();
      param1.setWhereClauseParameter(0, PRD_YYYYMM[0]);
      param1.setWhereClauseParameter(1, PRD_YYYYMM[0]);
      param1.setWhereClauseParameter(2, PRD_YYYYMM[0]);
      PosRowSet rhfRstVO = this.getDao("mesdao").find("UIH020210_RHF_EXT.select", param1);
    
      while(rhfRstVO.hasNext()) {
    	  
          PosRow rhfRstROW = rhfRstVO.next();
          SLAB_RT         = (String)rhfRstROW.getAttribute("SLAB_RT");
          RHF_DAY_CNT     = (String)rhfRstROW.getAttribute("RHF_DAY_CNT");
          RHF_DAY_WGT     = (String)rhfRstROW.getAttribute("RHF_DAY_WGT");
          RHF_MON_CNT     = (String)rhfRstROW.getAttribute("RHF_MON_CNT");
          RHF_MON_WGT     = (String)rhfRstROW.getAttribute("RHF_MON_WGT"); 
          

          EDIT_PROD[0][0] = "�崏第";
    	  EDIT_PROD[1][0] = "濮崏第";
          
          if (SLAB_RT != null && SLAB_RT.equals("H")) {
        	  EDIT_PROD[0][1] = RHF_DAY_CNT;
        	  EDIT_PROD[0][2] = RHF_MON_CNT;
        	  EDIT_PROD[0][3] = RHF_DAY_WGT;
        	  EDIT_PROD[0][4] = RHF_MON_WGT;
          }	else if (SLAB_RT != null && SLAB_RT.equals("C"))  { 
        	  EDIT_PROD[1][1] = RHF_DAY_CNT;
        	  EDIT_PROD[1][2] = RHF_MON_CNT;
        	  EDIT_PROD[1][3] = RHF_DAY_WGT;
        	  EDIT_PROD[1][4] = RHF_MON_WGT; 
          }	  
          
          
      }   
      
      
      
      PosParameter param2 = new PosParameter();
      param2.setWhereClauseParameter(0, PRD_YYYYMM[0]);
      param2.setWhereClauseParameter(1, PRD_YYYYMM[0]);
      param2.setWhereClauseParameter(2, PRD_YYYYMM[0]); 
      PosRowSet MillRstVO = this.getDao("mesdao").find("UIH020210_COIL_RST.select", param2);
    
      while(MillRstVO.hasNext()) {
    	  
          PosRow MillRstROW = MillRstVO.next();
          SLAB_RT          = (String)MillRstROW.getAttribute("COIL_RT");
          MILL_DAY_CNT     = (String)MillRstROW.getAttribute("MILL_DAY_CNT");
          MILL_DAY_WGT     = (String)MillRstROW.getAttribute("MILL_DAY_WGT");
          MILL_MON_CNT     = (String)MillRstROW.getAttribute("MILL_MON_CNT");
          MILL_MON_WGT     = (String)MillRstROW.getAttribute("MILL_MON_WGT"); 
          

          EDIT_PROD[0][0] = "�崏第";
    	  EDIT_PROD[1][0] = "濮崏第";
          
          if (SLAB_RT != null && SLAB_RT.equals("H")) {
        	  EDIT_PROD[0][5] = MILL_DAY_CNT;
        	  EDIT_PROD[0][6] = MILL_MON_CNT;
        	  EDIT_PROD[0][7] = MILL_DAY_WGT;
        	  EDIT_PROD[0][8] = MILL_MON_WGT;
          }	else if (SLAB_RT != null && SLAB_RT.equals("C"))  { 
        	  EDIT_PROD[1][5] = MILL_DAY_CNT;
        	  EDIT_PROD[1][6] = MILL_MON_CNT;
        	  EDIT_PROD[1][7] = MILL_DAY_WGT;
        	  EDIT_PROD[1][8] = MILL_MON_WGT; 
          }	  
          
          
      }
      
      String ENT_DAY_CNT     =  null;
      String ENT_MON_CNT     =  null;
      String ENT_DAY_WGT     =  null;
      String ENT_MON_WGT     =  null;
      String EXT_DAY_CNT     =  null;
      String EXT_MON_CNT     =  null;
      String EXT_DAY_WGT     =  null;
      String EXT_MON_WGT     =  null;
      
      
      PosParameter param3 = new PosParameter();
      param3.setWhereClauseParameter(0, PRD_YYYYMM[0]);
      param3.setWhereClauseParameter(1, PRD_YYYYMM[0]);
      param3.setWhereClauseParameter(2, PRD_YYYYMM[0]);
      PosRowSet SlabRejVO = this.getDao("mesdao").find("UIH020210_SLAB_REJ.select", param3);
    
      while(SlabRejVO.hasNext()) {
    	  
          PosRow SlabRejROW = SlabRejVO.next();
          SLAB_RT          = (String)SlabRejROW.getAttribute("SLAB_RT");
          ENT_DAY_CNT     = (String)SlabRejROW.getAttribute("ENT_DAY_CNT");
          ENT_MON_CNT     = (String)SlabRejROW.getAttribute("ENT_MON_CNT");
          ENT_DAY_WGT     = (String)SlabRejROW.getAttribute("ENT_DAY_WGT");
          ENT_MON_WGT     = (String)SlabRejROW.getAttribute("ENT_MON_WGT"); 
          EXT_DAY_CNT     = (String)SlabRejROW.getAttribute("EXT_DAY_CNT");
          EXT_MON_CNT     = (String)SlabRejROW.getAttribute("EXT_MON_CNT");
          EXT_DAY_WGT     = (String)SlabRejROW.getAttribute("EXT_DAY_WGT");
          EXT_MON_WGT     = (String)SlabRejROW.getAttribute("EXT_MON_WGT"); 
          

          EDIT_PROD[0][0] = "�崏第";
    	  EDIT_PROD[1][0] = "濮崏第";
          
          if (SLAB_RT != null && SLAB_RT.equals("H")) {
        	  EDIT_PROD[0][9]  = ENT_DAY_CNT;
        	  EDIT_PROD[0][10] = ENT_MON_CNT;
        	  EDIT_PROD[0][11] = ENT_DAY_WGT;
        	  EDIT_PROD[0][12] = ENT_MON_WGT;
        	  EDIT_PROD[0][13] = EXT_DAY_CNT;
        	  EDIT_PROD[0][14] = EXT_MON_CNT;
        	  EDIT_PROD[0][15] = EXT_DAY_WGT;
        	  EDIT_PROD[0][16] = EXT_MON_WGT;
        	  
          }	else if (SLAB_RT != null && SLAB_RT.equals("C"))  { 
        	  EDIT_PROD[1][9]  = ENT_DAY_CNT;
        	  EDIT_PROD[1][10] = ENT_MON_CNT;
        	  EDIT_PROD[1][11] = ENT_DAY_WGT;
        	  EDIT_PROD[1][12] = ENT_MON_WGT;
        	  EDIT_PROD[1][13] = EXT_DAY_CNT;
        	  EDIT_PROD[1][14] = EXT_MON_CNT;
        	  EDIT_PROD[1][15] = EXT_DAY_WGT;
        	  EDIT_PROD[1][16] = EXT_MON_WGT;
          }	  
          
          
      }
      
      String DAY_CNT = null; 
      String DAY_WGT = null; 
      String MON_CNT = null; 
      String MON_WGT = null; 
      
      PosParameter param4 = new PosParameter();
      param4.setWhereClauseParameter(0, PRD_YYYYMM[0]); 
      param4.setWhereClauseParameter(1, PRD_YYYYMM[0]);
      param4.setWhereClauseParameter(2, PRD_YYYYMM[0]);
      PosRowSet CoilRejVO = this.getDao("mesdao").find("UIH020210_COIL_REJ.select", param4);
    
      while(CoilRejVO.hasNext()) {
    	  
          PosRow CoilRejROW = CoilRejVO.next();
          
          SLAB_RT     = (String)CoilRejROW.getAttribute("SLAB_RT");
          DAY_CNT     = (String)CoilRejROW.getAttribute("DAY_CNT");
          DAY_WGT     = (String)CoilRejROW.getAttribute("DAY_WGT");
          MON_CNT     = (String)CoilRejROW.getAttribute("MON_CNT");
          MON_WGT     = (String)CoilRejROW.getAttribute("MON_WGT"); 
          

          EDIT_PROD[0][0] = "�崏第";
    	  EDIT_PROD[1][0] = "濮崏第";
          
          if (SLAB_RT != null && SLAB_RT.equals("H")) {
        	  EDIT_PROD[0][17] = DAY_CNT;
        	  EDIT_PROD[0][18] = MON_CNT;
        	  EDIT_PROD[0][19] = DAY_WGT;
        	  EDIT_PROD[0][20] = MON_WGT;
          }	else if (SLAB_RT != null && SLAB_RT.equals("C"))  { 
        	  EDIT_PROD[1][17] = DAY_CNT;
        	  EDIT_PROD[1][18] = MON_CNT;
        	  EDIT_PROD[1][19] = DAY_WGT;
        	  EDIT_PROD[1][20] = MON_WGT; 
          }	  
          
          
      }
      
     
      
      for(int m=0;m < 2;m++) {                                      
    	  HashMap   map1 =  new HashMap(30,6) ;                                                          
           list1.add(map1);                                         
           map1.put("REP_MTL_CLF"      , EDIT_PROD[m][0]    );                                                        
           map1.put("RST_RHF_CNT"      , EDIT_PROD[m][1]    );     
           map1.put("RST_RHF_T_CNT"    , EDIT_PROD[m][2]    );     
           map1.put("RST_RHF_WGT"      , EDIT_PROD[m][3]    );     
           map1.put("RST_RHF_T_WGT"    , EDIT_PROD[m][4]    );     
           map1.put("RST_COIL_CNT"     , EDIT_PROD[m][5]    );     
           map1.put("RST_COIL_T_CNT"   , EDIT_PROD[m][6]    );     
           map1.put("RST_COIL_WGT"     , EDIT_PROD[m][7]    );     
           map1.put("RST_COIL_T_WGT"   , EDIT_PROD[m][8]    );     
           map1.put("RHF_B_REJ_CNT"    , EDIT_PROD[m][9]    );     
           map1.put("RHF_B_REJ_T_CNT"  , EDIT_PROD[m][10]    );     
           map1.put("RHF_B_REJ_WGT"    , EDIT_PROD[m][11]    );     
           map1.put("RHF_B_REJ_T_WGT"  , EDIT_PROD[m][12]    );     
           map1.put("RHF_A_REJ_CNT"    , EDIT_PROD[m][13]    );     
           map1.put("RHF_A_REJ_T_CNT"  , EDIT_PROD[m][14]    );     
           map1.put("RHF_A_REJ_WGT"    , EDIT_PROD[m][15]    );     
           map1.put("RHF_A_REJ_T_WGT"  , EDIT_PROD[m][16]    );     
           map1.put("MILL_REJ_CNT"     , EDIT_PROD[m][17]    );     
           map1.put("MILL_REJ_T_CNT"   , EDIT_PROD[m][18]    );     
           map1.put("MILL_REJ_WGT"     , EDIT_PROD[m][19]    );     
           map1.put("MILL_REJ_T_WGT"   , EDIT_PROD[m][20]    );     
           
        	                                                           
      }	                                                           

        
      
       
      context.put("ProdEdit",list1);
      
      
      String  SHIP_DAY_CNT = null; 
      String  SHIP_DAY_WGT = null; 
      String  SHIP_MON_CNT = null; 
      String  SHIP_MON_WGT = null; 
      String  COLD_DAY_CNT = null; 
      String  COLD_DAY_WGT = null; 
      String  COLD_MON_CNT = null; 
      String  COLD_MON_WGT = null; 

      
      PosParameter param5 = new PosParameter();
      param5.setWhereClauseParameter(0, PRD_YYYYMM[0]);
      param5.setWhereClauseParameter(1, PRD_YYYYMM[0]);
      param5.setWhereClauseParameter(2, PRD_YYYYMM[0]);
      param5.setWhereClauseParameter(3, PRD_YYYYMM[0]);
      param5.setWhereClauseParameter(4, PRD_YYYYMM[0]);
      param5.setWhereClauseParameter(5, PRD_YYYYMM[0]);
      PosRowSet ShipColdVO = this.getDao("mesdao").find("UIH020210_SHIP.select", param5);
    
      while(ShipColdVO.hasNext()) {
    	  
          PosRow ShipColdROW = ShipColdVO.next();
          
          SHIP_DAY_CNT = (String)ShipColdROW.getAttribute("SHIP_DAY_CNT"); 
          SHIP_DAY_WGT = (String)ShipColdROW.getAttribute("SHIP_DAY_WGT"); 
          SHIP_MON_CNT = (String)ShipColdROW.getAttribute("SHIP_MON_CNT"); 
          SHIP_MON_WGT = (String)ShipColdROW.getAttribute("SHIP_MON_WGT"); 
          COLD_DAY_CNT = (String)ShipColdROW.getAttribute("COLD_DAY_CNT"); 
          COLD_DAY_WGT = (String)ShipColdROW.getAttribute("COLD_DAY_WGT"); 
          COLD_MON_CNT = (String)ShipColdROW.getAttribute("COLD_MON_CNT"); 
          COLD_MON_WGT = (String)ShipColdROW.getAttribute("COLD_MON_WGT"); 

          
          

    	  EDIT_SHIP[0]  = "  "; 
          
           
    	  EDIT_SHIP[1] = SHIP_DAY_CNT;
    	  EDIT_SHIP[2] = SHIP_MON_CNT;
    	  EDIT_SHIP[3] = SHIP_DAY_WGT;
    	  EDIT_SHIP[4] = SHIP_MON_WGT;
    	  EDIT_SHIP[5] = COLD_DAY_CNT;
    	  EDIT_SHIP[6] = COLD_MON_CNT;
    	  EDIT_SHIP[7] = COLD_DAY_WGT;
    	  EDIT_SHIP[8] = COLD_MON_WGT;

          
          
      }
      
      HashMap   map2 =  new HashMap(10,1) ;   
   
      list2.add(map2);                                         
          
      map2.put("REP_MTL_CLF"   , EDIT_SHIP[0]     );     
      map2.put("SHIP_CNT"      , EDIT_SHIP[1]     );     
      map2.put("SHIP_T_CNT"    , EDIT_SHIP[2]     );
      map2.put("SHIP_WGT"      , EDIT_SHIP[3]     );     
      map2.put("SHIP_T_WGT"    , EDIT_SHIP[4]     );     
      map2.put("COLD_CNT"      , EDIT_SHIP[5]     );
      map2.put("COLD_T_CNT"    , EDIT_SHIP[6]     );     
      map2.put("COLD_WGT"      , EDIT_SHIP[7]     );
      map2.put("COLD_T_WGT"    , EDIT_SHIP[8]     );
    	
      context.put("ShipEdit",list2); 
      
      
      //涴爵苀數豻第講
      String  YC_DAY_CNT = null; 
      String  YC_DAY_WGT = null; 
      String  YC_MON_CNT = null; 
      String  YC_MON_WGT = null; 
      String  YC_DAY_WGT_T = null; 
      String  YC_MON_WGT_T = null; 
      
      PosParameter param55 = new PosParameter();
      param55.setWhereClauseParameter(0, PRD_YYYYMM[0]);
      param55.setWhereClauseParameter(1, PRD_YYYYMM[0]);
      param55.setWhereClauseParameter(2, PRD_YYYYMM[0]);
      param55.setWhereClauseParameter(3, PRD_YYYYMM[0]);
      param55.setWhereClauseParameter(4, PRD_YYYYMM[0]);
      param55.setWhereClauseParameter(5, PRD_YYYYMM[0]);
      PosRowSet YCColdVO = this.getDao("mesdao").find("UIH020210_YC.select", param55);
    
      while(YCColdVO.hasNext()) {
    	  
          PosRow YCColdROW = YCColdVO.next();
          
          YC_DAY_CNT = (String)YCColdROW.getAttribute("YC_DAY_CNT"); 
          YC_DAY_WGT = (String)YCColdROW.getAttribute("YC_DAY_WGT"); 
          YC_MON_CNT = (String)YCColdROW.getAttribute("YC_MON_CNT"); 
          YC_MON_WGT = (String)YCColdROW.getAttribute("YC_MON_WGT");
          YC_DAY_WGT_T = (String)YCColdROW.getAttribute("YC_DAY_WGT_T");
          YC_MON_WGT_T = (String)YCColdROW.getAttribute("YC_MON_WGT_T");

          
          

          EDIT_YC[0]  = "  "; 
          
           
          EDIT_YC[1] = YC_DAY_CNT;
          EDIT_YC[2] = YC_DAY_WGT;
          EDIT_YC[3] = YC_MON_CNT;
          EDIT_YC[4] = YC_MON_WGT;
          EDIT_YC[5] = YC_DAY_WGT_T;
          EDIT_YC[6] = YC_MON_WGT_T;
          
      }
      
      HashMap   map4 =  new HashMap(10,1) ;   
   
      list4.add(map4);                                         
          
      map4.put("MTL_CLF"   , EDIT_YC[0]     );     
      map4.put("CNT"      , EDIT_YC[1]     );     
      map4.put("T_CNT"    , EDIT_YC[3]     );
      map4.put("WGT"      , EDIT_YC[2]     );     
      map4.put("T_WGT"    , EDIT_YC[4]     );     
      map4.put("LIB"    , EDIT_YC[5]     );
      map4.put("T_LIB"    , EDIT_YC[6]     );
    	
      context.put("YCEdit",list4); 
      
      
      
      
      String COIL_RT = null;
      String YARD1_COIL_CNT = null;
      String YARD1_COIL_WGT = null;
      String YARD2_COIL_CNT = null;
      String YARD2_COIL_WGT = null;
      String YARD3_COIL_CNT = null;
      String YARD3_COIL_WGT = null;
      String TOT_COIL_CNT = null;
      String TOT_COIL_WGT = null;
      
      
      PosRowSet YardCoilVO = this.getDao("mesdao").find("UIH020210_YARD.select" );
    
      while(YardCoilVO.hasNext()) {
    	  
          PosRow YardCoilROW = YardCoilVO.next();
          COIL_RT        = (String)YardCoilROW.getAttribute("COIL_RT");
          YARD1_COIL_CNT = (String)YardCoilROW.getAttribute("YARD1_COIL_CNT"); 
          YARD1_COIL_WGT = (String)YardCoilROW.getAttribute("YARD1_COIL_WGT"); 
          YARD2_COIL_CNT = (String)YardCoilROW.getAttribute("YARD2_COIL_CNT"); 
          YARD2_COIL_WGT = (String)YardCoilROW.getAttribute("YARD2_COIL_WGT"); 
          YARD3_COIL_CNT = (String)YardCoilROW.getAttribute("YARD3_COIL_CNT"); 
          YARD3_COIL_WGT = (String)YardCoilROW.getAttribute("YARD3_COIL_WGT"); 
          TOT_COIL_CNT   = (String)YardCoilROW.getAttribute("TOT_COIL_CNT");
          TOT_COIL_WGT   = (String)YardCoilROW.getAttribute("TOT_COIL_WGT");

          
          
          if (COIL_RT != null && COIL_RT.equals("H") ) {
        	  EDIT_YARD[0][0]  = "�崏第";   
        	  EDIT_YARD[0][1] = YARD1_COIL_CNT;
              EDIT_YARD[0][2] = YARD2_COIL_CNT;
              EDIT_YARD[0][3] = YARD3_COIL_CNT;
              EDIT_YARD[0][4] = TOT_COIL_CNT;
              EDIT_YARD[0][5] = YARD1_COIL_WGT;
              EDIT_YARD[0][6] = YARD2_COIL_WGT;
              EDIT_YARD[0][7] = YARD3_COIL_WGT;
              EDIT_YARD[0][8] = TOT_COIL_WGT;
          } else {
        	  EDIT_YARD[1][0]  = "濮崏第"; 
        	  EDIT_YARD[1][1] = YARD1_COIL_CNT;
              EDIT_YARD[1][2] = YARD2_COIL_CNT;
              EDIT_YARD[1][3] = YARD3_COIL_CNT;
              EDIT_YARD[1][4] = TOT_COIL_CNT;
              EDIT_YARD[1][5] = YARD1_COIL_WGT;
              EDIT_YARD[1][6] = YARD2_COIL_WGT;
              EDIT_YARD[1][7] = YARD3_COIL_WGT;
              EDIT_YARD[1][8] = TOT_COIL_WGT;
          }
     
          
      }
     
      for (i = 0; i < 2; i++) {
        HashMap   map3 =  new HashMap(10,1) ;   
   
        list3.add(map3);                                         
           
        map3.put("REP_MTL_CLF"    , EDIT_YARD[i][0]     );     
        map3.put("STOCK_1_CNT"    , EDIT_YARD[i][1]     );     
        map3.put("STOCK_2_CNT"    , EDIT_YARD[i][2]     );
        map3.put("STOCK_3_CNT"    , EDIT_YARD[i][3]     );     
        map3.put("STOCK_T_CNT"    , EDIT_YARD[i][4]     );     
        map3.put("STOCK_1_WGT"    , EDIT_YARD[i][5]     );
        map3.put("STOCK_2_WGT"    , EDIT_YARD[i][6]     );     
        map3.put("STOCK_3_WGT"    , EDIT_YARD[i][7]     );
        map3.put("STOCK_T_WGT"    , EDIT_YARD[i][8]     );
        
      }	
      context.put("YardEdit",list3); 
     
	  return PosBizControlConstants.SUCCESS;
	}

}