<?php 
include('./../fnc/DBConnect.php');
include('./../fnc/componente.php');
include('./../fnc/parametro.php');
include('./../fnc/vinculo.php');
include('./../fnc/UsuarioPanel.php');
include('./../fnc/bitacora.php');
include('./../fnc/aplicacion.php');
include('./../fnc/panel.php');
include('./../fnc/utileria.php');
include('./../usuariosWeb/fnc/usuarioWeb.php');
include('fnc/Producto.php');
include('fnc/Catalogo.php');
include('fnc/Categoria.php');

session_start('PanelAzulDigial');

if(!session_is_registered("panel")){
	echo "<div style=\"	font-family: Verdana, Arial, Helvetica, sans-serif;	color: #0066CC;	font-size: 16px;font-weight: bolder;\">Invalid User</div>";
}

$panel->reactivarDB();

$tipo_u=$panel->usuario->tipo;
$user_u=$panel->usuario->id;
$estado_u=$panel->usuario->estado;


$userModificar = "";
$userEliminar = "";
$userAdicionar = "";
$userAdministrar="";
if($panel->usuario->tipo==3 && $panel->usuario->vinculo->modificar=="NO" && $panel->usuario->vinculo->administrador=="NO"){
	$userModificar = "disabled";
}
if($panel->usuario->tipo==3 && $panel->usuario->vinculo->eliminar=="NO" && $panel->usuario->vinculo->administrador=="NO"){
	$userEliminar= "disabled";
}
if($panel->usuario->tipo==3 && $panel->usuario->vinculo->adicionar=="NO" && $panel->usuario->vinculo->administrador=="NO"){
	$userAdicionar= "disabled";
}
if($panel->usuario->tipo==3 && $panel->usuario->vinculo->administrador=="NO"){
	$userAdministrar= "disabled";
}

$ini_line = (array_key_exists('ini_line', $_REQUEST)) ? $_REQUEST['ini_line']: 1;
$inicio =   $panel->inicioPagina($ini_line);
$ini =      ($ini_line-1)*10;

$nivel =              (array_key_exists('nivel', $_REQUEST))  ? $_REQUEST['nivel']: 0;

$id_ =                (array_key_exists('id', $_REQUEST))                 ? $_REQUEST['id']: NULL;
$ids =                (array_key_exists('ids', $_REQUEST))                ? $_REQUEST['ids']: NULL;
$idss =               (array_key_exists('idss', $_REQUEST))               ? $_REQUEST['idss']: NULL;

$panel->aplicacion = new Aplicacion();
$panel->setFilesPanel(2);


$name_categoria=NULL;
$name_subcategoria=NULL;
$name_subcategorias=NULL;

if($idss){
	$name_subcategorias = $panel->aplicativo->getNombreCategoria($idss);
}
if($ids){
	$name_subcategoria = $panel->aplicativo->getNombreCategoria($ids);
}
if($id_){
	$name_categoria = $panel->aplicativo->getNombreCategoria($id_);
}
$parametros_catalogo = $panel->aplicativo->parametro->getParametros($panel->aplicativo->id,$panel->aplicativo->nombre);

$numero_categorias = $panel->aplicativo->numeroSubCategoriasCategoria();


?>
<link href="css/panel2.css" rel="stylesheet" type="text/css">
<link href="css/panel2Contenido.css" rel="stylesheet" type="text/css">
<link href="css/scrollbar.css" rel="stylesheet" type="text/css">
<link href="css/scrollbar2.css" rel="stylesheet" type="text/css">
<script src="js/validaciones.js"></script>
<script> 
if (history.forward(1)){location.replace(history.forward(1))} 
</script> 

<script>

function getRadioValue_() {
	var value = null;
	var sel_ = document.frm.sel;
	with (document.frm) {
		if (sel_ == null) {
			return null;
		}
		var longitud = document.frm.length;
		if (longitud) {
			for (var i=0; i<longitud; i++) { 
				if (document.frm.elements[i].checked) { 
					value = document.frm.elements[i].value;
					break;
				} 
			}
		} else {
			if (sel_.checked) { 
				value = sel_.value;
			} 
		}
	}
	return value;
}

function checkRadio(objRadio) {
	objRadio.checked = !(objRadio.checked)
}

function fncModificar(){
	var nivel =  document.frm.nivel.value;

	var id =     document.frm.id_.value;
	var ids =    document.frm.ids.value;
	var idss =   document.frm.idss.value;
	var name =   document.frm.name_categoria.value;
	var names =  document.frm.name_subcategoria.value;
	var namess = document.frm.name_subcategorias.value;
	var prd = getRadioValue_();
	if (prd == null) {
        alert('You must select an item!');
		return;
	}else{

		if(prd.indexOf("c")==0){
			cat = prd.substr(1,prd.length);
				
			if(nivel==0){
				document.location.href = 'mod_categoria.php?&nivel='+nivel+'&id='+cat+'&ids='+ids+'&idss='+idss+'&name_categoria='+name+'&name_subcategoria='+names+'&name_subcategorias='+namess;
			}
			if(nivel==1){
				document.location.href = 'mod_categoria.php?&nivel='+nivel+'&id='+id+'&ids='+cat+'&idss='+idss+'&name_categoria='+name+'&name_subcategoria='+names+'&name_subcategorias='+namess;
			}
			if(nivel==2){
				document.location.href = 'mod_categoria.php?&nivel='+nivel+'&id='+id+'&ids='+ids+'&idss='+cat+'&name_categoria='+name+'&name_subcategoria='+names+'&name_subcategorias='+namess;	
			}
		}
	}
}

function fncAddCategoria() {
	var nivel =  document.frm.nivel.value;

	var id =     document.frm.id_.value;
	var ids =    document.frm.ids.value;
	var idss =   document.frm.idss.value;
	var name =   document.frm.name_categoria.value;
	var names =  document.frm.name_subcategoria.value;
	var namess = document.frm.name_subcategorias.value;

	var cant=document.frm.cant.value;

	
	var aux=parseInt(cant,10);
	
	if(<? echo $numero_categorias; ?>< <? echo $parametros_catalogo['num_categoria'];?>){
		if(confirm("You will add a new Category, are you sure ?")){
			document.location.href = 'add_categoria.php?&nivel='+nivel+'&id='+id+'&ids='+ids+'&idss='+idss+'&name_categoria='+name+'&name_subcategoria='+names+'&name_subcategorias='+namess;	
		}
		return;    
	}else{
		alert('No se puede agregar otra categor�a. Se alcanzo el m�ximo permitido de ('+ <? echo $parametros_catalogo['num_categoria'];?> +') categor�as');
	}
		return;    
}

function fncEliminar() {
    var prd = getRadioValue_();
    if (null == prd) {
        alert('To delete, first select your option.');
        return;
    }else{

		if(prd.indexOf("c")==0){
			var cat = prd.substr(1,prd.length);
			if(confirm("All the products of the Category will be delete, continue?")){
				var nivel =  document.frm.nivel.value;
	
				var id =     document.frm.id_.value;
				var ids =    document.frm.ids.value;
				var idss =   document.frm.idss.value;
				var name =   document.frm.name_categoria.value;
				var names =  document.frm.name_subcategoria.value;
				var namess = document.frm.name_subcategorias.value;

				if(nivel==3){
					_fraUsr.location.href = 'fnc/main.php?nivel=3&task=eli_subcarpeta&id='+id+'&name_carpeta='+name+'&ids='+ids+'&name_subcarpeta='+names+'&idss='+idss+'&name_subcarpetas='+namess+'&idsss='+cat;
				}
				if(nivel==2){
					_fraUsr.location.href = 'fnc/main.php?nivel=2&task=eli_subcarpeta&id='+id+'&name_carpeta='+name+'&ids='+ids+'&name_subcarpeta='+names+'&idss='+cat;
				}
				if(nivel==1){
					_fraUsr.location.href = 'fnc/main.php?nivel=1&task=eli_subcarpeta&id='+id+'&name_carpeta='+name+'&ids='+cat;
				}
				if(nivel==0){
					_fraUsr.location.href = 'fnc/main.php?nivel=0&tarea=eli_categoria&id='+cat;
				}
			}				
		}
	}
    return;
}

