公共控制器
<?php
namespace frontend\controllers;use yii\web\Controller;
// use yii\base\Model;
use Yii;
/**
* user controller
*/
class CommonController extends Controller/ /继承原始控制器
{
public function init()// 用init方法
{
parent::init(); //继承
$user_id = Yii::$app->session->get('user_info')['id'];
//我的好友信息
$my_friend =\Yii::$app->db->createCommand("select username,u.id from user1 u join friend f on u.id=f.friend_id where f.user_id = $user_id and status = 1")->queryAll();
//我的好友中给我发的信息中未读的信息
$un_see =\Yii::$app->db->createCommand("select count(send_id) as num,send_id from user_info ui where ui.receive_id = $user_id and ui.status = 0 GROUP BY send_id")->queryAll();
foreach ($my_friend as $k => $v) {
foreach ($un_see as $k1 => $v1) {
if ($my_friend[$k]['id']==$un_see[$k1]['send_id']) {
$my_friend[$k1]['un_see_num'] = $un_see[$k1]['num'];
}
}
}
Yii::$app->view->params['my_friend'] = $my_friend;// 设置参数用于公共模板调用
}
}
公共模板中这么调用
$this->params['my_friend']