public function edit() { $message = Message::find($this->request->id); if ($this->request->data && $message->save($this->request->data)) { return compact('message'); } else { return array('errors' => $message->errors()); } }
public function actionIndex() { $curUser = \Yii::$app->user->id; UserSettingsBlock::sync($curUser); //todo return data model $block = Block::find()->with('links')->where(['hidden' => Block::STATUS_SHOW, 'type' => Block::TYPE_TAB])->orderBy('order')->all(); $model = UserSettingsBlock::find()->with('block')->orderBy('column, order')->where(['{{%user_settings_block}}.user_id' => $curUser])->all(); $msg = Message::find()->where(['status' => Message::STATUS_SHOW])->all(); return $this->render('index', ['model' => $model, 'blocks' => $block, 'messages' => $msg, 'link' => Link::getLinksBlocks()]); }
public function actionList() { $messages = Message::find()->where(['is_visible' => true])->orderBy('timestamp desc')->all(); $model = new Message(); if ($model->load(Yii::$app->request->post())) { $model->save(); $this->redirect(['list']); } return $this->render('list', ['messages' => $messages, 'model' => $model]); }
public function actionEdit() { $languages = Message::getLanguages(); $model = new Message(); $model->language = $_GET['language']; $model->file = $_GET['file']; $model->messageId = $_GET['message-id']; $model->message = Message::find($_GET['language'], $_GET['file'], $_GET['message-id']); $files = Message::getFiles($_GET['language']); return $this->render('edit', array('languages' => $languages, 'files' => $files, 'language' => $model->language, 'file' => $model->file, 'message' => $model->message, 'messageId' => $model->messageId)); }
public function bootstrap() { $messages = Message::find('all', array('order' => array('created' => -1), 'limit' => 20)); $messages = $messages->map(function ($model) { $arr = $model->to('array'); $arr['id'] = $arr['_id']; unset($arr['_id']); return $arr; }, array('collect' => false)); $messages = json_encode($messages); return compact('messages'); }
public function actionDelMessage() { if (!Yii::$app->user->isGuest && Yii::$app->user->identity->isAdmin()) { $post = Yii::$app->request->post(); if ($post['id']) { $message = Message::find()->where(['id' => $post['id']])->one(); if ($message) { $message->delete(); } } } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Message::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'language', $this->language])->andFilterWhere(['like', 'translation', $this->translation]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Message::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'timestamp' => $this->timestamp, 'creator_id' => $this->creator_id, 'is_visible' => $this->is_visible]); $query->andFilterWhere(['like', 'content', $this->content]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Message::find(); $query->joinWith(['editor']); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['editor'] = ['asc' => ['bnm_users.name' => SORT_ASC]]; $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['ID' => $this->ID, 'user' => $this->user, 'date' => $this->date, 'type' => $this->type]); $query->andFilterWhere(['like', 'bnm_media.name', $this->name])->andFilterWhere(['like', 'desp', $this->desp])->andFilterWhere(['like', 'author', $this->author])->andFilterWhere(['like', 'url', $this->url])->andFilterWhere(['like', 'bnm_users.name', $this->editor])->andFilterWhere(['like', 'thumbnail', $this->thumbnail]); return $dataProvider; }
public function searchOwnMessages($params) { $query = Message::find()->joinWith(['sender' => function ($query) { $query->from(['senderName' => 'user']); }]); $dataProvider = new ActiveDataProvider(['query' => $query]); $dataProvider->sort->attributes['senderName.username'] = ['asc' => ['senderName.username' => SORT_ASC], 'desc' => ['senderName.username' => SORT_DESC]]; $this->load($params); if (!$this->validate()) { return $dataProvider; } $query->joinWith('senderName'); //$query->where(['like', 'senderName.username', $this->sender]); $query->andFilterWhere(['content' => $this->content])->andFilterWhere(['like', 'senderName.username', $this->sender])->andFilterWhere(['like', 'created_at', $this->created_at])->andFilterWhere(['receiver' => Yii::$app->user->identity->id]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Message::find(); $query->joinWith('sender'); ///$query->select($_columns); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'sender_id' => $this->sender_id, 'seen_at' => $this->seen_at]); $query->andFilterWhere(['like', 'message', $this->message])->andFilterWhere(['like', 'status', $this->status])->orderBy('send_at DESC'); return $dataProvider; }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $validator = Validator::make(Input::all(), Message::rules(), [], Message::niceNames()); if ($validator->fails()) { $error = $validator->errors(); $data['success'] = false; } else { $input = Request::all(); $message = Message::create($input); $id = $message->id; $data = Message::find($id)->toArray(); $data['user2_accountname'] = $input['user2_accountname']; $id_conv2 = $input['conversation2_id']; $conversation2 = Conversation::find($id_conv2); $conversation2->unseen++; $conversation2->save(); $data['success'] = true; } return json_encode($data); }
public function actionView($id) { $message = Message::findOne($id); $messages = Message::find()->where(['number' => $message->number])->all(); $model = Project::findOne($message->project_id); $reply = new Message(); foreach ($messages as $item) { $item->status = 4; $item->save(); } if ($reply->load(Yii::$app->request->post()) && $reply->validate()) { // $reply->user_id = $reply->project_id = $message->project_id; $reply->status = 1; $reply->time = time(); $reply->type = 'text'; $reply->save(); // Send twilio Text through project model $model->sendText([$message->user_id], $reply->message); Yii::$app->session->setFlash('success', 'Message Sent'); $this->redirect(['/project/messages', 'id' => $message->project_id]); } return $this->render('view', ['message' => $message, 'messages' => $messages, 'model' => $model, 'reply' => $reply]); }
public function actionMessages($id) { $messages = \app\models\Message::find()->where(['project_id' => $id])->andWhere('status != 3')->andWhere('status != 1')->limit(999)->orderBy('time DESC')->all(); $model = Project::findOne($id); return $this->render('messages', ['messages' => $messages, 'model' => $model]); }
public function actionNewmsglist() { $user_id = Yii::$app->user->identity->id; $res = Message::find()->select('from')->where(['`to`' => $user_id, '`status`' => 0])->asArray()->all(); //$res = count($res); //print_r($res); return json_encode($res); }
/** * Display the specified resource. * GET /inbox/{message} * * @param Message $message * @return Response */ public function read($id) { $message = Message::find($id); if ($message == null) { return Redirect::to('inbox'); } $user = Auth::user(); if ($message->recipient_id == $user->id && $message->last_reply <= $message->created_at) { $message->unread = 0; $message->save(); } elseif ($message->sender_id == $user->id && $message->receiver_replied == 1) { $message->receiver_replied = 0; $message->save(); } foreach ($message->unreadReplies as $reply) { if ($reply->recipient_id == $user->id) { $reply->unread = 0; $reply->save(); } } return View::make($user->role->name . '.messages.read')->withMessage($message); }
public function actionMedia($type, $cat = 0, $order = 'date', $asc = 'desc', $name = "", $desp = "", $author = "") { $query; $typeid; if ($type == 'album') { $query = Album::find(); $typeid = 0; } else { if ($type == 'video') { $query = Video::find(); $typeid = 1; } else { $query = Message::find(); $typeid = 2; } } $pagination = new Pagination(['defaultPageSize' => 30, 'totalCount' => $query->count()]); $query->distinct(); $catArr = []; if ($cat) { $query->joinWith("category"); $catArr = explode(',', $cat); $query->andWhere(['or', ['bnm_category_relationships.category' => $catArr]]); } $query->joinWith("editor"); $query->andFilterWhere(['like', 'bnm_media.name', $name]); $query->andFilterWhere(['like', 'bnm_media.desp', $desp]); $query->orderBy($order . ' ' . $asc)->offset($pagination->offset)->limit($pagination->limit); //->asArray() // $catQuery = Category::find()->joinWith("categoryRelationship")->andWhere(['bnm_category_relationships.type' => $typeid])->distinct(); return $this->render('media', ['media' => $query->all(), 'categories' => $catQuery->all(), 'pagination' => $pagination, 'catArr' => $catArr, 'catUrl' => $cat, 'oldCat' => ['cat' => $cat], 'oldOrder' => ['order' => $order, 'asc' => $asc], 'oldSearch' => ['name' => $name, 'desp' => $desp, 'author' => $author], 'type' => $type, 'typeid' => $typeid, 'asc' => $asc, 'order' => $order, 'name' => $name, 'desp' => $desp, 'author' => $author]); }
public function messageAction() { $where = '1=1'; if ($this->request->isPost()) { if ($this->request->getPost("search") == 1) { empty($this->request->getPost("keyword", "string")) || ($where .= " and keyword like '%" . $this->request->getPost("keyword", "string") . "%'"); empty($this->request->getPost("type", "int")) || ($where .= " and type=" . $this->request->getPost("type", "int")); // $this->view->disable(); // echo $where; // exit; } else { $message = new Message(); $message->setKeyword($this->request->getPost("keyword", "string")); $message->setType($this->request->getPost("type", "int")); if ($this->request->getPost("type") == 2) { if ($this->request->hasFiles() == true) { $content = $this->request->getPost("content"); $title = $this->request->getPost("title"); $url = $this->request->getPost("url"); $img = array(); foreach ($this->request->getUploadedFiles() as $file) { if ($file->getError()) { exit($file->getError()); } $filename = $this->config->uploadDir . uniqid() . "." . $file->getExtension(); $file->moveTo(APP_PATH . "/public" . $filename); $filename = $_SERVER['REQUEST_SCHEME'] . '://' . $_SERVER['HTTP_HOST'] . $filename; array_push($img, $filename); } $message->setUrl(htmlspecialchars(json_encode($url))); $message->setContent(htmlspecialchars(json_encode($content))); $message->setTitle(htmlspecialchars(json_encode($title))); $message->setImg(json_encode($img)); $message->create(); } else { exit("图片上传错误"); } } else { $message->setContent($this->request->getPost("content", "string")[0]); $message->create(); } } } if ($message = Message::find($where)) { $arr = array(); $message->rewind(); while ($message->valid()) { $n = $message->current(); if ($n) { $r['id'] = $n->getId(); $r['keyword'] = $n->getKeyword(); $r['type'] = $n->getType(); $r['title'] = $n->getTitle(); $r['content'] = $n->getContent(); $r['img'] = $n->getImg(); $r['url'] = $n->getUrl(); array_push($arr, $r); } $message->next(); } $this->view->messages = $arr; } }
NavBar::begin(['brandLabel' => Yii::$app->name, 'brandUrl' => Yii::$app->homeUrl, 'options' => ['class' => 'navbar-inverse navbar-fixed-top']]); echo Nav::widget(['options' => ['class' => 'navbar-nav navbar-right'], 'encodeLabels' => false, 'items' => [['label' => 'Home', 'url' => ['/site/index']], Yii::$app->user->isGuest ? ['label' => 'Login', 'url' => ['/site/login']] : ['label' => Html::img(Yii::$app->user->identity->avatar_md, ['class' => 'avatar img-circle']), 'linkOptions' => ['class' => 'hasAvatar'], 'items' => [['label' => 'Logout', 'url' => ['/site/logout'], 'linkOptions' => ['data-method' => 'post']]]]]]); NavBar::end(); ?> <div class="container"> <div class="row"> <div class="col-sm-6 col-sm-offset-3"> <div class="chat panel panel-default"> <div class="panel-heading"> Chat </div> <div class="panel-body"> <div id="chat"> <?php foreach (\app\models\Message::find()->limit(8)->orderBy('date DESC')->all() as $msg) { ?> <div class="chat-post" data-steamid="<?php echo $msg->steamid; ?> "> <a href="<?php echo $msg->user->profile_url; ?> " target="_blank"> <img class="chat-avatar img-circle" src="<?php echo $msg->user->avatar_md; ?> "> </a> <dl class="chat-body">
public function getMessageCount() { $message_count = \app\models\Message::find()->where(['project_id' => $this->id])->andWhere('status != 3')->andWhere('status != 4')->andWhere('status != 1')->limit(999)->orderBy('time DESC')->count(); return $message_count; }
public function actionDashboard() { $projectGraphs = NULL; $availableGraph = NULL; $unavailableGraph = NULL; $finalListGraph = NULL; $requestsGraph = NULL; // Get Messages $messages = \app\models\Message::find()->andWhere('status != 3')->andWhere('status != 1')->limit(15)->orderBy('time DESC')->all(); // Get Project Data $projectDataProvider = new ActiveDataProvider(['query' => \app\models\Project::find()->orderBy('date DESC')->limit(5), 'pagination' => ['pageSize' => 5]]); // Get Talent Data $personDataProvider = new ActiveDataProvider(['query' => \app\models\Person::find()->orderBy('date_updated DESC')->limit(5), 'pagination' => ['pageSize' => 5]]); // Get data for graphs $projects = \app\models\Project::find()->limit(5)->all(); foreach ($projects as $project) { $projectGraphs[] = $project->title; $finalListGraph[] = \app\models\Project::countList($project->id, 2); $availableGraph[] = \app\models\Project::countList($project->id, 1, 3); $unavailableGraph[] = \app\models\Project::countList($project->id, 1, 4); $requestsGraph[] = \app\models\Project::countList($project->id, 1, 2); } Yii::$app->view->title = 'Dashboard'; return $this->render('dashboard', ['messages' => $messages, 'projectDataProvider' => $projectDataProvider, 'personDataProvider' => $personDataProvider, 'projectGraphs' => $projectGraphs, 'availableGraph' => $availableGraph, 'unavailableGraph' => $unavailableGraph, 'finalListGraph' => $finalListGraph, 'requestsGraph' => $requestsGraph]); }
/** * Lists all Message models. * @return mixed */ public function actionIndex() { return $this->render('index', ['messages' => Message::find()->all()]); }
/** * Lists all Message models. * @return mixed */ public function actionIndex() { $model = Message::find()->all(); return $this->render('index', ['model' => $model]); }
public function actionList() { $dataProvider = new ActiveDataProvider(['query' => Message::find(), 'pagination' => array('pageSize' => 25)]); return $this->render('list', ['dataProvider' => $dataProvider]); }
/** * Lists all Message models. * @return mixed */ public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Message::find()]); return $this->render('index', ['dataProvider' => $dataProvider]); }
public function actionIndex() { $count = ['clients' => count(Client::find()->all()), 'websites' => count(Website::find()->all()), 'checklists' => count(Checklist::find()->all()), 'messages' => count(Message::find()->all())]; return $this->render('index', ['count' => $count]); }
<?php /* @var $this yii\web\View */ use app\models\Message; use kartik\file\FileInput; use yii\helpers\Url; use app\models; $this->title = 'Messenger'; ?> <div class="site-index"> <div class="messages"> <h1>Messages</h1> <?php foreach (Message::find()->all() as $message) { ?> <div class="message" id="<?php echo $message->id; ?> "> <h4><?php echo $message->user_name; ?> says:</h4> <?php echo $message->content; ?> <br> <br> <small><?php echo date("d M H:i", strtotime($message->created_at)); ?>