AdminNewOrderApiController.java 26 KB

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