douaoj0994
2017-11-14 08:17
浏览 687
已采纳

laravel查询中where条件的数组值

I have an array called assetIDs as below

$assetIDs = Collection {#505 ▼
  #items: array:2 [▼
    0 => 4
    1 => 7
  ]
}

and I have the data in the table as below shown

data

and I'm doing query on the above table using this

$supplier_id = SupplierAsset::whereIn('asset_id',$asset_ids)->pluck('supplier_id');

and result for the above query is below

Collection {#510 ▼
  #items: array:3 [▼
    0 => 1
    1 => 1
    2 => 2
  ]
}

here whereIn is returning all the possible rows which satisfies the condition. Actually I need to get the result as like which supplier_id has both the values of assetIDs array.In my table supplier_id=1 has the both values 4 and 7 Just like below collection.

Collection {#510 ▼
  #items: array:3 [▼
    0 => 1
    1 => 1
  ]
}

Can anybody suggest me the solution for this please?

图片转代码服务由CSDN问答提供 功能建议

我有一个名为 assetIDs 的数组,如下所示 < pre> $ assetIDs = Collection {#505▼ #items:array:2 [▼ 0 =&gt; 4 1 =&gt; 7 ] }

我在表格中的数据如下所示

我正在使用此

$ supplier_id = SupplierAsset :: whereIn(上表)进行查询 'asset_id',$ asset_ids) - &gt; pluck('supplier_id');

以上查询的结果在

  Collection {#510▼
 #items:array:3 [▼
 0 =&gt;  1 
 1 =&gt;  1 
 2 =&gt;  2 
] 
} 
   
 
 

此处 whereIn 返回满足条件的所有可能行。 实际上我需要获得结果,就像 supplier_id 具有 assetIDs 数组的值一样。在我的表 supplier_id = 1 中有两个值 4 7 就像下面的集合一样。

  Collection {#510▼
 #items:array:3 [  ▼
 0 =&gt;  1 
 1 =&gt;  1 
] 
} 
   
 
 

有人可以建议我解决这个问题吗?

  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • doujingxi3356 2017-11-14 09:08
    已采纳

    You can try:

    $supplier_id = SupplierAsset::whereIn('asset_id',$asset_ids)
                   ->groupBy('supplier_id')
                   ->havingRaw('count(distinct asset_id) = ' . count($assetIDs))
                   ->pluck('supplier_id');
    
    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • droos02800 2017-11-14 09:34

    Here is the mysql you should do :

    1- get all the id who have more than 1 supplier_id :

    SELECT supplier_id, Count(distinct asset_id) as dist_asst
     FROM Table
     GROUP BY supplier_id
     HAVING dist_asst > 1
    

    2- then doing a join :

    SELECT t1.supplier_id
    FROM Table t1
    INNER JOIN (SELECT supplier_id, Count(distinct asset_id) as dist_asst
         FROM Table
         GROUP BY supplier_id
         HAVING dist_asst > 1) t2 on t2.supplier_id = t1.supplier_id
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题