iamberry-common-parent/watero-rst-web/src/main/java/com/iamberry/rst/controllers/cm/AdminSalesOrderController.java

package com.iamberry.rst.controllers.cm;

import com.iamberry.rst.core.cm.SalesOrder;
import com.iamberry.rst.core.cm.SalesOrderItem;
import com.iamberry.rst.core.cm.StoreInfo;
import com.iamberry.rst.core.page.PagedResult;
import com.iamberry.rst.core.tools.LogisticsInfo;
import com.iamberry.rst.faces.cm.SalesOrderService;
import com.iamberry.rst.faces.cm.StoreInfoService;
import com.iamberry.rst.faces.order.EfastOrderService;
import com.iamberry.rst.utils.ExcelUtil;
import com.iamberry.rst.utils.StitchAttrUtil;
import com.iamberry.wechat.tools.ResponseJson;
import net.sf.json.JSONObject;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang3.StringEscapeUtils;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.text.MessageFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import static com.iamberry.rst.util.SmsConfig.SEND_NOTICE;

/**
 * 订单信息
 * Created by liuzhiwei on 2017/12/4.
 */
@Controller
@RequestMapping("admin/salesOrder")
public class AdminSalesOrderController {

    @Autowired
    private SalesOrderService salesOrderService;
    @Autowired
    private EfastOrderService efastOrderService;

    @Autowired
    private StoreInfoService storeInfoService;
    private Object lock = new Object();

