Bestseller_products - Version 1.1.7

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(`qty_ordered`) AS qo,`product_id`,created_at,store_id,`parent_item_id` from ".$table_prefixx."sales_flat_order_item Group By `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
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.6</version>
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.6</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,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-03</date>
14
- <time>05:28:13</time>
15
- <contents><target name="magecommunity"><dir name="CapacityWebSolutions"><dir name="Bestseller"><dir name="Block"><file name="Bestseller.php" hash="16f2ac58e88e7fb1752f2c37cceebf8b"/></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="36c6f83d6df5e5514a1725061a26792b"/><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>
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>