unit_price_model.js 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220
  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. data.market_price = parseFloat(data.market_price);
  81. let unitPriceIndex = this.isPriceIncluded(unitPriceData, data.market_price);
  82. if (unitPriceData && unitPriceIndex >= 0) {
  83. return [unitPriceData[unitPriceIndex], false];
  84. }
  85. // 如果不存在基价单价,则在数据源中获取
  86. if (data.base_price === undefined) {
  87. let firstUnitPrice = unitPriceData[0] !== undefined ? unitPriceData[0] : [];
  88. data.base_price = firstUnitPrice.base_price !== undefined ? firstUnitPrice.base_price : 0;
  89. data.type = firstUnitPrice.type !== undefined ? firstUnitPrice.type : 0;
  90. data.unit = firstUnitPrice.unit !== undefined ? firstUnitPrice.unit : 0;
  91. }
  92. // 更改名称
  93. if (gljCount > 0) {
  94. let regular = /\(\d+\)/;
  95. let changeString = '(' + gljCount + ')';
  96. data.name = regular.test(data.name) ? data.name.replace(regular, changeString) :
  97. data.name + changeString;
  98. }
  99. let insertData = {
  100. code: data.code,
  101. base_price: data.base_price,
  102. market_price: data.market_price,
  103. unit_price_file_id: unitPriceFileId,
  104. name: data.name,
  105. type: data.type,
  106. unit: data.unit
  107. };
  108. let addPriceResult = await this.add(insertData);
  109. return [addPriceResult, true];
  110. }
  111. /**
  112. * 新增记录
  113. *
  114. * @param {object} data
  115. * @return {Promise}
  116. */
  117. async add(data) {
  118. let counterModel = new CounterModel();
  119. if (data instanceof Array) {
  120. // 如果是批量新增
  121. for(let tmp in data) {
  122. data[tmp].id = await counterModel.getId(collectionName);
  123. }
  124. } else {
  125. data.id = await counterModel.getId(collectionName);
  126. }
  127. this.setScene('add');
  128. return this.db.model.create(data);
  129. }
  130. /**
  131. * 判断数据中是否包含某个市场价格的记录
  132. *
  133. * @param {Array} data
  134. * @param {Number} price
  135. * @return {Number}
  136. */
  137. isPriceIncluded(data, price) {
  138. let index = -1;
  139. if (data.length <= 0) {
  140. return index;
  141. }
  142. for(let tmp in data) {
  143. if (data[tmp].market_price === price) {
  144. index = tmp;
  145. break;
  146. }
  147. }
  148. return index;
  149. }
  150. /**
  151. * 更新市场单价
  152. *
  153. * @param {Object} condition
  154. * @param {Object} updateData
  155. * @param {String} extend
  156. * @return {Promise}
  157. */
  158. async updatePrice(condition, updateData, extend = '') {
  159. if (Object.keys(condition).length <= 0 || Object.keys(updateData).length <= 0) {
  160. return false;
  161. }
  162. // 首先查找相应的数据判断工料机类型
  163. let unitPriceData = await this.findDataByCondition(condition);
  164. if (!unitPriceData) {
  165. throw '找不到对应的单价数据';
  166. }
  167. // 基价单价的计算
  168. switch (unitPriceData.type) {
  169. // 主材、设备自动赋值基价单价=市场单价
  170. case GLJTypeConst.MAIN_MATERIAL:
  171. case GLJTypeConst.EQUIPMENT:
  172. updateData.base_price = updateData.market_price;
  173. break;
  174. }
  175. // 额外更新数据
  176. if (extend !== '') {
  177. extend = JSON.parse(extend);
  178. for (let code in extend) {
  179. let extendUpdateData = {
  180. market_price: extend[code].market_price,
  181. };
  182. let tmpCondition = {
  183. unit_price_file_id: unitPriceData.unit_price_file_id,
  184. code: code
  185. };
  186. let extendResult = await this.db.update(tmpCondition, extendUpdateData);
  187. if (!extendResult) {
  188. throw '更新额外数据,编码为' + code + '的数据失败!';
  189. }
  190. }
  191. }
  192. let result = await this.db.update(condition, updateData);
  193. return result.ok !== undefined && result.ok === 1;
  194. }
  195. }
  196. export default UnitPriceModel;