Re: Upcoming Function ?

benni91 — Mon, 13 Feb 2012 00:47:55 +1300

Hi simon_w,

EDIT: I found the problem which brought me to another one. See the Edit at the End

thx for your help. I used your code like this in my EventPage.php

<?php
class EventPage extends Page {

   static $default_child = 'none';
   static $allowed_children = 'none';
   static $can_be_root = true;

   public static $db = array(
   );

public static $has_one = array(
);

   public static $has_many = array(
      'Events' => 'EventObject',
   );

   function getCMSFields() {
      $fields = parent::getCMSFields();
      $fields->removeFieldFromTab('Root.Content.Main', 'Content');
      // Events
      $fields->addFieldToTab('Root.Content.Main', $Event = new DataObjectManager($this, 'Events', 'EventObject', array('NextEvent' => 'Nächstes Event? (1=ja)', 'EventName' => 'Name des Events', 'EventDate' => 'Datum des Events (Jahr/Monat/Tag)', 'EventTime' => 'Uhrzeit des Events'), 'getCMSFields_forPopup'));
      $Event->copyOnImport = false;
      $Event->setAddTitle('ein Event');
      return $fields;
   }
}
class EventPage_Controller extends Page_Controller {
   public function UpcomingEvent() {
      return $this->Events('"EventDate" >= CURDATE()', '"EventDate" ASC', '', 1)->First();
   }
}

and that's my Upcoming.ss Include

<% control getPageByClass(EventPage) %>
         <% control UpcomingEvent %>
            <div id="latest_flyer">
               <div class="event_flyer_hover"><a href="termine#$EventName $EventDate"><img src="{$BaseHref}$ThemeDir/images/blank.gif" alt="$EventName" /></a></div>
               $EventFlyer.setWidth(155)
            </div>
            <div id="latest_event_details">
               <ul>
                  <li><h2>$EventName</h2></li>
                  <li></li>
                  <li>$EventDate.NiceGER</li>
                  <li></li>
                  <li>$EventTime</li> 
                  <li></li>
                  <li></li>
               </ul>
               <div id="latest_event_more">
                  <div class="button"><a href="termine#$EventName $EventDate">Mehr Infos</a></div>
                  <div class="button_arrow"></div>
               </div>
            </div>
            <div class="clear"></div>
         <% end_control %>
      <% end_control %>

The Problem is it shows nothing Just a blank area where the content should be. Do you know where's the mistake?

Regards Benni

Edit:
Ok the Problem is the <% control getPageByClass(EventPage) %>
If i remove this, the upcoming function works at the EventPage but not on the other Pages.
Why? <% control getPageByClass(EventPage) %> should make the EventPage accessible from all the other Pages.

Adding the Function to Page.php results an ServerError ;/

Posted to: Upcoming Function ? Show Thread | Post Reply

Re: Upcoming Function ?

simon_w — Sun, 12 Feb 2012 13:04:43 +1300

I'm assuming that your EventPage class has a has_many relation to EventObject called EventObjects.

The has_many relation function takes the same arguments as a DataObject::get(), so you can filter and sort the resultant set. Something like

public function UpcomingEvent() {
return $this->EventObjects('"EventDate" >= CURDATE()', '"EventDate" ASC', '', 1)->First();
}

What this does is only returns EventObjects with an EventDate that's either today or in the future, sorts the results by ascending EventDate and then only returns the first one. As the EventObjects() method always returns a ComponentSet, it then goes and specifically gets the first object in the set, which will either be the next event or null.

Posted to: Upcoming Function ? Show Thread | Post Reply

Upcoming Function ?

benni91 — Sun, 12 Feb 2012 12:25:44 +1300

Hi,

can someone tell me how to make an upcoming function?
i created a data object with event entries. i want that only the event which is the next is displayed.

that's my eventobject.php

<?php
class EventObject extends DataObject {

   public static $db = array(
      'NextEvent' => 'Boolean',
      'EventName' => 'Text',
      'EventDate' => 'Date',
      'EventTime' => 'Text',
      'EventDescription' => 'HTMLText',
   );

   public static $has_one = array(
      'EventFlyer' => 'Image',
      'EventPage' => 'EventPage'
   );

   static $default_sort = "Created DESC";

function getCMSFields_forPopup() {
      $fields = new FieldSet();
         $fields->push(new CheckBoxField('NextEvent', 'findet das Event als nächstes Statt?(IMMER NUR BEI EINEM EVENT AUSWÄHLEN!!!)'));
         $fields->push(new TextField('EventName', 'Was findet statt?'));
         $fields->push($Date = new DateField('EventDate', 'An welchem Datum findet es statt?'));
         $Date->setConfig('showcalendar', true);
         $fields->push(new TextField('EventTime', 'Zu welcher Uhrzeit findet es statt?'));
         $fields->push(new SimpleTINYMCEField('EventDescription', 'Genauere Infos, Auftritte, Preise, etc. zum Event'));
         $fields->push($EventFlyer = new ImageUploadField('EventFlyer', 'Der Flyer des Events'));
         $EventFlyer->setUploadFolder('event');
return $fields;
}
}
?>

i really hope someone could help me.
Regards
Benni

Posted to: Upcoming Function ? Show Thread | Post Reply

Re: Page to DataObject Relation to DataObject using HasOneDOM and HasManyDOM

Muaddib — Sat, 11 Feb 2012 09:04:03 +1300

Any pointers on this still appreciated. ....

Posted to: Page to DataObject Relation to DataObject using HasOneDOM and HasManyDOM Show Thread | Post Reply

Re: Redirect and Description on FileIFrameField

Pipifix — Sat, 11 Feb 2012 02:51:20 +1300

Sorry for the crosspost. I moved this issue to this thread: http://www.silverstripe.org/dataobjectmanager-module-forum/show/8358?start=8#post311609

Thanks, Pipifix

Posted to: Redirect and Description on FileIFrameField Show Thread | Post Reply

Re: SimpleTreeDropdownField makes Problems

Pipifix — Sat, 11 Feb 2012 02:40:30 +1300

Hello.

I'm still searching a solution for that. So i will appreciate your help. If i change the the PageRedirect in PageRedirectID in the ImageDataObjectManager the dropdown is also not shown. Maybe someone can give me a tip or point me to the error?

Thanks Pipifix

Posted to: SimpleTreeDropdownField makes Problems Show Thread | Post Reply

Truncating Text Field In CMS View of DOM

ocean — Sat, 11 Feb 2012 00:10:42 +1300

Hello,

I'd like to reduce the number of characters of a text field as displayed in the CMS view of the DOM, as the rows are getting ridiculously large in proportion to the overall view!

I managed to implement this kind of thing for an image field:

public function getDOMThumbnail()
{
return $this->Image()->CroppedImage(150,150);
}

Where 'DOMThumbnail' is placed in the DOM array. But can find no similar example of how to reduce a text field, in this case its an HTMLtext field, nor have any of my attempts/experiments from reading through the api docs really helped much either in solving the problem. Seems like it should be pretty simple really?!

Thanks
~ Sean

Posted to: Truncating Text Field In CMS View of DOM Show Thread | Post Reply

Multiple files on a dataobjekt (Model Admin)

Pipifix — Thu, 09 Feb 2012 09:21:25 +1300

Hello everybody.

i'm german and i hope i can explain my problem in a understandable way. i've got a bunch of pdfs and docs (organized by kickassets) that i wanna conncect to a dataobject called 'Projekt' . Some of the files are unique to the projects (=Projekt). Some files belong to almost all projects. Examples for the files could be ‘description-project1.pdf‘ or ‘project-application-form.doc‘. I've tried a solution according to this code http://www.silverstripe.org/dataobjectmanager-module-forum/show/15656#post298390

At first i thought i need a description for the file so i set a descritption. But i realized any file got a name. Maybe i can use this name instead the descrition for a better explanation of the downloadable file (user centric view).

Here is my code:
ResourceFile.php

<?php
class ResourceFile extends File {

static $has_one = array (
'Resource' => 'Resource'
);
}

Resource.php:

<?php
class Resource extends DataObject
{
static $db = array (
'Name' => 'Text',
'Description' => 'Text'
);

static $has_many = array (
'Attachments' => 'ResourceFile'
);

static $has_one = array (
'Projekt' => 'Projekt'
);

public function getCMSFields_forPopup()
{
return new FieldSet(
   new TextField('Name'),
   new TextareaField('Description'),
   new MultipleFileUploadField('Attachments')
   );
}
}

Maybe the description is obsolet. Is the has_one relation right? because one file can be attached to many projects so i guess i have to use has_many. but there i a strange error.

At least the Projekt-Dataobject

Projekt.php

<?php

class Projekt extends DataObject
{
   static $db = array(
      'Title' => 'Varchar(255)',
      'Description' => 'HTMLText',
      'Long' => 'Int',
      'Lat' => 'Int',
      'URLSegment' => 'Varchar(255)',
      'ProjectCat' => "Enum('Soziales, Strasse, Wirtschaft')",
      'ProjectStatus' => "Enum('Planung, Durchfuehrung, Abgeschlossen')",
      'StatusText' => 'Varchar(255)',
      'MetaTitle' => 'Varchar(255)'
   );

   //Set our defaults
   static $defaults = array(
      'Title' => 'Neues Projekt',
      'URLSegment' => 'neues-projekt'
   );

   static $has_one = array(
      'Image' => 'Image',
      'LinkedPage' => 'SiteTree'
   );

   static $has_many = array (
   'Resources' => 'Resource'
   );


   //Relate to the category pages
   static $belongs_many_many = array(
      'Categories' => 'CategoryPage'
   );

   //Fields to show in ModelAdmin table
   static $summary_fields = array(
      'Title' => 'Title',
      'URLSegment' => 'URLSegment',
      'ProjectStatus' => 'ProjectStatus',
      'ProjectCat' => 'ProjectCat',
   );

   //Add an SQL index for the URLSegment
   static $indexes = array(
      "URLSegment" => true
   );

   //Fields to search in ModelAdmin
   static $searchable_fields = array (
      'Title',
      'ProjectStatus',
      'ProjectCat',
      'Categories.ID' => array(
         'title' => 'Category'
      )
   );

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

      //Main Tab
      $fields->addFieldToTab("Root.Main", new TextField('Title', 'Titel/Name des Projektes'));
      $fields->addFieldToTab("Root.Main", new TextField('MetaTitle', 'Untertitle zum Projekt'));
      .
      .
      .

      //DownloadResourcen
      $manager = new DataObjectManager(
      $this, // Controller
      'Resources', // Source name
      'Resource', // Source class
      array(
      'Name' => 'Name',
      'Description' => 'Description',
      'Attachment.Name' => 'Attachment',
      ), // Headings
      'getCMSFields_forPopup' // Detail fields (function name or FieldSet object)
      // Filter clause
      // Sort clause
      // Join clause
      );

      // If undefined, all types are allowed. Pass with or without a leading "."
      //$manager->setAllowedFileTypes(array('pdf','doc'));

      // Label for the upload button in the popup
      //$manager->setBrowseButtonText("Upload (PDF or DOC only)");

      // In grid view, what field will appear underneath the icon. If left out, it defaults to the file title.
      //$manager->setGridLabelField('Name');

      // Plural form of the objects being managed. Used on the "Add" button.
      // If left out, this defaults to [MyObjectName]s
      //$manager->setPluralTitle('Resources');

      $fields->addFieldToTab("Root.Dateien", $manager);

      //$fields->addFieldToTab("Root.Dateien", new TextField('DownloadItem', 'Download-Datei'));

      return $fields;
   }

//some functions

}

The resource tab on a project in modelladmin is shown. The popup is working and saving a file works well. But the saved ressource is not shown in the modelladminlisting.

EDIT: In the popup the upload functionality works. i can import an existing file and i see (so far) this file in the attached files block. When I save his popup a green message appears ('Added new Resource successfully') but the file in the attached files block disappears.
EDIT_END:

Plus: If i comment out the setAllowedFileTypes or the setBrowseButtonText there is an error.?
Whats wrong with that code? Is this the wrong way to attach multiple files?

Thanks for your help.
Pipifix

Posted to: Multiple files on a dataobjekt (Model Admin) Show Thread | Post Reply

Re: Comments in DataObject Page

Willr — Wed, 08 Feb 2012 21:34:09 +1300

jmax - try the comments module. Comments has been stripped out for 3.0 and includes the ability to work on DataObject. While it's still a very early stage and designed for 3.0 rather than 2.4, it may provide a good start for you.

https://github.com/silverstripe/silverstripe-comments

Posted to: Comments in DataObject Page Show Thread | Post Reply

Page to DataObject Relation to DataObject using HasOneDOM and HasManyDOM

Muaddib — Wed, 08 Feb 2012 08:41:50 +1300

I have Project Pages, which can have assigned one Mentor, and multpile Participants as DataObjects.
Each Mentor,Participant have multiple images.
Almost similar to posts above, just i'm using HasOneDOM and HasManyDOM

Geting error:

[User Error] Couldn't run query: SELECT "Participant"."ClassName", "Participant"."Created", "Participant"."LastEdited", "Participant"."FullName", "Participant"."PictureID", "Participant"."ID", CASE WHEN "Participant"."ClassName" IS NOT NULL THEN "Participant"."ClassName" ELSE 'Participant' END AS "RecordClassName" FROM "Participant" WHERE ("" = '7') ORDER BY Created DESC Unknown column '' in 'where clause'

It somehow doesn't make relations Participant=>something?

==========Project Page============

class Project extends Page
{
static $has_one = array (
'Mentor' => 'Mentor'
);
static $has_many = array (
'Participants' => 'Participant'
);

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

$participants = new HasManyDataObjectManager(
$this,
'Participants',
'Participant',
array(
'FullName'=>'FullName'
)
);

$mentor = new HasOneDataObjectManager(
$this,
'Mentor',
'Mentor',
array(
'FullName'=>'FullName'
)
);

$fields->addFieldToTab('Root.Content.Mentor', $mentor);
$fields->addFieldToTab('Root.Content.Participants', $participants);
return $fields;
}
}

========== End Project Page============

==========Participant Page============

class Participant extends DataObject
{
static $db = array (
'FullName' => 'Text'
);

static $has_one = array(
'Picture'=>'ImageResource'
);

static $has_many = array (
'Projects' => 'Project',
'Images' => 'ImageResource'
);
public function getCMSFields()
{
return new FieldSet(
new TextField('FullName'),
new SimpleImageField('Picture'),
new FileDataObjectManager(
$this,
'Images',
'ImageResource',
'Attachment',
array(
'Description'=>'Description'
)
)
);
}
}

