class GetNaturezaConta():
def __init__(self, codi_emp):
self._DB = DB()
self._connection = self._DB.getConnection()
self._codi_emp = codi_emp
def get(self):
try:
sql = readSql(os.path.dirname(os.path.abspath(__file__)),
'get_natureza_conta.sql', self._codi_emp)
df = pd.read_sql_query(sql, self._connection)
data = json.loads(df.to_json(orient='records', date_format='iso'))
return data
except Exception as e:
print(e)
finally:
self._DB.closeConnection()
class GetHasZeramento():
def __init__(self):
self._DB = DB()
self._connection = self._DB.getConnection()
def get(self, codi_emp, end_date):
try:
sql = readSql(os.path.dirname(os.path.abspath(__file__)),
'get_has_zeramento.sql', end_date, codi_emp)
df = pd.read_sql_query(sql, self._connection)
data = json.loads(df.to_json(orient='records', date_format='iso'))
return data
except Exception as e:
print(e)
def closeConnection(self):
self._DB.closeConnection()
class GetBalances():
def __init__(self):
self._DB = DB()
self._connection = self._DB.getConnection()
def get(self, codi_emp, codi_emp_plano_contas, clas_cta, start_date,
end_date):
try:
sql = readSql(os.path.dirname(os.path.abspath(__file__)),
'get_balances.sql', codi_emp, codi_emp_plano_contas,
clas_cta, end_date, codi_emp, codi_emp_plano_contas,
clas_cta, end_date)
df = pd.read_sql_query(sql, self._connection)
data = json.loads(df.to_json(orient='records', date_format='iso'))
return data
except Exception as e:
print(e)
def closeConnection(self):
self._DB.closeConnection()