From what I have read so far I would just need to do this to get my listing in the admin. Great so far It works I can add new items all is peachy. Until I go to edit. It gives me a SQL error and notifies me that it can't find the parentID field. What am I missing here?
SQL ERROR
[User Error] Couldn't run query: SELECT `RotatorImg`.*, `RotatorImg`.ID, if(`RotatorImg`.ClassName,`RotatorImg`.ClassName,'RotatorImg') AS RecordClassName FROM `RotatorImg` WHERE (ParentID = '1') ORDER BY SortOrder ASC Unknown column 'ParentID' in 'where clause'
Here's what I have
RotatorImg.php
class RotatorImg extends DataObject
{
static $db = array(
'RotLink' => 'Text',
'RotImage' => 'Text'
);
function getCMSFields_forPopup()
{
return new FieldSet(
new TextField('RotLink', "Rotator Link"),
new TextField('RotImage', "Rotator Image")
);
}
}
HomePage.php
class HomePage extends Page
{
public static $db = array();
public static $has_one = array();
public static $has_many = array(
'Rotator' => 'RotatorImg'
);
function getCMSFields()
{
$fields = parent::getCMSFields();
$fields->addFieldToTab("Root.Content.Rotator", new DataObjectManager(
$this,
'Rotator',
'RotatorImg',
array('RotLink' => 'Rotator Link','RotImage' => 'Rotator Image'),
'getCMSFields_forPopup'
));
return $fields;
}
}
class HomePage_Controller extends ContentController
{
...
function GetRotator()
{
return DataObject::get('RotatorImg', "RotImage IS NOT NULL", "SortOrder", "", "", "DataObjectSet");
}
...
}