新版小京东V5.0二次开发解密开源版，我给他添加了一个产品分类图片字段；调用不出来，这是为什么呢？

Question

这篇问题已被关闭，原因：问题质量差 - 问题太水、伸手党

新版小京东V5.0二次开发解密开源版，我给他添加了一个产品分类图片字段；调用不出来，这是为什么呢？

北风燕归来

6921330

发布于
2017-02-21

我看这http://home.51.com/quanhongsh...（ECSHOP给分类添加代表图）
我想给手机版产品分类下面加一个图片

添加产品分类图片成功，在后台可以添加上传成功了，就是调用失败了

这是admin/category.php文件
<?php

/**

ECSHOP 商品分类管理程序
============================================================================
版权所有 2005-2010 上海商派网络科技有限公司，并保留所有权利。
网站地址: http://www.ecshop.com；
这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
使用；不允许对程序代码以任何形式任何目的的再发布。
============================================================================
$Author: liuhui $
$Id: category.php 17063 2010-03-25 06:35:46Z liuhui $
*/

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');
$exc = new exchange($ecs->table("category"), $db, 'cat_id', 'cat_name');

/ act操作项的初始化 /
if (empty($_REQUEST['act']))
{

$_REQUEST['act'] = 'list';

}
else
{

$_REQUEST['act'] = trim($_REQUEST['act']);

}

/ 代码增加_start By jdy /
include_once(ROOT_PATH . '/includes/cls_image.php');

$image = new cls_image($_CFG['bgcolor']);
// 最大上传文件大小
$php_maxsize = ini_get('upload_max_filesize');
$htm_maxsize = '2M';

include_once(ROOT_PATH . 'includes/cls_image.php');
$image = new cls_image($_CFG['bgcolor']);
$catimg_dir="category_img";
$smarty->assign('data_dir', '/'.DATA_DIR. '/');
if($_REQUEST['cat_id']){

$parent_id=$GLOBALS['db']->getOne("select parent_id from ". $GLOBALS['ecs']->table('category') ." where cat_id='$_REQUEST[cat_id]' ");
$is_topcat= $parent_id==0 ? '1' : '0';
$smarty->assign('is_topcat',    $is_topcat);

}
if ($_REQUEST['act'] == 'drop_adimg_1')
{

$cat_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

/* 取得 adimg 名称 */
$sql = "SELECT cat_adimg_1 FROM " .$ecs->table('category'). " WHERE cat_id = '$cat_id'";
$adimg_name = $db->getOne($sql);

if (!empty($adimg_name))
{
    @unlink(ROOT_PATH . DATA_DIR . '/'. $catimg_dir .'/' .$adimg_name);
    $sql = "UPDATE " .$ecs->table('category'). " SET cat_adimg_1 = '' WHERE cat_id = '$cat_id'";
    $db->query($sql);
}
$link= array(array('text' => '返回商品分类编辑页', 'href' => 'category.php?act=edit&cat_id=' . $cat_id), array('text' => '返回商品分类列表页', 'href' => 'category.php?act=list'));
sys_msg('成功删除子分类广告图1', 0, $link);

}
elseif ($_REQUEST['act'] == 'drop_adimg_2')
{

$cat_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

/* 取得 adimg 名称 */
$sql = "SELECT cat_adimg_2 FROM " .$ecs->table('category'). " WHERE cat_id = '$cat_id'";
$adimg_name = $db->getOne($sql);

if (!empty($adimg_name))
{
    @unlink(ROOT_PATH . DATA_DIR . '/'. $catimg_dir .'/' .$adimg_name);
    $sql = "UPDATE " .$ecs->table('category'). " SET cat_adimg_2 = '' WHERE cat_id = '$cat_id'";
    $db->query($sql);
}
$link= array(array('text' => '返回商品分类编辑页', 'href' => 'category.php?act=edit&cat_id=' . $cat_id), array('text' => '返回商品分类列表页', 'href' => 'category.php?act=list'));
sys_msg('成功删除子分类广告图2', 0, $link);

}
/ 代码增加_end By jdy /

/------------------------------------------------------ /
//-- 商品分类列表
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'list')
{

/* 获取分类列表 */
$cat_list = cat_list(0, 0, false);
/* 模板赋值 */
$smarty->assign('ur_here',      $_LANG['04_category_list']);
$smarty->assign('action_link',  array('href' => 'category.php?act=add', 'text' => $_LANG['04_category_add']));
$smarty->assign('full_page',    1);

$smarty->assign('cat_info',     $cat_list);

/* 列表页面 */
assign_query_info();
$smarty->display('category_list.htm');

}

if ($_REQUEST['act'] == 'virtual_list')
{

/* 获取分类列表 */
$cat_list = cat_list1(0, 0, false);

/* 模板赋值 */
$smarty->assign('ur_here',      $_LANG['virtual_category_list']);
$smarty->assign('action_link',  array('href' => 'category.php?act=add_virtual', 'text' => $_LANG['04_category_add']));
$smarty->assign('full_page',    1);

$smarty->assign('cat_info',     $cat_list);

/* 列表页面 */
assign_query_info();
$smarty->display('category_virtual_list.htm');

}

/------------------------------------------------------ /
//-- 排序、分页、查询
/------------------------------------------------------ /
elseif ($_REQUEST['act'] == 'query')
{

    $is_virtual = empty($_REQUEST['is_virtual'])? 0 : intval($_REQUEST['is_virtual']);
if(empty($_POST['cat_name']))
{
    /* 获取分类列表 */
    $cat_list = $is_virtual ? cat_list1(0, 0, false) : cat_list(0, 0, false);
}
// 如果查询条件不为空
else {
    $cat_list = search_cat($_POST['cat_name']);
}

$smarty->assign('cat_info',     $cat_list);

$is_virtual ? make_json_result($smarty->fetch('category_virtual_list.htm')): make_json_result($smarty->fetch('category_list.htm'));

}
/------------------------------------------------------ /
//-- 添加商品分类
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'add')
{

/* 权限检查 */
admin_priv('cat_manage');

/* 模板赋值 */
$smarty->assign('ur_here',      $_LANG['04_category_add']);
$smarty->assign('action_link',  array('href' => 'category.php?act=list', 'text' => $_LANG['04_category_list']));

$smarty->assign('goods_type_list',  goods_type_list(0)); // 取得商品类型
$smarty->assign('attr_list',        get_attr_list()); // 取得商品属性
$smarty->assign('is_virtual',        0); //  分类属性
$smarty->assign('cat_select',   cat_list(0, 0, true));
$smarty->assign('form_act',     'insert');
$smarty->assign('cat_info',     array('is_show' => 1));

/* 显示页面 */
assign_query_info();
$smarty->display('category_info.htm');

}

