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 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 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 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 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 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 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 index():
data = acessa_proc('sp_selectComunicado', '8')
return render_template('index.html', data=data)
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)
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)
