dongtao5055 2015-07-15 14:41
浏览 34

laravel - 自定义列表方法,带条件

I'm trying to create a custom "lists" method in my repository so I can pass an array of conditions but it's not working.

public function lists( array $conditions, $value, $key, $distinct = false )
{
  $query = $this->model();

  foreach( $conditions as $keyvalue => $columnvalue )
  {
    if( $keyvalue == 'id' )
    {
      $query->where($keyvalue, '=', $columnvalue );
    }
    else
    {
      $query->where($keyvalue, 'LIKE', '%'.$columnvalue.'%');  // Non-empty string for example; posted a story id
    }
  }

  if( $distinct )
  {
    return $query->distinct()->lists( $value, $key );  
  }
  else
  {
    return $query->lists( $value, $key );
  }
}

Any help appreciated, it returns all values and ignores the where clause.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥15 想问一下树莓派接上显示屏后出现如图所示画面,是什么问题导致的
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line
    • ¥500 火焰左右视图、视差(基于双目相机)
    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败