engineering_lib_model.js 6.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236
  1. /**
  2. * 计价规则标准库业务逻辑
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/8/31
  6. * @version
  7. */
  8. import mongoose from "mongoose";
  9. import BaseModel from "../../common/base/base_model";
  10. import CompilationModel from "./compilation_model";
  11. import {default as EngineeringConst, List as EngineeringList} from "../../common/const/engineering";
  12. class EngineeringLibModel extends BaseModel {
  13. /**
  14. * 构造函数
  15. *
  16. * @return {void}
  17. */
  18. constructor() {
  19. let parent = super();
  20. parent.model = mongoose.model("engineering_lib");
  21. parent.init();
  22. }
  23. /**
  24. * 获取标准库数据
  25. *
  26. * @param {Object} data
  27. * @param {Number} engineering
  28. * @return {Promise}
  29. */
  30. async getLib(data, engineering) {
  31. let result = {};
  32. if (data.length <= 0) {
  33. return result;
  34. }
  35. let id = '';
  36. for(let tmp of data) {
  37. if (tmp.engineering === engineering) {
  38. id = tmp.engineering_id;
  39. break;
  40. }
  41. }
  42. if (id === '') {
  43. return result;
  44. }
  45. let condition = {_id: id};
  46. return this.findDataByCondition(condition);
  47. }
  48. /**
  49. * 新增标准库
  50. *
  51. * @param {String} valuationId
  52. * @param {Object} data
  53. * @return {Promise}
  54. */
  55. async addLib(valuationId, data) {
  56. if (data.main_tree_col) {
  57. data.main_tree_col = JSON.parse(data.main_tree_col);
  58. } else {
  59. data.main_tree_col = {
  60. emptyRows: 3,
  61. headRows: 0,
  62. treeCol: 0,
  63. headRowHeight: [],
  64. cols:[]
  65. }
  66. }
  67. if(data.glj_col){
  68. data.glj_col = JSON.parse(data.glj_col);
  69. }
  70. let result = false;
  71. data = this.filterLibData(data);
  72. try {
  73. // 查找计价规则表中是否有对应工程专业标准库的数据
  74. let compilationModel = new CompilationModel();
  75. let engineeringLib = await compilationModel.getEngineeringLib(valuationId, data.section, data.engineering);
  76. if (engineeringLib === null) {
  77. // 不存在则插入
  78. result = await this.db.create(data);
  79. console.log(data);
  80. } else {
  81. delete data.id;
  82. delete data.section;
  83. delete data.engineering;
  84. console.log(`data==============================================`);
  85. console.log(data);
  86. // 存在则直接更新
  87. let condition = {_id: engineeringLib.engineering_id};
  88. result = await this.db.update(condition, data);
  89. result = result.ok === 1;
  90. }
  91. // 失败直接返回
  92. if (!result) {
  93. throw '操作失败';
  94. }
  95. // 新增后更新编办数据表中专业工程字段
  96. if (result && engineeringLib === null) {
  97. let insertData = {
  98. engineering: data.engineering,
  99. engineering_id: result._id
  100. };
  101. let updateResult = await compilationModel.addEngineeringLib(valuationId, data.section, insertData);
  102. if (!updateResult) {
  103. throw '新增编办数据中的专业工程失败!';
  104. }
  105. }
  106. } catch (error) {
  107. console.log(error);
  108. result = false;
  109. }
  110. return result;
  111. }
  112. /**
  113. * 过滤计价数据
  114. *
  115. * @param {Object} data
  116. * @return {Object}
  117. */
  118. filterLibData(data) {
  119. if (Object.keys(data).length <= 0 || data.section === undefined) {
  120. console.log('1');
  121. throw '数据有误';
  122. }
  123. // 检测专业工程是否合法
  124. data.engineering = parseInt(data.engineering);
  125. let match = false;
  126. for(let index in EngineeringConst) {
  127. if (EngineeringConst[index] === data.engineering) {
  128. match = true;
  129. break;
  130. }
  131. }
  132. if (!match) {
  133. throw '工程专业错误';
  134. }
  135. // 判断标准清单
  136. data.bill_lib = this._validLib(data.bill_lib);
  137. // 判断定额库
  138. data.ration_lib = this._validLib(data.ration_lib);
  139. // 判断工料机库
  140. data.glj_lib = this._validLib(data.glj_lib);
  141. // 判断清单指引库
  142. data.billsGuidance_lib = this._validLib(data.billsGuidance_lib);
  143. // 判断费率标准
  144. data.fee_lib = this._validLib(data.fee_lib);
  145. // 判断人工系数
  146. data.artificial_lib = this._validLib(data.artificial_lib);
  147. // 判断计算程序
  148. data.program_lib = this._validLib(data.program_lib);
  149. return data;
  150. }
  151. /**
  152. * 校验库数据
  153. *
  154. * @param {Object} libData
  155. * @return {Object}
  156. */
  157. _validLib(libData) {
  158. let result = [];
  159. // 判断标准库
  160. if (libData === undefined || libData ===null ||libData === '') {
  161. return result;//throw '标准库不能为空'; 按新需求,标准库等不做非空判断
  162. }
  163. libData = libData instanceof Array ? libData : [libData];
  164. for(let tmp in libData) {
  165. result[tmp] = JSON.parse(libData[tmp]);
  166. }
  167. return result;
  168. }
  169. /**
  170. * 获取对应标准库数量
  171. *
  172. * @param {Object} valuationData
  173. * @return {Object}
  174. */
  175. async getLibCount(valuationData) {
  176. let result = {};
  177. if (valuationData.engineering_list === undefined || valuationData.engineering_list.length <= 0) {
  178. return result;
  179. }
  180. // 整理需要查找的数据
  181. let findIdList = [];
  182. for(let engineering of valuationData.engineering_list) {
  183. findIdList.push(engineering.engineering_id);
  184. }
  185. let condition = {_id: {$in: findIdList}};
  186. let libData = await this.findDataByCondition(condition, null, false);
  187. if (libData === null) {
  188. return result;
  189. }
  190. // 整理数据
  191. let countData = {};
  192. for(let tmp of libData) {
  193. countData[tmp._id] = {
  194. bill_count: tmp.bill_lib.length,
  195. ration_count: tmp.ration_lib.length,
  196. glj_count: tmp.glj_lib.length,
  197. fee_count: tmp.fee_lib.length,
  198. artificial_count: tmp.artificial_lib.length,
  199. program_count: tmp.program_lib.length,
  200. };
  201. }
  202. for(let engineering of valuationData.engineering_list) {
  203. if (countData[engineering.engineering_id] !== undefined) {
  204. result[engineering.engineering] = countData[engineering.engineering_id];
  205. }
  206. }
  207. return result;
  208. }
  209. }
  210. export default EngineeringLibModel;