[{"_1":2,"_184":-5,"_185":-5},"loaderData",{"_3":4,"_95":96},"root",{"_5":6,"_36":37,"_68":69},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65,"_66":67},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","a94d33e5af9ddf2aabaf9f7bc53c11a8e3ce6ad2","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","API_URL","https://api.val.town","clerkState",{"_70":71},"__internal_clerk_state",{"_72":73,"_74":47,"_75":76,"_77":76,"_78":20,"_79":76,"_80":76,"_81":76,"_82":76,"_83":84,"_93":20,"_94":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_85":20,"_19":20,"_86":76,"_87":88,"_89":76,"_90":47,"_91":20,"_92":76},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_97":98,"_99":100,"_101":102,"_103":104,"_157":158,"_180":181,"_182":183},"handle","v7er","name","mmo","path","src-tauri/src/commands/metrics.rs","project",{"_105":106,"_99":100,"_107":108,"_109":-5,"_110":20,"_111":112,"_113":-5,"_114":-5,"_12":115,"_116":-5,"_117":20,"_118":-5,"_119":-5,"_120":33,"_14":121,"_122":-5,"_123":-5,"_124":-5,"_125":-5,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":135,"_138":139,"_143":144,"_156":20},"id","ec02899a-3155-11f1-86bb-42dde27851f2","createdAt",["D",1775438052675],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","019d5bac-65a2-765b-bf0e-efaa6646838f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019d5bac-65a2-765b-bf0e-f380c1f143d2","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_97":98,"_136":137},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQnZCOXM2WDI0VTloakRTNmlXQzVDbFRxT0YifQ","org",{"_97":98,"_140":137,"_12":115,"_141":142},"avatar","tier","free","branch",{"_145":146,"_99":45,"_105":147,"_148":106,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":100,"_155":98},"version",39,"ec034a42-3155-11f1-86bb-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_105":159,"_99":160,"_161":162,"_163":164,"_165":147,"_166":167,"_168":169,"_107":170,"_145":33,"_171":157,"_172":173,"_174":20,"_175":-5,"_101":176},"e1340330-3156-11f1-9205-42dde27851f2","metrics.rs","fileId","e13403ee-3156-11f1-9205-42dde27851f2","parentId","73e2db9d-be5b-4e72-8cdf-6e7755e14430","branchId","branchVersion",17,"latest",true,["D",1775438464034],"fileType","content","use tauri::State;\nuse uuid::Uuid;\nuse crate::{AppState, models::{Metric, DashboardStats, PlatformStat, TeamStat}};\n\n#[tauri::command]\npub async fn record_metric(\n account_id: String,\n date: String,\n platform: String,\n new_posts: Option,\n new_likes: Option,\n new_reacts: Option,\n new_comments: Option,\n new_friends: Option,\n new_followers: Option,\n profile_views: Option,\n reach: Option,\n comments_made: Option,\n friend_requests_sent: Option,\n messages_sent: Option,\n notes: Option,\n state: State<'_, AppState>,\n) -> Result {\n let db = state.db.lock().await;\n let id = Uuid::new_v4().to_string();\n let np = new_posts.unwrap_or(0);\n let nl = new_likes.unwrap_or(0);\n let nr = new_reacts.unwrap_or(0);\n let nc = new_comments.unwrap_or(0);\n let nf = new_friends.unwrap_or(0);\n let nfo = new_followers.unwrap_or(0);\n let pv = profile_views.unwrap_or(0);\n let rc = reach.unwrap_or(0);\n let cm = comments_made.unwrap_or(0);\n let frs = friend_requests_sent.unwrap_or(0);\n let ms = messages_sent.unwrap_or(0);\n let nt = notes.unwrap_or_default();\n\n db.conn.execute(\n \"INSERT INTO metrics (id, account_id, date, platform, new_posts, new_likes, new_reacts, new_comments, new_friends, new_followers, profile_views, reach, comments_made, friend_requests_sent, messages_sent, notes)\n VALUES (?1,?2,?3,?4,?5,?6,?7,?8,?9,?10,?11,?12,?13,?14,?15,?16)\n ON CONFLICT(account_id, date) DO UPDATE SET\n new_posts = new_posts + excluded.new_posts,\n new_likes = new_likes + excluded.new_likes,\n new_reacts = new_reacts + excluded.new_reacts,\n new_comments = new_comments + excluded.new_comments,\n new_friends = new_friends + excluded.new_friends,\n new_followers = new_followers + excluded.new_followers,\n profile_views = profile_views + excluded.profile_views,\n reach = reach + excluded.reach,\n comments_made = comments_made + excluded.comments_made,\n friend_requests_sent = friend_requests_sent + excluded.friend_requests_sent,\n messages_sent = messages_sent + excluded.messages_sent,\n notes = excluded.notes\",\n rusqlite::params![id, account_id, date, platform, np, nl, nr, nc, nf, nfo, pv, rc, cm, frs, ms, nt],\n ).map_err(|e| e.to_string())?;\n\n Ok(Metric {\n id, account_id, date, platform,\n new_posts: np, new_likes: nl, new_reacts: nr, new_comments: nc,\n new_friends: nf, new_followers: nfo, profile_views: pv, reach: rc,\n comments_made: cm, friend_requests_sent: frs, messages_sent: ms,\n notes: nt, created_at: chrono::Local::now().to_rfc3339(),\n })\n}\n\n#[tauri::command]\npub async fn get_metrics(\n account_id: Option,\n date_from: Option,\n date_to: Option,\n state: State<'_, AppState>,\n) -> Result, String> {\n let db = state.db.lock().await;\n let mut sql = \"SELECT id, account_id, date, platform, new_posts, new_likes, new_reacts, new_comments, new_friends, new_followers, profile_views, reach, comments_made, friend_requests_sent, messages_sent, notes, created_at FROM metrics WHERE 1=1\".to_string();\n let mut params_vec: Vec> = vec![];\n\n if let Some(aid) = account_id {\n sql.push_str(\" AND account_id = ?\");\n params_vec.push(Box::new(aid));\n }\n if let Some(df) = date_from {\n sql.push_str(\" AND date >= ?\");\n params_vec.push(Box::new(df));\n }\n if let Some(dt) = date_to {\n sql.push_str(\" AND date <= ?\");\n params_vec.push(Box::new(dt));\n }\n sql.push_str(\" ORDER BY date DESC, account_id LIMIT 500\");\n\n let mut stmt = db.conn.prepare(&sql).map_err(|e| e.to_string())?;\n let param_refs: Vec<&dyn rusqlite::ToSql> = params_vec.iter().map(|p| p.as_ref()).collect();\n\n let metrics = stmt.query_map(param_refs.as_slice(), |row| {\n Ok(Metric {\n id: row.get(0)?, account_id: row.get(1)?, date: row.get(2)?,\n platform: row.get(3)?, new_posts: row.get(4)?, new_likes: row.get(5)?,\n new_reacts: row.get(6)?, new_comments: row.get(7)?, new_friends: row.get(8)?,\n new_followers: row.get(9)?, profile_views: row.get(10)?, reach: row.get(11)?,\n comments_made: row.get(12)?, friend_requests_sent: row.get(13)?,\n messages_sent: row.get(14)?, notes: row.get(15)?, created_at: row.get(16)?,\n })\n }).map_err(|e| e.to_string())?\n .collect::, _>>()\n .map_err(|e| e.to_string())?;\n Ok(metrics)\n}\n\n#[tauri::command]\npub async fn get_metric_history(\n account_id: String,\n days: Option,\n state: State<'_, AppState>,\n) -> Result, String> {\n let db = state.db.lock().await;\n let d = days.unwrap_or(30);\n let mut stmt = db.conn.prepare(\n \"SELECT id, account_id, date, platform, new_posts, new_likes, new_reacts, new_comments, new_friends, new_followers, profile_views, reach, comments_made, friend_requests_sent, messages_sent, notes, created_at\n FROM metrics WHERE account_id = ?1 AND date >= date('now', ?2) ORDER BY date ASC\"\n ).map_err(|e| e.to_string())?;\n let offset = format!(\"-{} days\", d);\n let metrics = stmt.query_map(rusqlite::params![account_id, offset], |row| {\n Ok(Metric {\n id: row.get(0)?, account_id: row.get(1)?, date: row.get(2)?,\n platform: row.get(3)?, new_posts: row.get(4)?, new_likes: row.get(5)?,\n new_reacts: row.get(6)?, new_comments: row.get(7)?, new_friends: row.get(8)?,\n new_followers: row.get(9)?, profile_views: row.get(10)?, reach: row.get(11)?,\n comments_made: row.get(12)?, friend_requests_sent: row.get(13)?,\n messages_sent: row.get(14)?, notes: row.get(15)?, created_at: row.get(16)?,\n })\n }).map_err(|e| e.to_string())?\n .collect::, _>>()\n .map_err(|e| e.to_string())?;\n Ok(metrics)\n}\n\n#[tauri::command]\npub async fn get_dashboard_stats(state: State<'_, AppState>) -> Result {\n let db = state.db.lock().await;\n let today = chrono::Local::now().format(\"%Y-%m-%d\").to_string();\n\n let total_accounts: i64 = db.conn.query_row(\"SELECT COUNT(*) FROM accounts\", [], |r| r.get(0)).unwrap_or(0);\n let active_accounts: i64 = db.conn.query_row(\"SELECT COUNT(*) FROM accounts WHERE status = 'active'\", [], |r| r.get(0)).unwrap_or(0);\n let total_posts_today: i64 = db.conn.query_row(\"SELECT COALESCE(SUM(new_posts),0) FROM metrics WHERE date = ?1\", rusqlite::params![today], |r| r.get(0)).unwrap_or(0);\n let total_activities_today: i64 = db.conn.query_row(\"SELECT COUNT(*) FROM activities WHERE date(done_at) = ?1\", rusqlite::params![today], |r| r.get(0)).unwrap_or(0);\n let total_new_friends_today: i64 = db.conn.query_row(\"SELECT COALESCE(SUM(new_friends),0) FROM metrics WHERE date = ?1\", rusqlite::params![today], |r| r.get(0)).unwrap_or(0);\n let total_new_followers_today: i64 = db.conn.query_row(\"SELECT COALESCE(SUM(new_followers),0) FROM metrics WHERE date = ?1\", rusqlite::params![today], |r| r.get(0)).unwrap_or(0);\n let total_comments_today: i64 = db.conn.query_row(\"SELECT COALESCE(SUM(comments_made),0) FROM metrics WHERE date = ?1\", rusqlite::params![today], |r| r.get(0)).unwrap_or(0);\n let total_likes_today: i64 = db.conn.query_row(\"SELECT COALESCE(SUM(new_likes),0) FROM metrics WHERE date = ?1\", rusqlite::params![today], |r| r.get(0)).unwrap_or(0);\n\n // Platform breakdown\n let mut stmt = db.conn.prepare(\n \"SELECT a.platform, COUNT(a.id), COALESCE(SUM(m.new_posts),0), COALESCE(SUM(m.new_likes),0)\n FROM accounts a LEFT JOIN metrics m ON a.id = m.account_id AND m.date = ?1\n GROUP BY a.platform\"\n ).map_err(|e| e.to_string())?;\n let platform_breakdown = stmt.query_map(rusqlite::params![today], |row| {\n Ok(PlatformStat {\n platform: row.get(0)?,\n count: row.get(1)?,\n posts_today: row.get(2)?,\n likes_today: row.get(3)?,\n })\n }).map_err(|e| e.to_string())?\n .collect::, _>>()\n .map_err(|e| e.to_string())?;\n\n // Team breakdown\n let mut stmt2 = db.conn.prepare(\n \"SELECT t.id, t.name, COUNT(a.id), COALESCE(SUM(m.new_posts),0)\n FROM teams t LEFT JOIN accounts a ON a.team_id = t.id\n LEFT JOIN metrics m ON a.id = m.account_id AND m.date = ?1\n GROUP BY t.id ORDER BY COUNT(a.id) DESC\"\n ).map_err(|e| e.to_string())?;\n let team_breakdown = stmt2.query_map(rusqlite::params![today], |row| {\n Ok(TeamStat {\n team_id: row.get(0)?,\n team_name: row.get(1)?,\n account_count: row.get(2)?,\n posts_today: row.get(3)?,\n })\n }).map_err(|e| e.to_string())?\n .collect::, _>>()\n .map_err(|e| e.to_string())?;\n\n Ok(DashboardStats {\n total_accounts, active_accounts,\n total_posts_today, total_activities_today,\n total_new_friends_today, total_new_followers_today,\n total_comments_today, total_likes_today,\n platform_breakdown, team_breakdown,\n })\n}\n","deleted","label",[177,178,179,160],"src-tauri","src","commands","permalink","https://www.val.town/x/v7er/mmo/code/src-tauri/src/commands/metrics.rs","extension","rs","actionData","errors"]