weekly_report.html 5.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176
  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. p {
  29. margin: 5px
  30. }
  31. </style>
  32. </head>
  33. <body>
  34. <div align="center" style="margin-top: 25px;">
  35. <img src="https://ercare24.com/wp-content/uploads/2016/07/signature-care-resized-e1462918690585.png" alt="Avatar" class="image" width=50% >
  36. <h2 style="text-align:center; margin-top: 50px">Last Week Review Report</h2>
  37. </div>
  38. <div align="center">
  39. <table class="customers">
  40. <tr>
  41. <th style="width: 25%;">Platform</th>
  42. <th>Ratings</th>
  43. </tr>
  44. <!-- Google Reviews Summary -->
  45. <tr>
  46. <td>Google</td>
  47. <td>
  48. {% if google_ratings.count == 0 %}
  49. <span style="color: red; font-weight: bold;">No Ratings!</span>
  50. {% else %}
  51. {% for r in google_ratings %}
  52. {% if r.star_rating < 3 %}
  53. <p style="color: red; font-weight: bold;">{{ r.star_rating }}* star: {{ r.total }}</p>
  54. {% else %}
  55. <p>{{ r.star_rating }}* star: {{ r.total }}</p>
  56. {% endif %}
  57. {% endfor %}
  58. {% endif %}
  59. </td>
  60. </tr>
  61. <!-- Yelp Reviews Summary -->
  62. <tr>
  63. <td>Yelp</td>
  64. <td>
  65. {% if yelp_ratings.count == 0 %}
  66. <span style="color: red; font-weight: bold;">No Ratings!</span>
  67. {% else %}
  68. {% for r in yelp_ratings %}
  69. {% if r.rating < 3 %}
  70. <p style="color: red; font-weight: bold;">{{ r.rating }}* star: {{ r.total }}</p>
  71. {% else %}
  72. <p>{{ r.rating }}* star: {{ r.total }}</p>
  73. {% endif %}
  74. {% endfor %}
  75. {% endif %}
  76. </td>
  77. </tr>
  78. <!-- Facebook Reviews Summary -->
  79. <!-- <tr>-->
  80. <!-- <td>Facebook</td>-->
  81. <!-- <td>-->
  82. <!-- {% for r in google_ratings %}-->
  83. <!-- {% if r.star_rating < 3 %}-->
  84. <!-- <span style="color: red; font-weight: bold;">{{ r.star_rating }}* star: {{ r.total }}</span> </br>-->
  85. <!-- {% else %}-->
  86. <!-- <span>{{ r.star_rating }}* star: {{ r.total }}</span> </br>-->
  87. <!-- {% endif %}-->
  88. <!-- {% endfor %}-->
  89. <!-- </td>-->
  90. <!-- <td>-->
  91. <!-- {% for s_n in google_staffs %}-->
  92. <!-- {{ s_n }}, -->
  93. <!-- {% endfor %}-->
  94. <!-- </td>-->
  95. <!-- </tr>-->
  96. </table>
  97. <h2 style="text-align:center; margin-top: 50px">All bad reviews that been posted this week.</h2>
  98. <table class="customers">
  99. <tr>
  100. <th style="width: 25%;">Platform</th>
  101. <th>Review</th>
  102. </tr>
  103. <!-- Google Bad reviews list -->
  104. <tr>
  105. <td>Google</td>
  106. {% if google_bad_reviews.count > 0 %}
  107. <td style="width: 100%; padding: 0px">
  108. <table border="1px" style="border-collapse: collapse;">
  109. <tr style="background-color: rgb(179, 177, 177);">
  110. <!-- <td style="width: 20%;">Reviewer Name</td>-->
  111. <!-- <td style="width: 90%;">Comment</td>-->
  112. <!-- <td style="width: 10%;">Rating</td>-->
  113. </tr>
  114. {% for review in google_bad_reviews %}
  115. <tr>
  116. <!-- <td>{{ review.reviewer_name }}</td>-->
  117. {% if review.comment %}
  118. <td style="width: 90%;">{{ review.comment }}</td>
  119. {% else %}
  120. <td>No comment only rating.</td>
  121. {% endif %}
  122. <td style="width: 10%;">{{ review.star_rating }}*</td>
  123. </tr>
  124. {% endfor %}
  125. </table>
  126. </td>
  127. {% else %}
  128. <td>
  129. <span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>
  130. </td>
  131. {% endif %}
  132. </tr>
  133. <!-- Yelp bad reviews list-->
  134. <tr>
  135. <td>Yelp</td>
  136. {% if yelp_bad_reviews.count > 0 %}
  137. <td style="width: 100%; padding: 0px">
  138. <table border="1px" style="border-collapse: collapse;">
  139. <!-- <tr style="background-color: rgb(179, 177, 177);">-->
  140. <!--&lt;!&ndash; <td style="width: 20%;">Reviewer Name</td>&ndash;&gt;-->
  141. <!-- <td style="width: 90%;">Comment</td>-->
  142. <!-- <td style="width: 10%;">Rating</td>-->
  143. <!-- </tr>-->
  144. {% for review in yelp_bad_reviews %}
  145. <tr>
  146. <!-- <td>{{ review.reviewer_name }}</td>-->
  147. <td style="width: 90%;">{{ review.comment }}</td>
  148. <td style="width: 10%;">{{ review.rating }}*</td>
  149. </tr>
  150. {% endfor %}
  151. </table>
  152. </td>
  153. {% else %}
  154. <td>
  155. <span style="color: green; font-weight: bold;">No bad reviews has been posted in Yelp!</span>
  156. </td>
  157. {% endif %}
  158. </tr>
  159. </table>
  160. </div>
  161. </body>
  162. </html>