<div class="row">
	<div class="col-md-12">
		<form action="{U}module_billing/billing/cashier" method="post" id="form-filter" class="search">
                    
			<input type="hidden" name="situation" value="{if isset($filter['situation'])}{$filter['situation']}{/if}">
			<input type="hidden" name="period" value="{if isset($filter['period'])}{$filter['period']}{/if}">
			<input type="hidden" name="period_ini" value="{if isset($filter['period_ini'])}{$filter['period_ini']}{/if}">
			<input type="hidden" name="period_end" value="{if isset($filter['period_end'])}{$filter['period_end']}{/if}">
			<input type="hidden" name="id_category" value="{if isset($filter['id_category'])}{$filter['id_category']}{/if}">
			<input type="hidden" name="id_payment_method" value="{if isset($filter['id_payment_method'])}{$filter['id_payment_method']}{/if}">
			<input type="hidden" name="historic" value="{if isset($filter['historic'])}{$filter['historic']}{/if}">
			<input type="hidden" name="items_per_page" value="{if isset($filter['items_per_page'])}{$filter['items_per_page']}{/if}">

			
			<div class="panel panel-default">
				<div class="panel-body">

					<div class="row">
						<div class="col-md-12">
                                                    
							<div class="btn-group">
								<button class="btn btn-default dropdown-toggle" data-toggle="dropdown"
										aria-haspopup="true" aria-expanded="false">
									{if isset($filter['situation']) && $filter['situation'] != ''}
										{$filter['situation']}
									{else}
										{$_L['Situation']}
									{/if}
									<span class="caret"></span>
								</button>
								<ul class="dropdown-menu" id="filter-situation">
									<li class="dropdown-header">{$_L['Situation']}</li>
									<li role="separator" class="divider"></li>
									<li{if isset($filter['situation']) && $filter['situation'] == 'all'} class="active"{/if}>
										<a data-val="Todas" href="#">{$_L['All']}</a>
									</li>
									<li{if isset($filter['situation']) && $filter['situation'] == 'Em aberto'} class="active"{/if}>
										<a data-val="Em aberto" href="#">{$_L['Opened']}</a>
									</li>
									{*<li{if isset($filter['situation']) && $filter['situation'] == 'Parcial'} class="active"{/if}>*}
										{*<a data-val="Parcial" href="#">{$_L['Partial']}</a>*}
									{*</li>*}
									<li{if isset($filter['situation']) && $filter['situation'] == 'Paga'} class="active"{/if}>
										<a data-val="Paga" href="#">{$_L['Payed']}</a>
									</li>
									<li{if isset($filter['situation']) && $filter['situation'] == 'Atrasada'} class="active"{/if}>
										<a data-val="Atrasada" href="#">{$_L['Delayed']}</a>
									</li>
								</ul>
							</div>

							<div class="btn-group">
								<button class="btn btn-default dropdown-toggle" data-toggle="dropdown"
										aria-haspopup="true" aria-expanded="false">
									<i class="fa fa-calendar"></i>
									{if isset($filter['period']) && $filter['period'] != ''}
										{if $filter['period'] == 'all'}{$_L['All']}{/if}
										{if $filter['period'] == 'day'}{$_L['In day']}{/if}
										{if $filter['period'] == 'week'}{$_L['In week']}{/if}
										{if $filter['period'] == 'month'}{$_L['In month']}{/if}
										{if $filter['period'] == 'interval'}{$_L['Interval']}{/if}
									{else}
										{$_L['Period']}
									{/if}
									 <span class="caret"></span>
								</button>
								<ul class="dropdown-menu dropdown-period" id="filter-period">
									<li class="dropdown-header">{$_L['Period']}</li>
									<li role="separator" class="divider"></li>
									<li {if isset($filter['period']) && $filter['period'] == 'all'}class="active"{/if}>
										<a data-val="all" href="#">{$_L['All']}</a>
									</li>
									<li {if isset($filter['period']) && $filter['period'] == 'day'}class="active"{/if}>
										<a data-val="day" href="#">{$_L['In day']}</a>
									</li>
									<li {if isset($filter['period']) && $filter['period'] == 'week'}class="active"{/if}>
										<a data-val="week" href="#">{$_L['In week']}</a>
									</li>
									<li {if isset($filter['period']) && $filter['period'] == 'month'}class="active"{/if}>
										<a data-val="month" href="#">{$_L['In month']}</a>
									</li>
									<li role="separator" class="divider"></li>
									<li class="disabled">
										<div class="col-md-12">
											<label for="">{$_L['Interval']}:</label>
										</div>
									</li>
									<li>
										<div class="col-md-12">
											{$_L['Outset']}: <input type="text" class="form-control" name="p_ini" data-date-format="dd/mm/yyyy"
											   		value="{if isset($filter['period_ini'])}{implode('/', array_reverse(explode('-', $filter['period_ini'])))}{/if}" datepicker>
										</div>
									</li>
									<li>
										<div class="col-md-12">
											{$_L['End']}: <input type="text" class="form-control" name="p_end" data-date-format="dd/mm/yyyy"
														value="{if isset($filter['period_end'])}{implode('/', array_reverse(explode('-',$filter['period_end'])))}{/if}" datepicker>
										</div>
									</li>
									<li>
										<div class="col-md-12"><br>
											<a id="period-filter-interval" class="btn btn-primary btn-xs" href="#">{$_L['Filtrate']}</a>
										</div>
									</li>
								</ul>
							</div>

							<div class="btn-group dropdown">
								<button id="dropdown-advanced" class="btn btn-default dropdown-toggle"
										data-toggle="dropdown" aria-haspopup="true" aria-expanded="true">
									{$_L['Advanced']} <span class="caret"></span>
								</button>
								<ul class="dropdown-menu dropdown-advanced" aria-labelledby="dropdown-advanced">
									<li class="dropdown-header">{$_L['Advanced']}</li>
									<li role="separator" class="divider"></li>
									<li>
										<div class="col-md-12">
											<div class="form-group">
												<label>{$_L['Category']}</label>

												<select name="select_expense_categories" id="expense_categories" class="form-control">
													<option value="all">{$_L['All']}</option>
													{foreach $income_categories as $cat}
														{if isset($filter['id_category'])}
															<option {if $cat['id'] == $filter['id_category']}selected{/if}
																	value="{$cat['id']}">{$cat['name']}</option>
														{else}
															<option value="{$cat['id']}">{$cat['name']}</option>
														{/if}
													{/foreach}
													<option value="without">{$_L['Without category']}</option>
												</select>
											</div>
										</div>
									</li>
									<li>
										<div class="col-md-12">
											<div class="form-group paddingLR-md">
												<label>{$_L['Receipt form']}</label>
												<select name="select_payment_methods" id="payment_methods" class="form-control">
													<option value="all">{$_L['All']}</option>
													{foreach $payment_methods as $pmethod}
														{if isset($filter['id_payment_method'])}
															<option {if $pmethod['id'] == $filter['id_payment_method']}selected{/if}
																	value="{$pmethod['id']}" >{$pmethod['name']}</option>
														{else}
															<option value="{$pmethod['id']}">{$pmethod['name']}</option>
														{/if}
													{/foreach}
													<option value="unknown">{$_L['Not informed']}</option>
												</select>
											</div>
										</div>
									</li>
									<li>
										<div class="col-md-12">
											<div class="form-group">
												<label>{$_L['Historic']}</label>
												<input type="text" name="historic_field"
													   value="{if isset($filter['historic'])}{$filter['historic']}{/if}"
													   id="historic_field" class="form-control" placeholder="{$_L['Any historic']}">										</div>
										</div>
									</li>
									<li>
										<div class="col-md-12">
											<button id="advanced-filter" type="button" class="btn btn-primary btn-sm">{$_L['Filtrate']}</button>
											<a href=""> | {$_L['or Cancel']}</a><br>
										</div>
									</li>
								</ul>
							</div>
							<a class="btn btn-primary" id="filter-clear" href="#">
								<i class="fa fa-eraser"></i> {$_L['Clean Filter']}
							</a>
						</div>
					</div>
				</form>

                                <div class='margin-10px0'> 
                                    <table class="table table-bordered table-hover" id="print_report_list">
					<thead>
					<tr>
                                            <th>{$_L['User name']}</th>
                                            {foreach $arr_pmethods as $pmethods}
                                                <th>{$pmethods}</th>
                                            {/foreach}
                                            <th>{$_L['Total']}</th>
					</tr>
					</thead>
					<tbody>
                                        {$user_id = null}
                                        {$sum_payments = 0}
                                        {$sum_payments_total = 0}
                                        {$arr_pmethods_aux = array()}
                                        {$sum_pmethods_total = array()}
                                        
                                        {foreach $arr_pmethods as $pmethods}
                                            {$sum_pmethods_total[$pmethods] = 0}
                                        {/foreach}
					{if count($records) > 0}
						{foreach $records as $record}
                                                    
                                                    {if $user_id != $record['user_name_id']}
                                                        
                                                        {if $user_id > 0}
                                                            {foreach $arr_pmethods as $pmethods}
                                                                <td>
                                                                    {if isset($arr_pmethods_aux[$pmethods])}
                                                                        {number_format($arr_pmethods_aux[$pmethods], 2, ',', '.')}
                                                                    {/if}
                                                                </td>
                                                            {/foreach}
                                                            <td>{number_format($sum_payments, 2, ',', '.')}</td>
                                                            </tr>
                                                        {/if}
                                                        {$user_id = $record['user_name_id']}
                                                        {$arr_pmethods_aux = array()}
                                                        {$sum_payments = 0}
							<tr>
								<td>{$record['user_name']}</td>
                                                                
                                                                
                                                                
                                                    {/if}
                                                    {$sum_payments = $sum_payments + $record['value']}
                                                    {$arr_pmethods_aux[$record['pmethod']] = $record['value']}
                                                    {$sum_pmethods_total[$record['pmethod']] = $sum_pmethods_total[$record['pmethod']] + $record['value']}
						{/foreach}
                                                {foreach $arr_pmethods as $pmethods}
                                                    <td>
                                                        {if isset($arr_pmethods_aux[$pmethods])}
                                                            {number_format($arr_pmethods_aux[$pmethods], 2, ',', '.')}
                                                        {/if}
                                                    </td>
                                                {/foreach}
                                                <td>{number_format($sum_payments, 2, ',', '.')}</td>
                                            </tr>
                                            <tr style="background-color: antiquewhite;">
                                                <td>{$_L['Total']}</td>
                                            {foreach $arr_pmethods as $pmethods}
                                                <td>
                                                    {if isset($sum_pmethods_total[$pmethods])}
                                                        {number_format($sum_pmethods_total[$pmethods], 2, ',', '.')}
                                                        {$sum_payments_total = $sum_payments_total + $sum_pmethods_total[$pmethods]}
                                                    {/if}
                                                </td>
                                            {/foreach}
                                                <td>
                                                    {number_format($sum_payments_total, 2, ',', '.')}
                                                </td>
                                            </tr>
					{else}
						<tr>
							<td colspan="12">{$_L['No records found']}.</td>
						</tr>
					{/if}
					</tbody>
                                    </table>    
                                </div>
                                <span class="btn btn-success no-print" id="print_report"><i class="fa fa-print"></i> IMPRIMIR</span>
			</div>
		</div>
	</div>
</div>
<input type="hidden" id="type" value="Income"/>