ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a20f01362df8: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-account-sales-outbound at 2026-06-04 11:25:07 am by 221.216.117.119

Performance Profiling

Total processing time: 30 ms; Peak memory: 5.001 MB. Show Profiling Timeline

总计16条数据
TimeDurationCategoryInfo
  
11:25:07.4163.3 msyii\db\Command::querySELECT * FROM ((SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount, COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_amount, (COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0)) * COALESCE(am.pct / 100, 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub" ORDER BY created_at DESC LIMIT 40
11:25:07.4213.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3286, 3389, 3457, 982, 3377, 3435, 2553)
11:25:07.4132.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount, COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_amount, (COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0)) * COALESCE(am.pct / 100, 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub" ORDER BY created_at DESC) "c"
11:25:07.4242.1 msyii\db\Command::querySELECT SUM(outbound_amount) FROM ((SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount, COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_amount, (COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0)) * COALESCE(am.pct / 100, 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub"
11:25:07.4272.1 msyii\db\Command::querySELECT SUM(outbound_cost) FROM ((SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount, COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_amount, (COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0)) * COALESCE(am.pct / 100, 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub"
11:25:07.4292.0 msyii\db\Command::querySELECT COUNT(*) FROM ((SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount, COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("r"."handler"='1001') AND (("r"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (r.project_id is null)) GROUP BY "r"."id") UNION ALL ( SELECT (r.id::varchar || 20008::varchar) as id, r.id as id2, null::integer as supplier_id, r.client_id as client_id, null::integer as user_id, null::integer as contact_id, r.project_id as project_id, r.handler, r.wrote_date, r.serial_no, 20008 as ticket_type, r.abstract, r.description, r.created_by, r.amount, r.number, r.status, null::numeric as settle_amount, false as is_payment_settle, r.created_at, COALESCE(sum(eipss.actual_total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) * COALESCE(am.pct / 100, 0) as outbound_amount, (COALESCE(sum(eipss.total_amount), 0) - COALESCE(sum(eipss.actual_total_amount), 0)) * COALESCE(am.pct / 100, 0) as outbound_profit FROM "a57be577deb434"."tbl_erp_sales_outbounds" "r" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON pd.project_id = r.project_id LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" ON am.erp_profit_distribute_id = pd.id WHERE ("r"."status"=2) AND ("r"."created_at" >= '2026-01-01 00:00:00') AND ("r"."created_at" <= '2026-12-31 23:59:59') AND ("am"."user_id"='1001') AND ("r"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "r"."id", "am"."user_id", "am"."pct" )) "sub"
11:25:07.4321.1 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-sales-outbound', '{"user_id":"1001","created_at_period":"erpcurrentfascalyear","created_at_to":"","created_at_from":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":157,"id2":157,"supplier_id":"","client_id":3286,"user_id":"","contact_id":"","project_id":4142,"handler":1001,"wrote_date":"2026-05-26","serial_no":"XSCKD-20260526-00001","ticket_type":20008,"abstract":"","description":"\u6700\u7ec8\u7528\u6237\u4fe1\u606f\uff1a\n\u4ebf\u5ba2\u884c\u54a8\u8be2\u670d\u52a1(\u5317\u4eac)\u6709\u9650\u516c\u53f8\nExpedia Consulting Service (Beijing) Co., Ltd.","created_by":1011,"amount":"176442","number":"2","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-26 16:12:02","outbound_cost":"158798.2","outbound_amount":"176442","outbound_profit":"17643.8","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"}},"supplier":"","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"project":{"id":4142,"key":4142,"name":"PA1420 \u4e24\u53f0\u65b0\u8d2d\u9879\u76ee"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":156,"id2":156,"supplier_id":"","client_id":3389,"user_id":"","contact_id":"","project_id":4172,"handler":1001,"wrote_date":"2026-05-25","serial_no":"XSCKD-20260525-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"amount":"18000","number":"1","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-25 11:17:35","outbound_cost":"1","outbound_amount":"18000","outbound_profit":"17999","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"}},"supplier":"","client":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"project":{"id":4172,"key":4172,"name":"\u63a8\u7279\u5982\u56fe"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3389,"key":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"contract_no":""},{"id":152,"id2":152,"supplier_id":"","client_id":3457,"user_id":"","contact_id":"","project_id":4157,"handler":1001,"wrote_date":"2026-05-18","serial_no":"XSCKD-20260518-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"amount":"33333","number":"1","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-18 16:05:22","outbound_cost":"1","outbound_amount":"33333","outbound_profit":"33332","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"}},"supplier":"","client":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"project":{"id":4157,"key":4157,"name":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260401002"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3457,"key":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d"},"contract_no":""},{"id":151,"id2":151,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","project_id":4161,"handler":1001,"wrote_date":"2026-05-15","serial_no":"XSCKD-20260515-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"amount":"8468748","number":"3","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-05-15 15:30:46","outbound_cost":"135","outbound_amount":"8468748","outbound_profit":"8468613","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"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4161,"key":4161,"name":"3535"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":""},{"id":150,"id2":150,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","project_id":4161,"handler":1001,"wrote_date":"2026-04-23","serial_no":"XSCKD-20260423-00001","ticket_type":20008,"abstract":"","description":"","created_by":1001,"amount":"4234324","number":"1","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-04-23 16:51:35","outbound_cost":"647.205","outbound_amount":"4234324","outbound_profit":"4233676.795","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"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4161,"key":4161,"name":"3535"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":""},{"id":149,"id2":149,"supplier_id":"","client_id":982,"user_id":"","contact_id":"","project_id":4164,"handler":1001,"wrote_date":"2026-04-08","serial_no":"XSCKD-20260408-00003","ticket_type":20008,"abstract":"\u591a\u8212\u670d\u7684\u6c99\u53d1","description":"\u65b9\u5f0f\u5730\u65b9","created_by":1001,"amount":"24238558","number":"2","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-04-08 11:23:04","outbound_cost":"0","outbound_amount":"0","outbound_profit":"0","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"}},"supplier":"","client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"project":{"id":4164,"key":4164,"name":"\u6d4b\u8bd5\u65b0\u5efa\u5546\u673a\/\u7f16\u8f91\/\u751f\u6210\u5408\u540c"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"contract_no":""},{"id":132,"id2":132,"supplier_id":"","client_id":3377,"user_id":"","contact_id":"","project_id":4098,"handler":1001,"wrote_date":"2026-02-02","serial_no":"XSCKD-20260202-00001","ticket_type":20008,"abstract":"\u5229\u6da6\u7387\uff1a1.72%\uff1b\u6536\u8d27\u4eba\uff1a\u9648\u8d85","description":"","created_by":1011,"amount":"1630000","number":"20","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-02-02 10:45:23","outbound_cost":"1046515","outbound_amount":"1630000","outbound_profit":"583485","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"}},"supplier":"","client":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"project":{"id":4098,"key":4098,"name":"PA460\u8bbe\u5907\u7b49\u91c7\u8d2d\u9879\u76ee"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3377,"key":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"contract_no":""},{"id":124,"id2":124,"supplier_id":"","client_id":3435,"user_id":"","contact_id":"","project_id":4111,"handler":1001,"wrote_date":"2026-01-22","serial_no":"XSCKD-20260122-00001","ticket_type":20008,"abstract":"\u5229\u6da6\u7387\uff1a100%\uff1b\u6536\u8d27\u4eba\uff1a\u8d75\u7389\u5c71","description":"","created_by":1011,"amount":"29800","number":"1","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-01-22 13:34:43","outbound_cost":"0.00000000000000000000","outbound_amount":"14900.00000000000000000000","outbound_profit":"14900.00000000000000000000","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"}},"supplier":"","client":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":4111,"key":4111,"name":"\u91d1\u7545\u900dERP\u8f6f\u4ef6\u4e00\u5957\u91c7\u8d2d\u9879\u76ee"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":3435,"key":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""},{"id":122,"id2":122,"supplier_id":"","client_id":2553,"user_id":"","contact_id":"","project_id":4096,"handler":1001,"wrote_date":"2026-01-12","serial_no":"XSCKD-20260112-00001","ticket_type":20008,"abstract":"\u5229\u6da6\u7387\uff1a2%\uff1b\u6536\u8d27\u4eba\uff1a\u674e\u5b81\uff1bPA\u5382\u5546\u674e\u777f\u79ef\u5206723","description":"","created_by":1011,"amount":"1400","number":"2","status":2,"settle_amount":"","is_payment_settle":false,"created_at":"2026-01-12 16:36:46","outbound_cost":"380","outbound_amount":"1400","outbound_profit":"1020","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"}},"supplier":"","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"project":{"id":4096,"key":4096,"name":"\u6a21\u5757\u91c7\u8d2d"},"user":"","contact":"","ticket_type_display":"\u9500\u552e\u51fa\u5e93\u5355","bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","unit":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"},"contract_no":""}],"outbound_amount":"14577147.00000000000000000000","outbound_cost":"1206477.40500000000000000000","total_count":9,"pagenation":{"totalcount":9,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 11:25:07', 26665728) RETURNING "id"
11:25:07.4070.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:25:07.4080.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:25:07.4190.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001)
11:25:07.4200.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 (1001, 1011))
11:25:07.4240.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4142, 4172, 4157, 4161, 4164, 4098, 4111, 4096)
11:25:07.4110.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
11:25:07.4060.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:25:07.4120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)
11:25:07.4200.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 3)