6868bfe92a871: POST https://beta.jinchangxiao.com/vue/analysis/sales-collect-list at 2025-07-05 02:02:17 pm by 223.72.35.175
Log Messages
总计43条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 14:02:17.173 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 14:02:17.173 | trace | yii\base\Module::getModule | Loading module: debug |
| 14:02:17.174 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 14:02:17.174 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 14:02:17.174 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 14:02:17.174 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.174 | trace | yii\base\Module::getModule | Loading module: gii |
| 14:02:17.174 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 14:02:17.174 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 14:02:17.174 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/sales-collect-list' |
| 14:02:17.174 | trace | yii\base\Module::getModule | Loading module: vue |
| 14:02:17.175 | info | yii\web\Session::open | Session started |
| 14:02:17.175 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5250 |
| 14:02:17.175 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:02:17.180 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.180 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:02:17.180 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.180 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:02:17.180 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 14:02:17.182 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/sales-collect-list |
| 14:02:17.182 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.183 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 14:02:17.183 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionSalesCollectList() |
| 14:02:17.183 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.183 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.184 | info | yii\db\Command::query | SELECT SUM(amount) FROM (SELECT "scp".* FROM "a57be577deb434"."tbl_sales_contract_payments" "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE (p.id is not null) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) AND ("p"."client_id"='5') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c" |
| 14:02:17.187 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT "scp".* FROM "a57be577deb434"."tbl_sales_contract_payments" "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE (p.id is not null) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) AND ("p"."client_id"='5') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c" |
| 14:02:17.188 | info | yii\db\Command::query | SELECT "scp".* FROM "a57be577deb434"."tbl_sales_contract_payments" "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE (p.id is not null) AND ("p"."created_by" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) AND ("p"."client_id"='5') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc LIMIT 20 |
| 14:02:17.190 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.190 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:02:17.191 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (2286, 2305, 2333, 2149, 1866, 1990, 1426, 1793, 1044, 1794, 1507) |
| 14:02:17.191 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1709, 1982, 2033, 2761, 1806, 1077, 1738, 2859, 2849, 2427, 2671) |
| 14:02:17.192 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 14:02:17.192 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=5 |
| 14:02:17.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.193 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:02:17.193 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05') |
| 14:02:17.197 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.197 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 14:02:17.197 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=123, "last_visit_at"='now()' WHERE "id"=49799 |
| 14:02:17.198 | 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', 5250, 5, 'vue/analysis/sales-collect-list', '{"client_id":"5","page":"1","status":"collected","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":1478,"contract_id":2286,"amount":"675781","created_by":1014,"created_at":"2023-01-30 09:52:29","collected_date":"2023-01-30","description":null,"paid_amount":"675781","project":{"id":2761,"key":2761,"name":"\u5e73\u53f0\u786c\u4ef6\u6269\u5bb9\u9879\u76ee","budget":"6757810","bargain_date":"2022-06-06","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2023-01-30"},{"id":1458,"contract_id":2305,"amount":"1004684","created_by":1014,"created_at":"2022-12-26 15:42:43","collected_date":"2022-12-26","description":null,"paid_amount":"0","project":{"id":2849,"key":2849,"name":"\u601d\u79d1\u53caNetapp\u7eed\u4fdd\u9879\u76ee","budget":"2511710","bargain_date":"2022-06-22","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2022-12-26"},{"id":1451,"contract_id":2286,"amount":"3378905","created_by":1014,"created_at":"2022-12-22 17:18:55","collected_date":"2022-12-22","description":null,"paid_amount":"3378905","project":{"id":2761,"key":2761,"name":"\u5e73\u53f0\u786c\u4ef6\u6269\u5bb9\u9879\u76ee","budget":"6757810","bargain_date":"2022-06-06","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2022-12-22"},{"id":1424,"contract_id":2333,"amount":"353528","created_by":1014,"created_at":"2022-11-01 15:35:49","collected_date":"2022-11-01","description":null,"paid_amount":"0","project":{"id":2859,"key":2859,"name":"2022\u4ea4\u6362\u673a\u7eed\u4fdd","budget":"740792","bargain_date":"2022-06-30","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2022-11-01"},{"id":1367,"contract_id":2333,"amount":"387264","created_by":1014,"created_at":"2022-08-10 15:36:10","collected_date":"2022-08-10","description":null,"paid_amount":"0","project":{"id":2859,"key":2859,"name":"2022\u4ea4\u6362\u673a\u7eed\u4fdd","budget":"740792","bargain_date":"2022-06-30","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2022-08-10"},{"id":1363,"contract_id":2305,"amount":"1507026","created_by":1014,"created_at":"2022-08-05 17:18:30","collected_date":"2022-08-05","description":null,"paid_amount":"0","project":{"id":2849,"key":2849,"name":"\u601d\u79d1\u53caNetapp\u7eed\u4fdd\u9879\u76ee","budget":"2511710","bargain_date":"2022-06-22","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2022-08-05"},{"id":1328,"contract_id":2286,"amount":"2703124","created_by":1014,"created_at":"2022-06-13 16:45:03","collected_date":"2022-06-13","description":null,"paid_amount":"2703124","project":{"id":2761,"key":2761,"name":"\u5e73\u53f0\u786c\u4ef6\u6269\u5bb9\u9879\u76ee","budget":"6757810","bargain_date":"2022-06-06","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2022-06-13"},{"id":1270,"contract_id":2149,"amount":"148855.2","created_by":1014,"created_at":"2021-12-24 15:56:50","collected_date":"2021-12-24","description":null,"paid_amount":"0","project":{"id":2671,"key":2671,"name":"\u4ea4\u6362\u8bbe\u5907\u7eed\u4fdd","budget":"372138","bargain_date":"2021-11-25","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-12-24"},{"id":1259,"contract_id":2149,"amount":"223282.8","created_by":1014,"created_at":"2021-12-02 16:58:56","collected_date":"2021-12-02","description":null,"paid_amount":"148855.2","project":{"id":2671,"key":2671,"name":"\u4ea4\u6362\u8bbe\u5907\u7eed\u4fdd","budget":"372138","bargain_date":"2021-11-25","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-12-02"},{"id":1217,"contract_id":1866,"amount":"551500","created_by":1014,"created_at":"2021-08-30 11:07:13","collected_date":"2021-08-30","description":null,"paid_amount":"0","project":{"id":1806,"key":1806,"name":"\u6570\u636e\u4e2d\u5fc3\u8ba1\u7b97\u6269\u5bb9","budget":"5515000","bargain_date":"2021-01-28","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-08-30"},{"id":1195,"contract_id":1990,"amount":"1153860","created_by":1014,"created_at":"2021-08-02 16:52:18","collected_date":"2021-08-02","description":null,"paid_amount":"0","project":{"id":2427,"key":2427,"name":"\u8bbe\u5907\u7eed\u4fdd\u9879\u76ee","budget":"2307720","bargain_date":"2021-05-26","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-08-02"},{"id":1187,"contract_id":1866,"amount":"2757500","created_by":1014,"created_at":"2021-07-19 17:29:51","collected_date":"2021-07-19","description":null,"paid_amount":"1103000","project":{"id":1806,"key":1806,"name":"\u6570\u636e\u4e2d\u5fc3\u8ba1\u7b97\u6269\u5bb9","budget":"5515000","bargain_date":"2021-01-28","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-07-19"},{"id":1155,"contract_id":1990,"amount":"1153860.00","created_by":1014,"created_at":"2021-06-03 16:31:49","collected_date":"2021-06-03","description":null,"paid_amount":"0","project":{"id":2427,"key":2427,"name":"\u8bbe\u5907\u7eed\u4fdd\u9879\u76ee","budget":"2307720","bargain_date":"2021-05-26","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-06-03"},{"id":1066,"contract_id":1866,"amount":"2206000.00","created_by":1014,"created_at":"2021-02-04 11:21:38","collected_date":"2021-02-04","description":null,"paid_amount":"2206000","project":{"id":1806,"key":1806,"name":"\u6570\u636e\u4e2d\u5fc3\u8ba1\u7b97\u6269\u5bb9","budget":"5515000","bargain_date":"2021-01-28","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-02-04"},{"id":769,"contract_id":1426,"amount":"8000.00","created_by":5016,"created_at":"2021-02-04 09:30:54","collected_date":"2021-02-04","description":null,"paid_amount":"0","project":{"id":1738,"key":1738,"name":"\u5b58\u50a8\u786c\u76d81","budget":"8000","bargain_date":"2020-03-30","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2021-02-04"},{"id":1037,"contract_id":1793,"amount":"101184.80","created_by":1014,"created_at":"2020-12-30 17:26:46","collected_date":"2020-12-30","description":null,"paid_amount":"0","project":{"id":1982,"key":1982,"name":"\u4ea4\u6362\u673a\u7eed\u4fdd","budget":"252962.00","bargain_date":"2020-12-09","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2020-12-30"},{"id":1033,"contract_id":1044,"amount":"917753.00","created_by":1014,"created_at":"2020-12-29 16:49:47","collected_date":"2020-12-29","description":null,"paid_amount":"0","project":{"id":1077,"key":1077,"name":"\u53cc\u6d3b\u6570\u636e\u4e2d\u5fc3\u9879\u76ee","budget":"18355060","bargain_date":"2019-05-13","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2020-12-29"},{"id":1023,"contract_id":1793,"amount":"151777.20","created_by":1014,"created_at":"2020-12-23 15:53:19","collected_date":"2020-12-23","description":null,"paid_amount":"0","project":{"id":1982,"key":1982,"name":"\u4ea4\u6362\u673a\u7eed\u4fdd","budget":"252962.00","bargain_date":"2020-12-09","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2020-12-23"},{"id":1022,"contract_id":1794,"amount":"30600.00","created_by":1014,"created_at":"2020-12-23 15:47:14","collected_date":"2020-12-23","description":null,"paid_amount":"0","project":{"id":2033,"key":2033,"name":"9148\u6388\u6743\u9879\u76ee","budget":"30600.00","bargain_date":"2020-12-09","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2020-12-23"},{"id":953,"contract_id":1507,"amount":"264300.00","created_by":null,"created_at":"","collected_date":null,"description":null,"paid_amount":"0","project":{"id":1709,"key":1709,"name":"idc\u5b58\u50a8\u6269\u5bb9","budget":"2643000.00","bargain_date":"2020-05-12","created_by":1004,"client_id":5,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":5,"key":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"1970-01-01"}],"sumAmount":"59561038.00","pagenation":{"totalcount":63,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:02:17') RETURNING "id" |
| 14:02:17.200 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 14:02:17.200 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |