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

Log Messages

总计44条数据
TimeLevelCategoryMessage
 
10:20:43.424traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:20:43.424traceyii\base\Module::getModuleLoading module: debug
10:20:43.424traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:20:43.425traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:20:43.425traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:20:43.425traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.425traceyii\base\Module::getModuleLoading module: gii
10:20:43.425traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:20:43.425traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:20:43.425traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/collect-list'
10:20:43.425traceyii\base\Module::getModuleLoading module: vue
10:20:43.426infoyii\web\Session::openSession started
10:20:43.426infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:20:43.426infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:20:43.431traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.431traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:43.431infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:20:43.432traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.432traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:43.432infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:20:43.434traceyii\base\Controller::runActionRoute to run: vue/analysis/collect-list
10:20:43.434traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.435traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:20:43.435traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionCollectList()
10:20:43.435traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.436traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.437infoyii\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:20:43.443infoyii\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:20:43.447infoyii\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 120
10:20:43.450traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.450traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:43.450infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3887, 2927, 2996, 3060, 3905, 3919, 3912, 2991, 3795, 3892, 3895, 3879, 3878, 3910, 3920, 3735, 3705, 3899, 3900, 3736)
10:20:43.451infoyii\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 (3810, 3859, 3845, 3352, 3389, 3720, 3699, 3750, 3783, 3828, 3829, 3853, 3850, 3858, 3855, 3860, 3862, 3355, 3149, 3856)
10:20:43.452infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001, 5300, 5087, 5295)
10:20:43.452infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (93, 2548, 2094, 149, 2545, 12, 497, 3333, 3359, 2526, 2727, 2158, 2202, 1492, 3366)
10:20:43.455traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.455traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:43.455infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-23')
10:20:43.459traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.459traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:43.459infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=73, "last_visit_at"='now()' WHERE "id"=59629
10:20:43.461infoyii\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":"7","status":"collected","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":"1347","ticket_type":1,"contract_id":3887,"amount":"219300","collected_date":"2025-06-12 10:05:06","created_at":"2025-06-12 10:05:06","created_by":1013,"description":null,"project":{"id":3845,"key":3845,"name":"\u91cd\u578b\u673a\u68b0\u4fe1\u521b\u8f6f\u4ef6\u4e8c\u671f","budget":"219300","bargain_date":"2025-04-28","created_by":1005,"client_id":3359,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":3359,"key":3359,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-12"},{"id":"11929","ticket_type":1,"contract_id":2927,"amount":"9500","collected_date":"2025-06-12 10:00:34","created_at":"2025-06-12 10:00:34","created_by":1013,"description":null,"project":{"id":3355,"key":3355,"name":"oracle\u670d\u52a1","budget":"9500","bargain_date":"2023-12-27","created_by":5087,"client_id":2526,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-12"},{"id":"1346","ticket_type":1,"contract_id":2996,"amount":"11500","collected_date":"2025-06-12 09:59:40","created_at":"2025-06-12 09:59:40","created_by":1013,"description":null,"project":{"id":3352,"key":3352,"name":"\u6d4b\u63a7\u6280\u672f\u670d\u52a1\u8d39\uff08\u76f4\u7b7e\uff09","budget":"11500","bargain_date":"2023-12-27","created_by":5087,"client_id":2526,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1},"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-12"},{"id":"1345","ticket_type":1,"contract_id":3060,"amount":"120000","collected_date":"2025-06-10 16:46:59","created_at":"2025-06-10 16:46:59","created_by":1013,"description":null,"project":{"id":3149,"key":3149,"name":"\u5f02\u5730\u5907\u4efd-2023-G","budget":"1200000","bargain_date":"2024-01-01","created_by":5300,"client_id":497,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-10"},{"id":"1343","ticket_type":1,"contract_id":3905,"amount":"897","collected_date":"2025-06-06 17:41:33","created_at":"2025-06-06 17:41:33","created_by":1013,"description":null,"project":{"id":3856,"key":3856,"name":"POBJ25052425-\u56fa\u6001\u786c\u76d8-G-2025","budget":"897","bargain_date":"2025-05-14","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-06-06"},{"id":"1342","ticket_type":1,"contract_id":3919,"amount":"9950","collected_date":"2025-06-05 16:22:12","created_at":"2025-06-05 16:22:12","created_by":1013,"description":null,"project":{"id":3860,"key":3860,"name":"\u98de\u5854\u9632\u706b\u5899\u7eed\u4fdd1\u5e74-G-2025","budget":"9950","bargain_date":"2025-05-20","created_by":5300,"client_id":2202,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09"}},"created_at_display":"2025-06-05"},{"id":"1341","ticket_type":1,"contract_id":3912,"amount":"529000","collected_date":"2025-06-05 16:20:23","created_at":"2025-06-05 16:20:23","created_by":1013,"description":null,"project":{"id":3859,"key":3859,"name":"\u8d35\u5dde\u4e00\u4f53\u5316\u5b9e\u6218\u5e73\u53f0\u9879\u76ee","budget":"529000","bargain_date":"2025-05-19","created_by":1005,"client_id":2094,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)"}},"created_at_display":"2025-06-05"},{"id":"1339","ticket_type":1,"contract_id":2991,"amount":"51750","collected_date":"2025-06-04 16:59:37","created_at":"2025-06-04 16:59:37","created_by":1013,"description":null,"project":{"id":3389,"key":3389,"name":"\u5929\u7ffc\u4e912023\u5e74GA\u4e92\u8054\u7f51+\u653f\u52a1\u670d\u52a1\u5e73\u53f0\u8fb9\u754c\u5b89\u5168\u8de8\u7f51\u4ea4\u4e92\u670d\u52a1\uff08\u6df1\u4fe1\u670d\u8fc7\u5355\uff09","budget":"103500","bargain_date":"2023-12-04","created_by":1005,"client_id":2727,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":2727,"key":2727,"name":"\u4e0a\u6d77\u8fb0\u9510\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-04"},{"id":"1338","ticket_type":1,"contract_id":3795,"amount":"693000","collected_date":"2025-06-03 14:48:35","created_at":"2025-06-03 14:48:35","created_by":1013,"description":null,"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","budget":"2310000","bargain_date":"2025-02-21","created_by":1005,"client_id":3333,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-03"},{"id":"1337","ticket_type":1,"contract_id":3892,"amount":"1145250","collected_date":"2025-05-30 15:11:15","created_at":"2025-05-30 15:11:15","created_by":1013,"description":null,"project":{"id":3810,"key":3810,"name":"NETAPP\u5b58\u50a8\u7eed\u4fdd\u670d\u52a1-2025\u5e74","budget":"1527000","bargain_date":"2025-05-09","created_by":1005,"client_id":1492,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"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)"}},"created_at_display":"2025-05-30"},{"id":"1335","ticket_type":1,"contract_id":3895,"amount":"6546","collected_date":"2025-05-29 17:04:20","created_at":"2025-05-29 17:04:20","created_by":1013,"description":null,"project":{"id":3853,"key":3853,"name":"POAM25051307-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","budget":"6546","bargain_date":"2025-05-12","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-05-29"},{"id":"1384","ticket_type":1,"contract_id":3879,"amount":"511","collected_date":"2025-05-29 17:03:46","created_at":"2025-05-29 17:03:46","created_by":1013,"description":null,"project":{"id":3829,"key":3829,"name":"POTJ25047226-\u56fa\u6001\u786c\u76d8-2025-G","budget":"511","bargain_date":"2025-04-27","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-05-29"},{"id":"1334","ticket_type":1,"contract_id":3878,"amount":"594","collected_date":"2025-05-29 17:03:35","created_at":"2025-05-29 17:03:35","created_by":1013,"description":null,"project":{"id":3828,"key":3828,"name":"POTJ25046505-\u56fa\u6001\u786c\u76d8+\u5185\u5b58-2025","budget":"594","bargain_date":"2025-04-27","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-05-29"},{"id":"1333","ticket_type":1,"contract_id":3910,"amount":"129750","collected_date":"2025-05-28 16:35:56","created_at":"2025-05-28 16:35:56","created_by":1013,"description":null,"project":{"id":3858,"key":3858,"name":"\u5b9e\u9a8c\u5ba4\u5b58\u50a8\u7eed\u4fdd","budget":"173000","bargain_date":"2025-05-13","created_by":1005,"client_id":1492,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"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)"}},"created_at_display":"2025-05-28"},{"id":"1331","ticket_type":1,"contract_id":3920,"amount":"1600","collected_date":"2025-05-20 16:41:26","created_at":"2025-05-20 16:41:26","created_by":1013,"description":null,"project":{"id":3862,"key":3862,"name":"\u65b0\u8d2d\u786c\u76d8","budget":"1600","bargain_date":"2025-05-20","created_by":5295,"client_id":3366,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":3366,"key":3366,"name":"\u8fc7\u5355-\u5317\u4eac\u4e2d\u4f01\u6613\u4ed8\u5546\u52a1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff09"}},"created_at_display":"2025-05-20"},{"id":"1329","ticket_type":1,"contract_id":3735,"amount":"77425.5","collected_date":"2025-05-19 16:38:23","created_at":"2025-05-19 16:38:23","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-05-19"},{"id":"1328","ticket_type":1,"contract_id":3705,"amount":"458000","collected_date":"2025-05-16 16:54:30","created_at":"2025-05-16 16:54:30","created_by":1013,"description":null,"project":{"id":3699,"key":3699,"name":"\u7b2c\u4e8c\u56ed\u533a\u65b0\u8d2d\u51fa\u53e3\u9632\u706b\u5899-\u98de\u5854","budget":"458000","bargain_date":"2024-11-29","created_by":1005,"client_id":93,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-16"},{"id":"1326","ticket_type":1,"contract_id":3899,"amount":"8900","collected_date":"2025-05-16 14:40:48","created_at":"2025-05-16 14:40:48","created_by":1013,"description":null,"project":{"id":3850,"key":3850,"name":"\u6df1\u4fe1\u670dAC-1000-C600\u7eed\u4fdd-G-2025","budget":"8900","bargain_date":"2025-05-13","created_by":5300,"client_id":2158,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2158,"key":2158,"name":"\u4e2d\u8d6b\u96c6\u56e2\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u8d6b\u534e\u6052\u745e\u623f\u5730\u4ea7\u5f00\u53d1\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-16"},{"id":"1325","ticket_type":1,"contract_id":3900,"amount":"40630","collected_date":"2025-05-16 11:46:39","created_at":"2025-05-16 11:46:39","created_by":1013,"description":null,"project":{"id":3855,"key":3855,"name":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u56db","budget":"40630","bargain_date":"2025-05-13","created_by":1001,"client_id":2545,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-16"},{"id":"1324","ticket_type":1,"contract_id":3736,"amount":"90515","collected_date":"2025-05-16 11:44:51","created_at":"2025-05-16 11:44:51","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-05-16"}],"sumAmount":"30343966.91","pagenation":{"totalcount":253,"thispage":7,"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:20:43') RETURNING "id"
10:20:43.463traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:43.463traceyii\redis\Connection::executeCommandExecuting Redis Command: SET