
<?php
 
    /* CADASTROS RECENTES */
	$select_db->ExeRead("*",  'fid_clientes', " WHERE  	fid_data_aniversario LIKE '%' :d '%'", "d={$data}");

	$mes_extenso = array(
        '01' => 'Janeiro',
        '02' => 'Fevereiro',
        '03' => 'Marco',
        '04' => 'Abril',
        '05' => 'Maio',
        '06' => 'Junho',
        '07' => 'Julho',
        '08' => 'Agosto',
        '09' => 'Setembro',
        '10' => 'Outubro',
        '11' => 'Novembro',
        '12' => 'Dezembro'
    );

?>	
        <div class="col-md-12">
<div class="row" style="background-color: #e8e8e8; margin-bottom: 15px">
            <div class="col-md-9">
                <h3 style="margin: 0">
                    <i class="fa fa-user color1"></i>
                    Aniversariantes <span style="font-size: 12px"> do mês de: <?php echo $mes_extenso[ date('m') ]; ?></span>
                </h3>
            </div>
            	<div class="col-md-3" style="margin-top:10px">
			<button type="button" class="simple-btn" onclick="TerminalAdmin.dashboard();">Voltar para Dashboard</button>
		</div>
     </div>
</div>
        
        <table class="table table-striped">
		<thead>
			<tr>
				<th style="text-align: center">Nome</th>
				<th style="text-align: center">CPF</th>
				<th style="text-align: center">E-mail</th>
				<th style="text-align: center">Celular</th>
				<th style="text-align: center">Data</th>
	
			</tr>
		</thead>
		<tbody>
	    
   <?php
	  
	  for($i=0;$i<count($select_db->getResult());$i++){
		  
		  echo '<tr class="color5">
		  <td style="text-align: center;color:#333;" class="col-md-3">'.$select_db->getResult()[$i]['fid_nome'].'</td>
		   <td style="text-align: center;color:#333;" class="col-md-3">'.$select_db->getResult()[$i]['fid_cpf'].'</td>
		   <td style="text-align: center;color:#333;" class="col-md-3">' .$select_db->getResult()[$i]['fid_email'].'</td>
		    <td style="text-align: center;color:#333;" class="col-md-3">'. $select_db->getResult()[$i]['fid_celular'].'</td>
			<td style="text-align: center;color:#333;" class="col-md-3">'.date('d/m/Y H:i:s', strtotime($select_db->getResult()[$i]['fid_data'])).'</td>
			</tr>';
		  
	  }
	  
	?>

			<tr style="background-color: #1E90FF; color: #fff">
				<td colspan="5">&nbsp;</td>
				<td>Saldo Final</td>
				<td style="text-align: center"></td>
			</tr>
			
		</tbody>
		</table>

    </div>