public function actionSearch_data()
{
$data = json_decode(utf8_encode(file_get_contents("php://input")), false);
$term = $data->term;
\Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;
$response = [];
/*$pages = (new \yii\db\Query())
->select(['id', 'page_title', 'page_desc'])
->from('page')
->where(['like','page_desc',$term])
->all(); */
$pages = Page::find()->select(['id', 'page_title', 'page_desc', 'page_slug'])->where(['like', 'page_desc', $term])->all();
$i = 0;
foreach ($pages as $key => $value) {
$value->page_desc = str_replace(array("\r\n", "\r", "\n"), "", $value->page_desc);
$value->page_desc = trim(strip_tags($value->page_desc));
$response[$i]['page_title'] = $value->page_title;
$response[$i]['page_url'] = Page::get_parent_pages_backward($value->id, $value->page_slug);
$response[$i]['page_result'] = substr_count($value->page_desc, $term);
$response[$i]['page_thumb'] = '';
if (!empty($value->thumbimages)) {
$response[$i]['page_thumb'] = Yii::$app->urlManagerBackEnd->createAbsoluteUrl('/') . 'uploads/' . $value->thumbimages[0]->image;
}
$x = explode('.', $value->page_desc);
$response[$i]['page_desc'] = '';
foreach ($x as $sentence) {
if (substr_count($sentence, $term) > 0) {
$response[$i]['page_desc'] = str_replace($term, '<span class="highlight">' . $term . '</span>', $sentence) . '.';
break;
}
}
$i++;
}
return $response;
}
public function upload()
{
if ($this->validate()) {
foreach ($this->imageFiles as $file) {
$file->saveAs('uploads/' . $file->baseName . date('Yhis') . '.' . $file->extension);
}
$model2 = new Page();
$model2->pic_name = 'uploads/' . $file->baseName . date('Yhis') . '.' . $file->extension;
$model2->user_id = Yii::$app->user->identity->id;
$model2->up_date = date('Y-m-d');
$model2->status = 0;
$model2->insert();
return true;
} else {
return false;
}
}
public function actionCheckrequest()
{
$user_id = Yii::$app->user->identity->id;
$model = new FriendList();
$res = $model::find()->where(['to' => $user_id, 'status' => 0])->asArray()->all();
foreach ($res as $val) {
$res = \frontend\models\Page::find()->select('pic_name')->where(['user_id' => $val['from'], 'status' => 1])->asArray()->one();
$pic_url = empty($res) ? 'uploads/def.jpg' : $res['pic_name'];
$res2 = \app\models\User::find()->select('id,first_name,last_name')->where(['id' => $val['from']])->asArray()->one();
$fin[] = array('user_id' => $res2['id'], 'first_name' => $res2['first_name'], 'last_name' => $res2['last_name'], 'pic' => $pic_url);
}
//print_r($fin) ;
// print_r($pic);
return json_encode($fin);
}
public function actionCreate_json_page()
{
$response = [];
$file = 'json/allpages.json';
if (is_file($file)) {
unlink($file);
}
$pages_data_list = Page::find()->joinWith('page_rel')->where(['page_self_rels.parent_page_id' => 0])->all();
$i = 0;
foreach ($pages_data_list as $pages_data) {
$response[$pages_data->page_slug] = Page::getOne_page($pages_data->page_slug);
$i++;
}
$fp = fopen($file, 'w');
fwrite($fp, \yii\helpers\Json::encode($response));
fclose($fp);
return $this->redirect(['/']);
}
public function findChild_pages_by_id($id)
{
$child_pages = Page::find()->joinWith('page_rel')->where(['page_self_rels.parent_page_id' => $id, 'is_archive' => 0])->all();
return $child_pages;
}
public function getPage_rel()
{
return $this->hasOne(Page::className(), ['id' => 'page_id']);
}
<title><?php
echo Html::encode($this->title);
?>
</title>
<?php
$this->head();
?>
</head>
<body>
<?php
$this->beginBody();
?>
<div class="wrap">
<?php
$pic_nav = \frontend\models\Page::find()->where(['user_id' => Yii::$app->user->identity->id, 'status' => 1])->asArray()->all();
$pic_url = empty($pic_nav) ? 'uploads/def.jpg' : $pic_nav[0]['pic_name'];
NavBar::begin(['brandLabel' => 'Social network', 'brandUrl' => Yii::$app->homeUrl, 'options' => ['class' => 'navbar-inverse navbar-fixed-top']]);
if (Yii::$app->user->isGuest) {
$menuItems[] = ['label' => 'Home', 'url' => ['/site/index']];
// $menuItems[] = ['label' => 'Signup', 'url' => ['/site/signup']];
// $menuItems[] = ['label' => 'Login', 'url' => ['/site/login']];
} else {
$menuItems = [['label' => '<img src="/' . $pic_url . '" style="cursor: pointer; width: 27px; height: 25px;display: inline;margin: 0px 5px 0px 0px;border-radius: 2px;">' . Yii::$app->user->identity->first_name . '', 'url' => ['/site/index', 'id' => Yii::$app->user->identity->id], 'options' => ['id' => Yii::$app->user->identity->id]], ['label' => 'Massage', 'url' => ['/site/msglist']], ['label' => '<img src="/uploads/req.jpg" style="cursor: pointer; width: 27px; height: 25px;display: inline;margin: 0px 5px 0px 0px;border-radius: 2px; color: #0a0a0a">', 'linkOptions' => ['title' => 'Friend request', 'class' => 'fr_req', 'data-html' => 'true', 'data-toggle' => 'popover', 'data-placement' => 'bottom', 'data-content' => 'ContentContentContentContentContentvv']], ['label' => 'My pictures', 'url' => ['/site/upload']], ['label' => 'Search', 'url' => ['/user/index']], ['label' => 'Settings', 'items' => [['label' => 'Change password', 'url' => '/settings/changepassword'], ['label' => 'Change settings', 'url' => '/settings/']]], ['label' => 'Logout', 'url' => ['/site/logout'], 'linkOptions' => ['data-method' => 'post']]];
}
echo Nav::widget(['options' => ['class' => 'navbar-nav navbar-right'], 'items' => $menuItems, 'encodeLabels' => false]);
NavBar::end();
?>
<div class="container">
public function actionProfile($id)
{
$pic_avatar = \frontend\models\Page::find()->where(['user_id' => $id, 'status' => 1])->all();
$info_user = \app\models\User::find()->where(['id' => $id])->all();
//$user_list = \app\models\User::find()->all();
$edit = new TimeLine();
$pic = \frontend\models\Page::find()->where(['user_id' => $id])->all();
$model = new FriendList();
$sql = 'SELECT * FROM `friend_list` WHERE `from`=' . $id . ' and `status`=1 or `to`=' . $id . ' and `status`=1';
$res = $model->findBySql($sql)->asArray()->all();
//$res = $model::find()->where(['to'=>$user_id, 'status' => 0])->asArray()->all();
foreach ($res as $val) {
$res = \frontend\models\Page::find()->select('pic_name')->where(['user_id' => $val['from'], 'status' => 1])->asArray()->one();
$res2 = \app\models\User::find()->select('id,first_name,last_name')->where(['id' => $val['from']])->asArray()->one();
$user_list[] = array('user_id' => $res2['id'], 'first_name' => $res2['first_name'], 'last_name' => $res2['last_name'], 'pic' => $res['pic_name'], 'id' => $id);
}
return $this->render('profile', ['pic' => $pic, 'info_user' => $info_user, 'user_list' => $user_list, 'pic_avatar' => $pic_avatar, 'edit' => $edit, 'id' => $id]);
}
} elseif (Yii::$app->user->identity->id == $res2[0]['to']) {
$res = \frontend\models\Page::find()->select('pic_name')->where(['user_id' => $model->id, 'status' => 1])->asArray()->all();
$pic_url = empty($res) ? 'uploads/def.jpg' : $res[0]['pic_name'];
return '<div class="list-group">
<li class="list-group-item" style="height: 125px;width:350px;margin-left: 30px;">
' . Html::img('@web/' . $pic_url, ['alt' => 'Chenge picture', 'style' => ['cursor' => 'pointer', 'width' => '100px', 'height' => '100px', 'display' => 'inline', 'float' => 'left', 'margin-right' => '5px'], 'class' => 'img-thumbnail ']) . '
<a href="/site/profile/' . $model->id . '" <h4 class="list-group-item-heading">' . $model->first_name . " " . $model->last_name . '</h4></a>
<p class="list-group-item-text">' . $model->country . '</p>
<p class="list-group-item-text">' . floor((strtotime(date('Y-m-d')) - strtotime($model->bd_date)) / 60 / 60 / 24 / 365) . ' years' . '</p>
<p class="list-group-item-text but" style="margin-top: 6px;"><p class="list-group-item-text but" style="margin-top: 6px;"><button data_req="' . $model->id . '" type="button" class="btn btn-primary post_status add_fr">Accept</button> <button data_req="' . $model->id . '" type="button" class="btn btn-danger post_status del"> Cancel</button>
</p>
</li>
</div>';
} else {
$res = \frontend\models\Page::find()->select('pic_name')->where(['user_id' => $model->id, 'status' => 1])->asArray()->all();
$pic_url = empty($res) ? 'uploads/def.jpg' : $res[0]['pic_name'];
return '<div class="list-group">
<li class="list-group-item" style="height: 125px;width:350px;margin-left: 30px;">
' . Html::img('@web/' . $pic_url, ['alt' => 'Chenge picture', 'style' => ['cursor' => 'pointer', 'width' => '100px', 'height' => '100px', 'display' => 'inline', 'float' => 'left', 'margin-right' => '5px'], 'class' => 'img-thumbnail ']) . '
<a href="/site/profile/' . $model->id . '" <h4 class="list-group-item-heading">' . $model->first_name . " " . $model->last_name . '</h4></a>
<p class="list-group-item-text">' . $model->country . '</p>
<p class="list-group-item-text">' . floor((strtotime(date('Y-m-d')) - strtotime($model->bd_date)) / 60 / 60 / 24 / 365) . ' years' . '</p>
<p class="list-group-item-text but" style="margin-top: 6px;"><button id="' . $model->id . '" type="button" class="btn btn-primary post_status add">Add to friends</button>
</p>
</li>
</div>';
}
}
}]);
?>
