{% extends 'D2PartnerBundle::base.html.twig' %}

{% block head_script_extra %}
<script type="text/javascript" src="{{ asset('bundles/d2partner/js/partner_statement.js') }}"></script>
{% endblock head_script_extra %}
    
{% block page_header %}
	<form class="filter_form form-inline pull-right" role="form" method="get">
		{% for k, v in app.request.query %}
			{% if k|lower not in ['search', 'page', 'from_date', 'to_date', 'month', 'year', 'partner', 'ma_account'] %}
				<input type="hidden" name="{{ k }}" value="{{ v }}" />
			{% endif %}
		{% endfor %}
        <div class="filter">
			<label class="sr-only" for="month">Month</label>
			<select class="form-control" name="month" id="month" style="width:80px">
			{% set opts = {'': 'All', '1':"Jan", '2':"Feb", '3':"Mar", '4':"Apr", '5':"May", '6':"Jun", '7':"Jul", '8':"Aug", '9':"Sep", '10':"Oct", '11':"Nov", '12':"Dec"} %}
			{% for k, v in opts %}<option value="{{ k }}" {{ month is sameas(k|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
			</select>
			<label class="sr-only" for="year">Year</label>
			<select class="form-control" name="year" id="year" style="width:80px">
			{% set opts = {'': 'All', '2015':"2015", '2016':"2016", '2017':"2017", '2018':"2018", '2019':"2019", '2020':"2020", '2021':"2021", '2022':"2022", '2023':"2023", '2024':"2024", '2025':"2025", '2026':"2026", '2027':"2027", '2028':"2028", '2029':"2029", '2030':"2030"} %}
			{% for k, v in opts %}<option value="{{ k }}" {{ year is sameas(k|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
			</select>
            <label class="sr-only" for="company">Company</label>
            <select class="form-control" name="company" id="partner">
			<option value='' {{ app.request.get('company') == '' ? 'selected="selected"' : '' }}>Show All</option>
            {% for k, v in companies %}<option value="{{ v.getId }}" {{ app.request.get('company') is sameas(v.getId|lower) ? 'selected="selected"' : '' }}>{{ v.getCompanyName }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="partner">Partner</label>
            <select class="form-control" name="partner" id="partner">
			<option value='' {{ app.request.get('partner') == '' ? 'selected="selected"' : '' }}>Show All</option>
            {% for k, v in partners %}<option value="{{ v.getId }}" {{ app.request.get('partner') is sameas(v.getId|lower) ? 'selected="selected"' : '' }}>{{ v.getCompanyName }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="ma_account">Account</label>
            <select class="form-control" name="ma_account" id="ma_account" style="width:120px">
			<option value='' {{ app.request.get('ma_account') == '' ? 'selected="selected"' : '' }}>Show All</option>
            {% for k, v in ma_accounts %}<option value="{{ v.getId }}" {{ app.request.get('ma_account') is sameas(v.getId|lower) ? 'selected="selected"' : '' }}>{{ v.getMaAccountName }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="search">Search</label>
            <input type="text" class="form-control" name="search" id="search" placeholder="Search for" value="{{ app.request.get('search') }}">
            
            <div class="btn-group">
                <button type="submit" class="btn btn-default">Go</button>
                <button type="button" class="btn btn-default clear_filter">Clear</button>
            </div>
        </div>
	</form>
    <div class="clearfix"></div>
	<div class="record_list_count">Displaying 
		{{ (statement_items.getCurrentPageNumber()-1) * statement_items.getItemNumberPerPage() + 1 }}
		to
		{{ ((statement_items.getCurrentPageNumber()-1) * statement_items.getItemNumberPerPage()) + (statement_items.getItems()|length) }}
		of
		{{ statement_items.getTotalItemCount() }}
		<code>Partner Statement</code> records
	</div>
{% endblock page_header %}

{% block content %}
	{% set months = {1:"Jan", 2:"Feb", 3:"Mar", 4:"Apr", 5:"May", 6:"Jun", 7:"Jul", 8:"Aug", 9:"Sep", 10:"Oct", 11:"Nov", 12:"Dec"} %}
	<table class="table table-condensed">
		<thead>
			<tr>
				<th>{{ knp_pagination_sortable(statement_items, 'Date', 's.statement_date') }}</th>
				<th>{{ knp_pagination_sortable(statement_items, 'Month', 's.period_month') }}</th>
				<th>{{ knp_pagination_sortable(statement_items, 'Year', 's.period_year') }}</th>
				<th>{{ knp_pagination_sortable(statement_items, 'Company', 'ca.company_name') }}</th>
				<th>{{ knp_pagination_sortable(statement_items, 'Statement From', 'a.company_name') }}</th>
				<th>{{ knp_pagination_sortable(statement_items, 'Account', 'ma.ma_account_code') }}</th>
{#				
				<th style="text-align:right">{{ knp_pagination_sortable(statement_items, 'Amount ex VAT', 's.amount_ex_vat') }}</th>
				<th style="text-align:right">{{ knp_pagination_sortable(statement_items, 'VAT', 's.vat') }}</th>
#}
				<th style="text-align:right">{{ knp_pagination_sortable(statement_items, 'Current Amount', 's.amount_inc_vat') }}</th>
				<th></th>
			</tr>
		</thead>
		<tbody>
		{% for entity in statement_items %}
			<tr>
				<td>{{ entity.statementDate | date("Y/m/d") }}</td>
				<td>{{ months[entity.periodMonth] }}</td>
				<td>{{ entity.periodYear }}</td>
				<td>{% if entity.company is not null %} {{ entity.company.companyName | trim }} {% endif %}</td>
				<td>{{ entity.partner.companyName | trim }}</td>
				<td>{{ entity.maAccount.maAccountName | trim }}</td>
{#				
				<td style="text-align:right">{{ entity.amountExVat|number_format(2, '.', ' ') }}</td>
				<td style="text-align:right">{{ entity.vat|number_format(2, '.', ' ') }}</td>
#}
				<td style="text-align:right">{{ entity.amountIncVat|number_format(2, '.', ' ') }}</td>
				<td>
					<div class="btn-group pull-right">
					  <button type="button" class="btn btn-mini btn-info">Actions</button>
					  <button type="button" class="btn btn-mini dropdown-toggle" data-toggle="dropdown"><span class="caret"></span></button>
					  <ul class="dropdown-menu" role="menu">
						{% if is_granted('ROLE_ADMIN_PARTNER_PAYMENT_VIEW') %}
						<li><a href="{{ path('partner_admin_show_pdf_statement', { 'id': entity.id }) }}">View Statement</a></li>
						<li><a href="{{ path('partner_admin_edit_pdf_statement', { 'id': entity.id }) }}">Edit Statement</a></li>
						<li><a href="javascript:DeleteStatementFile({{ entity.id }})">Delete Statement</a></li>
						{% endif %}
					  </ul>
				   </div>
				</td> 
			</tr>
		{% endfor %}
		</tbody>
	</table>
	<div class="pagination pull-right">
		{{ knp_pagination_render(statement_items) }}
	</div>

{% endblock content %}