";
drawFooter();
break;
case "":
drawHeader("");
drawLinks();
drawCosponsorLegislators("Representative");
drawCosponsorLegislators("Senator");
drawFooter();
}
mysql_close();
function handleFormAction($t_forminput,$t_type) {
switch ($t_forminput) {
case "Add Name":
enterLegislatorInfo($t_type);
break;
case "Add Request":
enterRequestInfo($_GET['legid']);
break;
case "Add Aide":
enterAideInfo();
break;
case "Invitations Received":
checkReceived($_POST['legid']);
break;
case "Delete Entry":
deleteEntry($_POST['del_table'],$_POST['del_index'],$_POST['del_num']);
break;
case "Click to Add":
enterRequestInfo($_POST['refile_sponsor']);
break;
case "Mark as Sent":
markAsSent($_GET['legid']);
break;
}
}
function drawAllRequests($t_type) {
$query = "SELECT * FROM legislators WHERE leg_type = '$t_type' ORDER BY leg_lname ASC";
$result=retrieveFromDatabase($query);
$num_rows = mysql_num_rows($result);
echo "
";
}
function checkIfPresent($t_bill_num,$t_table,$t_match) {
$query = "SELECT * FROM $t_table WHERE $t_match = '$t_bill_num' LIMIT 1";
$result=retrieveFromDatabase($query);
$row = mysql_fetch_array($result);
$num_rows = mysql_num_rows($result);
return $num_rows;
}
function makeSpecificUpdates() {
updateBillSponsorID("Bradley H. Jones, Jr.", 125);
updateBillSponsorID("Harold P. Naughton, Jr.", 152);
updateBillSponsorID("Carl M. Sciortino, Jr.", 184);
updateBillSponsorID("George N. Peterson, Jr.", 161);
updateBillSponsorID("Jennifer L. Flanagan", 20);
updateBillSponsorID("James B. Eldridge", 18);
updateBillSponsorID("William G. Greene, Jr.", 114);
updateBillSponsorID("Timothy J. Toomey, Jr.", 202);
updateBillSponsorID("F. Jay Barrows", 59);
updateBillSponsorID("Thomas A. Golden, Jr.", 112);
updateBillSponsorID("Angelo J. Puppolo, Jr.", 167);
updateBillSponsorID("Donald F. Humason, Jr.",124);
}
function updateBillSponsorID($name, $id) {
$query = "UPDATE allbills SET bill_sponsorid = '$id' WHERE bill_sponsor = '$name'";
echo $query;
mysql_query($query);
}
function runNameIDConversion($t_type) {
$query = "SELECT * FROM legislators WHERE leg_type = '$t_type' ORDER BY leg_lname ASC";
$arrLEGS = array();
$result=retrieveFromDatabase($query);
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
while($row = mysql_fetch_array($result)) {
$temp_lname=$row['leg_lname'];
$temp_fname=$row['leg_fname'];
$temp_legid = $row['leg_num'];
$arrLEGS[$temp_legid] = $temp_fname." ".$temp_lname;
}
}
#print_r($arrLEGS);
$query = "SELECT * FROM allbills ORDER BY bill_num ASC";
$arrBILLS[0] = "Bills";
$result=retrieveFromDatabase($query);
$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
while($row = mysql_fetch_array($result)) {
$temp_name=$row['bill_sponsor'];
$temp_id = $row['bill_num'];
$arrBILLS[$temp_id] = $temp_name;
}
}
#print_r($arrBILLS);
$loopmax = 200;
$loopnum = 0;
$arrLEGIDS = array();
foreach ($arrLEGS as $key => $value) {
if ($loopnum < $loopmax) {
#echo "Key: $key; Value: $value \n";
$loopnum = $loopnum+1;
#echo $value." \n";
foreach ($arrBILLS as $bkey => $bvalue) {
similar_text($value,$bvalue,$p);
if ($p > 80) {
#echo $bvalue.": ".$p." \n";
$arrLEGIDS[$bkey] = $key;
}
}
#echo " \n";
} else {
break;
}
}
foreach ($arrLEGIDS as $billnum => $legnum) {
$query = "UPDATE allbills SET bill_sponsorid = '$legnum' WHERE bill_num = '$billnum' LIMIT 1";
mysql_query($query);
}
}
function drawAddAideForm($t_legid) {
?>
".$name."";
?>
";
echo $text."";
}
function getNameByID($t_legid) {
$query = "SELECT * FROM legislators WHERE leg_num = '$t_legid' LIMIT 1";
$result=mysql_query($query);
$row = mysql_fetch_array($result);
return $row['leg_lname'].", ".$row['leg_fname'];
}
function getLastNameByID($t_legid) {
$query = "SELECT * FROM legislators WHERE leg_num = '$t_legid' LIMIT 1";
$result=mysql_query($query);
$row = mysql_fetch_array($result);
return $row['leg_type']." ".$row['leg_lname'];
}
function enterLegislatorInfo($t_type) {
$fname = verifyInput($_POST['fname']);
$lname = verifyInput($_POST['lname']);
$err = "";
if ($fname == "")
$err = $err."Error: First name not entered";
if ($lname == "")
$err = $err."Error: Last name not entered";
if ($err) {
redAlert($err);
} else {
addLegToDatabase($t_type,$fname,$lname);
redAlert("Added Name: ".$fname." ".$lname);
}
}
function addLegToDatabase($t_type,$f_name,$l_name) {
$query = "INSERT INTO legislators VALUES ('','$t_type','$f_name','$l_name','','0')";
mysql_query($query);
}
function drawCosponsorLegislators($t_type) {
echo "
";
$query = "SELECT * FROM legislators WHERE leg_type = '$t_type' ORDER BY leg_lname ASC";
$result=retrieveFromDatabase($query);
$num_rows = mysql_num_rows($result);
echo "Select a ".$t_type." to add a request from:";
echo "
";
}
function drawFooter() {
## end mainbody_wrapper
echo "
";
echo "";
}
function retrieveFromDatabase($query) {
$result=mysql_query($query);
#$result = stripslashes($result);
return $result;
}
function leadingZeros($value, $places){
// Function written by Marcus L. Griswold (vujsa)
// Can be found at http://www.handyphp.com
// Do not remove this header!
if(is_numeric($value)){
for($x = 1; $x <= $places; $x++){
$ceiling = pow(10, $x);
if($value < $ceiling){
$zeros = $places - $x;
for($y = 1; $y <= $zeros; $y++){
$leading .= "0";
}
$x = $places + 1;
}
}
$output = $leading . $value;
}
else{
$output = $value;
}
return $output;
}
function drawIntro($to_name,$l_name,$numrows) {
$plural = "";
if ($numrows == 1) {
$plural = "bill";
} else {
$plural = "bills";
}
echo "Rep. Toomey would like to cosponsor ".$numrows." ".$plural." filed by ".$l_name;
echo "
";
echo "Hi ".$to_name.",
";
echo "Representative Toomey would like to cosponsor the following ".$plural." from your office:
";
}
function drawSignature($from_name) {
echo " ";
echo "Please let our office know if you need any other information or have any questions. ";
echo "Thank you,