<!DOCTYPE html>
<html>
<head>
<style>
.customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 90%;
}
.customers td, .customers th {
border: 1px solid rgb(41, 39, 39);
padding: 8px;
text-align: center;
}
.customers tr:nth-child(even){background-color: #f2f2f2;}
.customers tr:hover {background-color: #ddd;}
.customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4e5253;
color: rgb(255, 255, 255);
text-align: center;
}
table{
table-layout: fixed;
}
p {
margin: 5px
}
.bordered, .n-bordered{
border: 1px solid black;
border-collapse: collapse;
}
.n-bordered{
border: none;
}
.bordered td, .n-bordered td{
border: 1px solid black;
}
.n-bordered tr:first-child td{
border-top: none;
}
.n-bordered tr:last-child td{
border-bottom: none;
}
.n-bordered tr td:first-child{
border-left: none;
}
.n-bordered tr td:last-child{
border-right: none;
}
</style>
</head>
<body>
<div align="center" style="margin-top: 25px;">
<img src="https://ercare24.com/wp-content/uploads/2016/07/signature-care-resized-e1462918690585.png" alt="Avatar" class="image" width=50% >
<h2 style="text-align:center; margin-top: 50px">Last Week Review Report</h2>
</div>
<div align="center">
<table class="customers">
<tr>
<th style="width: 25%;">Platform</th>
<th>Ratings</th>
</tr>
<!-- Google Reviews Summary -->
<tr>
<td>Google</td>
<td>
{% if google_ratings.count == 0 %}
<span style="color: red; font-weight: bold;">No Ratings!</span>
{% else %}
{% for r in google_ratings %}
{% if r.star_rating < 3 %}
<p style="color: red; font-weight: bold;">{{ r.star_rating }}* star: {{ r.total }}</p>
{% else %}
<p>{{ r.star_rating }}* star: {{ r.total }}</p>
{% endif %}
{% endfor %}
{% endif %}
</td>
</tr>
<!-- Yelp Reviews Summary -->
<tr>
<td>Yelp</td>
<td>
{% if yelp_ratings.count == 0 %}
<span style="color: red; font-weight: bold;">No Ratings!</span>
{% else %}
{% for r in yelp_ratings %}
{% if r.rating < 3 %}
<p style="color: red; font-weight: bold;">{{ r.rating }}* star: {{ r.total }}</p>
{% else %}
<p>{{ r.rating }}* star: {{ r.total }}</p>
{% endif %}
{% endfor %}
{% endif %}
</td>
</tr>
<!-- Facebook Reviews Summary-->
<tr>
<td>Facebook</td>
<td>
{% if facebook_ratings %}
{% for r in facebook_ratings %}
{% if r.recommendation_type == True %}
<span style="color: green; font-weight: green;">Positive: {{ r.total }}</span> </br>
{% else %}
<span style="color: red; font-weight: red;">Negative: {{ r.total }}</span> </br>
{% endif %}
{% endfor %}
{% else %}
<span style="color: red; font-weight: bold;">No Ratings!</span>
{% endif %}
</td>
</tr>
</table>
<h2 style="text-align:center; margin-top: 50px">All bad reviews that been posted this week.</h2>
<table class="customers">
<tr>
<th style="width: 25%;">Platform</th>
<th>Review</th>
</tr>
<!-- Google Bad reviews list -->
<tr>
<td>Google</td>
{% if google_bad_reviews.count > 0 %}
<td style="width: 100%; padding: 0px">
<table class="n-bordered" border="1px" style="border-collapse: collapse;">
<tr style="background-color: rgb(179, 177, 177);">
<!-- <td style="width: 20%;">Reviewer Name</td>-->
<!-- <td style="width: 90%;">Comment</td>-->
<!-- <td style="width: 10%;">Rating</td>-->
</tr>
{% for review in google_bad_reviews %}
<tr>
<!-- <td>{{ review.reviewer_name }}</td>-->
{% if review.comment %}
<td style="width: 90%;">{{ review.comment }}</td>
{% else %}
<td>No comment only rating.</td>
{% endif %}
<td style="width: 10%;">{{ review.star_rating }}*</td>
</tr>
{% endfor %}
</table>
</td>
{% else %}
<td>
<span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>
</td>
{% endif %}
</tr>
<!-- Yelp bad reviews list-->
<tr>
<td>Yelp</td>
{% if yelp_bad_reviews.count > 0 %}
<td style="width: 100%; padding: 0px">
<table class="n-bordered" border="1px" style="border-collapse: collapse;">
<!-- <tr style="background-color: rgb(179, 177, 177);">-->
<!--<!– <td style="width: 20%;">Reviewer Name</td>–>-->
<!-- <td style="width: 90%;">Comment</td>-->
<!-- <td style="width: 10%;">Rating</td>-->
<!-- </tr>-->
{% for review in yelp_bad_reviews %}
<tr>
<!-- <td>{{ review.reviewer_name }}</td>-->
<td style="width: 90%;">{{ review.comment }}</td>
<td style="width: 10%;">{{ review.rating }}*</td>
</tr>
{% endfor %}
</table>
</td>
{% else %}
<td>
<span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>
</td>
{% endif %}
</tr>
<!-- Facebook Review-->
<tr>
<td>Facebook</td>
{% if facebook_bad_reviews.count > 0 %}
<td style="width: 100%; padding: 0px">
<table class="n-bordered" border="1px" style="border-collapse: collapse;">
{% for review in facebook_bad_reviews %}
<tr>
<td style="width: 90%;">{{ review.review_text }}</td>
<td style="width: 10%;">Not Recommended</td>
</tr>
{% endfor %}
</table>
</td>
{% else %}
<td>
<span style="color: green; font-weight: bold;">No bad reviews has been posted in Facebook!</span>
</td>
{% endif %}
</tr>
</table>
</div>
</body>
</html>