Created
May 28, 2020 07:47
-
-
Save krooluang/9affa735e08b39671814edc22e049120 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
var ss = SpreadsheetApp.openByUrl("##"); | |
var sheet = ss.getSheetByName("แผ่น1"); | |
function doPost(e) { | |
var data = JSON.parse(e.postData.contents) | |
var userMsg = data.originalDetectIntentRequest.payload.data.message.text; | |
var values = sheet.getRange(2, 2, sheet.getLastRow(),sheet.getLastColumn()).getValues(); | |
for(var i = 0;i<values.length; i++){ | |
if(values[i][0] == userMsg ){ | |
i=i+2; | |
var Name = sheet.getRange(i,2).getValue(); //ชื่อ สกุล | |
var Name2 = sheet.getRange(i,1).getValue(); //ชื่อ สกุลจริง | |
var classroom = sheet.getRange(i,3).getValue(); //ชั้น | |
var Data2 = sheet.getRange(i,4).getValue(); //เลขที่ | |
var Data3 = sheet.getRange(i,5).getValue(); //ชื่อเล่น | |
var Data4 = sheet.getRange(i,6).getValue(); //บ้านเลขที่ | |
var Data15 = sheet.getRange(i,7).getValue(); //ตำบล | |
var Data16 = sheet.getRange(i,8).getValue(); //อำเภอ | |
var Data17 = sheet.getRange(i,9).getValue(); //จังหวัด | |
var Data5 = sheet.getRange(i,10).getValue(); //เบอร์โทร | |
var Data6 = sheet.getRange(i,11).getValue(); //ID line | |
var Data7 = sheet.getRange(i,12).getValue(); //ชื่อบิดา | |
var Data8 = sheet.getRange(i,13).getValue(); //อาชีพ | |
var Data9 = sheet.getRange(i,14).getValue(); //เบอร์โทรพ่อ | |
var Data10 = sheet.getRange(i,15).getValue(); //ชื่อมารดา | |
var Data11 = sheet.getRange(i,16).getValue(); //อาชีพแม่ | |
var Data12 = sheet.getRange(i,17).getValue(); //เบอร์โทรแม่ | |
var Data13 = sheet.getRange(i,18).getValue(); //ผู้ปกครอง | |
var Data14 = sheet.getRange(i,19).getValue(); //ครูประจำชั้น | |
var Image = sheet.getRange(i,20).getValue(); //ภาพ | |
var result = { | |
"fulfillmentMessages": [ | |
{ | |
"platform": "line", | |
"type": 4, | |
"payload" : { | |
"line": { | |
"type": "flex", | |
"altText": "this is a flex message", | |
"contents": | |
{ | |
"type": "bubble", | |
"hero": { | |
"type": "image", | |
"url": Image, | |
"size": "full", | |
"aspectRatio": "1.51:1", | |
"aspectMode": "fit" | |
}, | |
"body": { | |
"type": "box", | |
"layout": "vertical", | |
"contents": [ | |
{ | |
"type": "text", | |
"text": ":: ข้อมูลนักเรียน ::", | |
"weight": "bold", | |
"align": "center", | |
"color": "#0000ff" | |
}, | |
{ | |
"type": "text", | |
"text": Name, | |
"weight": "bold", | |
"size": "xl", | |
"align": "center", | |
"color": "#ff0000" | |
}, | |
{ | |
"type": "text", | |
"text": "ชื่อ: "+Name2+"" | |
}, | |
{ | |
"type": "text", | |
"text": "ชั้น: "+classroom+"" | |
}, | |
{ | |
"type": "text", | |
"text": "เลขที่: "+Data2+"" | |
}, | |
{ | |
"type": "text", | |
"text": "ชื่อเล่น: "+Data3+" " | |
}, | |
{ | |
"type": "text", | |
"text": "บ้านเลขที่: "+Data4+" " | |
}, | |
{ | |
"type": "text", | |
"text": "ตำบล: "+Data15+" " | |
}, | |
{ | |
"type": "text", | |
"text": "อำเภอ: "+Data16+" " | |
}, | |
{ | |
"type": "text", | |
"text": "จังหวัด: "+Data17+" " | |
}, | |
{ | |
"type": "text", | |
"text": "เบอร์โทร: "+Data5+" " | |
}, | |
{ | |
"type": "text", | |
"text": "ID line: "+Data6+" " | |
}, | |
{ | |
"type": "text", | |
"text": "ชื่อบิดา: "+Data7+" " | |
}, | |
{ | |
"type": "text", | |
"text": "อาชีพบิดา: "+Data8+" " | |
}, | |
{ | |
"type": "text", | |
"text": "เบอร์โทรบิดา: "+Data9+" " | |
}, | |
{ | |
"type": "text", | |
"text": "ชื่อมารดา: "+Data10+" " | |
}, | |
{ | |
"type": "text", | |
"text": "อาชีพมารดา: "+Data11+" " | |
}, | |
{ | |
"type": "text", | |
"text": "เบอร์โทรมารดา: "+Data12+" " | |
}, | |
{ | |
"type": "text", | |
"text": "ผู้ปกครอง: "+Data13+" " | |
}, | |
{ | |
"type": "text", | |
"text": "ครูประจำชั้น: "+Data14+" " | |
}, | |
] | |
} | |
} | |
} | |
} | |
} | |
] | |
} | |
var replyJSON = ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON); | |
return replyJSON; | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment