index.php

<?PHP
//die('SITE OFFLINE UNTIL SPONSORED @ https://github.com/sponsors/insidenothing');

// preprocess data using zip.php (reviews all zip codes over known time)
$page_description = "Today's COVID 19 Data ".date('m/d/y');
include_once('menu.php');
	$date = date('Y-m-d');
	$zip_open=0;
	$zip_closed=0;
	if (isset($_GET['sort'])){
		$sort = 'report_count';
	}else{
		$sort = 'trend_duration';	
	}
	?>
	<h1>COVID 19 Data for <?PHP echo $date;?></h1>
 	<div>Sort By: <a href='?nosort=1'>Duration in Direction of Case Numbers (default)</a> -OR- <a href='?sort=1'>Case Count</a></div>
	<div class="row">
	  <div class="col-sm-4">
		  <h1>Phase One Reopen</h1><p>The following zip codes are flat for over 2 weeks and ready to look at how to begin phase one.</p>
		  <ol>  
		  <?PHP
		    $q = "SELECT * FROM coronavirus_zip where report_date = '$date' and trend_duration > '13' and (trend_direction = 'DOWN' or trend_direction = 'FLAT' ) and change_percentage_time <> '00:00:00' order by $sort desc";
		    $r = $covid_db->query($q);
		    while($d = mysqli_fetch_array($r)){
		       $zip_open++;
			    $count = $d['trend_duration'];
			    if ($count > 30){
				$count = '+30';    
			    }
		       echo "<li><a href='zipcode.php?zip=$d[zip_code]'>$d[state_name] $d[zip_code] $count days $d[trend_direction] at $d[report_count]</a></li>"; 
		    }
		    ?>
		  </ol>
	  </div>
	
	  <div class="col-sm-4">
		  <h1>Not Phase One</h1>
		  <ol> 
		    <?PHP
		    $q = "SELECT * FROM coronavirus_zip where zip_code <> '' and report_date = '$date' and trend_duration > '13' and trend_direction = 'UP' and change_percentage_time <> '00:00:00' order by $sort desc ";
		    $r = $covid_db->query($q);
		    while($d = mysqli_fetch_array($r)){
			    $zip_closed++;
			     $count = $d['trend_duration'];
			    if ($count > 30){
				$count = '+30';    
			    }
		       echo "<li><a href='zipcode.php?zip=$d[zip_code]'>$d[state_name] $d[zip_code] $count days $d[trend_direction] at $d[report_count]</a></li>"; 
		    }
		    $q = "SELECT * FROM coronavirus_zip where zip_code <> '' and report_date = '$date' and trend_duration = '13' and change_percentage_time <> '00:00:00' order by $sort desc";
		    $r = $covid_db->query($q);
		    while($d = mysqli_fetch_array($r)){
			    $zip_closed++;
			     $count = $d['trend_duration'];
			    if ($count > 30){
				$count = '+30';    
			    }
		       echo "<li><a href='zipcode.php?zip=$d[zip_code]'>$d[state_name] $d[zip_code] $count days $d[trend_direction] at $d[report_count]</a></li>"; 
		    }
		    $q = "SELECT * FROM coronavirus_zip where zip_code <> '' and report_date = '$date' and trend_duration < '13' and change_percentage_time <> '00:00:00' order by $sort desc";
		    $r = $covid_db->query($q);
		    while($d = mysqli_fetch_array($r)){
			    $zip_closed++;
			     $count = $d['trend_duration'];
			    if ($count > 30){
				$count = '+30';    
			    }
		       echo "<li><a href='zipcode.php?zip=$d[zip_code]'>$d[state_name] $d[zip_code] $count days $d[trend_direction] at $d[report_count]</a></li>"; 
		    }
		    ?>
		  </ol> 
	  </div>
 	  <div class="col-sm-4">
		  <h1>Phase Check Queue</h1>
		  <ol> 
		    <?PHP
		    $q = "SELECT * FROM coronavirus_zip where zip_code <> '' and report_date = '$date' and change_percentage_time = '00:00:00' order by $sort desc ";
		    $r = $covid_db->query($q);
		    while($d = mysqli_fetch_array($r)){
			     $count = $d['trend_duration'];
			    if ($count > 30){
				$count = '+30';    
			    }
		       echo "<li><a href='zipcode.php?zip=$d[zip_code]'>$d[state_name] $d[zip_code] $count days $d[trend_direction] at $d[report_count]</a></li>"; 
		    }
		    ?>
		  </ol> 
	  </div>		
		
	</div>
<?PHP
include_once('footer.php');
?>
<meta http-equiv="refresh" content="60">