예제 #1
0
 def get_group_video_list(self):
     qry = GroupMutilcatesQuery(
         """ v.videoId, v.title, v.tags, v.userId,v.href,v.flvHref,v.flvThumbNailHref,v.createDate,g.groupTitle,g.groupName """
     )
     qry.videoCateName = u"成果"
     qry.groupCateId = self.categoryId
     video_list = qry.query_map(4)
     request.setAttribute("video_list", video_list)
예제 #2
0
 def get_group_photo_list(self):
     qry = GroupMutilcatesQuery(
         """ p.photoId, p.title, p.tags, p.userId, p.createDate,p.href,g.groupTitle,g.groupName """
     )
     qry.photoCateName = u"成果"
     qry.groupCateId = self.categoryId
     photo_list = qry.query_map(4)
     request.setAttribute("photo_list", photo_list)
예제 #3
0
 def get_group_resource_list(self):
     qry = GroupMutilcatesQuery(
         """ r.resourceId, r.title,r.userId,r.downloadCount,r.createDate,r.href,g.groupTitle,g.groupName """
     )
     qry.resourceCateName = u"成果"
     qry.groupCateId = self.categoryId
     resource_list = qry.query_map(5)
     request.setAttribute("resource_list", resource_list)
예제 #4
0
 def get_group_article_list(self):
     qry = GroupMutilcatesQuery(
         """ a.articleId, a.title,a.userId,a.typeState,a.createDate,g.groupTitle,g.groupName """
     )
     qry.articleCateName = u"成果"
     qry.groupCateId = self.categoryId
     article_list = qry.query_map(5)
     request.setAttribute("article_list", article_list)
예제 #5
0
 def get_group_video_page_list(self):
     qry = GroupMutilcatesQuery(
         """ v.videoId, v.title, v.tags, v.userId,v.href,v.flvHref,v.flvThumbNailHref,v.createDate,g.groupTitle,g.groupName """
     )
     qry.videoCateName = u"成果"
     qry.groupCateId = self.categoryId
     pager = self.params.createPager()
     pager.itemName = u"视频"
     pager.itemUnit = u"个"
     pager.pageSize = 20
     pager.totalRows = qry.count()
     video_list = qry.query_map(pager)
     request.setAttribute("pager", pager)
     request.setAttribute("video_list", video_list)
예제 #6
0
 def get_group_photo_page_list(self):
     qry = GroupMutilcatesQuery(
         """ p.photoId, p.title, p.tags, p.userId, p.createDate,p.href,g.groupTitle,g.groupName """
     )
     qry.photoCateName = u"成果"
     qry.groupCateId = self.categoryId
     pager = self.params.createPager()
     pager.itemName = u"照片"
     pager.itemUnit = u"张"
     pager.pageSize = 20
     pager.totalRows = qry.count()
     photo_list = qry.query_map(pager)
     request.setAttribute("pager", pager)
     request.setAttribute("photo_list", photo_list)
예제 #7
0
 def get_group_resource_page_list(self):
     qry = GroupMutilcatesQuery(
         """ r.resourceId, r.title,r.userId,r.downloadCount,r.createDate,r.href,g.groupTitle,g.groupName """
     )
     qry.resourceCateName = u"成果"
     qry.groupCateId = self.categoryId
     pager = self.params.createPager()
     pager.itemName = u"文章"
     pager.itemUnit = u"篇"
     pager.pageSize = 20
     pager.totalRows = qry.count()
     resource_list = qry.query_map(pager)
     request.setAttribute("pager", pager)
     request.setAttribute("resource_list", resource_list)
예제 #8
0
 def get_group_article_page_list(self):
     qry = GroupMutilcatesQuery(
         """ a.articleId, a.title,a.userId,a.typeState,a.createDate,g.groupTitle,g.groupName """
     )
     qry.articleCateName = u"成果"
     qry.groupCateId = self.categoryId
     pager = self.params.createPager()
     pager.itemName = u"文章"
     pager.itemUnit = u"篇"
     pager.pageSize = 20
     pager.totalRows = qry.count()
     article_list = qry.query_map(pager)
     request.setAttribute("pager", pager)
     request.setAttribute("article_list", article_list)
