Carregando...

\n );\n }\n\n return (\n

\n {user ? (\n \n ) : (\n \n )}\n

\n );\n}",[],[289,296,303],{"_103":310,"_95":311,"_152":312,"_154":297,"_155":137,"_156":313,"_158":159,"_105":314,"_100":32,"_161":181,"_163":315,"_164":22,"_165":-5,"_166":316,"_98":317},"b9192046-8e96-11f0-939a-0224a6c84d84","AuthForm.tsx","b9192104-8e96-11f0-939a-0224a6c84d84",14,["D",1757543845002],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User, AuthResponse } from \"../../shared/types.ts\";\n\ninterface AuthFormProps {\n onLogin: (user: User, token: string) => void;\n}\n\nexport default function AuthForm({ onLogin }: AuthFormProps) {\n const [isLogin, setIsLogin] = useState(true);\n const [email, setEmail] = useState('');\n const [password, setPassword] = useState('');\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState('');\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n try {\n const endpoint = isLogin ? '/api/auth/login' : '/api/auth/register';\n const response = await fetch(endpoint, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({ email, password }),\n });\n\n const data: AuthResponse = await response.json();\n\n if (data.success && data.user && data.token) {\n onLogin(data.user, data.token);\n } else {\n setError(data.message || 'Erro desconhecido');\n }\n } catch (error) {\n setError('Erro de conexão');\n }\n\n setLoading(false);\n };\n\n return (\n

\n 🔍 Monitor de Palavras-chave\n

\n {isLogin ? 'Entre na sua conta' : 'Crie sua conta gratuita'}\n

\n \n

\n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Email\n \n setEmail(e.target.value)}\n className=\"mt-1 appearance-none relative block w-full px-3 py-2 border border-gray-300 placeholder-gray-500 text-gray-900 rounded-md focus:outline-none focus:ring-blue-500 focus:border-blue-500 focus:z-10 sm:text-sm\"\n placeholder=\"seu@email.com\"\n />\n

\n \n

\n \n Senha\n \n setPassword(e.target.value)}\n className=\"mt-1 appearance-none relative block w-full px-3 py-2 border border-gray-300 placeholder-gray-500 text-gray-900 rounded-md focus:outline-none focus:ring-blue-500 focus:border-blue-500 focus:z-10 sm:text-sm\"\n placeholder=\"Mínimo 6 caracteres\"\n minLength={6}\n />\n

\n\n

\n \n {loading ? (\n

\n ) : (\n isLogin ? 'Entrar' : 'Criar Conta'\n )}\n \n

\n\n

\n setIsLogin(!isLogin)}\n className=\"text-blue-600 hover:text-blue-500 text-sm\"\n >\n {isLogin ? 'Não tem conta? Registre-se' : 'Já tem conta? Entre'}\n \n

\n\n {!isLogin && (\n

Plano Gratuito inclui:

• 1 projeto
• 10 palavras-chave
• Atualizações semanais
• Histórico completo

\n )}\n

\n );\n}",[],[289,296,311],{"_103":319,"_95":320,"_152":321,"_154":297,"_155":137,"_156":191,"_158":159,"_105":322,"_100":32,"_161":181,"_163":323,"_164":22,"_165":-5,"_166":324,"_98":325},"c179ffe4-8e96-11f0-b3e0-0224a6c84d84","Dashboard.tsx","c17a00a2-8e96-11f0-b3e0-0224a6c84d84",["D",1757543859064],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User, ProjectWithStats } from \"../../shared/types.ts\";\nimport ProjectList from \"./ProjectList.tsx\";\nimport ProjectView from \"./ProjectView.tsx\";\n\ninterface DashboardProps {\n user: User;\n onLogout: () => void;\n}\n\nexport default function Dashboard({ user, onLogout }: DashboardProps) {\n const [projects, setProjects] = useState([]);\n const [selectedProject, setSelectedProject] = useState(null);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n loadProjects();\n }, []);\n\n const loadProjects = async () => {\n try {\n const token = localStorage.getItem('token');\n const response = await fetch('/api/projects', {\n headers: {\n 'Authorization': `Bearer ${token}`,\n },\n });\n\n if (response.ok) {\n const data = await response.json();\n if (data.success) {\n setProjects(data.data);\n }\n }\n } catch (error) {\n console.error('Erro ao carregar projetos:', error);\n }\n setLoading(false);\n };\n\n const handleProjectCreated = (project: ProjectWithStats) => {\n setProjects([project, ...projects]);\n };\n\n const handleProjectDeleted = (projectId: number) => {\n setProjects(projects.filter(p => p.id !== projectId));\n if (selectedProject?.id === projectId) {\n setSelectedProject(null);\n }\n };\n\n if (loading) {\n return (\n

