Re: Listing 2 DataObjectSets

martimiz — Sun, 12 Feb 2012 01:06:12 +1300

What you are doing should work - at least within your getRewardRedemptions function itself. Did you do a var_dump there, or a foreach echo?

What does your template look like? (the bit that handles getRewardRedemptions)?

Posted to: Listing 2 DataObjectSets Show Thread | Post Reply

Listing 2 DataObjectSets

eceers — Sat, 11 Feb 2012 19:52:10 +1300

Howdy, I have created 2 DataObjects Rewards and Redemptions. I would like to display them on a single list sorted by their created field.

Here is the code doing the work;

function getRewardRedemptions() {
$doSet = new DataObjectSet();

   if($Rewards = DataObject::get('Rewards',"MemberID={$this->Member->ID}")) {
      $doSet->merge($Rewards);
   }
   if($this->Member && $Redemptions = DataObject::get('Redemptions',"MemberID={$this->Member->ID}")) {
      $doSet->merge($Redemptions);
   }
   $doSet->Sort('Created');

   return $doSet;
}

It all works a-ok with one small hick up the list is grouping the Objects. So all the rewards and the redemptions are sitting together. What I would like to happen is the rewards and redemptions to be intertwinned.

I'm pretty certain there is one little tweak I need to make so it all falls into place.

Any help would be greatly appreciated.

Posted to: Listing 2 DataObjectSets Show Thread | Post Reply

Re: Make DOs searchable (Fulltextsearch)

Juanitou — Fri, 10 Feb 2012 21:46:42 +1300

Hi!

There are some threads elsewhere, try searching a bit more, but it’s a difficult subject. I have only managed to make it work, and with some limitations, thanks to the custom_search module:
http://www.silverstripe.org/form-questions/show/18547

A promising new module has been recently published, but I haven’t used it yet:
http://www.silverstripe.org/all-other-modules/show/19083

Hope it helps,
Juan

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

Make DOs searchable (Fulltextsearch)

Pipifix — Fri, 10 Feb 2012 07:59:46 +1300

Hi everybody,

I got two different dataobjects (projects, staff) not related to each other. Both got titles and decriptions. So i wanna make these titles and desc. searchable by the silverstripe buildin fulltextsearch. How to connetc the DO and the search. Despite of searching the forum i found no solution. Is there a tutorial or a nice snippet to get this done?

Thanks for help. Pipifix

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

Re: Unit Test for DataObjectDecorator

Willr — Thu, 09 Feb 2012 23:09:20 +1300

As I said, they're applied transparently so if you create a function Foo() calling Foo() on a member class would work.

//
class MemberDecorator extends DataObjectDecorator {
function Foo() { return "hi"; }
}
//
DataObject::add_extension('Member', 'MemberDecorator');
//

$member = Member::currentUser();
echo $member->Foo(); // "hi";

Posted to: Unit Test for DataObjectDecorator Show Thread | Post Reply

Re: Unit Test for DataObjectDecorator

juergr — Thu, 09 Feb 2012 08:44:39 +1300

But how can I call a Method on the Decorator?

If i have a MemberDecorator->doSomethingImportant() function, how do i call this function thru the Member class as i would during normal developement?

Can you make a little example, because i realy don't get it. (Sometimes i'm a little dumb...)

Posted to: Unit Test for DataObjectDecorator Show Thread | Post Reply

Re: Unit Test for DataObjectDecorator

Willr — Wed, 08 Feb 2012 21:12:45 +1300

Is there a way to tell the Saphire test that the Member Object is Decorated with another Object?

Decorators are applied transparently so you have to test again member directly (ensuring of course your decorator is added). You can see what extensions are applied to what object using the methods on object - http://api.silverstripe.org/2.4/sapphire/core/Object.html.

Posted to: Unit Test for DataObjectDecorator Show Thread | Post Reply

Unit Test for DataObjectDecorator

juergr — Wed, 08 Feb 2012 09:04:03 +1300

How do I write Unit Tests for DataObjectDecorators? I have a MemberDecorator which adds a lot of functionality and information to the member object and now i want to test these functions.

