def postEscola(): form = RegistrationCurso(request.form) cpf = request.form.get('cpf') instituicao = request.form.get('instituicao') sql = str(cpf), form.curso.data, instituicao local = request.form.get('local') locais = request.form.get('locais') insti = request.form.get('insti') if locais: if insti: acessa_sql( 'INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + locais + '),' + insti + ');') print 1 else: print locais sql = 'INSERT INTO LOCAL (local) VALUES ("' + locais + '");' data = acessa_sql(sql) print data if insti: if not locais: print 3 acessa_sql( 'INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + local + '),' + insti + ');') acessa_proc('sp_insertInfo_escola', sql) return redirect('/admin')
def postForm(): form = RegistrationForm(request.form) sql = form.cpf.data, form.nome.data, form.rg.data, form.bairro.data, form.rua.data, form.casa.data, form.phone.data cpf = form.cpf.data acessa_proc('DADOS', sql) acessa_proc('sp_uploadParaAlunos', sql) if not cpf: cpf = '000.000.000-00' return redirect(url_for('escola',cpf=cpf))
def postForm(): form = RegistrationForm(request.form) sql = form.cpf.data, form.nome.data, form.rg.data, form.bairro.data, form.rua.data, form.casa.data, form.phone.data cpf = form.cpf.data acessa_proc('DADOS', sql) acessa_proc('sp_uploadParaAlunos', sql) if not cpf: cpf = '000.000.000-00' return redirect(url_for('escola', cpf=cpf))
def protocolos(): if session.get('user'): name = session.get('user') data = acessa_proc('sp_selectProtocolo', '8') return render_template('protocolos.html', name=name, data=data) else: return redirect(url_for('signin'))
def relatorio(name): if session.get('user'): name = session.get('user') dado = acessa_proc('sp_selectRelatorioCompleto', '8') return render_template('relatorio.html', name=name) else: return redirect(url_for('signin'))
def graficoInfo(): datas = acessa_proc('sp_selectQTDAlunos', '8') adata = [] for aluns in datas: a = (aluns[0], aluns[1], (str(aluns[2]))) adata.append(a) fields = ["alunos", "year", "name"] data = [dict(zip(fields, d)) for d in adata] return json.dumps(data)
def controle(): if session.get('user'): name = session.get('user') form = ComunicadoForm(request.form) sql = form.assuntos.data, name if form.assuntos.data is not None: dados = acessa_proc('InsereComunicado', sql) print dados return render_template('controle.html', name=name, form=form) else: return redirect(url_for('signin'))
def add(): cpf = request.args.get('cpf').encode('utf8') parametros = cpf, data = acessa_proc('sp_selectInserteParaAlunos', parametros) if data is None: return redirect('/admin') else: nome = data[0][0] rg = data[0][1] bairro = data[0][4] rua = data[0][2] casa = data[0][3] phone = data[0][5] return jsonify(nome=nome, rg=rg, bairro=bairro, rua=rua, casa=casa, phone=phone)
def postEscola(): form = RegistrationCurso(request.form) cpf = request.form.get('cpf') instituicao = request.form.get('instituicao') sql = str(cpf), form.curso.data, instituicao local = request.form.get('local') locais = request.form.get('locais') insti = request.form.get('insti') if locais: if insti: acessa_sql('INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + locais + '),' + insti + ');') print 1 else: print locais sql = 'INSERT INTO LOCAL (local) VALUES ("' + locais + '");' data = acessa_sql(sql) print data if insti: if not locais: print 3 acessa_sql('INSERT INTO INSTITUICAO (ID_local, instituicao) VALUES((select ID_local from LOCAL where local=' + local + '),' + insti + ');') acessa_proc('sp_insertInfo_escola', sql) return redirect('/admin')
def index(): data = acessa_proc('sp_selectComunicado', '8') return render_template('index.html', data=data)
def acessa_login(_name, _email, _password): me = User(_email, _password) _hashed_password = me.seta_password(_password) parametros = _email, _hashed_password, _name acessa_proc('sp_createUser', parametros)
def indexProtocolo(): form = IndexProtocoloForm(request.form) sql = form.assunto.data, form.email.data, form.cpf.data if form.assunto.data is not None: acessa_proc('InsereProtocolo', sql) return render_template('protocolo.html', form=form)