Hi....
I've been playing with Cook for about a day and impressed by it. However I stumbled upon a few problems in trying to build my applications. I appreciate helps and guidance....
The app is to help manage and track debt payment by third party companies that they owe to a hardware & building materials supply shop.
Those companies can report to us if they have made payment, thru which channel (cheque, internet banking, deposit machine, counter payment, etc.)
Each USER in my application represent their COMPANY, only one company each user. It's a one to one relationship.
Each COMPANY can have multiple PROJECT ACCOUNT
Each COMPANY can also have multipe BANK ACCOUNT.
USER : Joomla User Account on my website.
COMPANY : A table that store profiles of the company that the particular user represent. Table columns contains address and contact number, etc.
PROJECT ACCOUNT : Debts are splitted into multple accounts, on project basis as they are normally paid after they get payment for each projects.
BANK ACCOUNT : Table that store each company's banking details (Bank name, bank account number, branch address, etc.).
COMPANY is linked to USER via the "Author Wizard".
PROJECT ACCOUNT is linked to COMPANY via Foreign Key.
BANK ACCOUNT is linked to COMPANY via Foreign Key.
I think I've got the Table part figured out.
I'm having problem with the Pages part... Not sure how to approach this.
I want to create a default landing page, where it would show :
1. The Company Details (1-to-1)
2. It's Bank Accounts (1 to many)
Both above in one page.
I tried but i guess the way Cook works, you have to either choose to display grid or fly (collection or item).
So I think I have to make do by splitting those two into separate pages.
No problem with Bank Accounts... (one to many)
But what about one-to-one?
I made an item page using FLY, I name it Company Profile.
However the toolbar only have DELETE/SAVE/APPLY/CANCEL.
When newly registered user get to the default page of my app, they see only labels, no data... which is expected.
However there's only "Cancel" in the toolbox.
I wish there could be an edit button for an item page..
So I created an item page with form... I name it Edit Company Profile.
I gave it "Save" and "Cancel" in the toolbar...
However upon saving I can't see the saved data in "Company Profile"...
I appreciate if someone could tell me how to :
1. combine grid and fly view
2. solve the one-to-one page above.
I don't want to hack... I know PHP (but not much on design pattern) and little MySQL (just enough to survive).
I could solve this by hacking or doing it manually (but that defeats the purpose because i want to do this quick without having to read Joomla API Documentation ).
Thanks...