But when i try to call a function of the MemberDecorator i get a error "undefined method" on member.

Is there a way to tell the Saphire test that the Member Object is Decorated with another Object?

Posted to: Unit Test for DataObjectDecorator Show Thread | Post Reply

Site search using page tags

NETim — Thu, 02 Feb 2012 22:50:51 +1300

Hi,

I have been trying to put together a search system that will search for pages that have been given certain tags.

The basic principle is that I have a type of page that can have any number of tags applied to it. The tags are controlled through modelAdmin so we build up a list of tags that could be applied to any of the tagable page types. What I am trying to achieve is the ability to search for pages which match all of the selected tags.

For example:

We have multiple pages for cars which have tags based on the car they are describing:

car page 1 tags: Red, 4 wheels, Soft top

car page 2 tags: Blue, 4 wheels, soft top, fast

car page 3 tags: Blue, 4 wheels, slow

on our search page we would have a list of all of the unique tags as checkcboxes so that the user could find a car that matches their needs:

tags:
Red,
Blue,
4 wheels,
soft top,
fast,
slow

My intention is that if a user searched for the tags Blue and 4 wheels, they would see cars 2 and 3. If they then added 'fast' they should only see car 2.

Any ideas?

Thanks,

Posted to: Site search using page tags Show Thread | Post Reply

Re: SOAPModelAccess / Content-Type of response

saviolan — Thu, 02 Feb 2012 08:31:56 +1300

search in the following link , it may help u

http://csharp.net-informations.com/communications/csharp-communications-tutorial.htm

savs.

Posted to: SOAPModelAccess / Content-Type of response Show Thread | Post Reply

Re: Getting DataObjects with NULL values

NicolasLeuenberger — Fri, 20 Jan 2012 23:08:26 +1300

Jackpot!

Wow, that was fast and the perfect answer. Thanks so much

Posted to: Getting DataObjects with NULL values Show Thread | Post Reply

Re: Getting DataObjects with NULL values

swaiba — Fri, 20 Jan 2012 23:06:35 +1300

how about "Date IS NULL" I think that is how MYSQL does it

Posted to: Getting DataObjects with NULL values Show Thread | Post Reply

Getting DataObjects with NULL values

NicolasLeuenberger — Fri, 20 Jan 2012 23:00:48 +1300

Hi dear community

One of my models is an event (AgendaEintrag) with a DateField. If no date is set, the MySQL-Entry contains the value NULL. Now I'd like to display all Events without a date. This does not work:

$agendaEintraege = DataObject::get("AgendaEintrag", "Date=NULL", "Date ASC");

If I search for anything else, it works. I can for example display past events:

$agendaEintraege = DataObject::get("AgendaEintrag", "Date=<CURDATE()", "Date ASC");

Any idea how I can get those NULL containing entries? Thanks

Posted to: Getting DataObjects with NULL values Show Thread | Post Reply

Re: Large number of files - are there plans to fix this?

Darren Inwood — Fri, 20 Jan 2012 16:30:08 +1300

Thanks Willr, I'll have to have a squiz through the ORM stuff for 3.0 and see if there's anything in there for really large dataobjectsets.

Posted to: Large number of files - are there plans to fix this? Show Thread | Post Reply

Re: Large number of files - are there plans to fix this?

Willr — Fri, 20 Jan 2012 16:13:22 +1300

Are there any plans to move operations like these to offline processes?

I had a look through the road map and can't see anything like this planned, couple performance related tickets (e.g http://open.silverstripe.org/ticket/6534)

Posted to: Large number of files - are there plans to fix this? Show Thread | Post Reply

Re: Large number of files - are there plans to fix this?

swaiba — Wed, 18 Jan 2012 23:21:33 +1300

If you didn't get a response and this is so urgent I'd raise it as a critical issue ont he open.silverstripe.org and hang out in NZ time on IRC to catch a silverstripe person to address this.

Posted to: Large number of files - are there plans to fix this? Show Thread | Post Reply

Re: Large number of files - are there plans to fix this?