function fncListarDocus(id) {
    document.location.href = 'listar_categoria.php?nivel=1&id='+id;
}

function fncListarPromociones() {
    document.location.href = 'l_productos.php?estado=promocion&nivel=0';
}

function fncAdministrar() {
	document.location.href = 'consultar_parametros.php';	
}

function fncListarUsuario() {
	var id = getRadioValue_();
	if (!id) {
		alert('Select a Category.');
		return;
	}
	document.location.href = 'listar_usuario.php?id='+id;
}
function reLoad(obj){
	var ind = obj.selectedIndex;
	var est = obj.options[ind].value;
	document.location.href= 'l_productos.php?seleccion=<?=$seleccion?>&estado='+est;
}
function fncCheckFormSearch(form) {

	var busc = form.buscar.value;
	if(busc == '')
	{
		alert('Enter a value tu find.');
		return false;
	}
	if ( !lengSpaceNess(busc) || specialChar(busc,true,true,true)) {
				alert("Is not possible enter special characters.");
				return false;
	}

	return true;
} 
</script>

<script src="js/SortTable.js"></script>
<br>
<center>
<table width="610" border="0" align="left" cellpadding="2" cellspacing="2" class="texto1">
    <tr bgcolor="cccccc">
    	
      <td colspan="4" class="migas"> <div align="left" class="migas"><a id="migainicio" href="../contenido.php" class="migas" style="cursor:hand" title="Indice de Aplicaciones" onMouseOver="javascript: mgOver(this);" onMouseOut="javascript: mgOut(this);">Start</a> 
        / <span class="migas"><a id="migacat" href="menu.php" class="migas" style="cursor:hand" title="Indice de Aplicaciones" onMouseOver="javascript: mgOver(this);" onMouseOut="javascript: mgOut(this);"> 
        <?=ucfirst(strtolower($panel->aplicativo->nombre))?>
        </a></span> / <span class="migasactivo"> Catalog List</span> </td>
    </tr>
    <tr valign="middle">
      <td height="14" colspan="4" valign="top"> <img src="img/menu.gif" width="49" height="22" align="top">
          <input name="tem2" type="button" class="boton1" style="width:80 "onClick="javascript: document.location.href= 'index.php'" value="Catalog">
         <!--  <input name="tem223" type="button" class="boton1" style="width:63 "onClick="javascript: document.location.href= 'l_productos.php?estado=disponible'" value="Disponible">
        <input name="tem224" type="button" class="boton1" style="width:83 "onClick="javascript: document.location.href= 'l_productos.php?estado=no_disponible'" value="No disponible">
        <input name="tem225" type="button" class="boton1" style="width:52 "onClick="javascript: document.location.href= 'l_productos.php?estado=nuevo'" value="Nuevo">
        <input name="tem22" type="button" class="boton1" style="width:58 "onClick="javascript: document.location.href= 'l_productos.php?estado=promocion'" value="Oferta"> -->

          <input name="tem222" type="button" class="boton1" style="width:90 " onClick="javascript: document.location.href= 'valores_config/index.php'" value="Parameters" <?=$userAdministrar?>>
      </td>
    </tr>
	<tr width="610">

				<td colspan="3" class="texto1">
				<form name="listar" method="get" onSubmit="<?=$PHP_SELF?>">
				
          <div align="left">Products 
            <select name="estado" class="listado" onChange="javascript: reLoad(this);" style="width:80px ">
					<option value="cat" <? if (!$estado){echo "selected";}?>></option>
					<option value="todos" <? if ($estado=="todos"){echo "selected";}?>>All</option>
					<option value="disponible" <? if ($estado=="disponible"){echo "selected";}?>>Available</option>
					<option value="nuevo" <? if ($estado=="nuevo"){echo "selected";}?>>New</option>
					<option value="destacado" <? if ($estado=="destacado"){echo "selected";}?>>Outstanding</option>
					<option value="promocion" <? if ($estado=="oferta"){echo "selected";}?>>Promotion</option>
					
					<option value="no_disponible" <? if ($estado=="no_disponible"){echo "selected";}?>>Not Available</option>

				  </select> 
				  </div>
				</form>
				</td>
				<td width="100" align="right">
				<form name="buscar" method="post" action="l_productos.php" onSubmit="return fncCheckFormSearch(this)">
				  <div align="right">
					<input type="hidden" name="seleccion" value="<?=$seleccion?>">
					<input name="buscar" type="text" class="listado" style="width:100px " value="<?=$buscar?>">
					
            <input name="bbuscar" type="submit" class="boton1" value="Find">
				  </div>
				</form>
				</td>

	</tr>
	<form name="frm" action="<?=$PHP_SELF?>" method="get" id="frm">

    <tr>
   		<td colspan="4" class="texto1">
		Select the category to see the products.
	      <input type='radio'  name='sel'  value='-1' style='visibility: hidden'>
        <input type="hidden" name="tem"             value="vacio">          
		<input type="hidden" value="<?=$id_userC?>" name="id" id="id">
		
	  	<input type="hidden" name="nivel"              value="<?=$nivel?>">	
	  	<input type="hidden" name="id_"                value="<?=$id_?>">	
	  	<input type="hidden" name="ids"                value="<?=$ids?>">	
 		<input type="hidden" name="idss"               value="<?=$idss?>">	
		<input type="hidden" name="name_categoria"     value="<?=$name_categoria?>">	
		<input type="hidden" name="name_subcategoria"  value="<?=$name_subcategoria?>">	
		<input type="hidden" name="name_subcategorias" value="<?=$name_subcategorias?>"> 

    </tr>
    <tr bgcolor="000099" class="titular1">
        <td width="262" align="left" bgcolor="000099" class="titular1">
		  <div align="center"><a href="javascript:SortRows(t,0)" title="Ordenar Alfabeticamente" class="titular1"> 
            Category</a> </div></td>
		<td width="100" align="center" valign="middle" class="titular1"> Permission</td>
        <td width="122" align="center" class="titular1">
		<div align="center"> Quantity </div>		</td>
        <td width="100" align="center" class="titular1">Selection</td>
    </tr>
   <?
 	
	$id_usuario=$panel->usuario->id;		
    if($panel->usuario->tipo==1 || $panel->usuario->tipo==2){
		$admin=1;
	}

	if($panel->usuario->tipo==3){
		
		if($panel->aplicativo->existeVinculo($id_usuario, 12, 1))
		{
			$admin=1;
		}else
		{
			$admin=0;
		}
	} 
	$idcat = $id_;
	if($nivel == 2) $idcat = $ids;
	if($nivel == 3) $idcat = $idss;
	if($nivel == 0) $idcat = 0;
	if(! $permiso ) $permiso = 'no establecido';

	$id_usuario = $panel->usuario->id;
	$adm = $panel->aplicativo->usuarioEsAdministrador($id_usuario);
	$mod = $panel->aplicativo->accionPermitida($id_usuario, 'modificar');
	$del = $panel->aplicativo->accionPermitida($id_usuario, 'eliminar');
	$add = $panel->aplicativo->accionPermitida($id_usuario, 'adicionar');

	$arr = $panel->aplicativo->listarCategoria($idcat, 0, $ini_line, $permiso, $id_usuario, $admin);
	
	$valdoc = $arr[3];
	$doc = $arr[1];
	$sub = $arr[2];

		?>
		<script>
		<? print($arr[4]); ?>
		</script>
    
    <tr bgcolor="000099">
        <td colspan="4" align="right" class="filatitulo">&nbsp;</td>
      </tr>
    <tr>
      <td class="filatitulo" colspan="4" align="right">&nbsp;</td>
    </tr>
    <tr>
        <td width="262" valign="top">
		<? 
		if($nivel == 2 && $sub == 0){
			if($panel->usuario->tipo==1 || $panel->usuario->tipo==2){
				echo '<input class="boton1" name="button" type="button" onClick="fncAddCategoria()" value="Add Category">';
			}
		
			if($panel->usuario->tipo==3){
				if($adm){
					echo '<input name="button" class="boton1" type="button" onClick="fncAddCategoria()" value="Add Category">';
				}else{
					if($add){
						echo '<input name="button" type="button" class="boton1" onClick="fncAddCategoria()" value="Add Category">';
					}				
				}
			}
		}
		?>		</td>
		<td width="100" align="center" bordercolor="#ECE9D8">&nbsp;</td>
        <td colspan="2" align="right">
		<? 
		if($sub == 0){
			if($panel->usuario->tipo==1 || $panel->usuario->tipo==2){
				echo '<input type="button" onClick="fncModificar()"  class="boton1" name="Editar" value="Change" style="width: 70">';
			}
		
			if($panel->usuario->tipo==3){
				if($adm){
					echo '<input class="boton1" type="button" onClick="fncModificar()" name="Editar" value="Change" style="width: 70">';
				}else{
					if($mod){
						echo '<input  class="boton1" type="button" onClick="fncModificar()" name="Editar" value="Change" style="width: 70">';
					}				
				}
			}
			?>
			  <? 
			if($panel->usuario->tipo==1 || $panel->usuario->tipo==2){
				echo '<input name="button2" class="boton1" type="button" onClick="fncEliminar()" value="Delete" style="width: 70">';
			}
		
			if($panel->usuario->tipo==3){
				if($adm){
					echo '<input name="button2" class="boton1" type="button" onClick="fncEliminar()" value="Delete" style="width: 70">';
				}else{
					if($del){
						echo '<input name="button2" type="button" class="boton1" onClick="fncEliminar()" value="Delete" style="width: 70">';
					}				
				}
			}
		}
		?>        </td>
    </tr>
	<tr>
	    <td colspan="4"> Categories: 
          <?	
        echo "<B>".$sub."</B>";
        ?>
          <input type="hidden" name="cant" value="<?=$sub?>">
		<br>
          Products: 
          <?
        echo "<B>".$doc."</B>";
        ?>
          <iframe src="" name="_fraUsr" id="_fraUsr" height="0" frameborder="0"></iframe>		
		</td>
	  </tr>
