ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a20f062b4c50: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-account-out at 2026-06-04 11:26:26 am by 221.216.117.119

Database Queries

总计19条数据
TimeDurationTypeQuery
  
11:26:26.7420.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:26:26.7440.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:26:26.7470.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:26.7480.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:26.75014.1 msSELECTSELECT COUNT(*) FROM (SELECT * FROM ((SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."is_payment_settle"=TRUE) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."is_payment_settle"=TRUE) AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) AND ("r"."handler"='1001') GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_id", "am"."pct" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub" ORDER BY created_at DESC) "c"

[+] Explain
11:26:26.76410.4 msSELECTSELECT * FROM ((SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."is_payment_settle"=TRUE) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."is_payment_settle"=TRUE) AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) AND ("r"."handler"='1001') GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_id", "am"."pct" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub" ORDER BY created_at DESC LIMIT 40

[+] Explain
11:26:26.7750.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 1000, 5252, 5388)

[+] Explain
11:26:26.7760.6 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1000, 5252, 5388, 1011))

[+] Explain
11:26:26.7770.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 6, 3)

[+] Explain
11:26:26.7770.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:26:26.7770.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
11:26:26.7780.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
11:26:26.7780.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3286, 3389, 3457, 982, 3377, 1661, 3432, 3435, 2553)

[+] Explain
11:26:26.7780.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_contacts" WHERE "id" IN (6231, 6221)

[+] Explain
11:26:26.7790.2 msSELECTSELECT "id", "id" AS "key", "serial_no" AS "name", "from_project" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4399, 1558, 4324)

[+] Explain
11:26:26.7790.4 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (1791, 4079, 4098)

[+] Explain
11:26:26.7809.3 msSELECTSELECT SUM(amount) FROM ((SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."is_payment_settle"=TRUE) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."is_payment_settle"=TRUE) AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) AND ("r"."handler"='1001') GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_id", "am"."pct" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub"

