/**
* SUMO MODULE: Relationship
*
* @version 0.5.0
* @link http://sumoam.sourceforge.net SUMO Access Manager
* @author Alberto Basso <*****@*****.**>
* @copyright Copyright © 2003-2009, Alberto Basso
* @package SUMO
* @category Console
*/
sumo_set_table_settings();
$num_groups = count($SUMO['user']['group']);
// Create sql query to select only groups of user
// and optionally search only users of a group
$group_query = sumo_get_group_query(false, true);
// Create search query
$search = '';
if ($_SESSION['search_relationship_group2accesspoints']) {
$field['usergroup'] = sumo_search_composer($_SESSION['search_relationship_group2accesspoints'], 'usergroup');
$search = $group_query ? " AND " : " WHERE ";
$search = $search . " (" . $field['usergroup'][0] . ")";
}
$query1 = "SELECT id,usergroup FROM " . SUMO_TABLE_GROUPS . " " . $group_query . " " . $search . "";
$query2 = $query1 . " ORDER BY " . $_SESSION['relationship']['group2accesspoints']['col_sql'] . " " . $_SESSION['relationship']['group2accesspoints']['mode_sql'];
$rs = $SUMO['DB']->Execute($query1);
$tot = $rs->PO_RecordCount();
$rs = $SUMO['DB']->SelectLimit($query2, $_SESSION['rows_relationship_group2accesspoints'], $_SESSION['start_relationship_group2accesspoints']);
$vis = $rs->PO_RecordCount();
/**
* Create list
* @copyright Copyright © 2003-2009, Alberto Basso
* @package SUMO
* @category Console
*/
// set table settings
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_accesspoints_list']) {
$field['b.name'] = sumo_search_composer($_SESSION['search_accesspoints_list'], 'b.name');
$field['a.path'] = sumo_search_composer($_SESSION['search_accesspoints_list'], 'a.path');
$field['a.name'] = sumo_search_composer($_SESSION['search_accesspoints_list'], 'a.name');
$search = $field['a.path'][0] && $field['a.name'][0] && $field['b.name'][0] ? " AND (" . $field['a.path'][0] . " OR " . $field['a.name'][0] . " OR " . $field['b.name'][0] . ") " : '';
}
// Create sql query to select only groups of user
$group_query = sumo_get_group_query($search);
$query = "SELECT a.id AS id, b.\"name\" AS node_name, a.path AS path, a.\"name\" AS \"name\", \na.usergroup AS usergroup, a.http_auth AS http_auth, a.filtering AS filtering,\na.pwd_encrypt AS pwd_encrypt, a.registration AS registration, a.reg_group AS reg_group, \na.change_pwd AS change_pwd, a.theme AS theme, a.created AS created, a.updated AS updated,\nb.id AS node_id\nFROM " . SUMO_TABLE_ACCESSPOINTS . " a, " . SUMO_TABLE_NODES . " b \nWHERE a.node = b.id " . $search . " " . $group_query . " \nORDER BY " . $_SESSION['accesspoints']['list']['col_sql'] . " " . $_SESSION['accesspoints']['list']['mode_sql'];
// MySQL Fix
$query = str_replace('"', '', $query);
$rs = $SUMO['DB']->Execute($query);
switch ($_POST['type']) {
case '':
case 'csv':
$ext = 'csv';
break;
case 'xls':
$ext = 'xls';
break;
case 'csvdump':
$ext = 'dump.csv';
break;