package com.agent.controller.agent;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;

import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.shiro.SecurityUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.agent.controller.BasicController;
import com.agent.entity.Constant;
import com.agent.entity.agent.BasicAgentEntity;
import com.agent.entity.agent.ManifestBillEntity;
import com.agent.entity.agent.ManifestEntity;
import com.agent.entity.agent.PackageTypeEntity;
import com.agent.entity.agent.PreparesecondaryEntity;
import com.agent.entity.agent.PubDgEntity;
import com.agent.entity.agent.TBasCarrierEntity;
import com.agent.entity.agent.WaybillReceiptEntity;
import com.agent.entity.agent.WaybillReceiptType;
import com.agent.entity.system.UserEntity;
import com.agent.service.agent.BasicAgentService;
import com.agent.service.agent.ConsigneeService;
import com.agent.service.agent.ConsignorService;
import com.agent.service.agent.ManifestBillService;
import com.agent.service.agent.ManifestCommodityService;
import com.agent.service.agent.ManifestContainerService;
import com.agent.service.agent.ManifestService;
import com.agent.service.agent.PackageTypeService;
import com.agent.service.agent.PreparesecondaryService;
import com.agent.service.agent.PubDgService;
import com.agent.service.agent.TBasCarrierService;
import com.agent.service.agent.WaybillReceiptService;
import com.agent.service.system.RoleService;
import com.agent.util.HttpJsonMsg;
import com.agent.vo.ResponseModel;
import com.agent.vo.agent.CommodityVo;
import com.agent.xml.XmlBuildTask;
import com.agent.xml.common.XmlHead;
import com.agent.xml.common.XmlUtil;
import com.agent.xml.fhlsli.FSXmlKit;
import com.agent.xml.manifestdeclare.DeclarePreparemasterXmlBody;
import com.agent.xml.manifestdeclare.ManifestBorderTransportMeansXml;
import com.agent.xml.manifestdeclare.ManifestCarrierXml;
import com.agent.xml.manifestdeclare.ManifestConsignmentItemXml;
import com.agent.xml.manifestdeclare.ManifestConsignmentPackagingXml;
import com.agent.xml.manifestdeclare.ManifestConsignmentXml;
import com.agent.xml.manifestdeclare.ManifestConsignorXml;
import com.agent.xml.manifestdeclare.ManifestDeclarationXml;
import com.agent.xml.manifestdeclare.ManifestDeclareMetaXml;
import com.agent.xml.manifestdeclare.ManifestDeclareMsgXml;
import com.agent.xml.manifestdeclare.ManifestDesXml;
import com.agent.xml.manifestdeclare.ManifestFreightPaymentXml;
import com.agent.xml.manifestdeclare.ManifestLoadingLocationXml;
import com.agent.xml.manifestdeclare.ManifestOrgXml;
import com.agent.xml.manifestdeclare.ManifestTransportContractDocumentXml;
import com.agent.xml.manifestdeclare.ManifestUnloadingLocationXml;
import com.agent.xml.manifestdeclare.ManifestsAddressXml;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.framework.core.Servlets;
import com.framework.shiro.SessionUtil;
import com.framework.util.MessageKit;
import com.framework.util.MessageType;
import com.plugin.easyui.DataGrid;
import com.plugin.easyui.EasyPage;

import tools.DBConnection;
import tools.NumKit;
import tools.Tools;
import tools.oclass.FemyList;

/**
 * Created by cohesion on 2017/4/19.
 */
@Controller
@RequestMapping(value = "/manifest")
public class ManifestController extends BasicController {
	private static final Logger logger = LoggerFactory.getLogger(ManifestController.class);

	public static boolean isSuccess = false;

	@Resource
	private ManifestService manifestService;

	@Resource
	private PreparesecondaryService preparesecondaryServer;

	@Resource
	private ManifestBillService billService;

	@Resource
	private PackageTypeService packageTypeService;

	@Resource
	private ManifestCommodityService commodityService;

	@Resource
	private ManifestContainerService containerService;

	@Resource
	private RoleService roleService;

	@Resource
	private BasicAgentService agentService;

	@Resource
	private PubDgService dgService;

	@Resource
	private TBasCarrierService tbasService;

	@Resource
	private ConsignorService consignorService;

	@Resource
	private ConsigneeService consigneeService;

	@Resource
	private WaybillReceiptService receiptService;

	private BasicAgentEntity getAgent() {
		UserEntity user = Tools.getUserEntity();
		long agent_id = user.getAgent();
		System.err.println("agent_id-->" + agent_id);

		BasicAgentEntity agent = agentService.findOne(agent_id);
		if (agent == null) {
			agent = new BasicAgentEntity();
		}
		if (StringUtils.isBlank(agent.getThreeCode())) {
			agent.setThreeCode("");
		}

		if (StringUtils.isBlank(agent.getNameCn())) {
			agent.setNameCn("");
		}

		return agent;
	}

	/**
	 * 测试用，查看当前账号对应的代理人信息
	 * 
	 * @param reuqest
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/getAgent", method = { RequestMethod.GET })
	@ResponseBody
	public ResponseModel getAgentInfo(HttpServletRequest reuqest, HttpServletResponse response) {
		ResponseModel model = new ResponseModel();
		response.setHeader("Access-Control-Allow-Origin", "*");

		BasicAgentEntity agent = getAgent();
		model.setData(agent);

		return model;
	}

	@RequestMapping(value = "/checkRepeat", method = { RequestMethod.GET })
	@ResponseBody
	public ResponseModel checkRepeat(HttpServletRequest reuqest, HttpServletResponse response, int manifestId,
			String manifest_no) {
		ResponseModel model = new ResponseModel();
		response.setHeader("Access-Control-Allow-Origin", "*");

		List<ManifestEntity> list = manifestService.findByManifestNo(manifest_no);
		if (list == null || list.size() == 0) {
			model.setStatus(200);
		} else {
			ManifestEntity firt = list.get(0);
			if (firt.getId() != manifestId) {
				model.setStatus(500);
				model.setMsg("主单号不能重复");
			} else {
				model.setStatus(200);
			}
		}
		return model;
	}

	/**
	 * 列表页面
	 * 
	 * @return
	 */
	@RequestMapping(value = "/list")
	public String getList(HttpServletRequest request, Model model) {
		request.setAttribute("version", System.currentTimeMillis());
		return "manifest/list";
	}

	// app端接口
	// 获取主单列表
	@RequestMapping(value = "/cross/grid.json")
	@ResponseBody
	public DataGrid<ManifestEntity> cross_grid_json(HttpServletRequest request, HttpServletResponse response,
			EasyPage<ManifestEntity> pageForm) {
		// response.setCharacterEncoding("UTF-8");
		// response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate");
		// response.setHeader("Pragma", "no-cache");
		response.setHeader("Access-Control-Allow-Origin", "*");
		// response.setDateHeader("Expires", 0);

		Map<String, Object> searchParams = Servlets.getParametersStartingWith(request, "search_");
		if (Tools.getUserId() != null && Tools.getUserId() != 1) {
			// 不是管理员,添加用户id的条件
			searchParams.put("EQ_USER_ID", Tools.getUserId());
		}
		pageForm.setSearchParams(searchParams);

		pageForm.parseData(manifestService.getPage(pageForm));
		return pageForm.getData();
	}

	@RequestMapping(value = "/cross/edit")
	@ResponseBody
	public Map cross_edit(Long id, HttpServletResponse response) {
		System.out.println("id：" + id);
		response.setHeader("Access-Control-Allow-Origin", "*");
		Map model = new HashMap();
		ManifestEntity manifest = null;
		// 判断是否是便捷
		if (id != null) {
			manifest = manifestService.findOne(id);
		}

		UserEntity user = SessionUtil.getUser();
		if (user != null && user.getAgent() != null) {
			BasicAgentEntity agent = agentService.findOne(user.getAgent());
			model.put("agent", agent);
			if (id == null) // 是新增表单
			{
				manifest = new ManifestEntity();
				manifest.setAgentcompany(agent.getNameCn());
				manifest.setAgentman(null); // 设置代理人名称为null
			}
		}
		model.put("manifest", manifest);
		// 海关关区
		List<String> Customs = getCustomsCode();
		model.put("CusToms", Customs);
		// 付款方式
		List<String> payTypes = getPayTypes();
		model.put("payTypes", payTypes);
		// 海关状态
		List<String> customsStatus = getcustomsStatus();
		model.put("customsStatus", customsStatus);

		// 危险品代码
		List<PubDgEntity> dgList = dgService.findAll();
		model.put("dgList", dgList);

		// 包装种类
		List<PackageTypeEntity> typeList = packageTypeService.findAll();
		model.put("typeList", typeList);

		// model.addAttribute("customsStatus",flag);
		return model;
	}

