catalog.php
<?php
// /admin/website_catalog.php
include $_SERVER['DOCUMENT_ROOT'].'/admin/pdo.inc';
include $_SERVER['DOCUMENT_ROOT'].'/includes/functions.inc';
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


// Require login
if (!isset($_COOKIE['SIM_id']) || !($SIMinfo = get_user_code())) {
  //exit('You need to log in.');
  
  $currentUrl = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS']=='on' ? 'https' : 'http').'://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
  $loginUrl   = '/login-app/auth/auth-modal.php?mode=login&return_url='.urlencode($currentUrl);
  
  ?>
  <div class="container center-wrap">
      <div class="card shadow-sm p-4">
        <h3 class="mb-2">Please log in to continue</h3>
        <p class="muted mb-3">You need to be logged in to request a proposal. Once you’re in, you’ll be brought right back here.</p>
        
        <button class="btn btn-primary mt-5">
            <a href="<?=$loginUrl ?>" class="btn btn-sm btn-secondary rounded text-white" 
             style="padding: 4px 5px 10px; font-size: 0.85rem; margin-right: 10px; height: 35px;">Log In</a>
        </button>


        </div>
    </div>
    <?
    exit;
}
$current_user_code = $SIMinfo['user_code'] ?? '';


$stmt = $pdo->prepare("SELECT user_code, user_type, first_name, last_name, email_address, company_name, phone_number
                       FROM simeya_users WHERE user_code=? LIMIT 1");
$stmt->execute([$current_user_code]);
$me = $stmt->fetch(PDO::FETCH_ASSOC);
//if (!$me) exit('User not found.');


$isSuper = (strtoupper($me['user_type'] ?? 'S') === 'A');




$entity = $_GET['entity'] ?? 'services'; // categories|services|addons
$action = $_GET['action'] ?? 'list';     // list|new|edit|save|delete
$id     = (int)($_GET['id'] ?? 0);
$msg    = $_GET['msg'] ?? '';


function h($s){ return htmlspecialchars($s ?? '', ENT_QUOTES, 'UTF-8'); }
function redirect_entity($e, $m=''){ header("Location: ?entity=$e".($m ? "&msg=".urlencode($m) : '')); exit; }


// ---------- POST handlers ----------
if ($_SERVER['REQUEST_METHOD']==='POST') {
  if ($entity==='categories' && $action==='save') {
    $id   = (int)($_POST['id'] ?? 0);
    $name = trim($_POST['name'] ?? '');
    $desc = trim($_POST['description'] ?? '');
    $act  = isset($_POST['is_active']) ? 1 : 0;
    $sort = (int)($_POST['sort_order'] ?? 0);


    if ($id) {
      $st=$pdo->prepare("UPDATE website_categories SET name=?, description=?, is_active=?, sort_order=? WHERE id=?");
      $st->execute([$name,$desc,$act,$sort,$id]);
      redirect_entity('categories','Category updated');
    } else {
      $st=$pdo->prepare("INSERT INTO website_categories (name,description,is_active,sort_order) VALUES (?,?,?,?)");
      $st->execute([$name,$desc,$act,$sort]);
      redirect_entity('categories','Category added');
    }
  }


  if ($entity==='services' && $action==='save') {
    $id    = (int)($_POST['id'] ?? 0);
    $cat   = (int)($_POST['category_id'] ?? 0);
    $name  = trim($_POST['name'] ?? '');
    $desc  = trim($_POST['short_desc'] ?? '');
    $price = (float)($_POST['base_price'] ?? 0);
    $note  = trim($_POST['price_note'] ?? '');
    $act   = isset($_POST['is_active']) ? 1 : 0;
    $sort  = (int)($_POST['sort_order'] ?? 0);


    if ($id) {
      $st=$pdo->prepare("UPDATE website_services SET category_id=?,name=?,short_desc=?,base_price=?,price_note=?,is_active=?,sort_order=? WHERE id=?");
      $st->execute([$cat,$name,$desc,$price,$note,$act,$sort,$id]);
      redirect_entity('services','Service updated');
    } else {
      $st=$pdo->prepare("INSERT INTO website_services (category_id,name,short_desc,base_price,price_note,is_active,sort_order) VALUES (?,?,?,?,?,?,?)");
      $st->execute([$cat,$name,$desc,$price,$note,$act,$sort]);
      redirect_entity('services','Service added');
    }
  }


  if ($entity==='addons' && $action==='save') {
    $id    = (int)($_POST['id'] ?? 0);
    $name  = trim($_POST['name'] ?? '');
    $desc  = trim($_POST['short_desc'] ?? '');
    $price = (float)($_POST['price'] ?? 0);
    $act   = isset($_POST['is_active']) ? 1 : 0;
    $sort  = (int)($_POST['sort_order'] ?? 0);


    if ($id) {
      $st=$pdo->prepare("UPDATE website_service_addons SET name=?,short_desc=?,price=?,is_active=?,sort_order=? WHERE id=?");
      $st->execute([$name,$desc,$price,$act,$sort,$id]);
      redirect_entity('addons','Add-on updated');
    } else {
      $st=$pdo->prepare("INSERT INTO website_service_addons (name,short_desc,price,is_active,sort_order) VALUES (?,?,?,?,?)");
      $st->execute([$name,$desc,$price,$act,$sort]);
      redirect_entity('addons','Add-on added');
    }
  }
}


// ---------- Delete handlers ----------
if ($action==='delete' && $id) {
  if ($entity==='categories') {
    $pdo->prepare("DELETE FROM website_categories WHERE id=?")->execute([$id]);
    redirect_entity('categories','Category deleted');
  }
  if ($entity==='services') {
    $pdo->prepare("DELETE FROM website_services WHERE id=?")->execute([$id]);
    redirect_entity('services','Service deleted');
  }
  if ($entity==='addons') {
    $pdo->prepare("DELETE FROM website_service_addons WHERE id=?")->execute([$id]);
    redirect_entity('addons','Add-on deleted');
  }
}


// ---------- Load lists ----------
$cats = $pdo->query("SELECT * FROM website_categories ORDER BY sort_order, name")->fetchAll(PDO::FETCH_ASSOC);
$srvc = $pdo->query("SELECT s.*, c.name AS cat_name
                     FROM website_services s
                     LEFT JOIN website_categories c ON c.id=s.category_id
                     ORDER BY s.sort_order, s.name")->fetchAll(PDO::FETCH_ASSOC);
$adds = $pdo->query("SELECT * FROM website_service_addons ORDER BY sort_order, name")->fetchAll(PDO::FETCH_ASSOC);


// ---------- Load one row for edit/new ----------
$row = null;
$isNew = ($action==='new');


if ($action==='edit' && $id) {
  if ($entity==='categories') {
    $st=$pdo->prepare("SELECT * FROM website_categories WHERE id=?"); $st->execute([$id]); $row=$st->fetch(PDO::FETCH_ASSOC);
  } elseif ($entity==='services') {
    $st=$pdo->prepare("SELECT * FROM website_services WHERE id=?"); $st->execute([$id]); $row=$st->fetch(PDO::FETCH_ASSOC);
  } else {
    $st=$pdo->prepare("SELECT * FROM website_service_addons WHERE id=?"); $st->execute([$id]); $row=$st->fetch(PDO::FETCH_ASSOC);
  }
}
if ($isNew) { $row = []; } // blank form
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Website Catalog Admin</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
<style>
  .tab a{ text-decoration:none }
  .sticky-form{ position:sticky; top:10px; z-index:10 }
  .form-switch .form-check-input { cursor: pointer; }
</style>
</head>
<body class="bg-light">    


    <h1 class="text-center mb-3">Simeya Catalog Manager</h1>
  
<div class="container py-4">


    <?php
    include($_SERVER['DOCUMENT_ROOT'].'/templates/website/header-app.php');
    ?>
    
      <h3 class="mb-3">Website Catalog Admin</h3>


      <?php if ($msg): ?>
        <div class="alert alert-success py-2"><?= h($msg) ?></div>
      <?php endif; ?>


    
      <ul class="nav nav-tabs mb-3">
        <!--<li class="nav-item"><a class="nav-link" href="/">Home</a></li>-->
  
        <li class="nav-item tab"><a class="nav-link <?= $entity==='categories'?'active':'' ?>" href="?entity=categories">Categories</a></li>
        <li class="nav-item tab"><a class="nav-link <?= $entity==='services'?'active':'' ?>" href="?entity=services">Services</a></li>
        <li class="nav-item tab"><a class="nav-link <?= $entity==='addons'?'active':'' ?>" href="?entity=addons">Add-ons</a></li>
          <!--<li class="nav-item"><a class="nav-link" href="/templates/website/proposal.php">Proposals</a></li>-->
      </ul>


    
      <?php
      // ====== CATEGORIES ======
      if ($entity==='categories'):
          ?>
        <div class="d-flex justify-content-between align-items-center mb-2">
              <h5 class="mb-0"><?= $isNew || $action==='edit' ? ($isNew ? 'Add Category' : 'Edit Category') : 'Categories' ?></h5>
              <a class="btn btn-sm btn-primary" href="?entity=categories&action=new">+ Add Category</a>
        </div>


        <?php if ($isNew || $action==='edit'): ?>
              <div class="card shadow-sm mb-3 sticky-form">
                <div class="card-body">
                      <form method="post" action="?entity=categories&action=save">
                        <input type="hidden" name="id" value="<?= (int)($row['id'] ?? 0) ?>">
                        <div class="row g-2">
                              <div class="col-md-3"><input autofocus class="form-control" name="name" placeholder="Category name" value="<?= h($row['name'] ?? '') ?>" required></div>
                              <div class="col-md-5"><input class="form-control" name="description" placeholder="Description" value="<?= h($row['description'] ?? '') ?>"></div>
                              <div class="col-md-2"><input class="form-control" name="sort_order" type="number" placeholder="Sort" value="<?= h($row['sort_order'] ?? 0) ?>"></div>
                              <div class="col-md-2"><div class="form-check form-switch mt-1">
                            <input     class="form-check-input" type="checkbox" name="is_active" <?= !isset($row['is_active']) || !empty($row['is_active']) ? 'checked':''; ?>> Active
                          </div>
                      </div>
                </div>
                <div class="mt-2 d-flex gap-2">
                      <button class="btn btn-primary">Save</button>
                      <a class="btn btn-outline-secondary" href="?entity=categories">Cancel</a>
                </div>
              </form>
          
          <div class="card shadow-sm mb-3 sticky-form">
        <div class="card-body">
          <form method="post" action="?entity=categories&action=save">
            <input type="hidden" name="id" value="<?= (int)($row['id'] ?? 0) ?>">
            <div class="row g-2">
              <div class="col-md-3"><input autofocus class="form-control" name="name" placeholder="Category name" value="<?= h($row['name'] ?? '') ?>" required></div>
              <div class="col-md-5"><input class="form-control" name="description" placeholder="Description" value="<?= h($row['description'] ?? '') ?>"></div>
              <div class="col-md-2"><input class="form-control" name="sort_order" type="number" placeholder="Sort" value="<?= h($row['sort_order'] ?? 0) ?>"></div>
              <div class="col-md-2"><div class="form-check form-switch mt-1">
                <input class="form-check-input" type="checkbox" name="is_active" <?= !isset($row['is_active']) || !empty($row['is_active']) ? 'checked':''; ?>> Active
              </div></div>
            </div>
            <div class="mt-2 d-flex gap-2">
              <button class="btn btn-primary">Save</button>
              <a class="btn btn-outline-secondary" href="?entity=categories">Cancel</a>
            </div>
          </form>
        </div>
      </div>
        </div>
      </div>
    <?php endif; ?>


    <table class="table table-sm table-bordered bg-white align-middle">
      <thead><tr><th>ID</th><th>Name</th><th>Description</th><th>Sort</th><th>Active</th><th class="text-end">Actions</th></tr></thead>
      <tbody>
      <?php foreach ($cats as $c): ?>
        <tr>
          <td><?= (int)$c['id'] ?></td>
          <td><?= h($c['name']) ?></td>
          <td><?= h($c['description']) ?></td>
          <td><?= (int)$c['sort_order'] ?></td>
          <td>
            <div class="form-check form-switch m-0">
              <input class="form-check-input js-toggle-active" type="checkbox"
                     data-entity="categories" data-id="<?= (int)$c['id'] ?>"
                     <?= $c['is_active'] ? 'checked' : '' ?>>
            </div>
          </td>
          <td class="text-end">
            <a class="btn btn-sm btn-outline-secondary" href="?entity=categories&action=edit&id=<?= (int)$c['id'] ?>">Edit</a>
            <a class="btn btn-sm btn-outline-danger" href="?entity=categories&action=delete&id=<?= (int)$c['id'] ?>" onclick="return confirm('Delete category?')">Delete</a>
          </td>
        </tr>
      <?php endforeach; ?>
      </tbody>
    </table>
  <?php endif; ?>


  <?php
  // ====== SERVICES ======
  if ($entity==='services'):
  ?>
    <div class="d-flex justify-content-between align-items-center mb-2">
      <h5 class="mb-0"><?= $isNew || $action==='edit' ? ($isNew ? 'Add Service' : 'Edit Service') : 'Services' ?></h5>
      <a class="btn btn-sm btn-primary" href="?entity=services&action=new">+ Add Service</a>
    </div>


    <?php if ($isNew || $action==='edit'): ?>
      <div class="card shadow-sm mb-3 sticky-form">
        <div class="card-body">
          <form method="post" action="?entity=services&action=save">
            <input type="hidden" name="id" value="<?= (int)($row['id'] ?? 0) ?>">
            <div class="row g-2">
              <div class="col-md-2">
                <select class="form-select" name="category_id" required>
                  <option value="">Category…</option>
                  <?php foreach ($cats as $c): ?>
                    <option value="<?= (int)$c['id'] ?>" <?= isset($row['category_id']) && $row['category_id']==$c['id']?'selected':''; ?>>
                      <?= h($c['name']) ?>
                    </option>
                  <?php endforeach; ?>
                </select>
              </div>
              <div class="col-md-3"><input autofocus class="form-control" name="name" placeholder="Service name" value="<?= h($row['name'] ?? '') ?>" required></div>
              <div class="col-md-3"><input class="form-control" name="short_desc" placeholder="Short description" value="<?= h($row['short_desc'] ?? '') ?>"></div>
              <div class="col-md-2"><input class="form-control" name="base_price" type="number" step="0.01" placeholder="Price" value="<?= h($row['base_price'] ?? 0) ?>"></div>
              <div class="col-md-1"><input class="form-control" name="sort_order" type="number" placeholder="Sort" value="<?= h($row['sort_order'] ?? 0) ?>"></div>
              <div class="col-md-1"><div class="form-check form-switch mt-1">
                <input class="form-check-input" type="checkbox" name="is_active" <?= !isset($row['is_active']) || !empty($row['is_active']) ? 'checked':''; ?>> Active
              </div></div>
            </div>
            <div class="row g-2 mt-2">
              <div class="col-md-10"><input class="form-control" name="price_note" placeholder="Price note (e.g. 'From')" value="<?= h($row['price_note'] ?? '') ?>"></div>
              <div class="col-md-2 d-flex gap-2">
                <button class="btn btn-primary w-100">Save</button>
                <a class="btn btn-outline-secondary w-100" href="?entity=services">Cancel</a>
              </div>
            </div>
          </form>
          <?php if (empty($cats)): ?>
            <div class="alert alert-warning mt-2">No categories yet — add a category first.</div>
          <?php endif; ?>
        </div>
      </div>
    <?php endif; ?>


    <table class="table table-sm table-bordered bg-white align-middle">
      <thead><tr><th>ID</th><th>Category</th><th>Name</th><th>Short Desc</th><th>Price</th><th>Sort</th><th>Active</th><th class="text-end">Actions</th></tr></thead>
      <tbody>
      <?php foreach ($srvc as $s): ?>
        <tr>
          <td><?= (int)$s['id'] ?></td>
          <td><?= h($s['cat_name']) ?></td>
          <td><?= h($s['name']) ?></td>
          <td><?= h($s['short_desc']) ?></td>
          <td>$<?= number_format((float)$s['base_price'],2) ?></td>
          <td><?= (int)$s['sort_order'] ?></td>
          <td>
            <div class="form-check form-switch m-0">
              <input class="form-check-input js-toggle-active" type="checkbox"
                     data-entity="services" data-id="<?= (int)$s['id'] ?>"
                     <?= $s['is_active'] ? 'checked' : '' ?>>
            </div>
          </td>
          <td class="text-end">
            <a class="btn btn-sm btn-outline-secondary" href="?entity=services&action=edit&id=<?= (int)$s['id'] ?>">Edit</a>
            <a class="btn btn-sm btn-outline-danger" href="?entity=services&action=delete&id=<?= (int)$s['id'] ?>" onclick="return confirm('Delete service?')">Delete</a>
          </td>
        </tr>
      <?php endforeach; ?>
      </tbody>
    </table>
  <?php endif; ?>


  <?php
  // ====== ADD-ONS ======
  if ($entity==='addons'):
  ?>
    <div class="d-flex justify-content-between align-items-center mb-2">
      <h5 class="mb-0"><?= $isNew || $action==='edit' ? ($isNew ? 'Add Add-on' : 'Edit Add-on') : 'Add-ons' ?></h5>
      <a class="btn btn-sm btn-primary" href="?entity=addons&action=new">+ Add Add-on</a>
    </div>


    <?php if ($isNew || $action==='edit'): ?>
      <div class="card shadow-sm mb-3 sticky-form">
        <div class="card-body">
          <form method="post" action="?entity=addons&action=save">
            <input type="hidden" name="id" value="<?= (int)($row['id'] ?? 0) ?>">
            <div class="row g-2">
              <div class="col-md-3"><input autofocus class="form-control" name="name" placeholder="Add-on name" value="<?= h($row['name'] ?? '') ?>" required></div>
              <div class="col-md-4"><input class="form-control" name="short_desc" placeholder="Short description" value="<?= h($row['short_desc'] ?? '') ?>"></div>
              <div class="col-md-2"><input class="form-control" name="price" type="number" step="0.01" placeholder="Price" value="<?= h($row['price'] ?? 0) ?>"></div>
              <div class="col-md-1"><input class="form-control" name="sort_order" type="number" placeholder="Sort" value="<?= h($row['sort_order'] ?? 0) ?>"></div>
              <div class="col-md-1"><div class="form-check form-switch mt-1">
                <input class="form-check-input" type="checkbox" name="is_active" <?= !isset($row['is_active']) || !empty($row['is_active']) ? 'checked':''; ?>> Active
              </div></div>
            </div>
            <div class="mt-2 d-flex gap-2">
              <button class="btn btn-primary">Save</button>
              <a class="btn btn-outline-secondary" href="?entity=addons">Cancel</a>
            </div>
          </form>
        </div>
      </div>
    <?php endif; ?>


    <table class="table table-sm table-bordered bg-white align-middle">
      <thead><tr><th>ID</th><th>Name</th><th>Short Desc</th><th>Price</th><th>Sort</th><th>Active</th><th class="text-end">Actions</th></tr></thead>
      <tbody>
      <?php foreach ($adds as $a): ?>
        <tr>
          <td><?= (int)$a['id'] ?></td>
          <td><?= h($a['name']) ?></td>
          <td><?= h($a['short_desc']) ?></td>
          <td>$<?= number_format((float)$a['price'],2) ?></td>
          <td><?= (int)$a['sort_order'] ?></td>
          <td>
            <div class="form-check form-switch m-0">
              <input class="form-check-input js-toggle-active" type="checkbox"
                     data-entity="addons" data-id="<?= (int)$a['id'] ?>"
                     <?= $a['is_active'] ? 'checked' : '' ?>>
            </div>
          </td>
          <td class="text-end">
            <a class="btn btn-sm btn-outline-secondary" href="?entity=addons&action=edit&id=<?= (int)$a['id'] ?>">Edit</a>
            <a class="btn btn-sm btn-outline-danger" href="?entity=addons&action=delete&id=<?= (int)$a['id'] ?>" onclick="return confirm('Delete add-on?')">Delete</a>
          </td>
        </tr>
      <?php endforeach; ?>
      </tbody>
    </table>
  <?php endif; ?>


</div>


<script>
document.addEventListener('click', async (e) => {
  const sw = e.target.closest('.js-toggle-active');
  if (!sw) return;


  const entity = sw.dataset.entity; // categories|services|addons
  const id     = sw.dataset.id;
  const active = sw.checked ? 1 : 0;


  try {
    const resp = await fetch('/admin/ajax_toggle_catalog.php', {
      method: 'POST',
      headers: { 'Content-Type':'application/x-www-form-urlencoded' },
      body: new URLSearchParams({ entity, id, active })
    });
    const txt = await resp.text();
    if (txt.trim() !== 'ok') {
      alert('Toggle failed: ' + txt);
      sw.checked = !sw.checked; // revert UI
    }
  } catch (err) {
    alert('Network error: ' + err);
    sw.checked = !sw.checked;
  }
});


// Auto-scroll to the edit/new form
(function(){
  const params = new URLSearchParams(location.search);
  const action = params.get('action');
  if (action === 'new' || action === 'edit') {
    const sticky = document.querySelector('.sticky-form input[autofocus]');
    if (sticky) { sticky.focus(); }
    window.scrollTo({ top: 0, behavior: 'smooth' });
  }
})();
</script>
</body>
</html>


proposal.php
 <?php
// /templates/website/survey.php
include($_SERVER['DOCUMENT_ROOT'].'/admin/pdo.inc');
include($_SERVER['DOCUMENT_ROOT'].'/includes/functions.inc');


?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Simeya – Web App Service Request</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">
<style>
  .price-badge { font-size:.85rem; }
  .sticky-summary{ position:sticky; top:1rem; }
  .lookup-wrap{ position:relative }
  .lookup-results{
    position:absolute; top:100%; left:0; right:0; z-index:1000;
    background:#fff; border:1px solid #ddd; border-top:none; max-height:240px; overflow:auto; display:none;
  }
  .lookup-item{ padding:8px 10px; cursor:pointer; }
  .lookup-item:hover{ background:#f6f6f6; }
  .muted{ color:#6c757d; font-size:.9em }
</style>
</head>


<?php
// Require login
if (!isset($_COOKIE['SIM_id']) || !($SIMinfo = get_user_code())) {
  //exit('You need to log in.');
  
  $currentUrl = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS']=='on' ? 'https' : 'http').'://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
  $loginUrl   = '/login-app/auth/auth-modal.php?mode=login&return_url='.urlencode($currentUrl);
  
  ?>
  <div class="container center-wrap">
      <div class="card shadow-sm p-4">
        <h3 class="mb-2">Please log in to continue</h3>
        <p class="muted mb-3">You need to be logged in to request a proposal. Once you’re in, you’ll be brought right back here.</p>
        
        <button class="btn btn-primary mt-5">
            <a href="<?=$loginUrl ?>" class="btn btn-sm btn-secondary rounded text-white" 
             style="padding: 4px 5px 10px; font-size: 0.85rem; margin-right: 10px; height: 35px;">Log In</a>
        </button>


        </div>
    </div>
    <?
    exit;
}
$current_user_code = $SIMinfo['user_code'] ?? '';


$stmt = $pdo->prepare("SELECT user_code, user_type, first_name, last_name, email_address, company_name, phone_number
                       FROM simeya_users WHERE user_code=? LIMIT 1");
$stmt->execute([$current_user_code]);
$me = $stmt->fetch(PDO::FETCH_ASSOC);
//if (!$me) exit('User not found.');


$isSuper = (strtoupper($me['user_type'] ?? 'S') === 'A');


// Default “target” user = self
$target = $me;


// Fetch categories, services, addons
$cats = $pdo->query("SELECT id,name,description FROM website_service_categories WHERE is_active=1 ORDER BY sort_order, name")->fetchAll(PDO::FETCH_ASSOC);


$svcStmt = $pdo->query("
  SELECT s.id, s.category_id, s.name, s.short_desc, s.base_price, s.price_note
  FROM website_services s
  JOIN website_service_categories c ON c.id=s.category_id AND c.is_active=1
  WHERE s.is_active=1
  ORDER BY c.sort_order, s.sort_order, s.name
");
$services = $svcStmt->fetchAll(PDO::FETCH_ASSOC);


$addOns = $pdo->query("SELECT id,name,short_desc,price FROM website_service_addons WHERE is_active=1 ORDER BY sort_order, name")->fetchAll(PDO::FETCH_ASSOC);


// Group services by category
$svcByCat = [];
foreach ($services as $s) $svcByCat[$s['category_id']][] = $s;


function h($s){ return htmlspecialchars($s ?? '', ENT_QUOTES, 'UTF-8'); }
$prefName  = trim(($target['first_name'] ?? '').' '.($target['last_name'] ?? ''));
$prefEmail = $target['email_address'] ?? '';
$prefComp  = $target['company_name'] ?? '';
$prefPhone = $target['phone_number'] ?? '';
?>
<body class="bg-light">


    <h1 class="text-center mb-3">Simeya Propposal Request</h1>
  
<div class="container py-4">
    <?php
    include($_SERVER['DOCUMENT_ROOT'].'/templates/website/header-app.php');
    ?>
             
  <h1 class="mb-3">Web Application Service Request</h1>
  <p class="text-muted">Select the services you need. We’ll generate a proposal instantly.</p>


    <ul class="nav nav-tabs mb-3">
        <!--<li class="nav-item"><a class="nav-link" href="/">Home</a></li>-->
  
        <li class="nav-item tab"><a class="nav-link <?= $entity==='categories'?'active':'' ?>" href="/templates/website/proposals.php">Proposals</a></li>
        <li class="nav-item tab"><a class="nav-link <?= $entity==='services'?'active':'' ?>" href="/templates/website/proposals_manage.php">Manage Proposals</a></li>
        <!--<li class="nav-item"><a class="nav-link" href="/templates/website/proposal.php">Proposals</a></li>-->
      </ul>
  <form id="surveyForm" action="/templates/website/proposal_submit.php" method="post">
    <!-- proposal stored for this user_code; super can change via lookup -->
    <input type="hidden" name="for_user_code" id="for_user_code" value="<?= h($current_user_code) ?>">
    <!-- who is submitting (always logged-in user) -->
    <input type="hidden" name="submitted_by" value="<?= h($current_user_code) ?>">
    <?php if ($isSuper): ?>
    
      <div class="card mb-4">
        <div class="card-header">Select Client (Super User)</div>
        <div class="card-body">
          <div class="lookup-wrap">
            <label class="form-label">Find user by name / email / company</label>
            <input type="text" id="userLookup" class="form-control" placeholder="Type at least 2 characters…">
            <div id="lookupResults" class="lookup-results"></div>
            <div class="form-text">Start typing; click a result to prefill the form for that user.</div>
          </div>
        </div>
      </div>
    <?php endif; ?>


    <!-- General info -->
    <div class="card mb-4">
      <div class="card-header display-6">General Information</div>
      <div class="card-body row g-3">
        <div class="col-md-6">
          <label class="form-label text-black display-7">Your Name</label>
          <input class="form-control" name="client_name" id="client_name" value="<?= h($prefName) ?>" required>
        </div>
        <div class="col-md-6">
          <label class="form-label">Company / Organization</label>
          <input class="form-control" name="company_name" id="company_name" value="<?= h($prefComp) ?>">
        </div>
        <div class="col-md-6">
          <label class="form-label">Email</label>
          <input type="email" class="form-control" name="email" id="email" value="<?= h($prefEmail) ?>" required>
        </div>
        <div class="col-md-6">
          <label class="form-label">Phone</label>
          <input class="form-control" name="phone" id="phone" value="<?= h($prefPhone) ?>">
        </div>
        <div class="col-md-6">
          <label class="form-label">Current Website (optional)</label>
          <input class="form-control" name="website" placeholder="https://example.com">
        </div>


        <div class="block-content col-12">
          <label class="form-label">Brief Project Description</label>
          <textarea id="editor1" name="project_desc" cols="30" rows="10"></textarea>
        </div>
      </div>
    </div>


    <div class="row">
      <!-- Left: services -->
      <div class="col-lg-8">


        <!-- Categories + services -->
        <?php foreach ($cats as $cat): ?>
          <?php
            $catId    = (int)$cat['id'];
            $panelId  = 'cat'.$catId;
            $btnId    = 'toggle_'.$panelId;
          ?>
          <div class="card mb-3">
            <div class="card-header d-flex justify-content-between align-items-center">
              <div class="display-6">
                <strong><?= h($cat['name']) ?></strong>
                <?php if (!empty($cat['description'])): ?>
                  <div class="small text-muted"><?= h($cat['description']) ?></div>
                <?php endif; ?>
              </div>
              <button
                type="button"
                class="btn btn-sm btn-outline-secondary toggle-btn"
                id="<?= $btnId ?>"
                data-target="#<?= $panelId ?>"
                data-storage-key="wb_cat_<?= $catId ?>"
              >Hide</button>
            </div>
            <div id="<?= $panelId ?>" class="collapse show">
              <div class="list-group list-group-flush">
                <?php if (!empty($svcByCat[$catId])): ?>
                  <?php foreach ($svcByCat[$catId] as $svc): ?>
                    <label class="list-group-item d-flex align-items-start gap-2">
                      <input class="form-check-input mt-1 service-check"
                             type="checkbox"
                             name="services[]"
                             value="<?= (int)$svc['id'] ?>"
                             data-price="<?= number_format($svc['base_price'],2,'.','') ?>">
                      <div class="w-100">
                        <div class="d-flex justify-content-between">
                          <div>
                            <div class="fw-medium"><?= h($svc['name']) ?></div>
                            <?php if ($svc['short_desc']): ?>
                              <div class="small text-muted"><?= h($svc['short_desc']) ?></div>
                            <?php endif; ?>
                          </div>
                          <span class="badge bg-primary-subtle text-primary-emphasis price-badge">
                            $<?= number_format($svc['base_price'],2) ?><?= $svc['price_note'] ? ' <small>('.h($svc['price_note']).')</small>' : '' ?>
                          </span>
                        </div>
                      </div>
                    </label>
                  <?php endforeach; ?>
                <?php else: ?>
                  <div class="p-3 text-muted">No services in this category yet.</div>
                <?php endif; ?>
              </div>
            </div>
          </div>
        <?php endforeach; ?>


        <!-- Add-ons -->
        <div class="card mb-3">
          <div class="card-header d-flex justify-content-between align-items-center">
            <div class="display-6">Add-ons</div>
            <button
              type="button"
              class="btn btn-sm btn-outline-secondary toggle-btn"
              id="toggle_addons"
              data-target="#addonsPanel"
              data-storage-key="wb_addons"
            >Hide</button>
          </div>
          <div id="addonsPanel" class="collapse show">
            <div class="list-group list-group-flush">
              <?php foreach ($addOns as $a): ?>
                <label class="list-group-item d-flex align-items-start gap-2">
                  <input class="form-check-input mt-1 addon-check"
                         type="checkbox"
                         name="addons[]"
                         value="<?= (int)$a['id'] ?>"
                         data-price="<?= number_format($a['price'],2,'.','') ?>">
                  <div class="w-100 d-flex justify-content-between">
                    <div>
                      <div class="fw-medium"><?= h($a['name']) ?></div>
                      <?php if ($a['short_desc']): ?>
                        <div class="small text-muted"><?= h($a['short_desc']) ?></div>
                      <?php endif; ?>
                    </div>
                    <span class="badge bg-success-subtle text-success-emphasis price-badge">
                      $<?= number_format($a['price'],2) ?>
                    </span>
                  </div>
                </label>
              <?php endforeach; ?>
            </div>
          </div>
        </div>


        <!-- Budget & timeline -->
        <div class="card mb-4">
          <div class="card-header display-6">Budget & Timeline</div>
          <div class="card-body row g-3">
            <div class="col-md-6">
              <label class="form-label">Budget Range</label>
              <select class="form-select" name="budget_range" required>
                <option value="" hidden>Select</option>
                <option>Under $1,000</option>
                <option>$1,000–$3,000</option>
                <option>$3,000–$5,000</option>
                <option>$5,000+</option>
              </select>
            </div>
            <div class="col-md-6">
              <label class="form-label">Timeline</label>
              <select class="form-select" name="timeline" required>
                <option value="" hidden>Select</option>
                <option>Urgent (2–4 weeks)</option>
                <option>Short-Term (1–3 months)</option>
                <option>Flexible (3–6 months)</option>
              </select>
            </div>
          </div>
        </div>


      </div>


      <!-- Right: Summary -->
      <div class="col-lg-4">
        <div class="card sticky-summary">
          <div class="card-header display-6">Summary</div>
          <div class="card-body">
            <div class="d-flex justify-content-between">
              <span>Services Subtotal</span>
              <strong id="sumServices">$0.00</strong>
            </div>
            <div class="d-flex justify-content-between">
              <span>Add-ons</span>
              <strong id="sumAddons">$0.00</strong>
            </div>
            <hr>
            <div class="d-flex justify-content-between fs-5">
              <span>Total</span>
              <strong id="sumTotal">$0.00</strong>
            </div>
            <input type="hidden" name="subtotal" id="subtotalHidden">
            <input type="hidden" name="addons_total" id="addonsHidden">
            <input type="hidden" name="grand_total" id="grandHidden">
          </div>
          <div class="card-footer text-end">
            <button class="btn btn-primary">Generate Proposal</button>
          </div>
        </div>
      </div>
    </div>
  </form>
</div>


<!-- CKEditor -->
<script src="/backend/assets/js/ckeditor/ckeditor.js"></script>
<script src="/backend/assets/js/ckeditor/styles.js"></script>
<script src="/backend/assets/js/ckeditor/ckeditor.custom.js"></script>


<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>
<script>
(function(){
  // === Summary calculator ===
  const svcChecks = document.querySelectorAll('.service-check');
  const addonChecks = document.querySelectorAll('.addon-check');
  const sumServices = document.getElementById('sumServices');
  const sumAddons   = document.getElementById('sumAddons');
  const sumTotal    = document.getElementById('sumTotal');
  const hSubtotal   = document.getElementById('subtotalHidden');
  const hAddons     = document.getElementById('addonsHidden');
  const hGrand      = document.getElementById('grandHidden');


  function recalc(){
    let s=0, a=0;
    svcChecks.forEach(cb => { if (cb.checked) s += parseFloat(cb.dataset.price||0); });
    addonChecks.forEach(cb => { if (cb.checked) a += parseFloat(cb.dataset.price||0); });
    const g = s + a;
    sumServices.textContent = '$' + s.toFixed(2);
    sumAddons.textContent   = '$' + a.toFixed(2);
    sumTotal.textContent    = '$' + g.toFixed(2);
    hSubtotal.value = s.toFixed(2);
    hAddons.value   = a.toFixed(2);
    hGrand.value    = g.toFixed(2);
  }
  document.addEventListener('change', (e)=>{
    if (e.target.classList.contains('service-check') || e.target.classList.contains('addon-check')) recalc();
  });
  recalc();


  // === Super user client lookup ===
  const lookup = document.getElementById('userLookup');
  const results = document.getElementById('lookupResults');
  const forUser = document.getElementById('for_user_code');


  const fName  = document.getElementById('client_name');
  const fEmail = document.getElementById('email');
  const fComp  = document.getElementById('company_name');
  const fPhone = document.getElementById('phone');


  if (lookup) {
    let timer = null;
    lookup.addEventListener('input', function(){
      const q = this.value.trim();
      clearTimeout(timer);
      if (q.length < 2) { results.style.display='none'; results.innerHTML=''; return; }
      timer = setTimeout(()=> doSearch(q), 250);
    });


    function doSearch(q){
      fetch('/templates/website/ajax_user_search.php?q=' + encodeURIComponent(q))
        .then(r=>r.ok?r.json():[])
        .then(list=>{
          if (!Array.isArray(list) || list.length===0) {
            results.innerHTML = '<div class="lookup-item muted">No matches</div>';
            results.style.display = 'block';
            return;
          }
          results.innerHTML = list.map(u => `
            <div class="lookup-item" data-code="${u.user_code}"
                 data-name="${(u.first_name||'')+' '+(u.last_name||'')}"
                 data-email="${u.email_address||''}"
                 data-company="${u.company_name||''}"
                 data-phone="${u.phone_number||''}">
              <div><strong>${escapeHtml((u.first_name||'')+' '+(u.last_name||''))}</strong> &lt;${escapeHtml(u.email_address||'')}>&nbsp;</div>
              <div class="muted">${escapeHtml(u.company_name||'')} ${u.phone_number?'• '+escapeHtml(u.phone_number):''}</div>
            </div>
          `).join('');
          results.style.display = 'block';
        })
        .catch(()=>{ results.style.display='none'; });
    }


    results.addEventListener('click', function(e){
      const item = e.target.closest('.lookup-item');
      if (!item) return;
      const code = item.dataset.code;
      const name = item.dataset.name || '';
      const email= item.dataset.email || '';
      const comp = item.dataset.company || '';
      const phone= item.dataset.phone || '';


      forUser.value = code;
      fName.value   = name.trim();
      fEmail.value  = email;
      fComp.value   = comp;
      fPhone.value  = phone;


      lookup.value = name + ' <' + email + '>';
      results.style.display = 'none';
      results.innerHTML = '';
    });


    document.addEventListener('click', (e)=>{
      if (!results.contains(e.target) && e.target !== lookup) results.style.display='none';
    });


    function escapeHtml(s){
      return (s||'').replace(/[&<>"']/g, m => ({'&':'&amp;','<':'&lt;','>':'&gt;','"':'&quot;',"'":'&#039;'}[m]));
    }
  }


  // === Show/Hide + remember state (categories & add-ons) ===
  // Uses Bootstrap Collapse but manages button label + localStorage.
  document.querySelectorAll('.toggle-btn').forEach(btn=>{
    const targetSel = btn.getAttribute('data-target');
    const key       = btn.getAttribute('data-storage-key') || ('wb_section_' + targetSel);
    const target    = document.querySelector(targetSel);
    if (!target) return;


    // Create collapse instance without immediate toggle
    const coll = new bootstrap.Collapse(target, { toggle:false });


    // Restore state
    const saved = localStorage.getItem(key); // 'open' | 'closed' | null
    if (saved === 'closed') {
      coll.hide();
      btn.textContent = 'Show';
    } else {
      coll.show();
      btn.textContent = 'Hide';
    }


    // Click handler: toggle + save
    btn.addEventListener('click', ()=>{
      const isShown = target.classList.contains('show');
      if (isShown) {
        coll.hide();
        btn.textContent = 'Show';
        localStorage.setItem(key, 'closed');
      } else {
        coll.show();
        btn.textContent = 'Hide';
        localStorage.setItem(key, 'open');
      }
    });


    // Also update on collapse events (e.g., if toggled elsewhere)
    target.addEventListener('shown.bs.collapse', ()=>{
      btn.textContent = 'Hide';
      localStorage.setItem(key, 'open');
    });
    target.addEventListener('hidden.bs.collapse', ()=>{
      btn.textContent = 'Show';
      localStorage.setItem(key, 'closed');
    });
  });
})();
</script>
</body>
</html>