def importAccounts(filename, typeofAccount):
import csv
f = open(filename, 'rb')
r = csv.DictReader(f, delimiter=',', quotechar='"')
for row in r:
parent = None
if row['parent']:
parent = Account.byNumber(row['parent']).id
#parent = row['parent']
a = Account(number=row['number'], parent_id=parent, name=unicode(row['name']),type=typeofAccount, tenant_id=currentTenant())
a.save()
if row['start']:
pass
#Journal(accountDebit_id=a.id, amount=row['start'], text="Saldo from Import").save()
f.close()
def accountList(accountType = 1):
accounts = []
a = Account().queryObject().filter(Account.type == accountType,Account.parent_id == None, Account.tenant_id == currentTenant()).all()
for account in a:
x = {"id":account.id, "number":account.number, "name":account.name}
parents = Account._iter(account)
if parents:
x["parents"] = parents
accounts.append(x)
return {"accounts":accounts}
def gen_tenant_id(mapper, connection, instance):
from tenants import currentTenant
instance.tenant_id = currentTenant()
