ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a6a33edcc0: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-assets at 2026-06-11 03:56:35 pm by 221.216.117.119

Performance Profiling

Total processing time: 480 ms; Peak memory: 9.201 MB. Show Profiling Timeline

总计331条数据
TimeDurationCategoryInfo
  
15:56:36.06114.0 msyii\db\Command::querySELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE ("cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount < COALESCE(sub.amount, 0))
15:56:36.08912.4 msyii\db\Command::querySELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true))
15:56:36.13510.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true)
15:56:36.04910.6 msyii\db\Command::querySELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount >= COALESCE(sub.amount, 0))
15:56:36.1028.9 msyii\db\Command::querySELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true))
15:56:36.2568.9 msyii\db\Command::querySELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true))
15:56:36.1138.4 msyii\db\Command::querySELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true))
15:56:36.2908.3 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2388.2 msyii\db\Command::querySELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true))
15:56:36.2987.5 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3767.4 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3847.4 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.4097.4 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4177.3 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3177.3 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3097.2 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2307.2 msyii\db\Command::querySELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true))
15:56:36.2487.0 msyii\db\Command::querySELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true))
15:56:36.1226.1 msyii\db\Command::querySELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true))
15:56:36.2124.8 msyii\db\Command::querySELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."cost_type"=1) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount >= COALESCE(sub.amount, 0))
15:56:36.2244.7 msyii\db\Command::querySELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."cost_type"=1) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount >= COALESCE(sub.amount, 0))
15:56:36.0824.6 msyii\db\Command::querySELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE ("cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount < COALESCE(sub.amount, 0))
15:56:35.9814.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:56:36.2083.5 msyii\db\Command::querySELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount < COALESCE(sub.amount, 0))
15:56:36.4443.5 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-analysis/list-assets', '{"year":"2026","month":"6","hide":"1","web_access_token":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"title":"\u8d44\u4ea7\u7c7b","type":1,"serial_no":"","parent_id":"","amount":"","balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":1,"parent_id":"","title":"\u5e93\u5b58\u73b0\u91d1","serial_no":"1001","amount":"0","balance_amount":"0","actual_amount":798908.16,"description":"","type":1,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":73,"parent_id":1,"title":"\u73b0\u91d1","serial_no":"100101","amount":"3480","balance_amount":"8610","actual_amount":8610,"description":"","type":1,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 15:39:57","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":4460,"index":3},{"id":103,"parent_id":1,"title":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","serial_no":"100103","amount":"19445.25","balance_amount":"345.48","actual_amount":345.48,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:36:06","updated_at":"2025-12-16 17:12:36","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":365.25,"index":3},{"id":104,"parent_id":1,"title":"\u6dd8\u5b9d\u7f51","serial_no":"100104","amount":"258.78","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":true,"is_current":false,"created_by":1001,"created_at":"2025-08-08 17:47:02","updated_at":"2025-12-29 17:52: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"}},"last_actual_amount":0,"index":3},{"id":102,"parent_id":1,"title":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","serial_no":"100102","amount":"458031.1","balance_amount":"789952.68","actual_amount":789952.68,"description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:35:40","updated_at":"2025-08-08 15:37:37","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":1033558.73,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1038383.98,"can_stop":false,"index":2},{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":1554539.96,"description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":101,"parent_id":3,"title":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","serial_no":"100203","amount":"93723.6","balance_amount":"55209.98","actual_amount":55209.98,"description":"","type":1,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:34:38","updated_at":"2025-08-11 19:33:40","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":709.98,"index":3},{"id":72,"parent_id":3,"title":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","serial_no":"100202","amount":"632136.5","balance_amount":"23097.26","actual_amount":23097.26,"description":"","type":1,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-18 17:24:17","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":22393.66,"index":3},{"id":71,"parent_id":3,"title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","serial_no":"100201","amount":"2875779.6","balance_amount":"1476233.72","actual_amount":1476232.72,"description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 18:50:15","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":642388.63,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":665492.27,"can_stop":false,"index":2},{"id":4,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d44\u4ea7","serial_no":"1101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":5,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d44\u4ea7","serial_no":"1421","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":6,"parent_id":"","title":"\u5e94\u6536\u7968\u636e","serial_no":"1121","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":7,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u5408\u540c)","serial_no":"1122","amount":"0","balance_amount":"0","actual_amount":92685234.71,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":12589970.44,"can_stop":false,"index":2},{"id":74,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u51fa\u5e93\u5355)","serial_no":"112200","amount":"5500","balance_amount":"5500","actual_amount":21133759.64,"description":"","type":1,"sort":7,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2026-01-23 16:05:33","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":11371505.84,"can_stop":false,"index":2},{"id":8,"parent_id":"","title":"\u9884\u4ed8\u6b3e\u9879","serial_no":"1123","amount":"0","balance_amount":"0","actual_amount":"0.0000000000","description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0.0000000000","can_stop":false,"index":2},{"id":11,"parent_id":"","title":"\u5176\u4ed6\u5e94\u6536\u6b3e","serial_no":"1132","amount":"0","balance_amount":"0","actual_amount":1185747.78,"description":"","type":1,"sort":11,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1153342,"can_stop":false,"index":2},{"id":12,"parent_id":"","title":"\u5b58\u8d27","serial_no":"1221","amount":"0","balance_amount":"0","actual_amount":549564.61166667,"description":"","type":1,"sort":12,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":98336.77,"can_stop":false,"index":2},{"id":13,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d44\u4ea7","serial_no":"1481","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":14,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u7684\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1501","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":15,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d44\u4ea7","serial_no":"1401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":15,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":25222520.151667,"last_actual_amount":14327060.86,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":16,"parent_id":"","title":"\u53ef\u4f9b\u51fa\u552e\u91d1\u878d\u8d44\u4ea7","serial_no":"1503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":16,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":17,"parent_id":"","title":"\u6301\u6709\u81f3\u5230\u671f\u6295\u8d44","serial_no":"1502","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":17,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":18,"parent_id":"","title":"\u957f\u671f\u5e94\u6536\u6b3e","serial_no":"1506","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":18,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":19,"parent_id":"","title":"\u957f\u671f\u80a1\u6743\u6295\u8d44","serial_no":"1511","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":19,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":20,"parent_id":"","title":"\u6295\u8d44\u6027\u623f\u5730\u4ea7","serial_no":"1521","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":20,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":21,"parent_id":"","title":"\u56fa\u5b9a\u8d44\u4ea7","serial_no":"1601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":21,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":22,"parent_id":"","title":"\u5728\u5efa\u5de5\u7a0b","serial_no":"1604","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":22,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":23,"parent_id":"","title":"\u751f\u4ea7\u6027\u751f\u7269\u8d44\u4ea7","serial_no":"1621","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":23,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":24,"parent_id":"","title":"\u65e0\u5f62\u8d44\u4ea7","serial_no":"1701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":24,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":25,"parent_id":"","title":"\u6cb9\u6c14\u8d44\u4ea7","serial_no":"1531","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":25,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":26,"parent_id":"","title":"\u5f00\u53d1\u652f\u51fa","serial_no":"1702","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":26,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":27,"parent_id":"","title":"\u5546\u8a89","serial_no":"1711","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":27,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":28,"parent_id":"","title":"\u957f\u671f\u5f85\u644a\u8d39\u7528","serial_no":"1801","amount":"222","balance_amount":"222","actual_amount":"222","description":"","type":1,"sort":28,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"222","can_stop":false,"index":2},{"id":29,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d44\u4ea7","serial_no":"1811","amount":"2","balance_amount":"2","actual_amount":"2","description":"","type":1,"sort":29,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"2","can_stop":false,"index":2},{"id":30,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1901","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":30,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u975e\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":224,"last_actual_amount":224,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u8d44\u4ea7\u603b\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":25222744.151667,"last_actual_amount":14327284.86,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1}],"list2":[{"title":"\u8d1f\u503a\u7c7b","type":2,"serial_no":"","parent_id":"","amount":"","balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":31,"parent_id":"","title":"\u77ed\u671f\u501f\u6b3e","serial_no":"2001","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":32,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d1f\u503a","serial_no":"2101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":33,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d1f\u503a","serial_no":"2102","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":34,"parent_id":"","title":"\u5e94\u4ed8\u7968\u636e","serial_no":"2201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":35,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5408\u540c)","serial_no":"2202","amount":"0","balance_amount":"0","actual_amount":10238566.08,"description":"","type":2,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":11472011.72,"can_stop":false,"index":2},{"id":75,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5165\u5e93\u5355)","serial_no":"220200","amount":"33","balance_amount":"33","actual_amount":5693009.49,"description":"","type":2,"sort":6,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2026-01-23 16:05:33","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":6725499.98,"can_stop":false,"index":2},{"id":36,"parent_id":"","title":"\u9884\u6536\u6b3e\u9879","serial_no":"2203","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":-2481663.42,"description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":57,"parent_id":37,"title":"\u5e94\u4ed8\u804c\u5de5\u5de5\u8d44","serial_no":"221101","amount":"0","balance_amount":"0","actual_amount":-2619663.42,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":-1956321.62,"index":3},{"id":58,"parent_id":37,"title":"\u5e94\u4ed8\u5956\u91d1","serial_no":"221102","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3},{"id":59,"parent_id":37,"title":"\u5e94\u4ed8\u793e\u4f1a\u4fdd\u9669\u8d39","serial_no":"221104","amount":"0","balance_amount":"0","actual_amount":115000,"description":"","type":2,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3},{"id":60,"parent_id":37,"title":"\u5e94\u4ed8\u4f4f\u623f\u516c\u79ef\u91d1","serial_no":"221105","amount":"0","balance_amount":"0","actual_amount":23000,"description":"","type":2,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3},{"id":61,"parent_id":37,"title":"\u5de5\u4f1a\u7ecf\u8d39","serial_no":"221106","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":7,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":-1956321.62,"can_stop":false,"index":2},{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":13000,"description":"","type":2,"sort":9,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":62,"parent_id":38,"title":"\u5e94\u4ea4\u589e\u503c\u7a0e","serial_no":"222101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3},{"id":63,"parent_id":38,"title":"\u5e94\u4ea4\u4e2a\u7a0e","serial_no":"222102","amount":"0","balance_amount":"0","actual_amount":13000,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":39,"parent_id":"","title":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","serial_no":"2241","amount":"0","balance_amount":"0","actual_amount":2266658.34,"description":"","type":2,"sort":10,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":2168715.33,"can_stop":false,"index":2},{"id":40,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d1f\u503a","serial_no":"2245","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":11,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":41,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2231","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":12,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":42,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d1f\u503a","serial_no":"2242","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":5491004.41,"last_actual_amount":6937893.69,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":43,"parent_id":"","title":"\u957f\u671f\u501f\u6b3e","serial_no":"2501","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":44,"parent_id":"","title":"\u5e94\u4ed8\u503a\u5238","serial_no":"2502","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":15,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":64,"parent_id":44,"title":"\u4f18\u5148\u80a1","serial_no":"250201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3},{"id":65,"parent_id":44,"title":"\u6c38\u7eed\u503a","serial_no":"250202","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":45,"parent_id":"","title":"\u957f\u671f\u5e94\u4ed8\u6b3e","serial_no":"2701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":16,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":46,"parent_id":"","title":"\u9884\u8ba1\u8d1f\u503a","serial_no":"2801","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":17,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":47,"parent_id":"","title":"\u9012\u5ef6\u6536\u76ca","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":18,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":48,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d1f\u503a","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":19,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":49,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":20,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":true,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u975e\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":0,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u8d1f\u503a\u5408\u8ba1","type":2,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":5491004.41,"last_actual_amount":6937893.69,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\u7c7b\uff09","type":3,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":50,"parent_id":"","title":"\u5b9e\u6536\u8d44\u672c","serial_no":"4001","amount":"222","balance_amount":"222","actual_amount":"222","description":"","type":3,"sort":1,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"222","can_stop":false,"index":2},{"id":51,"parent_id":"","title":"\u8d44\u672c\u516c\u79ef","serial_no":"4002","amount":"3333","balance_amount":"3333","actual_amount":"3333","description":"","type":3,"sort":2,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"3333","can_stop":false,"index":2},{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":244444,"description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":70,"parent_id":52,"title":"\u4efb\u610f\u76c8\u4f59\u516c\u79ef","serial_no":"410102","amount":"222222","balance_amount":"222222","actual_amount":"222222","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"222222","index":3},{"id":69,"parent_id":52,"title":"\u6cd5\u5b9a\u76c8\u4f59\u516c\u79ef","serial_no":"410101","amount":"22222","balance_amount":"22222","actual_amount":"22222","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"22222","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":244444,"can_stop":false,"index":2},{"id":53,"parent_id":"","title":"\u672a\u5206\u914d\u5229\u6da6","serial_no":"4104","amount":"-2082915.66","balance_amount":"-2082915.66","actual_amount":13999528.251667,"description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1400879.28,"can_stop":false,"index":2},{"id":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":67,"parent_id":54,"title":"\u4f18\u5148\u80a1","serial_no":"611601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3},{"id":68,"parent_id":54,"title":"\u6c38\u7eed\u503a","serial_no":"611602","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":55,"parent_id":"","title":"\u5176\u4ed6\u7efc\u5408\u6536\u76ca","serial_no":"6111","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":6,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":56,"parent_id":"","title":"\u4e13\u9879\u50a8\u5907","serial_no":"4301","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\uff09\u5408\u8ba1","type":3,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":14247527.251667,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1}],"count":{"list1_sum":25222744.151667,"list2_sum":19738531.661667,"last_list1_sum":14327284.86,"last_list2_sum":8586771.97,"start_list1_sum":6566525.43,"start_list2_sum":143761.74},"show_libra":true},"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 15:56:36', 467981056) RETURNING "id"
15:56:36.0783.5 msyii\db\Command::querySELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount >= COALESCE(sub.amount, 0))
15:56:36.2863.5 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2203.4 msyii\db\Command::querySELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount < COALESCE(sub.amount, 0))
15:56:36.3632.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2025-08-08 14:34:58') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3062.5 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4062.5 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3972.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2025-08-08 14:34:58') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.0032.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=73
15:56:36.3732.3 msyii\db\Command::querySELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:35.9852.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:56:36.0441.7 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE)
15:56:36.1621.7 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.0461.6 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("cost_type"=1) AND ("t"."created_at" < '2025-08-08 14:34:58') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = true)
15:56:36.0081.6 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=103
15:56:36.0191.6 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=1
15:56:35.9901.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:56:36.0061.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=73
15:56:36.0151.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=102
15:56:36.0121.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=104
15:56:36.0231.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=101
15:56:36.0331.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=0
15:56:36.0301.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=71
15:56:36.0261.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=72
15:56:36.0211.5 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=1
15:56:36.0101.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=103
15:56:36.0171.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=102
15:56:36.0351.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=0
15:56:36.0141.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=104
15:56:36.0321.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=71
15:56:36.3301.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.0251.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=101
15:56:36.1471.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.0281.4 msyii\db\Command::querySELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=72
15:56:36.3391.3 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1531.3 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3341.2 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.0751.2 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE)
15:56:35.9971.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) AND ("is_delete"=FALSE) ORDER BY "is_current" DESC, "sort", "id"
15:56:36.3421.2 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.2061.2 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("t"."cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false)
15:56:36.2181.2 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("t"."cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false)
15:56:36.2821.1 msyii\db\Command::querySELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1591.0 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.0771.0 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("cost_type"=1) AND ("t"."created_at" < '2025-08-08 14:34:58') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = true)
15:56:36.2681.0 msyii\db\Command::querySELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2750.9 msyii\db\Command::querySELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1490.9 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1980.9 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.1990.9 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.0000.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 (1000, 5064, 1001))
15:56:36.1520.8 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1640.8 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1300.8 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2026-06-30 23:59:59')
15:56:36.2020.8 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.2700.8 msyii\db\Command::querySELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2070.8 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE)
15:56:36.2190.8 msyii\db\Command::querySELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE)
15:56:36.1290.7 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("is_payment_settle"=TRUE) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3600.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1460.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.1650.7 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_lost_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2670.7 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("r"."settle_at" <= '2026-06-30 23:59:59')
15:56:36.3930.7 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:35.9950.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE)
15:56:36.3590.6 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3620.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_income_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1970.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.1610.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2790.6 msyii\db\Command::querySELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1310.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2026-06-30 23:59:59')
15:56:36.1720.6 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1500.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3310.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3250.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2740.6 msyii\db\Command::querySELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3950.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_income_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3680.6 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1560.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1660.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3290.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.2800.6 msyii\db\Command::querySELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3400.6 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1720.6 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2690.6 msyii\db\Command::querySELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.1580.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1570.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59'
15:56:36.2770.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.4010.5 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2810.5 msyii\db\Command::querySELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2810.5 msyii\db\Command::querySELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3350.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3380.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.2010.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1670.5 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_build_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1550.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.0010.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
15:56:36.2730.5 msyii\db\Command::querySELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3440.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3330.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.1680.5 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_disassemble_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1460.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') AND (t.is_start = false)
15:56:36.4260.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
15:56:36.3420.5 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.2710.5 msyii\db\Command::querySELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.3280.5 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true)
15:56:36.3520.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
15:56:36.1740.4 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_build_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2760.4 msyii\db\Command::querySELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.2830.4 msyii\db\Command::querySELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.1930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_current" DESC, "sort", "id"
15:56:36.2470.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=220200
15:56:36.1730.4 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_lost_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3270.4 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.is_start = false) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (("t"."bank_settle_at" IS NULL) OR ("t"."bank_settle_at" > '2026-06-30 23:59:59'))
15:56:36.2840.4 msyii\db\Command::querySELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4320.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
15:56:36.2650.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2203'
15:56:36.3920.4 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2660.4 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1340.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2025-12-31 23:59:59')
15:56:36.2850.4 msyii\db\Command::querySELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3950.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.0400.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1101'
15:56:35.9980.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 74, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
15:56:36.3940.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3610.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1120.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=112200
15:56:36.2730.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("r"."settle_at" <= '2025-12-31 23:59:59')
15:56:36.1330.4 msyii\db\Command::querySELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2025-12-31 23:59:59')
15:56:36.3910.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104
15:56:36.3680.4 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1580.4 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1940.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 75, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49)
15:56:36.4270.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 74, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
15:56:36.4360.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
15:56:36.1750.4 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_disassemble_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4240.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='6111'
15:56:36.0870.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=112200
15:56:36.3580.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.4320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 75, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49)
15:56:36.3280.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (is_start = false)
15:56:35.9990.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001)
15:56:36.3360.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.is_start = false) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (("t"."bank_settle_at" IS NULL) OR ("t"."bank_settle_at" > '2025-12-31 23:59:59'))
15:56:36.1330.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("is_payment_settle"=TRUE) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.2010.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1690.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1780.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1401'
15:56:36.1520.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') AND (t.is_start = false)
15:56:36.4010.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3600.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3250.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.2660.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2203'
15:56:36.3710.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.2290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=220200
15:56:36.0410.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1101'
15:56:36.3320.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3370.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true)
15:56:36.3720.3 msyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3630.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3530.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56)
15:56:36.3960.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3670.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1610.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3370.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (is_start = false)
15:56:36.4310.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "is_start"=TRUE
15:56:36.2720.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2780.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
15:56:36.4280.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001)
15:56:36.4370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56)
15:56:36.1900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801
15:56:35.9960.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
15:56:36.1740.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1760.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1481'
15:56:36.3660.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3940.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1510.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true)
15:56:36.1700.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4280.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5064, 1001))
15:56:36.1690.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59'
15:56:36.4000.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3410.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3690.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3580.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104
15:56:36.3700.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1950.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.2040.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2102'
15:56:36.4250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='6111'
15:56:36.1880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1702'
15:56:36.3710.3 msyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.4050.3 msyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1820.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1511'
15:56:36.4350.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "is_start"=TRUE
15:56:36.3470.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2701'
15:56:36.3730.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.4020.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2101'
15:56:36.1710.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1770.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1501'
15:56:36.3440.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2245'
15:56:36.1800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1502'
15:56:36.1880.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1531'
15:56:36.1920.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1901'
15:56:36.3990.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4000.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3570.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4002'
15:56:36.1790.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1503'
15:56:36.1870.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1701'
15:56:36.4040.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3540.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.1760.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1481'
15:56:36.3480.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2701'
15:56:36.4300.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.1960.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.4040.3 msyii\db\Command::querySELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4060.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.0420.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1421'
15:56:36.1810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1506'
15:56:36.1860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1621'
15:56:36.1940.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.4030.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4350.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.2050.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2201'
15:56:36.1960.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.1900.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801
15:56:36.1890.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1702'
15:56:36.3260.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.1810.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1511'
15:56:36.3720.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3510.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401'
15:56:36.3670.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.1800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1502'
15:56:36.3450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2245'
15:56:36.3690.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.3700.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:56:36.0020.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.3520.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2503'
15:56:36.3500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401'
15:56:36.3490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401'
15:56:36.2030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2101'
15:56:36.2780.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3560.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4001'
15:56:36.1830.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1601'
15:56:36.4030.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4260.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4301'
15:56:36.1700.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2801'
15:56:36.3530.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.0430.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1121'
15:56:36.1820.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1521'
15:56:36.4020.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.4380.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.1870.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1531'
15:56:36.1910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1811'
15:56:36.3450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2231'
15:56:36.3470.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2242'
15:56:36.3500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401'
15:56:36.4250.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4301'
15:56:36.4330.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.1850.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1604'
15:56:36.3480.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2801'
15:56:36.4050.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.3460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2231'
15:56:36.3260.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.3460.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2242'
15:56:36.1770.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1501'
15:56:36.1840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1601'
15:56:36.1840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1604'
15:56:36.1910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1811'
15:56:36.3510.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2503'
15:56:36.0010.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.0420.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1421'
15:56:36.1800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1506'
15:56:36.1890.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1711'
15:56:36.3550.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.4330.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.1850.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1621'
15:56:36.1860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1701'
15:56:36.3560.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4001'
15:56:36.1790.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1503'
15:56:36.1830.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1521'
15:56:36.2780.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59')
15:56:36.1890.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1711'
15:56:36.2050.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2201'
15:56:36.4290.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
15:56:36.1710.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59')
15:56:36.2040.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2102'
15:56:36.4390.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.1780.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1401'
15:56:36.3570.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4002'
15:56:36.4370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.1920.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1901'
15:56:36.4290.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.4390.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.0430.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1121'
15:56:36.1970.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.3550.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:56:36.4340.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:56:36.4310.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t"
15:56:36.0020.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.4340.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.4400.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.1950.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.3540.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.3550.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.4380.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.4300.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
15:56:36.4350.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10