<?php include 'header.php';?>
<div class="container-area">
  <div class="pt-4 pb-5">
    <div class="container">
      <div class="row document-card">
        <div class="col-md-12">
          <h3 class="m-0">New Assignments <span class="total_count" ></span></h3>
          <hr />
        </div>
        <?php
        $total = 0 ;
        $sql = "SELECT assignments.*, count(assignment_details.id) as totalCount, DATE_FORMAT(assignments.assignment_date, '%m/%d/%Y') as assignment_date_mdy  FROM assignments left join assignment_details on assignment_details.assignment_id = assignments.id  WHERE assignments.user_id = '".$_SESSION['user_id']."' and assignments.assignment_status_id = 1 group by assignments.id";
        $result = $conn->query($sql);
        while($row = $result->fetch_assoc()) {
            $assignment_no = $row["assignment_no"];
            $total = $total +  $row['totalCount'] ;
            ?> 
            <div class="col-md-2 col-sm-3">
              <div class="card animate w-100">
                <div class="card-body text-center">
                  <a href="data.php?assignment_no=<?php echo $assignment_no ; ?>" class="d-flex justify-content-center align-items-center bd-highlight">
                    <div class="">
                        <h6 class="card-title"><?php echo $row['assignment_date_mdy'] ; ?></h6>
                        <h3 class="card-title"><?php echo $assignment_no ; ?></h5>
                        <h6 class="card-title">(<?php echo $row['totalCount'] ; ?>)</h6>
                        <p class="card-text">
                        <!--<i class="fa fa-file-pdf-o" aria-hidden="true"></i>-->
                        <!--<i class="fa fa-database" aria-hidden="true"></i>-->
                      </p>
                    </div>
                  </a>
                </div>
              </div>
            </div>
            <?php
        }
        ?>
      </div>
    </div>
  </div>
</div>
<script>
    $(document).ready(function(){
        $(".total_count").html("(<?php echo $total ?>)");
    });
</script>
<?php include 'footer.php';?>