<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/artiplas_mdb.asp" -->
		 <%
Dim categorias
Dim categorias_numRows

Set categorias = Server.CreateObject("ADODB.Recordset")
categorias.ActiveConnection = MM_artiplas_mdb_STRING
categorias.Source = "SELECT categorias.id_categorias, categorias.nombre, categorias.descripcion, Count(productos.id_producto) AS CuentaDeid_producto FROM categorias INNER JOIN productos ON categorias.id_categorias = productos.id_categoria GROUP BY categorias.id_categorias, categorias.nombre, categorias.descripcion ORDER BY categorias.nombre"
categorias.CursorType = 0
categorias.CursorLocation = 2
categorias.LockType = 1
categorias.Open()

categorias_numRows = 0
%>

<%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = 10
Repeat1__index = 0
categorias_numRows = categorias_numRows + Repeat1__numRows
%>

<%
'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

Dim categorias_total
Dim categorias_first
Dim categorias_last

' set the record count
categorias_total = categorias.RecordCount

' set the number of rows displayed on this page
If (categorias_numRows < 0) Then
  categorias_numRows = categorias_total
Elseif (categorias_numRows = 0) Then
  categorias_numRows = 1
End If

' set the first and last displayed record
categorias_first = 1
categorias_last  = categorias_first + categorias_numRows - 1

' if we have the correct record count, check the other stats
If (categorias_total <> -1) Then
  If (categorias_first > categorias_total) Then
    categorias_first = categorias_total
  End If
  If (categorias_last > categorias_total) Then
    categorias_last = categorias_total
  End If
  If (categorias_numRows > categorias_total) Then
    categorias_numRows = categorias_total
  End If
End If
%>
<%
Dim MM_paramName 
%>
<%
' *** Move To Record and Go To Record: declare variables

Dim MM_rs
Dim MM_rsCount
Dim MM_size
Dim MM_uniqueCol
Dim MM_offset
Dim MM_atTotal
Dim MM_paramIsDefined

Dim MM_param
Dim MM_index

Set MM_rs    = categorias
MM_rsCount   = categorias_total
MM_size      = categorias_numRows
MM_uniqueCol = ""
MM_paramName = ""
MM_offset = 0
MM_atTotal = false
MM_paramIsDefined = false
If (MM_paramName <> "") Then
  MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "")
End If
%>
<%
' *** Move To Record: handle 'index' or 'offset' parameter

if (Not MM_paramIsDefined And MM_rsCount <> 0) then

  ' use index parameter if defined, otherwise use offset parameter
  MM_param = Request.QueryString("index")
  If (MM_param = "") Then
    MM_param = Request.QueryString("offset")
  End If
  If (MM_param <> "") Then
    MM_offset = Int(MM_param)
  End If

  ' if we have a record count, check if we are past the end of the recordset
  If (MM_rsCount <> -1) Then
    If (MM_offset >= MM_rsCount Or MM_offset = -1) Then  ' past end or move last
      If ((MM_rsCount Mod MM_size) > 0) Then         ' last page not a full repeat region
        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
      Else
        MM_offset = MM_rsCount - MM_size
      End If
    End If
  End If

  ' move the cursor to the selected record
  MM_index = 0
  While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1))
    MM_rs.MoveNext
    MM_index = MM_index + 1
  Wend
  If (MM_rs.EOF) Then 
    MM_offset = MM_index  ' set MM_offset to the last possible record
  End If

End If
%>
<%
' *** Move To Record: if we dont know the record count, check the display range

If (MM_rsCount = -1) Then

  ' walk to the end of the display range for this page
  MM_index = MM_offset
  While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size))
    MM_rs.MoveNext
    MM_index = MM_index + 1
  Wend

  ' if we walked off the end of the recordset, set MM_rsCount and MM_size
  If (MM_rs.EOF) Then
    MM_rsCount = MM_index
    If (MM_size < 0 Or MM_size > MM_rsCount) Then
      MM_size = MM_rsCount
    End If
  End If

  ' if we walked off the end, set the offset based on page size
  If (MM_rs.EOF And Not MM_paramIsDefined) Then
    If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then
      If ((MM_rsCount Mod MM_size) > 0) Then
        MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
      Else
        MM_offset = MM_rsCount - MM_size
      End If
    End If
  End If

  ' reset the cursor to the beginning
  If (MM_rs.CursorType > 0) Then
    MM_rs.MoveFirst
  Else
    MM_rs.Requery
  End If

  ' move the cursor to the selected record
  MM_index = 0
  While (Not MM_rs.EOF And MM_index < MM_offset)
    MM_rs.MoveNext
    MM_index = MM_index + 1
  Wend
