Sales_Report - Version 1.0.1

Version Notes

Spaces issue in Postcode is resolved.

Download this release

Release Info

Developer Manthan
Extension Sales_Report
Version 1.0.1
Comparing to
See all releases


Code changes from version 1.0.0 to 1.0.1

Files changed (3) hide show
  1. app/code/local/Sitegurus/Pincode/controllers/Adminhtml/PincodeController.php +3 -3
  2. app/design/adminhtml/default/default/template/pincode/sales_report.phtml +1 -1
  3. package.xml +7 -7
app/code/local/Sitegurus/Pincode/controllers/Adminhtml/PincodeController.php CHANGED
@@ -94,10 +94,10 @@ class Sitegurus_Pincode_Adminhtml_PincodeController extends Mage_Adminhtml_Contr
94
  $sql1 = "SELECT pin_code FROM pincode where area_name='".$area_name."'";
95
  $res = $read->fetchRow($sql1);
96
  $pincode = $res['pin_code'];
97
- $sql2 = "SELECT count(postcode),email FROM sales_flat_order_address where postcode in (".$pincode.") and address_type='billing' group by sales_flat_order_address.postcode";
98
  $res1 = $read->fetchRow($sql2);
99
 
100
- $sql3 = "select count(sales_flat_order_address.postcode),sum(sales_flat_order.subtotal),sum(sales_flat_order.base_subtotal_invoiced),sum(sales_flat_order.subtotal_refunded),sum(sales_flat_order.base_shipping_tax_amount),sum(sales_flat_order.shipping_amount),sum(sales_flat_order.discount_amount),sum(sales_flat_order.subtotal_canceled),date(sales_flat_order.created_at) from sales_flat_order,sales_flat_order_address where sales_flat_order_address.parent_id = sales_flat_order.entity_id and sales_flat_order_address.postcode in (".$pincode.")and sales_flat_order_address.address_type='billing' and date(sales_flat_order.created_at) between '".$from_date."' and '".$to_date."' group by sales_flat_order_address.postcode,date(sales_flat_order.created_at)";
101
  $ress2 = $read->fetchAll($sql3);
