road.php

我的比赛作品 第22届全国青少年科技创新大赛3等奨 备注: 同时使用VC及Delphi开发

<?php
chdir('../');
require "global.php";

$title = ' - BUS';

$route = array();
$query = mysql_query("SELECT s.* FROM bus_route r INNER JOIN bus_station s ON s.station=r.station WHERE r.roid='$roid' AND r.direction='$direction' ORDER BY r.sort,r.rid");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$route[$rt['station']] = $rt;
}

$beforekey = -1;
foreach ($route as $rkey => $rou)
{
	if ($beforekey != -1)
	{
		$route[$beforekey]['next'] = $rkey;
	}
	$beforekey = $rkey;
}

$logls=array();
$busls=array();
$query = mysql_query("SELECT * FROM bus_log WHERE roid='$roid' AND direction='$direction' ORDER BY passtime DESC");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$logls[$rt['station']][] = $rt;
	$busls[$rt['bid']][] = $rt;
}

//print_r($logls);

$busList = array();
$query = mysql_query("SELECT b.*,t.* FROM bus_busrun b LEFT JOIN bus_type t ON t.tid=b.bustype WHERE b.roid='$roid' AND b.direction='$direction' AND b.station='$station' AND b.enable='1'");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$rt['current'] = $route[$rt['station']]['name'];
	$nx = $route[$route[$rt['station']]['next']];
	if (isset($nx))
	{
		$rt['next'] = $nx['name'];
		$rt['nextid'] = $nx['station'];
	}
	$rt['nexttime'] = "Unknow";
	$self = $busls[$rt['bid']][0];
	$log = $logls[$rt['nextid']][0];
	if ($log)
	{
		$bus = $busls[$log['bid']][1];
		if ($bus)
		{
			$lefTM = ($log['passtime']-$bus['passtime']) - ($timestamp - $self['passtime']);
			if ($lefTM > 0)
			{
				$rt['nexttime'] = getLong($lefTM);
			}else{
				$rt['nexttime'] = "<font color='red'>***</font>";
			}
		}
	}
	$busList[] = $rt;
}

include template('web_road');
?>