public function indexAction()
{
if ($this->session->get('successfu_edite')) {
$this->view->successfu_edite = true;
$this->session->clear('successfu_edite');
}
$request = $this->getRequest();
$this->view->page_num = $page = $request->getRequest('page', 1);
$this->view->sort = $request->getRequest('sort', 'DESC');
$this->view->order = $request->getRequest('order', 'i.id');
$this->view->filter_id = $request->getQuery('filter_id');
$this->view->filter_name = $request->getQuery('filter_name');
$this->view->filter_username = $request->getQuery('filter_username');
$this->view->filter_price = $request->getQuery('filter_price');
$this->view->filter_sales = $request->getQuery('filter_sales');
$this->view->filter_profit = $request->getQuery('filter_profit');
$this->view->filter_free_request = $request->getQuery('filter_free_request');
$this->view->filter_free_file = $request->getQuery('filter_free_file');
$this->view->filter_weekly = $request->getQuery('filter_weekly');
$this->view->filter_user_id = $request->getQuery('filter_user_id');
$this->view->filter_web_profit = $request->getQuery('filter_web_profit');
$this->view->filter_refferals = $request->getQuery('filter_refferals');
$url = '';
if ($this->view->filter_id) {
$url .= '&filter_id=' . $this->view->filter_id;
}
if ($this->view->filter_name) {
$url .= '&filter_name=' . $this->view->filter_name;
}
if ($this->view->filter_username) {
$url .= '&filter_username='******'&filter_user_id=' . $this->view->filter_user_id;
}
if ($this->view->filter_price) {
$url .= '&filter_price=' . $this->view->filter_price;
}
if ($this->view->filter_sales) {
$url .= '&filter_sales=' . $this->view->filter_sales;
}
if ($this->view->filter_profit) {
$url .= '&filter_profit=' . $this->view->filter_profit;
}
if ($this->view->filter_free_request) {
$url .= '&filter_free_request=' . $this->view->filter_free_request;
}
if ($this->view->filter_free_file) {
$url .= '&filter_free_file=' . $this->view->filter_free_file;
}
if ($this->view->filter_weekly) {
$url .= '&filter_weekly=' . $this->view->filter_weekly;
}
$url1 = '';
if ($this->view->sort) {
$url1 .= '&sort=' . $this->view->sort;
}
if ($this->view->order) {
$url1 .= '&order=' . $this->view->order;
}
$url2 = '&page=' . $page;
$data = array('start' => $page * JO_Registry::get('admin_limit') - JO_Registry::get('admin_limit'), 'limit' => JO_Registry::get('admin_limit'), 'sort' => $this->view->sort, 'order' => $this->view->order, 'filter_id' => $this->view->filter_id, 'filter_name' => $this->view->filter_name, 'filter_username' => $this->view->filter_username, 'filter_price' => $this->view->filter_price, 'filter_sales' => $this->view->filter_sales, 'filter_profit' => $this->view->filter_profit, 'filter_free_request' => $this->view->filter_free_request, 'filter_free_file' => $this->view->filter_free_file, 'filter_weekly' => $this->view->filter_weekly, 'filter_user_id' => $this->view->filter_user_id, 'filter_web_profit' => $this->view->filter_web_profit, 'filter_refferals' => $this->view->filter_refferals, 'filter_status' => 'active');
$this->view->items = array();
$items = Model_Items::getItems($data);
if ($items) {
foreach ($items as $item) {
$this->view->items[] = array('id' => $item['id'], 'user_id' => $item['user_id'], 'href' => WM_Router::create($request->getBaseUrl() . '?module=' . $item['module'] . '&controller=items&item_id=' . $item['id']), 'name' => $item['name'], 'username' => $item['username'], 'name' => $item['name'], 'price' => WM_Currency::format($item['price']), 'sales' => $item['sales'], 'receive' => WM_Currency::format($item['sum_receive']), 'profit' => WM_Currency::format($item['earning']), 'web_profit' => WM_Currency::format($item['web_profit']), 'web_profit2' => WM_Currency::format($item['web_profit2']), 'has_referral_sum' => $item['referral_sum'], 'referral_sum' => WM_Currency::format($item['referral_sum']), 'free_request' => $item['free_request'] == 'true', 'free_file' => $item['free_file'] == 'true', 'weekly_from' => $item['weekly_from'] != '0000-00-00' ? JO_Date::getInstance($item['weekly_from'], 'dd.mm.yy', true)->toString() : '', 'weekly_to' => $item['weekly_to'] != '0000-00-00' ? JO_Date::getInstance($item['weekly_to'], 'dd.mm.yy', true)->toString() : '', 'comments' => $item['comments'], 'edit' => $request->getModule() . '/items/edit/?m=' . $item['module'] . '&id=' . $item['id'] . $url . $url1 . $url2, 'comments_href' => $request->getModule() . '/items/comments/?id=' . $item['id'] . $url . $url1 . $url2);
}
}
$this->view->sort = strtolower($this->view->sort);
$this->view->sort_id = $request->getModule() . '/items/?order=i.id&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_name = $request->getModule() . '/items/?order=i.name&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_username = $request->getModule() . '/items/?order=u.username&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_price = $request->getModule() . '/items/?order=i.price&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_sales = $request->getModule() . '/items/?order=i.sales&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_earning = $request->getModule() . '/items/?order=i.earning&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_free_request = $request->getModule() . '/items/?order=i.free_request&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_free_file = $request->getModule() . '/items/?order=i.free_file&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_web_profit = $request->getModule() . '/items/?order=web_profit2&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$this->view->sort_referral_sum = $request->getModule() . '/items/?order=referral_sum&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2;
$total_records = Model_Items::getTotalItems($data);
$this->view->total_pages = ceil($total_records / JO_Registry::get('admin_limit'));
$this->view->total_rows = $total_records;
$pagination = new Model_Pagination();
$pagination->setLimit(JO_Registry::get('admin_limit'));
$pagination->setPage($page);
$pagination->setTotal($total_records);
$pagination->setUrl($this->getRequest()->getModule() . '/items/?page={page}' . $url . $url1);
$this->view->pagination = $pagination->render();
}
