{% extends "loginheader.html" %}

{% block body %}
<div class="container-fluid pt-1" style="font-size:12px;">
                <div class="container text-center">
                          {% with messages = get_flashed_messages() %}
                                {% if messages %}
                                  {% for message in messages %}
                                  <div class="alert alert-warning alert-dismissible" role="alert">
                                        <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                          <span aria-hidden="true">&times;</span>
                                        </button>
                                        {{message}}
                                  </div>
                                  {% endfor %}
                                {% endif %}
                          {% endwith %}
                </div>

{% if workbookscount >= 1 %}
<div class="row p-3 border-bottom border-warning">
	<div class="col-md-12 pl-3">
			<div class="row">
				<div class="col-md-3 p-2 bg-light">
						<p class="col-md-12 lead px-3 py-1 text-left text-black rounded border border-dark"><strong>Workbooks  </strong><a class="text-primary" href="#" data-toggle="popover" data-trigger="focus" data-content="Latest versions of Workbooks only"><i class="fas fa-info-circle"></i></a></p>
						<div class="bg-light" style="height:300px;overflow-y:auto;">
						{% for row in workbooks: %}
						  <p class="px-3">{{ row[:-4] }}</p>
	                                	{% endfor %}
						</div>
				</div>
				<div class="col-md-3 p-2 bg-light border-left border-warning" style="background-color:Gainsboro;">
						<p class="col-md-12 lead px-3 py-1 text-left text-black rounded border border-dark"><strong>Datasources</strong></p>
						<div  style="height:300px;overflow-y:auto;">

						{% for row in datasources: %}
						  <p class="px-3">{{ row }}</p>
	                                	{% endfor %}
						</div>
				</div>
				<div class="col-md-3 p-2 bg-light border-left border-warning" style="background-color:Gainsboro;">
						<p class="col-md-12 lead px-3 py-1 text-left text-black rounded border border-dark"><strong>Fields  </strong><a class="text-primary" href="#" data-toggle="popover" data-trigger="focus" data-content="Fields highlighted are used in the Dashboards"><i class="fas fa-info-circle"></i></a></p>
						<div  style="height:300px;overflow-y:auto;">

						{% for row in fields: %}
							{% if row[-4:] == '|||Y' : %}
								<p class="px-3"><strong>{{ row[:-4] }}</strong></p>
							{% else: %}
								<p class="px-3">{{ row[:-3] }}</p>
							{% endif %}
	                                	{% endfor %}
						</div>
				</div>
				<div class="col-md-3 p-2 bg-light border-left border-warning" style="background-color:Gainsboro;">
						<p class="col-md-12 lead px-3 py-1 text-left text-black rounded border border-dark"><strong>Formulas</strong></p>
						<div style="height:300px;overflow-y:auto;">

						{% for row in calcfields: %}
						  <p>{{ row }}</p><br>
	                                	{% endfor %}
						</div>
				</div>
			</div>

	</div>
</div>
<div class="row p-3">
	<div class="col-md-3 pt-2 bg-light"> 
		<p class="py-1 lead  pl-3 text-left rounded border border-dark"><strong>Workbook Details <small>(click to download)</small>   </strong><a class="text-white" href="#" data-toggle="popover" data-trigger="focus" data-content="Latest versions of Workbooks only"><i class="fas fa-info-circle"></i></a></p>
	 	<div class="list-group list-group-flush text-white" style="height:300px;overflow-y:auto;">
			{% for row in twbcsvdictdedup: %}
	       	         <a href="{{ row[2] }}" class="list-group-item list-group-item-action" style="background-color:transparent !important;"><i class="fas fa-cloud-download-alt text-success"></i>  {{ row[0] }} </a>
	               	{% endfor %}
		</div>
	</div>
	<div class="col-md-9 pt-2 border-left border-warning bg-light" style="background-color:Gainsboro;"> 
			<p class="col-md-12 lead py-1 pl-3 text-left rounded border border-dark"><strong>TabR-Tool Usage Chart</strong></p>
			<div class="chart" id="bargraph" style="height:275px;">
				<script>
				        var graphs = {{plot | safe}};
					Plotly.plot('bargraph',graphs,{});
				</script>
			</div>
	</div>
</div>
{% else %}
<div class="row">
	<div class="col-md-12 text-left">
      		<p class="lead" style="font-size:32px">Welcome {{ session.username }}</p>
	</div>
</div>
<div class="row px-5 bg-light">
	<div class="col-md-6 text-center py-5">
                <p class="lead"> Get Started with TabR-Tool - the most sophisticated validation tool for Tableau Workbooks.</p>
                <p class="lead">Learn how to audit Tableau Dashboards for Datasources, Fields and Transformations.</p>
                <hr class="my-4">
		<p class="lead"> Easily parse thru the Tableau Dashboards to review and making sure the Business Rules and logic are as per the requirements.</p>
		<p class="lead"> Search thru the dashboards for datasources and attributes used. </p>
		<a class="btn btn-sm btn-primary" href="/tabvalidation" role="button">TabR-Tool</a>		
	</div>
	<div class="col-md-6 text-center py-5">
		<iframe src="https://onedrive.live.com/embed?cid=2D63D47864BF237E&amp;resid=2D63D47864BF237E%21106&amp;authkey=AH4BF0TyIRs0jWg&amp;em=2&amp;wdAr=1.7777777777777777" width="610px" height="367px" frameborder="0">This is an embedded <a target="_blank" href="https://office.com">Microsoft Office</a> presentation, powered by <a target="_blank" href="https://office.com/webapps">Office Online</a>.</iframe>
		<p><em>The Workbooks shown in the above ppt are downloaded from Tableau Public.</em></p>
	</div>
</div>
{% endif %}
</div>
<script>
$(function () {
  $('[data-toggle="popover"]').popover()
  $('.popover-dismiss').popover({ trigger: 'focus' })
})
</script>

{% endblock %}