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"
}
}