Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Create next preview button  (Read 36374 times)

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: Create next preview button
« Reply #30 on: August 21, 2019, 06:37:03 AM »
Thanks bro Sam_78 your awesome great your great's in this filed bro.
Thanks you very much bro  :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)
He is nice and great skill in this filed.
Thanks Sam_78  very much


hi!

Can you write step by step the details of your experience in this subject please ??

Regards

HADY
Thank you In Advanced
Regards
HADY

Offline Sam_78

  • Sr. Member
  • ****
  • Posts: 278
  • Karma: +43/-1
    • View Profile
Re: Create next preview button
« Reply #31 on: August 21, 2019, 09:48:07 AM »
Thanks bro Sam_78 your awesome great your great's in this filed bro.
Thanks you very much bro  :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)
He is nice and great skill in this filed.
Thanks Sam_78  very much

Hi I am happy it worked for you. Send me your URL once you are done with implementing this

Offline maulik 1intl

  • Jr. Member
  • **
  • Posts: 83
  • Karma: +6/-0
    • View Profile
Re: Create next preview button
« Reply #32 on: August 22, 2019, 12:07:53 AM »
Thanks bro Sam_78 your awesome great your great's in this filed bro.
Thanks you very much bro  :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)
He is nice and great skill in this filed.
Thanks Sam_78  very much

Hi I am happy it worked for you. Send me your URL once you are done with implementing this



Thanks
Currently only my few product is work because of SEO URL when i was import products it's not generate SEO Name so And also my SEO url work.Here is url

http://1intl.com/10367--s-28/10367-01
http://1intl.com/10359-s-30/10359-02

Also i will do change seo link of product. So next my all website work properly.

Thanks & Regards

Offline maulik 1intl

  • Jr. Member
  • **
  • Posts: 83
  • Karma: +6/-0
    • View Profile
Re: Create next preview button
« Reply #33 on: August 30, 2019, 04:51:38 AM »
Thanks bro Sam_78 your awesome great your great's in this filed bro.
Thanks you very much bro  :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)
He is nice and great skill in this filed.
Thanks Sam_78  very much

Hi I am happy it worked for you. Send me your URL once you are done with implementing this


Thanks  :) :) :) sam_78  :) :) :) :) :) i was done in my website next preview button completed today i get error in some my product delete and change it so some time it's redirect me to other page and i was fixed today of all my products.Thanks Sam_78 so much  :) :) :)  my website link as below

http://1intl.com

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: Create next preview button
« Reply #34 on: August 30, 2019, 05:04:20 AM »
nice introduction background video, congratulations.


 
Thank you In Advanced
Regards
HADY

Offline maulik 1intl

  • Jr. Member
  • **
  • Posts: 83
  • Karma: +6/-0
    • View Profile
Re: Create next preview button
« Reply #35 on: August 30, 2019, 05:08:57 AM »
nice introduction background video, congratulations.
I was complete product page next preview button update in website replay not video bro    :P :P :P :P

Offline baovietgps

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
    • định vị xe máy giá rẻ
Re: Create next preview button
« Reply #36 on: January 21, 2020, 09:37:33 AM »
I also want to apply for my website .
newbielink:https://dinhvixemay.org/ [nonactive]

Offline maulik 1intl

  • Jr. Member
  • **
  • Posts: 83
  • Karma: +6/-0
    • View Profile
Re: Create next preview button
« Reply #37 on: January 21, 2020, 11:42:04 AM »
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

 

Powered by SMFPacks Social Login Mod