<?php session_start();
//error_reporting(E_ALL & ~E_NOTICE | E_STRICT);

//ini_set("display_errors", 1); 
//error_reporting(E_ALL);
ob_start("ob_gzhandler");
if(isset($_SESSION['carro'])) 
$carro=$_SESSION['carro']; else $carro=false;
if (isset($_GET['cat'])) $cat="&cat=".$_GET['cat']; else $cat="";
if (isset($_GET['buscar'])) $buscar="&buscar=".$_GET['buscar']; else $buscar="";
?>
<?php require_once('Connections/tm87.php'); ?>
<?php

if (isset($_GET['categoria'])and($_GET['categoria']!="")) {
$colname_qry = "-1";
$colname_qry = (get_magic_quotes_gpc()) ? $_GET['categoria'] : addslashes($_GET['categoria']);

////mysql_select_db($database, $conexion);
$query_qry = sprintf("SELECT * FROM tienda_articulos right join tienda_categorias on categoria_id = id_categoria WHERE categoria_id = %s or categoria_3 = %s ORDER BY articulo ASC", GetSQLValueString($colname_qry, "int"), GetSQLValueString($colname_qry, "int"));
$qry = mysqli_query( $conexion,$query_qry) or die(mysqli_error());

$row_qry = mysqli_fetch_assoc($qry);
$totalRows_qry = mysqli_num_rows($qry);

// select original: SELECT * FROM tienda_articulos WHERE categoria_id = %s or categoria_2 = ".$_GET['categoria']." or categoria_3 = ".$_GET['categoria']." ORDER BY articulo ASC

} else if (isset($_GET['buscar'])and($_GET['buscar']!="")) {
$resultado = $_GET['buscar'];
//mysql_select_db($database, $conexion);
$query_qry = "SELECT * FROM tienda_articulos join tienda_categorias on categoria_id=id_categoria) left join tienda_fotos on articulo_id=id WHERE articulo like '%".$resultado."%' or categoria like '%".$resultado."%' group by id ORDER BY articulo asc";
$qry = mysqli_query( $conexion,$query_qry) or die(mysqli_error());
$row_qry = mysqli_fetch_assoc($qry);
$totalRows_qry = mysqli_num_rows($qry);
} else {
////mysql_select_db($database, $conexion);
$query_qry = sprintf("SELECT * FROM (tienda_articulos join tienda_categorias on categoria_id=id_categoria) left join tienda_fotos on articulo_id=id group by articulo ORDER BY articulo ASC");
$qry = mysqli_query( $conexion,$query_qry) or die(mysqli_error());
$row_qry = mysqli_fetch_assoc($qry);
$totalRows_qry = mysqli_num_rows($qry);
}

function limitarPalabras($cadena, $longitud, $elipsis = "..."){
	$palabras = explode(' ', $cadena);
	if (count($palabras) > $longitud)
	return implode(' ', array_slice($palabras, 0, $longitud)) . $elipsis;
	else return $cadena; }

// query para destacados
	////mysql_select_db($database, $conexion);
	$query_qry_destacados = sprintf("SELECT * FROM tienda_articulos WHERE destacado =1 ORDER BY articulo ASC limit 1,4", GetSQLValueString($colname_qry, "int"), GetSQLValueString($colname_qry, "int"));
	$qry_destacados = mysqli_query($conexion,$query_qry_destacados) or die(mysqli_error());
	$row_qry_destacados = mysqli_fetch_assoc($qry_destacados);
	$totalRows_qry_destacados = mysqli_num_rows($qry_destacados);
// query para destacados2
	////mysql_select_db($database, $conexion);
	$query_qry_destacados2 = sprintf("SELECT * FROM tienda_articulos WHERE destacado =1 ORDER BY articulo ASC limit 5,4", GetSQLValueString($colname_qry, "int"), GetSQLValueString($colname_qry, "int"));
	$qry_destacados2 = mysqli_query($conexion,$query_qry_destacados2) or die(mysqli_error());
	$row_qry_destacados2 = mysqli_fetch_assoc($qry_destacados2);
	$totalRows_qry_destacados2 = mysqli_num_rows($qry_destacados2);


 // query para ultimos productos 1
	////mysql_select_db($database, $conexion);
	$query_qry_ultimos = sprintf("SELECT * FROM tienda_articulos where destacado =0 ORDER BY ID DESC limit 1, 4", GetSQLValueString($colname_qry, "int"), GetSQLValueString($colname_qry, "int"));
	$qry_ultimos = mysqli_query($conexion,$query_qry_ultimos) or die(mysqli_error());
	$row_qry_ultimos = mysqli_fetch_assoc($qry_ultimos);
	$totalRows_qry_ultimos = mysqli_num_rows($qry_ultimos);
