'use strict'; /** * * * @author Mai * @date * @version */ const changeSort = { name: '变更令排序', hint: '默认的变更令排序,同时对变更令,变更清单进行排序\n' + '变更令排序勿需勾选任何预定义处理指标,但是在指标映射中,需要添加如下指标:' + '1. 如果只有变更令数据,则必须添加,"变更令(change)"下的"变更令号"' + '2. 如果有变更清单需要排序,则必须在1的基础上添加,变更令(change)"下的"变更令uuid"和"变更清单(chang_audit_list)"下的"所属变更令uuid"&"清单编号"', /** * * @param ctx - context常量 * @param data - 全部数据源{Array} * @param fieldsKey - 计算字段 */ fun: function(ctx, data, fieldsKey) { if (!data.change) return; // 变更令排序 data.change.sort(function (a, b) { return a.code.localeCompare(b.code); }); if (data.change_audit_list) { data.change_audit_list.sort(function (a, b) { const aCIndex = data.change.findIndex(function (c) { return c.cid === a.cid; }); const bCIndex = data.change.findIndex(function (c) { return c.cid === b.cid; }); return aCIndex === bCIndex ? ctx.helper.compareCode(a.code, b.code) : aCIndex - bCIndex; }); } }, }; const gatherGcl = { name: '汇总工程量清单', hint: '请使用mem_stage_bills下指标,注意事项:\n' + '1. 以下字段,不管报表是否实际使用,均应添加至指标映射,且在此处应勾选(不要求顺序):\n' + ' 清单编号(b_code), 名称(name), 单位(unit), 单价(unit_price), 树结构-是否子项(is_leaf)\n' + '2. 汇总后,以下字段,均会失效, 请勿使用:\n' + ' 台账ID(id), 树结构-ID(ledger_id), 树结构父项-ID(ledger_pid),\n' + ' 树结构-层级(level), 树结构-同层排序(order), 树结构-完整路径(full_path),\n' + ' 图册号(drawing_code), 备注(memo), 节点类型(node_type), 总额计量(is_tp)\n' + '3. 如需汇总"未计入清单章节项",请勾选"章节编号(chapter)"字段\n', fun: function (ctx, data, fieldsKey) { const gatherFields = function(gcl, data, fields) { for (const f of fields) { if (data[f]) { gcl[f] = ctx.helper.add(gcl[f], data[f]); } } }; if (!data.mem_stage_bills) return; const fields = ctx.helper._.map(fieldsKey, 'field'); const needFields = ['b_code', 'name', 'unit', 'unit_price', 'is_leaf']; for (const nf of needFields) { if (fields.indexOf(nf) === -1) return; } const gatherOther = fields.indexOf('chapter') >= 0; ctx.helper._.pull(data.mem_stage_bills, 'is_leaf'); const gclBills = [], other = {name: '未计入清单章节项', chapter: '100'}; for (const b of data.mem_stage_bills) { if (b.b_code && b.b_code !== '') { let gcl = gclBills.find(function (g) { return g.b_code === b.b_code && g.name === b.name && g.unit === b.unit && ctx.helper.checkZero(ctx.helper.sub(g.unit_price, b.unit_price)); }); if (!gcl) { gcl = { b_code: b.b_code, name: b.name, unit: b.unit, unit_price: b.unit_price, qc_bgl_code: [], }; gclBills.push(gcl); } gatherFields(gcl, b, [ 'deal_qty', 'deal_tp', 'sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'quantity', 'total_price', 'contract_qty', 'contract_tp', 'qc_qty', 'qc_tp', 'gather_qty', 'gather_tp', 'pre_contract_qty', 'pre_contract_tp', 'pre_qc_qty', 'pre_qc_tp', 'pre_gather_qty', 'pre_gather_tp', 'end_contract_qty', 'end_contract_tp', 'end_qc_qty', 'end_qc_tp', 'end_gather_qty', 'end_gather_tp', 'final_tp' ]); if (b.qc_bgl_code && b.qc_bgl_code !== '') { gcl.qc_bgl_code = gcl.qc_bgl_code.concat(b.qc_bgl_code.split(';')); } } else if (gatherOther) { gatherFields(other, b, [ 'deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price', 'contract_tp', 'qc_tp', 'gather_tp', 'pre_contract_tp', 'pre_qc_tp', 'pre_gather_tp', 'end_contract_tp', 'end_qc_tp', 'end_gather_tp', 'final_tp' ]); } } if (gatherOther) gclBills.push(other); for (const g of gclBills) { if (g.qc_bgl_code) g.qc_bgl_code = g.qc_bgl_code.join(';'); g.final_ratio = ctx.helper.mul(ctx.helper.div(g.end_gather_tp, g.final_ratio), 100); } data.mem_stage_bills = gclBills; } }; const sortGcl = { name: '工程量清单排序', hint: '只对一张表,进行工程量清单排序,排序哪张表,根据勾选的清单编号字段决定:\n' + 'e.g.1 要对mem_stage_bills排序,需要勾选mem_stage_bills下的"清单编号(b_code)"字段\n' + 'e.g.2 要对mem_stage_im_zl排序,需要勾选mem_stage_im_zl下的"中间计量总量信息_编号(code)"字段\n' + '特别的,如有"未计入清单章节项": \n' + ' 1. 默认"未计入清单章节项"排列在最后\n' + ' 2. 如须"未计入清单章节项"排在100章之后,请在清单编号字段后,依次勾选"章节编号(chapter)", "名称(name)"\n', fun: function (ctx, data, fieldsKey) { if (fieldsKey.length !== 1 && fieldsKey.length !== 3) return; const code = fieldsKey[0].field; const chapter = fieldsKey.length > 1 ? fieldsKey[1].field : ''; const name = fieldsKey.length > 2 ? fieldsKey[2].field : ''; const sortData = data[fieldsKey[0].table]; if (!sortData) return; sortData.sort(function (a, b) { if (chapter !== '') { if (a[name] === '未计入清单章节项') { return b[chapter] === '100' ? 1 : -1; } else if (b[name] === '未计入清单章节项') { return a[chapter] === '100' ? -1 : 1 } else { return ctx.helper.compareCode(a[code], b[code]); } } else { return ctx.helper.compareCode(a[code], b[code]); } }); } }; const analysisObj = { changeSort, gatherGcl, sortGcl }; const analysisDefine = (function (obj) { const result = []; for (const o in obj) { const analysis = obj[o]; if (analysis.name && analysis.hint && analysis.fun) { result.push({ name: analysis.name, key: o, hint: analysis.hint, }) } } return result; })(analysisObj); module.exports = { analysisObj, analysisDefine };