hi in account module i want to get all invoice record with invoice line and customer wise filter

i create one parser file parser.py

in which following function is used

def invoices(self):

self.cr.execute(

"SELECT * FROM account_move_line l ")

res = self.cr.dictfetchall()

return res

after i access in report.xml file

like

<t t-foreach="invoices()" t-as="i">

<tr>

<td>

<span t-esc="i['ref']"/>

</td>

<td>

<span t-esc="i['id']"/>

</td>

<td>

<span t-esc="i['date_created']"/>

</td>

<td>

<span t-esc="i['name']"/>

</td>

<td>

<span t-esc="i['partner_id']"/>

</td>

<td>

<span t-esc="i['credit']"/>

</td>

</tr>

</t>

but it will nit return information properly

how can i get all invoice with invoice line in report.xml