	// 保存或新增
	@RequestMapping(value = "/cross/save", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel cross_save(ManifestEntity manifest, HttpServletRequest reuqest, HttpServletResponse response) {
		ResponseModel model = new ResponseModel();
		response.setHeader("Access-Control-Allow-Origin", "*");
		try {
			manifest.setUSER_ID(Tools.getUserId());
			if (manifestService.isExistsByWaybill(manifest)) {
				model.setMsg("该订单已存在！");
				model.setStatus(500);
			} else {
				String stowagedate = reuqest.getParameter("stowagedate");
				manifest.setStowagedate(manifest.getStowagedate(stowagedate));
				// 处理预配时间
				manifest.setUSER_ID(SessionUtil.getUser().getId()); // 设置用户id
				manifest = manifestService.save(manifest);
				model.setData(manifest);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	// 保存并发送主单信息
	@RequestMapping(value = "/cross/savesend", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel cross_savesend(ManifestEntity manifest, HttpServletRequest request,
			HttpServletResponse response) {
		ResponseModel model = new ResponseModel();
		response.setHeader("Access-Control-Allow-Origin", "*");
		try {
			manifest.setUSER_ID(Tools.getUserId());
			if (manifestService.isExistsByWaybill(manifest)) {
				model.setStatus(500);
				model.setMsg("该订单号已存在！");
			} else {
				String stowagedate = request.getParameter("stowagedate");
				manifest.setStowagedate(manifest.getStowagedate(stowagedate));
				// 保存
				manifest.setIsdelete(1);
				manifest.setResponse_text("主单已发送");
				manifestService.save(manifest);
				System.out.println("收货人名称：" + manifest.getSh_name());
				System.out.println("发货人名称：" + manifest.getCo_name());
				System.out.println("-----------------id:" + manifest.getId());
				// 生成报文并且发送
				String rootPath = request.getSession().getServletContext().getRealPath("/");
				String path = rootPath + "/excel/manifest" + new Date().getTime() + ".xml";

				// String ndlrxml = XmlUtil.convertToXml2(manifestService.sendNDLRXml(manifest),
				// path);
				// String dlcfxml = XmlUtil.convertToXml2(manifestService.sendDLCFXml(manifest),
				// path);
				//
				// new XmlSendTask(ndlrxml).send();
				// new XmlSendTask(dlcfxml).send();

				new XmlBuildTask(manifestService.sendNDLRXml(manifest), path).perform();
				new XmlBuildTask(manifestService.sendDLCFXml(manifest), path).perform();

				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	// 分单列表获取接口
	@RequestMapping(value = "/cross/sub/grid.json")
	@ResponseBody
	public DataGrid<PreparesecondaryEntity> cross_gridSub(Long mawbId, HttpServletRequest request,
			HttpServletResponse response) {
		response.setHeader("Access-Control-Allow-Origin", "*");
		DataGrid<PreparesecondaryEntity> dg = new DataGrid<>();
		dg.setRows(preparesecondaryServer.findByMawbId(mawbId));
		return dg;
	}

	// 获取一条分单详情的接口
	@RequestMapping(value = "/cross/subedit", method = { RequestMethod.POST })
	@ResponseBody
	private Map subedit(Long id, Long mawbId, HttpServletResponse response) {
		Map model = new HashMap();
		ManifestEntity manifest = null;
		List<PreparesecondaryEntity> preparesecondaryList = null;
		PreparesecondaryEntity pre = null;
		String str = "";
		response.setHeader("Access-Control-Allow-Origin", "*");
		if (mawbId != null) {
			manifest = manifestService.findOne(mawbId);
			pre = preparesecondaryServer.findOne(mawbId);
			preparesecondaryList = preparesecondaryServer.findAll(manifest.getId());
			if (preparesecondaryList.isEmpty()) {
				str = calculate(manifest);
			} else {
				str = calculates(manifest, preparesecondaryList);
			}
		}
		if (id != null) {
			pre = preparesecondaryServer.findOne(id);
			manifest = manifestService.findOne(pre.getPreparemasterid());
			preparesecondaryList = preparesecondaryServer.findAll(manifest.getId());
			if (preparesecondaryList.isEmpty()) {
				str = calculate(manifest);
			} else {
				str = calculates(manifest, preparesecondaryList);
			}
		}

		UserEntity user = SessionUtil.getUser();
		if (user != null && user.getAgent() != null) {
			BasicAgentEntity agent = agentService.findOne(user.getAgent());
			model.put("agent", agent);
		}
		// 海关关区
		List<String> Customs = getCustomsCode();
		model.put("CusToms", Customs);
		// 付款方式
		List<String> payTypes = getPayTypes();
		model.put("payTypes", payTypes);
		// 海关状态
		List<String> customsStatus = getcustomsStatus();
		model.put("customsStatus", customsStatus);

		// 危险品代码
		List<PubDgEntity> dgList = dgService.findAll();
		model.put("dgList", dgList);

		// 包装种类
		List<PackageTypeEntity> typeList = packageTypeService.findAll();
		model.put("typeList", typeList);

		model.put("is_strs", str);
		model.put("id", mawbId);
		model.put("manifest", manifest);
		model.put("pre", pre);

		return model;
	}

	// 保存分单
	@RequestMapping(value = "/cross/sub_save", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel cross_sub_save(PreparesecondaryEntity Preparesecondary, HttpServletResponse response) {
		ResponseModel model = new ResponseModel();
		try {
			response.setHeader("Access-Control-Allow-Origin", "*");
			// 已存在，提示给用户
			if (preparesecondaryServer.isExists(Preparesecondary)) {
				model.setStatus(500);
				model.setMsg("该订单号已存在！");
			} else {
				Preparesecondary.setCreateDate(new Date());
				Preparesecondary = preparesecondaryServer.save(Preparesecondary);
				model.setData(Preparesecondary);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	@RequestMapping(value = "/cross/presavesend", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel cross_presavesend(PreparesecondaryEntity Preparesecondary, HttpServletRequest request,
			HttpServletResponse response) {
		ResponseModel model = new ResponseModel();
		try {
			response.setHeader("Access-Control-Allow-Origin", "*");
			if (preparesecondaryServer.isExists(Preparesecondary)) {
				model.setStatus(500);
				model.setMsg("该订单号已存在！");
			} else {
				String stowagedate = request.getParameter("stowagedate");
				Preparesecondary.setStowagedate(Preparesecondary.getStowagedate(stowagedate));

				// 生成报文并且发送
				String rootPath = request.getSession().getServletContext().getRealPath("/");
				String path = rootPath + "/excel/manifest" + new Date().getTime() + ".xml";

				// String ndlrxml =
				// XmlUtil.convertToXml2(manifestService.presenddlcfNdlrXml(Preparesecondary),
				// path);
				// String dlcfxml =
				// XmlUtil.convertToXml2(manifestService.presenddlcfNdlrXml(Preparesecondary),
				// path);
				// new XmlSendTask(ndlrxml).send();
				// new XmlSendTask(dlcfxml).send();

				new XmlBuildTask(manifestService.presenddlcfNdlrXml(Preparesecondary), path).perform();
				new XmlBuildTask(manifestService.presenddlcfNdlrXml(Preparesecondary), path).perform();

				model.setData(Preparesecondary);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);

				Preparesecondary.setIsdelete(1);
				Preparesecondary.setResponse_text("分单已发送");
				preparesecondaryServer.save(Preparesecondary);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 查询分页数据
	 * 
	 * @return
	 */
	@RequestMapping(value = "/grid.json")
	@ResponseBody
	public DataGrid<ManifestEntity> grid(HttpServletRequest request, EasyPage<ManifestEntity> pageForm) {
		Map<String, Object> searchParams = Servlets.getParametersStartingWith(request, "search_");
		// searchParams.put("EQ_isdelete", 0);
		pageForm.setSearchParams(searchParams);
		// UserEntity ue =
		// (UserEntity)SecurityUtils.getSubject().getSession().getAttribute("user");
		UserEntity ue = (UserEntity) SecurityUtils.getSubject().getSession().getAttribute("user");
		if (ue != null) {
			Long u = ue.getId();
			Set<String> sk = pageForm.getSearchParams().keySet();

			if (Tools.getUserId() != null && Tools.getUserId() != 1) {
				// 不是管理员,添加用户id的条件
				pageForm.getSearchParams().put("EQ_USER_ID", u);
			}
		}

		pageForm.parseData(manifestService.getPage(pageForm));
		return pageForm.getData();
	}

	/**
	 * * 模糊查询匹配信息
	 *
	 * @param manifest
	 * @return
	 * @return
	 */
	@RequestMapping(value = "/infor")
	@ResponseBody
	public List<ManifestEntity> infor(String id, Model model) {
		List<ManifestEntity> li = null;
		if (Tools.getUserId() != null && Tools.getUserId().longValue() == 1) {
			li = manifestService.queryAll();
		} else {
			li = manifestService.queryByUserId(Tools.getUserId());
		}

		List<ManifestEntity> result = new FemyList();
		for (ManifestEntity me : li) {
			if (result.contains(me)) {
			} else {
				result.add(me);
			}
		}
		return result;
	}

	/**
	 * * 模糊查询匹配信息
	 *
	 * @param manifest
	 * @return
	 * @return
	 */
	@RequestMapping(value = "/inforPre")
	@ResponseBody
	public List<PreparesecondaryEntity> inforPre(String id, Model model) {
		List<PreparesecondaryEntity> li = preparesecondaryServer.queryByUserId(Tools.getUserId());
		List<PreparesecondaryEntity> result = new FemyList();
		for (PreparesecondaryEntity pe : li) {
			if (result.contains(pe)) {

			} else {
				result.add(pe);
			}
		}
		return result;
	}

	/**
	 * 编辑
	 *
	 * @param id
	 * @return
	 */
	@RequestMapping(value = "/edit")
	public String edit(HttpServletRequest request, Long id, Model model) {
		request.setAttribute("version", System.currentTimeMillis());
		ManifestEntity manifest = null;
		// 判断是否是便捷
		if (id != null) {
			manifest = manifestService.findOne(id);
		}

		UserEntity user = SessionUtil.getUser();
		if (user != null && user.getAgent() != null) {
			BasicAgentEntity agent = agentService.findOne(user.getAgent());
			model.addAttribute("agent", agent);
			if (id == null) // 是新增表单
			{
				manifest = new ManifestEntity();
				manifest.setAgentcompany(agent.getNameCn());
				manifest.setAgentman(""); // 设置代理人名称为null
			}
		}
		model.addAttribute("manifest", manifest);
		// 海关关区
		List<String> Customs = getCustomsCode();
		model.addAttribute("CusToms", Customs);
		// 付款方式
		List<String> payTypes = getPayTypes();
		model.addAttribute("payTypes", payTypes);
		// 海关状态
		List<String> customsStatus = getcustomsStatus();
		model.addAttribute("customsStatus", customsStatus);

		// 危险品代码
		List<PubDgEntity> dgList = dgService.findAll();
		model.addAttribute("dgList", dgList);

		// 包装种类
		List<PackageTypeEntity> typeList = packageTypeService.findAll();
		model.addAttribute("typeList", typeList);
		request.setAttribute("version", System.currentTimeMillis());
		// model.addAttribute("customsStatus",flag);

		String waybill_no = manifest != null ? manifest.getWaybillnomaster() : "";
		WaybillReceiptEntity receipt = receiptService.findMain(waybill_no);
		request.setAttribute("receipt", receipt);

		return "manifest/edit";
	}

	/**
	 * 查询主单号是否存在
	 *
	 * @param mawbNo
	 * @return
	 */
	@RequestMapping(value = "/queryMawbNo", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel queryMawbId(Long id, String mawbNo) {
		ResponseModel model = new ResponseModel();
		List<ManifestEntity> list = null;
		if (StringUtils.isNotEmpty(mawbNo)) {
			list = manifestService.findByMawbNo(mawbNo);
		}
		boolean exist = false;
		if (CollectionUtils.isNotEmpty(list)) {
			if (list.size() > 0) {
				exist = true;
			}
		}
		if (exist) {
			model.setStatus(500);
		} else {
			model.setStatus(200);
		}
		return model;
	}

	/**
	 * 查询分制单分页数据
	 * 
	 * @return
	 */
	@RequestMapping(value = "/sub/grid.json")
	@ResponseBody
	public DataGrid<PreparesecondaryEntity> gridSub(Long mawbId, HttpServletRequest request) {
		DataGrid<PreparesecondaryEntity> dg = new DataGrid<>();
		dg.setRows(preparesecondaryServer.findByMawbId(mawbId));
		return dg;
	}

	/**
	 * 编辑
	 *
	 * @param id
	 * @return
	 */
	@RequestMapping(value = "/subedit", method = { RequestMethod.GET })
	private String subedit(HttpServletRequest request, Long id, Long mawbId, String type, Model model) {
		request.setAttribute("version", System.currentTimeMillis());
		ManifestEntity manifest = null;
		List<PreparesecondaryEntity> preparesecondaryList = null;
		PreparesecondaryEntity pre = null;
		String str = "";
		if (mawbId != null) {
			manifest = manifestService.findOne(mawbId);
			pre = preparesecondaryServer.findOne(mawbId);

			preparesecondaryList = preparesecondaryServer.findAll(manifest.getId());
			if (preparesecondaryList.isEmpty()) {
				str = calculate(manifest);
			} else {
				str = calculates(manifest, preparesecondaryList);
			}
		}
		if (id != null) {
			pre = preparesecondaryServer.findOne(id);

			manifest = manifestService.findOne(pre.getPreparemasterid());
			preparesecondaryList = preparesecondaryServer.findAll(manifest.getId());
			if (preparesecondaryList.isEmpty()) {
				str = calculate(manifest);
			} else {
				str = calculates(manifest, preparesecondaryList);
			}
		}

		UserEntity user = SessionUtil.getUser();
		if (user != null && user.getAgent() != null) {
			BasicAgentEntity agent = agentService.findOne(user.getAgent());
			model.addAttribute("agent", agent);
		}
		// 海关关区
		List<String> Customs = getCustomsCode();
		model.addAttribute("CusToms", Customs);
		// 付款方式
		List<String> payTypes = getPayTypes();
		model.addAttribute("payTypes", payTypes);
		// 海关状态
		List<String> customsStatus = getcustomsStatus();
		model.addAttribute("customsStatus", customsStatus);

		// 危险品代码
		List<PubDgEntity> dgList = dgService.findAll();
		model.addAttribute("dgList", dgList);

		// 包装种类
		List<PackageTypeEntity> typeList = packageTypeService.findAll();
		model.addAttribute("typeList", typeList);

		model.addAttribute("is_strs", str);
		model.addAttribute("id", mawbId);
		model.addAttribute("manifest", manifest);

		if (pre == null) {
			pre = new PreparesecondaryEntity();
			pre.setCarrier(manifest.getCarrier());//承运人
			pre.setFlightno(manifest.getFlightno());//航班号
			pre.setFlightdate(manifest.getFlightdate());//航班日期
			pre.setOriginatingstation(manifest.getOriginatingstation());//起始站
			pre .setCustomscode(manifest.getCustomscode());//海关关区
			pre.setDelivery_station(manifest.getDelivery_station());//交运货站
			pre.setDe_type(manifest.getDe_type());//交运类型
		}
		model.addAttribute("pre", pre);
		request.setAttribute("version", System.currentTimeMillis());

		String waybill_no = manifest != null ? manifest.getWaybillnomaster() : "";
		String sub_waybill_no = "";
		if (pre != null && pre.getWaybillnosecondary() != null) {
			sub_waybill_no = pre.getWaybillnosecondary();
		}
		WaybillReceiptEntity receipt = receiptService.findSub(waybill_no, sub_waybill_no);
		request.setAttribute("receipt", receipt);

		return "manifest/sub_edit";
	}

	// 计算 运单件数 运单重量 预配件数 预配重量
	private String calculates(ManifestEntity manifest, List<PreparesecondaryEntity> preparesecondaryList) {
		if (manifest == null || preparesecondaryList == null || preparesecondaryList.isEmpty()) {
			System.err.println("calculate() manifest or preparesecondaryList is null");
			return "";
		}

		int pp = 0;
		float tw = 0;
		int tp = 0;
		float pw = 0;

		for (PreparesecondaryEntity pre : preparesecondaryList) {
			pp += NumKit.parseInt(pre.getPreparepiece());
			tw += NumKit.parseFloat(pre.getTotalweight());
			tp += NumKit.parseInt(pre.getTotalpiece());
			pw += NumKit.parseFloat(pre.getPrepareweight());
		}

		int zpp = NumKit.parseInt(manifest.getPreparetotalpiece()) - pp;
		float ztw = NumKit.parseFloat(manifest.getTotalweight()) - tw;
		ztw = ztw < 0 ? 0 : ztw;
		int ztp = NumKit.parseInt(manifest.getTotalpiece()) - tp;
		float zpw = NumKit.parseFloat(manifest.getPreparetotalweight()) - pw;
		zpw = zpw < 0 ? 0 : zpw;

		String str = "{";
		str += "\"id\":\"" + manifest.getId() + "\",";
		str += "\"waybillnomaster\":\"" + manifest.getWaybillnomaster() + "\",";
		str += "\"totalpiece\":\"" + ztp + "\",";
		str += "\"totalweight\":\"" + NumKit.formatNumber(String.valueOf(ztw), 2) + "\",";
		str += "\"preparetotalpiece\":\"" + zpp + "\",";
		str += "\"preparetotalweight\":\"" + NumKit.formatNumber(String.valueOf(zpw), 2) + "\"";
		str += "}";
		return str;
	}

	// 计算 运单件数 运单重量 预配件数 预配重量
	private String calculate(ManifestEntity manifest) {
		if (manifest == null) {
			System.err.println("calculate() manifest is null");
			return "";
		}

		String str = "{";
		str += "\"id\":\"" + manifest.getId() + "\",";
		str += "\"waybillnomaster\":\"" + manifest.getWaybillnomaster() + "\",";
		str += "\"totalpiece\":\"" + manifest.getTotalpiece() + "\",";
		str += "\"totalweight\":\"" + manifest.getTotalweight() + "\",";
		str += "\"preparetotalpiece\":\"" + manifest.getPreparetotalpiece() + "\",";
		str += "\"preparetotalweight\":\"" + manifest.getPreparetotalweight() + "\"";
		str += "}";
		return str;
	}

	// 海关状态
	private List<String> getcustomsStatus() {
		List<String> list = new ArrayList<>();
		// 国际转运
		list.add("001");// 进、出口货物
		list.add("002");// 国际转运货物
		list.add("003");// 国境货物
		list.add("004");// 暂存进出竟集装箱
		return list;
	}

	// 海关关区
	private List<String> getCustomsCode() {
		List<String> list = new ArrayList<>();
		list.add("4604");
		list.add("4620");
		return list;
	}

	// 支付方式
	private List<String> getPayTypes() {
		List<String> list = new ArrayList<>();
		// 预付
		list.add("001");// 预付
		list.add("002");// 到付
		return list;
	}

	/**
	 * 编辑
	 *
	 * @param id
	 * @return
	 */
	// @RequestMapping(value = "/bill/edit")
	// public String editBill(Long id,Long manifestId,Model model){
	// ManifestBillEntity bill = null;
	// if(id==null){
	// bill = new ManifestBillEntity();
	// bill.setManifestId(manifestId);
	// }else {
	// bill = billService.findOne(id);
	// }
	// //包装种类
	// List<PackageTypeEntity> typeList = packageTypeService.findAll();
	// model.addAttribute("typeList",typeList);
	// model.addAttribute("bill",bill);
	// return "manifest/edit_bill";
	// }

	// 查询主单号是否已经存在
	@RequestMapping(value = "existsManifestNo")
	@ResponseBody
	public ResponseModel editBill(String waybill) {
		ResponseModel model = new ResponseModel(200, null, null);
		List<ManifestEntity> manifestList = manifestService.findByMawbNo(waybill);
		if (manifestList.size() > 0) {
			model.setData("该注单号已经存在了！");
			model.setStatus(0);
		}
		return model;
	}

	/**
	 * 保存
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/save", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel save(ManifestEntity manifest, HttpServletRequest reuqest) {
		String flightno = manifest.getFlightno();
		String carrier = "";
		if (StringUtils.isNotBlank(flightno) && flightno.length() > 2) {
			carrier = flightno.substring(0, 2);
			flightno = flightno.replace(carrier, "");
		}
		manifest.setCarrier(carrier);
		manifest.setFlightno(flightno);

		// consigneeService.saveFromManifest(manifest, Tools.getUserId());
		// consignorService.saveFromManifest(manifest, Tools.getUserId());

		ResponseModel model = new ResponseModel();
		try {
			manifest.setUSER_ID(Tools.getUserId());
			if (manifestService.isExistsByWaybill(manifest)) {
				model.setMsg("该订单已存在！");
				model.setStatus(500);

				System.err.println("before manifest--> 该订单已存在！");
			} else {
				String stowagedate = reuqest.getParameter("stowagedate");
				manifest.setStowagedate(manifest.getStowagedate(stowagedate));
				manifest.setSave_time(new Long(System.currentTimeMillis()));
				// 处理预配时间
				manifest = manifestService.save(manifest);
				//同步分单信息
				List<PreparesecondaryEntity> subList = preparesecondaryServer.findByMain(manifest.getWaybillnomaster());
				if(!subList.isEmpty()&&subList.size()>0){
					for (PreparesecondaryEntity preparesecondaryEntity : subList) {
						preparesecondaryEntity.setCarrier(manifest.getCarrier());//承运人
						preparesecondaryEntity.setFlightno(manifest.getFlightno());//航班号
						preparesecondaryEntity.setFlightdate(manifest.getFlightdate());//航班日期
						preparesecondaryEntity.setOriginatingstation(manifest.getOriginatingstation());//起始站
						preparesecondaryEntity .setCustomscode(manifest.getCustomscode());//海关关区
						preparesecondaryEntity.setDelivery_station(manifest.getDelivery_station());//交运货站
						preparesecondaryEntity.setDe_type(manifest.getDe_type());//交运类型
						preparesecondaryServer.save(preparesecondaryEntity);
					}
				}

				model.setData(manifest);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);

				receiptService.saveFromManifest(manifest, WaybillReceiptType.TEMP_SAVE);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	// 撤销主单
	@RequestMapping(value = "/backout")
	@ResponseBody
	public ResponseModel backout(HttpServletRequest request, Long id) {
		ResponseModel model = new ResponseModel(200, null, "");
		ManifestEntity manifest = null;
		try {
			if (id != null) {

				manifest = manifestService.findOne((id));

				// String deletePath = MessageKit.getMessagePath(MessageType.DELETE);
				// String deletexml =
				// XmlUtil.convertToXml2(manifestService.sendBackoutXml(manifest), deletePath);
				// // 转换报文
				// System.out.println("===================deletexml===================");
				// System.out.println(deletexml);

				// new XmlSendTask().saveMessage(ndlxml);
				// model.setStatus(200);

				WaybillReceiptType type = WaybillReceiptType.DELETE;
				manifest.setResponse_text(type.getName());
				manifest.setResponse_code(String.valueOf(type.getValue()));
				manifestService.save(manifest);
				receiptService.saveFromManifest(manifest, type);
			}
		} catch (Exception e) {
			model.setStatus(10060);
			model.setMsg("连接超时！");
		}
		return model;
	}

	/*
	 * 撤销分单
	 */
	@RequestMapping(value = "housebillbackout")
	@ResponseBody
	public ResponseModel housebillbackout(HttpServletRequest request, Long id) {
		ResponseModel model = new ResponseModel(1, null, "");
		return model;
	}

	@RequestMapping(value = "app/send", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel app_send(ManifestEntity manifest, HttpServletRequest request, HttpServletResponse response) {
		ResponseModel model = new ResponseModel(200, null, "主单发送成功！");

		return model;
	}

	/**
	 * 主单提交表单保存并且发送报文
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/savesend", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel savesend(ManifestEntity manifest, HttpServletRequest request, HttpServletResponse response) {
		String flightno = manifest.getFlightno();
		String carrier = "";
		if (StringUtils.isNotBlank(flightno) && flightno.length() > 2) {
			carrier = flightno.substring(0, 2);
			flightno = flightno.replace(carrier, "");
		}
		manifest.setCarrier(carrier);
		manifest.setFlightno(flightno);

		// consigneeService.saveFromManifest(manifest, Tools.getUserId());
		// consignorService.saveFromManifest(manifest, Tools.getUserId());

		ResponseModel model = new ResponseModel();
		try {
			manifest.setUSER_ID(Tools.getUserId());
			if (manifestService.isExistsByWaybill(manifest)) {
				model.setStatus(500);
				model.setMsg("该订单号已存在！");
			} else {
				// String responseCode = manifest.getResponse_code();
				// int resCode = NumKit.parseInt(responseCode);
				// WaybillReceiptType oldType = WaybillReceiptType.valueOf(resCode);
				// WaybillReceiptType type = oldType != null ? WaybillReceiptType.UPDATE :
				// WaybillReceiptType.APPLY;
				WaybillReceiptType type = WaybillReceiptType.APPLY;

				String stowagedate = request.getParameter("stowagedate");
				manifest.setStowagedate(ManifestEntity.getStowagedate(stowagedate));
				// 保存
				manifest.setIsdelete(1);
				manifest.setResponse_code(String.valueOf(type.getValue()));
				manifest.setResponse_text(type.getName());
				manifest.setSave_time(System.currentTimeMillis());
				manifestService.save(manifest);
				receiptService.saveFromManifest(manifest, type);

				// 生成报文并且发送
				String ndlrPath = MessageKit.getMessagePath(MessageType.NDLR);
				String dlcPath = MessageKit.getMessagePath(MessageType.DLCF);
				String sliPath = MessageKit.getMessagePath(MessageType.SLI);

				manifest.setAgentcompany(getAgent().getNameCn());
				manifest.setAgentman(getAgent().getThreeCode());
				manifest.setAgentcompanycode(getAgent().getThreeCode());

				new XmlBuildTask(manifestService.sendNDLRXml(manifest), ndlrPath).perform();
				new XmlBuildTask(manifestService.sendDLCFXml(manifest), dlcPath).perform();
				new XmlBuildTask(FSXmlKit.sliXml(manifest, getAgent()), sliPath).perform();

				// String ndlrxml = XmlUtil.convertToXml2(manifestService.sendNDLRXml(manifest),
				// ndlrPath);
				// String dlcfxml = XmlUtil.convertToXml2(manifestService.sendDLCFXml(manifest),
				// dlcPath);
				// String slifxml = XmlUtil.convertToXml2(FSXmlKit.sliXml(manifest, getAgent()),
				// sliPath);

				// System.err.println("===================ndlrxml===================");
				// System.err.println(ndlrxml);
				// System.err.println();
				//
				// System.err.println("===================dlcfxml===================");
				// System.err.println(dlcfxml);
				// System.err.println();
				//
				// System.err.println("===================slifxml===================");
				// System.err.println(slifxml);
				// System.err.println();

				// new XmlSendTask(ndlrxml).send();
				// new XmlSendTask(dlcfxml).send();
				// new XmlSendTask(slifxml).send();

				model.setData(manifest);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 发送交运报并且保存
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/sendDelivery", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel sendDelivery(ManifestEntity manifest, HttpServletRequest request,
			HttpServletResponse response) {
		ResponseModel model = new ResponseModel();
		try {
			manifest.setUSER_ID(Tools.getUserId());
			if (manifestService.isExistsByWaybill(manifest)) {
				model.setStatus(500);
				model.setMsg("订单已存在！");
			} else {
				// 保存
				manifest.setDe_ids(1);
				String stowagedate = request.getParameter("stowagedate");
				manifest.setStowagedate(manifest.getStowagedate(stowagedate));
				manifest = manifestService.save(manifest);
				// 生成报文并且发送
				String rootPath = request.getSession().getServletContext().getRealPath("/");
				String path = rootPath + "/excel/manifest" + new Date().getTime() + ".xml";
				new XmlBuildTask(manifestService.sendDeliveryXml(manifest), path).perform();

				// String dlcfxml =
				// XmlUtil.convertToXml2(manifestService.sendDeliveryXml(manifest), path);
				// new XmlSendTask(dlcfxml).send();

				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 删除报
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/saveis_delete", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel saveis_delete(ManifestEntity manifest) {
		ResponseModel model = new ResponseModel();
		try {
			manifest.setIsdelete(1);
			manifest = manifestService.save(manifest);
			model.setData(manifest);
			model.setStatus(200);
			model.setMsg(HttpJsonMsg.SUCCESS);
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 保存
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/sub_save", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel sub_save(PreparesecondaryEntity preparesecondary) {
		String flightno = preparesecondary.getFlightno();
		String carrier = "";
		if (StringUtils.isNotBlank(flightno) && flightno.length() > 2) {
			carrier = flightno.substring(0, 2);
			flightno = flightno.replace(carrier, "");
		}	
		preparesecondary.setCarrier(carrier);
		preparesecondary.setFlightno(flightno);

		// consigneeService.saveFromPreparesecondary(preparesecondary,
		// Tools.getUserId());
		// consignorService.saveFromPreparesecondary(preparesecondary,
		// Tools.getUserId());

		ResponseModel model = new ResponseModel();
		try {
			// 已存在，提示给用户
			if (preparesecondaryServer.isExists(preparesecondary)) {
				model.setStatus(500);
				model.setMsg("该订单号已存在！");
			} else {
				preparesecondary.setCreateDate(new Date());
				preparesecondary = preparesecondaryServer.save(preparesecondary);
				model.setData(preparesecondary);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);

				receiptService.saveFromPreparesecondary(preparesecondary, WaybillReceiptType.TEMP_SAVE);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	// 撤销分单
	@RequestMapping(value = "prebackout")
	@ResponseBody
	public ResponseModel prebackout(HttpServletRequest request, Long id) {
		ResponseModel model = new ResponseModel(200, null, "");
		if (id != null) {
			System.out.println("id:" + id);
			PreparesecondaryEntity preparesecondary = preparesecondaryServer.findOne(id);
			if (preparesecondary != null) {
				try {

					// String rootPath = request.getSession().getServletContext().getRealPath("/");
					// String path = rootPath + "/excel/manifest" + new Date().getTime() + ".xml";
					// String ndlrxml =
					// XmlUtil.convertToXml2(manifestService.backoutpresenddlcfNdlrXml(preparesecondary),
					// path);
					// String dlcfxml =
					// XmlUtil.convertToXml2(manifestService.presenddlcfdlcfXml(preparesecondary),
					// path);

					// System.out.println(ndlrxml);
					// new XmlSendTask().saveMessage(ndlrxml);

					WaybillReceiptType type = WaybillReceiptType.DELETE;
					preparesecondary.setResponse_text(type.getName());
					preparesecondary.setResponse_code(String.valueOf(type.getValue()));
					preparesecondaryServer.save(preparesecondary);

					receiptService.saveFromPreparesecondary(preparesecondary, type);
				} catch (Exception e) {
					model.setStatus(500);
					model.setMsg(HttpJsonMsg.ERROR);
				}
			}
		}
		return model;
	}

	/**
	 * 子单提交表单保存并且发送报文
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/presavesend", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel presavesend(PreparesecondaryEntity preparesecondary, HttpServletRequest request) {
		String flightno = preparesecondary.getFlightno();
		String carrier = "";
		if (StringUtils.isNotBlank(flightno) && flightno.length() > 2) {
			carrier = flightno.substring(0, 2);
			flightno = flightno.replace(carrier, "");
		}
		preparesecondary.setCarrier(carrier);
		preparesecondary.setFlightno(flightno);

		// consigneeService.saveFromPreparesecondary(preparesecondary,
		// Tools.getUserId());
		// consignorService.saveFromPreparesecondary(preparesecondary,
		// Tools.getUserId());

		ResponseModel model = new ResponseModel();
		try {
			if (preparesecondaryServer.isExists(preparesecondary)) {
				model.setStatus(500);
				model.setMsg("该订单号已存在！");
			} else {
				String responseCode = preparesecondary.getResponse_code();
				int resCode = NumKit.parseInt(responseCode);
				// WaybillReceiptType oldType = WaybillReceiptType.valueOf(resCode);
				// WaybillReceiptType type = oldType != null ? WaybillReceiptType.UPDATE :
				// WaybillReceiptType.APPLY;

				WaybillReceiptType type = WaybillReceiptType.APPLY;

				String stowagedate = request.getParameter("stowagedate");
				preparesecondary.setStowagedate(preparesecondary.getStowagedate(stowagedate));
				preparesecondary.setIsdelete(1);
				preparesecondary.setResponse_code(String.valueOf(type.getValue()));
				preparesecondary.setResponse_text(type.getName());
				preparesecondaryServer.save(preparesecondary);
				receiptService.saveFromPreparesecondary(preparesecondary, type);

				// 生成报文并且发送
				String ndlrPath = MessageKit.getMessagePath(MessageType.NDLR);
				String dlcPath = MessageKit.getMessagePath(MessageType.DLCF);
				String fhlPath = MessageKit.getMessagePath(MessageType.FHL);

				preparesecondary.setAgentcompany(getAgent().getNameCn());
				preparesecondary.setAgentman(getAgent().getNameCn());
				preparesecondary.setAgentcompanycode(getAgent().getThreeCode());

				new XmlBuildTask(manifestService.presenddlcfNdlrXml(preparesecondary), ndlrPath).perform();
				new XmlBuildTask(manifestService.presenddlcfdlcfXml(preparesecondary), dlcPath).perform();
				new XmlBuildTask(FSXmlKit.fhlXml(preparesecondary, getAgent()), fhlPath).perform();

				// String ndlrxml =
				// XmlUtil.convertToXml2(manifestService.presenddlcfNdlrXml(preparesecondary),
				// ndlrPath);
				// String dlcfxml =
				// XmlUtil.convertToXml2(manifestService.presenddlcfdlcfXml(preparesecondary),
				// dlcPath);
				// String fhlfxml = XmlUtil.convertToXml2(FSXmlKit.fhlXml(preparesecondary,
				// getAgent()), fhlPath);

				// RemoteFileKit.putFile(ndlrPath);
				// RemoteFileKit.putFile(dlcPath);
				// RemoteFileKit.putFile(fhlPath);

				// 发送redis储存数据
				// new XmlSendTask(ndlrxml).send();
				// new XmlSendTask(dlcfxml).send();
				// new XmlSendTask(fhlfxml).send();

				// System.out.println("===================ndlrxml===================");
				// System.out.println(ndlrxml);
				// System.out.println();
				//
				// System.out.println("===================dlcfxml===================");
				// System.err.println(dlcfxml);
				// System.out.println();
				//
				// System.out.println("===================fhlfxml===================");
				// System.err.println(fhlfxml);
				// System.out.println();

				model.setData(preparesecondary);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);

			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 保存并且发送
	 *
	 * @param manifest
	 * @return
	 */
	@RequestMapping(value = "/presendDelivery", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel presendDelivery(PreparesecondaryEntity Preparesecondary, HttpServletRequest request) {
		ResponseModel model = new ResponseModel();

		try {
			if (preparesecondaryServer.isExists(Preparesecondary)) {
				model.setStatus(500);
				model.setMsg("改订单号已经存在了！");
			} else {
				Preparesecondary.setIsdelete(1);
				Preparesecondary = preparesecondaryServer.save(Preparesecondary);
				// 生成报文并且发送
				String rootPath = request.getSession().getServletContext().getRealPath("/");
				String path = rootPath + "/excel/manifest" + new Date().getTime() + ".xml";
				// String dlcfxml =
				// XmlUtil.convertToXml2(manifestService.sendPreXml(Preparesecondary), path);
				// new XmlSendTask(dlcfxml).send();

				new XmlBuildTask(manifestService.sendPreXml(Preparesecondary), path).perform();

				model.setData(Preparesecondary);
				model.setStatus(200);
				model.setMsg(HttpJsonMsg.SUCCESS);
			}
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 
	 * @param waybillnomaster
	 *            主单号
	 * @param waybillnoSub
	 *            分单号
	 * @return
	 */
	@RequestMapping(value = "/daryMawbNo", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel daryMawbNo(String waybillnomaster, String waybillnoSub) {
		ResponseModel model = new ResponseModel();
		List<PreparesecondaryEntity> list = null;
		if (StringUtils.isNotEmpty(waybillnomaster) && StringUtils.isNotEmpty(waybillnoSub)) {
			list = preparesecondaryServer.findByMainAndSub(waybillnomaster, waybillnoSub);
		}
		boolean exist = list != null && list.size() > 0;

		if (exist) {
			model.setStatus(500);
		} else {
			model.setStatus(200);
		}
		return model;
	}

	@RequestMapping(value = "/xml", method = RequestMethod.POST)
	@ResponseBody
	public ResponseModel createXml(Long id, HttpServletRequest request, HttpServletResponse response) throws Exception {
		ResponseModel model = new ResponseModel();
		String rootPath = request.getSession().getServletContext().getRealPath("/");
		String path = rootPath + "/excel/manifest" + new Date().getTime() + ".xml";
		String xml = "";
		if (id != null) {
			xml = beanToXml(path, id);
		}
		model.setData(xml);
		return model;
	}

	// 生成报文
	private String beanToXml(String path, Long id) throws Exception {
		ManifestEntity maen = manifestService.findOne(id);
		List<PreparesecondaryEntity> preparesecondaryList = preparesecondaryServer.findAll(maen.getId());

		DeclarePreparemasterXmlBody body = new DeclarePreparemasterXmlBody();
		// 设置xml开头
		XmlHead head = new XmlHead();
		head.setMessageID("CN_MT2201_1P0_460470678920X_" + Constant.dateTimeFormatnumber.format(new Date()));
		head.setFunctionCode("9");
		head.setMessageType("MT2201");
		head.setSenderID("460470678920X_DXPENT0000460002");
		head.setReceiverID("4604");
		head.setSendTime(Constant.dateTimeFormatnumber.format(new Date()));
		head.setVersion("1.0");
		body.setHead(head);
		// 预配舱单
		ManifestDeclarationXml dec = new ManifestDeclarationXml();
		// 预配舱单主表信息
		// 承运人
		ManifestCarrierXml carr = new ManifestCarrierXml();
		carr.setId(maen.getCarrier());
		dec.setCarrier(carr);

		// 起始站
		ManifestOrgXml mo = new ManifestOrgXml();
		mo.setId(maen.getOriginatingstation());
		dec.setOrg(mo);

		// 目的站
		ManifestDesXml md = new ManifestDesXml();
		md.setId(maen.getDestinationstation());
		dec.setDes(md);

		// 航班号-航班日期
		ManifestBorderTransportMeansXml mt = new ManifestBorderTransportMeansXml();
		mt.setJourneyid(maen.getFlightno() + "/" + Constant.dateFormat.format(maen.getFlightdate()));
		dec.setBordertransportmeans(mt);

		ManifestConsignmentXml mcs = new ManifestConsignmentXml();

		// 运单号
		ManifestTransportContractDocumentXml mac = new ManifestTransportContractDocumentXml();
		mac.setId(maen.getWaybillnomaster());
		mcs.setTransportcontractdocument(mac);

		// 装载日期
		ManifestLoadingLocationXml ml = new ManifestLoadingLocationXml();
		ml.setId("CGO/4604");
		ml.setLoadingdate(Constant.dateTimeFormatnumber.format(maen.getStowagedate()));
		mcs.setLoadinglocation(ml);

		ManifestUnloadingLocationXml mu = new ManifestUnloadingLocationXml();
		mu.setId("CGO/4604");
		mcs.setUnloadinglocation(mu);
		mcs.setTransportsplitindicator("0");

		ManifestConsignmentPackagingXml mcon = new ManifestConsignmentPackagingXml();
		mcon.setQuantityquantity(maen.getTotalpiece());
		mcs.setConsignmentpackaging(mcon);

		mcs.setTotalgrossmassmeasure(maen.getTotalweight());
		mcs.setPrequantityquantity(maen.getPreparetotalpiece());
		mcs.setPretotalgrossmassmeasure(maen.getPreparetotalweight());
		mcs.setCustomsstatus(maen.getCustomscode());

		ManifestFreightPaymentXml mfp = new ManifestFreightPaymentXml();
		mfp.setMethodcode(maen.getPaymode());
		mcs.setFreightpayment(mfp);

		mcs.setProductname(maen.getProductname());
		mcs.setPreparetime(maen.getStowagedate().toString());
		mcs.setCustomscode(maen.getCustomscode());
		mcs.setAgentname(maen.getAgentman());
		mcs.setAgentCompany(maen.getAgentcompany());

		// ManifestConsigneeXml mcons = new ManifestConsigneeXml();
		// mcons.setName(maen.getConsigneename());
		//
		// ManifestAddressXml madd = new ManifestAddressXml();
		// madd.setLine(maen.getConsigneeaddress());
		// madd.setCityname(maen.getConsigneecity());
		// madd.setCountrycode(maen.getCountrycode());
		// madd.setProvincecode(maen.getProvincecode());
		// madd.setProvincename(maen.getProvincename());
		// madd.setZipcode(maen.getZipcode());
		// mcons.setAddress(madd);
		// mcs.setConsignee(mcons);
		//
		ManifestConsignorXml maci = new ManifestConsignorXml();
		// maci.setName(maen.getShippername());
		ManifestsAddressXml msadd = new ManifestsAddressXml();
		// msadd.setLine(maen.getShipperaddress());
		// msadd.setCityname(maen.getShippercity());
		maci.setAddress(msadd);
		mcs.setConsignor(maci);

		// 预配舱单子表信息
		if (preparesecondaryList != null) {
			List<ManifestConsignmentItemXml> ls = new ArrayList<ManifestConsignmentItemXml>();
			for (PreparesecondaryEntity entity : preparesecondaryList) {
				ManifestConsignmentItemXml maconca = new ManifestConsignmentItemXml();
				ManifestCarrierXml macrri = new ManifestCarrierXml();
				macrri.setId(entity.getCarrier());
				maconca.setCarrier(macrri);

				ManifestOrgXml orgs = new ManifestOrgXml();
				orgs.setId(entity.getOriginatingstation());
				maconca.setOrg(orgs);

				ManifestDesXml dess = new ManifestDesXml();
				orgs.setId(entity.getDestinationstation());
				maconca.setDes(dess);

				ManifestBorderTransportMeansXml mtm = new ManifestBorderTransportMeansXml();
				mtm.setJourneyid(entity.getFlightno() + "/" + Constant.dateFormat.format(maen.getFlightdate()));
				;
				maconca.setBorderTransportMeans(mtm);

				ManifestTransportContractDocumentXml masc = new ManifestTransportContractDocumentXml();
				masc.setId(entity.getWaybillnosecondary());
				maconca.setTransportcontractdocument(masc);

				ManifestLoadingLocationXml mus = new ManifestLoadingLocationXml();
				mus.setId("CGO/4604");
				maconca.setLoadinglocation(mus);
				maconca.setTransportsplitindicator("0");

				ManifestConsignmentPackagingXml cons = new ManifestConsignmentPackagingXml();
				cons.setQuantityquantity(entity.getTotalpiece());
				maconca.setConsignmentpackaging(cons);

				maconca.setTotalgrossmassmeasure(entity.getTotalweight());
				maconca.setPrequantityquantity(entity.getPreparepiece());
				maconca.setPretotalgrossmassmeasure(entity.getPrepareweight());
				maconca.setCustomsStatus(entity.getCustomsstatus().toString());

				ManifestFreightPaymentXml mafr = new ManifestFreightPaymentXml();
				mafr.setMethodcode(entity.getPaymode());
				maconca.setFreightPayment(mafr);

				maconca.setProductname(entity.getProductname());
				maconca.setPreparetime(entity.getStowagedate().toString());
				maconca.setCustomscode(entity.getCustomscode());
				maconca.setAgentname(entity.getAgentman());
				maconca.setCustomscode(entity.getCustomscode());

				// ManifestAddressXml madds = new ManifestAddressXml();
				// madds.setLine(entity.getConsigneeaddress());
				// madds.setCityname(entity.getConsigneecity());
				// madds.setCountrycode(entity.getCountrycode());
				// madds.setProvincecode(maen.getProvincecode());
				// madds.setProvincename(entity.getProvincename());
				// madds.setZipcode(entity.getZipcode());
				// mcons.setAddress(madds);
				// maconca.setConsignee(mcons);
				//
				// ManifestConsignorXml macis = new ManifestConsignorXml();
				// macis.setName(entity.getShippername());
				// ManifestsAddressXml msadds = new ManifestsAddressXml();
				// msadds.setLine(entity.getShipperaddress());
				// msadds.setCityname(entity.getShippercity());
				// macis.setAddress(msadds);
				// maconca.setConsignor(macis);

				ls.add(maconca);
			}
			mcs.setConsignmentitems(ls);
		}
		dec.setConsignment(mcs);

		body.setDeclaration(dec);

		ManifestDeclareMsgXml dms = new ManifestDeclareMsgXml();
		ManifestDeclareMetaXml mdme = new ManifestDeclareMetaXml();
		mdme.setSndr("CDCF");
		mdme.setRcvr("");
		mdme.setSeqn(maen.getWaybillnomaster() + Constant.dateTimeFormatnumber.format(new Date()));
		mdme.setDdtm(Constant.dateTimeFormatnumber.format(new Date()));
		mdme.setType("HYXX");
		mdme.setStyp("CDCF");// CDCF NDLR
		dms.setMeta(mdme);
		dms.setDeclarepreparemasterxmlbody(body);

		String xml = XmlUtil.convertToXml2(dms, path);

		// System.out.println(xml);
		// IMFServletManifst mis = new IMFServletManifst();
		// mis.init(xml.toString());

		return xml;
	}

	// private String beanToXml(String path,Long id){
	// ManifestEntity manifestEntity = manifestService.findOne(id);
	//
	// if(manifestEntity==null){
	// manifestEntity = new ManifestEntity();
	// }
	// List<ManifestBillEntity> billList = null;
	// ManifestBillEntity billEntity = new ManifestBillEntity();
	// ManifestCommodityEntity commodityEntity = new ManifestCommodityEntity();
	// ManifestContainerEntity containerEntity = new ManifestContainerEntity();
	// if(manifestEntity.getId()!=null){
	// billList = billService.findByManifestId(manifestEntity.getId());
	// }
	// if(CollectionUtils.isNotEmpty(billList)){
	// billEntity = billList.get(0);
	// }
	// List<ManifestCommodityEntity> commodities = null;
	// if(billEntity.getId()!=null){
	// commodities = commodityService.findByBillId(billEntity.getId());
	// }
	// if(CollectionUtils.isNotEmpty(commodities)){
	// commodityEntity = commodities.get(0);
	// }
	//
	// DeclareXmlBody body = new DeclareXmlBody();
	//
	// XmlHead head = new XmlHead();
	// head.setMessageID(id==null?"":id.toString());
	// head.setMessageType("Manifest");
	// head.setSenderID(SessionUtil.getUser().getId().toString());
	// head.setSendTime(Constant.dateFormat.format(new Date()));
	// head.setFunctionCode("");
	// head.setReceiverID(SessionUtil.getUser().getId().toString());
	// head.setVersion("1.0");
	// body.setHead(head);
	//
	// DeclareManifestXml manifestXml = new DeclareManifestXml();
	//
	// NameXml nameXml = new NameXml();
	// nameXml.setName(manifestEntity.getTransferName());
	// manifestXml.setRepresentativePerson(nameXml);
	//
	// IDXml idXml = new IDXml();
	// idXml.setId(manifestEntity.getLeaveCode());
	// manifestXml.setExitCustomsOffice(idXml);
	//
	// IDXml idXml1 = new IDXml();
	// idXml1.setId(manifestEntity.getAgentCompanyCode());
	// manifestXml.setAgent(idXml1);
	//
	// IDXml idXml2 = new IDXml();
	// idXml2.setId(manifestEntity.getCarrierCode());
	// manifestXml.setCarrier(idXml2);
	//
	// DeclareBorderTransportMeansXml transportMeansXml = new
	// DeclareBorderTransportMeansXml();
	// transportMeansXml.setJourneyID(manifestEntity.getVoyageNo());
	// transportMeansXml.setTypeCode(manifestEntity.getModeCode());
	// transportMeansXml.setId(manifestEntity.getToolCode());
	// transportMeansXml.setName(manifestEntity.getToolName());
	// transportMeansXml.setFirstArrivalLocationID(manifestEntity.getFirstPortCode());
	// transportMeansXml.setArrivalDateTime(manifestEntity.getFirstPortDate()!=null?Constant.dateFormat.format(manifestEntity.getFirstPortDate()):"");
	// transportMeansXml.setDepartureDateTime(manifestEntity.getDepartureDate()!=null?Constant.dateFormat.format(manifestEntity.getDepartureDate()):"");
	//
	// DeclareConsignmentXml consignmentXml = new DeclareConsignmentXml();
	//
	// DeclareTransportContractDocumentXml contractDocumentXml = new
	// DeclareTransportContractDocumentXml();
	//
	// contractDocumentXml.setId(billEntity.getLadingNo());
	// contractDocumentXml.setChangeReasonCode(billEntity.getModifyReasonCode());
	// contractDocumentXml.setConditionCode(billEntity.getTransportCode());
	// consignmentXml.setTransportContractDocument(contractDocumentXml);
	//
	// IDXml idXml3 = new IDXml();
	// idXml3.setId(billEntity.getSubLadingNo());
	// consignmentXml.setAssociatedTransportDocument(idXml3);
	//
	// consignmentXml.setGrossVolumeMeasure(billEntity.getVolume()!=null?billEntity.getVolume().toString():"");
	// consignmentXml.setValueAmount(billEntity.getCashType());
	//
	// DeclareLoadingLocationXml loadingLocationXml = new
	// DeclareLoadingLocationXml();
	// loadingLocationXml.setId(billEntity.getEncasementCode());
	// loadingLocationXml.setLoadingDate(billEntity.getCarryVehicleTime());
	// consignmentXml.setLoadingLocation(loadingLocationXml);
	//
	// DeclareUnloadingLocationXml unloadingLocationXml = new
	// DeclareUnloadingLocationXml();
	// unloadingLocationXml.setId(billEntity.getUnlodingCode());
	// unloadingLocationXml.setArrivalDate(billEntity.getArrivalDate()!=null?Constant.dateFormat.format(billEntity.getArrivalDate()):"");
	// consignmentXml.setUnloadingLocation(unloadingLocationXml);
	//
	// DeclareGoodsReceiptPlaceXml receiptPlaceXml = new
	// DeclareGoodsReceiptPlaceXml();
	//
	// receiptPlaceXml.setId(billEntity.getReceiveCode());
	// receiptPlaceXml.setName(billEntity.getReceiveName());
	// consignmentXml.setGoodsReceiptPlace(receiptPlaceXml);
	//
	// IDXml idXml4 = new IDXml();
	// idXml4.setId(billEntity.getTransitCode());
	// consignmentXml.setTranshipmentLocation(idXml4);
	//
	// IDXml idXml5 = new IDXml();
	// idXml5.setId(billEntity.getTransitDestinationCode());
	// consignmentXml.setTransitDestination(idXml5);
	//
	// consignmentXml.setRoutingCountryCode(billEntity.getTransitCountryCode());
	//
	// IDXml idXml6 = new IDXml();
	// idXml6.setId(billEntity.getConsignLocation());
	// consignmentXml.setGoodsConsignedPlace(idXml6);
	//
	// consignmentXml.setCustomsStatusCode(billEntity.getCustomsStatusCode());
	// consignmentXml.setTransportSplitIndicator(billEntity.getSendSign());
	//
	// DeclareMethodCodeXml methodCodeXml = new DeclareMethodCodeXml();
	// methodCodeXml.setMethodCode(billEntity.getPaymentMethod());
	// consignmentXml.setFreightPayment(methodCodeXml);
	//
	// DeclareConsignmentPackagingXml packagingXml = new
	// DeclareConsignmentPackagingXml();
	// packagingXml.setTypeCode(billEntity.getPackageType());
	// packagingXml.setQuantityQuantity(billEntity.getPieces()!=null?billEntity.getPieces().toString():"");
	// consignmentXml.setConsignmentPackaging(packagingXml);
	//
	// consignmentXml.setTotalGrossMassMeasure(billEntity.getTotalGrossWeight()!=null?billEntity.getTotalGrossWeight().toString():"");
	//
	// DeclarePreviousCustomsDocumentXml documentXml = new
	// DeclarePreviousCustomsDocumentXml();
	// documentXml.setId(billEntity.getPreviousCustomsNo());
	// documentXml.setTypeCode(billEntity.getPreviousCustomsType());
	// consignmentXml.setPreviousCustomsDocument(documentXml);
	//
	// DeclareDeliveryDestinationXml deliveryDestinationXml = new
	// DeclareDeliveryDestinationXml();
	// deliveryDestinationXml.setLine(billEntity.getDeliverDestination());
	// deliveryDestinationXml.setCityName(billEntity.getDeliverCity());
	// deliveryDestinationXml.setCountrySubEntityName(billEntity.getDeliverProvinceCode());
	// deliveryDestinationXml.setPostcodeID(billEntity.getDeliverPostCode());
	// deliveryDestinationXml.setCountryCode(billEntity.getDeliverCountryCode());
	// consignmentXml.setDeliveryDestination(deliveryDestinationXml);
	//
	// DeclareIntermediateCarrierXml intermediateCarrierXml = new
	// DeclareIntermediateCarrierXml();
	// intermediateCarrierXml.setId(billEntity.getCarrierSign());
	// DeclareCommunicationXml communicationXml = new DeclareCommunicationXml();
	// communicationXml.setId(billEntity.getCarrierContactNo());
	// communicationXml.setTypeID(billEntity.getCarrierContactType());
	// intermediateCarrierXml.setCommunication(communicationXml);
	// consignmentXml.setIntermediateCarrier(intermediateCarrierXml);
	//
	// //收货人
	// DeclareConsigneeXml consigneeXml = new DeclareConsigneeXml();
	// consigneeXml.setId(billEntity.getReceiverCode());
	// consigneeXml.setName(billEntity.getReceiverName());
	//
	// DeclareAddressXml addressXml = new DeclareAddressXml();
	// addressXml.setLine(billEntity.getReceiverAddress());
	// addressXml.setCityName(billEntity.getReceiverCity());
	// addressXml.setCountrySubEntityID(billEntity.getReceiverProvinceCode());
	// addressXml.setCountrySubEntityName(billEntity.getReceiverProvince());
	// addressXml.setCountryCode(billEntity.getReceiverCountryCode());
	// addressXml.setPostcodeID(billEntity.getReceiverPostCode());
	// consigneeXml.setAddress(addressXml);
	// DeclareCommunicationXml communicationXml1 = new DeclareCommunicationXml();
	// communicationXml1.setId(billEntity.getReceiverContactNo());
	// communicationXml1.setTypeID(billEntity.getReceiverContactType());
	// consigneeXml.setCommunication(communicationXml1);
	//
	// DeclareContactXml contactXml = new DeclareContactXml();
	// contactXml.setName(billEntity.getReceiverName());
	// DeclareCommunicationXml communicationXml2 = new DeclareCommunicationXml();
	// communicationXml2.setId(billEntity.getReceiverContactNo());
	// communicationXml2.setTypeID(billEntity.getReceiverContactType());
	// contactXml.setCommunication(communicationXml2);
	// consigneeXml.setContact(contactXml);
	//
	// consignmentXml.setConsignee(consigneeXml);
	//
	// //发货人
	// DeclareConsigneeXml consigneeXml1 = new DeclareConsigneeXml();
	// consigneeXml1.setId(billEntity.getSenderCode());
	// consigneeXml1.setName(billEntity.getSenderName());
	// DeclareAddressXml addressXml1 = new DeclareAddressXml();
	// addressXml1.setLine(billEntity.getSenderAddress());
	// addressXml1.setCityName(billEntity.getSenderCity());
	// addressXml1.setCountrySubEntityID(billEntity.getSenderProvinceCode());
	// addressXml1.setCountrySubEntityName(billEntity.getSenderProvince());
	// addressXml1.setPostcodeID(billEntity.getSenderPostCode());
	// addressXml1.setCountryCode(billEntity.getSenderCountryCode());
	// consigneeXml1.setAddress(addressXml1);
	// DeclareCommunicationXml communicationXml3 = new DeclareCommunicationXml();
	// communicationXml3.setId(billEntity.getSenderContactNo());
	// communicationXml3.setTypeID(billEntity.getSenderContactType());
	// consigneeXml1.setCommunication(communicationXml3);
	// consignmentXml.setConsignor(consigneeXml1);
	//
	// //通知人
	// DeclareConsigneeXml consigneeXml2 = new DeclareConsigneeXml();
	// consigneeXml2.setId(billEntity.getNotifierCode());
	// consigneeXml2.setName(billEntity.getNotifier());
	// addressXml.setLine(billEntity.getNotifierAddress());
	// addressXml.setCityName(billEntity.getNotifierCity());
	// addressXml.setCountrySubEntityID(billEntity.getNotifierProvinceCode());
	// addressXml.setCountrySubEntityName(billEntity.getNotifierProvince());
	// addressXml.setPostcodeID(billEntity.getNotifierPostCode());
	// addressXml.setCountryCode(billEntity.getNotifierCountryCode());
	// consigneeXml2.setAddress(addressXml);
	// DeclareCommunicationXml communicationXml4 = new DeclareCommunicationXml();
	// communicationXml4.setId(billEntity.getNotifierContact());
	// communicationXml4.setTypeID(billEntity.getNotifierContactCode());
	// consigneeXml2.setCommunication(communicationXml4);
	// consignmentXml.setNotifyParty(consigneeXml2);
	//
	// //危险品联系人
	// DeclareUNDGContactXml dgXml = new DeclareUNDGContactXml();
	// dgXml.setName(billEntity.getDangerContact());
	// DeclareCommunicationXml communicationXml5 = new DeclareCommunicationXml();
	// communicationXml5.setId(billEntity.getDangerContactNo());
	// communicationXml5.setTypeID(billEntity.getDangerContactType());
	// dgXml.setCommunication(communicationXml5);
	// consignmentXml.setuNDGContact(dgXml);
	//
	// //商品信息
	// DeclareConsignmentItemXml itemXml = new DeclareConsignmentItemXml();
	// itemXml.setSequenceNumeric(commodityEntity.getSerialNo());
	// DeclareConsignmentItemPackagingXml itemPackagingXml = new
	// DeclareConsignmentItemPackagingXml();
	// itemPackagingXml.setQuantityQuantity(commodityEntity.getPieces()!=null?commodityEntity.getPieces().toString():"");
	// itemPackagingXml.setTypeCode(commodityEntity.getPackageType());
	// itemPackagingXml.setMarksNumbers(commodityEntity.getMark());
	// itemXml.setConsignmentItemPackaging(itemPackagingXml);
	//
	// DeclareCommodityXml commodityXml = new DeclareCommodityXml();
	// commodityXml.setCargoDescription(commodityEntity.getSummary());
	// commodityXml.setuNDGCode(commodityEntity.getDangerNo());
	// commodityXml.setTariffClassificationCode(commodityEntity.getTariffNo());
	//
	// ContentXml contentXml = new ContentXml();
	// contentXml.setContent(commodityEntity.getRemark());
	// itemXml.setAdditionalInformation(contentXml);
	//
	// DeclareGoodsMeasureXml goodsMeasureXml = new DeclareGoodsMeasureXml();
	// goodsMeasureXml.setGrossMassMeasure(commodityEntity.getGrossWeight()!=null?commodityEntity.getGrossWeight().toString():"");
	// itemXml.setGoodsMeasure(goodsMeasureXml);
	//
	// DeclareCustomsProcedureXml procedureXml = new DeclareCustomsProcedureXml();
	// procedureXml.setCurrentCode(commodityEntity.getProcedureCode());
	// itemXml.setCustomsProcedure(procedureXml);
	//
	// idXml.setId(commodityEntity.getConsign());
	// itemXml.setuCR(idXml);
	//
	// DeclareOriginXml originXml = new DeclareOriginXml();
	// originXml.setOriginCountryCode(commodityEntity.getOriginCode());
	// itemXml.setOrigin(originXml);
	// consignmentXml.setConsignmentItem(itemXml);
	//
	// manifestXml.setConsignment(consignmentXml);
	//
	// contentXml.setContent(manifestEntity.getRemark());
	// manifestXml.setAdditionalInformation(contentXml);
	//
	// body.setDeclaration(manifestXml);
	// String xml = XmlUtil.convertToXml2(body, path);
	// return xml;
	// }

	/**
	 * 保存
	 *
	 * @param billJson
	 * @return
	 */
	@ResponseBody
	@RequestMapping(value = "/bill/save", method = RequestMethod.POST)
	public ResponseModel saveBill(String billJson, String voJson) {
		ResponseModel model = new ResponseModel();
		try {
			ManifestBillEntity bill = JSONObject.parseObject(billJson, ManifestBillEntity.class);
			List<CommodityVo> voList = JSONArray.parseArray(voJson, CommodityVo.class);
			bill = billService.save(bill, voList);
			model.setData(bill.getManifestId());
			model.setStatus(200);
			model.setMsg(HttpJsonMsg.SUCCESS);
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}

		return model;
	}

	/*
	 * 获取3字码对应的信息，然后自动填写上
	 */
	@RequestMapping("/gettreecode")
	@ResponseBody
	public ResponseModel gettreecode(HttpServletRequest request, String STOCKPRE) {
		ResponseModel model = new ResponseModel(1, null, "");

		// 这种方法获取到了对象的数量，但是获取不到对象本省，有问题，暂时不用这种方法
		// List<TBasCarrierEntity> tbc = tbasService.findAll();
		// for(int i = 0; i < tbc.size(); i ++)
		// {
		// }
		// model.setData(tbc);
		if (STOCKPRE != null) {
			Connection c = DBConnection.dbConn("CGOASM", "vmvnv1v2");
			// List<TBasCarrierEntity> list = new ArrayList<TBasCarrierEntity>();
			Statement sql;
			try {
				sql = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
				String sqlStr = "SELECT * FROM T_BAS_CARRIER WHERE STOCKPRE='" + STOCKPRE + "'";
				ResultSet rs = sql.executeQuery(sqlStr);

				while (rs.next()) {
					TBasCarrierEntity tbs = new TBasCarrierEntity();
					tbs.setcARRIERID(rs.getString(1));
					tbs.setsTOCKPRE(rs.getString(2));
					tbs.setcARRIERDESCCHN(rs.getString(3));
					tbs.setcARRIERDESCENG(rs.getString(4));
					tbs.setcARRIERSHORTNAMECHN(rs.getString(5));
					tbs.setcARRYWAY(rs.getString(6));
					tbs.setoPERATIONTIME(rs.getString(7));
					tbs.setiSFOREIGN(rs.getString(8));
					// tbs.setfREQORDERING(rs.getInt(9));
					// tbs.setId(rs.getInt(9)));
					model.setData(tbs);
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		}

		return model;
	}

	/**
	 * 获取商品信息
	 * 
	 * @param billId
	 * @return
	 */
	@ResponseBody
	@RequestMapping(value = "/commodity/get", method = RequestMethod.POST)
	public String getCommodity(Long billId) {
		return JSON.toJSONString(commodityService.getCommodityVos(billId), filter);
	}

	/**
	 * 编辑商品信息
	 * 
	 * @param id
	 * @return
	 */
	@RequestMapping(value = "/commodity/edit")
	public String getContainer(Long id, Model model) {
		CommodityVo vo = new CommodityVo();
		model.addAttribute("vo", vo);
		return "manifest/edit_commodity";
	}

	/**
	 * 删除
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(value = "/delete", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel delete(String ids) {
		ResponseModel model = new ResponseModel();
		try {
			manifestService.deleteAll(ids);
			model.setStatus(200);
			model.setMsg(HttpJsonMsg.SUCCESS);
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 删除
	 * 
	 * @param ids
	 * @return
	 */
	@RequestMapping(value = "/subdelete", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel subdelete(Long id) {
		ResponseModel model = new ResponseModel();
		try {
			preparesecondaryServer.delete(id);
			model.setStatus(200);
			model.setMsg(HttpJsonMsg.SUCCESS);
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

	/**
	 * 删除
	 * 
	 * @param id
	 * @return
	 */
	@RequestMapping(value = "/bill/delete", method = { RequestMethod.POST })
	@ResponseBody
	public ResponseModel deleteBill(Long id) {
		ResponseModel model = new ResponseModel();
		try {
			billService.delete(id);
			model.setStatus(200);
			model.setMsg(HttpJsonMsg.SUCCESS);
		} catch (Exception e) {
			model.setStatus(500);
			model.setMsg(HttpJsonMsg.ERROR);
			logger.error("系统异常 >>", e);
		}
		return model;
	}

}