source: extensions/Piwecard/admin/admin_permissions.php @ 30617

<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

global $template, $page, $conf;
 
$piwecard = get_plugin_data($plugin_id);

// +-----------------------------------------------------------------------+
// |                           form submission                             |
// +-----------------------------------------------------------------------+
// Switch on right side (=>)    
if (isset($_POST['falsify']) and isset($_POST['cat_true']) and count($_POST['cat_true']) > 0) {
        $piwecard->config['authorized_cats'] = 'selected';
        
        foreach ($_POST['cat_true'] as $cat)
                unset($piwecard->config['selected_cats'][array_search($cat, $piwecard->config['selected_cats'])]);
        $piwecard->set_config();
}

// Switch on left side (<=)
if (isset($_POST['trueify']) and isset($_POST['cat_false']) and count($_POST['cat_false']) > 0) {
        $query = 'SELECT id, name, uppercats, global_rank FROM '.CATEGORIES_TABLE.' WHERE id IN ("'.implode('","', $_POST['cat_false']).'");';
        $result = pwg_query($query);

        $piwecard->config['authorized_cats'] = 'selected';
        
        if (!empty($result)) {
                while ($cat = pwg_db_fetch_assoc($result))
                        array_push($piwecard->config['selected_cats'], $cat['id']);                     
        }
        usort($piwecard->config['selected_cats'], 'global_rank_compare');

        $piwecard->set_config();
}

if (isset($_POST['submit'])) {
        $piwecard->config['authorized_cats'] = $_POST['ecard_authorized_cats'];
        if ($_POST['ecard_authorized_cats'] == 'user')
                $piwecard->config['user_cats_case_sensitive'] = ((isset($_POST['ecard_user_cats_case_sensitive']) && $_POST['ecard_user_cats_case_sensitive'] == '1') ? true : false);
        $piwecard->config['authorized_groups_users'] = $_POST['ecard_authorized_groups_users'];
        if ($_POST['ecard_authorized_groups_users'] == 'granted' OR $_POST['ecard_authorized_groups_users'] == 'denied') {
                $piwecard->config['selected_groups'] = (isset($_POST['groups']) ? $_POST['groups'] : array());
                $piwecard->config['selected_users'] = (isset($_POST['users']) ? $_POST['users'] : array());
        }
        $piwecard->set_config();
        array_push($page['infos'], l10n('Information data registered in database'));
}

// +-----------------------------------------------------------------------+
// |                       template initialization                         |
// +-----------------------------------------------------------------------+

$template->set_filenames(array(
        'plugin_admin_content'  => PIWECARD_ROOT.'/admin/template/admin_permissions.tpl',
        'double_select'                 => 'double_select.tpl'
));
$template->assign('ecard', array(
                                                                'all_cats_checked' => (($piwecard->config['authorized_cats'] == 'all') ? 'checked="checked"' : ''),
                                                                'selected_cats_checked' => (($piwecard->config['authorized_cats'] == 'selected') ? 'checked="checked"' : ''),
                                                                'user_cats_checked' => (($piwecard->config['authorized_cats'] == 'user') ? 'checked="checked"' : ''),
                                                                'user_cats_case_sensitive' => (($piwecard->config['user_cats_case_sensitive']) ? 'checked="checked"' : ''),
                                                                'all_groups_users_checked' =>  (($piwecard->config['authorized_groups_users'] == 'all') ? 'checked="checked"' : ''),
                                                                'granted_groups_users_checked' =>  (($piwecard->config['authorized_groups_users'] == 'granted') ? 'checked="checked"' : ''),
                                                                'denied_groups_users_checked' =>  (($piwecard->config['authorized_groups_users'] == 'denied') ? 'checked="checked"' : ''),
                                                        )
);
$template->assign(array(
                                                'F_ACTION' => '',
                                                'L_CAT_OPTIONS_TRUE' => l10n('piwecard_selected_cats'),
                                                'L_CAT_OPTIONS_FALSE' => l10n('piwecard_non_selected_cats'),
                                        )
);