    public static void main(String args[]){
        String resultJson = "{\"resp_data\":{\"total_results\":\"363\",\"page_no\":5,\"page_size\":20,\"list\":[{\"order_id\":\"20981\",\"order_sn\":\"802270003015\",\"deal_code\":\"0227164747493987895\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519721285\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":null,\"consignee\":\"陈娟娟\",\"address\":\"河南省 郑州市 二七区 河南省 郑州市 二七区 郑密路侯寨中原第一城A21栋114(450052).\",\"zipcode\":\"\",\"tel\":\"\",\"mobile\":\"18538189355\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"河南省\",\"city\":\"郑州市\",\"district\":\"二七区\",\"invoice_no\":\"3353549819747\",\"add_time\":\"1519721285\",\"modified\":\"2018-02-28 15:10:09\",\"delivery_time\":\"1519801809\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-27 16:47:51\",\"lylx\":\"后台\",\"shipping_time\":null,\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"11\",\"city_id\":\"149\",\"district_id\":\"1253\"},{\"order_id\":\"20982\",\"order_sn\":\"802270003022\",\"deal_code\":\"0227164747998501275\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519721285\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":null,\"consignee\":\"任伟丽\",\"address\":\"河南省 新乡市 红旗区 河南省 新乡市 红旗区 华兰大道东段大学源B区(453000).\",\"zipcode\":\"\",\"tel\":\"\",\"mobile\":\"13639631941\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"河南省\",\"city\":\"新乡市\",\"district\":\"红旗区\",\"invoice_no\":\"3353550272835\",\"add_time\":\"1519721285\",\"modified\":\"2018-02-28 15:14:46\",\"delivery_time\":\"1519802086\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-27 16:47:51\",\"lylx\":\"后台\",\"shipping_time\":null,\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"11\",\"city_id\":\"160\",\"district_id\":\"1357\"},{\"order_id\":\"20983\",\"order_sn\":\"802270003039\",\"deal_code\":\"0227164747711414149\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519721286\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":null,\"consignee\":\"戚兆美\",\"address\":\"山东省 威海市 环翠区 山东省 威海市 环翠区 古陌路73号西，祥云花园南区速递易（264299B46）(264200).\",\"zipcode\":\"\",\"tel\":\"\",\"mobile\":\"13869003897\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"山东省\",\"city\":\"威海市\",\"district\":\"环翠区\",\"invoice_no\":\"3353549817633\",\"add_time\":\"1519721286\",\"modified\":\"2018-02-28 15:11:39\",\"delivery_time\":\"1519801898\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-27 16:47:52\",\"lylx\":\"后台\",\"shipping_time\":null,\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"22\",\"city_id\":\"295\",\"district_id\":\"2432\"},{\"order_id\":\"20984\",\"order_sn\":\"802270003046\",\"deal_code\":\"0227164747840345827\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519721286\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":null,\"consignee\":\"鲁燕\",\"address\":\"陕西省 西安市 雁塔区 陕西省 西安市 雁塔区 太白南路18号雁塔分局家属院().\",\"zipcode\":\"\",\"tel\":\"\",\"mobile\":\"13891920068\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"陕西省\",\"city\":\"西安市\",\"district\":\"雁塔区\",\"invoice_no\":\"3353549751086\",\"add_time\":\"1519721286\",\"modified\":\"2018-02-28 15:10:36\",\"delivery_time\":\"1519801836\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-27 16:47:52\",\"lylx\":\"后台\",\"shipping_time\":null,\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"24\",\"city_id\":\"311\",\"district_id\":\"2599\"},{\"order_id\":\"20985\",\"order_sn\":\"802270003053\",\"deal_code\":\"802270003053\",\"order_status\":\"3\",\"shipping_status\":\"3\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"alipay\",\"pay_time\":\"1519722545\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"4625\",\"user_nick\":\"何巧娟\",\"consignee\":\"贾宏伟\",\"address\":\"江西省 南昌市 新建县 \"江西南昌市新建县县城内江西南昌新建县黄家湖东路1666号众森红谷一品45栋2单元601室\",\"zipcode\":\"\",\"tel\":\"13970960083\",\"mobile\":\"13970960083\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"江西省\",\"city\":\"南昌市\",\"district\":\"新建县\",\"invoice_no\":\"3353552510977\",\"add_time\":\"1519722429\",\"modified\":\"2018-02-28 11:32:54\",\"delivery_time\":\"0\",\"sd_id\":\"4\",\"ck_id\":\"4\",\"create_time\":\"2018-02-27 17:08:42\",\"lylx\":\"后台\",\"shipping_time\":\"1519808945\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"004\",\"sdmc\":\"微商/代理商\",\"sd_outer_code\":\"\",\"province_id\":\"17\",\"city_id\":\"233\",\"district_id\":\"1967\"},{\"order_id\":\"20986\",\"order_sn\":\"802270003060\",\"deal_code\":\"0227171910S16148T\",\"order_status\":\"0\",\"shipping_status\":\"0\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"0\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"23\",\"shipping_name\":\"yto\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519723163\",\"to_buyer\":\"\",\"postscript\":\" \",\"order_amount\":\"339.00\",\"money_paid\":\"339.00\",\"total_amount\":\"399.00\",\"goods_amount\":\"399.00\",\"user_id\":\"3332\",\"user_nick\":null,\"consignee\":\"陈燕君\",\"address\":\"广东省 佛山市 南海区 桂城街道映月中学\",\"zipcode\":\"528200\",\"tel\":\"\",\"mobile\":\"18819445207\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"广东省\",\"city\":\"佛山市\",\"district\":\"南海区\",\"invoice_no\":\"\",\"add_time\":\"1519723151\",\"modified\":\"2018-02-27 17:19:09\",\"delivery_time\":\"0\",\"sd_id\":\"36\",\"ck_id\":\"15\",\"create_time\":\"2018-02-27 17:19:09\",\"lylx\":\"后台\",\"shipping_time\":null,\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"ckdm\":\"011\",\"ck_outer_code\":\"\",\"sddm\":\"033\",\"sdmc\":\"上朵Soodo微信商城\",\"sd_outer_code\":\"\",\"province_id\":\"6\",\"city_id\":\"80\",\"district_id\":\"747\"},{\"order_id\":\"20987\",\"order_sn\":\"802270003077\",\"deal_code\":\"802270003077\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"20\",\"shipping_name\":\"ems\",\"pay_name\":\"alipay\",\"pay_time\":\"1519724613\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"4742\",\"user_nick\":\"京东刷单\",\"consignee\":\"宋小姐\",\"address\":\"广东省 深圳市 龙岗区 广东深圳市龙岗区布吉街道茵悦之生花园6栋6单元1B\",\"zipcode\":\"\",\"tel\":\"13480112532\",\"mobile\":\"13480112532\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"广东省\",\"city\":\"深圳市\",\"district\":\"龙岗区\",\"invoice_no\":\"1118931118552\",\"add_time\":\"1519724502\",\"modified\":\"2018-02-28 15:12:43\",\"delivery_time\":\"1519801963\",\"sd_id\":\"6\",\"ck_id\":\"4\",\"create_time\":\"2018-02-27 17:42:32\",\"lylx\":\"京东\",\"shipping_time\":\"1520070213\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"006\",\"sdmc\":\"京东爱贝源旗舰店\",\"sd_outer_code\":\"\",\"province_id\":\"6\",\"city_id\":\"77\",\"district_id\":\"709\"},{\"order_id\":\"20988\",\"order_sn\":\"802270003084\",\"deal_code\":\"802270003084\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"144\",\"shipping_name\":\"eyb\",\"pay_name\":\"alipay\",\"pay_time\":\"1519726031\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"4742\",\"user_nick\":\"京东刷单\",\"consignee\":\"慕锦辉\",\"address\":\"北京 北京市 海淀区 北京海淀区五环到六环之间清河街道朱房北二街雪莲公寓207\",\"zipcode\":\"\",\"tel\":\"18601112099\",\"mobile\":\"18601112099\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"北京\",\"city\":\"北京市\",\"district\":\"海淀区\",\"invoice_no\":\"9747521762562\",\"add_time\":\"1519725965\",\"modified\":\"2018-02-28 15:12:48\",\"delivery_time\":\"1519801968\",\"sd_id\":\"6\",\"ck_id\":\"2\",\"create_time\":\"2018-02-27 18:06:53\",\"lylx\":\"京东\",\"shipping_time\":\"1520071631\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"02\",\"ck_outer_code\":\"\",\"sddm\":\"006\",\"sdmc\":\"京东爱贝源旗舰店\",\"sd_outer_code\":\"\",\"province_id\":\"2\",\"city_id\":\"52\",\"district_id\":\"502\"},{\"order_id\":\"20989\",\"order_sn\":\"802270003091\",\"deal_code\":\"0227235434J16236F\",\"order_status\":\"0\",\"shipping_status\":\"0\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"0\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"23\",\"shipping_name\":\"yto\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519746882\",\"to_buyer\":\"\",\"postscript\":\" \",\"order_amount\":\"339.00\",\"money_paid\":\"339.00\",\"total_amount\":\"399.00\",\"goods_amount\":\"399.00\",\"user_id\":\"3332\",\"user_nick\":null,\"consignee\":\"刘旭\",\"address\":\"辽宁省 沈阳市 沈河区 市府大路261号工商银行个人贷款中心三楼\",\"zipcode\":\"110013\",\"tel\":\"\",\"mobile\":\"13079260405\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"辽宁省\",\"city\":\"沈阳市\",\"district\":\"沈河区\",\"invoice_no\":\"\",\"add_time\":\"1519746874\",\"modified\":\"2018-02-27 23:54:28\",\"delivery_time\":\"0\",\"sd_id\":\"36\",\"ck_id\":\"15\",\"create_time\":\"2018-02-27 23:54:28\",\"lylx\":\"后台\",\"shipping_time\":null,\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"ckdm\":\"011\",\"ck_outer_code\":\"\",\"sddm\":\"033\",\"sdmc\":\"上朵Soodo微信商城\",\"sd_outer_code\":\"\",\"province_id\":\"18\",\"city_id\":\"244\",\"district_id\":\"2060\"},{\"order_id\":\"20990\",\"order_sn\":\"802280000011\",\"deal_code\":\"72614220719,802280000011\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"alipay\",\"pay_time\":\"1519781821\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"4785\",\"user_nick\":\"15110182948\",\"consignee\":\"唐慧娴\",\"address\":\"湖北省 武汉市 东西湖区 区沿海赛洛城一期27栋5楼\",\"zipcode\":\"\",\"tel\":\"18085032802\",\"mobile\":\"18085032802\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"湖北省\",\"city\":\"武汉市\",\"district\":\"东西湖区\",\"invoice_no\":\"3353552295733\",\"add_time\":\"1519780784\",\"modified\":\"2018-02-28 15:12:56\",\"delivery_time\":\"1519801976\",\"sd_id\":\"6\",\"ck_id\":\"2\",\"create_time\":\"2018-02-28 09:36:36\",\"lylx\":\"京东\",\"shipping_time\":\"1520127421\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"02\",\"ck_outer_code\":\"\",\"sddm\":\"006\",\"sdmc\":\"京东爱贝源旗舰店\",\"sd_outer_code\":\"\",\"province_id\":\"13\",\"city_id\":\"180\",\"district_id\":\"1551\"},{\"order_id\":\"20991\",\"order_sn\":\"802280000028\",\"deal_code\":\"802280000028\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"144\",\"shipping_name\":\"eyb\",\"pay_name\":\"alipay\",\"pay_time\":\"1519784534\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"3280.00\",\"money_paid\":\"3280.00\",\"total_amount\":\"3280.00\",\"goods_amount\":\"3280.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"石少华\",\"address\":\"湖北省 荆州市 洪湖市 曹市镇\",\"zipcode\":\"\",\"tel\":\"13135783616\",\"mobile\":\"13135783616\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"湖北省\",\"city\":\"荆州市\",\"district\":\"洪湖市\",\"invoice_no\":\"9747519854662\",\"add_time\":\"1519784493\",\"modified\":\"2018-02-28 15:12:49\",\"delivery_time\":\"1519801969\",\"sd_id\":\"24\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:22:02\",\"lylx\":\"后台\",\"shipping_time\":\"1519870934\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"021\",\"sdmc\":\"科学育儿\",\"sd_outer_code\":\"\",\"province_id\":\"13\",\"city_id\":\"186\",\"district_id\":\"1586\"},{\"order_id\":\"20992\",\"order_sn\":\"802280000035\",\"deal_code\":\"802280000035\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"alipay\",\"pay_time\":\"1519784588\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"石少华\",\"address\":\"湖北省 荆州市 洪湖市 曹市镇\",\"zipcode\":\"\",\"tel\":\"13135783616\",\"mobile\":\"13135783616\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"湖北省\",\"city\":\"荆州市\",\"district\":\"洪湖市\",\"invoice_no\":\"3353552362739\",\"add_time\":\"1519784543\",\"modified\":\"2018-02-28 15:12:58\",\"delivery_time\":\"1519801977\",\"sd_id\":\"24\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:22:49\",\"lylx\":\"后台\",\"shipping_time\":\"1519870988\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"021\",\"sdmc\":\"科学育儿\",\"sd_outer_code\":\"\",\"province_id\":\"13\",\"city_id\":\"186\",\"district_id\":\"1586\"},{\"order_id\":\"20993\",\"order_sn\":\"802280000042\",\"deal_code\":\"802280000042\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"144\",\"shipping_name\":\"eyb\",\"pay_name\":\"alipay\",\"pay_time\":\"1519785086\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"3280.00\",\"money_paid\":\"3280.00\",\"total_amount\":\"3280.00\",\"goods_amount\":\"3280.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"刘丽娟\",\"address\":\"新疆维吾尔自治区 石河子 石河子市 新疆农垦科学院乌伊公路221号\",\"zipcode\":\"\",\"tel\":\"18095980688\",\"mobile\":\"18095980688\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"新疆维吾尔自治区\",\"city\":\"石河子\",\"district\":\"石河子市\",\"invoice_no\":\"9747525309762\",\"add_time\":\"1519785026\",\"modified\":\"2018-02-28 15:07:48\",\"delivery_time\":\"1519801668\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:31:01\",\"lylx\":\"后台\",\"shipping_time\":\"1519871486\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"29\",\"city_id\":\"362\",\"district_id\":\"3070\"},{\"order_id\":\"20994\",\"order_sn\":\"802280000059\",\"deal_code\":\"802280000059\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"alipay\",\"pay_time\":\"1519785147\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"刘丽娟\",\"address\":\"新疆维吾尔自治区 石河子 石河子市 新疆农垦科学院乌伊公路221号\",\"zipcode\":\"\",\"tel\":\"18095980688\",\"mobile\":\"18095980688\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"新疆维吾尔自治区\",\"city\":\"石河子\",\"district\":\"石河子市\",\"invoice_no\":\"3353551595511\",\"add_time\":\"1519785094\",\"modified\":\"2018-02-28 16:21:24\",\"delivery_time\":\"1519806084\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:32:09\",\"lylx\":\"后台\",\"shipping_time\":\"1519871547\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"29\",\"city_id\":\"362\",\"district_id\":\"3070\"},{\"order_id\":\"20995\",\"order_sn\":\"802280000066\",\"deal_code\":\"802280000066\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"alipay\",\"pay_time\":\"1519785206\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"刘丽娟\",\"address\":\"新疆维吾尔自治区 石河子 石河子市 新疆农垦科学院乌伊公路221号\",\"zipcode\":\"\",\"tel\":\"18095980688\",\"mobile\":\"18095980688\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"新疆维吾尔自治区\",\"city\":\"石河子\",\"district\":\"石河子市\",\"invoice_no\":\"3353552057791\",\"add_time\":\"1519785159\",\"modified\":\"2018-02-28 15:08:28\",\"delivery_time\":\"1519801708\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:33:11\",\"lylx\":\"后台\",\"shipping_time\":\"1519871606\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"\",\"extension_id\":\"0\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"29\",\"city_id\":\"362\",\"district_id\":\"3070\"},{\"order_id\":\"20996\",\"order_sn\":\"802280000073\",\"deal_code\":\"802280000073\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"144\",\"shipping_name\":\"eyb\",\"pay_name\":\"alipay\",\"pay_time\":\"1519785830\",\"to_buyer\":\"同时寄出 客户寄回2806476911470刚收到机器，换新符号不会消失，水箱感应浮子装水会浮起 。重新提起按压到底也是一样，要求退货，协商同时寄出换新\",\"postscript\":\"\",\"order_amount\":\"3280.00\",\"money_paid\":\"3280.00\",\"total_amount\":\"3280.00\",\"goods_amount\":\"3280.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"庞珍珍\",\"address\":\"广东省 珠海市 斗门区 白蕉镇时代倾城一期9栋2804室\",\"zipcode\":\"\",\"tel\":\"15800296332\",\"mobile\":\"15800296332\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"广东省\",\"city\":\"珠海市\",\"district\":\"斗门区\",\"invoice_no\":\"9747536064962\",\"add_time\":\"1519785297\",\"modified\":\"2018-02-28 15:05:34\",\"delivery_time\":\"1519801534\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:43:03\",\"lylx\":\"后台\",\"shipping_time\":\"1519872230\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"同时寄出 客户寄回2806476911470刚收到机器，换新符号不会消失，水箱感应浮子装水会浮起 。重新提起按压到底也是一样，要求退货，协商同时寄出换新\",\"extension_id\":\"2\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"6\",\"city_id\":\"96\",\"district_id\":\"851\",\"extension\":\"8001\"},{\"order_id\":\"20997\",\"order_sn\":\"802280000080\",\"deal_code\":\"706090000066,706090000059,802280000080\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"20\",\"shipping_name\":\"ems\",\"pay_name\":\"alipay\",\"pay_time\":\"1519786070\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"3280.00\",\"money_paid\":\"3280.00\",\"total_amount\":\"3280.00\",\"goods_amount\":\"3280.00\",\"user_id\":\"2545\",\"user_nick\":\"庾某仁\",\"consignee\":\"庾某仁\",\"address\":\"广东省 广州市 花都区 炭步镇司法所\",\"zipcode\":\"\",\"tel\":\"13570346728\",\"mobile\":\"13570346728\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"广东省\",\"city\":\"广州市\",\"district\":\"花都区\",\"invoice_no\":\"1118927569552\",\"add_time\":\"1519786041\",\"modified\":\"2018-02-28 15:12:44\",\"delivery_time\":\"1519801964\",\"sd_id\":\"4\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:47:21\",\"lylx\":\"后台\",\"shipping_time\":\"1519872470\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"换货追单\",\"extension_id\":\"2\",\"email\":\"\",\"merge_new_order_sn\":\"\",\"splite_new_order_sn\":\"\",\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"004\",\"sdmc\":\"微商/代理商\",\"sd_outer_code\":\"\",\"province_id\":\"6\",\"city_id\":\"76\",\"district_id\":\"701\",\"extension\":\"8001\"},{\"order_id\":\"20998\",\"order_sn\":\"802280000097\",\"deal_code\":\"112915220313466613,802280000097\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"144\",\"shipping_name\":\"eyb\",\"pay_name\":\"weixinpay\",\"pay_time\":\"1519786209\",\"to_buyer\":\"\",\"postscript\":\"\",\"order_amount\":\"3280.00\",\"money_paid\":\"3280.00\",\"total_amount\":\"3280.00\",\"goods_amount\":\"3280.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"张旭\",\"address\":\"四川省 宜宾市 筠连县 四川省 宜宾市 筠连县 城北农贸市场楼上(645250).\",\"zipcode\":\"\",\"tel\":\"\",\"mobile\":\"15808474413\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"四川省\",\"city\":\"宜宾市\",\"district\":\"筠连县\",\"invoice_no\":\"9747533237362\",\"add_time\":\"1519786209\",\"modified\":\"2018-02-28 15:05:10\",\"delivery_time\":\"1519801510\",\"sd_id\":\"21\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:50:09\",\"lylx\":\"后台\",\"shipping_time\":\"1519872609\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"换货追单\",\"extension_id\":\"2\",\"email\":\"\",\"merge_new_order_sn\":\"\",\"splite_new_order_sn\":\"\",\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"018\",\"sdmc\":\"凯叔\",\"sd_outer_code\":\"\",\"province_id\":\"26\",\"city_id\":\"339\",\"district_id\":\"2892\",\"extension\":\"8001\"},{\"order_id\":\"20999\",\"order_sn\":\"802280000103\",\"deal_code\":\"802280000103\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"144\",\"shipping_name\":\"eyb\",\"pay_name\":\"alipay\",\"pay_time\":\"1519786571\",\"to_buyer\":\"客户寄回751829280501水箱难提压。 告知涂抹上食用油， 漏水拧紧滤芯擦干净底部重新安装水箱  依然漏水\",\"postscript\":\"\",\"order_amount\":\"3280.00\",\"money_paid\":\"3280.00\",\"total_amount\":\"3280.00\",\"goods_amount\":\"3280.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"刘萍\",\"address\":\"上海 上海市 长宁区 黄金城道555弄7号1902室（华丽家族小区）\",\"zipcode\":\"\",\"tel\":\"13501689246\",\"mobile\":\"13501689246\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"上海\",\"city\":\"上海市\",\"district\":\"长宁区\",\"invoice_no\":\"9747540076262\",\"add_time\":\"1519786498\",\"modified\":\"2018-02-28 15:12:36\",\"delivery_time\":\"1519801956\",\"sd_id\":\"4\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 10:55:58\",\"lylx\":\"后台\",\"shipping_time\":\"1519872971\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"客户寄回751829280501水箱难提压。 告知涂抹上食用油， 漏水拧紧滤芯擦干净底部重新安装水箱  依然漏水\",\"extension_id\":\"2\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"1\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"004\",\"sdmc\":\"微商/代理商\",\"sd_outer_code\":\"\",\"province_id\":\"25\",\"city_id\":\"321\",\"district_id\":\"2703\",\"extension\":\"8001\"},{\"order_id\":\"21000\",\"order_sn\":\"802280000110\",\"deal_code\":\"802280000110\",\"order_status\":\"1\",\"shipping_status\":\"1\",\"pay_status\":\"2\",\"process_status\":\"0\",\"is_send\":\"2\",\"is_locked\":\"0\",\"is_separate\":\"0\",\"shipping_id\":\"21\",\"shipping_name\":\"sto\",\"pay_name\":\"alipay\",\"pay_time\":\"1519788180\",\"to_buyer\":\"地推更换滤芯\",\"postscript\":\"\",\"order_amount\":\"0.00\",\"money_paid\":\"0.00\",\"total_amount\":\"0.00\",\"goods_amount\":\"0.00\",\"user_id\":\"3332\",\"user_nick\":\"\",\"consignee\":\"陈生\",\"address\":\"广东省 深圳市 其它区 龙华新区建辉路221号信伟大厦713\",\"zipcode\":\"\",\"tel\":\"13632821536\",\"mobile\":\"13632821536\",\"shipping_fee\":\"0.00\",\"cz_shipping_fee\":\"0.00\",\"province\":\"广东省\",\"city\":\"深圳市\",\"district\":\"其它区\",\"invoice_no\":\"3353598182298\",\"add_time\":\"1519787976\",\"modified\":\"2018-02-28 16:45:55\",\"delivery_time\":\"1519807555\",\"sd_id\":\"10\",\"ck_id\":\"4\",\"create_time\":\"2018-02-28 11:20:35\",\"lylx\":\"后台\",\"shipping_time\":\"1519960980\",\"inv_payee\":\"\",\"inv_content\":\"\",\"order_note\":\"地推更换滤芯\",\"extension_id\":\"2\",\"email\":\"\",\"merge_new_order_sn\":null,\"splite_new_order_sn\":null,\"goods_count\":\"2\",\"is_emergency\":\"0\",\"inv_status\":\"0\",\"order_name\":\"\",\"order_cert_type\":\"\",\"order_cert_no\":\"\",\"yfje\":0,\"ckdm\":\"04\",\"ck_outer_code\":\"\",\"sddm\":\"008\",\"sdmc\":\"地推订单\",\"sd_outer_code\":\"\",\"province_id\":\"6\",\"city_id\":\"77\",\"district_id\":\"3657\",\"extension\":\"8001\"}]}} \n";
        resultJson = StringEscapeUtils.unescapeJava(resultJson); // unicode
        resultJson = resultJson.replaceAll("[\\t\\n\\r]", "");
        JSONObject jsonObject = JSONObject.fromObject(resultJson);
        // default HTTP SUCCESS
        JSONObject respData = JSONObject.fromObject(jsonObject.get("resp_data"));
        System.out.println(respData);
    }

