商品批发增加起订数功能，设置购买数量（修正版）

2016-07-07 14:55 来源：www.chinab4c.com 作者：ecshop专家



适用于2.6.2和2.7.0，其他版本未测试。此版本是原来共享的基础上修改bug，就是：购物车中商品数量达到个数，不给折扣。
1.在ECS_goods数据表中新增最小购买数量字段min_number，可以在ecshop后台，sql查询那边直接运行，把ecs改成你改的表前缀，如果没有修改，直接使用以下代码。

  2. alter table `ecs_goods` add column `min_number` tinyint (3) UNSIGNEDDEFAULT '0' NOT NULLafter `warn_number`
复制代码
2.修改admin/goods.php

  2. 在
  3. 'warn_number' => 1,
  4. 代码行后插入
  5. 'min_number' => 0,
复制代码
  1. 在
  2. $warn_number = isset($_POST['warn_number']) ? $_POST['warn_number'] : 0;
  3. 代码行后插入
  4. $min_number = isset($_POST['min_number']) ? $_POST['min_number'] : 0;
复制代码
  1. 将
  2. /* 入库 */
  3. if ($is_insert)
  4. {
  5. if ($code == '')
  6. {
  7. ....由于发帖篇幅的限制省略原有代码无数
  8. }
  9. else
  10. {
  11. ......
  12. }
  13. }
  14. else
  15. {
  16. /* 如果有上传图片，删除原来的商品图 */
  17. .....
  18. }
复制代码

  2. 修改成
  3. /* 入库 */
  4. if ($is_insert)
  5. {
  6. if ($code == '')
  7. {
  8. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
  9. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
  10. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
  11. "seller_note, goods_weight, goods_number, warn_number,min_number, integral, give_integral, is_best, is_new, is_hot, " .
  12. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, rank_integral)" .
  13. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
  14. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".
  15. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".
  16. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
  17. " '$warn_number','$min_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', ".
  18. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral')";
  19. }
  20. else
  21. {
  22. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
  23. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
  24. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
  25. "seller_note, goods_weight, goods_number, warn_number, min_number,integral, give_integral, is_best, is_new, is_hot, is_real, " .
  26. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)" .
  27. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
  28. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".
  29. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".
  30. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
  31. " '$warn_number','$min_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', 0, '$is_on_sale', '$is_alone_sale', ".
  32. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$code', '$rank_integral')";
  33. }
  34. }
  35. else
  36. {
  37. /* 如果有上传图片，删除原来的商品图 */
  38. $sql = "SELECT goods_thumb, goods_img, original_img " .
  39. " FROM " . $ecs->table('goods') .
  40. " WHERE goods_id = '$_REQUEST[goods_id]'";
  41. $row = $db->getRow($sql);
  42. if ($proc_thumb && $goods_img && $row['goods_img'] && !goods_parse_url($row['goods_img']))
  43. {
  44. @unlink(ROOT_PATH . $row['goods_img']);
  45. @unlink(ROOT_PATH . $row['original_img']);
  46. }
  47. if ($proc_thumb && $goods_thumb && $row['goods_thumb'] && !goods_parse_url($row['goods_thumb']))
  48. {
  49. @unlink(ROOT_PATH . $row['goods_thumb']);
  50. }
  51. $sql = "UPDATE " . $ecs->table('goods') . " SET " .
  52. "goods_name = '$_POST[goods_name]', " .
  53. "goods_name_style = '$goods_name_style', " .
  54. "goods_sn = '$goods_sn', " .
  55. "cat_id = '$catgory_id', " .
  56. "brand_id = '$brand_id', " .
  57. "shop_price = '$shop_price', " .
  58. "market_price = '$market_price', " .
  59. "is_promote = '$is_promote', " .
  60. "promote_price = '$promote_price', " .
  61. "promote_start_date = '$promote_start_date', " .
  62. "promote_end_date = '$promote_end_date', ";
  63. /* 如果有上传图片，需要更新数据库 */
  64. if ($goods_img)
  65. {
  66. $sql .= "goods_img = '$goods_img', original_img = '$original_img', ";
  67. }
  68. if ($goods_thumb)
  69. {
  70. $sql .= "goods_thumb = '$goods_thumb', ";
  71. }
  72. if ($code != '')
  73. {
  74. $sql .= "is_real=0, extension_code='$code', ";
  75. }
  76. $sql .= "keywords = '$_POST[keywords]', " .
  77. "goods_brief = '$_POST[goods_brief]', " .
  78. "seller_note = '$_POST[seller_note]', " .
  79. "goods_weight = '$goods_weight'," .
  80. "goods_number = '$goods_number', " .
  81. "warn_number = '$warn_number', " .
  82. "min_number = '$min_number', " .
  83. "integral = '$_POST[integral]', " .
  84. "give_integral = '$give_integral', " .
  85. "rank_integral = '$rank_integral', " .
  86. "is_best = '$is_best', " .
  87. "is_new = '$is_new', " .
  88. "is_hot = '$is_hot', " .
  89. "is_on_sale = '$is_on_sale', " .
  90. "is_alone_sale = '$is_alone_sale', " .
  91. "goods_desc = '$_POST[goods_desc]', " .
  92. "last_update = '". gmtime() ."', ".
  93. "goods_type = '$goods_type' " .
  94. "WHERE goods_id = '$_REQUEST[goods_id]' LIMIT 1";
  95. }
