IR_Neatly_Reporting - Version 1.1.2.0

Version Notes

Added LIKE SKU search (search for an SKU group and include child products in metric counts).

Download this release

Release Info

Developer Jon Leighton
Extension IR_Neatly_Reporting
Version 1.1.2.0
Comparing to
See all releases


Code changes from version 1.1.1.0 to 1.1.2.0

Files changed (16) hide show
  1. app/code/community/IR/.DS_Store +0 -0
  2. app/code/community/IR/Neatly/.DS_Store +0 -0
  3. app/code/community/IR/Neatly/Block/Adminhtml/Version.php +0 -0
  4. app/code/community/IR/Neatly/Exception/Api.php +0 -0
  5. app/code/community/IR/Neatly/Helper/Data.php +1 -1
  6. app/code/community/IR/Neatly/Model/Reports/Abstract.php +0 -0
  7. app/code/community/IR/Neatly/Model/Reports/Customers.php +0 -0
  8. app/code/community/IR/Neatly/Model/Reports/Export.php +0 -14
  9. app/code/community/IR/Neatly/Model/Reports/Reporting.php +2 -1
  10. app/code/community/IR/Neatly/Model/Reports/Sales.php +0 -0
  11. app/code/community/IR/Neatly/{Controllers → controllers}/IndexController.php +0 -0
  12. app/code/community/IR/Neatly/etc/adminhtml.xml +0 -0
  13. app/code/community/IR/Neatly/etc/config.xml +1 -1
  14. app/code/community/IR/Neatly/etc/system.xml +0 -0
  15. app/etc/modules/IR_Neatly.xml +0 -0
  16. package.xml +30 -28
app/code/community/IR/.DS_Store ADDED
Binary file
app/code/community/IR/Neatly/.DS_Store ADDED
Binary file
app/code/community/IR/Neatly/Block/Adminhtml/Version.php CHANGED
File without changes
app/code/community/IR/Neatly/Exception/Api.php CHANGED
File without changes
app/code/community/IR/Neatly/Helper/Data.php CHANGED
@@ -6,7 +6,7 @@
6
  */
7
  class IR_Neatly_Helper_Data extends Mage_Core_Helper_Data