if ($_REQUEST['act'] == 'add_virtual')
{

/* 权限检查 */
admin_priv('cat_manage');

/* 模板赋值 */
$smarty->assign('ur_here',     '添加虚拟商品分类');
$smarty->assign('action_link',  array('href' => 'category.php?act=virtual_list', 'text' => $_LANG['04_category_list']));

$smarty->assign('goods_type_list',  goods_type_list(0)); // 取得商品类型
$smarty->assign('attr_list',        get_attr_list()); // 取得商品属性
$smarty->assign('cat_select',   get_virtual_cat_select());
$smarty->assign('is_virtual',        1); //  分类属性
$smarty->assign('form_act',     'insert');
$smarty->assign('cat_info',     array('is_show' => 1));

/* 显示页面 */
assign_query_info();
$smarty->display('category_virtual_info.htm');

}
/------------------------------------------------------ /
//-- 商品分类添加时的处理
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'insert')
{

/* 权限检查 */
admin_priv('cat_manage');

/ 初始化变量 /
/ 代码增加_start By szy /
$cat['is_virtual'] = !empty($_POST['is_virtual']) ? intval($_POST['is_virtual']) : 0;
/ 代码增加_end By szy /
$cat['cat_id'] = !empty($_POST['cat_id']) ? intval($_POST['cat_id']) : 0;
$cat['parent_id'] = !empty($_POST['parent_id']) ? intval($_POST['parent_id']) : 0;
$cat['sort_order'] = !empty($_POST['sort_order']) ? intval($_POST['sort_order']) : 0;
$cat['keywords'] = !empty($_POST['keywords']) ? trim($_POST['keywords']) : '';
$cat['cat_desc'] = !empty($_POST['cat_desc']) ? $_POST['cat_desc'] : '';
$cat['measure_unit'] = !empty($_POST['measure_unit']) ? trim($_POST['measure_unit']) : '';
$cat['show_in_nav'] = !empty($_POST['show_in_nav']) ? intval($_POST['show_in_nav']): 0;
$cat['style'] = !empty($_POST['style']) ? trim($_POST['style']) : '';
$cat['is_show'] = !empty($_POST['is_show']) ? intval($_POST['is_show']) : 0;
$cat['grade'] = !empty($_POST['grade']) ? intval($_POST['grade']) : 0;
$cat['filter_attr'] = !empty($_POST['filter_attr']) ? implode(',', array_unique(array_diff($_POST['filter_attr'],array(0)))) : 0;
/ 代码增加_start Byjdy /

$cat['category_index']       =  !empty($_POST['category_index'])  ? $_POST['category_index'] : '0';
$cat['category_index_dwt'] = !empty($_POST['category_index_dwt'])  ? $_POST['category_index_dwt'] : '0';
$cat['index_dwt_file']     = !empty($_POST['index_dwt_file'])  ? $_POST['index_dwt_file'] : '';
$cat['show_in_index']       =  !empty($_POST['show_in_index'])  ? $_POST['show_in_index'] : '0';
/* 代码增加 By  www.68ecshop.com Start */
$cat['show_goods_num']       =  !empty($_POST['show_goods_num'])  ? $_POST['show_goods_num'] : '0';
/* 代码增加 By  www.68ecshop.com End */
$cat['cat_nameimg']        =   basename($image->upload_image($_FILES['cat_nameimg'], $catimg_dir ));
$cat['cat_nameimg']        = $cat['cat_nameimg'] ?  $catimg_dir. '/' . $cat['cat_nameimg']  : '';
$cat['cat_adimg_1']        =   basename($image->upload_image($_FILES['cat_adimg_1'], $catimg_dir));
$cat['cat_adimg_1']        =     $cat['cat_adimg_1']  ?   $catimg_dir. '/' . $cat['cat_adimg_1']  :  '';
$cat['cat_adurl_1']        = !empty($_POST['cat_adurl_1']) ?  trim($_POST['cat_adurl_1'])      : '';
$cat['cat_adimg_2']        =   basename($image->upload_image($_FILES['cat_adimg_2'], $catimg_dir));
$cat['cat_adimg_2']        =     $cat['cat_adimg_2']  ?   $catimg_dir. '/' . $cat['cat_adimg_2']  :  '';
$cat['cat_adurl_2']        = !empty($_POST['cat_adurl_2']) ?  trim($_POST['cat_adurl_2'])      : '';
$cat['cat_index_rightad']        =   basename($image->upload_image($_FILES['cat_index_rightad'], $catimg_dir));
$cat['cat_index_rightad']        =     $cat['cat_index_rightad']  ?   $catimg_dir. '/' . $cat['cat_index_rightad']  :  '';
/* 代码增加_end Byjdy */

$cat['cat_recommend'] = !empty($_POST['cat_recommend']) ? $_POST['cat_recommend'] : array();$cat['filter_attr'] = !empty($_POST['filter_attr']) ? implode(',', array_unique(array_diff($_POST['filter_attr'],array(0)))) : 0;
$cat['cat_img'] = ''; //自定义上传分类图

$cat['cat_img_link']  = !empty($_POST['cat_img_link'])     ? trim($_POST['cat_img_link']) : '';
//检查是否有上传分类图片
if (isset($_FILES['cat_img']))
{
  //如果有错误
  if($_FILES['cat_img']['error'])
  {
   if ($_FILES['cat_img']['error'] == 0)
   {
    if (!$image->check_img_type($_FILES['cat_img']['type']))
    {
     sys_msg("上传的分类图类型无效", 1, array(), false);
    }
   }
   elseif ($_FILES['cat_img']['error'] == 1)
   {
    sys_msg(sprintf("上传的分类图超过了大小", $php_maxsize), 1, array(), false);
   }
   elseif ($_FILES['cat_img']['error'] == 2)
   {
    sys_msg(sprintf("上传的分类图超过了大小", $htm_maxsize), 1, array(), false);
   }
  }
  else  //没有错误检查是否存在temp目录
  {
   if ($_FILES['cat_img']['tmp_name'] != 'none')
   {
    if (!$image->check_img_type($_FILES['cat_img']['type']))
    {
     sys_msg('无效的分类图片', 1, array(), false);
    }
   }
  }
  //如果上传了分类图，则进行相应处理
  if ($_FILES['cat_img']['tmp_name'] != '' && $_FILES['cat_img']['tmp_name'] != 'none')
  {
   $catimg   = $image->upload_image($_FILES['cat_img']); // 上传的商品色彩图
   if ($catimg === false)
   {
    sys_msg($image->error_msg(), 1, array(), false);
   }
   else
   {
    $cat['cat_img'] = $catimg;
   }
  } 
}

$cat['cat_name'] = !empty($_POST['cat_name']) ? trim($_POST['cat_name']) : '';
$arrCatName = explode("," ,$cat['cat_name']);
/ 代码增加_start By www.ecshop68.com /
$cat['brand_qq'] = !empty($_POST['brand_wwwecshop68com']) ? $_POST['brand_wwwecshop68com'] : '';
$cat['attr_wwwecshop68com'] = !empty($_POST['attr_qq']) ? $_POST['attr_qq'] : '';

/* 代码增加_start  By   www.68ecshop.com  */
$cat['path_name']     = !empty($_POST['path_name'])     ? trim($_POST['path_name'])     : '';
if($cat['path_name'] != '')
{
    $is_have = $db->getOne("select cat_id  from ". $ecs->table('category') ." where path_name='$cat[path_name]' "); 
    if ($is_have)
    {
       $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
       sys_msg('对不起，已经存在同名目录', 0, $link);
    }
}
/* 代码增加_end  By   www.68ecshop.com  */

/ 代码增加_end By www.ecshop68.com /
foreach($arrCatName as $arrCatNameValue)
{
$cat['cat_name'] = $arrCatNameValue;

if (cat_exists($cat['cat_name'], $cat['parent_id']))
{
/ 同级别下不能有重复的分类名称 /

 $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
 sys_msg($_LANG['catname_exist'], 0, $link);

}

if($cat['grade'] > 10 || $cat['grade'] < 0)
{
/ 价格区间数超过范围 /

 $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
 sys_msg($_LANG['grade_error'], 0, $link);

}

/ 入库的操作 /
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(); // 清除缓存

/添加链接/
$link0 = $_LANG['continue_add'];
$link0 = $cat['is_virtual']? 'category.php?act=add_virtual':'category.php?act=add';

$link1 = $_LANG['back_list'];
$link1 = $cat['is_virtual']? 'category.php?act=virtual_list': 'category.php?act=list';

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

}

/------------------------------------------------------ /
//-- 编辑商品分类信息
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'edit')
{

admin_priv('cat_manage');   // 权限检查
$cat_id = intval($_REQUEST['cat_id']);
$cat_info = get_cat_info($cat_id);  // 查询分类信息数据
$attr_list = get_attr_list();
$filter_attr_list = array();

if ($cat_info['filter_attr'])
{
    $filter_attr = explode(",", $cat_info['filter_attr']);  //把多个筛选属性放到数组中

    foreach ($filter_attr AS $k => $v)
    {
        $attr_cat_id = $db->getOne("SELECT cat_id FROM " . $ecs->table('attribute') . " WHERE attr_id = '" . intval($v) . "'");
        $filter_attr_list[$k]['goods_type_list'] = goods_type_list($attr_cat_id);  //取得每个属性的商品类型
        $filter_attr_list[$k]['filter_attr'] = $v;
        $attr_option = array();
        
        if(!empty($attr_list)){
            foreach ($attr_list[$attr_cat_id] as $val)
            {
                $attr_option[key($val)] = current ($val);
            }
        }

        $filter_attr_list[$k]['option'] = $attr_option;
    }

    $smarty->assign('filter_attr_list', $filter_attr_list);
}
else
{
    $attr_cat_id = 0;
}

/* 模板赋值 */
$smarty->assign('is_virtual' , $cat_info['is_virtual']); //分类类型
$smarty->assign('attr_list',        $attr_list); // 取得商品属性
$smarty->assign('attr_cat_id',      $attr_cat_id);
$smarty->assign('ur_here',     '编辑虚拟商品分类');
$smarty->assign('action_link', array('text' => $_LANG['04_category_list'], 'href' => $cat_info['is_virtual']?'category.php?act=virtual_list':'category.php?act=list'));

//分类是否存在首页推荐
$res = $db->getAll("SELECT recommend_type FROM " . $ecs->table("cat_recommend") . " WHERE cat_id=" . $cat_id);
if (!empty($res))
{
    $cat_recommend = array();
    foreach($res as $data)
    {
        $cat_recommend[$data['recommend_type']] = 1;
    }
    $smarty->assign('cat_recommend', $cat_recommend);
}

$smarty->assign('cat_info',    $cat_info);
$smarty->assign('form_act',    'update');
$smarty->assign('cat_select',  $cat_info['is_virtual']?get_virtual_cat_select():cat_list(0, $cat_info['parent_id'], true));
$smarty->assign('goods_type_list',  goods_type_list(0)); // 取得商品类型

/* 显示页面 */
assign_query_info();
    //如果是虚拟商品则用虚拟分类模板
$cat_info['is_virtual']?$smarty->display('category_virtual_info.htm'):$smarty->display('category_info.htm');

}