Darren Inwood — Wed, 18 Jan 2012 14:29:49 +1300

This is about to cost us a major customer, can anybody at SilverStripe comment on whether or not any changes to the way Files are processed are planned?

Posted to: Large number of files - are there plans to fix this? Show Thread | Post Reply

Re: formatting date on results of custom query?

johnofjack — Tue, 17 Jan 2012 10:08:33 +1300

After dropping this for weeks, I went back to work on it today and finally figured it out.

This page had the info I needed.

Posted to: formatting date on results of custom query? Show Thread | Post Reply

DataObject::get() returns NULL when no records are found?

GuillaumeC — Mon, 16 Jan 2012 10:35:40 +1300

Hi everyone,

I'm not sure I fully understand all the inners of DataObject yet, but I'm surprised to see that executing DataObject::get() with a filter that returns no record returns nothing, rather than an empty DataObjectSet. Is this normal?

Example:

// assuming that the database contains no record which Date > CURDATE()

$news_articles = DataObject::get("NewsArticle", "Date > CURDATE()");
return $news_articles; // This returns NULL.

Thanks for your help!

Posted to: DataObject::get() returns NULL when no records are found? Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

swaiba — Sat, 14 Jan 2012 05:25:11 +1300

I like to help out where I can

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

NETim — Sat, 14 Jan 2012 05:03:37 +1300

Thanks,

That was a remarkably fast response.

Worked a charm. The CRM section now works as planned.

Thanks,

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

swaiba — Sat, 14 Jan 2012 04:56:23 +1300

   function getCMSFields() {
      $fields = parent::getCMSFields();
      $fields->removeByName('FIELDNAMEHERE');

return $fields;
}

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

NETim — Sat, 14 Jan 2012 04:51:36 +1300

Thanks,

You raise a good point.

My next issue would have been disabling the fields anyway. This way seems simpler. Less points at which it could go wrong.

Cheers,

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

swaiba — Sat, 14 Jan 2012 00:27:57 +1300

use getCMSFields
but I hide them - that way it doens't even give the user the ilusion they can modifiy it
and ensure you always get teh right memberid/created date instead of the one they want to add

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

NETim — Sat, 14 Jan 2012 00:12:39 +1300

Thanks,

That handles the after insertion part.

Any ideas on pre-populating those values when adding the note? The fields are editable when you add a new note and my intention is to have them set with the values to begin with.

If it's not possible then I can always go with hiding them from the form and just set them in the background.

Thanks

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

swaiba — Fri, 13 Jan 2012 22:30:16 +1300

the onBeforeWrite is a function to be placed in your Notes DataObject.
to see the created date (that the system writes automatically) this will help...

http://www.silverstripe.org/data-model-questions/show/18942

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

NETim — Fri, 13 Jan 2012 22:27:23 +1300

swaiba,

Thanks.

I had seen a few people mention the date fields but haven't had any success in using them.

With the function you listed, how would it be called in the context of ModelAdmin. Would I need to call it or would it be called when saving a record?

The basic idea of what I am trying to achieve is thus:

- A visitor to the site fills in the contact form
- When they submit the form, the values from the form are stored as 'SubmittedForm'
- In the CMS there is a new ModelAdmin which manages the 'SubmittedForm' model
- each 'SubmittedForm' then has many 'Notes'
- each 'Note' should have: 'Content', 'CreatedDate' and 'MemberName'

The only part of this that is not working as I intended is pre-populating the 'Date' and 'MemberName' fields in the pop-up when a user adds a new 'Note'.

The reason I am trying to pre-populate is to ensure the integrity of the data, so that we can be sure of exactly when, and by whom, the note was added without having to trust the user not to have entered false data.

Thanks

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Using SQL BETWEEN and AND together in DataObject::get

subvert — Fri, 13 Jan 2012 09:04:02 +1300

Greets,

I am trying to return "Appointment" DataObjects in the morning in one function, and then in the afternoon in another. It's throwing an error due to the double "and"'s in the statement. I have never used BETWEEN before in SS.

DataTypes being used are Date and Time.

Any pointers greatly appreciated.