    /**
     * 分页查询订单列表信息
     * @param request
     * @param salesOrder
     * @param pageSize
     * @param pageNO
     * @param totalNum
     * @return
     * @throws Exception
     */
    @RequestMapping("/list_order_page")
    @RequiresPermissions("salesOrder:select:salesOrder")
    public ModelAndView listOrderPage(HttpServletRequest request, SalesOrder salesOrder,
                                        @RequestParam(value = "pageSize", defaultValue = "10", required = false) Integer pageSize,
                                        @RequestParam(value = "pageNO", defaultValue = "1", required = false) Integer pageNO,
                                        @RequestParam(value = "totalNum", defaultValue = "0", required = false) Integer totalNum) throws Exception {
        ModelAndView mv = new ModelAndView("cm/salesOrder/sales_order_list");
        //分页获取订单信息
        PagedResult<SalesOrder> pagedResult = salesOrderService.listSalesOrderPage(pageNO, pageSize, salesOrder, totalNum == 0);
        if (totalNum != 0) {
            pagedResult.setTotal(totalNum);
        }
        salesOrder.setSalesOrderItemList(null);
        StitchAttrUtil.setModelAndView(salesOrder, mv, "/admin/salesOrder/list_order_page", pagedResult);
        return mv;
    }

    /**
     * 查询订单详情
     * @param request
     * @return
     * @throws Exception
     */
    @RequestMapping("/select_sales_order")
    @RequiresPermissions("salesOrder:select:salesOrder")
    public ModelAndView selectSalesOrder(HttpServletRequest request) throws Exception {
        ModelAndView mv = new ModelAndView("cm/salesOrder/sales_order_detail");
        String salesId = request.getParameter("salesId");
        if (!StringUtils.isNotEmpty(salesId)) {
            return mv;
        }
        SalesOrder order = new SalesOrder();
        order.setSalesId(Integer.parseInt(salesId));
        //根据id查询订单数据
        List<SalesOrder> orderList = salesOrderService.listSalesOrder(order);
        if (orderList == null || orderList.size() == 0) {
            return mv;
        }
        order = orderList.get(0);
        SalesOrderItem item = new SalesOrderItem();
        item.setItemOrderId(Integer.parseInt(salesId));
        //批量获取订单项信息
        List<SalesOrderItem> itemList = salesOrderService.listSalesOrderItem(item);
        order.setSalesOrderItemList(itemList);
        mv.addObject("order",order);
        return mv;
    }