8
  {
9
- const VERSION = '1.1.1.0';
10
 
11
  /**
12
  * Checks whether JSON can be rendered at the /neatly endpoint.
6
  */
7
  class IR_Neatly_Helper_Data extends Mage_Core_Helper_Data
8
  {
9
+ const VERSION = '1.1.2.0';
10
 
11
  /**
12
  * Checks whether JSON can be rendered at the /neatly endpoint.
app/code/community/IR/Neatly/Model/Reports/Abstract.php CHANGED
File without changes
app/code/community/IR/Neatly/Model/Reports/Customers.php CHANGED
File without changes
app/code/community/IR/Neatly/Model/Reports/Export.php CHANGED
@@ -1,18 +1,4 @@
1
  <?php
2
- function print_d()
3
- {
4
- echo "<pre>\n";
5
- foreach (func_get_args() as $object) {
6
- if (is_null($object)) {
7
- var_dump($object);
8
- } else {
9
- print_r($object);
10
- }
11
- echo "\n";
12
- }
13
- echo "</pre>";
14
- exit;
15
- }
16
 
17
  use IR_Neatly_Exception_Api as ApiException;
18
 
1
  <?php
 
 
 
 
 
 
 
 
 
 
 
 
 
 
2
 
3
  use IR_Neatly_Exception_Api as ApiException;
4
 
app/code/community/IR/Neatly/Model/Reports/Reporting.php CHANGED
@@ -289,7 +289,8 @@ class IR_Neatly_Model_Reports_Reporting extends IR_Neatly_Model_Reports_Abstract
289
 
290
  // if sku set.
291
  if ($options['sku']) {
292
- $query->where('sfoi.sku = ?', $options['sku']);
 
293
  } else {
294
  // join any attributes and categories set.
295
  $this->joinAttributes($query, $options['attributes'])
289
 
290
  // if sku set.
291
  if ($options['sku']) {
292
+ #$query->where('sfoi.sku = ?', $options['sku']);
293
+ $query->where('sfoi.sku LIKE ?', "{$options['sku']}%");
294
  } else {
295
  // join any attributes and categories set.
296
  $this->joinAttributes($query, $options['attributes'])
app/code/community/IR/Neatly/Model/Reports/Sales.php CHANGED
File without changes
app/code/community/IR/Neatly/{Controllers → controllers}/IndexController.php RENAMED
File without changes
app/code/community/IR/Neatly/etc/adminhtml.xml CHANGED
File without changes
app/code/community/IR/Neatly/etc/config.xml CHANGED
@@ -1,7 +1,7 @@
1
  <config>
2
  <modules>
3
  <IR_Neatly>
4
- <version>0.1.0</version>
5
  </IR_Neatly>
6
  </modules>
7
  <global>
1
  <config>
2
  <modules>
3
  <IR_Neatly>
4
+ <version>1.1.2.0</version>
5
  </IR_Neatly>
6
  </modules>
7
  <global>
app/code/community/IR/Neatly/etc/system.xml CHANGED
File without changes
app/etc/modules/IR_Neatly.xml CHANGED
File without changes
package.xml CHANGED
@@ -1,46 +1,48 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>IR_Neatly_Reporting</name>
4
- <version>1.1.1.0</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.gnu.org/copyleft/gpl.html">GNU General Public License (GPL)</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>View a range of detailed reports about your sales, products and customers from your Neatly dashboard.</summary>
10
- <description>This extension allows Neatly to pull and generate detailed reports about your sales, customers and products.&#xD;
11
  &#xD;
12
- Simply install the extension and enter your API key and you will be able to view the following data:&#xD;
13
  &#xD;
14
  &lt;ul&gt;&#xD;
15
- &lt;li&gt;Sales Overview&lt;/li&gt;&#xD;
16
- &lt;li&gt;Sales by Category&lt;/li&gt;&#xD;
17
- &lt;li&gt;Top Products&lt;/li&gt;&#xD;
18
- &lt;li&gt;Sales by Customer Group&lt;/li&gt;&#xD;
19
- &lt;li&gt;Sales by City&lt;/li&gt;&#xD;
20
- &lt;li&gt;Sales by Hour&lt;/li&gt;&#xD;
21
- &lt;li&gt;Sales by Day&lt;/li&gt;&#xD;
22
- &lt;li&gt;New vs Returning Customers&lt;/li&gt;&#xD;
23
- &lt;li&gt;Sales by Payment Type&lt;/li&gt;&#xD;
24
- &lt;li&gt;Sales by Country&lt;/li&gt;&#xD;
25
  &lt;/ul&gt;&#xD;
26
- You can also compare data against previous period of custom your date range comparison.&#xD;
27
- You can also create your own dashboard and compare against a wide range of metrics including Google Analytics.&#xD;
28
- Customer Search Filter&#xD;
29
- Want to send targeted emails to a specific group of customers?&#xD;
30
- Use our customer search feature to segment your customers and export as a CSV or export directly to Mailchimp.&#xD;
31
- Search for customers based on:&#xD;
 
32
  &lt;ul&gt;&#xD;
33
- &lt;li&gt;Number of Orders&lt;/li&gt;&#xD;
34
- &lt;li&gt;Order Value&lt;/li&gt;&#xD;
35
- &lt;li&gt;Product SKU&lt;/li&gt;&#xD;
36
- &lt;li&gt;City/Postcode&lt;/li&gt;&#xD;
37
  &lt;/ul&gt;&#xD;
38
- So if you want to reward your top customers or determine who has shopped with you for a while then this is the tool for you.</description>
39
- <notes>Added extension version number to admin configuration.</notes>
 
40
  <authors><author><name>Jon Leighton</name><user>iResources</user><email>j.leighton@i-resources.co.uk</email></author></authors>
41
- <date>2015-11-02</date>
42
- <time>16:43:50</time>
43
- <contents><target name="magecommunity"><dir name="IR"><dir name="Neatly"><dir name="Block"><dir name="Adminhtml"><file name="Version.php" hash="792a2ccf75775467ea34bbbf5df833c6"/></dir></dir><dir name="Controllers"><file name="IndexController.php" hash="27414d6c02230a52e64b457783d58273"/></dir><dir name="Exception"><file name="Api.php" hash="079a77634e425c151fcc97e9d67a2ebf"/></dir><dir name="Helper"><file name="Data.php" hash="c794f5a53f13b818dc9f200238773333"/></dir><dir name="Model"><dir name="Reports"><file name="Abstract.php" hash="5b908c879ffa6974085fedb19b530959"/><file name="Customers.php" hash="f6af2cf717dbb7d121d643d1171d6ccf"/><file name="Export.php" hash="dd905d7aa3ecbdc0e4e7ffa37d586c86"/><file name="Reporting.php" hash="86a6d7066041ce3e7206d6059c986da3"/><file name="Sales.php" hash="6b0fb8adb0ec9cbf283508fe59adb797"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="98b2b738856967354adade75f1830a9c"/><file name="config.xml" hash="33268e3951cce566d47534e7114cbe60"/><file name="system.xml" hash="cc0b1f5b0b6d340fabb3c221161436a7"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="IR_Neatly.xml" hash="8cfc6d5b71ff25155628d065d6a7335b"/></dir></target></contents>
44
  <compatible/>
45
  <dependencies><required><php><min>5.4.0</min><max>5.6.9</max></php></required></dependencies>
46
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>IR_Neatly_Reporting</name>
4
+ <version>1.1.2.0</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.gnu.org/copyleft/gpl.html">GNU General Public License (GPL)</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>View a range of detailed reports about your sales, products and customers from your Neatly dashboard.</summary>
10
+ <description>&lt;p&gt;This extension allows Neatly to pull and generate detailed reports about your sales, customers and products.&lt;/p&gt;&#xD;
11
  &#xD;
12
+ &lt;p&gt;Simply install the extension and enter your API key and you will be able to view the following data:&lt;/p&gt;&#xD;
13
  &#xD;
14
  &lt;ul&gt;&#xD;
15
+ &lt;li&gt;Sales Overview&lt;/li&gt;&#xD;
16
+ &lt;li&gt;Sales by Category&lt;/li&gt;&#xD;
17
+ &lt;li&gt;Top Products&lt;/li&gt;&#xD;
18
+ &lt;li&gt;Sales by Customer Group&lt;/li&gt;&#xD;
19
+ &lt;li&gt;Sales by City&lt;/li&gt;&#xD;
20
+ &lt;li&gt;Sales by Hour&lt;/li&gt;&#xD;
21
+ &lt;li&gt;Sales by Day&lt;/li&gt;&#xD;
22
+ &lt;li&gt;New vs Returning Customers&lt;/li&gt;&#xD;
23
+ &lt;li&gt;Sales by Payment Type&lt;/li&gt;&#xD;
24
+ &lt;li&gt;Sales by Country&lt;/li&gt;&#xD;
25
  &lt;/ul&gt;&#xD;
26
+ &#xD;
27
+ &lt;p&gt;You can also compare data against previous period of custom your date range comparison. You can also create your own dashboard and compare against a wide range of metrics including Google Analytics. &lt;/p&gt;&#xD;
28
+ &#xD;
29
+ &lt;p&gt;Customer Search Filter Want to send targeted emails to a specific group of customers? Use our customer search feature to segment your customers and export as a CSV or export directly to Mailchimp.&lt;/p&gt;&#xD;
30
+ &#xD;
31
+ &lt;p&gt;Search for customers based on:&lt;/p&gt;&#xD;
32
+ &#xD;
33
  &lt;ul&gt;&#xD;
34
+ &lt;li&gt;Number of Orders&lt;/li&gt;&#xD;
35
+ &lt;li&gt;Order Value&lt;/li&gt;&#xD;
36
+ &lt;li&gt;Product SKU&lt;/li&gt;&#xD;
37
+ &lt;li&gt;City/Postcode&lt;/li&gt;&#xD;
38
  &lt;/ul&gt;&#xD;
39
+ &#xD;
40
+ &lt;p&gt;So if you want to reward your top customers or determine who has shopped with you for a while then this is the tool for you.&lt;/p&gt;</description>
41
+ <notes>Added LIKE SKU search (search for an SKU group and include child products in metric counts).</notes>
42
  <authors><author><name>Jon Leighton</name><user>iResources</user><email>j.leighton@i-resources.co.uk</email></author></authors>
43
+ <date>2015-11-10</date>
44
+ <time>14:01:58</time>
45
+ <contents><target name="magecommunity"><dir name="IR"><dir name="Neatly"><dir name="Block"><dir name="Adminhtml"><file name="Version.php" hash="792a2ccf75775467ea34bbbf5df833c6"/></dir></dir><dir name="Exception"><file name="Api.php" hash="079a77634e425c151fcc97e9d67a2ebf"/></dir><dir name="Helper"><file name="Data.php" hash="97f05fdb918b6262a844207355695557"/></dir><dir name="Model"><dir name="Reports"><file name="Abstract.php" hash="5b908c879ffa6974085fedb19b530959"/><file name="Customers.php" hash="f6af2cf717dbb7d121d643d1171d6ccf"/><file name="Export.php" hash="a49ca83d9c689ba6dac9a18bd6dad0a1"/><file name="Reporting.php" hash="18d1aca9041a641a833f709a7ce1c304"/><file name="Sales.php" hash="6b0fb8adb0ec9cbf283508fe59adb797"/></dir></dir><dir name="controllers"><file name="IndexController.php" hash="27414d6c02230a52e64b457783d58273"/></dir><dir name="etc"><file name="adminhtml.xml" hash="98b2b738856967354adade75f1830a9c"/><file name="config.xml" hash="0becd70667796f8746d1b2d9d39108cd"/><file name="system.xml" hash="cc0b1f5b0b6d340fabb3c221161436a7"/></dir><file name=".DS_Store" hash="601020d0d1c6b7a09b8efd396666f583"/></dir><file name=".DS_Store" hash="3bb9d4dfd270501ac06721b1a902801b"/></dir></target><target name="mageetc"><dir name="modules"><file name="IR_Neatly.xml" hash="8cfc6d5b71ff25155628d065d6a7335b"/></dir></target></contents>
46
  <compatible/>
47
  <dependencies><required><php><min>5.4.0</min><max>5.6.9</max></php></required></dependencies>
48
  </package>