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.
|
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 |
<stability>stable</stability>
|
6 |
<license>Open GPL</license>
|
7 |
<channel>community</channel>
|
@@ -48,11 +48,11 @@ This module includes the following reports to Magento:
|
|
48 |
</ul>
|
49 |

|
50 |
<p>Thus, if a product is in several categories, it will be counted as a sale for all of these categories.</p></description>
|
51 |
-
<notes>-
|
52 |
<authors><author><name>Digital Pianism</name><user>digitalpianism</user><email>contact@digital-pianism.com</email></author></authors>
|
53 |
-
<date>2015-
|
54 |
-
<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="
|
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 |
</ul>
|
49 |

|
50 |
<p>Thus, if a product is in several categories, it will be counted as a sale for all of these categories.</p></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>
|