Re: How to include a Data Object Model in the search box?

BenWu — Tue, 22 May 2012 22:11:22 +1200

Hello, I found this:
http://www.i-lateral.com/tutorials/extending-fulltextsearch-for-dataobjects/
But i haven't tried this but it should work. It's small and simple. That could help small sites.

I also found this: "MATCH (Title, MenuTitle, Content, MetaTitle,
https://groups.google.com/group/silverstripe-dev/msg/f7af364f1fba2def
I tried it but unfortunately it doesn't work for me. I find it hard to debug so i give up.

But an ultimate solution would be this: http://code.google.com/p/lucene-silverstripe-plugin/
It will index all public pages.

[Edit]

I can report the lucene plugin works very well. The relation search works perfectly. however, if i do
wget http://your.server.name/dev/tasks/ProcessJobQueueTask to index the website, i can only get the login page. How to pass user/pass to wget?

[more edit]

and i found this for the wget problem:
http://www.silverstripe.org/general-questions/show/16560

Posted to: How to include a Data Object Model in the search box? | Show Thread | Post Reply

Re: How to include a Data Object Model in the search box?

swaiba — Tue, 22 May 2012 21:23:47 +1200

Hi,

Here are the links from my "ss pastie" file...

aram custom serach
http://www.silverstripe.org/all-other-modules/show/6641?start=24#post290089

my hacky way to custom search results
http://www.silverstripe.org/customising-the-cms/show/14067#post288644

Posted to: How to include a Data Object Model in the search box? | Show Thread | Post Reply

Re: How to include a Data Object Model in the search box?

danzzz — Tue, 22 May 2012 05:31:41 +1200

may you want to check this module:
http://www.ssbits.com/tutorials/2012/dataobject-as-pages-the-module/

you can learn it from this module or just use it

Posted to: How to include a Data Object Model in the search box? | Show Thread | Post Reply

Re: How to include a Data Object Model in the search box?

BenWu — Tue, 22 May 2012 04:50:38 +1200

i would like to know as well. guess we have to extend the searchform function??

Posted to: How to include a Data Object Model in the search box? | Show Thread | Post Reply

Re: onBeforeWrite called multiple times

BenWu — Tue, 15 May 2012 21:10:27 +1200

Hello UncleCheese, could you explain why we shall use static class variable, not object variable??

Posted to: onBeforeWrite called multiple times | Show Thread | Post Reply

GroupBy is not supported in DataList for SilverStripe 3 ?

Frankieboy — Sun, 13 May 2012 10:47:25 +1200

Hi there,