</form>
	<tr align="center" valign="top">
	  <td colspan="4">
      <form name="form2">
        <div align="center">
          <? $num_paginas = $panel->paginas($sub); ?>
          	<img src="img/inicio1.gif" width="20" height="20" title="Inicio" <? if($ini_line - 1 >= 1 ) echo " onClick=\"document.location.href = 'index.php?ini_line=".(1)."'\"";?>>
			&nbsp;
          	<img src="img/atras1.gif" width="20" height="20" title="Atras" <? if($ini_line - 1 >= 1 ) echo " onClick=\"document.location.href = 'index.php?ini_line=".($ini_line - 1)."'\"";?>>
			&nbsp;
			<span class="usuario">pg 
			<? if($num_paginas == 0) echo "0";else echo $ini_line;?> 
			Of <? echo $num_paginas;?></span>&nbsp;
  
          	<img src="img/adelante1.gif" width="20" height="20" title="Siguiente"  <? if($ini_line + 1 <= $num_paginas ) echo " onClick=\"document.location.href = 'index.php?ini_line=".($ini_line + 1)."'\"";?>>
			&nbsp;
          	<img src="img/ultimo1.gif" width="20" height="20" title="Ultimo" <? if($ini_line + 1 <= $num_paginas ) echo " onClick=\"document.location.href = 'index.php?ini_line=".($num_paginas)."'\"";?>>        </div>
    </form>	  </td>
    </tr>
</table>
</center>