| 单据日期 |
客户 |
销售人员 |
单据编号 |
业务类型 |
数量 |
销售收入 |
销售成本 |
销售毛利
(销售收入-销售成本) |
毛利率 |
优惠金额 |
销售净利润
(销售毛利-优惠金额) |
净利润率 |
优惠后金额 |
应收金额 |
已收款金额 |
整单备注 |
$row) {
$totalAmount = (float)$row['totalAmount'];
$amount = (float)$row['amount'];
$v[$arr]['salesNo'] = $row['salesNo'];
$v[$arr]['contactNo'] = $row['contactNo'];
$v[$arr]['billDate'] = $row['billDate'];//单据日期
$v[$arr]['salesName'] = $row['salesName'];//销售人员
$v[$arr]['contactName'] = $row['contactName'];//客户
$v[$arr]['billNo'] = $row['billNo'];//单据编号
$v[$arr]['transTypeName'] = $row['transTypeName'];//业务类型
$v[$arr]['totalQty'] = (float)$row['totalQty'];//数量
$v[$arr]['disAmount'] = (float)$row['disAmount'];//优惠金额
$v[$arr]['amount'] = (float)$row['amount'];//优惠后金额
$v[$arr]['totalAmount'] = (float)$row['totalAmount'];//销售收入
//$v[$arr]['totalCost'] = (float)$row['totalCost'];//销售成本
$v[$arr]['ysAmount'] = (float)$row['amount'];//应收金额
$v[$arr]['rpAmount'] = (float)$row['rpAmount'];//已收款金额
$v[$arr]['description'] = $row['description'];//整单备注
$details = $this->data_model->get_invoice_info(' a.iid ='.$row['id']);
$sum = 0;
foreach ($details as $key=>$detail) {
$qty = $detail['qty']>0 ? -abs($detail['qty']):abs($detail['qty']);
$unitcost = isset($info['inprice'][$detail['invId']][$detail['locationId']]) ? $info['inprice'][$detail['invId']][$detail['locationId']] : 0; //单位成本
$sum += $cost = $unitcost * $qty;
}
$v[$arr]['totalCost'] = round($sum,2);//销售成本
$v[$arr]['saleProfit'] = round($totalAmount - $sum,2);//销售毛利=销售收入-销售成本
$salepPofitRate = $totalAmount>0? ($v[$arr]['saleProfit']/$totalAmount)*100 :0;
$v[$arr]['salepPofitRate'] = round($salepPofitRate,2).'%';//毛利率
$v[$arr]['pureProfit'] = $v[$arr]['saleProfit'] - $v[$arr]['disAmount'];//销售净利润=销售毛利-优惠金额
$pureProfitRate = $amount>0? ($v[$arr]['pureProfit']/$amount)*100 :0;
$v[$arr]['pureProfitRate'] = round($pureProfitRate,2).'%';//净利润率
$sum1 += $v[$arr]['totalQty'];
$sum2 += $v[$arr]['disAmount'];
$sum3 += $v[$arr]['amount'];
$sum4 += $v[$arr]['totalAmount'];
$sum5 += $v[$arr]['ysAmount'];
$sum6 += $v[$arr]['rpAmount'];
$sum7 += $v[$arr]['totalCost'];
$sum8 += $v[$arr]['saleProfit'];
$sum9 += $salepPofitRate;
$sum10 += $v[$arr]['pureProfit'];
$sum11 += $pureProfitRate;
?>
|
|
|
|
|
systems['qtyPlaces'])?> |
systems['qtyPlaces'])?> |
|
|
% |
|
|
% |
|
|
|
|
| 合计： |
systems['qtyPlaces'])?> |
systems['qtyPlaces'])?> |
|
|
% |
|
|
% |
|
|
|