ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6949fc8d616c6: POST https://beta.jinchangxiao.com/vue/analysis/collect-list at 2025-12-23 10:21:01 am by 223.72.15.12

Log Messages

总计44条数据
TimeLevelCategoryMessage
 
10:21:01.398traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:21:01.398traceyii\base\Module::getModuleLoading module: debug
10:21:01.398traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:21:01.399traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:21:01.399traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:21:01.399traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.399traceyii\base\Module::getModuleLoading module: gii
10:21:01.399traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:21:01.400traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:21:01.400traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/collect-list'
10:21:01.400traceyii\base\Module::getModuleLoading module: vue
10:21:01.400infoyii\web\Session::openSession started
10:21:01.402infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:21:01.402infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:21:01.407traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.408traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:01.408infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:21:01.410traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.410traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:01.410infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:21:01.412traceyii\base\Controller::runActionRoute to run: vue/analysis/collect-list
10:21:01.412traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.414traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:21:01.414traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionCollectList()
10:21:01.414traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.414traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.416infoyii\db\Command::querySELECT SUM(amount) FROM (SELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "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 ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"
10:21:01.423infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "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 ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"
10:21:01.426infoyii\db\Command::querySELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) )) "sub") "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 ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc LIMIT 20 OFFSET 200
10:21:01.429traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.430traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:01.430infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3496, 3791, 3790, 3783, 3777, 3703, 3738, 3368, 3735, 3787, 3767, 3697, 3724, 3770, 3736, 3691, 3693, 3694)
10:21:01.431infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3774, 3770, 3578, 3641, 3732, 3736, 3735, 3734, 3768, 3723, 3749, 3720, 3750, 3771, 3776, 3761, 3769, 3744)
10:21:01.431infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295, 1005, 5087, 1001, 1004)
10:21:01.432infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 107, 2548, 3281, 3326, 149, 3327, 3302, 97, 48, 3280, 189, 1301, 3304)
10:21:01.434traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.434traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:01.434infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-23')
10:21:01.438traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.438traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:01.438infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=77, "last_visit_at"='now()' WHERE "id"=59629
10:21:01.439infoyii\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/analysis/collect-list', '{"dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420,5448,5449","page":"11","status":"collected","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":"1245","ticket_type":1,"contract_id":3496,"amount":"69589.8","collected_date":"2025-03-05 11:47:18","created_at":"2025-03-05 11:47:18","created_by":1013,"description":null,"project":{"id":3641,"key":3641,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0\u65b0\u8d2d","budget":"152959.6","bargain_date":"2024-08-15","created_by":5295,"client_id":3281,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"}},"created_at_display":"2025-03-05"},{"id":"1239","ticket_type":1,"contract_id":3791,"amount":"5869.5","collected_date":"2025-02-28 16:52:02","created_at":"2025-02-28 16:52:02","created_by":1013,"description":null,"project":{"id":3771,"key":3771,"name":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9","budget":"5869.5","bargain_date":"2025-02-24","created_by":5295,"client_id":3281,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"}},"created_at_display":"2025-02-28"},{"id":"1241","ticket_type":1,"contract_id":3790,"amount":"22200","collected_date":"2025-02-27 17:01:50","created_at":"2025-02-27 17:01:50","created_by":1013,"description":null,"project":{"id":3770,"key":3770,"name":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6","budget":"22200","bargain_date":"2025-02-07","created_by":5295,"client_id":189,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821"}},"created_at_display":"2025-02-27"},{"id":"1228","ticket_type":1,"contract_id":3783,"amount":"3200","collected_date":"2025-02-25 17:11:38","created_at":"2025-02-25 17:11:38","created_by":1013,"description":null,"project":{"id":3776,"key":3776,"name":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","budget":"3200","bargain_date":"2025-02-17","created_by":1004,"client_id":48,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-02-25"},{"id":"1214","ticket_type":1,"contract_id":3777,"amount":"30000","collected_date":"2025-02-24 17:29:15","created_at":"2025-02-24 17:29:15","created_by":1013,"description":null,"project":{"id":3761,"key":3761,"name":"2025\u65b0\u8d2d\u6280\u672f\u670d\u52a1","budget":"30000","bargain_date":"2025-02-10","created_by":5295,"client_id":107,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-02-24"},{"id":"1206","ticket_type":1,"contract_id":3703,"amount":"319460.45","collected_date":"2025-02-24 10:15:41","created_at":"2025-02-24 10:15:41","created_by":1013,"description":null,"project":{"id":3723,"key":3723,"name":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"319460.45","bargain_date":"2024-12-11","created_by":1001,"client_id":3304,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-24"},{"id":"1222","ticket_type":1,"contract_id":3738,"amount":"280000","collected_date":"2025-02-21 16:01:13","created_at":"2025-02-21 16:01:13","created_by":1013,"description":null,"project":{"id":3749,"key":3749,"name":"ZStack\u8d85\u878d\u5408\u8fc7\u5355","budget":"400000","bargain_date":"2024-09-10","created_by":1004,"client_id":3302,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":3302,"key":3302,"name":"\u6210\u90fd\u7cbe\u7075\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-21"},{"id":"1256","ticket_type":1,"contract_id":3368,"amount":"122200","collected_date":"2025-02-20 11:19:25","created_at":"2025-02-20 11:19:25","created_by":1013,"description":null,"project":{"id":3578,"key":3578,"name":"ZStack\u4e91\u8f6f\u4ef6","budget":"122200","bargain_date":"2024-08-29","created_by":1004,"client_id":3280,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":3280,"key":3280,"name":"\u5317\u4eac\u4f17\u901a\u667a\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8\/\u4e2d\u56fd\u822a\u6cb9\u96c6\u56e2\u77f3\u6cb9\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08ZStack\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-20"},{"id":"1258","ticket_type":1,"contract_id":3735,"amount":"309702","collected_date":"2025-02-18 14:24:27","created_at":"2025-02-18 14:24:27","created_by":1013,"description":null,"project":{"id":3750,"key":3750,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f","budget":"774255","bargain_date":"2024-12-16","created_by":1005,"client_id":2548,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":2548,"key":2548,"name":"\u5317\u4eac\u6da6\u7fd4\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-18"},{"id":"1254","ticket_type":1,"contract_id":3787,"amount":"1000","collected_date":"2025-02-17 16:47:04","created_at":"2025-02-17 16:47:04","created_by":1013,"description":null,"project":{"id":3774,"key":3774,"name":"\u6280\u672f\u670d\u52a11\u6b21-G-2025","budget":"1000","bargain_date":"2025-02-11","created_by":5300,"client_id":97,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-02-17"},{"id":"1252","ticket_type":1,"contract_id":3767,"amount":"1320","collected_date":"2025-02-14 10:16:08","created_at":"2025-02-14 10:16:08","created_by":1013,"description":null,"project":{"id":3768,"key":3768,"name":"\u670d\u52a1\u5668\u66f4\u6362\u914d\u4ef6","budget":"1320","bargain_date":"2025-01-20","created_by":5295,"client_id":1301,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"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)"}},"created_at_display":"2025-02-14"},{"id":"1221","ticket_type":1,"contract_id":3738,"amount":"120000","collected_date":"2025-02-12 16:14:45","created_at":"2025-02-12 16:14:45","created_by":1013,"description":null,"project":{"id":3749,"key":3749,"name":"ZStack\u8d85\u878d\u5408\u8fc7\u5355","budget":"400000","bargain_date":"2024-09-10","created_by":1004,"client_id":3302,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":3302,"key":3302,"name":"\u6210\u90fd\u7cbe\u7075\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-12"},{"id":"1244","ticket_type":1,"contract_id":3697,"amount":"101040","collected_date":"2025-02-11 09:13:42","created_at":"2025-02-11 09:13:42","created_by":5388,"description":null,"project":{"id":3736,"key":3736,"name":"\u897f\u660c\u7f51\u5173\u9879\u76ee-K","budget":"293040","bargain_date":"2024-10-30","created_by":5087,"client_id":3326,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-11"},{"id":"1110","ticket_type":1,"contract_id":3697,"amount":"192000","collected_date":"2025-02-11 09:13:10","created_at":"2025-02-11 09:13:10","created_by":5388,"description":null,"project":{"id":3736,"key":3736,"name":"\u897f\u660c\u7f51\u5173\u9879\u76ee-K","budget":"293040","bargain_date":"2024-10-30","created_by":5087,"client_id":3326,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-11"},{"id":"1277","ticket_type":1,"contract_id":3724,"amount":"88206.3","collected_date":"2025-02-10 15:25:51","created_at":"2025-02-10 15:25:51","created_by":1013,"description":null,"project":{"id":3744,"key":3744,"name":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"126009","bargain_date":"2024-12-25","created_by":1001,"client_id":3327,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-10"},{"id":"1219","ticket_type":1,"contract_id":3770,"amount":"32000","collected_date":"2025-02-10 13:25:13","created_at":"2025-02-10 13:25:13","created_by":1013,"description":null,"project":{"id":3769,"key":3769,"name":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","budget":"32000","bargain_date":"2025-03-05","created_by":5087,"client_id":3326,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"}},"created_at_display":"2025-02-10"},{"id":"1323","ticket_type":1,"contract_id":3736,"amount":"362060","collected_date":"2025-02-10 13:20:52","created_at":"2025-02-10 13:20:52","created_by":1013,"description":null,"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f","budget":"905150","bargain_date":"2024-12-24","created_by":1005,"client_id":149,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"}},"created_at_display":"2025-02-10"},{"id":"1211","ticket_type":1,"contract_id":3691,"amount":"598","collected_date":"2025-02-10 13:17:31","created_at":"2025-02-10 13:17:31","created_by":1013,"description":null,"project":{"id":3732,"key":3732,"name":"POTJ24120916-\u56fa\u6001\u786c\u76d8-G-2024","budget":"598","bargain_date":"2024-12-05","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-02-10"},{"id":"1210","ticket_type":1,"contract_id":3693,"amount":"594","collected_date":"2025-02-10 13:17:12","created_at":"2025-02-10 13:17:12","created_by":1013,"description":null,"project":{"id":3734,"key":3734,"name":"POTJ24120918-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-G-2024","budget":"594","bargain_date":"2024-12-05","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-02-10"},{"id":"1207","ticket_type":1,"contract_id":3694,"amount":"594","collected_date":"2025-02-10 13:16:36","created_at":"2025-02-10 13:16:36","created_by":1013,"description":null,"project":{"id":3735,"key":3735,"name":"POTJ24120919-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-G-2024","budget":"594","bargain_date":"2024-12-05","created_by":5300,"client_id":12,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-02-10"}],"sumAmount":"30343966.91","pagenation":{"totalcount":253,"thispage":11,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.12","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-23 10:21:01') RETURNING "id"
10:21:01.442traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:01.442traceyii\redis\Connection::executeCommandExecuting Redis Command: SET