def approve_entity_function(): data = request.get_data() json_data = json.loads(data) print(json_data) eId = json_data['eId'] uId = json_data['vuId'] en = entityInfoDB.search_entity(eId) print(uId) u = userInfoDB.search_user(uId) if u is None: return jsonify('uId Error') if en is None: return jsonify('eId Error') if en.eStatus == '8': return jsonify('false') print(u.role) if u.role == 'Manager': if en.eStatus == '7': return jsonify('false') if u.role == 'Curator': if en.eStatus == '4' or en.eStatus == '7': return jsonify('false') date = time.strftime('%Y-%m-%d', time.localtime(time.time())) # Approved date en.eSubDate = date print(u.role) if u.role == 'Manager': print('en.status') en.eStatus = '7' if u.role == 'Curator': en.eStatus = '4' fd = feedbackDB.search_feedback_eId(eId) if fd is not None: feedbackDB.dele_feedbackFdb(eId) fnum = feedbackDB.search_feedback_num() + 1 fId = 'FB_' + str(fnum) date = time.strftime('%Y-%m-%d', time.localtime(time.time())) fb = Model.Feedback(fId, json_data['eId'], uId, json.dumps(json_data['feedback']), date) feedbackDB.add_feedback2db(fb) entityInfoDB.update_entity2db(en) user = userInfoDB.search_user(en.euId) if user is not None: url = '' #json_data['url'] if user.uvs == '0': if u.role == 'Manager': SendEmail.releaseEntityEmail(user, url) else: SendEmail.approveEntityEmail(user, url) return jsonify('true')
def give_feedback_function(): data = request.get_data() json_data = json.loads(data) eId = json_data['eId'] uId = json_data['uId'] check_f = feedbackDB.search_feedback_eId(eId) if check_f is None: fnum = feedbackDB.search_feedback_num() + 1 fId = 'FB_' + str(fnum) date = time.strftime('%Y-%m-%d', time.localtime(time.time())) feedback = Model.Feedback(fId, json_data['eId'], json_data['feedback'], date) feedbackDB.add_feedback(feedback) return jsonify('true') else: return jsonify('false')
def check_feedback_function(): data = request.get_data() json_data = json.loads(data) feedback = feedbackDB.search_feedback_eId(json_data.eId) if feedback is not None: customers = [] for e in feedback: u = e.__dict__ result = json.dumps(u) customers.append(result) # print(result) result1 = str(customers).replace('\'', '') # print(result1) r = json.loads(result1) return jsonify(r) else: return jsonify('false')
def send_message_function(): data = request.get_data() print(request) json_data = json.loads(data) uId = json_data['uId'] #tuId = json_data['tuId'] eId = json_data['eId'] msg = json_data['message'] fb = feedbackDB.search_feedback_eId(eId) if fb is None: return jsonify('No feedback.') print(fb) date = time.strftime('%Y-%m-%d: %H:%M:%S', time.localtime(time.time())) mnum = messageDB.search_message_num() + 1 mId = 'MSG_' + str(mnum) message = Model.Message(mId,uId,fb.uId,eId,msg,date,None) messageDB.add_message2db(message) return jsonify('true')
def check_entity_function(): eId = request.values.get("eId") role = request.values.get("role") en = entityInfoDB.search_entity(eId) if en is None: return jsonify('eId Error!') if role == 'Manager': en.eStatus = 6 if role == 'Curator': en.eStatus = 2 result = dict() if en is None: return jsonify('No such Entity!') result['eId'] = en.eId result['uId'] = en.euId result['eType'] = en.eType result['eName'] = en.eName result['eTitle'] = en.eSubName result['sDate'] = en.eStartDate result['eDate'] = en.eEndDate result['bPlace'] = en.eBirthPlace result['dPlace'] = en.eDeathPlace result['sumNote'] = en.eSumNote result['ePrepared'] = en.ePrepared result['resources'] = en.eImgResource if en.eLocation is not None: dn = jsonEntity.read_entity(en.eLocation) result['fullNote'] = dn.fullNote if en.eImage is None: result['image'] = 'static/images/default.png' result['image'] = 'static/images/' + en.eId + '.png' als = alternationDB.search_alternation_eId_Fdb( en.eId) # just for one relationship result['alternation'] = [] if als is not None: for al in als: aa = Models.Objects.alternationforen(al.aType, al.alternate) result['alternation'].append(aa.__dict__) pr = publicResourceDB.search_publicResource_eId_Fdb( en.eId) # just for one relationship result['publish'] = [] if pr is not None: for r in pr: pp = Models.Objects.publicResourceforen(r.pId, r.pTitle, r.pType, r.pUrl) result['publish'].append(pp.__dict__) dr = digitalResourceDB.search_digitalResource_eId_Fdb( en.eId) # just for one relationship result['digital'] = [] if dr is not None: for r in dr: dd = Models.Objects.digitalResourceforen(r.dId, r.dTitle, r.dType, r.dUrl) result['digital'].append(dd.__dict__) rela = relationshipDB.search_relationship_eId(en.eId) result['relationship'] = [] if rela is not None: for r in rela: ren = entityInfoDB.search_entity(r.reId) if ren is not None: #rId, eId, relPairs, reId, eName, sDate, eType rr = Models.Objects.relationshipsforen(r.rId, r.eId, r.relationship, r.reId, ren.eName, ren.eType) else: rr = Models.Objects.relationshipsforen(r.rId, r.eId, r.relationship, r.reId, None, None) result['relationship'].append(rr.__dict__) # print(r.reId) occ = occupationDB.search_occupation_eId_Fdb(en.eId) result['function'] = [] if occ is not None: for o in occ: ff = Models.Objects.functions(o.oId, o.occupation, o.oEvent) result['function'].append(ff.__dict__) fb = feedbackDB.search_feedback_eId(eId) if fb is not None: print(fb.feedback) result['feedback'] = json.loads(fb.feedback) print(result) return jsonify(result)