// query para ultimos productos 2
	////mysql_select_db($database, $conexion);
	$query_qry_ultimos2 = sprintf("SELECT * FROM tienda_articulos where destacado =0 ORDER BY ID DESC limit 5, 4", GetSQLValueString($colname_qry, "int"), GetSQLValueString($colname_qry, "int"));
	$qry_ultimos2 = mysqli_query($conexion,$query_qry_ultimos2) or die(mysqli_error());
	$row_qry_ultimos2 = mysqli_fetch_assoc($qry_ultimos2);
	$totalRows_qry_ultimos2 = mysqli_num_rows($qry_ultimos2);


 ?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
		<title>TM87 - Efectos discoteca y escenario</title>
		<meta name="viewport" content="width=device-width, initial-scale=1.0">
		<meta name="description" content="">
		<!--[if ie]><meta content='IE=8' http-equiv='X-UA-Compatible'/><![endif]-->
		<!-- bootstrap -->
		<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">      
		<link href="bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet">
		
		<link href="themes/css/bootstrappage.css" rel="stylesheet"/>
		
		<!-- global styles -->
		<link href="themes/css/flexslider.css" rel="stylesheet"/>
		<link href="themes/css/main.css" rel="stylesheet"/>

		<!-- scripts -->
		<script src="themes/js/jquery-1.7.2.min.js"></script>
		<script src="bootstrap/js/bootstrap.min.js"></script>				
		<script src="themes/js/superfish.js"></script>	
		<script src="themes/js/jquery.scrolltotop.js"></script>
		<!--[if lt IE 9]>			
			<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
			<script src="js/respond.min.js"></script>
		<![endif]-->
	</head>
    <body>		
		<div id="top-bar" class="container">
			<?php include("cabecera.php"); ?>	
       	</div>
        
		<div id="wrapper" class="container">
			<section class="navbar main-menu">
				<div class="navbar-inner main-menu">				
					<!--<a href="index.php" class="logo pull-left"><img src="themes/images/logo.png" class="site_logo" alt=""  height="50px"></a>-->
					<nav id="menu" class="pull-right">
						<ul>
							<?php include("catalogo_categorias.php"); ?>
					  </ul>
					</nav>
				</div>
			</section>
			<section  class="homepage-slider" id="home-slider">
				<div class="flexslider">
					<ul class="slides">
						<li>
							<img src="themes/images/carousel/banner-1.jpg" alt="" />
                            <div class="intro">
								<h1>Proyectos a medida</h1>
								<p><span>Capacidad de instalaci&oacute;n y reparaci&oacute;n</span></p>
								<p><span>Nuestra empresa auna todo lo que nuestros clientes pueden necesitar</span></p>
							</div>
					  </li>
						<li>
							<img src="themes/images/carousel/banner-2.jpg" alt="" />
							<div class="intro">
								<h1>Proyectos en 24h/48h</h1>
								<p><span>Maximizaci&oacute;n costo / rendimiento</span></p>
								<p><span>Productos y servicios de alta calidad</span></p>
							</div>
					  </li>
					</ul>
				</div>			
			</section>
			<section class="header_text">
				Proyectos a medida, asesoramiento profesional gratuito, sala de exposici&oacute;n donde puede ver el material antes de comprarlo. 
				<br/>  Y lo m&aacute;s importante, capacidad de instalaci&oacute;n y reparaci&oacute;n de todos los equipos suministrados.
			</section>
			<section class="main-content">
				<div class="row">
					<div class="span12">													
						<div class="row">
							<div class="span12">
								<h4 class="title">
									<span class="pull-left"><span class="text"><span class="line">Productos <strong>Destacados</strong></span></span></span>
									<span class="pull-right">
										<a class="left button" href="#myCarousel" data-slide="prev"></a><a class="right button" href="#myCarousel" data-slide="next"></a>
									</span>
								</h4>
								<div id="myCarousel" class="myCarousel carousel slide">
									<div class="carousel-inner">
										<div class="active item">
											<ul class="thumbnails">												
												
 <!-- galaria de productos para repetir  -->							
                            <?php do { ?>
   								<?php if ($totalRows_qry_destacados <> 0) { ?>
                            	<li class="span3">
                                
                                    <div class="product-box" href="catalogo/product_detail.php?articulo=<?php echo $row_qry_destacados['articulo']; ?>">
                                         <span class="sale_tag"></span>
                                         <?php
                                            ////mysql_select_db($database, $conexion);
                                            $query_fotos = "SELECT * FROM tienda_fotos where articulo_id =".$row_qry_destacados['id'];
											
                                            $fotos = mysqli_query($conexion,$query_fotos) or die(mysqli_error());
                                            $row_fotos = mysqli_fetch_assoc($fotos);
                                        ?>  
										<?php if (($row_fotos['foto'] != "") OR ($row_fotos['foto'] != NULL)){
											if (file_exists("fototienda/".$row_fotos['foto'])){ ?>
												<!-- <a href="fototienda/<?php //echo $row_fotos['foto']; ?>" rel="lightbox"> -->
                                             <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_destacados['articulo']); ?>"><img src="fototienda/thumbs/<?php echo $row_fotos['foto'] ?>" alt=""  border="0"/>
										<!-- </a> -->
									   	<?php } else { ?>
											<img src="images/nofoto.jpg" border="0">
						   				<?php }
						   
										} else { ?>
											<img src="images/nofoto.jpg" border="0">
										<?php } ?>
                                        
                                        
                                        <!--<a href="../product_detail.html"><img alt="" src="../themes/images/ladies/9.jpg"></a><br/>-->	
                                         <a href="catalogo/product_detail.php?articulo=<?php echo urlencode($row_qry_destacados['articulo']); ?>" class="title"><?php echo $row_qry_destacados['articulo']; ?></a><br/>
                                         <?php 
                							$cadena = $row_qry_destacados['detalle'];
               							?>	
                                        <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_destacados['articulo']); ?>" class="category"><?php echo nl2br(limitarPalabras($cadena,15)); ?></a>
                                         <?php 
                							if ($row_qry_destacados['precio']>0){
										?>	
                                            <p class="price"><?php echo $row_qry_destacados['precio']; ?>&nbsp;&euro;</p>
                                         <?php } ?>
                                    </div>
                                    
                                </li>  
                               	<?php } ?>
                             <?php }  while ($row_qry_destacados = mysqli_fetch_assoc($qry_destacados)); ?>       
