PHP商品价格区间统计

最新推荐文章于 2021-12-27 08:55:59 发布

u010253004

最新推荐文章于 2021-12-27 08:55:59 发布

阅读量1.5k

点赞数

分类专栏： Mysql专栏 PHP专栏

本文链接：https://blog.youkuaiyun.com/rockyzhuo2014/article/details/100135001

版权

PHP专栏同时被 2 个专栏收录

8 篇文章

订阅专栏

Mysql专栏

3 篇文章

订阅专栏

根据查询语句查出价格统计

SELECT uid,SUM(pay_amount) AS pay_amounts  FROM bs_order GROUP BY uid ORDER BY pay_amounts;

查询结果

Array(    [0] => Array        (            [uid] => 14            [pay_amounts] => 5600.00        )    [1] => Array        (            [uid] => 5            [pay_amounts] => 5519.00        )    [2] => Array        (            [uid] => 9            [pay_amounts] => 1126.00        )    [3] => Array        (            [uid] => 3            [pay_amounts] => 500.00        )    [4] => Array        (            [uid] => 1            [pay_amounts] => 95.00        )    [5] => Array        (            [uid] => 0            [pay_amounts] => 10.00        ))

处理价格区间

$list = array_column($list,'pay_amounts');
$max_price= reset($list);
$min_price = reset($list);


$price_grade = 1;


for ($i = 1; $i <= log10($max_price); $i ++) {
    $price_grade *= 10;
}
// 跨度
$dx = (ceil(log10(($max_price - $min_price) / 3)) - 1) * $price_grade;
if ($dx <= 0) {
    $dx = $price_grade;
}
$array = array();
$j = 0;
while ($j <= $max_price) {
    $array[] = array(
        $j,
        $j + $dx - 1
    );
    $j = $j + $dx;
}
return $array;

返回处理结果：

Array
(
    [0] => Array
        (
            [0] => 0
            [1] => 999
        )

    [1] => Array
        (
            [0] => 1000
            [1] => 1999
        )

    [2] => Array
        (
            [0] => 2000
            [1] => 2999
        )

    [3] => Array
        (
            [0] => 3000
            [1] => 3999
        )

    [4] => Array
        (
            [0] => 4000
            [1] => 4999
        )

    [5] => Array
        (
            [0] => 5000
            [1] => 5999
        )

)