def home(request):
db = None
try:
if request.method == 'POST':
db = dbhelper.DBHelper()
result_dict = {}
result_dict['hot_search_word'] = ['曼谷', '芭提雅', '清迈']
location_results = db.get_hot_search(1, 4)
hot_locations = []
for result in location_results:
content = {}
content['piciture'] = None if result[
'picture'] == None else result['picture'].split(';')[0]
content['scene_name'] = result['scene_name']
scores = db.get_score(result['scene_name'])
scores = scores['score'].split(',')
content['chi_score'] = scores[0] if scores[0] else 0
content['eng_score'] = scores[1] if scores[1] else 0
content['thai_score'] = scores[2] if scores[2] else 0
hot_locations.append(content)
result_dict['hot_location'] = hot_locations
travel_note_results = db.get_notes_list(1, 4)
result_dict['recommend_travel_notes'] = travel_note_results
return HttpResponse(json.dumps(result_dict))
else:
raise Exception()
except Exception as e:
print e.message
return HttpResponse('404 NOT FOUND!!')
def __init__(self, parent, account):
self.account = account
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="书籍借阅",
size=(300, 270),
style=style)
self.SetBackgroundColour("#FFFFFF")
self.HeadLine = wx.StaticText(self, -1, label="书籍借阅", pos=(80, 30))
self.HeadLine.SetFont(wx.Font(20, wx.DECORATIVE, wx.NORMAL, wx.BOLD))
wx.StaticText(self, -1, label="书籍编号", pos=(50, 100))
wx.StaticText(self, -1, label="注意：请根据查询结果输入要借阅的书籍编号", pos=(30, 180))
self.ID = wx.TextCtrl(self, -1, pos=(125, 100), size=(-1, 20))
confirm_button = wx.Button(self,
-1,
label="确认",
pos=(70, 150),
size=(50, 20))
exit_button = wx.Button(self,
-1,
label="退出",
pos=(160, 150),
size=(50, 20))
self.Bind(wx.EVT_BUTTON, self.Borrow, confirm_button)
self.Bind(wx.EVT_BUTTON, self.Exit, exit_button)
self.helper = dbhelper.DBHelper()
self.Show()
def check_user(message):
aux_db = dbhelper.DBHelper()
if not aux_db.get_user_by_id(message[-1].from_user.id):
aux_db.add_user(message[-1].from_user.id,
message[-1].from_user.first_name,
message[-1].from_user.last_name,
message[-1].from_user.username)
def get_travel_note_list(request):
db = None
try:
db = dbhelper.DBHelper()
index = request.GET.get('page', default=1)
result = db.get_notes_list(int(index))
return HttpResponse(result)
except Exception as e:
logger.error(e.message)
finally:
db.close()
def login(request):
db = None
try:
if request.method == 'POST':
db = dbhelper.DBHelper()
account = request.REQUEST.get('account', '')
password = request.REQUEST.get('password', '')
result = db.login(account, password)
return HttpResponse(json.dumps(result))
except Exception as e:
return HttpResponse('404 Not Found!')
def register(request):
db = None
try:
if request.method == 'POST':
db = dbhelper.DBHelper()
account = request.POST('account', '')
password = request.POST('password', '')
user_name = request.POST('user_name', '')
result = db.register(account, password, user_name)
return HttpResponse(json.dumps(result))
except Exception as e:
return HttpResponse('404 Not Found!')
def get_translation(request):
db = dbhelper.DBHelper()
try:
scene_name = request.GET.get('scene_name')
index = request.GET.get('index')
lang = request.GET.get('lang')
result = db.get_single_scene_comments(scene_name, index, lang)
return HttpResponse(json.dumps(result))
except Exception as e:
logger.error(e.message)
finally:
db.close()
def __init__(self, parent):
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="单册编辑",
size=(550, 250),
style=style)
self.SetFont(wx.Font(12, wx.DECORATIVE, wx.NORMAL, wx.NORMAL))
self.SetBackgroundColour("#FFFFFF")
wx.StaticText(self, label="书名", pos=(10, 10))
wx.StaticText(self, label="作者", pos=(150, 10))
wx.StaticText(self, label="出版社", pos=(300, 10))
wx.StaticText(self, label="数量", pos=(150, 75))
wx.StaticText(self, label="出版时间", pos=(300, 75))
wx.StaticText(self, label="类型", pos=(10, 75))
wx.StaticText(self, label="输入书籍ID", pos=(10, 125))
self.text1 = wx.TextCtrl(self, -1, pos=(45, 10), size=(100, 20)) #书名
self.text2 = wx.TextCtrl(self, -1, pos=(185, 10), size=(100, 20)) #作者
self.text3 = wx.TextCtrl(self, -1, pos=(350, 10), size=(130, 20)) #出版社
self.text4 = wx.TextCtrl(self, -1, pos=(185, 70), size=(100, 25)) #数量
self.text5 = wx.TextCtrl(self, -1, pos=(100, 125), size=(100, 20))
self.YearList = [str(x) for x in range(1970, 2019)]
self.TypeList = [
"计算机", "外语", "文学", "艺术", "经管", "人文社科", "少儿", "生活", "进口原版", "科技",
"考试", "离职", "学术", "古籍", "哲学", "旅游", "法律", "宗教", "历史", "地理", "政治",
"军事心理学", "传记", "工具书", "建筑", "才会", "教育", "医学", "电子电工", "农业", "文化",
"美食", "娱乐时尚", "青春文学", "机械", "美术", "经济", "化工", "汽车与交通运输", "健康",
"冶(yě)金", "服饰美容", "育儿", "通信", "管理", "摄影", "投资理财", "音乐", "少儿科普",
"家庭与办公", "儿童文学", "图象图形与多媒体", "程序设计"
]
self.List1 = wx.Choice(self,
-1, (370, 70),
size=(70, 25),
choices=self.YearList) #出版日期
self.List3 = wx.Choice(self,
-1, (45, 70),
size=(100, 25),
choices=self.TypeList) #种类
self.button1 = wx.Button(self, -1, label="编辑", pos=(200, 170))
self.button2 = wx.Button(self, -1, label="重置", pos=(300, 170))
self.button3 = wx.Button(self, -1, label="查找", pos=(40, 170))
self.button4 = wx.Button(self, -1, label="删除", pos=(400, 170))
self.Bind(wx.EVT_BUTTON, self.edit, self.button1) #入库
self.Bind(wx.EVT_BUTTON, self.clear, self.button2) #清空
self.Bind(wx.EVT_BUTTON, self.search, self.button3) #查找
self.Bind(wx.EVT_BUTTON, self.delete, self.button4) #删除
self.helper = dbhelper.DBHelper()
self.Show()
def __init__(self, parent):
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="账户管理",
size=(800, 600),
style=style)
self.SetBackgroundColour("#FFFFFF")
self.helper = dbhelper.DBHelper()
self.list = wx.ListCtrl(self,
-1,
size=(600, 400),
style=wx.LC_REPORT | wx.LC_HRULES
| wx.LC_VRULES)
self.list.InsertColumn(0, "用户名")
self.list.InsertColumn(1, "密码")
self.list.InsertColumn(2, "借书证")
self.list.InsertColumn(3, "可借本数")
self.list.InsertColumn(4, "已借本数")
self.list.SetColumnWidth(0, 150)
self.list.SetColumnWidth(1, 100)
self.list.SetColumnWidth(2, 100)
self.list.SetColumnWidth(3, 100)
self.list.SetColumnWidth(4, 120)
wx.StaticText(self, label="用户名", pos=(10, 450))
wx.StaticText(self, label="可借本数", pos=(180, 450))
self.text1 = wx.TextCtrl(self, -1, pos=(60, 450), size=(90, 20)) #用户名
self.text4 = wx.TextCtrl(self, -1, pos=(240, 450),
size=(50, 20)) #可借本数
self.grant_button = wx.Button(self,
-1,
label="授权/删除账号",
pos=(50, 500),
size=(100, 40))
self.edit_button = wx.Button(self,
-1,
label="编辑可借本数",
pos=(200, 500),
size=(100, 40))
self.clear_button = wx.Button(self,
-1,
label="重置",
pos=(350, 500),
size=(100, 40))
self.Bind(wx.EVT_BUTTON, self.grant, self.grant_button)
self.Bind(wx.EVT_BUTTON, self.clear, self.clear_button)
self.Bind(wx.EVT_BUTTON, self.edit, self.edit_button)
self.display()
self.Show()
def get_scene_comments(request):
db = dbhelper.DBHelper()
try:
scene_name = ''
if request.method == 'GET':
scene_name = request.GET["scene"]
offset = request.REQUEST.get('offset', '0')
lang = request.REQUEST.get('lang', 'chi')
comments = db.get_scene_comments(scene_name, int(offset), lang)
return HttpResponse(json.dumps(comments))
except Exception as e:
return HttpResponse('404 NOT FOUND!!')
finally:
db.close()
def search(request):
db = dbhelper.DBHelper()
search_word = None
index = 1
if request.method == 'POST':
search_word = request.POST['search_word']
return HttpResponseRedirect("?scene=" + search_word)
else:
search_word = request.GET["scene"]
index = request.REQUEST.get('page', '1')
status = db.check_word(search_word)
if status == 1:
results, max_page = db.get_scene_list(search_word, int(index))
pictureContent = []
for result in results:
content ={}
content['picSrc'] = None if result['picture'] == None else result['picture'].split(';')[0]
content['titleSrc'] = '../search/search/?scene=' + result['scene_name'] + "&page=1"
content['titleText'] = result['scene_name']
content['ch'] = 5
content['en'] = 5
content['th'] = 5
pictureContent.append(json.dumps(content))
return render(request, 'Search/sceneList.html', {'pictureContent': json.dumps(pictureContent),
'maxPage': max_page})
elif status == 0:
result = db.get_scene_content(search_word)
result_dict = {}
logger.info(result)
if result['picture'] != None:
pictures = result['picture'].split(';')
maxPic = 5 if len(pictures) > 5 else len(pictures)
result_dict['BigPic'] = pictures[0]
for i in range(1, maxPic):
result_dict['Simg' + str(i)] = pictures[i]
result_dict['totalEva'] = 5
result_dict['chEva'] = 5
result_dict['enEva'] = 5
result_dict['thEva'] = 5
result_dict['mainBody'] = result['introduction']
result_dict['title'] = result['scene_name']
result_dict['tag1'] = '美食'
result_dict['tag2'] = '好玩'
result_dict['tag3'] = '天堂'
# result_dict['comments'] = db.get_scene_comments(result['scene_name'])
return render(request, 'Search/detailCh.html', {'result_dict': json.dumps(result_dict)})
else:
return HttpResponse('404 NOT FOUND!!')
db.close()
def get_tag(scene_name):
db = None
try:
db = dbhelper.DBHelper()
all_tag = []
comments = db.get_scene_comments(scene_name, -1, 'chi')['comments']
all_tag += get_chi_tag(comments)
comments = db.get_scene_comments(scene_name, -1, 'thai')['comments']
all_tag += thaisegment.extract_tags(comments)
comments = db.get_scene_comments(scene_name, -1, 'eng')['comments']
all_tag += engsegment.extract_tags(comments)
return all_tag
except Exception as e:
logger.error(e.message)
finally:
db.close()
def get_travel_note(request):
db = None
try:
db = dbhelper.DBHelper()
id = request.GET.get('id')
if not id:
raise Exception()
else:
result = db.get_note(id)
if result:
return HttpResponse(result)
else:
raise Exception()
except Exception as e:
return HttpResponse('404 NOT FOUND!!')
finally:
db.close()
def __init__(self, parent):
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="注册账号",
size=(300, 300),
style=style)
self.SetBackgroundColour("#FFFFFF")
self.HeadLine = wx.StaticText(self, -1, label="账号注册", pos=(80, 30))
self.HeadLine.SetFont(wx.Font(20, wx.DECORATIVE, wx.NORMAL, wx.BOLD))
wx.StaticText(self, -1, label="用户名", pos=(50, 100))
wx.StaticText(self, -1, label="密码", pos=(50, 135))
wx.StaticText(self, -1, label="再次输入密码", pos=(50, 170))
wx.StaticText(self, -1, label="注意：账户注册后，需管理员授权后才能借书", pos=(30, 220))
self.account = wx.TextCtrl(self, -1, pos=(125, 100), size=(-1, 20))
self.password = wx.TextCtrl(self,
-1,
pos=(125, 135),
size=(-1, 20),
style=wx.TE_PASSWORD)
self.password_confirm = wx.TextCtrl(self,
-1,
pos=(125, 170),
size=(-1, 20),
style=wx.TE_PASSWORD)
confirm_button = wx.Button(self,
-1,
label="确认",
pos=(70, 200),
size=(50, 20))
exit_button = wx.Button(self,
-1,
label="退出",
pos=(160, 200),
size=(50, 20))
self.Bind(wx.EVT_BUTTON, self.CreateAcount, confirm_button)
self.Bind(wx.EVT_BUTTON, self.Exit, exit_button)
self.helper = dbhelper.DBHelper()
self.Show()
def __init__(self, parent, account):
self.account = account
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="借阅记录",
size=(800, 600),
style=style)
self.SetBackgroundColour("#FFFFFF")
self.helper = dbhelper.DBHelper()
self.list = wx.ListCtrl(self,
-1,
size=(600, 400),
style=wx.LC_REPORT | wx.LC_HRULES
| wx.LC_VRULES)
self.list.InsertColumn(0, "借阅编号")
self.list.InsertColumn(1, "书本编号")
self.list.InsertColumn(2, "书名")
self.list.InsertColumn(3, "借阅日期")
self.list.InsertColumn(4, "最晚归还日期")
self.list.InsertColumn(5, "归还时间")
self.list.SetColumnWidth(0, 100)
self.list.SetColumnWidth(1, 100)
self.list.SetColumnWidth(2, 100)
self.list.SetColumnWidth(3, 100)
self.list.SetColumnWidth(4, 100)
self.list.SetColumnWidth(5, 100)
wx.StaticText(self, label="借阅编号", size=(100, -1), pos=(10, 450))
self.text1 = wx.TextCtrl(self, -1, pos=(120, 450),
size=(90, 20)) #借阅编号
self.grant_button = wx.Button(self,
-1,
label="归还书籍",
pos=(50, 500),
size=(100, 40))
self.Bind(wx.EVT_BUTTON, self.returnBook, self.grant_button)
self.display()
self.Show()
def hot_search(request):
db = None
try:
index = request.GET.get('page', default=1)
db = dbhelper.DBHelper()
results = db.get_hot_search(int(index), 8)
result_content = []
for result in results:
content = {}
content['piciture'] = None if result[
'picture'] == None else result['picture'].split(';')[0]
# content['titleSrc'] = '../search/search?scene=' + result['scene_name']
content['scene_name'] = result['scene_name']
scores = db.get_score(result['scene_name'])
scores = scores['score'].split(',')
content['chi_score'] = scores[0] if scores[0] else 0
content['eng_score'] = scores[1] if scores[1] else 0
content['thai_score'] = scores[2] if scores[2] else 0
result_content.append(json.dumps(content))
return HttpResponse(json.dumps(result_content))
except Exception as e:
return HttpResponse('404 NOT FOUND!!')
def search_notes(request):
db = None
try:
db = dbhelper.DBHelper()
search_word = request.GET.get('search_word')
if not search_word:
raise Exception()
else:
# result = {}
notes_result = db.search_note(search_word)
if notes_result:
return HttpResponse(json.dumps(notes_result))
else:
raise Exception()
# result['search_word'] = search_word
# result['content'] = notes_result
# if result:
# return HttpResponse(json.dumps(result))
except Exception as e:
return HttpResponse('404 NOT FOUND!!')
finally:
db.close()
def search(request):
#数据库
db = dbhelper.DBHelper()
#搜索词
search_word = None
try:
if request.method == 'GET':
search_word = request.GET['search_word']
if not search_word:
raise Exception()
#检查search_word的语言类型，分别为chi,eng,thai
lang = check_search_word(search_word)
#将搜索词转换为中文，且检查该景点是否存在，是否是大小景点。
# 1为大景点，0为小景点，-1为找不到
status, search_word = db.check_word(search_word, lang)
result = {}
if status == 1:
temp_result = db.get_big_scene_content(search_word)
result['scene_name'] = temp_result['scene_name']
if temp_result['picture']:
result['picture'] = temp_result['picture'].split(';')
result['introduction'] = temp_result['introduction']
result['scene_num'] = len(temp_result['indices'])
result['recommend_scene'] = temp_result['recommend_scene']
return HttpResponse(json.dumps(result))
elif status == 0:
temp_result = db.get_small_scene_content(search_word)
if temp_result['picture']:
temp_result['picture'] = temp_result['picture'].split(';')
return HttpResponse(json.dumps(temp_result))
else:
raise Exception()
except Exception as e:
logger.error(e.message)
return HttpResponse('404 NOT FOUND!!')
finally:
db.close()
def __init__(self, parent):
wx.Frame.__init__(self, parent, title="批量入库", size=(300, 300))
self.helper = dbhelper.DBHelper()
Dia = wx.FileDialog(parent,
message="Choose a file",
defaultDir="C:\\Users\Sail\Desktop\DBLab5",
style=1)
L = self.helper.getMaxBookID()
if L != None and L[0] != None:
BookID = int(L[0]) + 1
else:
BookID = 10000
if Dia.ShowModal() == wx.ID_OK:
f = open(Dia.GetPath(), 'r')
num = 1
Book = Table.Book(BookID)
for line in f:
line.rstrip('\n')
line = line.split()
Book.setID(BookID)
Book.setName(line[0])
Book.setAuthor(line[1])
Book.setPress(line[2])
Book.setPressDate(line[3])
Book.setType(line[4])
Book.setNumber(line[5])
BookID = BookID + 1
self.helper.BookInsert(Book)
num = num + 1
print(line)
f.close()
result = wx.MessageDialog(self, message="导入成功", caption="导入结果")
result.ShowModal()
result.Destroy()
Dia.Destroy()
self.Destroy()
def __init__(self, parent):
self.User_Account = ""
self.sign = 0
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="登陆",
size=(300, 300),
style=style)
self.user_type = "游客"
self.SetBackgroundColour("#FFFFFF")
self.HeadLine = wx.StaticText(self, -1, label="登陆账号", pos=(80, 30))
self.HeadLine.SetFont(wx.Font(20, wx.DECORATIVE, wx.NORMAL, wx.BOLD))
wx.StaticText(self, -1, label="用户名", pos=(50, 100))
wx.StaticText(self, -1, label="密码", pos=(50, 135))
self.account = wx.TextCtrl(self, -1, pos=(125, 100), size=(-1, 20))
self.password = wx.TextCtrl(self,
-1,
pos=(125, 135),
size=(-1, 20),
style=wx.TE_PASSWORD)
self.confirm_button = wx.Button(self,
-1,
label="确认",
pos=(70, 200),
size=(50, 20))
self.exit_button = wx.Button(self,
-1,
label="退出",
pos=(160, 200),
size=(50, 20))
self.Bind(wx.EVT_BUTTON, self.login, self.confirm_button)
self.Bind(wx.EVT_BUTTON, self.exit, self.exit_button)
self.helper = dbhelper.DBHelper()
self.Show()
def get_scene_list(request):
db = dbhelper.DBHelper()
scene_name = None
offset = 0
try:
if request.method == 'GET':
scene_name = request.GET['scene_name']
offset = request.REQUEST.get('offset', '1')
if scene_name == None or offset == None:
raise Exception
temp_result = db.get_scene_list(scene_name, int(offset))
for t in temp_result:
t['picture'] = t['picture'].split(';')[0]
scores = t['score'].split(',')
t['chi_score'] = scores[0]
t['eng_score'] = scores[1]
t['thai_score'] = scores[2]
return HttpResponse(json.dumps(temp_result))
except Exception as e:
return HttpResponse('404 NOT FOUND!!')
finally:
db.close()
import dbhelper
import telegram
db = dbhelper.DBHelper()
def start(update, context):
"""
:param update: telegram.Update
:param context: telegram.Context
"""
update.message.reply_text(
'send any text and I will add it to your todo list')
def show_items(update, context):
"""
:param update: telegram.Update
:param context: telegram.Context
"""
items = db.get_items(update.message.chat_id)
keyboard = [[item] for item in items]
reply_markup = telegram.ReplyKeyboardMarkup(keyboard)
context.bot.send_message(chat_id=update.message.chat_id,
text='your todo stuff',
reply_markup=reply_markup)
def __init__(self, parent, User_Type, User_ID=""):
self.user = User_Type
self.UserID = User_ID
style = wx.DEFAULT_FRAME_STYLE ^ (wx.RESIZE_BORDER | wx.MAXIMIZE_BOX)
wx.Frame.__init__(self,
parent,
title="图书管理系统",
size=(810, 670),
style=style)
self.helper = dbhelper.DBHelper()
self.Book = Table.Book("")
self.SetBackgroundColour("#FFFFFF")
self.Top = wx.Panel(self, size=(770, 90), pos=(10, 10)) #顶端部分
self.Display = wx.Panel(self, size=(770, 300), pos=(10, 110)) #顶端部分
self.Search = wx.Panel(self, size=(500, 200), pos=(10, 420))
self.Switch = wx.Panel(self, size=(100, 200), pos=(600, 420))
#----------------------Top---------------------------------------------------
self.Top_text1 = wx.StaticText(self.Top, label="图书管理系统", pos=(10, 20))
self.Top_text1.SetFont(wx.Font(30, wx.DECORATIVE, wx.NORMAL, wx.BOLD))
self.time = wx.StaticText(
self.Top,
label="当前日期:" +
time.strftime('%Y-%m-%d', time.localtime(time.time())),
pos=(400, 70))
wx.StaticText(self.Top, label="当前用户:" + self.user, pos=(540, 70))
if self.user == "游客":
self.enroll = wx.Button(self.Top,
-1,
label="注册",
pos=(630, 68),
size=(50, 20))
self.login = wx.Button(self.Top,
-1,
label="登陆",
pos=(700, 68),
size=(50, 20))
self.Bind(wx.EVT_BUTTON, self.Sign, self.enroll)
self.Bind(wx.EVT_BUTTON, self.log, self.login)
else:
wx.StaticText(self.Top, label="用户名:" + User_ID, pos=(650, 70))
self.exit_button = wx.Button(self.Top,
-1,
label="退出",
pos=(680, 30),
size=(50, 20))
self.Bind(wx.EVT_BUTTON, self.exit, self.exit_button)
#---------------------------------Display-------------------------------------
self.list = wx.ListCtrl(self.Display,
-1,
size=(700, 280),
style=wx.LC_REPORT | wx.LC_HRULES
| wx.LC_VRULES)
self.list.InsertColumn(0, "书籍编号")
self.list.InsertColumn(1, "书名")
self.list.InsertColumn(2, "作者")
self.list.InsertColumn(3, "出版社")
self.list.InsertColumn(4, "出版时间")
self.list.InsertColumn(5, "书籍类型")
self.list.InsertColumn(6, "余量")
self.list.SetColumnWidth(0, 100)
self.list.SetColumnWidth(1, 120)
self.list.SetColumnWidth(2, 100)
self.list.SetColumnWidth(3, 80)
self.list.SetColumnWidth(4, 80)
self.list.SetColumnWidth(5, 80)
self.list.SetColumnWidth(6, 80)
#------------------------------Search----------------------------------
self.Search.SetFont(wx.Font(12, wx.DECORATIVE, wx.NORMAL, wx.NORMAL))
wx.StaticText(self.Search, label="书名", pos=(10, 10))
wx.StaticText(self.Search, label="作者", pos=(150, 10))
wx.StaticText(self.Search, label="出版社", pos=(300, 10))
wx.StaticText(self.Search, label="出版时间", pos=(250, 75))
wx.StaticText(self.Search, label="类型", pos=(10, 75))
wx.StaticText(self.Search, label="--", pos=(390, 75))
self.Search_text1 = wx.TextCtrl(self.Search,
-1,
pos=(45, 10),
size=(100, 20))
self.Search_text2 = wx.TextCtrl(self.Search,
-1,
pos=(185, 10),
size=(100, 20))
self.Search_text3 = wx.TextCtrl(self.Search,
-1,
pos=(350, 10),
size=(130, 20))
self.Search_checkBox1 = wx.CheckBox(self.Search,
-1,
"可租借",
pos=(170, 75))
self.YearList = [str(x) for x in range(1970, 2019)]
self.TypeList = [
"计算机", "外语", "文学", "艺术", "经管", "人文社科", "少儿", "生活", "进口原版", "科技",
"考试", "离职", "学术", "古籍", "哲学", "旅游", "法律", "宗教", "历史", "地理", "政治",
"军事心理学", "传记", "工具书", "建筑", "才会", "教育", "医学", "电子电工", "农业", "文化",
"美食", "娱乐时尚", "青春文学", "机械", "美术", "经济", "化工", "汽车与交通运输", "健康",
"冶(yě)金", "服饰美容", "育儿", "通信", "管理", "摄影", "投资理财", "音乐", "少儿科普",
"家庭与办公", "儿童文学", "图象图形与多媒体", "程序设计"
]
self.Search_List1 = wx.Choice(self.Search,
-1, (320, 75),
size=(70, 20),
choices=self.YearList)
self.Search_List2 = wx.Choice(self.Search,
-1, (410, 75),
size=(70, 20),
choices=self.YearList)
self.Search_List3 = wx.Choice(self.Search,
-1, (45, 70),
size=(100, 25),
choices=self.TypeList)
self.Search_button1 = wx.Button(self.Search,
-1,
label="搜索",
pos=(100, 120))
self.Search_button2 = wx.Button(self.Search,
-1,
label="重置",
pos=(220, 120))
self.Search_button1.Bind(wx.EVT_BUTTON, self.search)
self.Search_button2.Bind(wx.EVT_BUTTON, self.Search_Clear)
#---------------------------------------------------------------------------------
if self.user == "管理员": #管理员按钮
self.Switch_button1 = wx.Button(self.Switch,
-1,
label="单册入库",
pos=(10, 10))
self.Switch_button2 = wx.Button(self.Switch,
-1,
label="批量入库",
pos=(10, 50))
self.Switch_button3 = wx.Button(self.Switch,
-1,
label="单册编辑",
pos=(10, 90))
self.Switch_button4 = wx.Button(self.Switch,
-1,
label="用户管理",
pos=(10, 130))
self.Bind(wx.EVT_BUTTON, self.AddOne, self.Switch_button1)
self.Bind(wx.EVT_BUTTON, self.AddMul, self.Switch_button2)
self.Bind(wx.EVT_BUTTON, self.EditOne, self.Switch_button3)
self.Bind(wx.EVT_BUTTON, self.Manage, self.Switch_button4)
elif self.user == "用户": #用户按钮
self.Switch_button5 = wx.Button(self.Switch,
-1,
label="借阅书籍",
pos=(10, 10))
self.Switch_button6 = wx.Button(self.Switch,
-1,
label="借阅记录",
pos=(10, 70))
self.Bind(wx.EVT_BUTTON, self.BorrowBook, self.Switch_button5)
self.Bind(wx.EVT_BUTTON, self.BorrowRecord, self.Switch_button6)
self.Show()
def get_poleman_id():
db = dbhelper.DBHelper()
id = db.get_poleman_id()[0][0]
return id
def __init__(self):
self._dbo = dbhelper.DBHelper()
self.loginWindow()
import re
import utils
import json
import dash
from dateutil import parser
import pytz
from imageio import imread
import dbhelper
from dash.exceptions import PreventUpdate
import environment
import os
if os.environ.get('USE_DATABASE', False):
config_settings = dbhelper.parsed_config_file(filename=os.environ.get('DATABASE_CONFIG', 'config.ini'))
db_connection = dbhelper.DBHelper(config_settings)
DISPLAY_COLS = ['created_at', 'text', 'favorite_count', 'retweet_count', 'in_reply_to_status_id']
else:
with open(os.environ.get('PARSED_TWEETS_PATH', ''), 'r', encoding='utf-8') as fp:
res = json.loads(fp.read())
DISPLAY_COLS = ['created_at', 'text', 'favorite_count', 'retweet_count', 'in_reply_to_status_id_str']
selected_features_api_tweets = ['created_at', 'favorite_count', 'favorited', 'id_str',
'in_reply_to_screen_name', 'in_reply_to_status_id_str', 'lang',
'retweet_count', 'retweeted', 'source', 'text']
selected_features_api_users = ['created_at', 'friends_count', 'followers_count', 'protected']
def register_callbacks(app):
@app.callback(
[Output('tweet-data-table', 'data'),
Output('currently-showing-helper', 'children'),
def __init__(self):
self._dbObject = dbhelper.DBHelper()
super().__init__(self.loginHandler, self.regHandler)
def __init__(self):
self._dbObject = dbhelper.DBHelper()
super().__init__(self)
version = '1.1 stable release'
strikes = {'id': 0}
userIDs = {'owner': '319285994253975553', 'self': '442722388757446671'}
imgs = {
'avatar':
'https://avatars0.githubusercontent.com/u/14945942?s=400&u=\
563ecf361e3cc4d40074868152d10951ca5e85b2&v=4',
'sebas_profile':
'https://cdn.discordapp.com/attachments/44414784649363\
4560/444744084830289921/Sebas_Profile.png'
}
log = Logger()
emoji = EmojiHandler()
dbh = dbhelper.DBHelper()
# dictionary provides text files to look for
txt_f = {
'splash': 'txt/splash.txt',
'help': 'txt/help.txt',
'verify': 'txt/verify.txt',
'rhelp': 'txt/rhelp.txt',
'vrfres': 'txt/verify_response.txt',
'vrfres_m': 'txt/verify_response_manual.txt',
'v_chan_err': 'txt/verify_channel_set_error.txt',
'v_chan_success': 'txt/verify_channel_set_success.txt'
}
# default help string
helpstr = " Type `..help` for more information."
