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

Log Messages

总计44条数据
TimeLevelCategoryMessage
 
10:21:39.358traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:21:39.358traceyii\base\Module::getModuleLoading module: debug
10:21:39.359traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:21:39.359traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:21:39.359traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:21:39.359traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.359traceyii\base\Module::getModuleLoading module: gii
10:21:39.359traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:21:39.360traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:21:39.360traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/collect-list'
10:21:39.360traceyii\base\Module::getModuleLoading module: vue
10:21:39.360infoyii\web\Session::openSession started
10:21:39.361infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:21:39.361infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:21:39.367traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.368traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:39.368infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:21:39.369traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.370traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:39.370infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:21:39.373traceyii\base\Controller::runActionRoute to run: vue/analysis/collect-list
10:21:39.373traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.375traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:21:39.375traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionCollectList()
10:21:39.375traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.376traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.378infoyii\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:39.389infoyii\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:39.395infoyii\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 100
10:21:39.400traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.400traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:39.401infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3997, 3664, 3989, 3954, 3943, 3942, 3930, 3935, 3966, 3965, 3978, 3861, 3916, 3626, 3953, 3941, 3952, 3958, 3967)
10:21:39.402infoyii\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 (3875, 3694, 3666, 3877, 3872, 3865, 3798, 3876, 3879, 3866, 3870, 3852, 3836, 3886, 3890, 3899, 3896, 3857, 3834)
10:21:39.403infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 1001, 5295)
10:21:39.404infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (918, 287, 2545, 528, 1301, 12, 3373, 3372, 189, 31, 2845, 2177, 3367, 3364)
10:21:39.406traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.406traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:39.407infoyii\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:39.415traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.415traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:21:39.415infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=88, "last_visit_at"='now()' WHERE "id"=59629
10:21:39.417infoyii\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":"6","status":"collected","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":"1358","ticket_type":1,"contract_id":3997,"amount":"8982","collected_date":"2025-06-26 16:37:30","created_at":"2025-06-26 16:37:30","created_by":1013,"description":null,"project":{"id":3899,"key":3899,"name":"AF-1000-FH1300A\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u9879\u76ee","budget":"8982","bargain_date":"2025-06-24","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-06-26"},{"id":"1356","ticket_type":1,"contract_id":3664,"amount":"154900","collected_date":"2025-06-26 16:36:47","created_at":"2025-06-26 16:36:47","created_by":1013,"description":null,"project":{"id":3666,"key":3666,"name":"24-25\u5e74\u7eed\u4fdd\u9879\u76ee","budget":"387250","bargain_date":"2024-11-30","created_by":1005,"client_id":918,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-26"},{"id":"1352","ticket_type":1,"contract_id":3989,"amount":"4500","collected_date":"2025-06-20 16:39:36","created_at":"2025-06-20 16:39:36","created_by":1013,"description":null,"project":{"id":3896,"key":3896,"name":"\u65b0\u8d2dSSL-VPN\u6388\u6743","budget":"4500","bargain_date":"2025-06-20","created_by":5295,"client_id":3373,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":3373,"key":3373,"name":"\u5317\u4eac\u8f68\u9053\u8fb0\u5149\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-20"},{"id":"1389","ticket_type":1,"contract_id":3954,"amount":"594","collected_date":"2025-06-19 18:03:41","created_at":"2025-06-19 18:03:41","created_by":1013,"description":null,"project":{"id":3879,"key":3879,"name":"POTJ25060424-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","budget":"594","bargain_date":"2025-06-04","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-19"},{"id":"1385","ticket_type":1,"contract_id":3943,"amount":"598","collected_date":"2025-06-19 18:03:29","created_at":"2025-06-19 18:03:29","created_by":1013,"description":null,"project":{"id":3877,"key":3877,"name":"POTJ25057452\u56fa\u6001\u786c\u76d8-2025","budget":"598","bargain_date":"2025-05-29","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-19"},{"id":"1348","ticket_type":1,"contract_id":3942,"amount":"594","collected_date":"2025-06-19 18:03:17","created_at":"2025-06-19 18:03:17","created_by":1013,"description":null,"project":{"id":3876,"key":3876,"name":"POTJ25057451\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","budget":"594","bargain_date":"2025-05-29","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-19"},{"id":"1344","ticket_type":1,"contract_id":3930,"amount":"52000","collected_date":"2025-06-19 18:01:40","created_at":"2025-06-19 18:01:40","created_by":1013,"description":null,"project":{"id":3865,"key":3865,"name":"2025\u5353\u8c6a\u8fd0\u7ef4\u8f6f\u4ef6\u65b0\u8d2d\u548c\u7eed\u4fdd","budget":"52000","bargain_date":"2025-06-05","created_by":5295,"client_id":2177,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":2177,"key":2177,"name":"\u4e2d\u79cd\u56fd\u9645\u79cd\u5b50\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-19"},{"id":"1340","ticket_type":1,"contract_id":3935,"amount":"32557","collected_date":"2025-06-19 17:57:49","created_at":"2025-06-19 17:57:49","created_by":1013,"description":null,"project":{"id":3872,"key":3872,"name":"PA1410 Bundle Lic\u91c7\u8d2d\u9879\u76ee","budget":"32557","bargain_date":"2025-05-28","created_by":1001,"client_id":2845,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-19"},{"id":"1336","ticket_type":1,"contract_id":3966,"amount":"25680","collected_date":"2025-06-17 17:15:55","created_at":"2025-06-17 17:15:55","created_by":1013,"description":null,"project":{"id":3836,"key":3836,"name":"2025veeam\u4ea7\u54c1\u7eed\u4fdd","budget":"25680","bargain_date":"2025-05-12","created_by":5295,"client_id":31,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":31,"key":31,"name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-17"},{"id":"1332","ticket_type":1,"contract_id":3965,"amount":"16500","collected_date":"2025-06-17 17:15:02","created_at":"2025-06-17 17:15:02","created_by":1013,"description":null,"project":{"id":3870,"key":3870,"name":"2025\u7ef4\u4fdd\u670d\u52a1-K","budget":"16500","bargain_date":"2025-05-12","created_by":5295,"client_id":31,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":31,"key":31,"name":"\u4e1c\u65b9\u7f51\u529b\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-17"},{"id":"1362","ticket_type":1,"contract_id":3978,"amount":"17500","collected_date":"2025-06-17 11:10:10","created_at":"2025-06-17 11:10:10","created_by":1013,"description":null,"project":{"id":3890,"key":3890,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee","budget":"35000","bargain_date":"2025-06-16","created_by":1001,"client_id":3372,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09"}},"created_at_display":"2025-06-17"},{"id":"1322","ticket_type":1,"contract_id":3861,"amount":"199428","collected_date":"2025-06-17 11:08:08","created_at":"2025-06-17 11:08:08","created_by":1013,"description":null,"project":{"id":3798,"key":3798,"name":"2025PA\u9632\u706b\u5899\u7eed\u4fdd-K","budget":"199428","bargain_date":"2025-04-08","created_by":5295,"client_id":528,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":528,"key":528,"name":"\u5317\u4eac\u8bfa\u8bda\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8(\u5357\u4eac\u5929\u5370\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u5929\u8bda\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u6c47\u8bda\u5065\u534e)"}},"created_at_display":"2025-06-17"},{"id":"1317","ticket_type":1,"contract_id":3916,"amount":"570000","collected_date":"2025-06-17 10:13:55","created_at":"2025-06-17 10:13:55","created_by":1013,"description":null,"project":{"id":3857,"key":3857,"name":"PA1410 \u4e09\u5e74\u670d\u52a13\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"570000","bargain_date":"2025-05-19","created_by":1001,"client_id":3364,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3364,"key":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"created_at_display":"2025-06-17"},{"id":"1315","ticket_type":1,"contract_id":3626,"amount":"737875","collected_date":"2025-06-16 17:35:16","created_at":"2025-06-16 17:35:16","created_by":1013,"description":null,"project":{"id":3694,"key":3694,"name":"PA\u9632\u706b\u5899\u65b0\u8d2d-2024-C","budget":"2672450","bargain_date":"2024-12-31","created_by":5300,"client_id":287,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"}},"created_at_display":"2025-06-16"},{"id":"1313","ticket_type":1,"contract_id":3626,"amount":"598350","collected_date":"2025-06-16 17:32:47","created_at":"2025-06-16 17:32:47","created_by":1013,"description":null,"project":{"id":3694,"key":3694,"name":"PA\u9632\u706b\u5899\u65b0\u8d2d-2024-C","budget":"2672450","bargain_date":"2024-12-31","created_by":5300,"client_id":287,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":287,"key":287,"name":"\u5317\u4eac\u5954\u9a70\u6c7d\u8f66\u6709\u9650\u516c\u53f8\uff08\u70df\u53f0\u4fca\u9a70\u7535\u6c14\u81ea\u52a8\u5316\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u6d69\u60a6\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09"}},"created_at_display":"2025-06-16"},{"id":"1354","ticket_type":1,"contract_id":3953,"amount":"15300","collected_date":"2025-06-13 16:58:32","created_at":"2025-06-13 16:58:32","created_by":1013,"description":null,"project":{"id":3834,"key":3834,"name":"2025veeam\u7eed\u4fdd","budget":"15300","bargain_date":"2025-05-30","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-06-13"},{"id":"1353","ticket_type":1,"contract_id":3941,"amount":"5100","collected_date":"2025-06-13 16:57:59","created_at":"2025-06-13 16:57:59","created_by":1013,"description":null,"project":{"id":3875,"key":3875,"name":"25\u5e74\u65b0\u8d2d\u670d\u52a1\u5668\u4e3b\u677f\u548c\u786c\u76d8","budget":"5100","bargain_date":"2025-06-04","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-06-13"},{"id":"1351","ticket_type":1,"contract_id":3952,"amount":"8200","collected_date":"2025-06-13 16:56:58","created_at":"2025-06-13 16:56:58","created_by":1013,"description":null,"project":{"id":3866,"key":3866,"name":"\u6280\u672f\u670d\u52a1-2025","budget":"8200","bargain_date":"2025-05-28","created_by":5300,"client_id":3367,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":3367,"key":3367,"name":"\u5317\u4eac\u7f51\u667a\u7396\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-06-13"},{"id":"1350","ticket_type":1,"contract_id":3958,"amount":"221180","collected_date":"2025-06-12 14:04:02","created_at":"2025-06-12 14:04:02","created_by":1013,"description":null,"project":{"id":3852,"key":3852,"name":"2025XDR\u3001\u63a2\u9488\u7eed\u4fdd\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u65b0\u8d2d","budget":"221180","bargain_date":"2025-05-26","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-06-12"},{"id":"1349","ticket_type":1,"contract_id":3967,"amount":"26550","collected_date":"2025-06-12 14:02:12","created_at":"2025-06-12 14:02:12","created_by":1013,"description":null,"project":{"id":3886,"key":3886,"name":"SR650\u670d\u52a1\u5668\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","budget":"26550","bargain_date":"2025-06-09","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-06-12"}],"sumAmount":"30343966.91","pagenation":{"totalcount":253,"thispage":6,"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:39') RETURNING "id"
10:21:39.420traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:21:39.420traceyii\redis\Connection::executeCommandExecuting Redis Command: SET