102
  foreach($ress2 as $res2){
103
  //DebugBreak();
@@ -149,7 +149,7 @@ class Sitegurus_Pincode_Adminhtml_PincodeController extends Mage_Adminhtml_Contr
149
  $pincode = $res['pin_code'];
150
  $sql2 = "SELECT count(postcode),email FROM sales_flat_order_address where postcode in (".$pincode.") and address_type='billing' group by sales_flat_order_address.postcode";
151
  $res1 = $read->fetchRow($sql2);
152
- $sql3 = "select count(sales_flat_order_address.postcode),sum(sales_flat_order.subtotal),sum(sales_flat_order.base_subtotal_invoiced),sum(sales_flat_order.subtotal_refunded),sum(sales_flat_order.base_shipping_tax_amount),sum(sales_flat_order.shipping_amount),sum(sales_flat_order.discount_amount),sum(sales_flat_order.subtotal_canceled),date(sales_flat_order.created_at) from sales_flat_order,sales_flat_order_address where sales_flat_order_address.parent_id = sales_flat_order.entity_id and sales_flat_order_address.postcode in (".$pincode.")and sales_flat_order_address.address_type='billing' and date(sales_flat_order.created_at) between '".$from_date."' and '".$to_date."' group by sales_flat_order_address.postcode,date(sales_flat_order.created_at)";
153
  $ress2 = $read->fetchAll($sql3);
154
  $i = 1;
155
  foreach($ress2 as $res2){
94
  $sql1 = "SELECT pin_code FROM pincode where area_name='".$area_name."'";
95
  $res = $read->fetchRow($sql1);
96
  $pincode = $res['pin_code'];
97
+ $sql2 = "SELECT count(postcode),email FROM sales_flat_order_address where postcode in ('".$pincode."') and address_type='billing' group by sales_flat_order_address.postcode";
98
  $res1 = $read->fetchRow($sql2);
99
 
100
+ $sql3 = "select count(sales_flat_order_address.postcode),sum(sales_flat_order.subtotal),sum(sales_flat_order.base_subtotal_invoiced),sum(sales_flat_order.subtotal_refunded),sum(sales_flat_order.base_shipping_tax_amount),sum(sales_flat_order.shipping_amount),sum(sales_flat_order.discount_amount),sum(sales_flat_order.subtotal_canceled),date(sales_flat_order.created_at) from sales_flat_order,sales_flat_order_address where sales_flat_order_address.parent_id = sales_flat_order.entity_id and sales_flat_order_address.postcode in ('".$pincode."')and sales_flat_order_address.address_type='billing' and date(sales_flat_order.created_at) between '".$from_date."' and '".$to_date."' group by sales_flat_order_address.postcode,date(sales_flat_order.created_at)";
101
  $ress2 = $read->fetchAll($sql3);
102
  foreach($ress2 as $res2){
103
  //DebugBreak();
149
  $pincode = $res['pin_code'];
150
  $sql2 = "SELECT count(postcode),email FROM sales_flat_order_address where postcode in (".$pincode.") and address_type='billing' group by sales_flat_order_address.postcode";
151
  $res1 = $read->fetchRow($sql2);
152
+ $sql3 = "select count(sales_flat_order_address.postcode),sum(sales_flat_order.subtotal),sum(sales_flat_order.base_subtotal_invoiced),sum(sales_flat_order.subtotal_refunded),sum(sales_flat_order.base_shipping_tax_amount),sum(sales_flat_order.shipping_amount),sum(sales_flat_order.discount_amount),sum(sales_flat_order.subtotal_canceled),date(sales_flat_order.created_at) from sales_flat_order,sales_flat_order_address where sales_flat_order_address.parent_id = sales_flat_order.entity_id and sales_flat_order_address.postcode in ('".$pincode."')and sales_flat_order_address.address_type='billing' and date(sales_flat_order.created_at) between '".$from_date."' and '".$to_date."' group by sales_flat_order_address.postcode,date(sales_flat_order.created_at)";
153
  $ress2 = $read->fetchAll($sql3);
154
  $i = 1;
155
  foreach($ress2 as $res2){
app/design/adminhtml/default/default/template/pincode/sales_report.phtml CHANGED
@@ -164,7 +164,7 @@
164
  $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
165
  $read= Mage::getSingleton('core/resource')->getConnection('core_read');
166
 
167
- $sql3 = "select count(sales_flat_order_address.postcode),sum(sales_flat_order.subtotal),sum(sales_flat_order.base_subtotal_invoiced),sum(sales_flat_order.subtotal_refunded),sum(sales_flat_order.base_shipping_tax_amount),sum(sales_flat_order.shipping_amount),sum(sales_flat_order.discount_amount),sum(sales_flat_order.subtotal_canceled),date(sales_flat_order.created_at) from sales_flat_order,sales_flat_order_address where sales_flat_order_address.parent_id = sales_flat_order.entity_id and sales_flat_order_address.postcode in (".$pincode.")and sales_flat_order_address.address_type='billing' and date(sales_flat_order.created_at) between '".$from_date."' and '".$to_date."' group by sales_flat_order_address.postcode,date(sales_flat_order.created_at)";
168
  $arr['res2'] = $read->fetchAll($sql3);
169
  return $arr;
170
 
164
  $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
165
  $read= Mage::getSingleton('core/resource')->getConnection('core_read');
166
 
167
+ $sql3 = "select count(sales_flat_order_address.postcode),sum(sales_flat_order.subtotal),sum(sales_flat_order.base_subtotal_invoiced),sum(sales_flat_order.subtotal_refunded),sum(sales_flat_order.base_shipping_tax_amount),sum(sales_flat_order.shipping_amount),sum(sales_flat_order.discount_amount),sum(sales_flat_order.subtotal_canceled),date(sales_flat_order.created_at) from sales_flat_order,sales_flat_order_address where sales_flat_order_address.parent_id = sales_flat_order.entity_id and sales_flat_order_address.postcode in ('".$pincode."') and sales_flat_order_address.address_type='billing' and date(sales_flat_order.created_at) between '".$from_date."' and '".$to_date."' group by sales_flat_order_address.postcode,date(sales_flat_order.created_at)";
168
  $arr['res2'] = $read->fetchAll($sql3);
169
  return $arr;
170
 
package.xml CHANGED
@@ -1,18 +1,18 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Sales_Report</name>
4
- <version>1.0.0</version>
5
  <stability>stable</stability>
6
- <license uri="http://opensource.org/licenses/osl-3.0.php">Open Software License (OSL) </license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>Area Wise Sales Report extension allows admin to add Pin Codes and Areas from admin interface and get the report of total sale in particular area.</summary>
10
  <description>This extension allows admin to manage (Add/Update/Delete) Pin code and Areas from admin interface and depending on that information admin can have detailed report of the total sell in particular areas with a filter of Date (From - To date).</description>
11
- <notes>This is the first stable version of the extension.</notes>
12
  <authors><author><name>Manthan</name><user>manthanext</user><email>manthan18121989@gmail.com</email></author></authors>
13
- <date>2013-11-21</date>
14
- <time>07:38:37</time>
15
- <contents><target name="magelocal"><dir name="Sitegurus"><dir name="Pincode"><dir name="Block"><dir name="Adminhtml"><dir name="Pincode"><dir name="Edit"><file name="Form.php" hash="315e488ed8862b2470a70abfab746adc"/><dir name="Tab"><file name="Form.php" hash="7f7f18b14e3dbed57ab8be5e76e1f93d"/></dir><file name="Tabs.php" hash="a25cd23c11d2bb10916c55de1cd7dee3"/></dir><file name="Edit.php" hash="f801ebe2b94882f92e89608a36911a6a"/><file name="Grid.php" hash="dc2c1d81f216ad8eb4e540d1ff5fbdd6"/></dir><file name="Pincode.php" hash="a04b25b745be2f898d8b6abc258fcb59"/></dir><file name="Pincode.php" hash="3b7e393170fc4aaadf3a02946385eaa0"/></dir><dir name="Helper"><file name="Data.php" hash="e5ee846f31970a8bc322210bae4ceb09"/></dir><dir name="Model"><dir name="Mysql4"><dir name="Pincode"><file name="Collection.php" hash="3f3ab1a36a7867f69ea0ef8a9861d573"/></dir><file name="Pincode.php" hash="df7f84310351d169d2a57bf87f281f9b"/></dir><file name="Pincode.php" hash="910ef76739e2ab23bf6e201a99df7abb"/><file name="Status.php" hash="ab5df1a5f08b8fab1eaaf13a93639057"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="PincodeController.php" hash="1a2d7151886a024f73b2b50166ec3814"/></dir><file name="IndexController.php" hash="2062fb83647d1b55a0c2f1440f0d3520"/></dir><dir name="etc"><file name="config.xml" hash="1afd3c22dc6f762725456ec615633a23"/></dir><dir name="sql"><dir name="pincode_setup"><file name="mysql4-install-0.1.0.php" hash="d97a69e6ccebb9bbf2bf620a6206755f"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="pincode.xml" hash="334c1c090c1232a0c49337d3220aa3b3"/></dir><dir name="template"><dir name="pincode"><file name="sales_report.phtml" hash="c7eb296a83ccda93d816be129eb642fb"/><file name="sales_report_bkp.phtml" hash="01a11687c17b8504180cc43133994242"/></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Sitegurus_Pincode.xml" hash="b73cfbed670632fc7423c15294d1d5c9"/></dir></target></contents>
16
  <compatible/>
17
- <dependencies><required><php><min>5.0.0</min><max>5.4.0</max></php></required></dependencies>
18
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Sales_Report</name>
4
+ <version>1.0.1</version>
5
  <stability>stable</stability>
6
+ <license>Open Software License (OSL)</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>Area Wise Sales Report extension allows admin to add Pin Codes and Areas from admin interface and get the report of total sale in particular area.</summary>
10
  <description>This extension allows admin to manage (Add/Update/Delete) Pin code and Areas from admin interface and depending on that information admin can have detailed report of the total sell in particular areas with a filter of Date (From - To date).</description>
11
+ <notes>Spaces issue in Postcode is resolved.</notes>
12
  <authors><author><name>Manthan</name><user>manthanext</user><email>manthan18121989@gmail.com</email></author></authors>
13
+ <date>2013-12-30</date>
14
+ <time>17:11:54</time>
15
+ <contents><target name="magelocal"><dir name="Sitegurus"><dir name="Pincode"><dir name="Block"><dir name="Adminhtml"><dir name="Pincode"><dir name="Edit"><file name="Form.php" hash="315e488ed8862b2470a70abfab746adc"/><dir name="Tab"><file name="Form.php" hash="7f7f18b14e3dbed57ab8be5e76e1f93d"/></dir><file name="Tabs.php" hash="a25cd23c11d2bb10916c55de1cd7dee3"/></dir><file name="Edit.php" hash="f801ebe2b94882f92e89608a36911a6a"/><file name="Grid.php" hash="dc2c1d81f216ad8eb4e540d1ff5fbdd6"/></dir><file name="Pincode.php" hash="a04b25b745be2f898d8b6abc258fcb59"/></dir><file name="Pincode.php" hash="3b7e393170fc4aaadf3a02946385eaa0"/></dir><dir name="Helper"><file name="Data.php" hash="e5ee846f31970a8bc322210bae4ceb09"/></dir><dir name="Model"><dir name="Mysql4"><dir name="Pincode"><file name="Collection.php" hash="3f3ab1a36a7867f69ea0ef8a9861d573"/></dir><file name="Pincode.php" hash="df7f84310351d169d2a57bf87f281f9b"/></dir><file name="Pincode.php" hash="910ef76739e2ab23bf6e201a99df7abb"/><file name="Status.php" hash="ab5df1a5f08b8fab1eaaf13a93639057"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="PincodeController.php" hash="0d19d85e5848f54e259274a0e5f29804"/></dir><file name="IndexController.php" hash="2062fb83647d1b55a0c2f1440f0d3520"/></dir><dir name="etc"><file name="config.xml" hash="1afd3c22dc6f762725456ec615633a23"/></dir><dir name="sql"><dir name="pincode_setup"><file name="mysql4-install-0.1.0.php" hash="d97a69e6ccebb9bbf2bf620a6206755f"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="pincode.xml" hash="334c1c090c1232a0c49337d3220aa3b3"/></dir><dir name="template"><dir name="pincode"><file name="sales_report.phtml" hash="d4d4ddcff4f96644f46ac23b8ec9e406"/><file name="sales_report_bkp.phtml" hash="01a11687c17b8504180cc43133994242"/></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Sitegurus_Pincode.xml" hash="b73cfbed670632fc7423c15294d1d5c9"/></dir></target></contents>
16
  <compatible/>
17
+ <dependencies><required><php><min>5.0.0</min><max>6.0.0</max></php></required></dependencies>
18
  </package>