$row = array();
while ($results = $query->fetch_object()) {
array_push($row, $results);
}
return $row;
}
function get_category_child($level, $parent)
{
$sql = "SELECT category_alias, category_name, category_id FROM tbl_category AS cat INNER JOIN tbl_category_relation AS cat_rel ON cat.category_id = cat_rel.category_child\n\t WHERE cat.category_level = '{$level}' AND cat_rel.category_parent = '{$parent}' AND `category_visibility_status` = '1' ORDER BY category_order LIMIT 1\n\t\t\t\t";
$query = $this->conn->query($sql);
if ($results = $query->fetch_object()) {
return $results;
}
}
}
$_navbar = new HEADER_NAVBAR();
$navbar_categories = $_navbar->get_categories('0', 'top');
$a = 0;
$navbar_category_childs = array();
foreach ($navbar_categories as $navbar_category) {
$navbar_category_childs[$a] = $_navbar->get_category_child('1', $navbar_category->category_id);
$a++;
}
if (isset($_SESSION['account']['login_id'])) {
$session_user_id = $_SESSION['account']['login_id'];
} else {
$session_user_id = 0;
}
$count_wishlist = $_navbar->count_wishlists($session_user_id);
/* --- MINI NAVBAR CART --- */
if (isset($_SESSION['cart_type_id']) && count($_SESSION['cart_type_id']) > 0) {
array_push($row, $result);
}
return $row;
}
function getPress()
{
$sql = "SELECT * FROM tbl_press_category WHERE `category_visibility` = 'Yes'";
$query = $this->conn->query($sql);
$row = array();
while ($result = $query->fetch_object()) {
array_push($row, $result);
}
return $row;
}
}
$_navbar = new HEADER_NAVBAR();
$countService = $_navbar->countService();
$rowService = array();
if ($countService->rows > 0) {
$getService = $_navbar->getService();
}
$getPress = $_navbar->getPress();
?>
<div class="navbar navbar-fixed-top" role="navigation">
<div class="navbar-header">
<div id="nav-toggle" data-toggle="collapse" data-target="#navbar-collapsible"><span></span></div>
<!-- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-data">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button> -->
function count_mini_item()
{
$sql = "SELECT COUNT(*) AS rows FROM tbl_wishlist WHERE user_id = '{$user_id}' ORDER BY wishlist_date DESC";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
function get_mini_item($stock_name, $type_id)
{
$sql = "SELECT img_src, type_name, type_price, stock_name, product_name, promo_id, promo_start_datetime, promo_end_datetime, promo_value\n\t \t\t\t FROM tbl_product_type AS type_ LEFT JOIN tbl_product AS prod_ ON type_.product_id = prod_.id\n \t\t\t\t\tLEFT JOIN tbl_category AS cat_ ON cat_.category_id = prod_.product_category\n\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_product_image AS img_ ON type_.type_id = img_.type_id\n\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_product_stock AS stock_ ON stock_.type_id = type_.type_id\n\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_promo_item AS promo_ ON type_.type_id = promo_.product_type_id\n WHERE `stock_name` = '{$stock_name}' AND `type_`.type_id = '{$type_id}'\n\t\t\t\t GROUP BY `stock_id`\n ";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_navbar = new HEADER_NAVBAR();
if (isset($_SESSION['account']['login_id'])) {
$session_user_id = $_SESSION['account']['login_id'];
} else {
$session_user_id = 0;
}
$count_wishlist = $_navbar->count_wishlists($session_user_id);
/* --- MINI NAVBAR CART --- */
if (isset($_SESSION['cart_type_id']) && count($_SESSION['cart_type_id']) > 0) {
$nav_mini_type = $_SESSION['cart_type_id'];
$nav_mini_stock = $_SESSION['cart_stock_id'];
$nav_mini_qty = $_SESSION['cart_qty'];
$class_mini_arrow_up = '';
$class_mini_arrow_down = '';
$class_mini_total_bag = '';
$class_mini_button_bag = '';
$total_bag = '0';
}
} else {
$total_bag = '0';
}
echo $total_bag;
}
function count_wishlists($user_id)
{
$sql = "SELECT COUNT(*) AS rows FROM tbl_wishlist WHERE user_id = '{$user_id}' ORDER BY wishlist_date DESC";
$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
}
$_navbar = new HEADER_NAVBAR();
if (isset($_SESSION['account']['login_id'])) {
$session_user_id = $_SESSION['account']['login_id'];
} else {
$session_user_id = 0;
}
$count_wishlist = $_navbar->count_wishlists($session_user_id);
?>
<div class="nav-ribbon">
<div class="container">
Free shipping on orders above IDR 500.000
</div>
</div>
<div class="navbar navbar-static-top" role="navigation">
";
$query = $this->conn->query($sql);
$row = array();
while($results = $query->fetch_object()){
array_push($row, $results);
}
return $row;
}
}
$_navbar = new HEADER_NAVBAR();
/*
# ----------------------------------------------------------------------
# CATEGORY
# ----------------------------------------------------------------------
*/
/* --- NEW ARRIVAL --- */
$_cat_count_new_men = $_navbar->count_new_cat('men');
$_cat_data_new_men = $_navbar->get_new_cat('men');
$_cat_count_new_women = $_navbar->count_new_cat('women');
$_cat_data_new_women = $_navbar->get_new_cat('women');
/* --- OTHERS --- */
