//引入ws模塊
const WebSocket = require('ws');
//創(chuàng)建服務(wù) port是端口
const wss = new WebSocket.Server({ port: 80});
//客戶端連接時(shí)會(huì)進(jìn)這個(gè)
wss.on('connection', function connection(ws) {
  console.log('連接成功');
  //客戶端發(fā)送消息時(shí)會(huì)觸發(fā)這個(gè)
  ws.on('message', function incoming(data) {
    console.log('收到消息');
    //data是客戶端發(fā)送的消息，這里clients.foreach是廣播給所有客戶端
    wss.clients.forEach(function each(client) {
      //把客戶端發(fā)來(lái)的data，循環(huán)發(fā)給每個(gè)客戶端
      client.send(data);
    });
  });
});

var http=require('http');
var qs = require('querystring'); //
var ws=require('ws');
var server=http.createServer(function (req, res) {
  res.end("This is a WebSockets server!");
});
var url = require('url');
//驗(yàn)證函數(shù)
function ClientVerify(info) {
  var ret = false;//拒絕
  //url參數(shù)
  var params = url.parse(info.req.url, true).query;
  //console.log(groupid);
  //groupid=params['groupid']
  //誰(shuí)誰(shuí)誰(shuí)來(lái)到了討論組
  // wss.clients.forEach(function each(client) {
  //   client.send('233');
  // });
  return true;
}
var wss = new ws.Server( { server: server,verifyClient: ClientVerify } );
/*//引入數(shù)據(jù)庫(kù)
 var mysql = require('mysql');
 //連接數(shù)據(jù)庫(kù)信息 普通版
 var connection = mysql.createConnection({
  host : '58.87.94.16',
  user : 'root',
  password : 'root',
  database : 'bootdo'
});*/
//引入數(shù)據(jù)庫(kù)
var mysql = require('mysql');
// 創(chuàng)建數(shù)據(jù)池
const pool = mysql.createPool({
  host   : '58.87.94.16',  // 數(shù)據(jù)庫(kù)地址
  user   : 'root',  // 數(shù)據(jù)庫(kù)用戶
  password : 'root',  // 數(shù)據(jù)庫(kù)密碼
  database : 'bootdo' // 選中數(shù)據(jù)庫(kù)
})
/*接收一個(gè)sql語(yǔ)句 以及所需的values
這里接收第二參數(shù)values的原因是可以使用mysql的占位符 '?'
比如 query(`select * from my_database where id = ?`, [1])
好像可以直接使用pool.query，暫時(shí)不明*/
let query = function(sql,values,callback){
  pool.getConnection(function(err,conn){
    if(err){
      callback(err,null,null);
    }else{
      conn.query(sql,values,function(err,results,fields){
        //釋放連接
        conn.release();
        //事件驅(qū)動(dòng)回調(diào)
        callback(err,results,fields);
      });
    }
  });
};
module.exports=query;
wss.on('connection', function connection(ws) {
  console.log('鏈接成功！');
  //console.log(ws);
  //查詢歷史聊天記錄 廣播給連接的客戶端
  var sql='select * from hi_test where groupid=1';
  console.log('sql語(yǔ)句',sql);
  query(sql,function (err,res,fields) {
    console.log('sql操作返回：', res);
    if(res!=null){
      ws.send(JSON.stringify(res));
    }
  });
  //監(jiān)聽(tīng)客戶端發(fā)送得消息
  ws.on('message', function incoming(data) {
    console.log('來(lái)自客戶端得message:',data);
    //保存客戶端發(fā)送得消息到數(shù)據(jù)庫(kù)
    sql="insert into hi_test(msg) values(?)";
    console.log('sql語(yǔ)句',sql);
    query(sql,data,function (err,res,fields) {
      console.log('sql操作返回：',res);//res.insertId
    });
    var sendData=JSON.stringify([{msg:data}])
    /**
     * 把消息發(fā)送到所有的客戶端
     * wss.clients獲取所有鏈接的客戶端
     */
    wss.clients.forEach(function each(client) {
      client.send(sendData);
    });
  });
});
server.listen(80, function listening() {
  console.log('

<view class='homeView'>
  <scroll-view scroll-y  scroll-top='{{scrolltop}}'>
    <view class='listView'>
      <block wx:for="{{serverMsg}}" wx:key='*this'>
        <!-- -->
        <view wx:if="{{item.user.id!=userInfo.userId}}" class='leftView'>
          <view class='name'>{{item.user.name}}</view>
          <view class='imgmsgleft'>
            <view>
            <!-- 我這用的是自己另一個(gè)服務(wù)的圖片 -->
              <image class='touimg' src='https://www.tjjxsoft.cn/static/images/img005.png'></image>
            </view>
            <view>{{item.msg}}</view>
          </view>
        </view>
        <view wx:else class='rightView'>
          <view class='name'>{{item.user.name}}</view>
          <view class='imgmsg'>
            <view>{{item.msg}}</view>
            <view>
            <!-- 我這用的是自己另一個(gè)服務(wù)的圖片 -->
              <image class='touimg' src='https://www.tjjxsoft.cn/static/images/img005.png'></image>
            </view>
          </view>
        </view>
      </block>
    </view>
  </scroll-view>
  <view class='sendView'>
    <input bindinput='sendTextBind' placeholder="輸入聊天內(nèi)容" value='{{sendText}}' />
    <button bindtap='sendBtn' type="primary">發(fā)送</button>
  </view>
</view>

var app = getApp();
Page({
  data: {
    socket_open: false,//判斷連接是否打開(kāi)
    sendText: "",//發(fā)送的消息
    serverMsg: [],//接受的服務(wù)端的消息
    userInfo: { userId: 1, name: "呵呵",img:'頭像'},//app.appData.userInfo,
    scrolltop: 999
  },
  /**輸入內(nèi)容 */
  sendTextBind: function(e) {
    this.setData({
      sendText: e.detail.value
    });
    console.log(this.data.sendText);
  },
  /**發(fā)送消息 */
  sendBtn: function(e) {
    console.log('發(fā)送消息事件！');
    var msgJson = {
      user: {
        id: this.data.userInfo.userId,//app.appData.userInfo.userId, //唯一ID區(qū)分身份
        name: this.data.userInfo.name, //顯示用姓名
        img: this.data.userInfo.img, //顯示用頭像
      },
      msg: this.data.sendText,//發(fā)送的消息
      groupid:1
    }
    //發(fā)送消息
    this.send_socket_message(JSON.stringify(msgJson));
    this.setData({
      sendText: ""http://發(fā)送消息后，清空文本框
    });
  },
  onLoad: function(options) {
    // app.login();
    // this.setData({
    //   userInfo: app.appData.userInfo
    // });
    //初始化
    this.wssInit();
  },
  wssInit() {
    var that = this;
    //建立連接
    wx.connectSocket({
      url: 'ws://localhost'//app.appData.socket
    })
    //監(jiān)聽(tīng)WebSocket連接打開(kāi)事件。
    wx.onSocketOpen(function(res) {
      console.log('WebSocket連接已打開(kāi)！');
      that.setData({
        socket_open: true
      });
    });
    //監(jiān)聽(tīng)WebSocket接受到服務(wù)器的消息事件。
    wx.onSocketMessage(function(res) {
      console.log('收到服務(wù)器內(nèi)容：', res);
      var server_msg = JSON.parse(res.data);
      console.log(server_msg);
      if (server_msg != null) {
        var msgnew = [];
        for (var i = 0; i < server_msg.length; i++) {
          msgnew.push(JSON.parse(server_msg[i].msg));
        }
        msgnew=that.data.serverMsg.concat(msgnew);
        that.setData({
          serverMsg: msgnew,
          scrolltop: msgnew.length * 100
        });
        console.log(that.data.serverMsg);
      }
    });
    //監(jiān)聽(tīng)WebSocket錯(cuò)誤。
    wx.onSocketError(function(res) {
      console.log('WebSocket連接打開(kāi)失敗，請(qǐng)檢查！', res)
    });
  },
  send_socket_message: function(msg) {
    //socket_open，連接打開(kāi)的回調(diào)后才會(huì)為true，然后才能發(fā)送消息
    if (this.data.socket_open) {
      wx.sendSocketMessage({
        data: msg
      })
    }
  }
})

.homeView {
  border-top: 1px solid #ededed;
}
.listView{
  padding-bottom: 50px;
}
.listView>view {
  padding: 10px;
}
.rightView {
  text-align: right;
}
.imgmsgleft {
  display: flex;
  justify-content: flex-start;
  align-items: center;
}
.imgmsgleft>view:last-child {
  border: solid 1px gray;
  padding: 10px;
  border-radius: 6px;
}
.imgmsg {
  display: flex;
  justify-content: flex-end;
  align-items: center;
}
.imgmsg>view:first-child {
  border: solid 1px gray;
  padding: 10px;
  border-radius: 6px;
  background-color: green;
}
.touimg {
  width: 50px;
  height: 50px;
}
.name {
  font-size: 14px;
  color: gray;
}
.sendView {
  display: flex;
  width: 100%;
  position: fixed;
  bottom: 0px;
  border-top: 1px #ededed solid;
  background-color: white;
}
.sendView>button {
  width: 20%;
}
.sendView>input {
  width: 80%;
  height: auto;
}