\n \n

Strayegy2B

Sistema Inteligente de Separação

\n Usuário\n \n

\n Senha\n \n

\n \n

\n\n\n

\n\n \n \n\n \n

\n\n \n

Dashboard

Online

Produtos Bipados

Completos

Incompletos

Finalizadas

Top 10 — Itens mais bipados

Separações recentes

\n\n \n

Nova Separação

Pallet 1

\n Anexar PDF\n

Anexe um romaneio do Mercado Livre Full (PDF) para começar.

\n \n \n

EAN não consta no estoque:

\n \n

—Separados: 0

\n \n \n

EAN	SKU	Descrição	Alvo	Sep	Status

\n \n \n \n

\n \n

\n\n \n

Histórico de Separações

\n\n \n

Estoque

\n \n

EAN	SKU	Descrição	Qtd

\n\n \n

Novo Colaborador

Nome completo

E-mail

Telefone

Senha

Repetir senha

Setor\n

Cliente

\n \n

\n\n

\n\n\n\n\n","label",[182,76],"pulls","branches",1,"forks","envVars",{"_269":263,"_271":26},"connections",{"_269":26,"_270":26},"count","unfilledCount","emptyCount",{"_44":306,"_13":182,"_74":252,"_54":-5,"_46":47,"_253":307,"_254":190,"_48":308,"_50":26,"_77":303,"_257":-5,"_78":24,"_259":-5,"_284":309,"_17":310},{"_44":299,"_13":300,"_74":301,"_54":252,"_46":47,"_253":256,"_254":190,"_48":302,"_50":26,"_77":303,"_257":-5,"_78":24,"_259":-5,"_284":304,"_17":305},{"_44":290,"_13":291,"_74":292,"_54":252,"_46":47,"_253":293,"_254":190,"_48":294,"_50":295,"_77":21,"_257":296,"_78":24,"_259":-5,"_284":297,"_17":298},{"_44":251,"_13":76,"_74":75,"_54":252,"_46":47,"_253":171,"_254":190,"_48":287,"_50":256,"_77":21,"_257":258,"_78":24,"_259":-5,"_284":288,"_17":289},{"_44":277,"_13":278,"_74":188,"_54":-5,"_46":47,"_253":279,"_254":190,"_48":280,"_50":115,"_77":281,"_257":282,"_78":24,"_259":283,"_284":285,"_17":286},"4734172f-a4a1-4505-a146-bcd1eb616689","main.ts",35,["D",1787198541307],"http","import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { createHash } from \"node:crypto\";\n\nfunction hashPw(s: string): string {\n return createHash(\"sha256\").update(\"strayegy-salt$\" + s).digest(\"hex\");\n}\n\n// ============================================================\n// BANCO DE DADOS (project-scoped SQLite)\n// ============================================================\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS usuarios (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n usuario_login TEXT UNIQUE,\n nome TEXT NOT NULL,\n email TEXT,\n telefone TEXT,\n senha TEXT NOT NULL,\n setor TEXT,\n cliente TEXT,\n perfil TEXT NOT NULL DEFAULT 'colaborador',\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS estoque (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n ean TEXT,\n sku TEXT,\n descricao TEXT,\n quantidade INTEGER DEFAULT 0,\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS separacoes (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n arquivo TEXT,\n colaborador TEXT,\n tipo TEXT,\n volume INTEGER DEFAULT 0,\n data_finalizacao TEXT,\n itens_json TEXT,\n created_at TEXT DEFAULT (datetime('now'))\n)`);\n\n// Garante o admin inicial: login admin / senha admin (criado uma única vez)\nconst admin = await sqlite.execute(`SELECT COUNT(*) AS c FROM usuarios WHERE usuario_login = 'admin'`);\nconst adminCount = admin.rows[0] as any;\nif (!adminCount || adminCount.c === 0) {\n await sqlite.execute(\n `INSERT INTO usuarios (usuario_login, nome, email, telefone, senha, setor, cliente, perfil) VALUES (?,?,?,?,?,?,?,?)`,\n [\"admin\", \"Administrador\", \"admin@strayegy.com\", \"\", \"admin\", \"Full\", \"Strayegy\", \"administrador\"],\n );\n}\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json\", \"Access-Control-Allow-Origin\": \"*\" },\n });\n}\n\nasync function body(req: Request) {\n try { return await req.json(); } catch { return {}; }\n}\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n\n // ----------- LOGIN -----------\n if (url.pathname === \"/api/login\" && req.method === \"POST\") {\n const b = await body(req);\n const r = await sqlite.execute(\n `SELECT * FROM usuarios WHERE usuario_login = ? OR email = ?`,\n [b.usuario || b.email, b.usuario || b.email],\n );\n const u = r.rows[0] as any;\n // aceita hash novo OU senha legada (pré-hash) para não quebrar contas existentes\n if (!u || (u.senha !== hashPw(b.senha ?? \"\") && u.senha !== b.senha)) {\n return json({ erro: \"Usuário ou senha incorretos\" }, 401);\n }\n return json({ id: u.id, usuario: u.usuario_login, nome: u.nome, email: u.email, setor: u.setor, cliente: u.cliente, perfil: u.perfil });\n }\n\n // ----------- COLABORADORES -----------\n if (url.pathname === \"/api/usuarios\" && req.method === \"POST\") {\n const b = await body(req);\n if (b.senha !== b.repeteSenha) return json({ erro: \"Senhas não coincidem\" }, 400);\n await sqlite.execute(\n `INSERT INTO usuarios (usuario_login, nome, email, telefone, senha, setor, cliente, perfil) VALUES (?,?,?,?,?,?,?,?)`,\n [b.usuario, b.nome, b.email, b.telefone, hashPw(b.senha), b.setor, b.cliente, b.perfil || \"colaborador\"],\n );\n return json({ ok: true });\n }\n\n if (url.pathname === \"/api/usuarios\" && req.method === \"GET\") {\n const r = await sqlite.execute(`SELECT id, usuario_login, nome, email, telefone, setor, cliente, perfil FROM usuarios`);\n return json(r.rows);\n }\n\n // ----------- ESTOQUE -----------\n if (url.pathname === \"/api/estoque\" && req.method === \"GET\") {\n const r = await sqlite.execute(`SELECT * FROM estoque ORDER BY id DESC`);\n return json(r.rows);\n }\n\n if (url.pathname === \"/api/estoque\" && req.method === \"POST\") {\n // {ean, sku, descricao, quantidade} — se o EAN já existe, soma quantidade\n const b = await body(req);\n const exist = await sqlite.execute(`SELECT id FROM estoque WHERE ean = ?`, [b.ean]);\n if (exist.rows.length) {\n await sqlite.execute(`UPDATE estoque SET quantidade = quantidade + ?, descricao = ? WHERE ean = ?`, [b.quantidade || 1, b.descricao, b.ean]);\n } else {\n await sqlite.execute(\n `INSERT INTO estoque (ean, sku, descricao, quantidade) VALUES (?,?,?,?)`,\n [b.ean, b.sku, b.descricao, b.quantidade || 1],\n );\n }\n return json({ ok: true });\n }\n\n // ----------- SEPARAÇÕES -----------\n if (url.pathname === \"/api/separacoes\" && req.method === \"GET\") {\n const r = await sqlite.execute(`SELECT * FROM separacoes ORDER BY id DESC`);\n return json(r.rows.map((row: any) => ({ ...row, itens: JSON.parse(row.itens_json || \"[]\") })));\n }\n\n if (url.pathname === \"/api/separacoes\" && req.method === \"POST\") {\n const b = await body(req);\n await sqlite.execute(\n `INSERT INTO separacoes (arquivo, colaborador, tipo, volume, data_finalizacao, itens_json) VALUES (?,?,?,?,?,?)`,\n [b.arquivo, b.colaborador, b.tipo, b.volume || 0, b.data_finalizacao, JSON.stringify(b.itens || [])],\n );\n return json({ ok: true });\n }\n\n // ----------- PROXY COSMOS -----------\n const gtin = url.searchParams.get(\"gtin\");\n if (gtin) {\n try {\n const cosmosUrl = `https://api.cosmos.bluesoft.com.br/gtins/${gtin}.json`;\n const response = await fetch(cosmosUrl, {\n headers: {\n \"X-Cosmos-Token\": (Deno.env.get(\"COSMOS_TOKEN\") ?? \"\").trim(),\n \"User-Agent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36\",\n },\n });\n const data = await response.text();\n return new Response(data, { status: response.status, headers: { \"Access-Control-Allow-Origin\": \"*\", \"Content-Type\": \"application/json\" } });\n } catch (err: any) {\n return json({ erro: err.message }, 500);\n }\n }\n\n // ----------- SITE -----------\n const htmlPage = await readFile(\"/public/separacao.html\");\n return new Response(htmlPage, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n}\n","strayegy2b","children",[],[278],["D",1787198665600],[],[182,76],"b6bc4092-6504-486c-a42e-74a3c10d7b1d","index.html","a1167480-9c41-11f1-823b-1607ee4eb77e",11,["D",1787194353754],2,"\n\n\n \n \n Leitor de Embalagens e EAN\n \n\n\n\n

Leitor de Produtos

\n \n

\n \n\n

\n\n \n\n\n\n",[],[182,291],"caf21643-0eec-4103-92ef-75021f353157","raw","7db44fdc-1e8a-47dd-b100-e56c389ad798",["D",1787195070210],"directory",[],[182,300],"702f0f2d-fd72-432f-b57e-ddc3b8abc495",7,["D",1787194111412],[273,274,275],[182],["D",1787192180179],["D",1789540832752],{"_11":12,"_229":81},{"_11":12,"_224":225,"_80":81,"_30":79,"_226":227,"_228":24},{"_50":171,"_13":16,"_44":47,"_216":177,"_217":-5,"_218":-5,"_219":-5,"_220":-5,"_221":-5,"_222":14,"_223":12},"ctx",{"_64":-5,"_248":349,"_350":351,"_352":353,"_354":24,"_355":24,"_356":24,"_357":190,"_358":-5,"_359":-7,"_360":-7,"_361":26,"_362":24,"_363":24,"_364":-5,"_365":24,"_366":24,"_367":24,"_368":-5},"ENV",{"_320":321,"_322":323,"_324":16,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","RENDER_GIT_BRANCH","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","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · separacao.html