复杂查询:
where([‘and’,[‘user_id’=>$id],[‘>’,’create_time’,time()-3600*48]])->orderBy(‘create_time’)
关联操作查询:
/*
- 查询用户48小时内的消息记录
- /
public function getMsgList($id){
$data = self::find()->joinWith(‘user’)->joinWith(‘adminUser’)->where([‘and’,[‘user_id’=>$id],[‘>’,’create_time’,time()-3600*48]])->orderBy(‘create_time’)->asArray()->all();
return $data;
}
/*
- 关联模型user表
- /
public function getUser(){
return $this->hasOne(User::className(),[‘id(user表id)’=>’user_id(本类id)’]);
}
/* - 关联模型后台用户表
- /
public function getAdminUser(){
return $this->hasOne(AdminUser::className(),[‘id’=>’admin_user’]);
}