<div id="layout">
<input type="checkbox" id="menu-trigger">
<div id="off-screen-menu">
<nav id="main-nav">
<ul class="flat-list">
<li>
<a href="../preview/dashboard.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#dashboard" />
</svg>
Dashboard
</a>
</li>
<li>
<a href="../preview/account-settings.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#settings" />
</svg>
Account settings
</a>
</li>
<li>
<a href="../preview/suppliers.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#package" />
</svg>
Suppliers
</a>
</li>
<li>
<a href="../preview/new-wine.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#upload" />
</svg>
Add wines
</a>
</li>
<li>
<a href="../preview/my-wine-cellar.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#view-list" />
</svg>
My wine cellar
</a>
</li>
<li>
<a href="../preview/wine-cellar-inventory.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#inventory" />
</svg>
Wine cellar inventory
</a>
</li>
<li>
<a href="../preview/add-dishes.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#dish" />
</svg>
Dishes
</a>
</li>
<li>
<a href="../preview/orders.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#clipboard-check" />
</svg>
Orders
</a>
</li>
<li>
<a href="../preview/digital-sommelier.html">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#sommelier" />
</svg>
Digital Sommelier
</a>
</li>
<li>
<a href="../preview/login.html" class="logout">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#logout" />
</svg>
Log out
</a>
</li>
</ul>
</nav>
<div class="lang-selector">
<label for="lang-trigger">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#flag-gb" />
</svg>
English
</label>
<input type="checkbox" id="lang-trigger">
<ul class="flat-list lang-list">
<li>
<a href="#">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#flag-se" />
</svg>
Svenska
</a>
</li>
<li>
<a href="#">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#flag-no" />
</svg>
Norsk
</a>
</li>
<li>
<a href="#">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#flag-dk" />
</svg>
Dansk
</a>
</li>
<li>
<a href="#">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#flag-de" />
</svg>
Deutsch
</a>
</li>
<li>
<a href="#">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#flag-fr" />
</svg>
Français
</a>
</li>
</ul>
</div>
</div>
<header id="header">
<div class="header-content">
<p class="main-title">
<a href="../preview/dashboard.html" class="block-link"><svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#logo-badge" />
</svg>
Fine Wine Club</a>
</p>
</div>
<div class="header-content">
<div class="shopping-list-wrapper">
<label for="shopping-list-trigger">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#clipboard-list" />
</svg>
<span class="trigger-label">Shopping list</span>
<span class="list-counter">3</span>
</label>
<input id="shopping-list-trigger" type="checkbox">
<div class="shopping-list">
<form action="#" method="post">
<div class="shopping-list-content">
<table class="shopping-list-table">
<thead>
<tr>
<th scope="col">Producer</th>
<th scope="col">Wine</th>
<th scope="col">Vintage</th>
<th scope="col"><span class="at-only">Remove</span></th>
</tr>
</thead>
<tbody>
<tr>
<td>Chateu Pontet-Canet</td>
<td>Chateu Pontet-Canet</td>
<td>2010</td>
<td><button type="button" class="size-xs alt" aria-label="Remove wine">
<span>
<svg class="icon size-xs alt" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#delete" />
</svg>
</span>
</button>
</td>
</tr>
<tr>
<td>Aalto</td>
<td>PS</td>
<td>2015</td>
<td><button type="button" class="size-xs alt" aria-label="Remove wine">
<span>
<svg class="icon size-xs alt" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#delete" />
</svg>
</span>
</button>
</td>
</tr>
<tr>
<td>Roederer</td>
<td>Cristal</td>
<td>2009</td>
<td><button type="button" class="size-xs alt" aria-label="Remove wine">
<span>
<svg class="icon size-xs alt" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#delete" />
</svg>
</span>
</button>
</td>
</tr>
</tbody>
</table>
<div class="submit-area ">
<button type="button" data-prototype-url="../preview/orders.html">
<span>
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#clipboard-add" />
</svg>
<span>Create purchase orders</span>
</span>
</button>
</div>
</div>
</form>
</div>
</div>
<label for="menu-trigger">
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#menu" />
</svg>
Menu
</label>
</div>
</header>
<main id="main-content">
<h1>Overview</h1>
<div class="dash-grid">
<div class="status-message status-warning">
<h3 class="status-message-title">Drastic price change</h3>
<p>The following wines have been updated:</p>
<ul>
<li><a href="../preview/product-page.html">Trapiche Sauvignon Blanc</a></li>
<li><a href="../preview/product-page.html">Achaval Ferrer Finca Mirador</a></li>
<li><a href="../preview/product-page.html">Trapiche Pinot Noir</a></li>
</ul>
<svg class="icon info-icon" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#status-warning" />
</svg>
<button type="warning" class="close-button">
<span>
<svg class="icon close-button" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#close" />
</svg>
<span></span>
</span>
</button>
</div>
<div class="status-message status-info">
<h3 class="status-message-title">Drinkability updates</h3>
<p>Drinkability has changed for the following wines:</p>
<ul>
<li><a href="../preview/product-page.html">Citeaux Meursault Limozin</a></li>
</ul>
<svg class="icon info-icon" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#status-info" />
</svg>
<button type="info" class="close-button">
<span>
<svg class="icon close-button" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#close" />
</svg>
<span></span>
</span>
</button>
</div>
<div class="status-message status-info">
<h3 class="status-message-title">Ratings updates</h3>
<p>Ratings have changed for the following wines:</p>
<ul>
<li><a href="../preview/product-page.html">Hugel Riesling VT</a></li>
<li><a href="../preview/product-page.html">Bertrand Ambroise Clos Vougeot</a></li>
</ul>
<svg class="icon info-icon" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#status-info" />
</svg>
<button type="info" class="close-button">
<span>
<svg class="icon close-button" height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#close" />
</svg>
<span></span>
</span>
</button>
</div>
</div>
<h2>Reports</h2>
<div class="dash-grid">
<div class="card ">
<h3>Total wine sales</h3>
<div class="scrollable-table">
<table class="dashboard-table">
<thead>
<tr>
<th scope="col"></th>
<th scope="col" class="num">April</th>
<th scope="col" class="num">May</th>
<th scope="col" class="num">June</th>
</tr>
</thead>
<tbody>
<tr>
<th scope="row">Bottles sold</th>
<td class="num">480</td>
<td class="num">645</td>
<td class="num">860</td>
</tr>
<tr>
<th scope="row">Turnover</th>
<td class="num">240 000</td>
<td class="num">358 000</td>
<td class="num">516 000</td>
</tr>
<tr>
<th scope="row">Average bottle price ex VAT</th>
<td class="num">500</td>
<td class="num">555</td>
<td class="num">600</td>
</tr>
<tr>
<th scope="row">Gross margin</th>
<td class="num">500</td>
<td class="num">555</td>
<td class="num">600</td>
</tr>
<tr>
<th scope="row">Gross margin %</th>
<td class="num">67%</td>
<td class="num">63%</td>
<td class="num">60%</td>
</tr>
<tr>
<th scope="row">Wine profit</th>
<td class="num">160 800</td>
<td class="num">225 540</td>
<td class="num">309 600</td>
</tr>
</tbody>
</table>
</div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>App profitability</h3>
<div class="scrollable-table">
<table class="dashboard-table">
<thead>
<tr>
<th scope="col"></th>
<th scope="col" class="num">April</th>
<th scope="col" class="num">May</th>
<th scope="col" class="num">June</th>
</tr>
</thead>
<tbody>
<tr>
<th scope="row">App used</th>
<td class="num">65</td>
<td class="num">220</td>
<td class="num">450</td>
</tr>
<tr>
<th scope="row">Wine profit</th>
<td class="num">19 856</td>
<td class="num">112 000</td>
<td class="num">287 000</td>
</tr>
<tr>
<th scope="row">Average profit</th>
<td class="num">305</td>
<td class="num">509</td>
<td class="num">638</td>
</tr>
</tbody>
</table>
</div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Best sellers</h3>
<div class="scrollable-table">
<table class="dashboard-table">
<thead>
<tr>
<th scope="col" class="num">Nr</th>
<th scope="col">Wine</th>
<th scope="col" class="num">Bottles sold</th>
<th scope="col" class="num"><abbr title="Gross margin">GM</abbr> total</th>
</tr>
</thead>
<tbody>
<tr>
<td class="num">1</td>
<td>Guigal Cotes du Rhone 2017</td>
<td class="num">216</td>
<td class="num">54 000</td>
</tr>
<tr>
<td class="num">2</td>
<td>Aalto, Aalto 2016</td>
<td class="num">164</td>
<td class="num">49 200</td>
</tr>
<tr>
<td class="num">3</td>
<td>Hamilton Russell Chardonnay 2015</td>
<td class="num">112</td>
<td class="num">29 680</td>
</tr>
<tr>
<td class="num">4</td>
<td>Jeff Carrel Les Darons 2017</td>
<td class="num">84</td>
<td class="num">19 320</td>
</tr>
<tr>
<td class="num">5</td>
<td>Zind-Humbrecht Riesling 2015</td>
<td class="num">65</td>
<td class="num">19 370</td>
</tr>
</tbody>
</table>
</div>
<div class="action-bar">
<button type="button" class="size-xs alt">
<span>
<span>Show all</span>
</span>
</button>
</div>
<p><label for="">Show best sellers since</label>
<select id="" name="" class="">
<option value="option-0">All time</option>
<option value="option-1">Last month</option>
<option value="option-2">Last quarter</option>
<option value="option-3">Last year</option>
</select>
</p>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
</div>
<h2>Wine cellar</h2>
<div class="dash-grid">
<div class="card ">
<h3>Wines by country</h3>
<div class="chart-container" id="chart-wines-by-country"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Styles</h3>
<div class="chart-container" id="chart-wine-styles"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Drinkability</h3>
<div class="chart-container" id="chart-drinkability"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Wine list price</h3>
<div class="chart-container" id="chart-wine-list-price"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
</div>
<div class="simple-accordion">
<div class="simple-accordion-item">
<p class="simple-accordion-title">
<span>Show more</span>
<svg class="icon " height="20" width="20" aria-hidden="true">
<use xlink:href="../../sprite.svg#angle" />
</svg>
</p>
<div class="collapsible-content">
<div class="simple-accordion-inner-content">
<div class="dash-grid">
<div class="card ">
<h3>Suppliers</h3>
<div class="chart-container" id="chart-supplier"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Colour</h3>
<div class="chart-container" id="chart-colour"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Grape</h3>
<div class="chart-container" id="chart-grape"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Market demand</h3>
<div class="chart-container" id="chart-market-demand"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
<div class="card ">
<h3>Purchase price</h3>
<div class="chart-container" id="chart-purchase-price"></div>
<p><small><em>Data updated 2019-06-01</em></small></p>
</div>
</div>
</div>
</div>
</div>
</div>
</main>
</div>
{{#> @regular-page}}
<h1>Overview</h1>
{{#> @dash-grid notifications}}
{{#> @status-message notification-1}}
<p>The following wines have been updated:</p>
<ul>
{{#each (limit ../wines 3)}}
<li><a href="{{ path '/components/preview/product-page' }}">{{Producer}} {{WineName}}</a></li>
{{/each}}
</ul>
{{/ @status-message}}
{{#> @status-message notification-2}}
<p>Drinkability has changed for the following wines:</p>
<ul>
{{#with ../wines.[33]}}
<li><a href="{{ path '/components/preview/product-page' }}">{{Producer}} {{WineName}}</a></li>
{{/with}}
</ul>
{{/ @status-message}}
{{#> @status-message notification-3}}
<p>Ratings have changed for the following wines:</p>
<ul>
{{#with ../wines.[14]}}
<li><a href="{{ path '/components/preview/product-page' }}">{{Producer}} {{WineName}}</a></li>
{{/with}}
{{#with ../wines.[27]}}
<li><a href="{{ path '/components/preview/product-page' }}">{{Producer}} {{WineName}}</a></li>
{{/with}}
</ul>
{{/ @status-message}}
{{/ @dash-grid}}
<h2>Reports</h2>
{{#> @dash-grid}}
{{#> @card total-wine-sales}}
<h3>Total wine sales</h3>
{{#> @scrollable-table}}
<table class="dashboard-table">
<thead>
<tr>
<th scope="col"></th>
<th scope="col" class="num">April</th>
<th scope="col" class="num">May</th>
<th scope="col" class="num">June</th>
</tr>
</thead>
<tbody>
{{#each table-rows}}
<tr>
<th scope="row">{{row-header}}</th>
<td class="num">{{month-1}}</td>
<td class="num">{{month-2}}</td>
<td class="num">{{month-3}}</td>
</tr>
{{/each}}
</tbody>
</table>
{{/ @scrollable-table}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card app-profitability}}
<h3>App profitability</h3>
{{#> @scrollable-table}}
<table class="dashboard-table">
<thead>
<tr>
<th scope="col"></th>
<th scope="col" class="num">April</th>
<th scope="col" class="num">May</th>
<th scope="col" class="num">June</th>
</tr>
</thead>
<tbody>
{{#each table-rows}}
<tr>
<th scope="row">{{row-header}}</th>
<td class="num">{{month-1}}</td>
<td class="num">{{month-2}}</td>
<td class="num">{{month-3}}</td>
</tr>
{{/each}}
</tbody>
</table>
{{/ @scrollable-table}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card best-sellers}}
<h3>Best sellers</h3>
{{#> @scrollable-table}}
<table class="dashboard-table">
<thead>
<tr>
<th scope="col" class="num">Nr</th>
<th scope="col">Wine</th>
<th scope="col" class="num">Bottles sold</th>
<th scope="col" class="num"><abbr title="Gross margin">GM</abbr> total</th>
</tr>
</thead>
<tbody>
{{#each table-rows}}
<tr>
<td class="num">{{number}}</td>
<td>{{wine-name}}</td>
<td class="num">{{bottles-sold}}</td>
<td class="num">{{gm-total}}</td>
</tr>
{{/each}}
</tbody>
</table>
{{/ @scrollable-table}}
{{#> @action-bar}}
{{> @button text="Show all" modifier="size-xs alt"}}
{{/ @action-bar}}
<p>{{> @select date-ranges}}</p>
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{/ @dash-grid}}
<h2>Wine cellar</h2>
{{#> @dash-grid}}
{{#> @card}}
<h3>Wines by country</h3>
{{> @chart-container id="chart-wines-by-country"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Styles</h3>
{{> @chart-container id="chart-wine-styles"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Drinkability</h3>
{{> @chart-container id="chart-drinkability"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Wine list price</h3>
{{> @chart-container id="chart-wine-list-price"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{/ @dash-grid}}
{{#> @simple-accordion title="Show more" }}
{{#> @dash-grid}}
{{#> @card}}
<h3>Suppliers</h3>
{{> @chart-container id="chart-supplier"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Colour</h3>
{{> @chart-container id="chart-colour"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Grape</h3>
{{> @chart-container id="chart-grape"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Market demand</h3>
{{> @chart-container id="chart-market-demand"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{#> @card}}
<h3>Purchase price</h3>
{{> @chart-container id="chart-purchase-price"}}
<p><small><em>Data updated 2019-06-01</em></small></p>
{{/ @card}}
{{/ @dash-grid}}
{{/ @simple-accordion}}
{{/ @regular-page}}
{
"notifications": {
"wines": [
{
"id": 20,
"WineName": "Sauvignon Blanc",
"Producer": "Trapiche",
"Country": "Argentina",
"Region": "Bordeaux",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 22,
"ProducerId": 25,
"Vintage": 2017,
"CountryId": 1,
"RegionId": 17,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 100,
"PurchasePricePerBottle": 897,
"MarketPricePerBottle": 915
},
{
"id": 48,
"WineName": "Finca Mirador",
"Producer": "Achaval Ferrer",
"Country": "Argentina",
"Region": "Bordeaux",
"District": null,
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 46,
"ProducerId": 43,
"Vintage": 2015,
"CountryId": 1,
"RegionId": 17,
"DistrictId": null,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 28,
"PurchasePricePerBottle": 479,
"MarketPricePerBottle": 477
},
{
"id": 49,
"WineName": "Pinot Noir",
"Producer": "Trapiche",
"Country": "Argentina",
"Region": "Bordeaux",
"District": null,
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied to Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 47,
"ProducerId": 25,
"Vintage": 2016,
"CountryId": 1,
"RegionId": 17,
"DistrictId": null,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 6,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 4,
"PurchasePricePerBottle": 132,
"MarketPricePerBottle": 136
},
{
"id": 18,
"WineName": "Chardonnay",
"Producer": "Las Moras",
"Country": "Argentina",
"Region": "San Juan",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 20,
"ProducerId": 24,
"Vintage": 2016,
"CountryId": 1,
"RegionId": 222,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 86,
"PurchasePricePerBottle": 193,
"MarketPricePerBottle": 181
},
{
"id": 19,
"WineName": "Intis Chardonnay Chenin Blanc",
"Producer": "Las Moras",
"Country": "Argentina",
"Region": "San Juan",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Old",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 21,
"ProducerId": 24,
"Vintage": 2014,
"CountryId": 1,
"RegionId": 222,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 1,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 92,
"PurchasePricePerBottle": 997,
"MarketPricePerBottle": 997
},
{
"id": 51,
"WineName": "Oblique Reserve Merlot Cabernet Sauvignon",
"Producer": "Ashton Hills",
"Country": "Australia",
"Region": "South Australia",
"District": "Adelaide Hills",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 49,
"ProducerId": 45,
"Vintage": 2016,
"CountryId": 2,
"RegionId": 177,
"DistrictId": 11,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 5,
"PurchasePricePerBottle": 218,
"MarketPricePerBottle": 213
},
{
"id": 50,
"WineName": "Sorby Shiraz",
"Producer": "Tim Adams",
"Country": "Australia",
"Region": "South Australia",
"District": "Clare Valley",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 48,
"ProducerId": 44,
"Vintage": 2014,
"CountryId": 2,
"RegionId": 177,
"DistrictId": 524,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 79,
"PurchasePricePerBottle": 863,
"MarketPricePerBottle": 871
},
{
"id": 21,
"WineName": "Chardonnay",
"Producer": "Brown Brothers",
"Country": "Australia",
"Region": "Victoria",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 20,
"ProducerId": 26,
"Vintage": 2018,
"CountryId": 2,
"RegionId": 211,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 27,
"PurchasePricePerBottle": 523,
"MarketPricePerBottle": 504
},
{
"id": 22,
"WineName": "King Valley Chardonnay",
"Producer": "Brown Brothers",
"Country": "Australia",
"Region": "Victoria",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 23,
"ProducerId": 26,
"Vintage": 2018,
"CountryId": 2,
"RegionId": 211,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 11,
"PurchasePricePerBottle": 227,
"MarketPricePerBottle": 218
},
{
"id": 23,
"WineName": "Orange Muscat Flora",
"Producer": "Brown Brothers",
"Country": "Australia",
"Region": "Victoria",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Sweet",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 24,
"ProducerId": 26,
"Vintage": 2016,
"CountryId": 2,
"RegionId": 211,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 4,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 69,
"PurchasePricePerBottle": 282,
"MarketPricePerBottle": 289
},
{
"id": 24,
"WineName": "Beverford Chardonnay",
"Producer": "Buller",
"Country": "Australia",
"Region": "Victoria",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 25,
"ProducerId": 27,
"Vintage": 2014,
"CountryId": 2,
"RegionId": 211,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 52,
"PurchasePricePerBottle": 151,
"MarketPricePerBottle": 145
},
{
"id": 25,
"WineName": "Fine Old Muscat",
"Producer": "Buller",
"Country": "Australia",
"Region": "Victoria",
"District": null,
"WineColor": "White",
"WineType": "Fortified",
"WineStyle": "Medium Sweet",
"WineWeight": "Full Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 26,
"ProducerId": 27,
"Vintage": 2015,
"CountryId": 2,
"RegionId": 211,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 3,
"WineStyleId": 3,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 13,
"PurchasePricePerBottle": 617,
"MarketPricePerBottle": 609
},
{
"id": 14,
"WineName": "Riesling Jubilee",
"Producer": "Hugel",
"Country": "France",
"Region": "ALSACE",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 16,
"ProducerId": 16,
"Vintage": 2010,
"CountryId": 9,
"RegionId": 6,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 81,
"PurchasePricePerBottle": 340,
"MarketPricePerBottle": 349
},
{
"id": 15,
"WineName": "Riesling SGN",
"Producer": "Hugel",
"Country": "France",
"Region": "ALSACE",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Sweet",
"WineWeight": "Full Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 17,
"ProducerId": 16,
"Vintage": 2015,
"CountryId": 9,
"RegionId": 6,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 4,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 17,
"PurchasePricePerBottle": 596,
"MarketPricePerBottle": 576
},
{
"id": 16,
"WineName": "Riesling VT",
"Producer": "Hugel",
"Country": "France",
"Region": "ALSACE",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Medium Sweet",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 18,
"ProducerId": 16,
"Vintage": 2005,
"CountryId": 9,
"RegionId": 6,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 3,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 37,
"PurchasePricePerBottle": 833,
"MarketPricePerBottle": 818
},
{
"id": 17,
"WineName": "Tokay Pinot Gris Jubilee",
"Producer": "Hugel",
"Country": "France",
"Region": "ALSACE",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Medium Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 19,
"ProducerId": 16,
"Vintage": 2011,
"CountryId": 9,
"RegionId": 6,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 2,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 8,
"PurchasePricePerBottle": 763,
"MarketPricePerBottle": 753
},
{
"id": 57,
"WineName": "Agassac",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Haut Medoc",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 54,
"ProducerId": null,
"Vintage": 2015,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 116,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": 15,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 20,
"PurchasePricePerBottle": 551,
"MarketPricePerBottle": 544
},
{
"id": 59,
"WineName": "Allees Cantemerle",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Haut Medoc",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Old",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 56,
"ProducerId": null,
"Vintage": 1995,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 116,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 1,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 19,
"PurchasePricePerBottle": 946,
"MarketPricePerBottle": 936
},
{
"id": 60,
"WineName": "Alter Ego Palmer",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Margaux",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 57,
"ProducerId": null,
"Vintage": 2005,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 112,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 65,
"PurchasePricePerBottle": 410,
"MarketPricePerBottle": 407
},
{
"id": 62,
"WineName": "Armailhac",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Pauillac",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Late",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 59,
"ProducerId": null,
"Vintage": 2003,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 124,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 4,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 11,
"PurchasePricePerBottle": 786,
"MarketPricePerBottle": 784
},
{
"id": 26,
"WineName": "Cantelys Blanc",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Pessac Leognan",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 27,
"ProducerId": null,
"Vintage": 2009,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 117,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 11,
"PurchasePricePerBottle": 549,
"MarketPricePerBottle": 561
},
{
"id": 27,
"WineName": "Carbonnieux Blanc",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Pessac Leognan",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 28,
"ProducerId": null,
"Vintage": 2016,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 117,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": 14,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 57,
"PurchasePricePerBottle": 929,
"MarketPricePerBottle": 938
},
{
"id": 58,
"WineName": "Allary Haut Brion",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Pessac Leognan",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 55,
"ProducerId": null,
"Vintage": 2011,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 117,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 95,
"PurchasePricePerBottle": 668,
"MarketPricePerBottle": 680
},
{
"id": 61,
"WineName": "Amiral Beychevelle",
"Producer": null,
"Country": "France",
"Region": "Bordeaux",
"District": "Saint Julien",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 58,
"ProducerId": null,
"Vintage": 2007,
"CountryId": 9,
"RegionId": 17,
"DistrictId": 120,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 41,
"PurchasePricePerBottle": 611,
"MarketPricePerBottle": 629
},
{
"id": 29,
"WineName": "Beaune Clos Saint Landry",
"Producer": "Bouchard Pere et Fils",
"Country": "France",
"Region": "Burgundy",
"District": "Beaune",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 30,
"ProducerId": 29,
"Vintage": 2012,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 156,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": 13,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 1,
"PurchasePricePerBottle": 181,
"MarketPricePerBottle": 173
},
{
"id": 63,
"WineName": "Beaune St Desire",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Beaune",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 60,
"ProducerId": 50,
"Vintage": 2014,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 156,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": 13,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 38,
"PurchasePricePerBottle": 715,
"MarketPricePerBottle": 713
},
{
"id": 31,
"WineName": "Chablis Cote Lechet",
"Producer": "Daniel Dampt",
"Country": "France",
"Region": "Burgundy",
"District": "Chablis",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied to Medium Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 32,
"ProducerId": 31,
"Vintage": 2016,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 167,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 6,
"WineDesignationId": null,
"WineClassificationId": 13,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 85,
"PurchasePricePerBottle": 991,
"MarketPricePerBottle": 1008
},
{
"id": 67,
"WineName": "Clos Vougeot",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Clos Vougeot",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 64,
"ProducerId": 50,
"Vintage": 2000,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 181,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": 7,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 38,
"PurchasePricePerBottle": 595,
"MarketPricePerBottle": 599
},
{
"id": 68,
"WineName": "Corton Rouge",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Corton",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Late",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 65,
"ProducerId": 50,
"Vintage": 1998,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 162,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": 7,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 4,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 7,
"PurchasePricePerBottle": 256,
"MarketPricePerBottle": 245
},
{
"id": 69,
"WineName": "Corton Rognet",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Corton",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 66,
"ProducerId": 50,
"Vintage": 2007,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 162,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": 7,
"Alcohol": null,
"DrinkDateFrom": 2014,
"DrinkDateTo": 2021,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 47,
"PurchasePricePerBottle": 918,
"MarketPricePerBottle": 918
},
{
"id": 28,
"WineName": "Corton Charlemagne Blanc",
"Producer": "Jean-Marc Boillot",
"Country": "France",
"Region": "Burgundy",
"District": "Corton Charlemagne",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 29,
"ProducerId": 28,
"Vintage": 2014,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 180,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": 7,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 25,
"PurchasePricePerBottle": 769,
"MarketPricePerBottle": 781
},
{
"id": 66,
"WineName": "Cote De Nuits Villages Rouge",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Cote de Nuits",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 63,
"ProducerId": 50,
"Vintage": 2009,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 204,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 4,
"PurchasePricePerBottle": 490,
"MarketPricePerBottle": 480
},
{
"id": 70,
"WineName": "Echezeaux",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Echezeaux",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 67,
"ProducerId": 50,
"Vintage": 2016,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 170,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": 7,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 1,
"PurchasePricePerBottle": 248,
"MarketPricePerBottle": 257
},
{
"id": 30,
"WineName": "Meursault Limozin",
"Producer": "Citeaux",
"Country": "France",
"Region": "Burgundy",
"District": "Meursault",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 31,
"ProducerId": 30,
"Vintage": 2013,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 168,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 85,
"PurchasePricePerBottle": 686,
"MarketPricePerBottle": 693
},
{
"id": 64,
"WineName": "Bourgogne Rouge",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": null,
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 61,
"ProducerId": 50,
"Vintage": 2013,
"CountryId": 9,
"RegionId": 20,
"DistrictId": null,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 59,
"PurchasePricePerBottle": 660,
"MarketPricePerBottle": 655
},
{
"id": 65,
"WineName": "Bourgogne Vv Rouge",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": null,
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 62,
"ProducerId": 50,
"Vintage": 2003,
"CountryId": 9,
"RegionId": 20,
"DistrictId": null,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 30,
"PurchasePricePerBottle": 197,
"MarketPricePerBottle": 194
},
{
"id": 71,
"WineName": "Nuits Saint Georges Rouge",
"Producer": "Bertrand Ambroise",
"Country": "France",
"Region": "Burgundy",
"District": "Nuits Saint Georges",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Old",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 68,
"ProducerId": 50,
"Vintage": 1985,
"CountryId": 9,
"RegionId": 20,
"DistrictId": 154,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 1,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 36,
"PurchasePricePerBottle": 498,
"MarketPricePerBottle": 496
},
{
"id": 75,
"WineName": "Blanc De Blancs",
"Producer": "Billecart Salmon",
"Country": "France",
"Region": "Champagne",
"District": null,
"WineColor": "White",
"WineType": "Sparkling",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 72,
"ProducerId": 54,
"Vintage": null,
"CountryId": 9,
"RegionId": 38,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 2,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 33,
"PurchasePricePerBottle": 168,
"MarketPricePerBottle": 155
},
{
"id": 76,
"WineName": "Brut Reserve",
"Producer": "Billecart Salmon",
"Country": "France",
"Region": "Champagne",
"District": null,
"WineColor": "White",
"WineType": "Sparkling",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 73,
"ProducerId": 54,
"Vintage": 2010,
"CountryId": 9,
"RegionId": 38,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 2,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 81,
"PurchasePricePerBottle": 622,
"MarketPricePerBottle": 602
},
{
"id": 77,
"WineName": "Brut Rose",
"Producer": "Billecart Salmon",
"Country": "France",
"Region": "Champagne",
"District": null,
"WineColor": "Rose",
"WineType": "Sparkling",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 74,
"ProducerId": 54,
"Vintage": 2014,
"CountryId": 9,
"RegionId": 38,
"DistrictId": null,
"WineColorId": 3,
"WineTypeId": 2,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 9,
"PurchasePricePerBottle": 344,
"MarketPricePerBottle": 333
},
{
"id": 44,
"WineName": "Pouilly Fume",
"Producer": "Didier Dagueneau",
"Country": "France",
"Region": "Loire",
"District": "Pouilly Fume",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied to Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 44,
"ProducerId": 41,
"Vintage": 2015,
"CountryId": 9,
"RegionId": 96,
"DistrictId": 387,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 6,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 35,
"PurchasePricePerBottle": 440,
"MarketPricePerBottle": 455
},
{
"id": 43,
"WineName": "Sancerre Monts Damnes",
"Producer": "Francois Cotat",
"Country": "France",
"Region": "Loire",
"District": "Sancerre",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 43,
"ProducerId": 40,
"Vintage": 2015,
"CountryId": 9,
"RegionId": 96,
"DistrictId": 391,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 84,
"PurchasePricePerBottle": 880,
"MarketPricePerBottle": 877
},
{
"id": 73,
"WineName": "Chateauneuf Du Pape",
"Producer": "Autard",
"Country": "France",
"Region": "Rhone",
"District": "Chateauneuf du Pape",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 70,
"ProducerId": 52,
"Vintage": 2015,
"CountryId": 9,
"RegionId": 155,
"DistrictId": 493,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 1,
"PurchasePricePerBottle": 858,
"MarketPricePerBottle": 839
},
{
"id": 74,
"WineName": "Cote Rotie Brune",
"Producer": "Barge",
"Country": "France",
"Region": "Rhone",
"District": "Cote Rotie",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 71,
"ProducerId": 53,
"Vintage": 2001,
"CountryId": 9,
"RegionId": 155,
"DistrictId": 496,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 26,
"PurchasePricePerBottle": 961,
"MarketPricePerBottle": 953
},
{
"id": 72,
"WineName": "Cotes Du Rhone",
"Producer": "Aphillanthes",
"Country": "France",
"Region": "Rhone",
"District": "Cotes du Rhone",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 69,
"ProducerId": 51,
"Vintage": 2017,
"CountryId": 9,
"RegionId": 155,
"DistrictId": 487,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 69,
"PurchasePricePerBottle": 865,
"MarketPricePerBottle": 880
},
{
"id": 32,
"WineName": "Brauneberger Juffer Riesling Kabinett",
"Producer": "Max Ferd Richter",
"Country": "Germany",
"Region": "Mosel",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied to Medium Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 33,
"ProducerId": 32,
"Vintage": 2011,
"CountryId": 10,
"RegionId": 117,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 6,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 27,
"PurchasePricePerBottle": 559,
"MarketPricePerBottle": 561
},
{
"id": 33,
"WineName": "Riesling Auslese",
"Producer": "Saarstein",
"Country": "Germany",
"Region": "Mosel",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Medium Dry",
"WineWeight": "Light Bodied to Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 34,
"ProducerId": 33,
"Vintage": 2013,
"CountryId": 10,
"RegionId": 117,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 2,
"WineWeightId": 6,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 46,
"PurchasePricePerBottle": 461,
"MarketPricePerBottle": 481
},
{
"id": 34,
"WineName": "Riesling Spatlese",
"Producer": "Saarstein",
"Country": "Germany",
"Region": "Mosel",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Medium Sweet",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 35,
"ProducerId": 33,
"Vintage": 2010,
"CountryId": 10,
"RegionId": 117,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 3,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 16,
"PurchasePricePerBottle": 758,
"MarketPricePerBottle": 762
},
{
"id": 35,
"WineName": "Aszu Tokaji 5 Puttonyos",
"Producer": "Disznoko",
"Country": "Hungary",
"Region": "Tokaji",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Sweet",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 36,
"ProducerId": 34,
"Vintage": 2010,
"CountryId": 12,
"RegionId": 195,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 4,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 86,
"PurchasePricePerBottle": 715,
"MarketPricePerBottle": 725
},
{
"id": 41,
"WineName": "Franciacorta Brut",
"Producer": "Ca Del Bosco",
"Country": "Italy",
"Region": "Lombardia",
"District": "Franciacorta",
"WineColor": "White",
"WineType": "Sparkling",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 41,
"ProducerId": 38,
"Vintage": 2015,
"CountryId": 13,
"RegionId": 97,
"DistrictId": 410,
"WineColorId": 2,
"WineTypeId": 2,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 92,
"PurchasePricePerBottle": 766,
"MarketPricePerBottle": 771
},
{
"id": 40,
"WineName": "Chardonnay",
"Producer": "Ca Del Bosco",
"Country": "Italy",
"Region": null,
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 20,
"ProducerId": 38,
"Vintage": 2016,
"CountryId": 13,
"RegionId": null,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 45,
"PurchasePricePerBottle": 166,
"MarketPricePerBottle": 150
},
{
"id": 42,
"WineName": "Moscato d'Asti",
"Producer": "Massolino",
"Country": "Italy",
"Region": "Piedmont",
"District": "Asti",
"WineColor": "White",
"WineType": "Sparkling",
"WineStyle": "Sweet",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 42,
"ProducerId": 39,
"Vintage": 2016,
"CountryId": 13,
"RegionId": 140,
"DistrictId": 457,
"WineColorId": 2,
"WineTypeId": 2,
"WineStyleId": 4,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 61,
"PurchasePricePerBottle": 835,
"MarketPricePerBottle": 815
},
{
"id": 39,
"WineName": "Asso Di Chardonnay",
"Producer": "Braida",
"Country": "Italy",
"Region": "Piedmont",
"District": "Langhe",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 40,
"ProducerId": 37,
"Vintage": 2015,
"CountryId": 13,
"RegionId": 140,
"DistrictId": 451,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 31,
"PurchasePricePerBottle": 550,
"MarketPricePerBottle": 536
},
{
"id": 37,
"WineName": "Vin Santo del Chianti Classico",
"Producer": "Antinori",
"Country": "Italy",
"Region": "Tuscany",
"District": "Vin Santo di Chianti",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Sweet",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 38,
"ProducerId": 35,
"Vintage": 2014,
"CountryId": 13,
"RegionId": 200,
"DistrictId": 552,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 4,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 90,
"PurchasePricePerBottle": 177,
"MarketPricePerBottle": 181
},
{
"id": 38,
"WineName": "Vin Santo",
"Producer": "Badia a Coltibuono",
"Country": "Italy",
"Region": "Tuscany",
"District": "Vin Santo di Chianti",
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Sweet",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 39,
"ProducerId": 36,
"Vintage": 2010,
"CountryId": 13,
"RegionId": 200,
"DistrictId": 552,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 4,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 65,
"PurchasePricePerBottle": 352,
"MarketPricePerBottle": 351
},
{
"id": 36,
"WineName": "Cervaro Sala Bianco",
"Producer": "Antinori",
"Country": "Italy",
"Region": "Umbria",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied to Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 37,
"ProducerId": 35,
"Vintage": 2016,
"CountryId": 13,
"RegionId": 201,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 4,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 53,
"PurchasePricePerBottle": 324,
"MarketPricePerBottle": 309
},
{
"id": 45,
"WineName": "Chardonnay",
"Producer": "Cloudy Bay",
"Country": "New Zealand",
"Region": "Marlborough",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied to Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 20,
"ProducerId": 42,
"Vintage": 2016,
"CountryId": 16,
"RegionId": 107,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 6,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 82,
"PurchasePricePerBottle": 286,
"MarketPricePerBottle": 283
},
{
"id": 46,
"WineName": "Gewurztraminer",
"Producer": "Cloudy Bay",
"Country": "New Zealand",
"Region": "Marlborough",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 45,
"ProducerId": 42,
"Vintage": 2016,
"CountryId": 16,
"RegionId": 107,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 83,
"PurchasePricePerBottle": 370,
"MarketPricePerBottle": 351
},
{
"id": 47,
"WineName": "Sauvignon Blanc",
"Producer": "Cloudy Bay",
"Country": "New Zealand",
"Region": "Marlborough",
"District": null,
"WineColor": "White",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Light Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 22,
"ProducerId": 42,
"Vintage": 2016,
"CountryId": 16,
"RegionId": 107,
"DistrictId": null,
"WineColorId": 2,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 1,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 54,
"PurchasePricePerBottle": 865,
"MarketPricePerBottle": 878
},
{
"id": 54,
"WineName": "Reserve Pinot Noir",
"Producer": "Cape Chamonix",
"Country": "South Africa",
"Region": "Coastal Region",
"District": "Franschhoek",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Medium Bodied",
"WineDrinkability": "Early",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 52,
"ProducerId": 48,
"Vintage": 2014,
"CountryId": 20,
"RegionId": 42,
"DistrictId": 19,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 2,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 2,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 55,
"PurchasePricePerBottle": 660,
"MarketPricePerBottle": 659
},
{
"id": 53,
"WineName": "V",
"Producer": "Vergelegen",
"Country": "South Africa",
"Region": "Coastal Region",
"District": "Stellenbosch",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 51,
"ProducerId": 47,
"Vintage": 2010,
"CountryId": 20,
"RegionId": 42,
"DistrictId": 330,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 63,
"PurchasePricePerBottle": 111,
"MarketPricePerBottle": 117
},
{
"id": 55,
"WineName": "Columella",
"Producer": "Sadie Family",
"Country": "South Africa",
"Region": "Coastal Region",
"District": "Swartland",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Mature",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 53,
"ProducerId": 49,
"Vintage": 2001,
"CountryId": 20,
"RegionId": 42,
"DistrictId": 329,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 3,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 74,
"PurchasePricePerBottle": 741,
"MarketPricePerBottle": 760
},
{
"id": 56,
"WineName": "Columella",
"Producer": "Sadie Family",
"Country": "South Africa",
"Region": "Coastal Region",
"District": "Swartland",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 53,
"ProducerId": 49,
"Vintage": 2014,
"CountryId": 20,
"RegionId": 42,
"DistrictId": 329,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 74,
"PurchasePricePerBottle": 979,
"MarketPricePerBottle": 992
},
{
"id": 52,
"WineName": "Rattlesnake Hill Cabernet Sauvignon",
"Producer": "Barnett",
"Country": "United States",
"Region": "California",
"District": "Napa Valley",
"WineColor": "Red",
"WineType": "Still",
"WineStyle": "Dry",
"WineWeight": "Full Bodied",
"WineDrinkability": "Young",
"BaseLwin": null,
"Lwin11": null,
"WineNameId": 50,
"ProducerId": 46,
"Vintage": 2014,
"CountryId": 23,
"RegionId": 21,
"DistrictId": 251,
"WineColorId": 1,
"WineTypeId": 1,
"WineStyleId": 1,
"WineWeightId": 5,
"WineDesignationId": null,
"WineClassificationId": null,
"Alcohol": null,
"DrinkDateFrom": null,
"DrinkDateTo": null,
"MarketPrice": null,
"AverageMarketPrice": null,
"WineBaseFlavourId": null,
"WineDrinkabilityId": 5,
"CreatedBy": null,
"CreatedDate": null,
"UpdatedBy": null,
"UpdateDate": null,
"BottleSizeId": null,
"GrapeId": null,
"Bottles": 31,
"PurchasePricePerBottle": 399,
"MarketPricePerBottle": 401
}
],
"notification-1": {
"title": "Drastic price change",
"type": "warning",
"icon": "status-warning",
"closable": true
},
"notification-2": {
"title": "Drinkability updates",
"type": "info",
"icon": "status-info",
"closable": true
},
"notification-3": {
"title": "Ratings updates",
"type": "info",
"icon": "status-info",
"closable": true
}
},
"total-wine-sales": {
"table-rows": [
{
"row-header": "Bottles sold",
"month-1": 480,
"month-2": 645,
"month-3": 860
},
{
"row-header": "Turnover",
"month-1": "240 000",
"month-2": "358 000",
"month-3": "516 000"
},
{
"row-header": "Average bottle price ex VAT",
"month-1": 500,
"month-2": 555,
"month-3": 600
},
{
"row-header": "Gross margin",
"month-1": 500,
"month-2": 555,
"month-3": 600
},
{
"row-header": "Gross margin %",
"month-1": "67%",
"month-2": "63%",
"month-3": "60%"
},
{
"row-header": "Wine profit",
"month-1": "160 800",
"month-2": "225 540",
"month-3": "309 600"
}
]
},
"app-profitability": {
"table-rows": [
{
"row-header": "App used",
"month-1": 65,
"month-2": 220,
"month-3": 450
},
{
"row-header": "Wine profit",
"month-1": "19 856",
"month-2": "112 000",
"month-3": "287 000"
},
{
"row-header": "Average profit",
"month-1": 305,
"month-2": 509,
"month-3": 638
}
],
"tadble-rows": [
{
"period": "April",
"app-used": 65,
"wine-profit": "19 856",
"average-profit": 305
},
{
"period": "May",
"app-used": 220,
"wine-profit": "112 000",
"average-profit": 509
},
{
"period": "June",
"app-used": 450,
"wine-profit": "287 000",
"average-profit": 638
}
]
},
"best-sellers": {
"date-ranges": {
"label": "Show best sellers since",
"options": [
{
"option": "All time"
},
{
"option": "Last month"
},
{
"option": "Last quarter"
},
{
"option": "Last year"
}
]
},
"table-rows": [
{
"number": 1,
"wine-name": "Guigal Cotes du Rhone 2017",
"bottles-sold": 216,
"gm-total": "54 000"
},
{
"number": 2,
"wine-name": "Aalto, Aalto 2016",
"bottles-sold": 164,
"gm-total": "49 200"
},
{
"number": 3,
"wine-name": "Hamilton Russell Chardonnay 2015",
"bottles-sold": 112,
"gm-total": "29 680"
},
{
"number": 4,
"wine-name": "Jeff Carrel Les Darons 2017",
"bottles-sold": 84,
"gm-total": "19 320"
},
{
"number": 5,
"wine-name": "Zind-Humbrecht Riesling 2015",
"bottles-sold": 65,
"gm-total": "19 370"
}
]
}
}
/**
* Draw a pie chart with Google Charts
*/
/* global google */
'use strict';
(function () {
// Cache the container elements
const winesByCountry = document.querySelector('#chart-wines-by-country');
const wineStyles = document.querySelector('#chart-wine-styles');
const wineDrinkability = document.querySelector('#chart-drinkability');
const wineListPrice = document.querySelector('#chart-wine-list-price');
const wineSupplier = document.querySelector('#chart-supplier');
const wineColour = document.querySelector('#chart-colour');
const wineGrape = document.querySelector('#chart-grape');
const wineMarketDemand = document.querySelector('#chart-market-demand');
const winePurchasePrice = document.querySelector('#chart-purchase-price');
// Halt if none of the elements are present
if (!winesByCountry && !wineStyles && !wineDrinkability && !wineListPrice)
return;
/**
* Configure & draw pie charts
*/
function pieChartConfig(data, elem) {
// Pie chart options
const pieChartOptions = {
legend: {
position: 'right',
alignment: 'center',
},
chartArea: {
top: 8,
height: '100%',
width: '90%',
},
};
// Draw
var chart = new google.visualization.PieChart(elem);
chart.draw(data, pieChartOptions);
}
/**
* Data: Wines by country
*/
function drawWinesByCountry() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Country');
data.addColumn('number', 'Bottles');
data.addRows([
['Germany', 197],
['France', 219],
['Italy', 348],
['Spain', 213],
['Australia', 111],
['Argentina', 183],
['Portugal', 321]
]);
pieChartConfig(data, winesByCountry);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawWinesByCountry);
/**
* Data: Wine styles
*/
function drawWineStyles() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Style');
data.addColumn('number', 'Bottles');
data.addRows([
['Dry', 197],
['Medium dry', 219],
['Medium sweet', 348],
['Sweet', 213],
]);
pieChartConfig(data, wineStyles);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawWineStyles);
/**
* Data: Drinkability
*/
function drawDrinkability() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Drinkability');
data.addColumn('number', 'Bottles');
data.addRows([
['Old', 97],
['Early', 119],
['Mature', 148],
['Late', 16],
['Young', 113],
]);
pieChartConfig(data, wineDrinkability);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawDrinkability);
/**
* Data: List price
*/
function drawListPrice() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'List price');
data.addColumn('number', 'Bottles');
data.addRows([
['0 - 399', 236],
['400 - 499', 108],
['500 - 599', 101],
['600 - 699', 93],
['700 - 799', 89],
['800 - 999', 62],
['1000 - 1499', 17],
['1500 - 1999', 35],
['2000 - 2999', 28],
['3000 - 9999', 8],
['10000 and up', 5],
]);
pieChartConfig(data, wineListPrice);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawListPrice);
/**
* Data: Supplier
*/
function drawSupplier() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Supplier');
data.addColumn('number', 'Bottles');
data.addRows([
['Vinunic', 213],
['Spring Wine', 222],
['Johan Lidby', 111],
]);
pieChartConfig(data, wineSupplier);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawSupplier);
/**
* Data: Colour
*/
function drawColour() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Colour');
data.addColumn('number', 'Bottles');
data.addRows([
['Red', 223],
['White', 154],
['Rosé', 99],
['Sparkling', 89],
['Fortified', 33],
]);
pieChartConfig(data, wineColour);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawColour);
/**
* Data: Grape
*/
function drawGrape() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Grape');
data.addColumn('number', 'Bottles');
data.addRows([
['Cabernet Sauvignon', 87],
['Merlot', 223],
['Pinot Noir', 99],
['Zinfandel', 123],
['Shiraz', 213],
['Malbec', 178],
['Tempranillo', 38],
['Sangiovese', 23],
['Barbera', 112],
['Carménère', 236],
]);
pieChartConfig(data, wineGrape);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawGrape);
/**
* Data: Market demand
*/
function drawMarketDemand() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Market demand');
data.addColumn('number', 'Bottles');
data.addRows([
['Strong trending wines', 43],
['Classic wines', 336],
['Weak trending wines', 88],
]);
pieChartConfig(data, wineMarketDemand);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawMarketDemand);
/**
* Data: Purchase price
*/
function drawPurchasePrice() {
const data = new google.visualization.DataTable();
data.addColumn('string', 'Purchase price');
data.addColumn('number', 'Price ranges');
data.addRows([
['0 - 199', 223],
['200 - 299', 108],
['300 - 399', 101],
['400 - 699', 93],
['700 - 1199', 89],
['1200 - 1999', 62],
['2000 or more', 56],
]);
pieChartConfig(data, winePurchasePrice);
}
// Set a callback to run when the API is loaded
google.charts.setOnLoadCallback(drawPurchasePrice);
// Redraw charts on window resize
window.addEventListener('resize', function() {
drawWinesByCountry();
drawWineStyles();
drawDrinkability();
drawListPrice();
drawSupplier();
drawColour();
drawGrape();
drawMarketDemand();
drawPurchasePrice();
});
})();
No notes defined.