Codeigniter一个字段中的记录的总和内容
问题描述：
我想从MySQL数据库中获取一些信息，并使用以下脚本（我正在使用Codeigniter）显示它。Codeigniter一个字段中的记录的总和内容
数据库ORDER_DETAILS
order_id | qty | price
4 2 0.9
4 1 0.9
4 1 0.85
在我看来，我有
<?php
\t $sum = $sum[0]->price;
\t $qty = $qty[0]->qty;
\t $total = $sum * $qty;
?>
<div class="container">
\t <div class="well">
\t <a href="<?php echo base_url('billing/view')?>" class="btn btn-success"><</a>
\t <?php foreach($customer as $data):?>
\t <a href="<?php echo base_url('print_pdf/reciept_pdf/'.$data->oid)?>" class="btn btn-info">PDF</a>
\t <a href="<?php echo base_url('print_pdf/download_pdf/'.$data->oid)?>" class="btn btn-warning">Download PDF</a>
\t
\t \t
\t \t \t <table class="table table-bordered">
\t \t \t <br>
\t \t \t <tr>
\t \t \t \t <td>Nome cliente:</td>
\t \t \t \t <td><?php echo $data->customer_name;?></td>
\t \t \t \t <td>NIF:</td>
\t \t \t \t <td><?php echo $data->customer_contact;?></td>
\t \t \t \t
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td>Pagamento:</td>
\t \t \t \t <td><?php echo $data->payment;?></td>
\t \t \t \t <td>Data da Ordem:</td>
\t \t \t \t <td><?php echo $data->date;?></td>
\t \t \t </tr>
\t \t <?php endforeach; \t ?>
\t \t \t <tr>
\t \t \t \t <td>Unid.</td>
\t \t \t \t <td>Item</td>
\t \t \t \t <td>Qtd.</td>
\t \t \t \t <td>Valor</td>
\t \t \t </tr>
\t \t \t <?php
\t \t \t foreach($results as $data):?>
\t \t \t <tr> \t
\t \t \t \t <td></td>
\t \t \t \t <td><?php echo $data->product_name;?></td>
\t \t \t \t <td><?php echo $data->qty;?></td>
\t \t \t \t <td>€ <?php
\t \t \t \t \t
\t \t \t \t echo number_format($data->qty * $data->price,2);?></td>
\t \t \t </tr>
\t \t \t <?php endforeach; \t ?>
\t \t \t <tr>
\t \t \t \t <td></td>
\t \t \t \t <td></td>
\t \t \t \t <td></td>
\t \t \t \t <td></td>
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td></td>
\t \t \t \t <td></td>
\t \t \t \t <td>Total da Venda (IVA Incl)</td>
\t \t \t \t <td>€ <?php echo number_format($total ,2) ;?></td>
\t \t \t \t
\t \t \t
\t \t \t \t
\t \t \t \t
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t
\t \t \t \t <td>Valor do IVA</td>
\t \t \t \t <td>€ <?php echo number_format($vat = 0 * $total ,2) ;?></td>
\t \t \t \t <td>Valor iliquido</td>
\t \t \t \t <td>€ <?php echo number_format($vatable =$total - $vat ,2);?></td>
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td>Tabela IVA</td>
\t \t \t \t <td>€ <?php echo number_format($vatable =$total - $vat ,2);?></td>
\t \t \t \t <td>Valor iliquido</td>
\t \t \t \t <td>€ <?php echo number_format($vatable =$total - $vat ,2);?></td>
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td>VAT-Exempt</td>
\t \t \t \t <td></td>
\t \t \t \t <td>Less:SC/PWD Discount</td>
\t \t \t \t <td></td>
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td>VAT Zero Rated</td>
\t \t \t \t <td></td>
\t \t \t \t <td>Amount Due</td>
\t \t \t \t <td></td>
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td>VAT - 0%</td>
\t \t \t \t <td>€ <?php echo number_format($vat = 0 * $total,2) ;?></td>
\t \t \t \t <td>Adicionar: IVA</td>
\t \t \t \t <td></td>
\t \t \t </tr>
\t \t \t <tr>
\t \t \t \t <td></td>
\t \t \t \t <td></td>
\t \t \t \t <td>Total Amout Due</td>
\t \t \t \t <td>€ <?php echo number_format($total,2)?></td>
\t \t \t </tr>
\t \t \t </table>
\t \t \t
\t </div>
</div>但结果是10.60，而不是3.55
在模型我有这个
public function get_sum($oid)
{
$this->db->select_sum('price')
->where('order_id',$oid);
$query = $this->db->get('order_details');
return $query->result();
}
public function get_qty($oid)
{
$this->db->select_sum('qty')
->where('order_id',$oid);
$query = $this->db->get('order_details');
return $query->result();
我有这样的：
public function view_id($oid)
{
if($this->session->userdata('logged_in')){
$data['qty'] = $this->billings->get_qty($oid);
$data['sum'] = $this->billings->get_sum($oid);
$data['results'] = $this->billings->fetch_order_details($oid);
$data['customer'] = $this->billings->fetch_customer_details($oid);
$this->load->view('order/order_details',$data);
}else{
redirect(base_url(''));
}
}
这个问题的任何帮助吗？
答
好的，现在就解决了：
怎么样？
插入在模型中新sintax，
public function get_qty($oid)
\t {
\t \t
\t \t $this->db->select('sum(price * qty) as qty', FAlSE)
\t \t \t \t ->where('order_id',$oid);
\t \t $query = $this->db->get('order_details');
\t \t return $query->result();
\t }在我改变$总和= $总和视图[0] - >价格;到$ sum = 1;
感谢所有的社区
是这个价格0,9 ?? –
0.9 ...是的，这是价格领域！非常感谢 – user2704611
你在哪里计算代码？显示完整的视图代码 –