/var/www/silverpalace.in/public_html/src/app/model/View.php
$data = $this->get("SELECT fo.id, fo.name, f.id AS filter_id, f.name AS filter_name
FROM product_filters pf
INNER JOIN products p ON p.id = pf.product
INNER JOIN filter_options fo ON fo.id = pf.filter_option
INNER JOIN filters f ON f.id = fo.filter
WHERE p.category = ? AND p.status = 2
ORDER BY f.name", [ $id ]);
}
$r = [];
foreach ($data as $row) {
$r['f'][$row['filter_id']]['id'] = $row["filter_id"];
$r['f'][$row['filter_id']]['name'] = $row["filter_name"];
$r['f'][$row['filter_id']]['options'][$row['id']]['id'] = $row["id"];
$r['f'][$row['filter_id']]['options'][$row['id']]['name'] = $row["name"];
}
return $r;
}
function categoryProducts($id, $slug, $page) {
$start = ($page-1) * 30;
$ids = $this->get("SELECT GROUP_CONCAT(id) AS ids FROM categories WHERE parent = ?", [ $id ]);
$ids = $ids[0]['ids'];
$r['pg'] = [];
if(!empty($ids)) {
$ids = $ids.','.$id;
if(isset($_GET['filters'])) {
$filters = "";
foreach ($_GET['filters'] as $f) {
$filters .= ", ".implode(', ', $f);
}
$filters = ltrim($filters, ", ");
$filter_size = sizeof($_GET['filters']);
$params = array( 'start' => $start, 'filter_size' => $filter_size, 'rangeStart' => $_GET['rangeStart'], 'rangeEnd' => $_GET['rangeEnd'] );
$r['p'] = $this->bind_get("SELECT p.id, p.name, p.slug, p.price, p.discounted_price, p.variants, p.enquiry,
(SELECT i.image FROM products_images i WHERE i.product = p.id ORDER BY sort ASC LIMIT 1) AS image
FROM product_filters pf
INNER JOIN products_categories pc ON pc.product = pf.product
INNER JOIN products p ON p.id = pf.product
WHERE p.status = 2
AND pc.category IN (".$ids.")
/var/www/silverpalace.in/public_html/src/app/controllers/View.php
if(isset($data['data'][0])) {
$data['color_bg'] = $data['data'][0]['color_bg'];
$data['subcategories'] = $mdl->subCategories($data['data'][0]['id']);
if(!empty($data['data'][0]['seo_title'])) {
$data['title'] = $data['data'][0]['seo_title'];
} else {
$data['title'] = $data['data'][0]['name'];
}
if(!empty($data['data'][0]['seo_keywords'])) {
$data['seo_keywords'] = $data['data'][0]['seo_keywords'];
}
if(!empty($data['data'][0]['seo_description'])) {
$data['seo_description'] = $data['data'][0]['seo_description'];
}
if(!empty($data['data'][0]['seo_image'])) {
$data['seo_image'] = HOME.'uploads/categories/'.$data['data'][0]['seo_image'];
}
$data['menu'] = $mdl->menu();
$data['data'] = $data['data'][0];
$data['products'] = $mdl->categoryProducts($data['data']['id'], $slug, $page);
// $data['counts'] = $mdl->productCounts($data['data']['id']);
$data['filters'] = $mdl->filters($data['data']['id']);
// if(!isset($_GET['filters'])) {
// $data['pagination'] = $cmn->pagination("view/category/".$slug, "products WHERE category = ".$data['data']['id'], $page);
// }
$this->render('view/category', $data);
} else {
header("Location: ".HOME."404/"); exit();
}
}
function collections($slug, $page) {
if($page == null) { $page = 1; }
$mdl = $this->model('View');
$cmn = $this->model('Common');
$data['data'] = $mdl->collections($slug);
if(isset($data['data'][0])) {
if(!empty($data['data'][0]['seo_title'])) {
$data['title'] = $data['data'][0]['seo_title'];
} else {
/var/www/silverpalace.in/public_html/src/main/Router.php
if(!empty($output)) {
$segments = explode('@', $output['callback']);
$controller = $segments[0];
if(ENABLE_LOGIN) {
if($output['mode']==1) {
if(isset($_SESSION[APP."_login"])) {
$controller = new $controller();
if($controller) {
call_user_func_array( array( $controller, $segments[1] ), $output['params'] );
}
} else {
header("Location: ".HOME."account/login/");
exit();
}
} elseif($output['mode'] == 0) {
$controller = new $controller();
if($controller) {
call_user_func_array( array( $controller, $segments[1] ), $output['params'] );
}
}
} else {
$controller = new $controller();
if($controller) {
call_user_func_array( array( $controller, $segments[1] ), $output['params'] );
}
}
} else {
echo '404';
}
}
}
/var/www/silverpalace.in/public_html/src/main/Router.php
if(!empty($output)) {
$segments = explode('@', $output['callback']);
$controller = $segments[0];
if(ENABLE_LOGIN) {
if($output['mode']==1) {
if(isset($_SESSION[APP."_login"])) {
$controller = new $controller();
if($controller) {
call_user_func_array( array( $controller, $segments[1] ), $output['params'] );
}
} else {
header("Location: ".HOME."account/login/");
exit();
}
} elseif($output['mode'] == 0) {
$controller = new $controller();
if($controller) {
call_user_func_array( array( $controller, $segments[1] ), $output['params'] );
}
}
} else {
$controller = new $controller();
if($controller) {
call_user_func_array( array( $controller, $segments[1] ), $output['params'] );
}
}
} else {
echo '404';
}
}
}
/var/www/silverpalace.in/public_html/index.php
transform: translate(-50%, -50%);
}
</style>
</head>
<body>
<div class="container">
<div class="content">
<p><strong>Under Maintenance.</strong><br>We'll be live soon. Stay tuned!</p>
</div>
</div>
</body>
</html>
<?php }
} else {
$router = new src\main\Router();
include "src/config/routes.php";
$router->dispatch();
}