pagination.js 992 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. async function getNextId(Model, where, items) {
  2. try {
  3. let maxId = await Model.max('id', { where })
  4. let lastItem = items.slice(-1)[0]
  5. if(!lastItem || maxId === lastItem.id) {
  6. return null
  7. } else {
  8. return lastItem.id
  9. }
  10. } catch (e) {
  11. console.log(e)
  12. return null
  13. }
  14. }
  15. async function getPreviousId(Model, where, items, limit) {
  16. try {
  17. let minId = await Model.min('id', { where })
  18. let firstItem = items[0]
  19. if(!firstItem || minId === firstItem.id) {
  20. return null
  21. } else {
  22. return firstItem.id
  23. }
  24. } catch (e) {
  25. console.log(e)
  26. return null
  27. }
  28. }
  29. function getPaginationProps(query) {
  30. let from = 0
  31. let limit = 10
  32. if(+query.from > 0) from = +query.from
  33. if(+query.limit > 0) limit = +query.limit
  34. if(+query.postNumber > 0) {
  35. let lowerFrom = +query.postNumber - Math.floor(limit / 2) + 1
  36. if(lowerFrom < 0) {
  37. from = 0
  38. } else {
  39. from = lowerFrom
  40. }
  41. }
  42. return { from, limit }
  43. }
  44. module.exports = {
  45. getNextId,
  46. getPreviousId,
  47. getPaginationProps
  48. }