Työkalu html-taulukon luomiseen talvilintulaskentareittiluettelosta

talvilintureitit.php

<?php
header('Content-Type: text/html; charset=utf-8');
?>
<style>
.number 
{
	text-align: right;
}
</style>
<pre>
<?php

$data = file("reitit.txt");

$html = "";
$html .= "<table class='basictable'>\n";
$html .= "<tr>\n";
$html .= "	<th>Nro</th>\n";
$html .= "	<th>Kunta</th>\n";
$html .= "	<th>Nimi & kartta</th>\n";
$html .= "	<th>Koord</th>\n";
$html .= "	<th>Eka</th>\n";
$html .= "	<th>Vika</th>\n";
$html .= "	<th>Pit/km</th>\n";
$html .= "	<th>Ed. vastuuhlö</th>\n";
$html .= "	<th>Syksy</th>\n";
$html .= "	<th>Talvi</th>\n";
$html .= "	<th>Kevät</th>\n";
$html .= "	<th>Yht</th>\n";
$html .= "</tr>\n";

$baseAddress = "http://koivu.luomus.fi/talvilintutuloksia/?reitti=";
$mapBaseAddress = "/tools/talvilintureitit/";

foreach ($data as $nro => $row)
{
	$html .= "<tr>\n";

	$row = trim($row);
	$cell = explode("\t", $row);

	$routeNumber = $cell[3];
	$html .= "<td class=\"number\">" . $routeNumber . "</td>"; 

	$html .= "<td>" . mb_convert_case($cell[5], MB_CASE_TITLE, "UTF-8") . "</td>"; 

	$longNumber = substr(("000" . $cell[3]), -4);
	$html .= "<td><strong><a href='" . $mapBaseAddress . $longNumber . ".pdf'>" . mb_convert_case($cell[6], MB_CASE_TITLE, "UTF-8") . "</a></strong></td>";

	$html .= "<td>" . substr($cell[4], 0, 3) . ":3" . substr($cell[4], 3) . "</td>"; 

	$html .= "<td>" . $cell[1] . "</td>";
	$html .= "<td>" . $cell[0] . "</td>";
	$html .= "<td class=\"number\">" . $cell[2] . "</td>";

	$html .= "<td>" . mb_convert_case($cell[7], MB_CASE_TITLE, "UTF-8") . "</td>";

	if ($cell[8])
	{
		$html .= "<td class=\"number\"><a href='$baseAddress" . $routeNumber . "&kausi=1'>" . $cell[8] . "</a></td>";
	}
	else
	{
		$html .= "<td>&nbsp;</td>";
	}
	if ($cell[9])
	{
		$html .= "<td class=\"number\"><a href='$baseAddress" . $routeNumber . "&kausi=2'>" . $cell[9] . "</a></td>";
	}
	else
	{
		$html .= "<td>&nbsp;</td>";
	}
	if ($cell[10])
	{
		$html .= "<td class=\"number\"><a href='$baseAddress" . $routeNumber . "&kausi=3'>" . $cell[10] . "</a></td>";
	}
	else
	{
		$html .= "<td>&nbsp;</td>";
	}

	$html .= "<td class=\"number\">" . $cell[11] . "</td>";

	$html .= "</tr>\n";
}

$html .= "</table>";

echo $html;

echo "\n\nFINISHED";