catalog/model/catalog/obtendatos.php
Code: Select all
<?php
require_once('../../../config.php');
require_once(DIR_SYSTEM . 'startup.php');
$db = new DB(DB_DRIVER, DB_HOSTNAME, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
$q=$_GET["q"];
$resultado = mysql_query("SELECT * FROM product WHERE model LIKE '%" . $q . "%'");
while($row = mysql_fetch_array($resultado))
{
$special_query = mysql_query("SELECT * FROM product_special WHERE product_id LIKE '%" . $row['product_id'] . "%' AND customer_group_id LIKE '%" . $this->customer->getCustomerGroupId . "%'");
$row_s = mysql_fetch_array($special_query);
if ($row['quantity'] > 0) {
$disponible = 7;
$stock_query = mysql_query("SELECT * FROM stock_status WHERE stock_status_id LIKE '%" . $disponible . "%'");
$stock = mysql_fetch_array($stock_query);
$rstock = $stock['name'];
}
if ($row['price']) {
echo '<div class="price">';
if (!$row_s['price']) {
echo '<span>';
echo 'Precio: ';
echo '</span>';
echo $row['price'];
} else {
echo '<span>';
echo 'Precio: ';
echo '</span>';
echo '<span class="price-new">';
echo $row_s['price'];
echo '</span>';
}
echo '</div>';
}
echo '<div class="actions">';
echo '<div class="cart">';
if ($row['price']) {
echo $rstock;
echo '<br>';
}
echo 'Cantidad: ';
echo '<input type="text" name="quantity" value="" class="input-mini" id="quantity-'.$row['product_id'].'">';
if ($rstock !== "Sin disponibilidad") {
echo '<br><input id="boton" name="boton" type="button" value="Añadir a la cesta" onclick="addQtyToCart(';
echo "'";
echo $row['product_id'];
echo "'";
echo ');" class="btn btn-cart btn-small" />';
}
echo '</div>';
echo '</div>';
}
?>
$special_query = mysql_query("SELECT * FROM product_special WHERE product_id LIKE '%" . $row['product_id'] . "%' AND customer_group_id LIKE '%" . $this->customer->getCustomerGroupId . "%'");
Esto $this->customer->getCustomerGroupId no me funciona
Alguna idea como puedo hacerlo?