商品批发增加起订数功能，设置购买数量(v2.6.2 默认模板)

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

1.在ECS_goods数据表中新增最小购买数量字段min_number
  1. alter table `ecs_goods` add column `min_number` tinyint (3) UNSIGNEDDEFAULT '0' NOT NULLafter `warn_number`
复制代码

2.修改admin/goods.php
  1. 在
  2. 'warn_number'=> 1,
  3. 代码行后插入
  4. '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;
复制代码



  2. 将
  3. /* 入库 */
  4. if ($is_insert)
  5. {
  6. if ($code == '')
  7. {
  8. ....由于发帖篇幅的限制省略原有代码无数
  9. }
  10. else
  11. {
  12. ......
  13. }
  14. }
  15. else
  16. {
  17. /* 如果有上传图片，删除原来的商品图 */
  18. .....
  19. }
复制代码

修改成

  2. /* 入库 */
  3. if ($is_insert)
  4. {
  5. if ($code == '')
  6. {
  7. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
  8. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
  9. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
  10. "seller_note, goods_weight, goods_number, warn_number,min_number, integral, give_integral, is_best, is_new, is_hot, " .
  11. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, rank_integral)" .
  12. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
  13. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".
  14. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".
  15. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
  16. " '$warn_number','$min_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', ".
  17. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral')";
  18. }
  19. else
  20. {
  21. $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
  22. "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .
  23. "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .
  24. "seller_note, goods_weight, goods_number, warn_number, min_number,integral, give_integral, is_best, is_new, is_hot, is_real, " .
  25. "is_on_sale, is_alone_sale, goods_desc, add_time, last_update, goods_type, extension_code, rank_integral)" .
  26. "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .
  27. "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".
  28. "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".
  29. "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".
  30. " '$warn_number','$min_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', 0, '$is_on_sale', '$is_alone_sale', ".
  31. " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$code', '$rank_integral')";
  32. }
  33. }
  34. else
  35. {
  36. /* 如果有上传图片，删除原来的商品图 */
  37. $sql = "SELECT goods_thumb, goods_img, original_img " .
  38. " FROM " . $ecs->table('goods') .
  39. " WHERE goods_id = '$_REQUEST[goods_id]'";
  40. $row = $db->getRow($sql);
  41. if ($proc_thumb && $goods_img && $row['goods_img'] && !goods_parse_url($row['goods_img']))
  42. {
  43. @unlink(ROOT_PATH . $row['goods_img']);
  44. @unlink(ROOT_PATH . $row['original_img']);
  45. }
  46. if ($proc_thumb && $goods_thumb && $row['goods_thumb'] && !goods_parse_url($row['goods_thumb']))
  47. {
  48. @unlink(ROOT_PATH . $row['goods_thumb']);
  49. }
  50. $sql = "UPDATE " . $ecs->table('goods') . " SET " .
  51. "goods_name = '$_POST[goods_name]', " .
  52. "goods_name_style = '$goods_name_style', " .
  53. "goods_sn = '$goods_sn', " .
  54. "cat_id = '$catgory_id', " .
  55. "brand_id = '$brand_id', " .
  56. "shop_price = '$shop_price', " .
  57. "market_price = '$market_price', " .
  58. "is_promote = '$is_promote', " .
  59. "promote_price = '$promote_price', " .
  60. "promote_start_date = '$promote_start_date', " .
  61. "promote_end_date = '$promote_end_date', ";
  62. /* 如果有上传图片，需要更新数据库 */
  63. if ($goods_img)
  64. {
  65. $sql .= "goods_img = '$goods_img', original_img = '$original_img', ";
  66. }
  67. if ($goods_thumb)
  68. {
  69. $sql .= "goods_thumb = '$goods_thumb', ";
  70. }
  71. if ($code != '')
  72. {
  73. $sql .= "is_real=0, extension_code='$code', ";
  74. }
  75. $sql .= "keywords = '$_POST[keywords]', " .
  76. "goods_brief = '$_POST[goods_brief]', " .
  77. "seller_note = '$_POST[seller_note]', " .
  78. "goods_weight = '$goods_weight'," .
  79. "goods_number = '$goods_number', " .
  80. "warn_number = '$warn_number', " .
  81. "min_number = '$min_number', " .
  82. "integral = '$_POST[integral]', " .
  83. "give_integral = '$give_integral', " .
  84. "rank_integral = '$rank_integral', " .
  85. "is_best = '$is_best', " .
  86. "is_new = '$is_new', " .
  87. "is_hot = '$is_hot', " .
  88. "is_on_sale = '$is_on_sale', " .
  89. "is_alone_sale = '$is_alone_sale', " .
  90. "goods_desc = '$_POST[goods_desc]', " .
  91. "last_update = '". gmtime() ."', ".
  92. "goods_type = '$goods_type' " .
  93. "WHERE goods_id = '$_REQUEST[goods_id]' LIMIT 1";
  94. }
复制代码

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.效果如图所示
后台图片
前台显示页面：
7.功能不完善之处请多多包涵。

回答：
不错的功能

好东西，收藏了

先收藏了,再慢慢改

很不错大礼收下了

谢谢共享，这个必须收藏的

收藏了楼主共享精神可嘉！

很好,很强大

比较实用，谢谢共享

学习了 ：）



有一個bug
在下訂單後的商品列表也可以改到其他數字

真好！！！谢谢！！

有人會改了BUG嗎?

在下訂單後有一個bug,商品列表可以改到其他數字
有人會改嗎?