    /**
     * 导出订单
     * @param request
     * @param res
     * @param salesOrder
     * @throws Exception
     */
    @RequiresPermissions("salesOrder:excel:salesOrder")
    @RequestMapping("/sales_order_excel")
    public void salesOrderExcel(HttpServletRequest request,HttpServletResponse res,
                                SalesOrder salesOrder) throws Exception{
        //根据id查询订单数据
        List<SalesOrder> orderList = salesOrderService.listOrderExcel(salesOrder);
        if (orderList == null || orderList.size() == 0) {
            return;
        }
        String[] cells = {
                "订单号","交易号","销售公司","店铺名称","产品名称",
                "颜色名称","数量","产品69码","是否支付","是否发货",
                "订单金额","支付金额","付款方式","邮费","支付时间",
                "发货时间","收货人姓名","收货人电话","收货地址",
                "物流公司","物流单号","用户备注"
        };
        //导出订单Excel并下载
        exportExcel(request,res,cells,orderList);
    }

    /**
     * 导出订单Excel并下载
     * @param request
     * @param res
     * @param cells
     * @param orderList
     * @throws Exception
     */
    public void exportExcel(HttpServletRequest request,HttpServletResponse res,
                            String[] cells,List<SalesOrder> orderList) throws Exception {
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        //创建一个workbook，对应一个Excel文件
        HSSFWorkbook wb = new HSSFWorkbook();
        //在workbook中添加一个sheet，对应Excel中的一个sheet
        HSSFSheet sheet = wb.createSheet("导出订单");
        //在sheet中添加表头第0行，老版本poi对excel行数列数有限制short
        HSSFRow row = sheet.createRow((int) 0);
        //创建单元格，设置值表头，设置表头居中
        HSSFCellStyle style = wb.createCellStyle();
        //居中格式
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        //设置表头

        if (cells == null || cells.length == 0) {
            return;
        }
        //循环设置表头
        HSSFCell cell = null;
        for (int i = 0;i < cells.length;i++) {
            String name = cells[i];
            cell = row.createCell(i);
            cell.setCellValue(name);
            cell.setCellStyle(style);
        }
        for (int i = 0; i < orderList.size(); i++) {
            row = sheet.createRow((int) i + 1);
            SalesOrder order = orderList.get(i);
            String payType = "";
            switch (order.getSalesPayType()) {
                case 1:payType = "微信支付";break;
                case 2:payType = "现金支付";break;
                case 3:payType = "已支付定金￥99";break;
                case 4:payType = "刷卡支付";break;
                case 5:payType = "支付宝支付";break;
            }
            String payStatus = "";
            switch (order.getSalesPayStatus()) {
                case 0:payStatus = "未支付";break;
                case 2:payStatus = "已支付";break;
            }
            String shippingStatus = "";
            switch (order.getSalesShippingStatus()) {
                case 0:shippingStatus = "未发货";break;
                case 1:shippingStatus = "已发货";break;
                case 3:shippingStatus = "备货中";break;
            }
            //获取快递公司
            String postFirm = getPostFirm(order.getSalesPostFirm());

            // 创建单元格，设置值
            row.createCell(0).setCellValue(order.getSalesOrderId());
            row.createCell(1).setCellValue(order.getSalesDealCode());
            row.createCell(2).setCellValue(order.getCompanyName());
            row.createCell(3).setCellValue(order.getStoreName());
            row.createCell(4).setCellValue(order.getItemProductName());
            row.createCell(5).setCellValue(order.getItemProductColor());
            row.createCell(6).setCellValue(order.getItemNum()==null?0:order.getItemNum());
            row.createCell(7).setCellValue(order.getItemColorBar()==null?"":order.getItemColorBar());
            row.createCell(8).setCellValue(payStatus);
            row.createCell(9).setCellValue(shippingStatus);
            row.createCell(10).setCellValue(order.getSalesAmount()/100);
            row.createCell(11).setCellValue(order.getSalesPayMoney()/100);
            row.createCell(12).setCellValue(payType);
            row.createCell(13).setCellValue(order.getSalesShippingFee());
            row.createCell(14).setCellValue(order.getSalesPayTime()==null?"":format.format(order.getSalesPayTime()));
            row.createCell(15).setCellValue(order.getSalesSendTime()==null?"":format.format(order.getSalesSendTime()));
            row.createCell(16).setCellValue(order.getSalesAddressName());
            row.createCell(17).setCellValue(order.getSalesAddressTel());
            row.createCell(18).setCellValue(order.getSalesAddressInfo());
            row.createCell(19).setCellValue(postFirm);
            row.createCell(20).setCellValue(order.getSalesPostNum());
            row.createCell(21).setCellValue(order.getSalesUserRemark());
        }
        //下载导出订单Excel
        downloadOrderExcel(res,wb);
    }

