ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68906543a1a96: POST https://beta.jinchangxiao.com/vue/analysis/sales-status-counts at 2025-08-04 03:46:11 pm by 124.64.23.198

Log Messages

总计59条数据
TimeLevelCategoryMessage
 
15:46:11.659traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:46:11.659traceyii\base\Module::getModuleLoading module: debug
15:46:11.660traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:46:11.662traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:46:11.662traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:46:11.663traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.663traceyii\base\Module::getModuleLoading module: gii
15:46:11.663traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:46:11.663traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:46:11.663traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-status-counts'
15:46:11.663traceyii\base\Module::getModuleLoading module: vue
15:46:11.874infoyii\web\Session::openSession started
15:46:11.875infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
15:46:11.875infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:46:11.881traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.881traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:46:11.882traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.882traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:46:11.882infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
15:46:11.885traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-status-counts
15:46:11.885traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.888traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:46:11.888traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesStatusCounts()
15:46:11.901infoyii\db\Command::querySELECT sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then 1 else 0 end) count1new, sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then p.budget else 0 end) count1newsum, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then 1 else 0 end) count1in, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then p.budget else 0 end) count1insum, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then 1 else 0 end) count1out, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then p.budget else 0 end) count1outsum, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then 1 else 0 end) count2new, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then p.budget else 0 end) count2newsum, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then 1 else 0 end) count2in, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then p.budget else 0 end) count2insum, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then 1 else 0 end) count2out, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then p.budget else 0 end) count2outsum, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then 1 else 0 end) count3new, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then p.budget else 0 end) count3newsum, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then 1 else 0 end) count3in, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then p.budget else 0 end) count3insum, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then 1 else 0 end) count3out, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then p.budget else 0 end) count3outsum, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then 1 else 0 end) count4new, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then p.budget else 0 end) count4newsum, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then 1 else 0 end) count4in, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then p.budget else 0 end) count4insum, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then 1 else 0 end) count4out, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then p.budget else 0 end) count4outsum, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then 1 else 0 end) count5new, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then p.budget else 0 end) count5newsum, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then 1 else 0 end) count5in, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then p.budget else 0 end) count5insum, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then 1 else 0 end) count5out, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then p.budget else 0 end) count5outsum, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then 1 else 0 end) count0new, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then p.budget else 0 end) count0newsum, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then 1 else 0 end) count0in, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then p.budget else 0 end) count0insum, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then 1 else 0 end) count0out, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then p.budget else 0 end) count0outsum FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT min(subpsl.id) AS min_id, max(subpsl.id) AS max_id, project_id FROM "a57be577deb434"."tbl_project_status_logs" "subpsl" WHERE subpsl.created_at >= '2025-08-04 00:00:00' AND subpsl.created_at < timestamp '2025-08-04 23:59:59' + interval '1 second' GROUP BY "subpsl"."project_id") "sub" ON sub.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "minpsl" ON sub.min_id = minpsl.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "maxpsl" ON sub.max_id = maxpsl.id WHERE ("p"."created_by" IN ('1004', '1005', '1013', '5087')) AND (sub.min_id is not null and sub.max_id is not null)
15:46:11.908traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.909traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.910infoyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (daterange(start_from::date, end_at::date, '[)') && '[2025-08-04 00:00:00, 2025-08-04 23:59:59]'::daterange) AND ("user_id" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
15:46:11.912traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:11.912infoyii\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_user_role_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:46:11.916infoyii\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_user_role_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:46:11.927traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:46:11.927traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
15:46:11.927infoyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2025-08-04 00:00:00') AND ("bargain_date" <= '2025-08-04 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) GROUP BY "created_by"
15:46:11.928infoyii\db\Command::querySELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-08-04 00:00:00') AND (start_at < timestamp '2025-08-04 23:59:59' + interval '1 second') AND ("w"."created_by" IN ('1004', '1005', '1013', '5087')) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)
15:46:11.934infoyii\db\Command::querySELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-08-04 00:00:00') AND (start_at < timestamp '2025-08-04 23:59:59' + interval '1 second') AND ("w"."created_by" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)
15:46:11.946infoyii\db\Command::querySELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1004', '1005', '1013', '5087')) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-04 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1004', '1005', '1013', '5087')) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-04 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"
15:46:11.961infoyii\db\Command::querySELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-04 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-04 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"
15:46:11.964infoyii\db\Command::querySELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1004', '1005', '1013', '5087')) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-04 23:59:59') AND ("ir"."is_draft"=FALSE)
15:46:11.966infoyii\db\Command::querySELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-04 23:59:59') AND ("ir"."is_draft"=FALSE)
15:46:11.967infoyii\db\Command::querySELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1004', '1005', '1013', '5087')) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-04 23:59:59') AND ("ps"."is_draft"=FALSE)
15:46:11.968infoyii\db\Command::querySELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-04 23:59:59') AND ("ps"."is_draft"=FALSE)
15:46:11.970infoyii\db\Command::querySELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from" IN ('1004', '1005', '1013', '5087')) AND ("c"."closed_at" >= '2025-08-04 00:00:00') AND ("c"."closed_at" <= '2025-08-04 23:59:59')
15:46:11.973infoyii\db\Command::querySELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("c"."closed_at" >= '2025-08-04 00:00:00') AND ("c"."closed_at" <= '2025-08-04 23:59:59')
15:46:11.975infoyii\db\Command::querySELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of" IN ('1004', '1005', '1013', '5087')) AND ("otc"."complete_at" >= '2025-08-04 00:00:00') AND ("otc"."complete_at" <= '2025-08-04 23:59:59')
15:46:11.980infoyii\db\Command::querySELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("otc"."complete_at" >= '2025-08-04 00:00:00') AND ("otc"."complete_at" <= '2025-08-04 23:59:59')
15:46:11.981infoyii\db\Command::querySELECT w.scenario_option_id as key, wso.name, count(w.id) as value FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND ("w"."created_by" IN ('1004', '1005', '1013', '5087')) AND (("w"."start_at" >= '2025-08-04 00:00:00') AND ("w"."start_at" <= '2025-08-04 23:59:59')) GROUP BY "w"."scenario_option_id", "wso"."name"
15:46:11.985infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND ("w"."created_by" IN ('1004', '1005', '1013', '5087')) AND (("w"."start_at" >= '2025-08-04 00:00:00') AND ("w"."start_at" <= '2025-08-04 23:59:59'))
15:46:11.987infoyii\db\Command::querySELECT sub.status, count(sub.id) as value FROM (SELECT id, created_by, CASE WHEN complete_at IS NOT NULL THEN complete_at ELSE end_at END as day_at, CASE WHEN is_complete = TRUE THEN 1 WHEN ( ( ( "is_complete" = FALSE ) AND ( "end_at" < '2025-08-04 15:46:11' ) ) ) THEN 2 ELSE 0 END as status FROM "a57be577deb434"."tbl_schedules" WHERE "is_public"=1) "sub" WHERE ("sub"."created_by" IN ('1004', '1005', '1013', '5087')) AND ("sub"."status" IN (0, 2)) GROUP BY "sub"."status"
15:46:12.198infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by" IN ('1004', '1005', '1013', '5087')) AND ("is_public"=1) AND ("is_complete"=FALSE)
15:46:12.201infoyii\db\Command::querySELECT sub.project_status as key, count('sub.id') as projects FROM (SELECT p.id, p.project_status FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."created_by" IN ('1004', '1005', '1013', '5087')) AND (project_status != 1) AND ("p"."bargain_date" >= '2025-08-04 00:00:00') AND ("p"."bargain_date" <= '2025-08-04 23:59:59')) "sub" GROUP BY "sub"."project_status"
15:46:12.204traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:12.205traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:46:12.205infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-08-04')
15:46:12.219traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:12.219traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:46:12.219infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=6, "last_visit_at"='now()' WHERE "id"=54932
15:46:12.222infoyii\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/sales-status-counts', '{"period":"today","dataUserId":"1004,1005,1013,5087","GroupId":"80","alert":"false","web_access_token":"whZjM8ZfyqxulYW-_i5kn1yK2K5nH7iz"}', '{"code":2000,"result":{"statusCounts":[{"id":"1","key":"\u9690\u6027\u9700\u6c42","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"2","key":"\u660e\u786e\u9700\u6c42","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"3","key":"\u5546\u673a\u6210\u4ea4","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"0","key":"\u6536\u6b3e\u5b8c\u6210","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"4","key":"\u5546\u673a\u5931\u8d25","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"5","key":"\u5546\u673a\u6401\u7f6e","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}}],"workCount":{"workTimeList":{"sum":0,"avg":0},"clientVisitList":{"sum":0,"avg":0},"engineerSpentList":{"sum":0,"avg":0},"implementTimes":{"sum":0,"avg":0},"preSalesTimes":{"sum":0,"avg":0},"deductedPoint":{"sum":0,"avg":0},"operationDatas":{"sum":0,"avg":0}},"chart":{"salesTimes":[],"salesTimesCounts":0,"schedules":[{"status":0,"value":77,"name":"\u8fdb\u884c\u4e2d","y":58.78},{"status":2,"value":54,"name":"\u5df2\u903e\u671f","y":41.22}],"schedulesCounts":131,"statusCounts":[],"projectCounts":0}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-04 15:46:12') RETURNING "id"
15:46:12.224traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:46:12.224traceyii\redis\Connection::executeCommandExecuting Redis Command: SET