主页 / 问题 / 900922
Accepted
Denis640Kb
Asked:2020-11-01 21:40:07 +0000 UTC2020-11-01 21:40:07 +0000 UTC

按值查找php中的所有数组并输出找到的数组

  • 772

大家好。伙计们，不要马上发誓。需要帮忙。有json类型

{
    "status": "ok",
   "timestamp": 1541078845094,
    "data": [
        {
            "id": 61,
            "fields": {
                "contract.id": 7,
                "date": 1534941334000,
                "amountType.id": 101291,
                "amountType.name": "Основная",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101172,
                "totalAmount.local": 3000000,
                "document.id": 28,
                "realDate": 1540557344563
            }
        },
        {
            "id": 65,
            "fields": {
                "contract.id": 7,
                "date": 1536842172808,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 277000,
                "document.id": 30,
                "realDate": 1540557372857
            }
        },
        {
            "id": 66,
            "fields": {
                "contract.id": 7,
                "date": 1537792593094,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 138500,
                "document.id": 31,
                "realDate": 1540557393120
            }
        },
        {
            "id": 67,
            "fields": {
                "contract.id": 7,
                "date": 1537879002218,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 13850,
                "document.id": 32,
                "realDate": 1540557402255
            }
        },
        {
            "id": 68,
            "fields": {
                "contract.id": 7,
                "date": 1537879002218,
                "amountType.id": 101298,
                "amountType.name": "Штраф за опоздание",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 300,
                "document.id": 33,
                "realDate": 1540557402287
            }
        },
        {
            "id": 69,
            "fields": {
                "contract.id": 7,
                "date": 1540384612793,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 401650,
                "document.id": 34,
                "realDate": 1540557412889
            }
        },
        {
            "id": 71,
            "fields": {
                "contract.id": 7,
                "date": 1540471012793,
                "amountType.id": 101298,
                "amountType.name": "Штраф за опоздание",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 300,
                "document.id": 35,
                "realDate": 1540557412933
            }
        },
        {
            "id": 70,
            "fields": {
                "contract.id": 7,
                "date": 1540471012793,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 12590.91,
                "document.id": 34,
                "realDate": 1540557412901
            }
        },
        {
            "id": 77,
            "fields": {
                "contract.id": 7,
                "date": 1540557470000,
                "amountType.id": 1012915,
                "amountType.name": "Предоплата по процентам",
                "actionType.id": 1010211,
                "actionType.name": "Предоплата",
                "paymentType.id": 101172,
                "totalAmount.local": 12900,
                "document.id": 38,
                "realDate": 1540557500140
            }
        },
        {
            "id": 75,
            "fields": {
                "contract.id": 7,
                "date": 1540557470000,
                "amountType.id": 101298,
                "amountType.name": "Штраф за опоздание",
                "actionType.id": 101022,
                "actionType.name": "Погашение",
                "paymentType.id": 101172,
                "totalAmount.local": 300,
                "document.id": 37,
                "realDate": 1540557500005
            }
        },
        {
            "id": 73,
            "fields": {
                "contract.id": 7,
                "date": 1540557470000,
                "amountType.id": 101298,
                "amountType.name": "Штраф за опоздание",
                "actionType.id": 101022,
                "actionType.name": "Погашение",
                "paymentType.id": 101172,
                "totalAmount.local": 300,
                "document.id": 37,
                "realDate": 1540557499939
            }
        },
        {
            "id": 76,
            "fields": {
                "contract.id": 7,
                "date": 1540557470000,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101022,
                "actionType.name": "Погашение",
                "paymentType.id": 101172,
                "totalAmount.local": 415500,
                "document.id": 37,
                "realDate": 1540557500028
            }
        },
        {
            "id": 74,
            "fields": {
                "contract.id": 7,
                "date": 1540557470000,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101022,
                "actionType.name": "Погашение",
                "paymentType.id": 101172,
                "totalAmount.local": 415500,
                "document.id": 37,
                "realDate": 1540557499968
            }
        },
        {
            "id": 72,
            "fields": {
                "contract.id": 7,
                "date": 1540557470000,
                "amountType.id": 101292,
                "amountType.name": "Процент",
                "actionType.id": 101021,
                "actionType.name": "Начисление",
                "paymentType.id": 101173,
                "totalAmount.local": 12590.91,
                "document.id": 36,
                "realDate": 1540557493266
            }
        }
    ]
}

如何找到其中的所有数组"amountType.id" = 101292，以便以后通过 PHPExcel 将它们添加到 excel 中？

我试图通过

$responseJson = "$response"; 
$response3 = json_decode($responseJson, true);
$response4 = $response3['data'];

$needle = 101022;

foreach($response4 as $t){
    if($t['fields']['actionType.id'] == $needle){
        $result = $t;
        if (strpos($t['fields']['actionType.id'], '101022') !== true) // именно через жесткое сравнение
        {
            echo "<pre>";
            print_r($result);
            echo "</pre>";
        }
        break;
    }
print_r($result);

}

是的，我知道添加了 2 种方法，但我已经在尝试不同的方法。在这件事上浪费了很多时间。愚蠢的谷歌没有给出想要的答案，它已经到了第 100 页。帮助兄弟。

php

1 个回答

  1. Best Answer

    利用array_filter()

    $needle = 101292;
$result = array_filter($arr['data'], function($v) use ($needle){
                 return $v['fields']['amountType.id'] == $needle;
             });
    • 1

相关问题