如何用angular和php计算？

debugcn 发表于 Dev

坦雅

我正在用angular和php构建一个项目。我的数据库中有一个“库存”表，可以检索表中的所有数据。我想计算总计“数量”列并显示总计，但是我不知道该怎么办。谁能帮忙吗？

的PHP：

<?php
  header('Content-Type: text/html; charset=utf-8');
  $connection = mysqli_connect('localhost','root','','hamatkin');

  mysqli_query($connection,"SET character_set_client = utf8");
  mysqli_query($connection,"SET character_set_connection = utf8");
  mysqli_query($connection,"SET character_set_results = utf8");

  if(!$connection){
    die("couldnt connect".mysqli_error);
  }

  $query="SELECT `stock_id`,`product_name`,`description`,`quantity` FROM `stock`";
  $queryResult = $connection->query($query);
  $queryResult2 = array();
  if( $queryResult->num_rows>0){
    while($row = $queryResult->fetch_assoc()){
      $queryResult2[] = $row;
    }
  }
  $queryResult3 = json_encode($queryResult2);
   echo json_encode($queryResult3);
?>

HTML：

    </div>

  <div class="table-responsive">
    <table  class="customer-list table table-striped">
      <thead>
        <tr>
          <!-- <th>#</th> -->
          <th class="Column-Header">קוד מוצר</th>
          <th class="Column-Header">שם מוצר</th>
          <th class="Column-Header">תיאור מוצר</th>
          <!-- <th class="Column-Header">כמות במלאי</th>
          <th class="Column-Header">סה"כ</th> -->


        </tr>
      </thead>
      <tbody>
        <tr ng-repeat="item in stockReport" ng-init="setTotals(item)">
              <td>{{item.ProductName}}</td>
              <td>{{item.quantity}}</td>
          </tr>

      <tfoot>
          <tr class="bg-warning">
              <td>Totals</td>
              <td>{{invoiceCount}}</td>
              <td></td>
          </tr>

        </tfoot>


      </tbody>
    </table>

  </div>

控制器：

"use strict";
angular.module('dataSystem').controller('reportsCtrl', function ($scope, $route, $location, $http) {
  $http({method:'GET', url:'api/reports-tab/stock-report.php/'})
      .then(function(response) {
        var arr = JSON.parse(JSON.parse(response.data));
        $scope.v = arr;


      })

      // This will log you the error code and trace, if there is an error.

      .catch(function(err) {
        console.log('err', err)
      });


      $scope.setTotals = function(item){
          if (item){
              item.total = item.quantity * item.unitCost;
              $scope.invoiceCount += item.quantity;

          }
      }



});

萨耶塔兰（Sajeetharan）

您可以在JS中使用以下功能，

JS：

$scope.setTotals = function(item){
        if (item){
            item.total = item.quantity * item.unitCost;
            $scope.invoiceCount += item.quantity;

        }
    }

看法

  <tr ng-repeat="item in items" ng-init="setTotals(item)">
            <td>{{item.ProductName}}</td>
            <td>{{item.quantity}}</td>                 
        </tr>
    </tbody>
    <tfoot>
        <tr class="bg-warning">
            <td>Totals</td>
            <td>{{invoiceCount}}</td>
            <td></td>                   
        </tr>

Working App

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。