sumo_search_composer PHP Code Examples

Example #1

0

Show file

File: action.export_datasource.php Project: airedale/sumo

/**
 * SUMO MODULE: Accesspoints | Export
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
// set table settings
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_network_dlist']) {
    $field['name'] = sumo_search_composer($_SESSION['search_network_dlist'], 'name');
    $search = $field['name'][0] ? " WHERE " . $field['name'][0] . " " : '';
}
$query = "SELECT * FROM " . SUMO_TABLE_DATASOURCES . " \n\t\t" . $search . " \n\t\t ORDER BY " . $_SESSION['network']['dlist']['col_sql'] . " " . $_SESSION['network']['dlist']['mode_sql'];
$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;

Example #2

0

Show file

File: action.group2accesspoints.php Project: airedale/sumo

 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 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
 */
$list = sumo_get_table_header($table['data']['group2accesspoints']);
while ($tab = $rs->FetchRow()) {
    $style = sumo_alternate_str('tab-row-on', 'tab-row-off');

Example #3

0

Show file

File: action.export.php Project: airedale/sumo

 * @package    SUMO
 * @category   Console
 */
// set table settings
sumo_set_table_settings();
$num_groups = count($SUMO['user']['group']);
// Create sql query to select only groups of user
$group_query = sumo_get_group_query(false, true);
$users_lang = sumo_get_string_languages();
// Create search query
$search = '';
if ($_SESSION['search_users_list']) {
    $field['user'] = sumo_search_composer($_SESSION['search_users_list'], 'username');
    $field['firstname'] = sumo_search_composer($_SESSION['search_users_list'], 'firstname');
    $field['lastname'] = sumo_search_composer($_SESSION['search_users_list'], 'lastname');
    $field['email'] = sumo_search_composer($_SESSION['search_users_list'], 'email');
    $search = $group_query ? " AND " : " WHERE ";
    $operand = count($field['lastname'][1]) > 1 ? 'AND' : 'OR';
    if ($field['user'][0] && $field['firstname'][0] && $field['lastname'][0]) {
        $search = $search . "((" . $field['user'][0] . ") OR (" . $field['email'][0] . ") OR " . "((" . $field['firstname'][0] . ") " . $operand . " (" . $field['lastname'][0] . ")) OR " . "(" . $field['usergroup'][0] . "))";
    } else {
        $search = '';
    }
}
$query = "SELECT * FROM " . SUMO_TABLE_USERS . " " . $group_query . " " . $search . " \n\t  ORDER BY " . $_SESSION['users']['list']['col_sql'] . " " . $_SESSION['users']['list']['mode_sql'];
$rs = $SUMO['DB']->CacheExecute(10, $query);
// Get datasources list
if ($_SESSION['users']['list']['col'][9]) {
    $datasources = sumo_get_datasource_info();
    for ($d = 0; $d < count($datasources); $d++) {
        $datasource[$datasources[$d]['id']] = $datasources[$d]['name'];

Example #4

0

Show file

File: action.user2accesspoints.php Project: airedale/sumo

 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 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_user2accesspoints']) {
    $field['user'] = sumo_search_composer($_SESSION['search_relationship_user2accesspoints'], 'username');
    $field['firstname'] = sumo_search_composer($_SESSION['search_relationship_user2accesspoints'], 'firstname');
    $field['lastname'] = sumo_search_composer($_SESSION['search_relationship_user2accesspoints'], 'lastname');
    $search = $group_query ? " AND " : " WHERE ";
    $search = $search . "( (" . $field['user'][0] . ") OR " . "((" . $field['firstname'][0] . ") OR (" . $field['lastname'][0] . ")))";
}
$query1 = "SELECT id,username,firstname,lastname FROM " . SUMO_TABLE_USERS . " " . $group_query . " " . $search . "";
$query2 = $query1 . " ORDER BY " . $_SESSION['relationship']['user2accesspoints']['col_sql'] . " " . $_SESSION['relationship']['user2accesspoints']['mode_sql'];
$rs = $SUMO['DB']->Execute($query1);
$tot = $rs->PO_RecordCount();
$rs = $SUMO['DB']->SelectLimit($query2, $_SESSION['rows_relationship_user2accesspoints'], $_SESSION['start_relationship_user2accesspoints']);
$vis = $rs->PO_RecordCount();
/**
 * Create list
 */
$list = sumo_get_table_header($table['data']['user2accesspoints']);
while ($tab = $rs->FetchRow()) {
    $style = sumo_alternate_str('tab-row-on', 'tab-row-off', $tab['username']);

Example #5

0

Show file

File: action.banned.php Project: airedale/sumo

 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
// ...verify if user can enable banned ip's
$enableip = sumo_verify_permissions(4, 'sumo');
// enable IP address
if ($_GET['enableip'] != '' && $enableip) {
    sumo_enable_bannedip($_GET['enableip']);
}
// set table settings
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_security_banned']) {
    $field['ip'] = sumo_search_composer($_SESSION['search_security_banned'], 'ip');
    $search = $field['ip'][0] ? " WHERE " . $field['ip'][0] . " " : '';
}
$query1 = "SELECT * FROM " . SUMO_TABLE_BANNED . " " . $search . " ";
$query2 = $query1 . " ORDER BY " . $_SESSION['security']['banned']['col_sql'] . " " . $_SESSION['security']['banned']['mode_sql'];
$rs = $SUMO['DB']->Execute($query1);
$tot = $rs->PO_RecordCount();
$rs = $SUMO['DB']->SelectLimit($query2, $_SESSION['rows_security_banned'], $_SESSION['start_security_banned']);
$vis = $rs->PO_RecordCount();
/**
 * Create list
 */
$col = $_SESSION['security']['banned']['col'];
if ($tot > 0) {
    $list = sumo_get_table_header($table['data']['banned']);
    while ($tab = $rs->FetchRow()) {

Example #6

0

Show file

File: action.slist.php Project: airedale/sumo

/**
 * SUMO MODULE: Sessions | Sessions list
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_sessions_slist']) {
    //$field['id'] = sumo_search_composer($_SESSION['search_sessions_slist'], 'id');
    $field['user'] = sumo_search_composer($_SESSION['search_sessions_slist'], 'username');
    $search = $field['user'][0] ? " WHERE " . $field['user'][0] . " " : '';
}
// Get nodes info
$query = "SELECT id,host,name FROM " . SUMO_TABLE_NODES . "\n\t  WHERE active = 1";
$rs = $SUMO['DB']->CacheExecute(300, $query);
while ($tab = $rs->FetchRow()) {
    $node[$tab['host']] = $tab;
}
$query = "SELECT 'max_activity' as status,MAX(activity) AS value FROM " . SUMO_TABLE_SESSIONS . "\n\t\t  UNION\n\t\t  SELECT 'active',COUNT(id) AS value FROM " . SUMO_TABLE_SESSIONS . "\n\t\t  WHERE expire > " . $SUMO['server']['time'] . "\n\t\t  UNION\n\t\t  SELECT 'inactive',COUNT(id) AS value FROM " . SUMO_TABLE_SESSIONS . "\n\t\t  WHERE expire < " . $SUMO['server']['time'];
$rs = $SUMO['DB']->Execute($query);
while ($tab = $rs->FetchRow()) {
    if ($tab['status'] == 'max_activity') {
        $max = $tab['value'];
    }
    if ($tab['status'] == 'active') {

Example #7

0

Show file

File: action.clist.php Project: airedale/sumo

/**
 * SUMO MODULE: Sessions | Connections list
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_sessions_clist']) {
    $field['ip'] = sumo_search_composer($_SESSION['search_sessions_clist'], 'ip');
    $search = " WHERE " . $field['ip'][0] . "";
}
$query1 = "SELECT node,ip,requests,time FROM " . SUMO_TABLE_CONNECTIONS . " " . $search;
$query2 = $query1 . " ORDER BY " . $_SESSION['sessions']['clist']['col_sql'] . " " . $_SESSION['sessions']['clist']['mode_sql'];
$rs = $SUMO['DB']->CacheExecute(5, $query1);
$tot = $rs->PO_RecordCount();
$SUMO['DB']->cacheSecs = 5;
$rs = $SUMO['DB']->CacheSelectLimit($query2, $_SESSION['rows_sessions_clist'], $_SESSION['start_sessions_clist']);
$vis = $rs->PO_RecordCount();
/**
 * Create list
 */
if ($tot > 0) {
    $list = sumo_get_table_header($table['data']['clist']);
    $col = $_SESSION['sessions']['clist']['col'];

Example #8

0

Show file

File: action.export.php Project: airedale/sumo

 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 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';

Example #9

0

Show file

File: action.ilist.php Project: airedale/sumo

/**
 * SUMO MODULE: Network | Local network list
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_network_ilist']) {
    $field['ip'] = sumo_search_composer($_SESSION['search_network_ilist'], 'ip');
    $search = $field['ip'][0] ? " WHERE " . $field['ip'][0] . " " : '';
}
$query1 = "SELECT * FROM " . SUMO_TABLE_INTRANETIP . " " . $search;
$query2 = $query1 . " ORDER BY " . $_SESSION['network']['ilist']['col_sql'] . " " . $_SESSION['network']['ilist']['mode_sql'];
$rs = $SUMO['DB']->Execute($query1);
$tot = $rs->PO_RecordCount();
$rs = $SUMO['DB']->SelectLimit($query2, $_SESSION['rows_network_ilist'], $_SESSION['start_network_ilist']);
$vis = $rs->PO_RecordCount();
$list = sumo_get_table_header($table['data']['ilist']);
/**
 * Create list
 */
$col = $_SESSION['network']['ilist']['col'];
while ($tab = $rs->FetchRow()) {
    $style = sumo_alternate_str('tab-row-on', 'tab-row-off');

Example #10

0

Show file

File: action.export.php Project: airedale/sumo

/**
 * SUMO MODULE: Security | Export
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
// set table settings
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_security_' . $table]) {
    $field['message'] = sumo_search_composer($_SESSION['search_security_' . $table], 'message', 'AND');
    if ($field['message'][0]) {
        $search = "WHERE (" . $field['message'][0] . ")";
    }
}
$submodule = $_GET['submodule'];
// Table selector
switch ($submodule) {
    case 'system_list':
        $query = "SELECT * FROM " . SUMO_TABLE_LOG_SYSTEM . " " . $search;
        break;
    case 'access_list':
        $query = "SELECT * FROM " . SUMO_TABLE_LOG_ACCESS . " " . $search;
        break;
    case 'errors_list':
        $query = "SELECT * FROM " . SUMO_TABLE_LOG_ERRORS . " " . $search;

Example #11

0

Show file

File: action.accesspoint2users.php Project: airedale/sumo

/**
 * SUMO MODULE: Relationship
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_relationship_accesspoint2users']) {
    $field['path'] = sumo_search_composer($_SESSION['search_relationship_accesspoint2users'], 'path');
    $field['name'] = sumo_search_composer($_SESSION['search_relationship_accesspoint2users'], 'name');
    $search = $field['path'][0] && $field['name'][0] ? " WHERE (" . $field['path'][0] . " OR " . $field['name'][0] . ") " : '';
}
// Create sql query	to select only groups of user
$group_query = sumo_get_group_query($search);
$query1 = "SELECT * FROM " . SUMO_TABLE_ACCESSPOINTS . " " . $group_query . " " . $search . "";
$query2 = $query1 . " ORDER BY " . $_SESSION['relationship']['accesspoint2users']['col_sql'] . " " . $_SESSION['relationship']['accesspoint2users']['mode_sql'];
$rs = $SUMO['DB']->Execute($query1);
$tot = $rs->PO_RecordCount();
$rs = $SUMO['DB']->SelectLimit($query2, $_SESSION['rows_relationship_accesspoint2users'], $_SESSION['start_relationship_accesspoint2users']);
$vis = $rs->PO_RecordCount();
/**
 * Create list
 */
$list = sumo_get_table_header($table['data']['accesspoint2users']);
while ($tab = $rs->FetchRow()) {

Example #12

0

Show file

File: action.export.php Project: airedale/sumo

 * SUMO MODULE: Groups | Export Data
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
// set table settings
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_groups_list']) {
    $field['usergroup'] = sumo_search_composer($_SESSION['search_groups_list'], 'usergroup');
    $field['description'] = sumo_search_composer($_SESSION['search_groups_list'], 'description');
    $search = $field['usergroup'][0] && $field['description'][0] ? "WHERE (" . $field['usergroup'][0] . " OR " . $field['description'][0] . ")" : "";
}
// Create sql query	to select only groups of user
$group_query = sumo_get_group_query($search);
$query = "SELECT * FROM " . SUMO_TABLE_GROUPS . " \n\t\t " . $search . " \n\t\t " . $group_query . " \n\t\t  ORDER BY " . $_SESSION['groups']['list']['col_sql'] . " " . $_SESSION['groups']['list']['mode_sql'];
$rs = $SUMO['DB']->CacheExecute(10, $query);
switch ($_POST['type']) {
    case '':
    case 'csv':
        $ext = 'csv';
        break;
    case 'xls':
        $ext = 'xls';
        break;
    case 'csvdump':

Example #13

0

Show file

File: action.nlist.php Project: airedale/sumo

/**
 * SUMO MODULE: Network | Network List
 * 
 * @version    0.5.0
 * @link       http://sumoam.sourceforge.net SUMO Access Manager
 * @author     Alberto Basso <*****@*****.**>
 * @copyright  Copyright &copy; 2003-2009, Alberto Basso
 * @package    SUMO
 * @category   Console
 */
sumo_set_table_settings();
// Create search query
$search = '';
if ($_SESSION['search_network_nlist']) {
    $field['name'] = sumo_search_composer($_SESSION['search_network_nlist'], 'name');
    $field['host'] = sumo_search_composer($_SESSION['search_network_nlist'], 'host');
    $search = $field['name'][0] && $field['host'][0] ? " WHERE (" . $field['name'][0] . " OR " . $field['host'][0] . ") " : '';
}
$query1 = "SELECT * FROM " . SUMO_TABLE_NODES . " " . $search;
$query2 = $query1 . " ORDER BY " . $_SESSION['network']['nlist']['col_sql'] . " " . $_SESSION['network']['nlist']['mode_sql'];
$rs = $SUMO['DB']->Execute($query1);
$tot = $rs->PO_RecordCount();
$rs = $SUMO['DB']->SelectLimit($query2, $_SESSION['rows_network_nlist'], $_SESSION['start_network_nlist']);
$vis = $rs->PO_RecordCount();
/**
 * Create list
 */
$list = sumo_get_table_header($table['data']['nlist']);
$col = $_SESSION['network']['nlist']['col'];
while ($tab = $rs->FetchRow()) {
    $style = sumo_alternate_str('tab-row-on', 'tab-row-off');

PHP sumo_search_composer Examples