var result = { "success": true, "data": { "plan": { "id": "P001", "name": "", "statecode": "", "buckets": [{ "code": "workerlist", "name": "%E8%80%83%E5%8B%A4%E8%AE%B0%E5%BD%95", "children": [{ "code": "salesRep", "name": "%E9%94%80%E5%94%AE%E4%BB%A3%E8%A1%A8%E8%80%83%E5%8B%A4", "isaggregated": false, "dimension": "Tag", "size": 24, "columncount": 12, "children": [{ "id": "salesRep_year", "bandid": "salesRep", "code": "year", "name": "%E5%B9%B4%E4%BB%BD", "fieldname": "year", "indexno": 0, "ismeasure": false }, { "id": "salesRep_season", "bandid": "salesRep", "code": "season", "name": "%E5%AD%A3%E5%BA%A6", "fieldname": "season", "indexno": 1, "ismeasure": false }, { "id": "salesRep_region", "bandid": "salesRep", "code": "region", "name": "%E5%A4%A7%E5%8C%BA", "fieldname": "region", "indexno": 2, "ismeasure": false }, { "id": "salesRep_employeecode", "bandid": "salesRep", "code": "employeecode", "name": "%E5%91%98%E5%B7%A5%E7%BC%96%E7%A0%81", "fieldname": "employeecode", "indexno": 3, "ismeasure": false }, { "id": "salesRep_employeename", "bandid": "salesRep", "code": "employeename", "name": "%E5%91%98%E5%B7%A5%E5%A7%93%E5%90%8D", "fieldname": "employeename", "indexno": 4, "ismeasure": false }, { "id": "salesRep_position", "bandid": "salesRep", "code": "position", "name": "%E5%B2%97%E4%BD%8D", "fieldname": "position", "indexno": 5, "ismeasure": false }, { "id": "salesRep_leader", "bandid": "salesRep", "code": "leader", "name": "%E9%A2%86%E5%AF%BC", "fieldname": "leader", "indexno": 6, "ismeasure": false }, { "id": "salesRep_group", "bandid": "salesRep", "code": "group", "name": "%E5%88%86%E7%BB%84", "fieldname": "group", "indexno": 7, "ismeasure": false }, { "id": "salesRep_day_all", "bandid": "salesRep", "code": "day_all", "name": "%E8%80%83%E5%8B%A4%E5%A4%A9%E6%95%B0", "fieldname": "day_all", "indexno": 8, "ismeasure": false }, { "id": "salesRep_day_work", "bandid": "salesRep", "code": "day_work", "name": "%E5%9C%A8%E5%B2%97%E5%A4%A9%E6%95%B0", "fieldname": "day_work", "indexno": 9, "ismeasure": false }, { "id": "salesRep_day_basent", "bandid": "salesRep", "code": "day_basent", "name": "%E7%BC%BA%E5%8B%A4%E5%A4%A9%E6%95%B0", "fieldname": "day_basent", "indexno": 10, "ismeasure": false }, { "id": "salesRep_rate_absent", "bandid": "salesRep", "code": "rate_absent", "name": "%E7%BC%BA%E5%8B%A4%E7%8E%87", "fieldname": "rate_absent", "indexno": 11, "ismeasure": false }] }] }, { "code": "baseflow", "name": "%E4%B8%9A%E5%8A%A1%E7%BB%9F%E8%AE%A1", "children": [{ "code": "salesAchieve", "name": "%E9%94%80%E5%94%AE%E8%BE%BE%E6%88%90%EF%BC%88%E5%AD%A3%E5%BA%A6%EF%BC%89", "isaggregated": false, "dimension": "Tag", "size": 24, "columncount": 9, "children": [{ "id": "salesAchieve_year", "bandid": "salesAchieve", "code": "year", "name": "%E5%B9%B4%E4%BB%BD", "fieldname": "year", "indexno": 0, "ismeasure": false }, { "id": "salesAchieve_season", "bandid": "salesAchieve", "code": "season", "name": "%E5%AD%A3%E5%BA%A6", "fieldname": "season", "indexno": 1, "ismeasure": false }, { "id": "salesAchieve_region", "bandid": "salesAchieve", "code": "region", "name": "%E5%A4%A7%E5%8C%BA", "fieldname": "region", "indexno": 2, "ismeasure": false }, { "id": "salesAchieve_employeecode", "bandid": "salesAchieve", "code": "employeecode", "name": "%E5%91%98%E5%B7%A5%E7%BC%96%E7%A0%81", "fieldname": "employeecode", "indexno": 3, "ismeasure": false }, { "id": "salesAchieve_employeename", "bandid": "salesAchieve", "code": "employeename", "name": "%E5%91%98%E5%B7%A5%E5%A7%93%E5%90%8D", "fieldname": "employeename", "indexno": 4, "ismeasure": false }, { "id": "salesAchieve_position", "bandid": "salesAchieve", "code": "position", "name": "%E5%B2%97%E4%BD%8D", "fieldname": "position", "indexno": 5, "ismeasure": false }, { "id": "salesAchieve_rate_achieve", "bandid": "salesAchieve", "code": "rate_achieve", "name": "%E8%BE%BE%E6%88%90%E7%8E%87", "fieldname": "rate_achieve", "indexno": 6, "ismeasure": false }, { "id": "salesAchieve_amt_achieve", "bandid": "salesAchieve", "code": "amt_achieve", "name": "%E8%B4%A1%E7%8C%AE%E9%87%91%E9%A2%9D", "fieldname": "amt_achieve", "indexno": 7, "ismeasure": false }, { "id": "salesAchieve_amt_growth", "bandid": "salesAchieve", "code": "amt_growth", "name": "%E5%A2%9E%E9%95%BF%E9%87%91%E9%A2%9D", "fieldname": "amt_growth", "indexno": 8, "ismeasure": false }] }, { "code": "salesBehavior", "name": "%E9%94%80%E5%94%AE%E8%A1%8C%E4%B8%BA%EF%BC%88%E5%AD%A3%E5%BA%A6%EF%BC%89", "isaggregated": false, "dimension": "Tag", "size": 24, "columncount": 10, "children": [{ "id": "salesBehavior_year", "bandid": "salesBehavior", "code": "year", "name": "%E5%B9%B4%E4%BB%BD", "fieldname": "year", "indexno": 0, "ismeasure": false }, { "id": "salesBehavior_season", "bandid": "salesBehavior", "code": "season", "name": "%E5%AD%A3%E5%BA%A6", "fieldname": "season", "indexno": 1, "ismeasure": false }, { "id": "salesBehavior_region", "bandid": "salesBehavior", "code": "region", "name": "%E5%A4%A7%E5%8C%BA", "fieldname": "region", "indexno": 2, "ismeasure": false }, { "id": "salesBehavior_employeecode", "bandid": "salesBehavior", "code": "employeecode", "name": "%E5%91%98%E5%B7%A5%E7%BC%96%E7%A0%81", "fieldname": "employeecode", "indexno": 3, "ismeasure": false }, { "id": "salesBehavior_employeename", "bandid": "salesBehavior", "code": "employeename", "name": "%E5%91%98%E5%B7%A5%E5%A7%93%E5%90%8D", "fieldname": "employeename", "indexno": 4, "ismeasure": false }, { "id": "salesBehavior_position", "bandid": "salesBehavior", "code": "position", "name": "%E5%B2%97%E4%BD%8D", "fieldname": "position", "indexno": 5, "ismeasure": false }, { "id": "salesBehavior_qty_newCust", "bandid": "salesBehavior", "code": "qty_newcust", "name": "%E6%96%B0%E5%BC%80%E5%AE%A2%E6%88%B7%E6%95%B0", "fieldname": "qty_newcust", "indexno": 6, "ismeasure": false }, { "id": "salesBehavior_qty_newprod", "bandid": "salesBehavior", "code": "qty_newprod", "name": "%E6%96%B0%E5%A2%9E%E4%BA%A7%E5%93%81%E6%95%B0", "fieldname": "qty_newprod", "indexno": 7, "ismeasure": false }, { "id": "salesBehavior_rate_vp", "bandid": "salesBehavior", "code": "rate_invoice", "name": "%E5%8F%91%E7%A5%A8%E6%8F%90%E4%BA%A4%E7%8E%87", "fieldname": "rate_invoice", "indexno": 8, "ismeasure": false }, { "id": "salesBehavior_rate_visit", "bandid": "salesBehavior", "code": "rate_visit", "name": "%E6%8B%9C%E8%AE%BF%E5%AE%8C%E6%88%90%E7%8E%87", "fieldname": "rate_visit", "indexno": 9, "ismeasure": false }] }, { "code": "businessSaleIn", "name": "%E5%95%86%E4%B8%9ASaleIn%EF%BC%88%E5%AD%A3%E5%BA%A6%EF%BC%89", "isaggregated": false, "dimension": "Tag", "size": 0, "columncount": 0, "children": [] }, { "code": "businessSaleOut", "name": "%E5%95%86%E4%B8%9ASaleOut%EF%BC%88%E5%AD%A3%E5%BA%A6%EF%BC%89", "isaggregated": false, "dimension": "Tag", "size": 0, "columncount": 0, "children": [] }, { "code": "businessStock", "name": "%E5%95%86%E4%B8%9AStock%EF%BC%88%E5%AD%A3%E5%BA%A6%EF%BC%89", "isaggregated": false, "dimension": "Tag", "size": 0, "columncount": 0, "children": [] }] }], "workbooks": [{ "id": "sales_rep", "planid": "P001", "code": "sales_rep", "bandid": "salesRep", "typecode": "main", "no": 1, "columns": [{ "id": "sales_rep_year", "indexno": 0, "code": "year", "name": "%E5%B9%B4%E4%BB%BD", "bandid": "salesRep", "bandcolumn": "year", "workfield": "", "variant": "", "expression": "", "orderno": 0 }, { "id": "sales_rep_season", "indexno": 1, "code": "season", "name": "%E5%AD%A3%E5%BA%A6", "bandid": "salesRep", "bandcolumn": "season", "workfield": "", "variant": "", "expression": "", "orderno": 1 }, { "id": "sales_rep_employeeName", "indexno": 2, "code": "employeeName", "name": "%E5%91%98%E5%B7%A5%E5%A7%93%E5%90%8D", "bandid": "salesRep", "bandcolumn": "employeename", "workfield": "", "variant": "", "expression": "", "orderno": 2 }, { "id": "sales_rep_employeecode", "indexno": 3, "code": "employeecode", "name": "%E5%91%98%E5%B7%A5%E7%BC%96%E7%A0%81", "bandid": "salesRep", "bandcolumn": "employeecode", "workfield": "", "variant": "", "expression": "", "orderno": 3 }, { "id": "sales_rep_position", "indexno": 4, "code": "position", "name": "%E5%B2%97%E4%BD%8D", "bandid": "salesRep", "bandcolumn": "position", "workfield": "", "variant": "", "expression": "", "orderno": 4 }, { "id": "sales_rep_bonus_base_a", "indexno": 5, "code": "base_a", "name": "%E5%A5%96%E9%87%91%E5%9F%BA%E6%95%B0A", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "position", "expression": "lookup%28%27setting_bonus_base%27%2C%40%7Bposition%7D%2C%27PartA%27%29", "orderno": 5 }, { "id": "sales_rep_bonus_base_b", "indexno": 6, "code": "base_b", "name": "%E5%A5%96%E9%87%91%E5%9F%BA%E6%95%B0B", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "position", "expression": "lookup%28%27setting_bonus_base%27%2C%40%7Bposition%7D%2C%27PartB%27%29", "orderno": 6 }, { "id": "sales_rep_bonus_base_c", "indexno": 7, "code": "base_c", "name": "%E5%A5%96%E9%87%91%E5%9F%BA%E6%95%B0C", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "position", "expression": "lookup%28%27setting_bonus_base%27%2C%40%7Bposition%7D%2C%27PartC%27%29", "orderno": 7 }, { "id": "sales_rep_rate_achieve", "indexno": 8, "code": "rate_achieve", "name": "%E8%BE%BE%E6%88%90%E7%8E%87", "bandid": "salesAchieve", "bandcolumn": "rate_achieve", "workfield": "", "variant": "", "expression": "", "orderno": 8 }, { "id": "sales_rep_payout", "indexno": 9, "code": "rate_payout", "name": "Payout", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "rate_achieve", "expression": "lookup%28%27payout%27%2C%40%7Brate_achieve%7D%2C%27payout%27%29", "orderno": 9 }, { "id": "sales_rep_acculate", "indexno": 10, "code": "acculate", "name": "%E5%8A%A0%E9%80%9F%E5%99%A8", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "rate_achieve", "expression": "lookup%28%27payout%27%2C%40%7Brate_achieve%7D%2C%27acceleration%27%29", "orderno": 10 }, { "id": "sales_rep_amt_begin", "indexno": 11, "code": "amt_begin", "name": "%E5%88%9D%E5%A7%8B%E5%A5%96%E9%87%91%E9%A2%9D", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "rate_payout%2C%20base_a", "expression": "%40%7Brate_payout%7D*%40%7Bbase_a%7D%2F100", "orderno": 11 }, { "id": "sales_rep_freeze_rate", "indexno": 12, "code": "rate_ceiling", "name": "%E5%AD%A3%E5%BA%A6%E5%B0%81%E9%A1%B6%E7%8E%87", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "position", "expression": "lookup%28%27payout_ceiling%27%2C%40%7Bposition%7D%29", "orderno": 12 }, { "id": "sales_rep_end", "indexno": 13, "code": "rate_end", "name": "%E5%AD%A3%E5%BA%A6%E6%94%AF%E4%BB%98%E7%8E%87", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "rate_payout%2C%20rate_ceiling", "expression": "min%28%40%7Brate_payout%7D%2C%40%7Brate_ceiling%7D%29", "orderno": 13 }, { "id": "sales_rep_begin", "indexno": 14, "code": "rate_freeze", "name": "%E5%B0%81%E9%A1%B6%E7%95%99%E5%AD%98%E7%8E%87", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "rate_payout%2C%20rate_end", "expression": "%40%7Brate_payout%7D%3E%40%7Brate_end%7D%3F%40%7Brate_payout%7D-%40%7Brate_end%7D%3B0", "orderno": 14 }, { "id": "sales_rep_toyear_amt", "indexno": 15, "code": "amt_toyear", "name": "%E5%B0%81%E9%A1%B6%E7%95%99%E5%AD%98", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "base_a%2C%20rate_freeze", "expression": "%40%7Bbase_a%7D*%40%7Brate_freeze%7D%2F100", "orderno": 15 }, { "id": "sales_rep_invoice_rate", "indexno": 16, "code": "rate_invoice", "name": "%E5%8F%91%E7%A5%A8%E6%8F%90%E4%BA%A4%E7%8E%87YTD", "bandid": "salesBehavior", "bandcolumn": "rate_invoice", "workfield": "", "variant": "", "expression": "", "orderno": 16 }, { "id": "sales_rep_invoice_amt", "indexno": 17, "code": "amt_invoice", "name": "%E5%8F%91%E7%A5%A8%E6%8F%90%E4%BA%A4%E7%95%99%E5%AD%98", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "rate_invoice%2C%20amt_begin%2C%20amt_toyear", "expression": "%40%7Brate_invoice%7D%3D%3D100%3F0%3B%40%7Bamt_begin%7D-%40%7Bamt_toyear%7D", "orderno": 17 }, { "id": "sales_rep_freeze_amt", "indexno": 18, "code": "amt_freeze", "name": "%E7%95%99%E5%AD%98%E9%A2%9D", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "amt_toyear%2C%20amt_invoice", "expression": "%40%7Bamt_toyear%7D%2B%40%7Bamt_invoice%7D", "orderno": 18 }, { "id": "sales_rep_amt", "indexno": 19, "code": "amt_working", "name": "%E5%A5%96%E9%87%91%E9%A2%9D", "bandid": "", "bandcolumn": "", "workfield": "", "variant": "amt_begin%2C%20amt_freeze", "expression": "%40%7Bamt_begin%7D-%40%7Bamt_freeze%7D", "orderno": 19 }] }] } } }; var datalist = { "success": true, "data": { "columns": [ {field: "year", name: "年份", align: "center", formatter: null, width: 0.6, expression: "[销售架构].[年份]"}, {field: "season", name: "季度", align: "center", formatter: null, width: 0.6, expression: "[销售架构].[季度]"}, {field: "employeename", name: "员工姓名", align: "center", formatter: null, expression: "[销售架构].[员工姓名]"}, {field: "employeecode", name: "员工编码", align: "center", formatter: null, expression: "[销售架构].[员工编码]"}, {field: "position", name: "岗位", align: "center", formatter: null, expression: "[销售架构].[岗位]"}, {field: "base_a", name: "奖金基数A", align: "right", formatter: "money", expression: "lookup('setting_bonus_base',@{position},'PartA')"}, {field: "base_b", name: "奖金基数B", align: "right", formatter: "money", expression: "lookup('setting_bonus_base',@{position},'PartB')"}, {field: "base_c", name: "奖金基数C", align: "right", formatter: "money", expression: "lookup('setting_bonus_base',@{position},'PartC')"}, {field: "rate_achieve", name: "达成率", align: "right", formatter: "percent", expression: "[销售达成].[达成率]"}, {field: "rate_payout", name: "Payout", align: "right", formatter: "percent", expression: "lookup('payout',@{rate_achieve},'payout')"}, {field: "acculate", name: "加速器", align: "right", formatter: "percent", expression: "lookup('payout',@{rate_achieve},'acceleration')"}, {field: "amt_begin", name: "初始奖金额", align: "right", formatter: "money", expression: "@{rate_payout}*@{base_a}/100"}, {field: "rate_ceiling", name: "封顶支付率(季)", align: "right", formatter: "percent", expression: "lookup('payout_ceiling',@{position})"}, {field: "rate_end", name: "支付率（季）", align: "right", formatter: "percent", expression: "@{rate_payout}>@{rate_end}?@{rate_payout}-@{rate_end};0"}, {field: "rate_freeze", name: "冻结率(季)", align: "right", formatter: "percent", expression: "@{base_a}*@{rate_freeze}/100"}, {field: "amt_toyear", name: "冻结金额（季）", align: "right", formatter: "money", expression: "[].[冻结金额（季）]"}, {field: "rate_invoice", name: "发票提交率", align: "right", formatter: "percent", expression: "[发票提交].[达成率]"}, {field: "amt_invoice", name: "冻结金额（发票）", align: "right", formatter: "money", expression: "@{rate_invoice}==100?0;@{amt_begin}-@{amt_toyear}"}, {field: "amt_freeze", name: "冻结总额", align: "right", formatter: "money", expression: "@{amt_toyear}+@{amt_invoice}"}, {field: "amt", name: "季度奖金", align: "right", formatter: "money", expression: "@{amt_begin}-@{amt_freeze}"} ], "datalist": [{ "year": "2022", "season": "1", "employeename": "%E5%85%B3%E7%BF%A0%E8%8E%B9", "employeecode": "107276", "position": "%E9%94%80%E5%94%AE%E4%BB%A3%E8%A1%A8", "base_a": "80000", "base_b": "10000", "base_c": "10000", "rate_achieve": "102.0000", "rate_payout": "106", "acculate": "3", "amt_begin": "1617600.0", "rate_ceiling": "105", "rate_end": "105.0", "rate_freeze": "0", "amt_toyear": "0.0", "rate_invoice": "100.0000", "amt_invoice": null, "amt_freeze": null, "amt": null, "bonus_newprod": null, "tracker": "2022-1-107276" }, { "year": "2022", "season": "1", "employeename": "%E5%AE%B9%E6%96%87%E5%8D%93", "employeecode": "205126", "position": "%E9%94%80%E5%94%AE%E4%BB%A3%E8%A1%A8", "base_a": "80000", "base_b": "10000", "base_c": "10000", "rate_achieve": "105.0000", "rate_payout": "115", "acculate": "3", "amt_begin": "1617600.0", "rate_ceiling": "105", "rate_end": "105.0", "rate_freeze": "0", "amt_toyear": "0.0", "rate_invoice": "92.0000", "amt_invoice": null, "amt_freeze": null, "amt": null, "bonus_newprod": null, "tracker": "2022-1-205126" }, { "year": "2022", "season": "1", "employeename": "%E5%BC%A0%E7%90%B4%E5%A8%A3", "employeecode": "232798", "position": "%E9%94%80%E5%94%AE%E4%BB%A3%E8%A1%A8", "base_a": "80000", "base_b": "10000", "base_c": "10000", "rate_achieve": "80.0000", "rate_payout": "60", "acculate": "2", "amt_begin": "1617600.0", "rate_ceiling": "105", "rate_end": "60.0", "rate_freeze": "0.0", "amt_toyear": "0.0", "rate_invoice": "100.0000", "amt_invoice": null, "amt_freeze": null, "amt": null, "bonus_newprod": null, "tracker": "2022-1-232798" }, { "year": "2022", "season": "1", "employeename": "%E5%BD%AD%E6%99%93%E6%A2%85", "employeecode": "363809", "position": "%E9%94%80%E5%94%AE%E7%BB%8F%E7%90%86", "base_a": "100000", "base_b": "20000", "base_c": "30000", "rate_achieve": "90.0000", "rate_payout": "80", "acculate": "2", "amt_begin": "2022000.0", "rate_ceiling": "105", "rate_end": "80.0", "rate_freeze": "0.0", "amt_toyear": "0.0", "rate_invoice": "95.0000", "amt_invoice": null, "amt_freeze": null, "amt": null, "bonus_newprod": null, "tracker": "2022-1-363809" }, { "year": "2022", "season": "1", "employeename": "%E8%91%A3%E6%95%8F%E8%83%9C", "employeecode": "391626", "position": "%E9%94%80%E5%94%AE%E7%BB%8F%E7%90%86", "base_a": "100000", "base_b": "20000", "base_c": "30000", "rate_achieve": "103.0000", "rate_payout": "109", "acculate": "3", "amt_begin": "2022000.0", "rate_ceiling": "105", "rate_end": "105.0", "rate_freeze": "0", "amt_toyear": "0.0", "rate_invoice": "100.0000", "amt_invoice": null, "amt_freeze": null, "amt": null, "bonus_newprod": null, "tracker": "2022-1-391626" }], "type": "workbook" } }