DataObjects/core.sql

[Pman.Core] / DataObjects / Office.php

diff --git a/DataObjects/Office.php b/DataObjects/Office.php
index 935200f..020ed59 100644 (file)
--- a/DataObjects/Office.php
+++ b/DataObjects/Office.php
@@ -14,14 +14,36 @@ class Pman_Core_DataObjects_Office extends DB_DataObject
     public $company_id;                      // int(11)  not_null
     public $name;                            // string(64)  not_null
     public $address;                         // blob(65535)  not_null blob
+    public $address2;                         // blob(65535)  not_null blob
+    public $address3;                         // blob(65535)  not_null blob 
     public $phone;                           // string(32)  not_null
     public $fax;                             // string(32)  not_null
     public $email;                           // string(128)  not_null
     public $role;                            // string(32)  not_null
-
-     
+    public $country;                         // string(4)
+    
     /* the code above is auto generated do not remove the tag below */
     ###END_AUTOCODE
+    function applyFilters($q, $au)
+    {
+        //DB_DataObject::debugLevel(1);
+        //$this->joinAddCountry();
+        //print_r($au);
+        $this->selectAdd("(SELECT lval FROM i18n WHERE lkey = Office.country AND ltype = 'c' AND inlang = '{$au->lang}') AS country_name");
+       
+    }
+    
+    function joinAddCountry()
+    {
+        $this->_join .= '
+            LEFT JOIN
+                i18n AS join_country
+            ON
+                (join_country.lkey = Office.country)
+        ';
+        $item = DB_DataObject::Factory('I18n');
+        $this->selectAs($item, 'country_id_%s', 'join_country');
+    }
     function toEventString() {
         return $this->name;
     }