帖子標題：[分享] ecshop後臺管理增加毛利潤統計功能的設置方法 ecshop, admin, 成本, center, admin, center, ecshop, 成本

最模板

1.修改訂單的語言文件languages\zh_cn\admin\order.php
   最後新增：$_LANG['cost_price'] = '成本價';
2.然後我們來修改訂單顯示模板文件 admin\templates\order_info.dwt
把<th colspan="7" scope="col">修改成<th colspan="8" 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">&nbsp;</td>
  </tr>
之後插入  
  <tr>
    <th>{$lang.cost_price}</th>
    <td id="cost_price">&nbsp;</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+'" />';
這樣就OK了。


ecshop模板
网站模板