/new/administrator/service_centres.asp

https://github.com/akabeko/fusionexcel · ASP · 86 lines · 82 code · 4 blank · 0 comment · 8 complexity · f4b6653aa8c2633c245199d7750e506e MD5 · raw file

  1. <!--#include file="../libraries.asp" -->
  2. <%
  3. Dim page_title
  4. page_title = "[Service Centres] Fusion Excel Content Management System"
  5. Dim RecordSet, sql
  6. %>
  7. <!--#include file="header.asp" -->
  8. <%
  9. if Request.ServerVariables("REQUEST_METHOD") = "POST" then
  10. if Request("delete") = 1 then
  11. call SetConnection(GetSCDbPath())
  12. call OpenDatabase()
  13. sql = "DELETE FROM service_centres WHERE service_centre_id IN (" & Request("action_service_centre_id") & ")"
  14. call ExecuteQuery(sql)
  15. call RedindexServiceCentres()
  16. Response.Redirect("services_centres.asp")
  17. end if
  18. end if
  19. %>
  20. <script type="text/javascript">
  21. function deleteConfirm() {
  22. var checkedVal = $("#id_service_centres_list input:checked");
  23. if(checkedVal.length > 0) {
  24. if(confirm("Delete " + checkedVal.length + " record(s)?")) {
  25. $("#id_service_centres_list").submit();
  26. }
  27. }
  28. }
  29. </script>
  30. <div style="float: left; margin-top: 15px;">
  31. <form method="post" action="service_centres.asp?search=title">
  32. <label for="id_search_text">Search: </label><input type="text" name="search_query" id="id_search_text" value="" size="50" style="border-radius: 5px; border: 1px solid #CCC;" />
  33. </form>
  34. </div>
  35. <div id="button_navigator">
  36. <a href="javascript::void(0)" onclick="deleteConfirm()" class="delete-btn" title="Delete Selected"></a>
  37. <a href="service_centre-edit.asp?action=add" class="new-btn" title="New Service Centre"></a>
  38. </div>
  39. <br />
  40. <%
  41. sql = "SELECT service_centre_id, country_name, publish, modified, modified_by FROM service_centres"
  42. if Request("search") = "title" and Request("search_query") <> "" then
  43. sql = sql & " WHERE country_name LIKE '%" & Replace(Request("search_query"), " ", "%") & "%'"
  44. end if
  45. sql = sql & " ORDER BY order_index"
  46. call SetConnection(GetSCDbPath())
  47. call OpenDatabase()
  48. call CreateRecordSet(RecordSet, sql)
  49. %>
  50. <form method="post" id="id_service_centres_list" action="service_centres.asp?delete=1">
  51. <table width="100%" border="0" cellspacing="0" cellpadding="0" class="service_centres_list listing">
  52. <thead>
  53. <tr>
  54. <td>&nbsp;</td>
  55. <td>ID</td>
  56. <td>Services Centres Title</td>
  57. <td>Publish</td>
  58. <td>Last Modified</td>
  59. <td>Last Modified By</td>
  60. </tr>
  61. </thead>
  62. <tbody>
  63. <% Do While not RecordSet.EOF %>
  64. <tr>
  65. <td><input type="checkbox" name="action_service_centre_id" value="<%= RecordSet("service_centre_id") %>" /></td>
  66. <td><%= RecordSet("service_centre_id") %></td>
  67. <td><a href="service_centre-edit.asp?action=edit&amp;id=<%= RecordSet("service_centre_id") %>"><%= RecordSet("country_name") %></a></td>
  68. <% if RecordSet("publish") then %>
  69. <td style="background: green; color: white;">Yes</td>
  70. <% else %>
  71. <td style="background: red; color: white;">No</td>
  72. <% end if %>
  73. <td><%= RecordSet("modified") %></td>
  74. <td><%= RecordSet("modified_by") %></td>
  75. </tr>
  76. <% RecordSet.MoveNext %>
  77. <% Loop %>
  78. </tbody>
  79. </table>
  80. </form>
  81. <% call CloseRecordSet(RecordSet) %>
  82. <!--#include file="footer.asp" -->