DigitalPianism_CustomReports - Version 0.1.6

Version Notes

- Add database table prefix to the wishlist report.

Download this release

Release Info

Developer Digital Pianism
Extension DigitalPianism_CustomReports
Version 0.1.6
Comparing to
See all releases


Code changes from version 0.1.5 to 0.1.6

app/code/community/DigitalPianism/CustomReports/Block/Wishlist/Grid.php CHANGED
@@ -1 +1 @@
1
- <?php
2
  * Class DigitalPianism_CustomReports_Block_Wishlist_Grid
3
  */
4
  protected $filterArray = array();
5
  /**
6
  *
7
  */
8
  public function __construct()
9
  {
10
  parent::__construct();
11
  $this->setId('wishlistReportGrid');
12
  $this->setDefaultSort('updated_at');
13
  $this->setDefaultDir('desc');
14
  }
15
  /**
16
  * @param $args
17
  */
18
  public function fillArray($args)
19
  {
20
  return $this->filterArray;
21
  }
22
  /**
23
  * @return $this
24
  * @throws Zend_Date_Exception
25
  */
26
  protected function _prepareCollection()
27
  {
28
  else
29
  else
30
  $end = new Zend_Date($eDate);
31
  $collection = Mage::getModel('wishlist/wishlist')
32
  $this->setCollection($collection);
33
  parent::_prepareCollection();
34
  return $this;
35
  }
36
  /**
37
  * @return $this
38
  * @throws Exception
39
  */
40
  protected function _prepareColumns()
41
  {
42
  $this->addColumn('wishlist_id', array(
43
  'header' =>Mage::helper('reports')->__('Wishlist ID'),
44
  'width' =>'50px',
45
  'index' =>'wishlist_id'
46
  ));
47
  $this->addColumn('customer_id', array(
48
  'header' =>Mage::helper('reports')->__('Customer ID'),
49
  'index' =>'customer_id'
50
  ));
51
  'header' =>Mage::helper('reports')->__('Customer Email'),
52
  'index' =>'email'
53
  ));
54
  'header' =>Mage::helper('reports')->__('Has Been Shared ?'),
55
  'index' =>'shared',
56
  'options' => array(
57
  0 => Mage::helper('reports')->__('No'),
58
  1 => Mage::helper('reports')->__('Yes')
59
  )
60
  ));
61
  $this->addColumn('updated_at', array(
62
  'header' =>Mage::helper('reports')->__('Updated At'),
63
  'align' =>'right',
64
  'index' =>'updated_at',
65
  'filter_index' =>'main_table.updated_at'
66
  ));
67
  array(
68
  'header' => Mage::helper('reports')->__('Action'),
69
  'width' => '100',
70
  'type' => 'action',
71
  'getter' => 'getCustomerId',
72
  'actions' => array(
73
  array(
74
  'caption' => Mage::helper('reports')->__('Edit Customer'),
75
  'url' => array('base'=> 'adminhtml/customer/edit'),
76
  'field' => 'id'
77
  )
78
  ),
79
  'filter' => false,
80
  'sortable' => false,
81
  'index' => 'stores',
82
  'is_system' => true,
83
  ));
84
  $this->addExportType('*/*/exportWishlistCsv', Mage::helper('reports')->__('CSV'));
85
  $this->addExportType('*/*/exportWishlistExcel', Mage::helper('reports')->__('Excel'));
86
  return parent::_prepareColumns();
87
  }
 
88
  * Class DigitalPianism_CustomReports_Block_Wishlist_Grid
89
  */
90
  protected $filterArray = array();
91
  /**
92
  *
93
  */
94
  public function __construct()
95
  {
96
  parent::__construct();
97
  $this->setId('wishlistReportGrid');
98
  $this->setDefaultSort('updated_at');
99
  $this->setDefaultDir('desc');
100
  }
101
  /**
102
  * @param $args
103
  */
104
  public function fillArray($args)
105
  {
106
  return $this->filterArray;
107
  }
108
  /**
109
  * @return $this
110
  * @throws Zend_Date_Exception
111
  */
112
  protected function _prepareCollection()
113
  {
114
  else
115
  else
116
  $end = new Zend_Date($eDate);
117
  $collection = Mage::getModel('wishlist/wishlist')
118
  $this->setCollection($collection);
119
  parent::_prepareCollection();
120
  return $this;
121
  }
122
  /**
123
  * @return $this
124
  * @throws Exception
125
  */
126
  protected function _prepareColumns()
