ecshop商品页面添加商品标签
日期:2018-08-15
需要给商品加属性,最简单粗暴的办法,后台调用加入,界面没有美化
goods.dwt文件
数据库order_goods表,建立字段catname catsize catdate catcolor
ECSHOP后台order_info.htm文件
goods.dwt文件
<ul class="quantity">
<h2>颜色:</h2>
<div class="items">
<select id="cat_color" name="cat_color">
<option value="红色">红色</option>
<option value="黑色">黑色</option>
<option value="粉色">粉色</option>
<option value="米色">米色</option>
<option value="咖啡色">咖啡色</option>
<option value="紫色">紫色</option>
<option value="棕色">棕色</option>
</select>
</div>
</ul>
<ul class="quantity">
<h2>车型:</h2>
<div class="items">
<span class="ui-number radius5">
<input class="num" name="catname" id="cat_name" type="text" size="5px" />
</span>
<em>如:帕萨特,福克斯,s600</em>
</div>
</ul>
<ul class="quantity">
<h2>年份:</h2>
<div class="items">
<select id="cat_date" name="cat_date">
<option value="1993">1993</option><option value="1994">1994</option><option value="1995">1995</option><option value="1996">1996</option><option value="1997">1997</option><option value="1998">1998</option><option value="1999">1999</option><option value="2000">2000</option><option value="2001">2001</option><option value="2002">2002</option><option value="2003">2003</option><option value="2004">2004</option><option value="2005">2005</option><option value="2006">2006</option><option value="2007">2007</option><option value="2008">2008</option><option value="2009">2009</option><option value="2010">2010</option><option value="2011">2011</option><option value="2012">2012</option><option value="2013">2013</option><option value="2014">2014</option>
<option value="2015">2015</option><option value="2016">2016</option>
<option value="2017">2017</option><option value="2018">2018</option>
<option value="2019">2019</option><option value="2020">2020</option>
</select>
</div>
</ul>
<ul class="quantity">
<h2>几座:</h2>
<div class="items">
<select id="cat_size" name="cat_size">
<option value="2">2</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="7">7</option>
<option value="8">8</option>
</select>
</div>
</ul>
common.js文件
var catsize = document.getElementById("cat_size");
var catdate = document.getElementById("cat_date");
var catcolor = document.getElementById("catcolor");
var indes = catsize.selectedIndex;
var index = catdate.selectedIndex;
var indec = catdate.selectedIndex;
goods.quick = quick;
goods.catname = catname;
goods.catsize = catsize.options[indes].value;
goods.catdate = catdate.options[index].value;
goods.catcolor = catcolor.options[indec].value;
flow.php文件
if (addto_cart($goods->goods_id, $goods->number, $goods->spec, $goods->parent, $goods->catname, $goods->catsize, $goods->catdate,$goods->catcolor))
/* 插入订单商品 */
$sql = "INSERT INTO " . $ecs->table('order_goods') . "( " .
"order_id, goods_id, goods_name, goods_sn, product_id, goods_number, market_price, ".
"goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id, catname, catsize, catdate, catcolor) ".
" SELECT '$new_order_id', goods_id, goods_name, goods_sn, product_id, goods_number, market_price, ".
"goods_price, goods_attr, is_real, extension_code, parent_id, is_gift, goods_attr_id, catname, catsize, catdate, catcolor".
" FROM " .$ecs->table('cart') .
" WHERE session_id = '".SESS_ID."' AND rec_type = '$flow_type'";
$db->query($sql);
lib_order.php文件
function addto_cart($goods_id, $num = 1, $spec = array(), $parent = 0, $catname = '', $catsize = '', $catdate='', $catcolor = '')
$sql = "UPDATE " . $GLOBALS['ecs']->table('cart') . " SET goods_number = '$num'" .
" , goods_price = '$goods_price', catname = '$catname', catsize = '$catsize', catdate = '$catdate', catcolor = '$catcolor'".
" WHERE session_id = '" .SESS_ID. "' AND goods_id = '$goods_id' ".
" AND parent_id = 0 AND goods_attr = '" .get_goods_attr_info($spec). "' " .
" AND extension_code <> 'package_buy' " .
"AND rec_type = 'CART_GENERAL_GOODS'";
$GLOBALS['db']->query($sql);
$parent['parent_id'] = 0;
$parent['catname'] = $catname;
$parent['catsize'] = $catsize;
$parent['catdate'] = $catdate;
$parent['catcolor'] = $catcolor;
数据库cart表,建立字段catname catsize catdate catcolor数据库order_goods表,建立字段catname catsize catdate catcolor
ECSHOP后台order_info.htm文件
<td>{$goods.catdate}年的:{$goods.catname}.{$goods.catsize}座.{$goods.catcolor}.的座垫</td>
ECSHOP后台order.php文件
/* 取得订单商品及货品 */
$goods_list = array();
$goods_attr = array();
$sql = "SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, o.catname, o.catsize, o.catdate, o.catcolor, g.suppliers_id, INULLb.brand_name, '') AS brand_name, p.product_sn
FROM " . $ecs->table('order_goods') . " AS o
LEFT JOIN " . $ecs->table('products') . " AS p
ON p.product_id = o.product_id
LEFT JOIN " . $ecs->table('goods') . " AS g
ON o.goods_id = g.goods_id
LEFT JOIN " . $ecs->table('brand') . " AS b
ON g.brand_id = b.brand_id
WHERE o.order_id = '$order[order_id]'";
语言languages/zh_cn/admin/order.php文件
$_LANG['cat_name'] = '车备注'; $_LANG['catname'] = '车型'; $_LANG['catsize'] = '座'; $_LANG['catdate'] = '年'; $_LANG['catcolor'] = '颜色';
本文原创地址:https://ecshopok.com/article-430.html
版权所有 © 转载时必须以链接形式注明出处!
觉得本文对您有用,想收藏下来!方法很简单:请点击-〉
我们一直坚持白天工作、晚上熬夜更新资源,付出了巨大的精力和时间,其中的辛酸难以言述。





暂无评论,来发表一个吧