Version Notes
Best Seller
Download this release
Release Info
| Developer | Capacity Web Solutions |
| Extension | Bestseller_products |
| Version | 1.1.7 |
| Comparing to | |
| See all releases | |
Code changes from version 1.1.6 to 1.1.7
app/code/community/CapacityWebSolutions/Bestseller/Block/Bestseller.php
CHANGED
|
@@ -33,8 +33,9 @@ class CapacityWebSolutions_Bestseller_Block_Bestseller extends Mage_Catalog_Bloc
|
|
| 33 |
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
|
| 34 |
$read = Mage::getSingleton('core/resource')->getConnection('core_read');
|
| 35 |
$table_prefixx = Mage::getConfig()->getTablePrefix();
|
| 36 |
-
$res = $write->query("select max(qo) as des_qty,`product_id`,`parent_item_id` FROM (select sum(
|
| 37 |
|
|
|
|
| 38 |
while ($row = $res->fetch())
|
| 39 |
{
|
| 40 |
$maxQty[]=$row['product_id'];
|
| 33 |
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
|
| 34 |
$read = Mage::getSingleton('core/resource')->getConnection('core_read');
|
| 35 |
$table_prefixx = Mage::getConfig()->getTablePrefix();
|
| 36 |
+
$res = $write->query("select max(qo) as des_qty,`product_id`,`parent_item_id`,`order_id` FROM (select sum(p.qty_ordered) AS qo,p.product_id,p.created_at,p.store_id,p.parent_item_id, s.status, p.order_id from sales_flat_order as s, sales_flat_order_item as p where s.entity_id = p.order_id AND s.status = 'complete' AND p.store_id = ".$this->getStoreId()." Group By p.product_id) AS t1 where store_id = ".$this->getStoreId()." AND parent_item_id is null AND created_at between'".$newdate."' AND '".$date."' Group By `product_id` order By des_qty desc");
|
| 37 |
|
| 38 |
+
|
| 39 |
while ($row = $res->fetch())
|
| 40 |
{
|
| 41 |
$maxQty[]=$row['product_id'];
|
app/code/community/CapacityWebSolutions/Bestseller/etc/config.xml
CHANGED
|
@@ -12,7 +12,7 @@
|
|
| 12 |
<global>
|
| 13 |
<modules>
|
| 14 |
<CapacityWebSolutions_Bestseller>
|
| 15 |
-
<version>1.1.
|
| 16 |
</CapacityWebSolutions_Bestseller>
|
| 17 |
</modules>
|
| 18 |
<blocks>
|
| 12 |
<global>
|
| 13 |
<modules>
|
| 14 |
<CapacityWebSolutions_Bestseller>
|
| 15 |
+
<version>1.1.7</version>
|
| 16 |
</CapacityWebSolutions_Bestseller>
|
| 17 |
</modules>
|
| 18 |
<blocks>
|
package.xml
CHANGED
|
@@ -1,7 +1,7 @@
|
|
| 1 |
<?xml version="1.0"?>
|
| 2 |
<package>
|
| 3 |
<name>Bestseller_products</name>
|
| 4 |
-
<version>1.1.
|
| 5 |
<stability>stable</stability>
|
| 6 |
<license uri="http://opensource.org/licenses/osl-3.0.php">OSL 3.0</license>
|
| 7 |
<channel>community</channel>
|
|
@@ -10,9 +10,9 @@
|
|
| 10 |
<description>This extension is display best seller product.</description>
|
| 11 |
<notes>Best Seller</notes>
|
| 12 |
<authors><author><name>Capacity Web Solutions</name><user>capacitywebsolutions</user><email>magento@capacitywebsolutions.com</email></author></authors>
|
| 13 |
-
<date>2014-09-
|
| 14 |
-
<time>
|
| 15 |
-
<contents><target name="magecommunity"><dir name="CapacityWebSolutions"><dir name="Bestseller"><dir name="Block"><file name="Bestseller.php" hash="
|
| 16 |
<compatible/>
|
| 17 |
<dependencies><required><php><min>5.0.0</min><max>5.6.0</max></php></required></dependencies>
|
| 18 |
</package>
|
| 1 |
<?xml version="1.0"?>
|
| 2 |
<package>
|
| 3 |
<name>Bestseller_products</name>
|
| 4 |
+
<version>1.1.7</version>
|
| 5 |
<stability>stable</stability>
|
| 6 |
<license uri="http://opensource.org/licenses/osl-3.0.php">OSL 3.0</license>
|
| 7 |
<channel>community</channel>
|
| 10 |
<description>This extension is display best seller product.</description>
|
| 11 |
<notes>Best Seller</notes>
|
| 12 |
<authors><author><name>Capacity Web Solutions</name><user>capacitywebsolutions</user><email>magento@capacitywebsolutions.com</email></author></authors>
|
| 13 |
+
<date>2014-09-18</date>
|
| 14 |
+
<time>12:04:56</time>
|
| 15 |
+
<contents><target name="magecommunity"><dir name="CapacityWebSolutions"><dir name="Bestseller"><dir name="Block"><file name="Bestseller.php" hash="07ffa1bc9a629e6957d897f185e38d04"/></dir><dir name="Helper"><file name="Data.php" hash="bc0bf539b64b2e6e709df40983cdd3dc"/></dir><dir name="controllers"><file name="IndexController.php" hash="e7348683b15be235f0d1756eccd5b755"/></dir><dir name="etc"><file name="config.xml" hash="7b0985e0aa59c24e25ee979cfbed4a7a"/><file name="system.xml" hash="b863b228c2ba0f4a0b7772a196b2e3ba"/></dir></dir></dir></target><target name="magedesign"><dir name="frontend"><dir name="base"><dir name="default"><dir name="template"><dir name="bestseller"><file name="bestseller-responsive.phtml" hash="6b4494d9f833df62bce7b9ffae96523c"/><file name="bestseller.phtml" hash="72a89e2c240fd0b4b16f6462fb53c4f0"/></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="CapacityWebSolutions_Bestseller.xml" hash="78f9e48e2abe50655fca24708da017c3"/></dir></target></contents>
|
| 16 |
<compatible/>
|
| 17 |
<dependencies><required><php><min>5.0.0</min><max>5.6.0</max></php></required></dependencies>
|
| 18 |
</package>
|
