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_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})