def project_list_mine_detail(pid): p = Project.query.filter_by(id=pid).first_or_404() if p.bp_url: bp_file = File.query.filter_by(server_name=p.bp_url).first() bp_url = get_file_url(bp_file.server_name, bp_file.local_name) p.bp_url = bp_url if p.icon_url: icon_file = File.query.filter_by(server_name=p.icon_url).first() icon_url = get_file_url(icon_file.server_name, icon_file.server_name) p.icon_url = icon_url return render_template('investor/project_list_mine_detail.html', project=p)
def show_project(pid): project = Project.query.filter_by(id=pid).first() if project.bp_url: bp_file = File.query.filter_by(server_name=project.bp_url).first() bp_url = get_file_url(bp_file.server_name, bp_file.local_name) project.bp_url = bp_url if project.icon_url: icon_file = File.query.filter_by(server_name=project.icon_url).first() icon_url = get_file_url(icon_file.server_name, icon_file.server_name) project.icon_url = icon_url return render_template('investor/project_detail.html', project=project)
def get(self, name): file = File.query.filter_by(server_name=name).first() if file: url = get_file_url(file.server_name, file.local_name) return url return None
def get_url(name): bp_file = File.query.filter_by(server_name=name).first() if bp_file: bp_url = get_file_url(bp_file.server_name, bp_file.local_name) return bp_url return None
def show_project(pid): project = Project.query.filter_by( id=pid, owner_id=user_manager.current_user.get_id()).first_or_404() if project.bp_url: bp_file = File.query.filter_by(server_name=project.bp_url).first() if bp_file: bp_url = get_file_url(bp_file.server_name, bp_file.local_name) if bp_url: project.bp_url = bp_url if project.icon_url: icon_file = File.query.filter_by(server_name=project.icon_url).first() if icon_file: icon_url = get_file_url(icon_file.server_name, icon_file.server_name) if icon_url: project.icon_url = icon_url before = project.phase_start present = datetime.datetime.now() days = (present - before).days pp = ProjectPhase.query.filter_by(project_id=project.id, phase_id=project.phase_index).first() if pp: project.ppid = pp.id else: project.ppid = 0 pas = PhaseAttachment.query.filter_by(phase_id=project.phase_index).all() attachments = Attachment.query.filter( Attachment.id.in_([pa.attachment_id for pa in pas])).all() return render_template('startup/project_detail.html', project=project, days=days, attachments=attachments)
def project_list_all(): projects = Project.query.all() for project in projects: if project.bp_url: bp_file = File.query.filter_by(server_name=project.bp_url).first() if bp_file: bp_url = get_file_url(bp_file.server_name, bp_file.local_name) project.bp_url = bp_url if project.icon_url: icon_file = File.query.filter_by( server_name=project.icon_url).first() if icon_file: icon_url = get_file_url(icon_file.server_name, icon_file.server_name) project.icon_url = icon_url return render_template('investor/project_list_all.html', projects=projects)
def project_list_mine(): # projects = Project.query.filter(Project.id.in_([f.project_id for f in FavoriteProjects.query.filter_by(investor_id=user_manager.current_user.id).all()])).all() projects = user_manager.current_user.favorite_projects for project in projects: if project.bp_url: bp_file = File.query.filter_by(server_name=project.bp_url).first() bp_url = get_file_url(bp_file.server_name, bp_file.local_name) project.bp_url = bp_url if project.icon_url: icon_file = File.query.filter_by( server_name=project.icon_url).first() icon_url = get_file_url(icon_file.server_name, icon_file.server_name) project.icon_url = icon_url return render_template('investor/project_list_mine.html', projects=projects)
def project_list(): projects = Project.query.filter_by( owner_id=user_manager.current_user.get_id()).all() for project in projects: if project.icon_url: icon_file = File.query.filter_by( server_name=project.icon_url).first() if icon_file: icon_url = get_file_url(icon_file.server_name, icon_file.server_name) project.icon_url = icon_url return render_template('startup/project_list.html', projects=projects)
def get_url(): from app.utils.sts import get_file_url url = get_file_url('demo.jpg', 'apple.jpg') return url