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

Log Messages

总计44条数据
TimeLevelCategoryMessage
 
10:20:44.281traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:20:44.281traceyii\base\Module::getModuleLoading module: debug
10:20:44.281traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:20:44.281traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:20:44.282traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:20:44.282traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.282traceyii\base\Module::getModuleLoading module: gii
10:20:44.282traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:20:44.282traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:20:44.282traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/collect-list'
10:20:44.282traceyii\base\Module::getModuleLoading module: vue
10:20:44.283infoyii\web\Session::openSession started
10:20:44.283infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:20:44.283infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:20:44.288traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.288traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:44.288infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:20:44.289traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.289traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:44.289infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:20:44.291traceyii\base\Controller::runActionRoute to run: vue/analysis/collect-list
10:20:44.291traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.292traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:20:44.292traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionCollectList()
10:20:44.292traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.293traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.294infoyii\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:44.301infoyii\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:44.304infoyii\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 140
10:20:44.307traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.308traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:44.308infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (3864, 3872, 3886, 3881, 3897, 3871, 3868, 3764, 3865, 3855, 3851, 3849, 3832, 3835, 3831, 3875, 3844, 3679, 3866, 3735)
10:20:44.309infoyii\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 (3547, 3700, 3750, 3801, 3805, 3802, 3815, 3811, 3812, 3821, 3825, 3826, 3851, 3814, 3799, 3823, 3803, 3824, 3822, 3781)
10:20:44.309infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 5295, 1004)
10:20:44.310infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (93, 2548, 12, 1301, 2146, 149, 1172, 2007, 2729, 24, 20, 3357)
10:20:44.312traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.312traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:44.312infoyii\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:44.316traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.316traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:20:44.316infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=74, "last_visit_at"='now()' WHERE "id"=59629
10:20:44.318infoyii\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":"8","status":"collected","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":"1321","ticket_type":1,"contract_id":3864,"amount":"25000","collected_date":"2025-05-16 11:42:35","created_at":"2025-05-16 11:42:35","created_by":1013,"description":null,"project":{"id":3803,"key":3803,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd1\u5e74-K-2025","budget":"25000","bargain_date":"2025-03-25","created_by":5300,"client_id":2146,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2146,"key":2146,"name":"\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-16"},{"id":"1319","ticket_type":1,"contract_id":3872,"amount":"598","collected_date":"2025-05-15 17:27:38","created_at":"2025-05-15 17:27:38","created_by":1013,"description":null,"project":{"id":3826,"key":3826,"name":"POTJ25045989-\u56fa\u6001\u786c\u76d8-G-2025","budget":"598","bargain_date":"2025-04-22","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-15"},{"id":"1318","ticket_type":1,"contract_id":3886,"amount":"14400","collected_date":"2025-05-15 17:26:42","created_at":"2025-05-15 17:26:42","created_by":1013,"description":null,"project":{"id":3822,"key":3822,"name":"2025\u7f51\u7edc\u6280\u672f\u670d\u52a1","budget":"48000","bargain_date":"2025-04-28","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-05-15"},{"id":"1316","ticket_type":1,"contract_id":3881,"amount":"237950","collected_date":"2025-05-14 16:47:37","created_at":"2025-05-14 16:47:37","created_by":1013,"description":null,"project":{"id":3823,"key":3823,"name":"\u4fe1\u521b\u5e73\u53f0\u6269\u5bb9-2025\u5e74","budget":"237950","bargain_date":"2025-04-25","created_by":1005,"client_id":20,"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1},"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)"}},"created_at_display":"2025-05-14"},{"id":"1314","ticket_type":1,"contract_id":3897,"amount":"4000","collected_date":"2025-05-14 16:45:04","created_at":"2025-05-14 16:45:04","created_by":1013,"description":null,"project":{"id":3851,"key":3851,"name":"\u6280\u672f\u670d\u52a1-\uff08\u5317\u4eac\u5954\u9a70-PA\u4e00\u4e2a\u6708\u7ef4\u4fdd\u6388\u6743\uff09-2025","budget":"4000","bargain_date":"2025-05-08","created_by":5300,"client_id":2729,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":2729,"key":2729,"name":"PA\u6e20\u9053-\u5317\u4eac\u4e00\u5b9e\u5929\u52e4\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-14"},{"id":"1312","ticket_type":1,"contract_id":3871,"amount":"594","collected_date":"2025-05-13 16:37:05","created_at":"2025-05-13 16:37:05","created_by":1013,"description":null,"project":{"id":3825,"key":3825,"name":"POTJ25045988-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","budget":"594","bargain_date":"2025-04-22","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-13"},{"id":"1311","ticket_type":1,"contract_id":3868,"amount":"598","collected_date":"2025-05-13 16:36:37","created_at":"2025-05-13 16:36:37","created_by":1013,"description":null,"project":{"id":3821,"key":3821,"name":"POBJ25044128-\u56fa\u6001\u786c\u76d8-G-2024","budget":"598","bargain_date":"2025-04-17","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-13"},{"id":"1308","ticket_type":1,"contract_id":3764,"amount":"61770","collected_date":"2025-05-12 17:10:18","created_at":"2025-05-12 17:10:18","created_by":1013,"description":null,"project":{"id":3547,"key":3547,"name":"\u79d1\u7814\u7ecf\u8d39\u8f6f\u4ef6\u5f00\u53d1\u9879\u76ee","budget":"205900","bargain_date":"2025-01-13","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-12"},{"id":"1300","ticket_type":1,"contract_id":3865,"amount":"9952","collected_date":"2025-05-06 14:15:59","created_at":"2025-05-06 14:15:59","created_by":1013,"description":null,"project":{"id":3799,"key":3799,"name":"\u865a\u62df\u5316\u7b2c\u4e09\u65b9\u8fd0\u7ef4\u670d\u52a1-2025","budget":"9952","bargain_date":"2025-04-07","created_by":5300,"client_id":24,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":24,"key":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-05-06"},{"id":"1307","ticket_type":1,"contract_id":3855,"amount":"594","collected_date":"2025-04-29 17:32:55","created_at":"2025-04-29 17:32:55","created_by":1013,"description":null,"project":{"id":3815,"key":3815,"name":"POBJ25040666\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-G-2025","budget":"594","bargain_date":"2025-04-07","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-04-29"},{"id":"1299","ticket_type":1,"contract_id":3851,"amount":"299","collected_date":"2025-04-29 17:32:37","created_at":"2025-04-29 17:32:37","created_by":1013,"description":null,"project":{"id":3812,"key":3812,"name":"POTJ25037886\u56fa\u6001\u786c\u76d8-G-2025","budget":"299","bargain_date":"2025-04-01","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-04-29"},{"id":"1306","ticket_type":1,"contract_id":3849,"amount":"594","collected_date":"2025-04-29 17:32:05","created_at":"2025-04-29 17:32:05","created_by":1013,"description":null,"project":{"id":3811,"key":3811,"name":"POTJ25037379-\u786c\u76d8\u5185\u5b58\u6761-2025","budget":"594","bargain_date":"2025-03-31","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-04-29"},{"id":"1298","ticket_type":1,"contract_id":3832,"amount":"594","collected_date":"2025-04-29 17:31:53","created_at":"2025-04-29 17:31:53","created_by":1013,"description":null,"project":{"id":3802,"key":3802,"name":"POTJ25034538-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","budget":"594","bargain_date":"2025-03-19","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-04-29"},{"id":"1297","ticket_type":1,"contract_id":3835,"amount":"511","collected_date":"2025-04-29 17:30:37","created_at":"2025-04-29 17:30:37","created_by":1013,"description":null,"project":{"id":3805,"key":3805,"name":"POBJ25034995-\u56fa\u6001\u786c\u76d8-G-2025","budget":"511","bargain_date":"2025-03-21","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-04-29"},{"id":"1296","ticket_type":1,"contract_id":3831,"amount":"594","collected_date":"2025-04-29 17:30:02","created_at":"2025-04-29 17:30:02","created_by":1013,"description":null,"project":{"id":3801,"key":3801,"name":"POTJ25034534-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","budget":"594","bargain_date":"2025-03-19","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-04-29"},{"id":"1295","ticket_type":1,"contract_id":3875,"amount":"72177","collected_date":"2025-04-27 17:17:36","created_at":"2025-04-27 17:17:36","created_by":1013,"description":null,"project":{"id":3824,"key":3824,"name":"\u670d\u52a1\u5668+\u9632\u706b\u5899\u65b0\u8d2d-K-2025","budget":"72177","bargain_date":"2025-04-25","created_by":5300,"client_id":3357,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1},"client":{"id":3357,"key":3357,"name":"\u5317\u4eac\u8231\u6e7e\u6587\u5316\u8fd0\u8425\u7ba1\u7406\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},"created_at_display":"2025-04-27"},{"id":"1294","ticket_type":1,"contract_id":3844,"amount":"19100","collected_date":"2025-04-21 17:28:15","created_at":"2025-04-21 17:28:15","created_by":1013,"description":null,"project":{"id":3781,"key":3781,"name":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd","budget":"19100","bargain_date":"2025-03-18","created_by":1004,"client_id":1172,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1},"client":{"id":1172,"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u7269\u6d41\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-04-21"},{"id":"1293","ticket_type":1,"contract_id":3679,"amount":"550000","collected_date":"2025-04-17 17:16:20","created_at":"2025-04-17 17:16:20","created_by":1013,"description":null,"project":{"id":3700,"key":3700,"name":"ADME \u5b9e\u9a8c\u5ba4\u5907\u4efd\u66ff\u6362","budget":"550000","bargain_date":"2024-11-21","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-04-17"},{"id":"1292","ticket_type":1,"contract_id":3866,"amount":"34800","collected_date":"2025-04-17 09:57:40","created_at":"2025-04-17 09:57:40","created_by":1013,"description":null,"project":{"id":3814,"key":3814,"name":"2025veeam\u7eed\u4fdd","budget":"34800","bargain_date":"2025-04-11","created_by":5295,"client_id":2007,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1},"client":{"id":2007,"key":2007,"name":"\u4f2f\u7eb3\u5fb7\u63a7\u5236\u8bbe\u5907(\u5317\u4eac)\u6709\u9650\u516c\u53f8-S"}},"created_at_display":"2025-04-17"},{"id":"1290","ticket_type":1,"contract_id":3735,"amount":"387127.5","collected_date":"2025-04-17 09:55:15","created_at":"2025-04-17 09:55:15","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-04-17"}],"sumAmount":"30343966.91","pagenation":{"totalcount":253,"thispage":8,"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:44') RETURNING "id"
10:20:44.320traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:20:44.320traceyii\redis\Connection::executeCommandExecuting Redis Command: SET