laravel sum different conditions

Laravel is a popular PHP development framework that provides many convenient functions and syntax to improve development efficiency. Among them, the sum function is a very commonly used function in Laravel, which can sum the values ​​in a set. But in actual development, we sometimes need to perform summation under different conditions. How should we deal with this? This article will introduce how Laravel performs sum operations under different conditions.

1. Sum operation in simple cases

In Laravel, we can easily perform sum operation on a collection, just call the sum function. For example, sum an array:

$sum = collect([1, 2, 3, 4, 5])->sum();

In this example, the value of $sum is 15, which is the sum of 1 2 3 4 5.

Similarly, if we have an array of objects and want to sum a certain attribute in it, we can do this:

$sum = collect([
    ['name' => 'Alice', 'score' => 80],
    ['name' => 'Bob', 'score' => 90],
    ['name' => 'Charlie', 'score' => 70]
])->sum('score');

In this example, the value of $sum is 240, That is the sum of 80 90 70.

2. Conditional sum operation

In actual development, we often need to perform sum operations under different conditions. In this case, we need to use the where function in Laravel. The where function can filter the values ​​in the collection based on specified conditions. For example, we have an array of users. Each user has two attributes: name and age. If we want to calculate the sum of the ages of all users older than 18 years old, we can do this:

$users = collect([
    ['name' => 'Alice', 'age' => 20],
    ['name' => 'Bob', 'age' => 16],
    ['name' => 'Charlie', 'age' => 25]
]);

$sum = $user->where('age', '>', 18)->sum('age');

In this example, $ The value of sum is 45, which is the sum of 20 25.

Similarly, if we have an array of orders, each order has a status attribute, and we want to calculate the sum of the amounts of all completed orders, we can do this:

$orders = collect([
    ['id' => 1, 'status' => 'created', 'amount' => 10],
    ['id' => 2, 'status' => 'completed', 'amount' => 20],
    ['id' => 3, 'status' => 'cancelled', 'amount' => 30],
    ['id' => 4, 'status' => 'completed', 'amount' => 40]
]);

$sum = $orders->where('status', 'completed')->sum('amount');

This example , the value of $sum is 60, which is the sum of 20 40.

3. Sum based on multiple conditions

Sometimes, we need to perform sum operation based on multiple conditions. This can be achieved by using the chain call of the where function in Laravel. For example, we have an array of users. Each user has three attributes: name, age, and region. If we want to calculate the sum of the ages of all users who are in Beijing and are older than 18 years old, we can do this:

$users = collect([
    ['name' => 'Alice', 'age' => 20, 'area' => 'Beijing'],
    ['name' => 'Bob', 'age' => 16, 'area' => 'Shanghai'],
    ['name' => 'Charlie', 'age' => 25, 'area' => 'Beijing']
]);

$sum = $user->where('age', '>', 18)->where('area', 'Beijing')->sum('age');

In this example, the value of $sum is 20, which is Alice’s age.

Similarly, if we have an array of orders, each order has a status attribute and a date attribute, and want to calculate the sum of the order amounts after January 1, 2019 in all completed orders, You can do it like this:

$orders = collect([
    ['id' => 1, 'status' => 'created', 'amount' => 10, 'date' => '2019-01-01'],
    ['id' => 2, 'status' => 'completed', 'amount' => 20, 'date' => '2019-01-05'],
    ['id' => 3, 'status' => 'cancelled', 'amount' => 30, 'date' => '2018-12-31'],
    ['id' => 4, 'status' => 'completed', 'amount' => 40, 'date' => '2019-02-01']
]);

$sum = $orders->where('status', 'completed')->where('date', '>', '2019-01-01')->sum('amount');

In this example, the value of $sum is 20, which is the amount of the second order.

To sum up, Laravel's sum function and where function are very convenient and practical, and can help us quickly complete the conditional sum operation. In actual development, we can flexibly use these functions according to different needs to improve development efficiency.

The above is the detailed content of laravel sum different conditions. For more information, please follow other related articles on the PHP Chinese website!