==========End Participant Page============

==========Mentor Page============
Same as Participant
==========End Mentor Page============

==========ImageResourcePage Page============

class ImageResource extends DataObject {
static $db = array(
'Description'=>'Text'
;
static $has_one = array(
'Attachment'=>'Image',
'Mentor'=>'Mentor',
'Participant'=>'Participant'
);
public function getCMSFields() {
return new FieldSet(
new TextField('Description'),
new FileIFrameField('Attachment')
);
}
}

==========End ImageResourcePage Page============

Totaly lost in space...

Posted to: Page to DataObject Relation to DataObject using HasOneDOM and HasManyDOM Show Thread | Post Reply

Re: DataObjectManager Within DataObjectManager?

Muaddib — Tue, 07 Feb 2012 12:57:51 +1300

Same situation, different problem:

==========Project Page============

class Project extends Page
{
static $has_one = array (
'Mentor' => 'Mentor'
);
static $has_many = array (
'Participants' => 'Participant'
);

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

$participants = new HasManyDataObjectManager(
$this,
'Participants',
'Participant',
array(
'FullName'=>'FullName'
)
);

$mentor = new HasOneDataObjectManager(
$this,
'Mentor',
'Mentor',
array(
'FullName'=>'FullName'
)
);

$fields->addFieldToTab('Root.Content.Mentor', $mentor);
$fields->addFieldToTab('Root.Content.Participants', $participants);
return $fields;
}
}

========== End Project Page============

==========Participant Page============

class Participant extends DataObject
{
static $db = array (
'FullName' => 'Text'
);

static $has_one = array(
'Picture'=>'ImageResource'
);

==========End Participant Page============

==========Mentor Page============
Same as Participant
==========End Mentor Page============

==========ImageResourcePage Page============

==========End ImageResourcePage Page============

Totaly lost in space...

Posted to: DataObjectManager Within DataObjectManager? Show Thread | Post Reply

Re: DOM duplicate images?

benni91 — Mon, 06 Feb 2012 23:38:30 +1300

Ah ok, thx !

Posted to: DOM duplicate images? Show Thread | Post Reply

Re: DOM duplicate images?

mirkosassetti — Mon, 06 Feb 2012 22:56:37 +1300

It is no longer any need to tweak, the function has been implemented.
Just set the parameter copyOnImport to false, like:

$managerImages->copyOnImport = false;

Posted to: DOM duplicate images? Show Thread | Post Reply

Slideshow update slideshows

Xazen — Mon, 06 Feb 2012 08:45:44 +1300

Hi SilverStripe Forum,

I installed the slideshow module: http://www.silverstripe.org/slideshow-module/

Everythings works fine but the "update slideshow" setting. I can choose:
- Apply to this page only
- Apply to all slideshows in this section
- Apply to all slideshows on this site

However.. Apply to this page only is the default option. Whenever I try to change it it stays on "Apply to this page only".

Is there anything I need to take attention to?

I added this line for each PageType to the _config.php.

DataObject::add_extension('PageType', 'Slideshow');

Posted to: Slideshow update slideshows Show Thread | Post Reply

Re: trying to get the latest images out of an ImageObject

benni91 — Mon, 06 Feb 2012 02:44:00 +1300

Hmm is it possible to get the latest Entry out of an DataObject with the Mysql Field "Created" ? If got absolutly no knowlege about sql but i think it should be possible?!

Perhapse this is one way?

Posted to: trying to get the latest images out of an ImageObject Show Thread | Post Reply

Re: DOM duplicate images?

benni91 — Mon, 06 Feb 2012 02:07:19 +1300

In wich file is this code? i can't find it :/

public function saveUploadifyForm($data, $form)
{
if(!isset($data['UploadedFiles']) || !is_array($data['UploadedFiles'])) {
return Director::redirectBack();
}

$file_class = $this->fileClassName;
$do_class = $this->sourceClass();
$idxfield = $this->fileFieldName."ID";
$fff = $this->fileFieldName;
$dataobject_ids = array();
if($this->hasDataObject) {
foreach($data['UploadedFiles'] as $id) {
if($file = DataObject::get_by_id("File", (int) $id)) {
// $upload_folder = $form->Fields()->fieldByName('UploadedFiles')->uploadFolder;
// $folder_id = Folder::findOrMake($upload_folder)->ID;
// if($file->ParentID != $folder_id) {
// $new_file_path = $this->uploadFolder.'/'.$file->Name;
// copy($file->getFullPath(), BASE_PATH.'/'.ASSETS_DIR.'/'.$new_file_path);
// $clone = new $file_class();
// $clone->Filename = $new_file_path;
// $clone->ParentID = $folder_id;
// $clone->write();
// $id = $clone->ID;
// }

$obj = new $do_class();
$obj->$idxfield = $id;
$ownerID = $this->getParentIdName($this->getParentClass(), $this->sourceClass());
$obj->$ownerID = $this->controllerID;
$this->updateDataObject($obj);
$obj->write();
$obj->$fff()->write();
$dataobject_ids[] = $obj->ID;
}
}
$_POST['uploaded_files'] = $dataobject_ids;
foreach($_POST['uploaded_files'] as $id) {
}
}
else {
foreach($data['UploadedFiles'] as $id) {
if($file = DataObject::get_by_id("File", (int) $id)) {
$ownerID = $this->getParentIdName($this->getParentClass(), $this->sourceClass());
$file->$ownerID = $this->controllerID;
$file->write();
}
}
}

$form = $this->EditUploadedForm();
return $this->customise(array(
'String' => is_string($form),
'DetailForm' => $form
))->renderWith($this->templatePopup);
}

Posted to: DOM duplicate images? Show Thread | Post Reply

Nested DataObjects and summary fields

VRoxane — Sun, 05 Feb 2012 10:07:51 +1300

Hello everyone !

I have a class Commande extending ModelAdmin.
In Commande exists a nested DataObject called NumeroColis (1 field : 'Numero'). I'm using the wonderful DOManager to handle it and it's perfect.

BUT :

When clicking the "Search" button, to show all the existing Commandes, I'd like to add a column called Numeros and for each Commande, show a list of the recorded NumeroColis.

This is what I did in Commande.php :

public function getListeNumeros() {
      $rawlist = DataObject::get('NumeroColis','CommandeID = '.$this->ID);
      $nums = $rawlist->column('Numero');
      $liste = implode(', ', $nums);
      if (isset($liste)) {
         return $liste;
      } else {
         return "Pas de colis";
      }
}

static $summary_fields = array(
...
'ListeNumeros' => 'Numéros',
...
);

I get a Internal Server Error when clicking the Search button... and I spent a lot of time on this, so I decided to ask the great SStripe international community ! Anyone ?

Posted to: Nested DataObjects and summary fields Show Thread | Post Reply

Re: SimpleTreeDropdownField makes Problems

Pipifix — Sat, 04 Feb 2012 05:10:26 +1300

Hi, i've run in the same problem. my goal is to show some images with a redirect link on homepage.

my class:

<?php
class CustomImage extends DataObject
{
//db fields
static $db = array (
'Description' => 'Varchar(100)',
);

   /**
    * Our custom image class contains one image that is used on one page.
    */
   public static $has_one = array (
      'SliderImage' => 'Image',
      'PageRedirect' => 'SiteTree'
   );

