

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: services.php</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'>&lt;?php
declare(strict_types=1);

require_once __DIR__ . &#039;/includes/auth.php&#039;;
require_login();

$admin_title = &#039;Services sliders&#039;;
$db = db();
if (!$db) {
    admin_flash(&#039;Database connection is not configured.&#039;, &#039;error&#039;);
}

if ($_SERVER[&#039;REQUEST_METHOD&#039;] === &#039;POST&#039; &amp;&amp; $db) {
    verify_csrf();
    $action = (string) ($_POST[&#039;action&#039;] ?? &#039;save&#039;);
    try {
        if ($action === &#039;delete&#039;) {
            $id = (int) ($_POST[&#039;id&#039;] ?? 0);
            $stmt = $db-&gt;prepare(&quot;DELETE FROM services WHERE id = ?&quot;);
            $stmt-&gt;bind_param(&#039;i&#039;, $id);
            $stmt-&gt;execute();
            admin_flash(&#039;Service deleted.&#039;);
            admin_redirect(&#039;services.php&#039;);
        }

        $id = (int) ($_POST[&#039;id&#039;] ?? 0);
        $title = trim((string) ($_POST[&#039;title&#039;] ?? &#039;&#039;));
        $slug = slugify((string) ($_POST[&#039;slug&#039;] ?? $title));
        $description = trim((string) ($_POST[&#039;description&#039;] ?? &#039;&#039;));
        $icon = trim((string) ($_POST[&#039;icon&#039;] ?? &#039;ai&#039;));
        $alt_text = trim((string) ($_POST[&#039;alt_text&#039;] ?? &#039;&#039;));
        $sort_order = (int) ($_POST[&#039;sort_order&#039;] ?? 0);
        $is_active = isset($_POST[&#039;is_active&#039;]) ? 1 : 0;
        $image_path = upload_image(&#039;image&#039;, trim((string) ($_POST[&#039;existing_image_path&#039;] ?? &#039;&#039;)));

        if ($title === &#039;&#039; || $description === &#039;&#039;) {
            throw new RuntimeException(&#039;Title and description are required.&#039;);
        }

        if ($id &gt; 0) {
            $stmt = $db-&gt;prepare(&quot;UPDATE services SET title=?, slug=?, description=?, icon=?, image_path=?, alt_text=?, sort_order=?, is_active=?, updated_at=NOW() WHERE id=?&quot;);
            $stmt-&gt;bind_param(&#039;ssssssiii&#039;, $title, $slug, $description, $icon, $image_path, $alt_text, $sort_order, $is_active, $id);
            $stmt-&gt;execute();
            admin_flash(&#039;Service updated.&#039;);
        } else {
            $stmt = $db-&gt;prepare(&quot;INSERT INTO services (title, slug, description, icon, image_path, alt_text, sort_order, is_active, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW())&quot;);
            $stmt-&gt;bind_param(&#039;ssssssii&#039;, $title, $slug, $description, $icon, $image_path, $alt_text, $sort_order, $is_active);
            $stmt-&gt;execute();
            admin_flash(&#039;Service created.&#039;);
        }
    } catch (Throwable $e) {
        admin_flash($e-&gt;getMessage(), &#039;error&#039;);
    }
    admin_redirect(&#039;services.php&#039;);
}

$edit = null;
if (!empty($_GET[&#039;edit&#039;]) &amp;&amp; $db) {
    $id = (int) $_GET[&#039;edit&#039;];
    $stmt = $db-&gt;prepare(&quot;SELECT * FROM services WHERE id = ?&quot;);
    $stmt-&gt;bind_param(&#039;i&#039;, $id);
    $stmt-&gt;execute();
    $edit = $stmt-&gt;get_result()-&gt;fetch_assoc();
}

$rows = [];
if ($db) {
    $result = $db-&gt;query(&quot;SELECT * FROM services ORDER BY sort_order ASC, id ASC&quot;);
    if ($result) {
        $rows = $result-&gt;fetch_all(MYSQLI_ASSOC);
    }
}
include __DIR__ . &#039;/includes/header.php&#039;;
?&gt;
&lt;section class=&quot;panel&quot;&gt;
    &lt;h2&gt;&lt;?= $edit ? &#039;Edit service&#039; : &#039;Create service&#039; ?&gt;&lt;/h2&gt;
    &lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
        &lt;?= csrf_field() ?&gt;
        &lt;input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;&lt;?= h((string) ($edit[&#039;id&#039;] ?? 0)) ?&gt;&quot;&gt;
        &lt;input type=&quot;hidden&quot; name=&quot;existing_image_path&quot; value=&quot;&lt;?= h($edit[&#039;image_path&#039;] ?? &#039;assets/img/ai-optimization.svg&#039;) ?&gt;&quot;&gt;
        &lt;div class=&quot;grid two&quot;&gt;
            &lt;label&gt;Title&lt;input name=&quot;title&quot; required value=&quot;&lt;?= h($edit[&#039;title&#039;] ?? &#039;&#039;) ?&gt;&quot;&gt;&lt;/label&gt;
            &lt;label&gt;Slug&lt;input name=&quot;slug&quot; value=&quot;&lt;?= h($edit[&#039;slug&#039;] ?? &#039;&#039;) ?&gt;&quot;&gt;&lt;/label&gt;
        &lt;/div&gt;
        &lt;label&gt;Description&lt;textarea name=&quot;description&quot; required&gt;&lt;?= h($edit[&#039;description&#039;] ?? &#039;&#039;) ?&gt;&lt;/textarea&gt;&lt;/label&gt;
        &lt;div class=&quot;grid three&quot;&gt;
            &lt;label&gt;Icon
                &lt;select name=&quot;icon&quot;&gt;
                    &lt;?php foreach ([&#039;ai&#039;,&#039;cooling&#039;,&#039;alerts&#039;,&#039;carbon&#039;,&#039;energy&#039;] as $icon): ?&gt;
                        &lt;option value=&quot;&lt;?= h($icon) ?&gt;&quot; &lt;?= ($edit[&#039;icon&#039;] ?? &#039;&#039;) === $icon ? &#039;selected&#039; : &#039;&#039; ?&gt;&gt;&lt;?= h($icon) ?&gt;&lt;/option&gt;
                    &lt;?php endforeach; ?&gt;
                &lt;/select&gt;
            &lt;/label&gt;
            &lt;label&gt;Image upload&lt;input type=&quot;file&quot; name=&quot;image&quot; accept=&quot;.jpg,.jpeg,.png,.webp&quot;&gt;&lt;/label&gt;
            &lt;label&gt;Sort order&lt;input type=&quot;number&quot; name=&quot;sort_order&quot; value=&quot;&lt;?= h((string) ($edit[&#039;sort_order&#039;] ?? 0)) ?&gt;&quot;&gt;&lt;/label&gt;
        &lt;/div&gt;
        &lt;label&gt;Alt text&lt;input name=&quot;alt_text&quot; value=&quot;&lt;?= h($edit[&#039;alt_text&#039;] ?? &#039;&#039;) ?&gt;&quot;&gt;&lt;/label&gt;
        &lt;label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;is_active&quot; value=&quot;1&quot; &lt;?= !isset($edit[&#039;is_active&#039;]) || (int) $edit[&#039;is_active&#039;] === 1 ? &#039;checked&#039; : &#039;&#039; ?&gt;&gt; Active&lt;/label&gt;
        &lt;button class=&quot;primary&quot; type=&quot;submit&quot;&gt;Save service&lt;/button&gt;
        &lt;?php if ($edit): ?&gt;&lt;a class=&quot;button&quot; href=&quot;services.php&quot;&gt;Cancel&lt;/a&gt;&lt;?php endif; ?&gt;
    &lt;/form&gt;
&lt;/section&gt;

&lt;section class=&quot;panel&quot;&gt;
    &lt;h2&gt;Services&lt;/h2&gt;
    &lt;div class=&quot;table-wrap&quot;&gt;
        &lt;table&gt;
            &lt;thead&gt;&lt;tr&gt;&lt;th&gt;Image&lt;/th&gt;&lt;th&gt;Title&lt;/th&gt;&lt;th&gt;Slug&lt;/th&gt;&lt;th&gt;Status&lt;/th&gt;&lt;th&gt;Order&lt;/th&gt;&lt;th&gt;Actions&lt;/th&gt;&lt;/tr&gt;&lt;/thead&gt;
            &lt;tbody&gt;
            &lt;?php foreach ($rows as $row): ?&gt;
                &lt;tr&gt;
                    &lt;td&gt;&lt;img src=&quot;../&lt;?= h($row[&#039;image_path&#039;]) ?&gt;&quot; alt=&quot;&quot;&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?= h($row[&#039;title&#039;]) ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?= h($row[&#039;slug&#039;]) ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?= (int) $row[&#039;is_active&#039;] === 1 ? &#039;Active&#039; : &#039;Hidden&#039; ?&gt;&lt;/td&gt;
                    &lt;td&gt;&lt;?= h((string) $row[&#039;sort_order&#039;]) ?&gt;&lt;/td&gt;
                    &lt;td class=&quot;actions&quot;&gt;
                        &lt;a class=&quot;button&quot; href=&quot;services.php?edit=&lt;?= (int) $row[&#039;id&#039;] ?&gt;&quot;&gt;Edit&lt;/a&gt;
                        &lt;form method=&quot;post&quot; data-confirm-delete&gt;&lt;?= csrf_field() ?&gt;&lt;input type=&quot;hidden&quot; name=&quot;action&quot; value=&quot;delete&quot;&gt;&lt;input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;&lt;?= (int) $row[&#039;id&#039;] ?&gt;&quot;&gt;&lt;button class=&quot;danger&quot; type=&quot;submit&quot;&gt;Delete&lt;/button&gt;&lt;/form&gt;
                    &lt;/td&gt;
                &lt;/tr&gt;
            &lt;?php endforeach; ?&gt;
            &lt;?php if (!$rows): ?&gt;&lt;tr&gt;&lt;td colspan=&quot;6&quot; class=&quot;muted&quot;&gt;No services found.&lt;/td&gt;&lt;/tr&gt;&lt;?php endif; ?&gt;
            &lt;/tbody&gt;
        &lt;/table&gt;
    &lt;/div&gt;
&lt;/section&gt;
&lt;?php include __DIR__ . &#039;/includes/footer.php&#039;; ?&gt;
</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/.trash/admin.1/services.php'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2F.trash%2Fadmin.1' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>