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>'; } } }]); ?>