elseif($_REQUEST['act'] == 'add_category')
{

$parent_id = empty($_REQUEST['parent_id']) ? 0 : intval($_REQUEST['parent_id']);
$category = empty($_REQUEST['cat']) ? '' : json_str_iconv(trim($_REQUEST['cat']));

if(cat_exists($category, $parent_id))
{
    make_json_error($_LANG['catname_exist']);
}
else
{
    $sql = "INSERT INTO " . $ecs->table('category') . "(cat_name, parent_id, is_show)" .
           "VALUES ( '$category', '$parent_id', 1)";

    $db->query($sql);
    $category_id = $db->insert_id();

    $arr = array("parent_id"=>$parent_id, "id"=>$category_id, "cat"=>$category);

    clear_cache_files();    // 清除缓存

    make_json_result($arr);
}

}

/------------------------------------------------------ /
//-- 编辑商品分类信息
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'update')
{

/* 权限检查 */
admin_priv('cat_manage');

/* 初始化变量 */
$is_virtual = !empty($_POST['is_virtual']) ? intval($_POST['is_virtual'])     : 0;
$cat_id              = !empty($_POST['cat_id'])       ? intval($_POST['cat_id'])     : 0;
$old_cat_name        = $_POST['old_cat_name'];
$cat['parent_id']    = !empty($_POST['parent_id'])    ? intval($_POST['parent_id'])  : 0;
$cat['sort_order']   = !empty($_POST['sort_order'])   ? intval($_POST['sort_order']) : 0;
$cat['keywords']     = !empty($_POST['keywords'])     ? trim($_POST['keywords'])     : '';
$cat['cat_desc']     = !empty($_POST['cat_desc'])     ? $_POST['cat_desc']           : '';
$cat['measure_unit'] = !empty($_POST['measure_unit']) ? trim($_POST['measure_unit']) : '';
$cat['cat_name']     = !empty($_POST['cat_name'])     ? trim($_POST['cat_name'])     : '';
$cat['is_show']      = !empty($_POST['is_show'])      ? intval($_POST['is_show'])    : 0;
$cat['show_in_nav']  = !empty($_POST['show_in_nav'])  ? intval($_POST['show_in_nav']): 0;
$cat['style']        = !empty($_POST['style'])        ? trim($_POST['style'])        : '';
$cat['grade']        = !empty($_POST['grade'])        ? intval($_POST['grade'])      : 0;
$cat['filter_attr']  = !empty($_POST['filter_attr'])  ? implode(',', array_unique(array_diff($_POST['filter_attr'],array(0)))) : 0;
$cat['cat_recommend']  = !empty($_POST['cat_recommend'])  ? $_POST['cat_recommend'] : array();
 $issave_catimg       = !empty($_POST['issave_catimg']) ? intval($_POST['issave_catimg']) : 1;
$cat['cat_img_link']  = !empty($_POST['cat_img_link'])     ? trim($_POST['cat_img_link']) : '';

         //检查是否有上传分类图片
         if (isset($_FILES['cat_img']))
         {
                   //如果有错误
                   if($_FILES['cat_img']['error'])
                   {
                            if ($_FILES['cat_img']['error'] == 0)
                            {
                                     if (!$image->check_img_type($_FILES['cat_img']['type']))
                                     {
                                               sys_msg("上传的分类图类型无效", 1, array(), false);
                                     }
                            }
                            elseif ($_FILES['cat_img']['error'] == 1)
                            {
                                     sys_msg(sprintf("上传的分类图超过了大小", $php_maxsize), 1, array(), false);
                            }
                            elseif ($_FILES['cat_img']['error'] == 2)
                            {
                                     sys_msg(sprintf("上传的分类图超过了大小", $htm_maxsize), 1, array(), false);
                            }
                   }
                   else  //没有错误检查是否存在temp目录
                   {
                            if ($_FILES['cat_img']['tmp_name'] != 'none')
                            {
                                     if (!$image->check_img_type($_FILES['cat_img']['type']))
                                     {
                                               sys_msg('无效的分类图片', 1, array(), false);
                                     }
                            }
                   }

                   //如果上传了分类图，则进行相应处理
                   if ($_FILES['cat_img']['tmp_name'] != '' && $_FILES['cat_img']['tmp_name'] != 'none')
                   {
                            $catimg   = $image->upload_image($_FILES['cat_img']); // 上传的商品色彩图
                            if ($catimg === false)
                            {
                                     sys_msg($image->error_msg(), 1, array(), false);
                            }
                            else
                            {
                                     $cat['cat_img'] = $catimg;
                            }

                            //检查是否存在上传的分类图,如果有则删除
                            $cat_img = $db->getOne('SELECT cat_img FROM ' .$ecs->table('category'). " WHERE cat_id='$cat_id'");
                            if($cat_img != '' && is_file('../' . $cat_img))
                            {
                                     @unlink('../' . $cat_img);
                            }        
                   }
         }

         if($issave_catimg == 2)
         {
                   //检查是否存在上传的分类图,如果有则删除
                   $cat_img = $db->getOne('SELECT cat_img FROM ' .$ecs->table('category'). " WHERE cat_id='$cat_id'");
                   if($cat_img != '' && is_file('../' . $cat_img))
                   {
                            @unlink('../' . $cat_img);
                            $cat['cat_img'] = '';
                   }
         }
 /*  代码增加_srat By www.ecshop68.com */
$cat['brand_qq']  = !empty($_POST['brand_wwwecshop68com']) ? $_POST['brand_wwwecshop68com'] : '';
$cat['attr_wwwecshop68com']  = !empty($_POST['attr_qq']) ? $_POST['attr_qq'] : '';
 /*  代码增加_end By www.ecshop68.com */
/* 代码增加_start Byjdy */


/* 代码增加_start  By   www.68ecshop.com  */
$cat['path_name']     = !empty($_POST['path_name'])     ? trim($_POST['path_name'])     : '';
if($cat['path_name'] != '')
{
    $is_have = $db->getOne("select count(*)  from ". $ecs->table('category') ." where cat_id !='$cat_id' and path_name='$cat[path_name]' "); 
    if ($is_have)
    {
       $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
       sys_msg('对不起，已经存在同名目录', 0, $link);
    }
}
/* 代码增加_end  By   www.68ecshop.com  */



$cat_imgs=$db->getOne("select cat_nameimg, cat_index_rightad, cat_adimg_1, cat_adimg_2  from ".$ecs->table("category")." where cat_id='$cat_id'");
if ($_FILES['cat_nameimg']['tmp_name'] != '' && $_FILES['cat_nameimg']['tmp_name'] != 'none')
{
    $cat['cat_nameimg'] = $catimg_dir. '/' .  basename($image->upload_image($_FILES['cat_nameimg'], $catimg_dir));
    /* 删除旧图片 */
    if (!empty($cat_imgs['cat_nameimg'])){
        @unlink(ROOT_PATH . DATA_DIR . '/'. $catimg_dir .'/' . $cat_imgs['cat_nameimg']);
    }
}
if ($_FILES['cat_index_rightad']['tmp_name'] != '' && $_FILES['cat_index_rightad']['tmp_name'] != 'none')
{
    $cat['cat_index_rightad'] = $catimg_dir. '/' .  basename($image->upload_image($_FILES['cat_index_rightad'], $catimg_dir));
    /* 删除旧图片 */
    if (!empty($cat_imgs['cat_index_rightad'])){
        @unlink(ROOT_PATH . DATA_DIR . '/'. $catimg_dir .'/' . $cat_imgs['cat_index_rightad']);
    }
}
if ($_FILES['cat_adimg_1']['tmp_name'] != '' && $_FILES['cat_adimg_1']['tmp_name'] != 'none')
{
    $cat['cat_adimg_1'] = $catimg_dir. '/' .  basename($image->upload_image($_FILES['cat_adimg_1'], $catimg_dir));
    /* 删除旧图片 */
    if (!empty($cat_imgs['cat_adimg_1'])){
        @unlink(ROOT_PATH . DATA_DIR . '/' .$catimg_dir. '/' . $cat_imgs['cat_adimg_1']);
    }
}
if ($_FILES['cat_adimg_2']['tmp_name'] != '' && $_FILES['cat_adimg_2']['tmp_name'] != 'none')
{
    $cat['cat_adimg_2'] = $catimg_dir. '/' .  basename($image->upload_image($_FILES['cat_adimg_2'], $catimg_dir));
    /* 删除旧图片 */
    if (!empty($cat_imgs['cat_adimg_2'])){
        @unlink(ROOT_PATH . DATA_DIR . '/' .$catimg_dir. '/' . $cat_imgs['cat_adimg_2']);
    }
}
$cat['cat_adurl_1']        = !empty($_POST['cat_adurl_1'])        ? sanitize_url(trim($_POST['cat_adurl_1']))      : '';
$cat['cat_adurl_2']        = !empty($_POST['cat_adurl_2'])        ? sanitize_url(trim($_POST['cat_adurl_2']))      : '';
$cat['category_index']       =  !empty($_POST['category_index'])  ? $_POST['category_index'] : '0';
$cat['category_index_dwt'] = (!empty($_POST['category_index_dwt']) && $cat['category_index'] != 0 && !empty($_POST['index_dwt_file'])) ? $_POST['category_index_dwt'] : '0';
$cat['index_dwt_file']     = (!empty($_POST['index_dwt_file']) && $cat['category_index'] != 0 && $cat['category_index_dwt'] != 0) ? $_POST['index_dwt_file'] : '';
$cat['show_in_index']       =  !empty($_POST['show_in_index'])  ? $_POST['show_in_index'] : '0';
/* 代码增加 By  www.68ecshop.com Start */
$cat['show_goods_num']       =  !empty($_POST['show_goods_num'])  ? $_POST['show_goods_num'] : '0';
/* 代码增加 By  www.68ecshop.com End */
/* 代码增加_end Byjdy */

/* 代码增加_start  By   www.68ecshop.com  */
$cat['path_name']     = !empty($_POST['path_name'])     ? trim($_POST['path_name'])     : '';
if($cat['path_name'] != ''){
    $is_have = $db->getOne("select count(*)  from ". $ecs->table('category') ." where cat_id !='$cat_id' and path_name='$cat[path_name]' "); 
    if ($is_have)
    {
       $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
       sys_msg('对不起，已经存在同名目录', 0, $link);
    }
}
/* 代码增加_end  By   www.68ecshop.com  */

/* 判断分类名是否重复 */

if ($cat['cat_name'] != $old_cat_name)
{
    if (cat_exists($cat['cat_name'],$cat['parent_id'], $cat_id))
    {
       $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
       sys_msg($_LANG['catname_exist'], 0, $link);
    }
}

/* 判断上级目录是否合法 */
$children = array_keys(cat_list($cat_id, 0, false));     // 获得当前分类的所有下级分类
if (in_array($cat['parent_id'], $children))
{
    /* 选定的父类是当前分类或当前分类的下级分类 */
   $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
   sys_msg($_LANG["is_leaf_error"], 0, $link);
}

if($cat['grade'] > 10 || $cat['grade'] < 0)
{
    /* 价格区间数超过范围 */
   $link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
   sys_msg($_LANG['grade_error'], 0, $link);
}

$dat = $db->getRow("SELECT cat_name, show_in_nav FROM ". $ecs->table('category') . " WHERE cat_id = '$cat_id'");

if ($db->autoExecute($ecs->table('category'), $cat, 'UPDATE', "cat_id='$cat_id'"))
{
    if($cat['cat_name'] != $dat['cat_name'])
    {
        //如果分类名称发生了改变
        $sql = "UPDATE " . $ecs->table('nav') . " SET name = '" . $cat['cat_name'] . "' WHERE ctype = 'c' AND cid = '" . $cat_id . "' AND type = 'middle'";
        $db->query($sql);
    }
    if($cat['show_in_nav'] != $dat['show_in_nav'])
    {
        //是否显示于导航栏发生了变化
        if($cat['show_in_nav'] == 1)
        {
            //显示
            $nid = $db->getOne("SELECT id FROM ". $ecs->table('nav') . " WHERE ctype = 'c' AND cid = '" . $cat_id . "' AND type = 'middle'");
            if(empty($nid))
            {
                //不存在
                $vieworder = $db->getOne("SELECT max(vieworder) FROM ". $ecs->table('nav') . " WHERE type = 'middle'");
                $vieworder += 2;
                $uri = build_uri('category', array('cid'=> $cat_id), $cat['cat_name']);

                $sql = "INSERT INTO " . $ecs->table('nav') . " (name,ctype,cid,ifshow,vieworder,opennew,url,type) VALUES('" . $cat['cat_name'] . "', 'c', '$cat_id','1','$vieworder','0', '" . $uri . "','middle')";
            }
            else
            {
                $sql = "UPDATE " . $ecs->table('nav') . " SET ifshow = 1 WHERE ctype = 'c' AND cid = '" . $cat_id . "' AND type = 'middle'";
            }
            $db->query($sql);
        }
        else
        {
            //去除
            $db->query("UPDATE " . $ecs->table('nav') . " SET ifshow = 0 WHERE ctype = 'c' AND cid = '" . $cat_id . "' AND type = 'middle'");
        }
    }

    //更新首页推荐
    insert_cat_recommend($cat['cat_recommend'], $cat_id);
    /* 更新分类信息成功 */
    clear_cache_files(); // 清除缓存
    admin_log($_POST['cat_name'], 'edit', 'category'); // 记录管理员操作

    /* 提示信息 */
    $link[] = array('text' => $_LANG['back_list'], 'href' => $is_virtual?'category.php?act=virtual_list':'category.php?act=list');
    sys_msg($_LANG['catedit_succed'], 0, $link);
}

}

