package com.ICT.AFC.contract.actions;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import com.ICT.AFC.contract.beans.*;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import com.ICT.AFC.DB.DB;
import com.ICT.AFC.util.DateTransact;
import java.util.ArrayList;

public class QueryContractAction
    extends Action {
    String TwosqlStr = "";
    public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest httpServletRequest,
                               HttpServletResponse httpServletResponse) throws
      Exception {
    //獲取數(shù)據(jù)源
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);
    //跳轉(zhuǎn)頁面
    String PageForward = "querycontractinfo";

    //聲明ArrayList對象
    ArrayList contract = new ArrayList();

    //判斷分頁狀態(tài)
    String PageNum=httpServletRequest.getParameter("PageNum");

   ContractOperate contractoperate = new ContractOperate();

   if(PageNum == null || PageNum.equals(""))
   {
     //獲得查詢條件SQL語句
      String planStartTime = httpServletRequest.getParameter("planStartTime");
      String planEndTime = httpServletRequest.getParameter("planEndTime");
      String contractOwner = httpServletRequest.getParameter("contractOwner");
      contractOwner = new String(contractOwner.getBytes("ISO8859_1"));
      String contractEntity = httpServletRequest.getParameter("contractEntity");
      contractEntity = new String(contractEntity.getBytes("ISO8859_1"));
      String contractIsSell = httpServletRequest.getParameter("contractIsSell");
      contractIsSell = new String(contractIsSell.getBytes("ISO8859_1"));
      boolean isFirst = true;
      String sqlStr = "";
      java.sql.Date i = DateTransact.parseStringToSqlDate(planEndTime);
      if (planStartTime == null || planStartTime.equals("")) {
        planStartTime = "";
      }
      else {
        isFirst = false;
        sqlStr = sqlStr + " where to_char(CONTRACTSTARTDATE,'yyyy-MM-dd') >='" +
            planStartTime + "'";
      }
      if (planEndTime == null || planEndTime.equals("")) {
        planEndTime = "";
      }
      else {
        if (isFirst) {
          isFirst = false;
          sqlStr = sqlStr + " where to_char(CONTRACTENDDATE,'yyyy-MM-dd') <='" +
              planEndTime + "'";
        }
        else {
          sqlStr = sqlStr + " and to_char(CONTRACTENDDATE,'yyyy-MM-dd') <='" +
              planEndTime + "'";
        }
      }
      if (contractOwner == null || contractOwner.equals("")) {
        contractOwner = "";
      }
      else {
        if (isFirst) {
          isFirst = false;
          sqlStr = sqlStr + " where contractOwner ='" + contractOwner + "'";
        }
        else {
          sqlStr = sqlStr + " and contractOwner ='" + contractOwner + "'";
        }
      }
      if (contractEntity == null || contractEntity.equals("")) {
        contractEntity = "";
      }
      else {
        if (isFirst) {
          isFirst = false;
          sqlStr = sqlStr + " where contractEntity ='" + contractEntity + "'";
        }
        else {
          sqlStr = sqlStr + " and  contractEntity ='" + contractEntity + "'";
        }
      }
      if (contractIsSell == null || contractIsSell.equals("")) {
        contractIsSell = "";
      }
      else {
        if (isFirst) {
          isFirst = false;
          sqlStr = sqlStr + " where  contractIsSell ='" + contractIsSell + "'";
        }
        else {
          sqlStr = sqlStr + " and contractIsSell = '" + contractIsSell + "'";

        }
      }

      this.TwosqlStr = sqlStr;
      contract = contractoperate.getOnePageData(sqlStr, db, 1);

   }
   else
   {
     int k = Integer.parseInt(PageNum);
     String s =this.TwosqlStr;
     contract = contractoperate.getOnePageData(TwosqlStr, db,k );
   }

    httpServletRequest.setAttribute("contractlist", contract);
    httpServletRequest.setAttribute("contractoperate",contractoperate);

    return (actionMapping.findForward(PageForward));
  }
}