<?php
include_once("common.php");
require_once("Config.php");
require_once("DB.php");
require_once("ecMisc.php");
require_once("ecAPP.php");
require_once("HTML/Template/Flexy.php");
require_once("ecValidator.php");
require_once("ecValidator/fileupload.php");
require_once("ecAuth.php");
require_once("ecAuth/db.php");

$app = new ecAPP($config);
$options = array(
'templateDir'    => $app->settings["ecAPI"]["TEMPLATE_DIR"],
'compileDir'    => $app->settings["ecAPI"]["COMPILE_DIR"]
);

$tpl=new tpl();

$require_login = array("proveedor");
include("auth.php");


$tpl->proveedor = $app->readRecord("PROVEEDORES"," email___pro = '".$app->quotesql($_SESSION["userid"])."' ");


// Regiones Disponibles 
$query = $app->do_query("SELECT * FROM regiones ORDER BY ORDEN___REG ASC");
while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
{
	if ( $_REQUEST["region"] == $reg["ID______REG"] )
		$reg["SEL"] = true;
	$tpl->regiones[] = $reg;
}

$query = $app->do_query("SELECT * FROM comunas ORDER BY NOMBRE__COM ASC");
while( $reg = $query->fetchRow(DB_FETCHMODE_ASSOC) )
{
	if ( $_REQUEST["comuna"] == $reg["ID______COM"] )
	{
		$reg["SEL"] = true;
	}
	$tpl->comunas[] = $reg;
}


if($_REQUEST["guardar"]) {
	switch($_REQUEST["tab"]) {
	case 2:
		$hash = array(
		"WEB_____PRO" => strtolower(trim($_REQUEST["url"])),
		"EMAIL___PRO" => strtolower(trim($_REQUEST["email"])),
		"DIRECCIOPRO" => $_REQUEST["direccion"],
		"CONTACTOPRO" => $_REQUEST["contacto"],
		"FONO____PRO" => $_REQUEST["fono"],
		"FONO2___PRO" => $_REQUEST["2fono"],
		"FONO3___PRO" => $_REQUEST["3fono"],
		"FONO4___PRO" => $_REQUEST["4fono"],
		"CODIGO__PRO" => $_REQUEST["codigo"],
		"CELULAR_PRO" => $_REQUEST["celular"],
		"PASSWORDPRO" => strtolower(trim($_REQUEST["password"])),
		"REGION__PRO" => $_REQUEST["region"] ,
		"COMUNA__PRO" => $_REQUEST["comuna"] ,
		);

		$app->updateRecord("PROVEEDORES", $hash, "EMAIL___PRO='" . $app->quotesql($_SESSION["userid"]) . "'"); 
		break;
	case '3':
		if($_REQUEST["principal"]) {
			$qid = $app->initReadLoop("PRODUCTOS", "PROVEEDOPRD='" . $app->quotesql($yo["ID______PRO"]) . "'", "ORDEN___PRD ASC, NOMBRE__PRD ASC");
			$nwo = array();
			$orden = 2;
			while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {
				if($_REQUEST["principal"] == $row["ID______PRD"]) {
					$row["ORDEN___PRD"] = 1;
				} else {
					$row["ORDEN___PRD"] = $orden ++;
				}
				$nwo[$row["ID______PRD"]] = $row["ORDEN___PRD"];
			}
			foreach($nwo as $k => $v) {
				$app->updateRecord("PRODUCTOS", array("ORDEN___PRD" => $v), "ID______PRD='" . $app->quotesql($k) . "'");
			}
		}
		break;
	default:
		$val = new ecValidator_fileupload();
		$val->validate("logotienda", $_FILES);
		$hash = array(
		"DESCRIPCPRO" => $_REQUEST["desctienda"],
		);
		if($_FILES["logotienda"]) {
			$hash["IMAGEN__PRO"] = $_FILES["logotienda"];
			$hash["IMAGEN__PRO_NAME"] = $_FILES["logotienda_NAME"];
			$hash["IMAGEN__PRO_MIME"] = $_FILES["logotienda_MIME"];
		}
		$app->updateRecord("PROVEEDORES", $hash, "EMAIL___PRO='" . $app->quotesql($_SESSION["userid"]) . "'"); 
		break;
	}
}

$yo = $app->readRecord("PROVEEDORES", "EMAIL___PRO='" . $app->quotesql($_SESSION["userid"]) . "'");
if ( is_array( $yo  )  )
foreach($yo as $k => $v)
{
	$tpl->{$k} = $v;
	if ( $k == "REGION__PRO"  )
	{
		foreach( $tpl->regiones as $kk => $vv )
		{
			if (  $tpl->regiones[ $kk ]["ID______REG"] == $v   )
				$tpl->regiones[ $kk ]["SEL"] = true;
		}
	}
	if ( $k == "COMUNA__PRO"  )
	{
		foreach( $tpl->comunas as $kk => $vv )
		{
			if (  $tpl->comunas[ $kk ]["ID______COM"] == $v   )
				$tpl->comunas[ $kk ]["SEL"] = true;
		}
	}

}

