{% extends 'base.html' %}
<!-- browse_view.html -->
{% load crispy_forms_tags %}

{% block content %}
<style>
.row1 {
	background-color: #ffffff;
}
.row2 {
	background-color: #cceeee;
}
.clickable-row {
	cursor: pointer;
}
.row1:hover {
	background-color: #8ccf84;
}
.row2:hover {
	background-color: #8ccf84;
}
.column {
  float: left;
  width: 50%;
}
body{
  padding: 50px;
}
	.tablerow {
		vertical-align: top;
	}
	
	.label {
		font-size: 12px;
		font-weight: bold;
		vertical-align: center;
	}
	.textarealabel {
		font-size: 12px;
		font-weight: bold;
		vertical-align: top;
	}
	.field {
		font-size: 12px;
	}
	
.transactionstable {
	width: 900px;
}

.fieldtransactionid {
	column-width: 100px;
	align: center;
	color: black;
}
.fieldstudentid {
	column-width: 100px;
	align: center;
	color: black;
}
.fieldtransactiondate {
	column-width: 200px;
	align: center;
	color: black;
}
.fieldtransactiontype {
	column-width: 100px;
	align: center;
	color: black;
}

.fieldtransactionamount {
	column-width: 200px;
	align: center;
	color: black;
}

.fieldtransactionnotes {
	column-width: 200px;
	align: center;
	color: black;
}
.systemmessageclass {
	font-size: 14px;	
}
/* billingtooltip container */
.billingtooltip {
  position: relative;
  display: inline;
  border-bottom: 1px dotted black; /* If you want dots under the hoverable text */
}

/* billingtooltip text */
.billingtooltip .billingtooltiptext {
  visibility: hidden;
  width: 120px;
  background-color: black;
  color: #fff;
  text-align: center;
  padding: 5px 0;
  border-radius: 6px;
 
  /* Position the billingtooltip text - see examples below! */
  position: absolute;
  z-index: 1;
}

/* Show the billingtooltip text when you mouse over the billingtooltip container */
.billingtooltip:hover .billingtooltiptext {
  visibility: visible;
}
</style>



<table><tr valign="top"><td width="50px"></td>
	<td>
<!-- {{ qobj }} -->

<h1> Transactions Report </h1>
<form name="transactionsreportform" action="{{base}}generate_report/" method="POST">
	{% csrf_token %}
	<input class="ignore" type="hidden" name="action" value="transreport">
	Min $<input class="ignore" name="transmin" id="transmin" />
	Max $<input class="ignore" name="transmax" id="transmax" />
	Starting Processed Date <input name="startdate" id="transdatestart" type="date"/>
	Ending Processed Date <input name="enddate" id="transdateend" type="date"/>
	<select name="whichtransactions" id="whichtransactions"><option value="all">All transactions</option><option value="fees">Fees only</option><option value="payments">Payments only</option></select>
	Download csv <input name="format" class="ignore" type="checkbox" value="csv" /> &nbsp;
	<input class="ignore" type="submit" value="Create Report" />
</form>



<table valign="bottom">
				<tr valign="top">
	<td class="fieldtransactionid"><span class="billingtooltip">TID<span class="billingtooltiptext">Transaction ID</span></span></td>
	<td class="fieldstudentid"><span class="billingtooltip">SID<span class="billingtooltiptext">Student ID</span></span></td>
	<td class="fieldname">Name</td>
	<td class="fieldtransactiondate">Date</td>
	<td class="fieldtransactiondate">Processed</td>
	<td class="fieldtransactiontype">Type</td>
	<td class="fieldtransactionamount">Amount</td>
	<td class="fieldtransactionnotes">Notes</td>
	<td class="actionedit">Action</td>
	<td class="actiondelete">Delete</td>
	</tr>
{% for transaction in transactions %}
					<tr valign="bottom">
						<td class="fieldtransactionid">{{ transaction.id }}</td>
						<td class="fieldstudent">{{ transaction.student }}</td>
						<td class="fieldname">{{transaction.student.first_name}} {{transaction.student.middle_name}} {{transaction.student.last_name}}</td>
						<td class="fieldtransactiondate">{{ transaction.transactiondate|date:'Y-m-d' }}</td>
						<td class="fieldtransactiondate">{{ transaction.transactionprocesseddate|date:'Y-m-d' }}</td>
						<td class="fieldtransactiontype">{{ transaction.transactiontype }}</td>
						<td class="fieldtransactionamount"{{ transaction.transactionamount | floatformat:2 }}</td>
						<td class="fieldtransactionnotes">{{ transaction.transactionnotes }}</td>
					</tr>

