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

2、ce'decimal(10,2)UNSIGNEDDEFAULT'NoTNuLLafter'promote_price'altertable'ecs_order_goods'addcolumn'cost_price'decimal(10,2)DEFAULT'NOTNULLafter'market_price'這里是力口在了字段promote_price和market_price后面第二步.增加語(yǔ)言包，需要修改languageszh_cnadmingoods.php再最后添加/*新增-成本價(jià)*/$_LANG&#

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

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

5、oods_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_n

6、ew,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',"."'$brand_id','$shop_price','$cost_price',&

7、#39;$market_price','$is_promote','$promote_price',"."'$promote_start_date','$promote_end_date','$goods_img','$goods_thumb','$original_img',"."'$_POSTkeywords','$_POSTgoods_brief','$_POSTseller_note

8、9;,'$goods_weight','$goods_number',"."'$warn_number','$_POSTintegral','$give_integral','$is_best','$is_new','$is_hot','$is_on_sale','$is_alone_sale',"."'$_POSTgoods_desc','".gmtime().

9、"','".gmtime()."','$goods_type','$rank_integral')"else$sql="INSERTINTO".$ecs->table('goods')."(goods_name,goods_name_style,goods_sn,"."cat_id,brand_id,shop_price,cost_price,market_price,is_promote,promote_price,"

10、;."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,ext

