コード例 #1
0
ファイル: dividends.py プロジェクト: davidjo/gnucash_python
    def renderer (self, report):

        # this actually implements the report look

        # for some reason if do this if any error occurs in report GUI is locked
        #report_starting(self.name)

        # lots of stuff about getting option values

        optobj = self.options.lookup_name('General','Start Date')
        from_date_tp = optobj.get_option_value()
        optobj = self.options.lookup_name('General','End Date')
        to_date_tp = optobj.get_option_value()

        #pdb.set_trace()

        # now for html creation
        # where do we actually instantiate the Html object

        # in scheme created new scheme html doc
        # in python probably should pass the report xml document 
        # does the possibility of having new HtmlDocument make sense??
        document = gnc_html_document.HtmlDocument(stylesheet=report.stylesheet())

        # temporary measure - set the document style
        # some this should be done auto by the stylesheet set
        # but the StyleTable is not currently stored in the stylesheet
        # or at least not the right one
        document.style = report.style

        optobj = self.options.lookup_name('General',"Report's currency")
        report_currency = optobj.get_value()
        optobj = self.options.lookup_name('General','Price Source')
        price_source = optobj.get_option_value()

        optobj = self.options.lookup_name('General','Show Full Account Names')
        show_full_names = optobj.get_value()

        optobj = self.options.lookup_name('Accounts','Account Display Depth')
        display_depth = optobj.get_option_value()

        rptopt = self.options.lookup_name('General','Report name')
        rptttl = rptopt.get_value() + " - " + N_("%s to %s"%(gnc_print_date(from_date_tp),gnc_print_date(to_date_tp)))
        document.title = rptttl

        accobj = self.options.lookup_name('Accounts','Account')
        accounts = accobj.get_option_value()

        shwobj = self.options.lookup_name('Accounts','Always show sub-accounts')
        shwopt = shwobj.get_value()

        print("shwobj",shwobj,shwopt, file=sys.stderr)

        if shwopt:
            subacclst = get_all_subaccounts(accounts)
            for subacc in subacclst:
                if not Dividends.account_in_list(subacc,accounts):
                    accounts.append(subacc)

        #exchange_fn = gnc_commodity_utilities.case_exchange_fn(price_source, report_currency, to_date_tp)

        #pdb.set_trace()

        if len(accounts) > 0:

            if display_depth == 'all':
                tree_depth = self.accounts_get_children_depth(accounts)
            else:
                tree_depth = int(display_depth)

            #self.time_exchange_fn = gnc_commodity_utilities.case_exchange_time_fn(price_source, report_currency, commodity_list, to_date_tp, 0.0, 0.0)

            #pdb.set_trace()

            # need to figure out how to sort by full name
            # well this is useless - we need the account name!!
            accounts.sort(key=operator.methodcaller('GetName'))
            #self.money_in_accounts.sort(key=operator.methodcaller('GetName'))
            #self.money_out_accounts.sort(key=operator.methodcaller('GetName'))


            # find dividend accounts - junkily just look for name
            # - they have already been filtered for ACCT_TYPE_INCOME by default
            # - do we check again here??

            dividend_accounts = []

            for acc in accounts:
                if acc.get_current_depth() <= tree_depth:
                    accnm = acc.GetName()
                    if accnm.find('Dividend') >= 0 or accnm.find('dividend') >= 0:
                        if not Dividends.account_in_list(acc,dividend_accounts):
                            dividend_accounts.append(acc)
                            subacclst = get_all_subaccounts([acc])
                            for subacc in subacclst:
                                if not Dividends.account_in_list(subacc,dividend_accounts):
                                    dividend_accounts.append(subacc)
                    else:
                        parent = acc.get_parent()
                        prntnm = parent.GetName()
                        if prntnm.find('Dividend') >= 0 or prntnm.find('dividend') >= 0:
                            if not Dividends.account_in_list(acc,dividend_accounts):
                                dividend_accounts.append(acc)
                                subacclst = get_all_subaccounts([acc])
                                for subacc in subacclst:
                                    if not Dividends.account_in_list(subacc,dividend_accounts):
                                        dividend_accounts.append(subacc)


            base_text = document.StyleElement('body')
            base_text.text = N_("Selected Accounts")+"\n"
            base_text.tail = "\n"

            ultxt = document.doc.Element("ul")

            work_done = 0
            work_to_do = len(dividend_accounts)

            for acc in dividend_accounts:
                work_done += 1
                report_percent_done((work_done/float(work_to_do))*85.0)

                if acc.get_current_depth() <= tree_depth:

                    if show_full_names:
                        #accnm = acc.GetFullName()
                        accnm = acc.get_full_name()
                    else:
                        accnm = acc.GetName()
                    if acc.get_current_depth() == tree_depth and \
                        not len(acc.get_children()) == 0:
                        if shwopt:
                            acctxt = N_(" and subaccounts")
                        else:
                            acctxt = N_(" and selected subaccounts")
                    else:
                        acctxt = ""
                    accurl = gnc_html_utilities.account_anchor_text(acc)

                    anchor_li = document.doc.SubElement(ultxt,"li")

                    anchor_markup = document.doc.SubElement(anchor_li,"a")
                    anchor_markup.attrib['href'] = accurl
                    anchor_markup.text = N_(accnm) + "\n"
                    anchor_markup.tail = acctxt + "\n"


            do_accounts = []
            for acc in dividend_accounts:
                doacc = False
                for split in acc.GetSplitList():
                    parent = split.GetParent()
                    txn_date = parent.RetDatePosted().date()
                    if (txn_date >= from_date_tp.date() and txn_date <= to_date_tp.date()):
                        doacc = True
                if doacc:
                    do_accounts.append(acc)


            # Scheme uses a whole subclass of functions for dealing with
            # tables - indirectly creating all table elements
            # ignoring all this for now - just using CSS styles
            new_table = document.StyleElement('table')
            new_table.text = "\n"

            new_row = document.doc.SubElement(new_table,"tr")
            new_row.tail = "\n"
            new_data = document.doc.SubElement(new_row,"td",attrib={'rowspan' : "1", 'colspan' : "2" })
            new_ruler = document.doc.SubElement(new_data,"hr")

            new_row = document.StyleSubElement(new_table,'primary-subheading')
            new_row.text = ""
            new_row.tail = "\n"

            #new_col = document.doc.SubElement(new_row,"td",attrib={'rowspan' : "1", 'colspan' : "1"})
            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Dividend Account")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Payment Date")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Dividend Income")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Exchange Rate")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Report Currency")
            
            row_num = 0
            work_done = 0
            work_to_do = len(dividend_accounts)

            #pdb.set_trace()

            total_coll = CommodityCollector()
            total_rpt_coll = CommodityCollector()

            # this is bad - this assumes all dividends in single currency
            total_commod = None

            #for acc in dividend_accounts:
            for acc in do_accounts:

                row_num += 1
                work_done += 1
                report_percent_done((work_done/float(work_to_do))*5.0+90.0)

                if (row_num % 2) == 0:
                    new_row = document.StyleSubElement(new_table,'normal-row')
                else:
                    new_row = document.StyleSubElement(new_table,'alternate-row')

                new_row = document.StyleSubElement(new_table,'normal-row')
                new_row.text = "\n"
                new_row.tail = "\n"

                if show_full_names:
                    #accnm = acc.GetFullName()
                    accnm = acc.get_full_name()
                else:
                    accnm = acc.GetName()
                accurl = gnc_html_utilities.account_anchor_text(acc)

                new_col = document.doc.SubElement(new_row,"td")

                anchor_markup = document.doc.SubElement(new_col,"a")
                anchor_markup.attrib['href'] = accurl
                anchor_markup.text = accnm + "\n"

                acc_coll = CommodityCollector()
                acc_rpt_coll = CommodityCollector()

                for split in acc.GetSplitList():

                    parent = split.GetParent()
                    txn_date = parent.RetDatePosted().date()
                    commod_currency = parent.GetCurrency()
                    commod_currency_frac = commod_currency.get_fraction()

                    try:
                        other_split = split.GetOtherSplit()
                    except Exception as errexc:
                        other_split = None
                    print("other split for", other_split)

                    #if other_split != None:
                    #    other_accnt = 

                    corr_accnm = split.GetCorrAccountName()
                    print("corr account", corr_accnm)

                    # what do the functions eg GetCorrAccountName() do??
                    #

                    #if splt.GetAccount()

                    if (txn_date >= from_date_tp.date() and txn_date <= to_date_tp.date()):

                        row_num += 1

                        if (row_num % 2) == 0:
                            new_row = document.StyleSubElement(new_table,'normal-row')
                        else:
                            new_row = document.StyleSubElement(new_table,'alternate-row')

                        new_col = document.StyleSubElement(new_row,'text-cell')
                        new_col.text = N_(parent.GetDescription())

                        new_col = document.StyleSubElement(new_row,'text-cell')
                        new_col.text = N_(gnc_print_date(txn_date))

                        split_val = split.GetValue()

                        # we need to change the sign
                        split_val = split_val.neg()
 
                        # which is currency acc or other_acct??
                        #pdb.set_trace()

                        colval = gnc_commodity_utilities.GncMonetary(commod_currency,split_val)

                        new_col = document.StyleSubElement(new_row,'number-cell')
                        new_col.text = colval.to_currency_string()

                        # no easy way to get exchange rate
                        # - even in scheme do it by transforming an amount of 1
                        # actually uses 1000 to get the sig figs
                        # if no price we get none - make it 1
                        if not engine_ctypes.CommodityEquiv(commod_currency,report_currency):
                            prcval = GncNumeric(1000,1000)
                            prcmny = gnc_commodity_utilities.GncMonetary(commod_currency,prcval)
                            prcxch = gnc_commodity_utilities.exchange_by_pricedb_nearest(prcmny,report_currency,txn_date)
                            if prcxch == None:
                                prcxch = gnc_commodity_utilities.exchange_by_pricedb_latest(prcmny,report_currency)
                                if prcxch == None:
                                    prcxch = gnc_commodity_utilities.GncMonetary(report_currency,GncNumeric(1000,1000))
                            sclval = GncNumeric(1000,1000)
                            prcxch.amount = sclval.div(prcxch.amount,GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 6*256 | GNC_HOW_RND_ROUND)
                            #exch_rate = gnc_commodity_utilities.GncMonetary(report_currency,prcxch)
                            exch_rate = prcxch.amount
                        else:
                            #exch_rate = gnc_commodity_utilities.GncMonetary(report_currency,GncNumeric(1000,1000))
                            exch_rate = GncNumeric(1000,1000)


                        new_col = document.StyleSubElement(new_row,'number-cell')
                        #new_col.text = exch_rate.to_currency_string()
                        new_col.text = str(exch_rate.to_double())


                        if not engine_ctypes.CommodityEquiv(commod_currency,report_currency):
                            split_mny = gnc_commodity_utilities.GncMonetary(commod_currency,split_val)
                            splt_rpt = gnc_commodity_utilities.exchange_by_pricedb_nearest(split_mny,report_currency,txn_date)
                            if splt_rpt == None:
                                splt_rpt = gnc_commodity_utilities.exchange_by_pricedb_latest(split_mny,report_currency)
                                if splt_rpt == None:
                                    splt_rpt = gnc_commodity_utilities.GncMonetary(report_currency,GncNumeric(1000,1000))
                        else:
                            splt_rpt = gnc_commodity_utilities.GncMonetary(report_currency,split_val)

                        acc_coll.add(commod_currency, split_val)
                        total_coll.add(commod_currency, split_val)
                        acc_rpt_coll.add(splt_rpt.commodity, splt_rpt.amount)
                        total_rpt_coll.add(splt_rpt.commodity, splt_rpt.amount)

                        total_commod = commod_currency

                        colval = splt_rpt

                        new_col = document.StyleSubElement(new_row,'number-cell')
                        new_col.text = colval.to_currency_string()

                new_row = document.StyleSubElement(new_table,'normal-row')

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = "Balance"

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                #colval = gnc_commodity_utilities.GncMonetary(acc.GetCommodity(),acc.GetBalance().neg())
                colval = acc_coll.getmonetary(acc.GetCommodity())

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                colval = acc_rpt_coll.getmonetary(report_currency)

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()


                new_row = document.StyleSubElement(new_table,'normal-row')

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = "Joint contribution"

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                #colval = gnc_commodity_utilities.GncMonetary(acc.GetCommodity(),acc.GetBalance().neg())
                colval = acc_coll.getmonetary(acc.GetCommodity())
                colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                colval = acc_rpt_coll.getmonetary(report_currency)
                colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()


            if len(do_accounts) > 0:

                new_row = document.StyleSubElement(new_table,'normal-row')
                new_row.text = "\n"
                new_row.tail = "\n"

                new_data = document.doc.SubElement(new_row,"td",attrib={'rowspan' : "1", 'colspan' : "100%" })
                new_ruler = document.doc.SubElement(new_data,"hr")

                new_row = document.StyleSubElement(new_table,'grand-total')
                new_row.text = "\n"
                new_row.tail = "\n"

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = N_("Total")

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = " "

                colval = total_coll.getmonetary(total_commod)

                new_col = document.StyleSubElement(new_row,'total-number-cell')
                new_col.text = colval.to_currency_string()

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = " "

                colval = total_rpt_coll.getmonetary(report_currency)

                new_col = document.StyleSubElement(new_row,'total-number-cell')
                new_col.text = colval.to_currency_string()


                new_row = document.StyleSubElement(new_table,'grand-total')
                new_row.text = "\n"
                new_row.tail = "\n"

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = N_("Joint Contribution Total")

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = " "

                colval = total_coll.getmonetary(total_commod)
                colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'total-number-cell')
                new_col.text = colval.to_currency_string()

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = " "

                colval = total_rpt_coll.getmonetary(report_currency)
                colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'total-number-cell')
                new_col.text = colval.to_currency_string()


                new_row = document.StyleSubElement(new_table,'grand-total')
                new_row.text = "\n"
                new_row.tail = "\n"

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = N_("Joint Contribution US Tax (15%)")

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = " "

                # 15% is 0.15 (3/20) but halve for joint 0.15/2 or 3/40
                colval = total_coll.getmonetary(total_commod)
                colval.amount = colval.amount.mul(GncNumeric(3,40),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'total-number-cell')
                new_col.text = colval.to_currency_string()

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = " "

                # 15% is 0.15 (3/20) but halve for joint 0.15/2 or 3/40
                colval = total_rpt_coll.getmonetary(report_currency)
                colval.amount = colval.amount.mul(GncNumeric(3,40),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'total-number-cell')
                new_col.text = colval.to_currency_string()


            #new_col = document.StyleSubElement(new_row,'text-cell')
            #new_col.text = N_("Money In")
            #new_col = document.StyleSubElement(new_row,'total-number-cell')
            #colval = self.money_in_collector.sum(report_currency, exchange_fn)
            #new_col.text = colval.to_currency_string()


        report_finished()

        return document
