data_table.go 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. package builder
  2. import (
  3. "fmt"
  4. "html"
  5. "math"
  6. "strconv"
  7. "golang-fave/engine/wrapper"
  8. )
  9. type DataTableRow struct {
  10. DBField string
  11. DBExp string
  12. NameInTable string
  13. Classes string
  14. CallBack func(values *[]string) string
  15. }
  16. func DataTable(wrap *wrapper.Wrapper, table string, order_by string, order_way string, data *[]DataTableRow, action func(values *[]string) string, pagination_url string) string {
  17. var num int
  18. err := wrap.DB.QueryRow("SELECT COUNT(*) FROM `" + table + "`;").Scan(&num)
  19. if err != nil {
  20. return ""
  21. }
  22. pear_page := 10
  23. max_pages := int(math.Ceil(float64(num) / float64(pear_page)))
  24. curr_page := 1
  25. p := wrap.R.URL.Query().Get("p")
  26. if p != "" {
  27. pi, err := strconv.Atoi(p)
  28. if err != nil {
  29. curr_page = 1
  30. } else {
  31. if pi < 1 {
  32. curr_page = 1
  33. } else if pi > max_pages {
  34. curr_page = max_pages
  35. } else {
  36. curr_page = pi
  37. }
  38. }
  39. }
  40. limit_offset := curr_page*pear_page - pear_page
  41. result := `<table id="cp-table-` + table + `" class="table data-table table-striped table-bordered table-hover table_` + table + `">`
  42. result += `<thead>`
  43. result += `<tr>`
  44. sql := "SELECT"
  45. for i, column := range *data {
  46. if column.NameInTable != "" {
  47. result += `<th scope="col" class="col_` + column.DBField + ` ` + column.Classes + `">` + html.EscapeString(column.NameInTable) + `</th>`
  48. }
  49. if column.DBExp == "" {
  50. sql += " `" + column.DBField + "`"
  51. } else {
  52. sql += " " + column.DBExp + " as `" + column.DBField + "`"
  53. }
  54. if i+1 < len(*data) {
  55. sql += ","
  56. }
  57. }
  58. sql += " FROM `" + table + "` ORDER BY `" + order_by + "` " + order_way + " LIMIT ?, ?;"
  59. if action != nil {
  60. result += `<th scope="col" class="col_action">&nbsp;</th>`
  61. }
  62. result += `</tr>`
  63. result += `</thead>`
  64. result += `<tbody>`
  65. if num > 0 {
  66. rows, err := wrap.DB.Query(sql, limit_offset, pear_page)
  67. if err == nil {
  68. values := make([]string, len(*data))
  69. scan := make([]interface{}, len(values))
  70. for i := range values {
  71. scan[i] = &values[i]
  72. }
  73. for rows.Next() {
  74. err = rows.Scan(scan...)
  75. if err == nil {
  76. result += `<tr>`
  77. for i, val := range values {
  78. if (*data)[i].NameInTable != "" {
  79. if (*data)[i].CallBack == nil {
  80. result += `<td class="col_` + (*data)[i].DBField + ` ` + (*data)[i].Classes + `">` + html.EscapeString(string(val)) + `</td>`
  81. } else {
  82. result += `<td class="col_` + (*data)[i].DBField + ` ` + (*data)[i].Classes + `">` + (*data)[i].CallBack(&values) + `</td>`
  83. }
  84. }
  85. }
  86. if action != nil {
  87. result += `<td class="col_action">` + action(&values) + `</td>`
  88. }
  89. result += `</tr>`
  90. }
  91. }
  92. }
  93. } else {
  94. result += `<tr><td colspan="50">No any data found</td></tr>`
  95. }
  96. result += `</tbody></table>`
  97. // Show page navigation only if pages more then one
  98. if max_pages > 1 {
  99. result += `<nav>`
  100. result += `<ul class="pagination" style="margin-bottom:0px;">`
  101. class := ""
  102. if curr_page <= 1 {
  103. class = " disabled"
  104. }
  105. result += `<li class="page-item` + class + `">`
  106. result += `<a class="page-link" href="` + pagination_url + `?p=` + fmt.Sprintf("%d", curr_page-1) + `" aria-label="Previous">`
  107. result += `<span aria-hidden="true">&laquo;</span>`
  108. result += `<span class="sr-only">Previous</span>`
  109. result += `</a>`
  110. result += `</li>`
  111. for i := 1; i <= max_pages; i++ {
  112. class = ""
  113. if i == curr_page {
  114. class = " active"
  115. }
  116. result += `<li class="page-item` + class + `">`
  117. result += `<a class="page-link" href="` + pagination_url + `?p=` + fmt.Sprintf("%d", i) + `">` + fmt.Sprintf("%d", i) + `</a>`
  118. result += `</li>`
  119. }
  120. class = ""
  121. if curr_page >= max_pages {
  122. class = " disabled"
  123. }
  124. result += `<li class="page-item` + class + `">`
  125. result += `<a class="page-link" href="` + pagination_url + `?p=` + fmt.Sprintf("%d", curr_page+1) + `" aria-label="Next">`
  126. result += `<span aria-hidden="true">&raquo;</span>`
  127. result += `<span class="sr-only">Next</span>`
  128. result += `</a>`
  129. result += `</li>`
  130. result += `</ul>`
  131. result += `</nav>`
  132. }
  133. return result
  134. }