    /**
     * 下载导出订单Excel
     * @param res
     * @param wb
     * @throws Exception
     */
    public void downloadOrderExcel(HttpServletResponse res, HSSFWorkbook wb) throws Exception{
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
        String fileName = format.format(new Date()) + "订单报表";
        ByteArrayOutputStream os = new ByteArrayOutputStream();
        wb.write(os);
        byte[] content = os.toByteArray();
        InputStream is = new ByteArrayInputStream(content);
        // 设置response参数，可以打开下载页面
        res.reset();
        res.setContentType("application/vnd.ms-excel;charset=utf-8");
        res.setHeader("Content-Disposition", "attachment;filename="
                + new String((fileName + ".xls").getBytes(), "iso-8859-1"));
        ServletOutputStream out = res.getOutputStream();
        BufferedInputStream bis = null;
        BufferedOutputStream bos = null;
        try {
            bis = new BufferedInputStream(is);
            bos = new BufferedOutputStream(out);
            byte[] buff = new byte[2048];
            int bytesRead;
            // Simple read/write loop.
            while (-1 != (bytesRead = bis.read(buff, 0, buff.length))) {
                bos.write(buff, 0, bytesRead);
            }
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        } finally {
            if (bis != null)
                bis.close();
            if (bos != null)
                bos.close();
        }
    }