Posted to: Using SQL BETWEEN and AND together in DataObject::get Show Thread | Post Reply

Re: Setting dynamic default values with ModelAdmin

swaiba — Fri, 13 Jan 2012 06:27:17 +1300

Hi NETim,

Welcome to the forums!

I don't really follow...

The 'note' field works fine, as do the 'Date' and 'Member' fields. The problem comes when I try and set default values for the last 2 fields

are date and member the last two fileds?

first date is superflous because every record has a created and lasted edited field within it.
second the Member could be addin like follows..

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

$this->MemberID = Member::currentUserID();
}

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: DataObjectSet in DataObject

ivo — Fri, 13 Jan 2012 05:21:42 +1300

Yes you can!

You just have to take care to assign it to the right variable! gosh
Im Sorry

Posted to: DataObjectSet in DataObject Show Thread | Post Reply

DataObjectSet in DataObject

ivo — Fri, 13 Jan 2012 05:11:58 +1300

Hi,
can i set a DataObjectSet in a Dataobject?

...
$list = new DataObjectSet();
foreach ($dates as $d => $data) {
$do = new DataObject();
$do->Date = $d;
$do->Total = $data;
$list->push($do);
}

$DO->DatesList = $list;
return $DO;
...

and in the template call it via a nested control:

<% control DO %>
<div>
$ID
<% control DatesList %>
$Date $Total
<% end_control %>
<hr/>
</div>
<% end_control %>

Well i tried it but it doesnt seem to work.

Is there a alternative way to achieve something like that?

Posted to: DataObjectSet in DataObject Show Thread | Post Reply

Re: $ClassName on translatable pages not updated after pagetype change [SOLVED]

balder — Thu, 12 Jan 2012 02:55:50 +1300

How stupid can a man be? I just forgot to SAVE & PUBLISH the updated tranlated pages :\
Sorry for wasting you time.

Posted to: $ClassName on translatable pages not updated after pagetype change [SOLVED] Show Thread | Post Reply

Setting dynamic default values with ModelAdmin

NETim — Thu, 12 Jan 2012 01:53:34 +1300

Hi,

Been fighting with this for a little while now.

I have put together a very basic CRM in SS using ModelAdmin where the details from a contact form are stored in the DB and shown under a tab section called CRM. What I'm trying to do with it now is to add a notes section where multiple notes can be stored with the date they were added and the member that added them.

The 'note' field works fine, as do the 'Date' and 'Member' fields. The problem comes when I try and set default values for the last 2 fields.

I have dug around the forums and a host of other sites for this and can't find anything about doing this with ModelAdmin.

Any help would be great.

Posted to: Setting dynamic default values with ModelAdmin Show Thread | Post Reply

Re: print array ,another problem

Silverfish — Thu, 12 Jan 2012 00:56:45 +1300

Hi snaip,

