def add_news():
form = JobsForm()
if form.validate_on_submit():
session = create_session()
job = Jobs()
job.team_leader = form.team_leader.data
job.job = form.job.data
job.work_size = form.work_size.data
job.collaborators = form.collaborators.data
job.is_finished = form.is_finished.data
session.add(job)
session.commit()
return redirect('/')
return render_template('jobs.html', title='Adding a job',
form=form)
def add_job():
form = AddJobForm()
if form.validate_on_submit():
db_sess = db_session.create_session()
jobs = Jobs()
jobs.team_leader = form.team_leader.data
jobs.job = form.job.data
jobs.work_size = form.work_size.data
jobs.collaborators = form.collaborators.data
jobs.is_finished = form.is_finished.data
current_user.jobs.append(jobs)
db_sess.merge(current_user)
db_sess.commit()
return redirect("/")
return render_template("job.html", title="Добавление работы", form=form)
def create_job():
if not request.json:
return jsonify({'error': 'Empty request'})
elif not all(
key in request.json
for key in ['team_leader', 'job', 'collaborators', 'work_size']):
return jsonify({'error': 'Bad request'})
session = db_session.create_session()
jobs = Jobs(team_leader=request.json['team_leader'],
job=request.json['job'],
work_size=request.json['work_size'],
collaborators=request.json['collaborators'])
session.add(jobs)
session.commit()
return jsonify({'success': 'OK'})
def add_job():
form = JobsForm()
if form.validate_on_submit():
db_sess = create_session()
jobs = Jobs()
jobs.job = form.job.data
jobs.team_leader = form.team_leader.data
jobs.work_size = form.work_size.data
jobs.collaborators = form.collaborators.data
jobs.is_finished = form.is_finished.data
current_user.jobs.append(jobs)
db_sess.merge(current_user)
db_sess.commit()
return redirect('/')
return render_template('jobs.html', title='Adding a Job', form=form)
def addjob():
add_form = AddJobForm()
if add_form.validate_on_submit():
session = db_session.create_session()
jobs = Jobs(
job=add_form.job.data,
team_leader=add_form.team_leader.data,
work_size=add_form.work_size.data,
collaborators=add_form.collaborators.data,
is_finished=add_form.is_finished.data
)
session.add(jobs)
session.commit()
return redirect('/')
return render_template('addjob.html', title='Adding a job', form=add_form)
def addjob():
form = AddJobForm()
if form.validate_on_submit():
sess = db_session.create_session()
job = Jobs(team_leader=form.team_lead.data,
job=form.title.data,
work_size=form.size.data,
collaborators=form.collaborators.data,
is_finished=form.finished.data)
for i in map(int, job.collaborators.split(', ')):
user = sess.query(User).filter(User.id == i).first()
user.jobs.append(job)
sess.commit()
return redirect('/')
return render_template('add_job.html', form=form, title='Adding a Job')
def post(self):
args = self.parse().parse_args()
session = db_session.create_session()
job = Jobs(
work_size=args['work_size'],
job=args['job'],
collaborators=args['collaborators'],
team_leader=args['team_leader'],
start_date=datetime.datetime.now(),
end_date=datetime.datetime.now(),
is_finished=args['is_finished']
)
session.add(job)
session.commit()
return jsonify({'success': 'OK'})
def adding_job():
form = AddingJob()
if form.validate_on_submit():
connect = db_session.create_session()
job = Jobs(team_leader=form.team_leader.data,
job=form.job.data,
work_size=form.work_size.data,
collaborators=form.collaborators.data,
is_finished=form.is_finished.data,
start_date=datetime.datetime.now(),
creater_id=current_user.id)
connect.add(job)
connect.commit()
return redirect("/")
return render_template('adding_job.html', title='Регистрация', form=form)
def main():
db_session.global_init('db/mars_explorer.db')
ex_job = Jobs()
ex_job.team_leader = 1
ex_job.job = 'deployment of residential modules 1'
ex_job.work_size = 15
ex_job.collaborators = 2
ex_job.start_date = datetime.date.today()
ex_job.is_finished = False
db_sess = db_session.create_session()
db_sess.add(ex_job)
db_sess.commit()
ex_job = Jobs()
ex_job.team_leader = 1
ex_job.job = 'deployment of residential modules 2'
ex_job.work_size = 20
ex_job.collaborators = 3
ex_job.start_date = datetime.date.today()
ex_job.is_finished = False
db_sess = db_session.create_session()
db_sess.add(ex_job)
db_sess.commit()
def edit_job(id):
form = JobsForm()
if request.method == "GET":
session = db_session.create_session()
job = session.query(Jobs).filter(Jobs.id == id).first()
if job:
form.job.data = job.job
form.team_leader.data = job.team_leader
form.work_size.data = job.work_size
form.collaborators.data = job.collaborators
form.start_date.data = job.start_date
form.end_date.data = job.end_date
form.is_finished.data = job.is_finished
cats = ""
for i in job.categories:
cats += str(i.id) + ","
form.categories.data = cats[:-1]
else:
abort(404)
if form.validate_on_submit():
session = db_session.create_session()
job = session.query(Jobs).filter(Jobs.id == id,
((Jobs.creator == current_user.id) |
(current_user.id == 1))).first()
if job:
creatorr = job.creator
session.delete(job)
job = Jobs()
job.team_leader = form.team_leader.data
job.job = form.job.data
job.work_size = form.work_size.data
job.collaborators = form.collaborators.data
job.start_date = form.start_date.data
job.end_date = form.end_date.data
job.is_finished = form.is_finished.data
job.creator = creatorr
for i in job.categories:
job.categories.remove(HazardCategory(name=i.name))
categories = HazardCategory(name=form.categories.data)
job.categories.append(categories)
session.add(job)
session.commit()
return redirect('/page')
else:
abort(404)
return render_template('edit_job.html',
title='Редактирование работы',
form=form)
def add_news():
if not current_user.is_authenticated:
return redirect('/')
form = JobsForm()
if form.validate_on_submit():
session = db_session.create_session()
news = Jobs()
news.title = form.title.data
news.content = form.content.data
news.is_private = form.is_private.data
current_user.news.append(news)
session.merge(current_user)
session.commit()
return redirect('/')
return render_template('jobs.html',
form=form)
def add_job():
session = db_session.create_session()
form = JobForm()
if form.validate_on_submit():
job = Jobs(
team_leader=form.team_leader.data,
job=form.job.data,
work_size=form.work_size.data,
is_finished=form.is_finished.data,
collaborators=form.collaborators.data
# about=form.about.data
)
session.add(job)
session.commit()
return redirect('/')
return render_template('addjob.html', title='Добавление работы', form=form)
def add_jobs():
form = AddJobForm()
if form.validate_on_submit():
db_sess = db_session.create_session()
job = Jobs()
job.job = form.job.data
job.team_leader = form.team_leader.data
job.work_size = form.work_size.data
job.collaborators = form.collaborators.data
job.is_finished = form.is_finished.data
db_sess.add(job)
db_sess.commit()
return redirect('/')
return render_template('add_jobs.html',
title='Добавление работы',
form=form)
def add_jobs():
form = WorksForm()
if form.validate_on_submit():
session = db_session.create_session()
jobs = Jobs()
jobs.job = form.job.data
jobs.team_leader = form.team_leader.data
jobs.collaborators = form.collaborators.data
jobs.work_size = form.work_size.data
jobs.hazard_category = form.hazard_category.data
jobs.is_finished = form.is_finished.data
current_user.User.append(jobs)
session.merge(current_user)
session.commit()
return redirect('/')
return render_template('works.html', title='Добавление работы', form=form)
def put(self):
args = parser.parse_args()
session = db_session.create_session()
jobs = Jobs(
team_leader=args['team_leader'],
job=args['job'],
work_size=args['work_size'],
collaborators=args['collaborators'],
end_date=args['end_date'],
is_finished=bool(args['is_finished']),
creater_id=args['creater_id'],
start_date=datetime.datetime.now()
)
session.add(jobs)
session.commit()
return jsonify({'success': 'OK - job is added'})
def post(self):
args = parser.parse_args()
db_sess = db_session.create_session()
job = Jobs(
id=args['id'],
team_leader=args['team_leader'],
job=args['job'],
work_size=args['work_size'],
collaborators=args['collaborators'],
start_date=args['start_date'],
end_date=args['end_date'],
is_finished=args['is_finished']
)
db_sess.add(job)
db_sess.commit()
return {404: 'OK'}
def add_jobs():
form = WorksForm()
if form.validate_on_submit():
db_sess = db_session.create_session()
jobs = Jobs()
jobs.team_leader = form.content2.data
jobs.job = form.content1.data
jobs.work_size = form.content3.data
jobs.collaborators = form.content4.data
jobs.is_finished = form.content5.data
current_user.jobs.append(jobs)
db_sess.merge(current_user)
db_sess.commit()
return redirect('/')
return render_template('addj.html', title='Добавление работы',
form=form)
def adding_job():
form = AddingJobForm()
if form.validate_on_submit():
db_session.global_init("db/mars.db")
db_sess = db_session.create_session()
job = Jobs()
job.job = form.job.data
job.team_leader = form.team_leader_id.data
job.work_size = form.work_size.data
job.collaborators = form.collaborators.data
job.start_date = datetime.now()
job.is_finished = form.is_job_finished.data
db_sess.add(job)
db_sess.commit()
return redirect("/")
return render_template('add_job.html', 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 add_job():
form = JobsForm()
if form.validate_on_submit():
session = db_session.create_session()
job = Jobs(team_leader=form.team_leader.data,
job=form.job.data,
work_size=form.work_size.data,
collaborators=form.collaborators.data,
is_finished=form.is_finished.data,
start_date=datetime.now())
categ = Category()
categ.name = form.category.data
job.category.append(categ)
session.add(job)
session.commit()
return redirect('/works/')
return render_template('addjob.html', title='Добавление работы', form=form)
def add_job():
form = forms.JobForm()
if form.validate_on_submit():
session = db_session.create_session()
job = Jobs(job=form.job.data,
is_finished=form.is_finished.data,
team_leader=form.team_leader.data,
collaborators=form.collaborators.data,
start_date=datetime.now(),
work_size=form.work_size.data)
session.add(job)
session.commit()
return redirect(url_for("index"))
return render_template('form.html',
title='Edit job',
form=form,
form_title="Add a job")
def g():
db_session.global_init(f"db/main_data_base.db")
user = Jobs()
user.team_leader = 1
user.job = "deployment of residential modules 1 and 2"
user.work_size = 15
user.collaborators = '2, 3'
user.start_date = datetime.datetime.now()
user.is_finished = False
connect = db_session.create_session()
connect.add(user)
connect.commit()
connect = db_session.create_session()
listt = []
for user in connect.query(Jobs):
listt.append(user)
return render_template('jobs.html', listt=listt)
def post(self):
args = parser.parse_args()
session = db_session.create_session()
if args['id'] <= 0:
abort(404, message=f"Id must be > 0")
may_b = session.query(Jobs).filter(Jobs.id == args['id']).first()
if may_b:
abort(404, message=f"Job with id {args['id']} already exist")
job = Jobs(id=args['id'],
team_leader=args['team_leader'],
job=args['job'],
work_size=args['work_size'],
collaborators=args['collaborators'],
is_finished=args['is_finished'])
session.add(job)
session.commit()
return jsonify({'success': 'OK'})
def add_job_func(team_leader,
job,
work_size=None,
collaborators=None,
start_date=None,
end_date=None,
is_finished=None):
session = db_session.create_session()
new_job = Jobs()
new_job.team_leader = team_leader
new_job.job = job
new_job.work_size = work_size
new_job.collaborators = collaborators
new_job.start_date = start_date
new_job.end_date = end_date
new_job.is_finished = is_finished
session.add(new_job)
session.commit()
def addjob():
if current_user.is_authenticated:
add_form = AddJobForm()
if add_form.validate_on_submit():
print(1)
db_sess = db_session.create_session()
jobs = Jobs(job=add_form.job.data,
team_leader=current_user.id,
work_size=add_form.work_size.data,
collaborators=add_form.collaborators.data,
is_finished=add_form.is_finished.data)
db_sess.add(jobs)
db_sess.commit()
return redirect('/')
return render_template('addjob.html',
title='Добавить вакансию',
form=add_form)
return redirect('/')
def add_jobs():
form = JobsForm()
if form.validate_on_submit():
db_sess = db_session.create_session()
jobs = Jobs()
jobs.job = form.job.data
jobs.team_leader = form.team_leader.data
jobs.work_size = form.work_size.data
jobs.collaborators = form.list_collaborators.data
jobs.is_finished = form.is_finished.data
jobs.categories.append(
db_sess.query(HazardCategory).filter(
HazardCategory.id == form.category.data).first())
# current_user.job.append(jobs)
db_sess.merge(current_user)
db_sess.commit()
return redirect('/')
return render_template('jobs.html', title='Добавление работы', form=form)