/modules/mod_articles_archive/helper.php

<?php
/**
 * @version		$Id$
 * @package		Joomla.Site
 * @subpackage	mod_articles_archive
 * @copyright	Copyright (C) 2005 - 2010 Open Source Matters, Inc. All rights reserved.
 * @license		GNU General Public License version 2 or later; see LICENSE.txt
 */

// no direct access
defined('_JEXEC') or die;

class modArchiveHelper
{
	function getList(&$params)
	{
		//get database
		$db = &JFactory::getDbo();

		$query = new JQuery;
		$query->select('MONTH(created) AS created_month, created, id, title, YEAR(created) AS created_year');
		$query->from('#__content');
		$query->where('state = -1 AND checked_out = 0');
		$query->group('created_year DESC, created_month DESC');
		
		// $query = 'SELECT MONTH(created) AS created_month, created, id, title, YEAR(created) AS created_year' .
		//	' FROM #__content' .
		//	' WHERE (state = -1 AND checked_out = 0)' .
		//	' GROUP BY created_year DESC, created_month DESC';
		$db->setQuery($query, 0, intval($params->get('count')));
		$rows = $db->loadObjectList();

		$menu = &JSite::getMenu();
		$item = $menu->getItems('link', 'index.php?option=com_content&view=archive', true);
		$itemid = isset($item) ? '&Itemid='.$item->id : '';

		$i		= 0;
		$lists	= array();
		foreach ($rows as $row)
		{
			$date = &JFactory::getDate($row->created);

			$created_month	= $date->toFormat("%m");
			$month_name		= $date->toFormat("%B");
			$created_year	= $date->toFormat("%Y");

			$lists[$i]->link	= JRoute::_('index.php?option=com_content&view=archive&year='.$created_year.'&month='.$created_month.$itemid);
			$lists[$i]->text	= $month_name.', '.$created_year;
			$i++;
		}
		return $lists;
	}
}