ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68967be999e8c: GET https://beta.jinchangxiao.com/vue/analysis/sales-payment-collection-by-times at 2025-08-09 06:36:25 am by 114.119.146.195

Log Messages

总计47条数据
TimeLevelCategoryMessage
 
06:36:25.630traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
06:36:25.630traceyii\base\Module::getModuleLoading module: debug
06:36:25.630traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
06:36:25.630traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
06:36:25.630traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
06:36:25.630traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.630traceyii\base\Module::getModuleLoading module: gii
06:36:25.630traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
06:36:25.631traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
06:36:25.631traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-payment-collection-by-times'
06:36:25.631traceyii\base\Module::getModuleLoading module: vue
06:36:25.631infoyii\web\Session::openSession started
06:36:25.632infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
06:36:25.632infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
06:36:25.636traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.636traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
06:36:25.637traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.637traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
06:36:25.637infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
06:36:25.639traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-payment-collection-by-times
06:36:25.639traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.640traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
06:36:25.640traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesPaymentCollectionByTimes()
06:36:25.642traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.642traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.643infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT sub.*, CASE WHEN total_this > sub.collected then (CASE WHEN total_this - sub.collected > sub.amount THEN sub.amount ELSE total_this - sub.collected END) else 0 END as uncollected, CASE WHEN sub.remind_date <= '2025-08-09' THEN ( CASE WHEN total_this > sub.collected then (CASE WHEN total_this - sub.collected > sub.amount THEN sub.amount ELSE total_this - sub.collected END) else 0 END) ELSE 0 END as overdue, CASE WHEN sub.collected >= total_this THEN 1 ELSE 0 END as status, CASE WHEN sub.collected >= total_this THEN 2 ELSE ( CASE WHEN sub.remind_date <= '2025-08-09' THEN 0 ELSE 1 END ) END as status2, sci.invoiced, (sc.amount - sci.invoiced) as uninvoiced FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected, sc.project_id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (sc.from_project is not null) AND (p.project_status = 3) AND (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sub.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0)) ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"
06:36:25.711infoyii\db\Command::querySELECT sub.*, CASE WHEN total_this > sub.collected then (CASE WHEN total_this - sub.collected > sub.amount THEN sub.amount ELSE total_this - sub.collected END) else 0 END as uncollected, CASE WHEN sub.remind_date <= '2025-08-09' THEN ( CASE WHEN total_this > sub.collected then (CASE WHEN total_this - sub.collected > sub.amount THEN sub.amount ELSE total_this - sub.collected END) else 0 END) ELSE 0 END as overdue, CASE WHEN sub.collected >= total_this THEN 1 ELSE 0 END as status, CASE WHEN sub.collected >= total_this THEN 2 ELSE ( CASE WHEN sub.remind_date <= '2025-08-09' THEN 0 ELSE 1 END ) END as status2, sci.invoiced, (sc.amount - sci.invoiced) as uninvoiced FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), case when p.collected is null then 0 else p.collected end as collected, sc.project_id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (sc.from_project is not null) AND (p.project_status = 3) AND (("sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sub.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, CASE WHEN t0.including_tax = true THEN COALESCE(sum(t1.amount), 0) ELSE t0.amount END AS invoiced FROM "a57be577deb434"."tbl_sales_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "t1" ON t0.id = t1.contract_id WHERE t0.need_analysis = true GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0)) ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20
06:36:25.788traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:25.788infoyii\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_sales_contract_payment_collection_remind_dates' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
06:36:25.794infoyii\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_sales_contract_payment_collection_remind_dates' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
06:36:25.802traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
06:36:25.803traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
06:36:25.803infoyii\db\Command::querySELECT "id", "id" AS "key", "project_id", "client_id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4075, 4068, 4065, 4064, 4055, 4054, 4050, 4049, 4048, 4047, 4046, 4044, 4043, 4036, 4029, 4026, 4024, 4022, 4021)
06:36:25.803infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3912, 3913, 3910, 3906, 3916, 3918, 3920, 3883, 3917, 3882, 3919, 3924, 3925, 3926, 3751, 3928, 3929, 3930, 3927)
06:36:25.804infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (12, 2762, 3378, 3383, 2182, 2553, 3286)
06:36:25.805infoyii\db\Command::querySELECT sum(amount) as budget FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ) ,( SELECT sum(scpcrdsub2.amount) as in_this_time FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub2 where scpcrdsub2.remind_date <= scpcrd.remind_date and scpcrdsub2.contract_id = scpcrd.contract_id and ( "scpcrdsub2"."remind_date" >= '2025-08-01 00:00:00' ) AND ( "scpcrdsub2"."remind_date" <= '2025-08-31 23:59:59' ) ), ( SELECT sum(scpcrdsub3.amount) as before_this_time FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub3 where scpcrdsub3.remind_date <= scpcrd.remind_date and scpcrdsub3.contract_id = scpcrd.contract_id and ( "scpcrdsub3"."remind_date" < '2025-08-01 00:00:00' ) ), case when p.collected is null then 0 else p.collected end as collected, sc.project_id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (sc.from_project is not null) AND (p.project_status = 3) AND (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE (("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))
06:36:25.868infoyii\db\Command::querySELECT sum ( CASE WHEN collected >= total_this THEN 0 WHEN collected < total_this AND collected <= before_this_time THEN in_this_time WHEN collected < total_this AND collected > before_this_time THEN in_this_time - (collected - before_this_time) END ) as uncollected FROM (SELECT max(total_this) as total_this, max(in_this_time) as in_this_time, CASE WHEN MAX ( before_this_time ) IS NULL THEN 0 ELSE MAX ( before_this_time ) END AS before_this_time, case when MAX ( collected ) > 0 then MAX ( collected ) else 0 end AS collected, project_id FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ) ,( SELECT sum(scpcrdsub2.amount) as in_this_time FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub2 where scpcrdsub2.remind_date <= scpcrd.remind_date and scpcrdsub2.contract_id = scpcrd.contract_id and ( "scpcrdsub2"."remind_date" >= '2025-08-01 00:00:00' ) AND ( "scpcrdsub2"."remind_date" <= '2025-08-31 23:59:59' ) ), ( SELECT sum(scpcrdsub3.amount) as before_this_time FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub3 where scpcrdsub3.remind_date <= scpcrd.remind_date and scpcrdsub3.contract_id = scpcrd.contract_id and ( "scpcrdsub3"."remind_date" < '2025-08-01 00:00:00' ) ), case when p.collected is null then 0 else p.collected end as collected, sc.project_id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (sc.from_project is not null) AND (p.project_status = 3) AND (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE (("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0)) GROUP BY "project_id") "sub2" WHERE collected < total_this
06:36:25.945infoyii\db\Command::querySELECT sum( CASE WHEN collected >= total_this THEN 0 ELSE total_this - collected END ) as overdue FROM (SELECT max(total_this) as total_this, CASE WHEN max(in_this_time) IS NULL THEN 0 ELSE max(in_this_time) END as in_this_time, CASE WHEN MAX ( before_this_time ) IS NULL THEN 0 ELSE MAX ( before_this_time ) END AS before_this_time, case when MAX ( collected ) > 0 then MAX ( collected ) else 0 end AS collected, project_id FROM (SELECT scpcrd.* ,( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ) ,( SELECT sum(scpcrdsub2.amount) as in_this_time FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub2 where scpcrdsub2.remind_date <= scpcrd.remind_date and scpcrdsub2.contract_id = scpcrd.contract_id and ( "scpcrdsub2"."remind_date" >= '2025-08-01 00:00:00' ) AND ( "scpcrdsub2"."remind_date" <= '2025-08-31 23:59:59' ) ), ( SELECT sum(scpcrdsub3.amount) as before_this_time FROM a57be577deb434.tbl_sales_contract_payment_collection_remind_dates scpcrdsub3 where scpcrdsub3.remind_date <= scpcrd.remind_date and scpcrdsub3.contract_id = scpcrd.contract_id and ( "scpcrdsub3"."remind_date" < '2025-08-01 00:00:00' ) ), case when p.collected is null then 0 else p.collected end as collected, sc.project_id FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON scpcrd.contract_id = sc.id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.from_project = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep WHERE (sc.from_project is not null) AND (p.project_status = 3) AND (("c"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL))) "sub" WHERE (sub.collected < sub.total_this) AND (remind_date <= '2025-08-09') AND ((("sub"."remind_date" >= '2025-08-01 00:00:00') AND ("sub"."remind_date" <= '2025-08-31 23:59:59')) OR ((sub.collected < total_this) AND (CASE WHEN sub.remind_date <= '2025-08-09' THEN (total_this - sub.collected) ELSE 0 END > 0))) GROUP BY "project_id") "sub2"
06:36:26.009traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:26.009traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
06:36:26.010infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-09')
06:36:26.013traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:26.014traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
06:36:26.014infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=5, "last_visit_at"='now()' WHERE "id"=54996
06:36:26.015infoyii\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/analysis/sales-payment-collection-by-times', '[]', '{"code":2000,"result":{"list":[{"id":2549,"contract_id":4075,"remind_date":"2025-08-09","reminded":false,"amount":"222","paid_amount":"0","overdue_days":"","status":0,"total_this":"345","collected":"1","project_id":3927,"uncollected":"222","overdue":"222","status2":0,"invoiced":"0","uninvoiced":"60000","contract":{"id":4075,"key":4075,"project_id":3927,"client_id":3286,"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","bargain_date":"2025-08-05","budget":"60000","collected":"1"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"222","over_due_display":"\u903e\u671f0\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":2548,"contract_id":4075,"remind_date":"2025-08-08","reminded":false,"amount":"123","paid_amount":"0","overdue_days":"","status":0,"total_this":"123","collected":"1","project_id":3927,"uncollected":"122","overdue":"122","status2":0,"invoiced":"0","uninvoiced":"60000","contract":{"id":4075,"key":4075,"project_id":3927,"client_id":3286,"project":{"id":3927,"key":3927,"name":"PA VM\u9632\u706b\u5899\u7ef4\u4fdd\u7eed\u7ea6","bargain_date":"2025-08-05","budget":"60000","collected":"1"},"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"122","over_due_display":"\u903e\u671f1\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":2529,"contract_id":4068,"remind_date":"2025-08-31","reminded":false,"amount":"299","paid_amount":"0","overdue_days":"","status":0,"total_this":"299","collected":"0","project_id":3930,"uncollected":"299","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"299","contract":{"id":4068,"key":4068,"project_id":3930,"client_id":12,"project":{"id":3930,"key":3930,"name":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025","bargain_date":"2025-07-25","budget":"299","collected":"0"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2525,"contract_id":4065,"remind_date":"2025-08-31","reminded":false,"amount":"598","paid_amount":"0","overdue_days":"","status":0,"total_this":"598","collected":"0","project_id":3929,"uncollected":"598","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"598","contract":{"id":4065,"key":4065,"project_id":3929,"client_id":12,"project":{"id":3929,"key":3929,"name":"OTJ25077468-\u56fa\u6001\u786c\u76d8-G-2025","bargain_date":"2025-07-24","budget":"598","collected":"0"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2524,"contract_id":4064,"remind_date":"2025-08-31","reminded":false,"amount":"598","paid_amount":"0","overdue_days":"","status":0,"total_this":"598","collected":"0","project_id":3928,"uncollected":"598","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"598","contract":{"id":4064,"key":4064,"project_id":3928,"client_id":12,"project":{"id":3928,"key":3928,"name":"OTJ25077428-\u56fa\u6001\u786c\u76d8-G-2025","bargain_date":"2025-07-24","budget":"598","collected":"0"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2526,"contract_id":4055,"remind_date":"2025-08-22","reminded":false,"amount":"619710","paid_amount":"0","overdue_days":"","status":0,"total_this":"619710","collected":"0","project_id":3751,"uncollected":"619710","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"885300","contract":{"id":4055,"key":4055,"project_id":3751,"client_id":2553,"project":{"id":3751,"key":3751,"name":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09","bargain_date":"2025-07-21","budget":"885300","collected":"0"},"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2523,"contract_id":4054,"remind_date":"2025-08-31","reminded":false,"amount":"840","paid_amount":"0","overdue_days":"","status":0,"total_this":"840","collected":"0","project_id":3926,"uncollected":"840","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"840","contract":{"id":4054,"key":4054,"project_id":3926,"client_id":3383,"project":{"id":3926,"key":3926,"name":"\u65b0\u8d2d\u4ea4\u6362\u673a\u6a21\u5757\u548c\u7ebf\u7f06","bargain_date":"2025-07-21","budget":"840","collected":"0"},"client":{"id":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2511,"contract_id":4050,"remind_date":"2025-08-29","reminded":false,"amount":"590","paid_amount":"0","overdue_days":"","status":0,"total_this":"590","collected":"0","project_id":3925,"uncollected":"590","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"590","contract":{"id":4050,"key":4050,"project_id":3925,"client_id":12,"project":{"id":3925,"key":3925,"name":"OTJ25076289-\u5185\u5b58\u6761-G-2025","bargain_date":"2025-07-21","budget":"590","collected":"0"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2510,"contract_id":4049,"remind_date":"2025-08-29","reminded":false,"amount":"598","paid_amount":"0","overdue_days":"","status":0,"total_this":"598","collected":"0","project_id":3924,"uncollected":"598","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"598","contract":{"id":4049,"key":4049,"project_id":3924,"client_id":12,"project":{"id":3924,"key":3924,"name":"OTJ25076163-\u56fa\u6001\u786c\u76d8-G-2025","bargain_date":"2025-07-21","budget":"598","collected":"0"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2509,"contract_id":4048,"remind_date":"2025-08-29","reminded":false,"amount":"56862","paid_amount":"0","overdue_days":"","status":0,"total_this":"56862","collected":"0","project_id":3919,"uncollected":"56862","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"56862","contract":{"id":4048,"key":4048,"project_id":3919,"client_id":2182,"project":{"id":3919,"key":3919,"name":"\u8054\u60f3\u7b14\u8bb0\u672c\u7535\u8111-K-2025","bargain_date":"2025-07-18","budget":"56862","collected":"0"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2508,"contract_id":4047,"remind_date":"2025-08-29","reminded":false,"amount":"19427","paid_amount":"0","overdue_days":"","status":0,"total_this":"19427","collected":"0","project_id":3882,"uncollected":"19427","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"19427","contract":{"id":4047,"key":4047,"project_id":3882,"client_id":2182,"project":{"id":3882,"key":3882,"name":"\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-K-2025","bargain_date":"2025-07-18","budget":"19427","collected":"0"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2537,"contract_id":4046,"remind_date":"2025-08-22","reminded":false,"amount":"5900","paid_amount":"5900","overdue_days":"","status":1,"total_this":"5900","collected":"5900","project_id":3917,"uncollected":"0","overdue":"0","status2":2,"invoiced":"0","uninvoiced":"5900","contract":{"id":4046,"key":4046,"project_id":3917,"client_id":2182,"project":{"id":3917,"key":3917,"name":"\u5927\u534e\u76d1\u63a7\u8bbe\u5907\u65b0\u8d2d-K-2025","bargain_date":"2025-07-17","budget":"5900","collected":"5900"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":0,"over_due_display":"","status_display":"\u5df2\u5b8c\u6210"},{"id":2541,"contract_id":4044,"remind_date":"2025-08-15","reminded":false,"amount":"15000","paid_amount":"15000","overdue_days":"","status":1,"total_this":"15000","collected":"15000","project_id":3883,"uncollected":"0","overdue":"0","status2":2,"invoiced":"0","uninvoiced":"50000","contract":{"id":4044,"key":4044,"project_id":3883,"client_id":2182,"project":{"id":3883,"key":3883,"name":"\u673a\u623f\u642c\u8fc1-K-2025","bargain_date":"2025-07-17","budget":"50000","collected":"15000"},"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":0,"over_due_display":"","status_display":"\u5df2\u5b8c\u6210"},{"id":2504,"contract_id":4043,"remind_date":"2025-08-22","reminded":false,"amount":"295","paid_amount":"0","overdue_days":"","status":0,"total_this":"295","collected":"0","project_id":3920,"uncollected":"295","overdue":"0","status2":1,"invoiced":"0","uninvoiced":"295","contract":{"id":4043,"key":4043,"project_id":3920,"client_id":12,"project":{"id":3920,"key":3920,"name":"OTJ25075740-\u5185\u5b58-2025","bargain_date":"2025-07-17","budget":"295","collected":"0"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":"0","over_due_display":"","status_display":"\u672a\u5b8c\u6210"},{"id":2503,"contract_id":4036,"remind_date":"2025-08-22","reminded":true,"amount":"598","paid_amount":"598","overdue_days":"","status":1,"total_this":"598","collected":"598","project_id":3918,"uncollected":"0","overdue":"0","status2":2,"invoiced":"598.00","uninvoiced":"0.00","contract":{"id":4036,"key":4036,"project_id":3918,"client_id":12,"project":{"id":3918,"key":3918,"name":"POTJ25074907-\u56fa\u6001\u786c\u76d8-2025","bargain_date":"2025-07-15","budget":"598","collected":"598"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":0,"over_due_display":"","status_display":"\u5df2\u5b8c\u6210"},{"id":2518,"contract_id":4029,"remind_date":"2025-08-01","reminded":false,"amount":"1500","paid_amount":"0","overdue_days":"","status":0,"total_this":"1500","collected":"0","project_id":3916,"uncollected":"1500","overdue":"1500","status2":0,"invoiced":"0","uninvoiced":"1500","contract":{"id":4029,"key":4029,"project_id":3916,"client_id":3383,"project":{"id":3916,"key":3916,"name":"\u65b0\u8d2dHP\u5b58\u50a8\u786c\u76d8","bargain_date":"2025-07-14","budget":"1500","collected":"0"},"client":{"id":3383,"key":3383,"name":"\u5317\u4eac\u601d\u8054\u79d1\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8-\u9b4f\u6cfd\u6587\uff08\u8fc7\u5355\uff09"}},"over_due_uncollected":"1500","over_due_display":"\u903e\u671f8\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":2498,"contract_id":4026,"remind_date":"2025-08-08","reminded":false,"amount":"128800","paid_amount":"0","overdue_days":"","status":0,"total_this":"128800","collected":"0","project_id":3906,"uncollected":"128800","overdue":"128800","status2":0,"invoiced":"0","uninvoiced":"184000","contract":{"id":4026,"key":4026,"project_id":3906,"client_id":3378,"project":{"id":3906,"key":3906,"name":"\u601d\u79d1N9K\u7eed\u4fdd\u9879\u76ee","bargain_date":"2025-07-11","budget":"184000","collected":"0"},"client":{"id":3378,"key":3378,"name":"\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"over_due_uncollected":"128800","over_due_display":"\u903e\u671f1\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":2492,"contract_id":4024,"remind_date":"2025-07-25","reminded":true,"amount":"2102786","paid_amount":"0","overdue_days":"","status":0,"total_this":"2102786","collected":"0","project_id":3910,"uncollected":"2102786","overdue":"2102786","status2":0,"invoiced":"2102786.00","uninvoiced":"901194.00","contract":{"id":4024,"key":4024,"project_id":3910,"client_id":2762,"project":{"id":3910,"key":3910,"name":"33\u6240\u9ad8\u6027\u80fd\u9879\u76ee","bargain_date":"2025-07-11","budget":"3003980","collected":"0"},"client":{"id":2762,"key":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"}},"over_due_uncollected":"2102786","over_due_display":"\u903e\u671f15\u5929","status_display":"\u672a\u5b8c\u6210"},{"id":2491,"contract_id":4022,"remind_date":"2025-08-21","reminded":true,"amount":"299","paid_amount":"299","overdue_days":"","status":1,"total_this":"299","collected":"299","project_id":3913,"uncollected":"0","overdue":"0","status2":2,"invoiced":"299.00","uninvoiced":"0.00","contract":{"id":4022,"key":4022,"project_id":3913,"client_id":12,"project":{"id":3913,"key":3913,"name":"POTJ25073432-\u56fa\u6001\u786c\u76d8-2025","bargain_date":"2025-07-10","budget":"299","collected":"299"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":0,"over_due_display":"","status_display":"\u5df2\u5b8c\u6210"},{"id":2490,"contract_id":4021,"remind_date":"2025-08-21","reminded":true,"amount":"594","paid_amount":"594","overdue_days":"","status":1,"total_this":"594","collected":"594","project_id":3912,"uncollected":"0","overdue":"0","status2":2,"invoiced":"594.00","uninvoiced":"0.00","contract":{"id":4021,"key":4021,"project_id":3912,"client_id":12,"project":{"id":3912,"key":3912,"name":"OTJ25072858-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","bargain_date":"2025-07-10","budget":"594","collected":"594"},"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"}},"over_due_uncollected":0,"over_due_display":"","status_display":"\u5df2\u5b8c\u6210"}],"count":{"budget":"14680760.2","uncollected":"1455306","collected":13225454.2,"overdue":"6769913.76"},"pagenation":{"totalcount":47,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-09 06:36:26') RETURNING "id"
06:36:26.017traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
06:36:26.018traceyii\redis\Connection::executeCommandExecuting Redis Command: SET