Author Topic: Create next preview button  (Read 23852 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: 270
  • Karma: +42/-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

 

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.