def sendImgmap(event): #圖片地圖
try:
image_url = 'https://i.imgur.com/Yz2yzve.jpg' #圖片位址
imgwidth = 1040 #原始圖片寛度一定要1040
imgheight = 300
message = ImagemapSendMessage(
base_url=image_url,
alt_text="圖片地圖範例",
base_size=BaseSize(height=imgheight, width=imgwidth), #圖片寬及高
actions=[
MessageImagemapAction( #顯示文字訊息
text='你點選了紅色區塊！',
area=ImagemapArea( #設定圖片範圍:左方1/4區域
x=0,
y=0,
width=imgwidth * 0.25,
height=imgheight)),
URIImagemapAction( #開啟網頁
link_uri='http://www.e-happy.com.tw',
area=ImagemapArea( #右方1/4區域(藍色1)
x=imgwidth * 0.75,
y=0,
width=imgwidth * 0.25,
height=imgheight)),
])
line_bot_api.reply_message(event.reply_token, message)
except:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text='發生錯誤！'))
def googlemap_imagemap_view(text):
googlemap_geocoding_api_key = app.config['GOOGLE_MAP_API_KEY']
googlemap_geocoding_base_url = "https://maps.googleapis.com/maps/api/geocode/json?"
googlemap_geocoding_query = urllib.parse.urlencode({
"address":
text,
"key":
googlemap_geocoding_api_key
})
try:
req = requests.get(googlemap_geocoding_base_url +
googlemap_geocoding_query)
result = json.loads(req.text)
lat = result["results"][0]["geometry"]["location"]["lat"]
lng = result["results"][0]["geometry"]["location"]["lng"]
googlemap_staticmap_api_key = app.config['GOOGLE_STATIC_MAPS_API_KEY']
googlemap_staticmap_base_url = "https://maps.googleapis.com/maps/api/staticmap?"
googlemap_staticmap_query = urllib.parse.urlencode({
"center":
"%s,%s" % (lat, lng),
"size":
"520x520",
"sensor":
"false",
"scale":
2,
"maptype":
"roadmap",
"zoom":
18,
"markers":
"%s,%s" % (lat, lng),
"key":
googlemap_staticmap_api_key
})
googlemap_staticmap_url = googlemap_staticmap_base_url + googlemap_staticmap_query
view = ImagemapSendMessage(
base_url='https://{}/imagemap/{}'.format(
request.host,
urllib.parse.quote_plus(googlemap_staticmap_url)),
alt_text='googlemap',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
# link_uri='comgooglemaps://?ll=%f,%f&q=%s' % (lat, lng, text),
link_uri='http://maps.google.co.jp/maps?q=%f,%f' %
(lat, lng),
area=ImagemapArea(x=0, y=0, width=1040, height=1040))
])
except:
view = TextSendMessage(text="ん〜〜「%s」はGoogleMapにないなぁ..." % text)
return view
def setUp(self):
self.tested = LineBotApi('d42b9b5dc4df7ad44e9bddd5ee915fc7')
self.imagemap_message = ImagemapSendMessage(
base_url='https://example.com/base',
alt_text='this is an imagemap',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri='https://example.com/',
area=ImagemapArea(
x=0, y=0, width=520, height=1040
)
),
MessageImagemapAction(
text='hello',
area=ImagemapArea(
x=520, y=0, width=520, height=1040
)
)
]
)
self.message = [{
"type": "imagemap",
"baseUrl": "https://example.com/base",
"altText": "this is an imagemap",
"baseSize": {
"height": 1040,
"width": 1040
},
"actions": [
{
"type": "uri",
"linkUri": "https://example.com/",
"area": {
"x": 0,
"y": 0,
"width": 520,
"height": 1040
}
},
{
"type": "message",
"text": "hello",
"area": {
"x": 520,
"y": 0,
"width": 520,
"height": 1040
}
}
]
}]
def create_img_map_msg():
actions = []
actions.append(URIImagemapAction(
link_uri='line://app/1614481927-WbXaLGy0',
area=ImagemapArea(
x=0, y=0, width=520, height=520
)
))
actions.append(URIImagemapAction(
link_uri='line://app/1614481927-BqrGLbvl',
area=ImagemapArea(
x=0, y=520, width=520, height=520
)
))
actions.append(URIImagemapAction(
link_uri='line://app/1614481927-2N50kX34',
area=ImagemapArea(
x=520, y=0, width=520, height=520
)
))
actions.append(URIImagemapAction(
link_uri='line://app/1614481927-WLrPnOXQ',
area=ImagemapArea(
x=520, y=520, width=520, height=520
)
))
message = ImagemapSendMessage(
base_url='https://' + request.host + '/imagemap/' + uuid.uuid4().hex,
alt_text='こんにちは！',
base_size=BaseSize(height=1040, width=1040),
actions=actions
)
return message
def reply(request):
return ImagemapSendMessage(
base_url='https://example.com/base',
alt_text='this is an imagemap',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(link_uri='https://example.com/',
area=ImagemapArea(x=0,
y=0,
width=520,
height=1040)),
MessageImagemapAction(text='hello',
area=ImagemapArea(x=520,
y=0,
width=520,
height=1040))
])
def handle_follow(event):
sendMessage = [
TextSendMessage(text='首次加入的朋友，請先註冊才能進行查詢及申請。'),
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/1/',
alt_text='1',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri='https://dc10101.serveo.net/static/1/1040.png',
area=ImagemapArea(x=0, y=0, width=1040, height=1040)),
MessageImagemapAction(text='註冊',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
line_bot_api.reply_message(event.reply_token, sendMessage)
def get_ads_info():
photo_url = 'https://github.com/housekeepbao/flight_bot/blob/master/images/travel_test_img.png?raw=true'
link_url = 'https://www.google.com.tw/maps/place/%E5%8F%A4%E6%97%A9%E5%91%B3%E5%B0%8F%E5%90%83%E5%BA%97/@25.0629705,121.5012555,23.8z/data=!4m8!1m2!2m1!1z5Y-w5YyX5qmLIOe-jumjnw!3m4!1s0x3442a92298613293:0xcff4aac1356b306!8m2!3d25.0629585!4d121.50107?hl=zh-TW'
actions = [
URIImagemapAction(
link_uri=link_url,
area=ImagemapArea(
x=0, y=0, width=520, height=1024
)
),
MessageImagemapAction(
text='我是第二個區域',
area=ImagemapArea(
x=520, y=0, width=520, height=512
)
),
MessageImagemapAction(
text='我是第三個區域',
area=ImagemapArea(
x=520, y=512, width=520, height=1024
)
)
]
return photo_url, link_url, actions
#!/usr/bin/env python
# coding: utf-8
# In[ ]:
#小遊戲imagemap
from linebot.models import (ImagemapArea, BaseSize, URIImagemapAction,
MessageImagemapAction, ImagemapSendMessage)
game_imagemap_message = ImagemapSendMessage(
base_url='https://is.gd/b6IhTz',
alt_text='小遊戲',
base_size=BaseSize(height=624, width=1040),
actions=[
URIImagemapAction(link_uri="https://play.famobi.com/surfer-archers",
area=ImagemapArea(x=4, y=4, width=341, height=312)),
URIImagemapAction(
link_uri="https://play.famobi.com/highway-rider-extreme",
area=ImagemapArea(x=347, y=0, width=341, height=312)),
URIImagemapAction(link_uri="https://play.famobi.com/high-hills",
area=ImagemapArea(x=699, y=0, width=341,
height=312)),
URIImagemapAction(link_uri="https://play.famobi.com/pizza-ninja-3",
area=ImagemapArea(x=5, y=312, width=341,
height=312)),
URIImagemapAction(
link_uri="https://play.famobi.com/billiard-blitz-challenge",
area=ImagemapArea(x=349, y=312, width=341, height=312)),
URIImagemapAction(
link_uri="https://play.famobi.com/angry-flappy-wings",
area=ImagemapArea(x=692, y=312, width=341, height=312))
def text_message_user(self, reply_token, text_message, profile):
if not 'NotTest' in text_message:
message = TextSendMessage('(=OωO=)')
self.reply(reply_token, message)
return
user_id = profile.user_id
if user_id is None:
user_id = self._get_provider_id()
if user_id != self._get_provider_id():
message = TextSendMessage('にゃー！\n(Permission denied)')
self.reply(reply_token, message)
return
test_messages = [
TemplateSendMessage(
alt_text='Buttons template',
template=ButtonsTemplate(
thumbnail_image_url='https://example.com/image.jpg',
title='Menu',
text='Please select',
actions=[
PostbackTemplateAction(label='postback',
text='postback text',
data='action=buy&itemid=1'),
MessageTemplateAction(label='message',
text='message text'),
URITemplateAction(label='uri',
uri='http://example.com/')
])),
TemplateSendMessage(
alt_text='Confirm template',
template=ConfirmTemplate(
text='Are you sure?',
actions=[
PostbackTemplateAction(label='postback',
text='postback text',
data='action=buy&itemid=1'),
MessageTemplateAction(label='message',
text='message text')
])),
TemplateSendMessage(
alt_text='Carousel template',
template=CarouselTemplate(columns=[
CarouselColumn(
thumbnail_image_url='https://example.com/item1.jpg',
title='this is menu1',
text='description1',
actions=[
PostbackTemplateAction(label='postback1',
text='postback text1',
data='action=buy&itemid=1'),
MessageTemplateAction(label='message1',
text='message text1'),
URITemplateAction(label='uri1',
uri='http://example.com/1')
]),
CarouselColumn(
thumbnail_image_url='https://example.com/item2.jpg',
title='this is menu2',
text='description2',
actions=[
PostbackTemplateAction(label='postback2',
text='postback text2',
data='action=buy&itemid=2'),
MessageTemplateAction(label='message2',
text='message text2'),
URITemplateAction(label='uri2',
uri='http://example.com/2')
])
])),
TemplateSendMessage(
alt_text='ImageCarousel template',
template=ImageCarouselTemplate(columns=[
ImageCarouselColumn(
image_url='https://example.com/item1.jpg',
action=PostbackTemplateAction(
label='postback1',
text='postback text1',
data='action=buy&itemid=1')),
ImageCarouselColumn(
image_url='https://example.com/item2.jpg',
action=PostbackTemplateAction(
label='postback2',
text='postback text2',
data='action=buy&itemid=2'))
])),
ImagemapSendMessage(
base_url='https://example.com/base',
alt_text='this is an imagemap',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(link_uri='https://example.com/',
area=ImagemapArea(x=0,
y=0,
width=520,
height=1040)),
MessageImagemapAction(text='hello',
area=ImagemapArea(x=520,
y=0,
width=520,
height=1040))
])
]
self.reply(reply_token, test_messages)
return
def art(reply_token):
image_url1 = createUri('/static/pics/AI1.jpg')
image_url2 = createUri('/static/pics/PI1.jpg')
image_url3 = createUri('/static/pics/PI2.png')
image_url4 = createUri('/static/pics/PS2.jpg')
image_url5 = createUri('/static/pics/PS2-1.png')
image_url6 = createUri('/static/pics/PS3.jpg')
image_url7 = createUri('/static/pics/PS3-1.jpg')
image_url8 = createUri('/static/pics/PS5.jpg')
image_url9 = createUri('/static/pics/PS5-1.png')
imagemap_message1 = ImagemapSendMessage(
base_url=createUri('/static/pics/imagemap'),
alt_text='繪畫作品',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(link_uri=image_url1,
area=ImagemapArea(x=0,
y=0,
width=520,
height=520)),
URIImagemapAction(link_uri=image_url2,
area=ImagemapArea(x=520,
y=0,
width=520,
height=520)),
URIImagemapAction(link_uri=image_url3,
area=ImagemapArea(x=0,
y=520,
width=1040,
height=520))
])
imagemap_message2 = ImagemapSendMessage(
base_url=createUri('/static/pics/imagemap2'),
alt_text='修圖作品',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(link_uri=image_url4,
area=ImagemapArea(x=0,
y=0,
width=475,
height=325)),
URIImagemapAction(link_uri=image_url5,
area=ImagemapArea(x=565,
y=0,
width=475,
height=325)),
URIImagemapAction(link_uri=image_url6,
area=ImagemapArea(x=0,
y=325,
width=475,
height=325)),
URIImagemapAction(link_uri=image_url7,
area=ImagemapArea(x=565,
y=325,
width=475,
height=325)),
URIImagemapAction(link_uri=image_url8,
area=ImagemapArea(x=0,
y=650,
width=475,
height=390)),
URIImagemapAction(link_uri=image_url9,
area=ImagemapArea(x=565,
y=650,
width=475,
height=390))
])
line_bot_api.reply_message(reply_token,
[imagemap_message1, imagemap_message2])
from linebot.models import ImagemapArea
from linebot.models import ImagemapSendMessage
from linebot.models import MessageImagemapAction
from linebot.models import URIImagemapAction
imagemaps = [{
"id":
"example",
"payload":
ImagemapSendMessage(base_url='https://example.com/base',
alt_text='this is an imagemap',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(link_uri='https://example.com/',
area=ImagemapArea(x=0,
y=0,
width=520,
height=1040)),
MessageImagemapAction(text='hello',
area=ImagemapArea(
x=520,
y=0,
width=520,
height=1040))
])
}, {
"id":
"pulsa",
"payload":
ImagemapSendMessage(
base_url='https://bangjoni.com/pulsa_images/pulsa1',
def setUp(self):
self.tested = LineBotApi('channel_secret')
self.imagemap_message = ImagemapSendMessage(
base_url='https://example.com/base',
alt_text='this is an imagemap',
base_size=BaseSize(height=1040, width=1040),
video=Video(
original_content_url='https://example.com/video.mp4',
preview_image_url='https://example.com/video_preview.jpg',
area=ImagemapArea(
x=0, y=0, width=1040, height=585
),
external_link=ExternalLink(
link_uri='https://example.com/see_more.html',
label='See More',
),
),
actions=[
URIImagemapAction(
link_uri='https://example.com/',
area=ImagemapArea(
x=0, y=0, width=520, height=1040
)
),
MessageImagemapAction(
text='hello',
area=ImagemapArea(
x=520, y=0, width=520, height=1040
)
)
]
)
self.message = [{
"type": "imagemap",
"baseUrl": "https://example.com/base",
"altText": "this is an imagemap",
"baseSize": {
"height": 1040,
"width": 1040
},
"video": {
"originalContentUrl": "https://example.com/video.mp4",
"previewImageUrl": "https://example.com/video_preview.jpg",
"area": {
"x": 0,
"y": 0,
"width": 1040,
"height": 585
},
"externalLink": {
"linkUri": "https://example.com/see_more.html",
"label": "See More"
}
},
"actions": [
{
"type": "uri",
"linkUri": "https://example.com/",
"area": {
"x": 0,
"y": 0,
"width": 520,
"height": 1040
}
},
{
"type": "message",
"text": "hello",
"area": {
"x": 520,
"y": 0,
"width": 520,
"height": 1040
}
}
]
}]
def handle_message(event):
logging.error(event)
model = 'w2v.mod'
model_loaded = Word2Vec.load(model)
candidates = []
with open('target.txt', 'r', encoding='utf-8') as f:
for line in f:
candidates.append(line.strip().split())
Ans = []
with open('A.txt', 'r', encoding='utf-8') as fs:
for line in fs:
a = line.replace("\\n", " ")
Ans.append(a.strip())
if (event.message.text == "時價登錄"):
answer = " 請輸入欲查詢地區(只限台北市)，仿照下列格式 — 例: [台北市信義區] "
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=answer))
elif (event.message.text == "GPS定位功能"):
answer = " 只要上傳你的定位資訊，我們便會提供給你:\n該地區(限台北市)商業活絡程度及房屋資訊喔!!"
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=answer))
elif (event.message.text == "商業活絡程度"):
answer = " 請輸入欲查詢地區(只限台北市)，仿照下列格式 — 例: [台北市信義區資訊] "
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=answer))
elif ((len(event.message.text) == 10) and event.message.text[1:4] == "台北市"
and event.message.text[6] == "區" and event.message.text[0] == "["
and event.message.text[9] == "]"
and event.message.text[7:9] == '資訊'):
find = event.message.text[1:7]
uri = 'https://jshare.com.cn/temp/' + str(areafin(
find[3:6])) + '/share/pure'
answer = find + '的商業活絡程度請連結至以下網址: \n' + uri
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=answer))
elif ((len(event.message.text) == 8) and event.message.text[1:4] == "台北市"
and event.message.text[6] == "區" and event.message.text[0] == "["
and event.message.text[7] == "]"):
columns = []
House_Name = []
Price_Num = []
House_Site = []
House_Web = []
sqlsearch(event.message.text[1:7], House_Name, Price_Num, House_Site,
House_Web)
max_num = 0
if (len(House_Name) >= 10):
max_num = 10
else:
max_num = len(House_Name)
r2 = []
for i in range(0, len(House_Name), 1):
r2.append(i)
r1 = random.sample(r2, k=max_num)
count = 0
if (max_num > 0):
if (count == 0):
columns.append(
CarouselColumn(
# thumbnail_image_url=str(House_Img[count]),
title='台北市的標準住宅單價(萬元/坪)趨勢',
text='提供近幾年該地區的每坪價格的趨勢給你參考',
actions=[
URITemplateAction(
label='連結網址',
uri='https://www.itushuo.com/embed/wqgsi')
]))
count += 1
while (count < max_num - 1):
columns.append(
CarouselColumn(
# thumbnail_image_url=str(House_Img[count]),
title=str(House_Name[r1[count]]),
text='價錢:' + str(Price_Num[r1[count]]) + '萬元\n位置:' +
str(House_Site[r1[count]]),
actions=[
URITemplateAction(label='連結網址',
uri=str(House_Web[r1[count]]))
]))
count += 1
columns.append(
CarouselColumn(
# thumbnail_image_url=str(House_Img[count]),
title=str(House_Name[r1[count]]),
text='價錢:' + str(Price_Num[r1[count]]) + '萬元\n位置:' +
str(House_Site[r1[count]]),
actions=[
URITemplateAction(label='連結網址',
uri=str(House_Web[r1[count]]))
]))
logging.error(columns)
Carousel_template = TemplateSendMessage(
alt_text='Carousel template',
template=CarouselTemplate(columns))
line_bot_api.reply_message(event.reply_token, Carousel_template)
else:
ar = '抱歉沒有找到該地區房價，請搜尋其他地區!'
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=ar))
elif ((len(event.message.text) == 5)
and event.message.text[0:5] == "生活小幫手"):
imagemap_message = ImagemapSendMessage(
base_url='https://i.imgur.com/MNlaWgX.jpg',
alt_text='this is an imagemap',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://drive.google.com/open?id=1jyyA5J5OudRCsykJI4yWcqdXKoYgN3rY&usp=sharing',
area=ImagemapArea(x=0, y=0, width=519, height=440)),
URIImagemapAction(
link_uri=
'https://drive.google.com/open?id=1j9MZriaPTJVcQGzhGxNql2-uWOfII-vB&usp=sharing',
area=ImagemapArea(x=520, y=0, width=519, height=440)),
URIImagemapAction(
link_uri=
'https://drive.google.com/open?id=1hvKl65mWcmfDQRywnLsmcqJSgo3pJPTI&usp=sharing',
area=ImagemapArea(x=0, y=441, width=519, height=440)),
URIImagemapAction(
link_uri=
'https://drive.google.com/open?id=1CKWg04o8Sq-tEgbcVmWQZEf68CZJdJsI&usp=sharing',
area=ImagemapArea(x=520, y=441, width=519, height=440)),
])
line_bot_api.reply_message(event.reply_token, imagemap_message)
else:
while True:
text = event.message.text
words = list(jieba.cut(text.strip(), cut_all=False))
res = []
index = 0
for candidate in candidates:
# print candidate
score = model_loaded.n_similarity(words, candidate)
res.append(ResultInfo(index, score, " ".join(candidate)))
index += 1
res.sort(key=lambda x: x.score, reverse=True)
k = 0
count = 0
dans = ""
dans += "我們將從資料庫中找出幾筆最相關的Q&A給您\n"
for i in res:
k += 1
if i.score > 0.6:
dans += "Q" + str(count + 1) + " : " + (i.text) + "\n"
dans += "A" + str(count + 1) + " : " + Ans[i.id] + "\n"
count += 1
if k > 9 or count == 3:
break
if count == 0:
ans = "請換個方式問問看"
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=ans))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text=dans))
def handle_message(event):
#--將使用者發送的訊息儲存再msg變數
msg = event.message.text
msglist = event.message.text.split()
#--透過datetime取的目前UTC+8的時間，並且編排樣式
nowTime = (datetime.datetime.utcnow() +
datetime.timedelta(hours=8)).strftime("%Y-%m-%d %H:%M:%S")
today = (datetime.datetime.utcnow() +
datetime.timedelta(hours=8)).strftime("%Y-%m-%d")
week = (datetime.datetime.utcnow() + datetime.timedelta(hours=8) +
datetime.timedelta(days=6)).strftime("%Y-%m-%d")
#--透過LINE API取的使用者ID
UID = event.source.user_id
#--透過LINE API和使用者ID取的使用者資料
profile = line_bot_api.get_profile(UID)
#--透過使用者資料取得使用者的名稱
displayName = profile.display_name
#--透過使用者資料取的使用者的照片
pictureUrl = profile.picture_url
#--尚未註冊訊息回復
Not_registered = [
TextSendMessage(text="尚未註冊!"),
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/1/',
alt_text='1',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri='https://dc10101.serveo.net/static/1/1040.png',
area=ImagemapArea(x=0, y=0, width=1040, height=1040)),
MessageImagemapAction(text='註冊',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
if msg == "註冊":
if len(UID) > 0:
data = chk_user(UID)
if data is None:
sendMessage = [
TextSendMessage(text='尚未註冊!'),
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/1/',
alt_text='1',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://dc10101.serveo.net/static/1/1040.png',
area=ImagemapArea(x=0,
y=0,
width=1040,
height=1040)),
MessageImagemapAction(text='註冊',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
line_bot_api.reply_message(event.reply_token, sendMessage)
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="已經註冊過!"))
elif msglist[0] == "$註冊":
data = chk_user(UID)
if data is None:
if len(msglist) == 3:
SQL = "select Student_ID from basic_info where Del_YN='N' and cName='" + msglist[
1] + "' and Student_ID='" + msglist[2] + "'"
data = SQL_select(SQL)
if data is not None:
SQL = "INSERT INTO userdata (Line_UID,cName,Student_ID,AddDate) VALUES ('" + UID + "',N'" + msglist[
1] + "','" + msglist[2] + "','" + nowTime + "')"
SQL_commit(SQL)
line_bot_api.reply_message(
event.reply_token,
TextSendMessage(text="已完成註冊! 請在手機使用選單功能~"))
else:
line_bot_api.reply_message(
event.reply_token, TextSendMessage(text="您不符合註冊資格!"))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="資料不完整!"))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="已經註冊過!"))
elif msg == "課表查詢":
data = chk_user(UID)
if data is not None:
student_ID = chk_student_ID(UID)
Class = chk_class(student_ID)
SQL = "select Class,Date,Course,T_course from course_table where Del_YN='N' and Class='" + Class + "' and Date between '" + today + "' and '" + week + "' order BY Date"
data = SQL_select_all(SQL)
if data is not None:
Date = ""
for x in range(0, len(data)):
data2 = data[x]
T_course = list(str(data2[3]))
T_course_type = ""
for y in range(0, len(T_course)):
if T_course[y] == "1":
T_course_type = T_course_type + "上午 "
elif T_course[y] == "2":
T_course_type = T_course_type + "下午 "
elif T_course[y] == "3":
T_course_type = T_course_type + "夜間 "
Date = Date + "日期：" + str(
data2[1].strftime("%Y-%m-%d")) + "\n" + "課程名稱：" + str(
data2[2]) + " " + T_course_type + "\n\n"
content = "班級：" + str(Class) + "\n" + Date
line_bot_api.reply_message(event.reply_token,
TextSendMessage(content))
else:
content = str(today) + "~" + str(week) + " 沒課"
line_bot_api.reply_message(event.reply_token,
TextSendMessage(content))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "缺勤查詢":
data = chk_user(UID)
if data is not None:
student_ID = chk_student_ID(UID)
cName = data[1]
SQL = "select Hours,status from missing_class where Del_YN='N' and student_ID='" + student_ID + "'"
data = SQL_select_all(SQL)
if data is not None:
Absentee = 0
sick = 0
Casual = 0
Statutory = 0
Maternity = 0
Funeral = 0
for x in range(0, len(data)):
data2 = data[x]
if data2[1] == 0:
Absentee = int(Absentee) + int(data2[0])
elif data2[1] == 1:
sick = int(sick) + int(data2[0])
elif data2[1] == 2:
Casual = int(Casual) + int(data2[0])
elif data2[1] == 3:
Statutory = int(Statutory) + int(data2[0])
elif data2[1] == 4:
Maternity = int(Maternity) + int(data2[0])
elif data2[1] == 5:
Funeral = int(Funeral) + int(data2[0])
Count = int(Absentee) * 2 + int(sick) + int(Casual) + int(
Statutory) + int(Maternity) + int(Funeral)
content = "查詢人：" + cName + "\n" + "曠課時數：" + str(
Absentee) + "\n" + "病假時數：" + str(
sick) + "\n" + "事假時數：" + str(Casual) + "\n"
content = content + "公假時數：" + str(
Statutory) + "\n" + "娩假時數：" + str(
Maternity) + "\n" + "喪假時數：" + str(
Funeral) + "\n" + "缺勤總時數：" + str(Count)
line_bot_api.reply_message(event.reply_token,
TextSendMessage(content))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="無缺勤紀錄!"))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "維修申請":
data = chk_user(UID)
if data is not None:
buttons_template_message = TemplateSendMessage(
alt_text='維修申請選單',
template=ButtonsTemplate(
#thumbnail_image_url='',
title='維修申請選單',
text='請選擇',
actions=[
MessageAction(label='報修紀錄查詢', text='報修紀錄查詢'),
MessageAction(label='申請設備維修', text='申請設備維修')
]))
line_bot_api.reply_message(event.reply_token,
buttons_template_message)
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "報修紀錄查詢":
data = chk_user(UID)
if data is not None:
student_ID = chk_student_ID(UID)
SQL = "select Class,Student_ID,Device,Remark,Room,Seat,AddDate from device_service where Del_YN='N' and student_ID='" + student_ID + "' order BY AddDate desc"
data = SQL_select(SQL)
if data is not None:
cName_apply = chk_cName(data[1])
content = "最新一筆紀錄如下\n申請人班級：" + str(
data[0]) + "\n" + "申請者：" + str(
cName_apply) + "\n" + "報修設備：" + str(data[2]) + "\n"
content = content + "設備徵狀：" + str(
data[3]) + "\n" + "教室：" + str(
data[4]) + "\n" + "座位座標：" + str(
data[5]) + "\n" + "申請日期：" + str(
data[6].strftime("%Y-%m-%d"))
line_bot_api.reply_message(event.reply_token,
TextSendMessage(content))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="無報修紀錄!"))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "申請設備維修":
data = chk_user(UID)
if data is not None:
sendMessage = [
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/3/',
alt_text='3',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://dc10101.serveo.net/static/3/1040.png',
area=ImagemapArea(x=0,
y=0,
width=1040,
height=1040)),
MessageImagemapAction(text='維修',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
line_bot_api.reply_message(event.reply_token, sendMessage)
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msglist[0] == "$維修":
data = chk_user(UID)
if data is not None:
if len(msglist) == 5:
student_ID = chk_student_ID(UID)
Class = chk_class(student_ID)
SQL = "INSERT INTO device_service (Class,Student_ID,Device,Remark,Room,Seat,AddDate) VALUES ('" + Class + "','" + student_ID + "','" + msglist[
1] + "','" + msglist[2] + "','" + msglist[
3] + "','" + msglist[4] + "','" + nowTime + "')"
SQL_commit(SQL)
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="報修成功!"))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="資料不完整!"))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "機房申請":
data = chk_user(UID)
if data is not None:
sendMessage = [
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/5/',
alt_text='5',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://dc10101.serveo.net/static/5/1040.png',
area=ImagemapArea(x=0,
y=0,
width=1040,
height=1040)),
MessageImagemapAction(text='辦法',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
]),
TemplateSendMessage(
alt_text='機房申請選單',
template=ButtonsTemplate(
#thumbnail_image_url='',
title='機房申請選單',
text='請選擇',
actions=[
MessageAction(label='機房申請查詢', text='機房申請查詢'),
MessageAction(label='申請機房使用', text='申請機房使用'),
URIAction(label='機房借用情況一覽表',
uri='http://bit.ly/2E7emtS')
]))
]
line_bot_api.reply_message(event.reply_token, sendMessage)
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "機房申請查詢":
data = chk_user(UID)
if data is not None:
student_ID = chk_student_ID(UID)
Class = chk_class(student_ID)
SQL = "select Class,Student_ID,Date,Room,Pepole,AddDate from room_apply where Del_YN='N' and Class='" + Class + "' and Date>='" + today + "' order BY Date"
data = SQL_select(SQL)
if data is not None:
cName_apply = chk_cName(data[1])
Date = data[2].strftime("%Y-%m-%d")
content = "離本日最近一筆紀錄如下\n申請人班級：" + str(
data[0]) + "\n" + "申請者：" + str(
cName_apply) + "\n" + "使用日期：" + str(Date) + "\n"
content = content + "申請機房：" + str(
data[3]) + "\n" + "使用人數：" + str(
data[4]) + "\n" + "申請日期：" + str(
data[5].strftime("%Y-%m-%d"))
line_bot_api.reply_message(event.reply_token,
TextSendMessage(content))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="無機房申請紀錄!"))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "申請機房使用":
data = chk_user(UID)
if data is not None:
sendMessage = [
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/4/',
alt_text='4',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://dc10101.serveo.net/static/4/1040.png',
area=ImagemapArea(x=0,
y=0,
width=1040,
height=1040)),
MessageImagemapAction(text='機房',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
line_bot_api.reply_message(event.reply_token, sendMessage)
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msglist[0] == "$機房":
data = chk_user(UID)
if data is not None:
if len(msglist) == 4:
student_ID = chk_student_ID(UID)
Class = chk_class(student_ID)
if msglist[1] >= today:
if msglist[1] <= week:
if int(msglist[3]) > 5:
SQL = "select Date from room_apply where Del_YN='N' and Class='" + Class + "' and Date='" + msglist[
1] + "' and Room='" + msglist[2] + "'"
data = SQL_select(SQL)
if data is None:
SQL = "INSERT INTO room_apply (Class,Student_ID,Date,Room,Pepole,AddDate) VALUES ('" + Class + "','" + student_ID + "','" + msglist[
1] + "','" + msglist[2] + "','" + msglist[
3] + "','" + nowTime + "')"
SQL_commit(SQL)
line_bot_api.reply_message(
event.reply_token,
TextSendMessage(text="機房申請成功!"))
else:
line_bot_api.reply_message(
event.reply_token,
TextSendMessage(text="此日期的機房已被申請!"))
else:
line_bot_api.reply_message(
event.reply_token,
TextSendMessage(text="使用人數不得小於6人!"))
else:
line_bot_api.reply_message(
event.reply_token,
TextSendMessage(text="僅能申請一周內日期!"))
else:
line_bot_api.reply_message(
event.reply_token, TextSendMessage(text="不可申請過去日期!"))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="資料不完整!"))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "意見回饋":
data = chk_user(UID)
if data is not None:
sendMessage = [
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/2/',
alt_text='2',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://dc10101.serveo.net/static/2/1040.png',
area=ImagemapArea(x=0,
y=0,
width=1040,
height=1040)),
MessageImagemapAction(text='意見',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
line_bot_api.reply_message(event.reply_token, sendMessage)
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msglist[0] == "$意見":
data = chk_user(UID)
if data is not None:
if len(msglist) >= 2:
student_ID = chk_student_ID(UID)
Class = chk_class(student_ID)
cName = data[1]
content = msg[4:]
SQL = "SELECT COUNT(Student_ID) from feedback where Del_YN='N' and Student_ID='" + student_ID + "' AND DATE_FORMAT(AddDate, '%Y-%m-%d')='" + today + "'"
data = SQL_select(SQL)
if data[0] < 4:
SQL = "INSERT INTO feedback (Line_UID,Class,Student_ID,cName,content,AddDate) VALUES ('" + UID + "','" + Class + "','" + student_ID + "','" + cName + "',N'" + content + "','" + nowTime + "')"
SQL_commit(SQL)
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="意見發送成功!"))
else:
line_bot_api.reply_message(
event.reply_token, TextSendMessage(text="當日意見不可超過5次!"))
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="資料不完整!"))
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
elif msg == "test":
data = chk_user(UID)
if data is not None:
sendMessage = [
ImagemapSendMessage(
base_url='https://dc10101.serveo.net/static/1/',
alt_text='1',
base_size=BaseSize(height=1040, width=1040),
actions=[
URIImagemapAction(
link_uri=
'https://dc10101.serveo.net/static/1/1040.png',
area=ImagemapArea(x=0,
y=0,
width=1040,
height=1040)),
MessageImagemapAction(text='註冊',
area=ImagemapArea(x=520,
y=0,
width=50,
height=50))
])
]
line_bot_api.reply_message(event.reply_token, sendMessage)
else:
line_bot_api.reply_message(event.reply_token, Not_registered)
else:
data = chk_user(UID)
if data is None:
line_bot_api.reply_message(event.reply_token, Not_registered)
else:
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text="請使用功能選單!"))
def message_event(event):
if buttonRegex.search(event.message.text):
line_bot_api.reply_message(
event.reply_token,
TemplateSendMessage(
alt_text='Buttons template',
template=ButtonsTemplate(
thumbnail_image_url=demo_image_url,
title='Menu',
text='Please select',
actions=[
PostbackTemplateAction(
label='postback',
display_text='postback text',
data='action=buy&itemid=1'),
MessageTemplateAction(label='message',
text='message text'),
URITemplateAction(label='uri',
uri='http://example.com/')
])))
elif stickerRegex.search(event.message.text.lower()):
# https://developers.line.me/en/docs/messaging-api/reference/#sticker-message
# https://developers.line.me/media/messaging-api/sticker_list.pdf
line_bot_api.reply_message(
event.reply_token,
StickerSendMessage(package_id='1', sticker_id='116'))
elif imageRegex.search(event.message.text.lower()):
# https://developers.line.me/en/docs/messaging-api/reference/#image-message
line_bot_api.reply_message(
event.reply_token,
ImageSendMessage(
original_content_url=
f'{PUBLIC_URL}/static/images/spring.jpg',
preview_image_url=f'{PUBLIC_URL}/static/images/spring.jpg')
)
elif videoRegex.search(event.message.text.lower()):
# https://developers.line.me/en/docs/messaging-api/reference/#video-message
line_bot_api.reply_message(
event.reply_token,
VideoSendMessage(
original_content_url=
f'{PUBLIC_URL}/static/videos/linebot_video_sample.mp4',
preview_image_url=
f'{PUBLIC_URL}/static/images/video_preview.jpg'))
elif locationRegex.search(event.message.text.lower()):
# https://developers.line.me/en/docs/messaging-api/reference/#location-message
line_bot_api.reply_message(
event.reply_token,
LocationSendMessage(title='京都アスニー',
address='京都市中京区聚楽廻松下町9-2',
latitude=35.0190007,
longitude=135.7362375))
elif event.message.text == 'カルーセル':
# https://developers.line.me/en/docs/messaging-api/reference/#carousel
line_bot_api.reply_message(
event.reply_token,
TemplateSendMessage(
alt_text='Carousel template',
template=CarouselTemplate(columns=[
CarouselColumn(
thumbnail_image_url=
f'{PUBLIC_URL}/static/images/image_carousel_1.jpg',
title='マンホール',
text='函館、十字街電停周辺で見つけた',
actions=[
PostbackAction(label='いいね',
display_text='いいね！',
data='action=like&item_id=1'),
MessageAction(label='何かしらのラベル',
text='何かしらのメッセージ'),
URIAction(label='詳細を見る',
uri='http://example.com/1')
]),
CarouselColumn(
thumbnail_image_url=
f'{PUBLIC_URL}/static/images/image_carousel_2.jpg',
title='白鷺',
text='平安神宮で撮った白鷺',
actions=[
PostbackAction(label='いいね',
display_text='いいね！',
data='action=like&item_id=2'),
MessageAction(label='何かしらのラベル',
text='何かしらのメッセージ'),
URIAction(label='詳細を見る',
uri='http://example.com/2')
])
])))
elif event.message.text == 'イメージカルーセル':
# https://developers.line.me/en/docs/messaging-api/reference/#image-carousel
line_bot_api.reply_message(
event.reply_token,
TemplateSendMessage(
alt_text='ImageCarousel template',
template=ImageCarouselTemplate(columns=[
ImageCarouselColumn(
image_url=
f'{PUBLIC_URL}/static/images/image_carousel_1.jpg',
action=PostbackAction(
label='函館のマンホール',
display_text='いいね',
data='action=like&item_id=1')),
ImageCarouselColumn(
image_url=
f'{PUBLIC_URL}/static/images/image_carousel_2.jpg',
action=URIAction(
label='白鷺について',
uri=
'https://ja.wikipedia.org/wiki/%E7%99%BD%E9%B7%BA'
))
])))
elif event.message.text == 'アカウント連携':
try:
line = Line.objects.select_related('service_user').get(
pk=event.source.user_id)
if not line.is_active:
raise LineAccountInactiveError()
line_bot_api.reply_message(
event.reply_token,
TemplateSendMessage(
alt_text='すでに連携されています',
template=ConfirmTemplate(
text=
f'{line.service_user.username}さん、アカウント連携を解除しますか？',
actions=[
PostbackAction(
label='キャンセル',
display_text='アカウント連携を解除しない',
data='action=accountLink&confirm=0'),
PostbackAction(
label='解除',
display_text='アカウント連携を解除する',
data='action=accountLink&confirm=1')
])))
except (Line.DoesNotExist, LineAccountInactiveError):
response = requests.post(
f'https://api.line.me/v2/bot/user/{event.source.user_id}/linkToken',
headers=line_bot_api.headers).json()
if 'linkToken' not in response:
return
link_token = response['linkToken']
url = f'{PUBLIC_URL}{reverse("accounts:line_login_view", kwargs={"link_token": link_token})}'
line_bot_api.reply_message(event.reply_token, [
ImagemapSendMessage(
base_url=f'{PUBLIC_URL}/static/images',
alt_text='ImageMap sample.',
base_size=BaseSize(width=1040, height=520),
actions=[
URIImagemapAction(
link_uri=url,
area=ImagemapArea(
x=0, y=0, width=1040, height=520))
]),
TextSendMessage(f'連携解除機能の提供及び連携解除機能のユーザへの通知'),
])
elif event.message.text == '終わり':
image_url = f'{PUBLIC_URL}/static/images/finish_response.jpg'
line_bot_api.reply_message(
event.reply_token,
ImageSendMessage(original_content_url=image_url,
preview_image_url=image_url))
elif event.message.text == 'アカウント情報取得':
try:
line = Line.objects.select_related('service_user').get(
pk=event.source.user_id, is_active=True)
text = f'サービスユーザ名: {line.service_user.username}\nLINEユーザ名: {line.display_name}\n' \
f'ステータスメッセージ: {line.status_message}'
line_bot_api.reply_message(event.reply_token,
TextSendMessage(text))
except Line.DoesNotExist:
line_bot_api.reply_message(
event.reply_token,
TemplateSendMessage(
alt_text='アカウント連携しますか？',
template=ConfirmTemplate(
text=f'アカウントを連携することで情報取得ができるようになります。アカウントを連携しますか？',
actions=[
PostbackAction(label='キャンセル',
display_text='キャンセル',
data='action=skip'),
PostbackAction(label='連携',
text='アカウント連携',
data='action=skip')
])))
else:
line_bot_api.reply_message(
event.reply_token, TextSendMessage(text=event.message.text))
def handle_message(event):
if event.message.text == 'packages':
gc = get_credential(json_keyfile)
sheetkey = '15uhQm6tkd69dEthC-Vc9tb-Orsjnywlw85GOBsZgxmY'
sh = gc.open_by_key(sheetkey)
ws = sh.worksheet('packages')
df = DataFrame(ws.get_all_records())
bubbles = []
for idx, row in df.iterrows():
bubbles.append(
BubbleContainer(hero=ImageComponent(
layout='vertical',
url="https://drive.google.com/uc?id={}".format(
row['cover']),
size='full',
aspect_mode='cover',
aspect_ratio='20:13',
action=MessageAction(
label='Test List',
text='Tests will be shown here in the future.')),
body=BoxComponent(
layout='vertical',
contents=[
TextComponent(text=row['title'],
weight='bold',
size='xl',
wrap=True),
TextComponent(text=row['description'],
wrap=True,
color='#cfcecc')
]),
footer=BoxComponent(
layout='vertical',
contents=[
ButtonComponent(
MessageAction(label='รายการตรวจ',
text=row['code']))
])))
line_bot_mumthealth.reply_message(
event.reply_token,
FlexSendMessage(alt_text='Health Packages',
contents=CarouselContainer(contents=bubbles)))
elif event.message.text == 'health-services':
imageUrl = '1Z63x6wA08ATfWr1SgBCkMhiMbD3h2lhP'
line_bot_mumthealth.reply_message(
event.reply_token,
ImagemapSendMessage(
base_url='https://drive.google.com/uc?id={}&_ignored='.format(
imageUrl),
alt_text='Health Services',
base_size=BaseSize(width=1040, height=1040),
actions=[
MessageImagemapAction(text='packages',
area=ImagemapArea(x=122,
y=123,
width=381,
height=305)),
URIImagemapAction(
link_uri='https://liff.line.me/1655424321-ovYzaqOz',
area=ImagemapArea(x=124, y=430, width=377,
height=301)),
MessageImagemapAction(text='Available soon..',
area=ImagemapArea(x=126,
y=734,
width=374,
height=302)),
MessageImagemapAction(text='Available soon..',
area=ImagemapArea(x=507,
y=125,
width=435,
height=301)),
MessageImagemapAction(text='Available soon..',
area=ImagemapArea(x=508,
y=431,
width=434,
height=299)),
]))
elif event.message.text.startswith('pkg'):
gc = get_credential(json_keyfile)
sheetkey = '15uhQm6tkd69dEthC-Vc9tb-Orsjnywlw85GOBsZgxmY'
sh = gc.open_by_key(sheetkey)
ws = sh.worksheet('tests')
df = DataFrame(ws.get_all_records())
bubbles = []
total = 0
for idx, row in df.iterrows():
if row['package'] == event.message.text:
total += row['price']
bubbles.append(
BubbleContainer(body=BoxComponent(
layout='vertical',
contents=[
TextComponent(
text=row['test'],
weight='bold',
size='xl',
wrap=True,
align='center',
),
TextComponent(text=row['description'],
wrap=True,
gravity='center'),
FillerComponent(flex=2),
TextComponent(text=u'{} บาท'.format(row['price']),
wrap=True,
weight='bold',
size='xl',
gravity='bottom',
color='#4287f5',
align='center')
])))
if len(bubbles) > 0:
bubbles.append(
BubbleContainer(
body=BoxComponent(layout='vertical',
contents=[
FillerComponent(flex=2, ),
TextComponent(
text='รวม {} บาท'.format(total),
weight='bold',
size='xl',
gravity='center',
align='center',
color='#4287f5')
]),
footer=BoxComponent(
layout='vertical',
contents=[
ButtonComponent(action=URIAction(
label=u'นัดหมายเพื่อรับบริการ',
uri='https://liff.line.me/1655713713-L9yW3XWK')
),
ButtonComponent(action=MessageAction(
label=u'ข้อมูลเพิ่มเติม', text='Here you go!'))
])))
line_bot_mumthealth.reply_message(
event.reply_token,
FlexSendMessage(alt_text='Health Packages',
contents=CarouselContainer(contents=bubbles)))
else:
line_bot_mumthealth.reply_message(
event.reply_token,
TextSendMessage(text='Sorry, this feature will be available soon.'.
format(event.message.text)))