assuming that you create the array() within an Model extending Page / SiteTree I guess I would create a DataObjectSet (http://api.silverstripe.org/2.4/sapphire/model/DataObjectSet.html) and return it to the Template. There you can loop it as a control.

Besides that I think that you should try to get this DataObjectSet directly from DB, without writing it into an array first and than back. Also I would try to get the Set with just one request. Doing DB-Requests (DataObject::get()) within a loop are not ideal for system performance and can be usually replaced by a single one (that's what databases live for ;)).

Regards
SF.

Posted to: print array ,another problem Show Thread | Post Reply

print array ,another problem

snaip — Wed, 11 Jan 2012 22:36:26 +1300

i cant find any solution for my problem (probably pretty easy)

i have an array

$array = array();

$data = DataObject::get('ModulKalendariumRok');
foreach ($data as $row) {
$data = DataObject::get('ModulKalendarium', "Rok = '$row->Rok'");
foreach ($data as $row) {
$array['Kalendarium'][$row->Rok][] = $row->Wydarzenie;
}
}

return new ArrayData($array);

>>>>>> print_r($array) >>>>>>

Array
(
[Kalendarium] => Array
(
[2011] => Array
(
[0] => test 2011
[1] => test v2 2011
)

[2010] => Array
(
[0] => test 2010
)

)

how to display it in the template to getting something like this:

2011
- test 2011
- test v2 2011

2010
- test 2010

Posted to: print array ,another problem Show Thread | Post Reply

Re: Show Created date in model admin lists

swaiba — Wed, 11 Jan 2012 22:24:52 +1300

   public static $summary_fields = array (
      'CreatedText',
   );

static $casting = array("CreatedText" => "Text");

   public function CreatedText() {
      return $this->Created;
   }

(note:untested)

Posted to: Show Created date in model admin lists Show Thread | Post Reply

Re: Show Created date in model admin lists

smartfaceweb — Wed, 11 Jan 2012 16:28:00 +1300

Are you able to provide an example?

All I am looking to do is show the Created and LastEdited columns in a model admin search results table.

Posted to: Show Created date in model admin lists Show Thread | Post Reply

$ClassName on translatable pages not updated after pagetype change [SOLVED]

balder — Wed, 11 Jan 2012 06:20:02 +1300

Title says it all... i just updated a website by creating a new page type for a set of pages: when i switch to the new page type in the main language, i can see everything gets updated on the tranlated pages as well (note that in the backend the dropdown for the pagetype in the translated pages is greyed out, and shows the new pagetype name) which seems perfect. BUT when i actually go to the frontend, the translated pages still show the old layout. And printing the $ClassName shows the old one as expected.
Am i missing something, is there a bug, or maybe i just did something wrong (but i cannot figure what, when or where!)
Thanks for any help!

Posted to: $ClassName on translatable pages not updated after pagetype change [SOLVED] Show Thread | Post Reply

Re: Show Created date in model admin lists

swaiba — Tue, 10 Jan 2012 04:32:50 +1300

I use casting for this...
http://doc.silverstripe.org/sapphire/en/topics/datamodel#casting

Posted to: Show Created date in model admin lists Show Thread | Post Reply

Show Created date in model admin lists

smartfaceweb — Mon, 09 Jan 2012 23:08:13 +1300

How do i do this, I have tried adding 'Created' to the $summary_fields array.

Posted to: Show Created date in model admin lists Show Thread | Post Reply

Escaping commas in Enum()

mikhail — Thu, 29 Dec 2011 11:52:24 +1300

"Enum('Value1, Value2, Value3')"

But what if I wanted:

"Enum('Value 1, and some Value 2', 'Value 2, and a little bit of Value 7', 'Value3, cake and pie')"

As far as I can tell there's no easy way to do this. I have tried escaping the commas in one string, tried passing it as multiple strings (which of course didn't work), even created this field with , ASCII commas in the hopes that it would write to DB in the raw format, but output in the proper encoding. This was probably the closest attempt at faking this, but the front-end fields are actually just outputting , as raw text.

Feel free to ignore this, it's more of an aesthetics question, I have for now replaced the commas with + that should hopefully carry the same meaning.

Posted to: Escaping commas in Enum() Show Thread | Post Reply

DataObject::get with Translatable ON - SiteTree/Page difference.

pali — Thu, 29 Dec 2011 03:25:01 +1300

Hello,

im using this really simple setup, but im surprised with odd behaviour.

This code will return only localized pages:

return DataObject::get("SiteTree");

this is returning all pages - doesn't care about locale:

return DataObject::get("Page");

SS version:
SS 2.4.6

mysite/_config.php:

Translatable::set_default_locale('en_US');
Object::add_extension('SiteTree','Translatable');
Object::add_extension('SiteConfig','Translatable');
Translatable::set_allowed_locales(array('en_US','ru_RU'));

mysite/code/Page.php >> Page_Controller:

...

public function init() {

      parent::init();

      if($this->dataRecord->hasExtension('Translatable')) {
         i18n::set_locale($this->dataRecord->Locale);
         setlocale(LC_TIME, $this->dataRecord->Locale . ".utf8");
      }
...
}

...

Is this standard behaviour?

Regards

Pali

Posted to: DataObject::get with Translatable ON - SiteTree/Page difference. Show Thread | Post Reply

Re: formatting date on results of custom query?

Mitchell — Tue, 27 Dec 2011 20:45:27 +1300

Useful Discussion

Posted to: formatting date on results of custom query? Show Thread | Post Reply

Re: formatting date on results of custom query?

johnofjack — Mon, 26 Dec 2011 03:32:46 +1300

I experimented with this at length, couldn't get it to work, decided to leave it alone awhile, came back to it, still can't get it to work.

Posted to: formatting date on results of custom query? Show Thread | Post Reply

DataObject partial translation

dreadman — Sat, 24 Dec 2011 05:15:24 +1300

hey there,

I'm working on a small Google Maps project at the moment. This involves a lot of DataObjects representing markers on my map. Of course by translating the page in other languages the coordinates of my markers stay the same. So I figured out an imo simple way for an universal method for the partial translation of my DataObjects. There are still some small problems, but for now I just want to know what you guys think about it and what could be done better. I'm far away from being a pro, so there will be space for improvements, thats for sure ;)

Right, here is what I did.

At first I created an basic object which holds the language and the relationship to the DataObject, that will be partly translatable.

class TranslatedObjectPart extends DataObject
{
static $db = array (
'Lang' => 'Varchar(10)'
);

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

public function getCMSFields() {
$allowedLang = Translatable::get_allowed_locales();
if (empty($allowedLang))
$allowedLang[] = i18n::default_locale ();
$langs = array_combine($allowedLang, $allowedLang);

return new FieldSet(
new DropdownField('Lang', 'Sprache', $langs)
);
}
}

Then I have an object, which actually holds one (or possibly more) parts, which can be created in every language you get from Translatable::get_allowed_locales(). The thing I like is that basicly you can translate any data type, not only text. For example you could add a has_one relation to an Image or any other DataObject. I hope you know, what I mean ;)

