PageRenderTime 50ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

/modules/menu/index.php

https://bitbucket.org/ssimpledecision/simpledecision
PHP | 163 lines | 152 code | 10 blank | 1 comment | 28 complexity | 60db1ea847b88b05103b45fe8eea796e MD5 | raw file
  1. <? include "../../inc/header_m.php";?>
  2. <?
  3. if (!empty($parent_home))
  4. $home_parent=" and parentid='$parent_home' ";
  5. $searchinmodul=$_POST['searchinmodul'];
  6. if (!empty($searchinmodul)){
  7. $searchinmodul=explode(' ', $searchinmodul);
  8. foreach ($searchinmodul as $key => $value) {
  9. $searchinmodules.="or UPPER(name) LIKE '%".strtoupper($value)."%' ";
  10. $searchinmodules.="or UPPER(text) LIKE '%".strtoupper($value)."%' ";
  11. }
  12. $searchinmodules=' ('.substr($searchinmodules, 2).') and ';
  13. }
  14. $del = $_POST['list'];
  15. $sor = $_POST['sor'];
  16. $del2 = $_POST['list2'];
  17. $sor2 = $_POST['sor2'];
  18. if (isset($del))
  19. foreach ($del as $delv)
  20. {
  21. if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$delv} $home_parent limit 1"))>0) {
  22. mysql_query("delete from {$pref}db_{$modul} where id={$delv} $home_parent");
  23. }}
  24. if (isset($sor))
  25. foreach ($sor as $sork=>$sorv)
  26. {
  27. if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$sork} $home_parent limit 1"))>0) {
  28. mysql_query("update {$pref}db_{$modul} set sort={$sorv} where id={$sork} $home_parent");
  29. }}
  30. if (isset($del2))
  31. foreach ($del2 as $delv2)
  32. {
  33. if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$delv2} $home_parent limit 1"))>0) {
  34. $sql1="select * from {$pref}db_pic where id_type={$id_modules} and id_el={$delv2} ";
  35. $query1=mysql_query($sql1);
  36. if ($query1 && mysql_num_rows($query1)>0)
  37. while ($res1=mysql_fetch_array($query1)) {
  38. $pic=$res1['pic'];
  39. unlink("{$_SERVER['DOCUMENT_ROOT']}/files/images/{$id_modules}/{$pic}");
  40. unlink("{$_SERVER['DOCUMENT_ROOT']}/files/images/{$id_modules}/mcith/mcith_{$pic}");
  41. }
  42. mysql_query("delete from {$pref}db_pic where id_type={$id_modules} and id_el={$delv2}");
  43. mysql_query("delete from {$pref}db_{$modul} where id={$delv2} $home_parent");
  44. }}
  45. if (isset($sor2))
  46. foreach ($sor2 as $sork2=>$sorv2)
  47. {
  48. if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$sork2} $home_parent limit 1"))>0) {
  49. mysql_query("update {$pref}db_{$modul} set sort={$sorv2} where id={$sork2} $home_parent");
  50. }}
  51. if (isset($_GET['sort'])) $_SESSION['sort'] = $_GET['sort'];
  52. if (isset($_SESSION['sort'])) $sort = $_SESSION['sort'];
  53. if (strpos($mod_ver,substr($sort,0,2))===false)
  54. $sort = 'sort';
  55. mysql_query("delete from {$pref}db_{$modul} where status=-1 and parentid='$parent_home'");
  56. $lim=30;
  57. if (isset($_GET['p'])) $p=$_GET['p']; else {$p=1;$_GET['p']=1;}
  58. $o=$p*$lim-$lim;
  59. $body='';
  60. if (isset($_GET['id_material'])) $id=$_GET['id_material'];
  61. if (isset($_POST['id_material'])) $id=$_POST['id_material'];
  62. if (empty($id)) $id=0;
  63. $breadcrumb=$id;
  64. if (!empty($breadcrumb)){
  65. $hlebkr=array();
  66. while ($breadcrumb<>0) {
  67. $title_hleb=mysql_result(mysql_query("select * from {$pref}db_{$modul} where id=$breadcrumb $home_parent"),0, 'name');
  68. $id_hleb=$breadcrumb;
  69. $breadcrumb=mysql_result(mysql_query("select * from {$pref}db_{$modul} where id=$breadcrumb $home_parent"),0, 'pid');
  70. array_push($hlebkr, "<div class='breadcrumb_divider'></div> <a href='?id_material=$id_hleb' class='current'>$title_hleb</a>");
  71. }
  72. }
  73. $breadcrumb='';
  74. krsort($hlebkr);
  75. foreach ($hlebkr as $key => $value) {
  76. $breadcrumb.=$value;
  77. }
  78. ////////////
  79. $query=mysql_query("select * from {$pref}db_{$modul} where {$searchinmodules} pid=$id $home_parent order by {$sort},id ");
  80. if (empty($id))
  81. $m_title="Меню";
  82. else
  83. $m_title="Пункты меню";
  84. $body.="
  85. <table class='tablesorter' cellspacing='0'>
  86. <thead>
  87. <tr>
  88. <th>ID</th>
  89. <th>Заголовок</th>
  90. <th>Сортировка</th>
  91. <th>Статус</th>
  92. <th>Редактировать</th>
  93. <td>Удалить<input type='checkbox' class='selectdelete'></td>
  94. </tr>
  95. </thead>
  96. <tbody>
  97. ";
  98. while ($res=mysql_fetch_array($query))
  99. {
  100. $body.="
  101. <tr>
  102. <td><a href='index.php?id_material={$res['id']}'>{$res['id']}</td>
  103. <td><a href='index.php?id_material={$res['id']}'>{$res['name']}</td>
  104. <td><span class='hid'>{$res['sort']}</span>
  105. <input type='text' size='3' name='sor[{$res['id']}]' value='{$res['sort']}' />
  106. </td>
  107. <td><span class='hid'>{$res['status']}</span><a class='statmat' id='_{$modul}-{$res['id']}-{$res['status']}' >
  108. <img src='{$pt}/{$cmspatch}/templates/img/{$res['status']}.gif' /></td>";
  109. if (empty($id))
  110. $body.="<td><a href='edit.categorie.php?id_material={$res['id']}'><img src='{$pt}{$tpl_admin}/images/icn_edit.png' /></td>";
  111. else
  112. $body.="<td><a href='edit.materials.php?id_material={$res['id']}'><img src='{$pt}{$tpl_admin}/images/icn_edit.png' /></td>";
  113. $body.="
  114. <td>
  115. <input type='checkbox' onclick='check();' name='list[]' class='listdelete' value='{$res['id']}' />
  116. </td>
  117. </tr>";
  118. }
  119. $body.="
  120. </tbody>
  121. </table>
  122. ";
  123. ?>
  124. <script>
  125. $(document).ready(function(){
  126. $('.modulForm').submit(function(){
  127. if (!confirm("Уверены, что хотите внести изменения?"))
  128. return false;
  129. })
  130. });
  131. </script>
  132. <form method='POST' acction='' class='modulForm' >
  133. <? if (isset($_POST['sf'])){?><h4 class="alert_success">Сохранено</h4><?}?>
  134. <article class="module width_full">
  135. <header><h3 class="tabs_involved"><?=$m_title?></h3>
  136. <!-- <ul class="tabs">
  137. <li><a href="#tab1">Список</a></li>
  138. </ul> -->
  139. </header>
  140. <div class="tab_container">
  141. <div id="tab1" class="tab_content">
  142. <?=$body?>
  143. </div></div>
  144. <footer>
  145. <div class="submit_link fl">
  146. </div>
  147. <div class="submit_link">
  148. <input type='submit' value='Сохранить' name='sf' />
  149. </div>
  150. </footer>
  151. </article>
  152. </form>
  153. <? include "../../inc/footer_m.php"; ?>