def inclusao(cpf_cnpj, senha, login, nome, telefone, email, endereco, especialidade): stmt = f''' select "id_usuario" from "Usuarios" where "CPF_CNPJ" = '{cpf_cnpj}' ''' result = sql.query(stmt) if result == []: stmt = f'''INSERT INTO public."Usuarios"("CPF_CNPJ", senha, login) VALUES ('{cpf_cnpj}', '{senha}', '{login}') ''' result = sql.update(stmt) if result == 'Feito': stmt = f'''select "id_usuario" from "Usuarios" where login = '******' and "CPF_CNPJ" = '{cpf_cnpj}' ''' result = sql.query(stmt) for x in result: stmt = f''' INSERT INTO public."Funcionarios"(id_usuario, nome, telefone, email, endereco, especialidade) VALUES ('{x['id_usuario']}', '{nome}', '{telefone}', '{email}','{endereco}', '{especialidade}');''' result = sql.update(stmt) else: stmt = f'''select "Id_Usuario" from Usuarios where "CPF_CNPJ" = '{cpf_cnpj}' ''' result = sql.query(stmt) for x in result: stmt = f''' INSERT INTO public."Funcionarios"("Id_Usuario", "Responsavel", "Codigo_Forma_Pagamento", "Dia_Pagamento") VALUES ('{x['Id_Usuario']}', ); ''' result = sql.update(stmt) return (result)
def login(): request.get_json(force=True) senha = request.json['senha'] login = request.json['login'] stmt = f'''select "id_usuario" from "Usuarios" where "login" = '{login}' and "senha" = '{senha}' ''' result = sql.query(stmt) return jsonify(result)
def edicao(cpf_cnpj, nome, endereco, telefone, email, senha, idusuario, responsavel, diaPagamento, login): stmt = f'''UPDATE "Clientes" set "nome_razaosocial" = '{nome}', "endereco" = '{endereco}', "telefone" = '{telefone}', "email" = '{email}' , "responsavel" = '{responsavel}', "dia_pagamento" = {diaPagamento} where "id_clientes" = {idusuario}''' result = sql.update(stmt) stmt = f'''select "id_usuario" from "Clientes" where "id_clientes" = {idusuario} ''' result = sql.query(stmt) for x in result: stmt = f''' UPDATE "Usuarios" set "CPF_CNPJ" = '{cpf_cnpj}' , "senha" = '{senha}',"login" = '{login}' where "id_usuario" = {x['id_usuario']}''' result = sql.update(stmt) return result
def todos(): stmt = 'select "id_funcionario","CPF_CNPJ", "email", "telefone","especialidade","nome" from "Usuarios" inner join "Funcionarios" on "Usuarios"."id_usuario" = "Funcionarios"."id_usuario" ' result = sql.query(stmt) return (result)
def busca(idcliente): stmt = f'select "id_clientes","nome_razaosocial","CPF_CNPJ", "telefone", "email" ,"endereco","senha","login","responsavel", "dia_pagamento" from "Usuarios" inner join "Clientes" on "Usuarios"."id_usuario" = "Clientes"."id_usuario" where "Clientes"."id_clientes" = {idcliente}' result = sql.query(stmt) return (result)
def todos(): stmt = 'select "id_clientes","CPF_CNPJ", "email", "telefone","nome_razaosocial" from "Usuarios" inner join "Clientes" on "Usuarios"."id_usuario" = "Clientes"."id_usuario" order by "id_clientes"' result = sql.query(stmt) return (result)