def results_cuerpo(request):
form = AdministratorResultsCuerpoForm(request.GET)
cuerpo_list = [] # soon to be filled if form is submitted
# verify if form has been sent
if form.is_valid():
# get region if selected
region = form.cleaned_data["region"]
if region:
# fetch all cuerpos from db
cursor = connections["principal"].cursor()
cuerpo_data_list = Region.fetch_all_related(cursor, region.old_id)
for cuerpo_data in cuerpo_data_list:
# try first to get cuerpo from our records
try:
cuerpo = Cuerpo.objects.get(old_id=cuerpo_data["id"])
cuerpo_list.append(cuerpo)
except Cuerpo.DoesNotExist:
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_data["id"])
if cuerpo: # is null in case of virtual cuerpo or inconsistent db
cuerpo.save()
cuerpo_list.append(cuerpo)
return render_to_response('administrator/results_cuerpo.html', {
'form': form,
'cuerpo_list': cuerpo_list,
'menu_titles': True,
},
context_instance=RequestContext(request))
def results_company(request):
form = AdministratorResultsCompanyForm(request.GET)
company_list = [] # soon to be filled if form is submitted
# check if user has specified a cuerpo_id
cuerpo_id = request.GET.get('cuerpo_id', None)
if cuerpo_id:
# try first to get cuerpo from our records
try:
cuerpo = Cuerpo.objects.get(old_id=cuerpo_id)
except Cuerpo.DoesNotExist:
# fetch cuerpo from db
cursor = connections["principal"].cursor()
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_id)
if cuerpo: # can null in case of virtual cuerpo or inconsistent db
cuerpo.save()
else:
request.flash['error'] = "El cuerpo que ha seleccionado no existe en los registros"
logging.error("Requested cuerpo:%s does not exist", cuerpo_id)
return redirect('administrator_results_company')
company_list = cuerpo.cuerpo_company.all()
menu_titles, main_menu_choices, user_permission_instance = request.user.get_profile().get_menu()
# Render the form
return render_to_response('administrator/results_company.html', {
'form': form,
'company_list': company_list,
'menu_titles': menu_titles[:-1],
'main_menu_choices': main_menu_choices,
'user_permission_instance': user_permission_instance
}, context_instance=RequestContext(request),
)
def results_cuerpo(request):
form = AdministratorResultsCuerpoForm(request.GET)
cuerpo_list = [] # soon to be filled if form is submitted
# verify if form has been sent
if form.is_valid():
# get region if selected
region = form.cleaned_data["region"]
if region:
# fetch all cuerpos from db
cursor = connections["principal"].cursor()
cuerpo_data_list = Region.fetch_all_related(cursor, region.old_id)
for cuerpo_data in cuerpo_data_list:
# try first to get cuerpo from our records
try:
cuerpo = Cuerpo.objects.get(old_id=cuerpo_data["id"])
cuerpo_list.append(cuerpo)
except Cuerpo.DoesNotExist:
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_data["id"])
if cuerpo: # is null in case of virtual cuerpo or inconsistent db
cuerpo.save()
cuerpo_list.append(cuerpo)
return render_to_response('administrator/results_cuerpo.html', {
'form': form,
'cuerpo_list': cuerpo_list,
'menu_titles': True,
}, context_instance=RequestContext(request))
def results_company(request):
form = AdministratorResultsCompanyForm(request.GET)
company_list = [] # soon to be filled if form is submitted
# check if user has specified a cuerpo_id
cuerpo_id = request.GET.get('cuerpo_id', None)
if cuerpo_id:
# try first to get cuerpo from our records
try:
cuerpo = Cuerpo.objects.get(old_id=cuerpo_id)
except Cuerpo.DoesNotExist:
# fetch cuerpo from db
cursor = connections["principal"].cursor()
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_id)
if cuerpo: # can null in case of virtual cuerpo or inconsistent db
cuerpo.save()
else:
request.flash[
'error'] = "El cuerpo que ha seleccionado no existe en los registros"
logging.error("Requested cuerpo:%s does not exist", cuerpo_id)
return redirect('administrator_results_company')
company_list = cuerpo.cuerpo_company.all()
menu_titles, main_menu_choices, user_permission_instance = request.user.get_profile(
).get_menu()
# Render the form
return render_to_response(
'administrator/results_company.html',
{
'form': form,
'company_list': company_list,
'menu_titles': menu_titles[:-1],
'main_menu_choices': main_menu_choices,
'user_permission_instance': user_permission_instance
},
context_instance=RequestContext(request),
)
def wrap(request, *args, **kwargs):
# If user isn't authenticated
if not request.user.is_authenticated():
logging.info("User not authenticated tried to access the system")
request.flash['notice'] = 'Por favor inicie sesión primero'
return redirect('login')
# define basic data
profile = request.user.get_profile()
region_id = kwargs.get('region_id', None)
cuerpo_id = kwargs.get('cuerpo_id', None)
company_id = kwargs.get('company_id', None)
cursor = connections['principal'].cursor()
# check role if defined at decorator instantiation
if self.roles:
role_name = None
# assign current role to human readable format
if profile.is_administrator():
role_name = 'administrator'
elif profile.is_regional_operations_manager():
role_name = 'regional_operations_manager'
elif profile.is_cuerpo_manager():
role_name = 'cuerpo'
elif profile.is_company_manager():
role_name = 'company'
# If user doesn't have access, redirect
if not (role_name in self.roles):
request.flash['error'] = 'Usted no tiene permisos para realizar esta acción'
logging.info("User %s doesn't have permission to access %s", request.user.username, request.path)
return redirect('index')
# deliver region if requested
if region_id:
region = Region.fetch_from_db(cursor, region_id)
if not region:
logging.info("Region:%s doesn't exist", region_id) # why %s: http://stackoverflow.com/questions/2796178/error-url-redirection
request.flash["error"] = 'La region que ha seleccionado no existe'
cursor.close()
return redirect('index')
# now we must check user's permissions
if not profile.has_region_permission(region):
logging.warning("User:%s unauthorized to access Region:%s information", profile.old_id, region_id)
request.flash["error"] = 'No tiene permiso para acceder a la información de la región seleccionada'
cursor.close()
return redirect('index')
# replace region_id with full region object
del kwargs['region_id']
kwargs['region'] = region
# deliver cuerpo if requested
if cuerpo_id:
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_id)
if not cuerpo:
logging.info("Cuerpo:%s doesn't exist", cuerpo_id) # why %s: http://stackoverflow.com/questions/2796178/error-url-redirection
request.flash["error"] = 'El cuerpo que ha ingresado no existe'
cursor.close()
return redirect('index')
# now we must check user's permissions
if not profile.has_cuerpo_permission(cursor, cuerpo):
logging.warning("User:%s unauthorized to access Cuerpo:%s information", profile.old_id, cuerpo_id)
request.flash["error"] = 'No tiene permiso para acceder a la información del cuerpo seleccionado'
cursor.close()
return redirect('index')
# replace cuerpo_id with full cuerpo object
del kwargs['cuerpo_id']
kwargs['cuerpo'] = cuerpo
# deliver company if requested
if company_id:
company = Company.fetch_from_db(cursor, company_id)
if not company:
logging.info("Company:%s doesn't exist", company_id) # why %s: http://stackoverflow.com/questions/2796178/error-url-redirection
request.flash["error"] = 'La compañía que ha ingresado no existe'
cursor.close()
return redirect('index')
# now we must check user's permissions
if not profile.has_company_permission(cursor, company):
logging.warning("User:%s unauthorized to access Company:%s information", profile.old_id, company_id)
request.flash["error"] = 'No tiene permiso para acceder a la información de la compañía seleccionada'
cursor.close()
return redirect('index')
# replace company_id with full company object
del kwargs['company_id']
kwargs['company'] = company
# user has permission over cuerpo
cursor.close()
return func(request, *args, **kwargs)
def authenticate(self, username=None, password=None):
user = None
cursor = connections['postfix'].cursor()
# username needs to be transformed into email
# reference: http://stackoverflow.com/questions/3217682/checking-validity-of-email-in-django-python
try:
validate_email(username)
except ValidationError:
username = u'@'.join((username, u'bomberos.cl',))
query = "SELECT correopk FROM mailbox WHERE username = %s AND password = %s"
params = (username, password,)
cursor.execute(query, params)
postfix_data = cursor.fetchone()
if postfix_data is None:
# The username/password do not match
logging.info("Username/password for user %s do not match", username)
cursor.close()
return None
try:
user = User.objects.get(username=username)
except User.DoesNotExist:
logging.info("The user (%s) is logging for the first time, initializing data", username)
user = User(username=username, password=password)
user.is_staff = False
user.is_superuser = False
user.save()
profile = user.get_profile()
# If for some reason the user does not have a uid in the database, burn everything and abort
if postfix_data[0] is None:
logging.info("User %s does not have a correopk", username)
profile.delete()
user.delete()
cursor.close()
return None
correo_pk = postfix_data[0]
# Try and get the user_id from usu_mail
query = "SELECT fk_usu FROM mail_usu WHERE fk_mail = %s"
params = (correo_pk,)
cursor.execute(query, params)
user_data = cursor.fetchone()
if not user_data:
logging.info("User %s with correopk %s does not exist in table 'mail_usu'" % (username, correo_pk))
profile.delete()
user.delete()
cursor.close()
return None
profile.old_id = user_data[0]
cursor.close()
cursor = connections['principal'].cursor()
# First of all, determine user role
profile.determine_role(cursor)
# If user is not reg. op. manager, fetch company
if profile.is_regional_operations_manager():
cuerpos = Region.fetch_all_related(cursor, profile.get_region_id())
for cuerpo_data in cuerpos:
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_data["id"])
if cuerpo: # is null in case of virtual cuerpo or inconsistent db
cuerpo.save()
else:
# Try and get the user company
query = "SELECT usu_fk_cia FROM usuarios WHERE usu_id = %s"
params = (profile.old_id,)
cursor.execute(query, params)
user_data = cursor.fetchone()
if not user_data:
# The user does not exist in the principal database (broken foreign key)
# As always, burn and quit
logging.error("User %s with id %s does not exist in table 'usuarios'", username, profile.old_id)
profile.delete()
user.delete()
cursor.close()
return None
old_company_id = user_data[0]
company = Company.fetch_from_db(cursor, old_company_id)
if not company:
logging.error("User %s associated company is foreign key broken (in commune, province, region, or cuerpo)", username)
profile.delete()
user.delete()
cursor.close()
return None
profile.company = company
profile.save()
user.save()
cursor.close()
return user
def wrap(request, *args, **kwargs):
# If user isn't authenticated
if not request.user.is_authenticated():
logging.info(
"User not authenticated tried to access the system")
request.flash['notice'] = 'Por favor inicie sesión primero'
return redirect('login')
# define basic data
profile = request.user.get_profile()
region_id = kwargs.get('region_id', None)
cuerpo_id = kwargs.get('cuerpo_id', None)
company_id = kwargs.get('company_id', None)
cursor = connections['principal'].cursor()
# check role if defined at decorator instantiation
if self.roles:
role_name = None
# assign current role to human readable format
if profile.is_administrator():
role_name = 'administrator'
elif profile.is_regional_operations_manager():
role_name = 'regional_operations_manager'
elif profile.is_cuerpo_manager():
role_name = 'cuerpo'
elif profile.is_company_manager():
role_name = 'company'
# If user doesn't have access, redirect
if not (role_name in self.roles):
request.flash[
'error'] = 'Usted no tiene permisos para realizar esta acción'
logging.info(
"User %s doesn't have permission to access %s",
request.user.username, request.path)
return redirect('index')
# deliver region if requested
if region_id:
region = Region.fetch_from_db(cursor, region_id)
if not region:
logging.info(
"Region:%s doesn't exist", region_id
) # why %s: http://stackoverflow.com/questions/2796178/error-url-redirection
request.flash[
"error"] = 'La region que ha seleccionado no existe'
cursor.close()
return redirect('index')
# now we must check user's permissions
if not profile.has_region_permission(region):
logging.warning(
"User:%s unauthorized to access Region:%s information",
profile.old_id, region_id)
request.flash[
"error"] = 'No tiene permiso para acceder a la información de la región seleccionada'
cursor.close()
return redirect('index')
# replace region_id with full region object
del kwargs['region_id']
kwargs['region'] = region
# deliver cuerpo if requested
if cuerpo_id:
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_id)
if not cuerpo:
logging.info(
"Cuerpo:%s doesn't exist", cuerpo_id
) # why %s: http://stackoverflow.com/questions/2796178/error-url-redirection
request.flash[
"error"] = 'El cuerpo que ha ingresado no existe'
cursor.close()
return redirect('index')
# now we must check user's permissions
if not profile.has_cuerpo_permission(cursor, cuerpo):
logging.warning(
"User:%s unauthorized to access Cuerpo:%s information",
profile.old_id, cuerpo_id)
request.flash[
"error"] = 'No tiene permiso para acceder a la información del cuerpo seleccionado'
cursor.close()
return redirect('index')
# replace cuerpo_id with full cuerpo object
del kwargs['cuerpo_id']
kwargs['cuerpo'] = cuerpo
# deliver company if requested
if company_id:
company = Company.fetch_from_db(cursor, company_id)
if not company:
logging.info(
"Company:%s doesn't exist", company_id
) # why %s: http://stackoverflow.com/questions/2796178/error-url-redirection
request.flash[
"error"] = 'La compañía que ha ingresado no existe'
cursor.close()
return redirect('index')
# now we must check user's permissions
if not profile.has_company_permission(cursor, company):
logging.warning(
"User:%s unauthorized to access Company:%s information",
profile.old_id, company_id)
request.flash[
"error"] = 'No tiene permiso para acceder a la información de la compañía seleccionada'
cursor.close()
return redirect('index')
# replace company_id with full company object
del kwargs['company_id']
kwargs['company'] = company
# user has permission over cuerpo
cursor.close()
return func(request, *args, **kwargs)
def authenticate(self, username=None, password=None):
user = None
cursor = connections['postfix'].cursor()
# username needs to be transformed into email
# reference: http://stackoverflow.com/questions/3217682/checking-validity-of-email-in-django-python
try:
validate_email(username)
except ValidationError:
username = u'@'.join((
username,
u'bomberos.cl',
))
query = "SELECT correopk FROM mailbox WHERE username = %s AND password = %s"
params = (
username,
password,
)
cursor.execute(query, params)
postfix_data = cursor.fetchone()
if postfix_data is None:
# The username/password do not match
logging.info("Username/password for user %s do not match",
username)
cursor.close()
return None
try:
user = User.objects.get(username=username)
except User.DoesNotExist:
logging.info(
"The user (%s) is logging for the first time, initializing data",
username)
user = User(username=username, password=password)
user.is_staff = False
user.is_superuser = False
user.save()
profile = user.get_profile()
# If for some reason the user does not have a uid in the database, burn everything and abort
if postfix_data[0] is None:
logging.info("User %s does not have a correopk", username)
profile.delete()
user.delete()
cursor.close()
return None
correo_pk = postfix_data[0]
# Try and get the user_id from usu_mail
query = "SELECT fk_usu FROM mail_usu WHERE fk_mail = %s"
params = (correo_pk, )
cursor.execute(query, params)
user_data = cursor.fetchone()
if not user_data:
logging.info(
"User %s with correopk %s does not exist in table 'mail_usu'" %
(username, correo_pk))
profile.delete()
user.delete()
cursor.close()
return None
profile.old_id = user_data[0]
cursor.close()
cursor = connections['principal'].cursor()
# First of all, determine user role
profile.determine_role(cursor)
# If user is not reg. op. manager, fetch company
if profile.is_regional_operations_manager():
cuerpos = Region.fetch_all_related(cursor, profile.get_region_id())
for cuerpo_data in cuerpos:
cuerpo = Cuerpo.fetch_from_db(cursor, cuerpo_data["id"])
if cuerpo: # is null in case of virtual cuerpo or inconsistent db
cuerpo.save()
else:
# Try and get the user company
query = "SELECT usu_fk_cia FROM usuarios WHERE usu_id = %s"
params = (profile.old_id, )
cursor.execute(query, params)
user_data = cursor.fetchone()
if not user_data:
# The user does not exist in the principal database (broken foreign key)
# As always, burn and quit
logging.error(
"User %s with id %s does not exist in table 'usuarios'",
username, profile.old_id)
profile.delete()
user.delete()
cursor.close()
return None
old_company_id = user_data[0]
company = Company.fetch_from_db(cursor, old_company_id)
if not company:
logging.error(
"User %s associated company is foreign key broken (in commune, province, region, or cuerpo)",
username)
profile.delete()
user.delete()
cursor.close()
return None
profile.company = company
profile.save()
user.save()
cursor.close()
return user