gacl/admin/group_admin.php

   1 <?php
   2 //First make sure user has access
   3 include_once("../../interface/globals.php");
   4 include_once("$srcdir/acl.inc");
   5 //ensure user has proper access
   6 if (!acl_check('admin', 'acl')) {
   7             echo xl('ACL Administration Not Authorized');
   8             exit;
   9 }
  10 //ensure php is installed
  11 if (!isset($phpgacl_location)) {
  12             echo xl('php-GACL access controls are turned off');
  13             exit;
  14 }
  15
  16
  17 require_once('gacl_admin.inc.php');
  18
  19 //GET takes precedence.
  20 if ($_GET['group_type'] != '') {
  21         $group_type = $_GET['group_type'];
  22 } else {
  23         $group_type = $_POST['group_type'];
  24 }
  25
  26 switch(strtolower(trim($group_type))) {
  27         case 'axo':
  28                 $group_type = 'axo';
  29                 $group_table = $gacl_api->_db_table_prefix . 'axo_groups';
  30                 $group_map_table = $gacl_api->_db_table_prefix . 'groups_axo_map';
  31                 $smarty->assign('current','axo_group');
  32                 break;
  33         default:
  34                 $group_type = 'aro';
  35                 $group_table = $gacl_api->_db_table_prefix . 'aro_groups';
  36                 $group_map_table = $gacl_api->_db_table_prefix . 'groups_aro_map';
  37                 $smarty->assign('current','aro_group');
  38                 break;
  39 }
  40
  41 switch ($_POST['action']) {
  42         case 'Delete':
  43                 //See edit_group.php
  44                 break;
  45         default:
  46                 $formatted_groups = $gacl_api->format_groups($gacl_api->sort_groups($group_type), HTML);
  47
  48                 $query = '
  49                         SELECT          a.id, a.name, a.value, count(b.'. $group_type .'_id)
  50                         FROM            '. $group_table .' a
  51                         LEFT JOIN       '. $group_map_table .' b ON b.group_id=a.id
  52                         GROUP BY        a.id,a.name,a.value';
  53                 $rs = $db->Execute($query);
  54
  55                 $group_data = array();
  56
  57                 if(is_object($rs)) {
  58                         while($row = $rs->FetchRow()) {
  59                                 $group_data[$row[0]] = array(
  60                                         'name' => $row[1],
  61                                         'value' => $row[2],
  62                                         'count' => $row[3]
  63                                 );
  64                         }
  65                 }
  66
  67                 $groups = array();
  68
  69                 foreach($formatted_groups as $id => $name) {
  70                         $groups[] = array(
  71                                 'id' => $id,
  72                                 // 'parent_id' => $parent_id,
  73                                 // 'family_id' => $family_id,
  74                                 'name' => $name,
  75                                 'raw_name' => $group_data[$id]['name'],
  76                                 'value' => $group_data[$id]['value'],
  77                                 'object_count' => $group_data[$id]['count']
  78                         );
  79                 }
  80
  81                 $smarty->assign('groups', $groups);
  82                 break;
  83 }
  84
  85 $smarty->assign('group_type', $group_type);
  86 $smarty->assign('return_page', $_SERVER['REQUEST_URI']);
  87
  88 $smarty->assign('current', $group_type .'_group');
  89 $smarty->assign('page_title', strtoupper($group_type) .' Group Admin');
  90
  91 $smarty->assign('phpgacl_version', $gacl_api->get_version());
  92 $smarty->assign('phpgacl_schema_version', $gacl_api->get_schema_version());
  93
  94 $smarty->display('phpgacl/group_admin.tpl');
  95 ?>