weekly_report.html 5.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <style>
  5. .customers {
  6. font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
  7. border-collapse: collapse;
  8. width: 90%;
  9. }
  10. .customers td, .customers th {
  11. border: 1px solid rgb(41, 39, 39);
  12. padding: 8px;
  13. text-align: center;
  14. }
  15. .customers tr:nth-child(even){background-color: #f2f2f2;}
  16. .customers tr:hover {background-color: #ddd;}
  17. .customers th {
  18. padding-top: 12px;
  19. padding-bottom: 12px;
  20. text-align: left;
  21. background-color: #4e5253;
  22. color: rgb(255, 255, 255);
  23. text-align: center;
  24. }
  25. table{
  26. table-layout: fixed;
  27. }
  28. </style>
  29. </head>
  30. <body>
  31. <div align="center" style="margin-top: 25px;">
  32. <img src="https://ercare24.com/wp-content/uploads/2016/07/signature-care-resized-e1462918690585.png" alt="Avatar" class="image" width=50% >
  33. <h2 style="text-align:center;">Last Week Review Report</h2>
  34. </div>
  35. <div align="center">
  36. <table class="customers">
  37. <tr>
  38. <th style="width: 25%;">Platform</th>
  39. <th style="width: 25%;">Ratings</th>
  40. <th>Name Mentioned</th>
  41. </tr>
  42. <!-- Google Reviews Summary -->
  43. <tr>
  44. <td>Google</td>
  45. <td>
  46. {% if google_ratings.count == 0 %}
  47. <span style="color: red; font-weight: bold;">No Ratings!</span>
  48. {% else %}
  49. {% for r in google_ratings %}
  50. {% if r.star_rating < 3 %}
  51. <span style="color: red; font-weight: bold;">{{ r.star_rating }}* star: {{ r.total }}</span> </br>
  52. {% else %}
  53. <span>{{ r.star_rating }}* star: {{ r.total }}</span> </br>
  54. {% endif %}
  55. {% endfor %}
  56. {% endif %}
  57. </td>
  58. <td>
  59. {% if google_staffs %}
  60. {% for s_n in google_staffs %}
  61. {{ s_n }},
  62. {% endfor %}
  63. {% else %}
  64. <p>No staff or doctor got mentioned!</p>
  65. {% endif %}
  66. </td>
  67. </tr>
  68. <!-- Yelp Reviews Summary -->
  69. <tr>
  70. <td>Yelp</td>
  71. <td>
  72. {% if yelp_ratings.count == 0 %}
  73. <span style="color: red; font-weight: bold;">No Ratings!</span>
  74. {% else %}
  75. {% for r in yelp_ratings %}
  76. {% if r.rating < 3 %}
  77. <span style="color: red; font-weight: bold;">{{ r.rating }}* star: {{ r.total }}</span> </br>
  78. {% else %}
  79. <span>{{ r.rating }}* star: {{ r.total }}</span> </br>
  80. {% endif %}
  81. {% endfor %}
  82. {% endif %}
  83. </td>
  84. <td>
  85. {% if yelp_staffs %}
  86. {% for s_n in yelp_staffs %}
  87. {{ s_n }},
  88. {% endfor %}
  89. {% else %}
  90. <p>No staff or doctor got mentioned!</p>
  91. {% endif %}
  92. </td>
  93. </tr>
  94. <!-- Facebook Reviews Summary -->
  95. <!-- <tr>-->
  96. <!-- <td>Facebook</td>-->
  97. <!-- <td>-->
  98. <!-- {% for r in google_ratings %}-->
  99. <!-- {% if r.star_rating < 3 %}-->
  100. <!-- <span style="color: red; font-weight: bold;">{{ r.star_rating }}* star: {{ r.total }}</span> </br>-->
  101. <!-- {% else %}-->
  102. <!-- <span>{{ r.star_rating }}* star: {{ r.total }}</span> </br>-->
  103. <!-- {% endif %}-->
  104. <!-- {% endfor %}-->
  105. <!-- </td>-->
  106. <!-- <td>-->
  107. <!-- {% for s_n in google_staffs %}-->
  108. <!-- {{ s_n }}, -->
  109. <!-- {% endfor %}-->
  110. <!-- </td>-->
  111. <!-- </tr>-->
  112. </table>
  113. <h5>Bad Reviews</h5>
  114. <table class="customers">
  115. <tr>
  116. <th style="width: 25%;">Platform</th>
  117. <th>Review</th>
  118. </tr>
  119. <!-- Google Bad reviews list -->
  120. <tr>
  121. <td>Google</td>
  122. {% if google_bad_reviews.count > 0 %}
  123. <td style="width: 100%;">
  124. <table border="1px" style="border-collapse: collapse;margin: -9px">
  125. <tr style="background-color: rgb(179, 177, 177);">
  126. <!-- <td style="width: 20%;">Reviewer Name</td>-->
  127. <td style="width: 90%;">Comment</td>
  128. <td style="width: 10%;">Rating</td>
  129. </tr>
  130. {% for review in google_bad_reviews %}
  131. <tr>
  132. <!-- <td>{{ review.reviewer_name }}</td>-->
  133. <td>{{ review.comment }}</td>
  134. <td>{{ review.star_rating }}*</td>
  135. </tr>
  136. {% endfor %}
  137. </table>
  138. </td>
  139. {% else %}
  140. <td>
  141. <span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>
  142. </td>
  143. {% endif %}
  144. </tr>
  145. <!-- Yelp bad reviews list-->
  146. <tr>
  147. <td>Yelp</td>
  148. {% if yelp_bad_reviews.count > 0 %}
  149. <td style="width: 100%;">
  150. <table border="1px" style="border-collapse: collapse;margin: -9px">
  151. <!-- <tr style="background-color: rgb(179, 177, 177);">-->
  152. <!--&lt;!&ndash; <td style="width: 20%;">Reviewer Name</td>&ndash;&gt;-->
  153. <!-- <td style="width: 90%;">Comment</td>-->
  154. <!-- <td style="width: 10%;">Rating</td>-->
  155. <!-- </tr>-->
  156. {% for review in yelp_bad_reviews %}
  157. <tr>
  158. <!-- <td>{{ review.reviewer_name }}</td>-->
  159. <td style="width: 90%;">{{ review.comment }}</td>
  160. <td style="width: 10%;">{{ review.rating }}*</td>
  161. </tr>
  162. {% endfor %}
  163. </table>
  164. </td>
  165. {% else %}
  166. <td>
  167. <span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>
  168. </td>
  169. {% endif %}
  170. </tr>
  171. </table>
  172. </div>
  173. </body>
  174. </html>