Carregando projetos...

\n );\n }\n\n return (\n

\n {/* Header */}\n

\n 🔍 Monitor de Palavras-chave\n

\n {selectedProject && (\n setSelectedProject(null)}\n className=\"ml-4 text-blue-600 hover:text-blue-500\"\n >\n ← Voltar aos projetos\n \n )}\n

\n \n

\n {user.email}\n \n {user.plan === 'unlimited' ? 'Unlimited' : 'Gratuito'}\n \n

\n \n \n Sair\n \n

\n\n {/* Content */}\n

\n {selectedProject ? (\n setSelectedProject(null)}\n />\n ) : (\n \n )}\n

\n );\n}",[],[289,296,320],{"_103":327,"_95":328,"_152":329,"_154":297,"_155":137,"_156":330,"_158":159,"_105":331,"_100":32,"_161":181,"_163":332,"_164":22,"_165":-5,"_166":333,"_98":334},"d1b050f2-8e96-11f0-89c1-0224a6c84d84","ProjectList.tsx","d1b051c4-8e96-11f0-89c1-0224a6c84d84",16,["D",1757543886267],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User, ProjectWithStats } from \"../../shared/types.ts\";\n\ninterface ProjectListProps {\n projects: ProjectWithStats[];\n user: User;\n onProjectSelect: (project: ProjectWithStats) => void;\n onProjectCreated: (project: ProjectWithStats) => void;\n onProjectDeleted: (projectId: number) => void;\n}\n\nexport default function ProjectList({ \n projects, \n user, \n onProjectSelect, \n onProjectCreated, \n onProjectDeleted \n}: ProjectListProps) {\n const [showCreateForm, setShowCreateForm] = useState(false);\n const [name, setName] = useState('');\n const [domain, setDomain] = useState('');\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState('');\n\n const canCreateProject = user.plan === 'unlimited' || projects.length === 0;\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError('');\n\n try {\n const token = localStorage.getItem('token');\n const response = await fetch('/api/projects', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`,\n },\n body: JSON.stringify({ name, domain }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n onProjectCreated({ ...data.data, keyword_count: 0, avg_position: null });\n setName('');\n setDomain('');\n setShowCreateForm(false);\n } else {\n setError(data.message || 'Erro ao criar projeto');\n }\n } catch (error) {\n setError('Erro de conexão');\n }\n\n setLoading(false);\n };\n\n const handleDelete = async (projectId: number) => {\n if (!confirm('Tem certeza que deseja deletar este projeto? Todas as palavras-chave e histórico serão perdidos.')) {\n return;\n }\n\n try {\n const token = localStorage.getItem('token');\n const response = await fetch(`/api/projects/${projectId}`, {\n method: 'DELETE',\n headers: {\n 'Authorization': `Bearer ${token}`,\n },\n });\n\n const data = await response.json();\n\n if (data.success) {\n onProjectDeleted(projectId);\n } else {\n alert('Erro ao deletar projeto: ' + data.message);\n }\n } catch (error) {\n alert('Erro de conexão');\n }\n };\n\n return (\n

Meus Projetos

\n Gerencie seus projetos de monitoramento de palavras-chave\n

\n \n

\n {canCreateProject ? (\n setShowCreateForm(true)}\n className=\"inline-flex items-center justify-center rounded-md border border-transparent bg-blue-600 px-4 py-2 text-sm font-medium text-white shadow-sm hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-blue-500 focus:ring-offset-2\"\n >\n Novo Projeto\n \n ) : (\n

\n Limite de projetos atingido (plano gratuito)\n

\n )}\n

\n\n {/* Formulário de criação */}\n {showCreateForm && (\n

Novo Projeto

\n \n

\n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Nome do Projeto\n \n setName(e.target.value)}\n required\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm px-3 py-2 border\"\n placeholder=\"Ex: Meu Site Principal\"\n />\n

\n \n

\n \n Domínio\n \n setDomain(e.target.value)}\n required\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm px-3 py-2 border\"\n placeholder=\"exemplo.com.br\"\n />\n

\n \n

