header('Content-type: text/html; charset=utf-8');
//
include("checksession.php");
include("antei.inc.php");
session_start();
$db = ADONewConnection("$db_tipo");
$db->Connect("$db_host", "$db_login", "$db_pass", "$database", 'sessions');
$idsubcat = $_GET['idsubcat'];
$idcat = $_GET['idcat'];
$name = $_GET['name'];
$id = $_GET['id'];
if(trim($idsubcat)=='') $idsubcat=0;
// Tramite id prodotti prendo id categoria e id sottocategoria
$idprodotto = $_GET['id'];
// T02_UKN T02_CATEGORY T02_PRODUCT_ID
#echo "IDPROD".$idprodotto."
";
// Andiamo a prendere la sotto-categoria di riferimento del prodotto
$rs_subcat = $db->Execute("Select T02_CATEGORY from T02_PRODUCT where T02_UKN = ".$idprodotto."");
$idc2 = $rs_subcat->fields['T02_CATEGORY'];
#echo "SUBCAT".$idc2."
";
// ora prendiamo la categoria principale
$rs_subcat2 = $db->Execute("Select T01_PRIMARY_CATEGORY from T01_PRODUCT_SUBCATEGORY where T01_UKN = ".$idc2."");
$idc = $rs_subcat2->fields['T01_PRIMARY_CATEGORY'];
#echo "CATPRINC".$idc."
";
//$idc = $_GET['idcat'];
//$idc2 = $_GET['idsubcat'];
$rs0 = $db->Execute("select * from T01_PRODUCT_CATEGORY
where T01_UKN = ".$idc."");
$T01_DESCR_CAT = $rs0->fields[2];
$rs1 = $db->Execute("select * from T01_PRODUCT_SUBCATEGORY
where T01_UKN = ".$idc2." order by T01_DESCR");
$T01_DESCR_CAT_2 = $rs1->fields[2];
$rs = $db->Execute("SELECT *
FROM T02_PRODUCT where T02_UKN = $id");
$T02_UKN = $rs->fields[0];
$T02_PRODUCT_ID = $rs->fields[2];
$T02_CATEGORY = $rs->fields[1];
$T02_NAME = $rs->fields[3];
$T02_DESCR = $rs->fields[4];
$T02_PRICE_DB = $rs->fields[$listinopers];
$T02_PRICE = number_format($T02_PRICE_DB,2,',', '.');
$T02_ONSTOCK = $rs->fields[7];
$FILEZ = $rs->fields[18];
$T02_HR_PICTURE = $rs->fields[11];
$T02_IVA = $rs->fields[26];
if($T02_HR_PICTURE =='') $T02_HR_PICTURE = 'neutro.gif';
if($T02_ONSTOCK=='1') $T02_ONSTOCK = 'Prodotto disponibile' ;
else $T02_ONSTOCK = "Prodotto momentaneamente non disponibile";
$rsc = $db->Execute("SELECT *
FROM T01_PRODUCT_SUBCATEGORY where T01_UKN = $T02_CATEGORY");
$T01_DESCRIZ = $rsc->fields[2];
$rs41 = $db->Execute("SELECT *
FROM T02_PRODUCT where T02_CATEGORY = ".$_GET['$idcat']." and T02_UKN=$id");
$subcateg1=$rs41->fields[1];
$rs42 = $db->Execute("SELECT T01_DESCR,T01_PRIMARY_CATEGORY
FROM T01_PRODUCT_SUBCATEGORY where T01_UKN=$subcateg1");
$subcateg=$rs42->fields[0];
$categ1=$rs42->fields[1];
$rs40 = $db->Execute("SELECT *
FROM T01_PRODUCT_CATEGORY where T01_UKN = $categ1");
$categ=$rs40->fields[2];
?>