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>
|
