def get_projects_for_admin(admin_id: int, preferred_locale: str) -> PMDashboardDTO:
""" Get projects for admin """
admins_projects = db.session.query(Project.id,
Project.status,
Project.campaign_tag,
Project.total_tasks,
Project.tasks_mapped,
Project.tasks_validated,
Project.tasks_bad_imagery,
Project.created,
Project.last_updated,
Project.default_locale,
AreaOfInterest.centroid.ST_AsGeoJSON().label('geojson'))\
.join(AreaOfInterest).filter(Project.author_id == admin_id).all()
if admins_projects is None:
raise NotFound('No projects found for admin')
admin_projects_dto = PMDashboardDTO()
for project in admins_projects:
pm_project = Project.get_project_summary(project, preferred_locale)
project_status = ProjectStatus(project.status)
if project_status == ProjectStatus.DRAFT:
admin_projects_dto.draft_projects.append(pm_project)
elif project_status == ProjectStatus.PUBLISHED:
admin_projects_dto.active_projects.append(pm_project)
elif project_status == ProjectStatus.ARCHIVED:
admin_projects_dto.archived_projects.append(pm_project)
else:
current_app.logger.error(f'Unexpected state project {project.id}')
return admin_projects_dto
def get_projects_for_admin(admin_id: int, preferred_locale: str) -> PMDashboardDTO:
""" Get projects for admin """
admins_projects = Project.query.filter_by(author_id=admin_id).all()
if admins_projects is None:
raise NotFound('No projects found for admin')
admin_projects_dto = PMDashboardDTO()
for project in admins_projects:
pm_project = project.get_project_summary(preferred_locale)
project_status = ProjectStatus(project.status)
if project_status == ProjectStatus.DRAFT:
admin_projects_dto.draft_projects.append(pm_project)
elif project_status == ProjectStatus.PUBLISHED:
admin_projects_dto.active_projects.append(pm_project)
elif project_status == ProjectStatus.ARCHIVED:
admin_projects_dto.archived_projects.append(pm_project)
else:
current_app.logger.error(f'Unexpected state project {project.id}')
return admin_projects_dto