git.roojs.org Git - Pman.Core/blob - DataObjects/Core_company.php

   1 <?php
   2 /**
   3  * Table Definition for Companies
   4  */
   5 class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
   6
   7 class Pman_Core_DataObjects_Core_Company extends DB_DataObject
   8 {
   9     ###START_AUTOCODE
  10     /* the code below is auto generated do not remove the above tag */
  11
  12     public $__table = 'core_company';                       // table name
  13     public $code;                            // string(32)  not_null
  14     public $name;                            // string(128)
  15     public $remarks;                         // blob(65535)  blob
  16     public $owner_id;                        // int(11)  not_null
  17     public $address;                         // blob(65535)  blob
  18     public $tel;                             // string(32)
  19     public $fax;                             // string(32)
  20     public $email;                           // string(128)
  21     public $id;                              // int(11)  not_null primary_key auto_increment
  22     public $isOwner;                         // int(11)
  23     public $logo_id;                         // int(11)  not_null
  24     public $background_color;                // string(8)  not_null
  25     public $comptype;                        // string(8)  not_null
  26     public $url;                             // string(254)  not_null
  27     public $main_office_id;                  // int(11)  not_null
  28     public $created_by;                      // int(11)  not_null
  29     public $created_dt;                      // datetime(19)  not_null binary
  30     public $updated_by;                      // int(11)  not_null
  31     public $updated_dt;                      // datetime(19)  not_null binary
  32     public $passwd;                          // string(64)  not_null
  33     public $dispatch_port;                   // string(255)  not_null
  34     public $province;                        // string(255)  not_null
  35     public $country;                         // string(4)  not_null
  36     public $is_system;                       // int(2)
  37
  38     /* the code above is auto generated do not remove the tag below */
  39     ###END_AUTOCODE
  40
  41     function applyFilters($q, $au)
  42     {
  43        $tn = $this->tableName();
  44         $this->selectAdd("i18n_translate('c' , {$tn}.country, 'en') as country_display_name ");
  45
  46         $tn = $this->tableName();
  47         //DB_DataObject::debugLevel(1);
  48         $x = DB_DataObject::factory('core_company');
  49         $x->comptype= 'OWNER';
  50         $x->find(true);
  51
  52         if (!empty($q['query']['company_project_id'])) {
  53             $add = '';
  54             if (!empty($q['query']['company_include_self'])) {
  55                 $add = " OR {$tn}.id = {$x->id}";
  56             }
  57             if (!empty($q['query']['company_not_self'])) {
  58                 $add = " AND {$tn}.id != {$x->id}";
  59             }
  60             $pids = array();
  61             $pid = $q['query']['company_project_id'];
  62             if (strpos($pid, ',')) {
  63                 $bits = explode(',', $pid);
  64                 foreach($bits as $b) {
  65                     $pids[] = (int)$b;
  66                 }
  67             } else {
  68                 $pids = array($pid);
  69             }
  70
  71
  72             $pids = implode(',', $pids);
  73             $this->whereAdd("{$tn}.id IN (
  74                 SELECT distinct(company_id) FROM ProjectDirectory where project_id IN ($pids)
  75             ) $add" );
  76
  77         }
  78         if (!empty($q['query']['comptype'])) {
  79
  80             $this->whereAddIn('comptype', explode(',', $q['query']['comptype']), 'string');
  81
  82         }
  83
  84         // depricated - should be moved to module specific (texon afair)
  85
  86          if (!empty($q['query']['province'])) {
  87              $prov = $this->escape($q['query']['province']);
  88             $this->whereAdd("province LIKE '$prov%'");
  89
  90
  91         }
  92         // ADD comptype_display name.. = for combos..
  93         $this->selectAdd("
  94             (SELECT display_name
  95                 FROM
  96                     core_enum
  97                 WHERE
  98                     etype='comptype'
  99                     AND
 100                     name={$tn}.comptype
 101                 LIMIT 1
 102                 ) as comptype_display_name
 103         ");
 104
 105         if(!empty($q['search']['name'])){
 106             $s = $this->escape($q['search']['name']);
 107             $this->whereAdd("
 108                 {$tn}.name LIKE '%$s%'
 109             ");
 110         }
 111         if(!empty($q['search']['name_starts'])){
 112             $s = $this->escape($q['search']['name_starts']);
 113             $this->whereAdd("
 114                 {$tn}.name LIKE '$s%'
 115             ");
 116         }
 117     }
 118
 119     function toEventString() {
 120         return $this->name;
 121     }
 122
 123     // ---------- AUTHENTICATION
 124      function isAuth()
 125     {
 126         $db = $this->getDatabaseConnection();
 127         $sesPrefix = $db->dsn['database'];
 128         @session_start();
 129         if (!empty($_SESSION[__CLASS__][$sesPrefix .'-auth'])) {
 130             // in session...
 131             $a = unserialize($_SESSION[__CLASS__][$sesPrefix .'-auth']);
 132             $u = DB_DataObject::factory('core_company');
 133             if ($u->get($a->id)) { //&& strlen($u->passwd)) {
 134                 return true;
 135             }
 136             $_SESSION[__CLASS__][$sesPrefix .'-auth'] = '';
 137
 138         }
 139         // not in session or not matched...
 140
 141
 142         return false;
 143
 144     }
 145     function getAuthUser()
 146     {
 147         if (!$this->isAuth()) {
 148             return false;
 149         }
 150         $db = $this->getDatabaseConnection();
 151         $sesPrefix = $db->dsn['database'];
 152         if (!empty($_SESSION[__CLASS__][$sesPrefix .'-auth'])) {
 153             $a = unserialize($_SESSION[__CLASS__][$sesPrefix .'-auth']);
 154
 155             $u = DB_DataObject::factory('core_company');
 156             if ($u->get($a->id)) { /// && strlen($u->passwd)) {
 157                 return clone($u);
 158             }
 159
 160         }
 161
 162
 163         return false;
 164     }
 165     function login()
 166     {
 167         $this->isAuth(); // force session start..
 168          $db = $this->getDatabaseConnection();
 169         $sesPrefix = $db->dsn['database'];
 170         $_SESSION[__CLASS__][$sesPrefix .'-auth'] = serialize($this);
 171
 172     }
 173     function logout()
 174     {
 175         $this->isAuth(); // force session start..
 176         $db = $this->getDatabaseConnection();
 177         $sesPrefix = $db->dsn['database'];
 178         $_SESSION[__CLASS__][$sesPrefix .'-auth'] = "";
 179
 180     }
 181     // ---------- AUTHENTICATION
 182     function checkPassword($val)
 183     {
 184         //echo '<pre>'.$val .  print_R($this,true);
 185         if (substr($this->passwd,0,1) == '$') {
 186             return crypt($val,$this->passwd) == $this->passwd ;
 187         }
 188         // old style md5 passwords...- cant be used with courier....
 189         return md5($val) == $this->passwd;
 190     }
 191     function setPassword($value)
 192     {
 193         $salt='';
 194         while(strlen($salt)<9) {
 195             $salt.=chr(rand(64,126));
 196             //php -r var_dump(crypt('testpassword', '$1$'. (rand(64,126)). '$'));
 197         }
 198         $this->passwd = crypt($value, '$1$'. $salt. '$');
 199
 200     }
 201     function onUpload($controller)
 202     {
 203         $image = DB_DataObject::factory('Images');
 204         return $image->onUploadWithTbl($this, 'logo_id');
 205
 206     }
 207     function  onUpdate($old, $req,$roo)
 208     {
 209         if (!empty($req['password1'])) {
 210             $this->setPassword($req['password1']);
 211             $this->update();
 212         }
 213     }
 214     function onInsert($req, $roo)
 215     {
 216         if (!empty($this->logo_id)) { // update images table to sycn with this..
 217             $img = DB_DataObject::factory('Images');
 218             if ($img->get($this->logo_id) && ($img->onid != $this->id)) {
 219                 $img->onid = $this->id;
 220                 $img->update();
 221             }
 222         }
 223         if (!empty($req['password1'])) {
 224             $this->setPassword($req['password1']);
 225             $this->update();
 226         }
 227         $img = DB_DataObject::factory('Images');
 228         $img->onid= 0;
 229
 230         $img->ontable = $this->tableName();
 231         $img->imgtype = 'LOGO';
 232         // should check uploader!!!
 233         if ($img->find()) {
 234             while($img->fetch()) {
 235                 $ii = clone($img);
 236                 $ii->onid = $this->id;
 237                 $ii->update();
 238                 $this->logo_id = $ii->id;
 239             }
 240             $this->update();
 241         }
 242
 243     }
 244
 245     function beforeInsert($q, $roo)
 246     {
 247         if(!empty($q['_check_name'])){
 248             if($this->checkName()){
 249                 $roo->jok('OK');
 250             }
 251
 252             $roo->jerr('EXIST');
 253         }
 254     }
 255
 256     function beforeUpdate($old, $q,$roo)
 257     {
 258         if(!empty($q['_check_name'])){
 259             if($this->checkName()){
 260                 $roo->jok('OK');
 261             }
 262
 263             $roo->jerr('EXIST');
 264         }
 265
 266         if(!empty($q['_merge_id'])){
 267             $this->merge($q['_merge_id'], $roo);
 268         }
 269
 270         if(!empty($this->is_system) &&
 271             ($old->code != $this->code  ) // used to be not allowed to change name..
 272         ){
 273             $roo->jerr('This company is not allow to editing Ref. or Company Name...');
 274         }
 275     }
 276
 277     function beforeDelete($req, $roo)
 278     {
 279         // should check for members....
 280         if(!empty($this->is_system) &&
 281             ($old->code != $this->code || $old->name != $this->name)
 282         ){
 283             $roo->jerr('This company is not allow to delete');
 284         }
 285         $img = DB_DataObject::factory('Images');
 286         $img->ontable = $this->tableName();
 287         $img->onid = $this->id;
 288         $img->find();
 289         while ($img->fetch()) {
 290             $img->beforeDelete();
 291             $img->delete();
 292         }
 293         return true;
 294
 295
 296     }
 297     /**
 298      * check who is trying to access this. false == access denied..
 299      */
 300     function checkPerm($lvl, $au, $changes = false)
 301     {
 302
 303         // do we have an empty system..
 304         if ($au && $au->id == -1) {
 305             return true;
 306         }
 307
 308
 309
 310         if ($au->company()->comptype != 'OWNER') {
 311
 312             // hacking!
 313             if ($changes && isset($changes['comptype']) && $changes['comptype'] != $this->comptype) {
 314                 return false;
 315             }
 316
 317             return $this->id == $au->company_id;
 318         }
 319
 320         return $au->hasPerm("Core.Companies", $lvl);
 321     }
 322
 323     function logoImageToHTML($size)
 324     {
 325         $i = DB_DataObject::factory('Images');
 326         if (!$this->logo_id || !$i->get($this->logo_id)) {
 327             return '';
 328         }
 329         return $i->toHTML($size);
 330
 331     }
 332      function firstImage($filter='image/%')
 333     {
 334         $i = DB_DataObject::factory('Images');
 335         //DB_DataObject::debugLevel(1);
 336         $im = $i->gather($this, $filter);
 337         if (empty($im)) {
 338             return false;
 339         }
 340         return $im[0];
 341     }
 342
 343     function firstImageTag($size =-1, $base="/Images/Thumb", $filter='image/%')
 344     {
 345         $fm = $this->firstImage($filter);
 346          if (empty($fm)) {
 347             return '';
 348         }
 349         return $fm->toHTML($size, $base);
 350     }
 351
 352     function toRooSingleArray($authUser, $request)
 353     {
 354         $ret = $this->toArray();
 355        // DB_DataObject::debugLevel(1);
 356         // get the comptype display
 357         $e = DB_DataObject::Factory('core_enum')->lookupObject('COMPTYPE', $this->comptype);
 358
 359         $ret['comptype_display'] = $ret['comptype'];
 360         if ($e   && !empty($e->name_display)) {
 361             $ret['comptype_display'] = $e->name_display;
 362         }
 363
 364
 365         return $ret;
 366     }
 367
 368     /**
 369      * # 2028
 370      * create the suppliers...
 371      *
 372      * @param object $roo
 373      * @param array $data
 374      *
 375      */
 376     function initCompaniesArray($roo, $data)
 377     {
 378         $tn = $this->tableName();
 379
 380         foreach($data as $d){
 381             $com = DB_DataObject::factory($tn);
 382             $com->setFrom($d);
 383             if(!$com->find(true)){
 384                 $com->created_dt = Date('Y-m-d H:i:s');
 385                 $com->updated_dt = Date('Y-m-d H:i:s');
 386                 $com->is_system = 1;// new column.. block the user changing the code and name..
 387                 $com->insert();
 388             }
 389         }
 390
 391
 392     }
 393
 394
 395     function initCompanies($roo, $opts)
 396     {
 397         $companies = DB_DataObject::factory('core_company');
 398
 399         $ctype = empty($opts['add-company-with-type']) ? 'OWNER' : $opts['add-company-with-type'];
 400
 401         $enum = DB_DataObject::Factory('core_enum')->lookup('COMPTYPE', $ctype  );
 402
 403         if (empty($enum)) {
 404             $roo->jerr("invalid company type '$ctype'");
 405         }
 406         if ($ctype =='OWNER') {
 407             $companies = DB_DataObject::factory('core_company');
 408             $companies->comptype_id = $enum;
 409             if ($companies->count()) {
 410                 $roo->jerr("Owner  company already exists");
 411             }
 412         }
 413         $companies = DB_DataObject::factory('core_company');
 414
 415         // check that
 416         $companies->setFrom(array(
 417             'name' => $opts['add-company'],
 418             'comptype' => $ctype,
 419             'comptype_id' => $enum,
 420         ));
 421         if ($companies->find(true)) {
 422             $roo->jerr("company already exists");
 423         }
 424         $companies->setFrom(array(
 425             'background_color' => '',
 426             'created_dt' => $this->sqlValue('NOW()'),
 427             'updated_dt' => $this->sqlValue('NOW()')
 428         ));
 429
 430
 431         $companies->insert();
 432         $companies->onInsert(array(), $roo);
 433     }
 434     static function lookupOwner()
 435     {
 436         $enum = DB_DataObject::Factory('core_enum')->lookup('COMPTYPE', 'OWNER'  );
 437         $companies = DB_DataObject::factory('core_company');
 438         $companies->comptype_id = $enum;
 439         if ($companies->find(true)) {
 440             return $companies;
 441         }
 442         return false;
 443     }
 444
 445     function merge($merge_to, $roo)
 446     {
 447         $affects  = array();
 448
 449         $all_links = $x->databaseLinks();
 450
 451         foreach($all_links as $tbl => $links) {
 452             foreach($links as $col => $totbl_col) {
 453                 $to = explode(':', $totbl_col);
 454                 if ($to[0] != $this->tableName()) {
 455                     continue;
 456                 }
 457
 458                 $affects[$tbl .'.' . $col] = true;
 459             }
 460         }
 461
 462         foreach($affects as $k => $true) {
 463             $ka = explode('.', $k);
 464
 465             $chk = DB_DataObject::factory($ka[0]);
 466
 467             if (!is_a($chk,'DB_DataObject')) {
 468                 $roo->jerr('Unable to load referenced table, check the links config: ' .$ka[0]);
 469             }
 470
 471             $chk->{$ka[1]} = $this->id;
 472
 473             foreach ($chk->fetchAll() as $c){
 474                 $cc = clone ($c);
 475                 $c->{$ka[1]} = $merge_to;
 476                 $c->update($cc);
 477             }
 478         }
 479
 480         $this->delete();
 481
 482         $roo->jok('Merged');
 483
 484     }
 485
 486     function checkName()
 487     {
 488         $company = DB_DataObject::factory('core_company');
 489         $company->setFrom(array(
 490             'name' => $this->name
 491         ));
 492
 493         if(!empty($this->id)){
 494             $company->whereAdd("id != {$this->id}");
 495         }
 496
 497         if(!$company->find(true)){
 498             return true;
 499         }
 500
 501         return false;
 502     }
 503 }