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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Customising the CMS /

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Multiple ComplexTableFields in CMS


Go to End


3 Posts   2424 Views

Avatar
JGC

Community Member, 25 Posts

12 January 2009 at 10:19pm

http://doc.silverstripe.com/doku.php?id=complextablefield

In the documentation for CTFs, they're all shown as using a parameter "MyName" (which goes where the relation name would go).

I'm modifying the CMS and trying to get different Page Types to show different CTFs. Each Page Type has its own class which extends Page, and it's pulling in only one table with no relations, which has its own class which extends DataObject.

Example:
BandMembers.php - table

<?php

class BandMembers extends DataObject
   {
   public static $db = array
      (
      'BandFirstName'         =>   'Text',
      'BandFamilyName'      =>   'Text',
      'BandInstruments'      =>   'Text',
      'BandMemberBlurb'      =>   'Text'
      );

   public static $has_one = array();
   }

class BandMembers_Controller extends ContentController
   {
   }

AboutPage.php - About Page page type

class AboutPage extends Page
   {

   ##
   ##   Set up the database
   ##

   static $db = array
   (
      'BackgroundTitle'         =>   'Text',
      'BackgroundContent'         =>   'HTMLText',
# Some more DB fields here, no name clashes or anything
   );

   function getCMSFields()
      {
      $fields = parent::getCMSFields();

      # Create Band Member management tab
      $showMembers = new ComplexTableField(
         $this,
         'MyName',
         'BandMembers',
         array(
            'BandFirstName' => 'Forename',
            'BandFamilyName' => 'Surname',
            'BandInstruments' => 'Instrument(s)'
         ),
         new FieldSet(
            new TextField('BandFirstName', 'Forename'),
            new TextField('BandFamilyName', 'Surname'),
            new TextField('BandInstruments', 'Instrument(s)'),
            new HTMLEditorField('BandMemberBlurb', 'Band Member Blurb')
         )
      );

      $showMembers->setPermissions(array(
         'add',
         'delete',
         'edit'
      ));

      $fields->addFieldToTab('Root.Content.BandMembers', $showMembers);
      return $fields;
      }

The problem is I can only use "MyName" as a parameter for one Page Type like this - other Page Types using MyName will pull in this form. Using anything else gives a error of "I can't handle sub-URLs of a ... object" (Form, in this case).

The member Dig here says he fixed it here:
http://www.silverstripe.com/extending-hacking-silverstripe-forum/flat/245239
"EDIT: I fixed it, I was being too clever and not constructing the full form if it wasn't being requested for displaying. Basically any path the exits early before creating the full form with the ComplexTableField in it will break it. Makes sense when you think about it!"

I'd try to return a form, except I have to return a FieldSet for getCMSMethods.

Any suggestions on how I can fix it to allow multiple CTFs with different tables?

Each CTF only needs to show data from one table.

Thanks in advance :)

Avatar
JGC

Community Member, 25 Posts

19 January 2009 at 10:02pm

Been trying to solve this for a while now, any ideas would be very much appreciated.

Avatar
dio5

Community Member, 501 Posts

20 January 2009 at 8:55am

Edited: 20/01/2009 8:55am

Hmm, not sure I'm really understanding you but in most of my cases I'd have a 'singular' named DataObject subclass (BandMember), which would lead to

- where you have 'MyName' I'd have 'BandMembers' (the 'Name' of the table)
- where you have 'BandMembers' I'd have 'BandMember' (the SourceClass).

The BandMember class is dataobject and is 'one' item in the BandMembers ctf.

Also, is there a specific reason why you're making a controller for the dataobject? (In most normal cases, dataobjects don't have a controller).