\n setShowCreateForm(false)}\n className=\"bg-white py-2 px-4 border border-gray-300 rounded-md shadow-sm text-sm font-medium text-gray-700 hover:bg-gray-50 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500\"\n >\n Cancelar\n \n \n {loading ? (\n

\n ) : (\n 'Criar Projeto'\n )}\n \n

\n )}\n\n {/* Lista de projetos */}\n

\n {projects.length === 0 ? (\n

📊

Nenhum projeto ainda

Crie seu primeiro projeto para começar a monitorar palavras-chave

\n {canCreateProject && (\n setShowCreateForm(true)}\n className=\"inline-flex items-center px-4 py-2 border border-transparent text-sm font-medium rounded-md text-white bg-blue-600 hover:bg-blue-700\"\n >\n Criar Primeiro Projeto\n \n )}\n

\n ) : (\n

\n {projects.map((project) => (\n onProjectSelect(project)}\n >\n

\n {project.name}\n

\n {\n e.stopPropagation();\n handleDelete(project.id);\n }}\n className=\"text-gray-400 hover:text-red-500\"\n >\n 🗑️\n \n

\n \n

\n {project.domain}\n

\n \n

\n {project.keyword_count} palavra{project.keyword_count !== 1 ? 's' : ''}-chave\n

\n \n {project.avg_position && (\n

\n Pos. média: {Math.round(project.avg_position)}\n

\n )}\n

\n \n

\n Criado em {new Date(project.created_at).toLocaleDateString('pt-BR')}\n

\n ))}\n

\n )}\n

\n \n );\n}",[],[289,296,328],{"_103":336,"_95":337,"_152":338,"_154":297,"_155":137,"_156":339,"_158":159,"_105":340,"_100":32,"_161":181,"_163":341,"_164":22,"_165":-5,"_166":342,"_98":343},"ea52cb3a-8e96-11f0-8fd1-0224a6c84d84","ProjectView.tsx","ea52cbf8-8e96-11f0-8fd1-0224a6c84d84",17,["D",1757543927596],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User, ProjectWithStats, KeywordWithRanking } from \"../../shared/types.ts\";\n\ninterface ProjectViewProps {\n project: ProjectWithStats;\n user: User;\n onBack: () => void;\n}\n\nexport default function ProjectView({ project, user, onBack }: ProjectViewProps) {\n const [keywords, setKeywords] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showAddForm, setShowAddForm] = useState(false);\n const [newKeyword, setNewKeyword] = useState('');\n const [addLoading, setAddLoading] = useState(false);\n const [error, setError] = useState('');\n\n useEffect(() => {\n loadKeywords();\n }, [project.id]);\n\n const loadKeywords = async () => {\n try {\n const token = localStorage.getItem('token');\n const response = await fetch(`/api/keywords/project/${project.id}`, {\n headers: {\n 'Authorization': `Bearer ${token}`,\n },\n });\n\n if (response.ok) {\n const data = await response.json();\n if (data.success) {\n setKeywords(data.data);\n }\n }\n } catch (error) {\n console.error('Erro ao carregar keywords:', error);\n }\n setLoading(false);\n };\n\n const canAddKeyword = user.plan === 'unlimited' || keywords.length < 10;\n\n const handleAddKeyword = async (e: React.FormEvent) => {\n e.preventDefault();\n setAddLoading(true);\n setError('');\n\n try {\n const token = localStorage.getItem('token');\n const response = await fetch('/api/keywords', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${token}`,\n },\n body: JSON.stringify({ \n projectId: project.id, \n keyword: newKeyword \n }),\n });\n\n const data = await response.json();\n\n if (data.success) {\n const newKeywordWithRanking: KeywordWithRanking = {\n ...data.data,\n current_position: null,\n current_url: null,\n last_checked: null,\n rankings: [],\n };\n setKeywords([newKeywordWithRanking, ...keywords]);\n setNewKeyword('');\n setShowAddForm(false);\n } else {\n setError(data.message || 'Erro ao adicionar palavra-chave');\n }\n } catch (error) {\n setError('Erro de conexão');\n }\n\n setAddLoading(false);\n };\n\n const handleDeleteKeyword = async (keywordId: number) => {\n if (!confirm('Tem certeza que deseja deletar esta palavra-chave?')) {\n return;\n }\n\n try {\n const token = localStorage.getItem('token');\n const response = await fetch(`/api/keywords/${keywordId}`, {\n method: 'DELETE',\n headers: {\n 'Authorization': `Bearer ${token}`,\n },\n });\n\n const data = await response.json();\n\n if (data.success) {\n setKeywords(keywords.filter(k => k.id !== keywordId));\n } else {\n alert('Erro ao deletar palavra-chave: ' + data.message);\n }\n } catch (error) {\n alert('Erro de conexão');\n }\n };\n\n const getPositionColor = (position: number | null) => {\n if (!position) return 'text-gray-400';\n if (position <= 3) return 'text-green-600';\n if (position <= 10) return 'text-yellow-600';\n if (position <= 20) return 'text-orange-600';\n return 'text-red-600';\n };\n\n const getPositionBadge = (position: number | null) => {\n if (!position) return 'Não encontrado';\n if (position <= 10) return `#${position}`;\n return `#${position}`;\n };\n\n if (loading) {\n return (\n

