area.php

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

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

$title = ' - BUS';

$route = array();
$dExists = array();
$station = array();
$stationArr = array();
$stationStr = "";
$query = mysql_query("SELECT * FROM bus_route WHERE station='$station_area1' OR station='$station_area2'");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$dExists[$rt['direction'].'-'.$rt['roid']]++;
	if ($stationStr) $stationStr.=",";
	$stationArr[$rt['station']]=$rt['station'];
	$route[] = $rt;
}

$stationStr = implode(',',$stationArr);
unset($stationArr);

if (!$stationStr){
	echo "不存在这样的巴士路线";
	exit;
}

$query = mysql_query("SELECT * FROM bus_station");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$station[$rt['station']]=$rt['name'];
}

$loadRoad = array();
$roadInfo = array();
foreach ($route as $key => $rou)
{
	if ($dExists[$rou['direction'].'-'.$rou['roid']] < 2)
	{
		unset($route[$key]);
	}else{
		$loadRoad[$rou['roid']]=1;
		$roadInfo[$rou['roid']] = array('direction'=>$rou['direction']);
	}
}

$loadStr = "";
foreach ($loadRoad as $road => $tmp)
{
	if ($loadStr) $loadStr.=",";
	$loadStr.=$road;
}

if (!$loadStr){
	echo "不存在这样的巴士路线";
	exit;
}

$roadArray = array();
$query = mysql_query("SELECT * FROM bus_road WHERE roid IN ($loadStr)");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	$roadArray[$rt['roid']] = $rt['road'];
}

$passRoute = array();
$roadFind = array();
$query = mysql_query("SELECT * FROM bus_route WHERE roid IN ($loadStr) ORDER BY direction,sort,rid");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC))
{
	if ($rt['direction'] != $roadInfo[$rt['roid']]['direction']) continue;
	if (!$roadFind[$rt['roid']])
	{
		if ($rt['station'] == $station_area1 || $rt['station'] == $station_area2)
		{
			$passRoute[$rt['roid']][] = $rt;
			$roadFind[$rt['roid']] = true;
		}
	}else{
		$passRoute[$rt['roid']][] = $rt;
		if ($roadFind[$rt['roid']])
		{
			if ($rt['station'] == $station_area1 || $rt['station'] == $station_area2)
			{
				$roadFind[$rt['roid']] = false;
			}
		}
	}
}

/** Query Bus Log **/
$roLogInfo = array();
$query = mysql_query("SELECT * FROM bus_log WHERE roid IN ($loadStr) AND station IN ($stationStr) ORDER BY bid,direction,roid,passtime");
while ($rt = mysql_fetch_array($query,MYSQL_ASSOC)){
	if ($roadInfo[$rt['roid']]['direction'] != $rt['direction']) continue;
	$roLogInfo[$rt['roid']][$rt['station']] = $rt;
}

$timeArray = array();
foreach ($passRoute as $roid => $route)
{
	if ($roLogInfo[$roid])
	{
		$before = NULL;
		foreach ($route as $road)
		{
			if ($before != NULL)
			{
				$timeArray[$roid] = getLong($roLogInfo[$roid][$road['station']]['passtime'] - $roLogInfo[$roid][$before['station']]['passtime']);
			}
			$before = $road;
		}
	}
}
/** Query Bus Log **/

include template('web_area');
?>