11、ension_code,rank_integral)"."VALUES('$_POSTgoods_name','$goods_name_style','$goods_sn','$catgory_id',"."'$brand_id','$shop_price','$cost_price','$market_price','$is_promote','$promote_price',".&q

12、uot;'$promote_start_date','$promote_end_date','$goods_img','$goods_thumb','$original_img',"."'$_POSTkeywords','$_POSTgoods_brief','$_POSTseller_note','$goods_weight','$goods_number',"."'$warn_numb

13、er','$_POSTintegral','$give_integral','$is_best','$is_new','$is_hot',0,'$is_on_sale','$is_alone_sale',"."'$_POSTgoods_desc','".gmtime()."','".gmtime()."','$goods_type','$code

14、','$rank_integral')"else/*如果有上傳圖片，刪除原來(lái)的商品圖*/$sql="SELECTgoods_thumb,goods_img,original_img"."FROM".$ecs->table('goods')."WHEREgoods_id='$_REQUESTgoods_id'"$row=$db->getRow($sql);if($proc_thumb&&$goods_img&&$row'

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

16、9;goods_thumb');$sql="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=

17、'$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='$pr

18、omote_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_thumb='$goods_thumb',"if($code!='')$sql.

19、="is_real=0,extension_code='$code',"$sql.="keywords='$_POSTkeywords',"."goods_brief='$_POSTgoods_brief',"."seller_note='$_POSTseller_note',"."goods_weight='$goods_weight',"."goods_number='$goods_number

20、',"."warn_number='$warn_number',"."integral='$_POSTintegral',"."give_integral='$give_integral',"."rank_integral='$rank_integral',"."is_best='$is_best',"."is_new='$is_new',"."is_h

21、ot='$is_hot',"."is_on_sale='$is_on_sale',"."is_alone_sale='$is_alone_sale',"."goods_desc='$_POSTgoods_desc',"."last_update='".gmtime()."',"."goods_type='$goods_type'"."WHEREgoods_id=

22、'$_REQUESTgoods_id'LIMIT1"(第三步主要是在插入數(shù)據(jù)庫(kù)時(shí)，把成本價(jià)(cost_price)的值插入到數(shù)據(jù)庫(kù))第四該在商品編輯頁(yè)讀取和顯示成本價(jià)格，需要修改admin/templates/goods_int找到代碼<tr><tdclass="label">$lang.lab_market_price</td><td><inputtype="text"name="market_price"value="$goarket_pri

23、ce"size="20"/><inputtype="button"value="$egral_market_price"onclick="integral_market_price()"/></td></tr>在這段代碼之后添加顯示成本價(jià)格的表格<!-新增成本價(jià)begin-><tr><tdclass="label">$lab_cost_price</td><td><

24、;inputtype="text"name="cost_price"value="$goodt_price"size="20"/><br/><spanclass="notice-span"if$help_openstyle="display:block"elsestyle="display:none"/ifid="minNumber">$lang.notice_cost_price</span>

25、</td></td></tr><!-成本價(jià)end->這樣就把就完成了在商品添加時(shí)增加商品的成本價(jià)和在商品列表頁(yè)編輯商品頁(yè)顯示成本價(jià)的功能ecshop功能二次開(kāi)發(fā)關(guān)于后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能(二)訂單的語(yǔ)言文件languageszh_cnadminorder.php最后新增：$_LANG'cost_price'='成本價(jià)'后我們來(lái)修改訂單顯示模板文件admintemplatesorder_inf把<由colspan="7"scope="col">修改成&l

26、t;thcolspan="8"scope="col">在<tdscope="col"><divalign="center"><strong>$ltorage</strong></div></td>代碼之后插入<tdscope="col"><divalign="center"><strong>$lang.cost_price</strong></d

27、iv></td>在<td><divalign="right">$goods.storage</div></td>代碼之后插入<td><divalign="right">$goods.cost_price</div></td>3.下面是如何修改修改adminorde將$sql="SELECTo.*oods_numberASstorage,o.goods_attr,IFNULL(nd_name,'')ASbrand_na

28、me"."FROM".$ecs->table('order_goods')."ASo"."LEFTJOIN".$ecs->table('goods')."ASgOoods_id=ds_id"."LEFTJOIN".$ecs->table('brand')."ASbONnd_id=b.brand_id"."WHERrder_id='$orderorder_id'"修改

29、成$sql="SELECTo.*,ods_numberASstorage,if(t_price>0,t_price,g.cost_price)AScost_price,o.goods_attr,IFNULL(b.brand_name,'')ASbrand_name"."FROM".$ecs->table('order_goods')."ASo"."LEFTJOIN".$ecs->table('goods')."ASgONods_id=g.g

30、oods_id"."LEFTJOIN".$ecs->table('brand')."ASbONg.brand_idrand_id"."WHERrder_id='$orderorder_id'"在/*取得參數(shù)*/$goods_price=floatval($_POST'goods_price'$key);之后插入$cost_price=floatval($_POST'cost_price'$key);將/*修改*/$sql="UPDATE"

31、;.$ecs->table('order_goods')."SETgoods_price='$goods_price',"."goods_number='$goods_number',"."goods_attr='$goods_attr'"."WHERErec_id='$rec_id'LIMIT1"修改成$sql="UPDATE".$ecs->table('order_goods').&q

32、uot;SETgoods_price='$goods_price',cost_price='$cost_price',"."goods_number='$goods_number',"."goods_attr='$goods_attr'"."WHERErec_id='$rec_id'LIMIT1"在/*標(biāo)記訂單為已確認(rèn)*/update_order($order_id,array('order_status'=>OS_CONF

33、IRMED,'confirm_time'=>gmtime();之后插入/*計(jì)算并插入商品的成本*/$sql_cost="UPDATE".$GLOBALS'ecs'->table('order_goods')."asog,".$GLOBALS'ecs'->table('goods')."asgSETst_price=ost_price"."WHEREog.goods_idoods_id"."ANDoer_id=

34、'$order_id'andot_price=0"$GLOBALS'db'->query($sql_cost);/*標(biāo)記訂單為已確認(rèn)*/=>update_order($order_id,array('order_status'=>OS_CONFIRMED,'confirm_time'gmtime();update_order_amount($order_id);之后插入/*計(jì)算并插入商品的成本*/$sql_cost="UPDATE".$GLOBALS'ecs'->

35、;table('order_goods')."asog,".$GLOBALS'ecs'->table('goods')."asgSETog.cost_price=g.cost_price"."WHEREods_id=g.goods_id"."ANDrder_id='$order_id'andost_price=0"$GLOBALS'db'->query($sql_cost);將/*取得商品信息*/$goods_id=$_RE

36、QUEST'goods_id'$sql="SELECTgoods_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')."ASg&qu

37、ot;."LEFTJOIN".$ecs->table('brand')."ASbONand_id=b.brand_id"."LEFTJOIN".$ecs->table('category')."AScONt_idat_id"."WHEREgoods_id='$goods_id'"修改成/*取得商品信息*/$goods_id=$_REQUEST'goods_id'$sql="SELECTgoods_id,c.ca

38、t_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')."ASg"."LEFTJOIN".$ecs->table(&#

39、39;brand')."ASbOrand_id=nd_id"."LEFTJOIN".$ecs->table('category')."AScOat_id=c.cat_id"."WHEREgoods_id='$goods_id'"件includeslib_order.php修改order_goods8數(shù)的SQL語(yǔ)句，將$sql="SELECTrec_id,goods_id,goods_name,goods_sn,market_price,goods_number

40、,"."goods_price,goods_attr,is_real,parent_id,is_gift,"."goods_price*goods_numberASsubtotal,extension_code"."FROM".$GLOBALS'ecs'->table('order_goods')." WHEREorder_id='$order_id'"修改成$sql="SELECTo.rec_id,o.goods_id,ds_name,o.

41、goods_sn,rket_priceoods_number,"."ds_price,iost_price>ost_price,t_price)AScost_price,ds_attr,o.is_real,ent_id,o.is_gift,".ods_priceoods_numberASsubtotal,ension_code"."FROM".$GLOBALS'ecs'->table('order_goods')."ASo"."LEFTJOIN".$G

