<div class="col-md-4"> <div class="page-header"><h1>Clientes</h1></div> <?php $clients = get_list('cliente', 5, $connection); if (!empty($clients)) { echo '<table class="table"><thead><tr><th>#</th><th>Nome</th><th>Email</th><th>Telefone</th></tr></thead><tbody>'; foreach ($clients as $client) { echo '<tr><td>' . $client['id'] . '</td><td>' . $client['nome'] . '</td><td>' . $client['email'] . '</td><td>' . $client['telefone'] . '</td></tr>'; } echo '</tbody></table>'; } ?> </div> <div class="col-md-4"> <div class="page-header"><h1>Pedidos</h1></div> <?php $orders = get_list('pedido', 5, $connection); if (!empty($orders)) { echo '<table class="table"><thead><tr><th>Produto</th><th>Cliente</th></tr></thead><tbody>'; foreach ($orders as $order) { echo '<tr><td>' . get_name_by_id('produto', $order['produto_id'], $connection) . '</td><td>' . get_name_by_id('cliente', $order['cliente_id'], $connection) . '</td></tr>'; } echo '</tbody></table>'; } ?> </div> </div> <?php require_once 'footer.php';
</div> <div class="form-group"> <label for="client">Cliente:</label> <select class="form-control" id="client" name="client" required> <?php $clients = get_list('cliente', ' ', $connection); foreach ($clients as $client) { echo '<option value="' . $client['id'] . '">' . $client['nome'] . '</option>'; } ?> </select> </div> <input type="submit" class="btn btn-lg btn-success" /> </form> </div> <div class="col-md-4"> <?php $lasts = get_list('pedido', ' ', $connection); if (!empty($lasts)) { echo '<h3>Pedidos</h3><h6>Pedidos não podem ser alterados para preservar o histórico.</h6'; echo '<ul class="list-group">'; foreach ($lasts as $last) { echo '<li class="list-group-item"><h4 class="list-group-item-heading">' . get_name_by_id('produto', $last['produto_id'], $connection) . '</h4><p class="list-group-item-text">' . get_name_by_id('cliente', $last['cliente_id'], $connection) . '</p></li>'; } echo '</ul>'; } ?> </div> </div> <?php require_once 'footer.php';