editgroup.php 3.4 KB

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