class TranslatedText extends TranslatedObjectPart
{
static $db = array (
'Text' => 'Text'
);

public function getCMSFields() {
$f = parent::getCMSFields();
$f->insertAfter(new TextareaField('Text'), "Lang");
return $f;
}
}

After that I made a base class for any DataObject, which should be partially translated. This class is very simple, it just deletes all of it8s (partial) translations before it gets deleted.

class TranslatableDataObject extends DataObject {
function onBeforeDelete() {
parent::onBeforeDelete();
$translations = DataObject::get("TranslatedObjectPart", "TranslatableDataObjectID = $this->ID");
foreach ($translations->toArray() as $tran)
$tran->delete();
}
}

Finally, my object which gets translated. I was surprised that you can insert a DataObjectManager into a popup, which itself ist opened by a DOM from a Page, but it works Now I can add translations for the Title, while the rest stays the same. Using TitleInCurrentLang() I get the translation of the Title or the normal Title as fallback.

class MyDataObject extends TranslatableDataObject
{
static $db = array (
'Title' => 'Text',
'CenterLat' => 'Double',
'CenterLng' => 'Double',
'MapZoom' => 'Int'
);

static $has_many = array (
'TranslatedTitle' => 'TranslatedText'
);

public function getCMSFields() {
return new FieldSet(
new TextField('Title','Titel'),
new DataObjectManager(
$this, // Controller
'TranslatedTitle', // Source name
'TranslatedText', // Source class
array(
'Text' => 'Titel',
'Lang' => 'Sprache'
),
'getCMSFields()'
),
new NumericField('CenterLat', 'Breitengrad des Mittepunkts (zB 50.12345)', 0.00000),
new NumericField('CenterLng', 'Längengrad des Mittepunkts (zB 11.12345)', 0.00000),
new NumericField('MapZoom', 'Zoomstufe der Karte', 2)
);
}

function TitleInCurrentLang(){
$lang = Translatable::get_current_locale();
$title = DataObject::get_one("TranslatedText", "TranslatableDataObjectID = $this->ID AND Lang = '$lang'");
if ($title)
return $title->Text;
return $this->ViewTitle;
}
}

