echo '</header>';
echo '<h3 class="SponsID">';
echo 'SponsID: ' . $SponsID;
echo '<br>Name: ' . get_person_name($SponsID);
$role = get_access_level($SponsID);
$printing_role = $role;
if ($role == 'SponsRep') $printing_role = "Sponsorship Representative";
if ($role == 'SectorHead') $printing_role = "Sector Head";
if ($role == 'CSO') $printing_role = "Chief Sponsorship Officer";
echo '<br>Role: ' . $printing_role;
if (get_access_level($SponsID) == "SponsRep" || get_access_level($SponsID) == "SectorHead"){
echo '<br>Sector: ' . get_person_sector($SponsID);
}
echo '</h3>';
echo '<div align="center">';
$meeting_view_query = "SELECT
SponsOfficer.SponsID as 'SponsID',
Name as 'SponsRep Name',
CMPName as 'Company Name',
CEName as 'Company Executive Name',
MeetingType as 'Meeting Type',
Date,
<?php
session_start();
require './DBconnect.php';
require './library_functions.php';
$SponsID = $_SESSION['loginID'];
//get SponsID from previos session
$SponsAccessLevel = get_access_level($SponsID);
if ($SponsAccessLevel != "CSO") {
header('Location: ./home.php');
}
// //Amount Earned By Each Sector Pie Chart
// $Amount_Earned_by_IT_Sector = mysql_query("SELECT sum(Amount) Amount_Earned_by_Sector_in_Rupees FROM
// (`AccountLog` inner join ((SELECT SponsID, Sector FROM `SectorHead`)
// UNION (SELECT SponsID, Sector FROM SponsRep)) as `SponsOfficer` on SponsOfficer.SponsID = AccountLog.SponsID)
// WHERE Sector=\"IT\" GROUP BY `Sector` ORDER BY Amount_Earned_by_Sector_in_Rupees DESC;");
// $Amount_Earned_by_IT_Sector_Result = mysql_fetch_assoc($Amount_Earned_by_IT_Sector);
// $IT = (int)$Amount_Earned_by_IT_Sector_Result["Amount_Earned_by_Sector_in_Rupees"];
// $Amount_Earned_by_Builders_Sector = mysql_query("SELECT sum(Amount) Amount_Earned_by_Sector_in_Rupees FROM
// (`AccountLog` inner join ((SELECT SponsID, Sector FROM `SectorHead`)
// UNION (SELECT SponsID, Sector FROM SponsRep)) as `SponsOfficer` on SponsOfficer.SponsID = AccountLog.SponsID)
// WHERE Sector=\"Builders\"
// GROUP BY `Sector` ORDER BY Amount_Earned_by_Sector_in_Rupees DESC;");
// $Amount_Earned_by_Builders_Sector_Result = mysql_fetch_assoc($Amount_Earned_by_Builders_Sector);
// $Builders = (int)$Amount_Earned_by_Builders_Sector_Result["Amount_Earned_by_Sector_in_Rupees"];
// $Amount_Earned_by_Clothes_Retail_Sector = mysql_query("SELECT sum(Amount) Amount_Earned_by_Sector_in_Rupees FROM
// (`AccountLog` inner join ((SELECT SponsID, Sector FROM `SectorHead`)
// UNION (SELECT SponsID, Sector FROM SponsRep)) as `SponsOfficer` on SponsOfficer.SponsID = AccountLog.SponsID)
// WHERE Sector=\"Clothes Retail\"
// GROUP BY `Sector` ORDER BY Amount_Earned_by_Sector_in_Rupees DESC;");
// $Amount_Earned_by_Clothes_Retail_Sector_Result = mysql_fetch_assoc($Amount_Earned_by_Clothes_Retail_Sector);
foreach ($auth_info as $user_id => $info) {
if ($user_id != $_SESSION['user_id']) {
echo "<option value=\"" . $info['id'] . "\">" . $info['username'] . "</option>\n";
}
//Don't let admins modify their own privileges
}
echo "</select></td>\n" . "<td rowspan=\"2\" style=\"width:175px\">";
echo_checkboxes();
echo "</td>\n" . "<td><input type=\"submit\" value=\"Modify User\"></td></tr>\n" . "<tr><td style=\"vertical-align:top\"><b>Full Name:</b><br><input type=\"text\" name=\"real_name\" style=\"width:150px\"></td><td></td></tr>" . "</table>\n</form>";
break;
//----------------------------------------
//----------------------------------------
case 'add_user':
default:
if (isset($_POST['username'])) {
$access_level = get_access_level();
$result = add_user($_POST['username'], $_POST['password'], $_POST['real_name'], $access_level);
if ($result != 1) {
echo "<br>" . $result . "<br>\n";
} else {
echo "<br>User has been successfully added!<br>\n";
}
}
echo "<br><br><form action=\"" . $_SERVER['PHP_SELF'] . "?function=add_user\" method=\"POST\">\n" . "<table id=\"checkbox_table\">\n" . "<tr><th colspan=\"4\">Add User Account</th></tr>\n" . "<tr><th>Username</th><th>Password</th><th style=\"width:150px\">Access</th><th> </th></tr>\n" . "<tr><td style=\"vertical-align:top\"><input type=\"text\" name=\"username\" style=\"width:100px\"></td>\n" . "<td><input type=\"password\" name=\"password\" style=\"width:100px\"></td>\n" . "<td rowspan=\"2\">";
echo_checkboxes();
echo "</td>\n" . "<td><input type=\"submit\" value=\"Add User\"></td></tr>\n" . "<tr><td colspan=\"2\" style=\"vertical-align:top\"><b>Full Name:</b><br><input type=\"text\" name=\"real_name\" style=\"width:150px\"></td><td></td></tr>" . "</table>\n</form>";
break;
}
//END switch
?>
</div><!-- END 'content' -->