    /**
     * 获取快递公司
     * @param firm
     * @return
     */
    public String getPostFirm(String firm) {
        String postFirm = "";
        switch (firm) {
            case "sto":postFirm = "申通快递";break;
            case "yto":postFirm = "圆通快递";break;
            case "sf":postFirm = "顺丰快递";break;
            case "ems":postFirm = "邮政EMS";break;
            case "zto":postFirm = "中通快递";break;
            case "zjs":postFirm = "宅急送";break;
            case "yunda":postFirm = "韵达快递";break;
            case "cces":postFirm = "cces快递";break;
            case "pick":postFirm = "上门提货";break;
            case "htky":postFirm = "汇通快递";break;
            case "ttkdex":postFirm = "天天快递";break;
            case "stars":postFirm = "星晨急便";break;
            case "jd":postFirm = "京东快递";break;
            case "01":postFirm = "其他";break;
            case "02":postFirm = "上门送货";break;
            default:postFirm = "申通快递";break;
        }
        return postFirm;
    }

    /**
     * 获取快递公司
     * @param firm
     * @return
     */
    public String getPostCode(String firm) {
        if (firm == null || firm.equals("")) {
            return "01";
        }
        LogisticsInfo logisticsInfo = new LogisticsInfo();
        logisticsInfo.setLogisticsName(firm);
        List<LogisticsInfo> listLogisticsInfo = salesOrderService.getLogisticsInfo(logisticsInfo);
        if(listLogisticsInfo.size() > 0){
            return listLogisticsInfo.get(0).getLogisticsRstCode();
        }else{
            return "01";
        }
        /*String postCode = "";
        switch (firm) {
            case "申通快递":postCode = "sto";break;
            case "圆通快递":postCode = "yto";break;
            case "顺丰快递":postCode = "sf";break;
            case "邮政EMS":postCode = "ems";break;
            case "省外EMS":postCode = "ems";break;
            case "中通快递":postCode = "zto";break;
            case "宅急送":postCode = "zjs";break;
            case "韵达快递":postCode = "yunda";break;
            case "cces快递":postCode = "cces";break;
            case "上门提货":postCode = "pick";break;
            case "汇通快递":postCode = "htky";break;
            case "天天快递":postCode = "ttkdex";break;
            case "星晨急便":postCode = "stars";break;
            case "京东快递":postCode = "jd";break;
            case "其他":postCode = "01";break;
            case "上门送货":postCode = "02";break;
            default:postCode = "sto";break;
        }
        return postCode;*/
    }

