[vQmod] - 1.4.x & 1.5.x Show Random products for modules

[shamshair]

*****************Thanks A Lot For this great sharing*********************

[3antz]

Hi Q, thanks for the free mod. Is there a way to only show products which are available in stock?

[Klimskady]

Thanks for this Q!.

[Pr3W]

Hi Q, thanks for the free mod. Is there a way to only show products which are available in stock?

I have the same doubt.

[jty]

Hi Q, thanks for the free mod. Is there a way to only show products which are available in stock?

in stock is controlled by the field p.quantity
so, to only show products in stock we need to add p.quantity > 0 somewhere
to do it without touching the getProduct function in model (because it's use elsewhere for other purposes, I added p.quantity > 0 into the latest.php controller file like this. Look for the words "here" in the following code.

Code: Select all

$results = $this->model_catalog_product->getProducts($data);
      // randomise latest - from
      // http://forum.opencart.com/viewtopic.php?f=131&t=32570&start=20
      srand((float)microtime() * 1000000);
      shuffle($results);
      $results = array_slice($results, 0, $setting['limit']);
      //
      
      foreach ($results as $result) {
        // here
        if ($result['quantity'] > 0) {
        // end here
         if ($result['image']) {
            $image = $this->model_tool_image->resize($result['image'], $setting['image_width'], $setting['image_height']);
         } else {
            $image = false;
         }
                  
         // blaa blaa blaa code deleted
         
         $this->data['products'][] = array(
            'product_id' => $result['product_id'],
            // blaa blaa blaa code deleted
            'href'        => $this->url->link('product/product', 'product_id=' . $result['product_id']),
         );
        // here
       }
        // end here
      }

      if (file_exists(DIR_TEMPLATE . $this->config->get('config_template') . '/template/module/latest.tpl')) {
      // blaa blaa blaa code deleted

[xtr3mx7]

thanks for the share Q, works perfectly on 1.5.4

[HASHR]

This worked perfectly for us! We appreciate it.
Cheers,
HASHR

[scot]

AWESOME! "Latest" Works on 1.5.5.1 Thank You!

[labeshops]

exactly what I needed for my specials! Works perfectly! Thanks.