ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1d3746b4192: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-account-cost at 2026-06-01 03:39:50 pm by 221.216.117.119

Performance Profiling

Total processing time: 47 ms; Peak memory: 5.003 MB. Show Profiling Timeline

总计16条数据
TimeDurationCategoryInfo
  
15:39:50.74710.0 msyii\db\Command::querySELECT 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"='5064') 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" >= '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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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" )) "sub" ORDER BY created_at DESC) "c"
15:39:50.7577.2 msyii\db\Command::querySELECT * 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"='5064') 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" >= '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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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" )) "sub" ORDER BY created_at DESC LIMIT 40
15:39:50.7746.5 msyii\db\Command::querySELECT 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"='5064') 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" >= '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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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" )) "sub"
15:39:50.7686.2 msyii\db\Command::querySELECT 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"='5064') 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" >= '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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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"='5064') 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" )) "sub"
15:39:50.7821.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-account-cost', '{"user_id":"5064","created_at_period":"erpcurrentfascalyear","created_at_to":"","created_at_from":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"XCfRahmCFXcXmdIMLA2cYqURDbuJi7wa"}', '{"code":2000,"result":{"list":[{"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":5064,"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":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":8467,"id2":8467,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260423-00001","ticket_type":20018,"abstract":"","description":"","created_by":5064,"handler":5064,"amount":"33.00","status":2,"settle_amount":"33","is_payment_settle":true,"created_at":"2026-04-23 17:25:23","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"handlerPerson":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":8184,"id2":8184,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260122-00003","ticket_type":20018,"abstract":"\u4e2d\u535a\u6570\u667a\u91d1\u7545\u900d\u4ea4\u4ed8\u6253\u8f66\u8d39","description":"","created_by":5064,"handler":5064,"amount":"136.60","status":2,"settle_amount":"136.6","is_payment_settle":true,"created_at":"2026-01-22 09:33:45","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"handlerPerson":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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":8182,"id2":8182,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260122-00001","ticket_type":20018,"abstract":"\u73af\u5b87\u667a\u521b\u91d1\u7545\u900d\u73b0\u573a\u4ea4\u4ed8\u5f80\u8fd4\u6253\u8f66\u8d39\u7528","description":"","created_by":5064,"handler":5064,"amount":"212.80","status":2,"settle_amount":"212.8","is_payment_settle":true,"created_at":"2026-01-22 09:33:45","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"handlerPerson":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"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"}]}],"total_amount":"392.40","total_count":4,"pagenation":{"totalcount":4,"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-01 15:39:50', 43778048) RETURNING "id"
15:39:50.7400.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:39:50.7450.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
15:39:50.7410.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:39:50.7660.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
15:39:50.7650.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5064)
15:39:50.7660.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5064, 1001))
15:39:50.7390.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:39:50.7670.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5064)
15:39:50.7660.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
15:39:50.7450.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)
15:39:50.7670.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10