0

how to calculate total amount of project_invoices (all row)

Json response

[
    "status": true,
    "message": null,
    "data": {
        "project_id": 1,
        "project_type": "project",
        "project_importid": null,
        "project_created": "2022-09-17T10:03:10.000000Z",
        "project_updated": "2022-10-09T13:36:29.000000Z",
        "project_client": "adsamy",
        "project_creator_first_name": "Abdo",
        "project_creator_last_name": "Mohamed",
        "project_category": "data",
        "project_title": "ui/ux",
        "project_date_start": "2022-09-17",
        "project_date_due": "2022-10-12",
        "project_description": null,
        "project_status": "not_started",
        "project_active_state": "active",
        "project_progress": 0,
        "project_billing_rate": "10.00",
        "project_billing_type": "hourly",
        "project_billing_estimated_hours": 120,
        "project_billing_costs_estimate": "30000.00",
        "project_progress_manually": "no",
        "clientperm_tasks_view": "yes",
        "clientperm_tasks_collaborate": "yes",
        "clientperm_tasks_create": "yes",
        "clientperm_timesheets_view": null,
        "clientperm_expenses_view": "no",
        "assignedperm_milestone_manage": "yes",
        "assignedperm_tasks_collaborate": "yes",
        "project_visibility": "visible",
        "project_invoices": [
            {
                "bill_final_amount": "5000.00"
            },
            {
                "bill_final_amount": "4000.00"
            }
        ] // content all row of amount
]

Expected Output

[
      "project_id": 1,
      ...,
      "project_invoices_amount": 238484
]
Uttam Nath
  • 644
  • 4
  • 16
Abdo Mohamed
  • 11
  • 1
    Welcome, to improve your experience on SO please [take the tour](http://stackoverflow.com/tour) and read [how to ask](https://stackoverflow.com/help/how-to-ask), an [On Topic question](https://stackoverflow.com/help/on-topic), then look at the [Question Check list](https://meta.stackoverflow.com/questions/260648/stack-overflow-question-checklist), the [perfect question](http://codeblog.jonskeet.uk/2010/08/29/writing-the-perfect-question/) and how to create a [Minimal, Complete and Verifiable Example](http://stackoverflow.com/help/mcve) – RiggsFolly Oct 09 '22 at 14:16

0 Answers0