def addemp():
if 'username' in session:
form = EmployeeForm(request.form)
if request.method == 'POST':
if form.validate():
empdata = request.form
firstname = empdata['firstname']
midname = empdata['midname']
lastname = empdata['lastname']
address = empdata['address']
email = empdata['email']
mobile = empdata['mobile']
gender = empdata['gender']
designation = empdata['designation']
name = firstname + " " + midname + " " + lastname
sql = "INSERT INTO employees(name, email, mobile, gender, designation, address) VALUES(%s, %s, %s, %s, %s, %s);"
conn = mysql.connect()
cursor = conn.cursor()
rows = cursor.execute(
sql, (name, email, mobile, gender, designation, address))
conn.commit()
if rows > 0:
flash('Employee Added Successfully')
return redirect(url_for('addemp'))
else:
flash('Failed to added new employee!')
return redirect(url_for('addemp'))
cursor.close()
conn.close()
else:
return render_template('addemployee.html', form=form)
elif request.method == 'GET':
return render_template('addemployee.html', form=form)
else:
return redirect(url_for('login'))
def addemp():
form = EmployeeForm(request.form)
if request.method == 'POST':
if form.validate():
return 'Submitted!'
else:
return render_template('addemployee.html', form=form)
elif request.method == 'GET':
return render_template('addemployee.html', form=form)
def cont4ct():
pass
form = EmployeeForm()
if request.method == 'POST':
if form.validate() == False:
return render_template('forms_employee.html', form=form)
elif request.method == 'GET':
return render_template('forms_employee.html', form=form)
else:
return render_template('form_data_employee.html')
def edit(id):
if 'username' in session:
form = EmployeeForm(request.form)
if request.method == 'POST':
if form.validate():
empdata = request.form
firstname = empdata['firstname']
midname = empdata['midname']
lastname = empdata['lastname']
address = empdata['address']
email = empdata['email']
mobile = empdata['mobile']
gender = empdata['gender']
designation = empdata['designation']
name = firstname + " " + midname + " " + lastname
sql = "UPDATE employees SET name = %s, email = %s, mobile = %s, gender = %s, designation = %s, address = %s WHERE id = %s;"
conn = mysql.connect()
cursor = conn.cursor()
rows = cursor.execute(
sql,
(name, email, mobile, gender, designation, address, id))
conn.commit()
if rows > 0:
flash('Employee Updated Successfully')
return redirect(url_for('index'))
else:
flash('Failed to update employee!')
return redirect(url_for('index'))
cursor.close()
conn.close()
else:
return render_template('edit.html', form=form, id=id)
elif request.method == 'GET':
sql = "SELECT * FROM employees WHERE id = %s;"
conn = mysql.connect()
cursor = conn.cursor()
cursor.execute(sql, (id))
data = cursor.fetchone()
fullname = data[1].split(" ")
ln = len(fullname)
if ln > 2:
form.firstname.data = fullname[0]
form.midname.data = fullname[1]
form.lastname.data = fullname[2]
else:
form.firstname.data = fullname[0]
form.lastname.data = fullname[1]
form.address.data = data[6]
form.email.data = data[2]
form.mobile.data = data[3]
form.gender.data = data[4]
form.designation.data = data[5]
return render_template('edit.html', form=form, id=id)
else:
return redirect(url_for('login'))
def employee():
form = EmployeeForm()
pageTitle = "Employee Form"
if request.method == 'POST':
if form.validate() == False:
flash('All fields are required.')
return render_template('employee.html',
form=form,
pageTitle=pageTitle)
else:
print('Doing employeeadd')
result = employeeAdd(request.form)
if result['error'] == 1:
return render_template('employee.html',
form=form,
pageTitle=pageTitle,
processMessage=result['message'])
else:
return redirect(url_for('employeelist'))
return render_template('employeeadd.html', formData=request.form)
elif request.method == 'GET':
return render_template('employee.html', form=form, pageTitle=pageTitle)
