\n {/* Add a wrapper class if needed */}\n {/* You could insert a Navbar component here matching the MYOB style */}\n

ServiceBoost AI

Enhanced Marketing Strategy Assistant

\n\n {/* Profile Panel */}\n

Business Profile

\n {isLoadingProfile &&

Loading profile...

}\n {profileError && (\n

{profileError}

\n )}\n\n

\n {/* Basic Info Row */}\n

\n Business Type:\n \n

\n Service Area:\n \n

\n\n {/* USP & Target Audience Row */}\n

\n Unique Selling Proposition (USP):\n \n

\n Describe your Ideal Customer(s):\n \n

\n\n {/* Services & Brand Tone Row */}\n

\n List Your Main Services/Products:\n \n

\n Desired Brand Tone/Voice:\n \n \n \n \n \n \n \n \n

\n\n {/* Save Button */}\n

\n \n

\n\n {/* Strategy Section */}\n {profile && !isLoadingProfile && (\n

Generated Marketing Strategy

\n \n\n {isLoadingStrategy &&

Generating strategy...

}\n {strategyError &&

{strategyError}

}\n\n {strategy && !isLoadingStrategy && (\n

\n {/* Display Content Themes */}\n {strategy.contentThemes && (\n

\n Content Themes & Ideas\n

{\" \"}\n {/* Example using Font Awesome class */}\n

{idea}

\n )}\n {/* Display Platform Focus */}\n {strategy.platformFocus && (\n

\n Platform Focus\n

\n {pf.platform}: {pf.rationale}\n

\n )}\n {/* Display Keyword Groups */}\n {strategy.keywordGroups && (\n

\n Local Keyword Groups\n

\n {strategy.keywordGroups.map((kg, index) => (\n

\n {kg.group}:\n

{kw}

\n ))}\n

\n )}\n {/* Display Promotion Ideas */}\n {strategy.promotionIdeas && (\n

\n Promotion Ideas\n

{promo}

\n )}\n

{\" \"}\n {/* End panel-body for strategy */}\n

// End panel for strategy\n )}\n {!profile && !isLoadingProfile && !profileError && (\n

\n Please save your profile details above to generate a marketing strategy.\n

\n )}\n

{\" \"}\n {/* End container */}\n

// End myob wrapper\n );\n}\n\n// --- Client-side Rendering Function (Remains the same) ---\nfunction client() {\n const root = document.getElementById(\"root\");\n if (root) { createRoot(root).render(); }\n else { console.error(\"Root element not found\"); }\n}\nif (typeof document !== \"undefined\") { client(); }\n\n// --- Server-side Logic (Val Town HTTP Endpoint) ---\nexport default async function server(request: Request): Promise {\n // Dynamically import backend modules\n const { sqlite } = await import(\"https://esm.town/v/std/sqlite\");\n const { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n\n // --- Database Setup (Expanded Schema) ---\n const TABLE_KEY = new URL(import.meta.url).pathname.replace(/[^a-zA-Z0-9_]/g, \"_\").slice(1);\n const PROFILE_TABLE = `business_profiles_${TABLE_KEY}`;\n const PROFILE_ID = \"profile_1\"; // Fixed ID for single profile MVP/Step 2\n\n try {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${PROFILE_TABLE} (\n id TEXT PRIMARY KEY,\n business_type TEXT,\n service_area TEXT,\n usp TEXT, -- Added\n target_customer TEXT, -- Added\n main_services TEXT, -- Added\n brand_tone TEXT, -- Added\n last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n )\n `);\n // Add new columns if table already exists (simple approach for Val Town)\n await sqlite.execute(`ALTER TABLE ${PROFILE_TABLE} ADD COLUMN usp TEXT`).catch(\n e => {/* ignore column already exists errors */},\n );\n await sqlite.execute(`ALTER TABLE ${PROFILE_TABLE} ADD COLUMN target_customer TEXT`).catch(e => {/* ignore */});\n await sqlite.execute(`ALTER TABLE ${PROFILE_TABLE} ADD COLUMN main_services TEXT`).catch(e => {/* ignore */});\n await sqlite.execute(`ALTER TABLE ${PROFILE_TABLE} ADD COLUMN brand_tone TEXT`).catch(e => {/* ignore */});\n } catch (e: any) {\n console.error(\"DB Init/Alter Error:\", e.message);\n }\n\n const url = new URL(request.url);\n\n // --- API Route Handling ---\n if (url.pathname === \"/api/profile\") {\n // GET Profile (Select new fields)\n if (request.method === \"GET\") {\n try {\n const { rows } = await sqlite.execute({\n sql:\n `SELECT business_type, service_area, usp, target_customer, main_services, brand_tone FROM ${PROFILE_TABLE} WHERE id = ?`,\n args: [PROFILE_ID],\n });\n if (rows.length > 0) {\n const profileData = {\n business_type: rows[0][0],\n service_area: rows[0][1],\n usp: rows[0][2],\n target_customer: rows[0][3],\n main_services: rows[0][4],\n brand_tone: rows[0][5],\n };\n return new Response(JSON.stringify(profileData), {\n headers: { \"Content-Type\": \"application/json\" },\n status: 200,\n });\n } else {\n return new Response(JSON.stringify({ message: \"Profile not found\" }), {\n status: 404,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n } catch (e: any) {\n /* ... error handling ... */\n console.error(\"Error fetching profile:\", e.message);\n return new Response(JSON.stringify({ error: \"Database error fetching profile\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n // POST Profile (Save/Update new fields)\n if (request.method === \"POST\") {\n try {\n const body = await request.json();\n const { business_type, service_area, usp, target_customer, main_services, brand_tone } = body;\n if (!business_type || !service_area) {\n return new Response(JSON.stringify({ error: \"Business Type and Service Area are required.\" }), {\n status: 400,\n });\n }\n await sqlite.execute({\n sql: `\n INSERT OR REPLACE INTO ${PROFILE_TABLE} (id, business_type, service_area, usp, target_customer, main_services, brand_tone, last_updated)\n VALUES (?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP);\n `,\n args: [PROFILE_ID, business_type, service_area, usp, target_customer, main_services, brand_tone],\n });\n return new Response(JSON.stringify({ message: \"Profile saved successfully\" }), { status: 200 });\n } catch (e: any) {\n /* ... error handling ... */\n console.error(\"Error saving profile:\", e.message);\n return new Response(JSON.stringify({ error: \"Database error saving profile\" }), { status: 500 });\n }\n }\n }\n\n // --- Generate Strategy Route ---\n if (url.pathname === \"/api/generate-strategy\" && request.method === \"POST\") {\n let profile: any = null;\n // 1. Fetch the enhanced profile\n try {\n const { rows } = await sqlite.execute({\n sql:\n `SELECT business_type, service_area, usp, target_customer, main_services, brand_tone FROM ${PROFILE_TABLE} WHERE id = ?`,\n args: [PROFILE_ID],\n });\n if (rows.length > 0) {\n profile = {\n business_type: rows[0][0],\n service_area: rows[0][1],\n usp: rows[0][2],\n target_customer: rows[0][3],\n main_services: rows[0][4],\n brand_tone: rows[0][5],\n };\n }\n } catch (e: any) {\n /* ... error handling ... */ return new Response(JSON.stringify({ error: \"DB error fetching profile\" }), {\n status: 500,\n });\n }\n\n if (!profile || !profile.business_type || !profile.service_area) {\n return new Response(JSON.stringify({ error: \"Business profile not found or incomplete.\" }), { status: 400 });\n }\n\n // 2. Call OpenAI with enhanced prompt\n try {\n const openai = new OpenAI(); // Needs 'openai' secret in VT\n // Construct a more detailed prompt\n let prompt =\n `Generate a concise marketing strategy starter pack for a ${profile.business_type} business serving the ${profile.service_area} area. `;\n if (profile.target_customer) prompt += `Their target customers are: ${profile.target_customer}. `;\n if (profile.usp) prompt += `Their unique selling proposition is: \"${profile.usp}\". `;\n if (profile.main_services) prompt += `Their main services include: ${profile.main_services}. `;\n if (profile.brand_tone) prompt += `They prefer a ${profile.brand_tone} brand tone. `;\n prompt +=\n `Focus on local digital marketing. Provide specific, actionable ideas. Format the output strictly as a JSON object with these keys:\n \"contentThemes\": An array of 3-4 distinct content theme ideas (strings).\n \"platformFocus\": An array of 2-3 objects, each with \"platform\" (string, e.g., \"Google Business Profile\", \"Facebook\") and \"rationale\" (string, brief reason why).\n \"keywordGroups\": An array of 2-3 objects, each with \"group\" (string, e.g., \"Service Keywords\", \"Local Intent\") and \"keywords\" (array of 3-5 related keyword strings).\n \"promotionIdeas\": An array of 2-3 simple, actionable promotion ideas (strings) suitable for this business.\n Do not include any introductory text, markdown formatting, or explanations outside the JSON structure.`;\n\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: prompt }],\n model: \"gpt-4o-mini\", // Or a more powerful model if needed\n response_format: { type: \"json_object\" },\n temperature: 0.75, // Slightly increased temperature for variety\n });\n\n const strategyJsonString = completion.choices[0]?.message?.content;\n if (!strategyJsonString) throw new Error(\"AI did not return content.\");\n\n const generatedStrategy = JSON.parse(strategyJsonString);\n\n // Basic validation (can be more thorough)\n if (!generatedStrategy || typeof generatedStrategy !== \"object\") {\n throw new Error(\"AI response was not a valid JSON object.\");\n }\n\n return new Response(JSON.stringify(generatedStrategy), {\n headers: { \"Content-Type\": \"application/json\" },\n status: 200,\n });\n } catch (e: any) {\n /* ... error handling ... */\n console.error(\"AI/Strategy Error:\", e);\n return new Response(JSON.stringify({ error: \"Failed to generate strategy via AI.\", details: e.message }), {\n status: 500,\n });\n }\n }\n\n // --- Default Route: Serve HTML for the React App ---\n if (request.method === \"GET\" && url.pathname === \"/\") {\n const html = `\n\n \n ServiceBoost AI\n \n \n \n \n \n

\n \n \n`;\n return new Response(html, { headers: { \"Content-Type\": \"text/html\" } });\n }\n\n // --- Handle Not Found ---\n return new Response(JSON.stringify({ error: \"Not Found\" }), { status: 404 });\n}","deleted","label",[98],"permalink","https://www.val.town/x/salon/svc/code/main.tsx","extension","actionData","errors"]