OrderReceivablesServiceImpl.java 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587
  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 com.goafanti.admin.service.DepartmentService;
  11. import com.goafanti.order.bo.*;
  12. import org.apache.commons.lang3.StringUtils;
  13. import org.apache.poi.ss.usermodel.Cell;
  14. import org.apache.poi.ss.usermodel.CellType;
  15. import org.apache.poi.ss.usermodel.Row;
  16. import org.apache.poi.ss.usermodel.Sheet;
  17. import org.apache.poi.ss.usermodel.Workbook;
  18. import org.apache.poi.ss.util.CellRangeAddress;
  19. import org.apache.poi.xssf.usermodel.XSSFCell;
  20. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
  21. import org.apache.poi.xssf.usermodel.XSSFRow;
  22. import org.apache.poi.xssf.usermodel.XSSFSheet;
  23. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  24. import org.springframework.beans.factory.annotation.Autowired;
  25. import org.springframework.stereotype.Service;
  26. import org.springframework.web.multipart.MultipartFile;
  27. import com.goafanti.common.bo.Error;
  28. import com.goafanti.common.constant.AFTConstants;
  29. import com.goafanti.common.dao.TOrderBillNewMapper;
  30. import com.goafanti.common.dao.TOrderBonusMapper;
  31. import com.goafanti.common.dao.TOrderLogMapper;
  32. import com.goafanti.common.dao.TOrderMidMapper;
  33. import com.goafanti.common.dao.TOrderNewMapper;
  34. import com.goafanti.common.dao.TOrderTaskMapper;
  35. import com.goafanti.common.dao.TemporaryReceivablesMapper;
  36. import com.goafanti.common.enums.OrderLogProcess;
  37. import com.goafanti.common.error.BusinessException;
  38. import com.goafanti.common.model.TOrderBillNew;
  39. import com.goafanti.common.model.TOrderBonus;
  40. import com.goafanti.common.model.TOrderLog;
  41. import com.goafanti.common.model.TOrderNew;
  42. import com.goafanti.common.model.TOrderTask;
  43. import com.goafanti.common.model.TemporaryReceivables;
  44. import com.goafanti.common.utils.DateUtils;
  45. import com.goafanti.common.utils.ExcelUtils;
  46. import com.goafanti.common.utils.ExportExcelUtil;
  47. import com.goafanti.common.utils.LoggerUtils;
  48. import com.goafanti.core.mybatis.BaseMybatisDao;
  49. import com.goafanti.core.mybatis.page.Pagination;
  50. import com.goafanti.core.shiro.token.TokenManager;
  51. import com.goafanti.order.enums.ApprovalNewState;
  52. import com.goafanti.order.enums.BonusSubject;
  53. import com.goafanti.order.enums.LiquidationNewState;
  54. import com.goafanti.order.enums.ProcessStatus;
  55. import com.goafanti.order.enums.ReceivablesStatus;
  56. import com.goafanti.order.enums.TransactionSubject;
  57. import com.goafanti.order.service.FundManageOrderService;
  58. import com.goafanti.order.service.OrderBillService;
  59. import com.goafanti.order.service.OrderInvoiceService;
  60. import com.goafanti.order.service.OrderReceivablesService;
  61. @Service
  62. public class OrderReceivablesServiceImpl extends BaseMybatisDao<TemporaryReceivablesMapper> implements OrderReceivablesService{
  63. @Autowired
  64. private TemporaryReceivablesMapper temporaryReceivablesMapper;
  65. @Autowired
  66. private TOrderBillNewMapper tOrderBillNewMapper;
  67. @Autowired
  68. private TOrderNewMapper tOrderNewMapper;
  69. @Autowired
  70. private TOrderBonusMapper tOrderBonusMapper;
  71. @Autowired
  72. private TOrderLogMapper tOrderLogMapper;
  73. @Autowired
  74. private TOrderTaskMapper tOrderTaskMapper;
  75. @Autowired
  76. private TOrderMidMapper tOrderMidMapper;
  77. @Resource
  78. private FundManageOrderService fundManageOrderService;
  79. @Resource
  80. private OrderInvoiceService orderInvoiceService;
  81. @Resource
  82. private OrderBillService orderBillService;
  83. @Autowired
  84. private DepartmentService departmentService;
  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<TOrderTaskBo> l = tOrderTaskMapper.getReceiverByOid(tr.getOrderNo());
  172. for (TOrderTaskBo 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(),count,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 adminDeps, String orderDeps, 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. addParemeter(rl, status, adminName, adminDeps, orderDeps, parameter);
  272. Pagination<ReceivablesListBo> p=(Pagination<ReceivablesListBo>) findPage("selectReceivablesList", "selectReceivablesCount", parameter, pageNo, pageSize);
  273. List<ReceivablesListBo> list=(List<ReceivablesListBo>) p.getList();
  274. for (ReceivablesListBo r : list) {
  275. //设置导入信息数据是否有问题判断
  276. // InptStatus 0 正常 1内容不完整 2订单未能匹配 3名称不匹配
  277. if (r.getAmount()==null||StringUtils.isBlank(r.getOrderNo())
  278. ||StringUtils.isBlank(r.getCorporateName())||r.getReceivablesTimes()==null) {
  279. r.setInptStatus(1);
  280. }else if(r.getTotalAmount()==null) {
  281. r.setInptStatus(2);
  282. }else if(!r.getCorporateName().equals(r.getUsername())) {
  283. r.setInptStatus(3);
  284. }else {
  285. r.setInptStatus(0);
  286. }
  287. }
  288. return p;
  289. }
  290. private void addParemeter(ReceivablesListBo rl, Integer status, String adminName, String adminDeps, String orderDeps, Map<String, Object> parameter) {
  291. if(StringUtils.isNotBlank(rl.getContractNo())) parameter.put("contractNo", rl.getContractNo());
  292. if(StringUtils.isNotBlank(rl.getOrderNo())) parameter.put("orderNo", rl.getOrderNo());
  293. if(StringUtils.isNotBlank(rl.getNickname())) parameter.put("nickname", rl.getNickname());
  294. if(StringUtils.isNotBlank(rl.getCorporateName())) parameter.put("corporateName", rl.getCorporateName());
  295. if(StringUtils.isNotBlank(adminName)) parameter.put("adminName", adminName);
  296. if(StringUtils.isNotBlank(adminDeps)){
  297. parameter.put("adminDeps", departmentService.parseArray(adminDeps));
  298. }
  299. if(StringUtils.isNotBlank(orderDeps)){
  300. parameter.put("orderDeps", departmentService.parseArray(orderDeps));
  301. }
  302. if(null!= status) parameter.put("status", status);
  303. if(StringUtils.isNotBlank(TokenManager.getAdminId())) parameter.put("aid", TokenManager.getAdminId());
  304. }
  305. @Override
  306. public Map<String, Object> getCountlistReceivables(ReceivablesListBo rl, Integer status, String adminName,
  307. String adminDeps, String orderDeps) {
  308. Map<String,Object> parameter=new HashMap<String, Object>();
  309. addParemeter(rl, status, adminName, adminDeps, orderDeps, parameter);
  310. //计算回收表的订单总金额与当前总收款额。
  311. Map<String,Object> map=new HashMap<String, Object>();
  312. map.put("totalAmount", new BigDecimal(temporaryReceivablesMapper.getCountlistReceivablesTotalAmount(parameter)).stripTrailingZeros() );
  313. map.put("amount",new BigDecimal(temporaryReceivablesMapper.getCountlistReceivablesAmount(parameter)).stripTrailingZeros() );
  314. return map;
  315. }
  316. @Override
  317. public void batchListReceivables(MultipartFile file) {
  318. //获得Workbook工作薄对象
  319. Workbook workbook = ExcelUtils.getWorkBook(file);
  320. //创建一个对象,用来存储数据
  321. List<TemporaryReceivablesBo> list=new ArrayList<>();
  322. if(workbook != null){
  323. //获得当前sheet工作表
  324. Sheet sheet = workbook.getSheetAt(0);
  325. if(sheet == null){
  326. return;
  327. }
  328. //获得当前sheet的开始行
  329. int firstRowNum = sheet.getFirstRowNum();
  330. //获得当前sheet的结束行
  331. int lastRowNum = sheet.getLastRowNum();
  332. //处理空白行
  333. for (int i = firstRowNum; i <= sheet.getLastRowNum();i++) {
  334. Row r = sheet.getRow(i);
  335. if(r == null){
  336. // 如果是空行(即没有任何数据、格式),直接把它以下的数据往上移动
  337. sheet.shiftRows(i+1, sheet.getLastRowNum(),-1);
  338. continue;
  339. }
  340. boolean flag = false;
  341. for(Cell c:r){
  342. if(c.getCellTypeEnum() != CellType.BLANK){
  343. flag = true;
  344. break;
  345. }
  346. }
  347. if(flag){
  348. i++;
  349. continue;
  350. } else{//如果是空白行(即可能没有数据,但是有一定格式)
  351. if(i == sheet.getLastRowNum())//如果到了最后一行,直接将那一行remove掉
  352. sheet.removeRow(r);
  353. else//如果还没到最后一行,则数据往上移一行
  354. sheet.shiftRows(i+1, sheet.getLastRowNum(),-1);
  355. }
  356. }
  357. lastRowNum=sheet.getLastRowNum();
  358. if (lastRowNum<2) {
  359. throw new BusinessException(new Error("未找到正确的参数。"));
  360. }
  361. //循环除了第2行的所有行
  362. for(int rowNum = firstRowNum+2;rowNum <= lastRowNum;rowNum++){
  363. //获得当前行
  364. Row row = sheet.getRow(rowNum);
  365. if(row == null){
  366. continue;
  367. }
  368. //获得当前行的开始列
  369. int firstCellNum = row.getFirstCellNum();
  370. //获得当前行的列数
  371. int lastCellNum = row.getLastCellNum();
  372. //循环当前行 cellNum = (firstCellNum+1) 则是除开第一例
  373. TemporaryReceivablesBo trb=new TemporaryReceivablesBo();
  374. for(int cellNum = (firstCellNum); cellNum < lastCellNum;cellNum++){
  375. Cell cell = row.getCell(cellNum);
  376. try {
  377. switch (cellNum) {
  378. case 0:
  379. trb.setFinancialPayNo(ExcelUtils.getCellValue(cell));
  380. break;
  381. case 1:
  382. trb.setOrderNo(ExcelUtils.getCellValue(cell).trim());
  383. break;
  384. case 2:
  385. trb.setCorporateName(ExcelUtils.getCellValue(cell));
  386. break;
  387. case 3:
  388. trb.setAmount(new BigDecimal((ExcelUtils.getCellValue(cell).equals("")?"0":ExcelUtils.getCellValue(cell))));
  389. break;
  390. case 4:
  391. trb.setReceivablesTime(DateUtils.StringToDate(ExcelUtils.getCellValue(cell), AFTConstants.YYYYMMDD));
  392. break;
  393. case 5:
  394. trb.setRemarks(ExcelUtils.getCellValue(cell));
  395. break;
  396. }
  397. } catch (Exception e) {
  398. throw new BusinessException(new Error("表格第"+(rowNum+1)+"行输入内容不正确。"));
  399. }
  400. }
  401. trb.setAid(TokenManager.getAdminId());
  402. trb.setCreateTime(new Date());
  403. trb.setStatus(0);
  404. list.add(trb);
  405. }
  406. }
  407. temporaryReceivablesMapper.insertBatch(list);
  408. //计算重复的单
  409. temporaryReceivablesMapper.updateRepeatOrderNo(TokenManager.getAdminId());
  410. }
  411. /**
  412. *
  413. * @param comment
  414. * @param fileName
  415. * @param list
  416. * @param type 0收款 1开票 2流水
  417. * @return
  418. */
  419. public static XSSFWorkbook exportTemplateInfoS(String[] comment,String fileName,List<?> list,Integer type){
  420. //map 数据 ,comment表头 (列名称)
  421. //1,创建一个workbook,对应的是一个excel文件
  422. XSSFWorkbook wb = new XSSFWorkbook();
  423. //遍历map
  424. XSSFSheet sheet = wb.createSheet(fileName);
  425. //3。创建一个row
  426. XSSFRow row = sheet.createRow(0);
  427. //4.创建一个cell
  428. XSSFCell cell = row.createCell(0);
  429. cell.setCellValue(fileName+"列表");
  430. XSSFCellStyle style1 = ExportExcelUtil.setCellStyle1(wb);//标题
  431. XSSFCellStyle style2 = ExportExcelUtil.setCellStyle2(wb);//正文
  432. cell.setCellStyle(style1);
  433. //合并列
  434. sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, comment.length-1));//合并单元格
  435. //设置其他单位格式
  436. //创建表头
  437. XSSFRow row2 = sheet.createRow(1);
  438. for(int i = 0; i < comment.length; i++){
  439. sheet.setColumnWidth(i, 3000);//设置列宽
  440. XSSFCell c = row2.createCell(i);
  441. c.setCellValue(comment[i]);
  442. c.setCellStyle(style2);
  443. }
  444. switch (type) {
  445. case 0:
  446. addSettlementReceivablesList(comment, list, sheet);
  447. break;
  448. case 1:
  449. addSettlementInvoiceList(comment, list, sheet);
  450. break;
  451. case 2:
  452. addSettlementMyBillList(comment, list, sheet);
  453. break;
  454. }
  455. return wb;
  456. }
  457. @SuppressWarnings("unchecked")
  458. private static void addSettlementMyBillList(String[] comment, List<?> list, XSSFSheet sheet) {
  459. for (TOrderBillNew ob : (List<TOrderBillNew>)list) {
  460. //新增一行
  461. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  462. for (int i = 0; i < comment.length; i++) {
  463. //当前列的只
  464. String o = "";
  465. switch (comment[i]) {
  466. // String[] comment = {"订单编号","合同编号","收款时间","财务流水时间","财务流水号","金额(万元)","收款方","付款方","流水科目","平台流水号","收款类型","备注"};
  467. case "订单编号": o = ob.getOrderNo(); break;
  468. case "合同编号": o = ob.getContractNo(); break;
  469. case "收款时间": o = ob.getCreateTimes(); break;
  470. case "财务流水时间": o = ob.getFinancialPayTimes(); break;
  471. case "财务流水号": o = ob.getFinancialPayNo(); break;
  472. case "金额(万元)": o = ob.getTransactionAmount().toString(); break;
  473. case "收款方": o = ob.getPayeeName(); break;
  474. case "付款方": o = ob.getPayerName(); break;
  475. case "流水科目": o = TransactionSubject.getValueByCode(ob.getTransactionSubject()); break;
  476. case "平台流水号": o = ob.getBillNo(); break;
  477. case "收款类型":
  478. if(ob.getType()==0) {
  479. o = "手工收款"; break;
  480. }else if(ob.getType()==1) {
  481. o = "批量收款"; break;
  482. }
  483. case "备注": o = ob.getRemarks(); break;
  484. default: o = ""; break;
  485. }
  486. XSSFCell c = r.createCell(i);
  487. c.setCellValue(o);
  488. }
  489. }
  490. }
  491. @SuppressWarnings("unchecked")
  492. private static void addSettlementInvoiceList(String[] comment, List<?> list, XSSFSheet sheet) {
  493. for (TOrderInvoiceBo ob : (List<TOrderInvoiceBo>)list) {
  494. //新增一行
  495. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  496. for (int i = 0; i < comment.length; i++) {
  497. //当前列的只
  498. String o = "";
  499. switch (comment[i]) {
  500. // String[] comment = {"编号","订单编号","开票金额(万元)","申请时间","开票状态"};
  501. case "编号": o = ob.getId().toString(); break;
  502. case "订单编号": o = ob.getOrderno(); break;
  503. case "开票金额(万元)": o = ob.getAmount().toString(); break;
  504. case "申请时间": o = ob.getCreateTime(); break;
  505. case "开票状态":
  506. // 状态 0未提交 1处理中 2通过 3拒绝 4 撤销
  507. switch(ob.getStatus()) {
  508. case 1 :o = "处理中"; break;
  509. case 2 :o = "通过"; break;
  510. }
  511. break;
  512. default: o = ""; break;
  513. }
  514. XSSFCell c = r.createCell(i);
  515. c.setCellValue(o);
  516. }
  517. }
  518. }
  519. @SuppressWarnings("unchecked")
  520. private static void addSettlementReceivablesList(String[] comment, List<?> list, XSSFSheet sheet) {
  521. for (OrderListBo ob : (List<OrderListBo>)list) {
  522. //新增一行
  523. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  524. for (int i = 0; i < comment.length; i++) {
  525. //当前列的只
  526. String o = "";
  527. switch (comment[i]) {
  528. // "订单编号", "合同编号","客户名称","订单部门","订单负责人","签单日期","下单日期",
  529. // "签单金额(万元)", "已开票金额(万元)", "已收金额(万元)","最近收款(万元)","结算状态","订单流程","是否特批"}
  530. case "订单编号": o = ob.getOrderNo().toString(); break;
  531. case "合同编号": o = ob.getContractNo(); break;
  532. case "客户名称": o = ob.getBuyerName(); break;
  533. case "订单部门": o = ob.getDepartmentName(); break;
  534. case "订单负责人": o = ob.getSellerName(); break;
  535. case "签单日期": o = ob.getSignTime(); break;
  536. case "下单日期": o = ob.getCreateTime(); break;
  537. case "签单金额(万元)":o=ob.getSignTotalAmount().toString();break;
  538. case "已开票金额(万元)":o=ob.getInvoiceAmount().toString();break;
  539. case "已收金额(万元)":o=ob.getActuallyTotalAmount().toString();break;
  540. case "总成本(万元)":o=ob.getCostAmount().toString();break;
  541. case "已付成本(万元)":o=ob.getPaymentAmount().toString();break;
  542. case "最近收款(万元)":o=ob.getFinalReceivables().toString();break;
  543. case "最近收款时间":o=ob.getFinalReceivablesTime();break;
  544. case "结算状态":o=LiquidationNewState.getValueByCode(ob.getLiquidationStatus());break;
  545. case "订单流程":o=ProcessStatus.getValueByCode(ob.getProcessStatus());break;
  546. case "是否特批":o=ApprovalNewState.getValueByCode(ob.getApproval());break;
  547. default: o = ""; break;
  548. }
  549. XSSFCell c = r.createCell(i);
  550. c.setCellValue(o);
  551. }
  552. }
  553. }
  554. }