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