<!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>