End If
%>
<%
' *** Move To Record: update recordset stats

' set the first and last displayed record
categorias_first = MM_offset + 1
categorias_last  = MM_offset + MM_size

If (MM_rsCount <> -1) Then
  If (categorias_first > MM_rsCount) Then
    categorias_first = MM_rsCount
  End If
  If (categorias_last > MM_rsCount) Then
    categorias_last = MM_rsCount
  End If
End If

' set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth

Dim MM_removeList
Dim MM_item
Dim MM_nextItem

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
  MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If

MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""

' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
  MM_nextItem = "&" & MM_item & "="
  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
    MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))
  End If
Next

' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
  MM_nextItem = "&" & MM_item & "="
  If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
    MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))
  End If
Next

' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then 
  MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "")  Then
  MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
  MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If

' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
  If (firstItem <> "") Then
    MM_joinChar = "&"
  Else
    MM_joinChar = ""
  End If
End Function
%>
<%
' *** Move To Record: set the strings for the first, last, next, and previous links

Dim MM_keepMove
Dim MM_moveParam
Dim MM_moveFirst
Dim MM_moveLast
Dim MM_moveNext
Dim MM_movePrev

Dim MM_urlStr
Dim MM_paramList
Dim MM_paramIndex
Dim MM_nextParam

MM_keepMove = MM_keepBoth
MM_moveParam = "index"

' if the page has a repeated region, remove 'offset' from the maintained parameters
If (MM_size > 1) Then
  MM_moveParam = "offset"
  If (MM_keepMove <> "") Then
    MM_paramList = Split(MM_keepMove, "&")
    MM_keepMove = ""
    For MM_paramIndex = 0 To UBound(MM_paramList)
      MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1)
      If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then
        MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex)
      End If
    Next
    If (MM_keepMove <> "") Then
      MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)
    End If
  End If
End If

' set the strings for the move to links
If (MM_keepMove <> "") Then 
  MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&"
End If

MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="

MM_moveFirst = MM_urlStr & "0"
MM_moveLast  = MM_urlStr & "-1"
MM_moveNext  = MM_urlStr & CStr(MM_offset + MM_size)
If (MM_offset - MM_size < 0) Then
  MM_movePrev = MM_urlStr & "0"
Else
  MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size)
End If
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<META name="description" content="Artiplas, Fabricacion, Distribucion y Comercializacion de Envases y Embalajes para Uso industrial. ">
<title>Artiplas</title>
<link href="artyplas.css" rel="stylesheet" type="text/css" />
<link href="migas.js" type="text/javascript" />
 <!--[if lte IE 6]>
<link href="ie6.css" rel="stylesheet" type="text/css" />
<![endif]-->
 <style type="text/css">
<!--
.Estilo5 {font-size: 9px}
-->
 </style>
</head>

<body>
<div id="wrapper">
	<div id="header">

<h1 style="display:none;">Artiplas</h1>


		<div id="login">
      <div id="top-login">
        <p>.</p>
      </div>
      <form action="gestion/" method="post" name="contrasenia">
        <p>
          <label for="user">Usuario</label>
          <input name="user" id="user" type="text"  size="10" tabindex="1"/>
        </p>
        <p class="ir">
          <input name="image" alt="enviar usuario y clave" type="image" tabindex="3" value="Ir" src="images/ir.gif"/>
        </p>
        <p>
          <label for="password">Clave</label>
          <input name="password" id="password" type="text"  size="10" tabindex="2"/>
        </p>
      </form>
      <div id="bottom-login">
        <p>.</p>
      </div>
    </div>
	<div id="navbar">
      <ul>
        <li><a href="index.htm"><span class="forma_boton">Empresa</span></a></li>
        <li><a href="productos.asp" class="selected";><span class="forma_boton">productos</span></a></li>
        <li><a href="actividad.asp"><span class="forma_boton">Actividad</span></a></li>
        <li><a href="contacto.asp"><span class="forma_boton">contacto</span></a></li>
        <li><a href="localizacion.htm"><span class="forma_boton">Ubicación</span></a></li>
      </ul>
    </div>
	
	</div><!--/header-->

