00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032
00033
00034
00035 class Mage_Reports_Model_Mysql4_Coupons_Collection extends Mage_Sales_Model_Entity_Order_Collection
00036 {
00037
00038 protected $_from = '';
00039 protected $_to = '';
00040
00041 public function setDateRange($from, $to)
00042 {
00043 $this->_from = $from;
00044 $this->_to = $to;
00045 $this->_reset();
00046 return $this;
00047 }
00048
00049 public function setStoreIds($storeIds)
00050 {
00051 $this->joinFields($this->_from, $this->_to, $storeIds);
00052 return $this;
00053 }
00054
00055 public function joinFields($from, $to, $storeIds = array())
00056 {
00057 $this->groupByAttribute('coupon_code')
00058 ->addAttributeToFilter('created_at', array('from' => $from, 'to' => $to, 'datetime' => true))
00059 ->addAttributeToFilter('coupon_code', array('neq' => ''))
00060 ->getselect()->from('', array('uses' => 'COUNT(e.entity_id)'))
00061 ->having('uses > 0')
00062 ->order('uses desc');
00063
00064 $storeIds = array_values($storeIds);
00065 if (count($storeIds) >= 1 && $storeIds[0] != '') {
00066 $this->addAttributeToFilter('store_id', array('in' => $storeIds));
00067 $this->addExpressionAttributeToSelect(
00068 'subtotal',
00069 'SUM({{base_subtotal}})',
00070 array('base_subtotal'))
00071 ->addExpressionAttributeToSelect(
00072 'discount',
00073 'SUM({{base_discount_amount}})',
00074 array('base_discount_amount'))
00075 ->addExpressionAttributeToSelect(
00076 'total',
00077 'SUM({{base_subtotal}}-{{base_discount_amount}})',
00078 array('base_subtotal', 'base_discount_amount'));
00079 } else {
00080 $this->addExpressionAttributeToSelect(
00081 'subtotal',
00082 'SUM({{base_subtotal}}*{{base_to_global_rate}})',
00083 array('base_subtotal', 'base_to_global_rate'))
00084 ->addExpressionAttributeToSelect(
00085 'discount',
00086 'SUM({{base_discount_amount}}*{{base_to_global_rate}})',
00087 array('base_discount_amount', 'base_to_global_rate'))
00088 ->addExpressionAttributeToSelect(
00089 'total',
00090 'SUM(({{base_subtotal}}-{{base_discount_amount}})*{{base_to_global_rate}})',
00091 array('base_subtotal', 'base_discount_amount', 'base_to_global_rate'));
00092 }
00093 }
00094
00095 public function getSelectCountSql()
00096 {
00097 $countSelect = clone $this->getSelect();
00098 $countSelect->reset(Zend_Db_Select::ORDER);
00099 $countSelect->reset(Zend_Db_Select::LIMIT_COUNT);
00100 $countSelect->reset(Zend_Db_Select::LIMIT_OFFSET);
00101 $countSelect->reset(Zend_Db_Select::COLUMNS);
00102 $countSelect->reset(Zend_Db_Select::GROUP);
00103 $countSelect->reset(Zend_Db_Select::HAVING);
00104 $countSelect->from("", "count(DISTINCT main_table.rule_id)");
00105 $sql = $countSelect->__toString();
00106 return $sql;
00107 }
00108 }