| | |
| | | FROM invoice_ledger il |
| | | JOIN invoice_registration_product irp ON il.invoice_registration_product_id = irp.id |
| | | JOIN sales_ledger sl ON irp.sales_ledger_id = sl.id |
| | | WHERE sl.customer_id =22 |
| | | WHERE sl.customer_id = #{customerId} |
| | | AND rp.invoice_ledger_id = il.id |
| | | ) |
| | | |
| | |
| | | JOIN invoice_registration_product irp ON il.invoice_registration_product_id = irp.id |
| | | JOIN sales_ledger sl ON irp.sales_ledger_id = sl.id |
| | | WHERE |
| | | sl.customer_id = 22 |
| | | sl.customer_id = #{customerId} |
| | | AND il.invoice_date IS NOT NULL |
| | | |
| | | ORDER BY happenTime ASC; |