<!--contenido-->
<!--barralateral-->
<div id="sidebar">
	
	
		<div class="side">
			<div class="cabecera_side">Cat&aacute;logo</div>
				<ul>					
					<li><a href="index.htm">Empresa</a></li>			
					<li><a href="productos.asp" class="selected">Productos</a></li>			
					<li><a href="actividad.asp">Actividad</a></li>			
					<li><a href="contacto.asp">Contacto</a></li>			
					<li><a href="localizacion.htm">Ubicación</a></li>		
				</ul>
			
			<div class="foot_side"></div>		
		</div><!--/side-->
		
		
		<div class="side">
			<div class="cabecera_side">Reg&iacute;strese</div>
				
					Si aun no es usuario registrado	
				<br /><br />
				<img src="images/boton_registro.jpg" alt="Registro" />
			
			<div class="foot_side"></div>		
		</div><!--/side-->

  </div><!--/sidebar-->


    <!-------textoyfotos--->


  <div id="content">
	<h2><span class="titulo"><a href="productos.asp"> Productos</a></span></h2> 
	
  <div id="productos_main">
        <% 
While ((Repeat1__numRows <> 0) AND (NOT categorias.EOF)) 
%>
        <div class="producto_port">
            <div class="titprod_portada">
              <h4><a href="productos_detalle.asp?nombre=<%=(categorias.Fields.Item("nombre").Value)%>&cat=<%=(categorias.Fields.Item("id_categorias").Value)%>" title="<%=(categorias.Fields.Item("nombre").Value)%>"><strong><%=(categorias.Fields.Item("descripcion").Value)%>&nbsp;...........................</strong></a></h4>
              <span class="Estilo5">( <%=(categorias.Fields.Item("CuentaDeid_producto").Value)%> productos )</span></div>
       <%
Dim fotos
Dim fotos_numRows

Set fotos = Server.CreateObject("ADODB.Recordset")
fotos.ActiveConnection = MM_artiplas_mdb_STRING
fotos.Source = "SELECT productos.id_categoria, productos.foto, productos.id_producto FROM productos WHERE (((productos.id_categoria)="&(categorias.Fields.Item("id_categorias").Value)&") AND ((productos.foto)=True))"
fotos.CursorType = 0
fotos.CursorLocation = 2
fotos.LockType = 1
fotos.Open()

fotos_numRows = 0

Repeat2__numRows = 3
Repeat2__index = 0
fotos_numRows = fotos_numRows + Repeat2__numRows


While ((Repeat2__numRows <> 0) AND (NOT fotos.EOF)) 
%><a href="productos_detalle.asp?nombre=<%=(categorias.Fields.Item("nombre").Value)%>&cat=<%=(categorias.Fields.Item("id_categorias").Value)%>" title="<%=(categorias.Fields.Item("nombre").Value)%>"><img src="images/productos/p_<%=(fotos.Fields.Item("id_producto").Value)%>.jpg" width="60" height="40" alt="producto de artiplas" class="img_port" /></a><% 
  Repeat2__index=Repeat2__index+1
  Repeat2__numRows=Repeat2__numRows-1
  fotos.MoveNext()
Wend
%>
</div>
<% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  categorias.MoveNext()
Wend
%>
          
<!--/.producto--><!--/.producto--><!--/.producto--><!--/.producto--><!--/.producto--><!--/.producto--><!--/.producto-->
		  <!--/.producto--><!--/.producto-->
		  <!--/.producto-->
	  </div><div style="clear:both"></div>
<p>
		  <!--/#producto-->
	  </p>
		<p>&nbsp;</p>
	  <p>&nbsp;</p>
	  <p>&nbsp;
		  
		  
      </p> 
        
      <table width="499" border="0" align="center">
        <tr>
          <td width="217"><% If MM_offset <> 0 Then %>
                <a href="<%=MM_movePrev%>">&lt; Anterior</a>
                <% End If ' end MM_offset <> 0 %>          </td>
          <td width="272"><div align="right">
            <% If Not MM_atTotal Then %>
              <a href="<%=MM_moveNext%>">Siguiente &gt;</a>
              <% End If ' end Not MM_atTotal %>          
          </div></td>
        </tr>
      </table>
  </div>
  <!--/content-->
</div><!--/wrapper-->
<div id="pie">
	<p>
	Poligono Erletxes, Plataforma K, Edif. 3, Nº 3-28<br />
48960 GALDAKANO - BIZKAIA<br />
Tfnos.: 94 472 30 04 - 94 495 46 94<br />
Fax: 94 416 41 48<br />
Móvil: 607 221 338<br />
</div>
</body>
</html>
<%
categorias.Close()
Set categorias = Nothing
%>
<%
fotos.Close()
Set fotos = Nothing
%>