🚀 Universal Ad Platform

\n\n

Register Business

\n {\n e.preventDefault();\n const formData = new FormData(e.currentTarget);\n registerBusiness({\n name: formData.get(\"businessName\") as string,\n email: formData.get(\"email\") as string,\n platforms: Array.from(formData.getAll(\"platforms\") as string[]),\n });\n e.currentTarget.reset();\n }}\n >\n \n \n

\n {platforms.map(platform => (\n \n {\" \"}\n {platform}\n \n ))}\n

\n \n \n

\n\n

Create Advertisement

\n {\n e.preventDefault();\n const formData = new FormData(e.currentTarget);\n createAd({\n businessId: businesses[0]?.id || \"\",\n title: formData.get(\"adTitle\") as string,\n description: formData.get(\"adDescription\") as string,\n platforms: Array.from(formData.getAll(\"adPlatforms\") as string[]),\n budget: Number(formData.get(\"budget\")),\n });\n e.currentTarget.reset();\n }}\n >\n \n \n

\n          <input name=\"budget\" type=\"number\" placeholder=\"Budget\" required />\n          <div>\n            {platforms.map(platform => (\n              <label key={platform}>\n                <input\n                  type=\"checkbox\"\n                  name=\"adPlatforms\"\n                  value={platform}\n                />{\" \"}\n                {platform}\n              </label>\n            ))}\n          </div>\n          <button type=\"submit\">Create Ad</button>\n        </form>\n      </div>\n\n      <div>\n        <h2>Advertisements</h2>\n        <select\n          value={selectedPlatform}\n          onChange={(e) => setSelectedPlatform(e.target.value)}\n        >\n          <option value=\"All\">All Platforms</option>\n          {platforms.map(platform => <option key={platform} value={platform}>{platform}</option>)}\n        </select>\n\n        {filteredAds.map(ad => (\n          <div\n            key={ad.id}\n            style={{\n              border: \"1px solid #ddd\",\n              margin: \"10px 0\",\n              padding: \"10px\",\n            }}\n          >\n            <h3>{ad.title}</h3>\n            <p>{ad.description}</p>\n            <p>Platforms: {ad.platforms.join(\", \")}</p>\n            <p>Budget: ${ad.budget}</p>\n          </div>\n        ))}\n      </div>\n\n      <a\n        href={import.meta.url.replace(\"esm.town\", \"val.town\")}\n        target=\"_top\"\n        style={{ color: \"#666\", textDecoration: \"none\" }}\n      >\n        View Source\n      </a>\n    </div>\n  );\n}\n\nfunction client() {\n  createRoot(document.getElementById(\"root\")).render(<App />);\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise<Response> {\n  const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n  const KEY = \"irerichrispusadplatformapp\";\n  const SCHEMA_VERSION = 3;\n\n  // Initialize tables\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_businesses_${SCHEMA_VERSION} (\n      id TEXT PRIMARY KEY,\n      name TEXT NOT NULL,\n      email TEXT NOT NULL,\n      platforms TEXT NOT NULL\n    )\n  `);\n\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS ${KEY}_ads_${SCHEMA_VERSION} (\n      id TEXT PRIMARY KEY,\n      businessId TEXT NOT NULL,\n      title TEXT NOT NULL,\n      description TEXT NOT NULL,\n      platforms TEXT NOT NULL,\n      budget REAL NOT NULL\n    )\n  `);\n\n  // Handle different routes\n  if (request.method === \"GET\") {\n    const url = new URL(request.url);\n\n    if (url.pathname === \"/businesses\") {\n      const businesses = await sqlite.execute(`\n        SELECT * FROM ${KEY}_businesses_${SCHEMA_VERSION}\n      `);\n      return new Response(\n        JSON.stringify(\n          businesses.rows.map(row => ({\n            ...row,\n            platforms: JSON.parse(row.platforms),\n          })),\n        ),\n        { headers: { \"Content-Type\": \"application/json\" } },\n      );\n    }\n\n    if (url.pathname === \"/ads\") {\n      const ads = await sqlite.execute(`\n        SELECT * FROM ${KEY}_ads_${SCHEMA_VERSION}\n      `);\n      return new Response(\n        JSON.stringify(\n          ads.rows.map(row => ({\n            ...row,\n            platforms: JSON.parse(row.platforms),\n          })),\n        ),\n        { headers: { \"Content-Type\": \"application/json\" } },\n      );\n    }\n  }\n\n  if (request.method === \"POST\") {\n    const url = new URL(request.url);\n    const body = await request.json();\n\n    if (url.pathname === \"/businesses\") {\n      const id = crypto.randomUUID();\n      await sqlite.execute(\n        `\n        INSERT INTO ${KEY}_businesses_${SCHEMA_VERSION} \n        (id, name, email, platforms) VALUES (?, ?, ?, ?)\n      `,\n        [\n          id,\n          body.name,\n          body.email,\n          JSON.stringify(body.platforms),\n        ],\n      );\n      return new Response(\n        JSON.stringify({\n          id,\n          ...body,\n        }),\n        { headers: { \"Content-Type\": \"application/json\" } },\n      );\n    }\n\n    if (url.pathname === \"/ads\") {\n      const id = crypto.randomUUID();\n      await sqlite.execute(\n        `\n        INSERT INTO ${KEY}_ads_${SCHEMA_VERSION} \n        (id, businessId, title, description, platforms, budget) \n        VALUES (?, ?, ?, ?, ?, ?)\n      `,\n        [\n          id,\n          body.businessId,\n          body.title,\n          body.description,\n          JSON.stringify(body.platforms),\n          body.budget,\n        ],\n      );\n      return new Response(\n        JSON.stringify({\n          id,\n          ...body,\n        }),\n        { headers: { \"Content-Type\": \"application/json\" } },\n      );\n    }\n  }\n\n  return new Response(\n    `\n    <html>\n      <head>\n        <title>Universal Ad Platform</title>\n        <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\" />\n        <style>\n          body { font-family: Arial, sans-serif; line-height: 1.6; }\n          input, textarea, select { \n            width: 100%; \n            margin: 10px 0; \n            padding: 8px; \n            box-sizing: border-box; \n          }\n        </style>\n      </head>\n      <body>\n        <div id=\"root\"></div>\n        <script src=\"https://esm.town/v/std/catch\"></script>\n        <script type=\"module\" src=\"${import.meta.url}\"></script>\n      </body>\n    </html>\n  `,\n    {\n      headers: { \"content-type\": \"text/html\" },\n    },\n  );\n}","deleted","label",[99],"permalink","https://www.val.town/x/Irerichrispus/irerichrispusadplatformapp/code/main.tsx","extension","actionData","errors"]
</article></body></html>