{% endfor %}
</table>



<h1>Collections Report </h1>
<form name="collectionsreportform" action="{{base}}generate_report/" method="POST">
	{% csrf_token %}
	<input class="ignore" type="hidden" name="action" value="collectionsreport">
	Minimum due $<input class="ignore" name="collectionsmin" id="collectionsmin" /> (leave blank for no minimum)<br/>
	Max $<input class="ignore" name="collectionsmax" id="collectionsmax" />  (leave blank for no maximum)<br/>
	Next payment due by <input name="startdate" id="collectionsdatestart" type="date"/><br>
	Show only students who ernolled after this date:  <input name="enrolldate" id="collectionsdateenroll" type="date"/>
	<input class="ignore" type="submit" value="Create Report" />
</form>
<br/><br/>
<h1>TOTAL RECEIVABLES: {{ totalowed | floatformat:2 }}</h1>
<table><tr><th>ID</th><th>Name</th><th>Due Date</th><th>Amount Due</th><th>Balance</th></tr>
	{% for student in collections %}
	<tr>
	<td>{{ student.id }}</td>
	<td>{{ student.first_name }} {{ student.middle_name }} {{ student.last_name }}</td>
	<td class="fieldtransactiondate">{{ student.next_due_date|date:'Y-m-d' }}</td>
	<td>{{ student.payment_amount_due | floatformat:2}}</td>
	<td>{{ student.balance | floatformat:2 }}</td>
	</tr>
	{% endfor %}
	
</table>


<h1>Prepays Report </h1>
<form name="prepaysreportform" action="{{base}}generate_report/" method="POST">
	{% csrf_token %}
	<input class="ignore" type="hidden" name="action" value="prepaysreport">
	First Date <input name="firstdate" id="firstdate" type="date"/><br>
	Date As Of <input name="dateasof" id="dateasof" type="date"/><br>
	Download csv <input name="format" class="ignore" type="checkbox" value="csv" /> &nbsp;
	<input class="ignore" type="submit" value="Create Report" />
</form>
<br/><br/>

	{% if prepaytotalowed %}
	Starting {{ prepayfirst }}, as of {{ prepayasof }}:<br/>
       <h2>Total Prepaid: ${{ prepaytotalprepaid | floatformat:2  }} </h2><br/>
       Total Prorata Owed: ${{ prepaytotalprorataowed  | floatformat:2 }} <br/>
       Total Owed: ${{ prepaytotalowed | floatformat:2  }} <br/>
       Total Paid: ${{ prepaytotalpaid  | floatformat:2 }} <br/>
<table>
	<tr><th>Cohort</th>
		
<th>current</th>
<th>loalength</th>
<th>discounts</th>
<th>first_name</th>
<th>grad</th>
<th>graddate</th>
<th>graduated</th>
<th>id</th>
<th>inactive</th>
<th>last_name</th>
<th>length</th>
<th>name</th>
<th>owed</th>
<th>paid</th>
<th>prepaid</th>
<th>prorataowed</th>
<th>start</th>
<th>start_date</th>
<th>studentname</th>
		
		</tr>
{% for item in prepays %}

<tr>
<td>{{item.cohort}}</td>
<td>{{item.current}}</td>
<td>{{item.loalength}}</td>
<td>{{item.discounts}}</td>
<td>{{item.first_name}}</td>
<td>{{item.grad}}</td>
<td>{{item.graddate}}</td>
<td>{{item.graduated}}</td>
<td>{{item.id}}</td>
<td>{{item.inactive}}</td>
<td>{{item.last_name}}</td>
<td>{{item.length}}</td>
<td>{{item.name}}</td>
<td>{{item.owed | floatformat:2 }}</td>
<td>{{item.paid | floatformat:2 }}</td>
<td>{{item.prepaid | floatformat:2 }}</td>
<td>{{item.prorataowed | floatformat:2 }}</td>
<td>{{item.start}}</td>
<td>{{item.start_date}}</td>
<td>{{item.studentname}}</td>
</tr>

{% endfor %}


</table>
{% endif %}
</td></tr></table>
{% endblock %}