   /**
    * Popup for editing a single image.
    *
    * @return FieldSet The iframe for editing the image.
    */
   public function getCMSFields_forPopup(){
      $fields = new FieldSet(
         new TextField('Description'),
         new SimpleTreeDropDownField('PageRedirectID','Bild verlinkt zu','SiteTree'),
         new FileIFrameField('SliderImage','Bild für den Slider', Null, Null, Null, 'Uploads/homepage-sliderbilder/')
      );
      return $fields;
   }
}

and my model:

class HomePage extends Page {
static $db = array(
      'HomeMainHeading' => 'Text',
      'HomeSubHeading' => 'Text',
      'HomeCol1' => 'HTMLText',
      'HomeCol2' => 'HTMLText'
);

   public static $has_many = array(
   'CustomImages' => 'CustomImage',
   );

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

      //SliderImages
      $images = new ImageDataObjectManager(
   $this, // Controller
   'CustomImages', // Source name
   'CustomImage', // Source class
   'SliderImage', // File name on DataObject
   array(
'Description' => 'Description' //,
// 'PageRedirect' => 'PageRedirect'
   ), // Headings
'getCMSFields_forPopup' // Detail fields
// Filter clause
// Sort clause
// Join clause
    );
      ...
      $fields->addFieldToTab('Root.Content.SliderBilder', $images);
      return $fields;
   }
}

if i comment out the PageRedirect in the array there is an error (…the method 'fortemplate' does not exist on…). otherwise the SimpleTreeDropDownField is not shown in the popup. Whats wrong with this code?

Thanks for your help. Pipifix

Posted to: SimpleTreeDropdownField makes Problems Show Thread | Post Reply

Re: [solved] cannot browse to file location using uploadify browse

bants — Fri, 03 Feb 2012 15:55:31 +1300

i didn't have flash installed... doh!

Posted to: [solved] cannot browse to file location using uploadify browse Show Thread | Post Reply

Re: trying to get the latest images out of an ImageObject

benni91 — Fri, 03 Feb 2012 06:21:27 +1300

BUMB ;)

Posted to: trying to get the latest images out of an ImageObject Show Thread | Post Reply

Re: Redirect and Description on FileIFrameField

Pipifix — Fri, 03 Feb 2012 05:28:10 +1300

The Desription is working. But the sitetree dropdown does'nt work.
My code for the function getCMSFields in CustomImage.php

public function getCMSFields(){
      return new FieldSet(
         new TextField('Description'),
         new TreeDropdownField('PageRedirectID','Bild verlinkt zu','SiteTree'),
         new FileIFrameField('SliderImage','Bild für den Slider', Null, Null, Null, 'Uploads/homepage-sliderimages/')
      );
   }

why is the dropdown not visible? is this a fact of the popup?

Pipifix

Posted to: Redirect and Description on FileIFrameField Show Thread | Post Reply

Redirect and Description on FileIFrameField

Pipifix — Fri, 03 Feb 2012 03:58:58 +1300

Hello

at the moment i try to understand the whole dataobject-thing. my goal is to set some images with a caption and a redirect to different pages. the templaterendering should used on the homepage by a jqery-imageslider (orbit). do i have to use FileIFrameField on a getCMSFields function? or getCMSFields_forPopup. I need to bind the description and the redirect to the CostumImage.

My code for the dataobject so far.

<?php
class CustomImage extends DataObject {
//db fields
static $db = array (
'Description' => 'Varchar(100)'
);

   /**
    * Our custom image class contains one image that is used on one page.
    */
   public static $has_one = array (
      'SliderImage' => 'Image',
      'PageRedirect' => 'SiteTree'
   );

   /**
    * Popup for editing a single image.
    *
    * @return FieldSet The iframe for editing the image.
    */
   public function getCMSFields(){
      return new FieldSet(
         new FileIFrameField('SliderImage')
      );
   }
}

in HomePage i've got

   public static $has_many = array(
   'CustomImages' => 'CustomImage',
   );

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

      //SliderImages
      $images = new ImageDataObjectManager(
   $this,
   'CustomImages',
   'CustomImage',
   'SliderImage'
      );


      return $fields;
   }
}

Is there a good tutorial about the FileIFrameField or HasManyComplexTableField. Thanks for your help.
Pipifix

Posted to: Redirect and Description on FileIFrameField Show Thread | Post Reply

Re: setTreeBaseID for SimpleTreeDropdownField

schellmax — Thu, 02 Feb 2012 05:46:47 +1300

back again: it's in now
don't know as of which revision, but thanks anyway!

Posted to: setTreeBaseID for SimpleTreeDropdownField Show Thread | Post Reply

Re: trying to get the latest images out of an ImageObject

benni91 — Thu, 02 Feb 2012 05:08:27 +1300

Sry, i think that was wrong in my first post. I'm not able to describe the relations good in english.

Thats the GalleryPage.php I hope it will help

<?php
class GalleryPage extends Page {

   static $allowed_children = 'none';
   static $default_parrent = 'GalleryHolder';
   static $can_be_root = false;

   public static $db = array(
      'Date' => 'Date',
      'Description' => 'HTMLText',
      //'ThumbnailSize' => 'Text',
   );

   public static $has_many = array(
      'GalleryImages' => 'GalleryImagesObject'
   );

   function getCMSFields() {
      $fields = parent::getCMSFields();
      $fields->removeFieldFromTab('Root.Content.Main', 'Content');
      $fields->addFieldToTab('Root.Content.Main', $date = new DateField('Date', 'Datum der Aufnahmen'));
      $date->setConfig('showcalendar', true);
      $fields->addFieldToTab('Root.Content.Main', new SimpleTinyMCEField('Description','Beschreibung der Gallerie'));
      //$fields->addFieldToTab('Root.Content.Main', new TextField('ThumbnailSize','Größe der Thumbnails (in px / muss ausgefüllt sein)'));
      $fields->addFieldToTab('Root.Content.Main', $GalleryImages = new ImageDataObjectManager($this, 'GalleryImages', 'GalleryImagesObject', 'GalleryImage', array('Title' => 'Titel des Bildes', 'Description' => 'Beschreibung des Bildes'), 'getCMSFields_forPopup'));
      $GalleryImages->copyOnImport = false;
      //$GalleryImages->setPageSize( '999' );
      $GalleryImages->setPerPageMap('50');
      $GalleryImages->setPageSize('50');
      return $fields;
   }
}

class GalleryPage_Controller extends Page_Controller {

   public function PrevNextPage($Mode = 'next') {
      if($Mode == 'next'){
         $Where = "ParentID = ($this->ParentID) AND Sort > ($this->Sort)";
         $Sort = "Sort ASC";
      }
      elseif($Mode == 'prev'){
         $Where = "ParentID = ($this->ParentID) AND Sort < ($this->Sort)";
      $Sort = "Sort DESC";
      }
      else{
      return false;
      }
      return DataObject::get("SiteTree", $Where, $Sort, null, 1);
   }
}
?>

Posted to: trying to get the latest images out of an ImageObject Show Thread | Post Reply

Re: trying to get the latest images out of an ImageObject

UncleCheese — Thu, 02 Feb 2012 04:44:11 +1300

How does GalleryPage relate to GalleryImageObject?

--------------------
SilverStripe tips, tutorials, screencasts and more: http://www.leftandmain.com

Posted to: trying to get the latest images out of an ImageObject Show Thread | Post Reply

Re: [solved] cannot browse to file location using uploadify browse