/------------------------------------------------------ /
//-- 批量转移商品分类页面
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'move')
{

/* 权限检查 */
admin_priv('cat_drop');

$cat_id = !empty($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;

/* 模板赋值 */
$smarty->assign('ur_here',     $_LANG['move_goods']);
$smarty->assign('action_link', array('href' => 'category.php?act=list', 'text' => $_LANG['04_category_list']));

$smarty->assign('cat_select', cat_list(0, $cat_id, true));
$smarty->assign('form_act',   'move_cat');

/* 显示页面 */
assign_query_info();
$smarty->display('category_move.htm');

}

/------------------------------------------------------ /
//-- 批量转移虚拟商品分类页面
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'move_virtual')
{

/* 权限检查 */
admin_priv('cat_drop');

$cat_id = !empty($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;

/* 模板赋值 */
$smarty->assign('ur_here',     $_LANG['move_goods']);
$smarty->assign('action_link', array('href' => 'category.php?act=virtual_list', 'text' => $_LANG['04_category_list']));

$smarty->assign('cat_select', cat_list1(0, $cat_id, true));
$smarty->assign('form_act',   'move_virtual_cat');

/* 显示页面 */
assign_query_info();
$smarty->display('category_move.htm');

}

/------------------------------------------------------ /
//-- 处理批量转移虚拟商品分类的处理程序
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'move_virtual_cat')
{

/* 权限检查 */
admin_priv('cat_drop');

$cat_id        = !empty($_POST['cat_id'])        ? intval($_POST['cat_id'])        : 0;
$target_cat_id = !empty($_POST['target_cat_id']) ? intval($_POST['target_cat_id']) : 0;

/* 商品分类不允许为空 */
if ($cat_id == 0 || $target_cat_id == 0)
{
    $link[] = array('text' => $_LANG['go_back'], 'href' => 'category.php?act=move_virtual');
    sys_msg($_LANG['cat_move_empty'], 0, $link);
}

/* 更新商品分类 */
$sql = "UPDATE " .$ecs->table('goods'). " SET cat_id = '$target_cat_id' ".
       "WHERE cat_id = '$cat_id'";
if ($db->query($sql))
{
    /* 清除缓存 */
    clear_cache_files();

    /* 提示信息 */
    $link[] = array('text' => $_LANG['go_back'], 'href' => 'category.php?act=virtual_list');
    sys_msg($_LANG['move_cat_success'], 0, $link);
}

}

