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

{% block head_script_extra %}
<script type="text/javascript" src="{{ asset('bundles/d2billing/js/billing_query.js') }}"></script>
{% endblock head_script_extra %}
    
{% block page_header %}
    <div class="clearfix"></div>
	<hr/>
	<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', 'partner'] %}
				<input type="hidden" name="{{ k }}" value="{{ v }}" />
			{% endif %}
		{% endfor %}
        <div class="filter">
            <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="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 
		{{ (query_items.getCurrentPageNumber()-1) * query_items.getItemNumberPerPage() + 1 }}
		to
		{{ ((query_items.getCurrentPageNumber()-1) * query_items.getItemNumberPerPage()) + (query_items.getItems()|length) }}
		of
		{{ query_items.getTotalItemCount() }}
		<code>Billing Waybill Filter</code> records
	</div>
{% endblock page_header %}

{% block content %}
<table class="table table-condensed">
	<thead>
		<tr>
			<th style="width:250px">{{ knp_pagination_sortable(query_items, 'Partner', 'p.company_name') }}</th>
			<th style="width:250px">{{ knp_pagination_sortable(query_items, 'Filter Name', 'w.query_name') }}</th>
			<th>{{ knp_pagination_sortable(query_items, 'Query', 'w.query') }}</th>
			<th>SQL</th>
			<th></th>
		</tr>
	</thead>
	<tbody>
	{% for entity in query_items %}
		<tr>
			<td>{{ entity.getPartner.getCompanyName | trim }}</td>
			<td>{{ entity.getQueryName | trim }}</td>
			<td>{{ entity.getQuery | trim }}</td>
			<td>{{ d2_query_to_sql(entity.getQuery) }}</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">
					<li><a href="{{ path('dynamic_billing_query_show', { 'id': entity.id }) }}">View Filter</a></li>
					<li><a href="{{ path('dynamic_billing_query_edit', { 'id': entity.id }) }}">Edit Filter</a></li>
					<li><a href="javascript:DeleteBillingWaybillQuery({{ entity.id }})">Delete Filter</a></li>
				  </ul>
			   </div>
			</td> 
		</tr>
	{% endfor %}
	</tbody>
</table>
<div class="pagination pull-right">
	{{ knp_pagination_render(query_items) }}
</div>
{% endblock content %}