def newEmployee(request): if request.method == 'POST': form = EmployeeForm(request.POST) if form.is_valid(): username = form['username'].value() password = form['password'].value() first_name = form['first_name'].value() last_name = form['last_name'].value() new_user = User.objects.create_user(username=username, first_name=first_name, password=password, last_name=last_name) new_user.save() user = User.objects.get(username=username) obj = employee() obj.user_id = user.id obj.employment_date = request.POST['employment_date'] obj.save() return redirect('backend:admin') else: form = EmployeeForm() return render(request, 'backend/add_new_employee.html', {'form': form})
def create_employee_view(company_slug_to_id, **kwargs): corporation_id = kwargs['corporation_id'] roles = RoleAccess(corporation_id=corporation_id, company_id=company_slug_to_id). \ roles_available_to_create_employee() roles_to_choose = [(i.id, i.name) for i in roles] form = EmployeeForm(roles_to_choose, corporation_id) next_page = request.args.get('next') if request.method == 'POST': if form.submit_employee.data and form.validate_on_submit(): EmployeeAccess(company_id=company_slug_to_id, first_name=form.first_name_employee.data.strip(), email=form.email_employee.data.strip(), role_id=form.role_employee.data.strip(), corporation_id=corporation_id). \ create_employee() flash('Your employee is now live!') if next_page: return redirect(next_page) form.first_name_employee.data = '' form.email_employee.data = '' form.role_employee.data = '' elif form.cancel_employee.data: if next_page: return redirect(next_page) form.first_name_employee.data = '' form.email_employee.data = '' form.role_employee.data = '' return render_template('create_employee.html', form=form)
def employee_login(): form = EmployeeForm() if form.validate_on_submit(): employee_id = form.employee_id.data password = form.password.data db = get_db() employee = db.execute( ''' SELECT * FROM employees WHERE employee_id = ?;''', (employee_id, )).fetchone() if employee is None: form.employee_id.errors.append("Unknown employee id") elif not check_password_hash(employee["password"], password): form.password.errors.append("Incorrect password!") eventLogger(employee_id, "got their password wrong") else: session.clear() session["employee_id"] = employee_id eventLogger(employee_id, "logged in") next_page = request.args.get("next") if not next_page: next_page = url_for("employee_home") return redirect(next_page) return render_template("employee_login.html", form=form)
def post(self, request, id): if request.user.is_superuser: empid = id form = EmployeeForm(request.POST) print "FORNM", request.POST emp = Employee.objects.get(id=empid) print emp edit_user = User.objects.filter(id=emp.usr_id) print "editttttttttttttt", edit_user.values('first_name') # form.emailedit=emp.usr_email if form.is_valid(): print "valid" edit_user.first_name = request.POST.get('first_name'), edit_user.last_name = request.POST.get('last_name'), # edit_user.email=request.POST.get('email'), # edit_user.save() # emp.address=request.POST.get('address'), # emp.dob=request.POST.get('dob'), # emp.mobile_no=request.POST.get('mobile_no'), # emp.dept=request.POST.get('dept') # emp.save() form.save() context = {'form': form} return render(request, self.template_name, context) else: print "not cvalid", form.errors context = {'form': form} return render(request, self.template_name, context) else: return redirect('emp_home')
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 employee(): my_form = EmployeeForm() print("sucess") if my_form.validate_on_submit(): # fetch the uploaded file file_csv = request.files.get('file_csv') print("valid") if file_csv: # get the file full path file_full_path = os.path.join(app.config['UPLOAD_FOLDER'], file_csv.filename) # save it in the server file system file_csv.save(file_full_path) # read that file in dataframe df = pd.read_csv(file_full_path) #print(df) employee_list_raw = df.to_dict('records') #create a list for bulk insert later on employee_list = [] for curr_employee in employee_list_raw: emp = Employee.from_dict(curr_employee) employee_list.append(emp) print("employee_list_count", len(employee_list)) # save t0 DB db.session.bulk_save_objects(employee_list) db.session.commit() # test query e_list = Employee.query.limit(5).all() print("*******") print(e_list) print("*******") return render_template('employee.html', title = 'Employee', my_form = my_form) # customize the title
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 add_employee(request): """ Add employee """ form = EmployeeForm(request, request.POST or None) if not form.is_valid(): return TemplateResponse(request, 'mus/create_employee_form.html', {'employee_form': form}) form.save() return HttpResponseRedirect('/employee/all/%d' %form.cleaned_data.get('company').pk)
def Add_employee(request): if request.method == 'POST': form = EmployeeForm(request.POST) if form.is_valid(): form.save() return msg(request,"Funcionario adicionado com Sucesso") else: form = EmployeeForm return render(request, 'add_employee.html', {'user':request.user,'form': form})
def edit_employee(employee_id): employee = Employee.query.get(employee_id) form = EmployeeForm(obj=employee) form.populate_obj(employee) if form.validate_on_submit(): db.session.commit() return redirect(url_for('employee_list')) return render_template('edit_employee.html', form=form, employee=employee)
def edit_employee(request, employee_id=None, template="employees/employee_edit.html", context=None): context = context or {} incidents = ['windscreen', 'smash and grab', 'road accident', 'vehicle'] employee = Employee.objects.get(pk=employee_id) if employee_id else None vehicle_history = VehicleDriver.objects.filter(driver__id=employee_id) traffic_incidents = Incident.objects.filter(driver_id=employee_id,incident_type='traffic fine')\ .values('id','reference_number','vehicle__registration_number','incident_date','cost','incident_type')\ .order_by('incident_date') other_incidents = Incident.objects.filter(driver_id=employee_id,incident_type__in=incidents)\ .values('id','reference_number','vehicle__registration_number','incident_date','cost','incident_type')\ .order_by('incident_date') insurance_incidents = InsuranceClaim.objects.filter(driver=employee)\ .values('id','insurance_reference_number','vehicle__registration_number','incident_date','quote_amount')\ .order_by('incident_date') employee_form = EmployeeForm(request.POST or None, instance=employee) driving_licence_form = DrivingLicenceForm(request.POST or None, request.FILES or None) if u'save' in request.POST: if employee_form.is_valid(): employee = employee_form.save(request.user) employee.save() has_errors = False submitted = request.POST.get('tab', '') if submitted == 'licence': has_errors = edit_driving_licence(driving_licence_form, employee, has_errors, request.user) if not has_errors: next = request.POST.get('next', '/') return HttpResponseRedirect(next) if u'cancel' in request.POST: next = request.POST.get('next', '/') return HttpResponseRedirect(next) context['employee'] = employee context['vehicle_history'] = vehicle_history context['employee_form'] = employee_form context['driving_licence_form'] = driving_licence_form context['traffic_incidents'] = traffic_incidents context['other_incidents'] = other_incidents context['insurnace_incidents'] = insurance_incidents return render(request, template, context)
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(request): if request.method == 'POST': form = EmployeeForm(request.POST) if form.is_valid(): form.save(commit=True) return render(request, 'finished.html') else: print form.errors else: form = EmployeeForm() return render(request, 'employee_form.html', {'form': form})
def add_employee(request): """ Add employee """ form = EmployeeForm(request, request.POST or None) if not form.is_valid(): return TemplateResponse(request, 'mus/create_employee_form.html', {'employee_form': form}) form.save() return HttpResponseRedirect('/employee/all/%d' % form.cleaned_data.get('company').pk)
def edit_emp(emp_id): emp = Employee.query.get_or_404(emp_id) form = EmployeeForm(obj=emp) depts = db.session.query(Department.dept_code, Department.dept_name) form.dept_code.choices = depts if form.validate_on_submit(): emp.name = form.name.data emp.state = form.state.data emp.dept_code = form.dept_code.data db.session.commit() return redirect('/phones') else: return render_template('edit-emp.html', form=form)
def edit_employee(id): emp = Employee.query.get_or_404(id) form = EmployeeForm(obj=emp) depts = [('mktg', 'Marketing')] form.dept_code.choices = depts if form.validate_on_submit(): emp.name = form.name.data emp.state = form.state.data emp.dept_code = form.dept_code.data db.session.commit() return redirect('/phones') else: return render_template("edit_employee_form.html", form=form)
def add_employee(): form = EmployeeForm() if form.validate_on_submit(): new_employee = Employee(firstname=form.firstname.data, lastname=form.lastname.data, department=form.department.data, user_id=current_user.id) db.session.add(new_employee) db.session.commit() flash('New employee added successfully.') return redirect(url_for('employee_list')) return render_template('add_employee.html', form=form)
def add_employee(): form = EmployeeForm() depts = db.session.query(Department.dept_code, Department.dept_name) form.dept_code.choices = depts if form.validate_on_submit(): name = form.name.data state = form.state.data dept_code = form.dept_code.data emp = Employee(name=name, state=state, dept_code=dept_code) db.session.add(emp) db.session.commit() return redirect('/phones') else: return render_template('add_employee_form.html', form=form)
def employee(): my_form = EmployeeForm() # convert to list if my_form.validate_on_submit(): # my_form.submitted() # file we are importing file_csv = request.files.get('file_csv') if file_csv: file_full_path = os.path.join(app.config['UPLOAD_FOLDER'], file_csv.filename) # print("file_full_path", file_full_path) # save to upload folder file_csv.save(file_full_path) # load the data in the table using pandas df = pd.read_csv(file_full_path) # print("raw_data", df.iloc[0]) # print("shape", df.shape) employee_list_raw = df.to_dict('records') # print("dictionary", employee_list_raw) employee_list = [] for curr_emp in employee_list_raw: emp = Employee.from_dict(curr_emp) employee_list.append(emp) # db.session.add(emp) # db.session.commit() print("employee_list_count", len(employee_list)) # save t0 DB db.session.bulk_save_objects(employee_list) db.session.commit() # test query e_list = Employee.query.limit(5).all() print("*******") print(e_list) print("*******") # send us to the display page # return redirect("/employee/" + str(my_data.id)) return render_template('employee.html', my_form=my_form)
def get(self, request, id): if request.user.is_superuser: empid = id emp_obj = Employee.objects.get(pk=id) choices = [ (dept.id, str(dept.name)) for dept in Department.objects.filter(name=emp_obj.dept.name) ] print choices form = EmployeeForm( initial={ 'first_name': emp_obj.usr.first_name, 'last_name': emp_obj.usr.last_name, 'address': emp_obj.address, 'dob': emp_obj.dob, 'mobile_no': emp_obj.mobile_no, 'dept': emp_obj.dept.id, # 'username':emp_obj.usr.username, # 'password':emp_obj.usr.password, # 'gender':emp_obj.gender, # 'email':emp_obj.usr.email, # 'edit':True, }) context = {'form': form} return render(request, self.template_name, context) else: return redirect('login')
def edit_user(user_id): employee = Employee.query.get_or_404(user_id) # obj=employee prepopulates fields automatically based on employee data form = EmployeeForm(obj=employee) depts = db.session.query(Department.dept_code, Department.dept_name) form.dept_code.choices = depts if form.validate_on_submit(): employee.name = form.name.data employee.state = form.state.data employee.dept_code = form.dept_code.data db.session.commit() return redirect('/phones') else: return render_template('edit_employee_form.html', form=form)
def create_employee(request): context = {} if request.method == 'POST': data = request.POST.get('form_data').split('&') data_dict = {} for d in data: data_dict[d.split("=")[0]] = urllib.unquote_plus(d.split("=")[1]) form = EmployeeForm(data=data_dict) if form.is_valid(): print "Data being sucessfully saved" form.save() return JsonResponse({'status': 'success'}) else: error_dict = form.errors message = "Entered data is incorrect" return JsonResponse({ 'status': 'fail', 'err_dict': error_dict, 'err_message': message }) else: form = EmployeeForm() context['form'] = form context['err_dict'] = {} return render(request, 'employee_form.html', context)
def edit_employee(request, id): emp_id = id data = Employee.objects.get(id=emp_id) context = {} if request.method == 'POST': updated_data = request.POST.get('form_data').split('&') data_dict = {} for d in updated_data: data_dict[d.split("=")[0]] = urllib.unquote_plus(d.split("=")[1]) print "Data coming in from form: ", data_dict form = EmployeeForm(data_dict, instance=data) if form.is_valid(): print "Data being sucessfully updated" form.save() return JsonResponse({'status': 'success'}) else: error_dict = form.errors message = "Entered data is incorrect" return JsonResponse({ 'status': 'fail', 'err_dict': error_dict, 'err_message': message }) else: form = EmployeeForm(instance=data) context['form'] = form context['id'] = emp_id return render(request, 'update_employee.html', context)
def add_employee(): """Show a form to add new employee and handle form to add new employee""" # Get the appropriate form from forms.py form = EmployeeForm() # Make options for select input depts = db.session.query(Department.dept_code, Department.dept_name) form.dept_code.choices = depts # For POST request if form.validate_on_submit(): emp = Employee(name=form.name.data, state=form.state.data, dept_code=form.dept_code.data) db.session.add(emp) db.session.commit() return redirect('/phones') else: return render_template('add_employee_form.html', form=form)
def add_employee(): form = EmployeeForm() # Adds a tuple to the dept_code.choices select form field ie. ('mktg', 'Marketing') depts = db.session.query(Department.dept_code, Department.dept_name) form.dept_code.choices = depts if form.validate_on_submit(): name = form.name.data state = form.state.data dept_code = form.dept_code.data new_employee = Employee(name=name, state=state, dept_code=dept_code) db.session.add(new_employee) db.session.commit() return redirect('/phones') else: return render_template('add_employee_form.html', form=form)
def add_employee(): form = EmployeeForm() depts = db.session.query(Department.dept_code, Department.dept_name) #pdb.set_trace() #depts = [('mktg','Marketing')] form.dept_code.choices = depts #raise if form.validate_on_submit(): name = form.name.data state = form.state.data dept_code = form.dept_code.data emp = Employee(name=name, state=state, dept_code=dept_code) db.session.add(emp) db.session.commit() return redirect('/phones') else: return render_template('add_employee.html', form=form)
def add_interviewers(request): emp = employee.get_employee_by_user(userid=request.user.id) if request.method == 'POST': form = EmployeeForm(request.POST) if form.is_valid(): try: interviewer = form.save() return render( request, 'interviewer_detail.html', {'interviewer': interviewer}) except Exception as ex: print ex else: form = EmployeeForm() return render( request, 'add_interviewer.html', {'form': form, 'cid': emp.company.id})
def edit_employee(id): """Show form to edit employee and handle form to update existing employee""" # Get employee based on input id emp = Employee.query.get_or_404(id) # Get the appropriate form from forms.py and re-pupolate the fields on HTML form = EmployeeForm(obj=emp) # Make options for select input depts = db.session.query(Department.dept_code, Department.dept_name) form.dept_code.choices = depts # For POST request if form.validate_on_submit(): # Update employee, get data from the form emp.name = form.name.data emp.state = form.state.data emp.dept_code = form.dept_code.data db.session.commit() return redirect('/phones') else: return render_template("edit_employee_form.html", form=form, emp=emp)
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)
def update1(request): if request.POST: form = EmployeeForm(request.POST,request.FILES) print "hello1" if form.is_valid(): form.save() print "hello" return HttpResponseRedirect('/employee/update') else: form = EmployeeForm() args = {} args.update(csrf(request)) args['form'] = form return render_to_response('update.html', args)
def create_employee(request, company_id): """ View for creating employee in company """ company = Company.objects.get(pk=company_id) current_employee = Employee.objects.get(user__pk=request.user.pk) if not current_employee.isEnsoUser( ) and current_employee.company.pk != company.pk: logUnauthorizedAccess("User tried to create_employee", request) raise PermissionDenied() form = EmployeeForm(request, initial=dict(company=company)) form.fields['manager'].queryset = Employee.objects.filter(is_manager=True, company=company) form.fields[ 'development_plan_type'].queryset = DevelopmentPlanType.objects.filter( Q(company=company) | Q(company__isnull=True)) return TemplateResponse(request, 'mus/create_employee_form.html', { 'employee_form': form, 'company': company })
def employeelist(): form = EmployeeForm() pageTitle = "Employee List" if request.method == 'GET': # Open database connection db = pymysql.connect("localhost", "localCentosUser", "Pa55word", "employees") # prepare a cursor object using cursor() method cursor = db.cursor() # execute SQL query using execute() method. cursor.execute("SELECT VERSION()") # Fetch a single row using fetchone() method. data = cursor.fetchone() print("Database version : %s " % data) #now lets fetch records cursor.execute( "INSERT INTO employee (employee_name,username,user_password,email,gender,salary,active) SELECT * FROM (SELECT 'Darshan Patel','dpxx56','123123','*****@*****.**','M',565656,0) AS tmp WHERE NOT EXISTS (SELECT 1 FROM employee WHERE employee_name = 'Darshan Patel') LIMIT 1;" ) db.commit() cursor.execute("SELECT * FROM employee;") data = cursor.fetchall() print('Total records: %d' % cursor.rowcount) # disconnect from server db.close() columnList = ('id', 'employee_name', 'username', 'user_password', 'email', 'gender', 'salary', 'active') return render_template('employeelist.html', pageTitle=pageTitle, data=data, columnList=columnList)