def emp_add():
values = json.loads(request.form['params'])
try:
empid = Employee.add(values)
except Exception as ex:
return jsonify(error=str(ex))
return jsonify(empid=empid, employees=Employee.get_all())
def emp_drop():
empid = json.loads(request.args['empid'])
success = Employee.delete(empid)
if not success:
msg = 'Record not deleted for unknown reason. Contact admin.'
return jsonify(error=msg)
data = Employee.get_all()
return jsonify(employees=data)
def _get_data(self):
from dal.dao import Dao
from models.project import Project
from models.employee import Employee
from models.assignment import Assignment
dao = Dao(db_path=self.db_path, stateful=True)
self._prj_rex = Project.get_all(dao)
self._emp_rex = Employee.get_all(dao)
self._asn_rex = Assignment.get_all(dao)
dao.close()
def emp_update():
values = json.loads(request.form['params'])
empid = values['id']
try:
numrows = Employee.update(values)
if numrows != 1:
msg = 'Record not updated for unknown reason. Contact admin.'
return jsonify(error=msg)
except Exception as ex:
return jsonify(error=str(ex))
return jsonify(empid=empid, employees=Employee.get_all())
def prj_list():
projects = Project.get_all()
emp_rex = Employee.get_all()
employees = [{'id': employee['id'], 'value': employee['name']} for employee in emp_rex]
is_authenticated = session['is_authenticated'] if 'is_authenticated' in session else False
page = 'projects.html' if is_authenticated else 'projects_ro.html'
return render_template(
page,
title='allocat projects',
projects=projects,
employees=employees
)
def prj_list():
# app.logger.info('User has opened Projects.')
rex = Project.get_all()
prjs = [rec.serialize() for rec in rex] if rex else []
rex = Employee.get_all()
emps = [{'id': rec.id, 'name': rec.name} for rec in rex]
rex = Assignment.get_all()
asns = [rec.serialize() for rec in rex] if rex else []
return render_template('projects/project_panel.html',
title='allocat projects',
projects=prjs,
employees=emps,
assignments=asns)
def emp_list():
employees = Employee.get_all()
prj_rex = Project.get_all()
projects = [
{
'id': project['id'],
'value': project['nickname'],
'first_month': project['first_month'],
'last_month': project['last_month']
} for project in prj_rex]
is_authenticated = session['is_authenticated'] if 'is_authenticated' in session else False
page = 'employees.html' if is_authenticated else 'employees_ro.html'
return render_template(
page,
title='allocat employees',
projects=projects,
employees=employees
)
def __load(self, months):
employees = Employee.get_all()
assignments = Assignment.get_for_timeframe(months[0], months[-1])
employee_assignments = {}
for assignment in assignments:
if assignment['employee_id'] not in employee_assignments:
employee_assignments[assignment['employee_id']] = []
employee_assignments[assignment['employee_id']].append(assignment)
for employee in employees:
row = EffortRow(employee)
for month in months:
cell = EffortCell(month)
if employee['id'] not in employee_assignments:
continue
for emp_asn in employee_assignments[employee['id']]:
if int(month) < emp_asn['first_month'] or int(month) > emp_asn['last_month']:
continue
cell.total += emp_asn['effort']
cell.percent_efforts.append(
PercentEffort(emp_asn['project'], emp_asn['effort'])
)
row.effort_cells.append(cell)
if row.effort_cells:
self.effort_rows.append(row)
def _get_data(self):
from dal.dao import Dao
from tests.ledger_data.test_data import invoices_q2_pre_query
from models.employee import Employee
from models.department import Department
from models.grant_admin import GrantAdmin
from models.invoice import Invoice
from models.assignment import Assignment
dao = Dao(db_path=self.db_path, stateful=True)
self._emp_rex = Employee.get_all(dao)
self._dept_rex = Department.get_all(dao)
self._grant_admin_rex = GrantAdmin.get_all(dao)
invoices_unpaid = Invoice.get_rex(dao)
# invoices_unpaid = invoices_q2
self._invoices_sent = [
invoice for invoice in invoices_unpaid if invoice.sent
]
self._invoices_unsent = [
invoice for invoice in invoices_unpaid if not invoice.sent
]
self._asn_rex = Assignment.get_billables(dao)
dao.close()
def __load(self, months):
employees = Employee.get_all()
assignments = Assignment.get_for_timeframe(months[0], months[-1])
employee_assignments = {}
for assignment in assignments:
if assignment['employee_id'] not in employee_assignments:
employee_assignments[assignment['employee_id']] = []
employee_assignments[assignment['employee_id']].append(assignment)
for employee in employees:
row = EffortRow(employee)
for month in months:
cell = EffortCell(month)
if employee['id'] not in employee_assignments:
continue
for emp_asn in employee_assignments[employee['id']]:
if int(month) < emp_asn['first_month'] or int(
month) > emp_asn['last_month']:
continue
cell.total += emp_asn['effort']
cell.percent_efforts.append(
PercentEffort(emp_asn['project'], emp_asn['effort']))
row.effort_cells.append(cell)
if row.effort_cells:
self.effort_rows.append(row)
