Create next preview button

AbanteCart Development > Development Help Needed

<< < (5/8) > >>

HADY:

--- Quote from: maulik 1intl on August 08, 2019, 11:51:02 AM --- :) :) ok you need to put this code in file best of luck
storefront\view\default\template\common\header.tpl

--- End quote ---

YES MY FRIEND!

I knew it. thanks a lot.

I have a question about something. can i contact you privately please??

regards

maulik 1intl:

--- Quote from: Sam_78 on August 09, 2019, 12:03:18 PM ---You will need to edit core code to get this. Better option is to make an extension

But try this if it works for you because I think you have some custom code already:

https://github.com/abantecart/abantecart-src/blob/master/public_html/storefront/controller/pages/product/product.php#L750

if(isset($category_info) && count($category_info) > 0){
         $nextPrevProducts = $this->model_catalog_product->getProductNextPrevProducts($product_id, $category_info['category_id']);
         $this->data['nextPrevProducts'] = $nextPrevProducts;
      }

right above foreach ($results as $result) {

-----
https://github.com/abantecart/abantecart-src/blob/master/public_html/storefront/model/catalog/product.php

Add this before last } line

public function getProductNextPrevProducts($productId, $categoryId){
      $sql = "SELECT * FROM " . $this->db->table("products_to_categories") . " WHERE `category_id` = $categoryId and product_id in ( select product_id from " . $this->db->table("products") . " where STATUS = 1)";
      $query = $this->db->query($sql);
      $product_data = $query->rows;
      $nextPrevProduct = array();
      if(count($product_data) > 0){
         foreach($product_data as $k => $v){
            if($v['product_id'] == $productId){
               $preProductId = isset($product_data[$k - 1]['product_id']) ? $product_data[$k - 1]['product_id'] : 0;
               $nextProductId = isset($product_data[$k + 1]['product_id']) ? $product_data[$k + 1]['product_id'] : 0;
               $cateSql = "SELECT keyword FROM `url_aliases` WHERE `query` LIKE 'category_id=$categoryId'";
               $cateSqlQuery = $this->db->query($cateSql);
               $cateURL = count($cateSqlQuery->rows) > 0 ? $cateSqlQuery->row['keyword']: '';

               $prevProductSql = "SELECT keyword FROM `url_aliases` WHERE `query` LIKE 'product_id=$preProductId'";
               $prevProductSqlQuery = $this->db->query($prevProductSql);
         $prevProductURL = count($prevProductSqlQuery->rows) > 0 ? $prevProductSqlQuery->row['keyword']: '';

               $nextProductSql = "SELECT keyword FROM `url_aliases` WHERE `query` LIKE 'product_id=$nextProductId'";
               $nextProductSqlQuery = $this->db->query($nextProductSql);
               $nextProductURL = count($nextProductSqlQuery->rows) > 0 ? $nextProductSqlQuery->row['keyword']: '';

               $nextPrevProduct['prev_product'] = (trim($prevProductURL) != '') ? $cateURL . "/" . $prevProductURL : '';
               $nextPrevProduct['next_product'] = (trim($nextProductURL) != '') ? $cateURL . "/" . $nextProductURL : '';
            }
         }
      }
      return $nextPrevProduct;
   }

And last go to product.tpl and add this code where ever you want buttons and style it the way you want.

https://github.com/abantecart/abantecart-src/blob/master/public_html/storefront/view/default/template/pages/product/product.tpl#L268

<?php if(is_array($nextPrevProducts)){ ?>
<div>
   <div style="float: left">
      <?php if(trim($nextPrevProducts['prev_product']) != '') {?>
         <a href="<?php echo trim($nextPrevProducts['prev_product']); ?>" > Previous Product </a>
      <?php } ?>
   </div>
   <div style="float: right">
      <?php if(trim($nextPrevProducts['next_product']) != '') {?>
         <a href="<?php echo trim($nextPrevProducts['next_product']); ?>" > Next Product </a>
      <?php } ?>
   </div>
</div>
<?php } ?>

You can contact AbanteCart developers (they have paid service abantecart.com/contact-us) or some other developers https://www.fiverr.com/nattoben This developer has made few extension for AbanteCart he might be able to help you https://marketplace.abantecart.com/index.php?rt=product/vendor&v=40

P.S I am not promoting anyone here just trying to help you as what you want is not an easy thing. It needs some custom development

--- End quote ---

Nice work and Thanks you so much :) :) :) :) :)
i am just try your code today in my local server but its show me some error.i am just put your code for new install abantecart in localhost and add your above code in it.
/storefront/controller/pages/product/product.php#L750

$results = $this->model_catalog_product->getProductTags($product_id);
      /* Sam_78*/
      if(isset($category_info) && count($category_info) > 0){
$nextPrevProducts = $this->model_catalog_product->getProductNextPrevProducts($product_id, $category_info['category_id']);
$this->data['nextPrevProducts'] = $nextPrevProducts;
      }
      /* Sam_78*/
storefront/model/catalog/product.php
this code also add after add this code it's start error to show i was put code as after
public function hasTrackOptions{} function is end and also add last line before } this.
i am attach image of error to show.

thanks you so much :) :) :) :)

Sam_78:
what error are you getting? send errors from error log file so I can look at it.

maulik 1intl:

--- Quote from: Sam_78 on August 19, 2019, 10:44:58 AM ---what error are you getting? send errors from error log file so I can look at it.

--- End quote ---

Thanks you so much for replay

Above error is database name table error which i was change and now i was update in live project but Previous Product and next product link not show in page or not get value of product id. i was attach image that not id get.

As per above code add in all file in live project http://1intl.com

Thanks so much :) :) :)

maulik 1intl:
Thanks :) :) :) :) :)
attach all there file with code but data is not display id.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version