/** * 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'); }
/** * Deletes group */ public static function postDeletePage($id) { $app = \Slim\Slim::getInstance(); $userDAO = new UserDAO(); if (!$userDAO->hasRole('ADMIN')) { return $app->status(403); } if (!empty($_POST['yes'])) { $dao = new GroupDAO(); $dao->delete($id); } return $app->redirect(MAINURL . '/groups'); }
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'); } }
/** * Process message form */ public static function postEditPage($id) { $app = \Slim\Slim::getInstance(); $dao = new MessageDAO(); $userDAO = new UserDAO(); $strong = \Strong\Strong::getInstance(); $user = $strong->getUser(); $user = $userDAO->fetch($user['id']); $groupDAO = new GroupDAO(); $groupsQuery = array(); $senderDAO = new SenderDAO(); $sendersQuery = array(); $strong = \Strong\Strong::getInstance(); $user2 = $strong->getUser(); $groupsQuery['user_id'] = $user2['id']; $sendersQuery['user_id'] = $user2['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->view->set('KIND_TEXT_MSG', Message::KIND_TEXT_MSG); $app->view->set('KIND_PHOTO_MSG', Message::KIND_PHOTO_MSG); $app->view->set('KIND_AUDIO_MSG', Message::KIND_AUDIO_MSG); $app->view->set('KIND_VIDEO_MSG', Message::KIND_VIDEO_MSG); $item = $dao->fetch($id); if (empty($item)) { return $app->notFound(); } else { if (!$userDAO->hasRole('ADMIN') && $item->getGroupId() > 0 && !in_array($item->getGroupId(), array_keys($groups['list']))) { return $app->status(403); } if (empty($_POST['data'])) { $_POST['data'] = $item->getData(); } } $statuses = $dao->getStatuses($item); if (!empty($_POST['resend'])) { $dao->resend($item); $app->redirect(MAINURL . '/messages/edit/' . $item->getId()); return; } $item->dataHuman = self::getHumanUrl($item); $mime = '*/*'; if (Message::KIND_PHOTO_MSG == $item->getKind()) { $mime = 'image/*'; } if (Message::KIND_AUDIO_MSG == $item->getKind()) { $mime = 'audio/*'; } if (Message::KIND_VIDEO_MSG == $item->getKind()) { $mime = 'video/*'; } $item->setUserId($user->getId()); $dateParts = explode('-', $_POST['stime_date']); $timeParts = explode(':', $_POST['stime_time']); $stime = mktime($timeParts[0], $timeParts[1], $timeParts[2], $dateParts[1], $dateParts[2], $dateParts[0]); $item->setStime($stime); if ($item->getKind() == Message::KIND_TEXT_MSG) { $item->setData($_POST['data']); } $item->setGroupId($_POST['group_id']); $item->setSenderId($_POST['sender_id']); $personalized = array(); $customField = $dao->getCustomFields($item); $numbers = $groupDAO->getNumbers($item->getGroupId()); foreach ($customField as $num => $fields) { if (empty($numbers[$num])) { continue; } $personalized[$num] = $num; } $_POST['personalized'] = 'personalized $validator'; $validator = new \Valitron\Validator($_POST); $validator->addRule('credits', function ($name, $value) use($user, $userDAO) { if ($userDAO->hasRole('ADMIN')) { return true; } return $user->getCredits() > 0; }); $validator->addRule('time', function ($name, $value) { $value = explode(':', $value); if (count($value) != 3) { return false; } return true; }); $validator->addRule('personalized', function ($name, $value) use($personalized, $numbers) { if (count($personalized) == 0) { return true; } return count($personalized) == count($numbers); }); $validator->rule('personalized', 'personalized'); $validator->label('Personalized'); $validator->rule('required', 'group_id'); $validator->label('Group'); $validator->rule('required', 'sender_id'); $validator->label('Sender'); $validator->rule('date', 'stime_date'); $validator->label('Date'); $validator->rule('time', 'stime_time'); $validator->label('Time'); $validator->rule('required', 'data'); $validator->label('Message'); $validator->rule('credits', 'credits'); $validator->label('Credits'); if ($validator->validate()) { $item = $dao->save($item); if (!empty($_POST['send']) && empty($statuses)) { $dao->addStatus($item, Message::MESSAGE_STATUS_TO_SEND); if (!$userDAO->hasRole('ADMIN')) { $numbers = $groupDAO->getNumbers($item->getGroupId()); $user->setCredits($user->getCredits() - count($numbers)); $userDAO->save($user); } } $app->redirect(MAINURL . '/messages/edit/' . $item->getId()); } else { $app->view->set('menu', 'messages'); $app->view->set('id', $id); $app->view->set('item', $item); $app->view->set('numbers', $numbers); $app->view->set('numbers_count', count($numbers)); $app->view->set('personalized', $personalized); $app->view->set('personalized_count', count($personalized)); $app->view->set('groups', $groups); $app->view->set('senders', $senders); $app->view->set('statuses', $statuses); $app->view->set('errors', $validator->errors()); $app->view->set('mime', $mime); $app->render('messages/edit.twig.html'); } }
/** * Deletes message */ public static function deletePage($id) { $app = \Slim\Slim::getInstance(); $dao = new UserDAO(); $dao->delete($id); return $app->redirect(MAINURL . '/users'); }