[匯編]ecshop功能二次開發(fā)之后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能

1、ecshop功能二次開發(fā)之后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能ecshop功能二次開發(fā)之后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能ecshop功能二次開發(fā)之后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能 在做ecshop二次開發(fā)的時(shí)候增加一個(gè)財(cái)務(wù)統(tǒng)計(jì)的功能！首先在訂單中的商品信息【編輯】頁(yè)面中，修改成本價(jià)。也可以在添加商品時(shí)添加成本的 如果不做手工修改，則使用默認(rèn)的商品成本價(jià)（在商品信息里編輯的成本第一步：修改數(shù)據(jù)庫(kù)中的商品表ecs_goods和訂單商品表ecs_order_goods，添加成本價(jià)字段cost_price 把SQL語(yǔ)句列出來： alter table ecs_goods add column cos

2、t_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后面第二步.增加語(yǔ)言包 ，需要修改languageszh_cnadmingoods.php 再最后添加 /* 新增-成本價(jià) */$_

3、LANG'lab_cost_price' = '成本價(jià):'$_LANG'notice_cost_price' = '該商品進(jìn)貨價(jià)格(成本價(jià)，在商品添加時(shí)設(shè)置，也可以在商品編輯里面修改 。).' 在兩個(gè)（有兩個(gè)地方需要修改） 'promote_price' => 0, 后新增一行添加 'cost_price' => 0,再在 $shop_price = !empty($_POST'shop_price') ? $_POST'shop_price' : 0;

4、后添加 $cost_price = !empty($_POST'cost_price') ? $_POST'cost_price' : 0;將 /* 入庫(kù) */ if ($is_insert) 。源代碼太多省略（了這個(gè)是真實(shí)商品和虛擬商品） else /* 如果有上傳圖片，刪除原來的商品圖 */ 。源代碼太多省略了 修改成 /* 入庫(kù) */ if ($is_insert) if ($code = '') $sql = "INSERT INTO " . $ecs->table('goods') . &quo

