def get_estados_siglas(self):
with connection.cursor() as cursor:
siglas = []
cursor.execute("SELECT sigla FROM estados")
res = cursor.fetchall()
for item in res:
siglas.append(item['sigla'])
return self.json(siglas)
def get_municipios_by_uf(self, uf):
with connection.cursor() as cursor:
items = []
cursor.execute("SELECT * FROM comarcas WHERE uf = '{uf}'".format(uf=uf))
res = cursor.fetchall()
for item in res:
items.append({"codibge": item['codibge'], "nome": item['nome']})
return self.json(items)
def update_order(req, order_id):
data = req.json
with connection.cursor() as cursor:
sql = """UPDATE `processos_pedidos`
SET `tipo_pedido` = %s, `valor_risco_provavel` = %s,
`status` = %s WHERE `id` = %s"""
valor = str(data['valor_risco_provavel']).replace('.', '').replace(
',', '.')
rows = cursor.execute(
sql, (data['tipo_pedido'], valor, data['status'], order_id))
connection.commit()
return 1 if rows > 0 else 0
def new_order(req):
data = req.json
with connection.cursor() as cursor:
sql = """INSERT INTO `processos_pedidos`
(`num_processo`, `tipo_pedido`, `valor_risco_provavel`, `status`)
VALUES (%s, %s, %s, %s)"""
rows = cursor.execute(
sql, (data['num_processo'], data['tipo_pedido'],
data['valor_risco_provavel'].replace('.', '').replace(
',', '.'), data['status']))
connection.commit()
return 1 if rows > 0 else 0
def new_process(req):
data = req.json
with connection.cursor() as cursor:
sql = """INSERT INTO `processos` (`num_processo`, `data_distrib`, `reu_principal`,
`valor_causa`, `vara`, `comarca`, `uf`)
VALUES (%s, %s, %s, %s, %s, %s, %s)"""
dt = data['data_distrib'].split('/')
data_formatada = dt[2] + '-' + dt[1] + '-' + dt[0]
rows = cursor.execute(
sql,
(data['num_processo'], data_formatada, data['reu'],
data['valor'].replace('.', '').replace(
',', '.'), data['vara'], data['codibge'], data['estado']))
connection.commit()
return 1 if rows > 0 else 0
def get_process(process_id):
with connection.cursor() as cursor:
sql = """SELECT
p.num_processo,
DATE_FORMAT(p.data_distrib, '%d/%m/%Y') as data_distrib,
p.reu_principal,
p.valor_causa,
p.vara,
p.comarca as codibge,
c.nome as comarca,
p.uf,
DATE_FORMAT(FROM_UNIXTIME(p.criado), '%d/%m/%Y') as criado,
DATE_FORMAT(FROM_UNIXTIME(p.atualizado), '%d/%m/%Y') as atualizado
FROM processos as p
LEFT JOIN comarcas as c ON p.comarca = c.codibge
WHERE num_processo = {id}""".format(id=process_id)
cursor.execute(sql)
return cursor.fetchone()
def get_processes(self, page=1):
with connection.cursor() as cursor:
sql = """SELECT p.num_processo,
DATE_FORMAT(p.data_distrib, '%d/%m/%Y') as data_distrib,
p.reu_principal,
p.valor_causa,
p.vara,
p.comarca as codibge,
c.nome as comarca,
p.uf,
DATE_FORMAT(FROM_UNIXTIME(p.criado), '%d/%m/%Y') as criado,
DATE_FORMAT(FROM_UNIXTIME(p.atualizado), '%d/%m/%Y') as atualizado
FROM processos as p
LEFT JOIN comarcas as c ON p.comarca = c.codibge
ORDER BY criado DESC"""
cursor.execute(sql)
processes = cursor.fetchall()
total = len(processes)
end = page * self.ppp
start = end - self.ppp
i = 1
# cria lista de processos da página
processes_page = {"items": []}
for process in processes:
sql = "SELECT pp.id, pp.tipo_pedido, ppt.tipo as tipo_nome, pp.valor_risco_provavel, pp.status " \
"FROM `processos_pedidos` as pp " \
"LEFT JOIN `processos_pedidos_tipos` as ppt ON pp.tipo_pedido = ppt.id " \
"WHERE pp.num_processo = '{num}'".format(num=process['num_processo'])
cursor.execute(sql)
orders = cursor.fetchall()
process['pedidos'] = orders
if start < i <= end:
processes_page['items'].append(process)
i += 1
processes_page["total"] = total
processes_page["pagina"] = page
processes_page["paginas"] = int(total / self.ppp)
return self.json(processes_page)
def get_order_types():
with connection.cursor() as cursor:
cursor.execute("SELECT * FROM `processos_pedidos_tipos`")
return cursor.fetchall()