Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Customising the CMS /

dynamically adding items to $db


Go to End
Reply


12 Posts   2213 Views

Avatar
Carbon Crayon

Community Member, 598 Posts

13 January 2009 at 1:08pm

Hi guys

I want to be able to add items to the $db of a page based on a set of other pages. So I have a CatagoryPage type and an EnviromentPage type and i want the CatagoryPage's $db to add a key value pair into the array for each EnviromentPage that exists, so that when i create a new EnviromentPage and flush the db, it will add the appropriate fields to the CatagoryPage.

Does anyone know of a way to dynamicaly add keys and value pairs to the $db array in this way?

cheers

Aram

Avatar
Carbon Crayon

Community Member, 598 Posts

13 January 2009 at 11:59pm

Ok I think I need to use the DataObjectDecorator for this, but I am having trouble getting it to do anything!

I have a class in mysite/code/PageDecorator.php

class PageDecorator extends DataObjectDecorator {

   function extraDBFields() {
      
      return array(
         'db' => array('Value' => 'Varchar(255)')

      );
   }
   
}

and in mysite/_config.php i have

DataObject::add_extension('Page', 'PageDecorator');

But when I do a DB flush nothing happens?

Am I missing something really obvious here?

cheers

Aram

Avatar
UncleCheese

Forum Moderator, 4096 Posts

14 January 2009 at 4:05am

Are you running 2.3? Try extraStatics().

Avatar
UncleCheese

Forum Moderator, 4096 Posts

14 January 2009 at 4:08am

As for the dynamic $db question, I'm having a hard time understanding why you would need to do that? This is an Enum field?

Couldn't you just associate a Category with an Environment using a TypeDropdown?

Avatar
Carbon Crayon

Community Member, 598 Posts

14 January 2009 at 8:50am

Edited: 14/01/2009 8:55am

Hi UncleCheese

Thanks for helping with this. I am running 2.23 as this is a site which I made a while back and am now trying to add functionality. Here is the context of what i am trying to do:

I created a site for a friend who runs an ebay store ([url]http://www.urban-knights-ebay.com[/url]). It allows him to manage his product pages/faqs/postage info etc. easily and means creating a new product is super easy.

Now he wants to be able to create different enviroments for different aution sites, so that had can go to /product1/ebay or /product1/ebid to get to the enviroment for that product, giving him the correct banner and links etc. Essentially each page would have multiple 'modes' or skins for different stores. I have managed to set it up so that when he creates a new enviroment he can set all the general stuff like header image etc, but the problem I have is some of the fields on the product are enviroment specific. This means that each time he creates a new enviroment, new fields need to appear on each product to allow him to set those variables.

So for example if he creates a new enviroment page for 'ebid' then I need to add a field to the ProductPage class called Ebid_sampleLink.

I need a function attached to the product page that can cycle throughe the current Enviroment pages and add the fields as neccecary.

Can I do this with a DataObject decorator?

cheers

Aram

Avatar
UncleCheese

Forum Moderator, 4096 Posts

14 January 2009 at 9:50am

I see..

Sure.. I would just use extraStatics() and mod your db array(). It will take some finagling, but I think you'll get it. The nice thing is that extraStatics() will put you in a function, so you can do whatever you want there. Here's some peudo code:

class Environment extends DataObject
{
function extraStatics()
{
$db = array();
foreach(DataObject::get("Environment") as $env)
{
$key = self::sanitize($env->Title);
$db[$key."_Link"] = "Text";
$db[$key."_SomeOtherField"] = "Text"
}
return array('db' => $db);
}

private static function sanitize($str)
{
// do some stuff here to make sure your string is a clean database field.
return $str;
}

public function getCMSFields()
{
$f = parent::getCMSFields();
foreach($this->dbFields() /* I believe that's the function. $this->stat('db') will work, too */ as $name => $type)
{
$f->addFieldToTab("Root.Content.EnvironmentStuff", new TextField($name));
}
return $f;

}
}

Does that make sense? It will take a little futzing around, but I think you see the idea. Interesting problem to solve, though. Let me know how you do.. or ... how you "get on" as you folks like to say.

Avatar
Carbon Crayon

Community Member, 598 Posts

14 January 2009 at 10:30pm

Hey UncleCheese, thanks a lot for that, I 'got on' great ;) Managed to get a hacky version working last night by using the extraDBFields and DataObjectDecorator (i'm still on 2.23 remember), will tidy it up tonight and post my code :)

Avatar
UncleCheese

Forum Moderator, 4096 Posts

15 January 2009 at 8:21am

Yeah, curious to see it. Nice work.

Go to Top