<!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);">-->
<!--&lt;!&ndash;              <td style="width: 20%;">Reviewer Name</td>&ndash;&gt;-->
<!--              <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>