admin/goods.php,ecshop后台管理增加商品成本价和毛利润统计功能

爱被打了一巴掌 2023-01-16 09:47 113阅读 0赞

ecshop功能二次开发之后台管理增加成本价和毛利润统计功能

在做ecshop二次开发的时候增加一个财务统计的功能！

首先在订单中的商品信息【编辑】页面中，修改成本价。也可以在添加商品时添加成本的如果不做手工修改，则使用默认的商品成本价(在商品信息里编辑的成本

价格)。我用的版本是ecshop2.7.2

第一步：修改数据库中的商品表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

找到代码

\{$lang.lab\_market\_price\}

在这段代码之后添加显示成本价格的表格

\{$lang.lab\_cost\_price\}

\{$lang.notice\_cost\_price\}

这样就把就完成了在商品添加时增加商品的成本价和在商品列表页编辑商品页显示成本价的功能

ecshop 功能二次开发 关于后台管理增加成本价和毛利润统计功能(二)

1.修改订单的语言文件languages\\zh\_cn\\admin\\order.php

最后新增：$\_LANG\['cost\_price'\] = '成本价';

2.然后我们来修改订单显示模板文件 admin\\templates\\order\_info.dwt

把

修改成

在

**\{$lang.storage\}**

代码之后插入

**\{$lang.cost\_price\}**

在

\{$goods.storage\}

代码之后插入

\{$goods.cost\_price\}

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

在

\{$lang.goods\_attr\}

之后插入

\{$lang.cost\_price\}

在

\{$goods.goods\_attr\}

之后插入

在

\{$lang.goods\_price\}

之后插入

\{$lang.cost\_price\}

在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 = '';

ecshop 功能二次开发 关于后台管理增加成本价和毛利润统计功能(三)

毛利润显示在报表统计的销售明细里 并且增加了成本汇总

1.首先要修改对应的语言文件languages\\zh\_cn\\admin\\statistic.php

在最后新增

$\_LANG\['cost\_price'\] = '成本价';

$\_LANG\['gross\_profit'\] = '毛利润';

$\_LANG\['sale\_total'\] = '销售收入：';

$\_LANG\['cost\_total'\] = '成本汇总：';

$\_LANG\['gross\_profit\_total'\] = '毛利润合计：';

$\_LANG\['gross\_profit\_rate'\] = '成本毛利率：';

2.修改对应的模板文件admin\\templates\\sale\_list.dwt

在

\{$lang.sell\_price\}之后插入     \{$lang.cost\_price\}\{$lang.gross\_profit\}

在

\{$list.sales\_price\}

之后插入

\{$list.cost\_price\}\{$list.gross\_profit\}

在  \{foreachelse\}

\{$lang.no\_records\}

\{/foreach\}

之后插入

\{if $sale\_total\}

\{$lang.sale\_total\}\{$sale\_total\}\{$lang.cost\_total\}\{$cost\_total\}\{$lang.gross\_profit\_total\}\{$gross\_profit\_total\}\{$lang.gross\_profit\_rate\}\{$gross\_profit\_rate\}

\{/if\}

3.修改sale\_list.php

将  $sql = 'SELECT og.goods\_id, og.goods\_sn, og.goods\_name, og.goods\_number AS goods\_num, og.goods\_price '.

'AS sales\_price, oi.add\_time AS sales\_time, oi.order\_id, oi.order\_sn '.

"FROM " . $ecs->table('order\_goods')." AS og, ".$ecs->table('order\_info')." AS oi ".

$where. " ORDER BY sales\_time DESC, goods\_num DESC";

修改成$sql = 'SELECT og.goods\_id, og.goods\_sn, og.goods\_name, og.goods\_number AS goods\_num, og.cost\_price, og.goods\_price '.

'AS sales\_price,(og.goods\_price-og.cost\_price)\*og.goods\_number as gross\_profit, oi.add\_time AS sales\_time, oi.order\_id, oi.order\_sn '.

"FROM " . $ecs->table('order\_goods')." AS og, ".$ecs->table('order\_info')." AS oi ".

