How to make approval system according to role hierarchy

I want to build an approval system like this

Example:- I have roles like Sr. Manager, Manager, Team Leader, Employees.

If employee raised a query, then this query will go to his team leader, he can approval/reject this query, if accept then this query will go to manager and Sr. Manager.

How to make a flow system like this.

Notification will also be sent.

I don't know how to setup make database table for this case.

Any help will be appreciated.

Thanks in advance.

All you need is an approved field in your table, set it to 0 = not approved or 1 = approved.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )