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