doutan5724 2017-12-06 10:02
浏览 25
已采纳

Cakephp 3.3 - 如何在连接表时删除嵌套级别

I'm using CakePHP 3.3 and try to get data by join table

$this->find()
->select([
    'TableA.id',
    'TableA.user_id',
    'TableA.note',
    'TableB.log_date'
])
->where([
    'TableA.user_id' => $userId
])
->join([
    'table' => 'table_b',
    'alias' => 'TableB',
    'conditions' => 'TableA.table_b_id = TableB.id',
]);

I try to var_dump() result var_dump($result->toArray());die; My array display like this:

    "data": [
    {
        "id": 1317,
        "user_id": 331,
        "note": "Take note",
        "TableB": {
            "log_date": "2017-11-16"
        }
      },
      {
        "id": 1318,
        "user_id": 331,
        "note": "Take note",
        "TableB": {
            "log_date": "2017-11-16"
        }
      }
  ],

My result has nested in TableB. How I can remove nested and display like this:

    "data": [
      {
        "id": 1317,
        "user_id": 331,
        "note": "Take note",
        "log_date": "2017-11-16"
      },
      {
        "id": 1318,
        "user_id": 331,
        "note": "Take note",
        "log_date": "2017-11-16"
      }
   ],

Could I get all data in same level in array? Thanks for reading!

  • 写回答

1条回答 默认 最新

  • dongren9739 2017-12-06 10:18
    关注

    You can make alias for joined fields by using associative keys in select()

    $result = $this
        ->Articles
        ->find()
        ->select([
            'Articles.id', 
            'user_id' => 'users.id' 
        ])
        ->join([
            'table' => 'users', 
            'conditions' => 'users.id = Articles.user_id'
        ])
        ->toArray(); 
    

    The sample of result:

    [{"id":26,"user_id":2},{"id":27,"user_id":2}]
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 我这模型写的不对吗?为什么lingo解出来的下面影子价格这一溜少一个变量
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波