第一步，商品表必须有个字段代表某个商品最小订购数量->min_number
打开 goods 表在最后字段添加一个 min_numbertinyint 类型默认值为 0代表没
有最小起订量
sql:alter table `goods` add column `min_number` tinyint (3)
UNSIGNEDDEFAULT '0' NOT NULLafter `warn_number`
第二部,在后台添加商品的时候必须有个 text 文本框设置最小起订量
admin/goods.php
在'warn_number'=> 1 ,代码行后插入'min_number'=> 0,
在$warn_number = isset($_POST['warn_number']) ? $_POST['warn_number'] :
0;
后 添 加 代 码 $min_number = isset($_POST['min_number']) ?
$_POST['min_number'] : 0;
第三部修改添加商品 sql 语句
修改代码
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,min_number, integral,give_integral, is_best, is_new, is_hot, ".
"is_on_sale, is_alone_sale, goods_desc, add_time, last_update,
goods_type,rank_integral)" .
"VALUES ('$_POST[goods_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', ".
"'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]',
'$goods_weight','$goods_number',".
评论2