普通网友 2019-04-29 18:22
浏览 56
已采纳

如何在复杂的数组中使用cakephp集合函数,它只适用于简单的数组

I transformed an XML to JSON, this is the link: https://api.myjson.com/bins/us5f4

I used a lot of CakePHP 3.30 and below Collection's functions. What I need to do is to only extract some data, for example the tag @INDICATOR and @TIME_PERIOD.

I already tried using nest, filter, append, map in collections and none of them work for some reason.

This is my controller:

<?php
namespace App\Controller;

use App\Controller\AppController;
use Cake\Collection\Collection;
use Cake\ORM\TableRegistry;
use Cake\Utility\Xml;

class BalancesFiscalesController extends AppController
{public function balancesDatos2(){
        $xmlArray = Xml::toArray(Xml::build('webroot/e-ggds/BalanceFiscalGC.xml'));


                    $collection = new Collection($xmlArray);
                    $collection->nest('@INDICATOR', '[]')->toList(); //I tried with the parent "Series" still same problem. It returns me the whole JSON instead of what I need. I also tried filter, map, append, no luck.

        //Gobierno Central
        $response = [
            'gob_central' =>[
                    'titulos' =>[
                        $collection
                    ]
                    ]
            ];


           $this->set([
            'data' => $response,
            '_serialize' => ['data']
              ]);

    }

}

  • 写回答

1条回答 默认 最新

  • duanbu4962 2019-04-30 21:30
    关注

    To extract a field from a collection, you'd use the extract function. Assuming that it's all under the [data][gob_central][titulos][0][StructureSpecificData][message:DataSet][Series] key, it might look like this:

    $series = $xmlArray['data']['gob_central']['titulos'][0]['StructureSpecificData']['message:DataSet']['Series'];
    $data = collection($series)->extract('@INDICATOR')->toArray();
    

    If there might be multiple items in the titulos key, then maybe more like this:

    $titulos = $xmlArray['data']['gob_central']['titulos'];
    $data = collection($titulos)->extract('StructureSpecificData.message:DataSet.Series.{*}.@INDICATOR')->toArray();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 comsol仿真等离激元
  • ¥15 静电纺丝煅烧后如何得到柔性纤维
  • ¥15 (标签-react native|关键词-镜像源)
  • ¥100 照片生成3D人脸视频
  • ¥15 伪装视频时长问题修改MP4的时长问题,
  • ¥15 JETSON NANO
  • ¥15 VS开发qt时如何在paintgl函数中用pushbutton控制切换纹理
  • ¥20 关于 openpyxl 处理excel文件地问题
  • ¥15 MS中不知道高分子的构型怎么构建模型
  • ¥60 QQOP数据,什么是op数据号,怎么提取op数据!能不能大量提取(语言-c语言)