Full Blown Accounting System - D4PHP !

[AzureCrystal]

Yes, it can be done, I just finished all major coding for a commercial, full blown realty office accounting application on D4PHP, everything works, including a full text search across all columns of a grid, printing, saving and deleting with confirm dialogs, full DB maintenance and client side dbgrid selection which populates edit fields and tabbing works(thanks to great info found here), I don't want to post all the code until I can make a generic app, but if you are interested in code for a particular screen, just let pm me and I will be happy to share ....

The application is sort of a "Realty Quickbooks" customized for a client of mine, it adds accounts, verifies correct numeric entries, ties bank transactions to the accounts, and balances and reconciles the balance against the bank statement, all working nicely in D4PHP, I am proud of this oddball product !!

[AzureCrystal]

[AzureCrystal]

Yes, it can be done folks !!

[AzureCrystal]

I wanted to gratefully thank 405hp for all the gracious and excellent help, without his super tips and code examples on this board, I would have ended porting this into ASP.NET, THANKS 405hp !!!

[mk_common]

how i can create a menu

i have 2 php files

customer.php
product.php

i have created a menu name "Data Entry"

under Data Entry 2 sub items

// what should i write to execute the customer.php
1. Customer Master
// what should i write to execute the product.php
2. Product Master

if possible please send me your menu form at mk_common@yahoo.com


warm regards,
mk.

[delphi-php]

That's fantastic stuff AzureCrystal!! Thanks for sharing your success story, your application is an inspiration to us all and renews all our hopes for Delphi for PHP

Obviously you do not want to release your commerical code, but it would be great in the future if you could release a watered down version so other users can see how you did it.

Thanks for sharing and well done!!

[AzureCrystal]

Will email you the code, hope this helps !

Originally Posted by mk_common

how i can create a menu

i have 2 php files

customer.php
product.php

i have created a menu name "Data Entry"

under Data Entry 2 sub items

// what should i write to execute the customer.php
1. Customer Master
// what should i write to execute the product.php
2. Product Master

if possible please send me your menu form at mk_common@yahoo.com


warm regards,
mk.

[AzureCrystal]

Thanks for the thumbs up, I would love to generalize(white label) this, that was always the plan, of course, if I ever get enough time to pop my head out my rabbit hole... This would be a nice D4PHP tutorial project !!! Maybe I just haven't thought of an easy way to make it generic, but time is my enemy...

BTW, I got the green light to write the companion application, which is a complete property management application that interfaces with this one(when people pay their deposits, rents, etc...), and I should have that one up here in about 3 weeks as well....

Originally Posted by delphi-php

That's fantastic stuff AzureCrystal!! Thanks for sharing your success story, your application is an inspiration to us all and renews all our hopes for Delphi for PHP

Obviously you do not want to release your commerical code, but it would be great in the future if you could release a watered down version so other users can see how you did it.

Thanks for sharing and well done!!

[AzureCrystal]

Firs thing to do is when you add the menu items in the property inspector, you have to assign each menu item a TAG number, then just add this code to the menu's click event, to redirect to the different forms. In my case I have 13 forms, so for each form you would have a case statement which redirects to the appropriate form. NOTE: you could also use the redirect() call, I'm not sure what the difference is, but that would seem more D4PHP centric to use...

PHP Code:

       function MainMenu1Click($sender, $params)
       {
            switch ($params['tag']) {
            case 1:
                Header("Location: addAccount.php");
                break;
            case 2:
                Header("Location: modifyAccount.php");
                break;
            case 3:
                Header("Location: viewAccount.php");
                break;
            case 4:
                Header("Location: viewOpenAccounts.php");
                break;
            case 5:
                Header("Location: selectAccount.php?caller=Deposit");
                break;
            case 6:
                Header("Location: selectAccount.php?caller=Payment");
                break;
            case 7:
                Header("Location: selectTransaction.php?caller=NSF");
                break;
            case 8:
                Header("Location: selectTransaction.php?caller=Void");
                break;
            case 9:
                Header("Location: clearChecks.php");
                break;
            case 10:
                Header("Location: clearDeposits.php");
                break;
            case 11:
                Header("Location: balanceAccount.php");
                break;
            case 12:
                Header("Location: selectAccount.php?caller=recordFee");
                break;
            case 13:
                Header("Location: selectAccount.php?caller=recordInterest");
                break;
            case 99:
                Header("Location: HomePage.php");
                break;
            }
       } 


Originally Posted by mk_common

how i can create a menu

i have 2 php files

customer.php
product.php

i have created a menu name "Data Entry"

under Data Entry 2 sub items

// what should i write to execute the customer.php
1. Customer Master
// what should i write to execute the product.php
2. Product Master

if possible please send me your menu form at mk_common@yahoo.com


warm regards,
mk.

[AzureCrystal]

Also attached is an actual form with the menu component and the calls...