showing the extract of an account

Posted 1 year ago by halil

Hi. I'm working on our own accounting system which includes cash, bank account, inventory etc. I have the tables for all these processes. Now i want to get the extract of a customer(or safe, supplier, stock, bank account). For customer, the related tables are cash_from_customers, sales, card_payments etc. The similar columns for all these tables are id, amount, date. How can i query and get below result for a certain customer?

the result what i want: http://imgur.com/a/ZtAFm

Please sign in or create an account to participate in this conversation.

Laracasts Mascot

Hi, Have We Met Yet?

Did you know that, in addition to the forum, Laracasts includes well over 1000 lessons on modern web development? All for the price of one lunch out per month.

Sign Me Up


Reply to

Use Markdown with GitHub-flavored code blocks.