/** * Get list of groups * * @param number $page */ public static function getPage($page = 0) { $app = \Slim\Slim::getInstance(); $dao = new GroupDAO(); $userDAO = new UserDAO(); $app->expires(time()); $strong = \Strong\Strong::getInstance(); $userStrong = $strong->getUser(); $query = $_GET; if (!$userDAO->hasRole('ADMIN')) { $query['user_id'] = $userStrong['id']; } $pager = new Pager(MAINURL . '/groups/', 25); $pager->setPage($page); $query = $pager->getQueryArray($query); $list = $dao->getList($query); $pager->setCount(count($list['list'])); if (isset($list['total'])) { $pager->setTotal($list['total']); } $ownerList = $dao->getList(array(user_id => $userStrong['id'])); $app->view->set('menu', 'groups'); $app->view->set('query', $query); $app->view->set('result', $list); $app->view->set('user_result', $ownerList); $app->view->set('pager', $pager); $app->view->set('users', $userDAO->getList()); $app->render('groups/list.twig.html'); }
/** * Get list of users */ public static function getPage($page = 0) { $app = \Slim\Slim::getInstance(); $dao = new UserDAO(); if (!$dao->hasRole('ADMIN')) { return $app->status(403); } $app->expires(time()); $query = $_GET; $query['deleted'] = (int) $query['deleted']; $pager = new Pager(MAINURL . '/users/', 25); $pager->setPage($page); $query = $pager->getQueryArray($query); $list = $dao->getList($query); $pager->setCount(count($list['list'])); if (isset($list['total'])) { $pager->setTotal($list['total']); } $app->view->set('menu', 'users'); $app->view->set('query', $query); $app->view->set('result', $list); $app->view->set('pager', $pager); $app->view->set('app', $app); $app->render('users/list.twig.html'); }
/** * Get list of messages */ public static function getPage($page = 0) { $app = \Slim\Slim::getInstance(); $dao = new MessageDAO(); $userDAO = new UserDAO(); $users = $userDAO->getList(); $groupDAO = new GroupDAO(); $groupsQuery = array(); $senderDAO = new SenderDAO(); $sendersQuery = array(); if (!$userDAO->hasRole('ADMIN')) { $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $groupsQuery['user_id'] = $user['id']; $sendersQuery['user_id'] = $user['id']; } $groups = $groupDAO->getList($groupsQuery); if (0 == $groups['total']) { return $app->redirect(MAINURL . '/groups'); } $senders = $senderDAO->getList($sendersQuery); if (0 == $senders['total']) { return $app->redirect(MAINURL . '/senders'); } $app->expires(time()); $query = $_GET; if (!$userDAO->hasRole('ADMIN')) { $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $query['user_id'] = $user['id']; } $pager = new Pager(MAINURL . '/messages/', 25); $pager->setPage($page); $query = $pager->getQueryArray($query); $list = $dao->getList($query); $pager->setCount(count($list['list'])); if (isset($list['total'])) { $pager->setTotal($list['total']); } foreach ($list['list'] as $k => $v) { $list['list'][$k]->dataHuman = self::getHumanUrl($v); } $app->view->set('menu', 'messages'); $app->view->set('result', $list); $app->view->set('pager', $pager); $app->view->set('groups', $groups); $app->view->set('senders', $senders); $app->view->set('users', $users); $app->render('messages/list.twig.html'); }
/** * Get list of messages */ public static function getPage($page = 0) { $app = \Slim\Slim::getInstance(); $app->expires(time()); $userDAO = new UserDAO(); $groupDAO = new GroupDAO(); $groupsQuery = array(); if (!$userDAO->hasRole('ADMIN')) { $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $groupsQuery['user_id'] = $user['id']; } $groups = $groupDAO->getList($groupsQuery); if (0 == $groups['total']) { return $app->redirect(MAINURL . '/groups'); } $chatDAO = new ChatDAO(); $query = $_GET; $query['from'] = preg_replace('![^0-9]*!', '', $query['search']); if (!$userDAO->hasRole('ADMIN')) { $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $query['user_id'] = $user['id']; } $pager = new Pager(MAINURL . '/inbox/', 25); $pager->setPage($page); $query = $pager->getQueryArray($query); $list = $chatDAO->getList($query); $pager->setCount(count($list['list'])); if (isset($list['total'])) { $pager->setTotal($list['total']); } $app->view->set('menu', 'inbox'); $app->view->set('query', $query); $app->view->set('result', $list); $app->view->set('pager', $pager); $app->render('inbox/list.twig.html'); }
public static function getInboxPage($page = 0) { $app = \Slim\Slim::getInstance(); $limit = 25; if ($_GET['format'] == 'csv') { $page = 0; $limit = 10000; } $userDAO = new UserDAO(); $chatDAO = new ChatDAO(); $formUtils = new FormUtils(); $startTime = $formUtils->toTimestamp($_GET['start_date'] . ' 00:00'); $endTime = $formUtils->toTimestamp($_GET['end_date'] . ' 23:59'); if ($endTime <= 0) { $endTime = time(); } if ($startTime <= 0) { $startTime = $endTime - 7 * 24 * 3600; } $app->view->set('start_date', $startTime); $app->view->set('end_date', $endTime); $query = $_GET; $query['start_date'] = $startTime; $query['end_date'] = $endTime; if (!$userDAO->hasRole('ADMIN')) { $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $query['user_id'] = $user['id']; } $pager = new Pager(MAINURL . '/reports/inbox/?' . http_build_query($_GET), $limit); $pager->setPage($page); $query = $pager->getQueryArray($query); $list = $chatDAO->getList($query); $pager->setCount(count($list['list'])); if (isset($list['total'])) { $pager->setTotal($list['total']); } $reportTable = array(); foreach ($list['list'] as $message) { $reportTable[] = $message; } $app->view->set('menu', 'reports'); $app->view->set('reportTable', array_values($reportTable)); $app->view->set('query', $query); $app->view->set('pager', $pager); if ($_GET['format'] == 'csv') { header("Content-type: text/csv"); header("Content-disposition: attachment; filename=inbox.csv"); $app->render('reports/inbox.twig.csv'); } else { $app->render('reports/inbox.twig.html'); } }