from rest_framework import status from rest_framework.exceptions import ValidationError from api.models import TtStaff, TtTagRelation, TtLocation, TtPathway from api.models.tt_student_set import TtStudentSet from api.translation import __ from api.utils import log_critical_error, get_exception_detail from api.validator import BaseValidator from api.views.admin.base import AdminApiBase class StudentSetList(AdminApiBase): def validate_request(self,request): rules = { "academic_term_id": "required|exists:api.TtAcademicTerm,id", "filter": "nullable", "page": "nullable", "per_page": "nullable", "sort_by": "nullable", "order_by": "nullable", } # if need rename field, can put here attribute = { # "email": __("attr.email"), } # validate id first, cause need get pos by id, if wrong id direct return error validator = BaseValidator(request.data,rules,attribute) error = validator.validate() if error: raise ValidationError(error) def post(self, request): try: self.api_log_skip_outgoing_data=True self.validate_request(request) data = self.get_data(request) response = data return self.api_response(data=response) except ValidationError as e: first_message = e.detail['error'] errors = e.detail['errors'] return self.api_response(error=first_message,errors=errors,code=status.HTTP_400_BAD_REQUEST) except Exception as e: e_details = get_exception_detail(e) log_critical_error(user_id=None,descr=e_details['descr'],url=e_details['url'],trace=e_details['trace']) return self.api_response(error=__("message.internal_server_error"),code=status.HTTP_500_INTERNAL_SERVER_ERROR) def get_data(self,request): student_sets = ( TtStudentSet.objects .select_related("department","pos","academic_term","availability","start_preference","usage_preference") .prefetch_related( "module", "constraint_profile", "constraint_profile__free_block", "constraint_profile__resource_break", "constraint_profile__maximum_hour", "constraint_profile__maximum_workspan", "constraint_profile__travel_table", "student", "tag__tag" #tags means the relation add in models, __tag means the relation table tag_id get the tag object ) .filter(academic_term_id=request.data.get("academic_term_id")) ) student_sets = self.listing_filter(request,student_sets) paginated_details = self.listing_pagination(request,student_sets) total = paginated_details["total"] paginated_data = paginated_details["paginated_data"] page = paginated_details["page"] pos_ids = {ss.pos_id for ss in paginated_data if ss.pos_id is not None} pathways = TtPathway.objects.filter(pos_id__in=pos_ids).values("id", "pathway_string_2", "pos_id") pathway_lookup = { (p["pos_id"], p["pathway_string_2"]): p for p in pathways } return_data=[] relation_table = { "free_block":{"id","code","name"}, "resource_break": {"id", "code", "name"}, "maximum_workspan": {"id", "code", "name"}, "maximum_hour": {"id", "code", "name"}, "travel_table": {"id", "code", "name"} } for val in paginated_data: data={} data["id"] = val.id data["code"] = val.code data["name"] = val.name data['desc'] = val.desc data['department'] = val.department.name if val.department else None data['department_id'] = val.department_id data['academic_term'] = val.academic_term.name if val.academic_term else None data['academic_term_id'] = val.academic_term_id data['pos'] = val.pos.name if val.pos else None data['pos_id'] = val.pos_id data['planned_size'] = val.planned_size data['real_size'] = val.real_size data["availability_id"] = val.availability.id if val.availability else None data["availability_name"] = val.availability.name if val.availability else "-" data["availability_pattern"] = val.availability.pattern if val.availability else val.availability_pattern data["start_preference_id"] = val.start_preference.id if val.start_preference else None data["start_preference_name"] = val.start_preference.name if val.start_preference else "-" data["start_preference_pattern"] = val.start_preference.pattern if val.start_preference else val.start_preference_pattern data["usage_preference_id"] = val.usage_preference.id if val.usage_preference else None data["usage_preference_name"] = val.usage_preference.name if val.usage_preference else "-" data["usage_preference_pattern"] = val.usage_preference.pattern if val.usage_preference else val.usage_preference_pattern modules = [] module_ids = [] for m in val.module.all(): modules.append({"id": m.id, "code": m.code, "name": m.name}) module_ids.append(m.id) data['module'] = modules # get pathway code without extra query module_ids.sort() pathway_string_2 = ";".join(map(str, module_ids)) if module_ids else None match_key = (val.pos_id, pathway_string_2) pathway = pathway_lookup.get(match_key) data['pathway_id'] = pathway['id'] if pathway else None data['student'] = [ {"id": student.id,"name": student.name} for student in val.student.all() ] data['constraint_profile'] = [] for constraint_profile in val.constraint_profile.all(): constraint_data = { "id": constraint_profile.id, "name": constraint_profile.name, "code": constraint_profile.code, "active_constraints": [], } for relation_key, relation_columns in relation_table.items(): relation_models = getattr(constraint_profile, relation_key, None) if relation_models: new_items = [ { **{column: getattr(item, column) for column in relation_columns}, "category": relation_key, "category_name": __("attr." + relation_key) } for item in relation_models.all() ] constraint_data["active_constraints"].extend(new_items) data["constraint_profile"].append(constraint_data) data["tag"] = [ {"id": tag.tag.id, "name": tag.tag.name} for tag in val.tag.all() ] for i in range(1,11): extra_data_field = f"extra_data_{i}" data[extra_data_field] = getattr(val,extra_data_field,None) return_data.append(data) return { "total": total, "page": page, "data": return_data, }