OrderReceivablesServiceImpl.java 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589
  1. package com.goafanti.order.service.impl;
  2. import java.math.BigDecimal;
  3. import java.util.ArrayList;
  4. import java.util.Date;
  5. import java.util.HashMap;
  6. import java.util.List;
  7. import java.util.Map;
  8. import java.util.UUID;
  9. import javax.annotation.Resource;
  10. import org.apache.commons.lang3.StringUtils;
  11. import org.apache.poi.ss.usermodel.Cell;
  12. import org.apache.poi.ss.usermodel.Row;
  13. import org.apache.poi.ss.usermodel.Sheet;
  14. import org.apache.poi.ss.usermodel.Workbook;
  15. import org.apache.poi.ss.util.CellRangeAddress;
  16. import org.apache.poi.xssf.usermodel.XSSFCell;
  17. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
  18. import org.apache.poi.xssf.usermodel.XSSFRow;
  19. import org.apache.poi.xssf.usermodel.XSSFSheet;
  20. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  21. import org.springframework.beans.factory.annotation.Autowired;
  22. import org.springframework.stereotype.Service;
  23. import org.springframework.web.multipart.MultipartFile;
  24. import com.goafanti.common.bo.Error;
  25. import com.goafanti.common.constant.AFTConstants;
  26. import com.goafanti.common.dao.TOrderBillNewMapper;
  27. import com.goafanti.common.dao.TOrderBonusMapper;
  28. import com.goafanti.common.dao.TOrderLogMapper;
  29. import com.goafanti.common.dao.TOrderMidMapper;
  30. import com.goafanti.common.dao.TOrderNewMapper;
  31. import com.goafanti.common.dao.TOrderTaskMapper;
  32. import com.goafanti.common.dao.TemporaryReceivablesMapper;
  33. import com.goafanti.common.enums.OrderLogProcess;
  34. import com.goafanti.common.error.BusinessException;
  35. import com.goafanti.common.model.TOrderBillNew;
  36. import com.goafanti.common.model.TOrderBonus;
  37. import com.goafanti.common.model.TOrderLog;
  38. import com.goafanti.common.model.TOrderNew;
  39. import com.goafanti.common.model.TOrderTask;
  40. import com.goafanti.common.model.TemporaryReceivables;
  41. import com.goafanti.common.utils.DateUtils;
  42. import com.goafanti.common.utils.ExcelUtils;
  43. import com.goafanti.common.utils.ExportExcelUtil;
  44. import com.goafanti.common.utils.LoggerUtils;
  45. import com.goafanti.core.mybatis.BaseMybatisDao;
  46. import com.goafanti.core.mybatis.page.Pagination;
  47. import com.goafanti.core.shiro.token.TokenManager;
  48. import com.goafanti.order.bo.OrderListBo;
  49. import com.goafanti.order.bo.ReceivablesListBo;
  50. import com.goafanti.order.bo.TOrderInvoiceBo;
  51. import com.goafanti.order.bo.TOrderNewBo;
  52. import com.goafanti.order.bo.TemporaryReceivablesBo;
  53. import com.goafanti.order.enums.ApprovalNewState;
  54. import com.goafanti.order.enums.BonusSubject;
  55. import com.goafanti.order.enums.LiquidationNewState;
  56. import com.goafanti.order.enums.ProcessStatus;
  57. import com.goafanti.order.enums.ReceivablesStatus;
  58. import com.goafanti.order.enums.TransactionSubject;
  59. import com.goafanti.order.service.FundManageOrderService;
  60. import com.goafanti.order.service.OrderBillService;
  61. import com.goafanti.order.service.OrderInvoiceService;
  62. import com.goafanti.order.service.OrderReceivablesService;
  63. @Service
  64. public class OrderReceivablesServiceImpl extends BaseMybatisDao<TemporaryReceivablesMapper> implements OrderReceivablesService{
  65. @Autowired
  66. private TemporaryReceivablesMapper temporaryReceivablesMapper;
  67. @Autowired
  68. private TOrderBillNewMapper tOrderBillNewMapper;
  69. @Autowired
  70. private TOrderNewMapper tOrderNewMapper;
  71. @Autowired
  72. private TOrderBonusMapper tOrderBonusMapper;
  73. @Autowired
  74. private TOrderLogMapper tOrderLogMapper;
  75. @Autowired
  76. private TOrderTaskMapper tOrderTaskMapper;
  77. @Autowired
  78. private TOrderMidMapper tOrderMidMapper;
  79. @Resource
  80. private FundManageOrderService fundManageOrderService;
  81. @Resource
  82. private OrderInvoiceService orderInvoiceService;
  83. @Resource
  84. private OrderBillService orderBillService;
  85. @Override
  86. public int addReceivables(TemporaryReceivablesBo t) {
  87. t.setAid(TokenManager.getAdminId());
  88. if(t.getCorporateName()==null)t.setCorporateName("");
  89. t.setCreateTime(new Date());
  90. t.setStatus(0);
  91. if(t.getReceivablesTimes()!=null) t.setReceivablesTime(DateUtils.StringToDate(t.getReceivablesTimes(), AFTConstants.YYYYMMDD));
  92. return temporaryReceivablesMapper.insertSelective(t);
  93. }
  94. @Override
  95. public int updateReceivables(TemporaryReceivablesBo t) {
  96. t.setOrderNo(t.getOrderNo().trim());
  97. t.setStatus(ReceivablesStatus.ZC.getCode());
  98. if(t.getReceivablesTimes()!=null) {
  99. t.setReceivablesTime(DateUtils.StringToDate(t.getReceivablesTimes(), AFTConstants.YYYYMMDD));
  100. }
  101. return temporaryReceivablesMapper.updateByPrimaryKeySelective(t);
  102. }
  103. @Override
  104. public int deleteReceivables(String ids) {
  105. List<String> delList = new ArrayList<String>();
  106. String[] strs = ids.split(",");
  107. for (String str : strs) {
  108. delList.add(str);
  109. }
  110. return temporaryReceivablesMapper.deleteByids(delList);
  111. }
  112. @Override
  113. public int deleteAllReceivables() {
  114. return temporaryReceivablesMapper.deleteByaid(TokenManager.getAdminId());
  115. }
  116. @SuppressWarnings("deprecation")
  117. @Override
  118. public int batchImport() {
  119. List<TemporaryReceivables> list=temporaryReceivablesMapper.selectByaid(TokenManager.getAdminId());
  120. if(list.size()>99)throw new BusinessException(new Error("数量过大,建议不超过99。"));
  121. List<TOrderBillNew> listBull=new ArrayList<>();
  122. for (TemporaryReceivables tr : list) {
  123. TOrderBillNew tbn=new TOrderBillNew();
  124. //获取已收款
  125. BigDecimal bill = tOrderBillNewMapper.getAmountByOid(tr.getOrderNo());
  126. //获取总金额
  127. TOrderNewBo t=tOrderNewMapper.getOrderNewDetail(tr.getOrderNo());
  128. //订单匹配不到
  129. if(t==null||t.getOrderNo()==null) {
  130. tr.setStatus(ReceivablesStatus.DDYC.getCode());
  131. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  132. continue;
  133. }else if(t.getDeleteSign()==2||t.getDeleteSign()==3) {
  134. tr.setStatus(ReceivablesStatus.BGSD.getCode());
  135. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  136. continue;
  137. }else if(!tr.getCorporateName().equals(t.getUserName())) {
  138. tr.setStatus(ReceivablesStatus.MCYC.getCode());
  139. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  140. continue;
  141. }else if(temporaryReceivablesMapper.selectReceivablesNumberRepeats(tr)>0) {
  142. tr.setStatus(ReceivablesStatus.YSK.getCode());
  143. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  144. continue;
  145. }
  146. //计算收款结果
  147. BigDecimal bd = bill.add(tr.getAmount());
  148. //判断表中数据
  149. BigDecimal count = new BigDecimal(0).add(bd);
  150. for (TOrderBillNew tBill : listBull) {
  151. if (tBill.getOrderNo().equals(tr.getOrderNo())) {
  152. count=count.add(tBill.getTransactionAmount());
  153. continue;
  154. }
  155. }
  156. TOrderBonus bonus = new TOrderBonus();
  157. bonus.setId(UUID.randomUUID().toString());
  158. bonus.setOrderNo(tr.getOrderNo());
  159. bonus.setGrantBy(TokenManager.getAdminId());
  160. int lstaus = 0;//如果订单流水小于首付 lstaus 0
  161. if(count.compareTo(t.getTotalAmount()) == 1){//如果订单流水总额大于总金额 return -1
  162. tr.setStatus(ReceivablesStatus.JEYC.getCode());
  163. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  164. continue;
  165. }else if (count.compareTo(t.getTotalAmount()) == 0) {//等于总额
  166. //付完款//如果订单流水等于于总金额 lstaus 2
  167. lstaus = 2;
  168. bonus.setBonusSubject(BonusSubject.WK.getCode());//12
  169. //发放给技术员如果付完款所有参与这个项目任务的人都会有结算奖
  170. //获得所有的任务负责人
  171. List<TOrderTask> l = tOrderTaskMapper.getReceiverByOid(tr.getOrderNo());
  172. for (TOrderTask tOrderTask : l) {
  173. if(null != tOrderTask &&null != tOrderTask.getTaskReceiver()){
  174. bonus.setTaskId(tOrderTask.getId());//任务id
  175. bonus.setGrantTarget(tOrderTask.getTaskReceiver());
  176. bonus.setGrantType(1);
  177. int c = tOrderBonusMapper.checkByOnoAndSub(bonus);
  178. //不存在就设置
  179. if(c==0){
  180. bonus.setId(UUID.randomUUID().toString());
  181. tOrderBonusMapper.insertSelective(bonus);
  182. }
  183. }
  184. }
  185. if(tr.getStatus()==2) {
  186. tr.setStatus(0);
  187. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  188. }
  189. addOrderLog(tr.getOrderNo(), OrderLogProcess.CWQK.getCode());
  190. }else if (count.compareTo(t.getTotalAmount()) == -1) {//小于总额
  191. //如果订单流水小于总金额
  192. if(bd.compareTo(t.getFirstAmount()) == 0 || bd.compareTo(t.getFirstAmount()) == 1){//首付完成
  193. //查看首付奖是否存在
  194. TOrderBonus b = new TOrderBonus();
  195. b.setOrderNo(tr.getOrderNo());
  196. b.setBonusSubject(11);
  197. b.setGrantType(0);
  198. b.setGrantTarget(t.getSalesmanId());
  199. int c = tOrderBonusMapper.checkByOnoAndSub(b);
  200. //不存在就设置
  201. if(c==0){
  202. bonus.setBonusSubject(BonusSubject.SF.getCode());//11
  203. }
  204. lstaus = 1;
  205. addOrderLog(tr.getOrderNo(), OrderLogProcess.CWSF.getCode());
  206. }
  207. }
  208. if(tr.getStatus()==2) {
  209. tr.setStatus(0);
  210. temporaryReceivablesMapper.updateByPrimaryKeySelective(tr);
  211. }
  212. //否则新增流水信息
  213. Date date=new Date();
  214. tbn.setBillNo(UUID.randomUUID().toString().replaceAll("-", ""));
  215. tbn.setCreater(TokenManager.getAdminId());
  216. tbn.setType(1);//批量
  217. tbn.setOrderNo(t.getOrderNo());
  218. tbn.setCreateTime(date);
  219. tbn.setPayeeId("0");//默认设置0
  220. tbn.setPayerId(t.getBuyerId());
  221. tbn.setTransactionSubject(0);
  222. tbn.setTransactionChannel(2);
  223. tbn.setConfirmSign(0);
  224. tbn.setTransactionAmount(tr.getAmount());
  225. tbn.setDeleteSign((new Byte("0")));
  226. tbn.setFinancialPayTime(tr.getReceivablesTime());
  227. tbn.setFinancialPayNo(tr.getFinancialPayNo());
  228. tbn.setRemarks(tr.getRemarks());
  229. tOrderMidMapper.updatefinalReceivables(t.getOrderNo(),tr.getAmount(),date);
  230. //修改订单结算金额和结算状态
  231. //如果已经首付并且流程状态是没有派给咨询师的修改流程状态为4
  232. TOrderNew orderNew = new TOrderNew();
  233. orderNew.setOrderNo(tr.getOrderNo());
  234. //这里的已收金额是以前收的所有金额加上本次收的金额
  235. orderNew.setSettlementAmount(count);
  236. orderNew.setLiquidationStatus(lstaus);
  237. tOrderNewMapper.updateByPrimaryKeySelective(orderNew);
  238. //如果达到奖金发放要求新增奖金信息
  239. if(null != bonus.getBonusSubject()){
  240. bonus.setId(UUID.randomUUID().toString());
  241. bonus.setGrantTarget(t.getSalesmanId());
  242. //设置发放人类型
  243. bonus.setGrantType(0);
  244. tOrderBonusMapper.insertSelective(bonus);
  245. }
  246. listBull.add(tbn);
  247. }
  248. if(!listBull.isEmpty()) {
  249. tOrderBillNewMapper.insertBatch(listBull);
  250. temporaryReceivablesMapper.deleteNormalByaid(TokenManager.getAdminId());
  251. }else {
  252. return -1;
  253. }
  254. LoggerUtils.debug(getClass(), "=========================批量导入结束===================");
  255. return 1;
  256. }
  257. private void addOrderLog(String orderNo, Integer code) {
  258. TOrderLog tl=new TOrderLog();
  259. tl.setOrderNo(orderNo);
  260. tl.setProcess(code);
  261. tl.setAid(TokenManager.getAdminId());
  262. tOrderLogMapper.insertSelective(tl);
  263. }
  264. @SuppressWarnings("unchecked")
  265. @Override
  266. public Pagination<ReceivablesListBo> listReceivables(ReceivablesListBo rl,Integer status,String adminName, String adminDepId, String orderDepId, Integer pageSize,
  267. Integer pageNo) {
  268. Map<String,Object> parameter=new HashMap<String, Object>();
  269. if(pageSize==null||pageSize<1)pageSize=10;
  270. if(pageNo==null||pageNo<1)pageNo=1;
  271. if(StringUtils.isNotBlank(rl.getContractNo()))parameter.put("contractNo", rl.getContractNo());
  272. if(StringUtils.isNotBlank(rl.getOrderNo()))parameter.put("orderNo", rl.getOrderNo());
  273. if(StringUtils.isNotBlank(rl.getNickname()))parameter.put("nickname", rl.getNickname());
  274. if(StringUtils.isNotBlank(rl.getCorporateName()))parameter.put("corporateName", rl.getCorporateName());
  275. if(StringUtils.isNotBlank(adminName))parameter.put("adminName", adminName);
  276. if(StringUtils.isNotBlank(adminDepId))parameter.put("adminDepId", adminDepId);
  277. if(StringUtils.isNotBlank(orderDepId))parameter.put("orderDepId", orderDepId);
  278. if(null!=status)parameter.put("status", status);
  279. if(StringUtils.isNotBlank(TokenManager.getAdminId()))parameter.put("aid", TokenManager.getAdminId());
  280. Pagination<ReceivablesListBo> p=(Pagination<ReceivablesListBo>) findPage("selectReceivablesList", "selectReceivablesCount", parameter, pageNo, pageSize);
  281. List<ReceivablesListBo> list=(List<ReceivablesListBo>) p.getList();
  282. for (ReceivablesListBo r : list) {
  283. //设置导入信息数据是否有问题判断
  284. // InptStatus 0 正常 1内容不完整 2订单未能匹配 3名称不匹配
  285. if (r.getAmount()==null||StringUtils.isBlank(r.getOrderNo())
  286. ||StringUtils.isBlank(r.getCorporateName())||r.getReceivablesTimes()==null) {
  287. r.setInptStatus(1);
  288. }else if(r.getTotalAmount()==null) {
  289. r.setInptStatus(2);
  290. }else if(!r.getCorporateName().equals(r.getNickname())) {
  291. r.setInptStatus(3);
  292. }else {
  293. r.setInptStatus(0);
  294. }
  295. }
  296. return p;
  297. }
  298. @Override
  299. public Map<String, Object> getCountlistReceivables(ReceivablesListBo rl, Integer status, String adminName,
  300. String adminDepId, String orderDepId) {
  301. Map<String,Object> parameter=new HashMap<String, Object>();
  302. if(StringUtils.isNotBlank(rl.getContractNo()))parameter.put("contractNo", rl.getContractNo());
  303. if(StringUtils.isNotBlank(rl.getOrderNo()))parameter.put("orderNo", rl.getOrderNo());
  304. if(StringUtils.isNotBlank(rl.getNickname()))parameter.put("nickname", rl.getNickname());
  305. if(StringUtils.isNotBlank(rl.getCorporateName()))parameter.put("corporateName", rl.getCorporateName());
  306. if(StringUtils.isNotBlank(adminName))parameter.put("adminName", adminName);
  307. if(StringUtils.isNotBlank(adminDepId))parameter.put("adminDepId", adminDepId);
  308. if(StringUtils.isNotBlank(orderDepId))parameter.put("orderDepId", orderDepId);
  309. if(null!=status)parameter.put("status", status);
  310. if(StringUtils.isNotBlank(TokenManager.getAdminId()))parameter.put("aid", TokenManager.getAdminId());
  311. //计算回收表的订单总金额与当前总收款额。
  312. Map<String,Object> map=new HashMap<String, Object>();
  313. map.put("totalAmount", new BigDecimal(temporaryReceivablesMapper.getCountlistReceivablesTotalAmount(parameter)).stripTrailingZeros() );
  314. map.put("amount",new BigDecimal(temporaryReceivablesMapper.getCountlistReceivablesAmount(parameter)).stripTrailingZeros() );
  315. return map;
  316. }
  317. @SuppressWarnings("deprecation")
  318. @Override
  319. public void batchListReceivables(MultipartFile file) {
  320. //获得Workbook工作薄对象
  321. Workbook workbook = ExcelUtils.getWorkBook(file);
  322. //创建一个对象,用来存储数据
  323. List<TemporaryReceivablesBo> list=new ArrayList<>();
  324. if(workbook != null){
  325. //获得当前sheet工作表
  326. Sheet sheet = workbook.getSheetAt(0);
  327. if(sheet == null){
  328. return;
  329. }
  330. //获得当前sheet的开始行
  331. int firstRowNum = sheet.getFirstRowNum();
  332. //获得当前sheet的结束行
  333. int lastRowNum = sheet.getLastRowNum();
  334. //处理空白行
  335. for (int i = firstRowNum; i <= sheet.getLastRowNum();i++) {
  336. Row r = sheet.getRow(i);
  337. if(r == null){
  338. // 如果是空行(即没有任何数据、格式),直接把它以下的数据往上移动
  339. sheet.shiftRows(i+1, sheet.getLastRowNum(),-1);
  340. continue;
  341. }
  342. boolean flag = false;
  343. for(Cell c:r){
  344. if(c.getCellType() != Cell.CELL_TYPE_BLANK){
  345. flag = true;
  346. break;
  347. }
  348. }
  349. if(flag){
  350. i++;
  351. continue;
  352. } else{//如果是空白行(即可能没有数据,但是有一定格式)
  353. if(i == sheet.getLastRowNum())//如果到了最后一行,直接将那一行remove掉
  354. sheet.removeRow(r);
  355. else//如果还没到最后一行,则数据往上移一行
  356. sheet.shiftRows(i+1, sheet.getLastRowNum(),-1);
  357. }
  358. }
  359. lastRowNum=sheet.getLastRowNum();
  360. if (lastRowNum<2) {
  361. throw new BusinessException(new Error("未找到正确的参数。"));
  362. }
  363. //循环除了第2行的所有行
  364. for(int rowNum = firstRowNum+2;rowNum <= lastRowNum;rowNum++){
  365. //获得当前行
  366. Row row = sheet.getRow(rowNum);
  367. if(row == null){
  368. continue;
  369. }
  370. //获得当前行的开始列
  371. int firstCellNum = row.getFirstCellNum();
  372. //获得当前行的列数
  373. int lastCellNum = row.getLastCellNum();
  374. //循环当前行 cellNum = (firstCellNum+1) 则是除开第一例
  375. TemporaryReceivablesBo trb=new TemporaryReceivablesBo();
  376. for(int cellNum = (firstCellNum); cellNum < lastCellNum;cellNum++){
  377. Cell cell = row.getCell(cellNum);
  378. try {
  379. switch (cellNum) {
  380. case 0:
  381. trb.setFinancialPayNo(ExcelUtils.getCellValue(cell));
  382. break;
  383. case 1:
  384. trb.setOrderNo(ExcelUtils.getCellValue(cell).trim());
  385. break;
  386. case 2:
  387. trb.setCorporateName(ExcelUtils.getCellValue(cell));
  388. break;
  389. case 3:
  390. trb.setAmount(new BigDecimal((ExcelUtils.getCellValue(cell).equals("")?"0":ExcelUtils.getCellValue(cell))));
  391. break;
  392. case 4:
  393. trb.setReceivablesTime(DateUtils.StringToDate(ExcelUtils.getCellValue(cell), AFTConstants.YYYYMMDD));
  394. break;
  395. case 5:
  396. trb.setRemarks(ExcelUtils.getCellValue(cell));
  397. break;
  398. }
  399. } catch (Exception e) {
  400. throw new BusinessException(new Error("表格第"+(rowNum+1)+"行输入内容不正确。"));
  401. }
  402. }
  403. trb.setAid(TokenManager.getAdminId());
  404. trb.setCreateTime(new Date());
  405. trb.setStatus(0);
  406. list.add(trb);
  407. }
  408. }
  409. temporaryReceivablesMapper.insertBatch(list);
  410. //计算重复的单
  411. temporaryReceivablesMapper.updateRepeatOrderNo(TokenManager.getAdminId());
  412. }
  413. /**
  414. *
  415. * @param comment
  416. * @param fileName
  417. * @param list
  418. * @param type 0收款 1开票 2流水
  419. * @return
  420. */
  421. public static XSSFWorkbook exportTemplateInfoS(String[] comment,String fileName,List<?> list,Integer type){
  422. //map 数据 ,comment表头 (列名称)
  423. //1,创建一个workbook,对应的是一个excel文件
  424. XSSFWorkbook wb = new XSSFWorkbook();
  425. //遍历map
  426. XSSFSheet sheet = wb.createSheet(fileName);
  427. //3。创建一个row
  428. XSSFRow row = sheet.createRow(0);
  429. //4.创建一个cell
  430. XSSFCell cell = row.createCell(0);
  431. cell.setCellValue(fileName+"列表");
  432. XSSFCellStyle style1 = ExportExcelUtil.setCellStyle1(wb);//标题
  433. XSSFCellStyle style2 = ExportExcelUtil.setCellStyle2(wb);//正文
  434. cell.setCellStyle(style1);
  435. //合并列
  436. sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, comment.length-1));//合并单元格
  437. //设置其他单位格式
  438. //创建表头
  439. XSSFRow row2 = sheet.createRow(1);
  440. for(int i = 0; i < comment.length; i++){
  441. sheet.setColumnWidth(i, 3000);//设置列宽
  442. XSSFCell c = row2.createCell(i);
  443. c.setCellValue(comment[i]);
  444. c.setCellStyle(style2);
  445. }
  446. switch (type) {
  447. case 0:
  448. addSettlementReceivablesList(comment, list, sheet);
  449. break;
  450. case 1:
  451. addSettlementInvoiceList(comment, list, sheet);
  452. break;
  453. case 2:
  454. addSettlementMyBillList(comment, list, sheet);
  455. break;
  456. }
  457. return wb;
  458. }
  459. @SuppressWarnings("unchecked")
  460. private static void addSettlementMyBillList(String[] comment, List<?> list, XSSFSheet sheet) {
  461. for (TOrderBillNew ob : (List<TOrderBillNew>)list) {
  462. //新增一行
  463. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  464. for (int i = 0; i < comment.length; i++) {
  465. //当前列的只
  466. String o = "";
  467. switch (comment[i]) {
  468. // String[] comment = {"订单编号","合同编号","收款时间","财务流水时间","财务流水号","金额(万元)","收款方","付款方","流水科目","平台流水号","收款类型","备注"};
  469. case "订单编号": o = ob.getOrderNo(); break;
  470. case "合同编号": o = ob.getContractNo(); break;
  471. case "收款时间": o = ob.getCreateTimes(); break;
  472. case "财务流水时间": o = ob.getFinancialPayTimes(); break;
  473. case "财务流水号": o = ob.getFinancialPayNo(); break;
  474. case "金额(万元)": o = ob.getTransactionAmount().toString(); break;
  475. case "收款方": o = ob.getPayeeName(); break;
  476. case "付款方": o = ob.getPayerName(); break;
  477. case "流水科目": o = TransactionSubject.getValueByCode(ob.getTransactionSubject()); break;
  478. case "平台流水号": o = ob.getBillNo(); break;
  479. case "收款类型":
  480. if(ob.getType()==0) {
  481. o = "手工收款"; break;
  482. }else if(ob.getType()==1) {
  483. o = "批量收款"; break;
  484. }
  485. case "备注": o = ob.getRemarks(); break;
  486. default: o = ""; break;
  487. }
  488. XSSFCell c = r.createCell(i);
  489. c.setCellValue(o);
  490. }
  491. }
  492. }
  493. @SuppressWarnings("unchecked")
  494. private static void addSettlementInvoiceList(String[] comment, List<?> list, XSSFSheet sheet) {
  495. for (TOrderInvoiceBo ob : (List<TOrderInvoiceBo>)list) {
  496. //新增一行
  497. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  498. for (int i = 0; i < comment.length; i++) {
  499. //当前列的只
  500. String o = "";
  501. switch (comment[i]) {
  502. // String[] comment = {"编号","订单编号","开票金额(万元)","申请时间","开票状态"};
  503. case "编号": o = ob.getId().toString(); break;
  504. case "订单编号": o = ob.getOrderno(); break;
  505. case "开票金额(万元)": o = ob.getAmount().toString(); break;
  506. case "申请时间": o = ob.getCreateTime(); break;
  507. case "开票状态":
  508. // 状态 0未提交 1处理中 2通过 3拒绝 4 撤销
  509. switch(ob.getStatus()) {
  510. case 1 :o = "处理中"; break;
  511. case 2 :o = "通过"; break;
  512. }
  513. break;
  514. default: o = ""; break;
  515. }
  516. XSSFCell c = r.createCell(i);
  517. c.setCellValue(o);
  518. }
  519. }
  520. }
  521. @SuppressWarnings("unchecked")
  522. private static void addSettlementReceivablesList(String[] comment, List<?> list, XSSFSheet sheet) {
  523. for (OrderListBo ob : (List<OrderListBo>)list) {
  524. //新增一行
  525. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  526. for (int i = 0; i < comment.length; i++) {
  527. //当前列的只
  528. String o = "";
  529. switch (comment[i]) {
  530. // "订单编号", "合同编号","客户名称","订单部门","订单负责人","签单日期","下单日期",
  531. // "签单金额(万元)", "已开票金额(万元)", "已收金额(万元)","最近收款(万元)","结算状态","订单流程","是否特批"}
  532. case "订单编号": o = ob.getOrderNo().toString(); break;
  533. case "合同编号": o = ob.getContractNo(); break;
  534. case "客户名称": o = ob.getBuyerName(); break;
  535. case "订单部门": o = ob.getDepartmentName(); break;
  536. case "订单负责人": o = ob.getSellerName(); break;
  537. case "签单日期": o = ob.getSignTime(); break;
  538. case "下单日期": o = ob.getCreateTime(); break;
  539. case "签单金额(万元)":o=ob.getSignTotalAmount().toString();break;
  540. case "已开票金额(万元)":o=ob.getInvoiceAmount().toString();break;
  541. case "已收金额(万元)":o=ob.getActuallyTotalAmount().toString();break;
  542. case "总成本(万元)":o=ob.getCostAmount().toString();break;
  543. case "已付成本(万元)":o=ob.getPaymentAmount().toString();break;
  544. case "最近收款(万元)":o=ob.getFinalReceivables().toString();break;
  545. case "最近收款时间":o=ob.getFinalReceivablesTime();break;
  546. case "结算状态":o=LiquidationNewState.getValueByCode(ob.getLiquidationStatus());break;
  547. case "订单流程":o=ProcessStatus.getValueByCode(ob.getProcessStatus());break;
  548. case "是否特批":o=ApprovalNewState.getValueByCode(ob.getApproval());break;
  549. default: o = ""; break;
  550. }
  551. XSSFCell c = r.createCell(i);
  552. c.setCellValue(o);
  553. }
  554. }
  555. }
  556. }