Proporcionamos soluciones a la industria, ofreciendo maquinarias y repuestos en stock, como así también el servicio integral de importación de todo tipo de maquinarias e insumos a pedido de terceros, coordinando las operaciones con un equipo permanente en China.
$db = new database();
/* $SQL = 'SELECT t1.nombre, t1.imagen_ch, CONCAT_WS(" / ", t2.rubro, t3.rubro) AS rubro_subrubro,
t1.id, md5(t1.id) AS idU
FROM productos t1
LEFT OUTER JOIN rubros t3 ON (t1.rubros_id = t3.id AND t3.estado = "Y" AND t3.borrado = "N")
LEFT OUTER JOIN rubros t2 ON (t3.rubros_id = t2.id AND t2.estado ="Y" AND t2.borrado = "N")
WHERE 1
AND t1.borrado = "N"
AND t1.estado = "Y"
AND t1.destacado = "Y"
ORDER BY t1.orden, t1.destacado, t1.id
LIMIT 6';
*/
$SQL = 'SELECT t1.nombre, t1.imagen_ch, t3.rubro AS subrubro, t2.rubro AS rubro, t3.borrado as borra_sub, t3.estado as esta_sub, t2.borrado as borra_rub, t2.estado as esta_rub, t3.id,
md5(t1.id) AS idU, t1.id
FROM productos t1
LEFT OUTER JOIN rubros t3 ON (t1.rubros_id = t3.id)
LEFT OUTER JOIN rubros t2 ON (t2.id = t3.rubros_id)
WHERE 1
AND t1.borrado = "N"
AND t1.estado = "Y"
AND t1.destacado = "Y"
AND (t3.estado = "Y" or t3.estado IS NULL)
AND (t2.estado = "Y" or t2.estado IS NULL)
ORDER BY t1.orden, t1.destacado, t1.id DESC
LIMIT 6';
$rs = $db->db_query($SQL);
$f = $db->db_fetch_assoc($rs);
if($f){?>
do{?>
if(is_null($f['rubro']) && is_null($f['subrubro'])){
$link = 'repuestos';
}else{
$link = 'maquinaria';
}?>
if($f['imagen_ch']){?>

}else{?>

}?>
Notice: Undefined variable: f in /home/fullmaq/public_html/index.php on line 148
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/index.php on line 148
if(is_null($f['rubro']) && is_null($f['subrubro'])){?>
Repuesto
}else{?>
Notice: Undefined variable: f in /home/fullmaq/public_html/index.php on line 152
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/index.php on line 152
/
Notice: Undefined variable: f in /home/fullmaq/public_html/index.php on line 152
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/index.php on line 152
}?>
}while($f = $db->db_fetch_assoc($rs));?>
} ?>
$db = new database();
$SQL = "SELECT t1.rubro AS subRubro, t2.rubro, t2.id, t3.id AS idSubRubro, md5(t1.id) AS idU,
md5(t4.id) AS idSeccion, t4.seccion
FROM rubros t1
INNER JOIN rubros t2 ON (t1.rubros_id = t2.id AND t2.estado ='Y' AND t2.borrado ='N' )
INNER JOIN productos t3 ON (t1.id = t3.rubros_id)
INNER JOIN secciones t4 ON (t3.secciones_id = t4.id)
WHERE 1
AND t1.estado = 'Y'
AND t1.borrado = 'N'
GROUP BY t1.rubro
ORDER BY t1.rubro
;";
$rs = $db->db_query($SQL);
$f = $db->db_fetch_assoc($rs);
if($f){
$rubro = NULL;
?>
RUBROS
do{?>
if($rubro != $f['id']){?>
if($rubro != NULL){?>
}?>
Notice: Undefined variable: f in /home/fullmaq/public_html/includes/inc-col-der.php on line 33
Notice: Trying to access array offset on value of type null in /home/fullmaq/public_html/includes/inc-col-der.php on line 33
}?>