文章目录一、企业列表二、审核一、企业列表后端代码staticmethod async def select_enterprise_list(page: int,size: int,enterprise_name: str, submit_time_start: str,submit_time_end: str): query Q() if enterprise_name: query query Q(enterprise_name__icontainsenterprise_name) if submit_time_start: query query Q(submit_time__gtesubmit_time_start) if submit_time_end: query query Q(submit_time__ltesubmit_time_end) total_count await Enterprise.all().filter(query).count() total_page math.ceil(total_count / size) offset (page - 1) * size res await Enterprise.filter(query).offset(offset).limit(size) enterprise_list [] for item in res: enterprise_id item.id info await EnterpriseInfo.get_or_none( enterprise_identerprise_id).prefetch_related(industry) enterprise_qualification await EnterpriseQualification.get_or_none( enterprise_identerprise_id) res_dict { enterprise: item, enterpriseinfo: info, enterprise_qualification: enterprise_qualification, industry: info.industry.name } enterprise_list.append(res_dict) page_dict { total_count: total_count, total_page: total_page, page: page, size: size } return { enterprise_list: enterprise_list, page_dict: page_dict } enterprise_router.get(/detail/{enterprise_id}, summary查询企业信息, description查询企业信息) async def select_enterprise_by_id(enterprise_id: int): res await EnterpriseService.select_enterprise_by_id(enterprise_id) return {code: 200, data: res, msg: 查询成功}二、审核后端代码staticmethod async def select_enterprise_by_id(enterprise_id: int,): enterprise await Enterprise.get_or_none(identerprise_id) enterpriseinfo await (EnterpriseInfo.get_or_none(enterprise_identerprise_id) .prefetch_related(industry)) enterprise_qualification await EnterpriseQualification.get_or_none(enterprise_identerprise_id) return { enterprise: enterprise, enterpriseinfo: enterpriseinfo, enterprise_qualification: enterprise_qualification, industry: enterpriseinfo.industry.name } staticmethod async def enterprise_review(data:EnterpriseReviewCreateRequest): enterprise_id data.enterprise_id enterprise_review await EnterpriseReview.get_or_none(enterprise_identerprise_id) if enterprise_review is None: enterprise_review await EnterpriseReview.create( enterprise_identerprise_id, review_resultdata.review_result, review_reasondata.review_reason, remarkdata.remark, review_timenow() ) else: enterprise_review.review_result data.review_result if data.review_result else enterprise_review.review_result enterprise_review.review_reason data.review_reason if data.review_reason else enterprise_review.review_reason enterprise_review.remark data.remark if data.remark else enterprise_review.remark enterprise_review.review_time now() await enterprise_review.save() if data.review_result 1: enterprise await Enterprise.get_or_none(identerprise_id) enterprise.account_status AccountStatus.NORMAL await enterprise.save() enterpriseQualification await EnterpriseQualification.get_or_none(enterprise_identerprise_id) await RecruitTeam.create( enterprise_identerprise_id, name enterpriseQualification.contact_name, mobile enterpriseQualification.contact_phone, email enterpriseQualification.contact_email, status TeamMemberStatus.NORMAL ) enterprise_router.get(/detail/{enterprise_id}, summary查询企业信息, description查询企业信息) async def select_enterprise_by_id(enterprise_id: int): res await EnterpriseService.select_enterprise_by_id(enterprise_id) return {code: 200, data: res, msg: 查询成功} enterprise_router.post(/enterprise_review, summary审核企业信息, description审核企业信息) async def enterprise_review(data: EnterpriseReviewCreateRequest): res await EnterpriseService.enterprise_review(data) return {code: 200, data: res, msg: 审核成功}