def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) #分类的父分类, 缺省 = null self.parentId = None #分类的类型 缺省是文章分类 self.itemType = 'default'
def resolveEntity(self, qctx, entity): if "user" == entity: qctx.addJoinEntity("cu", "cu.user", "user", "LEFT JOIN") elif "channel" == entity: qctx.addJoinEntity("cu", "cu.channel", "channel", "LEFT JOIN") else: BaseQuery.resolveEntity(self, qctx, entity);
def resolveEntity(self, qctx, entity): if "subj" == entity: qctx.addJoinEntity("ev", "ev.metaSubject", "subj", "LEFT JOIN") elif ("grad" == entity): qctx.addJoinEntity("ev", "ev.grade", "grad", "LEFT JOIN") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.prepareCourseId = None self.createUserId = None self.k = self.params.getStringParam("k") #查询关键字 self.ktype = self.params.getStringParam("ktype") #查询类型[关键字对应的类型] if self.ktype == None: self.ktype = "1" #默认关键字查询标题 self.unit = self.params.getStringParam("unit") #主备人所属机构 self.course_BeginDate = self.params.getStringParam("course_BeginDate") self.course_EndDate = self.params.getStringParam("course_EndDate") self.subjectId = self.params.getIntParamZeroAsNull("subjectId") self.gradeId = self.params.getIntParamZeroAsNull("gradeId") request.setAttribute("subjectId", self.subjectId) request.setAttribute("gradeId", self.gradeId) request.setAttribute("k", self.k) request.setAttribute("ktype", self.ktype) request.setAttribute("unit", self.unit) request.setAttribute("course_BeginDate", self.course_BeginDate) request.setAttribute("course_EndDate", self.course_EndDate) self.orderType = 0 self.status = None self.stage = None #集备执行的阶段,正在进行running;已经完成finishaed;还未进行will ;recommend 推荐的 self.containChild = None #准确学科的查询 self.prepareCoursePlanId = None self.prepareCourseGenerated = True self.custormAndWhere = None #自定义条件查询 sft = SimpleDateFormat("yyyy-MM-dd HH:mm:ss") self.nowDate = sft.format(Date())
def resolveEntity(self, qctx, entity): if "u" == entity: qctx.addEntity("User", "u", "pc.createUserId = u.userId") #备课发起人 elif "ul" == entity: qctx.addEntity("User", "ul", "pc.leaderId = ul.userId") #备课主备人 else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) #发表评论的用户标识, 缺省 = null, 表示不限定 self.userId = None #被评论的文章/资源的所属用户的标识,缺省 = null 表示不限定 self.aboutUserId = None #被评论的对象类型, 缺省 = null 表示不限定; 一般和objectId 一起使用. self.objType = None #被评论的对象标识, 缺省 = null 表示不限定 self.objId = None #审核标志; 缺省 = 1 表示获取审核通过的, = 0 表示获取未审核通过的; = null 表示不限定 self.audit = 1 #排序方式, 0 - 按照 id 逆序排列, 1 - createDate 逆序排列 self.orderType = 0 # 查询关键字. self.k = None # 查询字段. 0 标题或内容 1用户 self.f = "0" self.unitId = None self.commentType = None
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.columnId = None self.userId = None self.hasPicture = None self.k = None self.orderType = 0
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.orderType = 0 self.params = ParamUtil(request) self.actionId = None self.userId = None
def resolveEntity(self, qctx, entity): if "pcs" == entity: qctx.addEntity( "PrepareCourseStage", "pcs", "pct.prepareCourseStageId = pcs.prepareCourseStageId") else: BaseQuery.resolveEntity(qctx, entity)
def resolveEntity(self, qctx, entity): if "pct" == entity: qctx.addEntity( "PrepareCourseTopic", "pct", "pct.prepareCourseTopicId = pctr.prepareCourseTopicId") else: BaseQuery.resolveEntity(qctx, entity)
def resolveEntity(self, qctx, entity): if "send" == entity: # 关联到接收者. qctx.addJoinEntity("msg", "msg.sender", "send", "LEFT JOIN") elif "recv" == entity: # 关联到发送者. qctx.addJoinEntity("msg", "msg.receiver", "recv", "LEFT JOIN") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.parentGuid = None self.parentObjectType = None self.userId = None self.orderType = 0
def resolveEntity(self, qctx, entity): if "u" == entity: qctx.addEntity("User", "u", "t.userId = u.userId") elif "g" == entity: qctx.addEntity("Group", "g", "t.groupId = g.groupId") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.pathInfoType = None self.unit = None self.k = None self.orderType = 0 self.isTry = None #只用来进行测试
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.tagId = None self.objectType = 11 self.delState = False self.isPrivateShow = False self.orderType = 0
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.subjectId = self.params.getIntParamZeroAsNull("subjectId") # 新闻所属学段 self.gradeId = self.params.getIntParamZeroAsNull("gradeId") self.userIsFamous = None self.unit = None # 是否精华,缺省为 null 表示所有文章; = true 表示获取精华的; = false 表示获取非精华的. self.bestState = None # 排序方式, 0 - 按照 id desc, 1 - createDate desc, 2 - viewCount desc, 3 - commentCount desc self.orderType = 0 self.userId = self.params.getIntParamZeroAsNull("userId") # 用户筛选. self.sysCateId = self.params.getIntParamZeroAsNull( "categoryId") # 文章文章所属系统分类. self.k = self.params.getStringParam("k") # 关键字 self.f = self.params.getStringParam("f") # 查询的字段 if self.f == None: self.f = "title" if self.f == "": self.f = "title" request.setAttribute("categoryId", self.sysCateId) request.setAttribute("sysCateId", self.sysCateId) request.setAttribute("userId", self.userId) request.setAttribute("subjectId", self.subjectId) request.setAttribute("gradeId", self.gradeId) request.setAttribute("k", self.k) request.setAttribute("f", self.f)
def resolveEntity(self, qctx, entity): if "u" == entity: qctx.addEntity("User", "u", "actr.userId = u.userId") elif "act" == entity: qctx.addEntity("Action", "act", "act.actionId = actr.actionId") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.prepareCourseId = None self.commentedUserId = None self.commentUserId = None self.orderType = 0
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) # 新闻标识, 默认为空, 表示不限制 self.newsId = None # 查询条数, 一般在未指定 pager 的时候使用 #self.count = 10 # 限定群组标识, 缺省 = 0 表示获取站点的; = null 表示不限制 self.groupId = None # 发布用户标识, 缺省 = null 表示不限制 self.userId = None # 要获取的对象状态, 缺省 = 0, 表示或缺正常状态的; = null 表示不限制 self.status = 0 # 要获取的类型, 缺省 = null 表示不限制 self.newsType = None # 是否要求有图片, 缺省 = null 表示不限制 self.picture = None # 要查询的关键字, 缺省 = null 表示不限制 self.k = None # 排序方式, 缺省 = 0 按照创建时间逆序排列. = 1,按viewCount DESC. = 2, 按newsId 逆序. self.orderType = 0
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.tagId = None self.objectType = 12 self.delState = False self.auditState = 0 self.shareMode = 1000 self.orderType = 0
def resolveEntity(self, qctx, entity): if "u" == entity: qctx.addEntity("User", "u", "pcpc.commentedUserId = u.userId") elif "pc" == entity: qctx.addEntity("PrepareCourse", "pc", "pcpc.prepareCourseId = pc.prepareCourseId") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.prepareCourseId = None self.prepareCourseTopicId = None self.prepareCourseStageId = None self.userId = None self.orderType = 0
def resolveEntity(self, qctx, entity): if "msubj" == entity: qctx.addEntity("MetaSubject", "msubj", "subj.subjectId = msubj.msubjId") elif ("grad" == entity): qctx.addJoinEntity("subj", "subj.gradeId", "grad", "LEFT JOIN") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.sendId = None # 消息发送者标识, 缺省不限定. self.receiveId = None # 消息接收者标识, 缺省不限定. self.isDel = False # 删除标识(删除至回收站) 默认为false, 表示查询未删除的. self.isSenderDel = None # 发送者删除消息标识, 缺省为 None 不限定. self.orderType = MessageQuery.ORDER_TYPE_ID_DESC # 缺省按照 id 逆序排列.
def resolveEntity(self, qctx, entity): if entity == "photo": qctx.addJoinEntity("cp", "cp.photo", "photo","LEFT JOIN") elif "user" == entity: qctx.addJoinEntity("cp", "cp.user", "user","LEFT JOIN") elif "unit" == entity: qctx.addJoinEntity("cp", "cp.unit", "unit","LEFT JOIN") else: BaseQuery.resolveEntity(self, qctx, entity);
def resolveEntity(self, qctx, entity): if "subj" == entity: qctx.addJoinEntity("ec", "ec.metaSubject", "subj", "LEFT JOIN") elif ("grad" == entity): qctx.addJoinEntity("ec", "ec.grade", "grad", "LEFT JOIN") ##if "u" == entity: # qctx.addEntity("User", "u", "ev.userId = u.userId") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.tagId = None self.objectType = 3 self.auditState = 0 self.hideState = 0 self.draftState = False self.delState = False self.orderType = 0
def resolveEntity(self, qctx, entity): if "u" == entity: qctx.addEntity("User", "u", "p.userId = u.userId") elif "stap" == entity: qctx.addJoinEntity("p", "p.staple", "stap", "LEFT JOIN") elif "sc" == entity: qctx.addJoinEntity("p", "p.sysCate", "sc", "LEFT JOIN") else: BaseQuery.resolveEntity(self, qctx, entity)
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.specialSubjectId = None self.objectType = None self.objectId = None self.k = self.params.getStringParam("k") request.setAttribute("k", self.k) self.orderType = 0
def __init__(self, selectFields): BaseQuery.__init__(self, selectFields) self.params = ParamUtil(request) self.prepareCourseId = None self.userId = None self.privateContentExist = None #是否只显示有内容的个案 默认None,全部显示 True,查询有内容的,False 查询无内容的 self.stage = None #集备执行的阶段,正在进行running;已经完成finishaed;还未进行will sft = SimpleDateFormat("yyyy-MM-dd HH:mm:ss") self.nowDate = sft.format(Date())