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/')