复制代码
3.修改admin/templates/goods_info.htm
  1. 在
  2. <!--商品优惠价格 end -->
  3. <tr>
  4. <td class="label">{$lang.lab_market_price}</td>
  5. <td><input type="text" name="market_price" value="{$goods.market_price}" size="20" />
  6. <input type="button" value="{$lang.integral_market_price}" onclick="integral_market_price()" />
  7. </td>
  8. </tr>
  9. 之后新增插入
  10. <!--新增 批发数量限制 begin -->
  11. <tr>
  12. <td class="label">{$lang.lab_min_number}</td>
  13. <td><input type="text" name="min_number" value="{$goods.min_number}" size="20" />
  14. <br /><span class="notice-span" {if $help_open}style="display:block" {else} style="display:none" {/if} id="minNumber">{$lang.notice_min_number}</span></td>
  15. </td>
  16. </tr>
  17. <!-- 批发数量限制 end -->
复制代码
4.修改languages/zh_cn/admin/goods.php
  1. 在文件最后新增
  2. /* 新增 */
  3. $_LANG['lab_min_number'] = '最小购买数量:';
  4. $_LANG['notice_min_number'] = '该商品最小购买数量,0表示按购买数量无限制.';
复制代码
5.修改themes/default/goods.dwt
  1. 将
  2. <input name="number" type="text" id="number" value="1" size="4" onblur="changePrice()" style="border:1px solid #ccc; "/>
  3. 修改成
  4. <input name="number" type="text" id="number" value="{$goods.min_number|default:"1"}" size="4" onblur="changePrice()" style="border:1px solid #ccc; "/>
复制代码
  1. 在
  2. var qty = document.forms['ECS_FORMBUY'].elements['number'].value;
  3. 之后添加
  4. <!-- {if $goods.min_number} -->
  5. if (qty < {$goods.min_number})
  6. {
  7. alert('您输入的数字小于此商品最小购买数量：{$goods.min_number}');
  8. qty = {$goods.min_number};
  9. }
  10. <!-- {/if} -->
复制代码
6.修改language/zh_cn/shopping_flow.php
  1. $_LANG['stock_insufficiency'] = '非常抱歉，您选择的商品 %s 的库存数量只有 %d，您最多只能购买 %d 件。';后增加一行
  2. $_LANG['goods_number_too_few'] = '非常抱歉，您选择的商品 %s ,购买的的数量小于此商品最小购买数量 %d 件。';
复制代码
7.修改flow.php
  1. 查找
  2. $sql = "SELECT g.goods_name, g.goods_number ".
  3. "FROM " .$GLOBALS['ecs']->table('goods'). " AS g, ".
  4. $GLOBALS['ecs']->table('cart'). " AS c ".
  5. "WHERE g.goods_id = c.goods_id AND c.rec_id = '$key'";
  6. 修改为
  7. $sql = "SELECT g.goods_name, g.goods_number, g.min_number ".
  8. "FROM " .$GLOBALS['ecs']->table('goods'). " AS g, ".
  9. $GLOBALS['ecs']->table('cart'). " AS c ".
  10. "WHERE g.goods_id = c.goods_id AND c.rec_id = '$key'";
复制代码
  1. 在代码 if ($row['goods_number'] < $val)
  2. {
  3. show_message(sprintf($GLOBALS['_LANG']['stock_insufficiency'], $row['goods_name'],
  4. $row['goods_number'], $row['goods_number']));
  5. exit;
  6. }后添加
  7. if ($row['min_number'] > $val)
  8. {
  9. show_message(sprintf($GLOBALS['_LANG']['goods_number_too_few'], $row['goods_name'],
  10. $row['min_number']));
  11. exit;
  12. }
复制代码


回答：
不错
支持

谢谢楼主的分享，但是这样恐怕用户体验不是很好吧？日常生活中都是买的多优惠率越高，这样用户可能会？？？
希望楼主考虑考虑

4# owndream 就是有人需要我才写的，呵呵。。。

这个可以选择应用范围么？
品牌，分类，或者商品，

不能。。如果需要可以拓展下。

感谢楼主分享， 不过购物车 更新数量要是能跟 产品页一样就更好了！呵呵
继续支持！

不太适合做批发的,一般有些批是一包一包的批,一包里有很多件,比如一包10件,客户输入11怎么办?还是没办法

好定西啊！！！

不错的功能，支持楼主

此功能在商品详情面购买时有批发数量限制，但是在购物流程结算时可以任意修改批发数量

此功能在商品详情面购买时有批发数量限制，但是在购物流程结算时可以任意修改批发数量
gzjob 发表于 2009-10-30 01:14

当数量小于后台设置的数量的时候，会自动按照平常购买，不打折扣。

想问下 我在ecshop后台，sql查询那边直接运行，alter table `ecs_goods` add column `min_number` tinyint (3) UNSIGNEDDEFAULT '0' NOT NULLafter `warn_number`

现在顾客只能够买1 样东西。 怎么办？？
一把货物放入购物车就直接跳到结帐的面页 。。。 跳过了checkout的面页。

应该怎么处理呢？

请大家帮帮忙。。

www.fashiondeliver21.com