ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6877459b688c1: POST https://beta.jinchangxiao.com/vue/dashboard/sales-rep-score at 2025-07-16 02:24:27 pm by 124.127.56.185

Log Messages

总计38条数据
TimeLevelCategoryMessage
 
14:24:27.427traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:24:27.427traceyii\base\Module::getModuleLoading module: debug
14:24:27.428traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:24:27.428traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:24:27.428traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:24:27.428traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.428traceyii\base\Module::getModuleLoading module: gii
14:24:27.429traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:24:27.429traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:24:27.429traceyii\web\Application::handleRequestRoute requested: 'vue/dashboard/sales-rep-score'
14:24:27.429traceyii\base\Module::getModuleLoading module: vue
14:24:27.429infoyii\web\Session::openSession started
14:24:27.430infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:24:27.430infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:24:27.438traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.438traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:24:27.439traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.439traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:24:27.439infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:24:27.441traceyii\base\Controller::runActionRoute to run: vue/dashboard/sales-rep-score
14:24:27.441traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\DashboardController::actionSalesRepScore()
14:24:27.441infoyii\db\Command::querySELECT u.id, name, srsb.*, budget_count, profit_count, bargain_count, opportunity_budget_count, opportunity_count, (CASE WHEN srsb.budget_base > 0 THEN floor(u.budget_count * 10 / srsb.budget_base) ELSE 0 END) as budget_score, (CASE WHEN srsb.profit_base > 0 THEN floor(u.profit_count * 10 / srsb.profit_base) ELSE 0 END) as profit_score, (CASE WHEN srsb.bargain_base > 0 THEN floor(u.bargain_count * 10 / srsb.bargain_base) ELSE 0 END) as bargain_score, (CASE WHEN srsb.opportunity_budget_base > 0 THEN floor(u.opportunity_budget_count * 10 / srsb.opportunity_budget_base) ELSE 0 END) as opportunity_budget_score, (CASE WHEN srsb.opportunity_base > 0 THEN floor(u.opportunity_count * 10 / srsb.opportunity_base) ELSE 0 END) as opportunity_score, work_log_score, ( (CASE WHEN srsb.budget_base > 0 THEN floor(u.budget_count * 10 / srsb.budget_base) ELSE 0 END) + (CASE WHEN srsb.profit_base > 0 THEN floor(u.profit_count * 10 / srsb.profit_base) ELSE 0 END) + (CASE WHEN srsb.bargain_base > 0 THEN floor(u.bargain_count * 10 / srsb.bargain_base) ELSE 0 END) + (CASE WHEN srsb.opportunity_budget_base > 0 THEN floor(u.opportunity_budget_count * 10 / srsb.opportunity_budget_base) ELSE 0 END) + (CASE WHEN srsb.opportunity_base > 0 THEN floor(u.opportunity_count * 10 / srsb.opportunity_base) ELSE 0 END) + work_log_score ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_sales_rep_score_bases" "srsb" ON 1 = 1 WHERE ("u"."user_status"=1) AND ("u"."id"=1001) AND ("aa"."item_name"='AccountManager') GROUP BY "u"."id", "srsb"."id"
14:24:27.445traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.448traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.449infoyii\db\Command::querySELECT max(sub.count) as count, scenario_option_id FROM (SELECT count(w.id) as count, scenario_option_id FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON w.created_by = u.id WHERE ("u"."user_status"=1) AND ("w"."scenario_id"=1) AND ("w"."is_draft"=FALSE) AND ("w"."is_draft" IS NOT NULL) AND ("w"."created_at" >= '2025-01-01 00:00:00') AND ("w"."created_at" <= '2025-12-31 23:59:59') GROUP BY "created_by", "scenario_option_id") "sub" GROUP BY "scenario_option_id"
14:24:27.463infoyii\db\Command::querySELECT wso.*, count(sub.id) as count FROM "a57be577deb434"."tbl_work_log_scenario_options" "wso" LEFT JOIN (SELECT "w".* FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON w.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id WHERE ("w"."scenario_id"=1) AND ("w"."is_draft"=FALSE) AND ("w"."is_draft" IS NOT NULL) AND ("w"."created_at" >= '2025-01-01 00:00:00') AND ("w"."created_at" <= '2025-12-31 23:59:59') AND ("u"."user_status"=1) AND ("aa"."item_name"='AccountManager')) "sub" ON sub.scenario_option_id = wso.id WHERE "work_log_scenario_id"=1 GROUP BY "wso"."id" ORDER BY "count" DESC, "sort" LIMIT 10
14:24:27.700traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.701infoyii\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_work_log_scenario_options' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
14:24:27.705infoyii\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_work_log_scenario_options' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
14:24:27.715traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:24:27.715traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
14:24:27.715infoyii\db\Command::querySELECT count(w.id) as count, scenario_option_id FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON w.created_by = u.id WHERE ("u"."user_status"=1) AND ("w"."scenario_id"=1) AND ("w"."is_draft"=FALSE) AND ("w"."is_draft" IS NOT NULL) AND ("w"."created_by"=1001) AND ("w"."created_at" >= '2025-01-01 00:00:00') AND ("w"."created_at" <= '2025-12-31 23:59:59') GROUP BY "scenario_option_id"
14:24:27.716infoyii\db\Command::querySELECT avg( (CASE WHEN srsb.budget_base > 0 THEN floor(u.budget_count * 10 / srsb.budget_base) ELSE 0 END) + (CASE WHEN srsb.profit_base > 0 THEN floor(u.profit_count * 10 / srsb.profit_base) ELSE 0 END) + (CASE WHEN srsb.bargain_base > 0 THEN floor(u.bargain_count * 10 / srsb.bargain_base) ELSE 0 END) + (CASE WHEN srsb.opportunity_budget_base > 0 THEN floor(u.opportunity_budget_count * 10 / srsb.opportunity_budget_base) ELSE 0 END) + (CASE WHEN srsb.opportunity_base > 0 THEN floor(u.opportunity_count * 10 / srsb.opportunity_base) ELSE 0 END) + work_log_score ) as score FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id LEFT JOIN "a57be577deb434"."tbl_sales_rep_score_bases" "srsb" ON 1 = 1 WHERE ("u"."user_status"=1) AND ("aa"."item_name"='AccountManager')
14:24:27.718traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.718traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:24:27.718infoyii\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/dashboard/sales-rep-score', '{"web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"name":"\u5218\u4eba\u8bda","score":"15","work_score":0,"avg_score":17,"items":[{"key":"budget_info","title":"\u672c\u8d22\u5e74\u6210\u4ea4\u6d41\u6c34","base_score":"10","score":"10","pct":100,"count":"3413455","base":"3413455","display":"\u8fbe\u6807"},{"key":"profit_info","title":"\u672c\u8d22\u5e74\u6210\u4ea4\u5229\u6da6","base_score":"10","score":0,"pct":9,"count":17143.95,"base":182130.5,"display":"\u672a\u8fbe\u6807"},{"key":"bargain_info","title":"\u672c\u8d22\u5e74\u6210\u4ea4\u6b21\u6570","base_score":"10","score":"3","pct":33,"count":"4","base":"12","display":"\u672a\u8fbe\u6807"},{"key":"opportunity_budget_info","title":"\u5f53\u524d\u660e\u786e\u9700\u6c42\u91d1\u989d","base_score":"10","score":0,"pct":3,"count":"409324.06","base":"11290000","display":"\u672a\u8fbe\u6807"},{"key":"opportunity_info","title":"\u5f53\u524d\u660e\u786e\u9700\u6c42\u6570\u91cf","base_score":"10","score":"2","pct":28,"count":"2","base":"7","display":"\u672a\u8fbe\u6807"}],"workCounts":[{"key":"scenario_option_72","title":"\u6316\u6398\u5546\u673a","base_score":5,"score":0,"pct":0,"count":0,"base":123,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_66","title":"\u5ba2\u60c5\u589e\u8fdb","base_score":5,"score":0,"pct":0,"count":0,"base":60,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_67","title":"\u5546\u673a\u63a8\u52a8","base_score":5,"score":0,"pct":0,"count":0,"base":60,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_73","title":"\u552e\u540e\u670d\u52a1","base_score":5,"score":0,"pct":0,"count":0,"base":20,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_69","title":"\u5382\u5546\u5408\u4f5c","base_score":5,"score":0,"pct":0,"count":0,"base":6,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_71","title":"\u62dc\u8bbf\u5ba2\u6237","base_score":5,"score":0,"pct":0,"count":0,"base":3,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_70","title":"\u4ea7\u54c1\u57f9\u8bad","base_score":5,"score":0,"pct":0,"count":0,"base":3,"display":"\u672a\u8fbe\u6807"},{"key":"scenario_option_2","title":"\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a","base_score":5,"score":0,"pct":0,"count":0,"base":0,"display":"\u8fbe\u6807"},{"key":"scenario_option_62","title":"\u5ba2\u6237\u5fae\u4fe1","base_score":5,"score":0,"pct":0,"count":0,"base":0,"display":"\u8fbe\u6807"},{"key":"scenario_option_3","title":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a","base_score":5,"score":0,"pct":0,"count":0,"base":0,"display":"\u8fbe\u6807"}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-16 14:24:27') RETURNING "id"
14:24:27.719traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:24:27.720traceyii\redis\Connection::executeCommandExecuting Redis Command: SET