0
Como listar os cadastros por data ? (Dia e hora)
Olá, tenho um site com painel administrativo para concessionárias, porém, quando os carros vão sendo cadastrados, são exibidos por ordem alfabética, queria que fossem listador por ordem de cadastro, para que, quando um carro fosse cadastrado aparecesse no topo da lista .
Segue o index da parte de exibição dos carros:
INDEX
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<meta name="description" content="" />
<meta name="author" content="" />
<!--[if IE]>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<![endif]-->
<title>Admin</title>
<link href="//maxcdn.bootstrapcdn.com/bootswatch/3.3.5/cosmo/bootstrap.min.css" rel="stylesheet">
<link href="<?php echo Router::base(); ?>/assets/css/font-awesome.css" rel="stylesheet" />
<link href="<?php echo Router::base(); ?>/assets/css/style.css" rel="stylesheet" />
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<?php require_once 'View/adm/common/menu.php'; ?>
<div class="container-fluid back ">
<div class="container text-center">
<h4 class="page-head-line titulo">Autos</h4>
</div>
</div>
<div class="content-wrapper">
<div class="container">
<p class="text-right">
<a href="<?php echo Router::base(); ?>/auto/novo/" class="btn btn-primary">
<i class="fa fa-plus-circle">
Cadastrar Novo
</a>
</p>
<?php echo status::msg(); ?>
<?php if (isset($dados['auto'][0])): ?>
<table class="table table-striped table-bordered" id="tb1">
<tr>
<th width="150">Imagem</th>
<th class="hidden-xs">Marca</th>
<th class="hidden-xs">Modelo</th>
<th class="hidden-xs">Versão</th>
<!--<th width=100>Final Placa</th>-->
<th width=110 class="text-center hidden-xs">Em destaque</th>
<th class="text-center" width="180"><i class="fa fa-cog"</th>
</tr>
<?php foreach ($dados['auto'] as $obj): ?>
<tr>
<?php if ($obj->foto_url != ""): ?>
<td class="text-center"><img src="<?php echo Router::base(); ?>/midias/thumb.php?zc=1&w=267&h=207&src=fotos/<?php echo $obj->foto_url; ?>" style="height: 100px" alt="Foto" class="img-responsive"/> </td>
<?php else : ?>
<td class="text-center"><img src="<?php echo Router::base(); ?>/assets/img/sem.png" style="height: 100px" alt="Foto" class="img-responsive"/> </td>
<?php endif; ?>
<td class="text-uppercase hidden-xs" style="line-height: 100px"><?php echo $obj->marca_nome; ?></td>
<td class="text-uppercase hidden-xs" style="line-height: 100px"><?php echo $obj->modelo_nome; ?></td>
<td class="text-uppercase hidden-xs" style="line-height: 100px"> <?php echo $obj->versao_nome; ?></td>
<td class="text-center hidden-xs" style="line-height: 100px"> <?php echo ($obj->auto_destaque == 1) ? 'Sim' : 'Não'; ?></td>
<td class="text-center" style="line-height: 100px">
<a href="<?php echo Router::base(); ?>/auto/foto/<?php echo $obj->auto_id; ?>/"
class="btn btn-warning btn-sm" data-toggle="tooltip" title="Fotos"><i class="fa fa-photo">
</a>
<a href="<?php echo Router::base(); ?>/auto/editar/<?php echo $obj->auto_id; ?>/"
class="btn btn-primary btn-sm" data-toggle="tooltip" title="Editar"><i class="fa fa-edit">
</a>
<button data-link="<?php echo Router::base(); ?>/auto/remover/<?php echo $obj->auto_id; ?>/"
class="btn btn-danger btn-sm btn-remover-auto" data-toggle="tooltip" title="Remover"><i class="fa fa-trash">
</button>
</td>
</tr>
<?php endforeach; ?>
</table>
<?php else : ?>
<p class="well well-sm"> Nenhum registro encontrado!</p>
<?php endif; ?>
<div id="pageNav" class="text-center"></div>
</div>
</div>
<div class="modal fade" id="modal-remove-auto">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title">Remover Auto</h4>
</div>
<div class="modal-body">
<p>Você está prestes à remover um auto!</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancelar</button>
<a href="#" class="btn btn-danger" id="link-remover">Remover</a>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<?php require_once 'View/adm/common/rodape.php'; ?>
<script type="text/javascript" src="<?php echo Router::base(); ?>/assets/paginacao/paging.js"></script>
<script type="text/javascript">
<?php if (count($dados['auto']) >= 15) : ?>
var pager = new Pager('tb1', 15);
pager.init();
pager.showPageNav('pager', 'pageNav');
pager.showPage(1);
<?php endif; ?>
$(function () {
$("#menu-auto").addClass('menu-top-active');
$('[nasc-toggle="tooltip"]').tooltip();
});
setTimeout(function () {
$('.msg-status').slideUp();
}, 2500);
$(function () {
$('[data-toggle="tooltip"]').tooltip();
$('.btn-remover-auto').on('click', function () {
$('#modal-remove-auto').modal('show');
var link = $(this).data('link');
$('#link-remover').attr('href', link);
});
});
</script>
</body>
</html>
Segue o index da parte de exibição dos carros:
INDEX
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
<meta name="description" content="" />
<meta name="author" content="" />
<!--[if IE]>
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<![endif]-->
<title>Admin</title>
<link href="//maxcdn.bootstrapcdn.com/bootswatch/3.3.5/cosmo/bootstrap.min.css" rel="stylesheet">
<link href="<?php echo Router::base(); ?>/assets/css/font-awesome.css" rel="stylesheet" />
<link href="<?php echo Router::base(); ?>/assets/css/style.css" rel="stylesheet" />
<!--[if lt IE 9]>
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
<script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<body>
<?php require_once 'View/adm/common/menu.php'; ?>
<div class="container-fluid back ">
<div class="container text-center">
<h4 class="page-head-line titulo">Autos</h4>
</div>
</div>
<div class="content-wrapper">
<div class="container">
<p class="text-right">
<a href="<?php echo Router::base(); ?>/auto/novo/" class="btn btn-primary">
<i class="fa fa-plus-circle">
Cadastrar Novo
</a>
</p>
<?php echo status::msg(); ?>
<?php if (isset($dados['auto'][0])): ?>
<table class="table table-striped table-bordered" id="tb1">
<tr>
<th width="150">Imagem</th>
<th class="hidden-xs">Marca</th>
<th class="hidden-xs">Modelo</th>
<th class="hidden-xs">Versão</th>
<!--<th width=100>Final Placa</th>-->
<th width=110 class="text-center hidden-xs">Em destaque</th>
<th class="text-center" width="180"><i class="fa fa-cog"</th>
</tr>
<?php foreach ($dados['auto'] as $obj): ?>
<tr>
<?php if ($obj->foto_url != ""): ?>
<td class="text-center"><img src="<?php echo Router::base(); ?>/midias/thumb.php?zc=1&w=267&h=207&src=fotos/<?php echo $obj->foto_url; ?>" style="height: 100px" alt="Foto" class="img-responsive"/> </td>
<?php else : ?>
<td class="text-center"><img src="<?php echo Router::base(); ?>/assets/img/sem.png" style="height: 100px" alt="Foto" class="img-responsive"/> </td>
<?php endif; ?>
<td class="text-uppercase hidden-xs" style="line-height: 100px"><?php echo $obj->marca_nome; ?></td>
<td class="text-uppercase hidden-xs" style="line-height: 100px"><?php echo $obj->modelo_nome; ?></td>
<td class="text-uppercase hidden-xs" style="line-height: 100px"> <?php echo $obj->versao_nome; ?></td>
<td class="text-center hidden-xs" style="line-height: 100px"> <?php echo ($obj->auto_destaque == 1) ? 'Sim' : 'Não'; ?></td>
<td class="text-center" style="line-height: 100px">
<a href="<?php echo Router::base(); ?>/auto/foto/<?php echo $obj->auto_id; ?>/"
class="btn btn-warning btn-sm" data-toggle="tooltip" title="Fotos"><i class="fa fa-photo">
</a>
<a href="<?php echo Router::base(); ?>/auto/editar/<?php echo $obj->auto_id; ?>/"
class="btn btn-primary btn-sm" data-toggle="tooltip" title="Editar"><i class="fa fa-edit">
</a>
<button data-link="<?php echo Router::base(); ?>/auto/remover/<?php echo $obj->auto_id; ?>/"
class="btn btn-danger btn-sm btn-remover-auto" data-toggle="tooltip" title="Remover"><i class="fa fa-trash">
</button>
</td>
</tr>
<?php endforeach; ?>
</table>
<?php else : ?>
<p class="well well-sm"> Nenhum registro encontrado!</p>
<?php endif; ?>
<div id="pageNav" class="text-center"></div>
</div>
</div>
<div class="modal fade" id="modal-remove-auto">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title">Remover Auto</h4>
</div>
<div class="modal-body">
<p>Você está prestes à remover um auto!</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Cancelar</button>
<a href="#" class="btn btn-danger" id="link-remover">Remover</a>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<?php require_once 'View/adm/common/rodape.php'; ?>
<script type="text/javascript" src="<?php echo Router::base(); ?>/assets/paginacao/paging.js"></script>
<script type="text/javascript">
<?php if (count($dados['auto']) >= 15) : ?>
var pager = new Pager('tb1', 15);
pager.init();
pager.showPageNav('pager', 'pageNav');
pager.showPage(1);
<?php endif; ?>
$(function () {
$("#menu-auto").addClass('menu-top-active');
$('[nasc-toggle="tooltip"]').tooltip();
});
setTimeout(function () {
$('.msg-status').slideUp();
}, 2500);
$(function () {
$('[data-toggle="tooltip"]').tooltip();
$('.btn-remover-auto').on('click', function () {
$('#modal-remove-auto').modal('show');
var link = $(this).data('link');
$('#link-remover').attr('href', link);
});
});
</script>
</body>
</html>
comentários (0)
suspender
Lista de Respostas:
Nenhuma resposta foi publicada ainda.