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