ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685b643ac1871: POST https://beta.jinchangxiao.com/v2/project/of-client at 2025-06-25 10:51:38 am by 211.137.80.11

Log Messages

总计49条数据
TimeLevelCategoryMessage
 
10:51:38.792traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:51:38.792traceyii\base\Module::getModuleLoading module: debug
10:51:38.792traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:51:38.792traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:51:38.792traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:51:38.793traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.793traceyii\base\Module::getModuleLoading module: gii
10:51:38.793traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:51:38.794traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:51:38.794traceyii\web\Application::handleRequestRoute requested: 'v2/project/of-client'
10:51:38.794traceyii\base\Module::getModuleLoading module: v2
10:51:38.794infoyii\web\Session::openSession started
10:51:38.795infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:51:38.797infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'
10:51:38.802traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.802traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:51:38.802traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.802traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:51:38.803infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
10:51:38.805traceyii\base\Controller::runActionRoute to run: v2/project/of-client
10:51:38.805traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProject
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
10:51:38.806traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
10:51:38.806traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ProjectController::actionOfClient()
10:51:38.807infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='3332') AND ("deleted"=FALSE)
10:51:38.808traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.809traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:51:38.810traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.810traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:51:38.815traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.816traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.818infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."client_id"=3332) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC) "c"
10:51:38.835infoyii\db\Command::querySELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5295, 5311)) OR ("prr"."user_id"=5295) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5295))) AND ("p"."client_id"=3332) GROUP BY "p"."id" ORDER BY "bargain_date" DESC, "p"."created_at" DESC LIMIT 10
10:51:38.846traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createProject
10:51:38.846traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesDirector
10:51:38.846traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: SalesManager
10:51:38.846traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
10:51:38.846traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:51:38.847traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:51:38.847infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1141, 'v2/project/of-client', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","id":"3332","page":"1","posttime":"1750819840","token":"68e06f3db1665b8e7bcbb1059fdfeb5f","version_code":"1141"}', '{"code":200,"data":{"list":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 10:51:38') RETURNING "id"