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()