DemandCollectionServiceImpl.java 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218
  1. package com.goafanti.demandCollection.service.impl;
  2. import java.io.IOException;
  3. import java.io.OutputStream;
  4. import java.text.SimpleDateFormat;
  5. import java.util.Date;
  6. import java.util.HashMap;
  7. import java.util.List;
  8. import java.util.Map;
  9. import javax.servlet.http.HttpServletResponse;
  10. import org.apache.commons.lang3.StringUtils;
  11. import org.apache.commons.logging.Log;
  12. import org.apache.commons.logging.LogFactory;
  13. import org.apache.poi.ss.usermodel.HorizontalAlignment;
  14. import org.apache.poi.xssf.usermodel.XSSFCell;
  15. import org.apache.poi.xssf.usermodel.XSSFCellStyle;
  16. import org.apache.poi.xssf.usermodel.XSSFRow;
  17. import org.apache.poi.xssf.usermodel.XSSFSheet;
  18. import org.apache.poi.xssf.usermodel.XSSFWorkbook;
  19. import org.springframework.beans.factory.annotation.Autowired;
  20. import org.springframework.stereotype.Service;
  21. import com.alibaba.druid.sql.visitor.functions.Char;
  22. import com.goafanti.common.bo.Error;
  23. import com.goafanti.common.dao.DemandCollectionMapper;
  24. import com.goafanti.common.error.BusinessException;
  25. import com.goafanti.common.model.DemandCollection;
  26. import com.goafanti.common.utils.ExportExcelUtil;
  27. import com.goafanti.core.mybatis.BaseMybatisDao;
  28. import com.goafanti.core.mybatis.page.Pagination;
  29. import com.goafanti.demandCollection.bo.InputDemandCollection;
  30. import com.goafanti.demandCollection.bo.OutDemandCollection;
  31. import com.goafanti.demandCollection.service.DemandCollectionService;
  32. @Service
  33. public class DemandCollectionServiceImpl extends BaseMybatisDao<DemandCollectionMapper> implements DemandCollectionService {
  34. protected final Log logger = LogFactory.getLog(DemandCollectionServiceImpl.class);
  35. @Autowired
  36. private DemandCollectionMapper demandCollectionMapper;
  37. @Override
  38. public int addDemandCollection(DemandCollection d) {
  39. return demandCollectionMapper.insertSelective(d);
  40. }
  41. @SuppressWarnings("unchecked")
  42. @Override
  43. public Pagination<OutDemandCollection> demandCollectionList(InputDemandCollection i) {
  44. Map<String, Object> map=new HashMap<>();
  45. if(StringUtils.isNotBlank(i.getDwmc()))map.put("dwmc", i.getDwmc());
  46. if(StringUtils.isNotBlank(i.getDwxz()))map.put("dwxz", i.getDwxz());
  47. if(StringUtils.isNotBlank(i.getStartTime())&&StringUtils.isNotBlank(i.getEndTime())) {
  48. map.put("startTime", i.getStartTime());
  49. map.put("endTime", i.getEndTime()+" 23:59:59");
  50. }
  51. if(StringUtils.isNotBlank(i.getSsszp()))map.put("ssszp", i.getSsszp());
  52. if(StringUtils.isNotBlank(i.getSsszc()))map.put("ssszc", i.getSsszc());
  53. if(StringUtils.isNotBlank(i.getSssza()))map.put("sssza", i.getSssza());
  54. return (Pagination<OutDemandCollection>) findPage("findDemandCollectionList","findDemandCollectionCount",
  55. map, i.getPageNo(), i.getPageSize());
  56. }
  57. @SuppressWarnings("unchecked")
  58. @Override
  59. public void exportDemandCollectionList(HttpServletResponse response, InputDemandCollection idc) throws IOException {
  60. OutputStream out = response.getOutputStream();
  61. try {
  62. System.out.println(1);
  63. String[] comment = { "编号", "单位名称", "单位性质", "行业领域", "所属市州", "所属园区", "拥有的省级及以上平台", "法人代表", "统一社会信用代码", "经济规模",
  64. "人员规模", "成立时间", "注册资本", "通讯地址", "邮编", "联系人", "联系电话", "email", "主营业务及核心产品(服务)", "2018年度项目主营业务收入(万元)",
  65. "2018年度项目净利润(万元)", "2019年度项目主营业务收入(万元)", "2019年度项目净利润(万元)", "年度研发投入", "年度研发投入占营业收入比例", "是否曾获银行贷款",
  66. "银行贷款", "是否为高新技术企业编号 ", "高企证书编号 ", "是否为科技型中小企业", "科企证书编号", "专利数量", "发明专利", "实用新型", "是否曾获科技专项资金",
  67. "是否有产学研合作", "是否已获机构投资者投资 ", "成果名称", "成果领域", "成果属性", "成果体现形式", "成果成熟度", "成果知识产权形式", "知识产权权属 ",
  68. "专利状态", "成果登记情况", "拟采取成果转移转化方式自主转化 ", "拟采取成果转移转化方式合作开发 ", "拟采取成果转移转化方式技术转让 ", "预计可转移转化时间", "成果简述",
  69. "是否有成果合作需求", "是否有意向合作单位", "意向合作单位", "意向合作方式", "企业已展开的国际与区域科技创新合作方式", "主要合作方式 ", "已享受的科技政策",
  70. "拟申请的省级项目", "是否授权省科技主管部门将上述有关信息对外公开发布", "技术负责人", "技术负责人手机", "需求名称", "需求类别", "技术需求类型", "需求领域",
  71. "目前产品技术现状", "研发难点", "预期达到的效果(主要技术指标、技术成熟度、条件、成本等)", "已经开展的工作", "现有研发条件情况(人员情况、仪器设备投入等)",
  72. "目前合作对象情况(合作对象、方式、已投入研发资金情况等)", "是否有下一步合作需求", "意向合作对象", "合作单位名称", "拟采取的合作方式", "需求解决截止时间",
  73. "需求是否可以公开 ", "为解决技术难题能提供的合作资金", "资金用途", "资金缺口", "需求解决方式", "企业产品是否有销往国外", "企业产品是否有意向出口", "创建时间" };
  74. String fileName ="需求征集表" + new SimpleDateFormat("yyyy-MM-dd HH:mm").format(new Date()) + ".xls";
  75. XSSFWorkbook wb =ExportExcelUtil.exportTemplateInfoS(comment,"需求征集表");
  76. System.out.println(2);
  77. //根据列表编写文档
  78. XSSFSheet sheet =wb.getSheetAt(0);
  79. XSSFCellStyle styleTitle = wb.createCellStyle();
  80. styleTitle.setAlignment(HorizontalAlignment.CENTER);
  81. styleTitle.setWrapText(true);
  82. System.out.println(3);
  83. for (OutDemandCollection ob : (List<OutDemandCollection>)demandCollectionList(idc).getList()) {
  84. System.out.println(4);
  85. int x=0;
  86. //新增一行
  87. XSSFRow r = sheet.createRow(sheet.getLastRowNum()+1);
  88. for (int i = 0; i < comment.length; i++) {
  89. //当前列的只
  90. String o = "";
  91. switch (comment[i]) {
  92. case "编号" : o = ob.getId(); break;
  93. case "单位名称" : o = ob.getDwmc(); break;
  94. case "单位性质" : o = ob.getDwxz(); break;
  95. case "行业领域" : o = ob.getHtly(); break;
  96. case "所属市州" : o = ob.getSsszc()+"-"+ob.getSssza(); break;
  97. case "所属园区" : o = ob.getSsyq(); break;
  98. case "拥有的省级及以上平台" : o = ob.getYysjjyspt(); break;
  99. case "法人代表" : o = ob.getFrdb(); break;
  100. case "统一社会信用代码" : o = ob.getYysjjyspt(); break;
  101. case "经济规模" : o = ob.getJjgm(); break;
  102. case "人员规模" : o = ob.getRygm(); break;
  103. case "成立时间" : o = ob.getClsj(); break;
  104. case "注册资本" : o = ob.getZczb(); break;
  105. case "通讯地址" : o = ob.getTxdz(); break;
  106. case "邮编" : o = ob.getYb(); break;
  107. case "联系人" : o = ob.getLxr(); break;
  108. case "联系电话" : o = ob.getLxdh(); break;
  109. case "email" : o = ob.getEmail(); break;
  110. case "主营业务及核心产品(服务)" : o = ob.getZyywjhxcp(); break;
  111. case "2018年度项目主营业务收入(万元)" : o = ob.getNdxmzyywsr18(); break;
  112. case "2018年度项目净利润(万元)" : o = ob.getNdxmjlr18(); break;
  113. case "2019年度项目主营业务收入(万元)" : o = ob.getNdxmzyywsr19(); break;
  114. case "2019年度项目净利润(万元)" : o = ob.getNdxmjlr19(); break;
  115. case "年度研发投入" : o = ob.getNdyftr(); break;
  116. case "年度研发投入占营业收入比例" : o = ob.getNdyftrzyysrbl(); break;
  117. case "是否曾获银行贷款" : o = ob.getSfchyhdk(); break;
  118. case "银行贷款" : o = ob.getSfchyhdkValue(); break;
  119. case "是否为高新技术企业编号 " : o = ob.getSfwgxjsqy(); break;
  120. case "高企证书编号 " : o = ob.getSfwgxjsqyValue(); break;
  121. case "是否为科技型中小企业" : o = ob.getSfwkjxzxqy(); break;
  122. case "科企证书编号" : o = ob.getSfwkjxzxqyValue(); break;
  123. case "专利数量" : o = ob.getZlsl(); break;
  124. case "发明专利" : o = ob.getZlslFmzl(); break;
  125. case "实用新型" : o = ob.getZlslSyxx(); break;
  126. case "是否曾获科技专项资金" : o = ob.getSfchkjzxzj(); break;
  127. case "是否有产学研合作" : o = ob.getSfycxyz(); break;
  128. case "产学研合作" : o = ob.getSfycxyzValue(); break;
  129. case "是否已获机构投资者投资 " : o = ob.getSfyhjgtzztz(); break;
  130. case "机构投资者投资 " : o = ob.getSfyhjgtzztzValue(); break;
  131. case "成果名称" : o = ob.getCgmc(); break;
  132. case "成果领域" : o = ob.getCgly(); break;
  133. case "成果属性" : o = ob.getCgsx(); break;
  134. case "成果体现形式" : o = ob.getCgtxxs(); break;
  135. case "成果成熟度" : o = ob.getCgcsd(); break;
  136. case "成果知识产权形式" : o = ob.getCgzscqxs(); break;
  137. case "知识产权权属 " : o = ob.getZscqqs(); break;
  138. case "专利状态" : o = ob.getZlzt(); break;
  139. case "成果登记情况" : o = ob.getCgdjqk(); break;
  140. case "成果登记编号" : o = ob.getCgdjqkValue(); break;
  141. case "拟采取成果转移转化方式自主转化 " : o = ob.getNcqcgzyzhfszzzh(); break;
  142. case "拟采取成果转移转化方式合作开发 " : o = ob.getNcqcgzyzhfshzkf(); break;
  143. case "拟采取成果转移转化方式技术转让 " : o = ob.getNcqcgzyzhfsjszr(); break;
  144. case "预计可转移转化时间" : o = ob.getYjkzyzhsj(); break;
  145. case "成果简述" : o = ob.getCgjs();
  146. if (x==0)sheet.setColumnWidth(i, 10000);
  147. break;
  148. case "是否有成果合作需求" : o = ob.getSfycghzxq(); break;
  149. case "是否有意向合作单位" : o = ob.getSfyyxhzdw(); break;
  150. case "意向合作单位" : o = ob.getSfyyxhzdwValue(); break;
  151. case "意向合作方式" : o = ob.getYxhzfs(); break;
  152. case "企业已展开的国际与区域科技创新合作方式" : o = ob.getQyyzkdgjqykjcxhzqk();
  153. if (x==0)sheet.setColumnWidth(i, 10000);
  154. break;
  155. case "主要合作方式 " : o = ob.getZyhzfs(); break;
  156. case "已享受的科技政策" : o = ob.getYssdkjzc(); break;
  157. case "拟申请的省级项目" : o = ob.getNsqdsjxm(); break;
  158. case "是否授权省科技主管部门将上述有关信息对外公开发布" :
  159. o = ob.getSqskjzgbmxxdwgkfb().replace("\n", String.valueOf((char)10));
  160. if (x==0)sheet.setColumnWidth(i, 10000);
  161. break;
  162. case "技术负责人" : o = ob.getJsfzr(); break;
  163. case "技术负责人手机" : o = ob.getJsfsj(); break;
  164. case "需求名称" : o = ob.getXqmc(); break;
  165. case "需求类别" : o = ob.getXqbl(); break;
  166. case "技术需求类型" : o = ob.getJsxqlx(); break;
  167. case "需求领域" : o = ob.getXqly(); break;
  168. case "目前产品技术现状" : o = ob.getMqcpjsxz(); break;
  169. case "研发难点" : o = ob.getYfnd(); break;
  170. case "预期达到的效果(主要技术指标、技术成熟度、条件、成本等)" : o = ob.getYqdddxg(); break;
  171. case "已经开展的工作" : o = ob.getYjzkdgz(); break;
  172. case "现有研发条件情况(人员情况、仪器设备投入等)" : o = ob.getXyyftjqk(); break;
  173. case "目前合作对象情况(合作对象、方式、已投入研发资金情况等)" : o = ob.getMqhzdxqk(); break;
  174. case "是否有下一步合作需求" : o = ob.getSfyxybhzxq(); break;
  175. case "意向合作对象" : o = ob.getYxhzdx(); break;
  176. case "合作单位名称" : o = ob.getYxhzdxValue(); break;
  177. case "拟采取的合作方式" : o = ob.getNcqdhzfs(); break;
  178. case "需求解决截止时间" : o = ob.getXqjjjzsj(); break;
  179. case "为解决技术难题能提供的合作资金" : o = ob.getWjjjsntntgdhzzj(); break;
  180. case "资金用途" : o = ob.getZjyt(); break;
  181. case "资金缺口" : o = ob.getZjqk(); break;
  182. case "需求解决方式" : o = ob.getXqjjfs(); break;
  183. case "企业产品是否有销往国外": o = ob.getSfxwgw(); break;
  184. case "企业产品是否有意向出口": o = ob.getSfyxck(); break;
  185. case "创建时间": o = ob.getCreateTime(); break;
  186. default: o = ""; break;
  187. }
  188. XSSFCell c = r.createCell(i);
  189. c.setCellStyle(styleTitle);
  190. c.setCellValue(o);
  191. }
  192. x++;
  193. }
  194. //返回名称及参数
  195. response.addHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(),"iso-8859-1"));
  196. response.setContentType("application/octet-stream;charset=utf-8");
  197. // 返回数据流
  198. wb.write(out);
  199. out.flush();
  200. out.close();
  201. } catch (Exception e) {
  202. logger.error(e.getLocalizedMessage());
  203. throw new BusinessException(new Error("表格生成错误。"));
  204. }finally {
  205. out.flush();
  206. out.close();
  207. }
  208. }
  209. }