本文整理汇总了PHP中Builder::leftJoin方法的典型用法代码示例。如果您正苦于以下问题：PHP Builder::leftJoin方法的具体用法？PHP Builder::leftJoin怎么用？PHP Builder::leftJoin使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Builder的用法示例。
在下文中一共展示了Builder::leftJoin方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: 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;
}