/** * 获取聊天记录 * * @param $sendId * @param $receiveId * * @return mixed */ public function getMessageHistory($sendId, $receiveId) { $table = 'user_message'; $messageModel = \common\models\Base::getInstance($table); $where = "receive_user_id={$sendId} and send_user_id={$receiveId} and status=2"; $handle = $messageModel->Query()->where($where)->select('*'); $list = $handle->all(); \Yii::$app->db->createCommand("update bhy_{$table} set status=1 where {$where}")->execute(); return $list; }
/** * 发送红包 * @param $sendId * @param $receiveId * @param $money * @param $bri_message * @return bool|string * @throws \Exception */ public function sendBribery($sendId, $receiveId, $money, $bri_message) { $tran = \Yii::$app->db->beginTransaction(); $model = Base::getInstance('user_bribery'); $model->send_user_id = $sendId; $model->receive_user_id = $receiveId; $model->money = $money; $model->create_time = time(); $model->status = 0; $model->bri_message = $bri_message; if ($model->insert(true)) { $id = \Yii::$app->db->lastInsertID; if (User::getInstance()->changeBalance($sendId, $money)) { $tran->commit(); } return $id; } $tran->rollBack(); return false; }
/** * 添加评论 * @param $data * @return bool */ public function addComment($data) { $tran = \Yii::$app->db->beginTransaction(); $comment = \common\models\Base::getInstance("user_comment"); $comment->user_id = \common\util\Cookie::getInstance()->getCookie('bhy_id')->value; $comment->content = $data['content']; $comment->dynamic_id = $data['dynamicId']; $comment->private = $data['private']; $comment->create_time = $data['create_time']; $flag = $comment->save(); $id = Yii::$app->db->lastInsertID; $dynamic = \common\models\Base::getInstance("user_dynamic")->findOne($data['dynamicId']); $dynamic->comment_num = $dynamic->comment_num + 1; if ($flag && $dynamic->save()) { $tran->commit(); return $id; } $tran->rollBack(); return false; }
public function addApply($user_id, $data) { $apply = Base::getInstance('user_rendezvous_apply'); $apply->rendezvous_id = $data['rendezvous_id']; $apply->user_id = $user_id; $apply->create_time = YII_BEGIN_TIME; $apply->phone = $data['mobile']; isset($data['msg']) ? $apply->message = $data['msg'] : true; return $apply->insert(false); }
/** * 用户操作日志 */ public function userLog($log) { $userLog = \common\models\Base::getInstance('user_log'); $userLog->user_id = $log['user_id']; $userLog->type = $log['type']; $userLog->create_time = $log['time']; $userLog->ip = ip2long($_SERVER["REMOTE_ADDR"]); return $userLog->insert(false); }