42、LOBALS'ecs'->table('goods')."ASgONo.goods_id=ods_id"." WHEREorder_id='$order_id'"訂單商品模板admintemplatesordt在<thscope="col">$loods_attr</th>之后插入<thscope="col">$last_price</th>在<td><textareaname="goo

43、ds_attr"cols="30"rows="$goows">$gooods_attr</textarea></td>之后插入<td><inputname="cost_price"type="text"style="text-align:right"value="$goost_price"size="10"/></td>在<tr><th>$lang.good

44、s_price</th><tdid="add_price">&nbsp;</td></tr>之后插入<tr><th>$lang.cost_price</th><tdid="cost_price">&nbsp;</td></tr>在documenElementById('add_price').innerHTML=''之后插入documetElementById('cost_pric

45、e').innerHTML=''在documetElementById('add_price').innerHTML=priceHtml;之后插入documetElementById('cost_price').innerHTML='<inputtype="text"name="cost_price"value="'+resust_price+'"/>'ecshop功能二次開(kāi)發(fā)關(guān)于后臺(tái)管理增加成本價(jià)和毛利潤(rùn)統(tǒng)計(jì)功能（三）毛利潤(rùn)顯示在報(bào)表

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

47、9;gross_profit_rate'='成本毛利率：'應(yīng)的模板文件admintemplatessale_lis在<th>$lanl_price</th>之后插入<th>$last_price</th><th>$lross_profit</th>在<tdalign="right">$lales_price</td>之后插入<tdalign="right">$lost_price</td><tdalign=

48、"right">$lross_profit</td>在foreachelse<tr><tdclass="no-records"colspan="10">$lang.no_records</td></tr>/foreach之后插入if$sale_total<tralign="center"><tdalign="right"colspan="4">$lane_total</td>

49、<tdalign="right">$sale_total</td><tdalign="right">$last_total</td><tdalign="right">$cost_total</td></tr><tralign="center"><tdalign="right"colspan="4">$lanss_profit_total</td><td

50、align="right">$gross_profit_total</td><tdalign="right">$lross_profit_rate</td><tdalign="right">$gross_profit_rate</td></tr>/if3.修改sale_lis將$sql='SELECToods_id,ods_sn,og.goods_name,og.goods_numberASgoods_num,og.goods_price'.

51、'ASsales_price,o_timeASsales_time,rder_id,oer_sn'."FROM".$ecs->table('order_goods')."ASog,".$ecs->table('order_info')."ASoi".$where."ORDERBYsales_timeDESC,goods_numDESC"修改成$sql='SELECTods_id,og.goods_sn,ods_name,ods_numberASgo

52、ods_num,st_price,ods_price'.'ASsales_price,(og.goods_price-og.cost_price)*og.goods_numberasgross_profit,d_timeASsales_time,oi.order_id,der_sn'."FROM".$ecs->table('order_goods')."ASog,".$ecs->table('order_info')."ASoi".$where."ORDER

53、BYsales_timeDESC,goods_numDESC"將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

54、_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_p

55、rice');$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($sa

56、le_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'la

57、ng');之后插入$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);在echoecs_iconv(EC_CHARSET,'GB2312',$_

58、LANG'sell_price')."t"之后插入echoecs_iconv(EC_CHARSET,'GB2312',$_LANG'cost_price')."t"echoecs_iconv(EC_CHARSET,'GB2312',$_LANG'gross_profit')."t"將foreach($goods_sales_listAS$key=>$value)echoecs_iconv(EC_CHARSET,'GB2312',$value'goods_name')."t"echoecs_iconv(EC_CHARSET,'GB2312',''.$value'order_sn'.'')."t"echoecs_iconv(EC_CHARSET,'GB2312',$value'