search.php

通达OA2007SE源代码 非常好的

      {
        echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
 <tr class="TableHeader">
    <td nowrap align="center">车次 </td>
    <td nowrap align="center">发车时间 </td>
    <td nowrap align="center">到站时间 </td>
    <td nowrap align="center">公里数 </td>
    <td nowrap align="center">硬座票价 </td>
    <td nowrap align="center">操作 </td>
  </tr>
';
      }
      $TRAINID = $ROW[0];
      $PASSA_DAY = $ROW[1];
      $PASSB_DAY = $ROW[2];
      $PASSA_ZHANCI = $ROW[3];
      $PASSB_ZHANCI = $ROW[4];
      $DEPART_TIME = $ROW[5];
      $ARRIVE_TIME = $ROW[6];
      $PASSA_DISTANCE = $ROW[7];
      $PASSB_DISTANCE = $ROW[8];
      $STATIONA_STATION = $ROW[9];
      $STATIONB_STATION = $ROW[10];
      $ARRIVE_TIME = substr ($ARRIVE_TIME, 0, 5);
      $DEPART_TIME = substr ($DEPART_TIME, 0, 5);
      $DAY = ($PASSB_DAY - $PASSA_DAY);
      $TOTAL_HOUR = (((24 * $DAY) + substr ($ARRIVE_TIME, 0, 2)) - substr ($DEPART_TIME, 0, 2));
      $TOTAL_MINUTE = (substr ($ARRIVE_TIME, 3, 2) - substr ($DEPART_TIME, 3, 2));
      if (($TOTAL_MINUTE < 0))
      {
        $TOTAL_HOUR = ($TOTAL_HOUR - 1);
        $TOTAL_MINUTE = (60 + $TOTAL_MINUTE);
      }
      if (($ARRIVE_TIME == '00:00'))
      {
        $ARRIVE_TIME = '<--始发站-->';
      }
      if (($DEPART_TIME == '00:00'))
      {
        $DEPART_TIME = '<--终点站-->';
      }
      $NUMBER_OF_STATION = ($PASSB_ZHANCI - $PASSA_ZHANCI);
      $DISTANCE = ($PASSB_DISTANCE - $PASSA_DISTANCE);
      $query = 'select train.train,train.kind,stationa.station,stationb.station,kind.kind from train,station stationa,station stationb,kind ';
      ($query .= (((''.'where train.id=').$TRAINID).' and train.kind=kind.id	and stationa.id=train.fstation and stationb.id=train.estation'));
      $cursor1 = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $CHECI = $ROW[0];
        $TRAIN_KIND_NUM = $ROW[1];
        $FIRST_STATION = $ROW[2];
        $END_STATION = $ROW[3];
        $TRAIN_KIND_NAME = $ROW[4];
      }
      $TRAIN_NAME1 = (($STATIONA_STATION.'到').$STATIONB_STATION);
      $TRAIN_NAME2 = (((((((($CHECI.'次').'（').$FIRST_STATION).'--').$END_STATION).'）').$TRAIN_KIND_NAME).'列车');
      switch ($TRAIN_KIND_NUM)
      {
        case '1':
        {
          $SEAT = 'kttkz';
          $BED = 'kttkw';
          break;
        }
        case '2':
        {
          $SEAT = 'ktpkz';
          $BED = 'ktpkw';
          break;
        }
        case '3':
        {
          $SEAT = '';
          $BED = '';
          break;
        }
        case '4':
        {
          $SEAT = 'kttkz';
          $BED = 'kttkw';
          break;
        }
        case '5':
        {
          $SEAT = 'tkz';
          $BED = 'tkw';
          break;
        }
        case '6':
        {
          $SEAT = 'pkz';
          $BED = 'pkw';
          break;
        }
        case '7':
        {
          $SEAT = '';
          $BED = '';
          break;
        }
        case '8':
        {
          $SEAT = 'tkz';
          $BED = 'tkw';
          break;
        }
      }
      $DISTANCE2 = ($DISTANCE + 100);
      $query4 = ((((((('select '.$SEAT).',').$BED).' from price where distance>=').$DISTANCE).' and distance<').$DISTANCE2);
      if ((($TRAIN_KIND_NUM != 3) AND ($TRAIN_KIND_NUM != 7)))
      {
        $cursor4 = exequery ($connection, $query4);
        if ($ROW = mysql_fetch_array ($cursor4))
        {
          $PRICE_SEAT = $ROW[0];
          $PRICE_BED = $ROW[1];
        }
        $ARRAY_PRICE_SEAT = explode (',', $PRICE_SEAT);
        $ARRAY_PRICE_BED = explode (',', $PRICE_BED);
        $PRICE_HARDSEAT = $ARRAY_PRICE_SEAT[0];
        $PRICE_SOFTSEAT = $ARRAY_PRICE_SEAT[1];
        $PRICE_HARDBED_TOP = $ARRAY_PRICE_BED[0];
        $PRICE_HARDBED_MIDDLE = $ARRAY_PRICE_BED[1];
        $PRICE_HARDBED_BELOW = $ARRAY_PRICE_BED[2];
        $PRICE_SOFTBED_TOP = $ARRAY_PRICE_BED[3];
        $PRICE_SOFTBED_BELOW = $ARRAY_PRICE_BED[4];
      }
      else
      {
        $PRICE_HARDSEAT = '';
        $PRICE_SOFTSEAT = '';
        $PRICE_HARDBED_TOP = '';
        $PRICE_HARDBED_MIDDLE = '';
        $PRICE_HARDBED_BELOW = '';
        $PRICE_SOFTBED_TOP = '';
        $PRICE_SOFTBED_BELOW = '';
      }
      switch ($DAY)
      {
        case '0':
        {
          $DAY_NAME = '当天';
          break;
        }
        case '1':
        {
          $DAY_NAME = '次日';
          break;
        }
        case '2':
        {
          $DAY_NAME = '第三天';
          break;
        }
        case '3':
        {
          $DAY_NAME = '第四天';
          break;
        }
        case '4':
        {
          $DAY_NAME = '第五天';
          break;
        }
        case '5':
        {
          $DAY_NAME = '第六天';
          break;
        }
        case '6':
        {
          $DAY_NAME = '第七天';
          break;
        }
      }
      if (((($CIRCLE_TIMES + 1) % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '    <tr class="';
      echo $TableLine;
      echo '">
	<td nowrap align="center">';
      echo $TRAIN_NAME1;
      echo '<br><a href="detail.php?TRAIN_NAME=';
      echo (($TRAIN_NAME1.'<BR>').$TRAIN_NAME2);
      echo '&DEPART_TIME=';
      echo $DEPART_TIME;
      echo '&ARRIVE_TIME=';
      echo $ARRIVE_TIME;
      echo '&TOTAL_HOUR=';
      echo $TOTAL_HOUR;
      echo '&TOTAL_MINUTE=';
      echo $TOTAL_MINUTE;
      echo '&DISTANCE=';
      echo $DISTANCE;
      echo '&NUMBER_OF_STATION=';
      echo $NUMBER_OF_STATION;
      echo '&PRICE_HARDSEAT=';
      echo $PRICE_HARDSEAT;
      echo '&PRICE_SOFTSEAT=';
      echo $PRICE_SOFTSEAT;
      echo '&PRICE_HARDBED_TOP=';
      echo $PRICE_HARDBED_TOP;
      echo '&PRICE_HARDBED_MIDDLE=';
      echo $PRICE_HARDBED_MIDDLE;
      echo '&PRICE_HARDBED_BELOW=';
      echo $PRICE_HARDBED_BELOW;
      echo '&PRICE_SOFTBED_TOP=';
      echo $PRICE_SOFTBED_TOP;
      echo '&PRICE_SOFTBED_BELOW=';
      echo $PRICE_SOFTBED_BELOW;
      echo '&DAY=';
      echo $DAY;
      echo '&TRAINID=';
      echo $TRAINID;
      echo '" >';
      echo $TRAIN_NAME2;
      echo '</a></td>
	<td nowrap align="center">';
      echo $DEPART_TIME;
      echo '</td>
	<td nowrap align="center">';
      echo $DAY_NAME;
      echo ' ';
      echo $ARRIVE_TIME;
      echo '</td>
	<td nowrap align="center">';
      echo $DISTANCE;
      echo '</td>
	<td nowrap align="center">';
      echo $PRICE_HARDSEAT;
      echo '</td>
	<td nowrap align="center"><a href="detail.php?TRAIN_NAME=';
      echo (($TRAIN_NAME1.'<BR>').$TRAIN_NAME2);
      echo '&DEPART_TIME=';
      echo $DEPART_TIME;
      echo '&ARRIVE_TIME=';
      echo $ARRIVE_TIME;
      echo '&TOTAL_HOUR=';
      echo $TOTAL_HOUR;
      echo '&TOTAL_MINUTE=';
      echo $TOTAL_MINUTE;
      echo '&DISTANCE=';
      echo $DISTANCE;
      echo '&NUMBER_OF_STATION=';
      echo $NUMBER_OF_STATION;
      echo '&PRICE_HARDSEAT=';
      echo $PRICE_HARDSEAT;
      echo '&PRICE_SOFTSEAT=';
      echo $PRICE_SOFTSEAT;
      echo '&PRICE_HARDBED_TOP=';
      echo $PRICE_HARDBED_TOP;
      echo '&PRICE_HARDBED_MIDDLE=';
      echo $PRICE_HARDBED_MIDDLE;
      echo '&PRICE_HARDBED_BELOW=';
      echo $PRICE_HARDBED_BELOW;
      echo '&PRICE_SOFTBED_TOP=';
      echo $PRICE_SOFTBED_TOP;
      echo '&PRICE_SOFTBED_BELOW=';
      echo $PRICE_SOFTBED_BELOW;
      echo '&DAY=';
      echo $DAY;
      echo '&TRAINID=';
      echo $TRAINID;
      echo '" >详情 </a></td>
</tr>
';
      $CIRCLE_TIMES = ($CIRCLE_TIMES + 1);
      if ((100 < $CIRCLE_TIMES))
      {
        break;
      }
    }
  }
  echo '</table>
';
  if (($CIRCLE_TIMES == 0))
  {
    message ('', '没有符合条件的结果');
  }
  button_back ();
  echo '
</body>
</html>
';
?>