* Created by PhpStorm.
* User: Nguyen
* Date: 10/10/2015
* Time: 3:03 PM
*/
use common\models\Relationship;
use dosamigos\ckeditor\CKEditor;
use kartik\date\DatePicker;
use kartik\select2\Select2;
use yii\helpers\Html;
use yii\widgets\ActiveForm;
$this->title = 'Sửa bài';
$this->params['breadcrumbs'][] = $this->title;
$sql = 'SELECT * FROM relationship WHERE ((user_id_1=:user_id)
OR (user_id_2=:user_id)) AND status=1';
$arrRelationship = Relationship::findBySql($sql, [':user_id' => Yii::$app->user->getId()])->asArray()->all();
$arrUserName = array();
foreach ($arrRelationship as $rel) {
if ($rel['user_id_1'] == Yii::$app->user->getId()) {
$arrUserName[$rel['user_id_2']] = \common\models\User::findOne(['id' => $rel['user_id_2']])->username;
} else {
$arrUserName[$rel['user_id_1']] = \common\models\User::findOne(['id' => $rel['user_id_1']])->username;
}
}
?>
<div class="post-edit-form">
<div class="row">
<div class="col-lg-10 col-lg-offset-1">
<div class="box box-info">
<div class="box-header">
public static function isInRelationship($user_id_1, $user_id_2)
{
$sql = 'SELECT * FROM relationship WHERE ((user_id_1=:user_id_1 AND user_id_2=:user_id_2)
OR (user_id_1=:user_id_2 AND user_id_2=:user_id_1)) AND status=1';
return Relationship::findBySql($sql, [':user_id_1' => $user_id_1, ':user_id_2' => $user_id_2])->count() > 0;
}
public function actionShowListFriend($friend_type)
{
$user_id = Yii::$app->user->getId();
$sql = 'SELECT * FROM relationship WHERE ((user_id_1=:user_id AND with_user_1_is=:friend_type)
OR (user_id_2=:user_id AND with_user_2_is=:friend_type)) AND status=1';
$arrRelationship = Relationship::findBySql($sql, [':user_id' => $user_id, ':friend_type' => $friend_type])->asArray()->all();
$model = array();
foreach ($arrRelationship as $relationship) {
if ($relationship['user_id_1'] == $user_id) {
array_push($model, User::findOne(['id' => $relationship['user_id_2']]));
} else {
array_push($model, User::findOne(['id' => $relationship['user_id_1']]));
}
}
return $this->render('show-friend', ['model' => $model]);
}
