Version Notes
Second Beta version
Download this release
Release Info
| Developer | BrainSINS |
| Extension | Vtrio |
| Version | 1.0.1 |
| Comparing to | |
| See all releases | |
Code changes from version 1.0.0 to 1.0.1
app/code/community/Vtrio/CustomReports/Model/Collection.php
CHANGED
|
@@ -174,12 +174,12 @@ class Vtrio_CustomReports_Model_Collection extends Mage_Core_Model_Abstract
|
|
| 174 |
}
|
| 175 |
|
| 176 |
|
| 177 |
-
|
| 178 |
$sales_flat_order_table = Mage::getSingleton('core/resource')->getTableName('sales_flat_order');
|
| 179 |
-
|
| 180 |
$sql = "SELECT sfoi.created_at as date, sfoi.name, sfoi.sku, sfoi.price, sfoi.qty_ordered,
|
| 181 |
-
(select CONCAT(sfoa.firstname,' ',sfoa.lastname,'\n',sfoa.street,'\n',sfoa.city,', ',sfoa.region,', ',sfoa.postcode,'\n',sfoa.country_id) from sales_flat_order_address as sfoa where sfoa.entity_id=sfo.shipping_address_id) as shipping_address,
|
| 182 |
-
(select CONCAT(sfoa1.firstname,' ',sfoa1.lastname,'\n',sfoa1.street,'\n',sfoa1.city,', ',sfoa1.region,', ',sfoa1.postcode,'\n',sfoa1.country_id) from sales_flat_order_address as sfoa1 where sfoa1.entity_id=sfo.billing_address_id) as billing_address
|
| 183 |
FROM $sale_flat_table as sfoi
|
| 184 |
left join $sales_flat_order_table as sfo on sfo.entity_id=sfoi.order_id
|
| 185 |
$category
|
| 174 |
}
|
| 175 |
|
| 176 |
|
| 177 |
+
$sale_flat_table= Mage::getSingleton('core/resource')->getTableName('sales_flat_order_item');
|
| 178 |
$sales_flat_order_table = Mage::getSingleton('core/resource')->getTableName('sales_flat_order');
|
| 179 |
+
$sales_flat_order_address = Mage::getSingleton('core/resource')->getTableName('sales_flat_order_address');
|
| 180 |
$sql = "SELECT sfoi.created_at as date, sfoi.name, sfoi.sku, sfoi.price, sfoi.qty_ordered,
|
| 181 |
+
(select CONCAT(sfoa.firstname,' ',sfoa.lastname,'\n',sfoa.street,'\n',sfoa.city,', ',sfoa.region,', ',sfoa.postcode,'\n',sfoa.country_id) from $sales_flat_order_address as sfoa where sfoa.entity_id=sfo.shipping_address_id) as shipping_address,
|
| 182 |
+
(select CONCAT(sfoa1.firstname,' ',sfoa1.lastname,'\n',sfoa1.street,'\n',sfoa1.city,', ',sfoa1.region,', ',sfoa1.postcode,'\n',sfoa1.country_id) from $sales_flat_order_address as sfoa1 where sfoa1.entity_id=sfo.billing_address_id) as billing_address
|
| 183 |
FROM $sale_flat_table as sfoi
|
| 184 |
left join $sales_flat_order_table as sfo on sfo.entity_id=sfoi.order_id
|
| 185 |
$category
|
app/code/community/Vtrio/CustomReports/etc/config.xml
CHANGED
|
@@ -2,7 +2,7 @@
|
|
| 2 |
<config>
|
| 3 |
<modules>
|
| 4 |
<Vtrio_CustomReports>
|
| 5 |
-
<version>1.0.
|
| 6 |
</Vtrio_CustomReports>
|
| 7 |
</modules>
|
| 8 |
<global>
|
| 2 |
<config>
|
| 3 |
<modules>
|
| 4 |
<Vtrio_CustomReports>
|
| 5 |
+
<version>1.0.1</version>
|
| 6 |
</Vtrio_CustomReports>
|
| 7 |
</modules>
|
| 8 |
<global>
|
app/etc/modules/Vtrio_CustomReports.xml
CHANGED
|
@@ -4,7 +4,7 @@
|
|
| 4 |
<Vtrio_CustomReports>
|
| 5 |
<active>true</active>
|
| 6 |
<codePool>community</codePool>
|
| 7 |
-
<version>1.0.
|
| 8 |
</Vtrio_CustomReports>
|
| 9 |
</modules>
|
| 10 |
</config>
|
| 4 |
<Vtrio_CustomReports>
|
| 5 |
<active>true</active>
|
| 6 |
<codePool>community</codePool>
|
| 7 |
+
<version>1.0.1</version>
|
| 8 |
</Vtrio_CustomReports>
|
| 9 |
</modules>
|
| 10 |
</config>
|
package.xml
CHANGED
|
@@ -1,18 +1,18 @@
|
|
| 1 |
<?xml version="1.0"?>
|
| 2 |
<package>
|
| 3 |
<name>VReport</name>
|
| 4 |
-
<version>1.0.
|
| 5 |
-
<stability>
|
| 6 |
<license uri="http://opensource.org/licenses/osl-3.0.php">MITL</license>
|
| 7 |
<channel>community</channel>
|
| 8 |
<extends/>
|
| 9 |
-
<summary>VReport module helps users to generate reports in more user friendly and business prospective way
|
| 10 |
-
<description>VReport module helps users to generate reports in more user friendly and business prospective way. The report can be generated Category
|
| 11 |
-
<notes>
|
| 12 |
<authors><author><name>Developer</name><user>Developer</user><email>dev@vtrio.com</email></author></authors>
|
| 13 |
<date>2016-03-11</date>
|
| 14 |
-
<time>
|
| 15 |
-
<contents><target name="
|
| 16 |
<compatible/>
|
| 17 |
<dependencies><required><php><min>5.3.0</min><max>7.0.0</max></php></required></dependencies>
|
| 18 |
</package>
|
| 1 |
<?xml version="1.0"?>
|
| 2 |
<package>
|
| 3 |
<name>VReport</name>
|
| 4 |
+
<version>1.0.1</version>
|
| 5 |
+
<stability>beta</stability>
|
| 6 |
<license uri="http://opensource.org/licenses/osl-3.0.php">MITL</license>
|
| 7 |
<channel>community</channel>
|
| 8 |
<extends/>
|
| 9 |
+
<summary>VReport module helps users to generate reports in more user friendly and business prospective way. </summary>
|
| 10 |
+
<description>VReport module helps users to generate reports in more user friendly and business prospective way. The report can be generated Category and Sub Categories wise. Additionaly the module provides time based and Order Status based filters and export options.Export file contains details like Product Name,SKU,total Price,Quantity Ordered, shipping and billing addres. The report will help store owners in setting business plans based on order status and category</description>
|
| 11 |
+
<notes>Second Beta version</notes>
|
| 12 |
<authors><author><name>Developer</name><user>Developer</user><email>dev@vtrio.com</email></author></authors>
|
| 13 |
<date>2016-03-11</date>
|
| 14 |
+
<time>09:10:41</time>
|
| 15 |
+
<contents><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="vtrio"><dir name="customreports"><file name="gridproduct.phtml" hash="07dedcdaff3a17bc8510bb1f38e257e0"/></dir></dir></dir></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="vtriocustomreport"><file name="pagination.css" hash="3e61bea82df74a73e3b00c1952aa9770"/></dir></dir></dir></dir></target><target name="mage"><dir name="app"><dir name="code"><dir name="community"><dir name="Vtrio"><dir name="CustomReports"><dir name="Block"><dir name="Report"><dir name="Custom"><file name="Grid.php" hash="97be1eeaff2eabf3ed16dd4214a3abf9"/></dir><file name="Custom.php" hash="53ca9fae5564ba0c877c1a8e6e89e5e1"/></dir></dir><dir name="Helper"><file name="Data.php" hash="4fe236db0b3efb39c7283593a14dbbfe"/></dir><dir name="Model"><file name="Collection.php" hash="09d1aac7c6074a69a6a7fe793578afc3"/></dir><dir name="controllers"><dir name="Report"><file name="IndexController.php" hash="1afc4f670300dfe40466ebe75c182420"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="08112c6bf1a058fce42ee7a8f87b34c5"/><file name="config.xml" hash="0ba9d8d2e0743f57f37071eeeeee10b4"/></dir></dir></dir></dir></dir><dir name="etc"><dir name="modules"><file name="Vtrio_CustomReports.xml" hash="353cfc772c346784ad1b75de523e4077"/></dir></dir></dir></target></contents>
|
| 16 |
<compatible/>
|
| 17 |
<dependencies><required><php><min>5.3.0</min><max>7.0.0</max></php></required></dependencies>
|
| 18 |
</package>
|
