ProjectStatisticsServiceImpl.java 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417
  1. package com.goafanti.order.service.impl;
  2. import java.io.File;
  3. import java.io.FileOutputStream;
  4. import java.io.IOException;
  5. import java.io.OutputStream;
  6. import java.text.SimpleDateFormat;
  7. import java.util.*;
  8. import javax.servlet.http.HttpServletResponse;
  9. import com.goafanti.common.bo.Result;
  10. import groovy.util.logging.Log4j;
  11. import org.apache.commons.collections4.map.HashedMap;
  12. import org.apache.commons.lang3.StringUtils;
  13. import org.apache.poi.ss.util.CellRangeAddress;
  14. import org.apache.poi.xssf.usermodel.XSSFCell;
  15. import org.apache.poi.xssf.usermodel.XSSFRow;
  16. import org.apache.poi.xssf.usermodel.XSSFSheet;
  17. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  18. import org.springframework.beans.factory.annotation.Value;
  19. import org.springframework.stereotype.Service;
  20. import com.goafanti.common.bo.Error;
  21. import com.goafanti.common.dao.TOrderTaskMapper;
  22. import com.goafanti.common.error.BusinessException;
  23. import com.goafanti.common.utils.ExportExcelUtil;
  24. import com.goafanti.core.mybatis.BaseMybatisDao;
  25. import com.goafanti.core.mybatis.page.Pagination;
  26. import com.goafanti.order.bo.InputProjectStatistics;
  27. import com.goafanti.order.bo.InputProvincialStatistics;
  28. import com.goafanti.order.bo.OutProjectStatistics;
  29. import com.goafanti.order.bo.OutProvincialStatistics;
  30. import com.goafanti.order.enums.NewProjectStatus;
  31. import com.goafanti.order.service.ProjectStatisticsService;
  32. @Service
  33. @Log4j
  34. public class ProjectStatisticsServiceImpl extends BaseMybatisDao<TOrderTaskMapper> implements ProjectStatisticsService {
  35. @Value("${upload.path}")
  36. private String downloadPath;
  37. @SuppressWarnings("unchecked")
  38. @Override
  39. public Pagination<OutProjectStatistics> selectTaskList(InputProjectStatistics ps) {
  40. Map<String, Object> params= new HashedMap<>();
  41. Integer pageNo=1,pageSize=10;
  42. if(ps.getStartDate()!=null)params.put("startDate", ps.getStartDate());
  43. if(ps.getEndDate()!=null)params.put("endDate", ps.getEndDate()+" 23:59:59");
  44. if(ps.getDepId()!=null)params.put("depId", ps.getDepId());
  45. if(ps.getThchDepId()!=null)params.put("thchDepId", ps.getThchDepId());
  46. if(ps.getProjectStatus()!=null)params.put("projectStatus", ps.getProjectStatus());
  47. if(ps.getProjectType()!=null)params.put("projectType", ps.getProjectType());
  48. if(ps.getOrderNo()!=null)params.put("orderNo", ps.getOrderNo());
  49. if(ps.getContractNo()!=null)params.put("contractNo", ps.getContractNo());
  50. if(ps.getUserName()!=null)params.put("userName", ps.getUserName());
  51. if(ps.getDeclarationBatch()!=null)params.put("declarationBatch", ps.getDeclarationBatch());
  52. if(ps.getProjectSituation()!=null)params.put("projectSituation", ps.getProjectSituation());
  53. if(ps.getProjectAmount()!=null) {
  54. // 0~0.5万、0.5~1万、1~2万、2~5万、5~10万、10~30万、30~50万、50到80万、80万上
  55. double s = 0,e=0;
  56. if (ps.getProjectAmount()==0) { s=0;e=0.5;
  57. }else if (ps.getProjectAmount()==1) {s=0;e=0.5;
  58. }else if (ps.getProjectAmount()==2) {s=0.5;e=1;
  59. }else if (ps.getProjectAmount()==3) {s=1;e=2;
  60. }else if (ps.getProjectAmount()==4) {s=2;e=5;
  61. }else if (ps.getProjectAmount()==5) {s=5;e=10;
  62. }else if (ps.getProjectAmount()==6) {s=10;e=30;
  63. }else if (ps.getProjectAmount()==7) {s=30;e=50;
  64. }else if (ps.getProjectAmount()==8) {s=50;e=80;
  65. }else if (ps.getProjectAmount()==9) {s=80;
  66. }
  67. params.put("projectAmount", ps.getProjectAmount());
  68. params.put("amountStart", s);
  69. params.put("amountEnd", e);
  70. }
  71. params.put("status",ps.getStatus()==null?0:ps.getStatus());
  72. if(ps.getProvince()!=null) params.put("province", ps.getProvince());
  73. if(ps.getProjectId()!=null) params.put("projectId", ps.getProjectId());
  74. if(ps.getScreen()!=null) params.put("screen", ps.getScreen());
  75. if(ps.getPageNo()!=null)pageNo=ps.getPageNo();
  76. if(ps.getPageSize()!=null)pageSize=ps.getPageSize();
  77. Pagination<OutProjectStatistics> p = (Pagination<OutProjectStatistics>)findPage("selectProjectStatisticsListByPage",
  78. "selectProjectStatisticsCount", params, pageNo, pageSize);
  79. return p;
  80. }
  81. @Override
  82. public void exporTaskList(HttpServletResponse response, InputProjectStatistics ib) throws IOException {
  83. OutputStream out = response.getOutputStream();
  84. try {
  85. if(ib.getPageSize()==null)ib.setPageSize(9999999);
  86. if(ib.getStatus()==null)ib.setStatus(0);
  87. @SuppressWarnings("unchecked")
  88. List<OutProjectStatistics> list= (List<OutProjectStatistics>) selectTaskList(ib).getList();
  89. String[] comment = {"派单时间","派单省份","订单部门","营销员","合同编号","订单编号","签单客户","项目类型","项目名称","负责部门",
  90. "咨询师/咨询经理","项目状态"};
  91. List<String> ls = new ArrayList<String>();
  92. Collections.addAll(ls, comment);
  93. if (ib.getStatus()==1) {
  94. //高新、科技
  95. //是否立项 立项时间 是否抽查 联系人电话 法人电话 证书编号 申报批次
  96. String[] ss= {"是否立项","立项时间","是否抽查","联系人电话","法人电话","证书编号","申报批次"};
  97. Collections.addAll(ls, ss);
  98. }else if (ib.getStatus()==2) {
  99. //双软
  100. ls.add("下证时间");
  101. }else if (ib.getStatus()==3) {
  102. //软著
  103. String[] ss= {"软著数量/已下证","有无材料","加急天数","下证时间","证书编号","成本","利润"};
  104. Collections.addAll(ls, ss);
  105. }else if (ib.getStatus()==4) {
  106. //专利
  107. String[] ss= {"是否高新","项目数量/下证数","驳回数","专利号","专利名称","受理时间","下证时间","成本","利润"};
  108. Collections.addAll(ls, ss);
  109. }
  110. ls.add("签单金额");
  111. ls.add("特别说明");
  112. comment= ls.toArray(new String[ls.size()]);
  113. String fileName ="项目汇总表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  114. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"项目汇总表");
  115. //根据列表编写文档
  116. XSSFSheet sheet =wb.getSheetAt(0);
  117. XSSFRow row = sheet.createRow(2);
  118. //4.创建一个cell
  119. XSSFCell cell = row.createCell(0);
  120. //处理搜索条件
  121. cell.setCellValue(getInputString(ib));
  122. sheet.addMergedRegion(new CellRangeAddress(2, 2, 0, comment.length-1));//合并单元格
  123. for (OutProjectStatistics ob : list) {
  124. //新增一行
  125. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  126. for (int i = 0; i < comment.length; i++) {
  127. //当前列的只
  128. String o = "";
  129. switch (comment[i]) {
  130. // "派单时间","派单省份","订单部门","营销员","合同编号","订单编号","签单客户","项目类型",
  131. // "项目名称","负责部门","咨询师/咨询经理","项目状态","签单金额"
  132. case "派单时间": o = ob.getDistributionTime(); break;
  133. case "派单省份": o = ob.getProvince(); break;
  134. case "订单部门": o = ob.getDepName(); break;
  135. case "营销员": o = ob.getSalesmanName(); break;
  136. case "合同编号": o = ob.getContractNo(); break;
  137. case "订单编号": o = ob.getOrderNo(); break;
  138. case "签单客户": o = ob.getUserName(); break;
  139. case "项目类型": o = ob.getCname(); break;
  140. case "项目名称": o = ob.getPname(); break;
  141. case "负责部门": o = ob.getTechDepName(); break;
  142. case "咨询师/咨询经理": o = ob.getTechName(); break;
  143. case "项目状态": o = NewProjectStatus.getValueByCode(ob.getProjectStatus()); break;
  144. //是否立项 立项时间 是否抽查 联系人电话 法人电话 证书编号 申报批次
  145. case "是否立项": o = ob.getSetUpStatus()==null?"":ob.getSetUpStatus()==1?"是":"否"; break;
  146. case "立项时间": o = ob.getSetUpTime(); break;
  147. case "是否抽查":
  148. //是否抽查 0否 1未通过 2通过
  149. if (ob.getSpotCheckStatus()==null) o="";
  150. else if (ob.getSpotCheckStatus()==0) o="否";
  151. else if (ob.getSpotCheckStatus()==1) o="未通过";
  152. else if (ob.getSpotCheckStatus()==2) o="通过";
  153. break;
  154. case "联系人电话": o = ob.getContactMobile(); break;
  155. case "法人电话": o = ob.getLegalPersonTel(); break;
  156. case "证书编号": o = ob.getCertificateNumber(); break;
  157. case "申报批次": o = ob.getDeclarationBatch(); break;
  158. //"下证时间"
  159. case "下证时间": o = ob.getLicenceTime(); break;
  160. //"软著数量/已下证","有无材料","加急天数","下证时间","证书编号","成本","利润"
  161. case "软著数量/已下证": o = StringUtils.join(ob.getCommodityQuantity(),"/",ob.getCertificatesCount()); break;
  162. case "有无材料": o = ob.getIfMaterial()==null?"":ob.getIfMaterial()==1?"是":"否"; break;
  163. case "加急天数": o = ob.getUrgentDay()==null?"":ob.getUrgentDay()==1?"是":"否"; break;
  164. case "成本": o = ob.getCostAmount().stripTrailingZeros().toPlainString(); break;
  165. case "利润": o = ob.getProfit().stripTrailingZeros().toPlainString(); break;
  166. //"是否高新","项目数量/下证数","驳回数","专利号","专利名称","受理时间","下证时间","成本","利润"
  167. case "是否高新": o = ob.getHighTechstatus()==null?"":ob.getHighTechstatus()==1?"是":"否"; break;
  168. case "项目数量/下证数": o = StringUtils.join(ob.getCommodityQuantity(),"/",ob.getCertificatesCount()); break;
  169. case "驳回数": o = ob.getRejectCount()==null?"":ob.getRejectCount().toString(); break;
  170. case "专利号": o = ob.getPatentNo(); break;
  171. case "专利名称": o = ob.getPatentName(); break;
  172. case "受理时间": o = ob.getAcceptTime(); break;
  173. case "签单金额": o = ob.getCommodityPrice().stripTrailingZeros().toPlainString(); break;
  174. case "特别说明": o = ob.getSpecialComment(); break;
  175. default: o = ""; break;
  176. }
  177. XSSFCell c = r.createCell(i);
  178. c.setCellValue(o);
  179. }
  180. }
  181. //返回名称及参数
  182. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  183. response.setContentType("application/octet-stream;charset=utf-8");
  184. // 返回数据流
  185. wb.write(out);
  186. out.flush();
  187. out.close();
  188. } catch (Exception e) {
  189. e.printStackTrace();
  190. throw new BusinessException(new Error("表格生成错误。"));
  191. }finally {
  192. out.flush();
  193. out.close();
  194. }
  195. }
  196. /**
  197. * 拼接搜索参数
  198. * @param ib
  199. * @return
  200. */
  201. private String getInputString(InputProjectStatistics ib) {
  202. String str="搜索条件:";
  203. int i=1;
  204. if(ib.getStartDate()!=null) {
  205. str=StringUtils.join(str,i++,"-开始时间:",ib.getStartDate()," ");
  206. }
  207. if(ib.getEndDate()!=null)str=StringUtils.join(str,i++,"-结束时间:",ib.getEndDate()," ");
  208. if (ib.getProvinceName()!=null)str=StringUtils.join(str,i++,"-省份:",ib.getProvinceName()," ");
  209. if(ib.getDepId()!=null)str=StringUtils.join(str,i++,"-订单部门:",ib.getDepName()," ");
  210. if(ib.getThchDepId()!=null)str=StringUtils.join(str,i++,"-责任部门:",ib.getThchDepName()," ");
  211. if(ib.getProjectStatus()!=null)str=StringUtils.join(str,i++,"-项目别类:",ib.getProjectStatusName()," ");
  212. if(ib.getProjectType()!=null)str=StringUtils.join(str,i++,"-项目分类:",ib.getProjectTypeName()," ");
  213. if(ib.getOrderNo()!=null)str=StringUtils.join(str,i++,"-订单编号:",ib.getOrderNo()," ");
  214. if(ib.getContractNo()!=null)str=StringUtils.join(str,i++,"-合同编号:",ib.getContractNo()," ");
  215. if(ib.getUserName()!=null)str=StringUtils.join(str,i++,"-客户名称:",ib.getUserName()," ");
  216. if(ib.getDeclarationBatch()!=null)str=StringUtils.join(str,i++,"-申报批次:",ib.getDeclarationBatch()," ");
  217. if(ib.getProjectSituation()!=null) {
  218. //0 正常 1专利 2软著 3审计 4双软
  219. String str3="";
  220. if (ib.getProjectSituation()==0) { str3="通用";
  221. }else if (ib.getProjectAmount()==1) { str3="专利";
  222. }else if (ib.getProjectAmount()==2) { str3="软著";
  223. }else if (ib.getProjectAmount()==3) { str3="审计";
  224. }else if (ib.getProjectAmount()==4) { str3="双软";
  225. }
  226. str=StringUtils.join(str,i++,"-项目情况:",str3," ");
  227. }
  228. if(ib.getProjectAmount()!=null) {
  229. String str2="";
  230. // 0~0.5万、0.5~1万、1~2万、2~5万、5~10万、10~30万、30~50万、50到80万、80万上
  231. if (ib.getProjectAmount()==0) { str2="0~0.5万";
  232. }else if (ib.getProjectAmount()==1) { str2="0~0.5万";
  233. }else if (ib.getProjectAmount()==2) { str2="0.5~1万";
  234. }else if (ib.getProjectAmount()==3) { str2="1~2万";
  235. }else if (ib.getProjectAmount()==4) { str2="2~5万";
  236. }else if (ib.getProjectAmount()==5) { str2="5~10万";
  237. }else if (ib.getProjectAmount()==6) { str2="10~30万";
  238. }else if (ib.getProjectAmount()==7) { str2="30~50万";
  239. }else if (ib.getProjectAmount()==8) { str2="50到80万";
  240. }else if (ib.getProjectAmount()==9) { str2="80万上";
  241. }
  242. str=StringUtils.join(str,i++,"-项目金额:",str2," ");
  243. }
  244. if(i==1)str=StringUtils.join(str,"无");
  245. return str;
  246. }
  247. @SuppressWarnings("unchecked")
  248. @Override
  249. public Pagination<OutProvincialStatistics> selectProvincialStatistics(InputProvincialStatistics is) {
  250. Map<String, Object> params= new HashedMap<>();
  251. Integer pageNo=1,pageSize=10;
  252. if(is.getStartDate()!=null)params.put("startDate", is.getStartDate());
  253. if(is.getEndDate()!=null)params.put("endDate", is.getEndDate()+" 23:59:59");
  254. if(is.getThchDepId()!=null)params.put("thchDepId", is.getThchDepId());
  255. if(is.getProjectStatus()!=null)params.put("projectStatus", is.getProjectStatus());
  256. if(is.getProjectType()!=null)params.put("projectType", is.getProjectType());
  257. if(is.getProvince()!=null)params.put("province", is.getProvince());
  258. if(is.getProjectId()!=null)params.put("projectId", is.getProjectId());
  259. params.put("status",is.getStatus()==null?0:is.getStatus());
  260. if(is.getPageNo()!=null)pageNo=is.getPageNo();
  261. if(is.getPageSize()!=null)pageSize=is.getPageSize();
  262. Pagination<OutProvincialStatistics> p = (Pagination<OutProvincialStatistics>)findPage("selectProvincialStatisticsListByPage",
  263. "selectProvincialStatisticsCount", params, pageNo, pageSize);
  264. return p;
  265. }
  266. @Override
  267. public Result exporProvincialList(InputProvincialStatistics ib) {
  268. OutputStream out = null;
  269. XSSFWorkbook wb=null;
  270. try {
  271. if(ib.getPageSize()==null)ib.setPageSize(9999999);
  272. if(ib.getStatus()==null)ib.setStatus(0);
  273. @SuppressWarnings("unchecked")
  274. List<OutProvincialStatistics> list= (List<OutProvincialStatistics>) selectProvincialStatistics(ib).getList();
  275. //派单賞份负责部门项目类別陸存数(个)派单数(个)下证数(个)签单额(万元)成本(万元)利润(万元)
  276. String[] comment = {"派单省份","负责部门","项目别类","库存数","派单数"};
  277. List<String> ls = new ArrayList<String>();
  278. Collections.addAll(ls, comment);
  279. if (ib.getStatus()==1) {
  280. //高新
  281. //是否立项 立项时间 是否抽查 联系人电话 法人电话 证书编号 申报批次
  282. String[] ss= {"完成数","立项数","抽查数","未通过"};
  283. Collections.addAll(ls, ss);
  284. }else if (ib.getStatus()==2||ib.getStatus()==3) {
  285. //发明专利、实用新型
  286. ls.add("受理数");
  287. ls.add("完结数");
  288. ls.add("授权数");
  289. ls.add("驳回数");
  290. }else if (ib.getStatus()==4) {
  291. //软著
  292. ls.add("下证数");
  293. }else if (ib.getStatus()==5) {
  294. //商标
  295. String[] ss= {"申请数","驳回数","下证数"};
  296. Collections.addAll(ls, ss);
  297. }else if (ib.getStatus()==0) {
  298. String[] ss= {"完成数","公示数"};
  299. Collections.addAll(ls, ss);
  300. }
  301. String[] ss= {"签单额(万元)","成本(万元)","利润(万元)"};
  302. Collections.addAll(ls, ss);
  303. comment= ls.toArray(new String[ls.size()]);
  304. // String fileName ="项目数据统计" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  305. String filename = UUID.randomUUID().toString() + "_ProvincialList.xlsx";
  306. wb =ExportExcelUtil.exportTemplateInfoS(comment,"项目数据统计");
  307. //根据列表编写文档
  308. XSSFSheet sheet =wb.getSheetAt(0);
  309. XSSFRow xr = sheet.createRow(sheet.getLastRowNum()+1);
  310. //4.创建一个cell
  311. XSSFCell cell = xr.createCell(0);
  312. cell.setCellValue(getProvincialInputString(ib));
  313. sheet.addMergedRegion(new CellRangeAddress(2, 2, 0, comment.length-1));//合并单元格
  314. for (OutProvincialStatistics ob : list) {
  315. //新增一行
  316. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  317. for (int i = 0; i < comment.length; i++) {
  318. //当前列的只
  319. String o = "";
  320. switch (comment[i]) {
  321. // "派单省份","负责部门","项目别类","库存数(个)","派单数(个)","下证数(个)","签单数(个)","成本(万元)","利润(万元)"
  322. case "派单省份": o = ob.getProvinceName(); break;
  323. case "负责部门": o = ob.getThchDepName(); break;
  324. case "项目别类": o = ob.getProjectStatus(); break;
  325. case "库存数": o = ob.getStockCount().toString(); break;
  326. case "派单数": o = ob.getDistributeCount().toString(); break;
  327. //"完成数","立项数","抽查数","未通过"
  328. case "完成数": o = ob.getCompleteCount().toString(); break;
  329. case "立项数": o = ob.getSetUpCount().toString(); break;
  330. case "抽查数": o = ob.getSpotCheckCount().toString(); break;
  331. case "未通过": o = ob.getFailedCount().toString(); break;
  332. //受理数 完结数 授权数 驳回数
  333. case "受理数": o = ob.getAcceptCount().toString(); break;
  334. case "完结数": o = ob.getCompleteCount().toString(); break;
  335. case "授权数": o = ob.getAuthorizeCount().toString(); break;
  336. case "驳回数": o = ob.getRejectCount().toString(); break;
  337. //下证数
  338. case "下证数": o = ob.getCertificatesCount().toString(); break;
  339. //"申请数","驳回数","下证数"
  340. case "申请数": o = ob.getApplyCount().toString(); break;
  341. //"完成数","公示/立项数"
  342. case "公示数": o = ob.getPublicityCount().toString(); break;
  343. case "签单额(万元)": o = ob.getAmountCount().stripTrailingZeros().toPlainString(); break;
  344. case "成本(万元)": o = ob.getCostAmount().stripTrailingZeros().toPlainString(); break;
  345. case "利润(万元)": o = ob.getProfit().stripTrailingZeros().toPlainString(); break;
  346. default: o = ""; break;
  347. }
  348. XSSFCell c = r.createCell(i);
  349. c.setCellValue(o);
  350. }
  351. }
  352. String downloadPath = this.downloadPath+"/" + filename;
  353. File desc = new File(downloadPath);
  354. if (!desc.getParentFile().exists()) {
  355. desc.getParentFile().mkdirs();
  356. }
  357. out=new FileOutputStream(downloadPath);
  358. // 返回数据流
  359. wb.write(out);
  360. return new Result().data(filename);
  361. } catch (Exception e) {
  362. e.printStackTrace();
  363. throw new BusinessException(new Error("表格生成错误。"));
  364. }finally {
  365. if (out != null) {
  366. try {
  367. out.close();
  368. } catch (IOException e1) {
  369. e1.printStackTrace();
  370. }
  371. }
  372. if (wb !=null){
  373. try {
  374. wb.close();
  375. } catch (IOException e1) {
  376. e1.printStackTrace();
  377. }
  378. }
  379. }
  380. }
  381. private String getProvincialInputString(InputProvincialStatistics ib) {
  382. String str="搜索条件:";
  383. int i=1;
  384. if(ib.getStartDate()!=null) str=StringUtils.join(str,i++,"-开始时间:",ib.getStartDate()," ");
  385. if(ib.getEndDate()!=null)str=StringUtils.join(str,i++,"-结束时间:",ib.getEndDate()," ");
  386. if(ib.getProvince()!=null)str=StringUtils.join(str,i++,"-省份:",ib.getProvinceName()," ");
  387. if(ib.getThchDepId()!=null)str=StringUtils.join(str,i++,"-责任部门:",ib.getThchDepName()," ");
  388. if(ib.getProjectStatus()!=null)str=StringUtils.join(str,i++,"-项目别类:",ib.getProjectStatusName()," ");
  389. if(ib.getProjectType()!=null)str=StringUtils.join(str,i++,"-项目分类:",ib.getProjectTypeName()," ");
  390. if(ib.getProjectId()!=null)str=StringUtils.join(str,i++,"-项目名称:",ib.getProjectName()," ");
  391. if(i==1)StringUtils.join(str,"无");
  392. return str;
  393. }
  394. }