weekly_report.html 7.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245
  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: 100%;
  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. p {
  29. margin: 5px
  30. }
  31. .bordered, .n-bordered{
  32. border: 1px solid black;
  33. border-collapse: collapse;
  34. }
  35. .n-bordered{
  36. border: none;
  37. }
  38. .bordered td, .n-bordered td{
  39. border: 1px solid black;
  40. }
  41. .n-bordered tr:first-child td{
  42. border-top: none;
  43. }
  44. .n-bordered tr:last-child td{
  45. border-bottom: none;
  46. }
  47. .n-bordered tr td:first-child{
  48. border-left: none;
  49. }
  50. .n-bordered tr td:last-child{
  51. border-right: none;
  52. }
  53. </style>
  54. </head>
  55. <body>
  56. <div align="center" style="margin-top: 25px;">
  57. <img src="https://ercare24.com/wp-content/uploads/2016/07/signature-care-resized-e1462918690585.png" alt="Avatar" class="image" width=50% >
  58. <h2 style="text-align:center; margin-top: 50px">Last Week Review Report</h2>
  59. </div>
  60. <div align="center">
  61. <table class="customers">
  62. <tr>
  63. <th style="width: 25%;">Platform</th>
  64. <th>Ratings</th>
  65. </tr>
  66. <!-- Google Reviews Summary -->
  67. <tr>
  68. <td>Google</td>
  69. <td>
  70. {% if google_ratings.count == 0 %}
  71. <span style="color: red; font-weight: bold;">No Ratings!</span>
  72. {% else %}
  73. {% for r in google_ratings %}
  74. {% if r.star_rating < 3 %}
  75. <p style="color: red; font-weight: bold;">{{ r.star_rating }}* star: {{ r.total }}</p>
  76. {% else %}
  77. <p>{{ r.star_rating }}* star: {{ r.total }}</p>
  78. {% endif %}
  79. {% endfor %}
  80. {% endif %}
  81. </td>
  82. </tr>
  83. <!-- Yelp Reviews Summary -->
  84. <!-- <tr>-->
  85. <!-- <td>Yelp</td>-->
  86. <!-- <td>-->
  87. <!-- {% if yelp_ratings.count == 0 %}-->
  88. <!-- <span style="color: red; font-weight: bold;">No Ratings!</span>-->
  89. <!-- {% else %}-->
  90. <!-- {% for r in yelp_ratings %}-->
  91. <!-- {% if r.rating < 3 %}-->
  92. <!-- <p style="color: red; font-weight: bold;">{{ r.rating }}* star: {{ r.total }}</p>-->
  93. <!-- {% else %}-->
  94. <!-- <p>{{ r.rating }}* star: {{ r.total }}</p>-->
  95. <!-- {% endif %}-->
  96. <!-- {% endfor %}-->
  97. <!-- {% endif %}-->
  98. <!-- </td>-->
  99. <!-- </tr> -->
  100. <!-- <tr>-->
  101. <!-- <td>Yelp</td>-->
  102. <!-- <td>-->
  103. <!-- {% if yelp_ratings.count == 0 %}-->
  104. <!-- <span style="color: red; font-weight: bold;">No Ratings!</span>-->
  105. <!-- {% else %}-->
  106. <!-- {% for r in yelp_ratings %}-->
  107. <!-- {% if r.rating < 3 %}-->
  108. <!-- <p style="color: red; font-weight: bold;">{{ r.rating }}* star: {{ r.total }}</p>-->
  109. <!-- {% else %}-->
  110. <!-- <p>{{ r.rating }}* star: {{ r.total }}</p>-->
  111. <!-- {% endif %}-->
  112. <!-- {% endfor %}-->
  113. <!-- {% endif %}-->
  114. <!-- </td>-->
  115. <!-- </tr> -->
  116. <!-- Facebook Reviews Summary-->
  117. <tr>
  118. <td>Facebook</td>
  119. <td>
  120. {% if facebook_ratings %}
  121. {% for r in facebook_ratings %}
  122. {% if r.recommendation_type == True %}
  123. <span style="color: green; font-weight: green;">Positive: {{ r.total }}</span> </br>
  124. {% else %}
  125. <span style="color: red; font-weight: red;">Negative: {{ r.total }}</span> </br>
  126. {% endif %}
  127. {% endfor %}
  128. {% else %}
  129. <span style="color: red; font-weight: bold;">No Ratings!</span>
  130. {% endif %}
  131. </td>
  132. </tr>
  133. </table>
  134. <h2 style="text-align:center; margin-top: 50px">All negative reviews that been posted this week.</h2>
  135. <table class="customers">
  136. <tr>
  137. <th style="width: 25%;">Platform</th>
  138. <th>Review</th>
  139. </tr>
  140. <!-- Google Bad reviews list -->
  141. <tr>
  142. <td>Google</td>
  143. {% if google_bad_reviews.count > 0 %}
  144. <td style="width: 100%; padding: 0px">
  145. <table class="n-bordered" border="1px" style="border-collapse: collapse;">
  146. <tr style="background-color: rgb(179, 177, 177);">
  147. <!-- <td style="width: 20%;">Reviewer Name</td>-->
  148. <!-- <td style="width: 90%;">Comment</td>-->
  149. <!-- <td style="width: 10%;">Rating</td>-->
  150. </tr>
  151. {% for review in google_bad_reviews %}
  152. <tr>
  153. <!-- <td>{{ review.reviewer_name }}</td>-->
  154. {% if review.comment %}
  155. <td style="width: 90%;">{{ review.comment }}</td>
  156. {% else %}
  157. <td>No comment only rating.</td>
  158. {% endif %}
  159. <td style="width: 10%;">{{ review.star_rating }}*</td>
  160. </tr>
  161. {% endfor %}
  162. </table>
  163. </td>
  164. {% else %}
  165. <td>
  166. <span style="color: green; font-weight: bold;">No negative reviews has been posted in Google!</span>
  167. </td>
  168. {% endif %}
  169. </tr>
  170. <!-- Yelp bad reviews list-->
  171. <!-- <tr>-->
  172. <!-- <td>Yelp</td>-->
  173. <!-- {% if yelp_bad_reviews.count > 0 %}-->
  174. <!-- <td style="width: 100%; padding: 0px">-->
  175. <!-- <table class="n-bordered" border="1px" style="border-collapse: collapse;">-->
  176. <!--&lt;!&ndash; <tr style="background-color: rgb(179, 177, 177);">&ndash;&gt;-->
  177. <!--&lt;!&ndash;&lt;!&ndash; <td style="width: 20%;">Reviewer Name</td>&ndash;&gt;&ndash;&gt;-->
  178. <!--&lt;!&ndash; <td style="width: 90%;">Comment</td>&ndash;&gt;-->
  179. <!--&lt;!&ndash; <td style="width: 10%;">Rating</td>&ndash;&gt;-->
  180. <!--&lt;!&ndash; </tr>&ndash;&gt;-->
  181. <!-- {% for review in yelp_bad_reviews %}-->
  182. <!-- <tr>-->
  183. <!--&lt;!&ndash; <td>{{ review.reviewer_name }}</td>&ndash;&gt;-->
  184. <!-- <td style="width: 90%;">{{ review.comment }}</td>-->
  185. <!-- <td style="width: 10%;">{{ review.rating }}*</td>-->
  186. <!-- </tr>-->
  187. <!-- {% endfor %}-->
  188. <!-- </table>-->
  189. <!-- </td>-->
  190. <!-- {% else %}-->
  191. <!-- <td>-->
  192. <!-- <span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>-->
  193. <!-- </td>-->
  194. <!-- {% endif %}-->
  195. <!-- </tr>-->
  196. <!-- Facebook Review-->
  197. <tr>
  198. <td>Facebook</td>
  199. {% if facebook_bad_reviews.count > 0 %}
  200. <td style="width: 100%; padding: 0px">
  201. <table class="n-bordered" border="1px" style="border-collapse: collapse;">
  202. {% for review in facebook_bad_reviews %}
  203. <tr>
  204. <td style="width: 90%;">{{ review.review_text }}</td>
  205. <td style="width: 10%;">Not Recommended</td>
  206. </tr>
  207. {% endfor %}
  208. </table>
  209. </td>
  210. {% else %}
  211. <td>
  212. <span style="color: green; font-weight: bold;">No negative recommendation has been posted in Facebook!</span>
  213. </td>
  214. {% endif %}
  215. </tr>
  216. </table>
  217. </div>
  218. </body>
  219. </html>