def edit_department(id):
"""
Edit a department
"""
check_admin()
add_department = False
department = Department.query.get_or_404(id)
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.name = form.name.data
department.description = form.description.data
db.session.commit()
flash('You have successfully edited the department.')
# redirect to the departments page
return redirect(url_for('admin.list_departments'))
form.description.data = department.description
form.name.data = department.name
return render_template('admin/departments/department.html',
action="Edit",
add_department=add_department,
form=form,
department=department,
title="Edit Department")
def add_department():
"""
Add a department to the database
"""
check_admin()
add_department = True
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
description=form.description.data)
try:
# add department to the database
db.session.add(department)
db.session.commit()
flash('You have successfully added a new department.')
except:
# in case department name already exists
flash('Error: department name already exists.')
# redirect to departments page
return redirect(url_for('admin.list_departments'))
# load department template
return render_template('admin/departments/department.html', action="Add",
add_department=add_department, form=form,
title="Add Department")
def add_department():
"""
Adicionar um departamento ao DB
"""
check_admin()
add_department = True
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
description=form.description.data)
try:
db.session.add(department)
db.session.commit()
flash('Voce adicionou com sucesso um novo departamento.')
except:
flash('Erro: nome do departamento ja existe.')
return redirect(url_for('admin.list_departments'))
return render_template('admin/departments/department.html',
action="Add",
add_department=add_department,
form=form,
title="Adicionar Departamento")
def edit_department(id):
"""
Editar um departamento
"""
check_admin()
add_department = False
department = Department.query.get_or_404(id)
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.name = form.name.data
department.description = form.description.data
db.session.commit()
flash('Voce editou com sucesso o departamento.')
return redirect(url_for('admin.list_departments'))
form.description.data = department.description
form.name.data = department.name
return render_template('admin/departments/department.html',
action="Editar",
add_department=add_department,
form=form,
department=department,
title="Editar Departamento")
def edit_dep(id):
form = DepartmentForm()
if request.method == "GET":
session = db.create_session()
dep = session.query(models.departments.Dep).filter(
models.departments.Department.id == id,
((models.departments.Department.user == current_user) |
(current_user.id == 1))).first()
if dep:
form.title.data = dep.title
form.members.data = dep.members
form.chief.data = dep.chief
form.email.data = dep.email
else:
abort(404)
if form.validate_on_submit():
session = db.create_session()
job = session.query(models.jobs.Jobs).filter(
models.jobs.Jobs.id == id,
((models.jobs.Jobs.user == current_user) |
(models.jobs.Jobs.team_leader == 1))).first()
if job:
title = form.title.data
members = form.members.data
chief = form.chief.data
emai = form.email.data
session.commit()
return redirect('/departments')
else:
abort(404)
return render_template('new_dep.html',
title='Редактирование новости',
form=form)
def edit_department(id):
""" edit a department """
check_admin()
add_department = False
# this department object stores and carries over the information
# querried from the database
department = Department.query.get_or_404(id)
# simplifies the creation of object form without using the constructor that takes in the database columns
# as parametres e.g in the add_department view
form = DepartmentForm(obj=department)
if form.validate_on_submit():
# replacing existing information in database with the new changes
department.name = form.name.data
department.description = form.description.data
db.session.commit()
flash('you have successfully edited the department.')
# redirect to the departments page to view the new changes
return redirect(url_for('admin.list_departments'))
# this seems like a repetition of form = DepartmentForm(obj=department)
# taking te information from database to be displayed in the editing form
form.description.data = department.description
form.name.data = department.name
return render_template('admin/departments/department.html',
action="Edit",
add_department=add_department,
form=form,
department=department,
title="Edit Department")
def edit_department(id):
check_admin()
add_department = False
department = Department.query.get_or_404(id)
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.name = form.name.data
department.description = form.description.data
try:
db.session.commit()
logger.info('department edited succesflly')
flash('You have successfully edited the department.')
return redirect(url_for('admin.list_departments'))
except Exception as e:
logger.error('department couldnt be edited')
flash("cannot edit department try again")
form.description.data = department.description
form.name.data = department.name
return render_template('admin/departments/department.html',
action="Edit",
add_department=add_department,
form=form,
department=department,
title="Edit Department")
def add_department():
check_admin()
add_department = True
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
description=form.description.data)
try:
db.session.add(department)
db.session.commit()
logger.info('department added successfully')
flash('You have successfully added a new department.')
except:
logger.error('department couldnt be added')
flash('Error: department name already exists.')
return redirect(url_for('admin.list_departments'))
return render_template('admin/departments/department.html',
action="Add",
add_department=add_department,
form=form,
title="Add Department")
def edit_department(id):
"""
Edit a department
"""
add_department = False
department = Department.query.get_or_404(id)
form = DepartmentForm(
obj=department
) # pass obj to the form (To edit the form, load data from database to fill the form)
if form.validate_on_submit(
): # method is POST ( only if the form is submitted)
department.name = form.name.data
department.description = form.description.data
db.session.commit()
flash('You have successfully edited the department.')
# redirect to the departments page
return redirect(url_for('admin.list_departments'))
form.description.data = department.description
form.name.data = department.name
return render_template('admin/departments/department.html',
action="Edit",
add_department=add_department,
form=form,
department=department,
title="Edit Department")
def add_department():
"""
Add a department to the database
"""
check_admin()
add_department = True
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
description=form.description.data)
try:
# add department to the database
db.session.add(department)
db.session.commit()
flash('Novo departamento adicionado com sucesso.')
except:
# in case department name already exists
flash('Erro: nome do departamento ja existe.')
# redirect to departments page
return redirect(url_for('admin.list_departments'))
# load department template
return render_template('admin/departments/department.html',
action="Add",
add_department=add_department,
form=form,
title="Adicionar Departamento")
def add():
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
user_id=form.dept_admin.data)
db.session.add(department)
db.session.commit()
flash('You have successfully added a new department.')
return redirect(url_for('admin.view'))
return render_template('admin/add.html', form=form, title="Add Department")
def add():
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
user_id=form.dept_admin.data)
db.session.add(department)
db.session.commit()
flash('You have successfully added a new department.')
return redirect(url_for('admin.view'))
return render_template('admin/add.html', form = form, title = "Add Department")
def insert_into_department(request) :
if request.method == 'POST' :
form = DepartmentForm(request.POST)
if form.is_valid() :
c = connection.cursor()
dept_name = form.cleaned_data['dept_name']
HOD = form.cleaned_data['HOD']
floor_no = form.cleaned_data['floor_no']
c.execute("insert into department VALUES(%s , %s , %s )" , [dept_name , HOD , floor_no])
c.close()
return HttpResponseRedirect("/mani_tables/show_department")
def add_department():
"""
Add a department to the database
"""
check_admin()
add_department = True
form = DepartmentForm()
if form.validate_on_submit():
department = Department(name=form.name.data,
description=form.description.data)
try:
# add department to the database
db.session.add(department)
db.session.commit()
try:
ak1 = Attacker(name='Cyberkrieg(Staaten)', wert=4)
ak2 = Attacker(name='Cyber-Terroristen', wert=4)
ak3 = Attacker(name='Organisierte Cyberkriminelle', wert=3)
ak4 = Attacker(name='Cyberkriminelle Einzeltater', wert=2)
ak5 = Attacker(name='Hacker-Gruppen', wert=2)
ak6 = Attacker(name='Cyber-Aktivist', wert=2)
ak7 = Attacker(name='Skriptkiddies', wert=1)
ak8 = Attacker(name='Unzufriedener Mitarbeiter', wert=1)
db.session.add(ak1)
db.session.add(ak2)
db.session.add(ak3)
db.session.add(ak4)
db.session.add(ak5)
db.session.add(ak6)
db.session.add(ak7)
db.session.add(ak8)
db.session.commit()
except:
db.session.rollback()
flash('You have successfully added a new department.')
except:
# in case department name already exists
flash('Error: department name already exists.')
# redirect to departments page
return redirect(url_for('admin.list_departments'))
# load department template
return render_template('admin/departments/department.html',
action="Add",
add_department=add_department,
form=form,
title="Add Department")
def edit_department(id):
"""
Edit an entry
"""
check_admin()
add_department = False
department = Department.query.get_or_404(id)
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.accNum = form.accNum.data
department.name = form.name.data
#department.description = form.description.data
#department.Normalside = form.Normalside.data
department.AccCategory = form.AccCategory.data
#department.SaccCategory = form.SaccCategory.data
#department.iBalance = form.iBalance.data
#department.debit = form.debit.data
#department.credit = form.credit.data
department.balance = form.balance.data
department.Dtime = form.Dtime.data
#department.statement =form.statement.data
department.Comment = form.Comment.data
db.session.commit()
flash('You have successfully edited the account.')
# redirect to the departments page
return redirect(url_for('admin.list_departments'))
form.accNum.data = department.accNum
form.name.data = department.name
#form.description.data = department.description
#form.Normalside.data = department.Normalside
form.AccCategory.data = department.AccCategory
#form.SaccCategory.data = department.SaccCategory
#form.iBalance.data = department.iBalance
#form.debit.data = department.debit
#form.credit.data = department.credit
form.balance.data = department.balance
form.Dtime.data = department.Dtime
#form.statement.data = department.statement
form.Comment.data = department.Comment
return render_template('admin/departments/department.html',
action="Edit",
add_department=add_department,
form=form,
department=department,
title="Edit account")
def edit(id):
department = Department.query.get_or_404(id)
# if current_user.id != issue.user_id:
# abort(403)
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.name = form.name.data
department.user_id = form.dept_admin.data
db.session.add(department)
db.session.commit()
return redirect(url_for('admin.view'))
form.name.data = department.name
form.dept_admin.data = department.user_id
return render_template('admin/edit.html', form=form, title="Edit Department")
def department_add(request, template_name='departments/department_add.html'):
form = DepartmentForm(request.POST or None)
username = request.session['username']
print username
if form.is_valid():
print form
form.save()
return redirect('department_list')
return render(request, template_name, {
'form': form,
'username': username,
'var3': 'active',
})
def departments(request):
if request.POST:
form = DepartmentForm(request.POST)
if form.is_valid():
form.save()
return HttpResponseRedirect('/departments/')
else:
form = DepartmentForm()
title = "Departments"
types = Department.objects.all()
url = "departments"
return render(request, 'add.html', locals())
def new_dep():
form = DepartmentForm()
if form.validate_on_submit():
session = db.create_session()
dep = models.departments.Department(title=form.title.data,
members=form.members.data,
chief=form.chief.data,
email=form.email.data)
session.add(dep)
session.commit()
return redirect('/departments')
return render_template('new_dep.html',
title='New departments',
form=form,
current_user=current_user)
def add_department_view(request):
from forms import DepartmentForm
form = None
if request.method == 'POST':
form = DepartmentForm(request.POST)
if form.is_valid():
form.save()
else:
form = DepartmentForm()
deps = main_utils.get_all_departments()
from django.template import RequestContext
return render_to_response('maitenance/department.html', RequestContext(request, {'form': form, 'deps': deps}))
def edit(id):
department = Department.query.get_or_404(id)
# if current_user.id != issue.user_id:
# abort(403)
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.name = form.name.data
department.user_id = form.dept_admin.data
db.session.add(department)
db.session.commit()
return redirect(url_for('admin.view'))
form.name.data = department.name
form.dept_admin.data = department.user_id
return render_template('admin/edit.html',
form=form,
title="Edit Department")
def edit_department(id):
qry = db.session.query(Department).filter(
Department.id == id
) #When you use the contains word then strings with that word will be returned which may not be the case for male, it would also return female coz the word male is in female
department = qry.first()
if department:
form = DepartmentForm(
formdata=request.form,
obj=department) #You can also pass None to the formdata parameter
if request.method == 'POST' and form.validate():
department.name = form.name.data
db.session.add(department)
db.session.commit()
return render_template('departments/edit_department.html',
department=department,
form=form)
def department_edit(request,
pk,
template_name='departments/department_add.html'):
username = request.session['username']
deps = get_object_or_404(Department, pk=pk)
form = DepartmentForm(request.POST or None, instance=deps)
if form.is_valid():
form.save()
return redirect('department_list')
return render(request, template_name, {
'form': form,
'username': username,
'var3': 'active',
'deps': deps,
})
def departments():
form = DepartmentForm()
if form.validate_on_submit():
department_to_add = form.name.data.title()
dept_check = Department.query.filter_by(name=department_to_add).first()
if dept_check:
flash('This department already exists.')
return redirect(url_for('departments'))
else:
new_department = Department(name=department_to_add,
user_id=current_user.id)
db.session.add(new_department)
db.session.commit()
flash('New department added to the list.')
return redirect(url_for('departments'))
department_list = Department.query.filter_by(user_id=current_user.id).order_by(Department.name).all()
return render_template('departments.html', department_list=department_list, form=form)
def creating_department():
departments = Department.query.all()
form = DepartmentForm(request.form)
if request.method == "POST":
name = form.name.data
chief = form.chief.data
Department.save(Department(name=name, chief=chief))
return render_template('department.html',
departments=departments,
form=form)
def create_department():
#pass the model where the data is to be sent for saving ie department model
#Pass the form data from the frontend
form = DepartmentForm(request.form)
if request.method == 'POST':
department = Department()
department.name = form.name.data
db.session.add(department)
db.session.commit()
return render_template('departments/create_department.html', form=form)
def add_department():
"""
Add a department to the database
"""
check_admin()
add_department = True
form = DepartmentForm()
if form.validate_on_submit():
department = Department(
accNum=form.accNum.data,
name=form.name.data,
#description = form.description.data,
#Normalside = form.Normalside.data,
AccCategory=form.AccCategory.data,
#SaccCategory = form.SaccCategory.data,
#iBalance = form.iBalance.data,
#debit = form.debit.data,
#credit = form.credit.data,
balance=form.balance.data,
Dtime=form.Dtime.data,
#statement = form.statement.data,
Comment=form.Comment.data)
try:
# add department to the database
db.session.add(department)
db.session.commit()
flash('You have successfully added a new entry.')
except:
# in case department name already exists
flash('Error: entry name already exists.')
# redirect to departments page
return redirect(url_for('admin.list_departments'))
# load department template
return render_template('admin/departments/department.html',
action="Add",
add_department=add_department,
form=form,
title="Add Account")
def delete_department(id):
qry = db.session.query(Department).filter(Department.id == id)
department = qry.first()
if department:
form = DepartmentForm(formdata=request.form, obj=department)
""" This will delete the member objects associated with the department from the members' database"""
for member in department.department_member: #This displays the individual member objects associated with the department object
qry = db.session.query(DepMember).filter(DepMember.id == member.id)
member = qry.first()
db.session.delete(member)
db.session.commit()
if request.method == 'POST' and form.validate():
db.session.delete(department)
db.session.commit()
#pass a redirect after deleting the department object
return render_template('departments/delete.html',
form=form,
department=department)
else:
return 'Error deleting #{id}'.format(id=id)
def view():
qry = db.session.query(Department).filter(
Department.name == "personal ministries"
) #When you use the contains word then strings with that word will be returned which may not be the case for male, it would also return female coz the word male is in female
department = qry.all()
#departmentals = department.department_members
if department:
form = DepartmentForm(formdata=None, obj=department)
return render_template('department/view-departmental.html',
form=form,
department=department)
def editdepartments(request, type_id):
types = get_object_or_404(Department, pk=type_id)
t = "Edit"
if request.POST:
form = DepartmentForm(request.POST, instance=types)
if form.is_valid():
form.save()
return HttpResponseRedirect('/departments/')
else:
form = DepartmentForm(instance=types)
types = Department.objects.all()
title = "Edit Departments"
url = "departments"
return render_to_response("edit.html", {
'form': form,
't': t,
}, context_instance=RequestContext(request, locals()))
def edit_department(id):
# Edit a department
check_admin()
add_department = False #The view queries the database for a department with id,if dep. doesn't exist,throw a 404 not found
department = Department.query.get_or_404(
id) #If it does, updated with the form data
form = DepartmentForm(obj=department)
if form.validate_on_submit():
department.name = form.name.data
department.description = form.description.data
db.session.commit()
flash('You have successfully edited the department.')
# redirect to the departments page
return redirect(url_for('admin.list_departments'))
form.description.data = department.description
form.name.data = department.name
return render_template('admin/departments/department.html',
action='Edit',
add_department=add_department,
form=form,
department=department,
title='Edit Department')
def choosedepartment():
if (not request.args.get('email')):
return redirect(url_for('home'))
if (session.get('onetime') == False):
flash('URL NOT FOUND', 'danger')
return redirect(url_for('home'))
email = request.args.get('email')
form = DepartmentForm()
if request.method == 'POST':
cursor = conn.cursor()
result = request.form.to_dict()
department = result['department']
cursor = conn.cursor()
cursor.execute(
f"INSERT INTO department(email,dept) VALUES ('{email}','d{int(department)}')"
)
conn.commit()
session['onetime'] = False
return redirect(url_for('login'))
else:
return render_template('department.html', form=form)
def render_forms (request) :
patient = PatientForm ()
department = DepartmentForm()
doctor = DoctorForm()
return render(request, 'mani_tables/all_forms.html', {'patient': patient , 'department' : department , 'doctor' : doctor})
