主页 / user-314403

Denis640Kb's questions

Martin Hope
Denis640Kb
Asked: 2020-12-19 15:38:20 +0000 UTC
  • 2

大家好。sql不强，但是需要删除所有的记录副本，除了第一个，Name是一样的。

我正在尝试通过以下方式做到这一点：

DELETE FROM Login
WHERE Name NOT IN (SELECT max(Name) FROM Login GROUP BY Name HAVING 
count(Name)>1)

但我收到一个错误
You can't specify target table 'Login' for update in FROM clause

我试图通过类比如何使用带有子查询的查询删除 SQL 记录？

但是什么也没发生。

大概是这样的：

DELETE FROM Login
WHERE Name NOT IN (
  (SELECT tempT.Login
   FROM (SELECT Name WHERE Name NOT IN (SELECT max(Name) FROM Login GROUP BY Name HAVING count(Name) > 1))
          AS tempT)
)

我在这里尝试了很多选择。请帮忙。

mysql
Martin Hope
Denis640Kb
Asked: 2020-12-09 06:00:44 +0000 UTC
  • 1

您需要浏览每一页上的枚举并按下按钮。并等待按钮被按下。但是每个总是只取第一个值 489

   var arr = [
        '489',
        '1132',
        '490'
        ];
    $.each(arr, function (index, value) {
        location.href = 'https://тут адрес' + value + '/actors?deleteTill=2019-12-08T22%3A11%3A30';
      bz = $('input#confirm_deletion').prop('checked', true);
      bz1 = $('input.ignore_in_selects').val('true');
      $(".ui.button.orange").click();
      $('.ui.button.orange').submit();
    });
jquery
Martin Hope
Denis640Kb
Asked: 2020-10-10 17:33:07 +0000 UTC
  • 1

有html之类的

<div data-formbuilder-field-type="string" data-formbuilder-field-name="tenderNoticeNo" class="field static"><label for="tenderNoticeNo">Ставка сборов по клиенту</label><div style="display: none"><input name="tenderNoticeNo" type="text" value="13" id="tenderNoticeNo"></div><div class="static-input">13</div><div class="engymod">chain: []; tenderNoticeNo</div><div class="engymod">[]</div></div>

可能有几个这样的块，但每个 ata-formbuilder-field-name 是不同的。如何在这个数组中准确找到

 <div class="static-input">13</div>

并在那里输入数据，而不是 13。

javascript
Martin Hope
Denis640Kb
Asked: 2020-05-19 00:02:36 +0000 UTC
  • 0

求助各位，我需要帮助。有数据

{"stat":"Сообщение успешно обработано","status":"OK","messageId":"123","messageResult":"Запрос обработан","messageDate":1558037969,"lastName":"Мяяя","firstName":"Vzzz","middleName":"Kkk","iin":"111222333444","birthdate":"16.11.1993","period":"6","table":[{"DATE_OPR":"2011-12-11T00:00:00+06:00","SUMM_DB":"172755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"123","F50_GUARANTOR_RNN":"123123213","nameRu":""},{"DATE_OPR":"2011-01-11T00:00:00+06:00","SUMM_DB":"116755.1","SUMM_DB_NETTO":"117000.03099999996","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-02-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-03-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB","F50_GUARANTOR_RNN":"1231231232","nameRu":""},{"DATE_OPR":"2011-04-01T00:00:00+06:00","SUMM_DB":"117219.59999999998","SUMM_DB_NETTO":"111176.27599999998","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""},{"DATE_OPR":"2011-05-11T00:00:00+06:00","SUMM_DB":"115000.0","SUMM_DB_NETTO":"115578.4","PAY_ASSIGN":"","F52B_GUARANTOR_BANK_NAME":"АО "Verzi Bank" Обязат.пенсион.взносы GB (ГБ)","F50_GUARANTOR_RNN":"123123123","nameRu":""}]}

可以有不同数量的表值。我正在尝试通过 json_decode 转换为 json 数组，但它总是返回空。告诉我，我怎样才能将这些数据转换成一个多维数组，其中有几个表？谢谢