/------------------------------------------------------ /
//-- 处理批量转移商品分类的处理程序
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'move_cat')
{

/* 权限检查 */
admin_priv('cat_drop');

$cat_id        = !empty($_POST['cat_id'])        ? intval($_POST['cat_id'])        : 0;
$target_cat_id = !empty($_POST['target_cat_id']) ? intval($_POST['target_cat_id']) : 0;

/* 商品分类不允许为空 */
if ($cat_id == 0 || $target_cat_id == 0)
{
    $link[] = array('text' => $_LANG['go_back'], 'href' => 'category.php?act=move');
    sys_msg($_LANG['cat_move_empty'], 0, $link);
}

/* 更新商品分类 */
$sql = "UPDATE " .$ecs->table('goods'). " SET cat_id = '$target_cat_id' ".
       "WHERE cat_id = '$cat_id'";
if ($db->query($sql))
{
    /* 清除缓存 */
    clear_cache_files();

    /* 提示信息 */
    $link[] = array('text' => $_LANG['go_back'], 'href' => 'category.php?act=list');
    sys_msg($_LANG['move_cat_success'], 0, $link);
}

}

/------------------------------------------------------ /
//-- 编辑排序序号
/------------------------------------------------------ /

if ($_REQUEST['act'] == 'edit_sort_order')
{

check_authz_json('cat_manage');

$id = intval($_POST['id']);
$val = intval($_POST['val']);

if (cat_update($id, array('sort_order' => $val)))
{
    clear_cache_files(); // 清除缓存
    make_json_result($val);
}
else
{
    make_json_error($db->error());
}

}

/------------------------------------------------------ /
//-- 编辑数量单位
/------------------------------------------------------ /

if ($_REQUEST['act'] == 'edit_measure_unit')
{

check_authz_json('cat_manage');

$id = intval($_POST['id']);
$val = json_str_iconv($_POST['val']);

if (cat_update($id, array('measure_unit' => $val)))
{
    clear_cache_files(); // 清除缓存
    make_json_result($val);
}
else
{
    make_json_error($db->error());
}

}

/------------------------------------------------------ /
//-- 编辑排序序号
/------------------------------------------------------ /

if ($_REQUEST['act'] == 'edit_grade')
{

check_authz_json('cat_manage');

$id = intval($_POST['id']);
$val = intval($_POST['val']);

if($val > 10 || $val < 0)
{
    /* 价格区间数超过范围 */
    make_json_error($_LANG['grade_error']);
}

if (cat_update($id, array('grade' => $val)))
{
    clear_cache_files(); // 清除缓存
    make_json_result($val);
}
else
{
    make_json_error($db->error());
}

}

/------------------------------------------------------ /
//-- 切换是否显示在导航栏
/------------------------------------------------------ /

if ($_REQUEST['act'] == 'toggle_show_in_nav')
{

check_authz_json('cat_manage');

$id = intval($_POST['id']);
$val = intval($_POST['val']);

if (cat_update($id, array('show_in_nav' => $val)) != false)
{
    if($val == 1)
    {
        //显示
        $vieworder = $db->getOne("SELECT max(vieworder) FROM ". $ecs->table('nav') . " WHERE type = 'middle'");
        $vieworder += 2;
        $catname = $db->getOne("SELECT cat_name FROM ". $ecs->table('category') . " WHERE cat_id = '$id'");
        //显示在自定义导航栏中
        $_CFG['rewrite'] = 0;
        $uri = build_uri('category', array('cid'=> $id), $catname);

        $nid = $db->getOne("SELECT id FROM ". $ecs->table('nav') . " WHERE ctype = 'c' AND cid = '" . $id . "' AND type = 'middle'");
        if(empty($nid))
        {
            //不存在
            $sql = "INSERT INTO " . $ecs->table('nav') . " (name,ctype,cid,ifshow,vieworder,opennew,url,type) VALUES('" . $catname . "', 'c', '$id','1','$vieworder','0', '" . $uri . "','middle')";
        }
        else
        {
            $sql = "UPDATE " . $ecs->table('nav') . " SET ifshow = 1 WHERE ctype = 'c' AND cid = '" . $id . "' AND type = 'middle'";
        }
        $db->query($sql);
    }
    else
    {
        //去除
        $db->query("UPDATE " . $ecs->table('nav') . "SET ifshow = 0 WHERE ctype = 'c' AND cid = '" . $id . "' AND type = 'middle'");
    }
    clear_cache_files();
    make_json_result($val);
}
else
{
    make_json_error($db->error());
}

}

/------------------------------------------------------ /
//-- 切换是否显示
/------------------------------------------------------ /

if ($_REQUEST['act'] == 'toggle_is_show')
{

check_authz_json('cat_manage');

$id = intval($_POST['id']);
$val = intval($_POST['val']);

if (cat_update($id, array('is_show' => $val)) != false)
{
    clear_cache_files();
    make_json_result($val);
}
else
{
    make_json_error($db->error());
}

}

