网站开发分销系统,成都企业建站模板,厦门设计师网站,国家重点学科建设网站树形表格计算 一、盈收金额计算1、根据需要输入的子级位置#xff0c;修改数据2、获取兄弟节点数据#xff0c;并计算兄弟节点的金额合计3、金额合计#xff0c;遍历给所有的父级 一、盈收金额计算
1、根据需要输入的子级位置#xff0c;修改数据
2、获取兄弟节点数据修改数据2、获取兄弟节点数据并计算兄弟节点的金额合计3、金额合计遍历给所有的父级 一、盈收金额计算
1、根据需要输入的子级位置修改数据
2、获取兄弟节点数据并计算兄弟节点的金额合计
3、金额合计遍历给所有的父级
templatea-modal :titletitleMap[mode] :visiblevisible :destroyOnClosetrue :maskClosablefalse cancelhandleCancelwidth95%a-spin :spinningspinning tip加载中...a-table :columnscolumns bordered :data-sourcenewSource :scroll{ x: 800, y: 500 } :paginationfalse:rowKey(record, index) { return record.projectId } :defaultExpandAllRowstruev-ifnewSource.lengthtemplate slotpromote slot-scopetext,recordspan{{ rateCompute(record.preActual, record.budget) }}/span/templatetemplate slotbudget slot-scopetext,recorddiv classeditable-celldiv v-ifeditable classeditable-cell-input-wrapperdiv v-ifeditableData[record.projectId]a-input v-modeleditableData[record.projectId][budget]pressEntersave(editableData[record.projectId]) typenumberchangee e.target.value e.target.value.replace(/^0(\d)|[^\d]/g, ) /a-icon typecheck clicksave(editableData[record.projectId])stylemargin-right: 20px; /a-popconfirm title确定取消? confirmcancel(record.projectId)a-icon typeclose //a-popconfirm/divdiv v-else{{ text }}/div/divdiv v-else classeditable-cell-text-wrapperdiv v-ifrecord.children null{{ text || }}a-icon typeedit clickedit(record) //divdiv v-else{{ text || }}/div/div/div/template/a-table/a-spintemplate slotfootera-button keyback clickhandleCancel关闭/a-buttona-button typeprimary :visiblevisibleBtn :loadingloadingBtn clickhandleSubmit保存/a-button/template/a-modal
/templateJS
import { cloneDeep } from lodash-es;
export default {data() {return {visible: false,dataSource: [],newSource: [], //变化的源数据spinning: true,columns: [],//头部表单editableData: {},// 修改的位置数据editable: false, //是否编辑visibleBtn: false,loadingBtn: false,mode: add,titleMap: {add: 新增,edit: 修改},}},methods: {//计算比率// 本月比上月情况本月数字-上月数字/上月数字如果本月大于上月结果就是正数即上升反之为下降rateCompute(a, b) {if (a 0 b 0) {if (a b) return ((((b - a) / a) * 100).toFixed(2)) %else if (b a) - ((((b - a) / a) * 100).toFixed(2)) %else return 0%} else {if (a 0 b a) return 100%else return 0%}},edit(row) {this.editable truethis.editableData[row.projectId] cloneDeep(row)},save(row) {this.editable falsethis.calculate(row)},// 计算calculate(row) {//计算时需要同步执行 this.fun1(row)delete this.editableData[row.projectId];},fun1(row) {if (row.inOrOut 2) {if(Number(row.budget) 0){this.getObj(this.newSource, row.projectId, Number(- row.budget), row, callback)}else{this.getObj(this.newSource, row.projectId, Number(row.budget), row, callback)}} else {this.getObj(this.newSource, row.projectId, Number(row.budget), row, callback)}// 使用回调同步执行下面的方法function callback(isFind, _this, row) {if (isFind) {_this.fun2(row)}}},fun2(row) {// 获取兄弟节点的父级idlet brotherParentId row.parentProjectId// 获取兄弟节点数据let brotherParentArr this.getBrotherParentId(this.newSource, brotherParentId)console.log(brotherParentArr)if (brotherParentArr.length 0) {// 兄弟数组的和 相差值let ParentVal brotherParentArr.reduce((accumulator, currentValue) Number(accumulator) Number(currentValue));if (ParentVal) {this.fun3(row, ParentVal)}}},fun3(row, ParentVal) {// 相关连的数据包括原来未改变的初始值let joinedArr this.get_level_all(this.dataSource, row.projectId).filter(item item.projectId ! row.projectId)let _this this// 相差值if (joinedArr.length 0) {joinedArr.forEach((item) {_this.getParentId(_this.newSource, item.projectId, Number(ParentVal))});}},// 根据id 找到当前元素的对象并进行赋值getObj(data, id, val, row, callback) {let isFind falsedata.find((item) {if (item.projectId id) {if (val 0) item.budget 0else item.budget Number(val)item.promote this.rateCompute(Number(item.preActual), Number(item.budget))isFind true} else if (item.children ! null item.children.length 0) {this.getObj(item.children, id, val, row, callback);}});if (isFind) {callback(isFind, this, row)return isFind}},// 根据id找到所有的上级idget_level_all(data, id, arr []) {data.find((item) {if (item.projectId id) {arr.push(item);return true;} else if (item.children ! null item.children.length 0) {arr this.get_level_all(item.children, id, arr);if (arr.length) {arr.push(item);return true;} else {return false;}}return false;});return arr;},// 根据id找到所有的同级数据getBrotherParentId(data, id, arr []) {data.find((item) {if (item.parentProjectId id) {// 收支类型1收入2支出3其它// 支出:减if(item.inOrOut 2){if(Number(item.budget)0){arr.push((item.inOrOut 2 ? Number((- item.budget)) : Number(item.budget)));}else{arr.push(Number(item.budget));}}else{arr.push(Number(item.budget));}} else if (item.children ! null item.children.length 0) {this.getBrotherParentId(item.children, id, arr);}});return arr;},// 根据相差值遍历相关的父级或祖级getParentId(arr, id, numDiffer) {arr.forEach(item {if (item.projectId id) {item.budget Number(this.sumChildren(item.children))item.promote this.rateCompute(item.preActual, item.budget)}if (item.children ! null item.children.length 0) {this.getParentId(item.children, id, numDiffer)}})},// 获取子集得计算和sumChildren(children) {let sum 0children.map(item {if (item.inOrOut 2 Number(item.budget) 0) {sum Number(item.budget)} else {sum item.inOrOut 2 ? Number((- item.budget)) : Number(item.budget)}})return sum},// 取消cancel(key) {this.editable falsedelete this.editableData[key];},//显示open(mode add, par) {this.mode mode;this.visible true;//接口数据在下面let headers res.data.headers//去除不需要显示的列headers.map(item {if (item.hidden false) this.operator(item)})this.columns.push({title: 提升比率,dataIndex: promote,key: promote,align: left,width: 120,scopedSlots: { customRender: promote }})let row res.data.rows//树形表格children没有数据需要为空this.handNull(row)this.dataSource rowthis.spinning falsethis.newSource row},// 子集没数据赋值为空 nullhandNull(data) {data.forEach((item) {//计算提升比率item.promote this.rateCompute(item.preActual, item.budget)if (item.children.length 0) {item.children null} else {this.handNull(item.children);}});},// columns 表头赋值operator(item) {let obj {}if (item.columnId projectName) {obj[title] item.nameobj.dataIndex nameobj.key nameobj.align left}else if (item.columnId preActual) {obj[title] item.nameobj.dataIndex preActualobj.key preActualobj.align leftobj.width 200}else if (item.columnId budget) {obj[title] item.nameobj.dataIndex budgetobj.key budgetobj.align leftobj.width 200obj.scopedSlots { customRender: budget }}else return;this.columns.push(obj)},//关闭handleCancel() {this.visible false;this.editable falsethis.$emit(close);},// 确认handleSubmit() {this.loadingBtn true;this.visibleBtn true;//新增或修改let Api this.mode add ? add : editApi(par).then(res {if (res.code 200) {this.$notification[success]({message: 提示,description: 保存成功,duration: 8})this.visible falsethis.$emit(success);} else {this.$notification[error]({message: 提示,description: res.message,duration: 8})}this.visibleBtn falsethis.loadingBtn false})},}json {code: 200,message: 操作成功,data: {title: 月度预算,tabulatorId: 146,storeId: 159,storeName: 麓谷公园店,tabulator: 李生,headers: [{columnId: projectId,name: 项目ID,hidden: true,primary: false},{columnId: projectName,name: 项目名称,hidden: false,primary: false},{columnId: isLeaf,name: 是否叶子,hidden: true,primary: false},{columnId: inOrOut,name: 收支类型,hidden: true,primary: false},{columnId: parentProjectId,name: 上级预算项目ID,hidden: true,primary: false},{columnId: preActual,name: 10月,hidden: false,primary: false},{columnId: budget,name: 11月预算,hidden: false,primary: true}],rows: [{projectId: 165,name: 利润,parentProjectId: null,inOrOut: 1,children: [{projectId: 174,name: 成本,parentProjectId: 165,inOrOut: 2,children: [{projectId: 175,name: 原材料成本,parentProjectId: 174,inOrOut: 2,children: [],budget: 0,preBudget: ,preActual: 0,leaf: true}],preBudget: ,preActual: 0,budget: 0,leaf: false},{projectId: 173,name: 税额,parentProjectId: 165,inOrOut: 2,children: [],preBudget: ,preActual: 0,budget: 0,leaf: true},{projectId: 166,name: 营业收入,parentProjectId: 165,inOrOut: 1,children: [{projectId: 170,name: 外卖折后营收,parentProjectId: 166,inOrOut: 1,children: [{projectId: 172,name: 外卖优免,parentProjectId: 170,inOrOut: 2,children: [],preBudget: ,preActual: 0,budget: 0,leaf: true},{projectId: 171,name: 外卖折前营收,parentProjectId: 170,inOrOut: 1,children: [],preBudget: ,preActual: 0,budget: 0,leaf: true}],preBudget: ,preActual: 0,budget: 0,leaf: false}],preBudget: ,preActual: 0,budget: 0,leaf: false}],preBudget: ,preActual: 0,budget: 0,leaf: false}]}
}折后盈收折前盈收-优免
