def select_resources(page, us=None): q = """select * from source order by content desc;""" # s = Source.objects.order_by("-content")[(page-1)*ONE_PAGE_NUM:page*ONE_PAGE_NUM] s = Source.objects.raw(q)[(page - 1) * ONE_PAGE_NUM : page * ONE_PAGE_NUM] rsp = [] for v in s: content = {} content["id"] = v.id content["uploader"] = v.userid.id content["downloaded"] = v.content content["money"] = v.points content["downloader"] = v.download if us: from complaint.dao import complaintDao dao = complaintDao({"userid": us, "rsid": v.id}) content["complaint"] = dao.is_complaint_byRS() q = (dao.us.username + (" 下载资源: ").decode("utf-8") + v.download).encode("utf-8") # w = "warmer 下载资源: test.py" content["dw"] = is_activity(q) # content['dw'] = q rsp.append(content) return rsp
def add(req): if req.method=='POST' and req.COOKIES.has_key('userid'): jsonReq = simplejson.loads(req.body) rq = {} userid = req.COOKIES['userid'] actDao = activityDao({"userid":userid}) if jsonReq.has_key('titleid'): titleid = jsonReq['titleid'] dao = complaintDao({'userid':userid,'titleid':titleid}) if dao.is_complaint_byEX(): return HttpResponse(json.dumps({'tips':'你已经投诉过了'}), content_type="application/json") activities = " complaints for the title published by "+dao.us.username elif jsonReq.has_key('authorid'): authorid = jsonReq['authorid'] dao = complaintDao({'userid':userid,'authorid':authorid}) if dao.is_complaint_byAU(): return HttpResponse(json.dumps({'tips':'你已经投诉过了'}), content_type="application/json") activities = " complaints for "+dao.au.username elif jsonReq.has_key('topicid'): topicid = jsonReq['topicid'] dao = complaintDao({'userid':userid,'topicid':topicid}) if dao.is_complaint_byTP(): return HttpResponse(json.dumps({'tips':'你已经投诉过了'}), content_type="application/json") activities = " complaints for "+dao.tp.name elif jsonReq.has_key('opinionid'): opinionid = jsonReq['opinionid'] dao = complaintDao({'userid':userid,'opinionid':opinionid}) if dao.is_complaint_byOP(): return HttpResponse(json.dumps({'tips':'你已经投诉过了'}), content_type="application/json") opdao = dao.op activities = " complaints for an opinion published by "+opdao.userid.username+" on "+opdao.topicid.name elif jsonReq.has_key('rsid'): rsid = jsonReq['rsid'] dao = complaintDao({'userid':userid,'rsid':rsid}) q = (dao.us.username + (" 下载资源: ").decode("utf-8") + dao.rs.download).encode("utf-8") if not is_activity(q): return HttpResponse(json.dumps({'tips':'假如你没有下载这份资源,你怎么知道资源的内容违反礼仪?'}), content_type="application/json") else: if dao.is_complaint_byRS(): return HttpResponse(json.dumps({'tips':'你已经投诉过了'}), content_type="application/json") rsdao = dao.rs # activities = " complaints for a resource " + rsdao.download + " uploaded by "+ rsdao.userid.username activities = '对' + rsdao.userid.username + '发布的资源:' + rsdao.download + '进行投诉' rq['content'] = jsonReq['content'] actDao.add_a_activity(activities) return HttpResponse(json.dumps({'tips':dao.insert_a_complaint(rq,'+')}), content_type="application/json") return HttpResponse(json.dumps({'tips':'请求格式不正确or未登录'}), content_type="application/json")