/** * _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; }