ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1d1d188cfe0: POST https://beta.jinchangxiao.com/vue/project/list at 2026-06-01 01:48:08 pm by 43.224.72.82

Log Messages

总计66条数据
TimeLevelCategoryMessage
 
13:48:08.570traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
13:48:08.570traceyii\base\Module::getModuleLoading module: debug
13:48:08.571traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
13:48:08.577traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
13:48:08.577traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
13:48:08.582traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.582infotime tracing start1780292888582748928
13:48:08.582traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
13:48:08.582traceyii\web\Application::handleRequestRoute requested: 'vue/project/list'
13:48:08.582traceyii\base\Module::getModuleLoading module: vue
13:48:08.751infoyii\web\Session::openSession started
13:48:08.752infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5495
13:48:08.752infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:48:08.755traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.755traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:48:08.756traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.756traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:48:08.756infoyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
13:48:08.757traceyii\base\Controller::runActionRoute to run: vue/project/list
13:48:08.757traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.758traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.758traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProject
13:48:08.758traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.758traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.758traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
13:48:08.759traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ProjectController::actionList()
13:48:08.759traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.759traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:48:08.760traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'from_contact_name' in 'app\models\search\ProjectSearch'.
13:48:08.760traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.761traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.762infoyii\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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id" ORDER BY p.bargain_date DESC NULLS LAST, p.created_at DESC) "c"
13:48:08.768infoyii\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 o6a13e2c574d5a.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id" ORDER BY p.bargain_date DESC NULLS LAST, p.created_at DESC LIMIT 20
13:48:08.775infoyii\db\Command::querySELECT count(*) as count, sum(budget), "project_status" FROM (SELECT p.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 "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id") "sub" GROUP BY "project_status"
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: changeProjectStatus3
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: changeProjectStatus4
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: changeProjectStatus5
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.780traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.780infoyii\db\Command::querySELECT "id" AS "key", "project_status" AS "name", "color" FROM "o6a13e2c574d5a"."tbl_project_statuses" WHERE "id" IN (1, 2) ORDER BY "order"
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createProject
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createWorkLog
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createSchedule
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: AccountManager
13:48:08.781traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
13:48:08.781infoyii\db\Command::querySELECT SUM(case when need_analysis = true THEN amount ELSE 0 END) FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))
13:48:08.787infoyii\db\Command::querySELECT SUM(case when need_analysis = true THEN amount ELSE 0 END) FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE ("id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))) AND ("including_tax"=TRUE)
13:48:08.793infoyii\db\Command::querySELECT SUM(erp_settle_amount) FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))
13:48:08.799infoyii\db\Command::querySELECT SUM(amount) FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))
13:48:08.805infoyii\db\Command::querySELECT SUM(amount) FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "contract_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE ("id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id"))) AND ("including_tax"=TRUE))
13:48:08.811infoyii\db\Command::querySELECT SUM(total_contact_point - coalesce(paid_contact_point, 0)) FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id" IN (SELECT "from_project" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "from_project" IN (SELECT "p"."id" FROM "o6a13e2c574d5a"."tbl_projects" "p" LEFT JOIN "o6a13e2c574d5a"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "o6a13e2c574d5a"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "o6a13e2c574d5a"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND (("pa"."engineer_id"='5495')) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep"=5493) OR ("prr"."user_id"=5495) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) GROUP BY "p"."id")))
13:48:08.818traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.818traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
13:48:08.819infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/project/list', '{"ProjectSearch":{"engineer_id":["5495"],"group":"","project_status":"","creator":"","purchaseType":"","engineer_group":"1","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"bargain_date","sort":"DESC","Tsort":"","Tname":""},"page":"1","web_access_token":"BVNSh9YfxWIaBBEpqELLGqJuWOoESJvj"}', '{"code":2000,"result":{"count":{"statusCount":[{"count":0,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#f49b00","sum":0},{"count":0,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#4e6ef2","sum":0},{"count":0,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#3fad00","sum":0},{"count":0,"key":4,"name":"\u5546\u673a\u5931\u8d25","color":"#e5000a","sum":0},{"count":0,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222","sum":0},{"count":0,"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210","color":"#6200fe","sum":0}]},"list":[],"thisUser":"","options":{"Projects[project_status]":{"key":"Projects[project_status]","name":"\u5546\u673a\u72b6\u6001","value":[{"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},{"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"}]}},"can_create":false,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":0,"thispage":1,"pagesize":20},"count2":[{"name":"\u5408\u540c\u603b\u91d1\u989d","value":""},{"name":"\u5df2\u6536\u6b3e","value":""},{"name":"\u672a\u6536\u6b3e","value":0},{"name":"\u5df2\u5f00\u53d1\u7968","value":""},{"name":"\u672a\u5f00\u53d1\u7968","value":0}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 13:48:08', 236158208) RETURNING "id"
13:48:08.820traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13:48:08.820traceyii\redis\Connection::executeCommandExecuting Redis Command: SET