127
  {
128
  $this->addColumn('wishlist_id', array(
129
  'header' =>Mage::helper('reports')->__('Wishlist ID'),
130
  'width' =>'50px',
131
  'index' =>'wishlist_id'
132
  ));
133
  $this->addColumn('customer_id', array(
134
  'header' =>Mage::helper('reports')->__('Customer ID'),
135
  'index' =>'customer_id'
136
  ));
137
  'header' =>Mage::helper('reports')->__('Customer Email'),
138
  'index' =>'email'
139
  ));
140
  'header' =>Mage::helper('reports')->__('Has Been Shared ?'),
141
  'index' =>'shared',
142
  'options' => array(
143
  0 => Mage::helper('reports')->__('No'),
144
  1 => Mage::helper('reports')->__('Yes')
145
  )
146
  ));
147
  $this->addColumn('updated_at', array(
148
  'header' =>Mage::helper('reports')->__('Updated At'),
149
  'align' =>'right',
150
  'index' =>'updated_at',
151
  'filter_index' =>'main_table.updated_at'
152
  ));
153
  array(
154
  'header' => Mage::helper('reports')->__('Action'),
155
  'width' => '100',
156
  'type' => 'action',
157
  'getter' => 'getCustomerId',
158
  'actions' => array(
159
  array(
160
  'caption' => Mage::helper('reports')->__('Edit Customer'),
161
  'url' => array('base'=> 'adminhtml/customer/edit'),
162
  'field' => 'id'
163
  )
164
  ),
165
  'filter' => false,
166
  'sortable' => false,
167
  'index' => 'stores',
168
  'is_system' => true,
169
  ));
170
  $this->addExportType('*/*/exportWishlistCsv', Mage::helper('reports')->__('CSV'));
171
  $this->addExportType('*/*/exportWishlistExcel', Mage::helper('reports')->__('Excel'));
172
  return parent::_prepareColumns();
173
  }
 
1
  * Class DigitalPianism_CustomReports_Block_Wishlist_Grid
2
  */
3
  protected $filterArray = array();
4
  /**
5
  *
6
  */
7
  public function __construct()
8
  {
9
  parent::__construct();
10
  $this->setId('wishlistReportGrid');
11
  $this->setDefaultSort('updated_at');
12
  $this->setDefaultDir('desc');
13
  }
14
  /**
15
  * @param $args
16
  */
17
  public function fillArray($args)
18
  {
19
  return $this->filterArray;
20
  }
21
  /**
22
  * @return $this
23
  * @throws Zend_Date_Exception
24
  */
25
  protected function _prepareCollection()
26
  {
27
  else
28
  else
29
  $end = new Zend_Date($eDate);
30
  $collection = Mage::getModel('wishlist/wishlist')
31
  $this->setCollection($collection);
32
  parent::_prepareCollection();
33
  return $this;
34
  }
35
  /**
36
  * @return $this
37
  * @throws Exception
38
  */
39
  protected function _prepareColumns()
40
  {
41
  $this->addColumn('wishlist_id', array(
42
  'header' =>Mage::helper('reports')->__('Wishlist ID'),
43
  'width' =>'50px',
44
  'index' =>'wishlist_id'
45
  ));
46
  $this->addColumn('customer_id', array(
47
  'header' =>Mage::helper('reports')->__('Customer ID'),
48
  'index' =>'customer_id'
49
  ));
50
  'header' =>Mage::helper('reports')->__('Customer Email'),
51
  'index' =>'email'
52
  ));
53
  'header' =>Mage::helper('reports')->__('Has Been Shared ?'),
54
  'index' =>'shared',
55
  'options' => array(
56
  0 => Mage::helper('reports')->__('No'),
57
  1 => Mage::helper('reports')->__('Yes')
58
  )
59
  ));
60
  $this->addColumn('updated_at', array(
61
  'header' =>Mage::helper('reports')->__('Updated At'),
62
  'align' =>'right',
63
  'index' =>'updated_at',
64
  'filter_index' =>'main_table.updated_at'
65
  ));
66
  array(
67
  'header' => Mage::helper('reports')->__('Action'),
68
  'width' => '100',
69
  'type' => 'action',
70
  'getter' => 'getCustomerId',
71
  'actions' => array(
72
  array(
73
  'caption' => Mage::helper('reports')->__('Edit Customer'),
74
  'url' => array('base'=> 'adminhtml/customer/edit'),
75
  'field' => 'id'
76
  )
77
  ),
78
  'filter' => false,
79
  'sortable' => false,
80
  'index' => 'stores',
81
  'is_system' => true,
82
  ));
