function __construct($data, $formating)
{
$this->id = $data['id'];
$this->price = round($data['prix_vente'], 0);
$this->millesime = $data['millesime'];
$this->bio = $data['bio'];
$this->producteur = $data['producteur'];
$this->product_name = $data['nom'];
$this->appelation = $data['appelation'];
$this->cat_vin = $data['id_cat_vin'];
$this->region_du_monde = $data['id_region_du_monde'];
$this->pays = $data['id_pays'];
$this->region = $data['id_region'];
$this->sous_region = $data['id_sous_region'];
$this->defaultLabel = format_wine_label($data['id'], $formating, $data['id_region_du_monde'], $data['id_cat_vin']);
if ($data['label']) {
$this->label = $data['label'];
}
}
function print_demi_bouteilles($id)
{
global $mysql;
$sql = "SELECT \r\n\t\t\t\t\t\tv_list_vins.id_produit_vin as id_produit_vin,\r\n\t\t\t\t\t\tv_list_vins.id_produit as id,\r\n\t\t\t\t\t\tv_list_vins.prix_vente as prix_vente,\r\n\t\t\t\t\t \tv_list_vins.millesime as millesime,\r\n\t\t\t\t\t \tv_list_vins.producteur as producteur,\r\n\t\t\t\t\t \tv_list_vins.nom as nom,\r\n\t\t\t\t\t \tv_list_vins.appelation as appelation,\r\n\t\t\t\t\t\tv_list_vins.demi_bouteille as demi_bouteille,\r\n\t\t\t\t\t\tv_list_vins.id_cat_vin as id_cat_vin,\r\n\t\t\t\t\t\tv_list_vins.id_region_du_monde as id_region_du_monde,\r\n\t\t\t\t\t\tv_list_vins.id_pays as id_pays,\r\n\t\t\t\t\t\tv_list_vins.id_region as id_region,\r\n\t\t\t\t\t\tv_list_vins.id_sous_region as id_sous_region,\r\n\r\n\t\t\t\t\t\tt_output_vins.id_produit as output_id_produit,\r\n\t\t\t\t\t\tt_output_vins.type as type,\r\n\t\t\t\t\t\tt_output_vins.label as label\r\n\r\n\t\t\t\t\t\tFROM v_list_vins \r\n\t\t\t\t\t\tINNER JOIN t_output_vins ON v_list_vins.id_produit = t_output_vins.id_produit\r\n\t\t\t\t\t\tWHERE v_list_vins.id_cat_vin = {$id}\r\n\t\t\t\t\t\tAND t_output_vins.type = 'demi-bouteille'\r\n\t\t\t\t\t\tORDER BY v_list_vins.prix_vente ASC";
$query = $mysql->sql_query($sql);
$html = '';
if ($query && mysqli_num_rows($query) > 0) {
$html .= '<div><h2>Demi-bouteilles</h2>';
$html .= '<ul>';
while ($result = mysqli_fetch_assoc($query)) {
$id = $result["id_produit_vin"];
$price = number_format($result["prix_vente"], 0);
if ($result['label'] == '') {
$label = format_wine_label($result['output_id_produit'], 'rich', $result['id_region_du_monde'], $result['id_cat_vin']);
} else {
$label = format_wine_label_custom($result['label']);
}
$html .= "<li class='vin' data-id='{$id}'><span class='price'>{$price}</span> {$label}</li>";
}
$html .= '</ul>';
$html .= '</div>';
}
return $html;
}
function print_demi_bouteilles($id)
{
global $mysql;
$sql = "SELECT \n\t\t\t\t\t\tv_list_vins.id_produit_vin as id_produit_vin,\n\t\t\t\t\t\tv_list_vins.id_produit as id,\n\t\t\t\t\t\tv_list_vins.prix_vente as prix_vente,\n\t\t\t\t\t \tv_list_vins.millesime as millesime,\n\t\t\t\t\t \tv_list_vins.producteur as producteur,\n\t\t\t\t\t \tv_list_vins.nom as nom,\n\t\t\t\t\t \tv_list_vins.appelation as appelation,\n\t\t\t\t\t\tv_list_vins.demi_bouteille as demi_bouteille,\n\t\t\t\t\t\tv_list_vins.id_cat_vin as id_cat_vin,\n\t\t\t\t\t\tv_list_vins.id_region_du_monde as id_region_du_monde,\n\t\t\t\t\t\tv_list_vins.id_pays as id_pays,\n\t\t\t\t\t\tv_list_vins.id_region as id_region,\n\t\t\t\t\t\tv_list_vins.id_sous_region as id_sous_region,\n\n\t\t\t\t\t\tt_output_vins_admin.id_produit as output_id_produit,\n\t\t\t\t\t\tt_output_vins_admin.type as type,\n\t\t\t\t\t\tt_output_vins_admin.label as label\n\n\t\t\t\t\t\tFROM v_list_vins \n\t\t\t\t\t\tINNER JOIN t_output_vins_admin ON v_list_vins.id_produit = t_output_vins_admin.id_produit\n\t\t\t\t\t\tWHERE v_list_vins.id_cat_vin = {$id}\n\t\t\t\t\t\tAND t_output_vins_admin.type = 'demi-bouteille'\n\t\t\t\t\t\tORDER BY v_list_vins.prix_vente ASC\n\t\t\t\t\t\t";
$query = $mysql->sql_query($sql);
$html = '';
if ($query && mysqli_num_rows($query) > 0) {
$html .= start_table();
$html .= '<tr><th class="h3" class="title" colspan="2">Demi-bouteilles</th></tr>';
while ($result = mysqli_fetch_assoc($query)) {
if ($result['label'] == '') {
$label = format_wine_label($result['output_id_produit'], 'rich', $result['id_region_du_monde'], $result['id_cat_vin']);
} else {
$label = format_wine_label_custom($result['label']);
}
$html .= '<tr><td class="price"><span class="price">' . number_format($result['prix_vente'], 0) . '</span></td><td>' . $label . '</td></tr>';
}
$html .= end_table();
}
return $html;
}
function refresh_wine_label($id_product)
{
echo format_wine_label($id_product);
}
