def student_relative_excel(self, student_id="", student_name="", school_id="", grade_id="", class_id=""):
filters = {}
if student_id:
filters.update({"id": student_id})
if student_name:
filters.update({"name": student_name})
if school_id:
filters.update({"school_id": school_id})
if grade_id:
filters.update({"grade_id": grade_id})
if class_id:
filters.update({"grade_id": class_id})
student_list = db_api.student_list(**filters)
views_list = self.views(student_list)
for view in views_list:
school_info = db_api.school_get(id=view.get("school_id"))
if school_info:
view.update({"school_name": school_info.name})
grade_info = view.get("grade_info", None)
if grade_info:
view.update({"grade_name": grade_info.get("name")})
class_info = view.get("class_info", None)
if class_info:
view.update({"class_name": class_info.get("name")})
relation_list = self._get_relative_by_student(view.get("id"))
if relation_list:
view.update({"relative_list": relation_list})
return views_list
def _get_relations_by_student(self, student_id="", student_name=""):
if student_id:
_relation_list = db_api.relation_list(student_id=student_id)
return _relation_list
_student_list = db_api.student_list(name=student_name)
student_id = [_student.id for _student in _student_list]
_relation_list = db_api.relation_list(student_id=student_id)
return _relation_list
def infos_for_sign_day(self, id="", name="",
school_id="",
grade_id="", class_id="",
relative_id="", sign_date="",
limit=100, offset=1):
offset = (offset - 1) * limit if offset > 0 else 0
filters = dict()
if id:
filters.update({"id": id})
if name:
filters.update({"name": name})
if school_id:
filters.update({"school_id": school_id})
if grade_id:
filters.update({"grade_id": grade_id})
if class_id:
filters.update({"class_id": class_id})
if relative_id:
_relation_list = self._get_relations_by_relative(relative_id)
if _relation_list:
_ids = [_relation.student_id for _relation in _relation_list]
filters.update({"id": _ids})
student_list = db_api.student_list(offset=offset, limit=limit, **filters)
student_count = db_api.student_count(**filters)
# 关联学校和班级，还有学生得签到（学生亲属的签到信息）
views_list = self.views(student_list)
for view in views_list:
school_info = db_api.school_get(id=view.get("school_id"))
if school_info:
view.update({"school_name": school_info.name})
grade_info = view.get("grade_info", None)
if grade_info:
view.update({"grade_name": grade_info.get("name")})
class_info = view.get("class_info", None)
if class_info:
view.update({"class_name": class_info.get("name")})
sign_date = datetime.strptime(sign_date, "%Y-%m-%d") if convert.is_date(sign_date) else date.today()
sign_status_list = db_api.student_sign_status_list(sign_date, sign_date, student_id=view.get("id"))
if sign_status_list:
view.update({
"sign_date": datetime.strftime(sign_date, "%Y-%m-%d"),
"morning": sign_status_list[0].morning if sign_status_list[0].morning else "",
"afternoon": sign_status_list[0].afternoon if sign_status_list[0].afternoon else ""
})
return {"count": student_count, "state": 0, "message": "query success", "data": views_list}
def infos_for_sign_month(self, id="", name="",
school_id="",
grade_id="", class_id="",
relative_id="", sign_date="",
limit=100, offset=1):
offset = (offset - 1) * limit if offset > 0 else 0
filters = dict()
if id:
filters.update({"id": id})
if name:
filters.update({"name": name})
if school_id:
filters.update({"school_id": school_id})
if grade_id:
filters.update({"grade_id": grade_id})
if class_id:
filters.update({"class_id": class_id})
if relative_id:
_relation_list = self._get_relations_by_relative(relative_id)
if _relation_list:
_ids = [_relation.student_id for _relation in _relation_list]
filters.update({"id": _ids})
student_list = db_api.student_list(offset=offset, limit=limit, **filters)
student_count = db_api.student_count(**filters)
# 关联学校和班级，还有学生得签到（学生亲属的签到信息）
views_list = self.views(student_list)
for view in views_list:
school_info = db_api.school_get(id=view.get("school_id"))
if school_info:
view.update({"school_name": school_info.name})
grade_info = view.get("grade_info", None)
if grade_info:
view.update({"grade_name": grade_info.get("name")})
class_info = view.get("class_info", None)
if class_info:
view.update({"class_name": class_info.get("name")})
sign_count, late_count, early_count, sign_date = self.com_sign(view.get("id"), sign_date)
view.update({"sign": sign_count,
"late": late_count,
"early": early_count,
"sign_date": datetime.strftime(sign_date, "%Y-%m")})
return {"count": student_count, "state": 0, "message": "query success", "data": views_list}
def infos(self, id="", student_id="", student_name="", status="", limit=100, offset=1):
offset = (offset-1)*limit if offset > 0 else 0
filters = dict()
if id:
filters.update({"id": id})
if student_id or student_name:
if not student_id:
_student_list = db_api.student_list(name=student_name)
if _student_list:
student_id = [student_info.id for student_info in _student_list]
filters.update({"student_id": student_id})
if status:
filters.update({"status": status})
history_list = db_api.student_history_list(offset=offset, limit=limit, **filters)
views_list = self.views(history_list)
for view in views_list:
student_info = db_api.student_get(id=view.get("student_id"))
if student_info:
view.update({"student_name": student_info.name})
history_count = db_api.student_history_count(**filters)
return {"count": history_count, "state": 0, "message": "query success", "data": views_list}
def infos(self, id="", name="",
school_id="", school_name="",
grade_id="", grade_name="",
class_id="", class_name="",
relative_id="", relative_name="", phone="",
limit=100, offset=1):
offset = (offset - 1) * limit if offset > 0 else 0
filters = dict()
if id:
filters.update({"id": id})
if name:
filters.update({"name": name})
if school_id or school_name:
if not school_id:
_school_list = db_api.school_list(name=school_name)
if not _school_list:
return {"count": 0, "state": 0, "message": "query success", "data": []}
school_id = [school_info.id for school_info in _school_list]
filters.update({"school_id": school_id})
if grade_id or grade_name:
if not grade_id:
_grade_list = db_api.grade_list(name=grade_name)
if not _grade_list:
return {"count": 0, "state": 0, "message": "query success", "data": []}
grade_id = [grade_info.id for grade_info in _grade_list]
filters.update({"grade_id": grade_id})
if class_id or class_name:
if not class_id:
_class_list = db_api.class_list(name=class_name)
if not _class_list:
return {"count": 0, "state": 0, "message": "query success", "data": []}
class_id = [class_info.id for class_info in _class_list]
filters.update({"class_id": class_id})
if relative_id or relative_name or phone:
_relation_list = self._get_relations_by_relative(relative_id, relative_name, phone)
if _relation_list:
_ids = [_relation.student_id for _relation in _relation_list]
filters.update({"id": _ids})
student_list = db_api.student_list(offset=offset, limit=limit, **filters)
#关联学校和班级
views_list = self.views(student_list)
for view in views_list:
school_info = db_api.school_get(id=view.get("school_id"))
if school_info:
view.update({"school_name": school_info.name})
grade_info = view.get("grade_info", None)
if grade_info:
view.update({"grade_name": grade_info.get("name")})
class_info = view.get("class_info", None)
if class_info:
view.update({"class_name": class_info.get("name")})
relation_list = self._get_relations_by_student(view.get("id"))
if relation_list:
view.update({"relation_list": relation_list})
student_count = db_api.student_count(**filters)
return {"count": student_count, "state": 0, "message": "query success", "data": views_list}