FastAPI类招聘软甲框架搭建（企业端）——day08

一、企业端列表的实现1、企业列表模型表app\models\enterprise.pyclassRegisterStatus(IntEnum):登记状态CONTINUE1# 存续IN_BUSINESS2# 在业OPEN3# 开业SUSPENDED4# 停业LIQUIDATION5# 清算REVOKED6# 吊销CANCELLED7# 注销classCompanyScale(IntEnum):公司规模SCALE_0_201# 0-20人SCALE_20_992# 20-99人SCALE_100_4993# 100-499人SCALE_500_9994# 500-999人SCALE_1000_99995# 1000-9999人SCALE_10000_PLUS6# 10000人以上classFinancingStage(IntEnum):融资阶段允许为空ANGEL1# 天使轮A_ROUND2# A轮B_ROUND3# B轮C_ROUND4# C轮D_PLUS5# D轮及以上LISTED6# 已上市NO_NEED_FUND7# 不需要融资# -------------------------- 企业信息表模型 --------------------------classEnterpriseInfo(Model):企业信息表关联主企业表idfields.IntField(pkTrue,description主键ID)enterprise_namefields.CharField(max_length255,description企业名称)unified_social_credit_codefields.CharField(max_length50,uniqueTrue,description统一社会信用代码)legal_representativefields.CharField(max_length100,description法人代表)registered_capitalfields.CharField(max_length100,description注册资本)establish_datefields.DateField(nullTrue,description成立日期)register_statusfields.IntEnumField(enum_typeRegisterStatus,description登记状态)# 所属行业 外键行业字典表 Industryindustryfields.ForeignKeyField(tomodels.IndustryPosition,related_nameenterprise_info_list,on_deletefields.RESTRICT,description所属行业ID)company_scalefields.IntEnumField(enum_typeCompanyScale,description公司规模)financing_stagefields.IntEnumField(enum_typeFinancingStage,nullTrue,description融资阶段(可为空))headquarters_addressfields.CharField(max_length512,description总部地址)business_scopefields.TextField(description经营范围)# # 关联【企业表】外键对上一张图的 Enterprise 模型# enterprise fields.ForeignKeyField(# model_namemodels.Enterprise,# related_nameenterprise_info,# on_deletefields.CASCADE,# uniqueTrue,# description企业表ID一对一关联# )enterprise_idfields.IntField(nullTrue,description企业ID)classMeta:tablet_enterprise_infotable_description企业信息表def__str__(self):returnfEnterpriseInfo{self.enterprise_name}fromtortoiseimportfieldsfromtortoise.modelsimportModelclassEnterpriseQualification(Model):资质材料表idfields.IntField(pkTrue,description主键ID)contact_namefields.CharField(max_length100,description联系人姓名)contact_phonefields.CharField(max_length32,description联系电话)contact_emailfields.CharField(max_length128,description联系邮箱)business_license_urlfields.CharField(max_length512,nullTrue,description营业执照图片url)legal_id_front_urlfields.CharField(max_length512,nullTrue,description法人身份证正面图片url)legal_id_back_urlfields.CharField(max_length512,nullTrue,description法人身份证反面图片url)org_code_certfields.CharField(max_length256,nullTrue,description组织机构代码证)# 关联企业主表 Enterprise一对一关系# enterprise fields.ForeignKeyField(# model_namemodels.Enterprise,# related_namequalification,# on_deletefields.CASCADE,# uniqueTrue,# description企业表ID# )enterprise_idfields.IntField(nullTrue,description企业ID)classMeta:tablet_enterprise_qualificationtable_description资质材料表def__str__(self):returnfEnterpriseQualification contact:{self.contact_name}app\apis\enterprise_api.pyenterprise_router.get(/list,summary查询企业列表,description查询企业列表)asyncdefselect_enterprise_list(page:intQuery(1,title页码,description页码,ge1),page_size:intQuery(10,title每页数量,description每页数量,ge10,le50),enterprise_name:strQuery(None,title企业名称,description企业名称),submit_time_start:strQuery(None,title提交时间开始,description提交时间开始),submit_time_end:strQuery(None,title提交时间结束,description提交时间结束),):resawaitEnterpriseService.select_enterprise_list(page,page_size,enterprise_name,submit_time_start,submit_time_end)return{code:1,message:查询成功,data:res}app\schemas\enterprise.pyclassEnterpriseCreateRequest(BaseModel):enterprise_name:strField(...,description企业名称)unified_social_credit_code:strField(...,description统一社会信用代码)legal_representative:strField(...,description法人代表)registered_capital:strField(...,description注册资本)establish_date:date|NoneField(None,description成立日期)register_status:intField(...,description登记状态)industry_id:intField(...,description所属行业)company_scale:intField(...,description公司规模)financing_stage:intField(None,description融资阶段(可为空))headquarters_address:strField(...,description总部地址)business_scope:strField(...,description经营范围)# enterprise_id: int Field(None, description企业ID)contact_name:strField(...,description联系人姓名)contact_phone:strField(...,description联系电话)contact_email:strField(...,description联系邮箱)org_code_cert:strField(None,description组织机构代码证)app\services\enterprise_service.pystaticmethodasyncdefenterprise_review(enterpriseReviewCreateRequest:EnterpriseReviewCreateRequest):enterprise_identerpriseReviewCreateRequest.enterprise_id enterprise_reviewawaitEnterpriseReview.get_or_none(enterprise_identerprise_id)ifenterprise_reviewisNone:awaitEnterpriseReview.create(enterprise_identerprise_id,review_resultenterpriseReviewCreateRequest.review_result,review_reasonenterpriseReviewCreateRequest.review_reason,remarkenterpriseReviewCreateRequest.remark,review_timenow())else:enterprise_review.review_resultenterpriseReviewCreateRequest.review_resultifenterpriseReviewCreateRequest.review_resultelseenterprise_review.review_result enterprise_review.review_reasonenterpriseReviewCreateRequest.review_reasonifenterpriseReviewCreateRequest.review_reasonelseenterprise_review.review_reason enterprise_review.remarkenterpriseReviewCreateRequest.remarkifenterpriseReviewCreateRequest.remarkelseenterprise_review.remark enterprise_review.review_timenow()awaitenterprise_review.save()ifenterpriseReviewCreateRequest.review_result1:enterpriseawaitEnterprise.get_or_none(identerprise_id)enterprise.account_statusAccountStatus.NORMALawaitenterprise.save()# TODO 添加历史审核记录,发送短信(手机号)或者邮件(邮箱)给 用户2、企业审核boss-api\app\models\enterprise.pyclassEnterpriseReview(Model):企业审核表idfields.IntField(pkTrue,description主键ID)review_resultfields.IntField(nullTrue,description审核结果(1:通过,2:驳回))review_reasonfields.CharField(max_length512,nullTrue,description拒绝原因)# 备注说明remarkfields.TextField(nullTrue,description备注说明)# 审核时间audit_timefields.DatetimeField(nullTrue,description审核时间)# 审核人audit_userfields.CharField(max_length100,nullTrue,description审核人)# 关联企业主表 Enterprise一对一关系enterprise_idfields.IntField(nullTrue,description企业ID)classMeta:tablet_enterprise_reviewtable_description企业审核表boss-api\app\apis\enterprise_api.pyenterprise_router.post(/review,summary企业审核,description企业审核)asyncdefenterprise_review(enterpriseReviewCreateRequest:EnterpriseReviewCreateRequest):awaitEnterpriseService.enterprise_review(enterpriseReviewCreateRequest)return{code:1,message:审核完成}app\services\enterprise_service.pyenterprise_router.post(/review,summary企业审核,description企业审核)asyncdefenterprise_review(enterpriseReviewCreateRequest:EnterpriseReviewCreateRequest):awaitEnterpriseService.enterprise_review(enterpriseReviewCreateRequest)return{code:1,message:审核完成}3、企业端登录接口boss-api\app\apis\enterprise_api.pyenterprise_router.post(/login,summary企业登录,description企业登录)asyncdeflogin(loginMobileRequest:LoginMobileRequest):resawaitEnterpriseService.login(loginMobileRequest)return{code:1,message:登录成功,data:res}boss-api\app\services\enterprise_service.pystaticmethodasyncdeflogin(loginMobileRequest:LoginMobileRequest):enterprise_qualificationsawaitEnterpriseQualification.filter(contact_phoneloginMobileRequest.mobile)ifenterprise_qualificationsisNone:raiseException(手机号不存在)forenterprise_qualificationinenterprise_qualifications:enterprise_identerprise_qualification.enterprise_id logger.info(fenterprise_id:{enterprise_id})enterprise_reviewawaitEnterpriseReview.get_or_none(enterprise_identerprise_id)logger.info(fenterprise_review:{enterprise_review})ifenterprise_review.review_result1:# 审核通过keyfboss-api:enterprise-login:sms:{loginMobileRequest.mobile}redis_coderedis_client.get(key)ifredis_codeisNone:raiseException(验证码已过期)ifredis_code!loginMobileRequest.code:raiseException(验证码错误)access_token,refresh_tokencreate_tokens(str(enterprise_id),loginMobileRequest.mobile)logger.info(f生成 access_token:{access_token})logger.info(f生成 refresh_token:{refresh_token})redis_client.delete(key)return{enterprise_access_token:access_token,enterprise_refresh_token:refresh_token,}raiseException(账号未审核通过)