1--LINE Notify 個人頁面 發行存取權杖

2--http://3.114.197.59/test/line_notify.php?token=你的權杖&message=傳送的訊息

http://3.114.197.59/test/line_notify.php?token=RqFM12eMY4yNPP3PAh8xykKee5cHZXVGZDgMrdddF3Px&message=有人已通報消息，請立即查看!!

3--http://3.114.197.59/DeviceRC/url.php?title=APP名稱&data=[{ "url": "3.114.197.59/test/line_notify.php?token=你的權杖amp;message=傳送的訊息", "name": "按鈕名稱", "type": "message" }]

http://3.114.197.59/DeviceRC/url.php?title=辦公室控制器&data=[{ "url": "3.114.197.59/test/line_notify.php?token=2QIOtBVIC91RyUrXA17dEBXA6cNEglvgNRoWeWXCuVyamp;message=1018要上廁所，請幫忙", "name": "協助上廁所", "type": "message" }]

4--設定按鈕連接通知LINE, URL

LINE Developers

Lu Boris 影片教學

google sheet

https://docs.google.com/spreadsheets/d/1fhzJkHejcnyG-8A9nHcDShMBcy4mRAvZI0BAe30qNm0/edit#gid=0

google scripts

//程式碼開始

var CHANNEL_ACCESS_TOKEN = "KGn06heEoGQtKdU8NBHZtx9xyyaWQPDYZ6JkIXqIxYCjhE4030LS3ihYsGKK4oNaONda7DO7RKa+VQwSP8N05UDlFTR9UqQnwmXwDxYmhMrwBdpn3zsvC9OH3XF4Sls2HaPnh9oh+Q9+GQ4eajoZ7AdB04t89/1O/w1cDnyilFU=";

var spreadSheetID = "1fhzJkHejcnyG-8A9nHcDShMBcy4mRAvZI0BAe30qNm0";

var welcomeTitle = "問卷開始的說明";

var finishTitle = "問卷結束時的感謝語";

var spreadSheet = SpreadsheetApp.openById(spreadSheetID);

var sheet = spreadSheet.getActiveSheet();

var lastRow = sheet.getLastRow();

var lastColumn = sheet.getLastColumn();

var sheetData = sheet.getSheetValues(1, 1, lastRow, lastColumn);

var token = "OO76479tFQiAWDu44Uc0DTkcXWvXKvq6qFymVy3Vsj3"; //Line Notify 的權杖

function doPost(e) {

var userData = JSON.parse(e.postData.contents);

console.log(userData);

// 取出 replayToken 和發送的訊息文字

var replyToken = userData.events[0].replyToken;

var clientMessage = userData.events[0].message.text;

var clientID = userData.events[0].source.userId;

var QandO = [sheetData[0], sheetData[1]]; //取得題目和選項

var replyData = getUserAnswer(clientID, clientMessage);

switch (replyData[1]) {

case 0:

var replyMessage = finishTitle;

sendLineNotify("有人已通報消息，請立即查看!!");

break;

case 2:

var replyMessage = welcomeTitle + "\n\n" + QandO[0][replyData[1] - 1] + "\n\n" + QandO[1][replyData[1] - 1];

break;

default:

var replyMessage = QandO[0][replyData[1] - 1] + "\n\n" + QandO[1][replyData[1] - 1];

}

sendReplyMessage(CHANNEL_ACCESS_TOKEN, replyToken, replyMessage);

}

//傳送訊息給使用者

function sendReplyMessage(CHANNEL_ACCESS_TOKEN, replyToken, replyMessage) {

UrlFetchApp.fetch("https://api.line.me/v2/bot/message/reply", {

"headers": {

"Content-Type": "application/json; charset=UTF-8",

"Authorization": "Bearer " + CHANNEL_ACCESS_TOKEN,

},

"method": "post",

"payload": JSON.stringify({

"replyToken": replyToken,

"messages": [{

"type": "text",

"text":replyMessage,

}],

}),

});

}

//判斷使用者回答到第幾題

function getUserAnswer(clientID, clientMessage) {

var returnData = [];

for (var i = lastRow - 1; i >= 0; i--) {

if (sheetData[i][0] == clientID && sheetData[i][lastColumn - 1] == "") {

for (var j = 1; j <= lastColumn -1; j++) {

if (sheetData[i][j] == "") {break;}

}

sheet.getRange(i + 1, j + 1).setValue(clientMessage);

//如果使用者已經回答了最後一題，就把完成時間填上。不然就送出下一題給使用者

if (j + 2 == lastColumn) {

sheet.getRange(i + 1, lastColumn).setValue(Date());

returnData = [i + 1, 0];

}

else {

returnData = [i + 1, j + 2];

}

return returnData;

break;

}

}

//如果使用者還沒有回答過任何資料，就新增加一列在最後，把使用者ID輸入並開始送出題目

sheet.insertRowAfter(lastRow);

sheet.getRange(lastRow + 1, 1).setValue(clientID);

returnData = [lastRow + 1, 2];

return returnData;

}

function sendLineNotify(message){

var options =

{

"method" : "post",

"payload" : {"message" : message},

"headers" : {"Authorization" : "Bearer " + token}

};

UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);

}

//程式碼結束

請以 Line APP 掃描下面的QrCode，以進入通報系統。

MQTT 使用url 之 api

http://ai.prof-jj.com/MQTT/publish.php?topic=jjofficepc2&value=/close_windows&MQTT=broker.mqtt-dashboard.com