$where. " ORDER BY sales\_time DESC, goods\_num DESC";

将while ($items = $db->fetchRow($res))

$items\['sales\_price'\]   = price\_format($items\['sales\_price'\]);

$items\['sales\_time'\]    = local\_date($\_CFG\['time\_format'\], $items\['sales\_time'\]);

$goods\_sales\_list\[\]     = $items;

修改成

$sale\_total = $cost\_total = $gross\_profit\_total =$gross\_profit\_rate = 0;

while ($items = $db->fetchRow($res))

$sale\_total += $items\['sales\_price'\] \* $items\['goods\_num'\];

$cost\_total += $items\['cost\_price'\] \* $items\['goods\_num'\];

$gross\_profit\_total += $items\['gross\_profit'\];

$items\['cost\_price'\]   = price\_format($items\['cost\_price'\]);

$items\['gross\_profit'\]   = price\_format($items\['gross\_profit'\]);

$items\['sales\_price'\]   = price\_format($items\['sales\_price'\]);

$items\['sales\_time'\]    = local\_date($\_CFG\['time\_format'\], $items\['sales\_time'\]);

$goods\_sales\_list\[\]     = $items;

$total\_isdisplay = false;

if($sale\_total>0)

$total\_isdisplay = true;

$gross\_profit\_rate = round($gross\_profit\_total\*100/$sale\_total,2).'%';   //毛利/销售收入

$sale\_total   = price\_format($sale\_total);

$cost\_total   = price\_format($cost\_total);

$gross\_profit\_total   = price\_format($gross\_profit\_total);

在$smarty->assign('cfg\_lang',     $\_CFG\['lang'\]);

之后插入

$smarty->assign('sale\_total',     $sale\_total);

$smarty->assign('cost\_total',     $cost\_total);

$smarty->assign('gross\_profit\_total',$gross\_profit\_total);

$smarty->assign('gross\_profit\_rate',$gross\_profit\_rate);

在echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['sell\_price'\]) . "\\t";

之后插入echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['cost\_price'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['gross\_profit'\]) . "\\t";

将    foreach ($goods\_sales\_list AS $key => $value)

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['goods\_name'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', '\[ ' . $value\['order\_sn'\] . ' \]') . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['goods\_num'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['sales\_price'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['sales\_time'\]) . "\\t";

echo "\\n";

修改成

foreach ($goods\_sales\_list AS $key => $value)

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['goods\_name'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', '\[ ' . $value\['order\_sn'\] . ' \]') . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['goods\_num'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['sales\_price'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['cost\_price'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['gross\_profit'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $value\['sales\_time'\]) . "\\t";

echo "\\n";

if($total\_isdisplay)

echo ecs\_iconv(EC\_CHARSET, 'GB2312', '') . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['sale\_total'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $sale\_total) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['cost\_total'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $cost\_total) . "\\t\\n";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', '') . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['gross\_profit\_total'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $gross\_profit\_total) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $\_LANG\['gross\_profit\_rate'\]) . "\\t";

echo ecs\_iconv(EC\_CHARSET, 'GB2312', $gross\_profit\_rate) . "\\t\\n";

后台增加计算利润的功能已经做好了。

admin/goods.php,ecshop后台管理增加商品成本价和毛利润统计功能

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 admin/goods.php,ecshop后台管理增加商品成本价和毛利润统计功能

相关 JAVAWEB使用JSP+Servlet实现商品管理功能，后台为数据库，功能包括商品信息浏览、商品信息详情、商品信息删除及修改。

相关 16、【商品管理模块开发】——后台商品列表动态分页功能开发

相关 14、【商品管理模块开发】——后台商品新增保存、更新、上下架功能开发

相关 phpcms v9 后台增加搜索关键字编辑管理功能

相关电商后台管理系统商品添加和删除

相关电商后台管理系统商品分类参数修改和删除功能

相关商品管理系统——商品库存和采购需求检索功能

相关电商后台管理系统商品商品列表

相关电商后台管理系统商品报表功能——ECharts入门示例