However, there are some little drawbacks with this approach. The popup in the popup is opened at the bottom (not really a problem). And because of the filter in the DataObject::get_one() call inside TitleInCurrentLang() I can only have one TranslatedText per TranslatableDataObject, in more general terms only one object extending TranslatedObjectPart of the same class per TranslatableDataObject. I have some small ideas to work this out...and maybe you guys can give me a push in the right direction? ;)

Anyway, thats it for now, I'm going home. Merry Chrismas to you all.

dreadman

Posted to: DataObject partial translation Show Thread | Post Reply

Re: Object Relations with many_many

swaiba — Mon, 19 Dec 2011 06:48:39 +1300

This is a little confusing the title is "many_many" but the notation in both posts are "1-n" and "n-m"... maybe if you stick to a slightly more long hand "has_many" or "many_many" this would be crystal clear.

Using ModelAdmin I have not come across any relationship depths it is unable to handle in the form...

a has_many b
b has_many c
c has_many d

It opens a greybox popup to edit the relationship and then if you keep drilling down it down replace the greybox popup with the new one. This has a limitation of no back (i.e. once editing d you can only return to a, not c).

If d has_many a this creates a circle and the scaffolding fails - easily fixed by removing it within getCMSFields, but it ends the ability to "drill down" into the relationship.

I normally handle the many_many with multi select rather than the ManyManyComplexTableField, but I assume if I didn't it would allow the editing of the relationship as above.

So to summarise - avoid circular relationships and try to use ModelAdmin.

Posted to: Object Relations with many_many Show Thread | Post Reply

Re: Object Relations with many_many

sergieboy — Mon, 19 Dec 2011 04:51:53 +1300

I work since four weeks with SS, and my primary concern is not the flashy lights and bells, but the management of a datamodel with several levels : objectA N----M object B N------M object C N------M object D
I have same concerns of yours and I'm afraid that SS is not capable of handing this.
F.Ex the DOM is very nice but only handles up to 2 levels .

Posted to: Object Relations with many_many Show Thread | Post Reply

Re: write() - Method on Field of Subclass of $has_many - DataObject

mtz — Mon, 19 Dec 2011 03:58:22 +1300

Ok, my Problem seems to be solved.
After min. 5 Hours walking down the wrong way I figured out that my Eventhandler onAfterWrite has to be changed in onBeforeWrite...

;-s

Posted to: write() - Method on Field of Subclass of $has_many - DataObject Show Thread | Post Reply

write() - Method on Field of Subclass of $has_many - DataObject

mtz — Sat, 17 Dec 2011 05:41:58 +1300

Hello,

i got that following setup:

Page-Class width 2 $has_many relations, to: lets say "Customer"- and "CustomerPremium"- DataObjects.
My CustomerPremuim - Class is a direct Subclass of Customer.

Now i want an db-write - operation (update a Field) on each related CustomerPremium DataObject in that onAfterWrite() - Method on the Page-Class.

If i target the Parent-Class "Customer" with "$this->Customer()" the write() Method works, but not on the Subclass.
Even since the Subclass has its own $has_many relation in Page.

Any Idea why is that?

if i print out the result of the iteration i get my regular DataObjects in any case. So i'm wondering that i cant write to it just because
its an Subclass.

