require('DBconnect.php');
require('library_functions.php');
$SponsID=$_SESSION['loginID']; //get SponsID from previos session
?>
<header>
<h1>Sponsorship Department</h1>
</header>
<section id="overview">
<!-- I have put this stuff in the nav tag cause i wanted it to appear on the left without disturbing the page layout-->
<!-- You have to write a php code which displays the deals done in that sector-->
<?php
$earning_arr= get_earning_report($SponsID);
$meeting_arr= get_meeting_report($SponsID);
echo "<table class=\"sponsrepnav\" style=\"width:100%\" >";
echo"<caption><h2>Sponsorship Representative Details:</h2></caption>";
echo "<tr align=left>
<th>Name:</th>
<td>";
echo get_person_name($SponsID);
echo "</td></tr><tr align=left>
<th>Sector:</th>
<td>";
echo get_person_sector($SponsID);
echo "</td></tr><tr align=left>
<th>Companies signed:</th>
<td>";
function get_sector_details($SponsSector)
{
require 'DBconnect.php';
//this is needed in every function that uses mySQL
$num_spons_reps = 0;
$num_sector_heads = 0;
$num_companies_in_sector = 0;
$total_companies_signed = 0;
$total_earned = 0;
$max_earned = 0;
$max_earner_ID = -1;
$Sector_SR_query = "SELECT * FROM SponsRep WHERE Sector = '{$SponsSector}'";
$result = mysql_query($Sector_SR_query);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$num_spons_reps++;
$SponsRepID = $row['SponsID'];
$SponsRepEarningReport = get_earning_report($SponsRepID);
$total_companies_signed = $total_companies_signed + $SponsRepEarningReport[1];
$total_earned = $total_earned + $SponsRepEarningReport[2];
if ($max_earned < $SponsRepEarningReport[2]) {
$max_earned = $SponsRepEarningReport[2];
$max_earner_ID = $SponsRepID;
}
}
}
$Sector_SH_query = "SELECT * FROM SectorHead WHERE Sector='{$SponsSector}'";
$result = mysql_query($Sector_SH_query);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$num_sector_heads++;
}
}
$Sector_CMP_query = "SELECT * FROM Company WHERE Sector='{$SponsSector}'";
$result = mysql_query($Sector_CMP_query);
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$num_companies_in_sector++;
}
}
return array("num_spons_reps" => $num_spons_reps, "num_sector_heads" => $num_sector_heads, "num_companies_in_sector" => $num_companies_in_sector, "total_companies_signed" => $total_companies_signed, "total_earned" => $total_earned, "max_earner_ID" => $max_earner_ID, "max_earned" => $max_earned);
}
