def add_job():
form = JobsForm()
if form.validate_on_submit():
session = create_session()
job = Jobs()
job.customer = current_user.id
job.title = form.title.data
job.cost = form.cost.data
job.description = form.description.data
job.brief = ''.join(form.description.data[:30] + '...')
job.category = form.category.data
job.category_2 = form.category_2.data
UPLOAD_DIR: Path = Path(__file__).parent / 'static/jobs_img'
UPLOAD_DIR.mkdir(parents=True, exist_ok=True)
for upload in request.files.getlist('images'):
filename = secure_filename(upload.filename)
if filename != '':
save_path = str(UPLOAD_DIR / filename)
upload.save(save_path)
job.img = '\\static' + save_path.split("\\static")[1]
session.add(job)
session.merge(current_user)
session.commit()
return redirect('/')
return render_template('job_add.html', title='Adding a job', form=form)
def add_job():
form = JobsForm()
session = db_session.create_session()
jobs = Jobs()
if form.validate_on_submit():
jobs.description = form.description.data
jobs.employer = current_user
jobs.address = form.address.data
jobs.date = form.date.data
jobs.info = form.info.data
address = form.address.data
geocoder_api_server = "http://geocode-maps.yandex.ru/1.x/"
geocoder_params = {
"apikey": "40d1649f-0493-4b70-98ba-98533de7710b",
"geocode": address,
"format": "json"
}
response = requests.get(geocoder_api_server, params=geocoder_params)
if response:
json_response = response.json()
toponym = json_response["response"]["GeoObjectCollection"][
"featureMember"][0]["GeoObject"]
jobs.coords = toponym["Point"]["pos"]
user = session.query(User).filter(User.id == current_user.id).first()
user.job.append(jobs)
session.merge(user)
session.commit()
return redirect('/myjobs')
return render_template('jobs.html',
title='Добавление обращения',
form=form)
def add_job():
form = JobForm()
if form.validate_on_submit():
db_sess = db_session.create_session()
job = Jobs()
job.description = form.description.data
job.work_size = form.work_size.data
job.collaborators = form.collaborators.data
job.team_leader = form.team_leader.data
job.start_date = datetime.datetime.strptime(form.start_date.data, "%d/%m/%Y %H:%M")
job.end_date = datetime.datetime.strptime(form.end_date.data, "%d/%m/%Y %H:%M")
job.is_finished = form.is_finished.data
db_sess.add(job)
db_sess.commit()
return redirect('/index')
return render_template('addjob.html', form=form)
def createData():
session = db_session.create_session()
if session.query(Jobs).count() > 0:
return
user = User()
leader1 = user
user.surname = "Scott"
user.name = "Ridley"
user.position = "captain"
user.speciality = "research engineer"
user.address = "module_1"
user.email = "*****@*****.**"
session.add(user)
user = User()
leader2 = user
user.surname = "Weir"
user.name = "Andy"
user.position = "helper of captain"
user.speciality = "engineer"
user.address = "module_2"
user.email = "*****@*****.**"
session.add(user)
user = User()
user.surname = "Wotny"
user.name = "Mark"
user.position = "member"
user.speciality = "board engineer"
user.address = "module_3"
user.email = "*****@*****.**"
session.add(user)
user = User()
leader3 = user
user.surname = "Sanders"
user.name = "Teddy"
user.position = "member"
user.speciality = "explorer"
user.address = "module_3"
user.email = "*****@*****.**"
session.add(user)
# session.commit()
job = Jobs()
job.team_leader = leader1
job.description = 'deployment of residential modules 1 and 2'
job.start_date = datetime.datetime(2012, 3, 3, 10, 10, 10)
job.work_size = 15
job.collaborators = "2, 3"
job.is_finished = False
session.add(job)
job = Jobs()
job.team_leader = leader2
job.description = 'Exploration of mineral resources'
job.start_date = datetime.datetime(2012, 3, 3, 10, 10, 10)
job.work_size = 15
job.collaborators = "4, 3"
job.is_finished = False
session.add(job)
job = Jobs()
job.team_leader = leader3
job.description = 'Development of a management system'
job.start_date = datetime.datetime(2012, 3, 3, 10, 10, 10)
job.work_size = 25
job.collaborators = "5"
job.is_finished = False
session.add(job)
session.commit()
