ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90d263ace6: POST https://beta.jinchangxiao.com/vue/analysis/from-contact-histogram at 2025-09-16 03:09:26 pm by 114.244.128.96

Log Messages

总计56条数据
TimeLevelCategoryMessage
 
15:09:26.240traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:09:26.240traceyii\base\Module::getModuleLoading module: debug
15:09:26.240traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:09:26.241traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:09:26.241traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:09:26.241traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.241traceyii\base\Module::getModuleLoading module: gii
15:09:26.241traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:09:26.241traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:09:26.242traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/from-contact-histogram'
15:09:26.242traceyii\base\Module::getModuleLoading module: vue
15:09:26.280infoyii\web\Session::openSession started
15:09:26.281infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
15:09:26.281infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:09:26.290traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.292traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:26.293traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.293traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:26.293infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:09:26.296traceyii\base\Controller::runActionRoute to run: vue/analysis/from-contact-histogram
15:09:26.296traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewSalesChart
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 软件开发
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 人力资源
15:09:26.298traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
15:09:26.298traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionFromContactHistogram()
15:09:26.298traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.299traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.300infoyii\db\Command::querySELECT contact.id as c_id, contact.id as contact_id, contact.id as from_contact, sum(ps.point) as point, sum(p.budget) as budget, sum(p.profits) AS profits, sum(p.paid_point) as paid_point, sum(p.projects) as projects FROM "a57be577deb434"."tbl_contacts" "contact" LEFT JOIN (SELECT pcp.contact_id, sum(point) as point FROM "a57be577deb434"."tbl_project_contact_points" "pcp" LEFT JOIN (SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_contacts" "contact" ON p.from_contact = contact.id WHERE ("c"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') AND (("p"."project_status"=3) OR ((p.budget <= p.collected) AND ("p"."project_status"=3)))) "p" ON p.id = pcp.project_id and p.from_contact = pcp.contact_id WHERE p.id is not null GROUP BY "pcp"."contact_id") "ps" ON ps.contact_id = contact.id LEFT JOIN (SELECT p.from_contact, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, count(distinct p.id) as projects, sum(p.paid_contact_point) as paid_point FROM (SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_contacts" "contact" ON p.from_contact = contact.id WHERE ("c"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') AND (("p"."project_status"=3) OR ((p.budget <= p.collected) AND ("p"."project_status"=3)))) "p" GROUP BY "p"."from_contact") "p" ON contact.id = p.from_contact WHERE p.from_contact is not null GROUP BY "contact"."id"
15:09:26.307traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.307traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:26.308infoyii\db\Command::querySELECT sum(total_contact_point) as point, sum(paid_contact_point) as paid_point, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, count(p.id) as projects FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_contacts" "contact" ON p.from_contact = contact.id WHERE ("c"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') AND (("p"."project_status"=3) OR ((p.budget <= p.collected) AND ("p"."project_status"=3))) AND (p.from_contact is null)
15:09:26.310traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.310traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:26.310infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (SELECT "from_contact" FROM "a57be577deb434"."tbl_contacts" "contact" LEFT JOIN (SELECT pcp.contact_id, sum(point) as point FROM "a57be577deb434"."tbl_project_contact_points" "pcp" LEFT JOIN (SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_contacts" "contact" ON p.from_contact = contact.id WHERE ("c"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') AND (("p"."project_status"=3) OR ((p.budget <= p.collected) AND ("p"."project_status"=3)))) "p" ON p.id = pcp.project_id and p.from_contact = pcp.contact_id WHERE p.id is not null GROUP BY "pcp"."contact_id") "ps" ON ps.contact_id = contact.id LEFT JOIN (SELECT p.from_contact, sum(p.budget) as budget, sum(p.budget / 100 * p.profit_pct) AS profits, count(distinct p.id) as projects, sum(p.paid_contact_point) as paid_point FROM (SELECT "p".* FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = p.client_id LEFT JOIN "a57be577deb434"."tbl_contacts" "contact" ON p.from_contact = contact.id WHERE ("c"."sales_rep" IN (5301, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5096, 5448, 5420, 1001, 5087, 1008, 5230, 5088, 5208, 1003, 5294, 5357, 5076, 5300, 5089, 5311, 5364, 5295, 1013, 5128, 5203, 1004, 5072, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') AND (("p"."project_status"=3) OR ((p.budget <= p.collected) AND ("p"."project_status"=3)))) "p" GROUP BY "p"."from_contact") "p" ON contact.id = p.from_contact WHERE p.from_contact is not null GROUP BY "from_contact")
15:09:26.313traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.314traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:26.314infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=23) AND ("visit_date"='2025-09-16')
15:09:26.318traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.318traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:09:26.318infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=57, "last_visit_at"='now()' WHERE "id"=56587
15:09:26.319infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/analysis/from-contact-histogram', '{"project_status":["3","-1"],"contact_point_status":"","period":"currentfascalyear","web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":{"category":{"budgetCategory":["\u672a\u8bbe\u7f6e","\u674e\u777f\uff08Rick Li\uff09","\u738b\u660e\u4eae","\u5218\u70b3\u5764","\u97e9\u5f66\u5e73","\u5218\u82f1\u6960","\u5218\u70b3\u5764","\u738b\u5b66\u5a05","\u9a6c\u5a1f"],"profitsCategory":["\u672a\u8bbe\u7f6e","\u97e9\u5f66\u5e73","\u674e\u777f\uff08Rick Li\uff09","\u738b\u660e\u4eae","\u5218\u82f1\u6960","\u5218\u70b3\u5764","\u738b\u5b66\u5a05","\u9a6c\u5a1f","\u5218\u70b3\u5764"],"projectsCategory":["\u672a\u8bbe\u7f6e","\u674e\u777f\uff08Rick Li\uff09","\u5218\u70b3\u5764","\u5218\u82f1\u6960","\u738b\u660e\u4eae","\u97e9\u5f66\u5e73","\u738b\u5b66\u5a05","\u9a6c\u5a1f","\u5218\u70b3\u5764"]},"seriesBudget":[{"key":"0","name":"\u672a\u8bbe\u7f6e","y":"4333.71","data":{"point":"1283630","paid_point":"277175","budget":"43337103.8","profits":"12587806.422870000000000000","projects":147,"from_contact":0,"contact_id":0,"c_id":0}},{"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","y":"149.62","data":{"c_id":5957,"contact_id":5957,"from_contact":5957,"point":"348931.50","budget":"1496232","profits":"42668.044800000000000000","paid_point":"365","projects":"3"}},{"key":4844,"name":"\u738b\u660e\u4eae","y":"30.00","data":{"c_id":4844,"contact_id":4844,"from_contact":4844,"point":"","budget":"300000","profits":"15000.0000000000000000","paid_point":"","projects":"1"}},{"key":1262,"name":"\u5218\u70b3\u5764","y":"12.14","data":{"c_id":1262,"contact_id":1262,"from_contact":1262,"point":"40095.00","budget":"121361","profits":"788.846500000000000000","paid_point":"40095","projects":"1"}},{"key":5912,"name":"\u97e9\u5f66\u5e73","y":"8.00","data":{"c_id":5912,"contact_id":5912,"from_contact":5912,"point":"","budget":"80000","profits":"77000.000000000000000000","paid_point":"","projects":"1"}},{"key":4640,"name":"\u5218\u82f1\u6960","y":"3.50","data":{"c_id":4640,"contact_id":4640,"from_contact":4640,"point":"2940.00","budget":"35000","profits":"3416.000000000000000000","paid_point":"2940","projects":"1"}},{"key":6047,"name":"\u5218\u70b3\u5764","y":"3.26","data":{"c_id":6047,"contact_id":6047,"from_contact":6047,"point":"","budget":"32557","profits":"198.597700000000000000","paid_point":"","projects":"1"}},{"key":5980,"name":"\u738b\u5b66\u5a05","y":"1.53","data":{"c_id":5980,"contact_id":5980,"from_contact":5980,"point":"","budget":"15340","profits":"360.490000000000000000","paid_point":"","projects":"1"}},{"key":6029,"name":"\u9a6c\u5a1f","y":"0.40","data":{"c_id":6029,"contact_id":6029,"from_contact":6029,"point":"","budget":"3994","profits":"267.59800000000000000","paid_point":"","projects":"1"}}],"seriesProfits":[{"key":"0","name":"\u672a\u8bbe\u7f6e","y":"1258.78","data":{"point":"1283630","paid_point":"277175","budget":"43337103.8","profits":"12587806.422870000000000000","projects":147,"from_contact":0,"contact_id":0,"c_id":0}},{"key":5912,"name":"\u97e9\u5f66\u5e73","y":"7.70","data":{"c_id":5912,"contact_id":5912,"from_contact":5912,"point":"","budget":"80000","profits":"77000.000000000000000000","paid_point":"","projects":"1"}},{"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","y":"4.27","data":{"c_id":5957,"contact_id":5957,"from_contact":5957,"point":"348931.50","budget":"1496232","profits":"42668.044800000000000000","paid_point":"365","projects":"3"}},{"key":4844,"name":"\u738b\u660e\u4eae","y":"1.50","data":{"c_id":4844,"contact_id":4844,"from_contact":4844,"point":"","budget":"300000","profits":"15000.0000000000000000","paid_point":"","projects":"1"}},{"key":4640,"name":"\u5218\u82f1\u6960","y":"0.34","data":{"c_id":4640,"contact_id":4640,"from_contact":4640,"point":"2940.00","budget":"35000","profits":"3416.000000000000000000","paid_point":"2940","projects":"1"}},{"key":1262,"name":"\u5218\u70b3\u5764","y":"0.08","data":{"c_id":1262,"contact_id":1262,"from_contact":1262,"point":"40095.00","budget":"121361","profits":"788.846500000000000000","paid_point":"40095","projects":"1"}},{"key":5980,"name":"\u738b\u5b66\u5a05","y":"0.04","data":{"c_id":5980,"contact_id":5980,"from_contact":5980,"point":"","budget":"15340","profits":"360.490000000000000000","paid_point":"","projects":"1"}},{"key":6029,"name":"\u9a6c\u5a1f","y":"0.03","data":{"c_id":6029,"contact_id":6029,"from_contact":6029,"point":"","budget":"3994","profits":"267.59800000000000000","paid_point":"","projects":"1"}},{"key":6047,"name":"\u5218\u70b3\u5764","y":"0.02","data":{"c_id":6047,"contact_id":6047,"from_contact":6047,"point":"","budget":"32557","profits":"198.597700000000000000","paid_point":"","projects":"1"}}],"seriesProjects":[{"key":"0","name":"\u672a\u8bbe\u7f6e","y":147,"data":{"point":"1283630","paid_point":"277175","budget":"43337103.8","profits":"12587806.422870000000000000","projects":147,"from_contact":0,"contact_id":0,"c_id":0}},{"key":5957,"name":"\u674e\u777f\uff08Rick Li\uff09","y":"3","data":{"c_id":5957,"contact_id":5957,"from_contact":5957,"point":"348931.50","budget":"1496232","profits":"42668.044800000000000000","paid_point":"365","projects":"3"}},{"key":1262,"name":"\u5218\u70b3\u5764","y":"1","data":{"c_id":1262,"contact_id":1262,"from_contact":1262,"point":"40095.00","budget":"121361","profits":"788.846500000000000000","paid_point":"40095","projects":"1"}},{"key":4640,"name":"\u5218\u82f1\u6960","y":"1","data":{"c_id":4640,"contact_id":4640,"from_contact":4640,"point":"2940.00","budget":"35000","profits":"3416.000000000000000000","paid_point":"2940","projects":"1"}},{"key":4844,"name":"\u738b\u660e\u4eae","y":"1","data":{"c_id":4844,"contact_id":4844,"from_contact":4844,"point":"","budget":"300000","profits":"15000.0000000000000000","paid_point":"","projects":"1"}},{"key":5912,"name":"\u97e9\u5f66\u5e73","y":"1","data":{"c_id":5912,"contact_id":5912,"from_contact":5912,"point":"","budget":"80000","profits":"77000.000000000000000000","paid_point":"","projects":"1"}},{"key":5980,"name":"\u738b\u5b66\u5a05","y":"1","data":{"c_id":5980,"contact_id":5980,"from_contact":5980,"point":"","budget":"15340","profits":"360.490000000000000000","paid_point":"","projects":"1"}},{"key":6029,"name":"\u9a6c\u5a1f","y":"1","data":{"c_id":6029,"contact_id":6029,"from_contact":6029,"point":"","budget":"3994","profits":"267.59800000000000000","paid_point":"","projects":"1"}},{"key":6047,"name":"\u5218\u70b3\u5764","y":"1","data":{"c_id":6047,"contact_id":6047,"from_contact":6047,"point":"","budget":"32557","profits":"198.597700000000000000","paid_point":"","projects":"1"}}],"totalBudget":45421587.8,"totalProfits":12727505.99987,"totalProjects":157,"totalPoint":1675596.5,"totalPaidPoint":320575,"everyPoint":{"0":"1283630","1262":"40095.00","4640":"2940.00","4844":"","5912":"","5957":"348931.50","5980":"","6029":"","6047":""},"everyBudget":{"0":"43337103.8","1262":"121361","4640":"35000","4844":"300000","5912":"80000","5957":"1496232","5980":"15340","6029":"3994","6047":"32557"},"everyProfits":{"0":"12587806.422870000000000000","1262":"788.846500000000000000","4640":"3416.000000000000000000","4844":"15000.0000000000000000","5912":"77000.000000000000000000","5957":"42668.044800000000000000","5980":"360.490000000000000000","6029":"267.59800000000000000","6047":"198.597700000000000000"},"everyProjects":{"0":147,"1262":"1","4640":"1","4844":"1","5912":"1","5957":"3","5980":"1","6029":"1","6047":"1"}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 15:09:26') RETURNING "id"
15:09:26.321traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:09:26.321traceyii\redis\Connection::executeCommandExecuting Redis Command: SET