libController.js 6.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Zhong
  6. * @date 2018/5/29
  7. * @version
  8. */
  9. import BaseController from '../../common/base/base_controller';
  10. import moment from 'moment';
  11. const billsGuidanceFacade = require('../facade/facades');
  12. let logger = require('../../../logs/log_helper').logger;
  13. const fs = require("fs");
  14. // excel解析
  15. const excel = require("node-xlsx");
  16. let callback = function (req, res, err, msg, data) {
  17. res.json({error: err, message: msg, data: data});
  18. };
  19. const zhLibID = 'cf851660-3534-11ec-9641-2da8021b8e4e';
  20. class BillsGuideLibController extends BaseController{
  21. //获取编办及编办清单库信息
  22. async getComBillsLibInfo(req, res){
  23. try{
  24. let comBillsLibInfo = await billsGuidanceFacade.getComBillsLibInfo();
  25. callback(req, res, 0, '', comBillsLibInfo);
  26. }
  27. catch(err) {
  28. callback(req, res, 1, err, null);
  29. }
  30. }
  31. async getBillsGuideLibs(req, res){
  32. try{
  33. let libs = await billsGuidanceFacade.getBillsGuideLibs({deleted: false}, req.session.managerData.isTemporary);
  34. callback(req, res, 0, '', libs);
  35. }
  36. catch(err){
  37. callback(req, res, 1, '获取清单指引库数据错误', null);
  38. }
  39. }
  40. async updateBillsGuideLib(req, res){
  41. try{
  42. let data = JSON.parse(req.body.data);
  43. if(data.updateType === 'create'){
  44. data.updateData.createDate = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss');
  45. data.updateData.creator = req.session.managerData.username;
  46. await billsGuidanceFacade.initBillsGuideLib(data.updateData);
  47. }
  48. else{
  49. if (data.updateType === 'delete') {
  50. logger.info(`delete billsGuidanceLib ${req.ip}`);
  51. }
  52. await billsGuidanceFacade.updateBillsGuideLib(data);
  53. }
  54. callback(req, res, 0, '', data.updateData);
  55. }
  56. catch(err){
  57. callback(req, res, 1, '更新失败', null);
  58. }
  59. }
  60. //获取清单指引库和该库引用的清单
  61. async getLibWithBills(req, res){
  62. try{
  63. let data = JSON.parse(req.body.data);
  64. let rst = await billsGuidanceFacade.getLibWithBills(data.libID);
  65. callback(req, res, 0, '', rst);
  66. }
  67. catch(err){
  68. callback(req, res, 1, err, null);
  69. }
  70. }
  71. async getItemsByBills(req, res){
  72. try{
  73. let data = JSON.parse(req.body.data);
  74. let items = await billsGuidanceFacade.getItemsBybills(data.guidanceLibID, data.billsID);
  75. callback(req, res, 0, '', items);
  76. }
  77. catch(err){
  78. callback(req, res, 1, err, null);
  79. }
  80. }
  81. async getItemsByBillIDs(req, res){
  82. try{
  83. let data = JSON.parse(req.body.data);
  84. let items = await billsGuidanceFacade.getItemsByBillIDs(data.guidanceLibID, data.billIDs);
  85. callback(req, res, 0, '', items);
  86. }
  87. catch(err){
  88. callback(req, res, 1, err, null);
  89. }
  90. }
  91. async updateItems(req, res){
  92. try{
  93. if (req.session.managerData.isTemporary) {
  94. const match = req.headers.referer.match(/libID=([\d,a-z,A-Z,-]{36})/);
  95. if (match && match[1] && match[1] !== zhLibID) {
  96. throw '无此清单精灵库权限';
  97. }
  98. }
  99. let data = JSON.parse(req.body.data);
  100. let updateDatas = data.updateDatas;
  101. await billsGuidanceFacade.updateItems(updateDatas, req.session.managerData.isTemporary);
  102. callback(req, res, 0, '', null);
  103. }
  104. catch(err){
  105. callback(req, res, 1, err, null);
  106. }
  107. }
  108. async getBillMaterials(req, res){
  109. try{
  110. const data = JSON.parse(req.body.data);
  111. const materials = await billsGuidanceFacade.getBillMaterials(data.libID, data.billID);
  112. callback(req, res, 0, '', materials);
  113. }
  114. catch(err){
  115. callback(req, res, 1, err, null);
  116. }
  117. }
  118. async editBillMaterials(req, res){
  119. try{
  120. const data = JSON.parse(req.body.data);
  121. const materials = await billsGuidanceFacade.editBillMaterials(data.libID, data.billID, data.gljCodes, data.compilationID);
  122. callback(req, res, 0, '', materials);
  123. }
  124. catch(err){
  125. console.log(err);
  126. callback(req, res, 1, err.message, []);
  127. }
  128. }
  129. async generateClassData(req, res) {
  130. try{
  131. res.setTimeout(1000 * 60 * 10); // 不设置的话,处理时间过长,会触发默认的响应超时,报错(前端报错,后台还继续在处理)
  132. const data = JSON.parse(req.body.data);
  133. await billsGuidanceFacade.generateClassData(data.libID);
  134. callback(req, res, 0, '', []);
  135. }
  136. catch(err){
  137. console.log(err);
  138. callback(req, res, 1, err.message, []);
  139. }
  140. }
  141. async exportClassExcel(req, res) {
  142. try{
  143. const excelData = await billsGuidanceFacade.getClassExcelData(req.query.libID);
  144. console.log('start-build');
  145. const buffer = excel.build([{name: "清单分类库", data: excelData}], {'!cols': [{wch:6}, {wch:12}, {wch:14}, {wch:24}, {wch:45}, {wch:20}, {wch:30}, {wch:30}]});
  146. console.log('end-build');
  147. const filePath = './public/export.xlsx';
  148. fs.writeFileSync(filePath, buffer, 'binary');
  149. const stats = fs.statSync(filePath);
  150. // 下载相关header
  151. res.set({
  152. 'Content-Type': 'application/octet-stream',
  153. 'Content-Disposition': 'attachment; filename=billClass.xlsx',
  154. 'Content-Length': stats.size
  155. });
  156. fs.createReadStream(filePath).pipe(res);
  157. fs.unlink(filePath);
  158. }
  159. catch(err){
  160. console.log(err);
  161. response.end(error);
  162. }
  163. }
  164. async testItems(req, res){
  165. try{
  166. let data = JSON.parse(req.body.data);
  167. let rst = await billsGuidanceFacade.testItems(data.libID);
  168. res.json({error: 0, data: rst, message: ''});
  169. }
  170. catch (error){
  171. res.json({error: 1, data: null, message: error});
  172. }
  173. }
  174. }
  175. export default BillsGuideLibController;