ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868bf06d969b: POST https://beta.jinchangxiao.com/vue/analysis/used-client-collected-payment-collection at 2025-07-05 01:58:30 pm by 223.72.35.175

Performance Profiling

Total processing time: 87 ms; Peak memory: 5.194 MB. Show Profiling Timeline

总计15条数据
TimeDurationCategoryInfo
  
13:58:30.93614.7 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_project_used_clients' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
13:58:30.91810.9 msyii\db\Command::querySELECT sc.*, p.client_id, sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.budget - scp.collected) as uncollected, sum(sc.budget - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.budget - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "scp" ON scp.project_used_client_id = sc.id LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "sci" ON sci.project_used_client_id = sc.id LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "tcollect" ON tcollect.project_used_client_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_project_used_client_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.project_used_client_id = scpcrd.project_used_client_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN (SELECT "project_used_client_id", sum(amount) as collected FROM "a57be577deb434"."tbl_project_used_client_payments" GROUP BY "project_used_client_id") "scp" ON scp.project_used_client_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.project_used_client_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-05') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE ("p"."project_status"=3) AND (sc.used_client is not null) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) GROUP BY "sc"."id", "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
13:58:30.9108.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT sc.*, p.client_id, sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.budget - scp.collected) as uncollected, sum(sc.budget - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.budget - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "scp" ON scp.project_used_client_id = sc.id LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "sci" ON sci.project_used_client_id = sc.id LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "tcollect" ON tcollect.project_used_client_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_project_used_client_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.project_used_client_id = scpcrd.project_used_client_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN (SELECT "project_used_client_id", sum(amount) as collected FROM "a57be577deb434"."tbl_project_used_client_payments" GROUP BY "project_used_client_id") "scp" ON scp.project_used_client_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.project_used_client_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-05') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE ("p"."project_status"=3) AND (sc.used_client is not null) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) GROUP BY "sc"."id", "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
13:58:30.9306.2 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_project_used_clients' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
13:58:30.9636.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')
13:58:30.9565.5 msyii\db\Command::querySELECT sum(budget) as amount, sum(this_collected) as collected, sum(budget - collected) as uncollected, sum(collected_count) as collected_count, count(distinct client_id) as client_count FROM (SELECT sc.*, p.client_id, sum(scp.collected) as collected, sum(sci.invoiced) as invoiced, sum(tcollect.this_collected) as this_collected, sum(tcollect.collected_count) as collected_count, sum(sc.budget - scp.collected) as uncollected, sum(sc.budget - sci.invoiced) as uninvoiced, sum(od_total_this - od_collected) as overdue, CASE WHEN sum(od_total_this - od_collected) > 0 THEN 0 WHEN sum(sc.budget - scp.collected) > 0 THEN 1 ELSE 2 END AS status FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS collected FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "scp" ON scp.project_used_client_id = sc.id LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_invoices" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "sci" ON sci.project_used_client_id = sc.id LEFT JOIN (SELECT t0.id AS project_used_client_id, COALESCE(sum(t1.amount), 0) AS this_collected, count(t1.id) as collected_count FROM "a57be577deb434"."tbl_project_used_clients" "t0" LEFT JOIN "a57be577deb434"."tbl_project_used_client_payments" "t1" ON t0.id = t1.project_used_client_id GROUP BY "t0"."id") "tcollect" ON tcollect.project_used_client_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_project_used_client_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.project_used_client_id = scpcrd.project_used_client_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_project_used_clients" "sc" LEFT JOIN (SELECT "project_used_client_id", sum(amount) as collected FROM "a57be577deb434"."tbl_project_used_client_payments" GROUP BY "project_used_client_id") "scp" ON scp.project_used_client_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.project_used_client_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (remind_date <= '2025-07-05') AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id WHERE ("p"."project_status"=3) AND (sc.used_client is not null) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) GROUP BY "sc"."id", "p"."id" ORDER BY "p"."bargain_date" DESC) "sub"
13:58:30.8935.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:58:30.8983.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
13:58:30.9722.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/used-client-collected-payment-collection', '{"status":"","period":"","to":"","from":"","dataUserId":"","group":"","page":"1","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":95,"project_id":3801,"used_client":3334,"budget":"598000","profit":"478400","profit_pct":"80","collected_plan":"110000","remind_ahead":"","client_id":3278,"collected":"1.00","invoiced":"1","this_collected":"1.00","collected_count":"1","uncollected":"597999.00","uninvoiced":"597999","overdue":"109999.00","status":0,"project":{"id":3801,"key":3801,"name":"\u8d1f\u6570\u95ee\u9898","project_status":3,"budget":"8000","collected":"1","client_id":3278,"bargain_date":"2025-04-09","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3844,"from_project":3801,"serial_no":""}},"projectUsedClientPaymentCollectionRemindDates":[{"id":13,"key":13,"project_used_client_id":95,"remind_date":"2025-06-11","amount":110000,"name":"2025-06-11","value":110000,"overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f24\u5929","overdue_amount":109999,"remind_date":"2025-06-11"},{"id":40,"project_id":3769,"used_client":2130,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3326,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3769,"key":3769,"name":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","project_status":3,"budget":"32000","collected":"32000","client_id":3326,"bargain_date":"2025-03-05","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"buildContract":{"id":3770,"from_project":3769,"serial_no":"TS-LW-20250305001"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":92,"project_id":3786,"used_client":982,"budget":"20000","profit":"16000","profit_pct":"80","collected_plan":"8000","remind_ahead":"1 day","client_id":3334,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"20000","uninvoiced":"20000","overdue":"8000","status":0,"project":{"id":3786,"key":3786,"name":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","project_status":3,"budget":"3593747","collected":"-1","client_id":3334,"bargain_date":"2025-02-28","client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"buildContract":{"id":3803,"from_project":3786,"serial_no":"TSKJ20250228-LRC-001"}},"projectUsedClientPaymentCollectionRemindDates":[{"id":1,"key":1,"project_used_client_id":92,"remind_date":"2025-04-08","amount":8000,"name":"2025-04-08","value":8000,"overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f88\u5929","overdue_amount":8000,"remind_date":"2025-04-08"},{"id":44,"project_id":3783,"used_client":1457,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3333,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3783,"key":3783,"name":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","project_status":3,"budget":"2310000","collected":"0","client_id":3333,"bargain_date":"2025-02-21","client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3795,"from_project":3783,"serial_no":"TSKJ20250221-ZHY-001"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":42,"project_id":3780,"used_client":2136,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3329,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3780,"key":3780,"name":"59\u6240\u56fd\u4ea7\u670d\u52a1\u5668\u91c7\u8d2d -k","project_status":3,"budget":"277500","collected":"0","client_id":3329,"bargain_date":"2025-02-10","client":{"id":3329,"key":3329,"name":"\u6df1\u5733\u9f50\u5fc3\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8 (\u8fc7\u5355\uff09"},"buildContract":{"id":3789,"from_project":3780,"serial_no":"LINK20250210340000693"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":93,"project_id":3767,"used_client":3300,"budget":"20000","profit":"18000","profit_pct":"90","collected_plan":"2398","remind_ahead":"2 days","client_id":3327,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"20000","uninvoiced":"20000","overdue":"2398","status":0,"project":{"id":3767,"key":3767,"name":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","project_status":3,"budget":"121361","collected":"121361","client_id":3327,"bargain_date":"2025-01-16","client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3763,"from_project":3767,"serial_no":"TS-LRC-2025011601"}},"projectUsedClientPaymentCollectionRemindDates":[{"id":3,"key":3,"project_used_client_id":93,"remind_date":"2025-04-10","amount":55,"name":"2025-04-10","value":55,"overdue_days":""},{"id":4,"key":4,"project_used_client_id":93,"remind_date":"2025-04-07","amount":2343,"name":"2025-04-07","value":2343,"overdue_days":""}],"collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f86\u5929","overdue_amount":2398,"remind_date":"2025-04-07"},{"id":38,"project_id":3755,"used_client":287,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3328,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3755,"key":3755,"name":"\u9f50\u6cbb\u5821\u5792\u673a\u65b0\u8d2d-K-224","project_status":3,"budget":"537370","collected":"0","client_id":3328,"bargain_date":"2024-12-31","client":{"id":3328,"key":3328,"name":"\u8fc7\u5355-\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8\u4e0a\u6d77\u5206\u516c\u53f8-\u5317\u4eac\u5954\u9a70"},"buildContract":{"id":3740,"from_project":3755,"serial_no":"DCA2024120211"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":21,"project_id":3710,"used_client":1121,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3317,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3710,"key":3710,"name":"\u65b0\u8d2d\u6570\u636e\u5907\u4efd\u548c\u65e5\u5fd7\u5ba1\u8ba1\u7cfb\u7edf","project_status":3,"budget":"228435","collected":"68530","client_id":3317,"bargain_date":"2024-11-04","client":{"id":3317,"key":3317,"name":"\u5317\u4eac\u98de\u9e4f\u6052\u4e1a\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3646,"from_project":3710,"serial_no":"TS-WZW-2024110401"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":31,"project_id":3736,"used_client":2130,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3326,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3736,"key":3736,"name":"\u897f\u660c\u7f51\u5173\u9879\u76ee-K","project_status":3,"budget":"293040","collected":"293040","client_id":3326,"bargain_date":"2024-10-30","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"buildContract":{"id":3697,"from_project":3736,"serial_no":"TS-LW-2024103001"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":22,"project_id":3709,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3303,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3709,"key":3709,"name":"\u7535\u79d1\u592a\u529b\u4fe1\u606f\u4e2d\u5fc3\u673a\u623f\u642c\u8fc1","project_status":3,"budget":"305280","collected":"305280","client_id":3303,"bargain_date":"2024-10-29","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3645,"from_project":3709,"serial_no":"XSZYO68316"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":2,"project_id":3655,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3303,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3655,"key":3655,"name":"\u963f\u91cc\u4e91\u8fc1\u79fb\u670d\u52a1","project_status":3,"budget":"169600","collected":"169600","client_id":3303,"bargain_date":"2024-09-12","client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3542,"from_project":3655,"serial_no":"XSZY067245"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":1,"project_id":3651,"used_client":3300,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":2526,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3651,"key":3651,"name":"\u7cfb\u7edf\u516c\u53f8\u7f51\u7edc\u7ef4\u62a4\u2014K","project_status":3,"budget":"4000","collected":"4000","client_id":2526,"bargain_date":"2024-09-04","client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3522,"from_project":3651,"serial_no":"TS-LW-2024090401"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":49,"project_id":3638,"used_client":3174,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3299,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3638,"key":3638,"name":"\u534e\u4e3a\u65e0\u7ebfAP","project_status":3,"budget":"36950","collected":"36950","client_id":3299,"bargain_date":"2024-08-19","client":{"id":3299,"key":3299,"name":"\u6c5f\u897f\u6a1f\u6f9c\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3495,"from_project":3638,"serial_no":"TS-YJC-2024081901"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":53,"project_id":3609,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":2091,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3609,"key":3609,"name":"\u601d\u79d1N9K\u7b49\u7eed\u4fdd\u9879\u76ee","project_status":3,"budget":"300000","collected":"0","client_id":2091,"bargain_date":"2024-08-05","client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3477,"from_project":3609,"serial_no":"\u601d\u8054\u79d1\u8baf\u7b7e\u7ea6YJC-2024080501"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":36,"project_id":3583,"used_client":2526,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3270,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3583,"key":3583,"name":"\u670d\u52a1\u8d39-K","project_status":3,"budget":"110000","collected":"110000","client_id":3270,"bargain_date":"2024-07-22","client":{"id":3270,"key":3270,"name":"\u5317\u4eac\u51ef\u9510\u8fdc\u666f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3420,"from_project":3583,"serial_no":"TS-LW-2024072201"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":41,"project_id":3597,"used_client":3287,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3287,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3597,"key":3597,"name":"\u4ea4\u6362\u673a\u9879\u76ee","project_status":3,"budget":"170600","collected":"170600","client_id":3287,"bargain_date":"2024-07-12","client":{"id":3287,"key":3287,"name":"\u4e0a\u6d77\u7533\u94f6\u4e07\u56fd\u8bc1\u5238\u7814\u7a76\u6240\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3410,"from_project":3597,"serial_no":"TS-ZL-2024062603"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":48,"project_id":3555,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":2714,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3555,"key":3555,"name":"\u601d\u79d1\u7aef\u53e3\u6388\u6743\u9879\u76ee","project_status":3,"budget":"257296","collected":"257296","client_id":2714,"bargain_date":"2024-06-27","client":{"id":2714,"key":2714,"name":"\u5317\u4eac\u534e\u590f\u51ef\u777f\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3373,"from_project":3555,"serial_no":"TS-YJC-20240627"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":13,"project_id":3546,"used_client":149,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":3265,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3546,"key":3546,"name":"\u665f\u6e90\u81ea\u52a8\u5316\u8bbe\u5907\u5907\u4ef6","project_status":3,"budget":"87917","collected":"87917","client_id":3265,"bargain_date":"2024-05-24","client":{"id":3265,"key":3265,"name":"\u5317\u4eac\u91d1\u6e90\u5229\u76db\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3311,"from_project":3546,"serial_no":"TS-ZHY-2024052408"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4,"project_id":3487,"used_client":5,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":2091,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3487,"key":3487,"name":"2024\u865a\u62df\u5316\u5e73\u53f0\u786c\u4ef6\u7eed\u4fdd\u9879\u76ee","project_status":3,"budget":"2322000","collected":"2322000","client_id":2091,"bargain_date":"2024-04-28","client":{"id":2091,"key":2091,"name":"\u795e\u5dde\u6570\u7801\u7cfb\u7edf\u96c6\u6210\u670d\u52a1\u6709\u9650\u516c\u53f8"},"buildContract":{"id":3261,"from_project":3487,"serial_no":"\u601d\u8054\u79d1\u8bafDCS2024040186"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":54,"project_id":3512,"used_client":2724,"budget":"","profit":"","profit_pct":"","collected_plan":"","remind_ahead":"","client_id":2842,"collected":"0","invoiced":"0","this_collected":"0","collected_count":"0","uncollected":"","uninvoiced":"","overdue":"","status":2,"project":{"id":3512,"key":3512,"name":"\u4e00\u6c7d\u9752\u85e4\u7ef4\u4fdd\u670d\u52a1","project_status":3,"budget":"120000","collected":"0","client_id":2842,"bargain_date":"2024-04-23","client":{"id":2842,"key":2842,"name":"\u5317\u4eac\u79b9\u5b8f\u4fe1\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"buildContract":{"id":3243,"from_project":3512,"serial_no":"TS-ZHY-2024041895"}},"projectUsedClientPaymentCollectionRemindDates":[],"collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""}],"count":{"amount":"45984345","collected":"1.00","uncollected":"45984344.00","collected_count":"1","client_count":42},"pagenation":{"totalcount":52,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 13:58:30') RETURNING "id"
13:58:30.9702.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=104, "last_visit_at"='now()' WHERE "id"=49799
13:58:30.9021.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
13:58:30.9541.1 msyii\db\Command::querySELECT "id", "from_project", "serial_no" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3651, 3655, 3487, 3546, 3710, 3709, 3736, 3583, 3755, 3769, 3597, 3780, 3555, 3638, 3609, 3786, 3767, 3783, 3512, 3801)
13:58:30.9520.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected", "client_id", "bargain_date" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3801, 3769, 3786, 3783, 3780, 3767, 3755, 3710, 3736, 3709, 3655, 3651, 3638, 3609, 3583, 3597, 3555, 3546, 3487, 3512)
13:58:30.9530.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2526, 3303, 2091, 3265, 3317, 3326, 3270, 3328, 3287, 3329, 2714, 3299, 3334, 3327, 3333, 2842, 3278)
13:58:30.9550.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_used_client_id", "remind_date", "amount", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_project_used_client_payment_collection_remind_dates" WHERE "project_used_client_id" IN (95, 40, 92, 44, 42, 93, 38, 21, 31, 22, 2, 1, 49, 53, 36, 41, 48, 13, 4, 54)