bants — Thu, 02 Feb 2012 03:16:44 +1300

stupid me forgot to turn on dev mode and when i did i get this error:

I've also tried changing mod_security in .htaccess to no avail.

[Warning] pg_query(): Query failed: ERROR: column "parentid" does not exist LINE 1: ...File' END AS "RecordClassName" FROM "File" WHERE (ParentID =... ^
GET /deltageo/index.php/admin/RootForm/field/Logo/importlist?FolderID=2

Line 230 in C:\Program Files\BitNami WAPPStack\apache2\htdocs\deltageo\postgresql\code\PostgreSQLDatabase.php
Source

221       if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
222          Debug::message("Will execute: $sql");
223          return;
224       }
225
226       if(isset($_REQUEST['showqueries'])) {
227          $starttime = microtime(true);
228       }
229
230       $handle = pg_query($this->dbConn, $sql);
231
232       if(isset($_REQUEST['showqueries'])) {
233          $endtime = round(microtime(true) - $starttime * 1000, 1);
234          Debug::message("\n$sql\n{$endtime}ms\n", false);
235       }
236

Trace

pg_query(Resource id #79,SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE (ParentID = 2 AND ClassName != 'Folder') ORDER BY "SortOrder" ASC)
Line 230 of PostgreSQLDatabase.php
PostgreSQLDatabase->query(SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE (ParentID = 2 AND ClassName != 'Folder') ORDER BY "SortOrder" ASC,256)
Line 129 of DB.php
DB::query(SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE (ParentID = 2 AND ClassName != 'Folder') ORDER BY "SortOrder" ASC,256)
Line 400 of SQLQuery.php
SQLQuery->execute()
Line 757 of File.php
File->instance_get(ParentID = 2 AND ClassName != 'Folder',,,,DataObjectSet)
Line 2714 of DataObject.php
DataObject::get(File,ParentID = 2 AND ClassName != 'Folder')
Line 353 of UploadifyField.php
UploadifyField->importlist(SS_HTTPRequest)
Line 143 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
Line 161 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
Line 161 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
Line 147 of Controller.php
Controller->handleRequest(SS_HTTPRequest)
Line 282 of Director.php
Director::handleRequest(SS_HTTPRequest,Session)
Line 125 of Director.php
Director::direct(admin/RootForm/field/Logo/importlist)
Line 127 of main.php
require_once(C:\Program Files\BitNami WAPPStack\apache2\htdocs\deltageo\sapphire\main.php)
Line 63 of index.php

Posted to: [solved] cannot browse to file location using uploadify browse Show Thread | Post Reply

trying to get the latest images out of an ImageObject

benni91 — Wed, 01 Feb 2012 22:44:11 +1300

Hi @ all,

I'm trying to create my own image gallery. The galleries preview at the holder, should contain the last 4 images of this gallery.
The way i tried it doesn't work. I hope someone could help me.

The relations between the single pages and objects
GalleryHolder.php -> GalleryPage.php -> GalleryImagesObject.php -> Image Image Image ...

The GalleryHolder.php has this two function to sort the galleries and to get the latest 4 images of each gallery

   public function getGalleries() {
      return DataObject::get('GalleryPage', "ParentID = '$this->ID'", 'Date DESC');
   }

   function LatestGalleryImages($num=4) {
   $galleryimage = DataObject::get_one("GalleryHolder");
   return ($galleryimage) ? DataObject::get("GalleryPage", "ParentID = $galleryimage->ID", "Date DESC", "", $num) : false;
   }

that's the GalleryImagesObject.php

<?php
class GalleryImagesObject extends DataObject {

   public static $db = array(
      'Title' => 'Text',
      'Description' => 'Text'
   );

   public static $has_one = array(
      'GalleryImage' => 'Image',
      'GalleryPage' => 'GalleryPage'
   );

public function getCMSFields_forPopup() {

return new FieldSet(
   new TextField('Title', 'Titel des Bildes'),
   new TextAreaField('Description', 'Beschreibung des Bildes'),
   new ImageField('GalleryImage', 'Bild(er) hochladen')
);

}
}

and my GallerHolder.ss looks like this.

<% control getGalleries %>
   <% control GalleryImagesObject %>
      $GalleryImage
   <% end_control %>
   <a href="$Link" title="Die Gallerie $Title anzeigen">$Title</a>
<% end_control %>

-----

Where's the mistake(s) i made? I can see the link but not the images
Thx for your Help

Benni

P.s. Website

Posted to: trying to get the latest images out of an ImageObject Show Thread | Post Reply

[solved] cannot browse to file location using uploadify browse

bants — Wed, 01 Feb 2012 19:36:44 +1300

Hi,

i was playing round with Silverstripe and subsequently Uploadify on my laptop and loved it so much that i want to try making websites with it.

I have machine running windows server 2008 64bit and I installed Silverstripe on top of PostgreSQL (i'm a geographer, and this db has the best spatial extensions imo). The problem is that Uploadify will not open a file dialogue on the server so i cannot upload images.
When i click on the browse button, nothing happens and no messages are shown in firebug.
Trying to choose existing images leaves the "working" wheel spinning and i get a 500 error from firebug
The rest of Silverstripe seems to be working.

im using:
Windows Server 2008 sp1
WAPP stack running Apache 2.2.1, PostgreSQL 9.1.1, PHP 5.3.8
Silverstripe 2.4.6
Uploadify #534

Any help would be greatly appreciated!

James

Posted to: [solved] cannot browse to file location using uploadify browse Show Thread | Post Reply

Re: Comments in DataObject Page

jmax — Wed, 01 Feb 2012 11:27:45 +1300

Thanks Aram,

it's not simple for me..

i'll try...

Posted to: Comments in DataObject Page Show Thread | Post Reply

Re: Comments in DataObject Page

Aram — Wed, 01 Feb 2012 11:12:13 +1300

hi Jmax,

Unfortunately there is no simple way to add Comments to data-objects. For MyMuswell.com we wrote our own Comment system to allow commenting.

At it's core its simply a case of having a form which submits to the HolderPage controller and contains the DO's ID in a hidden field, which you can then Attach it using a has_many relationship.

Aram

Posted to: Comments in DataObject Page Show Thread | Post Reply

Re: Allow Comments in DataObjectManager

jmax — Wed, 01 Feb 2012 10:56:48 +1300

Hi freenet,

have you solved your issue? If yes, can you help me with the same problem?

my issue is explained here..

http://www.silverstripe.org/dataobjectmanager-module-forum/show/19101

thanks

Posted to: Allow Comments in DataObjectManager Show Thread | Post Reply

Re: Comments in DataObject Page

jmax — Tue, 31 Jan 2012 04:46:05 +1300

Anyone can help me?

Thanks

Posted to: Comments in DataObject Page Show Thread | Post Reply

Comments in DataObject Page

jmax — Fri, 27 Jan 2012 20:33:54 +1300

Hi all,

is there way to have comments in DataObject page?
I can view module in the page, i can insert comment, send email to admin when comment is
published, but the comment is published in all DataObject Pages.

Sorry for my english..

my Holder page is this:

CategoryPage.php
-----------------

<?php

class CategoryPage extends Page
{

public static $has_one = array(
'CategoryBanner' => 'Image'
);

public static $many_many = array(
'Products' => 'Product'
);

public static $has_many = array (
'Immagini' => 'Immagine',
'ImmaginiGalleria' => 'ImmagineGalleria'
);

static $allowed_children = array(
'none' => 'none'
);

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

$fields = parent::getCMSFields();
$manager = new FileDataObjectManager(
$this, // Controller
'ImmaginiGalleria', // Source name
'ImmagineGalleria', // Source class
'ImgGal',
array(
'Descrizione' => 'Descrizione',
), // Headings
'getCMSFields_forPopup' // Detail fields (function name or FieldSet object)
);
$fields->addFieldToTab("Root.Content.ImmaginiGalleria", $manager);

return $fields;
}
}

class CategoryPage_Controller extends Page_Controller
{

static $allowed_actions = array(
'show',
'InfoForm',
'PageComment'
);

public function init()
{
parent::init();

Requirements::css('products/css/products.css');
}

//Return the list of products for this category
public function getProductsList()
{
return $this->Products(Null, 'Epoca ASC');
}

//Get's the current product from the URL, if any
public function getCurrentProduct()
{
$Params = $this->getURLParams();
$URLSegment = Convert::raw2sql($Params['ID']);

if($URLSegment && $Product = DataObject::get_one('Product', "URLSegment = '" . $URLSegment . "'"))
{
return $Product;
}
}

//Shows the Product detail page
function show()
{
//Get the Product
if($Product = $this->getCurrentProduct())
{
$Data = array(
'Product' => $Product,
'MetaTitle' => $Product->MetaTitle
);

//return our $Data array to use, rendering with the ProductPage.ss template
return $this->customise($Data)->renderWith(array('ProductPage', 'Page'));
}
else //Product not found
{
return $this->httpError(404, 'Sorry that product could not be found');
}
}

//Generate out custom breadcrumbs
public function Breadcrumbs() {

//Get the default breadcrumbs
$Breadcrumbs = parent::Breadcrumbs();

if($Product = $this->getCurrentProduct())
{
//Explode them into their individual parts
$Parts = explode(SiteTree::$breadcrumbs_delimiter, $Breadcrumbs);

//Count the parts
$NumOfParts = count($Parts);

//Change the last item to a link instead of just text
$Parts[$NumOfParts-1] = ('<a href="' . $this->Link() . '">' . $Parts[$NumOfParts-1] . '</a>');

//Add our extra piece on the end
$Parts[$NumOfParts] = $Product->Title;

//Return the imploded array
$Breadcrumbs = implode(SiteTree::$breadcrumbs_delimiter, $Parts);
}

return $Breadcrumbs;
}

function InfoForm() {
// Create fields
$Params = Director::urlParams();

$fields = new FieldSet(
new TextField('Nome', 'Nome *'),
new TextField('Cognome', 'Cognome *'),
new EmailField('Email', 'Email *'),
new TextareaField('Note','Note'),
new HiddenField ('Info','Info',$this->Titolo),
new PhpCaptchaField('Captcha','')
);

// Create action
$actions = new FieldSet(
new FormAction('SendInfoForm', 'Invia')
);
// Create action

$validator = new RequiredFields('Nome', 'Cognome', 'Email');

return new Form($this, 'InfoForm', $fields, $actions, $validator);
}

function SendInfoForm($data) {

//Set data
$From = $data['Email'];
$To = "max@quamm.it";
$Subject = "Modulo Informazioni dal sito Giuseppediprinzio";
$email = new Email($From, $To, $Subject);
//set template
$email->setTemplate('ContactEmail');
//populate template
$email->populateTemplate($data);
//send mail
$email->send();
//return to submitted message

Director::redirect(Director::baseURL(). $this->URLSegment . "/?success=1");
}
public function Success()
{
return isset($_REQUEST['success']) && $_REQUEST['success'] == "1";
}

}

---------

My Product Page is this

Product.php

-------------

<?php

class Product extends DataObject
{
static $db = array(
'Title' => 'Varchar(255)',
'Description' => 'HTMLText',
'URLSegment' => 'Varchar(255)',
'MetaTitle' => 'Varchar(255)',
"Epoca" => "Enum(' , Anni ’20 - ’40, Anni ’40 - ’50, Anni ’50 - ’60, Anni ’60 - ’80, Anni ’80 - ’90, Anni ’90 - ’99', '')",
"Materiale" => "Enum(' , Terracotta, Ceramica Policroma, Carta, Gesso, Bronzo, Cera, Pietra, Argento', '')",
"Tipologia" => "Enum(' , Bassorilievo, Altorilievo, Tuttotondo, Incisione, Schizzo, Disegno b/n, Disegno colorato, Piatto Smaltato, Piastrella Dipinta', '')",
"Cani" => "Boolean",
"Cavalli" => "Boolean",
"CavalliAlati" => "Boolean",
"Centauri" => "Boolean",
"Donne" => "Boolean",
"Uomini" => "Boolean",
"Angeli" => "Boolean",
"Santi" => "Boolean",
"Bambini" => "Boolean",
"Paesaggi" => "Boolean",
"Barche" => "Boolean",
"Case" => "Boolean",
"Paesi" => "Boolean",
"Astratto" => "Boolean",
"Colombe" => "Boolean",
"Nudo" => "Boolean"
);

//Set our defaults
static $defaults = array(
'Title' => 'New Product',
'URLSegment' => 'new-product'
);

static $has_one = array(
'Image' => 'Image'
);

//Relate to the category pages
static $belongs_many_many = array(
'Categories' => 'CategoryPage'
);

//Fields to show in ModelAdmin table
static $summary_fields = array(
'Thumb' => 'Foto',
'Title' => 'Title',
'URLSegment' => 'URLSegment',
);

//Add an SQL index for the URLSegment
static $indexes = array(
"URLSegment" => true
);

//Fields to search in ModelAdmin
static $searchable_fields = array (
'Title',
'URLSegment',
'Description',
'Categories.ID' => array(
'title' => 'Category'
)
);

//Generate our thumbnail for the DOM
public function getThumb()
{
if($this->ImageID && $this->Image())
return $this->Image()->CMSThumbnail();
else
return '(No Image)';
}

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

//Main Tab
$fields->addFieldToTab("Root.Main", new TextField('Title', 'Title'));
$fields->addFieldToTab("Root.Main", new TextField('URLSegment', 'URL Segment'));
$fields->addFieldToTab("Root.Main", new TextField('MetaTitle', 'Meta Title')); $fields->addFieldsToTab('Root.SchedaOpera', array(new DropdownField('Epoca', 'Epoca', $this->dbObject('Epoca')->enumValues())));
$fields->addFieldsToTab('Root.SchedaOpera', array(new DropdownField('Materiale', 'Materiale', $this->dbObject('Materiale')->enumValues())));
$fields->addFieldsToTab('Root.SchedaOpera', array(new DropdownField('Tipologia', 'Tipologia', $this->dbObject('Tipologia')->enumValues())));
$fields->addFieldToTab('Root.SchedaOpera', new LabelField ("Soggetti","Soggetti:"));

$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Cavalli","Cavalli"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("CavalliAlati","Cavalli Alati"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Cani","Cani"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Centauri","Centauri"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Donne","Donne"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Uomini","Uomini"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Angeli","Angeli"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Santi","Santi"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Bambini","Bambini"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Paesaggi","Paesaggi"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Barche","Barche"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Case","Case"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Paesi","Paesi"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Astratto","Astratto"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Colombe","Colombe"));
$fields->addFieldsToTab('Root.SchedaOpera', new CheckBoxField("Nudo","Nudo"));
$fields->addFieldToTab("Root.Main", new HTMLEditorField('Description','Descrizione'));
//Categories
$Categories = DataObject::get('CategoryPage');
$fields->addFieldToTab("Root.Categories", new CheckboxsetField('Categories', 'Categorie', $Categories));

