public function popularAction()
{
$request = $this->getRequest();
$category_id = $request->getParam('category_id');
$page = (int) $request->getRequest('page', 1);
if ($page < 1) {
$page = 1;
}
$limit = JO_Registry::get('front_limit');
$order = $request->getRequest('order');
if (is_null($order)) {
$order = 'desc';
}
$sort = $request->getRequest('sort');
if (is_null($sort)) {
$sort = 'sales';
}
if ($sort == 'username') {
$prefix = 'users.';
} else {
$prefix = 'items.';
}
$date = $request->getRequest('date');
if (empty($date)) {
$date = date("m-Y", strtotime("-1 month"));
}
$date_parts = explode('-', $date);
$where = 'MONTH(`paid_datetime`) = \'' . $date_parts[0] . '\' AND YEAR(`paid_datetime`) = \'' . $date_parts[1] . '\'';
$this->view->category['name'] = $this->view->translate('Popular Items');
$this->getLayout()->meta_title = $this->view->category['name'];
$this->getLayout()->meta_description = $this->view->category['name'];
$link = $request->getBaseUrl() . '?controller=categories&action=popular&page_id=date/' . $date;
$this->view->sort_by = array(array('name' => $this->view->translate('title'), 'href' => WM_Router::create($link . '&sort=name'), 'is_selected' => $sort == 'name' ? true : false), array('name' => $this->view->translate('rating'), 'href' => WM_Router::create($link . '&sort=rating'), 'is_selected' => $sort == 'rating' ? true : false), array('name' => $this->view->translate('sales'), 'href' => WM_Router::create($link . '&sort=sales'), 'is_selected' => $sort == 'sales' ? true : false), array('name' => $this->view->translate('price'), 'href' => WM_Router::create($link . '&sort=price'), 'is_selected' => $sort == 'price' ? true : false), array('name' => $this->view->translate('author name'), 'href' => WM_Router::create($link . '&sort=username'), 'is_selected' => $sort == 'username' ? true : false));
/* ORDER */
$link .= '&sort=' . $sort;
$this->view->orders = array(array('name' => '»', 'href' => WM_Router::create($link . '&order=desc'), 'is_selected' => $order == 'desc' ? true : false), array('name' => '«', 'href' => WM_Router::create($link . '&order=asc'), 'is_selected' => $order == 'asc' ? true : false));
/* CRUMBS */
$this->view->crumbs = array();
$this->view->crumbs[] = array('name' => $this->view->translate('Home'), 'href' => $request->getBaseUrl());
$total_records = Model_Items::getTopSellersCount($where);
$start = $page * $limit - $limit;
if ($start > $total_records) {
$last_page = max(ceil($total_records / $limit), 1);
$start = $last_page * $limit - $limit;
} elseif ($start < 0) {
$start = 0;
}
$items = Model_Items::getTopSellers($start, $limit, $where, $prefix . $sort . ' ' . $order);
$categories = Model_Items::getPopularFilesDates();
if ($categories) {
$this->view->all_categories_name = $this->translate('Period');
$this->view->categories = array();
foreach ($categories as $k => $v) {
$this->view->categories[$k] = array('name' => $v['paid_date'], 'href' => WM_Router::create($request->getBaseUrl() . '?controller=categories&category_id=popular&page_id=date/' . str_replace(' ', '', $v['paid_date'])));
}
}
/* PAGENATION */
$link .= '&order=' . $order;
$pagination = new Model_Pagination();
$pagination->setLimit($limit);
$pagination->setPage($page);
$pagination->setText(array('text_prev' => $this->view->translate('Prev'), 'text_next' => $this->view->translate('Next')));
$pagination->setTotal($total_records);
$pagination->setUrl(WM_Router::create($link . '&page={page}'));
$this->view->pagination = $pagination->render();
if (!empty($this->view->pagination)) {
$this->view->pagination = str_replace('{of}', $this->view->translate('OF'), $this->view->pagination);
}
/* ITEMS */
if ($items) {
$this->view->items = array();
foreach ($items as $n => $item) {
if (!empty($item['demo_url'])) {
$item['demo_url'] = WM_Router::create($request->getBaseUrl() . '?controller=items&action=preview&item_id=' . $item['id'] . '&name=' . WM_Router::clearName($item['name']));
}
$this->view->items[] = Helper_Items::returnViewIndex($item, 'category');
}
}
$this->view->children = array();
$this->view->children['header_part'] = 'layout/header_part';
$this->view->children['footer_part'] = 'layout/footer_part';
$this->setViewChange('index');
}
public function top_sellersAction()
{
$this->getLayout()->meta_title = $this->translate('Top sellers');
$this->getLayout()->meta_description = $this->translate('Top sellers');
$this->getLayout()->placeholder('checkItemsType', true);
$model_images = new Model_Images();
$year = $this->getRequest()->getRequest('top_sellers');
$month = $this->getRequest()->getRequest($year);
$day = $this->getRequest()->getRequest($month);
if (!checkdate(intval($month), intval($day), intval($year))) {
$year = date('Y');
$month = date('m');
$day = date('d');
}
$dayOfWeek = date('N', mktime(0, 0, 0, $month, $day, $year));
$dayOfWeek = 7 - $dayOfWeek;
if ($dayOfWeek > 0) {
$endDate = date('Y-m-d', mktime(0, 0, 0, $month, $day + $dayOfWeek, $year));
} else {
if (strlen($month) == 1) {
$month = '0' . $month;
}
if (strlen($day) == 1) {
$day = '0' . $day;
}
$endDate = $year . '-' . $month . '-' . $day;
}
$startDate = date('Y-m-d', strtotime($endDate) - 604800);
$this->view->endDate = $endDate;
#GENERATE PREV AND NEXT
if (strtotime($endDate) < strtotime(date('Y-m-d'))) {
$this->view->nextDate = WM_Router::create($this->getRequest()->getBaseUrl() . '?controller=items&action=top_sellers/' . date('Y/m/d', strtotime($endDate) + 604800));
}
$this->view->prevDate = WM_Router::create($this->getRequest()->getBaseUrl() . '?controller=items&action=top_sellers/' . date('Y/m/d', strtotime($startDate)));
$month = date('m', strtotime($endDate)) - 1;
$endMonthlyDate = date('Y-m-d', mktime(0, 0, 0, $month, date('t', mktime(0, 0, 0, $month, 1, date('Y'))), date('Y')));
$startMonthlyDate = date('Y-m-d', mktime(0, 0, 0, $month - 3, 1, date('Y')));
$this->view->endMonthlyDate = $endMonthlyDate;
$endMonthlyDate2 = date('Y-m-d', mktime(0, 0, 0, $month, date('t', mktime(0, 0, 0, $month, 1, date('Y'))), date('Y')));
$startMonthlyDate2 = date('Y-m-d', mktime(0, 0, 0, $month, 1, date('Y')));
$this->view->month = $month;
#GET ITEMS
$topSellItems = Model_Items::getTopSellers(0, 50, "`paid_datetime` > '{$startDate} 23:59:59' AND `paid_datetime` < '{$endDate} 23:59:59' ");
$this->view->topSellItems = array();
if ($topSellItems) {
$position = 1;
foreach ($topSellItems as $n => $item) {
$item['position'] = $position++;
$this->view->topSellItems[] = Helper_Items::returnViewIndex($item, 'category');
}
}
$topMonthlyItems = Model_Items::getTopSellers(0, 50, "`paid_datetime` > '{$startMonthlyDate} 00:00:00' AND `paid_datetime` < '{$endMonthlyDate} 23:59:59' ");
$this->view->topMonthlyItems = array();
if ($topMonthlyItems) {
$position = 1;
foreach ($topMonthlyItems as $n => $item) {
$item['position'] = $position++;
$this->view->topMonthlyItems[] = Helper_Items::returnViewIndex($item, 'category');
}
}
$authors = Model_Users::getTopAuthors("AND `paid_datetime` > '{$startMonthlyDate2} 00:00:00' AND `paid_datetime` < '{$endMonthlyDate2} 23:59:59'");
if ($authors) {
foreach ($authors as $v => $aut) {
$authors[$v]['avatar'] = $model_images->resize($aut['avatar'], JO_Registry::forceGet('user_avatar_width'), JO_Registry::forceGet('user_avatar_height'), true);
$authors[$v]['href'] = WM_Router::create($this->getRequest()->getBaseUrl() . '?controller=users&username='******'username']));
}
}
$this->view->monthList = array();
for ($i = 1; $i <= 12; $i++) {
$this->view->monthList[] = JO_Date::getInstance(date('Y') . '-' . sprintf('%02d', $i) . '-01', 'MM', true)->toString();
}
$this->view->featuredAuthors = $authors;
$this->view->children['header_part'] = 'layout/header_part';
$this->view->children['footer_part'] = 'layout/footer_part';
}
