def queryDraftBox(request):
json_req = json.loads(request.body)
token = json_req['token']
if token == "123456":
article_count = Article.objects.filter(flag=0).count()
page = check_page(json_req['page'], article_count)
sql = ArticleDao.queryDraftBox()
articles = execute_sql(sql, page)
json_list = []
for article in articles:
json_dict = {
"article_id": article[0],
"title": article[1],
"simple_content": article[2],
"page_view": article[3],
"create_time": article[4].strftime("%Y年%m月%d日 %H:%M:%S"),
"type_name": article[5],
"type_id": article[6],
"photo_url": article[7],
"photo_flag": article[8],
}
json_list.append(json_dict)
result = {
'code': 200,
'article_count': article_count,
'article': json_list
}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
result = {'code': 401}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
def queryArticleDetailed(request):
json_req = json.loads(request.body)
token = json_req['token']
if token == "123456":
loginuser = {
"user_url":
'http://192.168.195.9:8888/static/images/20191202193207.jpg',
"user_id": 1001,
"user_name": '曾琳',
}
article_id = json_req['article_id']
user_id = 1001 # 设定当前用户id为1001
sql = ArticleDao.queryArticleDetailed()
articles = execute_sql(sql, user_id, article_id)
star_count = Collection.objects.filter(user_id=1001).count()
comment_count = Comment.objects.filter(article_id=article_id).count()
write_count = Article.objects.filter(user_id=1001).count()
collection_count = Collection.objects.filter(
article_id=article_id).count()
collect_flag = 0
if Collection.objects.filter(article_id=article_id,
user_id=1001).count() > 0:
collect_flag = 1
for article in articles:
json_dict = {
"article_id": article[0],
"title": article[1],
"content": article[2],
"page_view": queryPageView(article[0]),
"create_time": article[4].strftime("%Y年%m月%d日 %H:%M:%S"),
"user_id": article[5],
"user_url": article[6],
"user_name": article[7],
"user_account": article[8],
"point_count": article[9],
"type_id": article[10],
"type_name": article[11],
"point_flag": article[12],
"collect_flag": collect_flag,
"star_count": star_count,
"comment_count": comment_count,
"write_count": write_count,
"collection_count": collection_count
}
result = {'code': 200, 'user': loginuser, 'article': json_dict}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
result = {'code': 401}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
def queryCollectionByUserId(request):
json_req = json.loads(request.body)
token = json_req['token']
if token == "123456":
user_id = json_req['user_id']
article_count = Collection.objects.filter(user_id=user_id).count()
page = check_page(json_req['page'], article_count)
sql = ArticleDao.queryCollectionByUserId()
articles = execute_sql(sql, user_id, page) # 结果集
json_list = []
for article in articles:
json_dict = {
"article_id":
article[0],
"title":
article[1],
"simple_content":
article[2],
"page_view":
queryPageView(article[0]),
"create_time":
article[4].strftime('%Y{y}%m{m}%d{d}%H:%M:%S').format(y='年',
m='月',
d='日'),
"point_count":
article[5],
"type_name":
article[6],
"type_id":
article[7],
"photo_url":
article[8],
"photo_flag":
article[9],
"comment_count":
article[10],
}
json_list.append(json_dict)
result = {
'code': 200,
'article_count': article_count,
'article': json_list
}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
result = {'code': 401}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
def queryArticleByTypeId(request):
json_req = json.loads(request.body)
token = json_req['token']
if token == "123456":
type_id = json_req['type_id']
order = check_order(json_req['order_type'])
article_count = Article.objects.filter(type_id=type_id, flag=1).count()
page = check_page(json_req['page'], article_count)
sql = ArticleDao.queryArticleByTypeId(order)
user_id = 1001
articles = execute_sql(sql, user_id, type_id, page) # 结果集
json_list = []
for article in articles:
json_dict = {
"article_id": article[0],
"title": article[1],
"simple_content": article[2],
"page_view": queryPageView(article[0]),
"create_time": article[4].strftime("%Y年%m月%d日 %H:%M:%S"),
"user_url": article[5],
"user_name": article[6],
"user_account": article[7],
"point_flag": article[8],
"point_count": article[9],
"photo_url": article[10],
"comment_count": article[11],
}
json_list.append(json_dict)
result = {
'code': 200,
'article_count': article_count,
'data': json_list
}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
result = {'code': 401}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
def queryComment(request):
json_req = json.loads(request.body)
user_id = json_req['user_id']
article_id = json_req['article_id']
try:
comment_count = Comment.objects.filter(article_id=article_id,
is_delete=1).count()
page = check_page(json_req['page'], comment_count)
sql = CommentDao.queryComment
comments = execute_sql(sql, article_id, page)
json_list = []
for comment in comments:
json_dict = {
"comment_id": comment[0],
"comment_content": comment[1],
"create_time": comment[2].strftime("%Y年%m月%d日 %H:%M:%S"),
"user_id": comment[3],
"user_name": comment[4],
"user_url": comment[5]
}
json_list.append(json_dict)
result = {
'code': 200,
"loginuser": user_id,
'comment_count': comment_count,
'comment': json_list
}
return HttpResponse(json.dumps(result, ensure_ascii=False),
content_type="application/json")
except:
return HttpResponse(json.dumps({
'code': 405,
'information': '执行异常'
},
ensure_ascii=False),
content_type="application/json")
def getArticlePhoto(article_id):
sql = ArticleDao.getArticlePhoto()
args = (article_id, )
photo = execute_sql(sql, args)
return photo