<?php

namespace app\models;

use app\widgets\LinkPager;

use Yii;

use yii\data\Pagination;

/**

* This is the model class for table "doc_project".

*

* @property int $id

* @property string $encode_id 加密id

* @property string $title 项目名称

* @property string $remark 项目描述

* @property int $sort 项目排序

* @property int $type 项目类型

* @property int $status 项目状态

* @property int $creater_id 创建者id

* @property int $updater_id 更新者id

* @property string $created_at 创建时间

* @property string $updated_at 更新时间

*/

class Project extends Model

{

const PUBLIC_TYPE = 10;

const AUTH_TYPE = 20;

const PRIVATE_TYPE = 30;

/**

* 绑定数据表

*/

public static function tableName()

{

return '{{%project}}';

}

/**

* 验证规则

*/

public function rules()

{

return [

[['encode_id', 'title', 'status', 'creater_id'], 'required'],

[['type', 'sort'], 'filter', 'filter' => 'intval'], //此规则必须，否则就算模型里该字段没有修改，也会出现在脏属性里

[['encode_id'], 'string', 'max' => 50],

[['title', 'remark'], 'string', 'max' => 250],

[['encode_id'], 'unique'],

[['created_at', 'updated_at'], 'safe'],

];

}

/**

* 字段字典

*/

public function attributeLabels()

{

return [

'id' => 'ID',

'encode_id' => '加密id',

'title' => '项目名称',

'remark' => '项目描述',

'sort' => '项目排序',

'allow_search' => '搜索状态',

'status' => '项目状态',

'creater_id' => '创建者id',

'updater_id' => '更新者id',

'created_at' => '创建时间',

'updated_at' => '更新时间',

];

}

/**

* 项目所有类型标签

* @return array

*/

public function getTypeLabels()

{

return [

self::PUBLIC_TYPE => '公开项目',

// self::AUTH_TYPE => '授权项目',

self::PRIVATE_TYPE => '私有项目',

];

}

/**

* 获取当前项目类型标签

* @return mixed

*/

public function getTypeLabel()

{

return $this->getTypeLabels()[$this->type];

}

/**

* 获取项目环境

* @return \yii\db\ActiveQuery

*/

public function getEnvs()

{

$filter = ['status' => Env::ACTIVE_STATUS];

$order = [

'sort' =>SORT_DESC,

'id' => SORT_ASC

];

return $this->hasMany(Env::className(), ['project_id' => 'id'])->where($filter)->orderBy($order);

}

/**

* 获取项目模块

* @return \yii\db\ActiveQuery

*/

public function getModules()

{

$filter = [

'status' => Module::ACTIVE_STATUS

];

$order = [

'sort' =>SORT_DESC,

'id' => SORT_DESC

];

return $this->hasMany(Module::className(), ['project_id' => 'id'])->where($filter)->orderBy($order);

}

/**

* 获取项目接口

* @return \yii\db\ActiveQuery

*/

public function getApis()

{

$filter = [

'status' => Api::ACTIVE_STATUS

];

$order = [

'sort' =>SORT_DESC,

'id' => SORT_DESC

];

return $this->hasMany(Api::className(), ['project_id' => 'id'])->where($filter)->orderBy($order);

}

/**

* 获取项目成员

* @return \yii\db\ActiveQuery

*/

public function getMembers()

{

$order = ['id' => SORT_DESC];

return $this->hasMany(Member::className(), ['project_id' => 'id'])->orderBy($order);

}

/**

* 获取非项目成员(不包括自己)

* @return \yii\db\ActiveQuery

*/

public function getNotMembers($param = [])

{

$member_ids = $this->getMembers()->select('user_id')->column();

$query = Account::find();

$query->andFilterWhere(['status' => Account::ACTIVE_STATUS]);

$query->andFilterWhere(['not in', 'id', $member_ids])

->andFilterWhere(['<>', 'id', $this->creater_id]);

$query->andFilterWhere([

'or',

['like','name', $param['name']],

['like','email', $param['name']],

]);

$sql = $query->createCommand()->getRawSql();

return $query->all();

}

/**

* 判断是否是项目创建者

* @return bool

*/

public function isCreater($user_id = 0)

{

$user_id = (int)$user_id ? $user_id : Yii::$app->user->identity->id;

return $this->creater_id == $user_id ? true : false;

}

/**

* 判断是否是项目参与者

* @return bool

*/

public function isJoiner($user_id = 0)

{

$user_id = (int)$user_id ? $user_id : Yii::$app->user->identity->id;

$query = Member::find()->where(['project_id' => $this->id, 'user_id' => $user_id]);

return $query->exists() ? true : false;

}

/**

* 判断是否是公开项目

* @return bool

*/

public function isPublic()

{

return $this->type == self::PUBLIC_TYPE ? true : false;

}

/**

* 判断是否是私有项目

* @return bool

*/

public function isPrivate()

{

return $this->type == self::PRIVATE_TYPE ? true : false;

}

/**

* 获取项目地址

* @return string

*/

public function getUrl($scheme = false)

{

return url('home/project/show', ['id' => $this->encode_id], $scheme);

}

/**

* 获取项目身份

* @param int $user_id

* @return string

*/

public function getIdentity($user_id = 0)

{

if($this->isCreater($user_id)){

return '创建者';

}

if($this->isJoiner($user_id)){

return '项目成员';

}

return '普通游客';

}

/**

* 检测是否有操作权限

* @param $rule

* @return bool

*/

public function hasRule($type, $rule, $user_id = 0)

{

$user_id = (int)$user_id ? $user_id : Yii::$app->user->identity->id;

$account = Account::findModel($user_id);

// 系统管理员拥有一切权限

if($account->isAdmin){

return true;

}

// 项目创建者拥有所有权限

if($this->isCreater($user_id)){

return true;

}

$member = Member::findOne(['project_id' => $this->id, 'user_id' => $user_id]);

if(!$member->id){

return false;

}

if($member->hasRule($type, $rule)){

return true;

}

return false;

}

/**

* 项目搜索

* @param array $params

* @return $this

* @throws \Exception

*/

public function search($params = [])

{

$this->params = array2object($params);

if(!$this->params->orderBy){

$this->params->orderBy = 'id desc';

}

$query = self::find()->joinWith('creater');

$query->andFilterWhere([

'{{%project}}.creater_id' => $this->params->creater_id,

]);

$this->params->status && $query->andFilterWhere([

'{{%project}}.status' => $this->params->status,

]);

$this->params->type && $query->andFilterWhere(['in', '{{%project}}.type', $this->params->type]);

$query->andFilterWhere(['like', '{{%project}}.title', $this->params->title]);

$this->params->start_date && $query->andFilterWhere(['>=', '{{%project}}.created_at', $this->params->start_date . ' 00:00:00']);

$this->params->end_date && $query->andFilterWhere(['<=', '{{%project}}.created_at', $this->params->end_date . ' 23:59:59']);

$query->andFilterWhere([

'or',

['like','{{%user}}.name', $this->params->user->name],

['like','{{%user}}.email', $this->params->user->name],

]);

$this->count = $query->count();

$pagination = new Pagination([

'pageSizeParam' => false,

'totalCount' => $this->count,

'pageSize' => $this->pageSize,

'validatePage' => false,

]);

$this->models = $query

->offset($pagination->offset)

->limit($pagination->limit)

->orderBy($this->params->orderBy)

->all();

$this->sql = $query->createCommand()->getRawSql();

// dump($this->sql);

$this->pages = LinkPager::widget([

'pagination' => $pagination,

'nextPageLabel' => '下一页',

'prevPageLabel' => '上一页',

'firstPageLabel' => '首页',

'lastPageLabel' => '尾页',

'hideOnSinglePage' => true,

'maxButtonCount' => 5,

]);

return $this;

}

}