public function index()
{
$f3 = \Base::instance();
$this->_requireLogin();
$user = $f3->get('user');
$user_obj = $f3->get('user_obj');
$user_org_links = $f3->get('user_org_links');
$db = $f3->get('db.instance');
$tickets = $db->exec('SELECT * FROM support_tickets WHERE memberId = ? ORDER BY id DESC', $user['id']);
foreach ($tickets as $id => $ticket) {
$result = $db->exec('SELECT COUNT(*) AS `count` FROM support_tickets_msg WHERE ticketId = ?', $ticket['id']);
$tickets[$id]['messages_count'] = $result[0]['count'];
// Assigned or not ?
if ($ticket['assignedUserId'] != 0) {
$assignedUser = new User();
$assignedUser->load($ticket['assignedUserId']);
$tickets[$id]['assignedUser'] = $assignedUser->cast();
}
}
$f3->set('tickets', $tickets);
$active_tickets = $db->exec("SELECT * FROM support_tickets WHERE memberId = ? AND status != 'closed'", $user['id']);
$f3->set('active_tickets', $active_tickets);
$closed_tickets = $db->exec("SELECT * FROM support_tickets WHERE memberId = ? AND status = 'closed'", $user['id']);
$f3->set('closed_tickets', $closed_tickets);
$f3->set('target', 'support/index.html');
$this->_render('base.html');
}
public function index()
{
$f3 = \Base::instance();
$this->_requireLogin();
$this->_requireRank('support');
$user = $f3->get('user');
$user_obj = $f3->get('user_obj');
$user_org_links = $f3->get('user_org_links');
$db = $f3->get('db.instance');
$tickets = $db->exec('SELECT * FROM support_tickets ORDER BY id DESC');
foreach ($tickets as $id => $ticket) {
$result = $db->exec('SELECT COUNT(*) AS `count` FROM support_tickets_msg WHERE ticketId = ?', $ticket['id']);
$tickets[$id]['messages_count'] = $result[0]['count'];
// Assigned or not ?
if ($ticket['assignedUserId'] != 0) {
$assignedUser = new User();
$assignedUser->load($ticket['assignedUserId']);
$tickets[$id]['assignedUser'] = $assignedUser->cast();
}
// From who ?
$ticketCreator = new User();
$ticketCreator->load($ticket['memberId']);
$tickets[$id]['member'] = $ticketCreator->cast();
}
$f3->set('tickets', $tickets);
$active_tickets = $db->exec("SELECT * FROM support_tickets WHERE status != 'closed'");
$f3->set('active_tickets', $active_tickets);
$closed_tickets = $db->exec("SELECT * FROM support_tickets WHERE status = 'closed'");
$f3->set('closed_tickets', $closed_tickets);
// Very high priority tickets
$prio_tickets = $db->exec("SELECT * FROM support_tickets WHERE status != 'closed' AND priority = 4 ORDER BY id DESC");
foreach ($prio_tickets as $id => $ticket) {
$result = $db->exec('SELECT COUNT(*) AS `count` FROM support_tickets_msg WHERE ticketId = ?', $ticket['id']);
$prio_tickets[$id]['messages_count'] = $result[0]['count'];
// Assigned or not ?
if ($ticket['assignedUserId'] != 0) {
$assignedUser = new User();
$assignedUser->load($ticket['assignedUserId']);
$prio_tickets[$id]['assignedUser'] = $assignedUser->cast();
}
// From who ?
$ticketCreator = new User();
$ticketCreator->load($ticket['memberId']);
$prio_tickets[$id]['member'] = $ticketCreator->cast();
}
$f3->set('priority_tickets', $prio_tickets);
// Some side-bar stats
$result = $db->exec('SELECT count(*) AS `count` FROM users');
$f3->set('users_count', $result[0]['count']);
$f3->set('tickets_count', count($active_tickets));
$f3->set('target', 'dashboard/admin/support/index.html');
$this->_render('base.html');
}
public function view()
{
$f3 = \Base::instance();
$this->_requireLogin();
$this->_requireRank('support');
$user = $f3->get('user');
$user_obj = $f3->get('user_obj');
$user_org_links = $f3->get('user_org_links');
$db = $f3->get('db.instance');
$ticketId = $f3->get('PARAMS.id');
$ticket = new Ticket();
$ticket->load($ticketId);
if ($ticket->loaded()) {
if ($f3->exists('GET.action') and $f3->get('GET.action') == 'close') {
$ticket->status = 'closed';
$ticket->save();
$f3->reroute($f3->get('PATH'));
}
$f3->set('ticket', $ticket->cast());
// Load ticket messages
$result = $db->exec('SELECT * FROM support_tickets_msg WHERE ticketId = ? ORDER BY id DESC', $ticket->id);
foreach ($result as $id => $resp) {
if ($resp['senderId'] == $user['id']) {
// The sender is the actual user, no need to load
$result[$id]['sender'] = $user;
} else {
// Load the message senders information
$sender = new User();
$sender->load($resp['senderId']);
$result[$id]['sender'] = $sender->cast();
}
}
$f3->set('ticket_msg', $result);
$f3->set('target', 'dashboard/admin/support/view.html');
} else {
$f3->set('target', '404.html');
}
$this->_render('base.html');
}
public function detailspost()
{
$f3 = \Base::instance();
$this->_requireLogin();
$this->_requireRank('support');
$user = $f3->get('user');
$user_obj = $f3->get('user_obj');
$user_org_links = $f3->get('user_org_links');
$db = $f3->get('db.instance');
// Target user
$tuser_id = $f3->get('PARAMS.id');
$tuser = new User();
$tuser->load($tuser_id);
if ($tuser->rank > $user['rank']) {
$f3->reroute($f3->get('PATH'));
}
// Update one by one
$name = $f3->get('POST.tname');
$username = $f3->get('POST.tusername');
$email = $f3->get('POST.temail');
$age = (int) $f3->get('POST.tage');
$rank = $f3->get('POST.trank');
$errors = [];
if (empty($name)) {
$errors[] = "Name is required";
}
if (!preg_match("/^[0-9a-z]{4,}\$/i", $username)) {
$errors[] = "Usernames must be at least 4 characters and can only contain letters and numbers.";
}
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
$errors[] = "A valid email address is required.";
}
// Prevent setting the users rank to a rank higher then the user's one
if ($rank > $user['rank']) {
$errors[] = 'You can not set the users rank to a rank higher then yours';
}
if (empty($errors)) {
$tuser->name = $name;
$tuser->username = $username;
$tuser->email = $email;
$tuser->age = $age;
$tuser->rank = $rank;
$tuser->save();
new Notification('Updated users profile successfully !', 'success', true);
$f3->reroute($f3->get('PATH'));
} else {
$f3->set('errors', $errors);
$f3->set('tuser', $tuser->cast());
$f3->set('target', 'dashboard/admin/users/details.html');
$this->_render('base.html');
}
}
