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

Log Messages

总计44条数据
TimeLevelCategoryMessage
 
10:13:36.567traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
10:13:36.567traceyii\base\Module::getModuleLoading module: debug
10:13:36.567traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
10:13:36.567traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
10:13:36.568traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
10:13:36.568traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.568traceyii\base\Module::getModuleLoading module: gii
10:13:36.568traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
10:13:36.568traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
10:13:36.568traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/collect-list'
10:13:36.568traceyii\base\Module::getModuleLoading module: vue
10:13:36.569infoyii\web\Session::openSession started
10:13:36.569infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5016
10:13:36.569infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:13:36.573traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.574traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:13:36.574infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:13:36.575traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.575traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:13:36.575infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:13:36.577traceyii\base\Controller::runActionRoute to run: vue/analysis/collect-list
10:13:36.577traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.578traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
10:13:36.578traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionCollectList()
10:13:36.578traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.579traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.580infoyii\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"='1001') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"
10:13:36.585infoyii\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"='1001') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc) "c"
10:13:36.589infoyii\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"='1001') ORDER BY scp.created_at DESC NULLS LAST, scp.id desc LIMIT 20
10:13:36.591traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.592traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:13:36.592infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4055, 4112, 4144, 4106, 3978, 3997, 3935, 3916, 3967, 3900, 3857, 3803, 3724, 3763, 3703, 3502, 3755)
10:13:36.593infoyii\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 (3751, 3927, 3949, 3950, 3644, 3723, 3767, 3764, 3786, 3816, 3872, 3855, 3886, 3890, 3899, 3744, 3857)
10:13:36.593infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:13:36.594infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2845, 3389, 2616, 2545, 3327, 2553, 3372, 3334, 3304, 2117, 3286, 3364)
10:13:36.595traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.595traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:13:36.595infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-23')
10:13:36.599traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.599traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
10:13:36.600infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=60, "last_visit_at"='now()' WHERE "id"=59629
10:13:36.601infoyii\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","page":"1","status":"collected","web_access_token":"rYIMJ2M0YvHw1MK3H80OQXXQVDLAg_YG"}', '{"code":2000,"result":{"list":[{"id":"12062","ticket_type":1,"contract_id":4055,"amount":"858740.72","collected_date":"2025-10-24 11:44:02","created_at":"2025-10-24 11:44:02","created_by":1013,"description":null,"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","budget":"885300","bargain_date":"2025-07-21","created_by":1001,"client_id":2553,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-10-24"},{"id":"12044","ticket_type":1,"contract_id":4112,"amount":"42448","collected_date":"2025-10-13 13:59:38","created_at":"2025-10-13 13:59:38","created_by":1013,"description":"","project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","budget":"42448","bargain_date":"2025-08-22","created_by":1001,"client_id":3286,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-10-13"},{"id":"12028","ticket_type":1,"contract_id":4144,"amount":"90000","collected_date":"2025-09-17 15:21:49","created_at":"2025-09-17 15:21:49","created_by":1013,"description":"","project":{"id":3950,"key":3950,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899AF-1000-FH2300B","budget":"270000","bargain_date":"2025-09-05","created_by":1001,"client_id":3389,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"}},"created_at_display":"2025-09-17"},{"id":"12023","ticket_type":1,"contract_id":4106,"amount":"15340","collected_date":"2025-09-08 17:06:23","created_at":"2025-09-08 17:06:23","created_by":1013,"description":"","project":{"id":3949,"key":3949,"name":"PA1410\u4e00\u5e74\u670d\u52a1","budget":"15340","bargain_date":"2025-08-19","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-09-08"},{"id":"1363","ticket_type":1,"contract_id":3978,"amount":"17500","collected_date":"2025-06-30 09:53:22","created_at":"2025-06-30 09:53:22","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-30"},{"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":"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":"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":"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":"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"},{"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":"1274","ticket_type":1,"contract_id":3857,"amount":"3994","collected_date":"2025-04-08 14:54:29","created_at":"2025-04-08 14:54:29","created_by":1013,"description":null,"project":{"id":3816,"key":3816,"name":"\u5357\u975e\u7ea2\u77f3\u9879\u76ee\u6570\u636e\u7f51PA440\u8bbe\u5907\u7eed\u4fdd","budget":"3994","bargain_date":"2025-04-07","created_by":1001,"client_id":2117,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2117,"key":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-04-08"},{"id":"1265","ticket_type":1,"contract_id":3803,"amount":"3048204","collected_date":"2025-03-28 14:27:23","created_at":"2025-03-28 14:27:23","created_by":1013,"description":null,"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","budget":"3048204","bargain_date":"2025-02-28","created_by":1001,"client_id":3334,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},"created_at_display":"2025-03-28"},{"id":"1304","ticket_type":1,"contract_id":3724,"amount":"12600.9","collected_date":"2025-03-12 17:16:52","created_at":"2025-03-12 17:16:52","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-03-12"},{"id":"1273","ticket_type":1,"contract_id":3763,"amount":"12136.1","collected_date":"2025-03-12 17:16:37","created_at":"2025-03-12 17:16:37","created_by":1013,"description":null,"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","budget":"121361","bargain_date":"2025-01-16","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-03-12"},{"id":"1272","ticket_type":1,"contract_id":3763,"amount":"84952.7","collected_date":"2025-03-05 11:48:47","created_at":"2025-03-05 11:48:47","created_by":1013,"description":null,"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","budget":"121361","bargain_date":"2025-01-16","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-03-05"},{"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":"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":"1243","ticket_type":1,"contract_id":3502,"amount":"120000","collected_date":"2025-01-24 10:45:26","created_at":"2025-01-24 10:45:26","created_by":1013,"description":null,"project":{"id":3644,"key":3644,"name":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","budget":"120000","bargain_date":"2024-08-28","created_by":1001,"client_id":2553,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"created_at_display":"2025-01-24"},{"id":"1242","ticket_type":1,"contract_id":3755,"amount":"122000","collected_date":"2025-01-24 10:41:10","created_at":"2025-01-24 10:41:10","created_by":1013,"description":null,"project":{"id":3764,"key":3764,"name":"PA1410 \u4e24\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","budget":"122000","bargain_date":"2025-01-13","created_by":1001,"client_id":2616,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4},"client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},"created_at_display":"2025-01-24"}],"sumAmount":"5790166.17","pagenation":{"totalcount":25,"thispage":1,"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 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/142.0.0.0 Safari\/537.36"}', FALSE, '2025-12-23 10:13:36') RETURNING "id"
10:13:36.602traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10:13:36.603traceyii\redis\Connection::executeCommandExecuting Redis Command: SET