Database design and implemeting the screen that users can record checks, give to currents for payment, receive payment from bank/lawyer and track all their movements. Some parts of the project are binded to other Controller.php or Model.php files (for example: Bank List for payment,Current list, lawyer list. ) Description of the project and screenshots here. Since this project is currently used by the company(MomentumSoft), source codes are private for security issues. You can send me an email for the share source code repository.
This project was developed using the PHP Codeigniter framework in accordance with the Model-View-Controller structure.
This screens are used for check record/transactions tracking for each user. All currents and banks informations are pulled from database existing records/tables dynamically due to each user's id. All bank balance transactions are saved in database,but they are not processed now. This CheckCard and CheckMovements models in database creates the necessary infrastructure for processing movements and transactions. Use Cases for Customer Check and Own Check
Database Model and Descriptions;
Main Check Screen( with some test records )
user can select type of the document. Inputs will come according to the selected document type :
recording customer check. Current Directory on "Cari Seçimi" is dynamically pulled from database. This directory shows all the currents that users have according to logged user. :
when we click the "Save/Update" button on the tab.
then we are directed to main page that all check exist. if we want to update, delete or do check transaction, ve click de "DÜZENLE/HAREKETLERİ GÖR" button on the "İŞLEMLER" tab.
And when we clicked the edit button , this buttons on "İŞLEMLER" tab are coming according to Check State. if chkeck in "PÖRTFÖYDE" state that means we can do this transactions on the check.
In order to test, when we click "BANKA TAHSİLE VER" button for send check to bank payment, this pop up model will open:
When we click the "BANKA SEÇ" button Bank Directory model will open for show users saved banks. The user can select the bank from which the check will be payment :
then we can see the check state is changed. The check can't be editted right now because we send check to bank payment. We can mark this check "BANKA TAHSİL EDİLDİ" if we get the payment(and bank payment process will be doing right now) or we can send check back to portfolio for another transaction.
if we try to delete check, we can't do that. We tell the user what he/she can do :
and we can send check back to portfolio(Click the "PÖRTFÖYE GERİ AL" button) for do another transaction.
then we can give the check another current now. When we click the "CİROLA" button current directory pop up will open.
and as can we see, after we send check to current, check transactions we can do have changed:
we will send check back to portfolio and we will mark the check as cash cashed.
we can see the check's new state on main screen.
now check is locked upbecause it was charged.
and as i said, we can see al check movements because all of this movements are saved in database that we design.
i summerized this project's doing. It's other functions ( Send check to lawyer, send check to bank assurance...) are also working properly and all records are in our database.