83
  $this->addExportType('*/*/exportWishlistCsv', Mage::helper('reports')->__('CSV'));
84
  $this->addExportType('*/*/exportWishlistExcel', Mage::helper('reports')->__('Excel'));
85
  return parent::_prepareColumns();
86
  }
87
+ <?php
88
  * Class DigitalPianism_CustomReports_Block_Wishlist_Grid
89
  */
90
  protected $filterArray = array();
91
  /**
92
  *
93
  */
94
  public function __construct()
95
  {
96
  parent::__construct();
97
  $this->setId('wishlistReportGrid');
98
  $this->setDefaultSort('updated_at');
99
  $this->setDefaultDir('desc');
100
  }
101
  /**
102
  * @param $args
103
  */
104
  public function fillArray($args)
105
  {
106
  return $this->filterArray;
107
  }
108
  /**
109
  * @return $this
110
  * @throws Zend_Date_Exception
111
  */
112
  protected function _prepareCollection()
113
  {
114
  else
115
  else
116
  $end = new Zend_Date($eDate);
117
  $collection = Mage::getModel('wishlist/wishlist')
118
  $this->setCollection($collection);
119
  parent::_prepareCollection();
120
  return $this;
121
  }
122
  /**
123
  * @return $this
124
  * @throws Exception
125
  */
126
  protected function _prepareColumns()
127
  {
128
  $this->addColumn('wishlist_id', array(
129
  'header' =>Mage::helper('reports')->__('Wishlist ID'),
130
  'width' =>'50px',
131
  'index' =>'wishlist_id'
132
  ));
133
  $this->addColumn('customer_id', array(
134
  'header' =>Mage::helper('reports')->__('Customer ID'),
135
  'index' =>'customer_id'
136
  ));
137
  'header' =>Mage::helper('reports')->__('Customer Email'),
138
  'index' =>'email'
139
  ));
140
  'header' =>Mage::helper('reports')->__('Has Been Shared ?'),
141
  'index' =>'shared',
142
  'options' => array(
143
  0 => Mage::helper('reports')->__('No'),
144
  1 => Mage::helper('reports')->__('Yes')
145
  )
146
  ));
147
  $this->addColumn('updated_at', array(
148
  'header' =>Mage::helper('reports')->__('Updated At'),
149
  'align' =>'right',
150
  'index' =>'updated_at',
151
  'filter_index' =>'main_table.updated_at'
152
  ));
153
  array(
154
  'header' => Mage::helper('reports')->__('Action'),
155
  'width' => '100',
156
  'type' => 'action',
157
  'getter' => 'getCustomerId',
158
  'actions' => array(
159
  array(
160
  'caption' => Mage::helper('reports')->__('Edit Customer'),
161
  'url' => array('base'=> 'adminhtml/customer/edit'),
162
  'field' => 'id'
163
  )
164
  ),
165
  'filter' => false,
166
  'sortable' => false,
167
  'index' => 'stores',
168
  'is_system' => true,
169
  ));
170
  $this->addExportType('*/*/exportWishlistCsv', Mage::helper('reports')->__('CSV'));
171
  $this->addExportType('*/*/exportWishlistExcel', Mage::helper('reports')->__('Excel'));
172
  return parent::_prepareColumns();
173
  }
app/code/community/DigitalPianism/CustomReports/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <DigitalPianism_CustomReports>
5
- <version>0.1.5</version>
6
  </DigitalPianism_CustomReports>
7
  </modules>
8
 
2
  <config>
3
  <modules>
4
  <DigitalPianism_CustomReports>
5
+ <version>0.1.6</version>
6
  </DigitalPianism_CustomReports>
7
  </modules>
8
 
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>DigitalPianism_CustomReports</name>
4
- <version>0.1.5</version>
5
  <stability>stable</stability>
6
  <license>Open GPL</license>
7
  <channel>community</channel>
@@ -48,11 +48,11 @@ This module includes the following reports to Magento:&#xD;
48
  &lt;/ul&gt;&#xD;
49
  &#xD;
50
  &lt;p&gt;Thus, if a product is in several categories, it will be counted as a sale for all of these categories.&lt;/p&gt;</description>
51
- <notes>- Modify the admin route regarding Magento patch SUPEE-6788</notes>
52
  <authors><author><name>Digital Pianism</name><user>digitalpianism</user><email>contact@digital-pianism.com</email></author></authors>
