public function up()
{
$query = new \yii\db\Query();
$query->select('notification.id')->from('notification');
$query->andWhere(['or', ['class' => 'humhub\\modules\\space\\notifications\\Invite'], ['class' => 'humhub\\modules\\space\\notifications\\InviteAccepted'], ['class' => 'humhub\\modules\\space\\notifications\\InviteDeclined'], ['class' => 'humhub\\modules\\space\\notifications\\ApprovalRequest'], ['class' => 'humhub\\modules\\space\\notifications\\ApprovalRequestAccepted'], ['class' => 'humhub\\modules\\space\\notifications\\ApprovalRequestDeclined']]);
$query->leftJoin('user', 'notification.originator_user_id=user.id');
$query->andWhere('user.id IS NULL');
foreach ($query->all() as $notification) {
$this->delete('notification', ['id' => $notification['id']]);
}
}
public static function getInfo($id)
{
$db = new yii\db\Query();
$db->from('ur_questions');
$db->leftJoin('ur_l', 'ur_questions.ur_l_id = ur_l.id');
$db->InnerJoin('region_ur_l', 'region_ur_l.id_ur = ur_l.id');
$db->InnerJoin('region', 'region_ur_l.id_reg = region.id');
$db->groupBy('ur_l.id');
$db->select(['ur_l.name as uname', 'GROUP_CONCAT(DISTINCT(region.name)) as rname', 'ur_l.contact_mail', 'ur_l.contact_phone', 'ur_l.contact_face', 'question', 'qfiles', 'ansver', 'ur_questions.created_at', 'ur_l.id', 'ur_questions.id as qid']);
$db->where(['=', 'ur_questions.id', $id]);
//$db->leftJoin('region', 'ur_l.region_id = region.id');
return $db->One();
}
