Changeset 517 for trunk/xpressme_integration_kit/admin/index.php

Timestamp:

Feb 25, 2010, 1:24:08 AM (15 years ago)

Author:

toemon

Message:

システム情報にグループ権限の情報を表示 Fixes #288

File:

• trunk/xpressme_integration_kit/admin/index.php (modified) (2 diffs)

trunk/xpressme_integration_kit/admin/index.php

@@ -610 +610 @@
         }
 }
+function xpress_group_role_state($is_report = false)
+{
+        global $xoopsModule;
+        $xoopsDB =& Database::getInstance();
+        $xp_prefix = $GLOBALS['xoopsModule']->getInfo('dirname');
+        if ($xp_prefix == 'wordpress'){
+                $xp_prefix = 'wp';
+        }
+        $prefix = $xoopsDB->prefix($xp_prefix . '_');
+        $group_role_tables = $prefix.'group_role';
+        $sql = "SELECT groupid , name AS xoops_groupe ,group_type, role , login_all FROM ". $group_role_tables;
+        $result = $xoopsDB->query($sql);
+        if ($is_report){
+                echo "******** " . _AM_XP2_GROUP_ROLE . "********" . "<br />\n";
+        } else {
+                echo "<fieldset><legend style='font-weight: bold; color: #900;'>" . _AM_XP2_GROUP_ROLE . "</legend>";
+                echo "<div style='padding: 8px;'>";
+                echo '<table width="400" cellspacing="1" cellpadding="1" border="1">';
+                echo '<tbody>';
+                echo '<tr>';
+                echo '<td>GROUP</td>';
+                echo '<td>GROUPE TYPE</td>';
+                echo '<td>ROLE</td>';
+                echo '<td>Allways Check</td>';
+                echo '</tr>';
+        }
+        $groupe_list = '';
+        while ($myrow = $xoopsDB->fetchArray($result)){
+                $xoops_groupe = $myrow["xoops_groupe"] ;
+                $group_type = empty($myrow["group_type"]) ? "None" : $myrow["group_type"] ;
+                $role = empty($myrow["role"]) ? "inhibit register" : $myrow["role"] ;
+                $login_all = empty($myrow["login_all"]) ? 'No' : 'Yes' ;
+                if (!empty($groupe_list)) $groupe_list .= ',';
+                $groupe_list .= $myrow["groupid"];
+                if ($is_report){
+                        echo $xoops_groupe . ' : ';
+                        echo '(' . $group_type. ') : ';
+                        echo $role;
+                        echo '(' . $login_all. ') : ';
+                        echo '<br />';
+                } else {
+                        echo '<tr>';
+                        echo '<td>' . $xoops_groupe . '</td>';
+                        echo '<td>' . $group_type . '</td>';
+                        echo '<td>' . $role . '</td>';
+                        echo '<td>' . $login_all . '</td>';
+                        echo '</tr>';
+                }
+        }
+        $group_tables = $xoopsDB->prefix('groups');
+        $where = ' WHERE groupid NOT IN (' . $groupe_list . ')';
+        $sql = "SELECT groupid , name AS xoops_groupe ,group_type FROM ". $group_tables . $where;
+        $result = $xoopsDB->query($sql);
+        while ($myrow = $xoopsDB->fetchArray($result)){
+                $xoops_groupe = $myrow["xoops_groupe"] ;
+                $group_type = empty($myrow["group_type"]) ? 'inhibit(None)' : 'inhibit(' .$myrow["group_type"].')' ;
+                $role = "No set";
+                $login_all = 'No Set';
+                if ($is_report){
+                        echo $xoops_groupe . ' : ';
+                        echo '[' . $group_type. '] : ';
+                        echo $role;
+                        echo '(' . $login_all. ') : ';
+                        echo '<br />';
+                } else {
+                        echo '<tr>';
+                        echo '<td>' . $xoops_groupe . '</td>';
+                        echo '<td>' . $group_type . '</td>';
+                        echo '<td>' . $role . '</td>';
+                        echo '<td>' . $login_all . '</td>';
+                        echo '</tr>';
+                }
+        }
+        if ($is_report){
+                echo "<br />";
+        } else {
+                echo '</tbody>';
+                echo '</table>';
+                echo "</div>";
+                echo '</legend>';
+                echo "</fieldset><br />";
+        }
+}
 function xpress_block_state($is_report = false)
 {
@@ -766 +849 @@
 xpress_block_state($report);
 xpress_block_options($report);
+xpress_group_role_state($report);
 admin_check_user_meta_prefix($report);
 xpress_state($report);