X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FCore_company.php;h=2a55369440745695f27dc9bae55cce4ccb78c902;hb=e23146506d2ade4e9263cb608f9e21f5da13020e;hp=1dea0f9018d421a4267c0961a060b149cc148eab;hpb=db3107ac05ef266d257bf99eb5246cf054f5932e;p=Pman.Core diff --git a/DataObjects/Core_company.php b/DataObjects/Core_company.php index 1dea0f90..2a553694 100644 --- a/DataObjects/Core_company.php +++ b/DataObjects/Core_company.php @@ -2,7 +2,7 @@ /** * Table Definition for Companies */ -require_once 'DB/DataObject.php'; +class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php'; class Pman_Core_DataObjects_Core_Company extends DB_DataObject { @@ -40,15 +40,16 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject function applyFilters($q, $au) { - $tn = $this->tableName(); + + $tn = $this->tableName(); $this->selectAdd("i18n_translate('c' , {$tn}.country, 'en') as country_display_name "); $tn = $this->tableName(); //DB_DataObject::debugLevel(1); - $x = DB_DataObject::factory('Companies'); + $x = DB_DataObject::factory('core_company'); $x->comptype= 'OWNER'; $x->find(true); - + if (!empty($q['query']['company_project_id'])) { $add = ''; if (!empty($q['query']['company_include_self'])) { @@ -57,6 +58,7 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject if (!empty($q['query']['company_not_self'])) { $add = " AND {$tn}.id != {$x->id}"; } + $pids = array(); $pid = $q['query']['company_project_id']; if (strpos($pid, ',')) { @@ -102,7 +104,13 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject ) as comptype_display_name "); - if(!empty($q['search']['name'])){ + if(!empty($q['query']['name'])){ + $s = $this->escape($q['query']['name']); + $this->whereAdd(" + {$tn}.name LIKE '%$s%' + "); + } + if(!empty($q['search']['name'])){ $s = $this->escape($q['search']['name']); $this->whereAdd(" {$tn}.name LIKE '%$s%' @@ -121,7 +129,9 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject } // ---------- AUTHENTICATION - function isAuth() + // not sure where authetnication via company is used?? posibly media-outreach + + function isAuth() { $db = $this->getDatabaseConnection(); $sesPrefix = $db->dsn['database']; @@ -129,7 +139,7 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject if (!empty($_SESSION[__CLASS__][$sesPrefix .'-auth'])) { // in session... $a = unserialize($_SESSION[__CLASS__][$sesPrefix .'-auth']); - $u = DB_DataObject::factory('Companies'); + $u = DB_DataObject::factory('core_company'); if ($u->get($a->id)) { //&& strlen($u->passwd)) { return true; } @@ -152,7 +162,7 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject if (!empty($_SESSION[__CLASS__][$sesPrefix .'-auth'])) { $a = unserialize($_SESSION[__CLASS__][$sesPrefix .'-auth']); - $u = DB_DataObject::factory('Companies'); + $u = DB_DataObject::factory('core_company'); if ($u->get($a->id)) { /// && strlen($u->passwd)) { return clone($u); } @@ -227,7 +237,7 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject $img = DB_DataObject::factory('Images'); $img->onid= 0; - $img->ontable = 'Companies'; + $img->ontable = $this->tableName(); $img->imgtype = 'LOGO'; // should check uploader!!! if ($img->find()) { @@ -240,13 +250,51 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject $this->update(); } - - - + } + + function beforeInsert($q, $roo) + { + if(!empty($q['_check_name'])){ + if($this->checkName()){ + $roo->jok('OK'); + } + + $roo->jerr('EXIST'); + } } function beforeUpdate($old, $q,$roo) { + // we still use comptype in some old systems... + + if (!empty($q['comptype_id'])) { + $en = DB_DataObject::Factory('core_enum'); + $en->get($q['comptype_id']); + $this->comptype = $en->name; + } + + + if(!empty($q['_flag_delete'])){ + $this->deleted_dt = $this->sqlValue("NOW()"); + $this->deleted_by = $roo->getAuthUser()->id; + } + + if(!empty($q['_flag_undelete'])){ + $this->deleted_dt = ""; + $this->deleted_by = 0; + } + if(!empty($q['_check_name'])){ + if($this->checkName()){ + $roo->jok('OK'); + } + + $roo->jerr('EXIST'); + } + + if(!empty($q['_merge_id'])){ + $this->merge($q['_merge_id'], $roo); + } + if(!empty($this->is_system) && ($old->code != $this->code ) // used to be not allowed to change name.. ){ @@ -256,14 +304,20 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject function beforeDelete($req, $roo) { + // should check for members.... if(!empty($this->is_system) && ($old->code != $this->code || $old->name != $this->name) ){ $roo->jerr('This company is not allow to delete'); } + + + } + function onDelete($req, $roo) + { $img = DB_DataObject::factory('Images'); - $img->ontable = 'Companies'; + $img->ontable = $this->tableName(); $img->onid = $this->id; $img->find(); while ($img->fetch()) { @@ -374,7 +428,7 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject function initCompanies($roo, $opts) { - $companies = DB_DataObject::factory('companies'); + $companies = DB_DataObject::factory('core_company'); $ctype = empty($opts['add-company-with-type']) ? 'OWNER' : $opts['add-company-with-type']; @@ -384,13 +438,13 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject $roo->jerr("invalid company type '$ctype'"); } if ($ctype =='OWNER') { - $companies = DB_DataObject::factory('companies'); + $companies = DB_DataObject::factory('core_company'); $companies->comptype_id = $enum; if ($companies->count()) { $roo->jerr("Owner company already exists"); } } - $companies = DB_DataObject::factory('companies'); + $companies = DB_DataObject::factory('core_company'); // check that $companies->setFrom(array( @@ -411,14 +465,73 @@ class Pman_Core_DataObjects_Core_Company extends DB_DataObject $companies->insert(); $companies->onInsert(array(), $roo); } - function lookupOwner() + static function lookupOwner() { $enum = DB_DataObject::Factory('core_enum')->lookup('COMPTYPE', 'OWNER' ); - $companies = DB_DataObject::factory('companies'); + $companies = DB_DataObject::factory('core_company'); $companies->comptype_id = $enum; if ($companies->find(true)) { return $companies; } return false; } + + function merge($merge_to, $roo) + { + $affects = array(); + + $all_links = $this->databaseLinks(); + + 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'); + + } + + function checkName() + { + $company = DB_DataObject::factory('core_company'); + $company->setFrom(array( + 'name' => $this->name + )); + + if(!empty($this->id)){ + $company->whereAdd("id != {$this->id}"); + } + + if(!$company->find(true)){ + return true; + } + + return false; + } }