libController.js 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179
  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 updateItems(req, res){
  82. try{
  83. if (req.session.managerData.isTemporary) {
  84. const match = req.headers.referer.match(/libID=([\d,a-z,A-Z,-]{36})/);
  85. if (match && match[1] && match[1] !== zhLibID) {
  86. throw '无此清单精灵库权限';
  87. }
  88. }
  89. let data = JSON.parse(req.body.data);
  90. let updateDatas = data.updateDatas;
  91. await billsGuidanceFacade.updateItems(updateDatas, req.session.managerData.isTemporary);
  92. callback(req, res, 0, '', null);
  93. }
  94. catch(err){
  95. callback(req, res, 1, err, null);
  96. }
  97. }
  98. async getBillMaterials(req, res){
  99. try{
  100. const data = JSON.parse(req.body.data);
  101. const materials = await billsGuidanceFacade.getBillMaterials(data.libID, data.billID);
  102. callback(req, res, 0, '', materials);
  103. }
  104. catch(err){
  105. callback(req, res, 1, err, []);
  106. }
  107. }
  108. async editBillMaterials(req, res){
  109. try{
  110. const data = JSON.parse(req.body.data);
  111. const materials = await billsGuidanceFacade.editBillMaterials(data.libID, data.billID, data.gljCodes, data.compilationID);
  112. callback(req, res, 0, '', materials);
  113. }
  114. catch(err){
  115. console.log(err);
  116. callback(req, res, 1, err.message, []);
  117. }
  118. }
  119. async generateClassData(req, res) {
  120. try{
  121. const data = JSON.parse(req.body.data);
  122. await billsGuidanceFacade.generateClassData(data.libID);
  123. callback(req, res, 0, '', []);
  124. }
  125. catch(err){
  126. console.log(err);
  127. callback(req, res, 1, err.message, []);
  128. }
  129. }
  130. async exportClassExcel(req, res) {
  131. try{
  132. const excelData = await billsGuidanceFacade.getClassExcelData(req.query.libID);
  133. const buffer = excel.build([{name: "清单分类库", data: excelData}], {'!cols': [{wch:6}, {wch:12},{wch:14},{wch:24}, {wch:45}]});
  134. const filePath = './public/export.xlsx';
  135. fs.writeFileSync(filePath, buffer, 'binary');
  136. const stats = fs.statSync(filePath);
  137. // 下载相关header
  138. res.set({
  139. 'Content-Type': 'application/octet-stream',
  140. 'Content-Disposition': 'attachment; filename=billClass.xlsx',
  141. 'Content-Length': stats.size
  142. });
  143. fs.createReadStream(filePath).pipe(res);
  144. fs.unlink(filePath);
  145. }
  146. catch(err){
  147. console.log(err);
  148. response.end(error);
  149. }
  150. }
  151. async testItems(req, res){
  152. try{
  153. let data = JSON.parse(req.body.data);
  154. let rst = await billsGuidanceFacade.testItems(data.libID);
  155. res.json({error: 0, data: rst, message: ''});
  156. }
  157. catch (error){
  158. res.json({error: 1, data: null, message: error});
  159. }
  160. }
  161. }
  162. export default BillsGuideLibController;