@extends('layouts.layout_pagina',
[
    'icone_titulo'=>'fas fa-hand-holding-usd',
    'titulo'=>'Conta a Receber',
    'breadcrumb'=>['Financeiro','Conta a Receber']
])

@section('css')
    <link rel="stylesheet" href="{{{ URL::asset('js/DataTables/datatables.min.css') }}}" />
@endsection

@section('scripts')
    <script src="{{{ URL::asset('js/DataTables/datatables.min.js') }}}"></script>
    <script src="{{{ URL::asset('js/views/financeiro/contareceber/list.js') }}}"></script>
    
@endsection

@section('pagina')
    
    <div class="container-fluid">  

        <div class="card mt-2">

            <div class="card-header cor-card-header text-white d-flex bg-primary-gradient" style="height: 50px; align-items: center">               
                <h2> Registros do Contas a Receber </h2>
                
            </div> 
            

            <div class="card-body">
                <form method="GET" action="{{route('financeiro.conta_receber.pesquisar')}}">
                    <div class="row" >
                        <div class="col col-sm-3 text-left">
                            <label class="col-form-label text-md-left">Início</label>
                            <br/>
                            <input class="form-control" type="date" name="dataInicio"/>
                        </div>
                        <div class="col col-sm-3 text-left">
                            <label class="col-form-label text-md-left">Termino</label>
                            <br/>
                            <input class="form-control" type="date" name="dataFinal"/>
                        </div>
                        <div class="col-12 col-md-3">
                            <label class="col-form-label">Cliente</label>
                            <br/>
                            <select class="form-control" name="cliente">
                                <option value="">Todos...</option>
                                @foreach($listaclientes as $lista)
                                    <option value="{{$lista->id}}">{{$lista->nome}}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col col-sm-2 text-center">
                            <label for="btnPesquisa" class="col-form-label">&nbsp;</label>
                            <br/>
                            <button id="btnPesquisa" type="submit" class="btn btn-success"><i class="fas fa-search"></i> Pesquisar</button>
                        </div>  
                    </div>
                </form>
            </div>

        </div>
            
        <div class="card mt-2">   

            <div class="card-body">
                <div class="row" >
                    <div class="col-12 col-md-12 table-responsive">
                        <table id="tbContasReceber" class="table table-hover text-left" style="width:100%">
                            <thead>
                                <tr>
                                    <th></th>
                                    <th></th>
                                    <th>Descrição</th>
                                    <th class="text-center">Cliente</th>
                                    <th class="text-center">Registro</th>
                                    <th class="text-center">Vencimento</th>
                                    <th class="text-center">Valor</th>
                                    <th class="text-center">Recebido</th>
                                    <th class="text-center">Situação</th>                                 
                                   
                                    
                                </tr>
                            </thead>
                            <tbody>
                                @php 
                                    $total = 0;
                                    $totalpago = 0;      
                                    $aberto = 0;
                                    $atraso = 0;  
                                    $hoje = date('Y-m-d');
                                @endphp
                                @foreach($listaContasReceber as $lista)
                                    <tr data-id="{{ $lista->id }}">
                                        <td width="10%" class="text-center">
                                            <span name="editBtn" class="btn btn-xs btn-warning fas fa-edit text-white cursor-pointer" data="{{$lista['id']}}" style="cursor: pointer;color: #009933;" title="Baixar Valor"></span>
                                            <span name="atualBtn" class="btn btn-xs btn-primary fas fa-user-alt  text-white cursor-pointer" data="{{$lista['id']}}" style="cursor: pointer;color: #009933;" title="Alterar Cliente/Vencimento"></span>
                                        </td>
                                        <td><input type="checkbox" class="selecionar" checked="true"></td>
                                        <td id="{{$lista['id']}}_descricao">{{$lista['descricao']}}</td>
                                        <td class="text-center" id="{{$lista['id']}}_cliente" data="{{$lista['fk_cliente']}}">{{$lista->Cliente['nome']}}</td>                                          
                                        <td class="text-center" id="{{$lista['id']}}_registro">{{date('d/m/Y', strtotime($lista['dt_registro']))}}</td>
                                        <td class="text-center" id="{{$lista['id']}}_vencimento" data="{{date('d/m/Y', strtotime($lista['dt_vencimento']))}}">{{date('d/m/Y', strtotime($lista['dt_vencimento']))}}</td>
                                        <td class="text-center" id="{{$lista['id']}}_valor" data="{{$lista['valor']}}">{{$lista['valor']}}</td>  
                                        <td class="text-center" id="{{$lista['id']}}_valorrec" data="{{$lista['valor_recebido']}}">{{$lista['valor_recebido']}}</td>                                                                                 
                                        @if($lista['situacao']=='Registrado')
                                            @if($lista['dt_vencimento'] < $hoje)
                                                <td class="text-center" id="{{$lista['id']}}_situacao"><span class="badge-pill badge-danger">Atrasado</span></td>
                                            @else 
                                                <td class="text-center" id="{{$lista['id']}}_situacao"><span class="badge-pill badge-warning">{{$lista['situacao']}}</span></td>
                                            @endif
                                        @elseif($lista['situacao']=='Finalizado')
                                            <td class="text-center" id="{{$lista['id']}}_situacao"><span class="badge-pill badge-success">{{$lista['situacao']}}</span></td>
                                        @endif                                        
                                        
                                        <input type="hidden" id="{{$lista['id']}}_forma_pagamento" data="{{$lista['fk_forma_pagamento']}}">
                                        <input type="hidden" id="{{$lista['id']}}_notafiscal" data="{{$lista['nota_fiscal']}}">
                                        <input type="hidden" id="{{$lista['id']}}_desconto" data="{{$lista['desconto']}}">
                                        <input type="hidden" id="{{$lista['id']}}_juros" data="{{$lista['juros']}}">
                                        <input type="hidden" id="{{$lista['id']}}_valor_saldo" data="{{$lista['valor_saldo']}}">
                                        <input type="hidden" id="{{$lista['id']}}_valor_recebido" data="{{$lista['valor_recebido']}}">
                                        <input type="hidden" id="{{$lista['id']}}_id" data="{{$lista['id']}}">
                                    </tr>
                                    @php                                         
                                        
                                        $total = $total + ($lista['valor'] - $lista['valor_recebido']);
                                        $totalpago = $totalpago + $lista['valor_recebido'];                                        
                                        
                                        if($lista['situacao']=='Registrado'){
                                            if($lista['dt_vencimento'] < $hoje){
                                                $atraso = $atraso + ($lista['valor']-$lista['valor_recebido']); 
                                            } else {
                                                $aberto = $aberto + ($lista['valor']-$lista['valor_recebido']); 
                                            }                                            
                                        }  
                                                                            
                                    @endphp 
                                @endforeach 
                            </tbody>
                        </table>
                    </div>
                </div> 
            </div>

        </div>


        <div class="card mt-2">
           
            <div class="card-header cor-card-header text-white d-flex bg-primary-gradient" style="height: 50px; align-items: center">               
                <h2> Total Valor Selecionado </h2>
                <div class="col text-right">
                        <button id="btnConfirma" type="button" class="btn btn-success"><i class="fas fa-save"></i> Confirmar Recebimento </button>                                            
                </div>
            </div>            
            <div class="card-body">
              

                <div class="row" >  

                    <div class="col-sm-6 col-md-8">                       
                    </div>

                    <div class="col-sm-6 col-md-4">
                        <div class="card card-stats card-round">
                            <div class="card-body ">
                                <div class="row">
                                    <div class="col-5">
                                        <div class="icon-big text-center">
                                            <i class="flaticon-coins text-warning"></i>
                                        </div>
                                    </div>
                                    <div class="col-7 col-stats">
                                        <div class="numbers">
                                            <p class="card-category"> Valor a Receber:</p>
                                            <h4 class="card-title" id="total">  {{number_format($total,2,'.','')}} </h4>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>                                    
                    
                </div>             

                
            </div>          

         </div>
 

        <div class="card mt-2">
            <div class="card-header cor-card-header text-white d-flex bg-primary-gradient" style="height: 50px; align-items: center">               
                <h2> Totalização  </h2>
            </div>            
            <div class="card-body">

                <div class="row" >

                    <div class="col-sm-6 col-md-4">
                        <div class="card card-stats card-round">
                            <div class="card-body ">
                                <div class="row">
                                    <div class="col-5">
                                        <div class="icon-big text-center">
                                            <i class="flaticon-coins text-success"></i>
                                        </div>
                                    </div>
                                    <div class="col-7 col-stats">
                                        <div class="numbers">
                                            <p class="card-category"> Total Pago:</p>
                                            <h4 class="card-title">R$ {{number_format($totalpago,2,',','.')}}</h4>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-sm-6 col-md-4">
                        <div class="card card-stats card-round">
                            <div class="card-body ">
                                <div class="row">
                                    <div class="col-5">
                                        <div class="icon-big text-center">
                                            <i class="flaticon-coins text-primary"></i>
                                        </div>
                                    </div>
                                    <div class="col-7 col-stats">
                                        <div class="numbers">
                                            <p class="card-category"> Total em Aberto:</p>
                                            <h4 class="card-title">R$ {{number_format($aberto,2,',','.')}}</h4>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    <div class="col-sm-6 col-md-4">
                        <div class="card card-stats card-round">
                            <div class="card-body ">
                                <div class="row">
                                    <div class="col-5">
                                        <div class="icon-big text-center">
                                            <i class="flaticon-coins text-danger"></i>
                                        </div>
                                    </div>
                                    <div class="col-7 col-stats">
                                        <div class="numbers">
                                            <p class="card-category"> Total em Atraso:</p>
                                            <h4 class="card-title">R$ {{number_format($atraso,2,',','.')}}</h4>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                    
                </div>

                
            </div>
        </div>



    </div>


 
    
 <!-- Modal edição-->
 <div class="modal fade" id="editconta" tabindex="-1" role="dialog" aria-labelledby="editconta" aria-hidden="true">
    <div class="modal-dialog modal-lg" role="document">

        <div class="modal-content">
            <div class="modal-header card-header cor-card-header text-white d-flex justify-content-between bg-primary-gradient">
                <h5 class="modal-title" > Baixar Recebimento </h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>

            <form  method="POST" action="{{route('financeiro.conta_receber.editar')}}" >
                    @csrf
            <div class="card-body">           

                
               
                <div class="row mt-3">                    
                  

                    <div class="col-12 col-md-8">
                        <label class="form-label" for="descricao">Cliente</label>
                        <input class="form-control" id="cliente" type="text" disabled name="cliente" />
                       
                    </div>

                    <div class="col-12 col-md-4">
                        <label class="form-label" for="descricao">Vencimento</label>
                        <input class="form-control" id="dtVencimento" type="text" disabled name="dtVencimento" />
                        <div class="invalid-feedback">
                            Por favor, escolha uma descrição para a Conta a Pagar.
                        </div>
                    </div>

                   
                </div>

                <div class="row mt-3"> 

                    <div class="col-12 col-md-4">
                        <label class="form-label" for="valor">Valor Real</label>
                        <input class="form-control mask_moeda" id="valorreal" type="text" name="valorreal" disabled/>
                        <div class="invalid-feedback">
                            Por favor, escolha um valor.
                        </div>
                    </div>
                    
                    <div class="col-12 col-md-4">
                        <label class="form-label" for="valor">Valor Recebido</label>
                        <input class="form-control mask_moeda" id="valorrec" type="text" name="valorrec" disabled/>
                        <div class="invalid-feedback">
                            Por favor, escolha um valor.
                        </div>
                    </div>

                    <div class="col-12 col-md-4">
                        <label class="form-label" for="valor">Valor Baixa*</label>
                        <input class="form-control mask_moeda" id="valor" type="text" name="valor" required/>
                        <div class="invalid-feedback">
                            Por favor, escolha um valor.
                        </div>
                    </div>

                </div>

                <div class="row mt-3"> 

                    <div class="col-12 col-md-4"></div>  

                    <div class="col-12 col-md-4">
                        <label for="formaPagamento">Forma de Pagamento*</label>
                        <select class="form-control" id="formaPagamento" name="formaPagamento" required>
                            <option ></option>
                            <option value="1">DINHEIRO</option>
                            <option value="2">DÉBITO</option>
                            <option value="3">CRÉDITO</option>
                            <option value="4">PIX-CONTA</option>
                        </select>
                    </div>  
                    
                     <div class="col-12 col-md-4">
                        <label for="fornecedor">Situação*</label>
                        <select class="form-control" id="situacao" name="situacao" required>
                            <option ></option>
                            <option> Registrado </option>
                            <option> Finalizado </option>
                            <option> Cancelado </option>
                            
                        </select>
                    </div>
                    
                </div>   
                
                <input type="hidden" name="id" id="id" >
                

                <div class="row mt-3">                    

                    <div class="col-12 col-md-12 text-right">
                       
                        <button class="btn btn-success" id="btnSalvar" type="submit">
                            <i class="fas fa-save"></i>  Atualizar 
                        </button>
                        <button type="button" class="btn btn-danger" data-dismiss="modal"><i class="fa fa-window-close"></i> Cancelar</button> 
                    </div>
                </div>
            </div>

            </form>

        </div>
    </div>
</div>



 
 <!-- Modal edição-->
 <div class="modal fade" id="alteraconta" tabindex="-1" role="dialog" aria-labelledby="editconta" aria-hidden="true">
    <div class="modal-dialog modal-lg" role="document">

        <div class="modal-content">
            <div class="modal-header card-header cor-card-header text-white d-flex justify-content-between bg-primary-gradient">
                <h5 class="modal-title" > Alterar Cliente ou Vencimento </h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>

            <form  method="POST" action="{{route('financeiro.conta_receber.alterar')}}" >
                    @csrf
            <div class="card-body">           

                
               
                <div class="row mt-3">                    
                  

                    <div class="col-12 col-md-8">
                        <label class="form-label" for="descricao">Cliente</label>
                        <select class="form-control" id="ecliente" name="ecliente" >
                            <option ></option>   
                            @foreach($listaclientes as $lista)
                                <option value="{{$lista->id}}">{{$lista->nome}}</option>
                            @endforeach                         
                        </select>                       
                    </div>

                    <div class="col-12 col-md-4">
                        <label class="form-label" for="descricao">Vencimento</label>
                        <input class="form-control" id="evenc" type="date" name="evenc" />                        
                    </div>

                   
                </div>  
                
                
                <input type="hidden" name="eid" id="eid" >
                

                <div class="row mt-3">                    

                    <div class="col-12 col-md-12 text-right">
                       
                        <button class="btn btn-success" id="btnSalvar" type="submit">
                            <i class="fas fa-save"></i>  Atualizar 
                        </button>
                        <button type="button" class="btn btn-danger" data-dismiss="modal"><i class="fa fa-window-close"></i> Cancelar</button> 
                    </div>
                </div>
            </div>

            </form>

        </div>
    </div>
</div>




 
 <!-- Modal adição-->
 <div class="modal fade" id="addConfirma" tabindex="-1" role="dialog" aria-labelledby="addconta" aria-hidden="true">
	<div class="modal-dialog" role="document">

		<div class="modal-content">
			<div class="modal-header card-header cor-card-header text-white d-flex justify-content-between bg-primary-gradient">
				<h5 class="modal-title" > Recebimentos de Vendas </h5>
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
					<span aria-hidden="true">&times;</span>
				</button>
			</div>

            <form  method="POST" action="{{route('financeiro.conta_receber.confirmar')}}" >
                    @csrf
            <div class="card-body"> 
    
                    <div class="row mt-3">  
                        
                        <div class="col-12 col-md-12">
                            <label for="formaPagamento">Forma de Pagamento</label>
                            <select class="form-control" id="fprec" name="fprec" required>
                                <option ></option>
                                <option value="1">DINHEIRO</option>
                                <option value="2">DÉBITO</option>
                                <option value="3">CRÉDITO</option>
                                <option value="4">PIX-CONTA</option>
                            </select>
                        </div> 
    
                    </div>    

                    <input type="hidden" name="idrec[]" id="idrec" >
    
                    <div class="row mt-3"> 
                        <div class="col-12 col-md-12 text-right">
                            <button class="btn btn-success" id="btnSalvar" type="submit">
                                <i class="fas fa-save"></i>  Confirmar
                            </button>
                            <button type="button" class="btn btn-danger" data-dismiss="modal"><i class="fa fa-window-close"></i> Cancelar</button> 
                        </div>
                    </div> 


            </div>

            </form>

		</div>
	</div>
</div>


@endsection