6a21053a00574: POST https://beta.jinchangxiao.com/vue/project/export at 2026-06-04 12:55:21 pm by 221.216.117.119
Log Messages
总计89条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 12:55:22.001 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 12:55:22.001 | trace | yii\base\Module::getModule | Loading module: debug |
| 12:55:22.001 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 12:55:22.001 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 12:55:22.001 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 12:55:22.001 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.002 | info | time tracing start | 1780548922002098944 |
| 12:55:22.002 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 12:55:22.002 | trace | yii\web\Application::handleRequest | Route requested: 'vue/project/export' |
| 12:55:22.002 | trace | yii\base\Module::getModule | Loading module: vue |
| 12:55:22.002 | info | yii\web\Session::open | Session started |
| 12:55:22.003 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 12:55:22.003 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 12:55:22.006 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.006 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 12:55:22.007 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.007 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 12:55:22.007 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 12:55:22.008 | trace | yii\base\Controller::runAction | Route to run: vue/project/export |
| 12:55:22.008 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.010 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 12:55:22.010 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ProjectController::actionExport() |
| 12:55:22.010 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.010 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 12:55:22.011 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'from_contact_name' in 'app\models\search\ProjectSearch'. |
| 12:55:22.012 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.013 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.014 | info | yii\db\Command::query | 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 (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)) OR ("prr"."user_id"=1001) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (("c"."sales_rep"='5087')) AND (("p"."project_progress"='4')) AND (("ttr2"."taxonomy_id"='232')) GROUP BY "p"."id" ORDER BY "p"."created_at" DESC |
| 12:55:22.025 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2128, 2130) |
| 12:55:22.026 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 12:55:22.029 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 12:55:22.030 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id"=5087 |
| 12:55:22.030 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id"=80 |
| 12:55:22.035 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=6 |
| 12:55:22.035 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=47 |
| 12:55:22.036 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (20, 5) |
| 12:55:22.036 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 12:55:22.036 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1 |
| 12:55:22.037 | info | yii\db\Command::query | SELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (3109, 2755) ORDER BY "contribution" DESC, "engineer_id" |
| 12:55:22.038 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (4, 5) |
| 12:55:22.038 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"=4 |
| 12:55:22.038 | info | yii\db\Command::query | SELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.039 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3109, 2755) |
| 12:55:22.040 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 1, 128, 179, 232, 184, 200, 2100000000, 374, 335, 226, 164, 135, 197, 199, 377, 349)) ORDER BY "sort" |
| 12:55:22.040 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3109, 2755) |
| 12:55:22.041 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 1, 128, 179, 232, 184, 200, 2100000000, 374, 335, 226, 164, 135, 197, 199, 377, 349)) ORDER BY "sort" |
| 12:55:22.043 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3109, 2755) |
| 12:55:22.043 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 1, 128, 179, 232, 184, 200, 2100000000, 374, 335, 226, 164, 135, 197, 199, 377, 349)) ORDER BY "sort" |
| 12:55:22.044 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 12:55:22.044 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 12:55:22.045 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 12:55:22.045 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 12:55:22.045 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 12:55:22.046 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "sales_id"=5087 |
| 12:55:22.046 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_groups" WHERE "id"=80 |
| 12:55:22.046 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1 |
| 12:55:22.048 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2128, 2130) |
| 12:55:22.049 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 |
| 12:55:22.050 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) |
| 12:55:22.050 | info | yii\db\Command::query | SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", sum(points) as points FROM "a57be577deb434"."tbl_case_assignments" GROUP BY "case_id") "ca" ON ca.case_id = c.id WHERE "c"."project_id" IN (3109, 2755) GROUP BY "c"."project_id" |
| 12:55:22.061 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 12:55:22.061 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 12:55:22.061 | info | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("project_id" IN (3109, 2755)) GROUP BY "project_id" |
| 12:55:22.062 | info | yii\db\Command::query | SELECT "project_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3109, 2755) GROUP BY "project_id" |
| 12:55:22.063 | info | yii\db\Command::query | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (3109, 2755)) GROUP BY "project_id" |
| 12:55:22.064 | info | yii\db\Command::query | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (3109, 2755)) GROUP BY "c"."project_id" |
| 12:55:22.077 | info | yii\db\Command::query | SELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3109, 2755)) GROUP BY "c"."project_id" |
| 12:55:22.087 | info | yii\db\Command::query | SELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (3109, 2755)) GROUP BY "project_id" |
| 12:55:22.095 | info | yii\db\Command::query | SELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3109, 2755)) GROUP BY "project_id" |
| 12:55:22.107 | info | yii\db\Command::query | SELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "is_settle", "is_deliver", "is_outbound", "erp_settle_amount", "erp_un_settle_amount", "including_tax", "amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3109, 2755) |
| 12:55:22.121 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.121 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id" IN (3109, 2755) ORDER BY "id" |
| 12:55:22.122 | info | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=1) AND ("object_id" IN (3109, 2755)) GROUP BY "object_id" |
| 12:55:22.195 | info | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=1) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (3109, 2755)) GROUP BY "object_id" |
| 12:55:22.226 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.226 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status" IN (2, 5)) AND ("project_id" IN (3109, 2755)) |
| 12:55:22.227 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_clients" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.228 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2128 |
| 12:55:22.235 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_receivers" WHERE "project_used_client_id"=88 |
| 12:55:22.243 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id"=88 |
| 12:55:22.244 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_payments" WHERE "project_used_client_id"=88 |
| 12:55:22.244 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_used_client_invoices" WHERE "project_used_client_id"=88 |
| 12:55:22.245 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE ("status"=1) AND ("project_id" IN (3109, 2755)) |
| 12:55:22.246 | info | yii\db\Command::query | SELECT s.id, project_id, client_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2026-05-21')) AND ((("is_public"=1) AND ("created_by" != 1001)) OR ("created_by"=1001) OR ("ccr"."user_id"=1001)) AND ("s"."project_id" IN (3109, 2755)) ORDER BY set_top_at DESC nulls last, sort ASC, CASE WHEN is_complete = true THEN complete_at END DESC, CASE WHEN is_complete = false THEN end_at END ASC, end_at DESC |
| 12:55:22.247 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.250 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.255 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "case_no", "project_id" FROM "a57be577deb434"."tbl_cases" WHERE "project_id" IN (3109, 2755) |
| 12:55:22.258 | info | yii\db\Command::query | SELECT "id", "case_id", "engineer_id", "assignment_status", "points", "percent" FROM "a57be577deb434"."tbl_case_assignments" WHERE "case_id" IN (5085, 5407, 5455) ORDER BY "assigned_at" DESC |
| 12:55:22.262 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1015, 1017) |