//Images
$fields->addFieldToTab("Root.Immagini", new ImageField('Image', 'Immagine', Null, Null, Null, 'Opere/'));

return $fields;
}

//Set URLSegment to be unique on write
function onBeforeWrite()
{
// If there is no URLSegment set, generate one from Title
if((!$this->URLSegment || $this->URLSegment == 'new-product') && $this->Title != 'New Product')
{
$this->URLSegment = SiteTree::generateURLSegment($this->Title);
}
else if($this->isChanged('URLSegment'))
{
// Make sure the URLSegment is valid for use in a URL
$segment = preg_replace('/[^A-Za-z0-9]+/','-',$this->URLSegment);
$segment = preg_replace('/-+/','-',$segment);

// If after sanitising there is no URLSegment, give it a reasonable default
if(!$segment) {
$segment = "product-$this->ID";
}
$this->URLSegment = $segment;
}

// Ensure that this object has a non-conflicting URLSegment value.
$count = 2;
while($this->LookForExistingURLSegment($this->URLSegment))
{
$this->URLSegment = preg_replace('/-[0-9]+$/', null, $this->URLSegment) . '-' . $count;
$count++;
}

parent::onBeforeWrite();
}

//Test whether the URLSegment exists already on another Product
function LookForExistingURLSegment($URLSegment)
{
return (DataObject::get_one('Product', "URLSegment = '" . $URLSegment ."' AND ID != " . $this->ID));
}

