package com.bookstore.other;


import java.io.IOException;
import java.sql.SQLException;
import java.util.Map;
import java.util.Vector;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bookstore.BookStoreConst;
import com.bookstore.svlt.ParamServlet;
import com.bookstore.user.BsUserInfo;

/**
* @author zhangh
* Date 2006-5-18
* Window - Preferences - Java - Code Style - Code Templates
*/
public class SvltBsOther extends ParamServlet
{
	/**
	 * 
	 */
	private static final long serialVersionUID = -7839280465808460238L;
	BsOtherInfo	other	= null;
	BsUserInfo userinfo = null;
	
	public void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
	{
		try
		{
			super.byHttpService(request, response, BookStoreConst.ENCODING);
			other = new BsOtherInfo(BookStoreConst.BOOKSTORESPOOL);
			userinfo = new BsUserInfo(BookStoreConst.BOOKSTORESPOOL);
			action = request.getParameter("action");
			System.out.println("action = "+action);
			if (action.equals("addPayment"))//添加送貨方式
			{
				String paymentName = request.getParameter("paymentName");
				String fee = request.getParameter("fee");
				other.addPayment(paymentName,fee);
				url = BookStoreConst.JSPPaymentManager +"?info=1";
			} 
			else if(action.equals("editPayment"))	//修改送貨方式
			{
				String id = request.getParameter("id");
				String paymentName = request.getParameter("paymentName");
				String fee = request.getParameter("fee");
				String keepPrice = request.getParameter("keepPrice");
				String time = request.getParameter("time");
				String description = request.getParameter("description");
				other.modifyPayment(id,paymentName,fee,keepPrice,time,description);
				url = BookStoreConst.JSPPaymentManager +"?info=2";
			}
			else if(action.equals("delPayment"))//刪除送貨方式
			{
				String id = request.getParameter("id");
				other.deletePayment(id);
				url = BookStoreConst.JSPPaymentManager +"?info=3";
			}
			else if(action.equals("addPaymentType"))//添加支付方式
			{
				String paymentName = request.getParameter("paymentName");
				String time = request.getParameter("time");
				String description  = request.getParameter("description");
				String sort = request.getParameter("sort");	
				other.addPaymentType(paymentName,time,description,sort);
				url = BookStoreConst.JSPPayManager +"?info=1";
			}
			else if(action.equals("editPaymentType"))//修改支付方式
			{
				String id = request.getParameter("id");
				String paymentName = request.getParameter("paymentName");
				String time = request.getParameter("time");
				String description  = request.getParameter("description");
				String sort = request.getParameter("sort");	
				other.modifyPaymentType(id,paymentName,time,description,sort);
				url = BookStoreConst.JSPPayManager +"?info=2";
			}
			else if(action.equals("delPaymentType"))//刪除支付方式
			{
				String id = request.getParameter("id");
				other.delPaymentType(id);
				url = BookStoreConst.JSPPayManager +"?info=3";
			}
			else if(action.equals("addProvince"))//添加省信息
			{
				String shengname = request.getParameter("shengname");
				String shengno = request.getParameter("shengno");
				String sort=request.getParameter("sort");
				other.addProvince(shengname,shengno,sort);
				url = BookStoreConst.JSPProvince+"?info=1";		
			}
			else if(action.equals("editProvince"))//修改省信息
			{
				String id = request.getParameter("id");
				String shengname = request.getParameter("shengname");
				String shengno = request.getParameter("shengno");
				String sort=request.getParameter("sort");
				other.modifyProvince(id,shengname,shengno,sort);
				url = BookStoreConst.JSPProvince+"?info=2";		
			}
			else if(action.equals("delProvince"))//刪除省信息
			{
				String id = request.getParameter("id");
				other.delProvince(id);
				url = BookStoreConst.JSPProvince+"?info=3";		
			}
			else if(action.equals("addCollaborate"))//添加合作伙伴
			{
				String netName = request.getParameter("netName");
				String netAddress = request.getParameter("netAddress");
				String sort = request.getParameter("sort");
				other.addCollaborate(netName,netAddress,sort);
				url = BookStoreConst.JSPCollaborate+"?info=1";
			}
			else if(action.equals("editCollaborate"))//修改合作伙伴
			{
				String id = request.getParameter("id");
				String netName = request.getParameter("netName");
				String netAddress = request.getParameter("netAddress");
				String sort = request.getParameter("sort");
				other.modifyCollaborate(id,netName,netAddress,sort);
				url = BookStoreConst.JSPCollaborate+"?info=2";
			}
			else if(action.equals("delCollaborate"))//刪除合作伙伴
			{
				String id = request.getParameter("id");
				other.delCollaborate(id);
				url = BookStoreConst.JSPCollaborate+"?info=3";
			}
			else if(action.equals("addNews"))//添加新聞
			{
				String title = request.getParameter("title");
				String type = request.getParameter("type");
				String content = request.getParameter("content");
				other.addNews(title,type,content);
				url = BookStoreConst.JSPNewsManager;
			}
			else if(action.equals("delNews"))//刪除新聞
			{
				String id = request.getParameter("id");
				other.delNews(id);
				url = BookStoreConst.JSPNewsManager;
			}
			else if(action.equals("editNews"))//修改新聞
			{
				String id = request.getParameter("id");
				String title = request.getParameter("title");
				String type = request.getParameter("type");
				String content = request.getParameter("content");
				other.modifyNews(id,title,type,content);
				url = BookStoreConst.JSPNewsManager;
			}
			else if(action.equals("addCity"))//添加市
			{
				String shengid = request.getParameter("shengid");
				String cityName = request.getParameter("cityName");
				String cityNumber = request.getParameter("cityNumber");
				String sort = request.getParameter("sort");
				other.addCity(shengid,cityName,cityNumber,sort);
				url = BookStoreConst.JSPCityManager+"?info=1";
			}
			else if(action.equals("editCity"))//修改市信息
			{
				String cityid = request.getParameter("id");
				String shengid = request.getParameter("shengid");
				String cityName = request.getParameter("cityName");
				String cityNumber = request.getParameter("cityNumber");
				String sort = request.getParameter("sort");
				other.modifyCity(cityid,shengid,cityName,cityNumber,sort);
				url = BookStoreConst.JSPCityManager+"?info=2";
			}
			else if(action.equals("delCity"))//刪除市信息
			{
				String cityid = request.getParameter("id");
				other.delCity(cityid);
				url = BookStoreConst.JSPCityManager+"?info=3";
			}
			else if(action.equals("editContent"))//修改信息內容
			{
				String content = request.getParameter("Content");
				String type = request.getParameter("type");
				other.modifyOtherInfo(type,content);
				url = BookStoreConst.JSPOtherInfoManager+"?type="+type +"&info=1";
			}
			else if(action.equals("deal"))//生成定單
			{
				String userId = request.getParameter("userId");
				String receiveMan = request.getParameter("receiveMan");
				String linkMan = request.getParameter("linkMan");
				String address = request.getParameter("address");
				String phone = request.getParameter("phone");
				String province = request.getParameter("province");
				String city = request.getParameter("city");
				String district = request.getParameter("district");
				String zip = request.getParameter("zip");
				String mobilePhone = request.getParameter("mobilePhone");
				String paymentType = request.getParameter("paymentType");
				String carrierType = request.getParameter("carrierType");
				String sumPrice = request.getParameter("sumPrice");
				String cartIdArray = request.getParameter("cartIds");
				String orderId = ""+other.deal( userId,receiveMan, linkMan,
						 address, phone, province, city, district,
						 zip, mobilePhone, paymentType,
						 carrierType, Double.parseDouble(sumPrice));
				String cartIds[] = null;
				if(cartIdArray!=null)
				{
					cartIds = cartIdArray.split(",");
					for(int i=1;i<cartIds.length;i++)
					{
						Vector carts = userinfo.getCartById(cartIds[i]);
						System.out.println("cartIds["+i+"] = "+cartIds[i]);
						Map cart = (Map)carts.get(0);
						String productType = (String)cart.get("productType");
						String commodityName =(String)cart.get("name");
						String isbn = (String)cart.get("isbn");
						sumPrice = (String)cart.get("sumPrice");
						String number = (String)cart.get("number");
						String price = Double.parseDouble(sumPrice)/Double.parseDouble(number)+"";
						dealOrder(commodityName,isbn,price,sumPrice,number,orderId,productType,cartIds[i]);
					}
				}
				url = request.getContextPath()+"/web/goodsInfo.jsp?orderId="+orderId;
			}
			else if(action.equals("addDistrict"))
			{
				String provinceId = request.getParameter("provinceId");
				String cityId = request.getParameter("cityId");
				String districtName = request.getParameter("districtName");
				String districtNumber = request.getParameter("districtNumber");
				String sort = request.getParameter("sort");
				other.addDistrict(cityId,districtName,districtNumber,sort);
				url = request.getContextPath()+"/admin/other/districtManage.jsp?provinceId="+provinceId+"&cityId="+cityId;
			}
			else if(action.equals("editDistrict"))
			{
				String id = request.getParameter("id");
				String provinceId = request.getParameter("provinceId");
				String cityId = request.getParameter("cityId");
				String districtName = request.getParameter("districtName");
				String districtNumber = request.getParameter("districtNumber");
				String sort = request.getParameter("sort");
				other.modifyDistrict(id,cityId,districtName,districtNumber,sort);
				url = request.getContextPath()+"/admin/other/districtManage.jsp?provinceId="+provinceId+"&cityId="+cityId;
			}
			else if(action.equals("deleteDistrict"))
			{
				String districId = request.getParameter("districtId");
				other.delDistrict(districId);
				String provinceId = request.getParameter("provinceId");
				String cityId = request.getParameter("cityId");
				url = request.getContextPath()+"/admin/other/districtManage.jsp?provinceId="+provinceId+"&cityId="+cityId;
			}
			url = response.encodeRedirectURL(url);
			response.sendRedirect(url);
		}
		catch (Exception ex)
		{
			ex.printStackTrace();
		}
	}
	
	private synchronized void dealOrder(String commodityName,String isbn,String price,String sumPrice,
			String number,String orderId,String productType,String cartId) throws SQLException
	{
		other.dealDetail(commodityName,isbn,price,sumPrice,number,orderId,productType);
		userinfo.cleanCartByCartId(cartId);
	}
}