/**
* 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');
}
}
