<?php
define('StartTag', 1); // -1 => Heutiger Tag, 0 => Sonntag .... 6=> Samstag
define('Days', 7); // Anzahl anzuzeigender Tage
$AddWoche = (isset($_GET['kw']) ? $_GET['kw'] : 0);
if (StartTag == -1)
$StartTag = mktime(0, 0, 0, date("n"), date("j") + (Days * $AddWoche), date("Y"));
else {
$StartTag = mktime(0, 0, 0, date("n"), date("j") + (Days * $AddWoche) + StartTag - date("w") - (date('w') < StartTag ? Days : 0), date("Y"));
}
$heute = strtotime("+0 day", time());
$heute = strtotime("+0 day", time());
$first = date('d.m.Y', $StartTag);
$last = date('d.m.Y', strtotime("+" . (Days - 1) . " day", $StartTag));
echo "<span style=\"font-size: 18pt;color:#ffffff;\">Sendeplan vom $first - $last</span>";
?>
<br/><br/>
<button class="menuitem mo" onclick="showday('mo')">Montag</button>
<button class="menuitem di" onclick="showday('di')">Dienstag</button>
<button class="menuitem mi" onclick="showday('mi')">Mittwoch</button>
<button class="menuitem do" onclick="showday('do')">Donnerstag</button>
<button class="menuitem fr" onclick="showday('fr')">Freitag</button>
<button class="menuitem sa" onclick="showday('sa')">Samstag</button>
<button class="menuitem so" onclick="showday('so')">Sonntag</button>
<div class="content sendeplan">
<!-- <div class="sp1" id="time">Uhrzeiten<br /><br /><br /><br /><br /><br /> -->
<?php
$sql = "SELECT * FROM `sendeplan`
JOIN sendevorlagen ON sendeplan.vorlagen_id = sendevorlagen.id
LEFT JOIN user ON sendeplan.UID = user.ID WHERE sendeplan.kw = ".date('W')." ORDER BY sendeplan.wt ASC, sendeplan.start ASC, sendeplan.end ASC;";
if ($the_query = mysqli_query($DBCON,$sql)) :
while ($row = mysqli_fetch_assoc($the_query)) :
$wt = '';
switch ($row['wt']) {
case 0:
$wt = 'mo';
break;
case 1:
$wt = 'di';
break;
case 2:
$wt = 'mi';
break;
case 3:
$wt = 'do';
break;
case 4:
$wt = 'fr';
break;
case 5:
$wt = 'sa';
break;
case 6:
$wt = 'so';
break;
}
?>
<div class="row sendeplan-tag <?php echo $wt; ?>">
<!-- Enthält die Uhrzeit -->
<div class="sidebar">
<span><?php echo $row['start']; ?> - <?php echo $row['end']; ?> Uhr</span>
<?php if ($row['wbox']) : ?>
<br><span style="color:#00ff00;">Wunschbox geöffnet</span>
<?php else : ?>
<br><span style="color:#ff0000;">Wunschbox geschlossen</span>
<?php endif; ?>
</div>
<!-- Enthält Sendungstitel, Bild und Beschreibung -->
<div class="main">
<h3><?php echo $row['title']; ?></h3>
<img src="<?php echo $row['image']; ?>" alt="Themenbild der Sendung <?php $row['title'] ?>">
<p><?php echo $row['desc']; ?></p>
</div>
<!-- Enthält Moderatorenbild -->
<div class="sidebar">
<a href="?profil&id=<?php echo $row['UID']; ?>">
<?php if (isset($row['avatar'])) : ?>
<img src="<?php echo $row['avatar']; ?>">
<?php
else :
switch ($row['geschlecht']) {
case 'M':
echo '<img src="img/avatar/noava_m.png">';
break;
case 'W':
echo '<img src="img/avatar/noava_w.png">';
break;
case 'N':
echo '<img src="img/avatar/noava_n.png">';
break;
}
endif;
?>
</a>
</div>
</div>
<?php
endwhile;
else :
echo '<span style="color:#fff;">Keine Sendungen vorhanden!</span>';
endif;
?>
</body>
<script>
function showday(day) {
$('.sendeplan-tag').css({display: 'none'});
$('.menuitem').removeClass('active');
$('.sendeplan-tag.'+day).css({display: 'inline-block'});
$('.menuitem.'+day).addClass('active');
}
$( document ).ready(function() {
var d = new Date();
var n = d.getDay();
switch(n) {
case 0:
day = 'so';
break;
case 1:
day = 'mo';
break;
case 2:
day = 'di';
break;
case 3:
day = 'mi';
break;
case 4:
day = 'do';
break;
case 5:
day = 'fr';
break;
case 6:
day = 'sa';
break;
}
showday(day);
});
</script>
</html>