unit_price_model.js 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195
  1. /**
  2. * 单价业务模型
  3. *
  4. * @author CaiAoLin
  5. * @date 2017/6/30
  6. * @version
  7. */
  8. import BaseModel from "../../common/base/base_model"
  9. import GLJTypeConst from "../../common/const/glj_type_const"
  10. import CounterModel from "./counter_model"
  11. import {default as UnitPriceSchema, collectionName as collectionName} from "./schemas/unit_price";
  12. class UnitPriceModel extends BaseModel {
  13. /**
  14. * 构造函数
  15. *
  16. * @return {void}
  17. */
  18. constructor() {
  19. let parent = super();
  20. parent.model = UnitPriceSchema;
  21. parent.init();
  22. }
  23. /**
  24. * 根据单价文件id获取单价数据
  25. *
  26. * @param {Number} fileId
  27. * @return {Promise}
  28. */
  29. async getDataByFileId(fileId) {
  30. fileId = parseInt(fileId);
  31. if (isNaN(fileId) || fileId <= 0) {
  32. return null;
  33. }
  34. let unitPriceList = await this.db.model.find({unit_price_file_id: fileId});
  35. if (unitPriceList.length <= 0) {
  36. return null;
  37. }
  38. // 整理数据
  39. let result = {};
  40. for(let tmp of unitPriceList) {
  41. result[tmp.code + tmp.name] = tmp;
  42. }
  43. return result;
  44. }
  45. /**
  46. * 设置场景
  47. *
  48. * @param {string} scene
  49. * @return {void}
  50. */
  51. setScene(scene = '') {
  52. switch (scene) {
  53. // 新增数据的验证规则
  54. case 'add':
  55. this.model.schema.path('base_price').required(true);
  56. this.model.schema.path('market_price').required(true);
  57. this.model.schema.path('name').required(true);
  58. this.model.schema.path('code').required(true);
  59. this.model.schema.path('unit').required(true);
  60. this.model.schema.path('type').required(true);
  61. this.model.schema.path('unit_price_file_id').required(true);
  62. }
  63. }
  64. /**
  65. * 新增单价数据
  66. *
  67. * @param {Object} data
  68. * @param {Number} unitPriceFileId
  69. * @param {Number} gljCount
  70. * @return {Promise} 返回数据以及是否新增
  71. */
  72. async addUnitPrice(data, unitPriceFileId, gljCount = 0) {
  73. if (data.code === undefined || data.project_id === undefined || data.name === undefined
  74. || data.market_price === undefined) {
  75. return [null, false];
  76. }
  77. // 先查找是否有同code的单价记录 @todo 后续可能会加入单位这个字段进一步确定唯一性
  78. let unitPriceData = await this.findDataByCondition({code: data.code, unit_price_file_id: unitPriceFileId}, null, false);
  79. // 如果有记录,判断是否存在一样的市场单价,有则直接返回数据
  80. let unitPriceIndex = this.isPriceIncluded(unitPriceData, data.market_price);
  81. if (unitPriceData && unitPriceIndex >= 0) {
  82. return [unitPriceData[unitPriceIndex], false];
  83. }
  84. // 如果不存在基价单价,则在数据源中获取
  85. if (data.base_price === undefined) {
  86. let firstUnitPrice = unitPriceData[0] !== undefined ? unitPriceData[0] : [];
  87. data.base_price = firstUnitPrice.base_price !== undefined ? firstUnitPrice.base_price : 0;
  88. data.type = firstUnitPrice.type !== undefined ? firstUnitPrice.type : 0;
  89. data.unit = firstUnitPrice.unit !== undefined ? firstUnitPrice.unit : 0;
  90. }
  91. // 更改名称
  92. if (gljCount > 0) {
  93. let regular = /\(\d\)/;
  94. let changeString = '(' + gljCount + ')';
  95. data.name = regular.test(data.name) ? data.name.replace(regular, changeString) :
  96. data.name + changeString;
  97. }
  98. let insertData = {
  99. code: data.code,
  100. base_price: data.base_price,
  101. market_price: data.market_price,
  102. unit_price_file_id: unitPriceFileId,
  103. name: data.name,
  104. type: data.type,
  105. unit: data.unit
  106. };
  107. let addPriceResult = await this.add(insertData);
  108. return [addPriceResult, true];
  109. }
  110. /**
  111. * 新增记录
  112. *
  113. * @param {object} data
  114. * @return {Promise}
  115. */
  116. async add(data) {
  117. let counterModel = new CounterModel();
  118. let unitPriceId = await counterModel.getId(collectionName);
  119. data.id = unitPriceId;
  120. this.setScene('add');
  121. return this.db.model.create(data);
  122. }
  123. /**
  124. * 判断数据中是否包含某个市场价格的记录
  125. *
  126. * @param {Array} data
  127. * @param {Number} price
  128. * @return {Number}
  129. */
  130. isPriceIncluded(data, price) {
  131. let index = -1;
  132. if (data.length <= 0) {
  133. return index;
  134. }
  135. for(let tmp in data) {
  136. if (data[tmp].market_price === price) {
  137. index = tmp;
  138. break;
  139. }
  140. }
  141. return index;
  142. }
  143. /**
  144. * 更新市场单价
  145. *
  146. * @param {Number} id
  147. * @param {Object} updateData
  148. * @return {Promise}
  149. */
  150. async updatePriceById(id, updateData) {
  151. id = parseInt(id);
  152. if (isNaN(id) || id <= 0 || Object.keys(updateData).length <= 0) {
  153. return false;
  154. }
  155. // 首先查找相应的数据判断工料机类型
  156. let unitPriceData = await this.findDataByCondition({id: id});
  157. if (!unitPriceData) {
  158. throw '找不到对应的单价数据';
  159. }
  160. // 基价单价的计算
  161. switch (unitPriceData.type) {
  162. // 主材、设备自动赋值基价单价=市场单价
  163. case GLJTypeConst.MAIN_MATERIAL:
  164. case GLJTypeConst.EQUIPMENT:
  165. updateData.base_price = updateData.market_price;
  166. break;
  167. }
  168. let result = await this.updateById(id, updateData);
  169. return result;
  170. }
  171. }
  172. export default UnitPriceModel;