/------------------------------------------------------ /
//-- 删除商品分类
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'remove')
{

check_authz_json('cat_manage');

/* 初始化分类ID并取得分类名称 */
$cat_id   = intval($_GET['id']);
$sql = "select is_virtual from ".$ecs->table('category')." where cat_id = $cat_id";
$is_virtual = $db -> getOne($sql);

$cat_name = $db->getOne('SELECT cat_name FROM ' .$ecs->table('category'). " WHERE cat_id='$cat_id'");

/* 当前分类下是否有子分类 */
$cat_count = $db->getOne('SELECT COUNT(*) FROM ' .$ecs->table('category'). " WHERE parent_id='$cat_id'");

/* 当前分类下是否存在商品 */
$goods_count = $db->getOne('SELECT COUNT(*) FROM ' .$ecs->table('goods'). " WHERE cat_id='$cat_id'");

/* 如果不存在下级子分类和商品，则删除之 */
if ($cat_count == 0 && $goods_count == 0)
{
    /* 删除分类 */
    $sql = 'DELETE FROM ' .$ecs->table('category'). " WHERE cat_id = '$cat_id'";
    if ($db->query($sql))
    {
        $db->query("DELETE FROM " . $ecs->table('nav') . "WHERE ctype = 'c' AND cid = '" . $cat_id . "' AND type = 'middle'");
        clear_cache_files();
        admin_log($cat_name, 'remove', 'category');
    }
      //检查是否存在上传的分类图,如果有则删除
               $cat_img = $db->getOne('SELECT cat_img FROM ' .$ecs->table('category'). " WHERE cat_id='$cat_id'");
               if($cat_img != '' && is_file('../' . $cat_img))
               {
                        @unlink('../' . $cat_img);
               }
}
else
{
    make_json_error($cat_name .' '. $_LANG['cat_isleaf']);
}

$url = 'category.php?act=query&is_virtual='.$is_virtual.'&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);

ecs_header("Location: $url\n");
exit;

}
/ 代码增加 By www.68ecshop.com Start /
/------------------------------------------------------ /
//-- 批量导出商品分类
/------------------------------------------------------ /
if ($_REQUEST['act'] == 'export')
{

$is_virtual = empty($_REQUEST['is_virtual']) ? 0 : intval($_REQUEST['is_virtual']);

// 存在搜索关键字时根据关键字搜索
if (isset($_REQUEST['keyword']) && !empty($_REQUEST['keyword']))
{
    // 获取分类列表
    $cat_list = search_cat($_REQUEST['keyword']);
}
// 不存在搜索关键字时搜索全部
else
{
    $cat_list = $is_virtual ? cat_list1(0, 0, false) : cat_list(0, 0, false);
}

// 引入phpexcel核心类文件
require_once ROOT_PATH . '/includes/phpexcel/Classes/PHPExcel.php';
// 实例化excel类
$objPHPExcel = new PHPExcel();
// 操作第一个工作表
$objPHPExcel->setActiveSheetIndex(0);
// 设置sheet名
$objPHPExcel->getActiveSheet()->setTitle('商品分类');
// 设置表格宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15);
// 列名表头文字加粗
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getFont()->setBold(true);
// 列表头文字居中
$objPHPExcel->getActiveSheet()->getStyle('A1:G1')->getAlignment()
            ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// 列名赋值
$objPHPExcel->getActiveSheet()->setCellValue('A1', '分类名称');
$objPHPExcel->getActiveSheet()->setCellValue('B1', '商品数量');
$objPHPExcel->getActiveSheet()->setCellValue('C1', '数量单位');
$objPHPExcel->getActiveSheet()->setCellValue('D1', '导航栏');
$objPHPExcel->getActiveSheet()->setCellValue('E1', '是否显示');
$objPHPExcel->getActiveSheet()->setCellValue('F1', '价格分级');
$objPHPExcel->getActiveSheet()->setCellValue('G1', '排序');

// 数据起始行
$row_num = 2;
// 向每行单元格插入数据
foreach($cat_list as $key => $value)
{
    // 设置排序列、是否显示列居中显示
    $objPHPExcel->getActiveSheet()->getStyle('B' . $row_num . ':' . 'G' . $row_num)->getAlignment()
        ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    // 设置所有垂直居中
    $objPHPExcel->getActiveSheet()->getStyle('A' . $row_num . ':' . 'F' . $row_num)->getAlignment()
        ->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
    // 设置单元格数值
    $objPHPExcel->getActiveSheet()->setCellValue('A' . $row_num, echo_space($value['level']) . $value['cat_name']);
    $objPHPExcel->getActiveSheet()->setCellValue('B' . $row_num, $value['goods_num']);
    $objPHPExcel->getActiveSheet()->setCellValue('C' . $row_num, $value['measure_unit']);
    $objPHPExcel->getActiveSheet()->setCellValue('D' . $row_num, ($value['nav'] ? '√' : '×'));
    $objPHPExcel->getActiveSheet()->setCellValue('E' . $row_num, ($value['is_show'] ? '√' : '×'));
    $objPHPExcel->getActiveSheet()->setCellValue('F' . $row_num, $value['grade']);
    $objPHPExcel->getActiveSheet()->setCellValue('G' . $row_num, $value['sort_order']);
    $row_num++;
}
$outputFileName = '商品分类_' . time() . '.xls';
$xlsWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header('Content-Disposition:inline;filename="' . $outputFileName . '"');
header("Content-Transfer-Encoding: binary");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
$xlsWriter->save("php://output");
echo file_get_contents($outputFileName);

}
/ 代码增加 By www.68ecshop.com End /

/------------------------------------------------------ /
//-- PRIVATE FUNCTIONS
/------------------------------------------------------ /
//
///**
// * 检查分类是否已经存在
// *
// * @param string $cat_name 分类名称
// * @param integer $parent_cat 上级分类
// * @param integer $exclude 排除的分类ID
// *
// * @return boolean
// */
//function cat_exists($cat_name, $parent_cat, $exclude = 0)
//{
// $sql = "SELECT COUNT(*) FROM " .$GLOBALS['ecs']->table('category').
// " WHERE parent_id = '$parent_cat' AND cat_name = '$cat_name' AND cat_id<>'$exclude'";
// return ($GLOBALS['db']->getOne($sql) > 0) ? true : false;
//}

/**

获得商品分类的所有信息
*
@param integer $cat_id 指定的分类ID
*
@return mix
*/

function get_cat_info($cat_id)
{

$sql = "SELECT * FROM " .$GLOBALS['ecs']->table('category'). " WHERE cat_id='$cat_id' LIMIT 1";
return $GLOBALS['db']->getRow($sql);

}

/**

添加商品分类
*
@param integer $cat_id
@param array $args
*
@return mix
*/

function cat_update($cat_id, $args)
{

if (empty($args) || empty($cat_id))
{
    return false;
}

return $GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('category'), $args, 'update', "cat_id='$cat_id'");

}

/**

获取属性列表
*
@access public
@param
*
@return void
*/

function get_attr_list()
{

$sql = "SELECT a.attr_id, a.cat_id, a.attr_name ".
       " FROM " . $GLOBALS['ecs']->table('attribute'). " AS a,  ".
       $GLOBALS['ecs']->table('goods_type') . " AS c ".
       " WHERE  a.cat_id = c.cat_id AND c.enabled = 1 ".
       " ORDER BY a.cat_id , a.sort_order";

$arr = $GLOBALS['db']->getAll($sql);

$list = array();

foreach ($arr as $val)
{
    $list[$val['cat_id']][] = array($val['attr_id']=>$val['attr_name']);
}

return $list;

}

/**

插入首页推荐扩展分类
*
@access public
@param array $recommend_type 推荐类型
@param integer $cat_id 分类ID
*
@return void
*/

function insert_cat_recommend($recommend_type, $cat_id)
{

//检查分类是否为首页推荐
if (!empty($recommend_type))
{
    //取得之前的分类
    $recommend_res = $GLOBALS['db']->getAll("SELECT recommend_type FROM " . $GLOBALS['ecs']->table("cat_recommend") . " WHERE cat_id=" . $cat_id);
    if (empty($recommend_res))
    {
        foreach($recommend_type as $data)
        {
            $data = intval($data);
            $GLOBALS['db']->query("INSERT INTO " . $GLOBALS['ecs']->table("cat_recommend") . "(cat_id, recommend_type) VALUES ('$cat_id', '$data')");
        }
    }
    else
    {
        $old_data = array();
        foreach($recommend_res as $data)
        {
            $old_data[] = $data['recommend_type'];
        }
        $delete_array = array_diff($old_data, $recommend_type);
        if (!empty($delete_array))
        {
            $GLOBALS['db']->query("DELETE FROM " . $GLOBALS['ecs']->table("cat_recommend") . " WHERE cat_id=$cat_id AND recommend_type " . db_create_in($delete_array));
        }
        $insert_array = array_diff($recommend_type, $old_data);
        if (!empty($insert_array))
        {
            foreach($insert_array as $data)
            {
                $data = intval($data);
                $GLOBALS['db']->query("INSERT INTO " . $GLOBALS['ecs']->table("cat_recommend") . "(cat_id, recommend_type) VALUES ('$cat_id', '$data')");
            }
        }
    }
}
else
{
    $GLOBALS['db']->query("DELETE FROM ". $GLOBALS['ecs']->table("cat_recommend") . " WHERE cat_id=" . $cat_id);
}

}

/**

根据关键词搜索商品分类
*
@access public
*
@return mix
*/