예제 #9
0
    def execute(self):
        categoryService = __jitar__.categoryService

        groupName = request.getAttribute("groupName")
        if groupName == None or groupName == "":
            return self.notFound()
        group = group_svc.getGroupByName(groupName)
        if group == None:
            return self.notFound()
        widgetId = self.params.getIntParamZeroAsNull("widgetId")
        if widgetId == None:
            return self.notFound()
        groupMutil = self.group_svc.getGroupMutilByWidgetId(widgetId)

        gm = None
        if self.loginUser != None:
            gm = self.group_svc.getGroupMemberByGroupIdAndUserId(
                group.groupId, self.loginUser.userId)
        request.setAttribute("group_member", gm)

        #课题研究组的分类
        self.groupPrentId = None
        isKtGroup = 0
        uuid = self.group_svc.getGroupCateUuid(group)
        if uuid == CategoryService.GROUP_CATEGORY_GUID_KTYJ:
            #课题
            isKtGroup = 1
            request.setAttribute("isKtGroup", "1")
            #课题的文章资源图片视频需要把下级的汇聚过来
            self.groupPrentId = group.groupId
        elif uuid == CategoryService.GROUP_CATEGORY_GUID_JTBK:
            #备课
            isKtGroup = 2
            request.setAttribute("isKtGroup", "2")
        else:
            isKtGroup = 0
            request.setAttribute("isKtGroup", "0")

        cmd = self.params.getStringParam("cmd")
        if cmd == "savecate":
            self.savecate()
        elif cmd == "savetitle":
            self.savetitle()

        itemType = CommonUtil.toGroupArticleCategoryItemType(
            group.getGroupId())
        articleCate_tree = categoryService.getCategoryTree(itemType)
        itemType = CommonUtil.toGroupResourceCategoryItemType(
            group.getGroupId())
        resourceCate_tree = categoryService.getCategoryTree(itemType)
        itemType = CommonUtil.toGroupPhotoCategoryItemType(group.getGroupId())
        photoCate_tree = categoryService.getCategoryTree(itemType)
        itemType = CommonUtil.toGroupVideoCategoryItemType(group.getGroupId())
        videoCate_tree = categoryService.getCategoryTree(itemType)

        request.setAttribute("articleCate_tree", articleCate_tree)
        request.setAttribute("resourceCate_tree", resourceCate_tree)
        request.setAttribute("photoCate_tree", photoCate_tree)
        request.setAttribute("videoCate_tree", videoCate_tree)

        article_cateId = 0
        resource_cateId = 0
        photo_cateId = 0
        video_cateId = 0
        if groupMutil != None:

            article_cateId = groupMutil.articleCateId
            resource_cateId = groupMutil.resourceCateId
            photo_cateId = groupMutil.photoCateId
            video_cateId = groupMutil.videoCateId

            article_cateName = ""
            resource_cateName = ""
            photo_cateName = ""
            video_cateName = ""
            if isKtGroup == 1:
                cateArt = categoryService.getCategory(article_cateId)
                cateRes = categoryService.getCategory(resource_cateId)
                catePho = categoryService.getCategory(photo_cateId)
                cateVio = categoryService.getCategory(video_cateId)
                if cateArt != None:
                    article_cateName = cateArt.name
                if cateRes != None:
                    resource_cateName = cateRes.name
                if catePho != None:
                    photo_cateName = catePho.name
                if cateVio != None:
                    video_cateName = cateVio.name
            qry1 = GroupMutilcatesQuery(
                """ v.videoId, v.title, v.tags, v.userId,v.href,v.flvHref,v.flvThumbNailHref,g.groupTitle,g.groupName """
            )
            if isKtGroup == 1:
                if video_cateName != "":
                    qry1.videoCateName = video_cateName
                else:
                    if groupMutil.videoCateId == None:
                        qry1.videoCateId = 0
                    else:
                        qry1.videoCateId = groupMutil.videoCateId
                qry1.groupPrentId = self.groupPrentId
            else:
                if groupMutil.videoCateId == None:
                    qry1.videoCateId = 0
                else:
                    qry1.videoCateId = groupMutil.videoCateId
                qry1.widgetId = widgetId
            video_list = qry1.query_map(groupMutil.videoNumShow)
            request.setAttribute("video_list", video_list)

            qry2 = GroupMutilcatesQuery(
                """ p.photoId, p.title, p.tags, p.userId,p.isPrivateShow, p.createDate,p.href,g.groupTitle,g.groupName """
            )
            if isKtGroup == 1:
                if photo_cateName != "":
                    qry2.photoCateName = photo_cateName
                else:
                    if groupMutil.photoCateId == None:
                        qry2.photoCateId = 0
                    else:
                        qry2.photoCateId = groupMutil.photoCateId
                qry2.groupPrentId = self.groupPrentId
            else:
                if groupMutil.photoCateId == None:
                    qry2.photoCateId = 0
                else:
                    qry2.photoCateId = groupMutil.photoCateId
                qry2.widgetId = widgetId
            photo_list = qry2.query_map(groupMutil.photoNumShow)
            request.setAttribute("photo_list", photo_list)

            qry3 = GroupMutilcatesQuery(
                """ a.articleId, a.title, a.userId ,a.createDate,a.typeState,g.groupTitle,g.groupName """
            )
            if isKtGroup == 1:
                if article_cateName != "":
                    qry3.articleCateName = article_cateName
                else:
                    if groupMutil.articleCateId == None:
                        qry3.articleCateId = 0
                    else:
                        qry3.articleCateId = groupMutil.articleCateId
                qry3.groupPrentId = self.groupPrentId
            else:
                if groupMutil.articleCateId == None:
                    qry3.articleCateId = 0
                else:
                    qry3.articleCateId = groupMutil.articleCateId
                qry3.widgetId = widgetId
            article_list = qry3.query_map(groupMutil.articleNumShow)
            request.setAttribute("article_list", article_list)

            qry4 = GroupMutilcatesQuery(
                """ r.resourceId, r.title,r.userId,r.createDate,g.groupTitle,g.groupName """
            )
            if isKtGroup == 1:
                if resource_cateName != "":
                    qry4.resourceCateName = resource_cateName
                else:
                    if groupMutil.resourceCateId == None:
                        qry4.resourceCateId = 0
                    else:
                        qry4.resourceCateId = groupMutil.resourceCateId
                qry4.groupPrentId = self.groupPrentId
            else:
                if groupMutil.resourceCateId == None:
                    qry4.resourceCateId = 0
                else:
                    qry4.resourceCateId = groupMutil.resourceCateId
                qry4.widgetId = widgetId
            resource_list = qry4.query_map(groupMutil.resourceNumShow)
            request.setAttribute("resource_list", resource_list)

        widget = self.page_svc.getWidget(widgetId)
        request.setAttribute("widget", widget)
        request.setAttribute("groupMutil", groupMutil)

        request.setAttribute("article_cateId", article_cateId)
        request.setAttribute("resource_cateId", resource_cateId)
        request.setAttribute("photo_cateId", photo_cateId)
        request.setAttribute("video_cateId", video_cateId)

        request.setAttribute("group", group)
        request.setAttribute("widgetId", widgetId)
        response.contentType = "text/html; charset=UTF-8"
        return "/WEB-INF/group/default/group_mutilcates.ftl"
