def get(self):
try:
menu_count = Menu.all().count()
except:
menu_count = 0
if menu_count == 0:
deleteMenuAndUserGroup()
createMenuAndUserGroup()
memcache.flush_all()
self.redirect("/adm")
def deleteMenuAndUserGroup():
try:
for m in MenuMenuLink.all():
m.delete()
except:
pass
try:
for m in Menu.all():
m.delete()
except:
pass
try:
for m in UserGroup.all():
m.delete()
except:
pass
def post(self):
upload = self.request.get('file')
workbook = xlrd.open_workbook(file_contents=upload)
worksheet = workbook.sheet_by_name(self.SHEET_NAME)
rows = worksheet.nrows - 1
columns = worksheet.ncols - 1
current_column = 0
while current_column < columns - 1:
current_column += 1
current_row = self.START_OFFSET
while current_row < rows:
foods = []
date = None
for row in xrange(current_row, current_row + self.ROW_OFFSET):
cell_type = worksheet.cell_type(row, current_column)
cell_value = worksheet.cell_value(row, current_column)
if cell_type == 3: # datetime
date = datetime(*xlrd.xldate_as_tuple(cell_value, workbook.datemode)).date()
else:
foods.append(cell_value)
try:
menu = Menu.all() \
.filter('day =', int(date.day)) \
.filter('month =', int(date.month)) \
.filter('year =', int(date.year)) \
.get()
if menu is None:
menu = Menu()
menu.day = date.day
menu.month = date.month
menu.year = date.year
menu.foods = foods
menu.save()
except:
pass
current_row += self.ROW_OFFSET
self.response.write('Ok')
def getMenu(self, UserGroup_key, user_is_admin):
countMenu = 0
tmpMenu = ''
wrkMenu = ''
tmpTree_Menu = ''
wrkTree_Menu = ''
q = Menu.all().filter('Menutext ==', 'root')
root = q.fetch(1)[0]
for objMenuLink in root.menu_child_set.order('Menuseq'):
wrkMenu = ''
wrkTree_Menu = ''
objMenu = objMenuLink.Child_key
logging.info(
'Menutext: %s , menu_parent_set.count %s, menu_child_set.count %s'
% (objMenu.Menutext, objMenu.menu_parent_set.count(),
objMenu.menu_child_set.count()))
if objMenu.Menulink:
if not AuthUserGroupPath(objMenu.Menulink,
UserGroup_key.id_or_name(),
user_is_admin):
continue
if objMenu.menu_child_set.count() == 0:
"""No child menues """
if objMenu.Menulink:
if objMenu.Target == 'new':
wrkMenu += ' <TR><TD><P ONCLICK="SubTree(' + "'" + objMenu.Menulink + "', '" + 'new' + "'" + ')"><A HREF="' + '#' + '">' + objMenu.Menutext + '</A></P></TD></TR>\n'
else:
wrkMenu += ' <TR><TD><P><A HREF="' + objMenu.Menulink + '">' + objMenu.Menutext + '</A></P></TD></TR>\n'
else:
for objChildMenu in objMenu.menu_child_set.order('Menuseq'):
childfound = False
logging.info('objChildMenu.Child_key: %s' %
(objChildMenu.Child_key))
if objChildMenu.Child_key.Menulink:
if not AuthUserGroupPath(
objChildMenu.Child_key.Menulink,
UserGroup_key.id_or_name(), user_is_admin):
continue
else:
childfound = True
else:
childfound = True
if childfound:
if objChildMenu.Child_key.Target == 'new':
wrkTree_Menu += ' <TR><TD><P ONCLICK="SubTree(' + "'" + objChildMenu.Child_key.Menulink + "', '" + objChildMenu.Child_key.Target + "'" + ')"> <A HREF="' + '#' + '">' + objChildMenu.Child_key.Menutext + '</A></P></TD></TR>\n'
else:
wrkTree_Menu += ' <TR><TD><P> <A HREF="' + objChildMenu.Child_key.Menulink + '">' + objChildMenu.Child_key.Menutext + '</A></P></TD></TR>\n'
if wrkTree_Menu == '':
continue
"""Menu is now a valid parent"""
countMenu += 1
if countMenu == 1:
tmpMenu += ' <DIV ID="MainTree">\n'
tmpMenu += ' <TABLE BORDER="0" WIDTH="100%" BORDERCOLORLIGHT="#FFFF99" BORDERCOLORDARK="#FFFF99" CELLSPACING="0" STYLE="padding-top: 0; padding-bottom: 0">\n'
if not wrkMenu == '':
tmpMenu += wrkMenu
else:
tmpMenu += ' <TR><TD><P ID="Menu' + '%s' % (
objMenu.key().id_or_name()
) + '" ONCLICK="SubTreeShow(this)"><A HREF="#">' + objMenu.Menutext + '</A></P></TD></TR>\n'
tmpTree_Menu += ' <DIV ID="Tree_Menu' + '%s' % (
objMenu.key().id_or_name()) + '" STYLE="display: none">\n'
tmpTree_Menu += ' <TABLE BORDER="0" WIDTH="100%" BORDERCOLORLIGHT="#FFFF99" BORDERCOLORDARK="#FFFF99" CELLSPACING="0" STYLE="padding-top: 0; padding-bottom: 0">\n'
tmpTree_Menu += wrkTree_Menu
tmpTree_Menu += ' </TABLE>\n'
tmpTree_Menu += ' </DIV>\n'
if countMenu > 0:
tmpMenu += " </TABLE>\n"
tmpMenu += " </DIV>\n"
return tmpMenu + tmpTree_Menu
