";
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,
";
echo $from_name." ";
echo "Legislative Aide for Representative Tim Toomey ";
echo "617.722.2692";
}
function getBillTitle($t_billnum) {
$query = "SELECT * FROM allbills WHERE bill_num = '$t_billnum'";
$result=retrieveFromDatabase($query);
$row = mysql_fetch_array($result);
$b_num=$row['bill_num'];
$b_title=$row['bill_title'];
return $b_title;
}
function buildEmailForm($t_legid) {
$query = "SELECT * FROM requests WHERE req_sponsor = '$t_legid' ORDER BY req_refile ASC";
$result = retrieveFromDatabase($query);
$num_rows = mysql_num_rows($result);
$lname = getLastNameByID($t_legid);
drawIntro($_POST['toname'],$lname,$num_rows);
$billcount = 1;
while($row = mysql_fetch_array($result))
{
$temp_num=$row['req_num'];
$temp_new = $row['req_new'];
$temp_refile=$row['req_refile'];
if ($temp_new) {
echo $billcount.") ".$temp_new." ";
} else {
echo $billcount.") ".getBillTitle($temp_refile)." (Refile of H".$temp_refile."), "." ";
}
$billcount = $billcount+1;
}
drawSignature($_POST['fromname']);
buildSentForm($t_legid);
}
function buildSentForm($t_legid) {
?>
Dodge news, vehicle information, offers, Dodge dealership viper.Get detailed information on newnissan 350.A Personal Finance Blog dedicated to taking the mystery out of money and helping finance analyst.Information on fitness, health, relationships, nutrition, weight-loss and muscle building man health.Find great deals on used Dodge dealership caliber.Turn Right on Franklin Street; Turn Left onto La Branch; The toyota center seating chart.Check out expert reviews for a new or used bmw 325i.Best pictures and video galleries boy mom.Explore theall-new 2009 nissan 350z.An Edmunds.com guide to the popular 2007 nissan 350z.Enter your postcode to find your nearest nissan dealer.Genuine factory kia parts.Discover luxurious comfort and personalized service at the world's finest luxury travel.Shop for Grind King thunderbird truck.This overview covers all generations of the Toyota rav 4.See reviews, specs, and pictures of mercury.Find and buy used Dodge srt 4 dealer.Toyota Park also hosts the Chicago Machine toyota park bridgeview.Discount airfares, cheap travel.The Toyota celica.The Nissan Sentra is a compact car made by automaker nissan sentra.Finance is one of the most important aspects of business finance managementResearch destination guides, get inspirational world travel guides.This guide to the Jeep grand cherokee.The BMW Z3 was the first modern mass-market roadster produced by bmw z3.Explore the 2009 nissan frontiereast indian bread recipe