<!-- galaria de productos  -->

                                                
											</ul>
										</div>
										<div class="item">
											<ul class="thumbnails">
 <!-- galaria de productos para repetir  -->							
                            <?php do { ?>
   								<?php if ($totalRows_qry_destacados2 <> 0) { ?>
                            	<li class="span3">
                                
                                    <div class="product-box" href="catalogo/product_detail.php?articulo=<?php echo $row_qry_destacados2['articulo']; ?>">
                                         <span class="sale_tag"></span>
                                         <?php
                                           // //mysql_select_db($database, $conexion);
                                            $query_fotos = "SELECT * FROM tienda_fotos where articulo_id =".$row_qry_destacados2['id'];
											
                                            $fotos = mysqli_query($conexion,$query_fotos) or die(mysqli_error());
                                            $row_fotos = mysqli_fetch_assoc($fotos);
                                        ?>  
										<?php if (($row_fotos['foto'] != "") OR ($row_fotos['foto'] != NULL)){
											if (file_exists("fototienda/".$row_fotos['foto'])){ ?>
												<!-- <a href="fototienda/<?php //echo $row_fotos['foto']; ?>" rel="lightbox"> -->
                                             <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_destacados2['articulo']); ?>"><img src="fototienda/thumbs/<?php echo $row_fotos['foto'] ?>" alt=""  border="0"/>
										<!-- </a> -->
									   	<?php } else { ?>
											<img src="images/nofoto.jpg" border="0">
						   				<?php }
						   
										} else { ?>
											<img src="images/nofoto.jpg" border="0">
										<?php } ?>
                                        
                                        
                                        <!--<a href="../product_detail.html"><img alt="" src="../themes/images/ladies/9.jpg"></a><br/>-->	
                                        <a href="catalogo/product_detail.php?articulo=<?php echo urlencode($row_qry_destacados2['articulo']); ?>" class="title"><?php echo $row_qry_destacados2['articulo']; ?></a><br/>
                                         <?php 
                							$cadena = $row_qry_destacados['detalle'];
               							?>	
                                        <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_destacados2['articulo']); ?>" class="category"><?php echo nl2br(limitarPalabras($cadena,15)); ?></a>
                                                                                <?php 
                							if ($row_qry_destacados2['precio']>0){
										?>	
                                            <p class="price"><?php echo $row_qry_destacados2['precio']; ?>&nbsp;&euro;</p>
                                         <?php } ?>

                                    </div>
                                    
                                </li>  
                               	<?php } ?>
                             <?php }  while ($row_qry_destacados2 = mysqli_fetch_assoc($qry_destacados2)); ?>       
<!-- galaria de productos  -->
											</ul>
										</div>
									</div>							
								</div>
							</div>						
						</div>
						<br/>
						<div class="row">
							<div class="span12">
								<h4 class="title">
									<span class="pull-left"><span class="text"><span class="line">Últimos <strong>Productos en cat&aacute;logo</strong></span></span></span>
									<span class="pull-right">
										<a class="left button" href="#myCarousel-2" data-slide="prev"></a><a class="right button" href="#myCarousel-2" data-slide="next"></a>
									</span>
								</h4>
								<div id="myCarousel-2" class="myCarousel carousel slide">
									<div class="carousel-inner">
										<div class="active item">
											<ul class="thumbnails">												
 <!-- galaria de productos para repetir  -->							
                            <?php do { ?>
   								<?php if ($totalRows_qry_ultimos <> 0) { ?>
                            	<li class="span3">
                                
                                    <div class="product-box" href="catalogo/product_detail.php?articulo=<?php echo $row_qry_ultimos['articulo']; ?>">
                                         <span class="sale_tag"></span>
                                         <?php
                                            //mysql_select_db($conexion,$database);
                                            $query_fotos = "SELECT * FROM tienda_fotos where articulo_id =".$row_qry_ultimos['id'];
											
                                            $fotos = mysqli_query($conexion,$query_fotos) or die(mysqli_error());
                                            $row_fotos = mysqli_fetch_assoc($fotos);
                                        ?>  
										<?php if (($row_fotos['foto'] != "") OR ($row_fotos['foto'] != NULL)){
											if (file_exists("fototienda/".$row_fotos['foto'])){ ?>
												<!-- <a href="fototienda/<?php //echo $row_fotos['foto']; ?>" rel="lightbox"> -->
                                             <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_ultimos['articulo']); ?>"><img src="fototienda/thumbs/<?php echo $row_fotos['foto'] ?>" alt=""  border="0"/>
										<!-- </a> -->
									   	<?php } else { ?>
											<img src="images/nofoto.jpg" border="0">
						   				<?php }
						   
										} else { ?>
											<img src="images/nofoto.jpg" border="0">
										<?php } ?>
                                        
                                        
                                        <!--<a href="../product_detail.html"><img alt="" src="../themes/images/ladies/9.jpg"></a><br/>-->	
                                        <a href="catalogo/product_detail.php?articulo=<?php echo urlencode($row_qry_ultimos['articulo']); ?>" class="title"><?php echo $row_qry_ultimos['articulo']; ?></a><br/>
                                         <?php 
                							$cadena = $row_qry_ultimos['detalle'];
               							?>	
                                        <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_ultimos['articulo']); ?>" class="category"><?php echo nl2br(limitarPalabras($cadena,15)); ?></a>
                                                                                <?php 
                							if ($row_qry_ultimos['precio']>0){
										?>	
                                            <p class="price"><?php echo $row_qry_ultimos['precio']; ?>&nbsp;&euro;</p>
                                         <?php } ?>

                                    </div>
                                    
                                </li>  
                               	<?php } ?>
                             <?php }  while ($row_qry_ultimos = mysqli_fetch_assoc($qry_ultimos)); ?>       
<!-- galaria de productos  -->
											</ul>
										</div>
										<div class="item">
											<ul class="thumbnails">
 <!-- galaria de productos para repetir  -->							
                            <?php do { ?>
   								<?php if ($totalRows_qry_ultimos2 <> 0) { ?>
                            	<li class="span3">
                                
                                    <div class="product-box" href="product_detail.php?articulo=<?php echo $row_qry_ultimos2['articulo']; ?>">
                                         <span class="sale_tag"></span>
                                         <?php
                                            ////mysql_select_db($database, $conexion);
                                            $query_fotos = "SELECT * FROM tienda_fotos where articulo_id =".$row_qry_ultimos2['id'];
											
                                            $fotos = mysqli_query($conexion,$query_fotos) or die(mysqli_error());
                                            $row_fotos = mysqli_fetch_assoc($fotos);
                                        ?>  
										<?php if (($row_fotos['foto'] != "") OR ($row_fotos['foto'] != NULL)){
											if (file_exists("fototienda/".$row_fotos['foto'])){ ?>
												<!-- <a href="fototienda/<?php //echo $row_fotos['foto']; ?>" rel="lightbox"> -->
                                             <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_ultimos2['articulo']); ?>"><img src="fototienda/thumbs/<?php echo $row_fotos['foto'] ?>" alt=""  border="0"/>
										<!-- </a> -->
									   	<?php } else { ?>
											<img src="images/nofoto.jpg" border="0">
						   				<?php }
						   
										} else { ?>
											<img src="images/nofoto.jpg" border="0">
										<?php } ?>
                                        
                                        
                                        <!--<a href="../product_detail.html"><img alt="" src="../themes/images/ladies/9.jpg"></a><br/>-->	
                                         <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_ultimos2['articulo']); ?>" class="title"><?php echo $row_qry_ultimos2['articulo']; ?></a><br/>
                                         <?php 
                							$cadena = $row_qry_ultimos2['detalle'];
               							?>	
                                        <a href="product_detail.php?articulo=<?php echo urlencode($row_qry_ultimos2['articulo']); ?>" class="category"><?php echo nl2br(limitarPalabras($cadena,15)); ?></a>
                						 <?php 
                                        	if ($row_qry_ultimos2['precio']>0){
										?>	
                                            <p class="price"><?php echo $row_qry_ultimos2['precio']; ?>&nbsp;&euro;</p>
                                         <?php } ?>
                                    </div>
                                    
                                </li>  
                               	<?php } ?>
                             <?php }  while ($row_qry_ultimos2 = mysqli_fetch_assoc($qry_ultimos2)); ?>       
