$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 --- */