6a20f095873e9: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-account-cost at 2026-06-04 11:27:17 am by 221.216.117.119
Performance Profiling
Total processing time: 53 ms; Peak memory: 5.618 MB. Show Profiling Timeline
总计15条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 11:27:17.562 | 8.8 ms | yii\db\Command::query | SELECT 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, r.amount 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_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 is null) 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"='-1') 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, r.amount 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_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 is null) 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"='-1') 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"='-1') 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"='-1') 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 is null) 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"='-1') 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" |
| 11:27:17.571 | 8.6 ms | yii\db\Command::query | 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, r.amount 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_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 is null) 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"='-1') 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, r.amount 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_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 is null) 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"='-1') 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"='-1') 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"='-1') 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 is null) 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"='-1') 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 OFFSET 80 |
| 11:27:17.585 | 7.7 ms | yii\db\Command::query | SELECT 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, r.amount 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_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 is null) 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"='-1') 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, r.amount 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_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 is null) 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"='-1') 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"='-1') 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"='-1') 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 is null) 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"='-1') 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" |
| 11:27:17.594 | 7.4 ms | yii\db\Command::query | SELECT 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, r.amount 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_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 is null) 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"='-1') 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, r.amount 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_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 is null) 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"='-1') 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"='-1') 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"='-1') 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 is null) 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"='-1') 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" |
| 11:27:17.583 | 2.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4383, 4371, 4281, 4345) |
| 11:27:17.603 | 1.4 ms | yii\db\Command::query | INSERT 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":"-1","created_at_period":"erpcurrentfascalyear","created_at_to":"","created_at_from":"","page":"3","pageSize":"40","listReload":"undefined","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":8248,"id2":8248,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-30","serial_no":"XJFYD-20260130-00002","ticket_type":20018,"abstract":"\u4ed8\u534e\u590f\u94f6\u884c\u624b\u7eed\u8d39","description":"","created_by":5252,"handler":"","amount":"49","status":2,"settle_amount":"49","is_payment_settle":true,"created_at":"2026-01-30 15:57:11","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8247,"id2":8247,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-30","serial_no":"XJFYD-20260130-00001","ticket_type":20018,"abstract":"\u5de5\u884c\u624b\u7eed\u8d39","description":"","created_by":5252,"handler":"","amount":"100","status":2,"settle_amount":"100","is_payment_settle":true,"created_at":"2026-01-30 15:42:47","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8246,"id2":8246,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-28","serial_no":"XJFYD-20260128-00001","ticket_type":20018,"abstract":"\u5956\u52b1\u9500\u552e\u91d1\u7545\u900d\u8f6f\u4ef6","description":"","created_by":5252,"handler":"","amount":"8000","status":2,"settle_amount":"8000","is_payment_settle":true,"created_at":"2026-01-28 10:03:47","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8245,"id2":8245,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260126-00002","ticket_type":20018,"abstract":"\u516c\u53f8\u8d2d\u4e702000\u5ea6\u7535\u8d39","description":"","created_by":1013,"handler":"","amount":"2180","status":2,"settle_amount":"2180","is_payment_settle":true,"created_at":"2026-01-26 17:11:36","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8244,"id2":8244,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-26","serial_no":"XJFYD-20260126-00001","ticket_type":20018,"abstract":"\u9500\u552e\u90e8\u5468\u4e00\u4f8b\u4f1a\u5956\u52b1","description":"","created_by":5252,"handler":"","amount":"600","status":2,"settle_amount":"600","is_payment_settle":true,"created_at":"2026-01-26 13:03:45","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8243,"id2":8243,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-23","serial_no":"XJFYD-20260123-00057","ticket_type":20018,"abstract":"\u4ed8\u534e\u590f\u94f6\u884c\u624b\u7eed\u8d39","description":"","created_by":5252,"handler":"","amount":"63","status":2,"settle_amount":"63","is_payment_settle":true,"created_at":"2026-01-23 16:52:20","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8241,"id2":8241,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00055","ticket_type":20018,"abstract":"\u4eac\u4e1c\u8d2d\u4e70HP2606\u6253\u5370\u673a\u4e00\u53f0\uff0c\u5929\u8272\u7852\u9f13\u4e00\u5957","description":"","created_by":1013,"handler":"","amount":"1758","status":2,"settle_amount":"1758","is_payment_settle":true,"created_at":"2026-01-23 10:12:46","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8238,"id2":8238,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00052","ticket_type":20018,"abstract":"\u516c\u53f8\u5efa\u884c\u624b\u673a\u8d39","description":"","created_by":1013,"handler":"","amount":"50.96","status":2,"settle_amount":"50.96","is_payment_settle":true,"created_at":"2026-01-23 10:12:45","createdBy":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","department_id":7,"avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"},"department":{"id":7,"key":7,"name":"\u5e93\u623f\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8237,"id2":8237,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00051","ticket_type":20018,"abstract":"\u8d2d\u4e70\u529e\u516c\u5ba4\u65b0\u5e74\u88c5\u9970","description":"","created_by":5360,"handler":"","amount":"132.31","status":2,"settle_amount":"132.31","is_payment_settle":true,"created_at":"2026-01-23 10:12:45","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8209,"id2":8209,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00023","ticket_type":20018,"abstract":"12-22 \u9999\u8549\uffe515.96\n12-29 \u9999\u8549\uffe515.96\n1-4 \u9999\u8549\uffe515.49\n1-12 \u9999\u8549\uffe515.96\n\u4e00\u7bb1\u82cf\u6253\u6c34 \uffe520.61","description":"","created_by":1011,"handler":"","amount":"83.98","status":2,"settle_amount":"83.98","is_payment_settle":true,"created_at":"2026-01-23 10:12:39","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8202,"id2":8202,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00016","ticket_type":20018,"abstract":"\u91d1\u7545\u900d\u6d4b\u8bd5\u7528\u624b\u673a\uff1a13911665172 12\u6708\u4efd\u8bdd\u8d398.87\n\u62d3\u5c0f\u6587\u624b\u673a\uff1a13911517620 12\u6708\u4efd\u8bdd\u8d3947","description":"","created_by":1011,"handler":"","amount":"55.87","status":2,"settle_amount":"55.87","is_payment_settle":true,"created_at":"2026-01-23 10:12:38","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8201,"id2":8201,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00015","ticket_type":20018,"abstract":"\u6309\u6469\u6905\u7528\u978b\u595750\u53ea\/\u5305","description":"","created_by":1011,"handler":"","amount":"14.8","status":2,"settle_amount":"14.8","is_payment_settle":true,"created_at":"2026-01-23 10:12:38","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8200,"id2":8200,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00014","ticket_type":20018,"abstract":"\u529e\u516c\u7528 WPS\u5927\u4f1a\u54582\u5e74\u671f\u4f1a\u5458\u8d39","description":"","created_by":1011,"handler":"","amount":"263","status":2,"settle_amount":"263","is_payment_settle":true,"created_at":"2026-01-23 10:12:38","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8199,"id2":8199,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00013","ticket_type":20018,"abstract":"\u5a03\u54c8\u54c8\u6876\u88c5\u6c3428\u5143*50\u6876\uff08\u8d60\u900115\u6876\uff0c\u5171\u8ba165\u6876\uff09","description":"","created_by":5360,"handler":"","amount":"1400","status":2,"settle_amount":"1400","is_payment_settle":true,"created_at":"2026-01-23 10:12:38","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8193,"id2":8193,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00007","ticket_type":20018,"abstract":"\u9500\u552e\u5468\u4f8b\u4f1a\u5956\u52b1\u7ea2\u5305\u76ae","description":"","created_by":5360,"handler":"","amount":"31.8","status":2,"settle_amount":"31.8","is_payment_settle":true,"created_at":"2026-01-23 10:12:37","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8191,"id2":8191,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00005","ticket_type":20018,"abstract":"12\u670829\u65e5\u4e0b\u5348\uff0c\u53c2\u4f1a\u4eba\u54583\u676f\u745e\u661f\u5496\u5561\uff1a46\u5143\uff1b\n12\u670830\u65e5\u4e2d\u5348\uff0c\u5ba1\u6838\u8001\u5e08\u7684\u5348\u9910\uff0c\u5409\u91ce\u5bb6\u53cc\u62fc\u5957\u9910\uff1a47.5\u5143","description":"","created_by":1011,"handler":"","amount":"93.5","status":2,"settle_amount":"93.5","is_payment_settle":true,"created_at":"2026-01-23 10:12:37","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8190,"id2":8190,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00004","ticket_type":20018,"abstract":"ISO\u5ba1\u6838\u8001\u5e08\u76841.5\u5929\u7684\u8f66\u9a6c\u8d39","description":"","created_by":1011,"handler":"","amount":"615","status":2,"settle_amount":"615","is_payment_settle":true,"created_at":"2026-01-23 10:12:37","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8189,"id2":8189,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00003","ticket_type":20018,"abstract":"4\u7bb1\u519c\u592b\u5c71\u6cc94L*6\uff0c4\u7bb1\u519c\u592b\u5c71\u6cc9380ml\u74f6\u88c5\u6c34","description":"","created_by":5360,"handler":"","amount":"280","status":2,"settle_amount":"280","is_payment_settle":true,"created_at":"2026-01-23 10:12:37","createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","department_id":3,"avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8188,"id2":8188,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00002","ticket_type":20018,"abstract":"12\u6708\u4efd\u987a\u4e30\u5feb\u9012\/\u987a\u4e30\u6025\u9001 \u8d39\u7528","description":"","created_by":1011,"handler":"","amount":"340","status":2,"settle_amount":"340","is_payment_settle":true,"created_at":"2026-01-23 09:34:00","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8187,"id2":8187,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260123-00001","ticket_type":20018,"abstract":"\u529e\u516c\u7528\u5370\u53f03\u4e2a\uff1b\n\u529e\u516c\u5ba4\u5783\u573e\u888b\u4e00\u7bb1","description":"","created_by":1011,"handler":"","amount":"33.19","status":2,"settle_amount":"33.19","is_payment_settle":true,"created_at":"2026-01-23 09:34:00","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8185,"id2":8185,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-22","serial_no":"XJFYD-20260122-00004","ticket_type":20018,"abstract":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6\u8d39\u752812\u6708","description":"","created_by":5252,"handler":"","amount":"10292","status":2,"settle_amount":"10292","is_payment_settle":true,"created_at":"2026-01-22 11:14:42","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8178,"id2":8178,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260121-00007","ticket_type":20018,"abstract":"\u767e\u5ea6\u7f51\u76d8\u4f1a\u5458\u8d39\u7528","description":"","created_by":5085,"handler":"","amount":"148","status":2,"settle_amount":"148","is_payment_settle":true,"created_at":"2026-01-21 12:54:57","createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8177,"id2":8177,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"","serial_no":"XJFYD-20260121-00006","ticket_type":20018,"abstract":"\u767e\u5ea6\u7f51\u76d8\u4f1a\u5458\u4e00\u5e74\uff0c\u7528\u4e8e\u5411\u5ba2\u6237\u5206\u53d1\u955c\u50cf\u3002","description":"","created_by":1023,"handler":"","amount":"154","status":2,"settle_amount":"154","is_payment_settle":true,"created_at":"2026-01-21 12:54:57","createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","department_id":2,"avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"handlerPerson":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8172,"id2":8172,"supplier_id":667,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4383,"wrote_date":"2026-01-21","serial_no":"XJFYD-20260121-00001","ticket_type":20018,"abstract":"\u4ed8\u5b50\u6e90\u7f8e\u79be\u54a8\u8be2\u8d39","description":"","created_by":5388,"handler":"","amount":"88000","status":2,"settle_amount":"88000","is_payment_settle":true,"created_at":"2026-01-21 11:52: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":{"name":"\u516c\u53f8\u8d39\u7528"},"supplier":{"id":667,"key":667,"name":"\u5b50\u6e90\u7f8e\u79be\uff08\u5317\u4eac\uff09\u6587\u5316\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4383,"key":4383,"name":"TSKJ20260120-LRC-01"},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":667,"key":667,"name":"\u5b50\u6e90\u7f8e\u79be\uff08\u5317\u4eac\uff09\u6587\u5316\u6709\u9650\u516c\u53f8"},"contract_no":"TSKJ20260120-LRC-01","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":8171,"id2":8171,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-19","serial_no":"XJFYD-20260119-00002","ticket_type":20018,"abstract":"\u9500\u552e\u90e8\u5468\u4e00\u4f8b\u4f1a\u5956\u52b1","description":"","created_by":5388,"handler":"","amount":"550","status":2,"settle_amount":"550","is_payment_settle":true,"created_at":"2026-01-19 09:41:21","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8170,"id2":8170,"supplier_id":755,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4371,"wrote_date":"2026-01-19","serial_no":"XJFYD-20260119-00001","ticket_type":20018,"abstract":"\u91d1\u7545\u900dAI\u63a8\u5e7f\u8d39","description":"","created_by":5388,"handler":"","amount":"38400","status":2,"settle_amount":"38400","is_payment_settle":true,"created_at":"2026-01-19 09:39:07","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":{"name":"\u516c\u53f8\u8d39\u7528"},"supplier":{"id":755,"key":755,"name":"\u5317\u4eac\u5b9e\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4371,"key":4371,"name":"SX2026011208"},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":755,"key":755,"name":"\u5317\u4eac\u5b9e\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":"SX2026011208","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":8169,"id2":8169,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-16","serial_no":"XJFYD-20260116-00004","ticket_type":20018,"abstract":"\u534e\u590f\u94f6\u884c\u624b\u7eed\u8d397*2+10.5*2","description":"","created_by":5388,"handler":"","amount":"35","status":2,"settle_amount":"35","is_payment_settle":true,"created_at":"2026-01-16 17:40:56","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8168,"id2":8168,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-16","serial_no":"XJFYD-20260116-00003","ticket_type":20018,"abstract":"400\u7535\u8bdd\u8d39","description":"","created_by":5388,"handler":"","amount":"112.21","status":2,"settle_amount":"112.21","is_payment_settle":true,"created_at":"2026-01-16 17:40:11","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8167,"id2":8167,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-16","serial_no":"XJFYD-20260116-00002","ticket_type":20018,"abstract":"\u4ea425\u5e744\u5b63\u5ea6\u5408\u540c\u5370\u82b1\u7a0e","description":"","created_by":5388,"handler":"","amount":"4005.86","status":2,"settle_amount":"4005.86","is_payment_settle":true,"created_at":"2026-01-16 14:43:56","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8166,"id2":8166,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-16","serial_no":"XJFYD-20260116-00001","ticket_type":20018,"abstract":"\u4ea425\u5e744\u5b63\u5ea6\u5de5\u4f1a\u7ecf\u8d39","description":"","created_by":5388,"handler":"","amount":"9578.58","status":2,"settle_amount":"9578.58","is_payment_settle":true,"created_at":"2026-01-16 14:40:14","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8165,"id2":8165,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-15","serial_no":"XJFYD-20260115-00002","ticket_type":20018,"abstract":"\u5eb7\u83c0\u73cd12\u6708\u793e\u4fdd\u8d39","description":"","created_by":5388,"handler":"","amount":"2667.27","status":2,"settle_amount":"2667.27","is_payment_settle":true,"created_at":"2026-01-15 15:17:25","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8164,"id2":8164,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-15","serial_no":"XJFYD-20260115-00001","ticket_type":20018,"abstract":"\u4ea412\u6708\u589e\u503c\u7a0e\u53ca\u9644\u52a0\u7a0e","description":"","created_by":5388,"handler":"","amount":"113064.37","status":2,"settle_amount":"113064.37","is_payment_settle":true,"created_at":"2026-01-15 15:10:58","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8163,"id2":8163,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-12","serial_no":"XJFYD-20260112-00001","ticket_type":20018,"abstract":"\u9500\u552e\u90e8\u5468\u4e00\u4f8b\u4f1a\u5956\u52b1","description":"","created_by":5388,"handler":"","amount":"500","status":2,"settle_amount":"500","is_payment_settle":true,"created_at":"2026-01-12 09:30:52","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8162,"id2":8162,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-09","serial_no":"XJFYD-20260109-00003","ticket_type":20018,"abstract":"\u534e\u590f\u94f6\u884c\u624b\u7eed\u8d393.5*2+7*2+24.61*2","description":"","created_by":5388,"handler":"","amount":"70.22","status":2,"settle_amount":"70.22","is_payment_settle":true,"created_at":"2026-01-09 16:54:06","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8161,"id2":8161,"supplier_id":664,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4281,"wrote_date":"2026-01-09","serial_no":"XJFYD-20260109-00002","ticket_type":20018,"abstract":"ISO27001\u8d44\u8d28\u5ba1\u6838\u8d39","description":"","created_by":5388,"handler":"","amount":"5000","status":2,"settle_amount":"5000","is_payment_settle":true,"created_at":"2026-01-09 13:57:44","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":{"name":"\u516c\u53f8\u8d39\u7528"},"supplier":{"id":664,"key":664,"name":"\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4281,"key":4281,"name":"TSKJ20251201-HYF-01"},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":664,"key":664,"name":"\u5317\u4eac\u8bc1\u53cb\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":"TSKJ20251201-HYF-01","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":8160,"id2":8160,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-09","serial_no":"XJFYD-20260109-00001","ticket_type":20018,"abstract":"12\u6708\u4fdd\u6d01\u8d39","description":"","created_by":5388,"handler":"","amount":"300","status":2,"settle_amount":"300","is_payment_settle":true,"created_at":"2026-01-09 10:02:46","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8158,"id2":8158,"supplier_id":750,"client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":4345,"wrote_date":"2026-01-06","serial_no":"XJFYD-20260106-00001","ticket_type":20018,"abstract":"\u91d1\u7545\u900d\u8f6f\u4ef6\u5c55\u4f4d\u79df\u8d41\u8d39","description":"","created_by":5388,"handler":"","amount":"23000","status":2,"settle_amount":"23000","is_payment_settle":true,"created_at":"2026-01-06 14:12:19","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":{"name":"\u516c\u53f8\u8d39\u7528"},"supplier":{"id":750,"key":750,"name":"\u5317\u4eac\u632f\u5a01\u5c55\u89c8\u6709\u9650\u516c\u53f8"},"client":"","user":"","contact":"","salesContract":"","purchaseContract":{"id":4345,"key":4345,"name":"TSKJ20251225-HYF-01"},"ticket_type_display":"\u73b0\u91d1\u8d39\u7528\u5355","bgcolor":"#02A7F0","status_display":"\u5f85\u4ed8\u6b3e","unit":{"id":750,"key":750,"name":"\u5317\u4eac\u632f\u5a01\u5c55\u89c8\u6709\u9650\u516c\u53f8"},"contract_no":"TSKJ20251225-HYF-01","handlers":[{"name":"\u516c\u53f8\u8d39\u7528"}]},{"id":8157,"id2":8157,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-05","serial_no":"XJFYD-20260105-00001","ticket_type":20018,"abstract":"\u9500\u552e\u90e8\u5468\u4e00\u4f8b\u4f1a\u5956\u52b1","description":"","created_by":5388,"handler":"","amount":"50","status":2,"settle_amount":"50","is_payment_settle":true,"created_at":"2026-01-05 09:22:20","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8156,"id2":8156,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-04","serial_no":"XJFYD-20260104-00002","ticket_type":20018,"abstract":"\u516c\u53f8\u7535\u8bdd\u8d39","description":"","created_by":5388,"handler":"","amount":"889.83","status":2,"settle_amount":"889.83","is_payment_settle":true,"created_at":"2026-01-04 17:15:36","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":8155,"id2":8155,"supplier_id":"","client_id":"","user_id":"","contact_id":"","project_id":"","sales_contract_id":"","purchase_contract_id":"","wrote_date":"2026-01-04","serial_no":"XJFYD-20260104-00001","ticket_type":20018,"abstract":"\u5efa\u884c\u5361\u624b\u7eed\u8d39","description":"","created_by":5388,"handler":"","amount":"20","status":2,"settle_amount":"20","is_payment_settle":true,"created_at":"2026-01-04 17:14:02","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":{"name":"\u516c\u53f8\u8d39\u7528"},"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":"526726.87","total_count":120,"pagenation":{"totalcount":120,"thispage":3,"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:27:17', 48568064) RETURNING "id" |
| 11:27:17.582 | 0.8 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (667, 755, 664, 750) |
| 11:27:17.555 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 11:27:17.557 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:27:17.580 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5252, 1013, 5360, 1011, 5085, 1023, 5388) |
| 11:27:17.560 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE) |
| 11:27:17.581 | 0.2 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1023, 5252, 5085, 5388, 1013, 5360, 1011)) |
| 11:27:17.555 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 11:27:17.581 | 0.1 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (2, 6, 7, 3) |
| 11:27:17.561 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE) |