my code is:
class Page extends .... {

$has_many {
"Customers" => "Customer",
"CustomersPremium" => "CustomerPremium"
}

function onAfterWrite(){
      foreach($this->CustomerPremium() as $i) {
         $i->Format = "482 x 288";
         $i->write();
      }

parent::onAfterWrite();

.....

Thanks!

Posted to: write() - Method on Field of Subclass of $has_many - DataObject Show Thread | Post Reply

Default disable object in DataObject

Craftnet — Fri, 16 Dec 2011 22:17:16 +1300

Hi,
I have a problem.

On my site I have a registration form for mail confirmation.
Each user after registration has a subsite with form to report new objectsleep .

The form requires the name object, address, etc. ...
Form application write in the DataObject.
How to make an application which is stored in the database was set by default to not display on the page

otherwise:
My point is that the notification sent by member in the database which to save the "ObjectSleep" it was turned off for as long as admin does not approve it.

At the moment member send the form saves the object in the database but it is automatically visible to others.

My code:

class Obiekt extends DataObject {

//--------------- BAZA DANYCH --------------- //
static $db = array(
'Title' => 'Varchar(255)',
'NazwaObiektu' => 'Varchar(255)',
'KodPocztowy' => 'Varchar(6)',
'Miejscowosc' => 'Varchar(255)',
'Ulica' => 'Varchar(255)',
'NrDomu' => 'Varchar(6)',
'Telefon' => 'Int',
'TelefonDodatkowy' => 'Int',
'Email' => 'Varchar(255)',
'Strona' => 'Varchar(255)',
'DostepnoscObiektu' => 'Boolean',
'Pokoj1' => 'Boolean',
'Pokoj2' => 'Boolean',
'Pokoj3' => 'Boolean',
'Pokoj4' => 'Boolean',
'Pokoj5' => 'Boolean',
'SrCenaMin' => 'Int',
'SrCenaMax' => 'Int',
'IloscMiejsc' => 'Int',
);
//--------------- ŁĄCZENIA BAZ DANYCH --------------- //
static $has_one = array(
'Wojewodztwo' => 'Wojewodztwo',
'Uzytkownik' => 'Uzytkownik',
'Region' => 'Region',
'Nocleg' => 'Nocleg',
);

//--------------- NAZWA --------------- //
   static $singular_name = 'Obiekt';
   static $plural_name = 'Obiekty';

   function getTitle() {
   return "{$this->NazwaObiektu}";
   }

//--------------- NAZWY POLA FORMULARZA --------------- //
   static $field_labels = array(
      'Title' => 'NazwaObiektu',
      'NazwaObiektu' => 'Nazwa Obiektu:',
      'KodPocztowy' => 'Kod pocztowy:',
      'Miejscowosc' => 'Miejscowosc:',
      'Ulica' => 'Ulica:',
      'NrDomu' => 'Numer domu / lokalu:',
      'Telefon' => 'Telefon:',
      'TelefonDodatkowy' => 'Telefon dodatkowy:',
      'Email' => 'Email:',
      'Strona' => 'Strona www (bez http://):',
      'DostepnoscObiektu' => 'Obiekt dostepny całorocznie:',
      'SrCenaMin' => 'Średnia cena noclegu za osobę od:',
   'SrCenaMax' => 'do:',
   );


//--------------- NAZWY POLA WYSZUKIWANIA --------------- //
   static $searchable_fields = array(
    'Miejscowosc' => array (
       'title' => 'Nazwa miejscowosci',
       'field' => 'TextField',
       'filter' => 'PartialMatchFilter',
    ),
    'Wojewodztwo.ID' => array(
       'title' => 'Województwo',
    ),
    'Region.ID' => array (
       'title' => 'Region',
    ),
    'Nocleg.ID' => array (
       'title' => 'Kategoria noclegu',
    ),
    'SrCenaMin' => array(
'field' => 'TextField',
'filter' => 'GreaterThanFilter',
'title' => 'Cena / od'
),
'SrCenaMax' => array(
'field' => 'TextField',
'filter' => 'LessThanFilter',
'title' => 'do / osoba'
),
);

   public function getDefaultSearchContext() {
      $context = parent::getDefaultSearchContext();
      return $context;
   }


   //--------------- UPRAWNIENIA --------------- //
public function canView($member = null) {
      return true;
   }

   public function canCreate($member = null) {
      return true;
   }

   public function canEdit($member = null) {
      if(!$member) $member = Member::currentUser();
      return (
         Permission::checkMember($member, 'ADMIN')
         || ($member && $member->ID == $this->ID)
      );
   }

   public function canDelete($member = null) {
      return $this->canEdit($member);
   }

}

I think i must use

'Status' => "Enum('Active,Disabled','Disabled')",

and

'defaults' => array(
'Status' => 'Disabled'
)

but i know idea where i must use this code and

what must be in ContentController which be blocked this object

unless you have a different idea

Sorry for my bad English

Posted to: Default disable object in DataObject Show Thread | Post Reply