Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Need fast help: cms->database->ss


Reply

937 Views

Avatar
ion

31 January 2008 at 1:12pm Community Member, 1 Post

Hello,

i'm new here. Trying to make first steps on moving old site from mambo to silverstripe, but have no time at the moment going deep into analysing code, class structure, reading api.silverstripe.com (successfuly done tutorial), experimenting, since i need basic result in 3 days and do not want to make it wrong from the beginning.
I have managed to make simple data editing, but stuck with templates and data->ss. Any help would be appreciated.

situation:

People:
firstName, lastName, peopleGroupID, peopleProfessionID, biographyID...etc

PeopleGroup:
groupName

peopleProfession:
proffesion, description

etc...

I have successfuly managed to make editing of groups, proffesions, people tables in CMS. Added new tab with grid view, popup editing , selecting of groups, professions and bio in combos etc.

Problems:
1. CMS
a) in grid view i can see now People table with
firstName, lastName, peopleGroupID, peopleProfessionID, biographyID
but i need to see:
firstName, lastName, groupName, profession
b) in other page (peopleOfSomeProfession extends PeoplePage) grid view i need to see only people with required profession:
firstName, lastName, groupName
2. Content
menu structure works, but...:
in menu i see:
People
profession1
profession2
etc..., but clicking on professionX i need to see:
-------
Pages
1 2 3 4 5 >

Name
group
profession
link to biography
link to biography pdf download (link is in biography table)
--------------

Please help me and i will write advanced tutorial/how-to on this topic, since i cannot find one that explains inner/outer joins, advanced multiple table data editing, multiple table output to ss.

I am experienced devloper in java, c++, c#, delphi, databases/sql, but i have only basic skills with php.

Do not need full code :)
Directions where to look and simple how-to tips would be very good.

ion