ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a759502443: POST https://beta.jinchangxiao.com/vue/erp-dashboard/list-settle at 2026-06-11 04:45:09 pm by 221.216.117.119

Performance Profiling

Total processing time: 148 ms; Peak memory: 4.255 MB. Show Profiling Timeline

总计15条数据
TimeDurationCategoryInfo
  
16:45:09.04135.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub" ORDER BY is_payment_settle asc, sub.created_at DESC) "c"
16:45:09.07722.1 msyii\db\Command::querySELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub" ORDER BY is_payment_settle asc, sub.created_at DESC LIMIT 40
16:45:09.12715.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub") "sub" WHERE ("ticket_type" IN (20018, 20023, 20024, 20025, 20026, 20027, 20012, 20019)) AND ("is_payment_settle"=TRUE)
16:45:09.1068.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub") "sub"
16:45:09.1157.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub") "sub" WHERE ("ticket_type" IN (20018, 20023, 20024, 20025, 20026, 20027)) AND ("is_payment_settle"=FALSE)
16:45:09.0276.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:45:09.1224.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT * FROM (SELECT (r.id::varchar || 20012::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, r.user_id as user_id, r.contact_id as contact_id, r.wrote_date, r.serial_no, 20012 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id") "sub") UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20019::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20019 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20023::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20023 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, settle_amount >= amount as is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20024::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20024 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20025::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20025 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20026::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20026 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20027::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, r.wrote_date, r.serial_no, 20027 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 GROUP BY "r"."id" )) "sub") "sub" WHERE ("ticket_type" IN (20012, 20019)) AND ("is_payment_settle"=FALSE)
16:45:09.1463.2 msyii\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-dashboard/list-settle', '{"status":"4","page":"1","pageSize":"40","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"id":8489,"id2":8489,"supplier_id":431,"client_id":"","user_id":"","contact_id":"","wrote_date":"2026-06-04","serial_no":"XJFYD-20260604-00001","ticket_type":20018,"abstract":"1","description":"","created_by":1001,"amount":"1","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-06-04 12:58:22","verify_at":"2026-06-04 12:58:22","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":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"}},{"id":11,"id2":11,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2026-06-01","serial_no":"GSD-20260601-00001","ticket_type":20026,"abstract":"1000","description":"","created_by":1001,"amount":"13000","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-06-01 12:52:52","verify_at":"2026-06-01 12:52:52","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":{},"ticket_type_display":"\u4e2a\u7a0e\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":8,"id2":8,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2026-06-01","serial_no":"GJJD-20260601-00001","ticket_type":20025,"abstract":"\u6d4b\u8bd5","description":"","created_by":1001,"amount":"46000","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-06-01 12:52:33","verify_at":"2026-06-01 12:52:33","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":{},"ticket_type_display":"\u516c\u79ef\u91d1\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":13,"id2":13,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2026-06-01","serial_no":"SBD-20260601-00001","ticket_type":20024,"abstract":"1000","description":"","created_by":1001,"amount":"184000","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-06-01 12:51:43","verify_at":"2026-06-01 12:51:43","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":{},"ticket_type_display":"\u793e\u4fdd\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":16,"id2":16,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2026-06-01","serial_no":"GZD-20260601-00003","ticket_type":20023,"abstract":"\u6d4b\u8bd5","description":"","created_by":1001,"amount":"186022","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-06-01 12:40:41","verify_at":"2026-06-01 12:40:41","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":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":15,"id2":15,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2026-06-01","serial_no":"GZD-20260601-00002","ticket_type":20023,"abstract":"\u6d4b\u8bd5","description":"","created_by":1001,"amount":"186022","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-06-01 12:37:27","verify_at":"2026-06-01 12:37: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":{},"user":{},"contact":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":8483,"id2":8483,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260522-00001","ticket_type":20018,"abstract":"","description":"","created_by":1001,"amount":"900","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-22 17:48:45","verify_at":"2026-05-22 17:48: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":{},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{}},{"id":2360,"id2":2360,"supplier_id":307,"client_id":"","user_id":"","contact_id":"","wrote_date":"2026-05-20","serial_no":"FKD-20260520-00001","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"200","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-20 11:25:08","verify_at":"2026-05-20 11:25:08","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":{"id":307,"key":307,"name":"\u5317\u4eac\u4e5d\u5dde\u5b89\u548c\u673a\u7535\u8bbe\u5907\u5b89\u88c5\u5de5\u7a0b\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":307,"key":307,"name":"\u5317\u4eac\u4e5d\u5dde\u5b89\u548c\u673a\u7535\u8bbe\u5907\u5b89\u88c5\u5de5\u7a0b\u6709\u9650\u516c\u53f8"}},{"id":9,"id2":9,"supplier_id":"","client_id":"","user_id":"","contact_id":"","wrote_date":"2026-05-12","serial_no":"GZD-20260512-00001","ticket_type":20023,"abstract":"7\u3001\u73b0\u91d1\u8d39\u7528\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\u4fdd\u5b58\u4e3a\u8349\u7a3f\u3001\u8d39\u7528\u62a5\u9500\u751f\u6210\u73b0\u91d1\u8d39\u7528\u5355\u3001\u6279\u91cf\u7ed3\u7b97\uff1b","description":"","created_by":1001,"amount":"46","status":2,"settle_amount":"23","is_payment_settle":false,"created_at":"2026-05-12 13:56:29","verify_at":"2026-05-12 13:56:46","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":{},"ticket_type_display":"\u5de5\u8d44\u5355","bgcolor":"#02A7F0","status_display":"\u5df2\u8ba1\u63d0","unit":{}},{"id":2357,"id2":2357,"supplier_id":"","client_id":2553,"user_id":"","contact_id":"","wrote_date":"2026-05-12","serial_no":"FKD-20260512-00005","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"800","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-12 13:43:51","verify_at":"2026-05-12 13:43:51","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":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":2356,"id2":2356,"supplier_id":"","client_id":2150,"user_id":"","contact_id":"","wrote_date":"2026-05-12","serial_no":"FKD-20260512-00004","ticket_type":20012,"abstract":"\u6d4b\u6492","description":"","created_by":1001,"amount":"2","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-12 13:13:24","verify_at":"2026-05-12 13:13: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":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":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","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)"}},{"id":2355,"id2":2355,"supplier_id":"","client_id":2150,"user_id":"","contact_id":"","wrote_date":"2026-05-12","serial_no":"FKD-20260512-00003","ticket_type":20012,"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","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","created_by":1001,"amount":"2","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-12 13:12:36","verify_at":"2026-05-12 13:12:36","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":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","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)"}},{"id":2354,"id2":2354,"supplier_id":756,"client_id":"","user_id":"","contact_id":"","wrote_date":"2026-05-12","serial_no":"FKD-20260512-00002","ticket_type":20012,"abstract":"5345","description":"rwre","created_by":1001,"amount":"1","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-05-12 13:07:40","verify_at":"2026-05-12 13:07:40","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":{"id":756,"key":756,"name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":756,"key":756,"name":"\u5317\u4eac\u667a\u5fb7\u5929\u8bda\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8461,"id2":8461,"supplier_id":"","client_id":89,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00024","ticket_type":20018,"abstract":"\u5c71\u4e1c\u62db\u91d1\u6570\u636e\u4e2d\u5fc3\u4fe1\u606f\u6536\u96c6\uff0c3\u670815-3\u670818\u53f7\u51fa\u5dee\u8865\u52a9","description":"","created_by":5248,"amount":"1200","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:15","verify_at":"2026-04-22 15:46:15","createdBy":{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M","department_id":2,"avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":89,"key":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)"}},{"id":8460,"id2":8460,"supplier_id":"","client_id":2762,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00023","ticket_type":20018,"abstract":"33\u6240\u670d\u52a1\u5668\u552e\u540e\u95ee\u9898\u5904\u7406","description":"","created_by":1023,"amount":"98.78","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"}},{"id":8459,"id2":8459,"supplier_id":"","client_id":2125,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00022","ticket_type":20018,"abstract":"239\u5382\u670d\u52a1\u5668\u552e\u540e\u95ee\u9898\u5904\u7406","description":"","created_by":1023,"amount":"96.32","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"}},{"id":8458,"id2":8458,"supplier_id":"","client_id":2191,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00021","ticket_type":20018,"abstract":"2026\u5e742\u6708\u901a\u8baf\u8d39","description":"","created_by":5085,"amount":"100","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2191,"key":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2191,"key":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8457,"id2":8457,"supplier_id":"","client_id":2191,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00020","ticket_type":20018,"abstract":"2026\u5e741\u6708\u901a\u8baf\u8d39","description":"","created_by":5085,"amount":"100","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2191,"key":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2191,"key":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8456,"id2":8456,"supplier_id":"","client_id":93,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00019","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"195.9","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8"}},{"id":8455,"id2":8455,"supplier_id":"","client_id":149,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00018","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"90.56","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"}},{"id":8454,"id2":8454,"supplier_id":"","client_id":149,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00017","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"109.3","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"}},{"id":8453,"id2":8453,"supplier_id":"","client_id":149,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00016","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"65.84","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"}},{"id":8452,"id2":8452,"supplier_id":"","client_id":149,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00015","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"87.8","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"}},{"id":8451,"id2":8451,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00014","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"194.66","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8450,"id2":8450,"supplier_id":"","client_id":2125,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00013","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"160.6","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:14","verify_at":"2026-04-22 15:46:14","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"}},{"id":8449,"id2":8449,"supplier_id":"","client_id":85,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00012","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"330.27","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":85,"key":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240"}},{"id":8448,"id2":8448,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00011","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"103.09","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8447,"id2":8447,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00010","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"120.3","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8446,"id2":8446,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00009","ticket_type":20018,"abstract":"\u4f4f\u5bbf\u8d39","description":"","created_by":5085,"amount":"204","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8445,"id2":8445,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00008","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"56.09","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8444,"id2":8444,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00007","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"130.06","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8443,"id2":8443,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00006","ticket_type":20018,"abstract":"\u4f4f\u5bbf\u8d39","description":"","created_by":5085,"amount":"181.05","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8442,"id2":8442,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00005","ticket_type":20018,"abstract":"\u4f4f\u5bbf\u8d39","description":"","created_by":5085,"amount":"166.49","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8441,"id2":8441,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00004","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"130.8","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8440,"id2":8440,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00003","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"166.4","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:13","verify_at":"2026-04-22 15:46:13","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8439,"id2":8439,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00002","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"303.31","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:12","verify_at":"2026-04-22 15:46:12","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":8438,"id2":8438,"supplier_id":"","client_id":2128,"user_id":"","contact_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00001","ticket_type":20018,"abstract":"\u4ea4\u901a\u8d39","description":"","created_by":5085,"amount":"174.39","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-22 15:46:11","verify_at":"2026-04-22 15:46:11","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"supplier":{},"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":{},"contact":{},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8"}},{"id":2350,"id2":2350,"supplier_id":45,"client_id":"","user_id":"","contact_id":"","wrote_date":"2026-04-09","serial_no":"FKD-20260409-00001","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"55","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-09 15:07:34","verify_at":"2026-04-09 15:07:34","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":{"id":45,"key":45,"name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":45,"key":45,"name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"}},{"id":2349,"id2":2349,"supplier_id":46,"client_id":"","user_id":"","contact_id":"","wrote_date":"2026-04-08","serial_no":"FKD-20260408-00002","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"0.32","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-08 15:45:25","verify_at":"2026-04-08 15:45:25","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":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"client":{},"user":{},"contact":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":46,"key":46,"name":"\u795e\u5dde\u6570\u7801(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"}},{"id":2348,"id2":2348,"supplier_id":"","client_id":3457,"user_id":"","contact_id":"","wrote_date":"2026-04-08","serial_no":"FKD-20260408-00001","ticket_type":20012,"abstract":"","description":"","created_by":1001,"amount":"1","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-04-08 15:40:01","verify_at":"2026-04-08 15:40:01","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":{},"ticket_type_display":"\u4ed8\u6b3e\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"}}],"pagenation":{"totalcount":10844,"thispage":1,"pagesize":40},"statusCount":[{"count":33,"key":1,"name":"\u8d39\u7528\u5f85\u7ed3\u7b97","status":1,"color":"#FEF7EC","border":"#FF9200"},{"count":10,"key":2,"name":"\u4ed8\u6b3e\u5f85\u7ed3\u7b97","status":2,"color":"#F4E8FF","border":"#C280FF"},{"count":10801,"key":3,"name":"\u5df2\u7ed3\u7b97","status":3,"color":"#E7F3D5","border":"#70B603"},{"count":10844,"key":4,"name":"\u5168\u90e8","status":4,"color":"#EAF8FE","border":"#81D3F8"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 16:45:09', 124235008) RETURNING "id"
16:45:09.0243.1 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:45:09.1031.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 307, 756, 45, 46)
16:45:09.1010.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1023, 5085, 5248))
16:45:09.1050.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2553, 2150, 89, 2762, 2125, 2191, 93, 149, 2128, 85, 3457)
16:45:09.1000.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5248, 1023, 5085)
16:45:09.1020.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 2)
16:45:09.0360.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001