public function get_users($group_id)
{
$group_id = DB::escape($group_id);
$data = DB::query("SELECT * FROM `users` WHERE `group` = '{$group_id}'", false);
$result = array();
while ($user = DB::next($data)) {
$result[] = $user;
}
return $result;
}
function getNextTitle($TheKey)
{
$prev_id = -1;
$next_id = -1;
$page =& $GLOBALS[page];
$id = $GLOBALS[id];
$bakpage = $page;
//if (isset($GLOBALS[sno]) && isset($GLOBALS[spage])) {
$sno =& $GLOBALS[sno];
$spage =& $GLOBALS[spage];
$page = ($spage - 1) * $this->Table["Limit"] + $sno - 1;
unset($GLOBALS[id]);
$this->Table["Limit"] = 1;
$prevnext = new DB($this->TableName);
if ($page > 0) {
$prevnext->next();
$prev_id = $prevnext->{$TheKey};
}
if ($prevnext->Total[0] > ++$page) {
$page++;
$prevnext = new DB($this->TableName);
$prevnext->next();
$next_id = $prevnext->{$TheKey};
}
$page = $bakpage;
$GLOBALS[id] = $id;
return array($prev_id, $next_id);
//}
}
</div>
</div>
<div class = 'row'>
<div class = 'title'> Phone Number </div>
<div class = 'value'>
<?=$this->univ_profile['phone_number'] ?>
</div>
</div>
<div class = 'row'>
<div class = 'title'>
Groups
</div>
<div id = 'groups'>
<div id = 'groups_list'>
<?
while ($group = DB::next($this->groups))
{
echo "<div>".
"<img width = '35' height = '35' alt = '{$group['name']}'".
"src = '".($group['picture'] ? content($group['picture']) : url('img/gdef.png'))."'/>".
"<a href = \"".url('group/'.$group['id'])."\">{$group['name']}</a>".
"</div>";
}
?>
</div>
</div>
</div>
<?php
if ($this->user->university == $this->univ_profile['id'])
{
?>
/**
* Returns user data, filtered by criteria
*/
public function filter()
{
global $cfg;
if (!isset($_POST['filter'])) {
$this->json_error("Missing filters!");
return;
}
$filter = json_decode($_POST['filter'], true);
$response = array();
$name = isset($filter['name'], $filter['name']['val']) ? "%" . DB::escape($filter['name']['val']) . "%" : '%';
$addr = isset($filter['addr'], $filter['addr']['val']) ? "%" . DB::escape($filter['addr']['val']) . "%" : '%';
$edu = isset($filter['edu'], $filter['edu']['val']) ? "%" . DB::escape($filter['edu']['val']) . "%" : '%';
$work = isset($filter['work'], $filter['addr']['val']) ? "%" . DB::escape($filter['work']['val']) . "%" : '%';
$mail = isset($filter['mail'], $filter['mail']['val']) ? "%" . DB::escape($filter['mail']['val']) . "%" : '%';
$query = "SELECT * FROM `users` WHERE " . "`full_name` LIKE '{$name}' AND " . "`address` LIKE '{$addr}' AND " . "`university_name` LIKE '{$edu}' AND " . "`workplace` LIKE '{$work}' AND " . "`email` LIKE '{$mail}' AND " . "`visible` = 1 ";
if (isset($filter['column'], $filter[$filter['column']]['dir'])) {
$column = array('name' => 'full_name', 'addr' => 'address', 'edu' => 'university_name', 'work' => 'workplace', 'mail' => 'email');
$query .= " ORDER BY {$column[$filter['column']]} " . ($filter[$filter['column']]['dir'] ? "DESC" : "ASC");
} else {
$query .= " ORDER BY `full_name` ASC";
}
if (!isset($filter['page'])) {
$this->json_error("Invalid page!");
return;
}
$query .= " LIMIT " . intval($filter['page']) * $cfg['per_page'] . ", " . ($cfg['per_page'] + 1);
$result = DB::query($query, false);
if (!$result) {
$this->json_error("Query failed!");
return;
}
$users = array();
$count = 0;
while ($count < $cfg['per_page'] && ($row = DB::next($result))) {
$users[] = array('id' => $row['id'], 'name' => $row['full_name'], 'addr' => $row['address'], 'work' => $row['workplace'], 'univ' => $row['university_name'], 'mail' => $row['email']);
$count++;
}
$this->json_response(array('users' => $users, 'more' => DB::next($result) != false));
}
public function get_timeline($id)
{
$result = array();
$data = DB::query("SELECT * FROM `timeline` WHERE \n `user` = '" . mysql_real_escape_string($id) . "' \n ORDER BY `date` ASC", false);
while ($evt = DB::next($data)) {
$result[] = $evt;
}
return $result;
}
