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