如何實現商品批發增加起訂數功能，現在和大家分享一下啊1.在ECS_goods數據表中新增最小購買數量字段min_number
alter table `ecs_goods` add column `min_number` tinyint (3) UNSIGNED DEFAULT '0' NOT NULL after
`warn_number`
2.修改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;
/* 入庫 */
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',".
" '$warn_number','$min_number', '$_POST[integral]', '$give_integral', '$is_best',
'$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', ".
" '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type',
'$rank_integral')";
}
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, min_number,integral,
give_integral, is_best, is_new, is_hot, is_real, " .
"is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type,
extension_code, 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',".
" '$warn_number','$min_number', '$_POST[integral]', '$give_integral', '$is_best',
'$is_new', '$is_hot', 0, '$is_on_sale', '$is_alone_sale', ".
" '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type',
'$code', '$rank_integral')";
}
}
else
{
/* 如果有上傳圖片，刪除原來的商品圖 */
$sql = "SELECT goods_thumb, goods_img, original_img " .
" FROM " . $ecs->table('goods') .
" WHERE goods_id = '$_REQUEST[goods_id]'";
$row = $db->getRow($sql);
if ($proc_thumb && $goods_img && $row['goods_img'] && !goods_parse_url($row['goods_img']))
{
@unlink(ROOT_PATH . $row['goods_img']);
@unlink(ROOT_PATH . $row['original_img']);
}
if ($proc_thumb && $goods_thumb && $row['goods_thumb'] && !goods_parse_url($row
['goods_thumb']))
{
@unlink(ROOT_PATH . $row['goods_thumb']);
}
$sql = "UPDATE " . $ecs->table('goods') . " SET " .
"goods_name = '$_POST[goods_name]', " .
"goods_name_style = '$goods_name_style', " .
"goods_sn = '$goods_sn', " .
"cat_id = '$catgory_id', " .
"brand_id = '$brand_id', " .
"shop_price = '$shop_price', " .
"market_price = '$market_price', " .
"is_promote = '$is_promote', " .
"promote_price = '$promote_price', " .
"promote_start_date = '$promote_start_date', " .
"promote_end_date = '$promote_end_date', ";
/* 如果有上傳圖片，需要更新數據庫 */
if ($goods_img)
{
$sql .= "goods_img = '$goods_img', original_img = '$original_img', ";
}
if ($goods_thumb)
{
$sql .= "goods_thumb = '$goods_thumb', ";
}
if ($code != '')
{
$sql .= "is_real=0, extension_code='$code', ";
}
$sql .= "keywords = '$_POST[keywords]', " .
"goods_brief = '$_POST[goods_brief]', " .
"seller_note = '$_POST[seller_note]', " .
"goods_weight = '$goods_weight'," .
"goods_number = '$goods_number', " .
"warn_number = '$warn_number', " .
"min_number = '$min_number', " .
"integral = '$_POST[integral]', " .
"give_integral = '$give_integral', " .
"rank_integral = '$rank_integral', " .
"is_best = '$is_best', " .
"is_new = '$is_new', " .
"is_hot = '$is_hot', " .
"is_on_sale = '$is_on_sale', " .
"is_alone_sale = '$is_alone_sale', " .
"goods_desc = '$_POST[goods_desc]', " .
"last_update = '". gmtime() ."', ".
"goods_type = '$goods_type' " .
"WHERE goods_id = '$_REQUEST[goods_id]' LIMIT 1";
}
3.修改admin/templates/goods_info.htm
在
<!--商品優惠價格 end -->
<tr>
<td class="label">{$lang.lab_market_price}</td>
<td><input type="text" name="market_price" value="{$goods.market_price}" size="20" />
<input type="button" value="{$lang.integral_market_price}"
onclick="integral_market_price()" />
</td>
</tr>
之后新增插入
<!--新增 批發數量限制 begin -->
<tr>
<td class="label">{$lang.lab_min_number}</td>
<td><input type="text" name="min_number" value="{$goods.min_number}" size="20" />
<br /><span class="notice-span" {if $help_open}style="display:block" {else}
style="display:none" {/if} id="minNumber">{$lang.notice_min_number}</span></td>
</td>
</tr>
<!-- 批發數量限制 end -->
在
<!--商品優惠價格 end -->
<tr>
<td class="label">{$lang.lab_market_price}</td>
<td><input type="text" name="market_price" value="{$goods.market_price}" size="20" />
<input type="button" value="{$lang.integral_market_price}"
onclick="integral_market_price()" />
</td>
</tr>
之后新增插入
<!--新增 批發數量限制 begin -->
<tr>
<td class="label">{$lang.lab_min_number}</td>
<td><input type="text" name="min_number" value="{$goods.min_number}" size="20" />
<br /><span class="notice-span" {if $help_open}style="display:block" {else}
style="display:none" {/if} id="minNumber">{$lang.notice_min_number}</span></td>
</td>
</tr>
<!-- 批發數量限制 end -->
4.修改languages/zh_cn/admin/goods.php
在文件最后新增
/* 新增 */
$_LANG['lab_min_number'] = '最小購買數量:';
$_LANG['notice_min_number'] = '該商品最小購買數量,0表示按購買數量無限制.';
5.修改themes/default/goods.dwt
將
<input name="number" type="text" id="number" value="1" size="4"
style="border:1px solid #ccc; "/>
修改成
<input name="number" type="text" id="number" value="{$goods.min_number|default:"1"}" size="4"
onblur="changePrice()" style="border:1px solid #ccc; "/>
在
var qty = document.forms['ECS_FORMBUY'].elements['number'].value;
之后添加
<!-- {if $goods.min_number} -->
if (qty < {$goods.min_number})
{
alert('您輸入的數字小于此商品最小購買數量：{$goods.min_number}');
qty = {$goods.min_number};
}
<!-- {/if} -->
