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 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 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 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 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 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 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 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 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 listString = ExcelUtil.readExcelHead(path); if(listString == null){ return "数据不合格，请检查文档内的数据是否正常！"; } List tradings = ExcelUtil.readCell2(path,listString.get(2));//外部交易号 List oderIds = ExcelUtil.readCell2(path,listString.get(4));//efast订单号 List kuyaidi = ExcelUtil.readCell2(path,listString.get(12));//快递公司 List 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 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; } }