    /**
     * 同步百胜订单
     *
     * @return
     * @throws Exception
     */
    @ResponseBody
    @RequiresPermissions("salesOrder:sync:order")
    @RequestMapping("/sync_efast_order")
    public ResponseJson syncEfastOrder(HttpServletRequest request) throws Exception {
        String salesDealCode = request.getParameter("salesDealCode").trim();
        if (!StringUtils.isNotEmpty(salesDealCode)) {
            return new ResponseJson(500, "订单编号不能为空，请重新输入!", 500);
        }
        //根据时间排序查询订单 信息
        SalesOrder salesOrder = new SalesOrder();
        salesOrder.setSalesOrderId(salesDealCode);
        int num = salesOrderService.getOrderInfoCount(salesOrder);
        if (num > 0) {
            return new ResponseJson(500, "该订单已存在，无需同步!", 500);
        }
        synchronized (lock) {
            //获取订单详情
            JSONObject orderInfo = efastOrderService.getOrderFormEfastByOrderId(salesDealCode);
            //添加订单和订单项
            boolean flag = true;
            try {
                flag = salesOrderService.syncEfastOrder(orderInfo);
            }catch (Exception e){
                return new ResponseJson(500, e.getMessage(), 500);
            }
            if (flag) {
                return new ResponseJson(200, "同步成功!", 200);
            } else {
                return new ResponseJson(500, "同步订单错误！", 500);
            }
        }
    }


    /**
     * 下载efast订单 (2018-05-25)
     * @param request
     * @param res
     * @param salesOrder
     * @throws Exception
     */
    @RequiresPermissions("salesOrder:excel:salesOrder")
    @RequestMapping("/download_efast_order")
    public void downloadEfastOrderExcel(HttpServletRequest request,HttpServletResponse res,
                                SalesOrder salesOrder) throws Exception{
        salesOrder.setSalesIsDownload(1);
        //根据id查询订单数据
        List<SalesOrder> orderList = salesOrderService.listOrderExcel(salesOrder);
            String[] cells = {
                    "订单序号(*)","下单日期(文本型*)","店铺代码(*)","交易号（*）","用户昵称（*）",
                    "收货人","手机号","电话","顾客地址（*）","邮编",
                    "支付方式","支付交易号","付款日期(货到付款时非必填*)","快递公司","运费",
                    "其他折扣","商家备注","条形码（*）","均摊金额（单价二选一）",
                    "单价","数量（*）","发票抬头","发票内容"
            };
            //导出订单Excel并下载
            efastOrderExcel(request,res,cells,orderList);

    }


