Jump to content

itshubinak

Members
  • Posts

    16
  • Joined

  • Last visited

Profile Information

  • Location
    pak
  • Activity
    Developer

itshubinak's Achievements

Newbie

Newbie (1/14)

1

Reputation

  1. Hi guys hope you are fine well i have having one issue i want to export all product stock with each product attribute wise stock quantity can you please tell me the query which i can use to extract my desired information as i have mentioned above its urgent kindly help me out .below is the query which i used and extract all the info with total qunatity but i want to have attribute wise quantity in it as well please modify it and helo me out SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) WHERE pl.id_lang = 1 AND cl.id_lang = 1 AND p.id_shop_default = 1 AND c.id_shop_default = 1 GROUP BY p.id_product waiting for you quick response
  2. issue Hase been resolved i have used the different logic to achieve my required functionality.Thanks
  3. still i am stuck in this issue PrestaShop Apprentice can you please explain me stey by stey what should i do to fix this issue Thanks in advance
  4. hi thanx for the reply but can you please elaborate in detail you overrife the categorycontroller should i cahnge in cntollor folder or in override folder & further please tell me in which file should i add this $product.imageslist to take image 0 and image 1 because i m exost with this code if you can write the code because i m not that my expert in prestashop development
  5. hi guys i am stuck in onething i want to have rollover effect on product list page mean when i place mouse on product image it change the change to the next image of the same product & when i place out he mouse from the image it gets back to the original image. for this i have used the following code which is working like when i place the mouse image change but the problem is when i plce out the mouse from the image its not getting back to the original image please check it out & give me the solution because it is very important & urgent for thanks in advance Link.php added this code in class folder then link.php file <?php class Link extends LinkCore { /** * Returns a link to a product image for display * Note: the new image filesystem stores product images in subdirectories of img/p/ * * @param string $name rewrite link of the image * @param string $ids id part of the image filename - can be "id_product-id_image" (legacy support, recommended) or "id_image" (new) * @param string $type * @param integer $rollover id of current product */ public function getImageLink($name, $ids, $type = null, $rollover = null) { $not_default = false; // legacy mode or default image $theme = ((Shop::isFeatureActive() && file_exists(_PS_PROD_IMG_DIR_.$ids.($type ? '-'.$type : '').'-'.(int)Context::getContext()->shop->id_theme.'.jpg')) ? '-'.Context::getContext()->shop->id_theme : ''); if ((Configuration::get('PS_LEGACY_IMAGES') && (file_exists(_PS_PROD_IMG_DIR_.$ids.($type ? '-'.$type : '').$theme.'.jpg'))) || ($not_default = strpos($ids, 'default') !== false)) { if ($this->allow == 1 && !$not_default) $uri_path = __PS_BASE_URI__.$ids.($type ? '-'.$type : '').$theme.'/'.$name.'.jpg'; else $uri_path = _THEME_PROD_DIR_.$ids.($type ? '-'.$type : '').$theme.'.jpg'; } else { // if ids if of the form id_product-id_image, we want to extract the id_image part $split_ids = explode('-', $ids); $id_image = (isset($split_ids[1]) ? $split_ids[1] : $split_ids[0]); $theme = ((Shop::isFeatureActive() && file_exists(_PS_PROD_IMG_DIR_.Image::getImgFolderStatic($id_image).$id_image.($type ? '-'.$type : '').'-'.(int)Context::getContext()->shop->id_theme.'.jpg')) ? '-'.Context::getContext()->shop->id_theme : ''); if(isset($rollover)) { $hover_image = Db::getInstance()->getRow('SELECT id_image FROM '._DB_PREFIX_.'image WHERE id_product = '.$rollover.' AND position = 2'); if($hover_image) $id_image = array_shift($hover_image); else return '0'; } elseif(!isset($rollover)) { $hover_image = Db::getInstance()->getRow('SELECT id_image FROM '._DB_PREFIX_.'image WHERE id_product = '.$rollover.' AND position = 1'); if($hover_image) $id_image = array_shift($hover_image); else return '0'; } if ($this->allow == 1) $uri_path = __PS_BASE_URI__.$id_image.($type ? '-'.$type : '').$theme.'/'.$name.'.jpg'; else $uri_path = _THEME_PROD_DIR_.Image::getImgFolderStatic($id_image).$id_image.($type ? '-'.$type : '').$theme.'.jpg'; } return $this->protocol_content.Tools::getMediaServer($uri_path).$uri_path; } } rollover javascript which placed in product list.tpl file <script> function makeRolloverImages() { $(function() { $('.rollover-images').each(function() { var newSrc = $(this).data('rollover'); if(newSrc == 0) return; var oldSrc; $(this).hover(function() { oldSrc = $(this).attr('src'); $(this).attr('src', newSrc).stop(true,true).hide().fadeIn('slow'); }, function() { $(this).attr('src', oldSrc).stop(true,true).hide().fadeIn('slow'); }); }); }); } makeRolloverImages(); </script> image displaying cod ein product list.tpl file <img class="rollover-images" data-rollover="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home_default', $product.id_product)}" src="{$link->getImageLink($product.link_rewrite, $product.id_image, 'home_default')}" alt="{$product.name|escape:html:'UTF-8'}" /> Please look into the code & resolve this issue. what is missing to get the iorginal image back after plceing out the mouse hover
  6. vekia i have applied manuall rate on dollar i m not getting the rate from online the problem which i m facing is that i have created the vocher and my store has two currencies on front hand the works when the currency is selected pak rupee but when the currency is selected as dollar it has you have not reached the minimum amount to use this voucher even on voucher i have mentioned the minimum amount for dollar as well
  7. vekia i have applied manuall rate on dollar i m not getting the rate from online the problem which i m facing is that i have created the vocher and my store has two currencies on front hand the works when the currency is selected pak rupee but when the currency is selected as dollar it has you have not reached the minimum amount to use this voucher even on voucher i have mentioned the minimum amount for dollar as well
  8. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issueHow to apply the dicount voucher on doller
  9. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue
  10. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue
  11. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says Error : "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue.
  12. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue
  13. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue
  14. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue
  15. i am facing an issue when i add discount voucher using cart rule when i set minimum amount for pk currency it works fine i-e i set if minimum amount is 3196 pak rupee then the voucher can be used it works fine but when in front end i set dollar currency & use the voucher its says "You have not reached the minimum amount required to use this voucher." why the voucher is not working for dollar currency even i created another voucher of the minimum ammount in dollar but still its giving the same error on dollar currency but works fine only when the currency is rupee. kindly tell me the issue
×
×
  • Create New...