package com.ICT.AFC.contract.actions;

import com.ICT.AFC.contract.forms.*;
import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import com.ICT.AFC.DB.DB;
import com.ICT.AFC.contract.beans.Contract;
import com.ICT.AFC.contract.beans.ContractOperate;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.lang.*;
import java.text.SimpleDateFormat;
import com.ICT.AFC.contracttree.beans.ContractTree;
import com.ICT.AFC.user.beans.User;
import org.apache.struts.upload.FormFile;
import java.io.InputStream;
import java.io.ByteArrayOutputStream;
import java.io.OutputStream;
import java.io.FileOutputStream;

public class addContractAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest Request,
                               HttpServletResponse Response) throws
      Exception {

    HttpSession session = Request.getSession();
    //獲取數據源
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);
    String PageForward = "addcontractinfok";
    //聲明form對象
    ContractForm ContractForm = (ContractForm) actionForm;
    FormFile file = ContractForm.getContractCopy(); //取得上傳的文件
    String filePath = "";

    try {
      InputStream stream = file.getInputStream(); //把文件讀入
      filePath = Request.getRealPath("/"); //取當前系統路徑
      ByteArrayOutputStream baos = new ByteArrayOutputStream();
      OutputStream bos = new FileOutputStream(filePath + "upload/" +
                                              file.getFileName()); //建立一個上傳文件的輸出流
      int bytesRead = 0;
      byte[] buffer = new byte[8192];
      while ( (bytesRead = stream.read(buffer, 0, 8192)) != -1) {
        bos.write(buffer, 0, bytesRead); //將文件寫入服務器
      }
      bos.close();
      stream.close();
    }
    catch (Exception e) {
      System.err.print(e);
    }

    Contract contract = new Contract();
    //獲取form表單的參數
    String contractNo = ContractForm.getContractNo(); //合同編號變量
    String contractCopy = filePath + "upload\\" + file.getFileName(); //合同原件路徑變量
    contract.setContractCopy(contractCopy);
    //contractNo = new String(contractNo.getBytes("ISO8859_1"));
    contract.setContractNo(contractNo);
    String contractEndDate = ContractForm.getContractEndDate(); //合同結束日期變量
    contract.setContractEndDate(contractEndDate);
    ////java.sql.Date contractEndDate = DateTransact.parseStringToSqlDate(contractEnd);//轉換成數據日期格式
    String contractEntity = ContractForm.getContractEntity(); //合同我方實體變量
    //contractEntity = new String(contractEntity.getBytes("ISO8859_1"));
    contract.setContractEntity(contractEntity);
    String contractIsSell = ContractForm.getContractIsSell(); //是否是銷售合同變量
    contract.setContractIsSell(contractIsSell);
    String contractIsPerside = ContractForm.getContractIsPerside();
    //contractIsPerside = new String(contractIsPerside.getBytes("ISO8859_1"));
    contract.setContractIsPerside(contractIsPerside);
    String contractMoneySys = ContractForm.getContractMoneySys(); //合同貨幣類型
    //contractMoneySys = new String(contractMoneySys.getBytes("ISO8859_1"));
    contract.setContractMoneySys(contractMoneySys);
    String contractName = ContractForm.getContractName(); //合同名稱
    //contractName = new String(contractName.getBytes("ISO8859_1"));
    contract.setContractName(contractName);
    String contractOtherSide = ContractForm.getContractOtherSide(); //合同對方實體
    //contractOtherSide = new String(contractOtherSide.getBytes("ISO8859_1"));
    contract.setContractOtherSide(contractOtherSide);
     String contractSubType =Request.getParameter("contractSubType"); //合同子合同
     contract.setContractSubType(contractSubType);
    String contractOwner =Request.getParameter("contractOwner"); //合同歸屬部門
    //contractOwner = new String(contractOwner.getBytes("ISO8859_1"));
    contract.setContractOwner(contractOwner);
    String contractRealTotal = ContractForm.getContractRealTotal(); //所合同實際金額
    contract.setContractRealTotal(contractRealTotal);
    String contractRemark = ContractForm.getContractRemark(); //合同備注
    //contractRemark = new String(contractRemark.getBytes("ISO8859_1"));
    contract.setContractRemark(contractRemark);
    String contractsignDate = ContractForm.getContractSignDate(); //合同注冊日期
    contract.setContractSignDate(contractsignDate);
    String contractSigner = ContractForm.getContractSigner(); //合同簽訂人
    //contractSigner = new String(contractSigner.getBytes("ISO8859_1"));
    contract.setContractSigner(contractSigner);
    String contractSource = ContractForm.getContractSource(); //合同來源變量
    //contractSource = new String(contractSource.getBytes("ISO8859_1"));
    contract.setContractSource(contractSource);
    String contractstartDate = ContractForm.getContractStartDate(); //合同開始日期變量
    contract.setContractStartDate(contractstartDate);
    String contractsubtype = ContractForm.getContractSubType(); //合同類型
    contract.setContractSubType(contractsubtype);
    String contractTotal = ContractForm.getContractTotal(); //合同總額變量
    contract.setContractTotal(contractTotal);
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
    String contractrddate = sdf.format(new Date()); //獲取系統時間
    contract.setContractRdDate(contractrddate);

    User user = (User) session.getAttribute("USER");
    contract.setContractrdaccout(user.getUserAccount());
    ContractOperate.addContract(db, contract); //添加合同信息到數據庫

    String treestr = ContractTree.getTree(db, user);
    session.setAttribute("CONTRACTTREE", treestr); //獲取樹型結構
    session.setAttribute("SEARCHCONTRACTINFO",
                         ContractOperate.searchContract(db, 0));

    db.close();
    return (actionMapping.findForward(PageForward));

  }
}