<html>
<body>
<?php
//
//Tabel heading
//=============
?>
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">
<tbody>
<tr>
<td style="font-weight: bold; width: 12%;">datum</td>
<td style="font-weight: bold; width: 6%;">tijd</td>
<td style="font-weight: bold; width: 8%;">soort</td>
<td style="font-weight: bold; width: 10%;">nummer</td>
<td style="font-weight: bold; width: 20%;">thuis</td>
<td style="font-weight: bold; width: 20%;">uit</td>
<td style="font-weight: bold; width: 19%;">scheidsrechter</td>
</tr>
</tbody>
</table>
<div class="clr" style="border-bottom: 3px solid #222; padding: 3px; margin-bottom: -10px;"></div>
<?php
//SQL sectie
// no direct access
//=================
defined( '_JEXEC' ) or die( 'Restricted access' );
// get data from mySQL
//=====================
$db =& JFactory::getDBO();
$query = "SELECT * FROM #__Wedstrijden WHERE datum >= curdate() ORDER BY DATUM, TIJD";
$db->setQuery($query);
$db->query();
$num_rows = $db->getNumRows();
//print_r($num_rows);
$row = $db->loadRowList();
//print_r($row);
//print_r($row['0']);
//
//Sorteer-kolom met CKC team toevoegen
//====================================
for ($i = 0; $i < $num_rows; $i++) {
$CKC_team = $row[$i]['3'];
if ($row[$i]['5'] <> "BBDZ08H"){
$CKC_team = $row[$i]['4'];
//echo $CKC_team;
}
if ($CKC_team == 'CKC MA1') {
$CKC_team = 'CKC AM1';
}
if ($CKC_team == 'CKC MB1') {
$CKC_team = 'CKC BM1';
}
if ($CKC_team == 'CKC MC1') {
$CKC_team = 'CKC CM1';
}
if ($CKC_team == 'CKC MC2') {
$CKC_team = 'CKC CM2';
}
if ($CKC_team == 'CKC MD1') {
$CKC_team = 'CKC DM1';
}
if ($CKC_team == 'CKC ME1') {
$CKC_team = 'CKC EM1';
}
if ($CKC_team == 'WINTERSTOP') {
$CKC_team = '1';
}
$Drow[$i] = array(
$row[$i]['0'],
$row[$i]['1'],
$row[$i]['2'],
$row[$i]['3'],
$row[$i]['4'],
$row[$i]['5'],
$row[$i]['6'],
$row[$i]['7'],
$row[$i]['8'],
$row[$i]['9'],
$row[$i]['10'],
$row[$i]['11'],
$row[$i]['12'],
$CKC_team);
}
//print_r($Drow['0']);
//?><br><?php
if ($num_rows > 0) {
//
// Obtain a list of columns
//
foreach ($Drow as $key => $rij) {
$r0[$key] = $rij['0'];
$r1[$key] = $rij['1'];
$r2[$key] = $rij['2'];
$r3[$key] = $rij['3'];
$r4[$key] = $rij['4'];
$r5[$key] = $rij['5'];
$r6[$key] = $rij['6'];
$r7[$key] = $rij['7'];
$r8[$key] = $rij['8'];
$r9[$key] = $rij['9'];
$r10[$key] = $rij['10'];
$r11[$key] = $rij['11'];
$r12[$key] = $rij['12'];
$r13[$key] = $rij['13'];
}
// Sorteren op kolom 1 (datum) en 12 (CKC team)
// Add $Drow as the last parameter, to sort by the common key
//===========================================================
array_multisort($r1, SORT_ASC,
$r13, SORT_ASC, $Drow);
//print_r($Drow['0']);
//?><?php
}
else {
echo "<center>Momenteel zijn er geen wedstrijden in de database</center>";
}
//
// Datums in juiste formaat zetten
//===============================
$i=0;
$Vandaag = strtotime(date('Y-m-d'));
//echo date ('Y-m-d')." ".$Vandaag;
$Vorig = 0;
if ($num_rows > 0) {
$WedsDat = strtotime($Drow[$i]['1']);
}
//
//Tabel weergeven
//===============
?>
<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">
<tbody>
<?php
//
// Alleen afdrukken als datum >= vandaag
//======================================
while ($i < $num_rows) {
if ($WedsDat >= $Vandaag) {
$WedsDatum = $Drow[$i]['1'];
$FindM = array("AM", "BM", "CM");
$ReplaceM = array("MA", "MB", "MC");
$CKCTeam = str_replace($FindM,$ReplaceM,$Drow[$i]['13']);
$ScheidsCKC = substr($Drow[$i]['8'], 0, -1*(strlen($Drow[$i]['8'])-strpos($Drow[$i]['8'], "-")));
$ScheidsKNVB = substr($Drow[$i]['9'], 0, -1*(strlen($Drow[$i]['9'])-strpos($Drow[$i]['9'], "-")));
//
//check op afgelasting
//====================
$db =& JFactory::getDBO();
$query = "
SELECT *
FROM #__Afgelast
WHERE datum = '$WedsDatum'
AND elftal = '$CKCTeam'
ORDER BY datum";
$db->setQuery($query);
$Afgelast = $db->loadObject();
//print_r($Afgelast);
?>
<tr<?php
if ($i % 2) {
if ($Afgelast->check0=="Afgelast"){
echo ' style="COLOR: #FF0000; background-color: #EBEBEB;"';
}else{
echo ' style="background-color: #EBEBEB;"';
}
}else{
if ($Afgelast->check0=="Afgelast"){
echo ' style="COLOR: #FF0000;"';
}
}
?>>
<td style="width: 11%; font-size:10px"><?php if ($WedsDat <> $Vorig) {echo date ('d-m-Y',$WedsDat);}?></td>
<td style="width: 6%; font-size:10px"><?php echo $Drow[$i]['6'];?></td>
<td style="width: 7%; font-size:10px"><?php echo $Drow[$i]['7'];?></td>
<td style="width: 10%; font-size:10px"><?php echo $Drow[$i]['2'];?></td>
<td style="width: 19%; font-size:10px"><?php echo $Drow[$i]['3'];?></td>
<td style="width: 19%; font-size:10px"><?php echo $Drow[$i]['4'];?></td>
<td style="width: 18%; font-size:10px"><?php
if ($Afgelast->check0=="Afgelast"){
echo "AFGELAST";
}elseif ($Drow[$i]['9'] <> "") {
echo $ScheidsKNVB;
} else {
echo $ScheidsCKC;}?></td>
</tr>
<?php
}
$i++;
$Vorig = $WedsDat;
$WedsDat = strtotime($Drow[$i]['1']);
}
//
//Afsluiten tabel en footer
//=========================
?>
</tbody>
</table>
<div class="clr" style="border-bottom: 3px solid #222; padding: 3px; margin-bottom: 10px;"></div>
</body>
</html>