<?php
//error_reporting(E_ALL ^ E_DEPRECATED); ini_set('display_errors', 1);
session_start();
include('script/variablen.php');
include('connect.php');
?>
<!DOCTYPE html>
<html lang="de-CH">
<head>

<?php include('page_meta.php'); ?>

	<title>Aktionen & Kataloge - Fux Elektrowerkzeuge GmbH, Rümlingen</title>

<?php include('page_css.php'); ?>

<?php include('page_script_top.php'); ?>

</head>

<?php
// WENN Cookie Admin aktiv
if ( !empty($_COOKIE["administrator"]) == 1 )
{
	echo '<body class="admin">'."\n";
}
else
{
	echo '<body oncontextmenu="return false">'."\n";
}

include('page_header.php'); ?>

<div id="content">

<section>

	<h1>Aktionen & Kataloge</h1>

	<article>
<?php
$result = mysqli_query($dbi,"SELECT nummer, titel, dateiname, text, m1, m2, m3, m4, m5, m6, m7, m8, von, DATE_FORMAT(von, '%d.%m.%Y') AS von_change, DATE_FORMAT(bis, '%d.%m.%Y') AS bis_change, click FROM aktionen WHERE von <= '$datum' AND bis >= '$datum' ORDER BY dateiname");
$num = mysqli_num_rows($result);

if ( $num == '0' )
{
echo 'Momentan sind keine Aktionen eingetragen!';
}

while($row = mysqli_fetch_assoc($result)) {

$link = 'flip/'.$row['dateiname'].'';

$bild_groesse = getimagesize ('aktion/'.$row['dateiname'].'.jpg');
$bild_breite = $bild_groesse[0];
$bild_hoehe = $bild_groesse[1];

if ( $bild_breite > $bild_hoehe )
{
	$height = 80;
}
else
{
	$height = 150;
}

echo '
<div class="box_marken">
	<a href="'.$link.'" target="_blank" class="katalog_box rahmen rund">';

$ausblenden = strtotime($row['von']);
$ausblenden = $ausblenden  + 2592000;

if ($timestamp <= $ausblenden)
{
echo '
	<div class="positionieren">
		<div style="position:absolute; left:210px; top:22px; width:132px; height:58px; z-index:1;"><img src="images/neu.png" width="132" height="58" alt="Neu"/></div>
	</div>';
}
if ( $row['click'] == 1 )
{
echo '
	<div class="positionieren">
		<div class="pos_pdf_tipp klein"><b>Tipp:</b> Die Produkte sind mit unserem Shop verlinkt!</div>
	</div>';
}
echo'		<div class="katalog_titel navi">'.$row['titel'].'</div>
		<div class="katalog_bild"><img src="aktion/'.$row['dateiname'].'.jpg" alt="'.$row['titel'].'" height="'.$height.'"/></div>
		<div class="katalog_text">
			<div class="katalog_pdf">Anschauen</div><br><br>
			<div class="klein">Gültig vom '.$row['von_change'].' - '.$row['bis_change'].'</div>
		</div>
	</a>
</div>';
}
?>
	</article>

<?php include('page_last.php'); ?>

</section>

</div>

<?php include('page_footer.php'); ?>

<?php include('page_script_bottom.php'); ?>

</body>
</html>