public static function compose()
{
self::login_required();
if ("POST" == Request::method()) {
$from = Request::user()->id;
$to = Request::POST()->to_account;
$subject = isset(Request::POST()->subject) ? Request::POST()->subject : '';
$text = Request::POST()->text;
Messages::create($from, $to, $subject, $text);
Response::redirect('mail/sent');
} else {
$inboxes_count = Messages::countMsg('to');
$outboxes_count = Messages::countMsg('from');
$users = Accounts::all();
View::render('mails/compose', ['inboxes_count' => $inboxes_count, 'outboxes_count' => $outboxes_count, 'users' => $users]);
}
}
private function getMessages()
{
$model = new Messages();
$messages = $model->find()->limit(10)->orderBy('id DESC')->asArray()->all();
$messages = json_encode($messages);
return $messages;
}
public function makeContactRequest(ContactRequest $req)
{
$msg = new Messages();
$msg->name = $req->input('name');
$msg->email = $req->input('email');
$msg->message = $req->input('message');
$msg->status = 0;
if ($msg->save()) {
return redirect()->back()->with('msg', 'ok');
}
}
public function actionAddmessage()
{
$date = date('Y-m-d H:i:s');
$model = new Messages();
$model->congrats = $_POST['congrats'];
$model->signature = $_POST['signature'];
$model->address = $_POST['address'];
$model->email = $_POST['email'];
$model->card = $_POST['card'];
$model->dateCreated = $date;
echo $model->save() ? 'true' : 'false';
}
/**
* Store a newly created resource in storage.
* POST
* @return Response
*/
public function store()
{
$uid_to = Input::get('uid_to');
$uid_from = Input::get('uid_from');
$message = Input::get('message');
$Messages = new Messages();
$Messages->uid_to = $following_uid;
$Messages->uid_from = $uid;
$Messages->message = $message;
$Messages->save();
//return Users::where('uid',$uid)->get();
return '';
}
public function actionIndex()
{
$model = new Messages();
if ($model->load(\Yii::$app->request->post())) {
if ($model->validate()) {
$ch = curl_init(\Yii::$app->request->post()['server'] . 'messages');
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query(['user' => $model->user, 'message' => $model->message]));
curl_exec($ch);
}
} else {
return $this->render('index', ['model' => $model]);
}
}
public function run()
{
$model = new Messages();
$messages = array_reverse(Messages::findAll(['message_to' => Yii::$app->request->get('id')]));
if ($model->load(Yii::$app->request->post())) {
if ($model->protectWidget()) {
if ($model->validate() and $model->save()) {
Yii::$app->getResponse()->redirect(Yii::$app->request->referrer);
}
} else {
Yii::$app->session->setFlash('warning', 'Ошибка! Письмо не отправленно!');
}
}
return $this->render('messages', ['model' => $model, 'messages' => $messages]);
}
public function postMessage(Request $request)
{
$this->validate($request, ['body' => 'required|max:1000']);
$messages = Messages::create(['name' => $request->input('name'), 'body' => $request->input('body')]);
// LaravelPusher::trigger('chat', 'chat_message', ['message' => $messages]);
return redirect()->route('message');
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
// this event fire when new message is created
Messages::created(function ($message) {
Event::fire(new MessageSentEvent($message));
});
}
public function getRead($id)
{
$inbox = Messages::find($id);
$inbox->status = 1;
$inbox->save();
return View::make('admin.inbox.readmessage', ['pageInfo' => ['siteTitle' => 'Inbox', 'pageHeading' => 'Inbox', 'pageHeadingSlogan' => 'Here is the place to contact with me'], 'data' => $inbox]);
}
public static function getMessagesByTypeUserId($users_id, $type)
{
$countSql = "SELECT count(mu.id) as count FROM " . self::tableName() . " mu LEFT JOIN " . Messages::tableName() . " m ON mu.messages_id = m.id WHERE mu.users_id=:users_id AND mu.type=:type";
$sql = "SELECT mu.id,m.title,m.create_time,m.create_user,m.type,mu.users_id,mu.status,m.content FROM " . self::tableName() . " mu LEFT JOIN " . Messages::tableName() . " m ON mu.messages_id = m.id WHERE mu.users_id=:users_id AND mu.type=:type";
$count = Yii::$app->db->createCommand($countSql, [':users_id' => $users_id, ':type' => $type])->queryScalar();
$pages = new Pagination(['totalCount' => $count, 'pageSize' => '20']);
$models = Yii::$app->db->createCommand($sql . " limit " . $pages->limit . " offset " . $pages->offset . "", [':users_id' => $users_id, ':type' => $type])->queryAll();
return ['models' => $models, 'pages' => $pages];
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Messages::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, 'tanggal' => $this->tanggal]);
$query->andFilterWhere(['like', 'dari', $this->dari])->andFilterWhere(['like', 'ke', $this->ke])->andFilterWhere(['like', 'isi', $this->isi]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Messages::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, 'type' => $this->type, 'status' => $this->status, 'create_time' => $this->create_time, 'update_time' => $this->update_time]);
$query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'content', $this->content])->andFilterWhere(['like', 'create_user', $this->create_user])->andFilterWhere(['like', 'update_user', $this->update_user]);
$query->orderBy('id desc');
return $dataProvider;
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
Comments::created(function ($comment) {
Event::fire(new CommentSentEvent($comment));
});
Messages::created(function ($message) {
Event::fire(new MessageSentEvent($message));
});
User::updated(function ($user) {
Event::fire(new ChangeRoleEvent($user));
});
User::created(function ($user) {
Event::fire(new NewUserEvent($user));
});
}
public function searchOwnMessages($params)
{
$query = Messages::find()->joinWith(['sender' => function ($query) {
$query->from(['senderName' => 'user']);
}]);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->sort->attributes['created_at'] = ['asc' => ['created_at' => SORT_ASC], 'desc' => ['created_at' => SORT_DESC]];
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
$query->joinWith('senderName');
$query->andFilterWhere(['content' => $this->content])->andFilterWhere(['like', 'senderName.username', $this->sender])->andFilterWhere(['like', 'created_at', $this->created_at])->andFilterWhere(['recepient' => Yii::$app->user->identity->id])->orderBy(['created_at' => SORT_DESC]);
return $dataProvider;
}
public function actionMessagesView()
{
$id = Yii::$app->request->get('id');
$messagesInfo = Messages::findOne($id);
MessagesUsers::updateAll(['status' => 1], ['messages_id' => $id]);
$levelName = Level::getOneLevelNameById(Yii::$app->user->identity->level_id);
$photo = UsersInfo::getPhotoByUserId(\Yii::$app->user->id);
$messageCount = MessagesUsers::getCountByUserIdAndType(\Yii::$app->user->id);
$currentTrain = TrainUsers::getTrainByUserId(Yii::$app->user->id);
$data = ['messagesInfo' => $messagesInfo, 'levelName' => $levelName, 'currentTrain' => $currentTrain, 'photo' => $photo, 'messageCount' => $messageCount];
return $this->render('messages-view', ['data' => $data]);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMessages()
{
return $this->hasOne(Messages::className(), ['id' => 'messages_id']);
}
protected function adminHeader()
{
view()->composer('admin.partials.header', function ($view) {
$view->with('headerData', ['notifications' => Notifications::where('user_id', Auth::user()->id)->orderBy('created_at', 'desc')->get(), 'messages' => Messages::where('status', 0)->orderBy('created_at', 'desc')->get()]);
});
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMessages()
{
return $this->hasMany(Messages::className(), ['accounts_id' => 'id']);
}
public function getReadMails()
{
$user = Session::read('member');
$id = $user['_id'];
$getReadMails = Messages::find('all', array('conditions' => array('refer_id' => $id, 'read' => 1)));
return $getReadMails;
}
/**
* Finds the Messages model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Messages the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Messages::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMessages0()
{
return $this->hasMany(Messages::className(), ['receiver_fk' => 'user_id']);
}
public function actionGetContent()
{
$id = Yii::$app->request->get('id');
$content = Messages::getContent($id);
echo $content;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMessages0()
{
return $this->hasMany(Messages::className(), ['from_id' => 'id']);
}
/**
* 根据用户id 和 消息类型 获取对应的数据
*
* @param $uid int 用id
* @param $type int 消息类型id 默认2为用户私信
* @param int $num 分页的条数
* @return mixed
*/
public function getMessageByUidAndType($uid, $type = 2, $num = 10)
{
$msg = Messages::where('rec_uid', $uid)->where('category', $type)->orderBy('id', 'desc')->paginate($num);
return $msg;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getMessages()
{
return $this->hasMany(Messages::className(), ['id' => 'messages_id'])->viaTable('network_has_messages', ['network_id' => 'id']);
}
<option value="user_level">级别</option>
<option value="all_user">全体用户</option>
</select>
<div class="help-block"></div>
</div>
用户名例如：张教练，级别例如：C级，全体用户不用填写
<?php
echo $form->field($model, 'users_id')->textInput(['style' => 'width:600px;']);
?>
<input name="MessagesUsers[type]" value="<?php
echo $type;
?>
" type="hidden">
<?php
echo $form->field($model, 'messages_id')->dropDownList(array_merge(array('' => '请选择模板'), ArrayHelper::map(\app\models\Messages::getAll(), 'id', 'title')), ['style' => 'width:500px;', 'onChange' => 'return showContent();', 'id' => 'messages_id']);
?>
<?php
echo $form->field($model, 'content')->textarea(['style' => 'width:500px;', 'id' => 'content']);
?>
<div class="form-group">
<?php
echo Html::submitButton($model->isNewRecord ? '创建' : '更新', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
<?php
ActiveForm::end();
?>
