leaf through products: a next & previous button for products

Code: Select all

	public function getProductsIDbyCategoryID($category_id) {
		$query = $this->db->query("SELECT `product_id` FROM  `product_to_category` WHERE  `category_id` =  '".$category_id."'");
								  
		return $query->rows;
	}  

Code: Select all

	public function getStatusByProductID($product_id) { 
	
		$query = $this->db->query("SELECT `status` FROM `product` WHERE `product_id`=".$product_id);
		return $query->rows;
	}

Code: Select all

if (isset($this->request->get['path'])) {
			$path = '';
				
			// ADDITION
			$parts = explode('_', $this->request->get['path']);
			// END ADDITION

			foreach (explode('_', $this->request->get['path']) as $path_id) {
				$category_info = $this->model_catalog_category->getCategory($path_id);
				
				if (!$path) {
					$path = $path_id;
				} else {
					$path .= '_' . $path_id;
				}
				
				if ($category_info) {
					$this->document->breadcrumbs[] = array(
						'href'      => $this->model_tool_seo_url->rewrite(HTTP_SERVER . 'index.php?route=product/category&path=' . $path),
						'text'      => $category_info['name'],
						'separator' => $this->language->get('text_separator')
					);
				}
			}

		// ADDITION
					$category_id = array_pop($parts);
		} else {
			$category_id = 0;
		}
			
		$this->data['category_id'] = $category_id;
			
		// END ADDITION

Code: Select all

$this->load->model('catalog/product');
		
		if (isset($this->request->get['product_id'])) {
			$product_id = $this->request->get['product_id'];
		} else {
			$product_id = 0;
		}
		
		// ADDITTION!!!
		
		$productsByCategoryID = $this->model_catalog_product->getProductsIDbyCategoryID($category_id); // create an array with our products
		
		
		for ($i=0;$i < count($productsByCategoryID); $i++) { // remove items that are not activated
			$statusProducts = $this->model_catalog_product->getStatusByProductID($productsByCategoryID[$i]["product_id"]);
			if ($statusProducts[0]["status"] == 0) {
				unset( $productsByCategoryID[$i] );
			}
		}
		
		foreach ($productsByCategoryID as $key => $value){
       			if ($productsByCategoryID[$key]["product_id"] == $product_id) {
					$next = current ($productsByCategoryID); //move back and forward in the array to create the hyperlinks for the NEXT and PREVIOUS buttons.

					prev($productsByCategoryID);
					if (!$next) {
						end ($productsByCategoryID);
					}
					$prev = prev ($productsByCategoryID);
					
					$url = 'index.php?route=product/product';
				
					if (isset($this->request->get['path'])) {
						$url .= '&path=' . $this->request->get['path'];
					}
					    				
					if ($next){ // there is only a next button if there is a next product to see
							$url_next = $url.'&product_id='. $next["product_id"];
							$this->data['next_url'] = $url_next;
					}else {
						$this->data['next_url'] = FALSE;
					}
					if ($prev){ // same here
						$url_prev = $url.'&product_id='. $prev["product_id"];
						$this->data['previous_url'] = $url_prev;
					} else {
						$this->data['previous_url'] = FALSE;
					}
				}   
				next ($productsByCategoryID); // set the array pointer to the next product
    	}
		
		// END


[b]3. in view\theme\catalog\[i]themename[/i]\template\product\product.php[/b]

create a div for the next and previous buttons:

	[code]	<?php if ($previous_url) { ?>
        	<a href="<?php echo ($previous_url); ?>"><</a>
        <?php } ?>
        <?php if ($next_url) { ?>
        	
        	<a href="<?php echo ($next_url); ?>">></a>
        <?php } ?>