def query_product_by_default(): samples = query_by_regular(3, '', '', '', '', '') sample_list = {} line = 1 for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 samples = query_by_regular(4, '', '', '', '', '') for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 return json.dumps(sample_list), 200, {'content-type': 'application/json'}
def query_mysamples_by_default(): username = current_user.realname samples = query_by_manager('', '', username, '', '', '') sample_list = {} line = 1 for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 samples = query_by_applyer('', '', username, '', '', '') for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 return json.dumps(sample_list), 200, {'content-type': 'application/json'}
def query_apply_by_project(): Project = request.args.get('key', '') samples = SampleInfo.query.filter_by(Project_name=Project, Status=1).all() sample_list = {} line = 1 for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 db.session.close() return json.dumps(sample_list), 200, {'content-type': 'application/json'}
def query_deliever_by_default(): samples = query_by_regular(6, '', '', '', '', '') sample_list = {} line = 1 for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 # samples = query_by_regular(7, '', '', '', '') # for sample in samples: # sample_list[line] = translate4web( # sample.SampleInfo2dict(), SampleInfoEN2ZH) # line += 1 return json.dumps(sample_list), 200, {'content-type': 'application/json'}
def query_mysample_by_detail(): username = current_user.realname select = request.json status = select['Status'] tube_id = select['Tube_ID'] agent_contacts = select['Agent_contacts'] time_start = select['Time_start'] time_end = select['Time_end'] samples = query_by_manager(status, tube_id, username, agent_contacts, time_start, time_end) sample_list = {} line = 1 for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 samples = query_by_applyer(status, tube_id, username, agent_contacts, time_start, time_end) for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 return json.dumps(sample_list), 200, {'content-type': 'application/json'}
def query_sample_by_detail(): select = request.json status = select['Status'] tube_id = select['Tube_ID'] agent_manager = select['Agent_manager'] time_start = select['Time_start'] time_end = select['Time_end'] print(type(select)) tag = select['Tag'] if "tag" in select.keys() else None print(f"tag:{tag}") print(f"tube_id:{tube_id}") samples = query_by_regular(status, tube_id, agent_manager, time_start, time_end, tag) sample_list = {} line = 1 print(f"samples:{samples}") for sample in samples: sample_list[line] = translate4web(sample.SampleInfo2dict(), SampleInfoEN2ZH) line += 1 return json.dumps(sample_list), 200, {'content-type': 'application/json'}
def query_quest_by_prisid(): prisid = request.args.get('key', '') sampleinfo = SampleInfo.query.filter_by(PriSID=prisid).first() if None == sampleinfo: db.session.close() return 'failed', 500, {'content-type': 'application/json'} elif None == sampleinfo.Tube_ID: db.session.close() return 'not ready', 300, {'content-type': 'application/json'} question = Questionnaire.query.filter_by( Tube_ID=sampleinfo.Tube_ID).first() if None == question: db.session.close() return 'failed', 500, {'content-type': 'application/json'} else: questionjson = translate4web(question.Questionnaire2dict(), QuestionnaireEN2ZH) db.session.close() return json.dumps(questionjson), 200, { 'content-type': 'application/json' }
def query_sample_by_prisid(): PriSID = request.args.get('key', '') sampleinfo = SampleInfo.query.filter_by(PriSID=PriSID).first() sampleinfo = translate4web(sampleinfo.SampleInfo2dict(), SampleInfoEN2ZH) db.session.close() return json.dumps(sampleinfo), 200, {'content-type': 'application/json'}