20:07:54.754 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
20:07:54.754 | trace | yii\base\Module::getModule | Loading module: debug |
20:07:54.755 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
20:07:54.755 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
20:07:54.755 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
20:07:54.755 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
20:07:54.755 | trace | yii\base\Module::getModule | Loading module: gii |
20:07:54.755 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
20:07:54.755 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
20:07:54.755 | trace | yii\web\Application::handleRequest | Route requested: 'vue/search/purchase-contract-by-supplier-id' |
20:07:54.755 | trace | yii\base\Module::getModule | Loading module: vue |
20:07:54.756 | info | yii\web\Session::open | Session started |
20:07:54.756 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
20:07:54.756 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
20:07:54.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
20:07:54.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
20:07:54.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
20:07:54.761 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
20:07:54.762 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
20:07:54.763 | trace | yii\base\Controller::runAction | Route to run: vue/search/purchase-contract-by-supplier-id |
20:07:54.763 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\SearchController::actionPurchaseContractBySupplierId() |
20:07:54.764 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name", "created_at" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "supplier_id"='431' ORDER BY "signed_at" DESC |
20:07:54.765 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4080, 2364, 2216, 2198, 2114) ORDER BY "id" |
20:07:54.766 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (14, 2120) |
20:07:54.767 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=2706 |
20:07:54.768 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
20:07:54.768 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
20:07:54.769 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/search/purchase-contract-by-supplier-id', '{"supplier_id":"431","web_access_token":"J23LUPtW6VCG7IfkCPCVdqFa_zEBghkd"}', '{"code":2000,"result":[{"id":4080,"key":4080,"name":"222222(2025-08-11)","created_at":"2025-08-11 18:59:40","purchaseClientRels":[]},{"id":2364,"key":2364,"name":"BJHLXT-GFJ-20220610(2022-08-03)","created_at":"2022-08-03 10:59:27","purchaseClientRels":[]},{"id":2216,"key":2216,"name":"20220211(2022-02-25)","created_at":"2022-02-25 15:17:24","purchaseClientRels":[]},{"id":2198,"key":2198,"name":"BJHLXT-GFJ-2021207(2022-01-21)","created_at":"2022-01-21 09:26:04","purchaseClientRels":[{"id":962,"contract_id":2198,"client_id":2120,"project_id":2706,"client":{"id":2120,"key":2120,"name":"\u8fbd\u5b81\u5e86\u9633\u7279\u79cd\u5316\u5de5\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004},"project":{"id":2706,"key":2706,"name":"\u56fd\u4ea7\u5316\u6d4b\u8bd5\u673a"}}]},{"id":2114,"key":2114,"name":"BJHLXT-GFJ-20210928(2021-10-26)","created_at":"2021-10-26 11:38:52","purchaseClientRels":[{"id":873,"contract_id":2114,"client_id":14,"project_id":null,"client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":null}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-11 20:07:54') RETURNING "id" |
20:07:54.770 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
20:07:54.770 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |