<?
header('Content-type: text/html');
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sat, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header('X-Content-Type-Options: nosniff');
?>
<?
//////////////////////////////////////////////
// town2.php
// Author: Derek Myska
// 
// -- description --
// town info page for all grandfathered towns
//////////////////////////////////////////////
include_once("/mnt/cluster/www6/readysetgov/includes/common.php");
include_once('include/config.php');
include_once('include/lib.php');

clean_params();

// global vars
$town = $_REQUEST['t'];
$info = array();

// clear drop select if not in a necessary town
if (preg_match('/bmv|wic|park|career|court|dhhs/i', $town)) {
        $_REQUEST['drop_select'] = '';
}

//////////////////////////////////////////////
// validate
//////////////////////////////////////////////
$query = @mysql_query(
        "SELECT town_id FROM towns
        WHERE town_name LIKE '$town'"
);

$row = mysql_fetch_assoc($query);
if (!preg_match('/^\d+$/', $row['town_id'])) {
        header("Location: index.html");
}
else {
        $townName = $town;
        $town = $row['town_id'];
}

if ($GRANDFATHERED[$town] != 1) {
        header("Location: town.php?t=$townName");
}

//////////////////////////////////////////////
// get town contact information
//////////////////////////////////////////////  
$query = @mysql_query(
        "SELECT town_name, town_id
        FROM towns
        WHERE towns.town_id='$town'"
);

$row = mysql_fetch_assoc($query);
$info['town_info']['town_name'] = $row['town_name'];
$info['town_info']['town_id'] = $row['town_id'];

//////////////////////////////////////////////
// get town facts
//////////////////////////////////////////////
$query = @mysql_query(
        "SELECT * FROM pages, published_page_values, towns
        WHERE towns.town_id='$town'
        AND pages.page_town_id=towns.town_id
        AND published_page_values.page_value_page_id=pages.page_id
        AND published_page_values.page_value_template_modules_id='4'
        AND published_page_values.page_value_module_option_id IN (
                '9', '10', '11', '12', '13', '14',
                '15', '16', '17', '18'
        )
        ORDER BY published_page_values.page_value_module_option_id"
);

while ($row = mysql_fetch_assoc($query)) {
        $info['town_facts']['option_' . $row['page_value_module_option_id']] = $row['page_value_data'];
}

foreach ($info['town_facts'] as $key => $value) {
        if (preg_match('/.+\"VALUE\"\;s\:\d*\:\".+\"\;\}$/', $info['town_facts'][$key])) {
                $info['town_facts'][$key] = preg_replace('/.+\"VALUE\"\;s\:\d*\:\"(.+)\"\;\}$/', '$1', $value);
        }
        else {
                $info['town_facts'][$key] = "N/A";
        }
}

$countyLink = strtolower($info['town_facts']['option_9']);

$senate = explode(",", $info['town_facts']['option_11']);
$house = explode(",", $info['town_facts']['option_12']);

$senateAll = array();
foreach ($senate as $key => $value) {
        array_push($senateAll, $value);
}
$houseAll = array();
foreach ($house as $key => $value) {
        array_push($houseAll, $value);
}

//////////////////////////////////////////////
// get town contact information
//////////////////////////////////////////////  
$query = @mysql_query(
        "SELECT * FROM pages, published_page_values, towns
        WHERE towns.town_id='$town'
        AND pages.page_town_id=towns.town_id
        AND published_page_values.page_value_page_id=pages.page_id
        AND published_page_values.page_value_template_modules_id='5'
        AND published_page_values.page_value_module_option_id IN (
                '20', '21', '22', '23', '24', '25',
                '26', '27', '28', '29', '30'
        )
        ORDER BY published_page_values.page_value_module_option_id"
);

while ($row = mysql_fetch_assoc($query)) {
        $info['contact_info']['option_' . $row['page_value_module_option_id']] = $row['page_value_data'];
}

foreach ($info['contact_info'] as $key => $value) {
        $info['contact_info'][$key] = preg_replace('/.+\"VALUE\"\;s\:\d*\:\"(.+)\"\;\}$/', '$1', $value);
}

// reformat the phone/fax numbers
$info['contact_info']['option_24'] = preg_replace('/(\d{3})(\d{3})(\d{4})/', '($1) $2-$3', $info['contact_info']['option_24']);
$info['contact_info']['option_25'] = preg_replace('/(\d{3})(\d{3})(\d{4})/', '($1) $2-$3', $info['contact_info']['option_25']);

// set to N/A if its....well...N/A
if (preg_match('/^\s*$/', $info['contact_info']['option_24'])) {
        $info['contact_info']['option_24'] = "N/A";
}

if (preg_match('/^\s*$/', $info['contact_info']['option_25'])) {
        $info['contact_info']['option_25'] = "N/A";
}

// check the official web site link
if ($info['contact_info']['option_26']) {
        $info['contact_info']['option_26'] = "<p><strong>Website:</strong> <a href='".$info['contact_info']['option_26']."'>Official Website</a></p>";
}