php
Martin Hope
Denis640Kb
Asked: 2020-01-29 16:08:29 +0000 UTC
  • 2

大家好。有表功能

function addField (argument) {
            var myTable = document.getElementById("mineTable");
            var currentIndex = myTable.rows.length;
            var currentRow = myTable.insertRow(-1);

            var valinRuss = document.createElement("textarea");
            valinRuss.setAttribute("name", "valinRuss" + currentIndex);

            var valinEng = document.createElement("textarea");
            valinEng.setAttribute("name", "valinEng" + currentIndex);

            var valinKaz = document.createElement("textarea");
            valinKaz.setAttribute("name", "valinKaz" + currentIndex);

            var td1 = document.createElement("td1");
            td1.setAttribute("name", "td1" + currentIndex);

            var currentCell = currentRow.insertCell(-1);
            currentCell.appendChild(td1);

            currentCell = currentRow.insertCell(-1);
            currentCell.appendChild(valinRuss);

            currentCell = currentRow.insertCell(-1);
            currentCell.appendChild(valinEng);

            currentCell = currentRow.insertCell(-1);
            currentCell.appendChild(valinKaz);

        }

html中的表格如下：

<table id="mineTable">
    <tr>
        <th>Заголовок1</th>
    </tr>
    <tr>
    <input type="button" class="button" value="+" onclick="addField();">
    </tr>
    <tr>
        <td></td>
        <td>Знач 1</td>
        <td>Знач 2</td>
        <td>Знач 3</td>
    </tr>
        <tr>
            <td name="td1">1</td>
            <td><textarea name="valinRuss">123</textarea></td>
            <td><textarea name="valinEng"></textarea></td>
            <td><textarea name="valinKaz"></textarea></td>
        </tr>
    </table>
</table>

你能告诉我如何使第一个字段的名称编号吗？例如：1（接下来的 3 个输入字段）2（接下来的 3 个输入字段）3（接下来的 3 个输入字段）4 ...

javascript
Martin Hope
Denis640Kb
Asked: 2020-01-27 07:39:46 +0000 UTC
  • 0

晚安。有一个数组：

Array(
[0] => Ауди|А8|300лс
[1] => БМВ|X6|350лс
[2] => Мерседес|S6|370лс
)

如何将此数组转换为显示：

