Add a button to the right of Toggle Grid / Preview Button in assign-template-blocks.php to open the Template Mega Menu.
assign-template-blocks.php
Assign Blocks to Template
Please log in to continue
You need to be logged in to request a proposal. Once you’re in, you’ll be brought right back here.
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);
$isSuper = (strtoupper($me['user_type'] ?? 'S') === 'A');
// --- Fetch template/menu/page labels (optional) ---
$stmt = $pdo->prepare("SELECT template_name FROM simeya_templates WHERE template_id=? AND user_code=?");
$stmt->execute([$template_id, $user_code]);
$template = $stmt->fetch();
$stmt = $pdo->prepare("SELECT menu_name FROM simeya_menus WHERE menu_id=? AND user_code=?");
$stmt->execute([$menu_id, $user_code]);
$menu = $stmt->fetch();
$stmt = $pdo->prepare("SELECT page_title FROM simeya_template_pages WHERE page_id=? AND template_id=?");
$stmt->execute([$page_id, $template_id]);
$page = $stmt->fetch();
include($_SERVER['DOCUMENT_ROOT'] . "/admin/add-template-menu-page.inc");
// Redirect to add GET params if missing
if (empty($_GET['template_id']) || empty($_GET['menu_id']) || empty($_GET['page_id'])) {
header("Location: assign-template-blocks.php?template_id=$template_id&menu_id=$menu_id&page_id=$page_id");
exit;
}
// --- Fetch User Templates/Menus/Pages ---
$stmt = $pdo->prepare("SELECT template_id, template_name FROM simeya_templates WHERE user_code=? ORDER BY created_at DESC");
$stmt->execute([$user_code]);
$templates = $stmt->fetchAll(PDO::FETCH_ASSOC);
$stmt = $pdo->prepare("SELECT menu_id, menu_name FROM simeya_menus WHERE user_code=? ORDER BY created_at DESC");
$stmt->execute([$user_code]);
$menus = $stmt->fetchAll(PDO::FETCH_ASSOC);
$stmt = $pdo->prepare("SELECT page_id, page_title FROM simeya_template_pages WHERE template_id=?");
$stmt->execute([$template_id]);
$pages = $stmt->fetchAll(PDO::FETCH_ASSOC);
// --- Pagination Setup ---
$per_page = 20;
$page_num = isset($_GET['pg']) ? max(1, intval($_GET['pg'])) : 1;
$offset = ($page_num - 1) * $per_page;
// --- Filters ---
$stmtFilters = $pdo->query("SELECT blocks FROM simeya_block_filters_master WHERE block_name='FILTERS' ORDER BY last_updated DESC LIMIT 1");
$filtersHTML = $stmtFilters->fetchColumn();
$filterTypes = $filtersHTML ? explode(',', $filtersHTML) : [];
$type = $_GET['type'] ?? '';
$whereClause = $type ? "sb.block_type = ?" : "sb.block_type NOT IN ('Head','Foot')";
$countStmt = $pdo->prepare("SELECT COUNT(*) FROM simeya_section_blocks sb WHERE $whereClause AND sb.block_status=1");
if ($type) $countStmt->execute([$type]); else $countStmt->execute();
$total_blocks = $countStmt->fetchColumn();
$total_pages = ceil($total_blocks / $per_page);
// --- Fetch Blocks (with membership flag) ---
$sql = "
SELECT DISTINCT sb.block_id, sb.block_type, sb.block_name, sb.block_content,
CASE WHEN utb.block_id IS NOT NULL THEN 1 ELSE 0 END AS is_added
FROM simeya_section_blocks sb
LEFT JOIN user_template_blocks utb
ON utb.block_id = sb.block_id AND utb.template_id = ?
WHERE $whereClause AND sb.block_status=1
ORDER BY sb.block_type, sb.block_name
LIMIT $per_page OFFSET $offset
";
/*
$sql = "
SELECT sb.block_id, sb.block_type, sb.block_name, sb.block_content,
CASE WHEN utb.block_id IS NOT NULL THEN 1 ELSE 0 END AS is_added
FROM simeya_section_blocks sb
LEFT JOIN user_template_blocks utb
ON utb.block_id = sb.block_id AND utb.template_id = ?
WHERE $whereClause AND sb.block_status=1
ORDER BY sb.block_type, sb.block_name
LIMIT $per_page OFFSET $offset
";
*/
$stmt = $pdo->prepare($sql);
if ($type) $stmt->execute([$template_id, $type]); else $stmt->execute([$template_id]);
$blocks = $stmt->fetchAll(PDO::FETCH_ASSOC);
$tmpName = $template['template_name'] ?? '';
?>
Simeya DIY Templates Manager
Choose a template to manage and assign blocks to it.
If the DIY Builder doesn’t fit your needs, the Custom option will.