// +-----------------------------------------------------------------------+
// |                          form construction                            |
// +-----------------------------------------------------------------------+
//Populate double_select
$query = 'SELECT id, name, uppercats, global_rank FROM '.CATEGORIES_TABLE.' WHERE id not IN ("'.implode('","', $piwecard->config['selected_cats']).'");';
$result = pwg_query($query);
$categories = array();
if (!empty($result)) {
        while ($row = pwg_db_fetch_assoc($result))
                array_push($categories, $row);
}
usort($categories, 'global_rank_compare');

$tpl = array();
if (!empty($result)) {
        foreach ($categories as $cat) {
        $tpl_false[$cat['id']] = get_cat_display_name_cache($cat['uppercats'], null, false);
        }
}
$template->assign('category_option_false', $tpl_false);
$template->assign('category_option_false_selected', array());

$query = 'SELECT id, name, uppercats, global_rank FROM '.CATEGORIES_TABLE.' WHERE id IN ("'.implode('","', $piwecard->config['selected_cats']).'");';
$result = pwg_query($query);
$categories = array();
if (!empty($result)) {
        while ($row = pwg_db_fetch_assoc($result))
                array_push($categories, $row);
}
usort($categories, 'global_rank_compare');

$tpl_true = array();
if (!empty($result)) {
        foreach ($categories as $cat) {
        $tpl_true[$cat['id']] = get_cat_display_name_cache($cat['uppercats'], null, false);
        }
}
$template->assign('category_option_true', $tpl_true);
$template->assign('category_option_true_selected', array());

//Populate Groups and Users
//Groups
$groups = array();
$query = 'SELECT id, name FROM '.GROUPS_TABLE.' ORDER BY name ASC;';
$groups = simple_hash_from_query($query, 'id', 'name');
$template->assign('groups', $groups);

//Selected groups
$selected_groups = $piwecard->config['selected_groups'];
$template->assign('piwecard_selected_groups', $selected_groups);

//Users
$users = array();
$query = 'SELECT '.$conf['user_fields']['id'].' AS id, '.$conf['user_fields']['username'].' AS username FROM '.USERS_TABLE.';';
$users = simple_hash_from_query($query, 'id', 'username');
$template->assign('users', $users);

//Selected users
$selected_users = $piwecard->config['selected_users'];
$template->assign('piwecard_selected_users', $selected_users);

if (count($selected_groups) > 0) {
        $selected_groups_ids = array();
        $query = 'SELECT user_id, group_id FROM '.USER_GROUP_TABLE.' WHERE group_id IN ('.implode(',', $selected_groups).');';
        $result = pwg_query($query);
        while ($row = pwg_db_fetch_assoc($result)) {
                if (!isset($selected_groups_ids[$row['group_id']])) {
                  $selected_groups_ids[$row['group_id']] = array();
                }
                array_push($selected_groups_ids[$row['group_id']], $row['user_id']);
        }
        $user_selected_by_group_ids = array();
        foreach ($selected_groups_ids as $group_users) {
                $user_selected_by_group_ids = array_merge($user_selected_by_group_ids, $group_users);
        }
        $user_selected_by_group_ids = array_unique($user_selected_by_group_ids);
        $user_selected_indirect_ids = array_diff($user_selected_by_group_ids, $selected_users);

        $template->assign('nb_users_selected_indirect', count($user_selected_indirect_ids));
        $template->assign('nb_users_selected_indirect_style', array(
                                                                                                                                'granted' => (($piwecard->config['authorized_groups_users'] == 'granted') ? '' : 'style="display: none"'),
                                                                                                                                'denied' => (($piwecard->config['authorized_groups_users'] == 'denied') ? '' : 'style="display: none"'),
                                                                                                                        )
        );

        foreach ($selected_groups_ids as $group_id => $group_users) {
                $group_usernames = array();
                foreach ($group_users as $user_id) {
                        if (in_array($user_id, $user_selected_indirect_ids)) {
                        array_push($group_usernames, $users[$user_id]);
                        }
                }

                $template->append('user_selected_indirect_groups', array(
                                                                                                                                'group_name' => $groups[$group_id],
                                                                                                                                'group_users' => implode(', ', $group_usernames),
                                                                                                                        )
                );
        }
}

// +-----------------------------------------------------------------------+
// |                           sending html code                           |
// +-----------------------------------------------------------------------+

$template->assign_var_from_handle('DOUBLE_SELECT', 'double_select');
$template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');