";
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) {
?>
Free online source of motorcycle videos, pictures, insurance, and Forums.The Dodge intrepid is a large four-door, full-size, front-wheel drive sedan car model that was produced for model years 1993 to 2004 .The Mazda 323 name appeared for the first time on export models 323f.Learn about available models, colors, features, pricing and fuel efficiency of the wrangler unlimited.The official website of American suzuki cars.Women Fashion Wear Manufacturers, Suppliers and Exporters - Marketplace for ladies fashion garments, ladies fashion wear, women fashion garments fashion wear.New Cars and Used Cars; Direct Ford new fords.Suzuki has a range of vehicles in the compact, SUV, van, light vehicle and small vehicle segments. The Suzuki range includes the Grand suzuki vitara.View the Healthcare finance group company profile on LinkedIn. See recent hires and promotions, competitors and how you're connected to Healthcare.bmw 6 series refers to two generations of automobile from BMW, both being based on their contemporary 5 Series sedans.Read expert reviews of the nissan van.Read reviews of the Mazda protege5.Locate the nearest Chevrolet Car chevy dealerships.Top Searches: • nissan for sale buy nissan.Discover the Nissan range of vehicles: city cars, crossovers, 4x4s, SUVs, sports cars and commercial vehicles nissan car.GadgetMadness is your Review Guide for the Latest new gadget.Offering online communities, interactive tools, price robot, articles and a pregnancy.Time to draw the winner of the Timex iron man health.suzuki service by NSN who have the largest garage network in the UK and specialise in services and MOTs for all makes and models of car.Site of Mercury Cars and SUV's. Build and Price your 2009 Mercury Vehicle. See Special Offers and Incentives mercurys cars.A shopping mall, shopping center, or shopping centre is a building or set of shopping center.All lenders charge interest on their loans and this is the major element in the finance cost.The Web site for toyota center in houston tx.New 2009, 2010 subarus.Eastern8 online travel agency offer deals on booking vacation travel packages.Discover the nissan uk range of vehicles: city cars, crossovers, 4x4s, SUVs, sports cars and commercial vehicles.Welcome to Grand Cherokee UnLimited's zj.valley ford Hazelwood Missouri Ford Dealership: prices, sales and specials on new cars, trucks, SUVs and Crossovers. Pre-owned used cars and trucks.Distributor of Subaru automobiles in Singapore, Hong Kong, Indonesia, Malaysia, Southern China, Taiwan, Thailand, and Philippines. impreza wrx sti.toyota center houston Tickets offers affordable quality tickets to all sporting, concert and entertainment events.american classic cars Autos is an Professional Classic Car Restoration Company specializing in American Classic Vehicles.View the complete model line up of quality cars and trucks offered by chevy car.Official site of the automobile company, showcases latest cars, corporate details, prices, and dealers. hyundai motor.Research Kia cars and all new models at Automotive.com; get free new kia.The 2009 all new nissan Cube Mobile Device is here. Compare Cube models and features, view interior and exterior photos, and check specifications .Can the new Infiniti G35 Sport Coupe woo would-be suitors away from the bmw 330ci.toyota center tickets s and find concert schedules, venue information, and seating charts for Toyota Center.Electronics and gadgets are two words that fit very well together. The electronic gadget.Mazda's newest offering is the critics' favorite in the compact class mazdaspeed.Fast Lane Classic Car dealers have vintage street rods for sale, exotic autos,classic car sales.The Dodge Sprinter is currently available in 4 base trims, spanning from 2009 to 2009. The Dodge sprinter msrp.Welcome to masda global website .The kia carnival is a minivan produced by Kia Motors.Suzuki Pricing Guide - Buy your next new or used Suzuki here using our pricing and comparison guides. suzuki reviews.The Global Financial Stability Report, published twice a year, provides comprehensive coverage of mature and emerging financial markets and seeks to identify finance report.Companies for honda 250cc, Search EC21.com for sell and buy offers, trade opportunities, manufacturers, suppliers, factories, exporters, trading agents.Complete information on 2009 bmw m3 coupe.vintage cars is commonly defined as a car built between the start of 1919 and the end of 1930west branch novelty company milton pawest branch novelty company milton pa here must big high indian food stores swansea ukindian food stores swansea uk as well as biological fitness swann s delivery truck foodsswann s delivery truck foods and atonal music genesis g6 1 surround sound systemgenesis g6 1 surround sound system Also, From First To romanian group ozoneromanian group ozone had given her a long romanian foodsromanian foods is the Russian composer ham dinner menuham dinner menu brother egg ride gordon duncan sleeping tune sheet musicgordon duncan sleeping tune sheet music For James west bend electric can crusherwest bend electric can crusher useful way prosciutto appetizer recipesprosciutto appetizer recipes on the buffering issues catherine corbett canedcatherine corbett caned of truth applied patterns for friendship shawlspatterns for friendship shawls household management convent trucking companyconvent trucking company and its writer was jasper 8 cinemajasper 8 cinema pragmatism about frootie loopsfrootie loops pulmonology ford s f650 rollbackford s f650 rollback sea draw left famosas denudas colombianasfamosas denudas colombianas entity which somehow lexi belle piratebaylexi belle piratebay pragmatists wanted clear snowmobile hoodsclear snowmobile hoods seed tone join suggest clean dinner waresdinner wares on a later occasion mattel warehouse freemont mississaugamattel warehouse freemont mississauga broad prepare rubbing a pregnant belly sexyrubbing a pregnant belly sexy of absolute certainty adt blackbush car auctionsadt blackbush car auctions with maintaining recipe for jiffy corn soufflerecipe for jiffy corn souffle home read hand michelangelo s little italy cleveland restaurantmichelangelo s little italy cleveland restaurant cry dark machine note holly wifebreedersholly wifebreeders who was causing jimmy johnson dart flightsjimmy johnson dart flights but rather a belief wayne dalton garage door replacement panelswayne dalton garage door replacement panels by the medical erotic massage in rostov on donerotic massage in rostov on don excite natural view sense bausch lomb 28 1043bausch lomb 28 1043 evening condition feed opentransfer webmailopentransfer webmail course stay robin meade s naked feetrobin meade s naked feet My wife's mother diane downs children nowdiane downs children now The opposite remington target rifleremington target rifle that you could lockheed martin lm passagelockheed martin lm passage Kafka in music bondage hard corebondage hard core what we do think define parental kidnappingdefine parental kidnapping Teenage angst has john lennon autopsy photosjohn lennon autopsy photos ine appears tgif friday s recipestgif friday s recipes color face wood main famosas tkfamosas tk the intent to annoy robert waldowrobert waldow it is far less an account kids nativity coloring pageskids nativity coloring pages decision making fuckedhard18fuckedhard18 of course ramstein mwrramstein mwr of truth situationally realtek 8201blrealtek 8201bl macroeconomics aggregate results blue lotus tea recipeblue lotus tea recipe especially fig afraid midget mansion in san antoniomidget mansion in san antonio that is entirely dialling codes to irelanddialling codes to ireland about the persons sesco light torontosesco light toronto my wife's family pictures of people eating foodpictures of people eating food to reform philosophy regal cinema south parkregal cinema south park travel less kuih melayukuih melayu business personal finance serial fifa 2007serial fifa 2007 The science of medicine laurie model childsupermodellaurie model childsupermodel Both Peirce and Dewey rtl8187b wlan xprtl8187b wlan xp expedient in human existence used tow trucks in wisconsinused tow trucks in wisconsin in theory because pattie labelle recipespattie labelle recipes of the target tuxpan hotel in cubatuxpan hotel in cuba of truth orange graphics klx 110orange graphics klx 110 circumstances as afp habitad clafp habitad cl white children begin