{% extends 'renter/index.html.twig' %}

{% block sidebard %}
    <li class="nav-item">
        <a class="nav-link" href="{{ path("user_panel") }}">
            <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-home"><path d="M3 9l9-7 9 7v11a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2z"></path><polyline points="9 22 9 12 15 12 15 22"></polyline></svg>
            <span class="ml-2">Panel</span>
        </a>
    </li>
    
    <li class="nav-item">
        <a class="nav-link active" aria-current="page" href="{{ path('user_rents') }}">
            <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-shopping-cart"><circle cx="9" cy="21" r="1"></circle><circle cx="20" cy="21" r="1"></circle><path d="M1 1h4l2.68 13.39a2 2 0 0 0 2 1.61h9.72a2 2 0 0 0 2-1.61L23 6H6"></path></svg>
            <span class="ml-2">Rents</span>
        </a>
    </li>
	<li class="nav-item">
        <a class="nav-link active" aria-current="page" href="{{ path('renter_rentdateReference') }}">
            <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-shopping-cart"><circle cx="9" cy="21" r="1"></circle><circle cx="20" cy="21" r="1"></circle><path d="M1 1h4l2.68 13.39a2 2 0 0 0 2 1.61h9.72a2 2 0 0 0 2-1.61L23 6H6"></path></svg>
            <span class="ml-2">DateRef</span>
        </a>
    </li>
    
    
{% endblock %}
{% block dashboard_current %}
    <nav aria-label="breadcrumb">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="{{ path('renter_panel') }}">Panel</a></li>
            <li class="breadcrumb-item active" aria-current="page">Locations</li>
        </ol>
    </nav>
{% endblock %}
{% block dashboard_body %}
	<h1>Recapitulatif Utile pour le loueur</h1>
    <h1 class="h2">Locations - renter/dateReference.html.twig -  {{ app.user.name }}</h1>
	
	<h2>1 ) findByIduserBydateReference($user) 
	<h4>	->andWhere('DATEDIFF( CURRENT_DATE() , rent.dateReference  ) <= 0') </h4>
	<h4>	->andWhere('rent.isPaid = true ') </h4>
	<h2> 2) findByUserdateReference) </h2>
	
	<h4>->andWhere('DATEDIFF( CURRENT_DATE() , rent.dateReference  ) > 0 </h4>
	<h4>		OR rent.isPaid != true ') </h4>
	
		{% set nbUser = 0 %}
        {% set totalPrice = 0 %}
		
		{% set totalReste = 0 %}
		
        {% for r in rentals %}
		
     		{% set totalPrice = totalPrice + r.getRent.price %}
			{% set nbUser = nbUser + 1  %}
							
        {% endfor %}
		
		{% for r in problams %}
		  	{% set totalReste = totalReste + r.getRent.price %}
			{% set nbUser = nbUser + 1  %}
		{% endfor %}
		
	<div class="row equal my-4">
        <div class="col-12 col-md-3 col-lg-3 mb-3 mb-lg-3">
            <div class="card rounded shadow-sm border-0">
                <div class="card-body p-4 text-center">
                    <p class="card-title">dans user/index.html.twig</p>
                    <h2 class="card-text">{{ nbUser|number_format(2) }} Locations</h2>
				
                </div>
            </div>
        </div>
	
		{% set nbUser = 0 %}
        {% set totalPrice = 0 %}
		
		{% set totalReste = 0 %}
		
        {% for r in rentals %}
		
     		{% set totalPrice = totalPrice + r.getRent.price %}
			{% set nbUser = nbUser +1  %}
						
        {% endfor %}
		{% for r in problams %}
		  	{% set totalReste = totalReste + r.getRent.price %}
		{% endfor %}
		
        <div class="col-12 col-md-3 col-lg-3 mb-3 mb-lg-3">
            <div class="card rounded shadow-sm border-0">
                <div class="card-body p-4 text-center">
                    <p class="card-title">Facture Regler avant la date Reference</p>
                    <h2 class="card-text">{{ totalPrice|number_format(2) }} €</h2>
                </div>
            </div>
        </div>
		<div class="col-12 col-md-6 col-lg-6 mb-6 mb-lg-6">
            <div class="card rounded shadow-sm border-0">
                <div class="card-body p-4 text-center">
                    <p class="card-title">Reste a Regler </p>
                    <h2 class="card-text">{{ totalReste|number_format(2) }} €</h2>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col">
            <div class="card rounded shadow-sm border-0">
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-hover">
                            <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">Adresse</th> 
								<th scope="col">DateLast</th>
                                <th scope="col">StartDates</th>
								<th scope="col">dateReference</th>
								<th scope="col">prix</th>
								<th scope="col">isPaid</th>
                                <th scope="col">Loueur</th>
								<th scope="col">Bailleur</th>
								<th scope="col">Nbjour</th>
                                <th scope="col">Paiement</th>
							    <th scope="col">OnGoing</th>	
                                <th scope="col">Statut</th>
                                <th scope="col"></th>
                            </tr>
                            </thead>
                            <tbody>
                            {% for r in rentals %}
                                <tr class='clickable-row' data-href='{{ path('renter_rent_details', { 'id': r.getRent.id }) }}' style="cursor: pointer;">
                                    <th scope="row">{{ r.getRent.id }}</th>
									<td>{{ r.getRent.caro.adresse }}</td>
									<th scope="row">{{ r.getRent.datelastregl|date("d/m/Y") }}</th>
                                 
								
                                    <td>{{ r.getRent.startDate|date("d/m/Y") }}
                                       </td>
									   <td>{{ r.getRent.dateReference|date("d/m/Y") }}
                                       </td>
                                    <td>
                                        {{ r.getRent.price }} 
                                   
                                    </td>
                                    <td>{{ r.getRent.isPaid ? 'Yes' : 'No' }}</td>
									
									<td>{{ r.getRent.user.name }}</td>
									<td>{{ r.getRent.caro.renter.name }}</td>
                                    <td>
                                        {{ r.ongoing }} 
                                    </td>
									<td>                              
										Regler										
									</td>
                                    	<td>
										<a href="{{ path('user_rent_detail', { 'id': r.getRent.id }) }}" class="btn btn-sm btn-primary">
                                         Détails <i class="fas fa-plus-square"></i>
										</a>
									</td>
									<td>ok</td>
                                                                
                                </tr>
                            {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
	
	<div class="card rounded shadow-sm border-0">
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-hover">
                            <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">Adresse</th> 
								<th scope="col">DateLast</th>
                                <th scope="col">StartDates</th>
								<th scope="col">dateReference</th>
								 <th scope="col">paid</th>
								 <th scope="col">prix</th>
                                <th scope="col">Loueur</th>
								<th scope="col">Bailleur</th>
								
								<th scope="col">Nbjour</th>
                                <th scope="col">Paiement</th>
							    <th scope="col">OnGoing</th>	
                                <th scope="col">Statut</th>
                                <th scope="col"></th>
                            </tr>
                            </thead>
                            <tbody>
                            {% for r in problams %}
                                <tr class='clickable-row' data-href='{{ path('renter_rent_details', { 'id': r.getRent.id }) }}' style="cursor: pointer;">
                                    <th scope="row">{{ r.getRent.id }}</th>
									<td>{{ r.getRent.caro.adresse }}</td>
									<th scope="row">{{ r.getRent.datelastregl|date("d/m/Y") }}</th>
             								
                                    <td>{{ r.getRent.startDate|date("d/m/Y") }}
                                    </td>
									<td>{{ r.getRent.dateReference|date("d/m/Y") }}
                                    </td>
                                    <td>
                                        {{ r.getRent.price }} 
                                     
                                    </td>
									<td>{{ r.getRent.isPaid ? 'Yes' : 'No' }}
                                                                         
                                    </td>
									<td>{{ r.getRent.user.name }}</td>
									<td>{{ r.getRent.caro.renter.name }}</td>
                                    <td> 
                                        {{ r.ongoing }} 
                                    </td>
									<td> {% if  r.ongoing > 15 %}
                                                                    
										Probleme		
										{% else %}
										En Attente 
																				
                                        {% endif %}  </td>
                                                                
									<td>
                                <a href="{{ path('user_rent_detail', { 'id': r.getRent.id }) }}" class="btn btn-sm btn-primary">
                                         Détails <i class="fas fa-plus-square"></i>
                                </a>
                                </td>
								<td>
								<a href="{{ path('user_RecurringBilling', {'id': r.getRent.id }) }}" class="btn btn-sm btn-danger">Payer test</a>                                        </a>
                                <a href="{{ path('checkouthangar', {'id': r.getRent.id }) }}" class="btn btn-sm btn-danger">Payer skype</a>
							
                                </td>
                                </tr>
                            {% endfor %}
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
	
{% endblock %}

{% block panel_scripts %}
    <script>
        jQuery(document).ready(function($) {
            $(".clickable-row").click(function() {
                window.location = $(this).data("href");
            });
        });
    </script>
{% endblock %}