smartWiki6首页

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及项目下的文章列表，权限。。。。

转载于:https://www.cnblogs.com/keiweila/p/7989765.html