</select>
</td>
</form>
<?php
###### pagenumbers ######
?>
<td class="scms_small_toolbar">
<?php
# get records total count
$sql = "SELECT COUNT(*) " . $from_sql . $where;
$sth = new SQL($sql);
$total_count = $sth->fetchsingle();
######### print pagenumbers table
$pagenumbers = print_pagenumbers(array("total_count" => $total_count, "rows_count" => 40));
?>
</td>
<?php
###### / pagenumbers ######
?>
</tr>
</table>
</td>
</tr>
<?php
# / FUNCTION BAR
################
?>
function print_users_table(){
global $site;
global $class_path;
global $group; # selected 1 group info
global $user; # selected 1 user info
$args = func_get_arg(0);
include_once($class_path."adminpage.inc.php");
include_once($class_path."custom.inc.php");
###########
# PERMISSIONS CHECK - get read-allowed group ID-s for current user
$read_allowed_groups = get_allowed_groups();
#echo printr($read_allowed_groups);
?>
<?
############################
# CONTENT TABLE
?>
<TABLE class="scms_content_area" width="100%" height="100%" border=0 cellspacing=0 cellpadding=0>
<TR>
<!-- Left column -->
<TD class="scms_left">
<TABLE border=0 width="100%" height="100%" cellspacing=0 cellpadding=0>
<!-- Search -->
<TR>
<TD id="search">
<?
#################
# SEARCH BOX
print_search_box(array(
"hide_end_form_tag" => $args['show_checkboxes'] // if we need to show checkboxes, don't print end form tag
));
?>
</TD>
</TR>
<!-- //Search -->
<TR>
<TD valign=top>
<div id=navigation class="scms_left_div">
<TABLE width="100%" border="0" cellpadding="0" cellspacing="0">
<?
/*
* Get favorites
*/
$favorites = $site->user->get_favorites(array(
fetch_user_favorits => 1,
fetch_group_favorits => 1,
));
if(count($favorites)>0) {
?>
<!-- Favorites -->
<tr>
<td class="scms_groupheader">
<IMG SRC="<?=$site->CONF['wwwroot'].$site->CONF['styles_path']?>/gfx/icons/16x16/actions/bookmark.png" WIDTH="16" HEIGHT="16" BORDER="0" ALT="" align=absmiddle> <?=$site->sys_sona(array(sona => "Favorites", tyyp=>"admin"))?>
</td>
</tr>
<TR>
<TD>
<table border=0>
<?
/*
* Display favorites
*/
foreach($favorites as $favorite_data) {
?>
<tr>
<td style="padding-right:4px;padding-left:16px"><img src="<?=$site->CONF['wwwroot'].$site->CONF[styles_path]?>/gfx/icons/16x16/users/<?= (strlen($favorite_data['group_id'])>0?'group':($favorite_data['is_superuser']?'superuser':'******')) ?>.png" width="16" height="16"></td>
<td><a href="javascript:<?= strlen($favorite_data['group_id'])>0?"select_group('".$favorite_data['group_id']."')":"document.getElementById('selectform_user_id').value='".$favorite_data['user_id']."';document.getElementById('selectform_group_id').value='".$favorite_data['user_group_id']."';document.forms['selectform'].submit();"; ?>"><?= strlen($favorite_data['group_id'])>0?$favorite_data['name']:$favorite_data['firstname'].' '.$favorite_data['lastname'] ?></a></td>
</tr>
<?
} //foreach
?>
</table>
</TD>
</TR>
<!-- //Favorites -->
<?
} //if favorites
?>
<!-- Menu tree -->
<TR>
<TD>
<?
#################
# GROUPS TREE: 2 views - tree & search result list
#### GROUP WHERE
if($site->user->is_superuser) {
$group_where_str = " 1=1 ";
}
else {
# $group_where_str = $site->db->prepare(" FIND_IN_SET(group_id,?) ", join(",",$read_allowed_groups));
$group_where_str = " group_id IN('".join("','", $read_allowed_groups)."') ";
}
###### GET tree html
$tree_html = get_grouptree_html(array(
"where_str" => $group_where_str,
"expand_all" => $args['expand_all'],
"show_checkboxes" => $args['show_checkboxes']
));
###### PRINT tree html
if ($args['show_checkboxes']){
echo "</form>";
}
?>
<?echo $tree_html; ?>
<?
# / GROUPS TREE
#################
?>
</TD>
</TR>
<!-- //Menu tree -->
</TABLE>
</div>
</TD>
</TR>
</TABLE>
<!-- // Left column -->
</TD>
<?
# / LEFT COLUMN
##################
?>
<?
# if not browse window
if($args['is_browse']) { $site->fdat['view']='overview_false'; }
############################
# MIDDLE LIST
#################
# USERS WHERE
$where_sql[] = $group_where_str;
# group filter
if($site->fdat['group_id'] && !$site->fdat['flt_role']) {
# 1. if search criteria is defined, then search from all current open subtree
if($site->fdat['search'] && $site->fdat['user_search'] && $site->fdat['search_subtree']) {
########## a) user search AND group search BOTH => use group search result
if($site->fdat['group_search']) {
# $where_sql[] = $site->db->prepare("FIND_IN_SET(group_id,?)",join(',',$group_search_result));
}
########## b) user search AND NOT group search => don't use group filter at all
else {
/*
# variant 2 => use group menu
$menu->get_full_subtree(array("parent_id" => $site->fdat['group_id']));
# $menu->full_subtree is variable from group tree and is all ID-s of group children
$tree_with_children = $menu->full_subtree;
#echo printr($tree_with_children);
$where_sql[] = $site->db->prepare("FIND_IN_SET(group_id,?)",join(',',$tree_with_children));
*/
}
}
# 2. if no search criteria, then show only users belonging to current group
else {
$where_sql[] = $site->db->prepare("group_id=?",$site->fdat['group_id']);
}
}
# user search filter, search from fixed fields ()
if($site->fdat['search'] && $site->fdat['user_search']) {
$where_sql[] = $site->db->prepare("(username LIKE ? OR firstname LIKE ? OR lastname LIKE ? OR email LIKE ?)",
$site->fdat['search'].'%',
$site->fdat['search'].'%',
$site->fdat['search'].'%',
$site->fdat['search'].'%'
);
}
# user role filter, search from user_roles
if($site->fdat['flt_role']) {
$where_sql[] = $site->db->prepare("(user_roles.role_id = ?)",
$site->fdat['flt_role']
);
### extra JOIN needed
$join = " LEFT JOIN user_roles ON user_roles.user_id = users.user_id ";
}
$where = is_array($where_sql) ? " WHERE ".join(" AND ",$where_sql) : '';
### if search is used then set page to null
if(!isset($site->fdat['page']) && ($site->fdat['search'] || $site->fdat['flt_role']) ) { $site->fdat['page'] = 0;}
# / USERS WHERE
#################
?>
<!-- Middle column -->
<TD class="scms_middle<?=($site->fdat['view']=='overview_true' ? "" : "_dialogwindow")?>" >
<TABLE style="width: 98%" height="100%" border="0" cellspacing="0" cellpadding="0">
<!-- Table title -->
<TR height=25>
<TD>
<?######### grey title header ########?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr class="scms_pane_header">
<td>
<IMG SRC="<?=$site->CONF['wwwroot'].$site->CONF['styles_path']?>/gfx/icons/16x16/users/user.png" WIDTH="16" HEIGHT="16" BORDER="0" ALT="" align=absmiddle> <?=$site->sys_sona(array(sona => "users", tyyp=>"admin"));?>
</td>
<td align="right">
</td>
<td style="width:120px">
<!-- Paging -->
<?
#################
# pagenumbers table
$sql = "SELECT COUNT(*) FROM users ".$join.$where;
$sth = new SQL($sql);
$total_count = $sth->fetchsingle();
$pagenumbers = print_pagenumbers(array(
"total_count" => $total_count,
"rows_count" => 20,
));
# / pagenumbers
#################
?>
<!-- //Paging -->
</td>
</tr>
</table>
<?######### / grey title header ########?>
</TD>
</TR>
<!-- // Table title -->
<?
#################
# table column names
?>
<!-- Table heading -->
<TR height=25>
<TD class="scms_tableheader">
<?
####### get assoc.array of visible fieldnames and translations
$visible_fields = get_visible_fields(array(
"prefpage_name" => ($args['is_browse'] ?'select_group':'user_management_fields'),
"sst_name" => 'custom,kasutaja',
));
#printr($visible_fields);
####### print column headers table
print_column_headers(array(
"visible_fields" => $visible_fields,
"page_prefs_url" => '&name='.($args['is_browse'] ?'select_group':'user_management_fields').'&sst_name=custom,kasutaja'
));
##### td width: calculate percents
$td_width = intval((100/sizeof(array_keys($visible_fields)))).'%';
?>
</TD>
</TR>
<!-- //Table heading -->
<?
# / COLUMN NAMES
#################
?>
<!-- Table data -->
<TR>
<TD valign=top>
<!-- Scrollable area -->
<div id=listing class="scms_middle_div">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="scms_table">
<?
#################
# users list
########### ORDER
$order = " ORDER BY ".$site->fdat['sortby']." ".$site->fdat['sort'];
########### SQL
$sql = $site->db->prepare("SELECT users.* FROM users ");
$sql .= $join;
$sql .= $where;
$sql .= $order;
$sql .= $pagenumbers['limit_sql'];
#print $sql;
$sth = new SQL($sql);
$listusers = array();
while($tmp = $sth->fetch()){
$listusers[] = $tmp;
}
#################
# loop over users
$i = 0;
foreach($listusers as $listuser){
$next_id = $listusers[$i+1]['user_id'];
$prev_id = $listusers[$i-1]['user_id'];
# $href = "?group_id=".$listuser[group_id]."&user_id=".$listuser[user_id];
# $href .= "&page=".$site->fdat['page'];
$href = "javascript:document.getElementById('selectform_user_id').value='".$listuser[user_id]."';document.getElementById('selectform_group_id').value='".$listuser[group_id]."';document.getElementById('selectform_user_next_id').value='".$next_id."';document.getElementById('selectform_user_prev_id').value='".$prev_id."';document.forms['selectform'].submit();";
# user is spueruser
if($listuser['is_predefined']) {$icongif = "superuser.png"; }
# ordinary user, not Everybody group member
else { $icongif = "user.png"; }
?>
<tr id="<?=$listuser[user_id]?>" <?=($site->fdat['user_id'] == $listuser[user_id] ? ' class="scms_activerow"' : '')?>>
<?##### icon ######?>
<td width="20"><img src="<?=$site->CONF['wwwroot'].$site->CONF['styles_path']?>/gfx/icons/16x16/users/<?=$icongif?>" width="16" height="16"></td>
<?# loop over visible fields
foreach(array_keys($visible_fields) as $key=>$field){
if($field=='fullname'){ $listuser[$field] = $listuser['firstname'].' '.$listuser['lastname']; }
?>
<td width="<?=$td_width?>" ondblclick="javascript:void(openpopup('<?=$site->CONF['wwwroot'].$site->CONF['adm_path']?>/edit_user.php?user_id=<?=$listuser[user_id]?>&tab=user&op=edit','user','366','450'))"><a href="<?=$href?>"><?=($listuser[$field] ? $listuser[$field] : ' ')?></a></td>
<? } # foreach ?>
<?##### delete ######?>
<!-- <td width="16" align="right"> </td>-->
</tr>
<?
$i++;
}
# / loop over users
#################
?>
</table>
</div>
<!-- //Scrollable area -->
</TD>
</TR>
<!-- //Table data -->
</TABLE>
</TD>
<?
# / MIDDLE LIST
############################
?>
</TD>
</TR>
<?
###################
# select buttons
if($args['is_browse']){
?>
<tr align="right" height=30>
<td valign="top" colspan="2" style="padding-top: 10px; padding-right:10px" >
<? if ($args['show_checkboxes']){ ?>
<input type="button" value="<?=$site->sys_sona(array(sona => "vali", tyyp=>"admin")) ?>" onclick="javascript:selectform.op2.value='selectclose'; send_box_values();" style="width: 60px">
<? } else { ?>
<input type="button" value="<?=$site->sys_sona(array(sona => "vali", tyyp=>"admin")) ?>" onclick="javascript:selectform.op2.value='selectclose';selectform.submit();" style="width: 60px">
<? } ?>
<input type="button" value="<?=$site->sys_sona(array(sona => "close", tyyp=>"editor")) ?>" onclick="javascript:window.close();" style="width: 60px">
</td>
</tr>
<?}?>
</TABLE>
<?
}