5、t; (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, goo

6、ds_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 ('$_POSTgoods_name', '$goods_name_style', '$goods_sn', '$catgory_id',

7、 " . "'$brand_id', '$shop_price','$cost_price', '$market_price', '$is_promote','$promote_price', ". "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img',

8、". "'$_POSTkeywords', '$_POSTgoods_brief', '$_POSTseller_note', '$goods_weight', '$goods_number',". " '$warn_number', '$_POSTintegral', '$give_integral', '$is_best', '$is_new', '$is_hot', '

9、;$is_on_sale', '$is_alone_sale', ". " '$_POSTgoods_desc', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral')" else $sql = "INSERT INTO " . $ecs->table('goods') . " (go

10、ods_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_num

11、ber, 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 ('$_POSTgoods_name', '$goods_name_style', '$goods_sn', 

12、9;$catgory_id', " . "'$brand_id', '$shop_price','$cost_price', '$market_price', '$is_promote','$promote_price', ". "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$

13、original_img', ". "'$_POSTkeywords', '$_POSTgoods_brief', '$_POSTseller_note', '$goods_weight', '$goods_number',". " '$warn_number', '$_POSTintegral', '$give_integral', '$is_best', '$is_new', '

14、;$is_hot', 0, '$is_on_sale', '$is_alone_sale', ". " '$_POSTgoods_desc', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$code', '$rank_integral')" else /* 如果有上傳圖片，刪除原來的商品圖 */ $sql = "SEL

15、ECT goods_thumb, goods_img, original_img " . " FROM " . $ecs->table('goods') . " WHERE goods_id = '$_REQUESTgoods_id'" $row = $db->getRow($sql); if ($proc_thumb && $goods_img && $row'goods_img' && !goods_parse_url($row

16、9;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 = &qu

17、ot;UPDATE " . $ecs->table('goods') . " SET " . "goods_name = '$_POSTgoods_name', " . "goods_name_style = '$goods_name_style', " . "goods_sn = '$goods_sn', " . "cat_id = '$catgory_id', " . "brand_id

18、 = '$brand_id', " . "shop_price = '$shop_price', " . "cost_price = '$cost_price', " . "market_price = '$market_price', " . "is_promote = '$is_promote', " . "promote_price = '$promote_price', " . &q

19、uot;promote_start_date = '$promote_start_date', " . "promote_end_date = '$promote_end_date', " /* 如果有上傳圖片，需要更新數(shù)據(jù)庫(kù) */ if ($goods_img) $sql .= "goods_img = '$goods_img', original_img = '$original_img', " if ($goods_thumb) $sql .= "goods_thu

20、mb = '$goods_thumb', " if ($code != '') $sql .= "is_real=0, extension_code='$code', " $sql .= "keywords = '$_POSTkeywords', " . "goods_brief = '$_POSTgoods_brief', " . "seller_note = '$_POSTseller_note', " .

21、 "goods_weight = '$goods_weight'," . "goods_number = '$goods_number', " . "warn_number = '$warn_number', " . "integral = '$_POSTintegral', " . "give_integral = '$give_integral', " . "rank_integral = '$

22、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 = '$_POSTgo

23、ods_desc', " . "last_update = '". gmtime() ."', ". "goods_type = '$goods_type' " . "WHERE goods_id = '$_REQUESTgoods_id' LIMIT 1" （第三步 主要是在插入數(shù)據(jù)庫(kù)時(shí)，把成本價(jià)（cost_price）的值插入到數(shù)據(jù)庫(kù)）第四步.下面應(yīng)該在商品編輯頁(yè)讀取和顯示成本價(jià)格，需要修改admin/templates/goods_info.d

24、wt 找到代碼 <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="$egral_market_price&quo

25、t; onclick="integral_market_price()" /> </td> </tr>在這段代碼之后添加顯示成本價(jià)格的表格<!-新增 成本價(jià) begin -> <tr> <td class="label">$lang.lab_cost_price</td> <td><input type="text" name="cost_price" value="$goods.cost_price"

26、; size="20" /> <br /> <span class="notice-span" if $help_openstyle="display:block" else style="display:none" /if id="minNumber">$lang.notice_cost_price</span></td> </td> </tr> <!- 成本價(jià) end ->這樣就把就完成了在商品添加時(shí)增

27、加商品的成本價(jià)和在商品列表頁(yè)編輯商品頁(yè)顯示成本價(jià)的功能ecshop 功能二次開發(fā) 關(guān)于后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能（二） 最后新增：$_LANG'cost_price' = '成本價(jià)'把<th colspan="7" scope="col">修改成<th colspan="8" scope="col">在<td scope="col"><div align="center"><stro

28、ng>$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>&l

29、t;div align="right">$goods.cost_price</div></td> 將 $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 "

30、 . $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 = '$orderorder_id' "修改成$sql = "SELECT o.*, g.goods_number AS storag

31、e,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

32、= g.goods_id " . "LEFT JOIN " . $ecs->table('brand') . " AS b ON g.brand_id = b.brand_id " . "WHERE o.order_id = '$orderorder_id' "在/* 取得參數(shù) */ $goods_price = floatval($_POST'goods_price'$key);之后插入$cost_price = floatval($_POST'cost_pri

33、ce'$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

34、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 = &#

35、39;$rec_id' LIMIT 1"在/* 標(biāo)記訂單為已確認(rèn) */ update_order($order_id, array('order_status' => OS_CONFIRMED, 'confirm_time' => gmtime();之后插入/* 計(jì)算并插入商品的成本 */ $sql_cost = "UPDATE ". $GLOBALS'ecs'->table('order_goods')." as og,". $GLOBALS'e

36、cs'->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);在 /* 標(biāo)記訂單為已確認(rèn) */ update_order($order_id, array('o

37、rder_status' => OS_CONFIRMED, 'confirm_time' => gmtime(); update_order_amount($order_id);之后插入/* 計(jì)算并插入商品的成本 */ $sql_cost = "UPDATE ". $GLOBALS'ecs'->table('order_goods')." as og,". $GLOBALS'ecs'->table('goods')." as g SE

38、T 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_

39、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 " . $e

40、cs->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 = &

41、quot;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')

42、 . " 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'" 修改order_goods

43、函數(shù)的SQL語(yǔ)句，將 $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(&

44、#39;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.paren

45、t_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

46、 = g.goods_id " . " WHERE order_id = '$order_id'" 在<th scope="col">$lang.goods_attr</th>之后插入<th scope="col">$lang.cost_price</th>在<td><textarea name="goods_attr" cols="30" rows="$goods.rows">

47、$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_pr

48、ice">&nbsp;</td> </tr>之后插入 <tr> <th>$lang.cost_price</th> <td id="cost_price">&nbsp;</td> </tr>在document.getElementById('add_price').innerHTML = ''之后插入document.getElementById('cost_price').innerHTML = &

49、#39;'在document.getElementById('add_price').innerHTML = priceHtml;之后插入document.getElementById('cost_price').innerHTML = '<input type="text" name="cost_price" value="'+result.cost_price+'" />' ecshop 功能二次開發(fā) 關(guān)于后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能（三）毛

50、利潤(rùn)顯示在報(bào)表統(tǒng)計(jì)的銷售明細(xì)里 并且增加了成本匯總1.首先要修改對(duì)應(yīng)的語(yǔ)言文件languageszh_cnadminstatistic.php 在最后新增 /* 新增 成本 毛利潤(rùn)*/$_LANG'cost_price' = '成本價(jià)'$_LANG'gross_profit' = '毛利潤(rùn)'$_LANG'sale_total' = '銷售收入：'$_LANG'cost_total' = '成本匯總：'$_LANG'gross_profit_total'

51、 = '毛利潤(rùn)合計(jì)：'$_LANG'gross_profit_rate' = '成本毛利率：' 在 <th>$lang.sell_price</th>之后插入 <th>$lang.cost_price</th> <th>$lang.gross_profit</th>在<td align="right">$list.sales_price</td>之后插入 <td align="right">$list

52、.cost_price</td> <td align="right">$list.gross_profit</td>在 foreachelse <tr><td class="no-records" colspan="10">$lang.no_records</td></tr> /foreach之后插入 if $sale_total <tr align="center"> <td align="right&

53、quot; colspan="4">$lang.sale_total</td> <td align="right">$sale_total</td> <td align="right">$lang.cost_total</td> <td align="right">$cost_total</td> </tr> <tr align="center"> <td align=&quo

54、t;right" colspan="4">$lang.gross_profit_total</td> <td align="right">$gross_profit_total</td> <td align="right">$lang.gross_profit_rate</td> <td align="right">$gross_profit_rate</td> </tr> /if 將 $sql = &#

55、39;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').&

56、quot; 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.ad

57、d_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&#

58、39;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($re

59、s)$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

60、_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 =

61、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-

62、>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_pr

63、ice') . "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',