Carregando palavras-chave...

\n );\n }\n\n return (\n

\n {/* Header do projeto */}\n

{project.name}

{project.domain}

\n \n

\n {canAddKeyword ? (\n setShowAddForm(true)}\n className=\"inline-flex items-center px-4 py-2 border border-transparent text-sm font-medium rounded-md text-white bg-blue-600 hover:bg-blue-700\"\n >\n Adicionar Palavra-chave\n \n ) : (\n

\n Limite de palavras-chave atingido (plano gratuito)\n

\n )}\n

\n\n {/* Stats */}\n

📝

\n Palavras-chave\n: \n {keywords.length}\n

\n\n

📊

\n Posição Média\n: \n {project.avg_position ? Math.round(project.avg_position) : '-'}\n

\n\n

🏆

\n Top 10\n: \n {keywords.filter(k => k.current_position && k.current_position <= 10).length}\n

\n\n {/* Formulário de adição */}\n {showAddForm && (\n

Nova Palavra-chave

\n \n

\n {error && (\n

\n {error}\n

\n )}\n \n

\n \n Palavra-chave\n \n setNewKeyword(e.target.value)}\n required\n className=\"mt-1 block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm px-3 py-2 border\"\n placeholder=\"Ex: marketing digital\"\n />\n

\n \n

\n setShowAddForm(false)}\n className=\"bg-white py-2 px-4 border border-gray-300 rounded-md shadow-sm text-sm font-medium text-gray-700 hover:bg-gray-50\"\n >\n Cancelar\n \n \n {addLoading ? (\n

\n ) : (\n 'Adicionar'\n )}\n \n

\n )}\n\n {/* Lista de palavras-chave */}\n

\n {keywords.length === 0 ? (\n

🔍

Nenhuma palavra-chave ainda

Adicione palavras-chave para começar o monitoramento

\n {canAddKeyword && (\n setShowAddForm(true)}\n className=\"inline-flex items-center px-4 py-2 border border-transparent text-sm font-medium rounded-md text-white bg-blue-600 hover:bg-blue-700\"\n >\n Adicionar Primeira Palavra-chave\n \n )}\n

\n ) : (\n

\n
\n
\n
\n
\n {keyword.keyword}\n
\n \n
\n
\n {getPositionBadge(keyword.current_position)}\n
\n \n handleDeleteKeyword(keyword.id)}\n className=\"text-gray-400 hover:text-red-500\"\n >\n 🗑️\n \n
\n
\n \n {keyword.current_url && (\n
\n {keyword.current_url}\n
\n )}\n \n
\n {keyword.last_checked ? (\n `Última verificação: ${new Date(keyword.last_checked).toLocaleString('pt-BR')}`\n ) : (\n 'Ainda não verificado'\n )}\n
\n
\n
\n

\n )}\n

