ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a21330c3b57c: POST https://beta.jinchangxiao.com/vue/analysis/project-data at 2026-06-04 04:10:52 pm by 221.216.117.119

Performance Profiling

Total processing time: 81 ms; Peak memory: 5.301 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
16:10:52.30216.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/project-data', '{"period":"currentfascalyear","created_at_period":"","dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5332,5449,5467,5476","page":"1","client_industry":"","client_type":"","projectProductTypes":"","project_status":["3"],"web_access_token":"-ooNs73DKJQ01PCpcbuHx_usnaO5SdwJ"}', '{"code":2000,"result":{"statusCount":[{"count":4,"key":1,"name":"\u9690\u6027\u9700\u6c42","sum":"20089400"},{"count":49,"key":2,"name":"\u660e\u786e\u9700\u6c42","sum":"72942908.00"},{"count":38,"key":3,"name":"\u5546\u673a\u6210\u4ea4","sum":21843024.37},{"count":5,"key":4,"name":"\u5546\u673a\u5931\u8d25","sum":"250000"},{"count":9,"key":5,"name":"\u5546\u673a\u6401\u7f6e","sum":"821684"},{"count":14,"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210","sum":"314700.2"}],"counts":{"projects":38,"budget":"21843024.37","profits":"8716138.44367400000000000000","clients":31},"circle":{"budgetCounts":[{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum_budget":"14046252","sum_profit":"6054326.2","y":64.31},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907","sum_budget":"3033869.78","sum_profit":"243082.754434","y":13.89},{"key":19,"name":"\u6280\u672f\u670d\u52a1","sum_budget":"2840313.6","sum_profit":"97805.8886","y":13},{"key":2,"name":"\u670d\u52a1\u5668","sum_budget":"1220108","sum_profit":"7442.6588","y":5.59},{"key":7,"name":"\u8f6f\u4ef6","sum_budget":"374633.0","sum_profit":"122050.39134","y":1.72},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum_budget":"140875","sum_profit":"2150472.816","y":0.64},{"key":22,"name":"\u670d\u52a1","sum_budget":"98394.99","sum_profit":"17742.0845","y":0.45},{"key":21,"name":"\u6570\u7801\u8bbe\u5907","sum_budget":"80435","sum_profit":"21993.5","y":0.37},{"key":23,"name":"\u793c\u54c1","sum_budget":"5443","sum_profit":"544.3","y":0.02},{"key":106,"name":"\u516c\u6709\u4e91","sum_budget":"2400","sum_profit":"594.24","y":0.01},{"key":18,"name":"\u673a\u623f\u8bbe\u5907","sum_budget":"300","sum_profit":"83.61","y":0}],"profitCounts":[{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","sum_budget":"14046252","sum_profit":"6054326.2","y":69.46},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","sum_budget":"140875","sum_profit":"2150472.816","y":24.67},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907","sum_budget":"3033869.78","sum_profit":"243082.754434","y":2.79},{"key":7,"name":"\u8f6f\u4ef6","sum_budget":"374633.0","sum_profit":"122050.39134","y":1.4},{"key":19,"name":"\u6280\u672f\u670d\u52a1","sum_budget":"2840313.6","sum_profit":"97805.8886","y":1.12},{"key":21,"name":"\u6570\u7801\u8bbe\u5907","sum_budget":"80435","sum_profit":"21993.5","y":0.25},{"key":22,"name":"\u670d\u52a1","sum_budget":"98394.99","sum_profit":"17742.0845","y":0.2},{"key":2,"name":"\u670d\u52a1\u5668","sum_budget":"1220108","sum_profit":"7442.6588","y":0.09},{"key":23,"name":"\u793c\u54c1","sum_budget":"5443","sum_profit":"544.3","y":0.01},{"key":106,"name":"\u516c\u6709\u4e91","sum_budget":"2400","sum_profit":"594.24","y":0.01},{"key":18,"name":"\u673a\u623f\u8bbe\u5907","sum_budget":"300","sum_profit":"83.61","y":0}],"statusCounts":[{"key":3,"projects":38,"name":"\u5546\u673a\u6210\u4ea4","y":100}],"industryCounts":[{"key":4,"name":"\u901a\u4fe1","sum_budget":"12804392","sum_profit":"5729331.1000000000000000","y":58.62},{"key":12,"name":"\u5e7f\u544a","sum_budget":"3837034","sum_profit":"23405.90740000000000","y":17.57},{"key":13,"name":"SI\/ISV","sum_budget":"2290740.18","sum_profit":"127431.300434000000000000","y":10.49},{"key":5,"name":"\u5236\u9020","sum_budget":"2225100.2","sum_profit":"453799.866340000000000000","y":10.19},{"key":20,"name":"\u5176\u4ed6","sum_budget":"469680","sum_profit":"2299823.030000000000000000","y":2.15},{"key":57,"name":"EDA\/CAE","sum_budget":"97173","sum_profit":"20435.442000000000000000","y":0.44},{"key":58,"name":"\u519b\u5de5","sum_budget":"35800","sum_profit":"33294.0000000000000000","y":0.16},{"key":8,"name":"\u7269\u6d41","sum_budget":"23104.99","sum_profit":"6523.847500000000000000","y":0.11},{"key":16,"name":"\u80fd\u6e90","sum_budget":"18600","sum_profit":"2760.240000000000000000","y":0.09},{"key":17,"name":"\u96f6\u552e","sum_budget":"20700","sum_profit":"4663.710000000000000000","y":0.09},{"key":18,"name":"\u5a92\u4f53","sum_budget":"20700","sum_profit":"14670.0000000000000000","y":0.09}],"usedClientIndustryCounts":[],"typeCounts":[{"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09","sum_budget":"15269532","sum_profit":"6332931.478000000000000000","y":69.91},{"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09","sum_budget":"6448019.17","sum_profit":"2348624.907334000000000000","y":29.52},{"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09","sum_budget":"125473.2","sum_profit":"34582.05834000000000000000","y":0.57}],"usedClientTypeCounts":[],"purchaseTypeCounts":[{"key":128,"name":"\u516c\u5f00\u62db\u6807","sum_budget":"13221050","sum_profit":"5901814.94000000000000000000","y":60.53},{"key":130,"name":"\u7ade\u4e89\u8c08\u5224","sum_budget":"3900238.99","sum_profit":"63787.364900000000000000","y":17.86},{"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7","sum_budget":"2404060.2","sum_profit":"2604965.724340000000000000","y":11.01},{"key":165,"name":"\u534f\u8bae\u4f9b\u8d27","sum_budget":"2116301.78","sum_profit":"115364.404434000000000000","y":9.69},{"key":182,"name":"\u56f4\u6807","sum_budget":"201373.4","sum_profit":"30206.0100000000000000","y":0.92},{"key":129,"name":"\u7279\u7ea6\u9080\u6807","sum_budget":"","sum_profit":"","y":0}]},"histogram":{"category":{"budgetCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"],"profitsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"],"clientsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"],"projectsCategory":["<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u4eba\u8bda<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png\" class=\"chart-avatar img-circle\" \/><br\/>\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9b4f\u6cfd\u6587<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png\" class=\"chart-avatar img-circle\" \/><br\/>\u5218\u5fae<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png\" class=\"chart-avatar img-circle\" \/><br\/>\u82cf\u6e05\u4e91<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u4f0a\u5cfb\u8fb0<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png\" class=\"chart-avatar img-circle\" \/><br\/>\u7fc1\u5bb6\u6210<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u62d3\u5b9e\u79d1\u6280<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png\" class=\"chart-avatar img-circle\" \/><br\/>\u970d\u536b\u8d85<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u5468\u4e3d\u98de<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u9a6c\u6668\u5e0c<\/div>","<div class=\"text-center\"><img style=\"width:34px;height:34px;\" src=\"\/img\/avatar-default.jpg\" class=\"chart-avatar img-circle\" \/><br\/>\u6768\u5dcd<\/div>"]},"seriesBudget":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"14947071.78"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"6143507.40"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"420440.00"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"176680.20"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"132220.00"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"23104.99"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"0.00"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"0.00"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":"0.00"},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"0.00"}],"seriesProfits":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"5852049.30"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"2141036.53"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"502084.81"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"176762.53"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"37681.43"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"6523.85"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"0.00"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"0.00"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":"0.00"},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":"0.00"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"0.00"}],"seriesClients":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":10},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":8},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":4},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":4},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":3},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":2},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":0},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":0},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":0}],"seriesProjects":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":16},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":8},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":5},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":4},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":3},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":2},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":0},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":0},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":0}]},"histogramSingle":{"category":{"budgetCategory":["\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","\u5927\u59d1\u8bf4\u7684\u98ce\u683c"],"profitsCategory":["\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5927\u59d1\u8bf4\u7684\u98ce\u683c"],"projectsCategory":["\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","\u5927\u59d1\u8bf4\u7684\u98ce\u683c"]},"seriesBudget":[{"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","y":"12804392"},{"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","y":"3837034"},{"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","y":"2000000"},{"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"1630000"},{"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","y":"378880"},{"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","y":"309425.78"},{"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","y":"201373.4"},{"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","y":"88240.2"},{"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"88221"},{"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","y":"74500"},{"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","y":"63840"},{"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","y":"57000"},{"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":"48000"},{"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","y":"35800"},{"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","y":"33333"},{"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"29800"},{"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"29800"},{"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","y":"28560"},{"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","y":"21104.99"},{"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","y":"20700"},{"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":"20700"},{"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","y":"18600"},{"key":3443,"name":"\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"10000"},{"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","y":"3900"},{"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","y":"3000"},{"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","y":"2400"},{"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","y":"2000"},{"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"1400"},{"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","y":"720"},{"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","y":"300"},{"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","y":"0"}],"seriesProfits":[{"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","y":"5729331.1000000000000000"},{"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","y":"2133329.850000000000000000"},{"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","y":"400000.000000000000"},{"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","y":"155340.8000000000000000"},{"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","y":"33294.0000000000000000"},{"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","y":"30206.0100000000000000"},{"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":"28036.00000000000000"},{"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"27714.0000000000000000"},{"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"27714.0000000000000000"},{"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","y":"23405.90740000000000"},{"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","y":"22324.028340000000000000"},{"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":"14670.0000000000000000"},{"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","y":"11746.728000000000000000"},{"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":"11740.800000000000000000"},{"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","y":"10999.8900000000000000"},{"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","y":"9435.552000000000000000"},{"key":3443,"name":"\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"9300.0000000000000000"},{"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"8822.1000000000000000"},{"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","y":"7529.700000000000000000"},{"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","y":"5276.2475000000000000"},{"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","y":"4734.214434000000000000"},{"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","y":"4663.710000000000000000"},{"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","y":"2760.240000000000000000"},{"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","y":"1258.140000000000000000"},{"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","y":"1247.600000000000000000"},{"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","y":"594.240000000000000000"},{"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","y":"375.00000000000000000"},{"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","y":"176.976000000000000000"},{"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","y":"83.610000000000000000"},{"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","y":"28.0000000000000000"},{"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","y":"0.00000000000000000000"}],"seriesProjects":[{"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","y":5},{"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":3},{"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","y":2},{"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","y":1},{"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","y":1},{"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","y":1},{"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","y":1},{"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)","y":1},{"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","y":1},{"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","y":1},{"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","y":1},{"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","y":1},{"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","y":1},{"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","y":1},{"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","y":1},{"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","y":1},{"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","y":1},{"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09","y":1},{"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","y":1},{"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3336,"name":"\u58f9\u8fdb\u5236\uff08\u5382\u5546\uff09","y":1},{"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","y":1},{"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3436,"name":"\u5317\u4eac\u5f18\u96c5\u745e\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","y":1},{"key":3438,"name":"\u5927\u8fde\u665f\u4e30\u539f\u4fe1\u606f\u54a8\u8be2\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","y":1},{"key":3443,"name":"\u5317\u4eac\u534e\u5b87\u65f6\u521b\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3448,"name":"\u5317\u4eac\u5723\u5609\u5965\u5bb6\u5177\u6709\u9650\u516c\u53f8-\u91d1\u7545\u900d","y":1},{"key":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","y":1},{"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","y":1},{"key":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","y":1}]}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 16:10:52', 58064896) RETURNING "id"
16:10:52.26912.8 msyii\db\Command::querySELECT taxonomy_id as key, tt.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_term_taxonomies" "tt" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.taxonomy_id = tt.id LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "uclient"."client_type" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "uclient" ON p.used_client = uclient.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id", "c"."client_industry", "c"."client_type", "uclient"."client_industry", "uclient"."client_type") "sub" ON ttr.object_id = sub.id WHERE "tt"."term_id"=9 GROUP BY "tt"."id", "ttr"."taxonomy_id"
16:10:52.2863.1 msyii\db\Command::querySELECT "client_id" AS "id", "c"."name" AS "name", count(distinct p.id) as projects, sum(budget) as budget, sum(profits) as profits FROM (SELECT "p"."id", "p"."client_id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id") "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id GROUP BY "client_id", "c"."id"
16:10:52.2652.7 msyii\db\Command::querySELECT ct.id as key, ct.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_types" "ct" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "uclient"."client_type" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "uclient" ON p.used_client = uclient.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id", "c"."client_industry", "c"."client_type", "uclient"."client_industry", "uclient"."client_type") "sub" ON ct.id = sub.client_type GROUP BY "ct"."id"
16:10:52.2832.6 msyii\db\Command::querySELECT count(distinct p.client_id) as clients, count(distinct p.id) as projects, sum(budget) as budget, sum(profits) as profits, "created_by" FROM (SELECT "p"."id", "p"."client_id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id") "p" GROUP BY "created_by"
16:10:52.2582.4 msyii\db\Command::querySELECT ci.id as key, ci.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_industries" "ci" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "c"."client_industry" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id", "c"."client_industry") "sub" ON ci.id = sub.client_industry GROUP BY "ci"."id"
16:10:52.2631.9 msyii\db\Command::querySELECT ci.id as key, ci.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_industries" "ci" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "uclient"."client_industry" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "uclient" ON p.used_client = uclient.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id", "c"."client_industry", "c"."client_type", "uclient"."client_industry") "sub" ON ci.id = sub.client_industry GROUP BY "ci"."id"
16:10:52.2511.9 msyii\db\Command::querySELECT count(*) as count, sum(budget), "project_status" FROM (SELECT sum(bgt.budget) as budget, CASE WHEN project_status = 3 and p.budget <= collected THEN -1 WHEN project_status = 3 and p.budget > collected THEN 3 ELSE project_status END as project_status FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') GROUP BY "p"."id") "sub" GROUP BY "project_status"
16:10:52.2611.7 msyii\db\Command::querySELECT ct.id as key, ct.name, sum(budget) as sum_budget, sum(profits) as sum_profit FROM "a57be577deb434"."tbl_client_types" "ct" LEFT JOIN (SELECT "p"."id", "p"."budget", (p.budget / 100 * p.profit_pct) as profits, "p"."created_by", "c"."client_type" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id", "c"."client_industry", "c"."client_type") "sub" ON ct.id = sub.client_type GROUP BY "ct"."id"
16:10:52.2551.7 msyii\db\Command::querySELECT product_type_id as key, name, sum(budget) as sum_budget, sum(budget * pct / 100) as sum_profit FROM "a57be577deb434"."tbl_project_product_types" "pt" WHERE "project_id" IN (SELECT "p"."id" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id") GROUP BY "product_type_id", "name"
16:10:52.2531.5 msyii\db\Command::querySELECT count(id) as projects, sum(budget) as budget, sum(profits) as profits, count(distinct client_id) as clients FROM (SELECT p.id, p.budget, (p.budget / 100 * p.profit_pct) as profits, p.client_id FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id") "sub"
16:10:52.2571.3 msyii\db\Command::querySELECT sub.project_status as key, count('sub.id') as projects FROM (SELECT "p"."id", "p"."project_status" FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_project_product_types" "bgt" ON bgt.project_id = p.id WHERE ("p"."created_by" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476')) AND ("p"."bargain_date" >= '2026-01-01 00:00:00') AND ("p"."bargain_date" <= '2026-12-31 23:59:59') AND ("p"."project_status"=3) GROUP BY "p"."id", "p"."project_status") "sub" WHERE sub.project_status != 1 GROUP BY "sub"."project_status"
16:10:52.2450.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:10:52.2820.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5332', '5449', '5467', '5476') ORDER BY "created_at"
16:10:52.2470.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:10:52.2820.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1004, 1005, 1013, 5087, 5295, 5300, 5311, 5332, 5449, 5467, 5476))
16:10:52.2450.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta