@extends('layouts.app')

@section('title', 'Cmor')

@section('content')

<h1><b>Cmor</b></h1>

    @isset($res_ee)
    <div class="ibox-title d-flex flex-column mb-2">
        <h2>Dati Elettrico</h2>
            <p><b>Pagamento Dalla Cassa:</b> {{$res_ee['pagato_dalla_cassa']}}€</p>
            <p><b>In Attesa:</b> {{$res_ee['in_attesa']}}€ </p>
            <p><b>Rifiutato: </b>{{$res_ee['rifiutato']}}€ </p>
    </div>
    @endisset
    <br>
    @isset($res_gas)
    <div class="ibox-title d-flex flex-column mb-2">
        <h2>Dati Gas</h2>
            <p><b>Pagamento Dalla Cassa:</b> {{$res_gas['pagato_dalla_cassa']}}€ </p>
            <p><b>In Attesa:</b> {{$res_gas['in_attesa']}}€ </p>
            <p><b>Rifiutato:</b> {{$res_gas['rifiutato']}}€</p>
    </div>
    @endisset
    {{-- 
    foreach($res_ee['nr_utenze'] as $nr) {
        if (array_key_exists($nr, $insoluti)){
           $insolutiSum += $insoluti[$nr];}
    }
    echo $insolutiSum; --}}

<br>
<div class="ibox-title">
    <h4>Aggiorna i dati inserendo i file sottostanti</h4>
    <div class="ibox-tools">
        <div class="row">

            <form action="{{ route('cmordata') }}" method="post" enctype="multipart/form-data">
                <input type="hidden" name="_token" value="{{ Session::token() }}" />

                    <div class="col-md-8">
                        <div class="row">
                            <label>File Cmor</label>
                            <div class="fileinput fileinput-new input-group {{$errors->has('file')?'has-error':''}}" data-provides="fileinput">
                                <div class="form-control" data-trigger="fileinput">
                                    <i class="glyphicon glyphicon-file fileinput-exists"></i>
                                    <span class="fileinput-filename"></span>
                                </div>
                                <span class="input-group-addon btn btn-primary btn-file" style="background:#1ab394!important;color:white;">
                                    <span class="fileinput-new">Seleziona file</span>
                                    <span class="fileinput-exists">cambia</span>
                                    <input type="file" name="cmor" accept=".xlsx, .csv" />
                                </span>
                                <a href="#" class="input-group-addon btn btn-danger fileinput-exists" data-dismiss="fileinput">Cancella</a>
                            </div>
                        </div>
                    </div>

                    <div class="col-md-8">
                        <div class="row">
                            <label>File Insoluti Utenze</label>
                            <div class="fileinput fileinput-new input-group {{$errors->has('file')?'has-error':''}}" data-provides="fileinput">
                                <div class="form-control" data-trigger="fileinput">
                                    <i class="glyphicon glyphicon-file fileinput-exists"></i>
                                    <span class="fileinput-filename"></span>
                                </div>
                                <span class="input-group-addon btn btn-primary btn-file" style="background:#1ab394!important;color:white;">
                                    <span class="fileinput-new">Seleziona file</span>
                                    <span class="fileinput-exists">cambia</span>
                                    <input type="file" name="insoluti" accept=".xlsx, .xls, .csv" />
                                </span>
                                <a href="#" class="input-group-addon btn btn-danger fileinput-exists" data-dismiss="fileinput">Cancella</a>
                            </div>
                        </div>
                    </div>

                <div class="col-md-12">
                    <button type="submit" class="btn btn-primary btn-lg center-block">Carica</button>
                </div>
                 <div class="clearfix"></div>
            </form>

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

@if(file_exists('./cmor/ELETTRICO.xlsx')) 
    <div class="ibox-title d-flex flex-column mb-2">
        <small>Sono già presenti nel sistema dei file, per avere la versione aggiornata usare il modulo sopra</small>
        <div><a href="{{ asset('/cmor/ELETTRICO.xlsx') }}">Scarica Excel Elettrico Dettagliato</a></div>
        <div><a href="{{ asset('/cmor/GAS.xlsx') }}">Scarica Excel Gas Dettagliato</a></div>
    </div>
@endif

{{-- @if(file_exists('./cmor/GAS.XLSX')) 
@endif --}}

@endsection