def newEmployee(company_id):
if 'username' not in login_session:
return redirect('/login')
company = session.query(Company).filter_by(id=company_id).one()
session.commit()
if login_session['user_id'] != company.user_id:
return "<script>function myFunction() {alert('You are not authorized \
to add Employee to this Company. Please create your own Company in \
order to add Employee.');}</script><body onload='myFunction()'>"
if request.method == 'POST':
file = request.files['image']
if os.path.exists("static/" + file.filename):
return "File already exist rename the file/select another image!"
else:
f = os.path.join(app.config['UPLOAD_FOLDER'], file.filename)
# add your custom code to check that the uploaded file is a valid \
# image and not a malicious file (out-of-scope for this post)
file.save(f)
company = session.query(Company).filter_by(id=company_id).one()
newEmployee = Employee(name=request.form['name'],
dob=request.form['dob'],
email=request.form['email'],
contact=request.form['mob'],
address=request.form['address'],
picture="/static/" + file.filename,
company_id=company_id,
user_id=company.user_id)
print newEmployee
session.add(newEmployee)
session.commit()
flash('New Employee %s Successfully Added' % (newEmployee.name))
return redirect(url_for('showEmployee', company_id=company_id))
else:
return render_template('newemployee.html', company=company)
def create_employee():
employee = Employee(project_id=request.get_json().get('project_id'),
name=request.get_json().get('name'),
title=request.get_json().get('title'),
phone=request.get_json().get('phone'),
seat=request.get_json().get('seat'))
employee_repository.create_employee(employee)
resp = jsonify(success=True)
resp.status_code = 200
return resp
def edit_employee():
employee = Employee(id=request.get_json().get('id'),
project_id=request.get_json().get('project_id'),
name=request.get_json().get('name'),
title=request.get_json().get('title'),
phone=request.get_json().get('phone'),
seat=request.get_json().get('seat'))
edited_employee = employee_repository.edit_employee(employee)
return make_response(
jsonify({'id': edited_employee.id, 'project_id': edited_employee.project_id,
'name': edited_employee.name, 'title': edited_employee.title,
'phone': edited_employee.phone, 'seat': edited_employee.seat}), 200)
def newEmployee():
if 'name' not in login_session:
return redirect(url_for('showLogin'))
if request.method == 'GET':
return render_template('newemployee.html')
name = request.form['name']
email = request.form['email']
mobile = request.form['mobile']
date = getDate(request.form['date'])
employee = Employee(name=name,
email=email,
mobile_number=mobile,
hire_date=date)
session.add(employee)
session.commit()
flash('New Employee %s is added' % name)
return redirect(url_for('mainPage'))
def importRow(row):
employeeId = session.query(Employee.p_id).\
filter(Employee.name == row[2]).scalar()
if (employeeId is None):
newEmployee = Employee(name=row[2], address=row[3])
session.add(newEmployee)
session.commit()
employeeId = session.query(Employee.p_id).\
filter(Employee.name == row[2]).scalar()
newExpense = Expense(date=row[0],
category=row[1],
employee=employeeId,
description=row[4],
pre_tax=row[5].replace(',', ''),
tax_name=row[6],
tax_amount=row[7].replace(',', ''))
session.add(newExpense)
session.commit()
def addCashier():
if request.method == 'POST':
if not request.form['eid']:
flash('Please enter employee id')
return redirect(url_for('addCashier'))
if not request.form['fname']:
flash('Please enter first name')
return redirect(url_for('addCashier'))
if not request.form['lname']:
flash('Please enter last name')
return redirect(url_for('addCashier'))
if not request.form['stsid']:
flash('Please enter status id')
return redirect(url_for('addCashier'))
if not request.form['salary']:
flash('Please enter salary')
return redirect(url_for('addCashier'))
# Add new item
cashier = Employee(eid=request.form['eid'],
etid='ET2',
fname=request.form['fname'],
lname=request.form['lname'],
stsid=request.form['stsid'],
salary=request.form['salary'])
session.add(cashier)
user = Cashier(username=request.form['username'],
password=request.form['password'])
session.add(user)
session.commit()
return redirect(url_for('showCashiers'))
else:
# Get all categories
return render_template('addCashier.html')
def create_new_emp():
if 'username' not in login_session:
return redirect('/login')
all_dept = get_all_dept()
if request.method == 'POST':
newemp = Employee(name=request.form['name'],
designation=request.form['designation'],
salary=request.form['salary'],
dept_id=get_dept_id(request.form['department']),
archival_flag='N',
desk_ph=request.form['desk_ph'],
emp_email=request.form['emp_email'],
city_state=request.form['city_state'],
reporting_manager=request.form['reporting_manager'],
user_id=login_session['user_id'])
session.add(newemp)
session.commit()
flash('New Employee %s Successfully Created' % newemp.name)
return redirect(url_for('employee_catalog'))
else:
return render_template('newEmpRec.html', all_dept=all_dept)
DBSession = sessionmaker(bind=engine)
# A DBSession() instance establishes all conversations with the database
# and represents a "staging zone" for all the objects loaded into the
# database session object. Any change made against the objects in the
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
new_emp1 = Employee(name='Carson Wentz',
designation='11 - Quarterback',
salary='10,000,000',
archival_flag='N',
dept_id='10',
start_date=func.now(),
desk_ph='428-789-1256',
emp_email='*****@*****.**',
city_state='Phildadelphia/PA',
reporting_manager='Doug Pederson',
user_id=1)
session.add(new_emp1)
session.commit()
new_emp2 = Employee(name='Nick Foles',
designation='12 - Quarterback',
salary='10,000,000',
archival_flag='N',
dept_id='10',
start_date=func.now(),
session.add(foodit51) #change.....................
session.add(foodit52) #change.....................
session.add(foodit53) #change.....................
session.add(foodit54) #change.....................
session.add(foodit55) #change.....................
session.add(foodit56) #change.....................
session.add(foodit57) #change.....................
session.add(foodit58) #change.....................
session.add(foodit59) #change.....................
session.add(foodit60) #change.....................
etype1 = EmployeeType(etid='ET1', name='ADMIN', description='ADMIN')
etype2 = EmployeeType(etid='ET2', name='CASHIER', description='CASHIER')
session.add(etype1)
session.add(etype2)
employee1 = Employee(eid='E1',
etid='ET2',
fname='Sultan',
lname='Lubbad',
stsid='S1',
salary=1000.5)
session.add(employee1)
user1 = Admin(username="******", password="******")
user2 = Cashier(username="******", password="******")
session.add(user1)
session.add(user2)
session.commit()
'''Creates an Employee with an Address'''
# Imports
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Employee, Address
engine = create_engine('sqlite:///employees.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind = engine)
session = DBSession()
# Create Employee
rebeccaEmployee = Employee(name = "Rebecca Allen")
session.add(rebeccaEmployee)
session.commit()
# Create Employee
rebeccaAddress = Address(street = "512 Sycamore Road", zip = "02001", employee = rebeccaEmployee)
session.add(rebeccaAddress)
session.commit()
# Read
employees = session.query(Employee).all()
for employee in employees:
print(employee.name)
# Update
rebecca = session.query(Employee).filter_by(name = "Rebecca Allen").one()
address = session.query(Address).filter_by(employee_id = rebecca.id).one()
company1 = Company(user_id=1, name="Mahindra Motors",\
picture="/static/Mahindra-logo.png")
session.add(company1)
session.commit()
company2 = Company(user_id=1, name="Sweetlime ventures", \
picture="/static/sweetlime.png")
session.add(company2)
session.commit()
employee1 = Employee(user_id=1, name="Mandar Waghe", \
dob="17/12/1994",\
email="*****@*****.**", \
contact="8007528271", address="Thane",\
picture="/static/mandar1.jpg"\
,company=company1)
session.add(employee1)
session.commit()
employee2 = Employee(user_id=1, name="Vijay Nath", dob="02/02/1994",\
email="*****@*****.**", contact="9856432312", \
address="Thane",\
picture="/static/blank_user.gif"\
,company=company1)
session.add(employee2)
session.commit()
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Address, Base, Employee
from faker import Faker
fake = Faker()
engine = create_engine('sqlite:///empData.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
emp2 = Employee(name='Pavan')
session.add(emp2)
session.commit()
emp2Addr = Address(street='2', zip='50002', employee=emp2)
session.add(emp2Addr)
session.commit()
emp3 = Employee(name='Hruday')
session.add(emp3)
session.commit()
emp3Addr = Address(street='3', zip='50003', employee=emp3)
session.add(emp3Addr)
session.commit()
emp4 = Employee(name='Virat')
session.add(emp4)
session.commit()
emp4Addr = Address(street='4', zip='50004', employee=emp4)
session.add(emp4Addr)
session.commit()
emp5 = Employee(name='Rohit')
session.add(emp5)
session.commit()
emp5Addr = Address(street='5', zip='50005', employee=emp5)