//Generate the link for this product
function Link()
{
//if we are on a category page return that
if(Director::CurrentPage()->ClassName == 'CategoryPage')
{
$Category = Director::CurrentPage();
}
//Otherwise just grab the first category this product is in
else
{
$Category = $this->Categories()->First();
}
//Check we have a category then return the link
if($Category)
{
return $Category->absoluteLink() . 'show/' . $this->URLSegment;
}
}
function AbsoluteLink() {
return Director::absoluteURL($this->Link());
}

}

If I add $PageComments in my .ss template when submit it, comment appear in each product...

I hope anyone help me.

Thanks

Max

Posted to: Comments in DataObject Page Show Thread | Post Reply

Re: DataObject::get by Year from a DateField?

mierla — Fri, 27 Jan 2012 02:10:03 +1300

I just wanted to add my thanks - I was able to use this construction to very easily retrieve a week's worth of events for a listing page - not just seven days from today, but a true week, including past days. Thank you!

Posted to: DataObject::get by Year from a DateField? Show Thread | Post Reply

Re: Using an attribute of a has_one relation as heading in Dataobjectmanager

BartM — Thu, 26 Jan 2012 20:39:15 +1300

Thank you very much, that did the trick. I already suspected it had to be something simple.

Posted to: Using an attribute of a has_one relation as heading in Dataobjectmanager Show Thread | Post Reply

Re: Using an attribute of a has_one relation as heading in Dataobjectmanager

UncleCheese — Thu, 26 Jan 2012 06:59:10 +1300

Try Member.Name

v--------------------
SilverStripe tips, tutorials, screencasts and more: http://www.leftandmain.com

Posted to: Using an attribute of a has_one relation as heading in Dataobjectmanager Show Thread | Post Reply

Using an attribute of a has_one relation as heading in Dataobjectmanager

BartM — Thu, 26 Jan 2012 03:41:44 +1300

Using an attribute of a has_one relation as heading in Dataobjectmanager

Hello all,

Once again I find myself using the DataObjectManager to build the necessary user-friendliness into my site and in general I am enjoying the experience. However, as usual, I seem to have run into this one small issue that I cannot seem to get my head around.

Here's hoping one of you can help me out.

The project I am currently working is fairly straightforward: a few pages explaining the goal and activities of the association that is our customer; and a couple of pages listing members and such for logged-in users.

The page that is giving me trouble is a page listing the members of the direction. The DirectionPage has a has_many relation with the dataobject DirectionMember. DirectionMember in turn has a has_one relation to the DataObject Member.

In the CMS the DirectionPage contains a DataObjectManager that shows all linked DirectionMembers, defined like this:

$manager = new DataObjectManager(
   $this, // Controller
   'DirectionMembers', // Source name
   'DirectionMember', // Source class
   array(
      'Function' => 'Functie',
      'EmailAddress' => 'Emailadres'
   ), // Headings
   'getCMSFields_forPopup' // Detail fields (function name or FieldSet object)
   // Filter clause
   // Sort clause
   // Join clause
);

And this is the definition of DirectionMember:

class DirectionMember extends DataObject
{
   static $db = array (
      'EmailAddress' => 'Text',
      'Function' => 'Text'
);

static $has_one = array (
      'Member' => 'Member',
      'Parent' => 'DirectionPage'
);

   public function getCMSFields_forPopup()
{
      $Group = DataObject::get_one("Group", "Title = 'WebsiteUsers'", "", "");
      $Members = $Group->Members(
                $limit = '',
                $offset = '',
                '',
                $sort = 'Member.Email',
                $join = ''
               );
      $dropdown = new DropdownField('MemberID','Lid',$Members->toDropdownMap('ID', 'Title', 'Selecteer lid'),$this->Member);

return new FieldSet(
new TextField('EmailAddress', 'Emailadres'),
         new TextField('Function', 'Functie'),
         $dropdown
);
}
}

Now, the above code works flawlessly... except that I would really like to show the DirectionMember's name as well as their function and email address. However, this name is stored inside the has_one field Member.
I had hoped that I could do something like this:

$manager = new DataObjectManager(
   $this, // Controller
   'DirectionMembers', // Source name
   'DirectionMember', // Source class
   array(
      'Member->Name' => 'Naam',
      'Function' => 'Functie',
      'EmailAddress' => 'Emailadres'
   ), // Headings
   'getCMSFields_forPopup' // Detail fields (function name or FieldSet object)
   // Filter clause
   // Sort clause

However, no such luck. Am I missing anything obvious, or is getting this name more involved?

Looking forward to your replies,
Bart M.

Posted to: Using an attribute of a has_one relation as heading in Dataobjectmanager Show Thread | Post Reply

Re: Problem with SiteTree in DOM

qbahamutp — Wed, 25 Jan 2012 22:48:46 +1300

Apologies for the bump. I'm just curious about how you can make this work. I've got a similar issue going on, but it's a low-priority, really.

I'm just curious about the principle of controlling the content of DOM columns using functions.

Regarding the example that UC wrote in the above post: how does it know to refer to the getGoldTitle()function based on its array key ('GoldTitle')?
I've tried adding a function to the page's controller that always returns "foo", but I can't even get that to work.

I'm hoping someone can help me figure this one out. Thanks in advance.

Posted to: Problem with SiteTree in DOM Show Thread | Post Reply

Re: Column 'ClassName' in where clause is ambiguous

UncleCheese — Wed, 25 Jan 2012 08:58:39 +1300

Yeah, this is a nasty error. I can't remember exactly how I've solved it in the past, but if I had to guess I'd say it has to do with SilverStripe's not-quite-complete management of columns. Because the ORM is designed a bit paranoid, it only creates columns, and won't' delete them. It's therefore possible (I think), that if you did:

class MyClass extends DataObject
--> Table MyClass has a ClassName column, because its parent is the base data class

Then change it to:

class MyClass extends Image
--> Table MyClass now has a ClassName column but it should not, and SilverStripe won't delete that column.

I could be wrong about that, but it sounds right to me. If it's true, when the tables join, you have an ambiguous column error.

--------------------
SilverStripe tips, tutorials, screencasts and more: http://www.leftandmain.com

Posted to: Column 'ClassName' in where clause is ambiguous Show Thread | Post Reply

Re: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue

SamIAm — Wed, 25 Jan 2012 08:52:17 +1300

This is for people who run into the same problem just in case. People on other site have suggested me to use 'return true' for my sidebar purpose and it is working now. Cheers, S:)