\n );\n}",[],[289,296,337],[289,296],{"_103":346,"_95":250,"_152":347,"_154":290,"_155":137,"_156":348,"_158":159,"_105":349,"_100":32,"_161":254,"_163":350,"_164":22,"_165":-5,"_166":351,"_98":352},"3a85ab74-8efe-11f0-a501-0224a6c84d84","3a85ac1e-8efe-11f0-a501-0224a6c84d84",53,["D",1757588300309],"# Frontend - Monitor de Palavras-chave\n\nInterface React para gerenciar projetos e monitorar rankings de palavras-chave.\n\n## Estrutura\n\n- `index.html` - Template HTML principal\n- `index.tsx` - Entry point React\n- `components/` - Componentes React organizados\n\n## Componentes\n\n- `App.tsx` - Componente raiz, gerencia autenticação\n- `AuthForm.tsx` - Formulário de login/registro\n- `Dashboard.tsx` - Layout principal após login\n- `ProjectList.tsx` - Lista e criação de projetos\n- `ProjectView.tsx` - Visualização detalhada de um projeto\n\n## Funcionalidades\n\n### Autenticação\n- Registro de nova conta\n- Login com email/senha\n- Persistência de token no localStorage\n- Logout\n\n### Gestão de Projetos\n- Criar projeto com nome e domínio\n- Listar projetos com estatísticas\n- Deletar projetos\n- Validação de limites por plano\n\n### Gestão de Palavras-chave\n- Adicionar palavras-chave a um projeto\n- Visualizar posição atual e histórico\n- Deletar palavras-chave\n- Indicadores visuais de performance\n\n## Tecnologias\n\n- React 18 com TypeScript\n- TailwindCSS para estilização\n- Fetch API para comunicação com backend\n- JWT para autenticação\n\n## Estados de Loading\n\nTodos os componentes incluem estados de loading apropriados e tratamento de erros para melhor UX.",[],[289,250],{"_103":354,"_95":355,"_152":356,"_154":290,"_155":137,"_156":357,"_158":159,"_105":358,"_100":32,"_161":254,"_163":359,"_164":22,"_165":-5,"_166":360,"_98":361},"1dbff954-8efe-11f0-a070-0224a6c84d84","favicon.svg","1dbff9fe-8efe-11f0-a070-0224a6c84d84",49,["D",1757588252036],"",[],[289,355],{"_103":363,"_95":364,"_152":365,"_154":290,"_155":137,"_156":291,"_158":159,"_105":366,"_100":32,"_161":254,"_163":367,"_164":22,"_165":-5,"_166":368,"_98":369},"a61794f0-8e96-11f0-94f9-0224a6c84d84","index.html","a61795b8-8e96-11f0-94f9-0224a6c84d84",["D",1757543813119],"\n\n\n \n \n Monitor de Palavras-chave\n \n \n \n\n\n

