X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_enum.php;h=af2681de5df3fcc518a9fba59e91a4177080068c;hb=a1b262677a50412ddc29d01558d5496480e691ce;hp=311bea4bea96db33db48e50f2e790d98255f699a;hpb=2441d6d1e680fd47bf8fb708b7837fc3f1e6818d;p=Pman.Core diff --git a/DataObjects/Core_enum.php b/DataObjects/Core_enum.php index 311bea4b..af2681de 100644 --- a/DataObjects/Core_enum.php +++ b/DataObjects/Core_enum.php @@ -26,7 +26,7 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject // DB_DataObject::debugLevel(1); if (!empty($q['query']['empty_etype'])) { - $this->whereAdd("etype = ''"); + $this->whereAdd("core_enum.etype = ''"); } // this should be handled by roo... using '!name[0]' .... @@ -58,13 +58,17 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject "); } -// print_r($this); - if(!empty($q['id'])){ - $this->id = $q['id']; + } + + function checkPerm($lvl, $au, $req=null) + { + if (!$au) { + return false; } - + return true; } + function autoJoinCmsTranslate($lang) { $l = $this->escape($lang); @@ -119,14 +123,19 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject function beforeUpdate($old, $request,$roo) - { $roo->jdata(array('old'=>$old,'req'=>$request)); + { + if(!empty($request['_merge_id'])){ + $this->merge($request['_merge_id'], $roo); + } + $tn = $this->tableName(); $x = $this->factory($tn); - if(!($old->etype == $request['etype'] && $old->name == $request['name'])){ + // check if record exists? + if(isset($request['etype']) && !($old->etype == $request['etype'] && $old->name == $request['name'])){ $x->whereAdd("etype = '{$this->escape($request['etype'])}' AND name = '{$this->escape($request['name'])}'"); $x->find(true); if($x->count() > 0){ - $roo->jerr('is exsiting'); + $roo->jerr('record already exists'); } } } @@ -161,6 +170,10 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject if ($old->etype != $this->etype) { $x->query("SELECT core_enum_seqmax_update('". $this->escape($old->etype) ."')"); } + if($this->name != $old->name && empty($old->etype) && empty($this->etype)){ + $x->query("UPDATE core_enum SET etype = '". $this->escape($this->name) + ."' WHERE etype = '". $this->escape($old->name)."'"); + } } /** @@ -176,6 +189,30 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject return 0; } + function lookupCreate($etype,$name, $display_name=false) { + + // check + $ce = DB_DataObject::Factory('core_enum'); + $ce->setFrom(array( + 'etype' => '', + 'name' => $etype + )); + if (!$ce->find(true)) { + $ce->display_name = $etype; + $ce->insert(); + } + + $ce = DB_DataObject::Factory('core_enum'); + $ce->etype = $etype; + $ce->name = $name; + if ($ce->find(true)) { + return $ce->id; + } + $ce->active = 1; + $ce->display_name = $display_name === false ? $ce->name : $display_name; + return $ce->insert(); + + } function lookupById($id) { $ce = DB_DataObject::Factory('core_enum'); @@ -302,5 +339,46 @@ class Pman_Core_DataObjects_Core_enum extends DB_DataObject } + function merge($merge_to, $roo) + { + $affects = array(); + + $all_links = $GLOBALS['_DB_DATAOBJECT']['LINKS'][$this->_database]; + + foreach($all_links as $tbl => $links) { + foreach($links as $col => $totbl_col) { + $to = explode(':', $totbl_col); + if ($to[0] != $this->tableName()) { + continue; + } + + $affects[$tbl .'.' . $col] = true; + } + } + + foreach($affects as $k => $true) { + $ka = explode('.', $k); + + $chk = DB_DataObject::factory($ka[0]); + + if (!is_a($chk,'DB_DataObject')) { + $roo->jerr('Unable to load referenced table, check the links config: ' .$ka[0]); + } + + $chk->{$ka[1]} = $this->id; + + foreach ($chk->fetchAll() as $c){ + $cc = clone ($c); + $c->{$ka[1]} = $merge_to; + $c->update($cc); + } + } + + $this->delete(); + + $roo->jok('Merged'); + + } + }