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

{% block head_script_extra %}
<style>
.highlight {
    background:#ff0022;
}
</style>

<script type="text/javascript" src="{{ asset('bundles/d2partner/js/credit_note_assignment.js') }}"></script>
<script>
$(document).ready(function() {
	$('#partner').on('change', function() {
		sel_val = $(this).val();
		if(sel_val != '')
		{
			GetPartnerMAAccounts(sel_val);	
		}
	});

    $('#statement_tbl').dblclick(function() {
        $('.highlight').removeClass('highlight');
        var t = getSelectedText();
        var regex = new RegExp($.trim(t), "gi");
        this.innerHTML = this.innerHTML.replace(regex, function(matched) {return "<span class=\"highlight \">" + matched + "</span>";});
        deselectText();
    });
});

function ReconStatement(month, year)
{
		var inv_sum = 0.00;
		$(".inv_" + month + "_" + year).each(function (index) {
			cc = $(this).html().trim();
			if(cc != '')
				inv_sum = inv_sum + parseFloat(cc);
		});
		var cred_sum = 0.00;
		$(".cred_" + month + "_" + year).each(function (index) {
			cc = $(this).html().trim();
			if(cc != '')
				cred_sum = cred_sum + parseFloat(cc);
		});
		
		var pop_str = '<table class="table table-condensed table-bordered"><tr><th colspan="2" style="text-align:center">PERIOD RECON</th></tr>';
		pop_str = pop_str + '<tr><th>INVOICES</th><td style="text-align:right">' + inv_sum.toFixed(2) + '</td></tr>';
		pop_str = pop_str + '<tr><th>CREDITS</th><td style="text-align:right">' + cred_sum.toFixed(2) + '</td></tr>'
		pop_str = pop_str + '<tr><th style="text-align:right">TOTAL</th><th style="text-align:right">' + (inv_sum - cred_sum).toFixed(2) + '</th></tr>'
		pop_str = pop_str + '</table>';	
		bootbox.alert(pop_str);
}

function GetPartnerMAAccounts(id)
{
	var data = 'partner_id=' + id;
	var url  = Routing.generate('fetch_invoice_partner_ma_accounts');

	$.ajax({
	  url: url,
	  data: data,
	  type: "GET",
	  dataType: 'json',
	  success: function( json ) {
		sel_val = $('#ma_account').val();
		$('#ma_account').children().remove();
	
		for( var i = 0; i < json.length; i++ )
		{
			if(sel_val == json[i].id)
				$("#ma_account").append('<option selected="selected" value=' + json[i].id + '>' + json[i].label + '</option>');
			else
				$("#ma_account").append('<option value=' + json[i].id + '>' + json[i].label + '</option>');
		};
	  }
	});
}

function getSelectedText() {
	var txt = '';
	if (window.getSelection) {
		txt = window.getSelection();
	} else if (document.getSelection) {
		txt = document.getSelection();
	} else if (document.selection) {
		txt = document.selection.createRange().text;
	}
	return txt;
}

function deselectText() {
	if (window.getSelection) {
		window.getSelection().removeAllRanges();
	} else if (document.getSelection) {
		txt = document.getSelection().removeAllRanges();
	} else if (document.selection) {
		txt = document.selection.empty;
	}

}

</script>
{% endblock head_script_extra %}
    
{% block page_header %}
	{% 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"} %}
	<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', 'ma_account'] %}
				<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="ma_account">Account</label>
            <select class="form-control" name="ma_account" id="ma_account">
			<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>
{% endblock page_header %}

{% block content %}
{% if error == false %}
	{% set balance = opening_balance %}
	<table id="statement_tbl" class="table table-condensed">
		<thead>
			<tr>
				<th>Partner</th>
				<th>MA Account</th>
				<th>Period</th>
				<th>Date</th>
				<th style="width:50%">Document</th>
				<th style="text-align:right">Debit</th>
				<th style="text-align:right">Credit</th>
				<th style="text-align:right">Balance</th>
			</tr>
		</thead>
		<tbody>
			<tr>
				<td colspan="7"></td>
				<td style="text-align:right">{{ opening_balance|number_format(2, '.', '') }}</td>
			</tr>
		{% set cur_month = 0 %}
		{% set cur_year = 0 %}
		{% for item in items %}
			{% if item['type'] == 'STATEMENT' %}
					{% set cur_month = item['month'] + 1 %}
					{% set cur_year = item['year'] %}
					{% if cur_month > 12 %}
						{% set cur_month = 1 %}
						{% set cur_year = cur_year + 1 %}
					{% endif %}

					<tr class="section_{{ item['month'] }}_{{ item['year'] }}">
						<td colspan="2"></td>
						<td>{{ item['month'] }} / {{ item['year'] }}</td>
						<td>{{ item['date']|date("Y/m/d") }}</td>
						<td colspan="1">
							<table class="table table-bordered table-extra-condensed">
								{% set statement = d2_partner_get_statement(partner, ma_account, item['month'], item['year']) %}
								<tr><th colspan="6" style="background-color:#F3F3F3; text-align:center"><a href="{% if statement is not null %}javascript:ShowStatement({{ item['id'] }}){% endif %}"><i class="icon-question-sign"></i></a> {% if statement is not null %}Partner Statement{% else %} STATEMENT NOT LOADED {% endif %}</th></tr>
								<tr {% if statement is not null %}onclick="javascript:ReconStatement({{ statement.periodMonth }}, {{ statement.periodYear }})" {% endif %}><th>120 days</th><th>90 days</th><th>60 days</th><th>30 days</th><th>Current</th><th>Due</th></tr>
								<tr>
									<td>{{ item['120_days']|number_format(2, '.', '') }}</td>
									<td>{{ item['90_days']|number_format(2, '.', '') }}</td>
									<td>{{ item['60_days']|number_format(2, '.', '') }}</td>
									<td>{{ item['30_days']|number_format(2, '.', '') }}</td>
									<td>{{ item['current']|number_format(2, '.', '') }}</td>
									<td>{{ item['due']|number_format(2, '.', '') }}</td>
								</tr>
								<tr>
									<td colspan="4"></td><th>Payments</th><td>{{ item['payment']|number_format(2, '.', ' ') }}</td>
								</tr>
								<tr>
									<td colspan="4"></td><th>Un-Allocated</th><td></td>
								</tr>
							</table>
							{% set period_indx = item['month'] ~ '/' ~ item['year'] %}
							<table class="table table-bordered table-extra-condensed">
								<tr><th colspan="6" style="background-color:#F3F3F3; text-align:center">Derived Statement</th></tr>
								<tr><th>120 days</th><th>90 days</th><th>60 days</th><th>30 days</th><th>Current</th><th>Due</th></tr>
								<tr>
									<td>{{ derived_aging['120_days']|number_format(2, '.', '') }}</td>
									<td>{{ derived_aging['90_days']|number_format(2, '.', '') }}</td>
									<td>{{ derived_aging['60_days']|number_format(2, '.', '') }}</td>
									<td>{{ derived_aging['30_days']|number_format(2, '.', '') }}</td>
									<td>{{ derived_aging['current']|number_format(2, '.', '') }}</td>
									<td>{{ balance|number_format(2, '.', '') }}</td>
								</tr>
								<tr>
									<td colspan="4"></td><th>Payments</th><td>{{ derived_aging['payment']|number_format(2, '.', ' ') }}</td>
								</tr>
								<tr>
									<td colspan="4"></td><th>Un-Allocated</th><td></td>
								</tr>
							</table>
						</td>
						<td colspan="3"></td>
					</tr>	
					{% set  derived_aging = d2_shift_derived_statement_aging(derived_aging) %}
			{% else %}
				{% set cur_period_indx = item['month'] ~ '/' ~ item['year'] %}
				{% if item['type'] == 'INVOICE' %}
					{% set balance = balance + item['debit'] %}
					{% set  derived_aging = d2_update_derived_statement_aging(derived_aging, item['type'], cur_month, cur_year, item['month'], item['year'], item['debit']) %}
				{% endif %}
				{% if item['type'] == 'CREDIT' %}
					{% set balance = balance - item['credit'] %}
					{% if item['alloc'] is null %}
						{% set  derived_aging = d2_update_derived_statement_aging(derived_aging, item['type'], cur_month, cur_year, item['month'], item['year'], item['credit']) %}
					{% else %}
						{% for cred_alloc in item['alloc'] %}
						{% set  derived_aging = d2_update_derived_statement_aging(derived_aging, item['type'], cur_month, cur_year, cred_alloc['month'], cred_alloc['year'], cred_alloc['amount']) %}
						{% endfor %}
					{% endif %}
				{% endif %}
				{% if item['type'] == 'PAYMENT' %}
					{% set balance = balance - item['payment'] %}
					{% set  derived_aging = d2_update_derived_statement_aging(derived_aging, item['type'], cur_month, cur_year, item['month'], item['year'], item['payment']) %}
				{% endif %}
				{% if item['type'] == 'ADJUSTMENT' %}
					{% set balance = balance - item['credit'] + item['debit'] %}
					{% set  derived_aging = d2_update_derived_statement_aging(derived_aging, item['type'], cur_month, cur_year, item['month'], item['year'], item['debit'] - item['credit']) %}
				{% endif %}
				<tr class="section_{{ cur_month }}_{{ cur_year }}">
					<td>{{ item['partner'] | trim }}</td>
					<td>{{ item['ma_account'] | trim }}</td>
					<td>{{ item['month'] }} / {{ item['year'] }}</td>
					<td>{{ item['date']|date("Y/m/d") }}</td>
					<td>
						{% if item['type'] == 'INVOICE' %}
						<a href="javascript:ShowPDFInvoice({{ item['id'] }})"><i class="icon-question-sign"></i></a>
						{% elseif item['type'] == 'CREDIT' %}
						<a href="javascript:ShowPDFCreditNote({{ item['id'] }})"><i class="icon-question-sign"></i></a>
						{% elseif item['type'] == 'PAYMENT' %}
						<a href="javascript:ShowPayment({{ item['id'] }})"><i class="icon-question-sign"></i></a>
						{% elseif item['type'] == 'ADJUSTMENT' %}
						<a href=""><i class="icon-question-sign"></i></a>
						{% endif %}

						{{ item['number'] | trim }}
						
						{% if item['type'] == 'INVOICE' %}
							{% set linked_credits = d2_partner_get_invoice_credits(item['id']) %}
							{% if item['alloc'] and (item['alloc'].amount != item['debit'])%}
							 [Payment: {{ item['alloc'].amount|number_format(2, '.', '') }}]
							{% elseif item['alloc'] is null%}
							 <span style="color:red">[Payment not allocated]</span>
							{% endif %}
							
							{% if linked_credits|length > 0 %}
							 [Credits: 
							{% for cred in linked_credits %}
							{{ cred.creditNote.creditNoteNumber }}: {{ cred.amountIncVat|number_format(2, '.', '') }}
							{% endfor %}
							]
							{% endif %}
						{% endif %}
					</td>
					<td style="text-align:right" class="inv_{{ item['month'] }}_{{ item['year'] }}">
						{% if item['type'] == 'INVOICE' %}
							{{ item['debit']|number_format(2, '.', '') }}
						{% elseif item['type'] == 'ADJUSTMENT' and item['debit'] > 0.00 %}	
							{{ item['debit']|number_format(2, '.', '') }}
						{% endif %}
					<td style="text-align:right" {% if item['type'] == 'CREDIT' %}class="cred_{{ item['month'] }}_{{ item['year'] }}"{% endif %}>
						{% if item['type'] == 'CREDIT' %}
							{{ item['credit']|number_format(2, '.', '') }}
						{% elseif item['type'] == 'PAYMENT' %}
							{{ item['payment']|number_format(2, '.', '') }}
						{% elseif item['type'] == 'ADJUSTMENT' and item['credit'] > 0.00 %}	
							{{ item['credit']|number_format(2, '.', '') }}
						{% endif %}
					</td>
					<td style="text-align:right">{{ balance|number_format(2, '.', '') }}</td>
				</tr>
			{% endif %}
		{% endfor %}

		</tbody>
	</table>
{% else %}
<h3 class="text-center">PLEASE SELECT A PARTNER AND MA ACCOUNT</h3>
{% endif %}

{% endblock content %}