editgroup.php 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104
  1. <?php
  2. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/auth.php");
  3. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/languages/" . HTML_LANG . ".php");
  4. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/idfilter.php");
  5. if (isset($_POST["editgroup"])) {
  6. $new['group_name'] = $_POST["f_group_name"];
  7. $new['comment'] = $_POST["f_group_comment"];
  8. update_record($db_link, "Group_list", "id='$id'", $new);
  9. header("Location: " . $_SERVER["REQUEST_URI"]);
  10. exit;
  11. }
  12. if (isset($_POST["addfilter"])) {
  13. $filter_id = $_POST["newfilter"] * 1;
  14. list ($forder) = mysqli_fetch_array(mysqli_query($db_link, "SELECT MAX(GF.order) FROM Group_filters GF where group_id='$id'"));
  15. $forder ++;
  16. $new['group_id'] = $id;
  17. $new['filter_id'] = $filter_id;
  18. $new['order'] = $forder;
  19. insert_record($db_link, "Group_filters", $new);
  20. header("Location: " . $_SERVER["REQUEST_URI"]);
  21. exit;
  22. }
  23. if (isset($_POST["removefilter"])) {
  24. $fgid = $_POST["fgid"];
  25. foreach ($fgid as $key => $val) {
  26. if (!empty($val)) { delete_record($db_link, "Group_filters", "id=" . $val * 1); }
  27. }
  28. header("Location: " . $_SERVER["REQUEST_URI"]);
  29. exit;
  30. }
  31. if (isset($_POST["saveorder"])) {
  32. if ((isset($_POST["fgid"])) and (isset($_POST["ford"]))) {
  33. $fgid = $_POST["fgid"];
  34. $ford = $_POST["ford"];
  35. LOG_DEBUG($db_link, "Resort filter rules for group id: $id");
  36. foreach ($ford as $key => $val) {
  37. $gid = $fgid[$key];
  38. $new['order'] = $val;
  39. update_record($db_link, "Group_filters", "id=" . $gid, $new);
  40. }
  41. }
  42. header("Location: " . $_SERVER["REQUEST_URI"]);
  43. exit;
  44. }
  45. unset($_POST);
  46. $group = get_record_sql($db_link, "SELECT * FROM Group_list WHERE id=".$id);
  47. print_filters_submenu($page_url);
  48. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/header.php");
  49. ?>
  50. <div id="cont">
  51. <br> <b>Группа</b> <br>
  52. <form name="def" action="editgroup.php?id=<?php echo $id; ?>" method="post">
  53. <input type="hidden" name="id" value=<?php echo $id; ?>>
  54. <table class="data">
  55. <tr>
  56. <td>Название</td>
  57. <td><input type="text" name="f_group_name" value="<?php echo $group['group_name']; ?>"></td>
  58. <td>Комментарий</td>
  59. <td><input type="text" name="f_group_comment" value="<?php echo $group['comment']; ?>"></td>
  60. </tr>
  61. <tr>
  62. <td colspan=2><input type="submit" name="editgroup" value="Сохранить"></td>
  63. </tr>
  64. </table>
  65. <br> <b>Список фильтров группы</b><br>
  66. <table class="data">
  67. <tr>
  68. <td><input type="checkbox" onClick="checkAll(this.checked);"></td>
  69. <td>Order</td>
  70. <td>Название фильтра</td>
  71. <td align="right"><input type="submit" onclick="return confirm('Удалиьт фильтр?')" name="removefilter" value="Удалить"></td>
  72. </tr>
  73. <?php
  74. $sSQL = "SELECT G.id, G.filter_id, F.name, G.order, F.comment FROM Group_filters G, Filter_list F WHERE F.id=G.filter_id and group_id=$id Order by G.order";
  75. $flist = get_records_sql($db_link,$sSQL);
  76. foreach ($flist as $row) {
  77. print "<tr align=center>\n";
  78. print "<td class=\"data\" style='padding:0'><input type=checkbox name=fgid[] value=".$row['id']."></td>\n";
  79. print "<td class=\"data\" align=left><input type=text name=ford[] value=".$row['order']." size=4 ></td>\n";
  80. print "<td class=\"data\" align=left><a href=editfilter.php?id=".$row['filter_id'].">" . $row['name'] . "</a></td>\n";
  81. print "<td class=\"data\" align=left>" . $row['comment'] . "</a></td>\n";
  82. print "</tr>";
  83. }
  84. ?>
  85. </table>
  86. <table>
  87. <tr>
  88. <td><input type="submit" name="addfilter" value="Добавить фильтр"> <?php print_filter_select($db_link, 'newfilter', $id); ?> </td>
  89. <td align="right"><input type="submit" name="saveorder" value="Применить порядок"></td>
  90. </tr>
  91. </table>
  92. </form>
  93. <?php
  94. require_once ($_SERVER['DOCUMENT_ROOT']."/inc/footer.php");
  95. ?>