53
- <date>2015-10-23</date>
54
- <time>16:33:40</time>
55
- <contents><target name="magecommunity"><dir name="DigitalPianism"><dir name="CustomReports"><dir name="Block"><dir name="Bestsellersbycategory"><file name="Grid.php" hash="29ced24f2347175f8ddb3976b17a3a2d"/></dir><file name="Bestsellersbycategory.php" hash="c04a80017dc23a469138915bd608fe33"/><file name="Customreport.php" hash="f3158fc88585c8924a5e6911ce7f9ee8"/><dir name="Lifetimesales"><file name="Grid.php" hash="f34c7c9aa442377b1bbd86fe234b7e5b"/></dir><file name="Lifetimesales.php" hash="a1074d45ffcadd8ceb6facda2566fa44"/><dir name="Noupsells"><file name="Grid.php" hash="4acdcc6742ad53120a3e907b09727e9e"/></dir><file name="Noupsells.php" hash="961b611b3b1a8f7b1ea57bdc4dbb27a6"/><dir name="Shoppedonce"><file name="Grid.php" hash="96e410f92fd88d5f4c21a8fd8203df6d"/></dir><file name="Shoppedonce.php" hash="e09510c61d1c0310739a361cb3e7f4e6"/><dir name="Signedupnoorder"><file name="Grid.php" hash="abb824130a4f365ce15789923c40d090"/></dir><file name="Signedupnoorder.php" hash="4f73318c21eb7f358aa4ab126d16cafe"/><dir name="Wishlist"><file name="Grid.php" hash="347ca1133e187fa791f6de6387794651"/></dir><file name="Wishlist.php" hash="376cbd949ea15e8c1c7f8d28fef66be4"/><dir name="Worstsellers"><file name="Grid.php" hash="4ebd28d28581125fa550b30543940847"/></dir><file name="Worstsellers.php" hash="311266f3a9d7ceccef74f05034205252"/><dir name="Worstsellersbycategory"><file name="Grid.php" hash="eea476f4bf7fdeb9ead5b9c90d91bb64"/></dir><file name="Worstsellersbycategory.php" hash="44f6b369080be2521eaa80797fde9740"/></dir><dir name="Model"><dir name="Reports"><dir name="Resource"><dir name="Product"><file name="Collection.php" hash="d31c0ea1728f3fe13e4efa438c653678"/></dir></dir></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="BestsellersbycategoryController.php" hash="44c28d7f6987c67ccc434be7847ddc4a"/><file name="LifetimesalesController.php" hash="66d5215c45be488839aafa9be07c5f9f"/><file name="NoupsellsController.php" hash="deea247924726caa56cd04bed578d7d8"/><file name="ShoppedonceController.php" hash="d35f0c366ab7b8b087c1cda2707c9784"/><file name="SignedupnoorderController.php" hash="127bf229c6bf8ef8a3c37b375285b9de"/><file name="WishlistController.php" hash="6f54870c276f3547377a55a0911a0775"/><file name="WorstsellersController.php" hash="8f9c233d4bc0b868eebf1a2767d90288"/><file name="WorstsellersbycategoryController.php" hash="1010003544df4469f4e958541ca9b357"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="129b1e3161edd1a4f038943a94890605"/><file name="config.xml" hash="0bc7dc25da85bf5e30e5f5fa1c44abc7"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="DigitalPianism_CustomReports.xml" hash="2244af82c076ed3abf5064672036ef0b"/></dir></target><target name="magelocale"><dir name="en_US"><file name="DigitalPianism_CustomReports.csv" hash="0fcee0228d1044be8c0b76f02079bf55"/></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="digitalpianism"><dir name="customreports"><file name="advancedgrid.phtml" hash="0254a130e6c76bf9c8f7a9b7ce1d27ca"/><file name="grid.phtml" hash="a8d2cbad8327390e2b9cd3b7717c384d"/></dir></dir></dir></dir></dir></dir></target></contents>
56
  <compatible/>
57
  <dependencies><required><php><min>4.1.0</min><max>6.0.0</max></php></required></dependencies>
58
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>DigitalPianism_CustomReports</name>
4
+ <version>0.1.6</version>
5
  <stability>stable</stability>
6
  <license>Open GPL</license>
7
  <channel>community</channel>
48
  &lt;/ul&gt;&#xD;
49
  &#xD;
50
  &lt;p&gt;Thus, if a product is in several categories, it will be counted as a sale for all of these categories.&lt;/p&gt;</description>
51
+ <notes>- Add database table prefix to the wishlist report.</notes>
52
  <authors><author><name>Digital Pianism</name><user>digitalpianism</user><email>contact@digital-pianism.com</email></author></authors>
53
+ <date>2015-11-27</date>
54
+ <time>15:32:11</time>
55
+ <contents><target name="magecommunity"><dir name="DigitalPianism"><dir name="CustomReports"><dir name="Block"><dir name="Bestsellersbycategory"><file name="Grid.php" hash="29ced24f2347175f8ddb3976b17a3a2d"/></dir><file name="Bestsellersbycategory.php" hash="c04a80017dc23a469138915bd608fe33"/><file name="Customreport.php" hash="f3158fc88585c8924a5e6911ce7f9ee8"/><dir name="Lifetimesales"><file name="Grid.php" hash="f34c7c9aa442377b1bbd86fe234b7e5b"/></dir><file name="Lifetimesales.php" hash="a1074d45ffcadd8ceb6facda2566fa44"/><dir name="Noupsells"><file name="Grid.php" hash="4acdcc6742ad53120a3e907b09727e9e"/></dir><file name="Noupsells.php" hash="961b611b3b1a8f7b1ea57bdc4dbb27a6"/><dir name="Shoppedonce"><file name="Grid.php" hash="96e410f92fd88d5f4c21a8fd8203df6d"/></dir><file name="Shoppedonce.php" hash="e09510c61d1c0310739a361cb3e7f4e6"/><dir name="Signedupnoorder"><file name="Grid.php" hash="abb824130a4f365ce15789923c40d090"/></dir><file name="Signedupnoorder.php" hash="4f73318c21eb7f358aa4ab126d16cafe"/><dir name="Wishlist"><file name="Grid.php" hash="0dde433a9bb53f759ec8c21af509d953"/></dir><file name="Wishlist.php" hash="376cbd949ea15e8c1c7f8d28fef66be4"/><dir name="Worstsellers"><file name="Grid.php" hash="4ebd28d28581125fa550b30543940847"/></dir><file name="Worstsellers.php" hash="311266f3a9d7ceccef74f05034205252"/><dir name="Worstsellersbycategory"><file name="Grid.php" hash="eea476f4bf7fdeb9ead5b9c90d91bb64"/></dir><file name="Worstsellersbycategory.php" hash="44f6b369080be2521eaa80797fde9740"/></dir><dir name="Model"><dir name="Reports"><dir name="Resource"><dir name="Product"><file name="Collection.php" hash="d31c0ea1728f3fe13e4efa438c653678"/></dir></dir></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="BestsellersbycategoryController.php" hash="44c28d7f6987c67ccc434be7847ddc4a"/><file name="LifetimesalesController.php" hash="66d5215c45be488839aafa9be07c5f9f"/><file name="NoupsellsController.php" hash="deea247924726caa56cd04bed578d7d8"/><file name="ShoppedonceController.php" hash="d35f0c366ab7b8b087c1cda2707c9784"/><file name="SignedupnoorderController.php" hash="127bf229c6bf8ef8a3c37b375285b9de"/><file name="WishlistController.php" hash="6f54870c276f3547377a55a0911a0775"/><file name="WorstsellersController.php" hash="8f9c233d4bc0b868eebf1a2767d90288"/><file name="WorstsellersbycategoryController.php" hash="1010003544df4469f4e958541ca9b357"/></dir></dir><dir name="etc"><file name="adminhtml.xml" hash="129b1e3161edd1a4f038943a94890605"/><file name="config.xml" hash="180a13004294354dc44287897dbcac16"/></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="DigitalPianism_CustomReports.xml" hash="2244af82c076ed3abf5064672036ef0b"/></dir></target><target name="magelocale"><dir name="en_US"><file name="DigitalPianism_CustomReports.csv" hash="0fcee0228d1044be8c0b76f02079bf55"/></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="template"><dir name="digitalpianism"><dir name="customreports"><file name="advancedgrid.phtml" hash="0254a130e6c76bf9c8f7a9b7ce1d27ca"/><file name="grid.phtml" hash="a8d2cbad8327390e2b9cd3b7717c384d"/></dir></dir></dir></dir></dir></dir></target></contents>
56
  <compatible/>
57
  <dependencies><required><php><min>4.1.0</min><max>6.0.0</max></php></required></dependencies>
58
  </package>