江西理工大學(xué)2025屆本科畢業(yè)設(shè)計（論文）-31-附錄系統(tǒng)功能代碼的主要部分：圖書信息部分defnews_page(request):ifrequest.methodin["POST","GET"]:msg={"code":normal_code,"msg":mes.normal_code,"data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}req_dict=request.session.get("req_dict")globalnews#獲取全部列名columns=news.getallcolumn(news,news)if"vipread"inreq_dictand"vipread"notincolumns:delreq_dict["vipread"]#當(dāng)前登錄用戶所在表tablename=request.session.get("tablename")'''__authSeparate__此屬性為真，params添加userid，后臺只查詢個人數(shù)據(jù)'''try:__authSeparate__=news.__authSeparate__except:__authSeparate__=Noneif__authSeparate__=="是":tablename=request.session.get("tablename")iftablename!="users"and'userid'incolumnsand'userid'notinreq_dict:try:req_dict['userid']=request.session.get("params").get("id")except:pass#當(dāng)項目屬性hasMessage為”是”，生成系統(tǒng)自動生成留言板的表messages，同時該表的表屬性hasMessage也被設(shè)置為”是”,字段包括userid（用戶id），username(用戶名)，content（留言內(nèi)容），reply（回復(fù)）#接口page需要區(qū)分權(quán)限，普通用戶查看自己的留言和回復(fù)記錄，管理員查看所有的留言和回復(fù)記錄try:__hasMessage__=news.__hasMessage__except:__hasMessage__=Noneif__hasMessage__=="是":tablename=request.session.get("tablename")iftablename!="users":req_dict["userid"]=request.session.get("params").get("id")#判斷當(dāng)前表的表屬性isAdmin,為真則是管理員表__isAdmin__=NoneallModels=apps.get_app_config('main').get_models()forminallModels:ifm.__tablename__==tablename:try:__isAdmin__=m.__isAdmin__except:__isAdmin__=Nonebreak#當(dāng)前表也是有管理員權(quán)限的表if__isAdmin__=="是"and'news'!='forum':ifreq_dict.get("userid")and'news'!='chat'and'news'!='examrecord':delreq_dict["userid"]else:#非管理員權(quán)限的表,判斷當(dāng)前表字段名是否有useridiftablename!="users"and'news'[:7]!='discuss'and"userid"innews.getallcolumn(news,news):req_dict["userid"]=request.session.get("params").get("id")#當(dāng)列屬性authTable有值(某個用戶表)[該列的列名必須和該用戶表的登錄字段名一致]，則對應(yīng)的表有個隱藏屬性authTable為”是”，那么該用戶查看該表信息時，只能查看自己的try:__authTables__=news.__authTables__except:__authTables__=Noneif__authTables__!=Noneand__authTables__!={}and__isAdmin__=="是":forauthColumn,authTablein__authTables__.items():ifauthTable==tablename:params=request.session.get("params")req_dict[authColumn]=params.get(authColumn)username=params.get(authColumn)breakq=Q()msg['data']['list'],msg['data']['currPage'],msg['data']['totalPage'],msg['data']['total'],\msg['data']['pageSize']=news.page(news,news,req_dict,request,q)returnJsonResponse(msg,encoder=CustomJsonEncoder)defnews_autoSort(request):'''．智能推薦功能(表屬性：[intelRecom（是/否）],新增clicktime[前端不顯示該字段]字段（調(diào)用info/detail接口的時候更新），按clicktime排序查詢)主要信息列表中使用，顯示最近點(diǎn)擊的或最新添加的5條記錄就行'''ifrequest.methodin["POST","GET"]:msg={"code":normal_code,"msg":mes.normal_code,"data":{"currPage":1,"totalPage":1,"total":1,"pageSize":10,"list":[]}}req_dict=request.session.get("req_dict")if"clicknum"innews.getallcolumn(news,news):req_dict['sort']='clicknum'elif"browseduration"innews.getallcolumn(news,news):req_dict['sort']='browseduration'else:req_dict['sort']='clicktime'req_dict['order']='desc'msg['data']['list'],msg['data']['currPage'],msg['data']['totalPage'],msg['data']['total'],\msg['data']['pageSize']=news.page(news,news,req_dict)returnJsonResponse(msg,encoder=CustomJsonEncoder)圖書分類部分deftushufenlei_detail(request,id_):ifrequest.methodin["POST","GET"]:msg={"code":normal_code,"msg":mes.normal_code,"data":{}}data=tushufenlei.getbyid(tushufenlei,tushufenlei,int(id_))iflen(data)>0:msg['data']=data[0]ifmsg['data'].__contains__("reversetime"):ifisinstance(msg['data']['reversetime'],datetime.datetime):msg['data']['reversetime']=msg['data']['reversetime'].strftime("%Y-%m-%d%H:%M:%S")else:ifmsg['data']['reversetime']!=None:reversetime=datetime.datetime.strptime(msg['data']['reversetime'],'%Y-%m-%d%H:%M:%S')msg['data']['reversetime']=reversetime.strftime("%Y-%m-%d%H:%M:%S")#瀏覽點(diǎn)擊次數(shù)try:__browseClick__=tushufenlei.__browseClick__except:__browseClick__=Noneif__browseClick__=="是"and"clicknum"intushufenlei.getallcolumn(tushufenlei,tushufenlei):try:clicknum=int(data[0].get("clicknum",0))+1except:clicknum=0+1click_dict={"id":int(id_),"clicknum":clicknum,"clicktime":datetime.datetime.now()}ret=tushufenlei.updatebyparams(tushufenlei,tushufenlei,click_dict)ifret!=None:msg['code']=crud_error_codemsg['msg']=retreturnJsonResponse(msg,encoder=CustomJsonEncoder)deftushufenlei_update(request):ifrequest.methodin["POST","GET"]:msg={"code":normal_code,"msg":mes.normal_code,"data":{}}req_dict=request.session.get("req_dict")if'clicktime'inreq_dict.keys()andreq_dict['clicktime']=="None":delreq_dict['clicktime']ifreq_dict.get("mima")and"mima"notintushufenlei.getallcolumn(tushufenlei,tushufenlei):delreq_dict["mima"]ifreq_dict.get("password")and"password"notintushufenlei.getallcolumn(tushufenlei,tushufenlei):delreq_dict["password"]try:delreq_dict["clicknum"]except:passerror=tushufenlei.updatebyparams(tushufenlei,tushufenlei,req_dict)iferror!=None:msg['code']=crud_error_codemsg['msg']=errorreturnJsonResponse(msg)deftushufenlei_delete(request):'''批量刪除'''ifrequest.methodin["POST","GET"]:msg={"code":normal_code,"msg":mes.normal_code,"data":{}}req_dict=request.session.get("req_dict")error=tushufenlei.deletes(tushufenlei,tushufenlei,req_dict.get("ids"))iferror!=None:msg['code']=crud_error_codemsg['msg']=e