ECSHOP商品分类批量增加
  • 分类:经验分享
  • 发表:2016-04-20
  • 围观(4,107)
  • 评论(0)

1、修改程序

/admin/category.php文件打开

约104行

$cat['cat_name']     = !empty($_POST['cat_name'])     ? trim($_POST['cat_name'])     : '';

下添加

$isall = (stristr($cat['cat_name'],",") <> "") ? 1 : 0;

约133行

if ($db->autoExecute($ecs->table('category'), $cat) !== false)
{
$cat_id = $db->insert_id();
if($cat['show_in_nav'] == 1)
{
$vieworder = $db->getOne("SELECT max(vieworder) FROM ". $ecs->table('nav') . " WHERE type = 'middle'");
$vieworder += 2;
//显示在自定义导航栏中
$sql = "INSERT INTO " . $ecs->table('nav') .
" (name,ctype,cid,ifshow,vieworder,opennew,url,type)".
" VALUES('" . $cat['cat_name'] . "', 'c', '".$db->insert_id()."','1','$vieworder','0', '" . build_uri('category', array('cid'=> $cat_id), $cat['cat_name']) . "','middle')";
$db->query($sql);
}
insert_cat_recommend($cat['cat_recommend'], $cat_id);

admin_log($_POST['cat_name'], 'add', 'category'); // 记录管理员操作
clear_cache_files(); // 清除缓存

改为:

/* 入库的操作 */
if ($isall)
{
$cat_name = $cat['cat_name'];
$cat_name = explode(",",$cat_name);
foreach ($cat_name AS $k)
{
$cat['cat_name'] = $k;
if ($db->autoExecute($ecs->table('category'), $cat) !== false)
{
$cat_id = $db->insert_id();
if($cat['show_in_nav'] == 1)
{
$vieworder = $db->getOne("SELECT max(vieworder) FROM ". $ecs->table('nav') . " WHERE type = 'middle'");
$vieworder += 2;
//显示在自定义导航栏中
$sql = "INSERT INTO " . $ecs->table('nav') .
" (name,ctype,cid,ifshow,vieworder,opennew,url,type)".
" VALUES('" . $cat['cat_name'] . "', 'c', '".$db->insert_id()."','1','$vieworder','0', '" . build_uri('category', array('cid'=> $cat_id), $cat['cat_name']) . "','middle')";
$db->query($sql);
}
insert_cat_recommend($cat['cat_recommend'], $cat_id);

}//结束
}
admin_log($_POST['cat_name'], 'add', 'category'); // 记录管理员操作
clear_cache_files(); // 清除缓存
/*添加链接*/
$link[0]['text'] = $_LANG['continue_add'];
$link[0]['href'] = 'category.php?act=add';

$link[1]['text'] = $_LANG['back_list'];
$link[1]['href'] = 'category.php?act=list';

sys_msg($_LANG['catadd_succed'], 0, $link);

}
else
{
if ($db->autoExecute($ecs->table('category'), $cat) !== false)
{
$cat_id = $db->insert_id();
if($cat['show_in_nav'] == 1)
{
$vieworder = $db->getOne("SELECT max(vieworder) FROM ". $ecs->table('nav') . " WHERE type = 'middle'");
$vieworder += 2;
//显示在自定义导航栏中
$sql = "INSERT INTO " . $ecs->table('nav') .
" (name,ctype,cid,ifshow,vieworder,opennew,url,type)".
" VALUES('" . $cat['cat_name'] . "', 'c', '".$db->insert_id()."','1','$vieworder','0', '" . build_uri('category', array('cid'=> $cat_id), $cat['cat_name']) . "','middle')";
$db->query($sql);
}
insert_cat_recommend($cat['cat_recommend'], $cat_id);

admin_log($_POST['cat_name'], 'add', 'category'); // 记录管理员操作
clear_cache_files(); // 清除缓存

/*添加链接*/
$link[0]['text'] = $_LANG['continue_add'];
$link[0]['href'] = 'category.php?act=add';

$link[1]['text'] = $_LANG['back_list'];
$link[1]['href'] = 'category.php?act=list';

sys_msg($_LANG['catadd_succed'], 0, $link);
}
}

2、修改模板

打开admin\templates\category_info.htm文件,约10行

<input type='text' name='cat_name' maxlength="20" value='{$cat_info.cat_name|escape:html}' size='27' />

改为

{if $form_act=="insert"}
<textarea name="cat_name" cols="35" rows="3">{$cat_info.cat_name|escape:html}</textarea> 多个分类以,分开
{else}
<input type='text' name='cat_name' maxlength="20" value='{$cat_info.cat_name|escape:html}' size='27' />{/if}

保存,OK。

已修改文件

admin

Top