예제 #10
0
    def execute(self):
        self.params = ParamUtil(request)
        categoryService = __jitar__.categoryService

        response.setContentType("text/html; charset=UTF-8")
        groupName = request.getAttribute("groupName")
        if groupName == None or groupName == "":
            return ""

        group = self.group_svc.getGroupByName(groupName)
        if group == None:
            return self.notFound()
        widgetId = self.params.getIntParamZeroAsNull("widgetId")
        if widgetId == None:
            return self.notFound()
        groupMutil = self.group_svc.getGroupMutilByWidgetId(widgetId)

        page = self.getGroupIndexPage(group)
        page = {
            "pageId": 0,
            "layoutId": 2,  # 固定是布局2
            "isSystemPage": "true",
            "owner": "user",
            "title": "",
            "skin": page.skin
        }

        self.groupPrentId = None
        isKtGroup = 0

        uuid = self.group_svc.getGroupCateUuid(group)
        if uuid == CategoryService.GROUP_CATEGORY_GUID_KTYJ:
            #课题
            request.setAttribute("isKtGroup", "1")
            isKtGroup = 1
            #课题的文章资源图片视频需要把下级的汇聚过来
            self.groupPrentId = group.groupId

            # 构造widgets .
            widgets = [{
                "id": "1",
                "pageId": 0,
                "columnIndex": 1,
                "title": u"课题介绍",
                "module": "group_info",
                "ico": "",
                "data": ""
            }]
        elif uuid == CategoryService.GROUP_CATEGORY_GUID_JTBK:
            #备课
            isKtGroup = 2
            request.setAttribute("isKtGroup", "2")
            # 构造widgets .
            widgets = [{
                "id": "1",
                "pageId": 0,
                "columnIndex": 1,
                "title": u"备课组信息",
                "module": "group_info",
                "ico": "",
                "data": ""
            }]
        else:
            isKtGroup = 0
            request.setAttribute("isKtGroup", "0")
            # 构造widgets .
            widgets = [{
                "id": "1",
                "pageId": 0,
                "columnIndex": 1,
                "title": u"协作组信息",
                "module": "group_info",
                "ico": "",
                "data": ""
            }]

        self.getGroupInfo(group.groupName)
        request.setAttribute("widget_list", widgets)
        request.setAttribute("widgets", widgets)
        request.setAttribute("page", page)

        if groupMutil != None:

            article_cateId = groupMutil.articleCateId
            resource_cateId = groupMutil.resourceCateId
            photo_cateId = groupMutil.photoCateId
            video_cateId = groupMutil.videoCateId

            article_cateName = ""
            resource_cateName = ""
            photo_cateName = ""
            video_cateName = ""
            if isKtGroup == 1:
                cateArt = categoryService.getCategory(article_cateId)
                cateRes = categoryService.getCategory(resource_cateId)
                catePho = categoryService.getCategory(photo_cateId)
                cateVio = categoryService.getCategory(video_cateId)
                if cateArt != None:
                    article_cateName = cateArt.name
                if cateRes != None:
                    resource_cateName = cateRes.name
                if catePho != None:
                    photo_cateName = catePho.name
                if cateVio != None:
                    video_cateName = cateVio.name

            qry1 = GroupMutilcatesQuery(
                """ v.videoId, v.title, v.tags, v.userId,v.href,v.flvHref,v.flvThumbNailHref,g.groupTitle,g.groupName,v.createDate """
            )
            if isKtGroup == 1:
                if video_cateName != "":
                    qry1.videoCateName = video_cateName
                else:
                    qry1.videoCateId = groupMutil.videoCateId
                qry1.groupPrentId = self.groupPrentId
            else:
                qry1.videoCateId = groupMutil.videoCateId
                qry1.widgetId = widgetId

            video_list = qry1.query_map()
            request.setAttribute("video_list", video_list)

            qry2 = GroupMutilcatesQuery(
                """ p.photoId, p.title, p.tags, p.userId,p.isPrivateShow, p.createDate,p.href,g.groupTitle,g.groupName,p.createDate """
            )
            if isKtGroup == 1:
                if photo_cateName != "":
                    qry2.photoCateName = photo_cateName
                else:
                    qry2.photoCateId = groupMutil.photoCateId
                qry2.groupPrentId = self.groupPrentId
            else:
                qry2.photoCateId = groupMutil.photoCateId
                qry2.widgetId = widgetId
            photo_list = qry2.query_map()
            request.setAttribute("photo_list", photo_list)

            qry3 = GroupMutilcatesQuery(
                """ a.articleId, a.title,a.userId,g.groupTitle,g.groupName,a.createDate,a.typeState """
            )
            if isKtGroup == 1:
                if article_cateName != "":
                    qry3.articleCateName = article_cateName
                else:
                    qry3.articleCateId = groupMutil.articleCateId
                qry3.groupPrentId = self.groupPrentId
            else:
                qry3.articleCateId = groupMutil.articleCateId
                qry3.widgetId = widgetId
            article_list = qry3.query_map()
            request.setAttribute("article_list", article_list)

            qry4 = GroupMutilcatesQuery(
                """ r.resourceId, r.title,r.userId,g.groupTitle,g.groupName,r.createDate """
            )
            if isKtGroup == 1:
                if resource_cateName != "":
                    qry4.resourceCateName = resource_cateName
                else:
                    qry4.resourceCateId = groupMutil.resourceCateId
                qry4.groupPrentId = self.groupPrentId
            else:
                qry4.resourceCateId = groupMutil.resourceCateId
                qry4.widgetId = widgetId
            resource_list = qry4.query_map()
            request.setAttribute("resource_list", resource_list)

        widget = self.page_svc.getWidget(widgetId)
        request.setAttribute("widget", widget)
        request.setAttribute("groupMutil", groupMutil)
        request.setAttribute("group", group)
        return "/WEB-INF/group/default/show_more_group_mutilcates.ftl"