ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2fb10789ebb: POST https://beta.jinchangxiao.com/vue/setting/list-erp-account-caption at 2026-06-15 04:00:07 pm by 221.216.117.25

Performance Profiling

Total processing time: 140 ms; Peak memory: 5.850 MB. Show Profiling Timeline

总计52条数据
TimeDurationCategoryInfo
  
16:00:07.66215.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" <= '2026-06-30 23:59:59')
16:00:07.6529.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')
16:00:07.6198.8 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') 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') 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" 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))
16:00:07.6108.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') 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') 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" 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))
16:00:07.6777.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"."bank_settle_at" <= '2026-06-30 23:59:59')
16:00:07.6006.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 (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))
16:00:07.6355.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" <= '2026-06-30 23:59:59')
16:00:07.5945.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" <= '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))
16:00:07.6303.5 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')
16:00:07.6442.6 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')
16:00:07.5862.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" <= '2026-06-30 23:59:59')
16:00:07.6981.8 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/setting/list-erp-account-caption', '{"type":"2","keyword":"","page":"1","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":35,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5408\u540c)","serial_no":"2202","amount":"0","balance_amount":"0","actual_amount":10240366.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"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":75,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5165\u5e93\u5355)","serial_no":"220200","amount":"33","balance_amount":"33","actual_amount":5692976.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"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":false,"can_start":false},{"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"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false},{"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"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":false,"can_start":false},{"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"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":false,"can_start":false},{"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"}},"parent":{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false}],"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"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"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"}},"parent":{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false},{"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"}},"parent":{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":"0","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":""},"can_update":false,"can_delete":true,"can_stop":false,"can_start":false}],"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"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":39,"parent_id":"","title":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","serial_no":"2241","amount":"0","balance_amount":"0","actual_amount":2266668.33,"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"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"parent":{"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":""},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false},{"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"}},"parent":{"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":""},"can_update":false,"can_delete":true,"can_stop":true,"can_start":false}],"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"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"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":true,"bgcolor":"#89c541"}],"can_create":false,"pagenation":{"totalcount":20,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-15 16:00:07', 131911936) RETURNING "id"
16:00:07.5901.5 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)
16:00:07.6901.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')
16:00:07.5891.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"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59')
16:00:07.6931.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')
16:00:07.5921.0 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)
16:00:07.5760.9 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='2') AND (parent_id is null) ORDER BY "is_delete", "sort", "id") "c"
16:00:07.6410.8 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')
16:00:07.5780.8 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:00:07.5690.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:00:07.5830.7 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')
16:00:07.6280.7 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')
16:00:07.6870.6 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'))
16:00:07.6490.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')
16:00:07.5710.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:00:07.6850.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')
16:00:07.6910.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')
16:00:07.5820.6 msyii\db\Command::querySELECT MAX(date) FROM "a57be577deb434"."tbl_erp_settles" WHERE "is_settle"=TRUE
16:00:07.6500.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')
16:00:07.6890.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')
16:00:07.6460.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')
16:00:07.6470.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')
16:00:07.6950.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')
16:00:07.5770.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='2') AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
16:00:07.6930.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')
16:00:07.6500.5 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')
16:00:07.5800.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
16:00:07.5720.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:00:07.6510.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')
16:00:07.6880.4 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)
16:00:07.5680.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:00:07.5770.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)
16:00:07.6880.4 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)
16:00:07.6480.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')
16:00:07.5800.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id" IN (37, 38, 44)
16:00:07.6920.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')
16:00:07.5790.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)
16:00:07.6860.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')
16:00:07.5810.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)
16:00:07.5810.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:00:07.5820.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10