// This is the script to download current season for import into the VTD template
include ($_SERVER['DOCUMENT_ROOT']."/inc/config.php");
if ($ses_AuthLevel >= $AuthLevel_BoardTop) {
//header("Content-type: application/text");
//header("Content-Disposition: attachment; filename=AsaSeasonRoster.txt");
// Connect to database
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_connect.php");
$SeasonSearch = $TeamYear."A%";
echo $TeamYear." ".$SeasonSearch."
";
// Create SQL statement
$sql = "SELECT Positions.*, PositionTypes.*, Groups.*, People.*, PeopleExt.*
FROM Positions, PositionTypes, Groups, People
LEFT JOIN PeopleExt
ON People.PeopleID = PeopleExt.PID
WHERE Positions.GroupID LIKE '$SeasonSearch' AND Positions.PositionID = PositionTypes.PositionID AND Groups.GroupID = Positions.GroupID AND Positions.PeopleID = People.PeopleID
ORDER BY LastName, FirstName, Positions.GroupID DESC, PositionTypes.PositionOrder";
// Execute Query
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_execute.php");
$Eol = "\n";
$TableStart = "
";
$RowStart = "";
$RowEnd = " |
";
$Delim = "";
$numrows = mysql_numrows($sql_result);
$PeopleIDCurrent = "";
$LineCount = 0;
//echo "Level = $ses_AuthLevel $Eol";
echo "$numrows total position responses $Eol";
echo $TableStart;
echo $RowStart."PositionID".$Delim."DL State".$Delim."DL Number".$Delim."DL Expire".$Delim."First Name".$Delim."Middle Name".$Delim."Last Name".$Delim."Address".$Delim."City".$Delim."State".$Delim."Zip".$Delim."Type (P or C)".$Delim."Team".$Delim."Fast or Slow".$Delim."Age".$Delim."Class".$Delim."Phone".$Delim."DOB".$Delim."Email".$Delim."Photo".$Delim."PeopleID".$Delim."AsaID".$RowEnd;
unset($PeopleIDTmp);
// Format results by row
while ($row = mysql_fetch_array($sql_result))
{
unset($MemberType);
$PositionID = $row["PositionID"];
if ($PositionID == "43") {
$MemberType = "P";
} else {
$MemberType = "C";
}
$PositionID = $row["PositionID"];
$PeopleID = $row["PeopleID"];
$AsaMemberID = $row["AsaMemberID"];
$LastName = $row["LastName"];
$FirstName = $row["FirstName"];
$NickName = $row["NickName"];
if ($NickName) {$FirstName .=" (".$NickName.")";}
$PeopleMI = $row["MiddleName"];
if (!$PeopleMI && $MemberType == "C") {
$PeopleMI = "MISSING";
} ELSEIF ($PeopleMI == "~") {
$PeopleMI = "None";
}
$PeopleDLID = $row["PeopleDLID"];
if (!$PeopleDLID && $MemberType == "C") { $PeopleDLID = "MISSING"; }
$PeopleDLST = $row["PeopleDLST"];
if (!$PeopleDLST && $MemberType == "C") { $PeopleDLST = "MISSING"; }
$PeopleDLExp = $row["PeopleDLExp"];
if (!$PeopleDLExp && $MemberType == "C") { $PeopleDLExp = "MISSING"; }
unset($Addr);
$Street = $row["Street"];
$Street2 = $row["Street2"];
if ($Street) {$Addr = $Street;}
if ($Street2) {$Addr .= " - ".$Street2;}
if (!$Addr) { $Addr = "MISSING"; }
unset($PostCodePlus4);
unset($PostCode5);
$City = $row["City"];
$State = $row["State"];
$PostalCode = $row["PostalCode"];
$PostalCode5 = substr("$PostalCode", 0, 5);
$PostalCodePlus4 = substr("$PostalCode", 5, 4);
$PostalCode = $PostalCode5; // ASA only wants first 5
$GroupChar = $row["GroupChar"];
$GroupID = $row["GroupID"];
if ($GroupName == ">Team Name Here<") {
$GroupName = "MISSING";
} ELSE {
$GroupName = $GroupChar." - ".$GroupName;
}
unset($TeamType);
$TeamType = substr("$GroupID", 5, 2);
if ($TeamType == "08" || $TeamType == "10" || $TeamType == "12" || $TeamType == "14") {
$TeamType = "A";
} else {
$TeamType = "B";
}
$GroupDiv = $row["GroupDiv"];
unset($Phone1AC);
unset($Phone1Prefix);
unset($Phone1Suffix);
unset($Phone1Ext);
unset($Phone1Dsp);
$Phone1 = $row["Phone1"];
$Phone1AC = substr("$Phone1", 0, 3);
$Phone1Prefix = substr("$Phone1", 3, 3);
$Phone1Suffix = substr("$Phone1", 6, 4);
$Phone1Ext = substr("$Phone1", 10, 10);
if ($Phone1) {
$Phone1Dsp .= $Phone1AC." ".$Phone1Prefix." ".$Phone1Suffix;
}
unset($BirthDsp);
unset($BirthYear);
unset($BirthMonth);
unset($BirthDay);
$BirthDate = $row["BirthDate"];
$BirthDate = explode("-", "$BirthDate");
$BirthYear = $BirthDate[0];
$BirthMonth = $BirthDate[1];
$BirthDay = $BirthDate[2];
if ($BirthYear > "0000") {
$BirthDsp = $BirthMonth."/".$BirthDay."/".$BirthYear;
} else {
$BirthDsp = "MISSING";
}
/* if ($MemberType != "P") {
unset($BirthDsp);
}
*/
unset($Photo);
if ($TeamType == "A"|| $TeamType == "B") {
$Photo = $DocRoot."/PidPhotos/".$PeopleID.".jpg";
if (file_exists($Photo)) {
$Photo = "Photo";
} else {
$Photo = "MISSING";
}
}
unset($EMailName);
if ($MemberType != "P") {
$EMailName = $row["EMailName"];
// if (!$EMailName) {
// $EMailName = "NoEmailAvail@cgfp.org"; // ASA/VTD expects an e-mail address for coaches
// }
}
if($GroupName != " - League Administration" && $PositionID != "56") {
if($PeopleID != $PeopleIDTmp) {
// if ($PeopleDLST == "MISSING" || $PeopleDLID == "MISSING" || $PeopleDLExp == "MISSING" || $BirthDsp == "MISSING") {
echo $RowStart."$PositionID".$Delim."$PeopleDLST".$Delim."$PeopleDLID".$Delim."$PeopleDLExp".$Delim."$FirstName".$Delim."$PeopleMI".$Delim."$LastName".$Delim."$Addr".$Delim."$City".$Delim."$State".$Delim."$PostalCode".$Delim."$MemberType".$Delim."$GroupID".$Delim."F".$Delim."$GroupDiv".$Delim."C".$Delim."$Phone1Dsp".$Delim."$BirthDsp".$Delim."$EMailName".$Delim."$Photo".$Delim."$PeopleID".$Delim."$AsaMemberID".$RowEnd;
// }
$PeopleIDTmp = $PeopleID;
}
}
}
echo $TableEnd;
include ($_SERVER['DOCUMENT_ROOT']."/inc/sql_close.php");
exit;
} ELSE {
echo "Only Board of Directors and above may view this file.";
}
?> |