base_bills_service.js 9.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. 'use strict';
  2. /**
  3. *
  4. *
  5. * @author Mai
  6. * @date
  7. * @version
  8. */
  9. const TreeService = require('./base_tree_service');
  10. // sql拼装器
  11. const rootId = -1;
  12. class BaseBillsSerivce extends TreeService {
  13. /**
  14. * 从标准数据中提取有效数据
  15. * @param {Object} stdData - 从标准库中查询所得
  16. * @returns {name, unit, source, code, b_code}
  17. * @private
  18. */
  19. _filterStdData(stdData) {
  20. const result = {
  21. name: stdData.name,
  22. unit: stdData.unit,
  23. source: stdData.source,
  24. node_type: stdData.node_type,
  25. };
  26. result.code = stdData.code ? stdData.code : '';
  27. result.b_code = stdData.b_code ? stdData.b_code : '';
  28. return result;
  29. }
  30. async addBillsNode(tenderId, selectId, data, reviseId) {
  31. if (data) {
  32. if (reviseId) data.crid = reviseId;
  33. return await this.addNode(tenderId, selectId, data);
  34. } else {
  35. return await this.addNode(tenderId, selectId, {crid: reviseId});
  36. }
  37. }
  38. /**
  39. * 新增子节点,并排在所有子节点的末尾
  40. * @param {Number} tenderId - 标段Id
  41. * @param {Number} selectId - 父节点Id
  42. * @param {Object} data - 新增节点数据(编号名称等)
  43. * @returns {Promise<*>}
  44. */
  45. async addChild(tenderId, selectId, data, reviseId) {
  46. if ((tenderId <= 0) || (selectId <= 0)) {
  47. return [];
  48. }
  49. const selectData = await this.getDataByKid(tenderId, selectId);
  50. if (!selectData) {
  51. throw '新增节点数据错误';
  52. }
  53. const children = await this.getChildrenByParentId(tenderId, selectId);
  54. const maxId = await this._getMaxLid(tenderId);
  55. data.id = this.uuid.v4();
  56. data.tender_id = tenderId;
  57. data.ledger_id = maxId + 1;
  58. data.ledger_pid = selectData.ledger_id;
  59. data.level = selectData.level + 1;
  60. data.order = children.length + 1;
  61. data.full_path = selectData.full_path + '-' + data.ledger_id;
  62. data.is_leaf = true;
  63. if (reviseId) data.crid = reviseId;
  64. this.transaction = await this.db.beginTransaction();
  65. try {
  66. const result = await this.transaction.insert(this.tableName, data);
  67. if (children.length === 0) {
  68. await this.transaction.update(this.tableName,
  69. {is_leaf: false, quantity: null, unit_price: null, total_price: null, deal_qty: null, deal_tp: null},
  70. { where: {tender_id: tenderId, ledger_id: selectData.ledger_id} });
  71. }
  72. await this.transaction.commit();
  73. } catch(err) {
  74. this.transaction.rollback();
  75. throw err;
  76. }
  77. this._cacheMaxLid(tenderId, maxId + 1);
  78. // 查询应返回的结果
  79. const resultData = {};
  80. resultData.create = await this.getDataByKid(tenderId, data.ledger_id);
  81. if (children.length === 0) {
  82. resultData.update = await this.getDataByKid(tenderId, selectId);
  83. }
  84. return resultData;
  85. }
  86. /**
  87. * 添加节点(来自标准清单)
  88. * @param {Number} tenderId
  89. * @param {Number} selectId
  90. * @param {Object} stdData
  91. * @return {Promise<*>}
  92. */
  93. async addStdNode(tenderId, selectId, stdData, reviseId) {
  94. const newData = this._filterStdData(stdData);
  95. const result = await this.addBillsNode(tenderId, selectId, newData, reviseId);
  96. return result;
  97. }
  98. /**
  99. * 添加标准节点,将选择的标准节点,添加为子节点(排序为末尾)
  100. * @param {Number} tenderId - 标段Id
  101. * @param {Number} selectId - 添加目标节点Id
  102. * @param {Object} stdData - 标准节点数据
  103. * @returns {Promise<*>}
  104. */
  105. async addStdNodeAsChild(tenderId, selectId, stdData, reviseId) {
  106. const newData = this._filterStdData(stdData);
  107. const result = await this.addChild(tenderId, selectId, newData, reviseId);
  108. return result;
  109. }
  110. /**
  111. * 根据parentData, data新增数据(新增为parentData的最后一个子项)
  112. * @param {Number} tenderId - 标段id
  113. * @param {Object} parentData - 父项数据
  114. * @param {Object} data - 新增节点,初始数据
  115. * @return {Promise<*>} - 新增结果
  116. * @private
  117. */
  118. async _addChildNodeData(tenderId, parentData, data, reviseId) {
  119. if (tenderId <= 0) {
  120. return undefined;
  121. }
  122. if (!data) {
  123. data = {};
  124. }
  125. const pid = parentData ? parentData.ledger_id : rootId;
  126. const maxId = await this._getMaxLid(tenderId);
  127. data.id = this.uuid.v4();
  128. data.tender_id = tenderId;
  129. data.ledger_id = maxId + 1;
  130. data.ledger_pid = pid;
  131. if (data.order === undefined) {
  132. data.order = 1;
  133. }
  134. data.level = parentData ? parentData.level + 1 : 1;
  135. data.full_path = parentData ? parentData.full_path + '-' + data.ledger_id : '' + data.ledger_id;
  136. if (data.is_leaf === undefined) {
  137. data.is_leaf = true;
  138. }
  139. if (reviseId) data.crid = reviseId;
  140. const result = await this.transaction.insert(this.tableName, data);
  141. this._cacheMaxLid(tenderId, maxId + 1);
  142. return [result, data];
  143. }
  144. /**
  145. * 根据parentData, data新增数据(自动排序)
  146. * @param tenderId
  147. * @param parentData
  148. * @param data
  149. * @return {Promise<void>}
  150. * @private
  151. */
  152. async _addChildAutoOrder(tenderId, parentData, data, reviseId) {
  153. const self = this;
  154. const findPreData = function(list, a) {
  155. if (!list || list.length === 0) { return null; }
  156. for (let i = 0, iLen = list.length; i < iLen; i++) {
  157. if (self.ctx.helper.compareCode(list[i].code, a.code) > 0) {
  158. return i > 0 ? list[i - 1] : null;
  159. }
  160. }
  161. return list[list.length - 1];
  162. };
  163. const pid = parentData ? parentData.ledger_id : rootId;
  164. const children = await this.getChildrenByParentId(tenderId, pid);
  165. const preData = findPreData(children, data);
  166. if (!preData || children.indexOf(preData) < children.length - 1) {
  167. await this._updateChildrenOrder(tenderId, pid, preData ? preData.order + 1 : 1);
  168. }
  169. data.order = preData ? preData.order + 1 : 1;
  170. const [addResult, node] = await this._addChildNodeData(tenderId, parentData, data, reviseId);
  171. return [addResult, node];
  172. }
  173. /**
  174. * 添加节点,并同步添加父节点
  175. * @param {Number} tenderId - 标段id
  176. * @param {Number} selectId - 选中节点id
  177. * @param {Object} stdData - 节点数据
  178. * @param {StandardLib} stdLib - 标准库
  179. * @return {Promise<void>}
  180. */
  181. async addStdNodeWithParent(tenderId, stdData, stdLib, reviseId) {
  182. // 查询完整标准清单,并按层次排序
  183. const fullLevel = await stdLib.getFullLevelDataByFullPath(stdData.list_id, stdData.full_path);
  184. fullLevel.sort(function(x, y) {
  185. return x.level - y.level;
  186. });
  187. let isNew = false,
  188. node,
  189. firstNew,
  190. updateParent,
  191. addResult;
  192. const expandIds = [];
  193. this.transaction = await this.db.beginTransaction();
  194. try {
  195. // 从最顶层节点依次查询是否存在,否则添加
  196. for (let i = 0, len = fullLevel.length; i < len; i++) {
  197. const stdNode = fullLevel[i];
  198. if (isNew) {
  199. const newData = this._filterStdData(stdNode);
  200. newData.is_leaf = (i === len - 1);
  201. [addResult, node] = await this._addChildNodeData(tenderId, node, newData, reviseId);
  202. } else {
  203. const parent = node;
  204. node = await this.getDataByCondition({
  205. tender_id: tenderId,
  206. ledger_pid: parent ? parent.ledger_id : rootId,
  207. code: stdNode.code,
  208. name: stdNode.name,
  209. });
  210. if (!node) {
  211. isNew = true;
  212. const newData = this._filterStdData(stdNode);
  213. newData.is_leaf = (i === len - 1);
  214. [addResult, node] = await this._addChildAutoOrder(tenderId, parent, newData, reviseId);
  215. if (parent && parent.is_leaf) {
  216. await this.transaction.update(this.tableName, { id: parent.id, is_leaf: false,
  217. unit_price: null, quantity: null, total_price: null, deal_qty: null, deal_tp: null});
  218. updateParent = parent;
  219. }
  220. firstNew = node;
  221. } else {
  222. expandIds.push(node.ledger_id);
  223. }
  224. }
  225. }
  226. await this.transaction.commit();
  227. } catch (err) {
  228. await this.transaction.rollback();
  229. throw err;
  230. }
  231. // 查询应返回的结果
  232. let createData = [],
  233. updateData = [];
  234. if (firstNew) {
  235. createData = await this.getDataByFullPath(tenderId, firstNew.full_path + '%');
  236. updateData = await this.getNextsData(tenderId, firstNew.ledger_pid, firstNew.order);
  237. if (updateParent) {
  238. updateData.push(await this.getDataByCondition({ id: updateParent.id }));
  239. }
  240. }
  241. return { create: createData, update: updateData };
  242. }
  243. }
  244. module.exports = BaseBillsSerivce;