if($_POST["eliminar"])
{
	
//print_r($_POST["viewSelectedRows"]);	
	
foreach( $_POST["viewSelectedRows"] as $v ){
	
	//echo $v."<br/>";

			$hash = array(
			"ACTIVOC_COT" => "S",

			);

		$app->updateRecord("COTIZACIONES", $hash, "ID______COT='".$v."' and PROVEEDOCOT='" . $app->quotesql($yo["ID______PRO"]) . "'"); 
	
}


}


if(!($tab = $_REQUEST["newtab"])) {
	$tab = $_REQUEST["tab"];
}

if($tab == 3) {
	$qid = $app->initReadLoop("PRODUCTOS", "PROVEEDOPRD='" . $app->quotesql($yo["ID______PRO"]) . "' AND owner___prd = 'usuario' ", "ORDEN___PRD ASC, NOMBRE__PRD ASC");
	$odd = 0;
	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {
		$row["odd"] = ($odd % 2) ? " class=\"odd\"" : "";
		if(!$odd) {
			$row["principal"] = "checked";
		}
		$tpl->productos[] = $row;
		$odd++;
	}
}

if($tab == 4) {
	$qid = $app->initReadLoop("NOTICIAS", "PROVEEDONOT='" . $app->quotesql($yo["ID______PRO"]) . "'", "FECHAHORNOT DESC");
	$odd = 1;
	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {
		$row["odd"] = $odd ? " class=\"odd\"" : "";
		$tpl->noticias[] = $row;
		$odd = !$odd;
	}
}

if($tab == 5) {
	$filtro = "";
	if(!$_REQUEST["todas"]) {
		$filtro = " AND RESPONDICOT='N'";
	}
	$tpl->todas = $_REQUEST["todas"];
	$qid = $app->initReadLoop("COTIZACIONES,INSCRITOS,PROVEEDORES", " ocultaprcot = 'N' AND proveedocot = ID______PRO AND INSCRITOCOT=ID______INS AND  activoc_cot IN ( 'N',NULL ) AND  proveedocot='" . $app->quotesql($yo["ID______PRO"]) . "' $filtro", "FECHAHORCOT DESC");
	$odd = 1;
	

	while($row = $qid->fetchRow(DB_FETCHMODE_ASSOC)) {
		$row["odd"] = $odd ? " class=\"odd\"" : "";
		if ( strlen(trim($row["CUERRESPCOT"])) > 0  )
			$row["RESPONDIDA"] = true;
		$tpl->cotizaciones[] = $row;
		$odd = !$odd;
	}
}


$output = new HTML_Template_Flexy($options);
switch($tab) {
case 2:
case 3:
case 4:
case 5:
	$template = "admprov".$tab."beta.html";
	break;
case 6:

	if ( $_FILES["VIDEO"] )
	{		
		if (  is_file( $_FILES["VIDEO"]["tmp_name"] )  )
		{
			if (  $_FILES["VIDEO"]["size"] <= 10485760  )
			{
				$video_location = $app->settings["ecAPI"]["UPLOAD_DIR"]."/".$tpl->proveedor["ID______PRO"]."_".rand(1000,9999)."_".".flv";
				
				$fname = explode(".", trim( strtolower( $_FILES["VIDEO"]["name"] ) ) );
				
				if (  $fname[ count( $fname ) -1  ] != "flv"  ) 
				{
					$tpl->error = "El Video no tiene extensi&oacute;n flv.";
				}
				else
				{
					if ( is_file( $app->settings["ecAPI"]["UPLOAD_DIR"]."/".$tpl->proveedor["VIDEO___PRO"]  ) )
					{
							@unlink( $app->settings["ecAPI"]["UPLOAD_DIR"]."/".$tpl->proveedor["VIDEO___PRO"]  );
					}
					
					
					@copy( $_FILES["VIDEO"]["tmp_name"] , $video_location  );
				
					$app->updateRecord("PROVEEDORES", array( "VIDEO___PRO" =>  basename( $video_location ) , "VIDEO___PRO_NAME" => basename( $video_location ) , "VIDEO___PRO_MIME"  => $_FILES["VIDEO"]["type"] ) , "  ID______PRO = '".(int) $tpl->proveedor["ID______PRO"] ."'  " );
					
					$tpl->proveedor["VIDEO___PRO"] = basename( $video_location );
				
					
				}
				
			}
			else
			{
				$tpl->error = "El Video tiene un peso superior a los 10Mb.";
			}
		}
		
	}


	$template = "admprov6.html";
	break;	
	
default:
	$template = "admprov.html";
	break;
}

$tpl->TITLE = "Panel Proveedor";
$tpl->DESCRIPTION = "Panel Proveedor.";

$output->compile($template);
$tpl->CONTENT=$output->bufferedOutputObject($tpl);

include("container.php");
?>