road.php

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

<?php
chdir('../');
require_once('global.php');


$title = 'ROAD';

if (!$step)
{
$busRoute = array();
$query = mysql_query("SELECT b.*,s.* FROM bus_route b LEFT JOIN bus_station s USING(station) WHERE direction='$direction' AND roid='$roid' ORDER BY b.direction,b.sort,b.rid");
while ($rt = mysql_fetch_array($query))
{
	$busRoute[] = $rt;
}
}else
{
	$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' ORDER BY r.sort,r.rid");
	while ($rt = mysql_fetch_array($query))
	{
		$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'];
		}
		echo "DATA->".$rt['nextid'];
		$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;
	}
}

wap_header('Index',"巴士查询系统");
require template("wap_road");
wap_footer();
?>