首頁猿問 php怎么將序列化數(shù)組內(nèi)的日期...

php怎么將序列化數(shù)組內(nèi)的日期填補(bǔ)不存在的日期

PHP

拉風(fēng)的咖菲貓 2019-03-17 02:23:25

從數(shù)據(jù)庫查詢的時(shí)間是不連續(xù)的如前端的圖表需要連續(xù)的日期但是數(shù)據(jù)庫中不存在不存在連續(xù)的時(shí)間 php需要處理為一個(gè)月內(nèi)連續(xù)的時(shí)間如：[2017.08.25,2017.08.26,2017.08.27,2017.08.28] [4,-,5,6,7,8]將data替換為-即可不知道怎么處理求各位大神支招

查看完整描述

2 回答

鳳凰求蠱

TA貢獻(xiàn)1825條經(jīng)驗(yàn) 獲得超4個(gè)贊

<?php

$data = array(
    'date' => array(
        '2017.08.24',
        '2017.08.26',
        '2017.08.28',
        '2017.08.30',
        '2017.08.31'
    ),
    'data' => array(
        1,
        2,
        3,
        4,
        5
    )
);

$len = count($data['date']);

$oneDaySecond = 86400;

$newData = array();

for ($i = 1; $i < $len; $i++) {
    $previous = strtotime(str_replace('.', '-', $data['date'][($i - 1)]));
    $current = strtotime(str_replace('.', '-', $data['date'][($i)]));

    $diff = $current - $previous;

    if (!in_array($data['date'][($i - 1)], $newData['date'], true)) {
        $newData['date'][] = $data['date'][($i - 1)];
        $newData['data'][] = $data['data'][($i - 1)];
    }

    if ($diff > $oneDaySecond) {
        for ($m = $previous + $oneDaySecond; $m < $current; $m += $oneDaySecond) {
            $newData['date'][] = date('Y.m.d', $m);
            $newData['data'][] = 0;
        }
    }

    $newData['date'][] = $data['date'][$i];
    $newData['data'][] = $data['data'][$i];
}

print_r($newData);

result

Array
(
    [date] => Array
        (
            [0] => 2017.08.24
            [1] => 2017.08.25
            [2] => 2017.08.26
            [3] => 2017.08.27
            [4] => 2017.08.28
            [5] => 2017.08.29
            [6] => 2017.08.30
            [7] => 2017.08.31
        )

    [data] => Array
        (
            [0] => 1
            [1] => 0
            [2] => 2
            [3] => 0
            [4] => 3
            [5] => 0
            [6] => 4
            [7] => 5
        )

)

反對回復(fù) 2019-03-18

SMILET

TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超4個(gè)贊

假如你獲得到的數(shù)據(jù)為：
data = {"8.11":100, "8.15":100, "8.20":100 }
你新建一個(gè)從初始日期到結(jié)束日期的對象：
newData = {"8.11":0, "8.12":0, "8.13":0, ···, "8.20":0}
然后遍歷data，將data里面的數(shù)據(jù)按照放進(jìn)newData對應(yīng)的位置，這樣就得到一個(gè)連續(xù)的、數(shù)據(jù)庫沒有的日期數(shù)據(jù)為0的新對象，然后把這個(gè)新數(shù)據(jù)返回出去。
這一步前端和后端做都可以，反正就是沒有的你就給補(bǔ)上0

反對回復(fù) 2019-03-18