コード例 #2
0
ファイル: transaction.py プロジェクト: davidjo/gnucash_python
    def renderer (self, report):

        # this actually implements the report look

        # for some reason if do this if any error occurs in report GUI is locked
        #report_starting(self.name)

        # lots of stuff about getting option values

        optobj = self.options.lookup_name('General','Start Date')
        from_date_tp = optobj.get_option_value()
        optobj = self.options.lookup_name('General','End Date')
        to_date_tp = optobj.get_option_value()

        #pdb.set_trace()

        # now for html creation
        # where do we actually instantiate the Html object

        # in scheme created new scheme html doc
        # in python probably should pass the report xml document 
        # does the possibility of having new HtmlDocument make sense??
        document = gnc_html_document.HtmlDocument(stylesheet=report.stylesheet())

        # temporary measure - set the document style
        # some this should be done auto by the stylesheet set
        # but the StyleTable is not currently stored in the stylesheet
        # or at least not the right one
        document.style = report.style

        optobj = self.options.lookup_name('General',"Report's currency")
        report_currency = optobj.get_value()
        optobj = self.options.lookup_name('General','Price Source')
        price_source = optobj.get_option_value()

        optobj = self.options.lookup_name('General','Show Full Account Names')
        show_full_names = optobj.get_value()

        optobj = self.options.lookup_name('Accounts','Account Display Depth')
        display_depth = int(optobj.get_option_value())

        rptopt = self.options.lookup_name('General','Report name')
        rptttl = rptopt.get_value() + " - " + N_("%s to %s"%(gnc_print_date(from_date_tp),gnc_print_date(to_date_tp)))
        document.title = rptttl

        accobj = self.options.lookup_name('Accounts','Account')
        accounts = accobj.get_option_value()

        shwobj = self.options.lookup_name('Accounts','Always show sub-accounts')
        shwopt = shwobj.get_value()

        print("shwobj",shwobj,shwopt, file=sys.stderr)

        #if shwopt:
        #    subacclst = get_all_subaccounts(accounts)
        #    for subacc in subacclst:
        #        if not Interest.account_in_list(subacc,accounts):
        #            accounts.append(subacc)

        #exchange_fn = gnc_commodity_utilities.case_exchange_fn(price_source, report_currency, to_date_tp)

        #pdb.set_trace()

        print("account len",len(accounts), file=sys.stderr)

        if len(accounts) > 0:

            topdepth = 10000
            for acc in accounts:
                curdep = int(acc.get_current_depth())
                if curdep < topdepth: topdepth = curdep
            print("account min depth",topdepth, file=sys.stderr)

            if display_depth == 'all':
                tree_depth = self.accounts_get_children_depth(accounts)
            else:
                tree_depth = topdepth+display_depth
            print("treedepth",tree_depth, file=sys.stderr)

            #self.time_exchange_fn = gnc_commodity_utilities.case_exchange_time_fn(price_source, report_currency, commodity_list, to_date_tp, 0.0, 0.0)

            #pdb.set_trace()

            # need to figure out how to sort by full name
            # well this is useless - we need the account name!!
            accounts.sort(key=operator.methodcaller('GetName'))
            #self.money_in_accounts.sort(key=operator.methodcaller('GetName'))
            #self.money_out_accounts.sort(key=operator.methodcaller('GetName'))


            base_text = document.StyleElement('body')
            base_text.text = N_("Selected Accounts")+"\n"
            base_text.tail = "\n"

            ultxt = document.doc.Element("ul")

            work_done = 0
            work_to_do = len(accounts)

            for acc in accounts:
                work_done += 1
                report_percent_done((work_done/float(work_to_do))*85.0)

                if acc.get_current_depth() <= tree_depth:

                    if show_full_names:
                        #accnm = acc.GetFullName()
                        accnm = acc.get_full_name()
                    else:
                        accnm = acc.GetName()
                    if acc.get_current_depth() == tree_depth and \
                        not len(acc.get_children()) == 0:
                        if shwopt:
                            acctxt = N_(" and subaccounts")
                        else:
                            acctxt = N_(" and selected subaccounts")
                    else:
                        acctxt = ""
                    accurl = gnc_html_utilities.account_anchor_text(acc)

                    anchor_li = document.doc.SubElement(ultxt,"li")

                    anchor_markup = document.doc.SubElement(anchor_li,"a")
                    anchor_markup.attrib['href'] = accurl
                    anchor_markup.text = N_(accnm) + "\n"
                    anchor_markup.tail = acctxt + "\n"


            do_accounts = []
            for acc in accounts:
                doacc = False
                for split in acc.GetSplitList():
                    parent = split.GetParent()
                    txn_date = parent.RetDatePosted().date()
                    if (txn_date >= from_date_tp.date() and txn_date <= to_date_tp.date()):
                        doacc = True
                if doacc:
                    do_accounts.append(acc)


            # Scheme uses a whole subclass of functions for dealing with
            # tables - indirectly creating all table elements
            # ignoring all this for now - just using CSS styles
            new_table = document.StyleElement('table')
            new_table.text = "\n"

            new_row = document.doc.SubElement(new_table,"tr")
            new_row.tail = "\n"
            new_data = document.doc.SubElement(new_row,"td",attrib={'rowspan' : "1", 'colspan' : "2" })
            new_ruler = document.doc.SubElement(new_data,"hr")

            new_row = document.StyleSubElement(new_table,'primary-subheading')
            new_row.text = ""
            new_row.tail = "\n"

            #new_col = document.doc.SubElement(new_row,"td",attrib={'rowspan' : "1", 'colspan' : "1"})
            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Date")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Num")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Description")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Memo/Notes")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Amount")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Exchange Rate")

            new_col = document.doc.SubElement(new_row,"td")
            new_col.text = N_("Report Currency")
            
            row_num = 0
            work_done = 0
            work_to_do = len(accounts)

            #pdb.set_trace()

            total_coll = CommodityCollector()
            total_rpt_coll = CommodityCollector()

            # this is bad - this assumes all interest in single currency
            total_commod = None

            #for acc in accounts:
            for acc in do_accounts:

                row_num += 1
                work_done += 1
                report_percent_done((work_done/float(work_to_do))*5.0+90.0)

                new_row = document.StyleSubElement(new_table,'normal-row')
                new_row.text = "\n"
                new_row.tail = "\n"

                if show_full_names:
                    #accnm = acc.GetFullName()
                    accnm = acc.get_full_name()
                else:
                    accnm = acc.GetName()
                accurl = gnc_html_utilities.account_anchor_text(acc)

                new_col = document.doc.SubElement(new_row,"td")

                anchor_markup = document.doc.SubElement(new_col,"a")
                anchor_markup.attrib['href'] = accurl
                anchor_markup.text = accnm + "\n"
                try:
                    jnkstr = accnm.encode('utf-8')
                except Exception as errexc :
                    pdb.set_trace()


                #pdb.set_trace()

                acc_currency = acc.GetCommodity()
                acc_currency_frac = acc_currency.get_fraction()


                # for the moment get exchange rate per account - assuming we do not have mutiple currencies in accounts
                # no easy way to get exchange rate
                # - even in scheme do it by transforming an amount of 1
                # actually uses 1000 to get the sig figs
                # if no price we get none - make it 1
                if not engine_ctypes.CommodityEquiv(acc_currency,report_currency):
                    prcval = GncNumeric(1000,1000)
                    prcmny = gnc_commodity_utilities.GncMonetary(acc_currency,prcval)
                    prcxch = gnc_commodity_utilities.exchange_by_pricedb_nearest(prcmny,report_currency,txn_date)
                    if prcxch == None:
                        prcxch = gnc_commodity_utilities.exchange_by_pricedb_latest(prcmny,report_currency)
                        if prcxch == None:
                            prcxch = gnc_commodity_utilities.GncMonetary(report_currency,GncNumeric(1000,1000))
                    sclval = GncNumeric(1000,1000)
                    prcxch.amount = sclval.div(prcxch.amount,GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 6*256 | GNC_HOW_RND_ROUND)
                    #exch_rate = gnc_commodity_utilities.GncMonetary(report_currency,prcxch)
                    exch_rate = prcxch.amount
                else:
                    #exch_rate = gnc_commodity_utilities.GncMonetary(report_currency,GncNumeric(1000,1000))
                    exch_rate = GncNumeric(1000,1000)


                acc_coll = CommodityCollector()
                acc_rpt_coll = CommodityCollector()

                # new idea - lets have a dict of commodities we find to get a subtotal for each commodity
                # well thats the goal but we have no connection to the original stock in the Tax
                # - all we have is the memo - which at least is constant per stock
                commod_colls = {} 

                for split in acc.GetSplitList():

                    parent = split.GetParent()
                    txn_date = parent.RetDatePosted().date()
                    split_currency = parent.GetCurrency()
                    split_currency_frac = split_currency.get_fraction()

                    try:
                        other_split = split.GetOtherSplit()
                    except Exception as errexc:
                        other_split = None
                    print("other split for", other_split)

                    #if other_split != None:
                    #    other_accnt = 

                    corr_accnm = split.GetCorrAccountName()
                    print("corr account", corr_accnm)

                    # what do the functions eg GetCorrAccountName() do??
                    #

                    #if splt.GetAccount()

                    if (txn_date >= from_date_tp.date() and txn_date <= to_date_tp.date()):

                        row_num += 1

                        if (row_num % 2) == 0:
                            new_row = document.StyleSubElement(new_table,'normal-row')
                        else:
                            new_row = document.StyleSubElement(new_table,'alternate-row')

                        # Date column
                        new_col = document.StyleSubElement(new_row,'text-cell')
                        new_col.text = N_(gnc_print_date(txn_date))

                        # Num column
                        new_col = document.StyleSubElement(new_row,'text-cell')
                        new_col.text = N_("")

                        # Description
                        new_col = document.StyleSubElement(new_row,'text-cell')

                        #new_col.text = N_(parent.GetDescription())
                        # unfortunately GetDescription returns a str type for utf-8 encoded data
                        # - we need to fix it
                        desctxt = parent.GetDescription()
                        try:
                            newtxt = desctxt.encode('utf-8')
                        except Exception as errexc:
                            newtxt = desctxt.decode('utf-8')
                            desctxt = newtxt
                            #pdb.set_trace()
                        new_col.text = N_(desctxt)

                        # Memo/Notes
                        # so the transaction has the Notes and the splits the memo
                        new_col = document.StyleSubElement(new_row,'text-cell')
                        #new_col.text = N_(split.GetMemo())
                        #new_col.text = N_(parent.GetNotes())
                        memotxt = split.GetMemo()
                        notestxt = parent.GetNotes()
                        new_col.text = N_(memotxt)

                        split_val = split.GetValue()

                        ## we need to change the sign
                        #split_val = split_val.neg()

                        # so this is not right - the transaction description
                        # is what has the stock description now
                        memostr = ""
                        if other_split != None:
                            # sum the splits per memo
                            memostr = other_split.GetMemo()
                            #if memostr in commod_colls:
                            #    commod_colls[memostr].add(acc_currency, split_val)
                            #else:
                            #    commod_colls[memostr] = CommodityCollector()
                            #    commod_colls[memostr].add(acc_currency, split_val)
                            if desctxt in commod_colls:
                                commod_colls[desctxt].add(acc_currency, split_val)
                            else:
                                commod_colls[desctxt] = CommodityCollector()
                                commod_colls[desctxt].add(acc_currency, split_val)

                        print("split val", memostr, str(split_val.to_double()))

 
                        # which is currency acc or other_acct??
                        #pdb.set_trace()

                        #colval = gnc_commodity_utilities.GncMonetary(commod_currency,split_val)
                        colval = gnc_commodity_utilities.GncMonetary(acc_currency,split_val)
                        print("coll val", str(colval.to_currency_string()))

                        # Account
                        new_col = document.StyleSubElement(new_row,'number-cell')
                        new_col.text = colval.to_currency_string()


                        # Exchange rate
                        new_col = document.StyleSubElement(new_row,'number-cell')
                        #new_col.text = exch_rate.to_currency_string()
                        new_col.text = str(exch_rate.to_double())


                        if not engine_ctypes.CommodityEquiv(acc_currency,report_currency):
                            split_mny = gnc_commodity_utilities.GncMonetary(acc_currency,split_val)
                            splt_rpt = gnc_commodity_utilities.exchange_by_pricedb_nearest(split_mny,report_currency,txn_date)
                            if splt_rpt == None:
                                splt_rpt = gnc_commodity_utilities.exchange_by_pricedb_latest(split_mny,report_currency)
                                if splt_rpt == None:
                                    splt_rpt = gnc_commodity_utilities.GncMonetary(report_currency,GncNumeric(1000,1000))
                        else:
                            splt_rpt = gnc_commodity_utilities.GncMonetary(report_currency,split_val)

                        acc_coll.add(acc_currency, split_val)
                        #total_coll.add(acc_currency, split_val)
                        acc_rpt_coll.add(splt_rpt.commodity, splt_rpt.amount)
                        #total_rpt_coll.add(splt_rpt.commodity, splt_rpt.amount)

                        #total_commod = acc_currency

                        #colval = splt_rpt

                        new_col = document.StyleSubElement(new_row,'number-cell')
                        new_col.text = colval.to_currency_string()


                new_row = document.StyleSubElement(new_table,'normal-row')

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""


                new_row = document.StyleSubElement(new_table,'normal-row')

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = "Account Total"

                # Num
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Description
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Memo/Notes
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Amount
                #colval = gnc_commodity_utilities.GncMonetary(acc.GetCommodity(),acc.GetBalance().neg())
                colval = acc_coll.getmonetary(acc.GetCommodity())

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()

                # Exchange Rate
                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = N_("")

                # Amount report currency
                colval = acc_rpt_coll.getmonetary(report_currency)

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()


                new_row = document.StyleSubElement(new_table,'normal-row')

                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = "Joint contribution"

                # Num
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Description
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Memo/Notes
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Amount
                #colval = gnc_commodity_utilities.GncMonetary(acc.GetCommodity(),acc.GetBalance().neg())
                colval = acc_coll.getmonetary(acc.GetCommodity())
                colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()

                # Exchange Rate
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # Amount report currency
                colval = acc_rpt_coll.getmonetary(report_currency)
                colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                new_col = document.StyleSubElement(new_row,'number-cell')
                new_col.text = colval.to_currency_string()


                new_row = document.StyleSubElement(new_table,'normal-row')
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                new_row = document.StyleSubElement(new_table,'normal-row')
                new_col = document.StyleSubElement(new_row,'text-cell')
                new_col.text = ""

                # dump totals per stock - in this case per memo

                pdb.set_trace()

                for commod in sorted(commod_colls.keys()):

                    new_row = document.StyleSubElement(new_table,'normal-row')

                    new_col = document.StyleSubElement(new_row,'text-cell')
                    new_col.text = "Commodity Total"

                    # Num
                    new_col = document.StyleSubElement(new_row,'text-cell')
                    new_col.text = ""

                    # Description
                    new_col = document.StyleSubElement(new_row,'text-cell')
                    new_col.text = N_(commod)

                    # Memo/Notes
                    new_col = document.StyleSubElement(new_row,'text-cell')
                    new_col.text = ""

                    # Amount
                    #colval = gnc_commodity_utilities.GncMonetary(acc.GetCommodity(),acc.GetBalance().neg())
                    commod_coll = commod_colls[commod]
                    colval = commod_coll.getmonetary(acc.GetCommodity())
                    #colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                    new_col = document.StyleSubElement(new_row,'number-cell')
                    new_col.text = colval.to_currency_string()

                    # Exchange Rate
                    new_col = document.StyleSubElement(new_row,'text-cell')
                    new_col.text = ""

                    # Amount report currency
                    commod_coll = commod_colls[commod]
                    colval = commod_coll.getmonetary(report_currency)
                    #colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                    new_col = document.StyleSubElement(new_row,'number-cell')
                    new_col.text = colval.to_currency_string()


            if len(do_accounts) > 0:

                #new_row = document.StyleSubElement(new_table,'normal-row')
                #new_row.text = "\n"
                #new_row.tail = "\n"

                #new_data = document.doc.SubElement(new_row,"td",attrib={'rowspan' : "1", 'colspan' : "100%" })
                #new_ruler = document.doc.SubElement(new_data,"hr")

                #new_row = document.StyleSubElement(new_table,'grand-total')
                #new_row.text = "\n"
                #new_row.tail = "\n"

                #new_col = document.StyleSubElement(new_row,'text-cell')
                #new_col.text = N_("Total")

                #new_col = document.StyleSubElement(new_row,'text-cell')
                #new_col.text = " "

                #colval = total_coll.getmonetary(total_commod)

                #new_col = document.StyleSubElement(new_row,'total-number-cell')
                #new_col.text = colval.to_currency_string()

                #new_col = document.StyleSubElement(new_row,'text-cell')
                #new_col.text = " "

                #colval = total_rpt_coll.getmonetary(report_currency)

                #new_col = document.StyleSubElement(new_row,'total-number-cell')
                #new_col.text = colval.to_currency_string()


                #new_row = document.StyleSubElement(new_table,'grand-total')
                #new_row.text = "\n"
                #new_row.tail = "\n"

                #new_col = document.StyleSubElement(new_row,'text-cell')
                #new_col.text = N_("Joint Contribution Total")

                #new_col = document.StyleSubElement(new_row,'text-cell')
                #new_col.text = " "

                #colval = total_coll.getmonetary(total_commod)
                #colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                #new_col = document.StyleSubElement(new_row,'total-number-cell')
                #new_col.text = colval.to_currency_string()

                #new_col = document.StyleSubElement(new_row,'text-cell')
                #new_col.text = " "

                #colval = total_rpt_coll.getmonetary(report_currency)
                #colval.amount = colval.amount.div(GncNumeric(2,1),GNC_DENOM_AUTO,GNC_HOW_DENOM_SIGFIG | 5*256 | GNC_HOW_RND_ROUND)

                #new_col = document.StyleSubElement(new_row,'total-number-cell')
                #new_col.text = colval.to_currency_string()

                pass



            #new_col = document.StyleSubElement(new_row,'text-cell')
            #new_col.text = N_("Money In")
            #new_col = document.StyleSubElement(new_row,'total-number-cell')
            #colval = self.money_in_collector.sum(report_currency, exchange_fn)
            #new_col.text = colval.to_currency_string()


        report_finished()

        return document