3069 Posts in 868 Topics by 650 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 1356 Views |
-
Linking list of Teasers (TreeMultiselectField)
10 May 2010 at 11:42pm
Hello!
On my Homepage (PageType: HomePage) I would like to have a list of Teasers to use. Each Teaser is defined in a separate entry (PageType: HPTeaser) in the Content-Tree. The idea is to use a teaser on several pages, being able to change the content of the teaser in a single place.
I used the following code in my HomePage.php file:
class HomePage extends Page {
public static $db = array(
);public static $has_many = array(
"HPTeasers" => "HPTeaser"
);function getCMSFields() {
$fields = parent::getCMSFields();$hpteaserfield = new TreeMultiselectField(
"HPTeasers",
"Homepage Teasers",
"HPTeaser"
);$fields->addFieldToTab("Root.Content.Main", $hpteaserfield);
return $fields;
}}
The DropDown is correctly displayed while editing a page of type HomePage, but I have the following problems:
- The selection is not limited to entries of type HPTeaser
- When I select one ore more entries they are listed correctly, but nothing seems to be saved to the database (when I reload the editor the field HPTeasers is always emptySo what could I do to fix these problems? And is there a better FieldType to use (eg. allowing Drag&Drop reordering of the selected Teasers)?
Many Thanks for your help
Maxx
-
Re: Linking list of Teasers (TreeMultiselectField)
20 May 2010 at 5:57am Last edited: 20 May 2010 5:58am
Hi Maxx,
i think you need different relations. Because ONE Teaser can be related on many Pages.
And many Pages can have many Teasers - is that right ?class HomePage extends Page {
static $many_many = array(
"Teasers" => "HPTeaser",
);
}
class HPTeaser extends Page {
static $belongs_many_many = array(
"HomePages" => "HomePage",
);
}If you want a orderrable n:m relation, take a look at the outstanding DataObjectManger
In your case especially the ManyManyDataObjectManager while using:
/mysite/_config.php// -> mysite/_config.php
SortableDataObject::add_sortable_many_many_relation('Teasers', 'HPTeaser'); -
Re: Linking list of Teasers (TreeMultiselectField)
21 July 2010 at 11:45pm
Hello, I have a problem with many_many sortable.
SortableDataObject::add_sortable_many_many_relation('WarePage','WareItems');
WarePage get items function:
$doSet = $this->getManyManyComponents('WareItems', '','', '', "{$SQL_start},10");Returns error:
[User Error] Couldn't run query: SELECT count(*) FROM SELECT "WareItem"."ClassName", "WareItem"."Created", "WareItem"."LastEdited", "WareItem"."Article", "WareItem"."Name", "WareItem"."Description", "WareItem"."Colour", "WareItem"."Size", "WareItem"."DateIn", "WareItem"."BrandNew", "WareItem"."Sale", "WareItem"."SortOrder", "WareItem"."WareBrandID", "WareItem"."PhotoID", "WareItem"."ID", CASE WHEN "WareItem"."ClassName" IS NOT NULL THEN "WareItem"."ClassName" ELSE 'WareItem' END AS "RecordClassName", "WarePage_WareItems"."SortOrder" FROM "WareItem" INNER JOIN "WarePage_WareItems" ON "WarePage_WareItems"."WareItemID" = "WareItem"."ID" WHERE ("WarePage_WareItems"."WarePageID" = 5) GROUP BY "WareItem"."ClassName", "WareItem"."Created", "WareItem"."LastEdited", "WareItem"."Article", "WareItem"."Name", "WareItem"."Description", "WareItem"."Colour", "WareItem"."Size", "WareItem"."DateIn", "WareItem"."BrandNew", "WareItem"."Sale", "WareItem"."SortOrder", "WareItem"."WareBrandID", "WareItem"."PhotoID", "WareItem"."ID", CASE WHEN "WareItem"."ClassName" IS NOT NULL THEN "WareItem"."ClassName" ELSE 'WareItem' END, "WarePage_WareItems"."SortOrder") as all_distinct Duplicate column name 'SortOrder'
And $doSet = $this->getManyManyComponents('WareItems', '',''); works fine.
Actually I don't know why WareItem.SortOrder created by dev/?flush=1
| 1356 Views | ||
|
Page:
1
|
Go to Top |