I am struggling to convert the code below from the tutorial (http://doc.silverstripe.org/sapphire/en/tutorials/3-forms) to Silverstripe 3. I understand using DataList is a recommend approach and DataObjectSet is depreciated, but it seems that Group By is not supported in DataList.
Anyone has idea how to make the code working using SilverStripe 3’s new ORM like http://www.silverstripe.org/silverstripe-3-s-new-orm/ ?

function BrowserPollResults() {
$submissions = DataObject::get('BrowserPollSubmission');
$total = $submissions->Count();

$doSet = new DataObjectSet();
foreach($submissions->groupBy('Browser') as $browser => $data) {
$percentage = (int) ($data->Count() / $total * 100);
$record = array(
'Browser' => $browser,
'Percentage' => $percentage
);
$doSet->push(new ArrayData($record));
}

return $doSet;
}

Posted to: GroupBy is not supported in DataList for SilverStripe 3 ? | Show Thread | Post Reply

Re: Pagination not working with a selected 'type' of children.

BigMoose — Sat, 12 May 2012 05:15:11 +1200

Thank you martimiz for your time. I won't get a chance to try this for a couple days as I am out of town, but as soon as I can I will give it a go and report back. I really appreciate your taking the time to brainstorm this matter.

Posted to: Pagination not working with a selected 'type' of children. | Show Thread | Post Reply

Re: Adding option drop-downs to pages

novaweb — Fri, 11 May 2012 08:57:48 +1200

You probably need to declare:

static $db = array(); or a $has_one or $has_many relationship titled 'ShowSocial'

Else you are giving the program the interface to do what you want, but you're not giving it anywhere to be saved.

Chur

Posted to: Adding option drop-downs to pages | Show Thread | Post Reply

Adding option drop-downs to pages

Spaghetti — Fri, 11 May 2012 03:02:55 +1200

I'm trying to figure out how to add an option on my CMS editor page, sidebar content. So far I've done this:

function getCMSFields()
{
$fields = parent::getCMSFields();
$fields->addFieldToTab(
    "Root.Content.Sidebar",
       new HTMLEditorField('SideContent','Sidebar content'));

    $fields->addFieldToTab(
    "Root.Content.Sidebar",
       new OptionsetField(
       'ShowSocial',
       $title = 'Show social widgets on this page',
       $source = array(
          '1' => 'show','2' => 'hide'),
         '1'
       ));
return $fields;
}

In my page controller, which shows the controls but doesn't save their state when I click save. What am I missing?

Posted to: Adding option drop-downs to pages | Show Thread | Post Reply

Re: Pagination not working with a selected 'type' of children.

martimiz — Thu, 10 May 2012 23:16:16 +1200

In your query ou're still retrieving every video object for the given page, and then you let your template decide what items to show. Default pagination is based on the entire DataObjectSet you retrieved, so that would account for the wrong number of pages.

You might consider adding the videotype to the query itself. Something like this (I'm basing this on your code - there might be a better way to do this by reconstructing the page structure, but just for an idea...):

function Videos($videotype='') {
if(!isset($_GET['film']) || !is_numeric($_GET['film']) || (int)$_GET['film'] < 1) $_GET['film'] = 0;
$SQL_start = (int)$_GET['film'];

$myFilter = "`ParentID` = '".$this->ID."'";
if ($videotype) $myFilter .= " AND `{$videotype}` = '1'";

      $doSet = DataObject::get(
      $callerClass = "VideoPage",
      $filter = $myFilter,
      $sort = "",
      $join = "",
      $limit = "{$SQL_start},9"
   );

return $doSet ? $doSet : false;
}

... and ...

public function Corporate() {
if (isset($_REQUEST['corporate']) && $_REQUEST['corporate'] == "1") return $this->Videos('TypeCorporate');
else return false;
}

Then you could

<% if Corporate %>
   <% control Corporate %>
      ...
   <% end_control %>
   ...
<% end_if %>

I've not tested this, it's just an idea

Posted to: Pagination not working with a selected 'type' of children. | Show Thread | Post Reply

Re: Pagination not working with a selected 'type' of children.

BigMoose — Thu, 10 May 2012 04:08:46 +1200

I believe that is correct. I changed the css, so that all the items in the 3x3 grid have exactly the same spacing. So I no longer use <% if MultipleOf(3) %> in my template. So that solved the issue of the spacing causing problems.

I did look at that tutorial on ssbits, but did not have success with it. It's probably due to the way I have chosen to write my code for sorting the video types. I came close to having success with this code:

function Videos() {
if(!isset($_GET['film']) || !is_numeric($_GET['film']) || (int)$_GET['film'] < 1) $_GET['film'] = 0;
$SQL_start = (int)$_GET['film'];
$doSet = DataObject::get(
$callerClass = "VideoPage",
$filter = "`ParentID` = '".$this->ID."'",
$sort = "",
$join = "",
$limit = "{$SQL_start},9"
);

return $doSet ? $doSet : false;
}

Again, I have zero idea what this code means. But changing it from $_GET['start'] to $_GET['film'] did partially work when I wanted to display pagination for just the film type videos. It would create the grid in the proper way even when using the old spacing and <%if Multiple Of(3) %>, but I would be left with links for page two, even though nothing existed on page two.

Posted to: Pagination not working with a selected 'type' of children. | Show Thread | Post Reply

Re: Pagination not working with a selected 'type' of children.

martimiz — Wed, 09 May 2012 06:14:07 +1200

I'm not sure if I get this right, but what you seem to be doing in your template, is in fact loop the entire DataObjectSet - and based on <% if Film %> filter, decide whether to show an item or not. That would mean that item 5 from the set would still be item 5. even though items 1, 2, 3 and 4 are not displayed...

Unfortunately paginating a filtered DataObjectSet isn't as straightforward. There's this tut on ssbits that might help you along:

http://www.ssbits.com/tutorials/2010/paginating-a-filtered-dataobjectset/

Posted to: Pagination not working with a selected 'type' of children. | Show Thread | Post Reply

Pagination not working with a selected 'type' of children.

BigMoose — Sun, 06 May 2012 04:19:10 +1200

I'm not desperately code savvy, but my website is coming along great non-the-less thanks to the forum posts from the past. However, I am struggling with one issue.

Essentially, my website has a page which displays a video gallery grid - 3x3 grid of thumbnails appears, and the user can click on a video to watch. Additionally, the videos can be viewed based on what type they are. In my case, there are only 4 options: Film & Television, Corporate, Sports & Events, and Other.

I've currently got things set up like this - there is a VideoHolder.php, and the child VideoPage.php.
VideoPage.php has the following code:

class VideoPage extends SiteTree {

   public static $db = array(
// Variables to classify the videos
   'TypeFilmTV' => 'Boolean',
   'TypeCorporate' => 'Boolean',
   'TypeSportsEvents' => 'Boolean',
   'TypeOther' => 'Boolean',
   );

// Down here I have all the new checkboxfields to appear in the cms.
}

The idea is that I can use <% if TypeFilmTV %> in my template to show only the ones of that type if it is selected.
I used checkboxes instead of a dropdown because a video could be classified as more than one type, and there are not many types anyway.

Now, in order that the user may select a video type to view on the page, I simply coded the link to add ?vidType=1 at the end of the link. These links are just a row of five buttons at the top of the page: "See All", "Film & Television", etc.

I then added the following into VideoHolder.php

class VideoHolder_Controller extends Page_Controller {

   public function Film()
{return isset($_REQUEST['film']) && $_REQUEST['film'] == "1";}

   public function Corporate()
{return isset($_REQUEST['corporate']) && $_REQUEST['corporate'] == "1";}

   public function Events()
{return isset($_REQUEST['events']) && $_REQUEST['events'] == "1";}

   public function Other()
{return isset($_REQUEST['other']) && $_REQUEST['other'] == "1";}
}

Then in my VideoHolder.ss template I could simply use a link as mentioned above with the added ?film=1 as an example and then write

<% if Film %> // Or whatever type I am working with

Anyway, all this works fine and dandy. The real problem I am having is when I use pagination now. In order to create my 3x3 grid, I have padding on the right side of each thumbnail except for the third one in each row. This is giving me the spacing I desire. I am accomplishing this by simply using:

<% if MultipleOf(3) %>

When pagination is used to view all the videos, it works perfectly. However, when a type is selected, pagination does not seem to 'see' the new position of each video. For example, suppose "video A" was third in the row, and "video B" appeared on page two when viewing all videos. Now when viewing just the videos labelled at "Film & Television" 'video A' appears in the second position. What will then happen is that 'video A' still does not have the padding on the right which had been controlled using <%MultipleOf(3)%>, even though it now appears second. Furthermore, "video B" is still showing on page 2 despite only 3 videos now appearing on page 1, and pagination coded to show 9 items per page. I hope this example is clear.

My pagination function is in my VideoHolder_Controller and looks like this

function Videos() {
    if(!isset($_GET['start']) || !is_numeric($_GET['start']) || (int)$_GET['start'] < 1) $_GET['start'] = 0;
    $SQL_start = (int)$_GET['start'];
    $doSet = DataObject::get(
      $callerClass = "VideoPage",
      $filter = "`ParentID` = '".$this->ID."'",
      $sort = "",
      $join = "",
      $limit = "{$SQL_start},9"
    );

    return $doSet ? $doSet : false;
   }

I believe this code needs to be altered, but I have no idea how this code works. Again, I am not code savvy. I simply got this code from:
http://doc.silverstripe.org/old/private:recipes:pagination and altered it very slightly for my needs. If anyone has an idea on how to alter this piece of code, and is willing to dumb it down for this shmuck I'd would be very appreciative. Thanking you in advance.

Posted to: Pagination not working with a selected 'type' of children. | Show Thread | Post Reply

Dynamically related content

tonibecker — Thu, 03 May 2012 22:14:06 +1200

Hy dudes from all over the world.
I'm having problems in design-solution-approach.

Here's the scenario:
I have my sitetree in this structure:

company ->Locations->Events

All of those have galleries and articles in a subsection.

I would like to use the tag system, but here's my problem. I want to crawl the whole sitetree, collect all tags from every page and than compare by 1 tag, 2 tags, 3 tags.... If one of thes matches show the related content.

In next step i have to filter them, let's say: I have pagetype article with 2 related tags show only the related content from documenttype article.

I solved this problem in umbraco and c# but i like the approach of silverstripe to handle data with grids and the extensibility.

Greetings Toni.

Code snippets would be nice if somebody solved this problem.

Posted to: Dynamically related content | Show Thread | Post Reply

Re: Get Relation on data durung onBeforeWrite (first time) [SOLVED]

zenmonkey — Thu, 03 May 2012 12:49:29 +1200

I got fixed, the DataObject in question was an extension of DataObjectAsPage so I wrapped the functions in my onBeforeWrite in a if($this->ID !=0). I'll post that it needs to be documented

Posted to: Get Relation on data durung onBeforeWrite (first time) [SOLVED] | Show Thread | Post Reply

Re: Get Relation on data durung onBeforeWrite (first time) [SOLVED]

swaiba — Thu, 03 May 2012 00:59:01 +1200

can you do a var_dump of $this and check for anything that matches the relationship?

we are talking a has_one relationship right?

Posted to: Get Relation on data durung onBeforeWrite (first time) [SOLVED] | Show Thread | Post Reply

Re: Get Relation on data durung onBeforeWrite (first time) [SOLVED]

zenmonkey — Thu, 03 May 2012 00:56:41 +1200

The relation is still null at onBeforeWrite the first time. It doesn't get created until the actual write. I'm talking about the initial creation of the record

Posted to: Get Relation on data durung onBeforeWrite (first time) [SOLVED] | Show Thread | Post Reply

Re: Get Relation on data durung onBeforeWrite (first time) [SOLVED]

swaiba — Wed, 02 May 2012 19:56:25 +1200

If it is a has_one then $this->RelationNameID should work

Posted to: Get Relation on data durung onBeforeWrite (first time) [SOLVED] | Show Thread | Post Reply

Get Relation on data durung onBeforeWrite (first time) [SOLVED]

zenmonkey — Wed, 02 May 2012 13:32:20 +1200

I have a dataobject in which I need relation data for a function on the first onBeforeWrite. The relation is set with DropdownField populated with a toDropdownMap in the CMS. In theory I should be able pull the ID from that form element but I'm not sure how its passed to the onBeforeWrite function. Calling $this->RelatedDataObejct doesn't work because that relation isn't set yet. And I can't get the form Value with $this->getField();

I could call the function I need in onAfterWrite and only fire it if the value I'm creating is null and putting another write function in it but that just seems like a recipe for disaster with potential write loops

Any ideas?

Posted to: Get Relation on data durung onBeforeWrite (first time) [SOLVED] | Show Thread | Post Reply

Re: jquerymobile Weirdness - editor issue

bembo99 — Wed, 25 Apr 2012 03:49:18 +1200

Or a jQuery solution...

;(function($){
$(document).bind("pageinit", function(){
$('.typography img').each(function(){
$(this).attr('src','/'+$(this).attr('src'));
});
});
})(jQuery);

Posted to: jquerymobile Weirdness - editor issue | Show Thread | Post Reply

Re: jquerymobile Weirdness - editor issue

Spaghetti — Fri, 20 Apr 2012 01:13:20 +1200

Right, got a better solution. Worked for me, try this:

in your mysite / _config.php add a configuration variable to say where your assets folder is relative to '/' (your web root) -as this is 'installation-specific configuration'.

//My assets dir is off a subdirectory which is SS's root.
global $assetsPrependHack;
$assetsPrependHack = "/ss/assets/";

Then in mysite / code / Page.php I added something similar to that blog post I mentioned before:

//AC: Hack to rewrite the start of asset
// urls so that they work on the ajaxy mobile version of the site.
global $assetsPrependHack;
if( isset($assetsPrependHack) ) {
$this->Content = str_replace(
' src="assets/', ' src="'.$assetsPrependHack,
$this->Content);
}

Posted to: jquerymobile Weirdness - editor issue | Show Thread | Post Reply

Re: jquerymobile Weirdness - editor issue

Spaghetti — Thu, 19 Apr 2012 21:05:52 +1200

Yes I've experienced this too. What fun.

There is one workaround, you can extend Page's onWriteBefore method to prefix the URL but I don't like this as it won't work if silverstripe isn't installed in the root directory on your server (so, for instance for local testing, it's no good to me). Found it in this post: http://www.electrictoolbox.com/silverstripe-prefix-img-src-assets-leading-slash/

I have a workaround but it's not pretty. Basically absolute urls. This works but it's fuggly UX. I really don't like the whole 'image dialog' anyway, it's really bad design - ideally I'd like a point and click solution.

Looking for a better way... let you know if I find one.

Posted to: jquerymobile Weirdness - editor issue | Show Thread | Post Reply

Re: Relation Performance

martimiz — Sun, 15 Apr 2012 04:19:23 +1200

You could maybe check out what happens by adding a ?showqueries=1 to your URL. I often use that in situations like this...

Posted to: Relation Performance | Show Thread | Post Reply

Relation Performance

zenmonkey — Sun, 15 Apr 2012 01:27:37 +1200

Ok I have a performance question. Consider the following

Page A has many Object B and has Many Object C
Object B Has One Page A and Has 1 Object C
Object C Has One Page A and Many Object B

When I render the page and I need to get the Object B has 1 Object C relation, does it run the relation query for each instance of Object B or does SS already know it has Object C because of the Has Many Relation with the page?

I know its not a big deal on small numbers, but I worry at how it will scale. Would it be better to cache Object B and Object C and pull the relationship data from that cache or will the extra filter operations cancel any performance gains?

Posted to: Relation Performance | Show Thread | Post Reply

Re: Filtering a DataObjectSet by range query?

Pipifix — Tue, 10 Apr 2012 20:56:00 +1200

Hi Nico,

i don't know if you mean filtering on backend or frontend. For the ModelAdmin in BE this will maybe a good start to look at: http://www.leftandmain.com/silverstripe-tutorials/2011/03/15/taming-the-beast-remodeling-modeladmin-part-2/. But keep in mind this is for ModelAdmin for SS2. Good luck…

Pipifix.

PS:Grüße aus Leipzig.

Posted to: Filtering a DataObjectSet by range query? | Show Thread | Post Reply

Re: [solved] Make DOs searchable (Fulltextsearch)

Pipifix — Tue, 10 Apr 2012 20:35:26 +1200

Hello again.

Just for the records. I've used Arams fine module Dataobject as pages . It contains a built-in-searchfunctionality. Nevertheless thanks a lot for your help and additional infos.

Pipifix

Posted to: [solved] Make DOs searchable (Fulltextsearch) | Show Thread | Post Reply

Re: Decorating DataObjectSet?

dizzystuff — Sun, 08 Apr 2012 03:09:30 +1200

Hi fatlewis! Could it just be that you're missing the ( ) at the end of ->items?

shuffle($this->owner->Items());

This isn't my first post but usually I'm here asking questions not answering them (I'm procrastinating pretty epically right now so figured I'd try to be useful at least) so please be nice back if this is doesn't do the trick

EDIT: just saw the date on the post heh. ah well. hope it helps someone.

Posted to: Decorating DataObjectSet? | Show Thread | Post Reply

Re: [SOLVED] Data object belongs_many_many, no relation after csv import

MattIn4D — Fri, 06 Apr 2012 15:14:04 +1200

I think I solved this.

I changed the relationships to has_one & has_many.

I added the following to the model admin extension:
   static $model_importers = array(
      'Standing' => 'StandingCsvBulkLoader',
   );

And extended CsvBulkLoader like so:
class StandingCsvBulkLoader extends CsvBulkLoader {

   public $columnMap = array(
      'Place' => 'Place',
      'Bowler' => 'Bowler',
      'Series' => 'Series',
      'Average' => 'Average',
      'Handicap' => 'Handicap',
      'Game1' => 'Game1',
      'Game2' => 'Game2',
      'Game3' => 'Game3',
      'Game4' => 'Game4',
      'Season' => 'Season.Title'
   );

   public $relationCallbacks = array(
      'Season.Title' => array(
         'relationname' => 'Season',
         'callback' => 'getSeasonByTitle'
      )
   );

   static function getSeasonByTitle(&$obj, $val, $record) {
      $SQL_val = Convert::raw2sql($val);
      return DataObject::get_one(
         'SeasonPage', "Title = '{$SQL_val}'"
      );
   }

}

Posted to: [SOLVED] Data object belongs_many_many, no relation after csv import | Show Thread | Post Reply

[SOLVED] Data object belongs_many_many, no relation after csv import

MattIn4D — Thu, 05 Apr 2012 10:03:01 +1200

I have a data object that contains tournament standings.

class Standing extends DataObject
{
   static $db = array (
      'Place' => 'Text',
      'Prize' => 'Text',
      'Bowler' => 'Text',
      'Series' => 'Text',
      'Average' => 'Text',
      'Handicap' => 'Text',
      'Game1' => 'Text',
      'Game2' => 'Text',
      'Game3' => 'Text',
      'Game4' => 'Text'
   );

   static $summary_fields = array (
      'Place' => 'Place',
      'Prize' => 'Prize',
      'Bowler' => 'Bowler',
      'Series' => 'Series',
      'Average' => 'Average',
      'Handicap' => 'Handicap',
      'Game1' => 'Game1',
      'Game2' => 'Game2',
      'Game3' => 'Game3',
      'Game4' => 'Game4',
      'Season' => 'Season'
   );

   static $belongs_many_many = array(
      'Season' => 'SeasonPage'
   );

   static $searchable_fields = array (
      'Season.ID' => array(
         'title' => 'Season'
      )
   );

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

      $fields->addFieldToTab("Root.Main", new TextField('Place', 'Place'));
      $fields->addFieldToTab("Root.Main", new TextField('Prize', 'Prize'));
      $fields->addFieldToTab("Root.Main", new TextField('Bowler', 'Bowler'));
      $fields->addFieldToTab("Root.Main", new TextField('Series', 'Series'));
      $fields->addFieldToTab("Root.Main", new TextField('Average', 'Average'));
      $fields->addFieldToTab("Root.Main", new TextField('Handicap', 'Handicap'));
      $fields->addFieldToTab("Root.Main", new TextField('Game1', 'Game1'));
      $fields->addFieldToTab("Root.Main", new TextField('Game2', 'Game2'));
      $fields->addFieldToTab("Root.Main", new TextField('Game3', 'Game3'));
      $fields->addFieldToTab("Root.Main", new TextField('Game4', 'Game4'));

      // Season
      $Season = DataObject::get('SeasonPage');
      $fields->addFieldToTab("Root.Season", new CheckboxsetField('Season', 'Season', $Season));

return $fields;
}
}

It belongs many many to SeasonPage.

class SeasonPage extends Page
{
   static $many_many = array(
      'Standings' => 'Standing'
   );

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

class SeasonPage_Controller extends Page_Controller
{
   //Return the list of standings for this season
   public function getStandingsList()
   {
      return $this->Standings(Null, 'Place ASC');
   }
}

What I need is to upload a csv file containing each seasons standings. This seems to work fine except that the standings are not relating to a SeasonPage. If I manually relate the standings to a season then export a csv it shows 2012[] in the Season column. But if I try to import a csv with 2012[] in the Season column the standings don't relate to a SeasonPage.
Any help would be greatly appreciated.

Posted to: [SOLVED] Data object belongs_many_many, no relation after csv import | Show Thread | Post Reply

Re: [SOLVED] 500 Error: "Uncaught Exception: Object->__call(): the method 'parent' does not exist on...

_Vince — Tue, 03 Apr 2012 15:26:03 +1200

Sorted.

Rather than a Page(), I should have tried to create a TrainerPage()

Posted to: [SOLVED] 500 Error: "Uncaught Exception: Object->__call(): the method 'parent' does not exist on... | Show Thread | Post Reply

[SOLVED] 500 Error: "Uncaught Exception: Object->__call(): the method 'parent' does not exist on...

_Vince — Mon, 02 Apr 2012 08:49:34 +1200

I'm having a bit of a problem with this.

Basically, I want to have a dataobject, "Trainer". Each trainer has their own page on the site. The trainers must be able to log in, so I thought to extend the Member class.

When the Trainer record is created, a Page would be created for the trainer as well. And yet, I can't get it to work. I always get

ERROR [User Error]: Uncaught Exception: Object->__call(): the method 'parent' does not exist on 'TrainerPage'
IN POST /allactive/admin/Data/Trainer/16/EditForm?action_doSave=Save
Line 724 in /var/www/allactive/sapphire/core/Object.php

Can anybody tell me what I've done wrong?

Here's the code for TrainerPage.

<?php
class TrainerPage extends SiteTree{
   static $has_one = array(
      "Trainer" => "Trainer"
   );
}

class TrainerPage_Controller extends Page_Controller{

}

and Trainer:

<?php
class Trainer extends Member{

   static $db = array(
      "TR_LandlineNumber" => "Varchar(20)",
      "TR_MobileNumber" => "Varchar(20)",
      "TR_Notes" => "Text"
   );

   static $has_one = array(
      "TR_Area" => "Area",
      "TR_Region" => "Region"
   );

   static $has_many = array(
      "Client" => "Client"
   );

function getCMSFields() {

$sqlQuery = new SQLQuery(array("ID", "AreaDescription"), "Area");
$AreaMap = $sqlQuery->execute()->map();

$sqlQuery = new SQLQuery(array("ID", "RegionDescription"), "Region");
$RegionMap = $sqlQuery->execute()->map();

$fields = parent::getCMSFields();
$fields->RemoveFieldFromTab( 'Root.Main', "DateFormat");
$fields->RemoveFieldFromTab( 'Root.Main', "TimeFormat");
$fields->RemoveFieldFromTab( 'Root.Main', "TR_AreaID");
$fields->RemoveFieldFromTab( 'Root.Main', "TR_RegionID");
$fields->RemoveFieldFromTab( 'Root.Main', "TR_Notes");
$fields->RemoveFieldFromTab( 'Root.Main', "TR_LandlineNumber");
$fields->RemoveFieldFromTab( 'Root.Main', "TR_MobileNumber");

$fields->addFieldToTab( 'Root.Main', new TextField("TR_LandlineNumber", "Landline Number"));
$fields->addFieldToTab( 'Root.Main', new TextField("TR_MobileNumber", "Mobile Number"));
$fields->addFieldToTab( 'Root.Main', new TextareaField("TR_Notes", "Notes"));
$fields->addFieldToTab( 'Root.Main', new ListboxField("TR_RegionID", "Region", $RegionMap));
$fields->addFieldToTab( 'Root.Main', new ListboxField("TR_AreaID", "Area", $AreaMap));

return $fields;
   }

   function onBeforeWrite(){

      // TODO: check if the page already exists

      parent::onBeforeWrite();

      $newTrainerPage = new Page();
      $newTrainerPage->ClassName = "TrainerPage";
      $newTrainerPage->Created = time();
      $newTrainerPage->LastEdited = time();
      $newTrainerPage->Title = $this->Surname . " " . $this->FirstName;
      $newTrainerPage->URLSegment = strtolower($this->Surname . "-" . $this->FirstName);
      $newTrainerPage->ShowInMenus = 1;
      $newTrainerPage->ShowInSearch = 1;
      $newTrainerPage->CanEditType = "Inherit";
      $newTrainerPage->CanViewType = "Inherit";
      $newTrainerPage->Status = "Published";
      $ID = $newTrainerPage->write();

$newTrainerPage->publish("Stage", "Live");

}
}

Posted to: [SOLVED] 500 Error: "Uncaught Exception: Object->__call(): the method 'parent' does not exist on... | Show Thread | Post Reply

Re: has_one and has_many relationship saving in a CTF

danzzz — Sun, 01 Apr 2012 23:14:36 +1200

do you mean, you create an event, and then without saving add the dates and then save?
I think SS should handle that for you.

if not you can use on BeforeWrite function ... for example I use the following function to save the Parents ParentID.

function onBeforeWrite() {

      $r = DB::query("SELECT ParentID FROM SiteTree WHERE ID = ".$this->ParentID);
      $this->CityPageID = $r->value();

      parent::onBeforeWrite();

   }

Posted to: has_one and has_many relationship saving in a CTF | Show Thread | Post Reply

has_one and has_many relationship saving in a CTF

copernicus — Fri, 30 Mar 2012 03:48:11 +1300

I have an Event dataobject and a DateTime dataobject. The Event has a $has_many for "Showtimes" => "DateTime" and the DateTime has a $has_one for "Event" => "Event". I have these in a CTF in ModelAdmin. Right now I can create a new Event and if I add the Event then add DateTimes, everything works. The DateTimes get the EventID field populated correctly because the Event already exists in the database.

In the more likely case, a user will create a new Event, add a title, etc... then try to add some DateTimes. Since the Event does not exist in the database, there is no ID to populate EventID in the DateTimes so it gets set to 0.

Should Silverstripe handle this automatically? Is there any way to have it so the user does not need to add an Event before adding DateTimes?

Posted to: has_one and has_many relationship saving in a CTF | Show Thread | Post Reply

Re: Adding Comments to DataObjects

Willr — Wed, 28 Mar 2012 19:19:12 +1300

The comments module is live and working in 3.0 (apart from moderation and ajax posting) but not sure what you mean by integrate with the wordpress blog comments? There's currently no importer or exporter for comments and nothing on the roadmap for it.

Posted to: Adding Comments to DataObjects | Show Thread | Post Reply

Re: Adding Comments to DataObjects

PokerVIP — Wed, 28 Mar 2012 06:03:43 +1300

Any updates on this? Would love to be able to differentiate between data objects.

We currently have wordpress blogs on our site - could the new comments system for Silverstripe 3.0 be easily integrated with this or would it require a messy work around?

How long a wait are we looking at?

Posted to: Adding Comments to DataObjects | Show Thread | Post Reply

Re: jquerymobile Weirdness - editor issue

bembo99 — Wed, 28 Mar 2012 04:50:03 +1300

I can verify that I have the same troubles as tazzy.

Seems the base href default functionality in SilverStripe is rather limiting in this case. I'm not sure how to get around the issue, without major overhauls to the way the WYSIWYG outputs file paths.

Any ideas anyone?

Posted to: jquerymobile Weirdness - editor issue | Show Thread | Post Reply

Filtering a DataObjectSet by range query?

NicoHaase — Sat, 24 Mar 2012 04:20:07 +1300

Hi,
we are developing a website with SS 3 and selfwritten DataObjects. One of them holds two dates, marking a start date and an end date for events. Somehow, we need to filter the whole set of DataObjects to receive all currently active eventy (such that start date < current date < end date). The given filter() function can only compare using equality, but not ranges... Is the only way to solve this using completely a selfwritten query?
Sunny greetings
Nico

Posted to: Filtering a DataObjectSet by range query? | Show Thread | Post Reply

Re: Unit Tests and Model Building

Willr — Fri, 23 Mar 2012 19:29:53 +1300

You could try the ?flush with your test runner - dev/tests/all?flush=all. If that doesn't work I'd double check you aren't referencing that code anywhere. What's the error message?

Posted to: Unit Tests and Model Building | Show Thread | Post Reply

Disable publish button?

Bundschuh — Fri, 23 Mar 2012 05:35:54 +1300

Is it possible to disable the publish button in the cms for a page?

Reason for that is, that i don't want specific pages to be published because they are only used as entries for the parent page.
This means also that these entries resp. pages should not be callable showed in the browser by url.

Greetings
Bundschuh

Posted to: Disable publish button? | Show Thread | Post Reply

Trouble adding has_many children

sdc395 — Fri, 23 Mar 2012 03:23:30 +1300

Hi all

Bit of a newbie question, I'm sure, but I just can't find a solution to this problem. I suspect it's something I'm doing wrong but...

OK, I have a parent class with a has_many relationship with a child class. SilverStripe/Sapphire creates the tables correctly but I'm not able to insert any child objects into the database using SS. The steps I'm expecting to work for me are...

1. create new Parent object
2. get Children component set
3. create Child objects and use add() to add them to Children
4. call write() on Parent to write Parent and Children to database

I'm not getting any error messages that I can find but nor am I getting any Child objects inserted into the database. I've done my best to find useful example code, read the documentation, etc. but I'm just stuck.

Could someone please point me at a complete example of achieving the above or highlight where I'm going wrong?

Thanks in advance
Simon

Posted to: Trouble adding has_many children | Show Thread | Post Reply

Re: Unit Tests and Model Building

mikelbring — Fri, 23 Mar 2012 02:33:16 +1300

I am actually running the tests in my browser, so is there a flush that I need to do for the tests via the browser besides `/dev/build/?flush=all` ?

Posted to: Unit Tests and Model Building | Show Thread | Post Reply

Re: Unit Tests and Model Building

Willr — Thu, 22 Mar 2012 18:47:59 +1300

Are you running the tests via cli? If so then you need to also flush that. SilverStripe mantains 2 caches, a web cache and a cli one. So you if you a flush=all in a webbrowser it doesn't clear the cli version.

Via sake you can do sake dev/tests/all flush=all

Posted to: Unit Tests and Model Building | Show Thread | Post Reply

Unit Tests and Model Building

mikelbring — Thu, 22 Mar 2012 10:16:46 +1300

I renamed a model file and do a `/dev/build/?flush=all` and it works fine for the live site, however my unit tests still want to load the old model file, although I am not using this model anywhere on the live site or in my unit tests. Do I need to run a separate build for unit tests? I cannot find anything regarding this.

Posted to: Unit Tests and Model Building | Show Thread | Post Reply

Decorating DataObjectSet?

fatlewis — Sat, 10 Mar 2012 05:35:46 +1300

Hey, this is my first post so be nice!

A site that I've been working on has portfolio pieces stored as DataObjects, each with a relevant image. These are getting pulled to the template and shown in a widget, but the aim has been to show a random 4 logos, rather than 4 from a specifically sorted set.

Being somewhat averse to using mySQL's "RAND()" function in a query, I figured the best way of doing it would be to initialize the full set of DataObjects and then use a shuffle function (which for some reason isn't in the core DataObjectSet class). Unfortunately decorating the class and using:

public function Shuffle() {
shuffle($this->owner->items);
}

Throws up the error:

[Notice] Indirect modification of overloaded property DataObjectSet::$items has no effect

I wondered if anyone could explain why this was and how one would go about decorating the class correctly (if at all)?

(FYI, I managed to achieve what I wanted by extending DataObjectSet, but wondered why decorating wasn't working)

Cheers!

Posted to: Decorating DataObjectSet? | Show Thread | Post Reply

Re: Duplicate page should duplicate and link dataobjects

max5k — Wed, 07 Mar 2012 10:59:57 +1300

yes, exactly. it just checks for the key of the relationship.

glad, if that works for you.

be careful in any production environment, though.
as this is not too much tested yet

i thought something like that would also be a nice core feature,
so that you could have

public static $relations_to_copy = array(
'myImages',
'myGeoObjects'
);

on any Page ?

..just my 2 cents.

Posted to: Duplicate page should duplicate and link dataobjects | Show Thread | Post Reply

Re: Duplicate page should duplicate and link dataobjects

Nobrainer Web — Tue, 06 Mar 2012 21:25:11 +1300

So for instance if i have

public static $has_many = array(
'Images' => 'Image',
'Employees' => 'DataObject'
);

then i should use

$items_to_duplicate = array(
'Images',
'Employees' //anything you want to duplicate
);

Or?

Posted to: Duplicate page should duplicate and link dataobjects | Show Thread | Post Reply

Re: Duplicate page should duplicate and link dataobjects

max5k — Tue, 06 Mar 2012 21:19:45 +1300

you might want to add a filter, which relations to duplicate
the above version does a little too much in some cases...

public function duplicate() {

$items_to_duplicate = array(
'Images' //anything you want to duplicate
);

$page = parent::duplicate();

//duplicate has many items
foreach ($this->has_many() as $key => $className) {
if (in_array($key, $items_to_duplicate)) {
foreach ($this->{$key}() as $item) {
$newField = $item->duplicate();
$id = get_class($this) . 'ID';
$newField->{$id} = $page->ID;
$newField->write();
}
}
}

//duplicate many_many items
foreach ($this->many_many() as $key => $className) {
if (in_array($key, $items_to_duplicate)) {
$page->{$key}()->addMany($this->{$key}()->getIdList());
}
}

return $page;
}

Posted to: Duplicate page should duplicate and link dataobjects | Show Thread | Post Reply

Re: Duplicate page should duplicate and link dataobjects

Nobrainer Web — Tue, 06 Mar 2012 20:55:47 +1300

Thank you so much for posting this max5k, this has gone in to my SilverStripe package that i put on all new sites.
So usefull!

Posted to: Duplicate page should duplicate and link dataobjects | Show Thread | Post Reply

Re: Duplicate page should duplicate and link dataobjects

max5k — Tue, 06 Mar 2012 11:19:37 +1300

great, thanks for that one.

this is what i ended up with:

duplicate all has_many and many_many relationships of a page dynamically...:

public function duplicate() {

$page = parent::duplicate();

//duplicate has many items
foreach ($this->has_many() as $key => $className) {
foreach ($this->{$key}() as $item) {
$newField = $item->duplicate();
$id = get_class($this) . 'ID';
$newField->{$id} = $page->ID;
$newField->write();
}
}

//duplicate many_many items
foreach( $this->many_many() as $key => $className ){
$page->{$key}()->addMany($this->{$key}()->getIdList());
}

return $page;
}

cheers

Posted to: Duplicate page should duplicate and link dataobjects | Show Thread | Post Reply

Re: Problem creating TreeMultiselectField to look up Page

Bureau Berg — Tue, 06 Mar 2012 03:05:25 +1300

@All, Thanks for sharing.

@Aaron, Did you got any solution to make this work with TreeMultiselectField custom page list?

my code is working great with "CheckboxSetField". But not working with TreeMultiselectField in case of custom page list "NewsPage".

My working Code with "CheckboxSetField":
------------------------------------------------------------
public static $many_many = array(
"FeaturedArticle"=>"NewsPage",
);

public function getCMSFields() {

      $fields = parent::getCMSFields();
      $pageList = DataObject::get('NewsPage');

$f = parent::getCMSFields();
$f->addFieldsToTab("Root.Content.FeaturedArticle", array(
new CheckboxSetField("FeaturedArticle", "Choose a your featured article:", $pageList),
));

return $f;
}
------------------------------------------------------------

Though when I use "TreeMultiselectField " this with "SiteTree" it works.

working Code with SiteTree is :

   public static $many_many = array(
      "FeaturedArticle"=>"SiteTree",
   );

public function getCMSFields() {

$f = parent::getCMSFields();
$f->addFieldsToTab("Root.Content.FeaturedArticle", array(
new TreeMultiSelectField("FeaturedArticle", "Choose a your featured article:", "SiteTree"),
));

}

Any idea why it is not working with "NewsPage" class in TreeMultiselectField ?

Posted to: Problem creating TreeMultiselectField to look up Page | Show Thread | Post Reply