package com.saas.biz.goodsStockMgr;

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

import com.saas.biz.goodsMgr.GoodsInfo;

import com.saas.biz.commen.commMethodMgr;
import com.saas.biz.dao.goodsStockDAO.GoodsStockDAO;
import com.saas.biz.dao.goodsStockDAO.GoodsStockExt;
import com.saas.sys.buffer.Buffers;
import com.saas.sys.dbm.Dbtable;
import com.saas.sys.exp.SaasApplicationException;
import com.saas.sys.log.Logger;
import com.saas.biz.custMgr.*;

public class GoodsStockInfo {

	Dbtable tradeQuery;

	commMethodMgr comm;

	Logger log;

	Buffers inBuffer;

	Buffers outBuffer;

	ArrayList queryResult = new ArrayList();

	public GoodsStockInfo() {

		log = new Logger(this);
		tradeQuery = new Dbtable();
		comm = new commMethodMgr();
	}

	public void setTradeQuery(Dbtable tradeQuery) {

		this.tradeQuery = tradeQuery;
	}

	public Dbtable getTradeQuery() {

		return this.tradeQuery;
	}

	public void setOutBuffer(Buffers outBuffer) {

		this.outBuffer = outBuffer;
	}

	public Buffers getOutBuffer() {

		return this.outBuffer;
	}

	public ArrayList getQueryResult() {

		return this.queryResult;
	}

	public void setQueryResult(ArrayList queryResult) {

		this.queryResult = queryResult;
	}

	/**
	 * 新增群組 user_id:是多個人員的id,以|分隔
	 * 
	 * @param inbuffer
	 */
	public void addGoodsStockInfo(Buffers inbuffer) {

		log.LOG_INFO("進入addGoodsStockInfo方法...");
		this.outBuffer = inbuffer;
		this.inBuffer = inbuffer;
		int iResult = -1;
		String cust_id = inbuffer.getString("SESSION_CUST_ID");
		String goods_id = inbuffer.getString("GOODS_ID");
		String stock_type = inbuffer.getString("STOCK_TYPE");
		String quo_num = inbuffer.getString("QUO_NUM");
		String trade = inbuffer.getString("TRADE");
		String user_id = inbuffer.getString("SESSION_USER_ID");
		String publish_date = inbuffer.getString("PUBLISH_DATE");
		String remark = inbuffer.getString("REMARK2");
		GoodsInfo info = new GoodsInfo();
		int i = info.checkGoods(cust_id, goods_id);
		try {
			if (i == 0) {
				iResult = insertGoodsStockInfo(cust_id, goods_id, stock_type,
						trade, quo_num, user_id, publish_date, remark);
			} else {
				iResult = updateGoodsStockInfo(cust_id, goods_id, stock_type,
						trade, quo_num, user_id, publish_date, remark);
			}
		} catch (Exception e) {
			log.LOG_INFO(e.getMessage());
		}
		if (iResult != 0) {
			this.outBuffer.setInt("RESULT_CODE", -1);
			this.outBuffer.setString("RESULT_INFO", "業務處理失敗！");
		} else {
			this.outBuffer.setInt("RESULT_CODE", 0);
			this.outBuffer.setString("RESULT_INFO", "業務處理成功！");
		}
		log.LOG_INFO("退出addGoodsInfo方法...");
	}

	public int insertGoodsStockInfo(String cust_id, String goods_id,
			String stock_type, String trade, String quo_num, String user_id,
			String publish_date, String remark) throws SaasApplicationException {

		GoodsStockExt goodsStockExt = new GoodsStockExt();
		goodsStockExt.setParam(":VCUST_ID", cust_id);
		goodsStockExt.setParam(":VGOODS_ID", goods_id);
		goodsStockExt.setParam(":VSTOCK_TYPE", stock_type);
		goodsStockExt.setParam(":VTRADE", trade);
		goodsStockExt.setParam(":VQUO_NUM", quo_num);
		goodsStockExt.setParam(":VUSER_ID", user_id);
		goodsStockExt.setParam(":VPUBLISH_DATE", publish_date);
		goodsStockExt.setParam(":VREMARK", remark);
		tradeQuery.executeBy(goodsStockExt.insBy("INS_All_GOODS_STOCK"));
		return 0;
	}

	public int updateGoodsStockInfo(String cust_id, String goods_id,
			String stock_type, String trade, String quo_num, String user_id,
			String publish_date, String remark) throws SaasApplicationException {
		GoodsStockExt goodsStockExt = new GoodsStockExt();
		goodsStockExt.setParam(":VCUST_ID", cust_id);
		goodsStockExt.setParam(":VGOODS_ID", goods_id);
		goodsStockExt.setParam(":VSTOCK_TYPE", stock_type);
		goodsStockExt.setParam(":VTRADE", trade);
		goodsStockExt.setParam(":VQUO_NUM", quo_num);
		goodsStockExt.setParam(":VUSER_ID", user_id);
		goodsStockExt.setParam(":VPUBLISH_DATE", publish_date);
		goodsStockExt.setParam(":VREMARK", remark);
		tradeQuery.executeBy(goodsStockExt.insBy("UPDATE_All_GOODS_STOCK"));
		return 0;
	}

}