您现在的位置是：首页 > cms教程 > Ecshop商城教程Ecshop商城教程

ecshop后台管理增加 和毛利润统计的实现方法

费汐家2025-01-14Ecshop商城教程已有人查阅

导读ecshop 功能二次开发 关于后台管理增加 和毛利润统计功能（一）首先在订单中的商品信息【编辑】页面中，修改 。也可以在添加商品时添加成本的如果不做手工修改，则使用默认的商品

ecshop 功能二次开发 关于后台管理增加 和毛利润统计功能（一）
首先在订单中的商品信息【编辑】页面中，修改 。也可以在添加商品时添加成本的如果不做手工修改，则使用默认的商品 （在商品信息里编辑的成本价格）。
第一步：修改数据库中的商品表ecs_goods和订单商品表ecs_order_goods，添加 字段cost_price
把SQL语句列出来： 
alter table `ecs_goods` add column `cost_price` decimal (10,2) UNSIGNED DEFAULT '0.00' NOT NULL after `promote_price`
alter table `ecs_order_goods` add column `cost_price` decimal (10,2) DEFAULT '0.00' NOT NULL after `market_price`
这里是加在了字段promote_price 和market_price后面
第二步.增加语言包 ，需要修改languages\zh_cn\admin\goods.php
再之后添加 
$_LANG['lab_cost_price'] = ' :';
$_LANG['notice_cost_price'] = '该商品进货价格( ，在商品添加时设置，也可以在商品编辑里面修改 。).';
第三步.修改admin/goods.php 把 格插入到数据库
在两个（有两个地方需要修改） 
'promote_price' => 0,
后新增一行添加 
'cost_price' => 0,
再在 
$shop_price = !empty($_POST['shop_price']) ? $_POST['shop_price'] : 0;
后添加 
$cost_price = !empty($_POST['cost_price']) ? $_POST['cost_price'] : 0;
将
if ($is_insert)
{
。。。。。源代码太多省略（了这个是真实商品和虚拟商品）
}
else
{
。。。。。源代码太多省略了
}
修改成 
if ($is_insert)
{
if ($code == '')
{
$sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .
"cat_id, brand_id, shop_price,cost_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, 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','$cost_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', '$_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,cost_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, 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','$cost_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', '$_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', " .
"cost_price = '$cost_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', " .
"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";
}
（第三步 主要是在插入数据库时，把 （cost_price）的值插入到数据库）
第四步.下面应该在商品编辑页读取和显示 格，需要修改admin/templates/goods_info.dwt
找到代码 
<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>
在这段代码之后添加显示 格的表格
这样就把就完成了在商品添加时增加商品的 和在商品列表页编辑商品页显示 的功能
ecshop 功能二次开发 关于后台管理增加 和毛利润统计功能（二）
1.修改订单的语言文件languages\zh_cn\admin\order.php
之后新增： 
$_LANG['cost_price'] = ' ';
2.然后我们来修改订单显示模板文件 admin\templates\order_info.dwt
把 
<th colspan="8" scope="col">
修改成 
<th scope="col">
在 
<td scope="col"><div align="center"><strong>{$lang.storage}</strong></div></td>
代码之后插入 
<td scope="col"><div align="center"><strong>{$lang.cost_price}</strong></div></td>
在 
<td><div align="right">{$goods.storage}</div></td>
代码之后插入 
<td><div align="right">{$goods.cost_price}</div></td>
3.下面是如何修改修改admin\order.php
将 
$sql = "SELECT o.*, g.goods_number AS storage, o.goods_attr, IFNULL(b.brand_name, '') AS brand_name " .
"FROM " . $ecs->table('order_goods') . " AS o ".
"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]' ";
修改成 
$sql = "SELECT o.*, g.goods_number AS storage,if(o.cost_price>0,o.cost_price,g.cost_price) AS cost_price, o.goods_attr, IFNULL(b.brand_name, '') AS brand_name " .
"FROM " . $ecs->table('order_goods') . " AS o ".
"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]' ";
在 
$goods_price = floatval($_POST['goods_price'][$key]);
之后插入 
$cost_price = floatval($_POST['cost_price'][$key]);
将 
$sql = "UPDATE " . $ecs->table('order_goods') .
" SET goods_price = '$goods_price', " .
"goods_number = '$goods_number', " .
"goods_attr = '$goods_attr' " .
"WHERE rec_id = '$rec_id' LIMIT 1";
修改成 
$sql = "UPDATE " . $ecs->table('order_goods') .
" SET goods_price = '$goods_price',cost_price = '$cost_price', " .
"goods_number = '$goods_number', " .
"goods_attr = '$goods_attr' " .
"WHERE rec_id = '$rec_id' LIMIT 1";
在 
update_order($order_id, array('order_status' => OS_CONFIRMED, 'confirm_time' => gmtime()));
之后插入 
$sql_cost = "UPDATE ". $GLOBALS['ecs']->table('order_goods')." as og,". $GLOBALS['ecs']->table('goods')." as g SET og.cost_price =
g.cost_price " .
" WHERE og.goods_id = g.goods_id".
" AND og.order_id = '$order_id' and og.cost_price=0";
$GLOBALS['db']->query($sql_cost);
在 
update_order($order_id, array('order_status' => OS_CONFIRMED, 'confirm_time' => gmtime()));
update_order_amount($order_id);
之后插入 
$sql_cost = "UPDATE ". $GLOBALS['ecs']->table('order_goods')." as og,". $GLOBALS['ecs']->table('goods')." as g SET og.cost_price =
g.cost_price " .
" WHERE og.goods_id = g.goods_id".
" AND og.order_id = '$order_id' and og.cost_price=0";
$GLOBALS['db']->query($sql_cost);
将 
$goods_id = $_REQUEST['goods_id'];
$sql = "SELECT goods_id, c.cat_name, goods_sn, goods_name, b.brand_name, " .
"goods_number, market_price, shop_price, promote_price, " .
"promote_start_date, promote_end_date, goods_brief, goods_type, is_promote " .
"FROM " . $ecs->table('goods') . " AS g " .
"LEFT JOIN " . $ecs->table('brand') . " AS b ON g.brand_id = b.brand_id " .
"LEFT JOIN " . $ecs->table('category') . " AS c ON g.cat_id = c.cat_id " .
" WHERE goods_id = '$goods_id'";
修改成 
$goods_id = $_REQUEST['goods_id'];
$sql = "SELECT goods_id, c.cat_name, goods_sn, goods_name, b.brand_name, " .
"goods_number, market_price, shop_price,cost_price, promote_price, " .
"promote_start_date, promote_end_date, goods_brief, goods_type, is_promote " .
"FROM " . $ecs->table('goods') . " AS g " .
"LEFT JOIN " . $ecs->table('brand') . " AS b ON g.brand_id = b.brand_id " .
"LEFT JOIN " . $ecs->table('category') . " AS c ON g.cat_id = c.cat_id " .
" WHERE goods_id = '$goods_id'";
4.修改文件includes\lib_order.php
修改order_goods函数的SQL语句，将 
$sql = "SELECT rec_id, goods_id, goods_name, goods_sn, market_price, goods_number, " .
"goods_price, goods_attr, is_real, parent_id, is_gift, " .
"goods_price * goods_number AS subtotal, extension_code " .
"FROM " . $GLOBALS['ecs']->table('order_goods') .
" WHERE order_id = '$order_id'";
修改成 
$sql = "SELECT o.rec_id, o.goods_id, o.goods_name, o.goods_sn, o.market_price, o.goods_number, " .
"o.goods_price,if(o.cost_price>0,o.cost_price,g.cost_price) AS cost_price, o.goods_attr, o.is_real, o.parent_id, o.is_gift, " .
"o.goods_price * o.goods_number AS subtotal, o.extension_code " .
"FROM " . $GLOBALS['ecs']->table('order_goods') . " AS o ".
"LEFT JOIN " . $GLOBALS['ecs']->table('goods') . " AS g ON o.goods_id = g.goods_id " .
" WHERE order_id = '$order_id'";
5.修改订单商品模板admin\templates\order.dwt
在 
<th scope="col">{$lang.goods_attr}</th>
之后插入 
<th scope="col">{$lang.cost_price}</th>
在 
<td><textarea name="goods_attr[]" cols="30" rows="{$goods.rows}">{$goods.goods_attr}</textarea></td>
之后插入 
<td><input name="cost_price[]" type="text" style="text-align:right" value="{$goods.cost_price}" size="10" /></td>
在 
<tr>
<th>{$lang.goods_price}</th>
<td id="add_price"> </td>
</tr>
之后插入 
<tr>
<th>{$lang.cost_price}</th>
<td id="cost_price"> </td>
</tr>
在 
document.getElementByIdx_x_x('add_price').innerHTML = '';
之后插入 
document.getElementByIdx_x_x('cost_price').innerHTML = '';
在 
document.getElementByIdx_x_x('add_price').innerHTML = priceHtml;
之后插入 
document.getElementByIdx_x_x('cost_price').innerHTML = '<input type="text" name="cost_price" value="'+result.cost_price+'" />';
ecshop 功能二次开发 关于后台管理增加 和毛利润统计功能（三）
毛利润显示在报表统计的销售明细里 并且增加了成本汇总
1.到admin目录下覆盖 sale_list.php 文件 （做好备份）
2.到admin\templates目录下覆盖 sale_list.html（做好备份）
完成后，到后台"清存缓存"
左边菜单栏找到“报表统计 ” -> 销售明细 查看即可.
缺陷：
如果按指定的时间查询，底下利润等就显示不出来了。 （这是由于查询的时候用ajax调用的,我没有找到调用时的sql或其它,不知道官方这里怎么写的）

感谢您的认可和支持

微信支付二维码 - 长按识别

微信

支付宝二维码 - 长按识别

支付宝

持续输出优质内容需要动力，您的每一个打赏都是深夜码字时的温暖咖啡☕

本文标签：

很赞哦！ ()

上一篇：ecshop限制或禁用缓存的实现方法

下一篇：ecshop在nginx下实现负载均衡的方法

相关教程

图文教程

相关源码

  • 自适应LED照明外贸灯具灯泡灯具英文网站模板该外贸灯具网站模板专为LED照明、灯具出口企业定制，采用PbootCMS内核开发，提供高效建站方案。通过响应式设计和SEO优化能力，帮助企业低成本构建专业外贸展示平台。查看源码
  • (自适应)html5宽屏电线电缆材料加工制造类企业网站源码下载本模板基于PbootCMS系统开发，特别适合电线电缆、电缆材料及相关加工制造类企业使用。采用HTML5宽屏设计，能够展示各类电缆产品的技术参数和规格详情，帮助客户全面了解产品特性。查看源码
  • 自适应营销型IT网络工作室互联网建站公司pbootcms网站模板为IT网络服务商、建站企业打造的高性能营销门户，基于PbootCMS开源内核深度开发采用HTML5自适应架构，实现PC与手机端数据实时同步交互。查看源码
  • (PC+WAP)绿色硅胶橡胶玩具制品营销型网站源码下载为硅胶橡胶制品及玩具行业打造的营销型网站模板，采用PbootCMS内核开发，通过模块化设计实现产品参数、安全认证、应用场景等专业内容的可视化呈现，助力企业建立可信赖的线上展示平台。查看源码
  • (自适应)html5导航目录索引工具类网站源码下载本模板基于PbootCMS开发，为站长导航、网址导航类网站设计。采用HTML5+CSS3技术构建，适配PC端和移动端，提供流畅的浏览体验。适用于个人站长、资源导航平台等场景查看源码
  • (自适应)家政保洁保姆打扫卫生清灰服务pbootcms模板免费下载采用手工编写的DIV+CSS架构，代码结构清晰无冗余，加载速度优异。响应式设计适配各类终端设备，保障手机、平板、电脑端的一致浏览体验。查看源码
分享笔记 （共有 篇笔记）
验证码：

大家在看

ecshop收货地址199/198号段提示手机号格式不正确！

本栏推荐

相关标签

大家喜欢