Posted to: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue Show Thread | Post Reply

Column 'ClassName' in where clause is ambiguous

CHD — Wed, 25 Jan 2012 03:12:47 +1300

Today, we published a site, then realised everything worked fine except for the Assets panel. When opening the Assets page we had this error:

"Column 'ClassName' in where clause is ambiguous"

A quick Google led us to this page: https://github.com/unclecheese/Uploadify/commit/88a3b16973c17382e81a13261dae187ba60c7cc0

But we already had the latest uploadify module installed, so it wasn't that. We couldn't find any problems in our DB tables. No missing classNames etc.

In our site we had a HomePage.php with:

static $has_many = array(
'AttachedFiles' => 'Slideshow'
);

and in Slideshow.php we had:

class Slideshow extends Image {

   static $has_one = array (
      'HomePage' => 'HomePage'
   );
}

All worked fine in the front end, and the CMS, but we couldn't get the Assets to work with what ever we tried!
Eventually, we just renamed the Slideshow to SlideshowItem and it fixed everything.

Can anybody shed in light on why this happened? We've never seen it before and re-use the HomePage.php & Slideshow.php files all the time, s why would this suddenly die?

Posted to: Column 'ClassName' in where clause is ambiguous Show Thread | Post Reply

Re: DOM + ModelAdmin + Image = strpos error

RobboDev — Tue, 24 Jan 2012 11:53:09 +1300

Thanks Jim

That worked for me.

Posted to: DOM + ModelAdmin + Image = strpos error Show Thread | Post Reply

Re: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue

SamIAm — Tue, 24 Jan 2012 08:21:32 +1300

Hi Sticks,

Thanks very much for replying. You are right that I need to change

function canView()
{
return $this->CategoryPages()->canView();
}

to return $this->Categories()->canView();

However another error came up, [User Error] Uncaught Exception: Object->__call(): the method 'canview' does not exist on 'ComponentSet' Any suggestions on how to fix this?

Thanks very much for your help.

Sam

Posted to: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue Show Thread | Post Reply

Re: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue

Sticks — Mon, 23 Jan 2012 16:26:25 +1300

Hi SamIAm, if you've declared the Category Pages as in the tutorial:

//Relate to the category pages
static $belongs_many_many = array(
'Categories' => 'CategoryPage'
);

...then your canView function should look like this:

function canView()
{
return $this->Categories()->canView();
}

ie. Change CategoryPages() to Categories() (or whatever you have named the relationship).

Now I'm not 100% on whether that'll make the overall functionality work but I'm pretty sure that's where the error is originating, and that's where I'd start.

Posted to: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue Show Thread | Post Reply

SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue

SamIAm — Mon, 23 Jan 2012 15:58:10 +1300

Hi everyone,

I've been following http://www.ssbits.com/tutorials/2010/dataobjects-as-pages-part-2-using-model-admin-and-url-segments-to-create-a-product-catalogue/ tutorial on my localhost and running into a sidebar problem.

When I use the same method to create a sidebar as tutorial one, an error message shows on my site: [User Error] Uncaught Exception: Object->__call(): the method 'categorypages' does not exist on 'Product'

I know someone had this problem before, but the solution in the discussion didn't solve my problem since I am using the new code ($Category = $this->Categories()->First(); on line 120).

This is the code I added to Product.php for sidebar to appear.

//Return the Title as a menu title
public function MenuTitle()
{
return $this->Title;
}

//Ensure that the DO shows up in menu (it is needed otherwise sidebar doesn't show when not logged in)

function canView()
{
return $this->CategoryPages()->canView();
}

Does anyone know how to fix it? Thanks very much.

Sam:)

Posted to: SSBITS: DataObjects as Pages Part 2 tutorial- sidebar issue Show Thread | Post Reply

Re: Uploadify problem

AndrewNZ — Thu, 19 Jan 2012 14:39:35 +1300

Hi Xazen,

Did you figure this out? We are having a similar problem. We installed DataObjectManager and Uploadify and ever since then, when we try to upload files (even from the standard Files & Images tab in the admin mode, we can select a file exactly like you but then nothing happens and no files get uploaded.

Thanks

Andrew

Posted to: Uploadify problem Show Thread | Post Reply

Re: Unpublished many_many relationships on front end.

Shawn Parr — Thu, 19 Jan 2012 11:10:57 +1300

Well, I figured it out.

Since my 'CollectionPage' extends Page, it is versioned, and versioned automatically grabs the Classname_Live data instead of just Classname when you are viewing the front end, which I knew but didn't know how to get around.

In my code that gets the pages to put into a CheckboxSetField I had this:

$collections = DataObject::get('CollectionPage');
$f->addFieldToTab("Root.Collections", new CheckboxSetField('Collections', 'Collections', $collections));

To make it work I changed from using DataObject::get() to directly calling Versioned::get_by_stage, which I could then specify to get the draft versions:

$collections = Versioned::get_by_stage('CollectionPage', 'Draft');
$f->addFieldToTab("Root.Collections", new CheckboxSetField('Collections', 'Collections', $collections));

Since part of implementing this 'admin' interface on the front end was to create permissions specific to the app and the editors needed access to view draft pages already this solution works perfectly for me. I haven't tested it but I believe if my users didn't have the ability to view draft pages this solution wouldn't work.

Posted to: Unpublished many_many relationships on front end. Show Thread | Post Reply

Re: DOM overtakes entire CMS

ToRo — Thu, 19 Jan 2012 05:44:44 +1300

Yeah. The folder is named correctly. This is an odd problem as nothing has been changed on this site, all of a sudden the DOM started working incorrectly.

Posted to: DOM overtakes entire CMS Show Thread | Post Reply

Re: DOM overtakes entire CMS

Sticks — Wed, 18 Jan 2012 11:22:41 +1300

Have you renamed the DOM folder to 'dataobject_manager'? I know not doing that can cause formatting issues.

Posted to: DOM overtakes entire CMS Show Thread | Post Reply

DOM overtakes entire CMS

ToRo — Wed, 18 Jan 2012 10:50:41 +1300

Tried searching around the forums, no luck.

New to Silverstripe, so bear with me. I am having trouble with the DataObjectManager where it is rendering on top of all of the tabs in the CMS, regardless of which tab I place it in. It just renders itself on top of the tabs in a very unformatted way like the data is just getting dumped out onto the page. Is this something you guys have seen before? All of the code is as it should be, short of replacing the DOM module files do you good people have any thoughts on what could be wrong?

Thanks

Posted to: DOM overtakes entire CMS Show Thread | Post Reply