<!-- galaria de productos  -->
											</ul>
										</div>
									</div>							
								</div>
							</div>						
						</div>
						<div class="row feature_box">						
							<div class="span4">
								<div class="service">
									<div class="responsive">	
										<img src="themes/images/feature_img_2.png" alt="" />
										<h4>INVESTIGACI&Oacute;N  <strong>DISE&Ntilde;O</strong></h4>
										<p>Nuestra empresa lleva a cabo la investigaci&oacute;n y participa en una serie de iniciativas para desarrollar constantemente nuestro sector y contribuir con ello al sesarrollo de la sociedad.</p>									
									</div>
								</div>
							</div>
							<div class="span4">	
								<div class="service">
									<div class="customize">			
										<img src="themes/images/feature_img_1.png" alt="" />
										<h4>INNOCACI&Oacute;N <strong>FORTALECIMIENTO</strong></h4>
										<p> Nuestra empresa est&aacute; implementando una estrategia para acelerar el crecimiento a trav&eacute;s de la innovaci&oacute;n y el fortalecimiento organizacional y capacidades asociados</p>
									</div>
								</div>
							</div>
							<div class="span4">
								<div class="service">
									<div class="support">	
										<img src="themes/images/feature_img_3.png" alt="" />
										<h4>SEGURIDAD <strong>SALUD LABORAL</strong></h4>
										<p> Nuestra empresa busca continuamente para desarrollar tecnolog&iacute;as y productos que tendr&aacute;n un mayor impacto en la seguridad de los trabajadores.</p>
									</div>
								</div>
							</div>	
						</div>		
					</div>				
				</div>
			</section>
			<section class="our_client">
				<h4 class="title"><span class="text">Tm87 colabora hacia un mundo m&aacute;s verde. &iexcl;&iexcl;&iexcl;Recicla!!!</span></h4>
				<div class="row">	
        			<div class="span2">
						<a href="#"><img alt="" src="themes/images/clients/1.png"></a>
					</div>
					<div class="span2">
						<a href="#"><img alt="" src="themes/images/clients/1.png"></a>
					</div>
		
					<div class="span2">
						<a href="#"><img alt="" src="themes/images/clients/1.png"></a>
					</div>
					<div class="span2">
						<a href="#"><img alt="" src="themes/images/clients/2.png"></a>
					</div>
					<div class="span2">
						<a href="#"><img alt="" src="themes/images/clients/3.png"></a>
					</div>
					<div class="span2">
						<a href="#"><img alt="" src="themes/images/clients/4.png"></a>
					</div>
				</div>
			</section>
			<section id="footer-bar">
				<?php include("catalogo/pie.php"); ?>
  			</section>
			<section id="copyright">
				<span>Copyright 2017 | TM87.S.A. Todos los derechos reservados.</span>
			</section>
		</div>
		<script src="themes/js/common.js"></script>
		<script src="themes/js/jquery.flexslider-min.js"></script>
		<script type="text/javascript">
			$(function() {
				$(document).ready(function() {
					$('.flexslider').flexslider({
						animation: "fade",
						slideshowSpeed: 4000,
						animationSpeed: 600,
						controlNav: false,
						directionNav: true,
						controlsContainer: ".flex-container" // the container that holds the flexslider
					});
				});
			});
		</script>
    </body>
</html>