{% extends 'CPPViawestAdminBundle:Default:base.html.twig' %}
{% block title %}Activity Dashboard{% endblock %}

 {% block pagecontent %}
 <style type="text/css">
  
	.odd{
	background-color:#A1DDFA;	
	}
	.even{
	background-color:#FFFFFF;
	
	}
	table {
    border-collapse: collapse;
}
	.table, th, td{
	border: 1px solid black;	
	}
</style>
<h2 class="box-contents">Product Activity Dashboard</h2>
  
<div id="" style="overflow-y: scroll; height:500px;">
<table border="0" cellpadding="8" class="content-text">
<Tr><td><strong>Product Name</strong></td><td><strong># Times Product Ordered</strong></td><td><strong># Total Product Copies Ordered</strong></td><td><strong>Product Purchases Total (pre tax)</strong></td>
{% set totalcopies = 0 %}
{% for products in productCountData %}

{% set totalcopies = totalcopies + products.copies %}
<tr class="{{ cycle(["even", "odd"], loop.index) }}">
	
         <td>{{ products.name }}</td><td>{{ products.count }}</td><td>{{ products.copies }}</td>
         <td>${{ products.cost|number_format(2, '.', ',') }}</td>
   
</tr>
{% endfor %}
<tr class="even">
<td colspan="4">Total live approved orders placed: <strong>{{ orderCounter }}</strong><br>
Total copies purchased for all products: <strong>{{ totalcopies }}</strong><br>
(includes tax) Total of all purchases: <strong>${{ spendcounter|number_format(2, '.', ',') }}</strong>
</td>

</table>
<h2 class="box-contents">Department Activity Dashboard</h2>
<table border="0" cellpadding="8" class="content-text">
<Tr><td><strong>Department Name</strong></td><td><strong># Orders by Department</strong></td><td><strong>Department Purchases Total (incl/ tax)</strong></td>

{% for department in departmentCountData %}


<tr class="{{ cycle(["even", "odd"], loop.index) }}">
	
         <td>{{ department.name }}</td><td>{{ department.count }}</td><td>${{ department.cost|number_format(2, '.', ',') }}</td>
         
   
</tr>
{% endfor %}
<tr class="even">
<td colspan="3">Total live approved orders placed (all departments): <strong>{{ orderCounter }}</strong><br>

(includes tax) Total of all department purchases: <strong>${{ spendcounter|number_format(2, '.', ',') }}</strong>
</td>

</table>				
				
				
				

 </div>
 {% endblock %}