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); }