ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4ccdadcf943: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-bank-view at 2026-07-07 05:58:05 pm by 39.156.194.178

Log Messages

总计66条数据
TimeLevelCategoryMessage
 
17:58:05.849traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:58:05.849traceyii\base\Module::getModuleLoading module: debug
17:58:05.850traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:58:05.850traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:58:05.850traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:58:05.851traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.851infotime tracing start1783418285851828992
17:58:05.852traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:58:05.852traceyii\web\Application::handleRequestRoute requested: 'vue/erp-analysis/list-bank-view'
17:58:05.852traceyii\base\Module::getModuleLoading module: vue
17:58:05.854infoyii\web\Session::openSession started
17:58:05.855infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:58:05.855infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:58:05.857traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.857traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.858infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:58:05.859traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.860traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.860infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:58:05.861traceyii\base\Controller::runActionRoute to run: vue/erp-analysis/list-bank-view
17:58:05.861traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.863traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:58:05.863traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpAnalysisController::actionListBankView()
17:58:05.864infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='1') AND ("settle_at" >= '2026/05/01 00:00:00') AND ("settle_at" <= '2026/05/31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id" ORDER BY settle_at DESC) "c"
17:58:05.870infoyii\db\Command::querySELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='1') AND ("settle_at" >= '2026/05/01 00:00:00') AND ("settle_at" <= '2026/05/31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id" ORDER BY settle_at DESC LIMIT 40
17:58:05.873traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.874traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.874infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:58:05.875infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:58:05.876infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
17:58:05.877infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (982, 3303, 2150, 3278, 3457)
17:58:05.878infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1
17:58:05.878infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" WHERE "erp_bank_amount_change_log_id" IN (1743, 1739, 1738, 1736, 1728, 1725, 1724, 1723, 1721, 1720, 1719, 1717)
17:58:05.879infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1000, 5250, 5016, 5461, 5064, 5332)
17:58:05.880infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2198
17:58:05.882traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.882traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.883infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2198 ORDER BY "id"
17:58:05.884traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.884infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_collect_ticket_settles' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
17:58:05.891infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_collect_ticket_settles' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
17:58:05.904traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.905traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
17:58:05.905infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4476
17:58:05.908traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.908traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.909infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8476
17:58:05.911infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "id"=8473
17:58:05.912infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2197
17:58:05.913infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2197 ORDER BY "id"
17:58:05.914infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_other_collect_tickets" WHERE "id"=53
17:58:05.918traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.918traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.919infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2195
17:58:05.919infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2195 ORDER BY "id"
17:58:05.920infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4457
17:58:05.921infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"=2196
17:58:05.921infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=2196 ORDER BY "id"
17:58:05.922infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4453
17:58:05.923infoyii\db\Command::querySELECT SUM(in_amount) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='1') AND ("settle_at" >= '2026/05/01 00:00:00') AND ("settle_at" <= '2026/05/31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id") "c"
17:58:05.926infoyii\db\Command::querySELECT SUM(out_amount) FROM (SELECT "l".* FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "l" LEFT JOIN "a57be577deb434"."tbl_erp_banks" "b" ON l.erp_bank_id = b.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = l.client_id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON s.id = l.supplier_id LEFT JOIN "a57be577deb434"."tbl_erp_bank_amount_change_log_handlers" "eh" ON eh.erp_bank_amount_change_log_id = l.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON eh.user_id = u.id WHERE ("erp_bank_id"='1') AND ("settle_at" >= '2026/05/01 00:00:00') AND ("settle_at" <= '2026/05/31 23:59:59') AND (in_amount is not null) GROUP BY "l"."id") "c"
17:58:05.929traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.929traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:58:05.929infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-bank-view', '{"created_at_period":"","not_zero":"","is_delete":"","created_at_to":"2026\/05\/31","created_at_from":"2026\/05\/01","erp_bank_id":"1","in_out":"in","keyword":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"code":2000,"result":{"list":[{"id":1743,"object_id":2198,"ticket_type":20013,"serial_no":"SKD-20260522-00001","erp_bank_id":1,"wrote_date":"2026-05-22","status":2,"amount":"100","in_amount":"100","out_amount":"","balance_amount":"1507568.72","supplier_id":"","client_id":982,"contact_id":"","user_id":"","abstract":"","description":"","settle_at":"2026-05-22 16:44:28.936345+08","verify_at":"2026-05-22 16:44:28","created_by":1001,"created_at":"2026-05-22 16:44:28","updated_at":"2026-05-22 16:44:28","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1404,"erp_bank_amount_change_log_id":1743,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":"","settleTickets":[{"type_display":"\u9500\u552e\u5408\u540c","serial_no":"2026-05-20-001","created_at":"2026-05-20 17:33:05"}]},{"id":1739,"object_id":8476,"ticket_type":20018,"serial_no":"XJFYD-20260512-00002","erp_bank_id":1,"wrote_date":"","status":6,"amount":"1","in_amount":"1","out_amount":"","balance_amount":"1507468.72","supplier_id":"","client_id":"","contact_id":"","user_id":"","abstract":"","description":"","settle_at":"2026-05-13 14:04:48.6976+08","verify_at":"2026-05-13 14:04:48","created_by":1001,"created_at":"2026-05-12 13:46:11","updated_at":"2026-05-13 14:04:48","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1402,"erp_bank_amount_change_log_id":1739,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355-\u7ea2\u5b57\u53cd\u51b2","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":"","contract_no":"","settleTickets":[]},{"id":1738,"object_id":6,"ticket_type":20027,"serial_no":"JJD-20260512-00001","erp_bank_id":1,"wrote_date":"2026-05-12","status":6,"amount":"100","in_amount":"100","out_amount":"","balance_amount":"1507467.72","supplier_id":"","client_id":"","contact_id":"","user_id":"","abstract":"\u4e2d\u535a\u6570\u667a\u4f1a\u8bae\u5df2\u7ed3\u675f\uff0c\u5df2\u91cd\u65b0\u68b3\u7406\u91c7\u8d2d\u5408\u540c\u3001\u8d39\u7528\u5408\u540c\u3001\u4ed8\u6b3e\u7ed3\u7b97\u3001\u91c7\u8d2d\u53d1\u7968\u3001\u5165\u5e93\u3001\u4ea7\u54c1\u62c6\u88c5\u7ec4\u88c5\u5168\u4e1a\u52a1\u6d41\u7a0b\u3002","description":"","settle_at":"2026-05-12 15:05:09.151852+08","verify_at":"2026-05-12 15:05:06","created_by":1001,"created_at":"2026-05-12 15:04:47","updated_at":"2026-05-12 15:05:09","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5956\u91d1\u5355-\u7ea2\u5b57\u53cd\u51b2","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":"","contract_no":"","settleTickets":[]},{"id":1736,"object_id":10,"ticket_type":20026,"serial_no":"GSD-20260512-00001","erp_bank_id":1,"wrote_date":"2026-05-12","status":6,"amount":"13","in_amount":"13","out_amount":"","balance_amount":"1507467.72","supplier_id":"","client_id":"","contact_id":"","user_id":"","abstract":"\u4e2d\u535a\u6570\u667a\u4f1a\u8bae\u5df2\u7ed3\u675f\uff0c\u5df2\u91cd\u65b0\u68b3\u7406\u91c7\u8d2d\u5408\u540c\u3001\u8d39\u7528\u5408\u540c\u3001\u4ed8\u6b3e\u7ed3\u7b97\u3001\u91c7\u8d2d\u53d1\u7968\u3001\u5165\u5e93\u3001\u4ea7\u54c1\u62c6\u88c5\u7ec4\u88c5\u5168\u4e1a\u52a1\u6d41\u7a0b\u3002","description":"","settle_at":"2026-05-12 15:04:21.618479+08","verify_at":"2026-05-12 15:04:18","created_by":1001,"created_at":"2026-05-12 15:03:48","updated_at":"2026-05-12 15:04:21","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u4e2a\u7a0e\u5355-\u7ea2\u5b57\u53cd\u51b2","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":"","contract_no":"","settleTickets":[]},{"id":1728,"object_id":8473,"ticket_type":20018,"serial_no":"XJFYD-20260509-00001","erp_bank_id":1,"wrote_date":"","status":6,"amount":"1","in_amount":"1","out_amount":"","balance_amount":"1513102.72","supplier_id":"","client_id":"","contact_id":"","user_id":"","abstract":"","description":"","settle_at":"2026-05-12 13:45:31.187093+08","verify_at":"2026-05-12 13:45:31","created_by":1001,"created_at":"2026-05-09 09:56:50","updated_at":"2026-05-12 13:45:31","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1395,"erp_bank_amount_change_log_id":1728,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1396,"erp_bank_amount_change_log_id":1728,"user_id":5332,"user":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355-\u7ea2\u5b57\u53cd\u51b2","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":"","contract_no":"","settleTickets":[]},{"id":1725,"object_id":39,"ticket_type":20015,"serial_no":"QTSRD-20260512-00001","erp_bank_id":1,"wrote_date":"2026-05-12","status":2,"amount":"5","in_amount":"3","out_amount":"","balance_amount":"1513464.93","supplier_id":"","client_id":3303,"contact_id":"","user_id":"","abstract":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","description":"\u65b0\u5efa\u5229\u6da6\u5212\u62e8\u5355\uff1a>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","settle_at":"2026-05-12 13:42:40.469136+08","verify_at":"2026-05-12 13:42:45","created_by":1001,"created_at":"2026-05-12 13:42:28","updated_at":"2026-05-12 13:42:45","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1390,"erp_bank_amount_change_log_id":1725,"user_id":1000,"user":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"}},{"id":1391,"erp_bank_amount_change_log_id":1725,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363"}},{"id":1392,"erp_bank_amount_change_log_id":1725,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633"}},{"id":1393,"erp_bank_amount_change_log_id":1725,"user_id":5461,"user":{"id":5461,"key":5461,"name":"\u8096\u5e05"}},{"id":1394,"erp_bank_amount_change_log_id":1725,"user_id":5064,"user":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u6536\u5165\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":"","settleTickets":[]},{"id":1724,"object_id":2197,"ticket_type":20013,"serial_no":"SKD-20260512-00003","erp_bank_id":1,"wrote_date":"2026-05-12","status":2,"amount":"2","in_amount":"1","out_amount":"","balance_amount":"1513461.93","supplier_id":"","client_id":2150,"contact_id":"","user_id":"","abstract":"\u5176\u4ed6\u5e94\u4ed8\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b\u5176\u4ed6\u5e94\u4ed8\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","description":"\u5176\u4ed6\u5e94\u4ed8\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","settle_at":"2026-05-12 13:26:23.98462+08","verify_at":"2026-05-12 13:26:23","created_by":1001,"created_at":"2026-05-12 13:26:23","updated_at":"2026-05-12 13:26:23","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1389,"erp_bank_amount_change_log_id":1724,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":2150,"key":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)"},"contract_no":"","settleTickets":[{"type_display":"\u5176\u4ed6\u5e94\u6536\u5355","serial_no":"QTYSD-20260407-00001","created_at":"2026-04-07 16:36:35"}]},{"id":1723,"object_id":55,"ticket_type":20021,"serial_no":"QTYSD-20260512-00001","erp_bank_id":1,"wrote_date":"2026-05-12","status":6,"amount":"1","in_amount":"1","out_amount":"","balance_amount":"1513460.93","supplier_id":"","client_id":3303,"contact_id":"","user_id":"","abstract":"\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5","description":"\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5","settle_at":"2026-05-12 13:24:53.282358+08","verify_at":"2026-05-12 13:24:49","created_by":1001,"created_at":"2026-05-12 13:24:07","updated_at":"2026-05-12 13:24:53","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1388,"erp_bank_amount_change_log_id":1723,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u5e94\u6536\u5355-\u7ea2\u5b57\u53cd\u51b2","bgcolor":"#D900AA","status_display":"\u7ea2\u5b57\u53cd\u51b2","unit":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":"","settleTickets":[]},{"id":1721,"object_id":42,"ticket_type":20020,"serial_no":"QTYFD-20260512-00001","erp_bank_id":1,"wrote_date":"2026-05-12","status":2,"amount":"1","in_amount":"1","out_amount":"","balance_amount":"1513460.93","supplier_id":"","client_id":3303,"contact_id":"","user_id":"","abstract":"\u6d4b\u8bd5","description":"\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5","settle_at":"2026-05-12 13:14:12.506641+08","verify_at":"2026-05-12 13:14:27","created_by":1001,"created_at":"2026-05-12 13:14:12","updated_at":"2026-05-12 13:14:27","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1386,"erp_bank_amount_change_log_id":1721,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":"","settleTickets":[]},{"id":1720,"object_id":40,"ticket_type":20020,"serial_no":"QTYFD-20260331-00001","erp_bank_id":1,"wrote_date":"2026-03-31","status":2,"amount":"8","in_amount":"8","out_amount":"","balance_amount":"1513459.93","supplier_id":"","client_id":3278,"contact_id":"","user_id":"","abstract":"g\u8bf4\u7684\u98ce\u683c","description":"\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5\u5b98\u65b9\u54e5\u54e5\u54e5\u54e5\u54e5\u54e5","settle_at":"2026-05-12 13:11:45.31372+08","verify_at":"2026-05-12 13:11:50","created_by":1001,"created_at":"2026-03-31 14:13:45","updated_at":"2026-05-12 13:11:50","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1385,"erp_bank_amount_change_log_id":1720,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u5176\u4ed6\u5e94\u4ed8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"contract_no":"","settleTickets":[]},{"id":1719,"object_id":2195,"ticket_type":20013,"serial_no":"SKD-20260512-00002","erp_bank_id":1,"wrote_date":"2026-05-12","status":2,"amount":"1","in_amount":"1","out_amount":"","balance_amount":"1513451.93","supplier_id":"","client_id":982,"contact_id":"","user_id":"","abstract":"","description":"","settle_at":"2026-05-12 13:09:24.254299+08","verify_at":"2026-05-12 13:09:24","created_by":1001,"created_at":"2026-05-12 13:09:24","updated_at":"2026-05-12 13:09:24","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1384,"erp_bank_amount_change_log_id":1719,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":"","settleTickets":[{"type_display":"\u9500\u552e\u5408\u540c","serial_no":"2026-04-08-001","created_at":"2026-04-08 11:18:13"}]},{"id":1717,"object_id":2196,"ticket_type":20013,"serial_no":"SKD-20260512-00001","erp_bank_id":1,"wrote_date":"2026-05-12","status":2,"amount":"1","in_amount":"1","out_amount":"","balance_amount":"1513451.93","supplier_id":"","client_id":3457,"contact_id":"","user_id":"","abstract":"1","description":"1","settle_at":"2026-05-12 13:08:42.252032+08","verify_at":"2026-05-12 13:08:53","created_by":1001,"created_at":"2026-05-12 13:08:42","updated_at":"2026-05-12 13:08:53","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"user":"","contact":"","erpBank":{"id":1,"key":1,"name":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530"},"handlers":[{"id":1382,"erp_bank_amount_change_log_id":1717,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"is_payment_settle":"","settle_amount":"","ticket_type_display":"\u6536\u6b3e\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"contract_no":"","settleTickets":[{"type_display":"\u9500\u552e\u5408\u540c","serial_no":"2026-04-01-001","created_at":"2026-04-01 11:28:03"}]}],"in_amount":"231","out_amount":"","pagenation":{"totalcount":12,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 17:58:05', 77726976) RETURNING "id"
17:58:05.932traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:58:05.933traceyii\redis\Connection::executeCommandExecuting Redis Command: SET