Array (
 [0]=>Array(
 CarMark => Ауди
 CarType => A8
 CarPower => 300лс
 )
 [1]=>Array(
 CarMark => БМВ
 CarType => X6
 CarPower => 350лс
 )

Ну и так далее в периоде(Неизвестно сколько может быть данных в 1 массиве)
php
Martin Hope
Denis640Kb
Asked: 2020-12-02 22:43:03 +0000 UTC
  • 0


有一个像这样的数组

{
        "id": 2,
        "firstName": "Тест",
        "lastName": "Тест",
        "patronymic": "Тест",
        "sexId": 101252,
        "mobilePhone": "71111111111",
        "registrationNumber": {
            "id": 6,
            "seria": "",
            "no": "",
            "extraNumber": "",
            "issueDate": null,
            "closeDate": null,
            "manager": "",
            "subdivisionCode": "",
            "complementaryDocTypeId": null
        },
        "personRelatives": [
            {
                "id": 4,
                "lastName": "dsv",
                "firstName": "sd",
                "patronymic": "",
                "resident": false,
                "passport": {
                    "id": 43,
                    "seria": "",
                    "no": "",
                    "extraNumber": null,
                    "issueDate": null,
                    "closeDate": null,
                    "manager": "",
                    "subdivisionCode": "",
                    "complementaryDocTypeId": null
                },
                "rnn": "",
                "telephone": "",
                "email": "",
                "workPlace": "",
                "address": "",
                "birthDate": null,
                "collateralRelId": 102147,
                "verified": null,
                "comments": ""
            }
        ],
        "clientRiskStatus": [
            {
                "id": 5,
                "insertDate": 1539244552517,
                "userId": 1027,
                "comments": "3211",
                "valueId": 102184
            },
            {
                "id": 8,
                "insertDate": 1540396776913,
                "userId": 1027,
                "comments": "321",
                "valueId": 102184
            },
            {
                "id": 9,
                "insertDate": 1540397890848,
                "userId": 1027,
                "comments": "123",
                "valueId": 102184
            },
            {
                "id": 10,
                "insertDate": 1540398177463,
                "userId": 1027,
                "comments": "вшозавц",
                "valueId": 102184
            },
            {
                "id": 11,
                "insertDate": 1540398590878,
                "userId": 1027,
                "comments": "авлоавыолз",
                "valueId": 102184
            },
            {
                "id": 2,
                "insertDate": 1539067291379,
                "userId": 1027,
                "comments": "Новый клиент",
                "valueId": 102185
            }
        ],
        "extraFields": [
            {
                "id": 178,
                "key": "placeOfEducation",
                "value": "kzt1"
            },
            {
                "id": 179,
                "key": "work1",
                "value": "workk1"
            },
            {
                "id": 180,
                "key": "work2",
                "value": null
            },
            {
                "id": 181,
                "key": "work3",
                "value": null
            },
            {
                "id": 182,
                "key": "placeOfEducation1",
                "value": "kzt1"
            },
            {
                "id": 183,
                "key": "work6",
                "value": ""
            }]}

extraFields 的数量可以是任何值。如何通过key找到价值并改变它？

试过了

$NEW = null;
$needle1 = "NEW";
foreach($response1['data']['extraFields'] as $t){
    if($t['key'] === $needle1){
       $t['value'] = "333";
        $NEW = $t['value'];
        break;
    }
}

或者

foreach($response1['data']['extraFields'] as $key => $val){
    $response1[$key]['work1'] = "010101";
}

但它仍然没有改变价值。告诉我我做错了什么？

php
Martin Hope
Denis640Kb
Asked: 2020-11-26 01:15:03 +0000 UTC
  • 1

大家好。伙计们，请帮忙。在 PHPStorm 中一切正常，但是当我将它传输到服务器时，出现了一个错误 -

Fatal error: Uncaught PHPExcel_Writer_Exception: Could not close zip file simple.xlsx. 
in /var/www/lilya/main/Classes/PHPExcel/Writer/Excel2007.php:389 Stack trace: #0 
/var/www/lilya/main/report.php(247): PHPExcel_Writer_Excel2007->save('simple.xlsx') 
#1 /var/www/lilya/main/Underwriting.php(2): include('/var/www/lilya/...') 
#2 /var/www/lilya/main/index.php(2): include('/var/www/lilya/...') 
#3 {main} thrown in 
/var/www/lilya/main/Classes/PHPExcel/Writer/Excel2007.php on line 389

我已经查看了整个互联网，但我自己无法找到解决方案。试图赋予文件夹权限，一切似乎都是值得的。请帮帮我。如果需要更多信息，我准备立即将其丢弃。

php
Martin Hope
Denis640Kb
Asked: 2020-11-24 19:44:46 +0000 UTC
  • 0

伙计们，请帮忙。我有一个带有表格的 html

<table class="secondtable">
    <tr>
        <th></th>
        <th>Customer</th>
        <th>input</th>
    </tr>
    <tr>
        <td class="secondtabletd">Number of FCB request in last 30 
days</td>
        <td class="secondtabletd"></td>
        <td class="secondtabletd"><input></td>
    </tr>
</table>

通过单击按钮，输入的数据将保存到 php，后者通过 Excel 对其进行处理。从 Excel (PHPExcel) 获取数据我现在如何将这些数据从 php 添加到 

  <td class="secondtabletd"></td>

如果我通过 required_once 连接，则会显示一个错误，即数据未填写在输入中。是的，Excel 文件没有时间处理 - 因此，它显示错误的数据。

javascript
Martin Hope
Denis640Kb
Asked: 2020-11-22 15:34:53 +0000 UTC
  • 0

大家好。伙计们，请告诉我。格式中有一个数组

{
"status": "ok",
"timestamp": 1542871773703,
"data": {
    "id": 7,
    "name": "7",
    "creationDate": 1539265369000,
}}

要通过 API 通过 POST 发送数据，您需要删除

    {
"status": "ok",
"timestamp": 1542871773703,
"data":

状态和时间戳没有问题 -

unset($response1['status']);
unset($response1['timestamp']);

但是如何删除“数据”：？这样数组本身就保留了。这样您就可以通过 Post 发送。简单地说，API POST 应该是这样的：

{
        "id": 7,
        "name": "7",
        "creationDate": 1539265369000,
    }
php
Martin Hope
Denis640Kb
Asked: 2020-11-21 07:18:27 +0000 UTC
  • 2

大家好。伙计们，请告诉我。有这样的代码：

<script type="text/javascript">
function ChangeSum(){
    var sum = $('#33301').val();
    $('#sum').val(sum);
}
</script>
<table>
<tr>
    <td><input type=text name="sum" size="64" id="sum"></td>
    <td id="dd301"><select id="33301" onchange="ChangeSum()" required 
size = “1”>
            <option value="1">Credit History</option>
            <option value="2">DSR</option>
            <option value="3">Income</option>
            <option value="4">Collateral</option>
            <option value="5">FTV</option>
            <option value="6">Geography</option>
            <option value="7">Age</option>
            <option value="8">LOB/LOS</option>
            <option value="9">Other</option>
            <option value="0">No</option>
        </select></td>
    <td id="f31"><input></td>
</tr>
</table>

在输入中不显示值。但是如果我不插入表格，而只是插入一个字段

<input type=text name="sum" size="64" id="sum">

，那么就没有问题了。

如何将数据插入表中？

javascript
Martin Hope
Denis640Kb
Asked: 2020-11-03 23:41:48 +0000 UTC
  • 0

伙计们，翻遍了一切。放弃神经。请告诉我。

有一个像这样的数组

{
    "0": {
        "id": 666
    },
    "status": "ok",
    "timestamp": 1541259393211,
    "data": [{
        "issueDate": "2018-08-22",
        "repaymentDate": "2018-09-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 300,
        "rest": 3000000
    }, {
        "issueDate": "2018-09-24",
        "repaymentDate": "2018-10-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2018-10-24",
        "repaymentDate": "2018-11-26",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2018-11-26",
        "repaymentDate": "2018-12-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2018-12-24",
        "repaymentDate": "2019-01-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-01-24",
        "repaymentDate": "2019-02-25",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-02-25",
        "repaymentDate": "2019-03-25",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-03-25",
        "repaymentDate": "2019-04-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-04-24",
        "repaymentDate": "2019-05-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-05-24",
        "repaymentDate": "2019-06-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-06-24",
        "repaymentDate": "2019-07-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-07-24",
        "repaymentDate": "2019-08-26",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-08-26",
        "repaymentDate": "2019-09-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-09-24",
        "repaymentDate": "2019-10-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-10-24",
        "repaymentDate": "2019-11-25",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-11-25",
        "repaymentDate": "2019-12-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2019-12-24",
        "repaymentDate": "2020-01-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-01-24",
        "repaymentDate": "2020-02-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-02-24",
        "repaymentDate": "2020-03-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-03-24",
        "repaymentDate": "2020-04-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-04-24",
        "repaymentDate": "2020-05-25",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-05-25",
        "repaymentDate": "2020-06-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-06-24",
        "repaymentDate": "2020-07-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-07-24",
        "repaymentDate": "2020-08-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-08-24",
        "repaymentDate": "2020-09-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-09-24",
        "repaymentDate": "2020-10-26",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-10-26",
        "repaymentDate": "2020-11-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }, {
        "issueDate": "2020-11-24",
        "repaymentDate": "2020-12-24",
        "principal": 0,
        "interest": 415500,
        "fee": 0,
        "penalty": 0,
        "rest": 3000000
    }]
}

我需要向所有子数组添加一个值为 0 的新键。

我知道这并不难，但我已经尝试了一切。还有 unshift 和 slice 以及一些已经很愚蠢的选项，但仍然没有任何结果。请帮帮我。

php
Martin Hope
Denis640Kb
Asked: 2020-11-01 21:40:07 +0000 UTC
  • 0

大家好。伙计们，不要马上发誓。需要帮忙。有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