def get_video_category(self): video_cates = self.get_video_category_ex() # 得到每个分类的最新的 6 张视频 qry = VideoQuery( " v.videoId, v.title, v.href,u.loginName,v.flvThumbNailHref") for c in video_cates: qry.sysCateTitle = c["categoryName"] c["video_list"] = qry.query_map(5) #如果没有分类,则显示当前的全部图片 if len(video_cates) == 0: video_cates = None pager = self.params.createPager() pager.itemName = u"视频" pager.itemUnit = u"个" pager.pageSize = 24 qry = VideoQuery( " v.videoId, v.title, v.createDate, v.href, v.userId, u.loginName, v.flvThumbNailHref " ) qry.orderType = 0 pager.totalRows = qry.count() video_list_all = qry.query_map(pager) request.setAttribute("video_list_all", video_list_all) request.setAttribute("pager", pager) request.setAttribute("video_cates", video_cates)
def get_method(self): self.collectionQueryString() qry = VideoQuery( """ v.title, v.videoId, v.flvThumbNailHref, v.createDate, v.href, v.flvHref, v.categoryId, v.addIp, v.typeState, v.userId, v.auditState,u.loginName """) qry.subjectId = self.subject.metaSubject.msubjId qry.gradeId = self.subject.metaGrade.gradeId if self.approveState == "" or self.approveState.isdigit() == False: qry.auditState = None else: qry.auditState = int(self.approveState) qry.k = self.params.safeGetStringParam("k") qry.f = self.params.safeGetStringParam("f") pager = self.params.createPager() pager.itemName = u"视频" pager.itemUnit = u"个" pager.pageSize = 25 pager.totalRows = qry.count() video_list = qry.query_map(pager) request.setAttribute("video_list", video_list) request.setAttribute("pager", pager) request.setAttribute("subject", self.subject) request.setAttribute("k", qry.k) request.setAttribute("f", qry.f) return "/WEB-INF/subjectmanage/video.ftl"
def genernate_jiaoyanshipin_content(self, webpart): cache_key = "sbj" + str(self.subject.subjectId) + "_" + str( webpart.getSubjectWebpartId()) + self.cacheKeyFix content = cache.get(cache_key) if content != None: request.setAttribute(cache_key, content) return map = HashMap() qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, u.nickName, v.summary,v.flvThumbNailHref """ ) qry.orderType = VideoQuery.ORDER_TYPE_VIDEOID_DESC qry.subjectId = self.metaSubjectId qry.gradeId = self.metaGradeId if self.unitId != None and self.unitId != 0: qry.unitId = self.unitId new_video_list = qry.query_map(4) map.put("new_video_list", new_video_list) map.put("subject", self.subject) map.put("SubjectRootUrl", self.subjectRootUrl) map.put("webpart", webpart) map.put("unitId", self.unitId) content = self.templateProcessor.processTemplate( map, "/WEB-INF/subjectpage/" + self.templateName + "/video.ftl", "utf-8") request.setAttribute(cache_key, content) cache.put(cache_key, content)
def get_new_video_list(self): qry = VideoQuery( " v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, v.flvThumbNailHref " ) qry.orderType = VideoQuery.ORDER_TYPE_VIDEOID_DESC new_video_list = qry.query_map(10) request.setAttribute("new_video_list", new_video_list)
def execute(self): type = self.params.safeGetStringParam("type") qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, u.nickName, v.summary,v.flvThumbNailHref """ ) if type == "hot": qry.orderType = VideoQuery.ORDER_TYPE_VIEWCOUNT_DESC else: qry.orderType = VideoQuery.ORDER_TYPE_VIDEOID_DESC t = u"最新上传" if type == "hot": t = u"热门排行" elif type == "search": t = u"关键字:" + qry.k pager = self.createPager() pager.totalRows = qry.count() video_list = qry.query_map(pager) request.setAttribute("video_list", video_list) request.setAttribute("t", t) request.setAttribute("type", type) request.setAttribute("pager", pager) request.setAttribute("head_nav", "videos") return "/WEB-INF/ftl/site_video_list.ftl"
def video_list(self): qry = VideoQuery( " v.videoId, v.flvHref, v.flvThumbNailHref, v.title,v.userId,v.createDate" ) qry.specialSubjectId = self.specialSubject.specialSubjectId v_list = qry.query_map(5) if len(v_list) > 0: request.setAttribute("video_list", v_list)
def get_video_querylist(self): qry = VideoQuery( " v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, v.flvThumbNailHref,v.auditState " ) qry.auditState = None qry.orderType = VideoQuery.ORDER_TYPE_VIDEOID_DESC vIds = self.params.getStringParam("id") qry.videoIds = vIds video_list = qry.query_map() request.setAttribute("video_list", video_list)
def get_video_list(self): qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, u.nickName, v.summary,v.flvThumbNailHref """ ) qry.orderType = VideoQuery.ORDER_TYPE_VIDEOID_DESC qry.unitId = self.unit.unitId pager = self.createPager() pager.totalRows = qry.count() video_list = qry.query_map(pager) request.setAttribute("video_list", video_list) request.setAttribute("pager", pager)
def get_hot_video_list(self): cache_key = "video_hot_list" hot_video_list = cache.get(cache_key) if hot_video_list == None: qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, u.trueName, v.flvThumbNailHref """ ) qry.orderType = VideoQuery.ORDER_TYPE_VIEWCOUNT_DESC hot_video_list = qry.query_map(8) cache.put(cache_key, hot_video_list) request.setAttribute("hot_video_list", hot_video_list)
def execute(self): params = ParamUtil(request) self.userName = params.safeGetStringParam("loginName") title = params.safeGetStringParam("title") userCateId = params.safeGetIntParam("userCateId") #print "-----------------------------category_video.py-----------------------------" #print "self.userName="******"title="+title #print "userCateId="+str(userCateId) if userCateId == 0: response.getWriter().write( u"<div style='text-align:center;'>请选择一个个人视频分类。</div>") return fc = FileCache() content = fc.getUserFileCacheContent( self.userName, "category_video_" + str(userCateId) + ".html", 30) if content != "": response.getWriter().write(content) fc = None return count = params.safeGetIntParam("count") if count == 0: count = 9 #print "count="+str(count) user = __jitar__.userService.getUserByLoginName(self.userName) if user == None: response.getWriter().write(u"不能加载当前用户。") return qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, u.nickName, v.summary,v.flvThumbNailHref """ ) qry.userCateId = userCateId qry.userId = user.userId video_list = qry.query_map(count) templateProcessor = __spring__.getBean("templateProcessor") map = HashMap() map.put("video_list", video_list) map.put("UserSiteUrl", self.getUserSiteUrl()) map.put("userCateId", userCateId) map.put("title", title) map.put("user", user) content = templateProcessor.processTemplate( map, "/WEB-INF/user/default/category_video.ftl", "utf-8") fc.writeUserFileCacheContent( self.userName, "category_video_" + str(userCateId) + ".html", content) response.getWriter().write(content) fc = None
def show_specialsubject_video_list(self): qry = VideoQuery( " v.videoId, v.flvHref, v.flvThumbNailHref, v.title,v.userId,v.createDate" ) qry.specialSubjectId = self.specialSubject.specialSubjectId 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("video_list", video_list) request.setAttribute("pager", pager) request.setAttribute("specialSubject", self.specialSubject) request.setAttribute("subject", self.subject) request.setAttribute("head_nav", "specialsubject") return "/WEB-INF/subjectpage/" + self.templateName + "/show_video_list.ftl"
def get_video_with_pager(self): pager = self.params.createPager() pager.itemName = u"视频" pager.itemUnit = u"个" pager.pageSize = 24 qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.userId, u.loginName, u.nickName, v.summary,v.flvThumbNailHref """ ) if ((self.categoryName != None) and (self.categoryName != "")): qry.sysCateTitle = self.categoryName if self.type == "new": qry.orderType = 1 elif self.type == "hot": qry.orderType = 2 else: qry.orderType = 0 pager.totalRows = qry.count() video_list = qry.query_map(pager) request.setAttribute("video_list", video_list) request.setAttribute("pager", pager)
def execute(self): self.params = ParamUtil(request) userId = self.params.safeGetIntParam("userId", 0) listCount = self.params.safeGetIntParam("count", 2) if(userId == 0) : request.setAttribute("MessageText", "没有找到所查询的视频!") return "/WEB-INF/ftl/show_message.ftl"; user = __jitar__.userService.getUserById(userId) if user == None: request.setAttribute("MessageText", "没有找到所查询的图片") return "/WEB-INF/ftl/show_message.ftl"; self.userName = user.loginName fc = FileCache() # 14400 为10 天 content = fc.getUserFileCacheContent(self.userName, "user_video.html",30) if content != "": response.getWriter().write(content) fc = None return qry = VideoQuery(""" v.videoId, v.title, v.createDate, v.lastModified, v.flvThumbNailHref, v.href, u.nickName, u.loginName, u.userIcon """) qry.userId = userId qry.orderType = 0 qry.isPrivateShow = None video_list = qry.query_map(int(listCount)) templateProcessor = __spring__.getBean("templateProcessor") map = HashMap() map.put("video_list", video_list) map.put("UserSiteUrl", self.getUserSiteUrl()) content = templateProcessor.processTemplate(map, "/WEB-INF/user/default/user_video.ftl", "utf-8") fc.writeUserFileCacheContent(self.userName, "user_video.html",content) response.getWriter().write(content) fc = None
def genernate_video_content(self, webpart): cache_key = "unit" + str(self.unit.unitId) + "_" + str( webpart.getUnitWebpartId()) content = cache.get(cache_key) if content != None: request.setAttribute(cache_key, content) return map = HashMap() qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.href, v.flvHref, v.userId, u.loginName, u.nickName, v.summary,v.flvThumbNailHref """ ) qry.orderType = VideoQuery.ORDER_TYPE_VIDEOID_DESC qry.unitId = self.unit.unitId new_video_list = qry.query_map(4) map.put("new_video_list", new_video_list) map.put("unit", self.unit) map.put("webpart", webpart) map.put("UnitRootUrl", self.unitRootUrl) content = self.templateProcessor.processTemplate( map, "/WEB-INF/unitspage/" + self.templateName + "/video.ftl", "utf-8") request.setAttribute(cache_key, content) cache.put(cache_key, content)
def execute(self): # 完整的调用参数: # js_video.py?top=4&count=4&type=0&cateid=13 # 默认支持 subjectId,gradeId,参数带这些值,默认是支持的 # 更多参数请参见 js_video。 self.params = ParamUtil(request) ShowCount = self.params.getIntParam("count") ShowTop = self.params.getIntParam("top") unitId = self.params.getIntParamZeroAsNull("unitid") cateid = self.params.getIntParamZeroAsNull("cateid") if ShowTop == None or ShowTop == 0: ShowTop = 10 if ShowCount == None or ShowCount == 0: ShowCount = 10 qry = VideoQuery(" v.videoId, v.title, v.createDate ") qry.categoryId = cateid video_list = qry.query_map(ShowTop) request.setAttribute("video_list", video_list) request.setAttribute("ShowCount", ShowCount) response.contentType = "text/html; charset=utf-8" return "/WEB-INF/ftl/js_video.ftl"
def execute(self): self.params = ParamUtil(request) self.loginName = request.getAttribute("loginName") # 解析 uri if self.parseUri() == False: return self.sendNotFound(self.uri) # 得到要工作室主人, 并验证用户状态 self.user = user_svc.getUserByLoginName(self.loginName) request.setAttribute("user", self.user) request.setAttribute("loginUser", self.loginUser) #print "self.user = "******"loginUser", self.loginUser) # 创建分页对象 pager = self.params.createPager() pager.setPageSize(18) qry = VideoQuery( """ v.videoId, v.title, v.createDate, v.lastModified, v.flvThumbNailHref, v.href, v.commentCount, v.viewCount, u.nickName, u.loginName, u.userIcon """ ) qry.userId = self.user.userId qry.isPrivateShow = None if self.categoryId != 0: qry.userStapleId = self.categoryId #print "userStapleId = ", userStapleId pager.totalRows = qry.count() pager.itemName = u"视频" pager.itemUnit = u"个" qry.orderType = 0 result = qry.query_map(pager) request.setAttribute("video_list", result) request.setAttribute("pager", pager) hql = """SELECT new Map(p.skin as skin) FROM Page p WHERE p.name = 'index' and p.objId = :userId and p.objType = 1 """ pageSkin = Command(hql).setInteger("userId", self.user.userId).first() # 构造页面数据,由于页面不是在数据库存在的,这里的数据是虚拟数据. #pages : [{id: ${page.pageId}, title: '${user.blogName!?js_string}', layoutId: ${page.layoutId!0} }], page = { "pageId": 0, "layoutId": 2, # 固定是布局2 "isSystemPage": "true", "owner": "user", "title": "", "skin": pageSkin["skin"] } request.setAttribute("page", page) self.page = self.getUserProfilePage(self.user) if self.page.customSkin != None: customSkin = JSONObject.parse(self.page.customSkin) request.setAttribute("customSkin", customSkin) # 构造widgets . widgets = [ { "id": "1", "pageId": 0, "columnIndex": 1, "title": u"个人档案", "module": "profile", "ico": "", "data": "" } #, {"id": "2", "pageId":0, "columnIndex":1, "title":"视频分类", "module":"video_cate", "ico":"", "data":""} , { "id": "placerholder1", "pageId": 0, "columnIndex": 2, "title": "", "module": "placeholder", "ico": "", "data": "" } ] request.setAttribute("widgets", widgets) request.setAttribute("widget_list", widgets) response.setContentType("text/html; charset=UTF-8") return "/WEB-INF/user/default/user_videos.ftl"
def get_hot_video_list(self): qry = VideoQuery( " v.videoId, v.title , u.loginName,v.flvThumbNailHref ") qry.orderType = VideoQuery.ORDER_TYPE_VIEWCOUNT_DESC hot_video_list = qry.query_map(10) request.setAttribute("hot_video_list", hot_video_list)