/ 代码修改 By www.68ecshop.com Start /
//function search_cat()
function search_cat($cat_name)
{
// if(empty($_POST['cat_name']))
// {
// return;
// }
/ 代码修改 By www.68ecshop.com End /

$res = NULL;

// 根据类别名称进行模糊查询
$sql = "SELECT c.cat_id, c.cat_name, c.measure_unit, c.parent_id, c.is_show, c.show_in_nav, c.grade, c.sort_order, COUNT(s.cat_id) AS has_children, 1 AS result ".
            'FROM ' . $GLOBALS['ecs']->table('category') . " AS c ".
            "LEFT JOIN " . $GLOBALS['ecs']->table('category') . " AS s ON s.parent_id=c.cat_id ".
            "GROUP BY c.cat_id ".
            /* 代码修改 By  www.68ecshop.com Start */

// "HAVING c.cat_name LIKE '%".$_POST['cat_name']."%' ".

            "HAVING c.cat_name LIKE '%".$cat_name."%' ".
            /* 代码修改 By  www.68ecshop.com End */
            'ORDER BY c.parent_id, c.sort_order ASC';
$res = $GLOBALS['db']->getAll($sql);

// 查询所有类别
$sql = "SELECT c.cat_id, c.cat_name, c.measure_unit, c.parent_id, c.is_show, c.show_in_nav, c.grade, c.sort_order, COUNT(s.cat_id) AS has_children ".
            'FROM ' . $GLOBALS['ecs']->table('category') . " AS c ".
            "LEFT JOIN " . $GLOBALS['ecs']->table('category') . " AS s ON s.parent_id=c.cat_id ".
            "GROUP BY c.cat_id ".
            'ORDER BY c.parent_id, c.sort_order ASC';
$res1 = $GLOBALS['db']->getAll($sql);

// 构建一个全分类的Map集合<cat_id, cat>
$cat_map = array();
foreach ($res1 as $cat)
{
    if(!empty($cat)){
        $cat_id = $cat['cat_id'];
        $cat_map[$cat_id] = $cat;
    }
}

// 对商品类别进行排序
$res1 = cat_options(0, $res1);

// 获取查询结果的上级所有父类别
$parents = array();
$cat_result = array();
foreach ($res as $cat)
{
    $cat_result[$cat['cat_id']] = 1;
    array_push($parents, $cat);
    get_cat_parents($parents, $cat_map, $cat['cat_id']);
}

// 重构集合，只包含将来返回结果所包含的类别
$cat_map = array();
foreach ($parents as $cat)
{
    $cat_map[$cat['cat_id']] = $cat;
}

// 移除与查询结果无关的类别
$res = array();
foreach ($res1 as $cat)
{
    if(!empty($cat_map[$cat['cat_id']])){
        // 标识出匹配查询条件的结果
        if(empty($cat_result[$cat['cat_id']])){
            $cat['is_result'] = 2;
        }else{
            $cat['is_result'] = 1;
        }
        array_push($res, $cat);
    }
}

return $res;

}

/**

获取指定类别ID的所有上级类别并存放到指定数组中
@access private
@param $parents 存放所有上级类别
@param $cat_map 存放所有类别的Map集合
@param $cat_id 待获取上级类别的类别ID
*/

function get_cat_parents(&$parents, $cat_map, $cat_id)
{


if(empty($parents)){
    $parents = array();
}

$cat = $cat_map[$cat_id];
$parent_id = $cat['parent_id'];

$cat = $cat_map[$parent_id];

if($parent_id != 0)
{
    // 递归
    get_cat_parents($parents, $cat_map, $parent_id);
}

array_push($parents, $cat);

}

/**

获取虚拟团购分类一级列表
@return type
*/

function get_virtual_cat_select(){

$sql = "select cat_id,cat_name from ".$GLOBALS['ecs']->table('category')." where is_virtual = 1 and parent_id = 0";
$res = $GLOBALS['db']->getAll($sql);
$cat_select = '';
foreach($res as $k=>$v){
    $cat_select .= "<option value='$v[cat_id]]'>$v[cat_name]</option>";
}
$cat_select .="</option>";
return $cat_select;

}

/ 代码增加 By www.68ecshop.com Start /
/** $exc = new exchange($ecs->table("category"), $db, 'cat_id', 'cat_name');

输出指定数目的空格
@return $text
*/

function echo_space($num)
{

$text = '';
for ($i = 0; $i < $num; $i++)
{
    $text .= '        ';
}
return $text;

}
/ 代码增加 By www.68ecshop.com End /
?>
这是admin/templates/category_info.htm

{include file="pageheader.htm"}

<div class="main-div">
<form action="category.php" method="post" name="theForm" enctype="multipart/form-data" onsubmit="return validate()">

{ 代码增加_start By www.68ecshop.com } { 代码增加_end By www.68ecshop.com }

{$lang.cat_name}: <textarea name='cat_name' rows="3" cols="48">{$cat_info.cat_name|escape:html}</textarea> <font color="red">*</font> <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeCat_name">{$lang.notice_cat_name}</span>

目录名称: <input type='text' name='path_name' maxlength="20" value='{$cat_info.path_name|escape:html}' size='27' /> <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticePathname">生成的【真静态HTML文件】将保存到该目录下
例如：在这里输入 jiaju，根目录下就会生成一个 category-jiaju 的二级目录用来保存纯静态HTML文件</span>

{$lang.parent_id}: <select name="parent_id"> <option value="0">{$lang.cat_top}</option> {$cat_select} </select>

{$lang.measure_unit}: <input type="text" name='measure_unit' value='{$cat_info.measure_unit}' size="12" />

{$lang.sort_order}: <input type="text" name='sort_order' {if $cat_info.sort_order}value='{$cat_info.sort_order}'{else} value="50"{/if} size="15" />

{$lang.is_show}: <input type="radio" name="is_show" value="1" {if $cat_info.is_show neq 0} checked="true"{/if}/> {$lang.yes} <input type="radio" name="is_show" value="0" {if $cat_info.is_show eq 0} checked="true"{/if} /> {$lang.no}

{$lang.show_in_nav}: <input type="radio" name="show_in_nav" value="1" {if $cat_info.show_in_nav neq 0} checked="true"{/if}/> {$lang.yes} <input type="radio" name="show_in_nav" value="0" {if $cat_info.show_in_nav eq 0} checked="true"{/if} /> {$lang.no}

{$lang.show_in_index}: <input type="checkbox" name="cat_recommend[]" value="1" {if $cat_recommend[1] eq 1} checked="true"{/if}/> {$lang.index_best} <input type="checkbox" name="cat_recommend[]" value="2" {if $cat_recommend[2] eq 1} checked="true"{/if} /> {$lang.index_new} <input type="checkbox" name="cat_recommend[]" value="3" {if $cat_recommend[3] eq 1} checked="true"{/if} /> {$lang.index_hot}

<img src="images/notice.gif" width="16" height="16" border="0" alt="{$lang.notice_style}">{$lang.filter_attr}:

[+] <select onChange="changeCat(this)"><option value="0">{$lang.sel_goods_type}</option>{$goods_type_list}</select> <select name="filter_attr[]"><option value="0">{$lang.sel_filter_attr}</option></select>

{if $smarty.foreach.filter_attr_tab.iteration eq 1} [+] {else} [-] {/if} <select onChange="changeCat(this)"><option value="0">{$lang.sel_goods_type}</option>{$filter_attr.goods_type_list}</select> <select name="filter_attr[]"><option value="0">{$lang.sel_filter_attr}</option>{html_options options=$filter_attr.option selected=$filter_attr.filter_attr}</select>

      <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeFilterAttr">{$lang.filter_attr_notic}</span></td>
  </tr>
   {*代码增加_start By www.ecshop68.com*}

<!--隐藏lw <tr>

    <td class="label">品牌排序:</td>
    <td>
      <input type="text" name="brand_wwwecshop68com" size=60 value="{$cat_info.brand_qq}" /> (半角逗号间隔)
    </td>
  </tr>
   <tr>
    <td class="label">属性排序:</td>
    <td>
      <textarea name='attr_qq' rows="6" cols="68">{$cat_info.attr_wwwecshop68com}</textarea>
      <br>
      格式参考： 注意每个属性栏目占一行，如果一行乘不下，别管它，它会自动换行，只要没到下个属性栏目之前别按回车键就行<br><font color=#ff3300>颜色:红色,蓝色,白色,棕色,紫色<br>尺码:M,L,XL,XXL,XXL</font>
    </td>
  </tr>-->
  {*代码增加_end By www.ecshop68.com*}
  <tr>
    <td class="label"><a href="javascript:showNotice('noticeGrade');" title="{$lang.form_notice}"><img src="images/notice.gif" width="16" height="16" border="0" alt="{$lang.notice_style}"></a>{$lang.grade}:</td>
    <td><input type="text" name="grade" value="{$cat_info.grade|default:0}" size="40" />
      <br />
      <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeGrade">{$lang.notice_grade}</span></td>
  </tr>