    /**
     * 导出订单Excel并下载
     * @param request
     * @param res
     * @param cells
     * @param orderList
     * @throws Exception
     */
    public void efastOrderExcel(HttpServletRequest request,HttpServletResponse res,
                            String[] cells,List<SalesOrder> orderList) throws Exception {
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm");
        SimpleDateFormat format2 = new SimpleDateFormat("yyyy-MM-dd");
        //创建一个workbook，对应一个Excel文件
        HSSFWorkbook wb = new HSSFWorkbook();
        //在workbook中添加一个sheet，对应Excel中的一个sheet
        HSSFSheet sheet = wb.createSheet("导出订单");
        //在sheet中添加表头第0行，老版本poi对excel行数列数有限制short
        HSSFRow row = sheet.createRow((int) 0);
        //创建单元格，设置值表头，设置表头居中
        HSSFCellStyle style = wb.createCellStyle();
        //居中格式
        style.setAlignment(HSSFCellStyle.ALIGN_CENTER);
        //设置表头

        if (cells == null || cells.length == 0) {
            return;
        }
        //循环设置表头
        HSSFCell cell = null;
        for (int i = 0;i < cells.length;i++) {
            String name = cells[i];
            cell = row.createCell(i);
            cell.setCellValue(name);
            cell.setCellStyle(style);
        }
        for (int i = 0; i < orderList.size(); i++) {
            row = sheet.createRow((int) i + 1);
            SalesOrder order = orderList.get(i);
            String payType = "";
            switch (order.getSalesPayType()) {
                case 1:payType = "微信支付";break;
                case 2:payType = "现金支付";break;
                case 3:payType = "已支付定金￥99";break;
                case 4:payType = "刷卡支付";break;
                case 5:payType = "支付宝支付";break;
            }

            StoreInfo storeInfo = storeInfoService.getStoreInfoById(order.getSalesStoreId());

            /**String[] cells = {
             "订单序号(*)","下单日期(文本型*)","店铺代码(*)","交易号（*）","用户昵称（*）",
             "收货人","手机号","电话","顾客地址（*）","邮编",
             "支付方式","支付交易号","付款日期(货到付款时非必填*)","快递公司","运费",
             "其他折扣","商家备注","条形码（*）","均摊金额（单价二选一）",
             "单价","数量（*）","发票抬头","发票内容"
             };**/

            // 创建单元格，设置值
            row.createCell(0).setCellValue(order.getSalesId());
            row.createCell(1).setCellValue(order.getSalesSalesTime()==null?"":format2.format(order.getSalesSalesTime()));
            row.createCell(2).setCellValue(storeInfo.getStoreId());
            row.createCell(3).setCellValue(order.getSalesDealCode());
            row.createCell(4).setCellValue(order.getSalesAddressName());
            row.createCell(5).setCellValue(order.getSalesAddressName());
            row.createCell(6).setCellValue(order.getSalesAddressTel());
            row.createCell(7).setCellValue("");
            row.createCell(8).setCellValue(order.getSalesAddressInfo());
            row.createCell(9).setCellValue("");
            row.createCell(10).setCellValue(payType);
            row.createCell(11).setCellValue(order.getSalesDealCode());
            row.createCell(12).setCellValue(order.getSalesPayTime()==null?"":format.format(order.getSalesPayTime()));
            row.createCell(13).setCellValue("");
            row.createCell(14).setCellValue("");
            row.createCell(15).setCellValue("");
            row.createCell(16).setCellValue(order.getSalesAdminRemark() == null ? "":order.getSalesAdminRemark());
            row.createCell(17).setCellValue(order.getItemColorBar());
            row.createCell(18).setCellValue("");
            row.createCell(19).setCellValue("");
            row.createCell(20).setCellValue(order.getItemNum());
            row.createCell(21).setCellValue("");
            row.createCell(22).setCellValue("");
        }
        //修改订单是否已下载状态
        if(orderList.size() > 0){
            salesOrderService.updateOrderListIsDownload(orderList);
        }
        //下载导出订单Excel
        downloadOrderExcel(res,wb);
    }


    /**
     * 上传efast物流信息excel到系统订单
     * @param response
     * @return
     */
    @RequestMapping("/uploadLogisticsExcel")
    @ResponseBody
    public String uploadLogisticsExcel(HttpServletResponse response,HttpServletRequest request,@RequestParam("file") String file)throws IOException  {
        Integer maxNumber = 100;
        String path = request.getServletContext().getRealPath(file);
        boolean flag = ExcelUtil.readExcelNumber(path,maxNumber);
        if(!flag){
            return "最大上传数量为一百条，请检查文档内的数据是否符合条件！";
        }
        List<String> listString  = ExcelUtil.readExcelHead(path);
        if(listString == null){
            return "数据不合格，请检查文档内的数据是否正常！";
        }
        List<String> tradings =   ExcelUtil.readCell2(path,listString.get(2));//外部交易号
        List<String> oderIds =   ExcelUtil.readCell2(path,listString.get(4));//efast订单号
        List<String> kuyaidi =   ExcelUtil.readCell2(path,listString.get(12));//快递公司
        List<String> danhao =   ExcelUtil.readCell2(path,listString.get(15));//快递单号
        if(oderIds == null || tradings == null || kuyaidi == null || danhao == null){
            return "数据不合格，请检查文档内的数据是否正常！";
        }
        if(oderIds.size() != kuyaidi.size() || oderIds.size() != danhao.size()|| oderIds.size() != tradings.size()){
            return "数据不合格，请检查文档内的数据是否正常！";
        }
        SalesOrder salesOrder = new SalesOrder();
        Integer success = 0,error = 0;
        List<String> errorOrders = new ArrayList();
        for (int i = 0;i< tradings.size();i++){
           if( tradings.get(i) != null &&  !tradings.get(i).equals("") &&
                   oderIds.get(i) != null &&  !oderIds.get(i).equals("") &&
                   kuyaidi.get(i) != null &&  !kuyaidi.get(i).equals("") &&
                   danhao.get(i) != null &&  !danhao.get(i).equals("")){
               String code = getPostCode(kuyaidi.get(i));
               salesOrder.setSalesDealCode(tradings.get(i));
               salesOrder.setSalesOrderId(oderIds.get(i));
               salesOrder.setSalesPostFirm(code);
               salesOrder.setSalesPostNum(danhao.get(i));
               Integer msg = salesOrderService.updateSalesOrderByDealCode(salesOrder);
               if(msg > 0){
                   success++;
               }else{
                   errorOrders.add(tradings.get(i));
                   error++;
               }
           }
        }
        String data = "上传完成，成功："+success+"条，失败："+error+"条";
        if(error > 0){
            data = data+errorOrders.toString();
        }
        return data;
    }
}