当前位置: 首页>>代码示例>>PHP>>正文


PHP Builder::select方法代码示例

本文整理汇总了PHP中Builder::select方法的典型用法代码示例。如果您正苦于以下问题:PHP Builder::select方法的具体用法?PHP Builder::select怎么用?PHP Builder::select使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Builder的用法示例。


在下文中一共展示了Builder::select方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: scopeIsAccessible

 /**
  * Select only those forums the user has access to.
  * WARNING: Creates JOINs with the forum_threads and the forums table.
  *
  * @param Builder   $query  The Eloquent Builder object
  * @param User      $user   User model or null if it's the current client
  * @return Builder
  */
 public function scopeIsAccessible($query, $user = null)
 {
     $query->select('forum_posts.*')->join('forum_threads', 'forum_posts.thread_id', '=', 'forum_threads.id')->join('forums', 'forum_threads.forum_id', '=', 'forums.id');
     if (!$user) {
         $user = user();
     }
     if ($user) {
         $internal = $user->hasAccess('internal');
         $teamIds = DB::table('team_user')->whereUserId($user->id)->lists('team_id');
         $teamIds[] = -1;
         // Add -1 as team ID so the SQL statements (`team_id` in (...)) always has valid syntax
         return $query->where('internal', '<=', $internal)->where(function ($query) use($teamIds) {
             $query->whereNull('team_id')->orWhereIn('team_id', $teamIds);
         });
     } else {
         return $query->whereInternal(0)->whereNull('team_id');
     }
 }
开发者ID:exelv1,项目名称:Contentify,代码行数:26,代码来源:ForumPost.php

示例2: scopeTransWhere

 /**
  * Applies a translatable index to a basic query. This scope will join the index
  * table and cannot be executed more than once.
  * @param  Builder $query
  * @param  string $index
  * @param  string $value
  * @param  string $locale
  * @return Builder
  */
 public function scopeTransWhere($query, $index, $value, $locale = null)
 {
     if (!$locale) {
         $locale = $this->translatableContext;
     }
     $query->select($this->model->getTable() . '.*');
     $query->where(function ($q) use($index, $value) {
         $q->where($this->model->getTable() . '.' . $index, $value);
         $q->orWhere(function ($q) use($index, $value) {
             $q->where('rainlab_translate_indexes.item', $index)->where('rainlab_translate_indexes.value', $value);
         });
     });
     // This join will crap out if this scope executes twice, it is a known issue.
     // It should check if the join exists before applying it, this mechanism was
     // not found in Laravel. So options are block joins entirely or allow once.
     $query->leftJoin('rainlab_translate_indexes', function ($join) use($locale) {
         $join->on(Db::raw(DbDongle::cast($this->model->getQualifiedKeyName(), 'TEXT')), '=', 'rainlab_translate_indexes.model_id')->where('rainlab_translate_indexes.model_type', '=', get_class($this->model))->where('rainlab_translate_indexes.locale', '=', $locale);
     });
     return $query;
 }
开发者ID:rainlab,项目名称:translate-plugin,代码行数:29,代码来源:TranslatableModel.php

示例3: dtGet

 /**
  * Get current result
  * @return array
  */
 public function dtGet()
 {
     $columns = implode(',', $this->dtGetAvailableColumns());
     return $this->dtModel->select(DB::raw($columns))->get()->toArray();
 }
开发者ID:roseffendi,项目名称:dales,代码行数:9,代码来源:ProvideDTData.php


注:本文中的Builder::select方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。