<tr>

    <td class="label">{$lang.cat_img}:</td>  
<td>
<input name="cat_img" type="file" />
{if $cat_info.cat_img}
<img src="images/yes.gif" border="0" />
<span style="color:#F00">是否保留当前的分类图：</span>
是<input type="radio" name="issave_catimg" id="issave_catimg" value="1" checked="checked" />
否<input type="radio" name="issave_catimg" id="issave_catimg" value="2" />
{else}
<img src="images/no.gif" />
{/if}
</td>
</tr>
<tr>
<td class="label">分类图链接地址：</td>
<td>
<input name="cat_img_link" type="text" value='{$cat_info.cat_img_link}' maxlength="200" size="50" />
</td>
</tr>
<tr>
    <td class="label"><a href="javascript:showNotice('noticeGoodsSN');" title="{$lang.form_notice}"><img src="images/notice.gif" width="16" height="16" border="0" alt="{$lang.notice_style}"></a>{$lang.cat_style}:</td>
    <td><input type="text" name="style" value="{$cat_info.style|escape}" size="40" />
      <br />
      <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeGoodsSN">{$lang.notice_style}</span></td>
  </tr>
  <tr>
    <td class="label">{$lang.keywords}:</td>
    <td><input type="text" name="keywords" value='{$cat_info.keywords}' size="50"></td>
  </tr>
  <tr>
    <td class="label">{$lang.cat_desc}:</td>
    <td><text
    <td class="label"><font color=#ff3300>是否更改频道首页默认模版:</font></td>
    <td>
      <input id="index_dwt_1" type="radio" name="category_index_dwt" value="1" {if $cat_info.category_index_dwt eq '1'}checked=checked{/if} onclick="_index_dwt('index_dwt_file', 1)" >更改
      <input id="index_dwt_0" type="radio" name="category_index_dwt" value="0" {if !$cat_info.category_index_dwt}checked=checked{/if} onclick="_index_dwt('index_dwt_file', 0)" >使用默认
       <br>
      <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeGoodsSN">注意：只有启用频道首页才需要设置“是否更改”。</span>
    </td>
  </tr>
  <tr id="index_dwt_file" style="display:{if $cat_info.category_index eq '1' && $cat_info.category_index_dwt eq '1'}{else}none{/if}">
    <td class="label"><font color=#ff3300>选择模版文件:</font></td>
    <td>
      <input type="text" name="index_dwt_file" value="{$cat_info.index_dwt_file|escape}" size="40" /><br />
      <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeGoodsSN">
        您可以为频道首页指定模版文件，文件请存放在模版文件夹目录下，此处输入文件名，例如category-2.dwt
      </span>
    </td>
  </tr>      
  {/if}
  <tr>
    <td class="label"><font color=#ff3300>在频道首页显示该二级分类:</font></td>
    <td><input type="radio" name="show_in_index" value="1" onclick="show_goods_num_area(1)" {if $cat_info.show_in_index eq '1'}checked=checked{/if} >
      显示
      <input type="radio" name="show_in_index" value="0" onclick="show_goods_num_area(0)" {if !$cat_info.show_in_index}checked=checked{/if}>
      不显示 <br>
      <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeGoodsSN">注意：只有二级分类才需要设置“是否显示</span></td>
  </tr>
    <tr id="goods_num_area" {if $cat_info.show_in_index neq '1'}style="display:none"{/if}>
        <td class="label"><font color=#ff3300>频道首页该分类下显示商品数量:</font></td>
        <td><input type="text" name="show_goods_num" value='{$cat_info.show_goods_num}' size="15"><br />
        <span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="noticeGoodsSN">例如：8，该分类在顶级频道以楼层显示时至多显示8个商品</span></td>
    </tr>
</table>
<div class="button-div">
  <input type="submit" class="button" value="{$lang.button_submit}" />
  <input type="reset" class="button" value="{$lang.button_reset}" />
</div>
<input type="hidden" name="act" value="{$form_act}" />
<input type="hidden" name="old_cat_name" value="{$cat_info.cat_name}" />
<input type="hidden" name="cat_id" value="{$cat_info.cat_id}" />
<input type="hidden" name="is_virtual" value="{$is_virtual}" />

</form>
</div>
{insert_scripts files="../js/utils.js,validator.js"}
{literal}
<script language="JavaScript">
<!--
document.forms['theForm'].elements['cat_name'].focus();
/**

检查表单输入的数据
*/

function validate()
{
validator = new Validator("theForm");
validator.required("cat_name", catname_empty);
if (parseInt(document.forms['theForm'].elements['grade'].value) >10 || parseInt(document.forms['theForm'].elements['grade'].value) < 0)
{

validator.addErrorMsg('{$lang.grade_error}');

}
return validator.passed();
}
onload = function()
{
// 开始检查订单
startCheckOrder();
}

/**

新增一个筛选属性
*/

function addFilterAttr(obj)
{
var src = obj.parentNode.parentNode;
var tbl = document.getElementById('tbody-attr');

var validator = new Validator('theForm');
var filterAttr = document.getElementsByName("filter_attr[]");

if (filterAttr[filterAttr.length-1].selectedIndex == 0)
{

validator.addErrorMsg(filter_attr_not_selected);

}

for (i = 0; i < filterAttr.length; i++)
{

for (j = i + 1; j <filterAttr.length; j++)
{
  if (filterAttr.item(i).value == filterAttr.item(j).value)
  {
    validator.addErrorMsg(filter_attr_not_repeated);
  } 
}

}

if (!validator.passed())
{

return false;

}

var row = tbl.insertRow(tbl.rows.length);
var cell = row.insertCell(-1);
cell.innerHTML = src.cells[0].innerHTML.replace(/(.)(addFilterAttr)(.)([)(+)/i, "$1removeFilterAttr$3$4-");
filterAttr[filterAttr.length-1].selectedIndex = 0;
}

/**

删除一个筛选属性
*/

function removeFilterAttr(obj)
{
var row = rowindex(obj.parentNode.parentNode);
var tbl = document.getElementById('tbody-attr');

tbl.deleteRow(row);
}

function _index_dwt(id, type)
{

if(type == 0){
    $("[name='style']").val("category_index.css");
}
document.getElementById(id).style.display = (type == 1 ? "" : "none");

}

...............

php

mysql

阅读 6.4k

1 个回答

得票最新

moonsola

8142110

发布于
2017-02-21

从出错的地方开始一层层网上输出调试呗，你还期望有什么别的方法？

查看全部 1 个回答

推荐问题

相似问题

找不到问题？创建新问题

新版小京东V5.0二次开发解密开源版，我给他添加了一个产品分类图片字段；调用不出来，这是为什么呢？

Java 开发 URL 匹配问题？

为何无法连接阿里云轻量应用服务器上 docker 中的 mysql ？

我想要可靠地升级网站，有没有标准的流程？或者需要注意的地方？

mysql 死锁问题？

TP6指定时间段内填写指定内容？

cURL error 77: error setting certificate file: /etc/ssl/certs/ca-certificates.crt 如何处理?

MyBatis Plus 如何对敏感字段加解密（使用哪种加密方式）？

新版小京东V5.0二次开发解密开源版，我给他添加了一个产品分类图片字段；调用不出来，这是为什么呢？

Java 开发 URL 匹配问题？

为何无法连接 阿里云轻量应用服务器上 docker 中的 mysql ？

我想要可靠地升级网站，有没有标准的流程？或者需要注意的地方？

mysql 死锁问题？

TP6指定时间段内填写指定内容？

cURL error 77: error setting certificate file: /etc/ssl/certs/ca-certificates.crt 如何处理?

MyBatis Plus 如何对敏感字段加解密（使用哪种加密方式）？

为何无法连接阿里云轻量应用服务器上 docker 中的 mysql ？