getRow('SELECT * FROM ' . $db_mymps . 'goods_category WHERE catid = \'' . $catid . '\'');
$here = '编辑商品分类';
include mymps_tpl('goods_category_edit');
} else {
if ($part == 'add') {
include MYMPS_DATA . '/category_tpl.inc.php';
$maxorder = $db->getOne('SELECT MAX(catorder) FROM ' . $db_mymps . 'goods_category');
$maxorder = $maxorder + 1;
$here = '添加商品分类';
include mymps_tpl('goods_category_add');
} else {
if ($part == 'del') {
empty($catid) && write_msg('没有选择记录');
mymps_delete('goods_category', 'WHERE catid = \'' . $catid . '\'');
mymps_delete('goods_category', 'WHERE parentid = \'' . $catid . '\'');
mymps_delete('goods', 'WHERE catid IN (' . mymps_get_goods_children($catid) . ')');
clear_cache_files('goods_category_option_static');
clear_cache_files('goods_category_pid_releate');
clear_cache_files('goods_category_tree');
write_msg('删除商品分类 ' . $catid . ' 成功', 'goods_category.php?part=list', 'Mymps');
}
}
}
}
} else {
if ($part == 'list') {
if (is_array($catorder)) {
foreach ($catorder as $key => $value) {
$db->query('UPDATE `' . $db_mymps . 'goods_category` SET catorder = \'' . $value . '\' WHERE catid = ' . $key);
}
}
if (is_array($if_viewids)) {
$db->query('UPDATE `' . $db_mymps . 'goods_category` SET if_view = \'1\' ');
foreach ($if_viewids as $key) {
$db->query('UPDATE `' . $db_mymps . 'goods_category` SET if_view = \'2\' WHERE catid = ' . $key);
}
} else {
$db->query('UPDATE `' . $db_mymps . 'goods_category` SET if_view = \'1\' ');
}
foreach (array('option_static', 'pid_releate', 'tree') as $range) {
clear_cache_files('goods_category_' . $range);
}
write_msg('商品分类更新成功！', '?part=list', 'record');
} else {
if ($part == 'add') {
$catname = explode('|', trim($catname));
$template = empty($template) ? 'list' : trim($template);
(empty($catname) || !is_array($catname)) && write_msg('请填写商品分类名称');
if (empty($catorder)) {
$sql = 'SELECT MAX(catorder) FROM ' . $db_mymps . 'goods_category';
$maxorder = $db->getOne($sql);
$catorder = $catorder + 1;
}
if (is_array($catname)) {
foreach ($catname as $key => $value) {
$value = trim($value);
$catorder++;
$len = strlen($value);
($len < 2 || 30 < $len) && write_msg('分类名必须在2个至30个字符之间');
$db->query('INSERT INTO ' . $db_mymps . 'goods_category (catname,if_view,title,keywords,description,parentid,catorder) VALUES (\'' . $value . '\',\'' . $isview . '\',\'' . $value . '\',\'' . $value . '\',\'' . $value . '\',\'' . $parentid . '\',\'' . $catorder . '\')');
}
foreach (array('option_static', 'pid_releate', 'tree') as $range) {
clear_cache_files('goods_category_' . $range);
}
$nav_path = '商品分类管理 » 增加商品分类';
$message = '成功增加商品分类';
$after_action = '继续增加商品分类' . "\r\n\t\t\t" . ' 已增加商品分类管理';
show_message($nav_path, $message, $after_action);
} else {
write_msg('商品分类分类添加失败，请按格式填写');
}
} else {
if ($part == 'edit') {
$template = empty($template) ? 'list' : trim($template);
empty($catname) && write_msg('请填写商品分类名称');
$catid == $parentid && write_msg('隶属商品分类不能为自己！');
$len = strlen($catname);
($len < 2 || 30 < $len) && write_msg('商品分类名必须在2个至30个字符之间');
$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 . '\'';
$res = $db->query($sql);
foreach (array('option_static', 'pid_releate', 'tree') as $range) {
clear_cache_files('goods_category_' . $range);
}
$nav_path = '商品分类管理 » 编辑商品分类';
$message = '成功编辑商品分类 ' . $catname;
$after_action = '继续增加商品分类' . "\r\n\t\t" . ' 重新编辑该商品分类 已增加商品分类管理';
show_message($nav_path, $message, $after_action);
}
}
}
}
is_object($db) && $db->Close();
$db = $mymps_global = $part = $action = $here = NULL;