/** * 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 senders * * @param number $page */ public static function getPage($page = 0) { $app = \Slim\Slim::getInstance(); $dao = new SenderDAO(); $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 . '/senders/', 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', 'senders'); $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('senders/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'); }
/** * Get edit group form * * @param number $id */ public static function getEditPage($id) { $app = \Slim\Slim::getInstance(); $dao = new GroupDAO(); $userDAO = new UserDAO(); $app->expires(time()); $item = $dao->fetch($id); if (empty($item)) { return $app->notFound(); } $numbers = $dao->getNumbers($item->getId()); $pager1 = new Pager(MAINURL . '/groups/edit/' . $item->getId(), 50); $pager1->setQueryMode('page1'); $pager1->setPage($_GET['page1']); $pager2 = new Pager(MAINURL . '/groups/edit/' . $item->getId(), 50); $pager2->setQueryMode('page2'); $pager2->setPage($_GET['page2']); $totalRegistered = 0; $totalUnregistered = 0; $numbersRegistered = array(); $numbersUnregistered = array(); $start1 = $pager1->getPageSize() * $pager1->getPage(); $end1 = $start1 + $pager1->getPageSize(); $start2 = $pager2->getPageSize() * $pager2->getPage(); $end2 = $start2 + $pager2->getPageSize(); $cntRegistered = 0; $cntUnregistered = 0; foreach ($numbers as $k => $v) { if (!empty($v['synced'])) { if ($cntRegistered >= $start1 && $cntRegistered < $end1) { $numbersRegistered[$k] = $v; } $cntRegistered++; $totalRegistered++; } else { if ($cntUnregistered >= $start2 && $cntUnregistered < $end2) { $numbersUnregistered[$k] = $v; } $cntUnregistered++; $totalUnregistered++; } } $pager1->setTotal($totalRegistered); $pager1->setCount(count($numbersRegistered)); $pager2->setTotal($totalUnregistered); $pager2->setCount(count($numbersUnregistered)); $senderDAO = new SenderDAO(); $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $senders = $senderDAO->getList(array(user_id => $user['id'])); $app->view->set('senders', $senders); $app->view->set('menu', 'groups'); $app->view->set('id', $id); $app->view->set('item', $item); $app->view->set('pager1', $pager1); $app->view->set('pager2', $pager2); $app->view->set('users', $userDAO->getList()); $app->view->set('numbersRegistered', $numbersRegistered); $app->view->set('numbersUnregistered', $numbersUnregistered); $app->view->set('duplicates', $dao->getDuplicates($item->getId())); $app->render('groups/edit.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'); } }