Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. router.get('/turmas/page/:skip', (req, res) => {
  2. Turma.select(req, res)
  3. })
  4.  
  5. select: (req, res) => {
  6.  
  7. let page = 0;
  8. if (req.params) {
  9.  
  10. page = parseInt(req.params.skip) * 3
  11. }
  12.  
  13. console.log(page)
  14.  
  15. Turma.findAll({
  16. limit: 3,
  17. offset: page
  18. }).then((turmas => {
  19. res.render('turma/index', {
  20. title: "Tumas",
  21. titlePanel: "Turmas",
  22. turmas: turmas
  23. })
  24. }))
  25.  
  26. },
  27.  
  28. <%- include ./../layout/header %>
  29. <a href="/turmas/register">
  30. <button class="btn btn-success ">Nova turma</button>
  31. </a>
  32.  
  33.  
  34. <div class="container">
  35. <table class="table">
  36. <thead>
  37. <tr>
  38. <th>ID</th>
  39. <th>Nome</th>
  40. <th>Serie</th>
  41. <th>Opções</th>
  42. </tr>
  43. </thead>
  44.  
  45.  
  46.  
  47. <tbody>
  48. <% turmas.forEach((turma)=> { %>
  49. <tr>
  50. <td><%= turma.TR_ID %></td>
  51. <td><%= turma.TR_NAME%></td>
  52. <td><%= turma.TR_YEAR %> Ano</td>
  53. <td>
  54.  
  55. <a href="turmas/update/<%= turma.TR_ID %>">
  56. <button class="btn btn-warning"> Editar </button>
  57. </a>
  58.  
  59. <a href="turmas/delete/<%= turma.TR_ID %>">
  60. <button class="btn btn-danger"> Excluir </button>
  61. </a>
  62. </td>
  63. </tr>
  64.  
  65. <% })%>
  66.  
  67.  
  68. </tbody>
  69.  
  70.  
  71. </table>
  72.  
  73. <!-- Nav com as paginas -->
  74. <nav aria-label="...">
  75. <ul class="pagination">
  76. <li class="page-item disabled"><a class="page-link" href="#" tabindex="-1" aria-disabled="true">Previous</a></li>
  77. <li class="page-item"><a class="page-link" href="#">1</a></li>
  78. <li class="page-item active" aria-current="page">
  79. <a class="page-link" href="#">2 <span class="sr-only">(current)</span></a>
  80. </li>
  81. <li class="page-item"><a class="page-link" href="#">3</a></li>
  82. <li class="page-item">
  83. <a class="page-link" href="#">Next</a>
  84. </li>
  85. </ul>
  86. </nav>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement