如何在php中对所有变量数据求和 - how to sum all variables data in php

how to sum all variables data in php

本文关键字：变量数据求和 php | 更新日期: 2023-09-27

我需要帮助求和总成本并将其显示在报告中。我设法将数量和成本相乘，但现在我如何总结显示相乘的列？以下是代码。

function inventory_summary($export_excel=0)
{
    $this->load->model('reports/Inventory_summary');
    $model = $this->Inventory_summary;
    $tabular_data = array();
    $report_data = $model->getData(array());
    foreach($report_data as $row)
    {
        $tabular_data[] = array($row['name'], $row['item_number'], $row['cost_price'], $row['quantity'], $Total_total=$row['quantity']*$row['cost_price']);
    }

    $data = array(
        "title" => $this->lang->line('reports_inventory_summary_report'),
        "subtitle" => '',
        "headers" => $model->getDataColumns(),
        "data" => $tabular_data,
        "summary_data" => $model->getSummaryData(array()),
        "export_excel" => $export_excel
    );
    $this->load->view("reports/tabular",$data); 
}

$Total_Total这个变量是从mysql数据库中提取并相乘的数据，因此不保存在数据库中。

添加：我想汇总的列的屏幕截图链接：https://i.stack.imgur.com/WHaAm.png

除此之外，如何用小数点显示合计列？我在谷歌上搜索了一下，但找不到任何关于在sql结果上添加小数的教程。

感谢任何帮助我完成报告的人。谢谢

开始

function inventory_summary($export_excel=0)
{
    $this->load->model('reports/Inventory_summary');
    $model = $this->Inventory_summary;
    $tabular_data = array();
    $report_data = $model->getData(array());
     $Totalprice=0;
        foreach($report_data as $row)
        {
        $Total_total=$row['quantity']*$row['cost_price'];
        $Total_total= number_format((float)$Total_total, 2, '.', '');
        $tabular_data[] = array($row['name'], $row['item_number'], $row['cost_price'], $row['quantity'],$Total_total );
        $Totalprice += $Total_total;
     }
    $tabular_data['Totalprice']=number_format((float)$Totalprice, 2, '.', '');

    $data = array(
        "title" => $this->lang->line('reports_inventory_summary_report'),
        "subtitle" => '',
        "headers" => $model->getDataColumns(),
        "data" => $tabular_data,
        "summary_data" => $model->getSummaryData(array()),
        "export_excel" => $export_excel
    );
    $this->load->view("reports/tabular",$data); 
}

你应该像array一样create，

function inventory_summary($export_excel=0)
{
    $this->load->model('reports/Inventory_summary');
    $model = $this->Inventory_summary;
    $tabular_data = array();
    $report_data = $model->getData(array());
    foreach($report_data as $row)
    {
       //create associative array here
       $tabular_data[]=array('name'=>$row['name'],'item_number'=>$row['item_number'],
                  'cost_price'=> $row['cost_price'],'quantity'=> $row['quantity']);
    }
    $data = array(
        "title" => $this->lang->line('reports_inventory_summary_report'),
        "subtitle" => '',
        "headers" => $model->getDataColumns(),
        "data" => $tabular_data,
        "summary_data" => $model->getSummaryData(array()),
        "export_excel" => $export_excel
    );
    $this->load->view("reports/tabular",$data); 
}

在显示data时，您可以通过其associative name 访问每个array variable