<tr id="{{ ucwords($c->nom_enfant) }}">
<td><img class="avatar" src=" {{ $c->photo ? asset('uploads/'.$c->photo): asset('images/avatar4.jpg') }}"></td>
<td>{{ ucwords($c->nom_enfant) }}</td>
<td>{{ \Carbon\Carbon::parse($c->created_at)->format('d-m-Y') }} </td>
<td>
@foreach($c->classrooms as $cr)
{{ $cr->nom_classe }}
@endforeach
</td>
<td>
<?php
$counter = App\Bill::where('child_id', $c->id)->where('status', 0)->count();
?>
<span class="label {{ $counter == 0 ? 'label-success' : 'label-danger' }} label-mini">
<i class="fa fa-money"></i></span>
</td>
<td>{{ $c->schoolYear->ann_scol }}</td>
<td>
<a class="delete-child" href="{{ action('ChildrenController@delete',[$c->id]) }}" class="actions_icons">
<i class="fa fa-trash-o liste_icons"></i></a>
<!-- <a class="archive-child" href="{{ action('ChildrenController@archive',[$c->id]) }}"><i class="fa fa-archive liste_icons"></i>
</a> -->
</td>
<td><a href="{{ action('ChildrenController@show',[$c->id]) }}"><div class="btn_details">Détails</div></a></td>
</tr>
</div>
</div>
@endif
@if(Auth::user() && Auth::user()->isAdmin())
<div class="row">
<div class="col-md-4">
<section class="panel bloc">
<div class="panel-body">
<a href="{{ action('BillsController@indexnr') }}">
<div class="bloc_info"><img src="{{ asset('images/factures.png') }}" >
<span class="count">
<?php
echo App\Bill::where('status', 0)->where('user_id', \Auth::user()->id)->CurrentYear()->count();
?>
</span><p>Factures non réglées</p></div>
</a></div>
</section>
</div>
<div class="col-md-4">
<section class="panel bloc">
<div class="panel-body">
<a href="#">
<div class="bloc_info"><img src="{{ asset('images/anniversary.png') }}" >
<?php
$annv = \App\Child::where('user_id', \Auth::user()->id)->whereRaw('EXTRACT(month from date_naissance) = ?', [\Carbon\Carbon::now()->month])->whereRaw('EXTRACT(day from date_naissance) = ?', [\Carbon\Carbon::now()->day])->count();
?>
<span class="count">{{ $annv }}</span><p>Anniversaires</p></div>
</a></div>
<div class="nom">
<span>{{ $child->nom_enfant }}</span>
</div>
</div>
<div class="age_date">
<div class="age"><span>{{ $child->date_naissance->diffInYears(Carbon\Carbon::now()) }} ans</span><div class="age_sep_date"></div></div>
<div class="date"><span>{{ $child->date_naissance->format('d-m-Y') }}</span></div>
</div>
</section>
<section class="panel">
<a href="{{ action('BillsController@show',[$child->id]) }}">
<?php
$status = App\Bill::where('child_id', $child->id)->first();
?>
@if($status->status == 1)
<div class="panel-body paimenent_fiche_enfant">
<i class="fa fa-money"></i><span>Paiement effectué</span>
</div>
@else
<div class="panel-body paimenent_fiche_enfant" style="background-color:#d3423e">
<i class="fa fa-money"></i><span>Paiement effectué</span>
</div>
@endif
</a>
</section>
<section class="panel">
<a href="{{ action('AttendancesController@show',[$child->id]) }}">
</div>
<!-- <div class="age_date">
<div class="age"><span>46 ans</span><div class="age_sep_date"></div></div>
<div class="date"><span>09-04-1973</span></div>
</div> -->
</section>
@foreach($family->children as $child)
@unless($child->deleted_at)
<section class="panel" >
<a href="{{ action('BillsController@show',[$child->id]) }}" >
<?php
$status = App\Bill::where('child_id', $child->id)->where('user_id', \Auth::user()->id)->first();
?>
@unless($status->deleted_at)
@if($status->status == 1)
<div class="panel-body paimenent_fiche_enfant">
<i class="fa fa-money"></i><span>Paiement effectué </span>
</div>
@else
<div class="panel-body paimenent_fiche_enfant" style="background-color:#d3423e">
<i class="fa fa-money"></i><span>Paiement non effectué</span>
</div>
@endif
@endunless
</a>