// build map it link
$mapit = "http://www.maine.gov/portal/local/new/town2.php?show=queryParam&";
$mapit .= "address=".$info['contact_info']['option_20']."&";
$mapit .= "city=".$info['contact_info']['option_21']."&";
$mapit .= "state=ME&";
$mapit .= "zip=".$info['contact_info']['option_23']."&";
$mapit .= "name=Town of $townName&";
$mapit .= "t=".$townName;

//////////////////////////////////////////////
// get the county online services
//////////////////////////////////////////////
$query = @mysql_query(
        "SELECT * FROM pages, published_page_values, towns
        WHERE towns.town_id='$town'
        AND pages.page_town_id=towns.town_id
        AND published_page_values.page_value_page_id=pages.page_id
        AND page_value_template_modules_id='6'
        AND published_page_values.page_value_module_option_id='29'
        ORDER BY published_page_values.page_value_module_option_id"
);

while ($row = mysql_fetch_assoc($query)) {
        $info['town_services']['option_' . $row['page_value_module_option_id']] = $row['page_value_data'];
}

foreach ($info['town_services'] as $key => $value) {
        preg_match_all('/\"(\d+)\"/', $value, $out);
}

$services = join(",", $out);
$links = array();
foreach ($out[1] as $key => $value) {
        $values .= "'$value',";
}

$values = preg_replace('/,$/', '', $values);

$links = '';
if (!preg_match('/^\s*$/', $values)) {
        $query = @mysql_query(
                "SELECT * FROM online_services
                WHERE online_service_id IN($values)"
        );

        $i = 0;
        $info['town_services'] = array();
        while ($row = mysql_fetch_assoc($query)) {
                $links .= "<p><a href='" . $row['online_service_url'] . "'>" . $row['online_service_name'] . "</a></p>";
                $info['town_services'][$i]['service'] = $row['online_service_name'];
                $info['town_services'][$i]['url'] = $row['online_service_url'];
                $i++;
        }
}

$links .= "<p><a href='http://www.maine.gov/online/trailerrenewal/'>Trailer Renewal</a></p>";

//////////////////////////////////////////////
// get left hand nav items
//////////////////////////////////////////////
$leftNav = '';
$query = @mysql_query(
        "SELECT page_id, page_title
        FROM pages
        WHERE page_town_id='$town'"
) or die(mysql_error());

$leftNav = build_left_nav($town, $townName, $row['page_id']);

?>



<!DOCTYPE HTML>
<!--[if IE 9 ]>    <html lang="en-us" dir="ltr" class="no-js ie9"> <![endif]-->   
<!--[if (gt IE 9)|!(IE)]><!--> <html lang="en-us" dir="ltr" class="no-js"><!-- InstanceBegin template="Templates/inside2017.dwt" codeOutsideHTMLIsLocked="false" --> <!--<![endif]-->
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Local: Maine.gov</title>
<!-- InstanceEndEditable -->
<meta name="description" content="Maine.gov - Official site includes links to services available online, Governor, state agencies, Legislature, US Congressional delegation, state parks, and tax information." />
<meta name="author" content="maine.gov" />
<meta name="robots" content="index,follow" />
<meta name="rating" content="Safe for kids" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<!--[if IE]><![endif]-->
<link rel="stylesheet" type="text/css" href="/portal/css/styles2017.css">

<link rel="stylesheet" type="text/css" href="/portal/js/slidebars.min.css">
<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,600,400italic,600italic" rel="stylesheet" type="text/css">
<noscript>
<style type="text/css"> 
/* This style needs to stay here!! */
	#alt-nav { display:block; }
	#header .sb-toggle-left, .navicon-line { display:none; }
	#getnotified { display:block!important; }
</style>
</noscript>
<link rel="shortcut icon" href="/portal/favicon.ico">
<!-- For non-Retina iPhone, iPod Touch, and Android 2.2+ devices: -->
<link rel="apple-touch-icon" href="/portal/57x57.png">
<!-- For first-generation iPad: -->
<link rel="apple-touch-icon" sizes="72x72" href="/portal/72x72.png">
<!-- For iPhone 4 with high-resolution Retina display: -->
<link rel="apple-touch-icon" sizes="114x114" href="/portal/114x114.png">
<!-- No such device exists yet, so if this value is used,
    it means the sizes attribute is ignored: -->
<link rel="apple-touch-icon" sizes="228x228" href="/portal/228x228.png">
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<!-- InstanceParam name="section" type="text" value="section" -->
<!-- InstanceParam name="crumbtrail" type="boolean" value="true" -->
<!-- InstanceParam name="Browse" type="boolean" value="true" -->
<!-- InstanceParam name="side" type="boolean" value="false" -->
<!-- InstanceParam name="topservices" type="boolean" value="true" -->
<!-- InstanceParam name="class" type="text" value="class" -->
<!-- InstanceParam name="sidebarsearch" type="boolean" value="true" -->
<!-- InstanceParam name="footer-code" type="boolean" value="false" -->

<?require("map.php");?>

