ecshop 在商品类表页添加类似于精品的自定义字段.doc

目前在做自己的博客爱T-blog web开发、分享 与爱T们技术交流在商品列表页添加自定义字段(爱T-blog)1、首先要修改数据表结构，给表 ecs_goods 增加新字段：other_col，进入ECSHOP后台 数据库管理 SQL查询，输入下面SQL语句，提交。注意如果你的数据表前缀不是ecs_ 请自行修改之alter table ecs_goods add column other_col varchar(64);2. 打开admin/goods.php在/* 处理商品数据 */那里$is_hot = isset($_POSTis_hot) ? 1 : 0;（大约803行）$other_col = isset($_POSTother_col) ? 1 : 0;在 /* 入库 */添加/* 入库 */if ($is_insert)if ($code = ”)$sql = “INSERT INTO ” . $ecs-table(goods) . ” (goods_name, goods_name_style, goods_sn, ” .“cat_id, brand_id, shop_price, market_price, is_promote, promote_price, ” .“promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, ” .“seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, other_col,” .“is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, rank_integral, suppliers_id)” .“VALUES ($_POSTgoods_name, $goods_name_style, $goods_sn, $catgory_id, ” .“$brand_id, $shop_price, $market_price, $is_promote,$promote_price, “.“$promote_start_date, $promote_end_date, $goods_img, $goods_thumb, $original_img, “.“$_POSTkeywords, $_POSTgoods_brief, $_POSTseller_note, $goods_weight, $goods_number,”.” $warn_number, $_POSTintegral, $give_integral, $is_best, $is_new, $is_hot,$other_col, $is_on_sale, $is_alone_sale, $is_shipping, “.” $_POSTgoods_desc, ” . gmtime() . “, ”. gmtime() .”, $goods_type, $rank_integral, $suppliers_id)”;else$sql = “INSERT INTO ” . $ecs-table(goods) . ” (goods_name, goods_name_style, goods_sn, ” .“cat_id, brand_id, shop_price, market_price, is_promote, promote_price, ” .“promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, ” .“seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, other_col,is_real, ” .“is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)” .“VALUES ($_POSTgoods_name, $goods_name_style, $goods_sn, $catgory_id, ” .“$brand_id, $shop_price, $market_price, $is_promote,$promote_price, “.“$promote_start_date, $promote_end_date, $goods_img, $goods_thumb, $original_img, “.“$_POSTkeywords, $_POSTgoods_brief, $_POSTseller_note, $goods_weight, $goods_number,”.” $warn_number, $_POSTintegral, $give_integral, $is_best, $is_new, $is_hot,$other_col, 0, $is_on_sale, $is_alone_sale, $is_shipping, “.” $_POSTgoods_desc, ” . gmtime() . “, ”. gmtime() .”, $goods_type, $code, $rank_integral)”;在 /* 如果有上传图片，需要更新数据库 */$sql .= “keywords = $_POSTkeywords, ” .“goods_brief = $_POSTgoods_brief, ” .“seller_note = $_POSTseller_note, ” .“goods_weight = $goods_weight,” .“goods_number = $goods_number, ” .“warn_number = $warn_number, ” .“integral = $_POSTintegral, ” .“give_integral = $give_integral, ” .“rank_integral = $rank_integral, ” .“is_best = $is_best, ” .“is_new = $is_new, ” .“other_col = $other_col, ” .“is_hot = $is_hot, ” .“is_on_sale = $is_on_sale, ” .“is_alone_sale = $is_alone_sale, ” .“is_shipping = $is_shipping, ” .“goods_desc = $_POSTgoods_desc, ” .“last_update = ”. gmtime() .”, “.“goods_type = $goods_type ” .“WHERE goods_id = $_REQUESTgoods_id LIMIT 1;在 /* 取消新品 */后添加/* 设为other_col */elseif ($_POSTtype = other_col)/* 检查权限 */admin_priv(goods_manage);update_goods($goods_id, other_col, 1);/* 取消other_col */elseif ($_POSTtype = not_other_col)/* 检查权限 */admin_priv(goods_manage);update_goods($goods_id, other_col, 0);在 / 修改新品推荐状态后面/* */ 修改other_col推荐状态/* */elseif ($_REQUESTact = toggle_other_col)check_authz_json(goods_manage);$goods_id = intval($_POSTid);$other_col = intval($_POSTval);if ($exc-edit(“other_col = $other_col, last_update=” .gmtime(), $goods_id)clear_cache_files();make_json_result($other_col);3.admin/templates/goods_info.htm搜索is_new在$lang.is_hot后面添加 other_col在大约204行$lang.