trAvis - MANAGER

Edit File: policy-group-member-main.php

<?php
# Policy group member screen
# Copyright (C) 2009-2011, AllWorldIT
# Copyright (C) 2008, LinuxRulz
# 
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
# 
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License along
# with this program; if not, write to the Free Software Foundation, Inc.,
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

include_once("includes/header.php");
include_once("includes/footer.php");
include_once("includes/db.php");

$db = connect_db();

printHeader(array(
		"Tabs" => array(
			"Back to groups" => "policy-group-main.php"
		),
));

# Check a policy group was selected
if (isset($_REQUEST['policy_group_id'])) {

?>
	<p class="pageheader">Policy Group Members</p>
	
<?php

$policy_group_stmt = $db->prepare("SELECT Name FROM ${DB_TABLE_PREFIX}policy_groups WHERE ID = ?");
	$policy_group_stmt->execute(array($_REQUEST['policy_group_id']));
	$row = $policy_group_stmt->fetchObject();
	$policy_group_stmt->closeCursor();
?>
	<form id="main_form" action="policy-group-member-main.php" method="post">
		<div>
			<input type="hidden" name="policy_group_id" value="<?php echo $_REQUEST['policy_group_id'] ?>" />
		</div>
		<div class="textcenter">
			<div class="notice">Policy Group: <?php echo $row->name ?></div>

Action
			<select id="main_form_action" name="frmaction" 
					onchange="
						var myform = document.getElementById('main_form');
						var myobj = document.getElementById('main_form_action');

if (myobj.selectedIndex == 2) {
							myform.action = 'policy-group-member-add.php';
							myform.submit();
						} else if (myobj.selectedIndex == 4) {
							myform.action = 'policy-group-member-change.php';
							myform.submit();
						} else if (myobj.selectedIndex == 5) {
							myform.action = 'policy-group-member-delete.php';
							myform.submit();
						}
">
	 
				<option selected>select action</option>
				<option disabled="disabled"> - - - - - - - - - - - </option>
				<option value="add">Add</option>
				<option disabled="disabled"> - - - - - - - - - - - </option>
				<option value="change">Change</option>
				<option value="delete">Delete</option>
			</select> 
		</div>

<p />

<table class="results" style="width: 75%;">
			<tr class="resultstitle">
				<td id="noborder"></td>
				<td class="textcenter">Member</td>
				<td class="textcenter">Disabled</td>
			</tr>
<?php

$stmt = $db->prepare("SELECT ID, Member, Disabled FROM ${DB_TABLE_PREFIX}policy_group_members WHERE PolicyGroupID = ?");
			$res = $stmt->execute(array($_REQUEST['policy_group_id']));

$i = 0;

# Loop with rows
			while ($row = $stmt->fetchObject()) {
?>
				<tr class="resultsitem">
					<td><input type="radio" name="policy_group_member_id" value="<?php echo $row->id ?>" /></td>
					<td class="textcenter"><?php echo $row->member ?></td>
					<td class="textcenter"><?php echo $row->disabled ? 'yes' : 'no' ?></td>
				</tr>
<?php
				}
				$stmt->closeCursor();
?>
		</table>
	</form>
<?php
} else {
?>
	<div class="warning">Invalid invocation</div>
<?php
}

printFooter();

# vim: ts=4
?>