AdminNewOrderApiController.java 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607
  1. package com.goafanti.order.controller;
  2. import java.io.IOException;
  3. import java.text.ParseException;
  4. import java.text.SimpleDateFormat;
  5. import java.util.List;
  6. import javax.servlet.http.HttpServletRequest;
  7. import javax.servlet.http.HttpServletResponse;
  8. import com.goafanti.order.bo.*;
  9. import org.apache.commons.lang3.StringUtils;
  10. import org.springframework.beans.factory.annotation.Autowired;
  11. import org.springframework.beans.factory.annotation.Value;
  12. import org.springframework.web.bind.annotation.RequestMapping;
  13. import org.springframework.web.bind.annotation.RequestMethod;
  14. import org.springframework.web.bind.annotation.RestController;
  15. import com.goafanti.common.bo.Result;
  16. import com.goafanti.common.constant.ErrorConstants;
  17. import com.goafanti.common.controller.CertifyApiController;
  18. import com.goafanti.common.model.TOrderNewWithBLOBs;
  19. import com.goafanti.common.model.TOrderRefundWithBLOBs;
  20. import com.goafanti.common.model.TOrderTask;
  21. import com.goafanti.common.utils.excel.NewExcelUtil;
  22. import com.goafanti.order.enums.ApprovalNewState;
  23. import com.goafanti.order.enums.OrderNewState;
  24. import com.goafanti.order.service.OrderNewService;
  25. @RestController
  26. @RequestMapping(value = "/api/admin/newOrder")
  27. public class AdminNewOrderApiController extends CertifyApiController {
  28. @Autowired
  29. private OrderNewService orderNewService;
  30. @Value(value = "${upload.path}")
  31. private String uploadPath = null;
  32. /**
  33. * 创建订单、开单
  34. * @param uid
  35. * @param orderType
  36. * @return
  37. */
  38. @RequestMapping(value = "/createOrder",method = RequestMethod.POST)
  39. public Result createOrder(String uid,Integer orderType){
  40. Result res = new Result();
  41. if(StringUtils.isBlank(uid)){
  42. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","客户编号"));
  43. return res;
  44. }
  45. if(orderType == null){
  46. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","订单类型"));
  47. return res;
  48. }
  49. res.data(orderNewService.createServiceOrder(uid,orderType));
  50. return res;
  51. }
  52. /**
  53. * 添加项目
  54. * @param t
  55. * @return
  56. */
  57. @RequestMapping(value = "/addOrderTask",method = RequestMethod.POST)
  58. public Result addOrderTask(TOrderTask t){
  59. Result res = new Result();
  60. if(StringUtils.isBlank(t.getOrderNo())){
  61. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","订单编号"));
  62. return res;
  63. }
  64. if (t.getOrderNo()!=null&&orderNewService.checkOrderMain(t)) {
  65. res.getError().add(buildError("订单主要任务已存在","订单主要任务已存在"));
  66. return res;
  67. }
  68. return res.data(orderNewService.addOrderTask(t));
  69. }
  70. /**
  71. * 修改项目(营销员)
  72. * @param t
  73. * @return
  74. */
  75. @RequestMapping(value = "/updateOrderTask",method = RequestMethod.POST)
  76. public Result updateOrderTask(TOrderTask t){
  77. Result res=new Result();
  78. if(null==t.getId()){
  79. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","项目编号"));
  80. return res;
  81. }
  82. if (t.getOrderNo()!=null&&orderNewService.checkOrderMain(t)) {
  83. res.getError().add(buildError("订单主要任务已存在","订单主要任务已存在"));
  84. return res;
  85. }
  86. return res.data(orderNewService.updateOrderTask(t));
  87. }
  88. /**
  89. * 删除订单项目
  90. * @return
  91. */
  92. @RequestMapping(value = "/deleteOrderTask",method = RequestMethod.POST)
  93. public Result deleteOrderTask(Integer id){
  94. Result res = new Result();
  95. if(id==null){
  96. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","项目编号"));
  97. return res;
  98. }
  99. return res.data(orderNewService.delectOrderTask(id));
  100. }
  101. /**
  102. * 删除订单
  103. * @return
  104. */
  105. @RequestMapping(value = "/deleteOrderNew",method = RequestMethod.POST)
  106. public Result deleteOrderNew(String orderNo){
  107. Result res = new Result();
  108. if(StringUtils.isBlank(orderNo)){
  109. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","订单编号"));
  110. return res;
  111. }
  112. int i=orderNewService.deleteOrderNew(orderNo);
  113. if (i==-1) {
  114. res.getError().add(buildError("订单未达删除条件","订单未达删除条件"));
  115. return res;
  116. }
  117. return res.data(i);
  118. }
  119. /**
  120. * 获取订单项目信息
  121. * @param orderNo
  122. * @return
  123. */
  124. @RequestMapping(value = "/getOrderTask",method = RequestMethod.GET)
  125. public Result getOrderTask(String orderNo){
  126. Result res = new Result();
  127. if(StringUtils.isBlank(orderNo)){
  128. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"","订单编号"));
  129. return res;
  130. }
  131. res.setData(orderNewService.selectOrderTask(orderNo));
  132. return res;
  133. }
  134. /**
  135. * 修改订单
  136. * @return
  137. */
  138. @RequestMapping(value = "/updateServiceOrderNew",method = RequestMethod.POST)
  139. public Result updateServiceOrder(TOrderNewWithBLOBs t,String isSubmit,String signDate){
  140. Result res = new Result();
  141. if(StringUtils.isBlank(t.getOrderNo())){
  142. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "订单编号"));
  143. return res;
  144. }
  145. if(null==t.getTotalAmount() || null==t.getFirstAmount()){
  146. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "订单金额 和 首付金额"));
  147. return res;
  148. }
  149. if(StringUtils.isBlank(t.getContractPictureUrl())){
  150. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "合同图片"));
  151. return res;
  152. }
  153. if(null==isSubmit){
  154. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "提交状态"));
  155. return res;
  156. }
  157. int i=Integer.valueOf(isSubmit);
  158. if (i==1) {
  159. if (orderNewService.checkORderTask(t.getOrderNo())) {
  160. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "主项目"));
  161. return res;
  162. }
  163. if (orderNewService.checkORderDun(t.getOrderNo())) {
  164. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "催款信息"));
  165. return res;
  166. }
  167. }
  168. if (StringUtils.isNotBlank(signDate)) {
  169. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
  170. try {
  171. t.setSignTime(sdf.parse(signDate));
  172. } catch (ParseException e) {
  173. e.printStackTrace();
  174. }
  175. }
  176. res.setData(orderNewService.updateServiceOrder(t,i));
  177. return res;
  178. }
  179. /**
  180. * 订单详情
  181. * @param orderNo
  182. * @return
  183. */
  184. @RequestMapping(value = "/getOrderNewDetail", method = RequestMethod.GET)
  185. public Result getOrderNewDetail(String orderNo){
  186. Result res = new Result();
  187. if(StringUtils.isBlank(orderNo)){
  188. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  189. return res;
  190. }
  191. res.setData(orderNewService.getOrderNewDetail(orderNo));
  192. return res;
  193. }
  194. /**
  195. * 收款截点编辑
  196. */
  197. @RequestMapping(value = "/createOrderDun", method = RequestMethod.POST)
  198. public Result createOrderDun(String orderDun,String orderNo){
  199. Result res = new Result();
  200. if(StringUtils.isBlank(orderNo)){
  201. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  202. return res;
  203. }
  204. res.setData(orderNewService.createOrderDun(orderDun,orderNo));
  205. return res;
  206. }
  207. /**
  208. * 查看订单收款截点
  209. */
  210. @RequestMapping(value = "/selectOrderDun", method = RequestMethod.GET)
  211. public Result selectOrderDun(String orderNo){
  212. Result res = new Result();
  213. if(StringUtils.isBlank(orderNo)){
  214. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  215. return res;
  216. }
  217. res.setData(orderNewService.selectOrderDun(orderNo));
  218. return res;
  219. }
  220. /**
  221. * 订单列表
  222. *
  223. *specially 0 个人 1 营销员管理 2 驳回 3 特批 4 咨询师管理 5部门订单查询 6客服查询 7统计签单订单 8客户订单列表 9 复审订单
  224. *distribution (咨询师管理列表 0 未分配 1部分 2全部
  225. *amountStatus 0 10万元以下 1 10万~20万 2 20万~30万 3 30万~40万 4 40万以上
  226. */
  227. @RequestMapping(value="/orderNewList", method = RequestMethod.GET)
  228. public Result orderNewList(String aid,String name,String orderNo,String starTime,String endTime ,Integer specially ,Integer approval,
  229. Integer distribution,String depId,String contractNo,Integer outsource,Integer liquidationStatus,Integer amountStatus,
  230. String contractStart,String contractEnd,String uid,Integer pageNo,Integer pageSize){
  231. Result res=new Result();
  232. res.data(orderNewService.orderNewList(aid,name, orderNo, starTime, endTime, specially ,approval, distribution,depId,
  233. contractNo,outsource, liquidationStatus,amountStatus,contractStart, contractEnd,uid,pageNo, pageSize));
  234. return res;
  235. }
  236. /**
  237. * 订单审核
  238. */
  239. @RequestMapping(value="/auditOrderNew", method = RequestMethod.POST)
  240. public Result auditOrderNew(String orderNo,Integer orderStatus,String reason){
  241. Result res=new Result();
  242. if(StringUtils.isBlank(orderNo)){
  243. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  244. return res;
  245. }
  246. if(orderStatus==null||(orderStatus!=OrderNewState.QDSHTG.getCode()&&orderStatus!=OrderNewState.QDSHJJ.getCode())||
  247. orderNewService.chekeOrderStatus(orderNo)){
  248. res.getError().add(buildError( "审核状态错误","审核状态错误"));
  249. return res;
  250. }
  251. if (orderStatus==OrderNewState.QDSHJJ.getCode()&&StringUtils.isBlank(reason)) {
  252. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"驳回原因", "驳回原因"));
  253. return res;
  254. }
  255. return res.data(orderNewService.updateOrderNew(orderNo,orderStatus,reason,0,null));
  256. }
  257. /**
  258. * 催款统计列表
  259. * @param newStatus 0旧催款 1新催款
  260. * @param specially 0查看自己 1查看别人
  261. */
  262. @RequestMapping(value="/dunOrderNewList", method = RequestMethod.GET)
  263. public Result dunOrderNewList(String name,String orderNo,String contractNo,String starTime,String endTime,Integer specially,String aid,
  264. String adminName,String depId,Integer newStatus,Integer pageNo,Integer pageSize){
  265. Result res=new Result();
  266. res.data(orderNewService.dunOrderNewList(name, orderNo,contractNo, starTime, endTime,specially,aid, adminName, depId,newStatus,pageNo, pageSize));
  267. return res;
  268. }
  269. /**
  270. * 催款统计列表
  271. */
  272. @RequestMapping(value="/arrearsDunList", method = RequestMethod.GET)
  273. public Result arrearsDunList(InputArrearsDunListBo in){
  274. Result res=new Result();
  275. res.data(orderNewService.arrearsDunList(in));
  276. return res;
  277. }
  278. /**
  279. * 新增催款记录
  280. */
  281. @RequestMapping(value="/createDunLog", method = RequestMethod.POST)
  282. public Result createDunLog(String dunId,String dumTime,String remarks){
  283. Result res=new Result();
  284. if (StringUtils.isBlank(dunId)) {
  285. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "催款ID","催款ID"));
  286. return res;
  287. }
  288. if (StringUtils.isBlank(dumTime)||StringUtils.isBlank(remarks)) {
  289. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "时间与描述","时间与描述"));
  290. return res;
  291. }
  292. res.data(orderNewService.createDunLog(dunId, dumTime, remarks));
  293. return res;
  294. }
  295. /**
  296. * 催款记录查询
  297. */
  298. @RequestMapping(value="/selectDunLogList", method = RequestMethod.GET)
  299. public Result selectDunLogList(String dunId){
  300. Result res=new Result();
  301. if (StringUtils.isBlank(dunId)) {
  302. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "催款ID","催款ID"));
  303. return res;
  304. }
  305. res.data(orderNewService.selectDunLogList(dunId));
  306. return res;
  307. }
  308. /**
  309. * 订单退单
  310. */
  311. @RequestMapping(value="/addOrderRefund", method = RequestMethod.POST)
  312. public Result addOrderRefund(TOrderRefundWithBLOBs t){
  313. Result res=new Result();
  314. if (StringUtils.isBlank(t.getOrderNo())) {
  315. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  316. return res;
  317. }
  318. if(StringUtils.isBlank(t.getContractUrl())||StringUtils.isBlank(t.getApplicationUrl())){
  319. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "合同与申请表","合同与申请表"));
  320. return res;
  321. }
  322. if (StringUtils.isBlank(t.getReason())) {
  323. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "退单原因","退单原因"));
  324. return res;
  325. }
  326. if(orderNewService.checkOderSettlementAmount(t.getOrderNo())){
  327. res.getError().add(buildError( "未达退单条件","未达退单条件"));
  328. return res;
  329. }
  330. res.data(orderNewService.addOrderRefund(t));
  331. return res;
  332. }
  333. /**
  334. * 退单详情
  335. */
  336. @RequestMapping(value="/orderRefundDetail", method = RequestMethod.GET)
  337. public Result OrderRefund(String id){
  338. Result res=new Result();
  339. if (StringUtils.isBlank(id)) {
  340. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "退单编号","退单编号"));
  341. return res;
  342. }
  343. res.data(orderNewService.orderRefundDetail(id));
  344. return res;
  345. }
  346. /**
  347. * 订单退单
  348. */
  349. @RequestMapping(value="/updateOrderRefund", method = RequestMethod.POST)
  350. public Result updateOrderRefund(TOrderRefundWithBLOBs t){
  351. Result res=new Result();
  352. if (null==t.getId()) {
  353. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "退单编号","退单编号"));
  354. return res;
  355. }
  356. if(StringUtils.isBlank(t.getContractUrl())||StringUtils.isBlank(t.getApplicationUrl())){
  357. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "合同与申请表","合同与申请表"));
  358. return res;
  359. }
  360. if (StringUtils.isBlank(t.getReason())) {
  361. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "退单原因","退单原因"));
  362. return res;
  363. }
  364. res.data(orderNewService.updateOrderRefund(t));
  365. return res;
  366. }
  367. /**
  368. * 审批特批订单
  369. * @param orderNo
  370. * @return
  371. */
  372. @RequestMapping(value = "/approvalOrder",method = RequestMethod.POST)
  373. public Result approvalOrder(String orderNo,Integer confirm,String reason){
  374. Result res = new Result();
  375. if (StringUtils.isBlank(orderNo)||confirm==null) {
  376. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号和审批","订单编号和审批"));
  377. return res;
  378. }
  379. if (confirm==ApprovalNewState.BH.getCode()&&StringUtils.isBlank(reason)) {
  380. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR,"驳回原因", "驳回原因"));
  381. return res;
  382. }
  383. if (orderNewService.chekeApprovalOrderStatus(orderNo)) {
  384. res.getError().add(buildError( "审核状态错误","审核状态错误"));
  385. return res;
  386. }
  387. return res.data(orderNewService.updateApprovalOrder(orderNo,confirm,reason));
  388. }
  389. /**
  390. * 退单列表
  391. */
  392. @RequestMapping(value="/orderRefundList", method = RequestMethod.GET)
  393. public Result orderRefundList(String name,String orderNo,String starTime,String endTime,Integer specially,Integer pageNo,Integer pageSize){
  394. Result res=new Result();
  395. res.data(orderNewService.orderRefundList(name, orderNo, starTime, endTime,specially, pageNo, pageSize));
  396. return res;
  397. }
  398. /**
  399. * 订单结单
  400. */
  401. @RequestMapping(value="/OrderOver", method = RequestMethod.GET)
  402. public Result updateOrderOver(String orderNo){
  403. Result res=new Result();
  404. if (StringUtils.isBlank(orderNo)) {
  405. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  406. return res;
  407. }
  408. int i=orderNewService.updateOrderOver(orderNo);
  409. if (i==-1) {
  410. res.getError().add(buildError("不符合结单条件","不符合结单条件"));
  411. return res;
  412. }
  413. res.setData(i);
  414. return res;
  415. }
  416. /**
  417. * 咨询师驳回订单
  418. */
  419. @RequestMapping(value = "/technicianBackOrder", method = RequestMethod.POST)
  420. public Result technicianBackOrder(String orderNo,String reason){
  421. Result res = new Result();
  422. int i=orderNewService.updatetechnicianBackOrder(orderNo, reason);
  423. if (i==-1) {
  424. res.getError().add(buildError("不符合驳回条件","不符合驳回条件"));
  425. return res;
  426. }
  427. return res;
  428. }
  429. /**
  430. * 财务订单转交
  431. */
  432. @RequestMapping(value = "/updateFinance", method= RequestMethod.GET)
  433. public Result updateFinance(String orderNo,String newFinance) {
  434. Result res = new Result();
  435. orderNewService.updateFinance( orderNo, newFinance);
  436. return res;
  437. }
  438. /**
  439. * 查看订单日志
  440. */
  441. @RequestMapping(value ="/selectOrderLog", method=RequestMethod.GET)
  442. public Result selectOrderLog (String orderNo) {
  443. Result res=new Result();
  444. if (StringUtils.isBlank(orderNo)) {
  445. res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "订单编号","订单编号"));
  446. return res;
  447. }
  448. res.data(orderNewService.selectOrderLog(orderNo));
  449. return res;
  450. }
  451. /** 退单文件上传 **/
  452. @RequestMapping(value = "/uploadRefundOrderFile", method = RequestMethod.POST)
  453. public Result uploadRefundOrderFile(HttpServletRequest req,String sign){
  454. Result res = new Result();
  455. //order_refund_file
  456. res.setData(handleFile(res, "/order_refund_file/", false, req, sign));
  457. return res;
  458. }
  459. /**
  460. * 催款列表下载
  461. * @throws IOException
  462. */
  463. @RequestMapping(value = "/exportOrderDunData", method = RequestMethod.GET)
  464. public Result exportOrderDunData(String name,String orderNo,String contractNo,String starTime,String endTime,Integer specially, String aid,String adminName,
  465. String depId,Integer newStatus,Integer pageNo,Integer pageSize,HttpServletResponse response){
  466. Result res = new Result();
  467. try {
  468. orderNewService.exportOrderDunData( name, orderNo,contractNo, starTime, endTime,specially, aid, adminName, depId,newStatus, pageNo, pageSize, response);
  469. } catch (Exception e) {
  470. res.getError().add(buildError("格式不正确"));
  471. return res;
  472. }
  473. return res;
  474. }
  475. /**
  476. * 项目列表下载
  477. * @throws IOException
  478. */
  479. @RequestMapping(value = "/exportOrderTaskData", method = RequestMethod.GET)
  480. public Result exportOrderTaskData(String orderNo,HttpServletResponse response){
  481. List<TOrderTaskBo> list=orderNewService.selectOrderTask(orderNo);
  482. NewExcelUtil<TOrderTaskBo>excel=new NewExcelUtil<>(TOrderTaskBo.class);
  483. return excel.exportExcel(list,"订单项目列表",response);
  484. }
  485. /**
  486. * 催款信息下载
  487. * @throws IOException
  488. */
  489. @RequestMapping(value = "/exportArrearsDunListData", method = RequestMethod.GET)
  490. public Result exportArrearsDunListData(InputArrearsDunListBo in,HttpServletResponse response){
  491. @SuppressWarnings("unchecked")
  492. List<OutArrearsDunListBo> list=(List<OutArrearsDunListBo>) orderNewService.arrearsDunList(in).getList();
  493. NewExcelUtil<OutArrearsDunListBo>excel=new NewExcelUtil<>(OutArrearsDunListBo.class);
  494. return excel.exportExcel(list,"欠款催款列表",response);
  495. }
  496. /**
  497. * 签单统计表
  498. * @throws IOException
  499. */
  500. @RequestMapping(value = "/statisticsList", method = RequestMethod.GET)
  501. public Result statisticsList(InputStatistics in){
  502. return res().data(orderNewService.statisticsList(in));
  503. }
  504. /**
  505. * 签单统计表
  506. * @throws IOException
  507. */
  508. @RequestMapping(value = "/statisticsListExprot", method = RequestMethod.GET)
  509. public Result statisticsListExprot(InputStatistics in){
  510. List<outStatisticsList> list =orderNewService.statisticsList(in);
  511. NewExcelUtil<outStatisticsList> excelUtil=new NewExcelUtil<>(outStatisticsList.class);
  512. StringBuffer sb=new StringBuffer("搜索条件=》");
  513. if (in.getDepName()!=null)sb=sb.append("部门:").append(in.getDepName()).append(",");
  514. if(in.getProvinceName()!=null)sb=sb.append("省份:").append(in.getProvinceName()).append(",");
  515. if(in.getSort()!=null){
  516. sb=sb.append("排序:");
  517. if (in.getSort()==0)sb=sb.append("按签单额");
  518. else if (in.getSort()==1)sb=sb.append("按签单总量");
  519. else if (in.getSort()==2)sb=sb.append("按签单人数");
  520. sb=sb.append(",");
  521. }
  522. if (in.getStartCreate()!=null&&in.getEndCreate()!=null){
  523. sb=sb.append("下单时间:").append(in.getStartCreate()).append("~").append(in.getEndCreate()).append(",");
  524. }
  525. if (in.getStartSign()!=null&&in.getEndSign()!=null){
  526. sb=sb.append("合同时间:").append(in.getStartSign()).append("~").append(in.getEndSign()).append(",");
  527. }
  528. return excelUtil.exportExcel(list,"签单统计表",uploadPath,sb.substring(0,sb.toString().length()-1));
  529. }
  530. /**
  531. * 省份签单统计表
  532. * @throws IOException
  533. */
  534. @RequestMapping(value = "/provinceStatisticsList", method = RequestMethod.GET)
  535. public Result provinceStatisticsList(InputStatistics in){
  536. return res().data(orderNewService.provinceStatisticsList(in));
  537. }
  538. /**
  539. * 签单统计表
  540. * @throws IOException
  541. */
  542. @RequestMapping(value = "/provinceStatisticsListExprot", method = RequestMethod.GET)
  543. public Result provinceStatisticsListExprot(InputStatistics in){
  544. List<outProvinceStatisticsList> list =orderNewService.provinceStatisticsList(in);
  545. NewExcelUtil<outProvinceStatisticsList> excelUtil=new NewExcelUtil<>(outProvinceStatisticsList.class);
  546. StringBuffer sb=new StringBuffer("搜索条件=》");
  547. if (in.getDepName()!=null)sb=sb.append("部门:").append(in.getDepName()).append(",");
  548. if(in.getProvinceName()!=null)sb=sb.append("省份:").append(in.getProvinceName()).append(",");
  549. if(in.getSort()!=null){
  550. sb=sb.append("排序:");
  551. if (in.getSort()==0)sb=sb.append("按签单额");
  552. else if (in.getSort()==1)sb=sb.append("按签单总量");
  553. else if (in.getSort()==2)sb=sb.append("按签单人数");
  554. sb=sb.append(",");
  555. }
  556. if (in.getStartCreate()!=null&&in.getEndCreate()!=null){
  557. sb=sb.append("下单时间:").append(in.getStartCreate()).append("~").append(in.getEndCreate()).append(",");
  558. }
  559. if (in.getStartSign()!=null&&in.getEndSign()!=null){
  560. sb=sb.append("合同时间:").append(in.getStartSign()).append("~").append(in.getEndSign()).append(",");
  561. }
  562. return excelUtil.exportExcel(list,"签单省份统计表",uploadPath,sb.substring(0,sb.toString().length()-1));
  563. }
  564. }