def endReport(request, id_action=None, string_option=None, comment=None):
logging.getLogger('info_logger').info('--- insertReportWitness ---')
id_user = request.session['id']
id_report = request.session['id_report']
query = queryUpdateReport(2, id_report)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if int(id_action) != int(
request.session['id_action']) and int(id_action) != 0:
query = queryInsertAction(id_user, id_report, id_action)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if comment != 'null':
query = queryInsertComment(id_user, id_report, comment.upper())
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if string_option != '0':
for option in string_option:
if option != ',':
query = queryInsertAction(id_user, id_report, int(option))
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
query = queryInsertAction(id_user, id_report, 1)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
return HttpResponseRedirect('/inventario_testigos/inicio/')
def closeSession(request):
logging.getLogger('info_logger').info('--- closeSession ---')
if not checkValue(request):
return render(request, 'login/start_login.html')
try:
del request.session['sessionStart']
id = int(request.session['id'])
del request.session['name']
del request.session['email']
del request.session['number_employee']
del request.session['business']
del request.session['marketstall']
del request.session['id_user']
del request.session['permission']
del request.session['active']
del request.session['id']
browser = getBrowser(request)
os = getSO(request)
ip = request.META['REMOTE_ADDR']
counter = str(ckackCounter(request))
query = queryInsertBinnacle(counter, 2, ip, id, browser, os, '')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
except:
logging.getLogger('info_logger').error(
'--- Error 404 - El servicio de autenticación no se encuentra disponible por el momento. ---'
)
return render(
request, 'error/error.html', {
'number':
'400',
'message':
'Solicitud Incorrecta',
'error':
'Actualmente usted no tiene una sesión iniciada o se cerro su sesión por inactividad. Inicie Sesión'
})
logging.getLogger('info_logger').info('--- Session Cerrada ---')
return render(request, 'login/start_login.html',
{'message_info': 'Vuelva Pronto.'})
def dateCheck(request):
logging.getLogger('info_logger').info('--- dateCheck ---')
if not checkValue(request):
date = {"error": "error"}
json_data = json.dumps(date)
return HttpResponse(json_data, content_type='application/json')
id_testigo = request.GET.get('id_testigo')
check = request.GET.get('check')
date_monitoring = request.GET.get('date_monitoring')
query = queryChangeTestigoDetails(id_testigo, date_monitoring)
number = select(query, 'tvazteca_bloq')
datas = 'ACTUALIZACION, montest_concentrado_error(REVISADOS: 0, {check}) ' \
'montest_detalle_error(REVISADO: 0,1) {number} : ' \
'id_tesgigo: {id}, fecha {date}'.format(check=check, number=number[0]['REVISADO'], id=id_testigo,
date=date_monitoring)
query = queryCheckTestigoConcentrated(id_testigo, check, date_monitoring)
result1 = queryDLL(query, 'tvazteca_vidnotd')
#result1 = queryDLL(query, 'tvazteca_bloq')
query = queryCheckTestigoDetails(id_testigo, date_monitoring)
result2 = queryDLL(query, 'tvazteca_vidnotd')
#result2 = queryDLL(query, 'tvazteca_bloq')
id = int(request.session['id'])
browser = getBrowser(request)
os = getSO(request)
ip = request.META['REMOTE_ADDR']
counter = str(ckackCounter(request))
query = queryInsertBinnacle(counter, 7, ip, id, browser, os, datas)
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
date = {"result1": result1, "result2": result2}
json_data = json.dumps(date)
return HttpResponse(json_data, content_type='application/json')
def evaluationLogin(request):
logging.getLogger('info_logger').info('--- evaluationLogin ---')
browser = getBrowser(request)
os = getSO(request)
ip = request.META['REMOTE_ADDR']
counter = str(ckackCounter(request))
if request.method == 'POST':
form = Login(request.POST)
if form.is_valid():
inputEmployee = form.cleaned_data['inputEmployee']
inputPassword = form.cleaned_data['inputPassword']
encryption = Encryption()
encryption.setData(inputEmployee)
inputEmployee = encryption.getEncryption()
encryption.setData(inputPassword)
inputPassword = encryption.getEncryption()
try:
resultSoap = Soap(inputEmployee, inputPassword)
soap = resultSoap.accessLogin()
result = soap['result']
except:
logging.getLogger('info_logger').error(
'--- Error 404 - El servicio de autenticación no se encuentra disponible por el momento. ---'
)
return render(
request, 'error/error.html', {
'number':
'404',
'message':
'No Encontrado',
'error':
'El servicio de autenticación no se encuentra disponible por el momento'
})
# print(request.META)
if '[Ok]' == result:
query = queryDetailsUser(soap['employee'][2])
# details = select(query, 'tvazteca_bloq')
details = select(query, 'tvazteca_bloq')
if len(details) == 1:
if details[0]['ACTIVO'] == 0:
request.session['sessionStart'] = True
request.session['name'] = details[0]['NOMBRE']
request.session['email'] = soap['employee'][1]
request.session['number_employee'] = soap['employee'][
2]
request.session['business'] = soap['employee'][3]
request.session['marketstall'] = details[0]['PERFIL']
request.session['id_user'] = soap['employee'][5]
request.session['permission'] = details[0]['PERMISOS']
request.session['active'] = details[0]['ACTIVO']
request.session['id'] = details[0]['ID']
request.session.set_expiry(30000)
query = queryInsertBinnacle(counter, 1, ip,
int(request.session['id']),
browser, os, '')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
return HttpResponseRedirect('inicio/')
else:
query = queryInsertBinnacle(counter, 6, ip, 1, browser,
os, '')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
logging.getLogger('info_logger').error(
'--- El Usuario. No esta activo por lo tanto no tiene acceso al sistema, Verificar su acceso ---'
)
return render(
request, 'login/start_login.html', {
'message_warning':
'El Usuario. No esta activo por lo tanto no tiene acceso al sistema, Verificar su acceso'
})
else:
query = queryInsertBinnacle(counter, 5, ip, 1, browser, os,
'')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
logging.getLogger('info_logger').error(
'--- El Usuario. No cuenta con privilegios para entrar ---'
)
return render(
request, 'login/start_login.html', {
'message_warning':
'El Usuario. No cuenta con privilegios para entrar'
})
elif '[Error]' == result:
query = queryInsertBinnacle(counter, 4, ip, 1, browser, os, '')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
logging.getLogger('info_logger').error(
'--- Contraseña incorrecta. Verficar ---')
return render(
request, 'login/start_login.html',
{'message_error': 'Contraseña incorrecta. Verficar'})
elif '[Fail]' == result:
query = queryInsertBinnacle(counter, 3, ip, 1, browser, os, '')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
logging.getLogger('info_logger').error(
'--- Usuario y Contraseña incorrectos. Verficar ---')
return render(request, 'login/start_login.html', {
'message_error':
'Usuario y Contraseña incorrectos. Verficar'
})
else:
query = queryInsertBinnacle(counter, 3, ip, 1, browser, os, '')
# queryDLL(query, 'tvazteca_bloq')
queryDLL(query, 'tvazteca_bloq')
logging.getLogger('info_logger').error(
'--- Usuario y Contraseña incorrectos. Verficar ---')
return render(request, 'login/start_login.html', {
'message_error':
'Usuario y Contraseña incorrectos. Verficar'
})
return render(request, 'login/start_login.html')
def insertReportWitness(request):
logging.getLogger('info_logger').info('--- insertReportWitness ---')
if not checkValue(request):
return render(request, 'login/start_login.html')
if request.method == 'POST':
id_user = request.session['id']
witness = request.session['witness']
if request.POST['list_sub_report'] == '0':
query = queryReportID(request.POST['list_type_report'], 1)
else:
query = queryReportID(request.POST['list_type_report'],
request.POST['list_sub_report'])
# dates = select(query, 'tvazteca_vidnotd')
data = select(query, 'tvazteca_bloq')
report = data[0]['ID']
query = queryInsertReport(witness, id_user, report, 1)
# dates = select(query, 'tvazteca_vidnotd')
id_report = query['1']
queryDLL(query['0'], 'tvazteca_bloq')
action = request.POST['list_action_report']
if '0' != action:
query = queryInsertAction(id_user, id_report, action)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
comment = request.POST['commentArea']
if comment:
query = queryInsertComment(id_user, id_report, comment.upper())
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_one_setting' in request.POST:
query = queryInsertAction(id_user, id_report, 2)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_two_setting' in request.POST:
query = queryInsertAction(id_user, id_report, 3)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_three_setting' in request.POST:
query = queryInsertAction(id_user, id_report, 4)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_four_setting' in request.POST:
query = queryInsertAction(id_user, id_report, 5)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_one' in request.POST:
query = queryInsertAction(id_user, id_report, 6)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_two' in request.POST:
query = queryInsertAction(id_user, id_report, 7)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_three' in request.POST:
query = queryInsertAction(id_user, id_report, 8)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
if 'option_four' in request.POST:
query = queryInsertAction(id_user, id_report, 9)
# dates = select(query, 'tvazteca_vidnotd')
queryDLL(query, 'tvazteca_bloq')
return HttpResponseRedirect('/inventario_testigos/inicio/')