def add_comparison(request):
type = request.matchdict['type']
hash1_name = request.matchdict['hash1']
hash2_name = request.matchdict['hash2']
if type == "employee":
hash1 = request.db_session.query(Hash_employee).filter(Hash_employee.name == hash1_name, Hash_employee.user == get_user(request)).first()
hash2 = request.db_session.query(Hash_employee).filter(Hash_employee.name == hash2_name, Hash_employee.user == get_user(request)).first()
print(hash1)
print(hash2)
porovnavacka = Comparison(get_user(request), hash1, hash2, 1)
DBSession.add(porovnavacka)
DBSession.flush()
DBSession.refresh(porovnavacka)
return{'status' : 'ok', 'id' : porovnavacka.id}
elif type == "event":
hash1 = request.db_session.query(Hash_employee).filter(Hash_employee.name == hash1_name, Hash_employee.user == get_user(request)).first()
hash2 = request.db_session.query(Hash_employee).filter(Hash_employee.name == hash2_name, Hash_employee.user == get_user(request)).first()
print(hash1)
print(hash2)
porovnavacka = Comparison(get_user(request), hash1, hash2, 0)
DBSession.add(porovnavacka)
DBSession.flush()
DBSession.refresh(porovnavacka)
return{'status' : 'ok', 'id' : porovnavacka.id}
else:
return{'status' : 'This ype of comparison is not in our system'}
def add_event(request):
post=request.POST
id_leader = post['id_leader']
time_begin = post['time_begin'].split(':')
time_begin = [int(x) for x in time_begin]
time_end = post['time_end'].split(':')
time_end = [int(x) for x in time_end]
date_begin = post['date_begin'].split('/')
date_begin = [int(x) for x in date_begin]
date_end = post['date_end'].split('/')
date_end = [int(x) for x in date_end]
leader = request.db_session.query(Employee).filter(Employee.by_user_id == get_verified_user_id(request), Employee.id == id_leader).first()
print(time_end)
zaciatok_eventu = datetime.datetime(date_begin[2], date_begin[0], date_begin[1], time_begin[0], time_begin[1], 0, 0)
koniec_eventu = datetime.datetime(date_end[2], date_end[0], date_end[1], time_end[0], time_end[1], 0, 0)
event = Event(get_user(request), leader, post['name'], zaciatok_eventu, koniec_eventu)
DBSession.add(event)
DBSession.flush()
DBSession.refresh(event)
#leader bude ako task
task = Task(event.leader, event, 0, 0, event.length())
DBSession.add(task)
return HTTPFound(location = request.route_url('events'))
def add(request):
type_to_add = request.matchdict['type_to_delete']
name = request.matchdict['name']
if type_to_add == "workposition":
if request.db_session.query(Employees_type).filter(Employees_type.name == name, Employees_type.by_user_id == get_verified_user_id(request)).first() == None:
new_workposition = Employees_type(get_user(request), name)
DBSession.add(new_workposition)
DBSession.flush()
DBSession.refresh(new_workposition)
return{'status': 'ok' ,'name': name, 'id' : new_workposition.id}
else:
return{'status': 'workposition with name '+name+' is in databse already'}
elif type_to_add == "workplace":
print('*' * 500)
print(name)
city = name.split('!')[0]
address = name.split('!')[1]
if request.db_session.query(Workplace).filter(Workplace.address == address).first() == None:
new_workplace = Workplace(get_user(request), city, address)
DBSession.add(new_workplace)
DBSession.flush()
DBSession.refresh(new_workplace)
return{'status': 'ok' ,'name': name, 'id' : new_workplace.id}
else:
return{'status': 'workposition with name '+name+' is in databse already'}
if type_to_add == "hash_employee":
if request.db_session.query(Hash_employee).filter(Hash_employee.name == name, Hash_employee.type == 1, Hash_employee.by_user_id == get_verified_user_id(request)).first() == None:
hash_zamestnanec = Hash_employee(get_user(request), name, 1)
DBSession.add(hash_zamestnanec)
DBSession.flush()
DBSession.refresh(hash_zamestnanec)
return{'status': 'ok' ,'name': name, 'id' : hash_zamestnanec.id}
else:
return{'status': 'employee hashtag with name '+name+' is in databse already'}
if type_to_add == "hash_event":
if request.db_session.query(Hash_employee).filter(Hash_employee.name == name, Hash_employee.type == 0, Hash_employee.by_user_id == get_verified_user_id(request)).first() == None:
hash_zamestnanec = Hash_employee(get_user(request), name, 0)
DBSession.add(hash_zamestnanec)
DBSession.flush()
DBSession.refresh(hash_zamestnanec)
return{'status': 'ok' ,'name': name, 'id' : hash_zamestnanec.id}
else:
return{'status': 'event hashtag with name '+name+' is in databse already'}