[+] Explain
11:26:26.7908.8 msSELECTSELECT COUNT(*) FROM ((SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" ON am.erp_cash_cost_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."is_payment_settle"=TRUE) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))) UNION ALL ( SELECT (r.id::varchar || 20018::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20018 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, r.is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."is_payment_settle"=TRUE) AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" ON am.erp_cost_ticket_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20014::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, r.contact_id as contact_id, r.project_id as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20014 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, r.settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."created_at" >= '2025-08-08 14:34:58') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, am.amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" ON am.erp_cost_convert_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) ) UNION ALL ( SELECT (r.id::varchar || 20016::varchar) as id, r.id as id2, null::integer as supplier_id, null::integer as client_id, null::integer as user_id, null::integer as contact_id, null::integer as project_id, r.sales_contract_id as sales_contract_id, r.purchase_contract_id as purchase_contract_id, r.wrote_date, r.serial_no, 20016 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, r.amount * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = r.sales_contract_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("sc"."from_project" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, r.handler as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) AND ("r"."handler"='1001') GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20011::varchar) as id, r.id as id2, r.supplier_id as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20011 as ticket_type, r.abstract, r.description, r.created_by, am.user_id as handler, COALESCE(sum(eipss.actual_total_amount), 0) - COALESCE(sum(eipss.total_amount), 0) * am.pct / 100 as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id", "am"."user_id", "am"."pct" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id" ) UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, null::integer as sales_contract_id, null::integer as purchase_contract_id, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.handler, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as amount, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub"

[+] Explain
11:26:26.8001.8 msINSERTINSERT 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-account-out', '{"user_id":"1001","created_at_period":"erpcurrentfascalyear","created_at_to":"","created_at_from":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":157,"id2":157,"supplier_id":"","client_id":3286,"user_id":"","contact_id":"","project_id":4142,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-05-26","serial_no":"XSCKD-20260526-00001","ticket_type":20008,"abstract":"","description":"\u6700\u7ec8\u7528\u6237\u4fe1\u606f\uff1a\n\u4ebf\u5ba2\u884c\u54a8\u8be2\u670d\u52a1(\u5317\u4eac)\u6709\u9650\u516c\u53f8\nExpedia Consulting Service (Beijing) Co., Ltd.","created_by":1011,"handler":1001,"amount":"158798.2","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-26 16:12:02","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":156,"id2":156,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","project_id":4172,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-05-25","serial_no":"XSCKD-20260525-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"1","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-25 11:17:35","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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"contract_no":""},{"id":152,"id2":152,"supplier_id":"","client_id":3457,"user_id":"","contact_id":"","project_id":4157,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-05-18","serial_no":"XSCKD-20260518-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"1","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-18 16:05:22","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"contract_no":""},{"id":151,"id2":151,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","project_id":4161,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-05-15","serial_no":"XSCKD-20260515-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"135","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-15 15:30:46","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":""},{"id":12,"id2":12,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-05-12","serial_no":"LRHBD-20260512-00001","ticket_type":20016,"abstract":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","description":"\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b\u9500\u552e\u4e1a\u7ee9\u5206\u644a\u5355>\u589e\u6539\u67e5\u3001\u5ba1\u6838(\u901a\u8fc7\/\u62d2\u7edd)\u3001\u751f\u6210\u6253\u5370\u6587\u4ef6\u3001\u7ea2\u5b57\u53cd\u51b2\u3001\u91cd\u65b0\u63d0\u4ea4\u3001\u6587\u4ef6\u4e0b\u8f7d\u3001\u4ed8\u6b3e\u5355\u3001\u4fdd\u5b58\u4e3a\u8349\u7a3f\uff1b","created_by":1001,"handler":1001,"amount":"10","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-12 13:33:00","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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5229\u6da6\u5212\u62e8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":""},{"id":8472,"id2":8472,"supplier_id":"","client_id":3377,"user_id":"","contact_id":"","project_id":"","sales_contract_id":4399,"purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260429-00001","ticket_type":20018,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"999.00","status":2,"settle_amount":"999","is_payment_settle":true,"created_at":"2026-04-29 15:52:14","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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":"","salesContract":{"id":4399,"key":4399,"name":"2026\/BJ040\/BJBJ2026-1028","from_project":4098,"fromProject":{"id":4098,"key":4098,"name":"PA460\u8bbe\u5907\u7b49\u91c7\u8d2d\u9879\u76ee"}},"purchaseContract":"","ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":"2026\/BJ040\/BJBJ2026-1028","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":8471,"id2":8471,"supplier_id":"","client_id":1661,"user_id":"","contact_id":"","project_id":"","sales_contract_id":1558,"purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260427-00001","ticket_type":20018,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"222.00","status":2,"settle_amount":"222","is_payment_settle":true,"created_at":"2026-04-27 23:35:52","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":{"id":1558,"key":1558,"name":"TSKJ20200602-HYF-004","from_project":1791,"fromProject":{"id":1791,"key":1791,"name":"\u706b\u773c5500VX\u91c7\u8d2d\u9879\u76ee"}},"purchaseContract":"","ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":1661,"key":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":"TSKJ20200602-HYF-004","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":150,"id2":150,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","project_id":4161,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-04-23","serial_no":"XSCKD-20260423-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"647.205","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-04-23 16:51:35","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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":""},{"id":8465,"id2":8465,"supplier_id":"","client_id":3432,"user_id":"","contact_id":"","project_id":"","sales_contract_id":4324,"purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260422-00028","ticket_type":20018,"abstract":"\u8d39\u7528\u8bf4\u660e\u6d4b\u8bd5\u8d39\u7528\uff0c\u62a5\u9500\u8d39\u7684\u8d39\u7528\u8bf4\u660e\u6d4b\u8bd5\u8bed\u97f3\u529f\u80fd\u529f\u80fd\u3002\u4e3a\u4ec0\u4e48\u4f60\u53d6\u6d88\u7684\u65f6\u5019\u624d\u4f1a\u81ea\u52a8\u5207\u6362\u7684\uff1f\u6309\u3002","description":"","created_by":1000,"handler":1001,"amount":"5","status":2,"settle_amount":"5","is_payment_settle":true,"created_at":"2026-04-22 15:46: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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"user":"","contact":"","salesContract":{"id":4324,"key":4324,"name":"2025-12-19-002","from_project":4079,"fromProject":{"id":4079,"key":4079,"name":"\u6c11\u822a\u5b89\u5168\u6cd5\u5f8b\u6cd5\u89c4\u6570\u636e\u5e93\u4f18\u5316\u4e0e\u5b89\u5168\u80dc\u4efb\u529b\u6d4b\u8bc4\u7cfb\u7edf\u5f00\u53d1\u9879\u76ee"}},"purchaseContract":"","ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":3432,"key":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662"},"contract_no":"2025-12-19-002","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":149,"id2":149,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","project_id":4164,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-04-08","serial_no":"XSCKD-20260408-00003","ticket_type":20008,"abstract":"\u591a\u8212\u670d\u7684\u6c99\u53d1","description":"\u65b9\u5f0f\u5730\u65b9","created_by":1001,"handler":1001,"amount":"0","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-04-08 11:23:04","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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":""},{"id":49,"id2":49,"supplier_id":"","client_id":"","user_id":"","contact_id":6231,"project_id":4098,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-02-02","serial_no":"FYD-20260202-00001","ticket_type":20014,"abstract":"\u5a01\u53d1\u4e16\u7eaa PA\u674e\u777f\u8fd4\u6b3e\u5408\u540c\u91d1\u989d1630000\u5143","description":"","created_by":5252,"handler":1001,"amount":"388713","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-02-02 12:46:01","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":{"id":6231,"key":6231,"name":"\u674e\u777f"},"salesContract":"","purchaseContract":"","ticket_type_display":"\u8d39\u7528\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":6231,"key":6231,"name":"\u674e\u777f"},"contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":132,"id2":132,"supplier_id":"","client_id":3377,"user_id":"","contact_id":"","project_id":4098,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-02-02","serial_no":"XSCKD-20260202-00001","ticket_type":20008,"abstract":"\u5229\u6da6\u7387\uff1a1.72%\uff1b\u6536\u8d27\u4eba\uff1a\u9648\u8d85","description":"","created_by":1011,"handler":1001,"amount":"1046515","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-02-02 10:45:23","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":""},{"id":124,"id2":124,"supplier_id":"","client_id":3435,"user_id":"","contact_id":"","project_id":4111,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-22","serial_no":"XSCKD-20260122-00001","ticket_type":20008,"abstract":"\u5229\u6da6\u7387\uff1a100%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u7389\u5c71","description":"","created_by":1011,"handler":1001,"amount":"0.00000000000000000000","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-01-22 13:34:43","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":8186,"id2":8186,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260122-00005","ticket_type":20018,"abstract":"","description":"","created_by":1001,"handler":1001,"amount":"15479","status":2,"settle_amount":"15479","is_payment_settle":true,"created_at":"2026-01-22 13:32:35","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"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":"","contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":8,"id2":8,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-13","serial_no":"LRHBD-20260113-00001","ticket_type":20016,"abstract":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6\u8d39\u752812\u6708","description":"","created_by":5388,"handler":1001,"amount":"124","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-01-13 11:00:57","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u5229\u6da6\u5212\u62e8\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":"","contract_no":""},{"id":46,"id2":46,"supplier_id":"","client_id":"","user_id":"","contact_id":6221,"project_id":4096,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-13","serial_no":"FYD-20260113-00001","ticket_type":20014,"abstract":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u674e\u777f\u8fd4\u6b3e\u5408\u540c\u989d1400\u5143","description":"","created_by":5388,"handler":1001,"amount":"723","status":2,"settle_amount":"0","is_payment_settle":false,"created_at":"2026-01-13 10:56:12","createdBy":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","department_id":6,"avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":"","user":"","contact":{"id":6221,"key":6221,"name":"\u674e\u777f"},"salesContract":"","purchaseContract":"","ticket_type_display":"\u8d39\u7528\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u5b8c\u6210","unit":{"id":6221,"key":6221,"name":"\u674e\u777f"},"contract_no":"","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":122,"id2":122,"supplier_id":"","client_id":2553,"user_id":"","contact_id":"","project_id":4096,"sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-12","serial_no":"XSCKD-20260112-00001","ticket_type":20008,"abstract":"\u5229\u6da6\u7387\uff1a2%\uff1b\u6536\u8d27\u4eba\uff1a\u674e\u5b81\uff1bPA\u5382\u5546\u674e\u777f\u79ef\u5206723","description":"","created_by":1011,"handler":1001,"amount":"380","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-01-12 16:36:46","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"supplier":"","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"user":"","contact":"","salesContract":"","purchaseContract":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""}],"total_amount":"1612752.40500000000000000000","total_count":17,"pagenation":{"totalcount":17,"thispage":1,"pagesize":40}},"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-04 11:26:26', 59749888) RETURNING "id"

[+] Explain