assign('ur_here', $_LANG['600_goods_diy_list']); $diy=''; $diy_list=array(); $diy=$db->getAll("select diy_name,diy_code,diy_cat from " . $ecs->table('diy_cat')); foreach($diy as $value) { if($value['diy_cat']) { $cat_names=''; $cats=explode(',',$value['diy_cat']); foreach($cats as $v) { $cat_name= $db->getOne("select cat_name from " . $ecs->table('category') . " where cat_id=$v"); if($cat_name) { $cat_names .= $cat_name . ','; } } $cat_names=substr($cat_names,0,strlen($cat_names)-1); $value['diy_cat']=$cat_names; } else { $value['diy_cat']=''; } $diy_list[]=$value; } $smarty->assign('full_page', 1); $smarty->assign('diy_list', $diy_list); assign_query_info(); $smarty->display('diy_list.htm'); } /*------------------------------------------------------ */ //-- 添加品牌 /*------------------------------------------------------ */ elseif ($_REQUEST['act'] == 'add') { $diy_code=$_REQUEST['code']; $smarty->assign('ur_here', $_LANG['601_diy_add']); $smarty->assign('action_link', array('text' => $_LANG['600_goods_diy_list'], 'href' => 'diy.php?act=list')); $smarty->assign('form_action', 'insert'); assign_query_info(); $diys=$db->getRow("select * from " .$ecs->table('diy_cat') . " where diy_code='$diy_code'"); if($diys['diy_cat']) { $cat_names=''; $cats=explode(',',$diys['diy_cat']); foreach($cats as $v) { $cat_name= $db->getOne("select cat_name from " . $ecs->table('category') . " where cat_id=$v"); if($cat_name) { $cat_names .= $cat_name . ','; } } $cat_names=substr($cat_names,0,strlen($cat_name)-1); $diys['diy_cat']=$cat_names; } else { $diys['diy_cat']="还没有为该类设置商品分类，请尽快设置！"; } $smarty->assign('diys', $diys); $smarty->assign('cat_list', cat_list(0)); $smarty->display('diy_info.htm'); } elseif ($_REQUEST['act'] == 'insert') { if(empty($_REQUEST['cat_id']) || $_REQUEST['cat_id']==0) { sys_msg('请选择下属分类'); } $diy_code=$_REQUEST['code']; $cat_ids=$_REQUEST['cat_id']; $cat_ids=implode(',',$cat_ids); $db->query("update " . $ecs->table('diy_cat') . " set diy_cat='$cat_ids' where diy_code='$diy_code'"); /* 清除缓存 */ clear_cache_files(); $link[0]['text'] = '返回到DIY分类管理'; $link[0]['href'] = 'diy.php?act=list'; sys_msg('编辑下属商品分类成功', 0, $link); } ?>