ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7ad856068d: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2025-09-15 02:09:09 pm by 114.246.237.213

Performance Profiling

Total processing time: 43 ms; Peak memory: 4.727 MB. Show Profiling Timeline

总计13条数据
TimeDurationCategoryInfo
  
14:09:09.4159.8 msyii\db\Command::querySELECT "p".* FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ("c"."name" ILIKE '%中国%') OR ("c"."pinyin_shortcut" ILIKE '%中国%') OR ("p"."pinyin_shortcut" ILIKE '%中国%') OR ("p"."project_title" ILIKE '%中国%') OR ("u2"."name" ILIKE '%中国%') ORDER BY "p"."bargain_date" DESC, "p"."updated_at" DESC LIMIT 40 OFFSET 40
14:09:09.4068.3 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id WHERE ("c"."name" ILIKE '%中国%') OR ("c"."pinyin_shortcut" ILIKE '%中国%') OR ("p"."pinyin_shortcut" ILIKE '%中国%') OR ("p"."project_title" ILIKE '%中国%') OR ("u2"."name" ILIKE '%中国%') ORDER BY "p"."bargain_date" DESC, "p"."updated_at" DESC) "c"
14:09:09.4293.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15')
14:09:09.3982.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:09:09.3961.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:09:09.4011.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:09:09.4341.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-sales-cost', '{"created_at_period":"currentfascalyear","created_by":"","keyword":"\u4e2d\u56fd","page":"2","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"list":[{"id":3805,"project_title":"POBJ25034995-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"511","updated_at":"2025-04-17 16:24:48","created_at":"2025-03-21 11:56:09","bargain_date":"2025-03-21","collected":"511","un_collected":0,"pinyin_shortcut":"POBJ25034995gtypG2025","description":"","id2":3805,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3835,"from_project":3805,"is_outbound":true},"buildContract":{"id":3835,"from_project":3805,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3801,"project_title":"POTJ25034534-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:25:02","created_at":"2025-03-19 20:04:27","bargain_date":"2025-03-19","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25034534gtypnct2025","description":"","id2":3801,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3831,"from_project":3801,"is_outbound":true},"buildContract":{"id":3831,"from_project":3801,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3802,"project_title":"POTJ25034538-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:24:56","created_at":"2025-03-19 20:08:35","bargain_date":"2025-03-19","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25034538gtypnct2025","description":"","id2":3802,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3832,"from_project":3802,"is_outbound":true},"buildContract":{"id":3832,"from_project":3802,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3792,"project_title":"IBM\u7535\u6e90\u66f4\u6362","client_id":20,"budget":"500","updated_at":"2025-04-07 11:28:10","created_at":"2025-03-06 09:00:53","bargain_date":"2025-03-06","collected":"500","un_collected":0,"pinyin_shortcut":"IBMdygh","description":"","id2":3792,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3812,"from_project":3792,"is_outbound":true},"buildContract":{"id":3812,"from_project":3792,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3794,"project_title":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"511","updated_at":"2025-03-20 17:24:57","created_at":"2025-03-06 19:44:56","bargain_date":"2025-03-06","collected":"511","un_collected":0,"pinyin_shortcut":"POBJ25031110gtypG2025","description":"","id2":3794,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3816,"from_project":3794,"is_outbound":true},"buildContract":{"id":3816,"from_project":3794,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3782,"project_title":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"629","updated_at":"2025-08-20 17:56:25","created_at":"2025-02-24 11:45:40","bargain_date":"2025-02-24","collected":"629","un_collected":0,"pinyin_shortcut":"POBJ25024486gtypG2025","description":"","id2":3782,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3792,"from_project":3782,"is_outbound":true},"buildContract":{"id":3792,"from_project":3782,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3775,"project_title":"POTJ25021715-\u7535\u6e90\u9644\u4ef6-G-2025","client_id":12,"budget":"556","updated_at":"2025-03-12 23:29:18","created_at":"2025-02-11 17:38:49","bargain_date":"2025-02-11","collected":"556","un_collected":0,"pinyin_shortcut":"POTJ25021715dyfjG2025","description":"","id2":3775,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3782,"from_project":3775,"is_outbound":true},"buildContract":{"id":3782,"from_project":3775,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3773,"project_title":"POBJ25020936-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"1533","updated_at":"2025-02-24 11:50:48","created_at":"2025-02-10 13:26:02","bargain_date":"2025-02-10","collected":"1533","un_collected":0,"pinyin_shortcut":"POBJ25020936gtypG2025","description":"","id2":3773,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3778,"from_project":3773,"is_outbound":true},"buildContract":{"id":3778,"from_project":3773,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3766,"project_title":"POTJ25013202-\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-G-2025","client_id":12,"budget":"20560","updated_at":"2025-02-26 11:32:21","created_at":"2025-01-14 18:03:36","bargain_date":"2025-01-14","collected":"20560","un_collected":0,"pinyin_shortcut":"POTJ25013202hswlsbG2025","description":"","id2":3766,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"144.00","erp_profit_amount":"0","erp_j_profit_amount":"-144.00","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3759,"from_project":3766,"is_outbound":true},"buildContract":{"id":3759,"from_project":3766,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3765,"project_title":"POTJ25013200-\u534e\u4e09\u7f51\u7edc\u8bbe\u59072-G-2025","client_id":12,"budget":"7156","updated_at":"2025-02-24 11:50:41","created_at":"2025-01-14 18:02:02","bargain_date":"2025-01-14","collected":"7156","un_collected":0,"pinyin_shortcut":"POTJ25013200hswlsb2G2025","description":"","id2":3765,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3758,"from_project":3765,"is_outbound":true},"buildContract":{"id":3758,"from_project":3765,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3721,"project_title":"MSS24-25\u5e74\u7eed\u4fdd","client_id":20,"budget":"117000","updated_at":"2025-08-19 12:54:08","created_at":"2024-11-24 19:54:17","bargain_date":"2025-01-03","collected":"117000","un_collected":0,"pinyin_shortcut":"MSS2425nxb","description":"","id2":3721,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"84.62","erp_profit_amount":"0","erp_j_profit_amount":"-84.62","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3745,"from_project":3721,"is_outbound":true},"buildContract":{"id":3745,"from_project":3721,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3757,"project_title":"H3C\u670d\u52a1\u5668\u786c\u76d8\u6362\u65b0","client_id":918,"budget":"700","updated_at":"2025-02-11 15:20:29","created_at":"2025-01-03 13:49:53","bargain_date":"2025-01-03","collected":"700","un_collected":0,"pinyin_shortcut":"H3Cfwqyphx","description":"","id2":3757,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3744,"from_project":3757,"is_outbound":true},"buildContract":{"id":3744,"from_project":3757,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""}],"pagenation":{"totalcount":52,"thispage":2,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 14:09:09') RETURNING "id"
14:09:09.4330.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=798, "last_visit_at"='now()' WHERE "id"=56557
14:09:09.4260.6 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1005, 5300))
14:09:09.4270.5 msyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3805, 3801, 3802, 3792, 3794, 3782, 3775, 3773, 3766, 3765, 3721, 3757)
14:09:09.4270.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
14:09:09.4250.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 20, 918)
14:09:09.4260.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1005)