if ($seq == "2")  { 

#$output = shell_exec("./district $parcel");
if ($debug) {
	$output = shell_exec("./test $parcel");
} else {
	$output = shell_exec("./district $parcel");
}

$output = str_replace(array( '[', ']' ), '', $output);

$array = array();
foreach(preg_split("/((\r?\n)|(\r\n?))/", $output) as $line) {

    $size = strlen($line);
    if ($size >> 5) {
        // do stuff with $line
        $array[] = str_getcsv($line);
        //print "|$line|\n";
    }
}

$list = array_shift($array[1]);
$zytotal = array_pop($array[2]);
$zytotal = trim(str_replace("'","",$zytotal));
//print_r($array);

//some values brought over:

$MyAddress = $array[0][0];
$MyAddress = trim(str_replace("'","",$MyAddress));

$MyCity = $array[0][1];
$MyCity = trim(str_replace("'","",$MyCity));
$MyCity = str_replace('\' ', '\'', ucwords(str_replace('\'', '\' ', strtolower($MyCity))));


$MyCTC = $array[0][2];
$MyMarket = $array[0][3];
$MyMarket = trim(str_replace('$','',$MyMarket));
$MyMarket = trim(str_replace("'","",$MyMarket));
$MyTaxable = $array[0][4];
$MyTaxable = trim(str_replace('$','',$MyTaxable));
$MyTaxable = trim(str_replace("'","",$MyTaxable));
$MyDistrict = $array[0][5];

$pieces = explode("-", $MyDistrict);
$MyDistrict = $pieces[1];
$MyDistrict = trim(str_replace("'","",$MyDistrict));
#$MyDistrict = preg_replace('/[\x00-\x1F\x7F]/', '', $MyDistrict);




?>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
  google.charts.load('current', {'packages':['corechart']});
  google.charts.setOnLoadCallback(drawChart);

  function drawChart() {

    var data = google.visualization.arrayToDataTable([
<?
print "       ['Tax', 'Amount']";
foreach($array[1] as $i => $item) {
    $a = $array[1][$i];
    $b = $array[2][$i];
    $c = trim(str_replace('$','',$b));
    $d = trim(str_replace("'","",$c));
    $a = trim(str_replace("'","",$a));


    if ($a == "FIRE PROT 13R") { 
		$fireprottot = $d; 
		$a = "FIRE PROT 13R (expiring)";
	}

    $comtotal = $comtotal + $d;
    print ",\n";
    print "       ['$a', $d]";

    //$a = trim(str_replace("'","",$a));
    //if ($a == "FIRE PROT 13R") { $fireprottot = $d; }


}
print "\n     ]);\n";
?>

     var formatter = new google.visualization.NumberFormat({
         prefix: '$'
     });
     formatter.format(data, 1);

     var options = {
       title: 'Hover over the pie slices to see dollar amounts',
       is3D: true,
       titleTextStyle: { color: 'white', fontSize: 14}, 
       chartArea:{left:100,top:100,width:'75%',height:'75%'},
       legend: {position: 'labeled', textStyle: {color: 'white', fontSize: 16}},
       backgroundColor: 'black',	
     };

     var chart = new google.visualization.PieChart(document.getElementById('piechart'));

     chart.draw(data, options);
   }
</script>

    <script type="text/javascript">
      google.charts.load("current", {packages:["corechart"]});
      google.charts.setOnLoadCallback(drawChart);
      function drawChart() {
        var data = google.visualization.arrayToDataTable([
<?
print "       ['Tax', 'Amount']";
foreach($array[3] as $i => $item) {
    $a = $array[3][$i];
    $b = $array[4][$i];
    $c = trim(str_replace('$','',$b));
    $d = trim(str_replace("'","",$c));

    $a = str_replace(' TOTAL', '', $a);

    $countytotal = $countytotal + $d;
    print ",\n";
    print "       [$a, $d]";

    $a = trim(str_replace("'","",$a));

    if (strpos($a, 'NORDONIA HILLS CSD') !== false) { $issue3 = 1; $csdpos = $i; $curcsd = $d; }
    if (strpos($a, 'NRD HL CSD') !== false) { $issue3 = 1; $csdpos = $i; $curcsd = $d; }
    if (strpos($a, 'NORD HLS CSD') !== false) { $issue3 = 1; $csdpos = $i; $curcsd = $d; }
    if (strpos($a, 'NRD HILLS CSD') !== false) { $issue3 = 1; $csdpos = $i; $curcsd = $d; }
    if (strpos($a, 'NRD HLS CSD') !== false) { $issue3 = 1; $csdpos = $i; $curcsd = $d; }



    //$pieslice = 2;
    if ($a == "MACEDONIA CITY") { $pieslice = $i; }
    if ($a == "BOSTON HEIGHTS VILL") { $pieslice = $i; }
    if ($a == "SAGAMORE HILLS TWP") { $pieslice = $i; }
    if ($a == "NORTHFIELD CENTER TWP") { $pieslice = $i; }
    if ($a == "NORTHFIELD VILLAGE") { $pieslice = $i; }
    // $array[$i] is same as $item

}
print "\n     ]);\n";
?>
        var options = {
          title: 'Hover over the pie slices to see dollar amounts',
          is3D: true,
	  titleTextStyle: { color: 'white', fontSize: 14}, 
	  chartArea:{left:100,top:100,width:'75%',height:'75%'},
          legend: {position: 'labeled', textStyle: {color: 'white', fontSize: 16}},
          backgroundColor: 'black',  
          slices: { <?= $pieslice ?>: {offset: 0.5}},
        };

        var formatter = new google.visualization.NumberFormat({
            prefix: '$'
        });
        formatter.format(data, 1);

        var chart = new google.visualization.PieChart(document.getElementById('piechart_3d'));
        chart.draw(data, options);
      }
    </script>


<?
//end the if seq = 2 
}
?>

</head>

<font size=+2>Nordonia Tax Calculator</font>
<br><sub>by Jeff Garvas</sub><BR>

<?php

if ($debug) {
echo "<font color=red><H1>SCRIPT IS IN DEBUG MODE</H1></font>";
}


$db = new SQLite3('taxes.db');

//take commas out of values
$income1 = str_replace(',', '', $income1);
$income2 = str_replace(',', '', $income2);
$house = str_replace(',', '', $house);

//if income1 and city are not both defined, error.
if ($seq > 2) {
        if (($income1 < 1) || ($city == "blank")) {
//        $seq="";
        $error = "<font color=red>Taxpayer 1 fields must be populated to proceed</font><br><br>";
        }

        if (($ownhome != "yes") && ($ownhome != "no")) {
//        $seq="";
        $error = $error . "<font color=red>You must indicate if you own a home or not</font><br><br>";
        }

$house = number_format((float)$house, 2, '.', '');
$income1 = number_format((float)$income1, 2, '.', '');
$income2 = number_format((float)$income2, 2, '.', '');

//log the tweet and who did it
//$logfile = 'hitlog.txt';

//$remip = $_SERVER['REMOTE_ADDR'];
// set the default timezone to use. Available since PHP 5.1
//date_default_timezone_set('America/New_York');
//$date = date('D M d h:i:s');

//$logstr = $remip . "," . $livehere . "," . $ownhome . "," . $house . "," . $city . "," . $income1 . "," . $spcity . "," . $income2 . "," . $address . "," . $rescity . "," . $market . "," . $taxable . "," . $district . "," . $i3annual . "," . $i8annual . "," . $fireprottot . "," . $allprop . "," . $i43annual . "," $i45annual;

//$txt = $date.": " . $logstr;
//$myfile = file_put_contents($logfile, $txt.PHP_EOL , FILE_APPEND | LOCK_EX);

/// add a tracking entry
//$sql = "INSERT INTO stats VALUES(datetime('now','localtime','+3 hours'),'$remip','$livehere','$ownhome','$house','$city','$income1','$spcity','$income2')";
//$db->prepare($sql);
//$db->exec($sql);

//debug

}



if ($seq > 1) {

// Property tax
// This is now OUTSIDE of the "Live Here" if() inside the hidden = 3 final display block
// right here we need to do property tax display ouput:

  // street should be passed into stage2 in $street
  //$sql = "SELECT address FROM parcels WHERE parcel = '" . $parcel . "'";
  //$street = $db->querySingle($sql);

  echo "<br><hr width=10% align=left>";

  echo "<h3><font color=orange>Property Tax Analysis For:</font> $street (Summit county parcel #$parcel)</h3>";

  echo "Your current property tax bill of $$countytotal* is allocated as shown in the first graph:";

?>

    <div id="piechart_3d" style="width: 900px; height: 500px;"></div>

<?  echo "$MyCity's share of $$comtotal (from above) is allocated as shown in this graph:"; 
?>

    <div id="piechart" style="width: 900px; height: 500px;"></div>

<?


echo "<font size=3><font color=orange>Source:</font> This Summit County Fiscal Office --> <a target=_blank href=\"http://fiscalweb.summitoh.net/clt/detailestmmain.get_tax3?tyear=2018&parcel=$parcel\">Tax Distribution</a> page for parcel $parcel. <a target=_blank href=\"http://fiscalweb.summitoh.net/clt/refintg2.opt?parcel=$parcel\">(Full parcel details can also be verified here)</a></font><br>";

echo "<br><hr width=66% align=center><br>";

echo "<h3><font color=orange>Levies:</font> What May 7th <i>property tax</i> levies might change your property tax liability?</h3>";

$ThisMarket = number_format($MyMarket); 
$ThisTaxable = number_format($MyTaxable); 
?>

Resident City: <?= $rescity ?><br>
Address: <?= $MyAddress ?><br>
Market Value: $<?= $ThisMarket ?><br>
Taxable (35%): $<?= $ThisTaxable?><br>
School District: <?= $MyDistrict ?><br>
<br>



<?


if ($issue3) { 

   $i3annual = $MyTaxable / 100 * .698;
   $AllProp = $AllProp + $i3annual;
   $i3monthly = $i3annual / 12;
   $i3annual = number_format((float)$i3annual, 2, '.', '');
   $i3monthly = number_format((float)$i3monthly, 2, '.', '');

   $totalcsd = $i3annual + $curcsd;
   $i3percent = $i3annual / $curcsd;
   $i3percent = $i3percent * 100;
   $i3percent = number_format((float)$i3percent, 2, '.', '');

?>
<hr width=5% align=left>
<h3><font color="green">Issue 3:</font> This NEW levy applies to your property based on your school district - <font color=red>Permanent</font></h3>
<u>Ballot Language:</u> <i>"An additional tax for the benefit of the Nordonia Hills City School District for the purpose of <b>current expenses</b> at a rate not exceeding 6.98 mills for each one dollar of valuation, which amounts to 69.8 cents for each one hundred dollars of valuation, for a continuing period of time, commencing in 2019, first due in calendar year 2020"</i>


<br><br><u>If Issue 3 passes:</u> 
<li>Your property tax will <font color=red>increase</font> by roughly <font color=red>$<?= $i3monthly ?></font> per month, or <font color=red>$<?= $i3annual ?> </font>annually. 
<li>Since Issue 3 is a net new tax, your total annual <?= $MyDistrict ?> tax liability would <font color=red>increase</font> by <font color=red><?= $i3percent ?>%</font> from <font color=red>$<?= $curcsd ?></font> to <font color=red>$<?= $totalcsd ?></font> annually.
<li>Since Issue 3 is a <font color=red>permanent</font> levy it will <font color=red>never expire.</font>
<br>

<br><u>If Issue 3 fails:</u> 
<li>Your property tax will not decrease, as there is no renewal component to Issue 3. 
<br><br>

<?

}


 $AllProp = number_format((float)$AllProp, 2, '.', '');


?>


<br><br>
<hr width=5% align=left>
<h3><font color=orange>The Math:</font> How we calculated the estimated tax increases above</h3>

Each property tax issue implies that it will cost a property owner a certain amount of money for every $100 dollars in valuation of their property in the school district.  For the purposes of this calculation the taxable value of your property is 35% of your market value ($<?= $ThisMarket ?>), or $<?= $ThisTaxable ?>. We are dividing that taxable value by 100 (to determine how many 100's of valuation exist) and multiply the result by the millage rate of each levy as indicated in it's ballot language. These values are speculative, estimated, and a best effort calculation that is subject to human error. <br><br>  

Since Issue 3 applies to the entire school district, (and its the only property tax issue on the ballot) we'll illustrate it as an example using .698 for it's 6.98 mill rate:<br><br>

<? 
$TempTaxable = trim(str_replace(",","",$ThisTaxable));
$hundreds = $TempTaxable / 100; 
?>

$<?= $ThisTaxable ?> / 100 = $<?=$hundreds ?> * .698 = $<?= $i3annual ?>/annually / 12 = $<?= $i3monthly ?>/monthly<br><br>


<?
// since we're at the end, log:
/// add a tracking entry
// address
// rescity
// market
// taxable
// district
// i3annual
// i8annual
// fireprottot
// allprop
// i43annual
// i45annual

//log the tweet and who did it
$logfile = 'hitlog.txt';

$remip = $_SERVER['REMOTE_ADDR'];
// set the default timezone to use. Available since PHP 5.1
date_default_timezone_set('America/New_York');
$date = date('D M d h:i:s');

$ThisTaxable = trim(str_replace(",","",$ThisTaxable));
$ThisMarket = trim(str_replace(",","",$ThisMarket));
$i3annual = trim(str_replace(",","",$i3annual));
$i8annual = trim(str_replace(",","",$i8annual));
$fireprottot = trim(str_replace(",","",$fireprottot));
$allprop = trim(str_replace(",","",$allprop));
$i43annual = trim(str_replace(",","",$i43annual));
$i45annual = trim(str_replace(",","",$i45annual));


$logstr = $remip . "," . $livehere . "," . $ownhome . "," . $house . "," . $city . "," . $income1 . "," . $spcity . "," . $income2 . "," . $MyAddress . "," . $rescity . "," . $ThisMarket . "," . $ThisTaxable . "," . $MyDistrict . "," . $i3annual . "," . $i8annual . "," . $fireprottot . "," . $allprop . "," . $i43annual . "," . $i45annual . "," . $parcel . "," . $captcha; 
$txt = $date.": " . $logstr;
$myfile = file_put_contents($logfile, $txt.PHP_EOL , FILE_APPEND | LOCK_EX);

$sql = "INSERT INTO stats VALUES(datetime('now','localtime','+3 hours'),'$remip','$livehere','$ownhome','$house','$city','$income1','$spcity','$income2','$MyAddress','$rescity','$ThisMarket','$ThisTaxable','$MyDistrict','$i3annual','$i8annual','$fireprottot','$allprop','$i43annual','$i45annual','$parcel')";
//$db->prepare($sql);
//$db->exec($sql);


// this is the end of the seq=2 (post address chosen) 
}