def performance_dataSource(): try: if request.method == "POST": raise Exception("method must be get") retrieve_list = ["performance_id", "corporation_id", "user_id", "hr_id", "value", "description", "registerdate", "department", "post"] querylist = Performance.get_obj(retrieve_list) msg = db.session.query(*querylist, Person.user_id, Person.name).\ filter(Performance.user_id == Person.user_id) return_msg = [] return_list = ["performance_id", "corporation_id", "user_id", "hr_id", "value", "description", "registerdate", "department", "post", "name"] for line in msg: line = list(line) line[6] = line[6].strftime('%Y-%m-%d') del line[9] temp = zip(return_list, line) return_msg.append(dict(temp)) return dict( status=1, message="success", data=return_msg ) except Exception as e: return dict( status=0, message=str(e), data="none" )
def newdataSource_dataSource(): try: if request.method == "POST": raise Exception("method must be get") corporation_id = request.values.get("corporation_id") if not corporation_id: raise Exception("corporation_id must not be empty") retrieve_list = ["performance_id", "corporation_id", "user_id", "hr_id", "value", "description", "registerdate", "department", "post"] querylist = Performance.get_obj(retrieve_list) msg = db.session.query(*querylist, Person.user_id, Person.name).\ filter(Performance.corporation_id == corporation_id).\ filter(Performance.user_id == Person.user_id) tempmessage = dict() for line in msg: user_id = line[retrieve_list.index("user_id")] if tempmessage.get(user_id, 0) == 0: tempmessage[user_id] = line else: history_date = tempmessage[user_id][retrieve_list.index("registerdate")] new_date = line[retrieve_list.index("registerdate")] if new_date > history_date: tempmessage[user_id] = line return_msg = [] return_list = ["performance_id", "corporation_id", "user_id", "hr_id", "value", "description", "registerdate", "department", "post", "name"] for line in tempmessage.values(): line = list(line) line[6] = line[6].strftime('%Y-%m-%d') del line[9] temp = zip(return_list, line) return_msg.append(dict(temp)) return dict( status=1, message="success", data=return_msg ) except Exception as e: return dict( status=0, message=str(e), data="none" )
def jixiaoCheck(): try: if request.method == "GET": raise Exception("method must be post") user_id = request.form.get('uid') if not all([user_id]): raise Exception("uid must not be empty") retrieve_list = [ "performance_id", "corporation_id", "user_id", "hr_id", "value", "description", "registerdate", "department", "post" ] querylist = Performance.get_obj(retrieve_list) msg = db.session.query(*querylist, Hr.hr_id, Hr.name, Corporation.corporation_id, Corporation.name). \ filter(Performance.user_id == user_id). \ filter(Performance.hr_id == Hr.hr_id). \ filter(Performance.corporation_id == Corporation.corporation_id). \ order_by(Performance.registerdate.desc()) retrieve_list = [ "performance_id", "corporation_id", "user_id", "hr_id", "value", "description", "registerdate", "department", "post", "hr_name", "corporation_id" ] return_msg = [] for line in msg: line = list(line) line[6] = line[6].strftime('%Y-%m-%d') del line[9] del line[10] temp = zip(retrieve_list, line) return_msg.append(dict(temp)) return dict(status=1, message="success", data=return_msg) except Exception as e: return dict(status=0, message=str(e), data="none")