1常量
classHomeControllerextendsController
{
constPageSize=20;
$this->data['lists']=Project::getProjectByMemberId($pageIndex,self::PageSize常量,$member_id);
2
$query=DB::table('projectaspro')
->select('pro.*')
->leftJoin('relationshipasrel',function($join)use($member_id){
$join->on('pro.project_id','=','rel.project_id')
->where('rel.member_id','=',$member_id);
})
->orWhere('pro.project_open_state','<>',0)
->orWhere('rel_id','>',0)
->orderBy('pro.project_id','DESC')
->paginate($pageSize,['*'],'page',$pageIndex);
3
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class User extends Model
{
public function cars()
{
return $this->hasMany(Car::class);
}
}
app/Models/Car.php:
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Model;
class Car extends Model
{
public function user()
{
return $this->belongsTo(User::class);
}
}
用户的所有车辆:
$cars = User::find(1)->cars;
取车的主人
$owner = Car::find(1)->user;
dd($owner->toArray());
作者：Summer
链接：https://www.zhihu.com/question/49485090/answer/116219727
来源：知乎
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。
3显示项目project及项目下的文章列表，权限。。。。