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())