</head>


<body onload="initialize();" id="section">
	<!-- Start Skip Navigation: Accessibility Requirement -->
	<ul class="skip-nav"> 
	  <li><a href="#main-nav" accesskey="1" title="Skip to Navigation: Accesskey+1">Skip to Navigation</a></li>
	  <li><a href="#content-area" accesskey="2" title="Skip to Content: Accesskey+2">Skip to Content</a></li>
	  <li><a href="#footer" accesskey="3" title="Skip to Footer: Accesskey+3">Skip To Footer</a></li>
	</ul>
	<!-- End Skip Navigation: Accessibility Requirement -->
	<!--Start Header include-->
        <?=file_get_contents(HTDOCS_PATH."inc/header2017.inc");?>
	<!--End Header include-->
	<div id="containerthingyforslidenav">
	<div id="page-header">
	<!--#include virtual="/portal/whatsnew-inc/CitizenAlert.inc"-->
	<!-- InstanceBeginEditable name="PhotoCredit" --><img src="/portal/img/camera-icon.png" alt="camera icon" class="tooltip" title="&lt;strong&gt;Photographer:&lt;/strong&gt; &lt;a href='https://www.flickr.com/photos/grsmithimages/7404551958/in/set-72157629195993352'&gt;GR Smith&lt;/a&gt; &lt;br&gt; &lt;strong&gt;Location:&lt;/strong&gt; Vaughn Woods" />
	<!-- InstanceEndEditable --></div> <!--End Page Header-->
	<div id="content-area" class="class">
		
			<ol id="crumbs">
				<li><a href="/portal/index.html">Home</a></li>
				<!-- InstanceBeginEditable name="breadcrumbs" -->
					<li>&raquo; Local</li>
				<!-- InstanceEndEditable -->
			</ol>
		
			
			<div id="inside-content" class="clearfix">
			<!-- InstanceBeginEditable name="maincontent" -->
				<h1>Local</h1>
				<div class="twoCol">
					
			       <h2>Town of <?=$info['town_info']['town_name']?></h2>

                        <h2>Online Services</h2>
                        <?=$links?>
                        <h2> Town Facts</h2>
                        <p><strong>County:</strong> <? print "<a href='county.php?c=" . $countyLink . "'>";?> <?=$info['town_facts']['option_9']?><input type="hidden" name="_pulldown" value="1"></a> </p>
                        <p><strong>School Dist/Dept:</strong><br />
                           <?=$info['town_facts']['option_10']?>
                        </p>
                <p><strong>Senate District:</strong> <?=join(", ", $senateAll)?></p>
                <p><strong>House District:</strong> <?=join(", ", $houseAll)?></p>
                <p><strong>Congressional District:</strong> <?=$info['town_facts']['option_13']?></p>
                <p><strong>Population:</strong> <?=$info['town_facts']['option_14']?><input type="hidden" name="_pulldown" value="2"></p>
<!-- module 4 -->
                <h3>Contact Information</h3>
                <p>
                        <strong>Address:</strong><br />
                        <?=$info['contact_info']['option_20']?><br />
                        <?=$info['contact_info']['option_21']?> , <?=$info['contact_info']['option_22']?>  <?=$info['contact_info']['option_23']?><br />
                        <a href="<?=$mapit?>">Map It</a>
                </p>
                <p><strong>Tel:</strong> <?=$info['contact_info']['option_24']?></p>
                <p><strong>Fax:</strong> <?=$info['contact_info']['option_25']?></p>
                <?=$info['contact_info']['option_26']?>
                <!-- module 6 -->
		
					<!-- left column stuffs goes here -->
					
					
				</div>
				<div class="twoCol">
					
			          <div id="map_canvas" style="width: 463px; height: 505px"> </div>
            <form action="town2.php" method="get" name="formmapping" id="formmapping">
            <input name='t' type='hidden' value='<?=$townName?>' />
                    <?=map_type_dd()?> <input name="submit" type="submit" value="Go" />
                    <?
                                if ($_REQUEST['show'] === 'poll') {
                                        echo "<br />" . polling_places_dd($town) . " <input name=\"submit\" type=\"submit\" value=\"Go\" />";
                                }
                                elseif ($_REQUEST['show'] === 'lib') {
                                        echo "<br />" . libaries_dd($town) . " <input name=\"submit\" type=\"submit\" value=\"Go\" />";
                                }
                                elseif ($_REQUEST['show'] === 'twnoff') {
                                        echo "<br />" . town_offices_dd($town) . " <input name=\"submit\" type=\"submit\" value=\"Go\" />";
                                }
                    ?>
            </form>
		
					<!-- right column stuffs goes here -->
					
					
				</div>
			<!-- InstanceEndEditable --></div> 
			<!--End Inside Content-->
	</div> <!--End Content Area-->
<!-- Start Footer include -->
        <?=file_get_contents(HTDOCS_PATH."inc/footer2017.inc");?>

<!--End Footer include-->
</div>

</body>
<!-- InstanceEnd --></html>