public static function getPinLikes($pin_id) { static $result = array(), $model_images = null, $request = null; if (isset($result[$pin_id])) { return $result[$pin_id]; } if ($model_images === null) { $model_images = new Helper_Images(); } if ($request === null) { $request = JO_Request::getInstance(); } $users = Model_Users::getUsers(array('filter_like_pin_id' => $pin_id, 'start' => 0, 'limit' => 20, 'order' => 'pins_likes.like_id', 'sort' => 'DESC')); $data = array(); if ($users) { foreach ($users as $user) { $avatar = Helper_Uploadimages::avatar($user, '_A'); $user['avatar'] = $avatar['image']; $data[] = array('avatar' => $user['avatar'], 'fullname' => $user['fullname'], 'href' => WM_Router::create($request->getBaseUrl() . '?controller=users&action=profile&user_id=' . $user['user_id'])); } } $result[$pin_id] = array('data' => $data, 'total' => Model_Users::getTotalUsers(array('filter_like_pin_id' => $pin_id)) - count($data)); return $result[$pin_id]; }
public function indexAction() { if ($this->session->get('successfu_edite')) { $this->view->successfu_edite = true; $this->session->clear('successfu_edite'); } if ($this->session->get('error_permision')) { $this->view->error_permision = $this->session->get('error_permision'); $this->session->clear('error_permision'); } $reques = $this->getRequest(); $this->view->sort = $reques->getRequest('sort', 'DESC'); $this->view->order = $reques->getRequest('order', 'u.user_id'); $this->view->page_num = $page = $reques->getRequest('page', 1); $this->view->filter_id = $reques->getQuery('filter_id'); $this->view->filter_name = $reques->getQuery('filter_name'); $this->view->filter_username = $reques->getQuery('filter_username'); $this->view->filter_email = $reques->getQuery('filter_email'); $this->view->filter_delete_account = $reques->getQuery('filter_delete_account'); $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_email=' . $this->view->filter_email; } if ($this->view->filter_delete_account) { $url .= '&filter_delete_account=' . $this->view->filter_delete_account; } $filter_delete_account = $this->view->filter_delete_account; if ($this->view->filter_delete_account == '*') { $filter_delete_account = null; } if (!$reques->issetQuery('filter_delete_account')) { $this->view->filter_delete_account = '*'; } $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 * Helper_Config::get('config_admin_limit') - Helper_Config::get('config_admin_limit'), 'limit' => Helper_Config::get('config_admin_limit'), 'sort' => $this->view->sort, 'order' => $this->view->order, 'filter_user_id' => $this->view->filter_id, 'filter_name' => $this->view->filter_name, 'filter_username' => $this->view->filter_username, 'filter_delete_account' => $filter_delete_account, 'filter_email' => $this->view->filter_email); $this->view->users = array(); $users = Model_Users::getUsers($data); if ($users) { foreach ($users as $user) { $user['edit_href'] = $reques->getModule() . '/users/edite/?id=' . $user['user_id'] . $url . $url1 . $url2; // $user['items_href'] = WM_Router::create( $this->getRequest()->getBaseUrl() . '?controller=ads&user_id=' . $user['user_id'] ); //$user['items_href'] = $reques->getModule() . '/ads/?filter_user_id=' . $user['user_id']; $user['username_href'] = $reques->getModule() . '/pins/?filter_user_id=' . $user['user_id']; $user['boards_href'] = $reques->getModule() . '/boards/?filter_user_id=' . $user['user_id']; $user['profile_url'] = WM_Router::create($this->getRequest()->getBaseUrl() . '?controller=users&action=profile&user_id=' . $user['user_id']); $user['delete_account_date'] = $user['delete_account_date'] != '0000-00-00 00:00:00' ? WM_Date::format($user['delete_account_date'], Helper_Config::get('config_date_format_long_time')) : ''; $this->view->users[] = $user; } } $this->view->sort = strtolower($this->view->sort); $this->view->sort_id = $reques->getModule() . '/users/?order=u.user_id&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_name = $reques->getModule() . '/users/?order=u.firstname&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_username = $reques->getModule() . '/users/?order=u.username&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_pins = $reques->getModule() . '/users/?order=u.pins&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_boards = $reques->getModule() . '/users/?order=u.boards&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_likes = $reques->getModule() . '/users/?order=u.likes&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $total_records = Model_Users::getTotalUsers($data); $this->view->total_pages = ceil($total_records / Helper_Config::get('config_admin_limit')); $this->view->total_rows = $total_records; $pagination = new Model_Pagination(); $pagination->setLimit(Helper_Config::get('config_admin_limit')); $pagination->setPage($page); $pagination->setTotal($total_records); $pagination->setUrl($this->getRequest()->getModule() . '/users/?page={page}' . $url . $url1); $this->view->pagination = $pagination->render(); }
public function indexAction() { if ($this->session->get('successfu_edite')) { $this->view->successfu_edite = true; $this->session->clear('successfu_edite'); } $reques = $this->getRequest(); $this->view->sort = $reques->getRequest('sort', 'DESC'); $this->view->order = $reques->getRequest('order', 'i.id'); $this->view->page_num = $page = $reques->getRequest('page', 1); $this->view->filter_id = $reques->getQuery('filter_id'); $this->view->filter_username = $reques->getQuery('filter_username'); $this->view->filter_total = $reques->getQuery('filter_total'); $this->view->filter_sales = $reques->getQuery('filter_sales'); $this->view->filter_sold = $reques->getQuery('filter_sold'); $this->view->filter_web_profit2 = $reques->getQuery('filter_web_profit2'); $this->view->filter_commission = $reques->getQuery('filter_commission'); $this->view->filter_items = $reques->getQuery('filter_items'); $this->view->filter_referals = $reques->getQuery('filter_referals'); $this->view->filter_referal_money = $reques->getQuery('filter_referal_money'); $this->view->filter_featured_author = $reques->getQuery('filter_featured_author'); $url = ''; if ($this->view->filter_id) { $url .= '&filter_id=' . $this->view->filter_id; } if ($this->view->filter_username) { $url .= '&filter_username='******'&filter_total=' . $this->view->filter_total; } if ($this->view->filter_sales) { $url .= '&filter_sales=' . $this->view->filter_sales; } if ($this->view->filter_sold) { $url .= '&filter_sold=' . $this->view->filter_sold; } if ($this->view->filter_web_profit2) { $url .= '&filter_web_profit2=' . $this->view->filter_web_profit2; } if ($this->view->filter_commission) { $url .= '&filter_commission=' . $this->view->filter_commission; } if ($this->view->filter_items) { $url .= '&filter_items=' . $this->view->filter_items; } if ($this->view->filter_referals) { $url .= '&filter_referals=' . $this->view->filter_referals; } if ($this->view->filter_referal_money) { $url .= '&filter_referal_money=' . $this->view->filter_referal_money; } if ($this->view->filter_featured_author) { $url .= '&filter_featured_author=' . $this->view->filter_featured_author; } $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_username' => $this->view->filter_username, 'filter_total' => $this->view->filter_total, 'filter_sales' => $this->view->filter_sales, 'filter_sold' => $this->view->filter_sold, 'filter_web_profit2' => $this->view->filter_web_profit2, 'filter_commission' => $this->view->filter_commission, 'filter_items' => $this->view->filter_items, 'filter_referals' => $this->view->filter_referals, 'filter_referal_money' => $this->view->filter_referal_money, 'filter_featured_author' => $this->view->filter_featured_author); $this->view->users = array(); $users = Model_Users::getUsers($data); $percentsClass = new Model_Percents(); if ($users) { foreach ($users as $user) { if (!isset($user['sum_referals'])) { $user['sum_referals'] = 0; } $user['deposit'] = WM_Currency::format($user['deposit']); $user['earning'] = WM_Currency::format($user['earning']); $user['total'] = WM_Currency::format($user['total']); $user['sold'] = WM_Currency::format($user['sum_price']); $user['has_referral_sum'] = $user['sum_referals']; $user['web_profit'] = WM_Currency::format($user['sum_price'] - $user['sum_receive']); $user['web_profit2'] = WM_Currency::format($user['sum_price'] - $user['sum_receive'] - $user['sum_referals']); $user['referal_money'] = WM_Currency::format($user['sum_referals']); $comision = $percentsClass->getPercentRow($user['user_id']); $user['commission'] = round($comision['percent']); $user['sum'] = Model_Balance::getTotalUserBalanceByType($user['user_id']); $user['referral_sum'] = WM_Currency::format($user['sum_referals']); $user['edit_href'] = $reques->getModule() . '/users/edite/?id=' . $user['user_id'] . $url . $url1 . $url2; $user['balance_href'] = $reques->getModule() . '/users/balance/?id=' . $user['user_id'] . $url . $url1 . $url2; $this->view->users[] = $user; } } $this->view->sort = strtolower($this->view->sort); $this->view->sort_id = $reques->getModule() . '/users/?order=u.user_id&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_username = $reques->getModule() . '/users/?order=u.username&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_total = $reques->getModule() . '/users/?order=u.total&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_sales = $reques->getModule() . '/users/?order=u.sales&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_sold = $reques->getModule() . '/users/?order=u.sold&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_web_profit2 = $reques->getModule() . '/users/?order=u.web_profit2&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_commission = $reques->getModule() . '/users/?order=u.commission&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_items = $reques->getModule() . '/users/?order=u.items&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_referals = $reques->getModule() . '/users/?order=u.referals&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_referal_money = $reques->getModule() . '/users/?order=u.referal_money&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_featured_author = $reques->getModule() . '/users/?order=u.featured_author&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $total_records = Model_Users::getTotalUsers($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() . '/users/?page={page}' . $url . $url1); $this->view->pagination = $pagination->render(); }