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(); }