ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689afc11e0696: POST https://beta.jinchangxiao.com/vue/search/purchase-contract-by-supplier-id at 2025-08-12 04:32:17 pm by 114.254.2.139

Log Messages

总计30条数据
TimeLevelCategoryMessage
 
16:32:17.918traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:32:17.918traceyii\base\Module::getModuleLoading module: debug
16:32:17.919traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:32:17.919traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:32:17.919traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:32:17.919traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:32:17.919traceyii\base\Module::getModuleLoading module: gii
16:32:17.919traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:32:17.919traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:32:17.919traceyii\web\Application::handleRequestRoute requested: 'vue/search/purchase-contract-by-supplier-id'
16:32:17.919traceyii\base\Module::getModuleLoading module: vue
16:32:17.920infoyii\web\Session::openSession started
16:32:17.920infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:32:17.920infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:32:17.925traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:32:17.925traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:32:17.925traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:32:17.926traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:32:17.926infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:32:17.928traceyii\base\Controller::runActionRoute to run: vue/search/purchase-contract-by-supplier-id
16:32:17.928traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SearchController::actionPurchaseContractBySupplierId()
16:32:17.928infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no" AS "name", "created_at" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "supplier_id"='38' ORDER BY "signed_at" DESC
16:32:17.929infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (4077, 3902, 3999, 3773, 3212, 3109, 2641, 2594, 2480, 2177, 2091, 2007, 1855, 1831, 1802, 1782, 1321, 1173) ORDER BY "id"
16:32:17.932infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (89, 15, 5, 1301, 1492, 57, 1331, 24, 497, 2532, 2545, 20, 2762)
16:32:17.933infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1946, 1973, 1388, 2647, 2711, 2601, 3013, 2994, 2974, 3069, 3149, 3433, 3760, 3855, 3823, 3910)
16:32:17.934traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:32:17.934traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:32:17.934infoyii\db\Command::queryINSERT 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":"38","web_access_token":"Hc6bcOPECvJmn-MxoPjAzgccBe0xyT-M"}', '{"code":2000,"result":[{"id":4077,"key":4077,"name":"TSKJ20250801-WJC-001(2025-08-01)","created_at":"2025-08-01 13:30:47","purchaseClientRels":[{"id":3653,"contract_id":4077,"client_id":2762,"project_id":3910,"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":5087},"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee"}}]},{"id":3902,"key":3902,"name":"\u672a\u8bbe\u7f6e(2025-05-13)","created_at":"2025-05-13 16:24:19","purchaseClientRels":[{"id":3312,"contract_id":3902,"client_id":2545,"project_id":3855,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db"}}]},{"id":3999,"key":3999,"name":"\u672a\u8bbe\u7f6e(2025-06-25)","created_at":"2025-06-25 13:38:06","purchaseClientRels":[{"id":3478,"contract_id":3999,"client_id":20,"project_id":3823,"client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":3823,"key":3823,"name":"\u4fe1\u521b\u5e73\u53f0\u6269\u5bb9-2025\u5e74"}}]},{"id":3773,"key":3773,"name":"TSKJ20250110-WJC-001(2025-01-22)","created_at":"2025-01-22 14:28:57","purchaseClientRels":[{"id":2979,"contract_id":3773,"client_id":2545,"project_id":3760,"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3760,"key":3760,"name":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee"}}]},{"id":3212,"key":3212,"name":"20240326-WJC(2024-03-28)","created_at":"2024-03-28 10:33:23","purchaseClientRels":[{"id":1865,"contract_id":3212,"client_id":2532,"project_id":3433,"client":{"id":2532,"key":2532,"name":"\u5317\u4eac\u65b9\u5dde\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":5087},"project":{"id":3433,"key":3433,"name":"\u4f53\u7cfb\u6548\u80fd\u7cbe\u51c6\u9884\u793a\u4e0e\u7efc\u5408\u5206\u6790\u7cfb\u7edf-K1"}}]},{"id":3109,"key":3109,"name":"YJTS20240126-1(2024-01-26)","created_at":"2024-01-26 16:12:45","purchaseClientRels":[{"id":1765,"contract_id":3109,"client_id":497,"project_id":3149,"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3149,"key":3149,"name":"\u5f02\u5730\u5907\u4efd-2023-G"}}]},{"id":2641,"key":2641,"name":"YJTS20230427(2023-04-28)","created_at":"2023-04-28 11:12:38","purchaseClientRels":[]},{"id":2594,"key":2594,"name":"TSKJ20230316-WJC-001(2023-03-17)","created_at":"2023-03-17 10:47:37","purchaseClientRels":[{"id":1295,"contract_id":2594,"client_id":24,"project_id":3069,"client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8","sales_rep":5300},"project":{"id":3069,"key":3069,"name":"HP\u670d\u52a1\u5668\u91c7\u8d2d-2023"}}]},{"id":2480,"key":2480,"name":"YSTS20221110-1(2022-11-11)","created_at":"2022-11-11 13:23:58","purchaseClientRels":[{"id":1184,"contract_id":2480,"client_id":1331,"project_id":3013,"client":{"id":1331,"key":1331,"name":"\u4e09\u76db\u667a\u6167\u6559\u80b2\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4e2d\u80b2\u8d1d\u62c9\u56fd\u9645\u6559\u80b2\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6c47\u51a0\u89e6\u6478\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5311},"project":{"id":3013,"key":3013,"name":"\u6570\u636e\u8fc1\u79fb-\u670d\u52a1\u5668\u786c\u76d8\u65b0\u8d2d"}},{"id":1185,"contract_id":2480,"client_id":1492,"project_id":2994,"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":2994,"key":2994,"name":"\u601d\u79d1\u670d\u52a1\u5668\u7528\u5185\u5b58"}},{"id":1186,"contract_id":2480,"client_id":1301,"project_id":2974,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295},"project":{"id":2974,"key":2974,"name":"\u670d\u52a1\u5668\u65b0\u8d2d"}}]},{"id":2177,"key":2177,"name":"YJTS20211221-1(2021-12-23)","created_at":"2021-12-23 11:13:41","purchaseClientRels":[{"id":951,"contract_id":2177,"client_id":1301,"project_id":2647,"client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":5295},"project":{"id":2647,"key":2647,"name":"\u5b89\u5168\u52a0\u56fa(\u4e1a\u52a1\u7f51)"}},{"id":952,"contract_id":2177,"client_id":1492,"project_id":2711,"client":{"id":1492,"key":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":2711,"key":2711,"name":"\u670d\u52a1\u5668\u5185\u5b58\u6269\u5bb9"}}]},{"id":2091,"key":2091,"name":"YJTS20210914-1(2021-09-16)","created_at":"2021-09-16 10:44:33","purchaseClientRels":[{"id":953,"contract_id":2091,"client_id":57,"project_id":2601,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","sales_rep":1005},"project":{"id":2601,"key":2601,"name":"\u65e0\u9521\u6570\u636e\u4e2d\u5fc3\u601d\u79d1\u8d85\u878d\u5408\u5185\u5b58\u6269\u5bb9"}}]},{"id":2007,"key":2007,"name":"-(2021-06-21)","created_at":"2021-06-21 09:14:28","purchaseClientRels":[]},{"id":1855,"key":1855,"name":"-(2021-01-26)","created_at":"2021-01-26 15:21:08","purchaseClientRels":[{"id":774,"contract_id":1855,"client_id":15,"project_id":1973,"client":{"id":15,"key":15,"name":"\u4e2d\u51b6\u4eac\u8bda\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u6c14\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)(\u5317\u4eac\u4eac\u8bda\u8d5b\u745e\u56fe\u6587\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":1004},"project":{"id":1973,"key":1973,"name":"\u670d\u52a1\u5668"}}]},{"id":1831,"key":1831,"name":"YJTS20210108-1(2021-01-11)","created_at":"2021-01-11 15:59:30","purchaseClientRels":[{"id":56,"contract_id":1831,"client_id":15,"project_id":1973,"client":{"id":15,"key":15,"name":"\u4e2d\u51b6\u4eac\u8bda\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u6c14\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)(\u5317\u4eac\u4eac\u8bda\u8d5b\u745e\u56fe\u6587\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":1004},"project":{"id":1973,"key":1973,"name":"\u670d\u52a1\u5668"}}]},{"id":1802,"key":1802,"name":"-(2020-12-17)","created_at":"2020-12-17 10:02:17","purchaseClientRels":[{"id":55,"contract_id":1802,"client_id":89,"project_id":1946,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":1946,"key":1946,"name":"2020\u5e74\u5206\u652f\u673a\u6784\u865a\u62df\u5316\u53ca\u5907\u4efd\u9879\u76ee"}}]},{"id":1782,"key":1782,"name":"YJTS20201204(2020-12-04)","created_at":"2020-12-04 14:24:47","purchaseClientRels":[{"id":762,"contract_id":1782,"client_id":89,"project_id":1946,"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","sales_rep":1005},"project":{"id":1946,"key":1946,"name":"2020\u5e74\u5206\u652f\u673a\u6784\u865a\u62df\u5316\u53ca\u5907\u4efd\u9879\u76ee"}}]},{"id":1321,"key":1321,"name":"AX-2019112001(2020-01-08)","created_at":"2020-01-08 15:14:49","purchaseClientRels":[]},{"id":1173,"key":1173,"name":"AX-2019090901(2019-09-10)","created_at":"2019-09-10 16:14:18","purchaseClientRels":[{"id":435,"contract_id":1173,"client_id":5,"project_id":1388,"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1004},"project":{"id":1388,"key":1388,"name":"\u670d\u52a1\u5668"}}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-12 16:32:17') RETURNING "id"
16:32:17.936traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:32:17.936traceyii\redis\Connection::executeCommandExecuting Redis Command: SET