/**
* _lifetime function.
*
* @access private
* @return void
*/
function _lifetime()
{
$database = JFactory::getDBO();
$today = CitruscartHelperBase::getToday();
Citruscart::load('CitruscartHelperOrder', 'helpers.order');
$firstsale_date = CitruscartHelperOrder::getDateMarginalOrder($this->getStatesCSV(), 'ASC');
$lastsale_date = CitruscartHelperOrder::getDateMarginalOrder($this->getStatesCSV(), 'DESC');
$return = $this->_getDateDb($firstsale_date, $lastsale_date);
$days = $return->days_in_business > 0 ? $return->days_in_business : 1;
$return->average_daily = $return->num / $days;
return $return;
}
/**
* Method to get date of the first or the last order
*
* @access private
* @return void
*/
public static function getDateMarginalOrder($states, $order = 'ASC')
{
$db = JFactory::getDBO();
$today = CitruscartHelperBase::getToday();
$q = new CitruscartQuery();
$q->select('tbl.created_date AS date');
$q->from('#__citruscart_orders AS tbl');
$q->where(" tbl.order_state_id IN ( " . $states . " ) ");
$q->order(" tbl.created_date " . $order);
$db->setQuery((string) $q);
$return = $db->loadObject();
if ($return) {
$return = $return->date;
} else {
$return = $today;
}
return $return;
}
