goods_category.php 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
  1. <?php
  2. //decode by http://dezend.qiling.org QQ 2859470
  3. define('CURSCRIPT', 'goods_category');
  4. require_once dirname(__FILE__) . '/global.php';
  5. require_once MYMPS_INC . '/db.class.php';
  6. require_once dirname(__FILE__) . '/include/color.inc.php';
  7. require_once dirname(__FILE__) . '/include/ifview.inc.php';
  8. @(require_once MYMPS_ROOT . '/plugin/goods/include/functions.php');
  9. (!defined('IN_ADMIN') || !defined('IN_MYMPS')) && exit('Access Denied');
  10. $part = $part ? $part : 'list';
  11. $cat_color = $color;
  12. if (!submit_check(CURSCRIPT . '_submit')) {
  13. if ($part == 'list') {
  14. chk_admin_purview('purview_商品分类');
  15. $f_cat = goods_cat_list('category', 0, 0, false);
  16. $here = '商品分类列表';
  17. include mymps_tpl('goods_category_list');
  18. } else {
  19. if ($part == 'edit') {
  20. include MYMPS_DATA . '/category_tpl.inc.php';
  21. $cat = $db->getRow('SELECT * FROM ' . $db_mymps . 'goods_category WHERE catid = \'' . $catid . '\'');
  22. $here = '编辑商品分类';
  23. include mymps_tpl('goods_category_edit');
  24. } else {
  25. if ($part == 'add') {
  26. include MYMPS_DATA . '/category_tpl.inc.php';
  27. $maxorder = $db->getOne('SELECT MAX(catorder) FROM ' . $db_mymps . 'goods_category');
  28. $maxorder = $maxorder + 1;
  29. $here = '添加商品分类';
  30. include mymps_tpl('goods_category_add');
  31. } else {
  32. if ($part == 'del') {
  33. empty($catid) && write_msg('没有选择记录');
  34. mymps_delete('goods_category', 'WHERE catid = \'' . $catid . '\'');
  35. mymps_delete('goods_category', 'WHERE parentid = \'' . $catid . '\'');
  36. mymps_delete('goods', 'WHERE catid IN (' . mymps_get_goods_children($catid) . ')');
  37. clear_cache_files('goods_category_option_static');
  38. clear_cache_files('goods_category_pid_releate');
  39. clear_cache_files('goods_category_tree');
  40. write_msg('删除商品分类 ' . $catid . ' 成功', 'goods_category.php?part=list', 'Mymps');
  41. }
  42. }
  43. }
  44. }
  45. } else {
  46. if ($part == 'list') {
  47. if (is_array($catorder)) {
  48. foreach ($catorder as $key => $value) {
  49. $db->query('UPDATE `' . $db_mymps . 'goods_category` SET catorder = \'' . $value . '\' WHERE catid = ' . $key);
  50. }
  51. }
  52. if (is_array($if_viewids)) {
  53. $db->query('UPDATE `' . $db_mymps . 'goods_category` SET if_view = \'1\' ');
  54. foreach ($if_viewids as $key) {
  55. $db->query('UPDATE `' . $db_mymps . 'goods_category` SET if_view = \'2\' WHERE catid = ' . $key);
  56. }
  57. } else {
  58. $db->query('UPDATE `' . $db_mymps . 'goods_category` SET if_view = \'1\' ');
  59. }
  60. foreach (array('option_static', 'pid_releate', 'tree') as $range) {
  61. clear_cache_files('goods_category_' . $range);
  62. }
  63. write_msg('商品分类更新成功!', '?part=list', 'record');
  64. } else {
  65. if ($part == 'add') {
  66. $catname = explode('|', trim($catname));
  67. $template = empty($template) ? 'list' : trim($template);
  68. (empty($catname) || !is_array($catname)) && write_msg('请填写商品分类名称');
  69. if (empty($catorder)) {
  70. $sql = 'SELECT MAX(catorder) FROM ' . $db_mymps . 'goods_category';
  71. $maxorder = $db->getOne($sql);
  72. $catorder = $catorder + 1;
  73. }
  74. if (is_array($catname)) {
  75. foreach ($catname as $key => $value) {
  76. $value = trim($value);
  77. $catorder++;
  78. $len = strlen($value);
  79. ($len < 2 || 30 < $len) && write_msg('分类名必须在2个至30个字符之间');
  80. $db->query('INSERT INTO ' . $db_mymps . 'goods_category (catname,if_view,title,keywords,description,parentid,catorder) VALUES (\'' . $value . '\',\'' . $isview . '\',\'' . $value . '\',\'' . $value . '\',\'' . $value . '\',\'' . $parentid . '\',\'' . $catorder . '\')');
  81. }
  82. foreach (array('option_static', 'pid_releate', 'tree') as $range) {
  83. clear_cache_files('goods_category_' . $range);
  84. }
  85. $nav_path = '商品分类管理 &raquo 增加商品分类';
  86. $message = '成功增加商品分类';
  87. $after_action = '<a href=\'?part=add\'><u>继续增加商品分类</u></a>' . "\r\n\t\t\t" . '&nbsp;&nbsp;<a href=\'?part=list\'><u>已增加商品分类管理</u></a>';
  88. show_message($nav_path, $message, $after_action);
  89. } else {
  90. write_msg('商品分类分类添加失败,请按格式填写');
  91. }
  92. } else {
  93. if ($part == 'edit') {
  94. $template = empty($template) ? 'list' : trim($template);
  95. empty($catname) && write_msg('请填写商品分类名称');
  96. $catid == $parentid && write_msg('隶属商品分类不能为自己!');
  97. $len = strlen($catname);
  98. ($len < 2 || 30 < $len) && write_msg('商品分类名必须在2个至30个字符之间');
  99. $sql = 'UPDATE ' . $db_mymps . 'goods_category SET catname=\'' . $catname . '\',if_view = \'' . $isview . '\',color=\'' . $fontcolor . '\',title=\'' . $title . '\',keywords=\'' . $keywords . '\',description=\'' . $description . '\',parentid=\'' . $parentid . '\',catorder=\'' . $catorder . '\' WHERE catid = \'' . $catid . '\'';
  100. $res = $db->query($sql);
  101. foreach (array('option_static', 'pid_releate', 'tree') as $range) {
  102. clear_cache_files('goods_category_' . $range);
  103. }
  104. $nav_path = '商品分类管理 &raquo 编辑商品分类';
  105. $message = '成功编辑商品分类 ' . $catname;
  106. $after_action = '<a href=\'?part=add\'><u>继续增加商品分类</u></a>' . "\r\n\t\t" . '&nbsp;&nbsp;<a href=\'?part=edit&catid=' . $catid . '\'><u>重新编辑该商品分类</u></a>&nbsp;&nbsp;<a href=\'?part=list#' . $catid . '\'><u>已增加商品分类管理</u></a>';
  107. show_message($nav_path, $message, $after_action);
  108. }
  109. }
  110. }
  111. }
  112. is_object($db) && $db->Close();
  113. $db = $mymps_global = $part = $action = $here = NULL;