<div class="breadcrumb-holder">
    <div class="container-fluid">
        <ul class="breadcrumb">
            <li class="breadcrumb-item"><a href="./">Home</a></li>
            <li class="breadcrumb-item active">Requerimentos</li>
        </ul><!--/.breadcrumb -->
    </div><!---/.container-fluid -->
</div><!--/.breadcrumb-holder -->

<section class="dashboard-counts section-padding">
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12">
                <div class="card">
                    <div class="card-header d-flex align-items-center">
                        <h2 class="h5 display">Lista de Requerimentos</h2>
                    </div><!--/.card-header -->
                    <div class="card-footer">
                        <a href="?p=requerimento" class="btn btn-sm btn-success">
                            <i class="fa fa-plus"></i> Adicionar
                        </a>
                    </div>
                    <div class="card-body">
                        <table class="table table-striped" id="dataTables">
                            <thead>
                                <tr>
                                    <th>Nome</th>
                                    <th>Vereador</th>
                                    <th>Data</th>
                                    <th>Tipo</th>
                                    <th>Situação</th>
                                    <th class="no-sort col-30"></th>
                                    <th class="no-sort col-30"></th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
								$requerimentosDao = new \Dao\Requerimentos();
								$lst_requerimentos = $requerimentosDao->getLista($conecta);

								foreach ($lst_requerimentos as $item) {
									$nomeVereador = '';

									// Adicione informações de depuração

									$vereadoresDao = new \Dao\Vereadores();
									$vereadoresDao->getVereadorPorId($conecta, $item->id_vereador);

									// Adicione informações de depuração

									if ($vereadoresDao->id > 0) {
										$nomeVereador = $vereadoresDao->nome;
									}

									echo '
										<tr>
											<td>' . $item->cadastro_id . '</td>
											<td>' . $nomeVereador . '</td>
											<td>' . date('d/m/Y H:i:s', strtotime($item->data)) . '</td>
											<td>' . $item->tipo . '</td>
											<td>' . $item->situacao . '</td>
											<td><a href="?p=requerimento&id=' . base64_encode($item->id) . '" class="btn btn-sm btn-warning"><i class="fa fa-pencil"></i></a></td>
											<td><a href="?p=excluir&id=' . base64_encode($item->id) . '" class="btn btn-sm btn-danger btn-delete"><i class="fa fa-trash"></i></a></td>
										</tr>
									';
								}

								?>

                            </tbody>
                        </table>
                    </div><!--/.card-body -->
                </div><!--/.card -->
            </div><!--/.col-lg-12 -->
        </div><!--/.row -->
    </div><!--/.container-fluid -->
</section><!--/.dashboard-counts -->