CodeIgniter Forums
Bookkeeping CRUD app - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: Choosing CodeIgniter (https://forum.codeigniter.com/forum-8.html)
+--- Thread: Bookkeeping CRUD app (/thread-75785.html)



Bookkeeping CRUD app - [email protected] - 03-17-2020

Hi dear members,

I apologize if this thread is not in the right place.
 
I want to make CRUD bookkeeping app.

I have three types of users: admin, manager and customer. admin will be able to see everything and to add managers, customers, companies and enable predefined books (payment, invoice, tax... 9 all together).

Each customer can have one or more small companies, each company has relation to 9 books. Those books can be dis/enabled by admin or manager. Company can be dis/enabled by admin or manager

For those books is important to have: inline cell editing, inserting / adding / removing rows between rows, dynamic recalculation of income and outcome per row (plus previous row), converting currency numbers into words (php code).
Export to PDF with customized header (company name, address, identification number...), and customized footer with page number, logo, book name. 

I managed to this in LiveCycle Designer with dynamic XML forms and JavaScript , but this solution is offline, and now I want to move online, with same feel but better.

I started following Udemy course and discovered CI. Beside that I found Pro Login and PDO Crud solutions. Now I am overwhelmed with information and do not know to proceed. Now I want to combine all those solutions together.

Do you have better (simplier) approach?
Is it possible to have it done properly moving forward. Because every time I have a problem, there are dozens of semi solutions, which make me desperate and force me to try something else.

I am basically newbie in programming and open for your ideas.

Cheers, Ivica


RE: Bookkeeping CRUD app - zahhar - 03-18-2020

Honestly with you: I doubt one can just sit down and write descent bookkeeping web-app alone and within reasonable timeframe. It is a task for year(s) considering ability to work full-time. You will have to write a lot of business logic, that comes on top of all that user-management, PDF generation, form builders, etc. Unit-testing will also require additional efforts, as well as security, API, overall architecture, several rounds of refactoring...

Back to your question about merging those software packages. "Pro Login" is CI3, "PDO Crud" is not CI at all, and most probably you would like to use CI4 in your project to benefit from long-term framework support. In short: this will be a pain.


RE: Bookkeeping CRUD app - [email protected] - 03-19-2020

Thank you zahhar. I am not in the hurry, I just want to start, and stick to the plan. I know what I want (I done it in the LiveCycle Designer video showcase and people who are using it, are generally satisfied with it.). I just do not know, how to accomplish this using CI4 and all compatible technologies. I suppose I need to start with user management and permissions, after that crud datatables for each accounting form. I believe better to start from the scratch, instead of using half solutions. Where to start, to start it properly?


RE: Bookkeeping CRUD app - Natanchikk - 09-21-2020

Hi, I'm also looking for ways / libraries to implement the crud system, so if you get anything, please let me know. Or I will write if there is progress.

I can say for sure that if you process a large amount of data in tables, then datatables are not the best option for this, if speed is important to you.

I use a laravel in conjunction with a backpack for the CRM. After a while, the data in the tables began to move up more slowly. Since datables does unnecessary steps to get data. And the more of this data, the slower the page loads.

In general, this is all convenient, but not for us. Smile So I decided to use something lighter or even my own.


RE: Bookkeeping CRUD app - abatrans - 09-25-2020

@Natanchikk - If you use datatables to display your data and you have large volumes of data, I suggest you look into using datatables' server-sided processing https://datatables.net/manual/server-side. This method only fetches the number of rows that is needed for the current page. I found that once you have 1000 or more records in a table, page loads does become very slow.


RE: Bookkeeping CRUD app - InsiteFX - 10-05-2020

This should give you an idea of what's involved.

Database for Financial Accounting Application II: Infrastructure