Fahrplaninformationssysteme - von Jörg Siebrands

Fahrpläne

Quelltext:

Im <body>-Tag muss ein onload-Ereignis hinzugefügt werden:

<body onload="runQuery()">

Restlicher Quelltext:

<script>

var oInterval = new Object();
var lineID;
var lineName;
var daygroupID;
var direction;


function showTimeTable4(t) { 
  var a = document.getElementById("mytable");
  a.tBodies[0].rows[0].cells[0].innerHTML = '<b>' + lineName + '</b>'; 
  for (i=1; i<t.length; i++) {
    a.tBodies[0].rows[i].cells[0].innerHTML = '<b>' + t[i][0] + '</b>';
    a.tBodies[0].rows[i].cells[0].bgColor = "#CCCCFF";
  }
  document.getElementById("mytable").style.visibility = "visible"; 
}

function showTimeTable3(t) { 
  var i,j,k;
  var a = new Array();
  var newTR, newTD, newTDText;
  var stunde, minute, feld;
  publicSQL.htmlTableDelete("mytable")
  document.getElementById("mytable").style.visibility = "hidden";
  for (i=0; i<t[1].length; i++) {
    newTR = document.getElementById("mytable").insertRow(i);
    newTD = document.createElement("td");
    newTDtext = document.createTextNode("");
    newTD.appendChild(newTDtext);
    newTR.appendChild(newTD); 
    for (j=1; j<t.length; j++) {
      newTD = document.createElement("td");
      if ( (i>0) && ((i % 2) == 0) ) {
        newTD.bgColor = "#F0F0F0";
      } else {
        newTD.bgColor = "#E0E0E0"; 
      }
      if (i == 0) {
        feld = t[j][i]; 
        newTD.bgColor = "#CCCCFF"; 
      } else {
        if (t[j][i] > -1) {
          stunde = Math.floor(t[j][i] / 60);
          minute = t[j][i] - (stunde * 60);
          stunde = ((stunde > 23) ? stunde - 24 : stunde); 
          feld = ((stunde < 10) ? "0" + stunde : stunde);
          feld = feld + ":" + ((minute < 10) ? "0" + minute : minute);
        } else if (t[j][i] == -1) {
          feld = ""; 
        } else if (t[j][i] < -1) {
          if (t[j][i] > -1000) {
            feld = "alle " + oInterval[Math.abs(t[j][i])] + " Min.";
            k = i+1;
            newTD.bgColor = "#E8E8E8";
            newTD.style.textAlign = "center";
            a[j] = newTD;
            while ( (k <t[1].length) && (t[j][k] == t[j][i]) ) {
              t[j][k] = -1000 - i;
              k++;
            }
          } else {
            a[j].rowSpan++;
          }
        } 
      }
      if (t[j][i] > -1000) {
        newTDtext = document.createTextNode(feld);
        newTD.appendChild(newTDtext);
        newTR.appendChild(newTD); 
      }
    }
  }
  publicSQL.query('select s.Station from ttc_' + lineID + ' t, stations s 
    where t.StationID = s.ID and t.DayGroupID = ' + daygroupID + ' 
    and t.Direction = ' + direction + ' order by t.Position', 'showTimeTable4');
}

function showTimeTable2(t) {
  for (var i=1; i<t.length; i++) {
    oInterval[t[i][0]] = t[i][1];
  }
  publicSQL.query('select * from tt_' + lineID + '_' + direction + '_' + daygroupID, 
    'showTimeTable3');
}

function showTimeTable() {
  publicSQL.query('select * from intervals', 'showTimeTable2'); 
}

function runQuery2(t) {
  var neuer;
  for (var i=1; i<t.length; i++) {
    neuer = new Option(t[i][1], t[i][0], false, false); 
    document.fmSelect.sbLines.options[i-1] = neuer;
  }
  document.fmSelect.sbLines.selectedIndex = 0;
  lineID = document.fmSelect.sbLines.options[document.fmSelect.sbLines.selectedIndex].value;
  lineName = document.fmSelect.sbLines.options[document.fmSelect.sbLines.selectedIndex].text; 
  publicSQL.query('select lc.DayGroupID, lc.Direction, dg.Text 
    from line_connections lc, daygroups dg where lc.LineID = ' + lineID + ' 
    and lc.DayGroupID = dg.ID order by dg.DayGroupID, lc.Direction', 'newDirAndDays'); 
}

function runQuery() {
  publicSQL.query('select * from lines order by ID', 'runQuery2'); 
}

function newDir(t) {
  var neuer;
  document.fmSelect.sbDirection.length = 0;
  for (var i=1; i<t.length; i++) {
    neuer = new Option(t[i][0], t[i][0], false, false);
    document.fmSelect.sbDirection.options[document.fmSelect.sbDirection.length] = neuer;
  }
  document.fmSelect.sbDirection.selectedIndex = 0;
  direction = 
    document.fmSelect.sbDirection.options[document.fmSelect.sbDirection.selectedIndex].value;
}

function newDirAndDays(t) {
  var wert;
  var alt = 0;
  var neuer;
  document.fmSelect.sbDays.length = 0; 
  for (var i=1; i<t.length; i++) {
    wert = t[i][0];
    if (wert != alt) {
      neuer = new Option(t[i][2], wert, false, false); 
      document.fmSelect.sbDays.options[document.fmSelect.sbDays.length] = neuer; 
    }
    alt = wert;
  }
  daygroupID = document.fmSelect.sbDays.options[document.fmSelect.sbDays.selectedIndex].value; 
  publicSQL.query('select lc.Direction from line_connections lc 
    where lc.LineID = ' + lineID + ' and lc.DayGroupID = ' + daygroupID + ' 
    order by lc.Direction', 'newDir'); 
}

function changeLine() {
  lineID = document.fmSelect.sbLines.options[document.fmSelect.sbLines.selectedIndex].value; 
  lineName = document.fmSelect.sbLines.options[document.fmSelect.sbLines.selectedIndex].text; 
  publicSQL.query('select lc.DayGroupID, lc.Direction, dg.Text 
    from line_connections lc, daygroups dg where lc.LineID = ' + lineID + ' 
    and lc.DayGroupID = dg.ID order by dg.DayGroupID, lc.Direction', 'newDirAndDays'); 
}

function changeDays() {
  daygroupID = document.fmSelect.sbDays.options[document.fmSelect.sbDays.selectedIndex].value; 
  publicSQL.query('select lc.Direction, from line_connections lc where lc.LineID = ' + lineID + ' 
    and lc.DayGroupID = ' + daygroupID + ' order by lc.Direction', 'newDir'); 
}

function changeDirection() {
  direction = 
    document.fmSelect.sbDirection.options[document.fmSelect.sbDirection.selectedIndex].value;
}
   
</script>
<form action="" method="post" name="fmSelect" id="fmSelect">
  <strong>Linie:</strong>
  <select name="sbLines" onChange="changeLine();">
  </select> 
  <strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fahrtage:</strong> 
  <select name="sbDays" id="sbDays" onChange="changeDays()">
  </select> 
  <strong>&nbsp;&nbsp;&nbsp;&nbsp;Richtung:</strong>
  <select name="sbDirection" id="sbDirection" onChange="changeDirection()">
  </select>
  <strong>&nbsp;</strong><strong>&nbsp;</strong><strong>&nbsp;</strong><strong>&nbsp;</strong>
  <input name="btStart" type="button" id="btStart" onClick="showTimeTable();" value="Start"> 
  <!-- hier kann ein Text zur Abfrage eingefügt werden -->
  <br><br>
</form>

<table id="mytable" border="1">
  <tr>
    <td></td>
  </tr>
</table>