\n \n\n",[],[289,364],{"_103":371,"_95":372,"_152":373,"_154":290,"_155":137,"_156":374,"_158":159,"_105":375,"_100":32,"_161":181,"_163":376,"_164":22,"_165":-5,"_166":377,"_98":378},"a9a65b24-8e96-11f0-967c-0224a6c84d84","index.tsx","a9a65bf6-8e96-11f0-967c-0224a6c84d84",12,["D",1757543819087],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[289,372],[289],{"_103":381,"_95":382,"_152":383,"_154":-5,"_155":137,"_156":384,"_158":159,"_105":385,"_100":32,"_161":162,"_163":-5,"_164":22,"_165":-5,"_166":386,"_98":396},"fff60b0a-8e96-11f0-91f1-0224a6c84d84","scripts","8f7fcad2-dcad-4dd9-8a26-4621bd31cda6",21,["D",1757543963895],[387],{"_103":388,"_95":389,"_152":390,"_154":383,"_155":137,"_156":391,"_158":159,"_105":392,"_100":217,"_161":181,"_163":393,"_164":22,"_165":-5,"_166":394,"_98":395},"2aebb230-8efe-11f0-8903-0224a6c84d84","create-unlimited-user.ts","fff600c4-8e96-11f0-91f1-0224a6c84d84",51,["D",1757588274131],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser(req: Request) {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'unlimited@keywordmonitor.com'; // Altere para seu email\n const password = 'unlimited123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users_v2 WHERE email = ?`, \n [email]\n );\n \n if (existingUser.rows.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users_v2 SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users_v2 (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n return new Response('Usuário unlimited criado com sucesso!', {\n headers: { 'Content-Type': 'text/plain' }\n });\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n return new Response('Erro: ' + error.message, {\n status: 500,\n headers: { 'Content-Type': 'text/plain' }\n });\n }\n}",[],[382,389],[382],{"_103":398,"_95":399,"_152":400,"_154":-5,"_155":137,"_156":209,"_158":159,"_105":401,"_100":32,"_161":162,"_163":-5,"_164":22,"_165":-5,"_166":402,"_98":418},"63f2d9a4-8e96-11f0-85db-0224a6c84d84","shared","6b8507fb-a838-4960-ab31-0f2a79aed9b2",["D",1757543702141],[403,410],{"_103":404,"_95":250,"_152":405,"_154":400,"_155":137,"_156":136,"_158":159,"_105":406,"_100":32,"_161":254,"_163":407,"_164":22,"_165":-5,"_166":408,"_98":409},"3fe7a5ea-8efe-11f0-8356-0224a6c84d84","3fe7a69e-8efe-11f0-8356-0224a6c84d84",["D",1757588309340],"# Shared - Tipos e Utilitários\n\nCódigo compartilhado entre frontend e backend, principalmente definições de tipos TypeScript.\n\n## Arquivos\n\n- `types.ts` - Interfaces e tipos TypeScript\n- `utils.ts` - Funções utilitárias (se necessário)\n\n## Tipos Principais\n\n### Entidades do Banco\n- `User` - Dados do usuário\n- `Project` - Projeto de monitoramento\n- `Keyword` - Palavra-chave a ser monitorada\n- `Ranking` - Registro de posição em uma data\n\n### Tipos Estendidos\n- `KeywordWithRanking` - Keyword com dados de posição atual\n- `ProjectWithStats` - Projeto com estatísticas agregadas\n\n### API Responses\n- `AuthResponse` - Resposta de autenticação\n- `ApiResponse` - Resposta padrão da API\n\n### Serper.dev\n- `SerperResult` - Resultado individual do Google\n- `SerperResponse` - Resposta completa da API\n\n## Compatibilidade\n\nTodo código nesta pasta deve funcionar tanto no frontend (browser) quanto no backend (Deno), evitando APIs específicas de cada ambiente.",[],[399,250],{"_103":411,"_95":412,"_152":413,"_154":400,"_155":137,"_156":209,"_158":159,"_105":414,"_100":32,"_161":181,"_163":415,"_164":22,"_165":-5,"_166":416,"_98":417},"63f2cfc2-8e96-11f0-85db-0224a6c84d84","types.ts","63f2d09e-8e96-11f0-85db-0224a6c84d84",["D",1757543702141],"// Tipos compartilhados entre frontend e backend\n\nexport interface User {\n id: number;\n email: string;\n plan: 'free' | 'unlimited';\n created_at: string;\n}\n\nexport interface Project {\n id: number;\n user_id: number;\n name: string;\n domain: string;\n created_at: string;\n}\n\nexport interface Keyword {\n id: number;\n project_id: number;\n keyword: string;\n location: string;\n language: string;\n created_at: string;\n}\n\nexport interface Ranking {\n id: number;\n keyword_id: number;\n position: number | null;\n url: string | null;\n title: string | null;\n snippet: string | null;\n checked_at: string;\n}\n\nexport interface KeywordWithRanking extends Keyword {\n current_position: number | null;\n current_url: string | null;\n last_checked: string | null;\n rankings: Ranking[];\n}\n\nexport interface ProjectWithStats extends Project {\n keyword_count: number;\n avg_position: number | null;\n}\n\nexport interface AuthResponse {\n success: boolean;\n token?: string;\n user?: User;\n message?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n message?: string;\n}\n\nexport interface SerperResult {\n position: number;\n title: string;\n link: string;\n snippet: string;\n domain: string;\n}\n\nexport interface SerperResponse {\n organic: SerperResult[];\n searchParameters: {\n q: string;\n gl: string;\n hl: string;\n };\n}",[],[399,412],[399],{"_103":420,"_95":250,"_152":421,"_154":-5,"_155":137,"_156":422,"_158":159,"_105":423,"_100":180,"_161":254,"_163":424,"_164":22,"_165":-5,"_166":425,"_98":426},"28ad69f0-8efe-11f0-8903-0224a6c84d84","5ebd5298-8e96-11f0-aca1-0224a6c84d84",50,["D",1757588270359],"# Monitor de Palavras-chave Google\n\nApp de monitoramento de ranking de palavras-chave no Google Brasil usando Serper.dev.\n\n## 🚀 Funcionalidades\n\n- **Plano Gratuito**: 1 projeto, 10 palavras-chave, atualizações semanais\n- **Plano Unlimited**: Projetos ilimitados, palavras-chave ilimitadas, atualizações diárias\n- Histórico completo de posições\n- Interface simples e focada no Brasil\n- Dados completos: posição, URL, título e snippet\n\n## 📁 Estrutura\n\n- `backend/` - API Hono + SQLite\n- `frontend/` - React + TailwindCSS\n- `cron/` - Jobs de verificação de ranking\n- `scripts/` - Utilitários de setup\n\n## ⚙️ Configuração\n\nDefina as variáveis de ambiente:\n- `SERPER_API_KEY` - Sua chave da API Serper.dev\n- `JWT_SECRET` - Segredo para tokens JWT (opcional, tem fallback)\n\n## 👤 Contas de Teste\n\n**Usuário Unlimited:**\n- Email: `unlimited@keywordmonitor.com`\n- Senha: `unlimited123`\n\n## 🔧 Como Usar\n\n1. Acesse o app no navegador\n2. Registre uma conta ou use a conta unlimited\n3. Crie um projeto com seu domínio\n4. Adicione palavras-chave para monitorar\n5. Acompanhe os rankings no dashboard\n\n## 📊 Cron Job\n\nO cron job `/cron/check-rankings.ts` verifica automaticamente:\n- **Usuários gratuitos**: 1x por semana\n- **Usuários unlimited**: Diariamente\n\nConfigure o schedule no Val Town web UI após deployment.\n\n## 🛠️ Tecnologias\n\n- **Backend**: Hono + SQLite\n- **Frontend**: React 18 + TailwindCSS\n- **API**: Serper.dev para dados do Google\n- **Autenticação**: JWT\n- **Hospedagem**: Val Town\n\n## 📈 Próximos Passos\n\n- [ ] Gráficos de evolução de posição\n- [ ] Alertas por email\n- [ ] Exportação de dados\n- [ ] Comparação com concorrentes\n- [ ] Análise de SERP features",[],[250],"files",[149,168,174,185,196,203,213,222,232,239,248,258,269,276,287,294,301,309,318,326,335,345,353,362,370,380,387,397,403,410,419],"counts",{"_431":32,"_432":180,"_433":32,"_434":435},"pulls","branches","forks","envVars",{"_436":32,"_437":32},"count","emptyCount","contents",[],{"_103":388,"_95":389,"_152":390,"_154":383,"_155":137,"_156":391,"_158":159,"_105":441,"_100":217,"_161":181,"_163":393,"_164":22,"_165":-5,"_98":442},["D",1757588274131],[382,389],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":451,"_254":456,"_459":460,"_501":502,"_513":-7,"_514":32,"_515":22},{"_103":104,"_95":96,"_105":452,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":453,"_131":454,"_134":455,"_146":22},["D",1757543171209],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},{"_103":388,"_95":389,"_152":390,"_154":383,"_155":137,"_156":391,"_158":159,"_105":457,"_100":217,"_161":181,"_163":393,"_164":22,"_165":-5,"_98":458},["D",1757588274131],[382,389],"history",[461,463,467,472,477,483,488,493,498],{"_103":388,"_155":137,"_152":390,"_95":389,"_163":393,"_161":181,"_100":217,"_154":383,"_105":462,"_156":391,"_165":-5},["D",1757588274131],{"_103":464,"_155":137,"_152":390,"_95":389,"_163":393,"_161":264,"_100":226,"_154":383,"_105":465,"_156":466,"_165":-5},"15b2ed0c-8efe-11f0-9051-0224a6c84d84",["D",1757588238529],48,{"_103":468,"_155":137,"_152":390,"_95":389,"_163":469,"_161":264,"_100":200,"_154":383,"_105":470,"_156":471,"_165":-5},"49400bf8-8e97-11f0-98ff-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser(req: Request) {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'unlimited@keywordmonitor.com'; // Altere para seu email\n const password = 'unlimited123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users_v2 WHERE email = ?`, \n [email]\n );\n \n if (existingUser.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users_v2 SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users_v2 (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n return new Response('Usuário unlimited criado com sucesso!', {\n headers: { 'Content-Type': 'text/plain' }\n });\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n return new Response('Erro: ' + error.message, {\n status: 500,\n headers: { 'Content-Type': 'text/plain' }\n });\n }\n}",["D",1757544086855],34,{"_103":473,"_155":137,"_152":390,"_95":389,"_163":474,"_161":264,"_100":236,"_154":383,"_105":475,"_156":476,"_165":-5},"40727c54-8e97-11f0-86b6-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser(req: Request) {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'admin@keywordmonitor.com'; // Altere para seu email\n const password = 'admin123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users_v2 WHERE email = ?`, \n [email]\n );\n \n if (existingUser.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users_v2 SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users_v2 (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n return new Response('Usuário unlimited criado com sucesso!', {\n headers: { 'Content-Type': 'text/plain' }\n });\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n return new Response('Erro: ' + error.message, {\n status: 500,\n headers: { 'Content-Type': 'text/plain' }\n });\n }\n}",["D",1757544072080],32,{"_103":478,"_155":137,"_152":390,"_95":389,"_163":479,"_161":264,"_100":480,"_154":383,"_105":481,"_156":482,"_165":-5},"121cb75c-8e97-11f0-9e8e-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser(req: Request) {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'admin@keywordmonitor.com'; // Altere para seu email\n const password = 'admin123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users WHERE email = ?`, \n [email]\n );\n \n if (existingUser.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n return new Response('Usuário unlimited criado com sucesso!', {\n headers: { 'Content-Type': 'text/plain' }\n });\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n return new Response('Erro: ' + error.message, {\n status: 500,\n headers: { 'Content-Type': 'text/plain' }\n });\n }\n}",4,["D",1757543994350],26,{"_103":484,"_155":137,"_152":390,"_95":389,"_163":485,"_161":264,"_100":157,"_154":383,"_105":486,"_156":487,"_165":-5},"0f74064a-8e97-11f0-9051-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser(req: Request) {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'admin@keywordmonitor.com'; // Altere para seu email\n const password = 'admin123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users WHERE email = ?`, \n [email]\n );\n \n if (existingUser.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n return new Response('Usuário unlimited criado com sucesso!', {\n headers: { 'Content-Type': 'text/plain' }\n });\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n throw error;\n }\n}",["D",1757543989889],25,{"_103":489,"_155":137,"_152":390,"_95":389,"_163":490,"_161":264,"_100":209,"_154":383,"_105":491,"_156":492,"_165":-5},"0d1dbaa8-8e97-11f0-8a8c-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser(req: Request) {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'admin@keywordmonitor.com'; // Altere para seu email\n const password = 'admin123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users WHERE email = ?`, \n [email]\n );\n \n if (existingUser.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n throw error;\n }\n}",["D",1757543985960],24,{"_103":494,"_155":137,"_152":390,"_95":389,"_163":495,"_161":264,"_100":180,"_154":383,"_105":496,"_156":497,"_165":-5},"0b268932-8e97-11f0-8734-0224a6c84d84","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { runMigrations } from \"../backend/database/migrations.ts\";\n\n// Hash de senha simples (mesmo método usado no auth)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + 'salt-keyword-monitor');\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\nexport default async function createUnlimitedUser() {\n console.log('🚀 Criando usuário unlimited...');\n \n try {\n // Garantir que o banco está inicializado\n await runMigrations();\n \n const email = 'admin@keywordmonitor.com'; // Altere para seu email\n const password = 'admin123'; // Altere para sua senha\n \n // Verificar se usuário já existe\n const existingUser = await sqlite.execute(\n `SELECT * FROM users WHERE email = ?`, \n [email]\n );\n \n if (existingUser.length > 0) {\n // Atualizar para unlimited se já existir\n await sqlite.execute(\n `UPDATE users SET plan = 'unlimited' WHERE email = ?`,\n [email]\n );\n console.log(`✅ Usuário ${email} atualizado para plano unlimited`);\n } else {\n // Criar novo usuário unlimited\n const passwordHash = await hashPassword(password);\n await sqlite.execute(\n `INSERT INTO users (email, password_hash, plan) VALUES (?, ?, 'unlimited')`,\n [email, passwordHash]\n );\n console.log(`✅ Usuário unlimited criado: ${email}`);\n console.log(`🔑 Senha: ${password}`);\n }\n \n console.log('🎉 Processo concluído!');\n \n } catch (error) {\n console.error('❌ Erro ao criar usuário unlimited:', error);\n throw error;\n }\n}",["D",1757543982653],23,{"_103":499,"_155":137,"_152":390,"_95":389,"_163":495,"_161":181,"_100":32,"_154":383,"_105":500,"_156":384,"_165":-5},"fff60010-8e96-11f0-91f1-0224a6c84d84",["D",1757543963895],"versions",[503,505,506,507,508,509,510,511,512],{"_254":461,"_504":463},"previous",{"_254":463,"_504":467},{"_254":467,"_504":472},{"_254":472,"_504":477},{"_254":477,"_504":483},{"_254":483,"_504":488},{"_254":488,"_504":493},{"_254":493,"_504":498},{"_254":498,"_504":-5},"versionNumber","page","hasNext","actionData","errors"]

diegoivo

testRankTracker

History for create-unlimited-user.ts