Changeset 477

Show
Ignore:
Timestamp:
11/25/08 21:13:56 (1 month ago)
Author:
arnaud
Message:

Librairies : Bourse modifications champs et methodes peer sur nouveaux champs

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/lib/model/Market.php

    r468 r477  
    6363    return $result; 
    6464  } 
     65   
     66  public function setAgencyPhone($v) 
     67  {  
     68    if ($this->agency_phone !== $v) { 
     69      $this->agency_phone = ereg_replace("[^0-9]","",$v);  
     70      $this->modifiedColumns[] = MarketPeer::AGENCY_PHONE; 
     71    } 
     72  } 
    6573} 
  • trunk/lib/model/MarketPeer.php

    r471 r477  
    2525      $c->add(ExchangePeer::IS_ACTIVE, 1); 
    2626      $c->add(ExchangePeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
    27           $criterion = $c->getNewCriterion(MarketPeer::CREATED_AT, $start_at, Criteria::GREATER_EQUAL); 
    28           $criterion->addAnd($c->getNewCriterion(MarketPeer::CREATED_AT, $end_at, Criteria::LESS_EQUAL)); 
     27          $criterion = $c->getNewCriterion(MarketPeer::MARKET_CREATED_AT, $start_at, Criteria::GREATER_EQUAL); 
     28          $criterion->addAnd($c->getNewCriterion(MarketPeer::MARKET_CREATED_AT, $end_at, Criteria::LESS_EQUAL)); 
    2929          $c->add($criterion); 
    3030    else: 
     
    5757      $c->add(ExchangePeer::IS_ACTIVE, 1); 
    5858      $c->add(ExchangePeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
    59           $criterion = $c->getNewCriterion(MarketPeer::UPDATED_AT, $start_at, Criteria::GREATER_EQUAL); 
    60           $criterion->addAnd($c->getNewCriterion(MarketPeer::UPDATED_AT, $end_at, Criteria::LESS_EQUAL)); 
     59          $criterion = $c->getNewCriterion(MarketPeer::MARKET_UPDATED_AT, $start_at, Criteria::GREATER_EQUAL); 
     60          $criterion->addAnd($c->getNewCriterion(MarketPeer::MARKET_UPDATED_AT, $end_at, Criteria::LESS_EQUAL)); 
    6161          $c->add($criterion); 
    6262      return MarketPeer::doCount($c); 
     
    8181      $c->add(ExchangePeer::IS_ACTIVE, 1); 
    8282      $c->add(ExchangePeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
    83           $criterion = $c->getNewCriterion(MarketPeer::CREATED_AT, $start_at, Criteria::GREATER_EQUAL); 
    84           $criterion->addAnd($c->getNewCriterion(MarketPeer::CREATED_AT, $end_at, Criteria::LESS_EQUAL)); 
    85           $c->add($criterion); 
    86           // sector limit 
    87           $c2 = new Criteria(); 
    88           $c2->add(Market_sectorPeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
    89           $sectors = Market_sectorPeer::doSelect($c2); 
    90           foreach($sectors as $sector): 
    91             $apicity = ApicityPeer::retrieveByPk($sector->getCityId()); 
    92             $c->add(MarketPeer::CITY, $apicity); 
    93           endforeach; 
     83          $criterion = $c->getNewCriterion(MarketPeer::MARKET_CREATED_AT, $start_at, Criteria::GREATER_EQUAL); 
     84          $criterion->addAnd($c->getNewCriterion(MarketPeer::MARKET_CREATED_AT, $end_at, Criteria::LESS_EQUAL)); 
     85          $c->add($criterion); 
    9486      return MarketPeer::doCount($c); 
    9587    else: 
     
    113105      $c->add(ExchangePeer::IS_ACTIVE, 1); 
    114106      $c->add(ExchangePeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
    115           $criterion = $c->getNewCriterion(MarketPeer::UPDATED_AT, $start_at, Criteria::GREATER_EQUAL); 
    116           $criterion->addAnd($c->getNewCriterion(MarketPeer::UPDATED_AT, $end_at, Criteria::LESS_EQUAL)); 
    117           $c->add($criterion); 
    118           // sector limit 
    119           $c2 = new Criteria(); 
    120           $c2->add(Market_sectorPeer::AGENCY_ID, sfContext::getInstance()->getUser()->getSubscriber()->getAgencyId()); 
    121           $sectors = Market_sectorPeer::doSelect($c2); 
    122           foreach($sectors as $sector): 
    123             $apicity = ApicityPeer::retrieveByPk($sector->getCityId()); 
    124             $c->add(MarketPeer::CITY, $apicity); 
    125           endforeach; 
     107          $criterion = $c->getNewCriterion(MarketPeer::MARKET_UPDATED_AT, $start_at, Criteria::GREATER_EQUAL); 
     108          $criterion->addAnd($c->getNewCriterion(MarketPeer::MARKET_UPDATED_AT, $end_at, Criteria::LESS_EQUAL)); 
     109          $c->add($criterion); 
    126110      return MarketPeer::doCount($c); 
    127111    else: 
  • trunk/lib/model/map/MarketMapBuilder.php

    r460 r477  
    199199                $tMap->addColumn('URL', 'Url', 'string', CreoleTypes::VARCHAR, false, 160); 
    200200 
    201                 $tMap->addColumn('LAST_CHANGE', 'LastChange', 'int', CreoleTypes::DATE, false, null); 
     201                $tMap->addColumn('MARKET_CREATED_AT', 'MarketCreatedAt', 'int', CreoleTypes::TIMESTAMP, false, null); 
     202 
     203                $tMap->addColumn('MARKET_UPDATED_AT', 'MarketUpdatedAt', 'int', CreoleTypes::TIMESTAMP, false, null); 
    202204 
    203205                $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false, null); 
  • trunk/lib/model/om/BaseMarket.php

    r460 r477  
    342342 
    343343         
    344         protected $last_change; 
     344        protected $market_created_at; 
     345 
     346 
     347         
     348        protected $market_updated_at; 
    345349 
    346350 
     
    10181022 
    10191023         
    1020         public function getLastChange($format = 'Y-m-d') 
    1021         { 
    1022  
    1023                 if ($this->last_change === null || $this->last_change === '') { 
     1024        public function getMarketCreatedAt($format = 'Y-m-d H:i:s') 
     1025        { 
     1026 
     1027                if ($this->market_created_at === null || $this->market_created_at === '') { 
    10241028                        return null; 
    1025                 } elseif (!is_int($this->last_change)) { 
    1026                                                 $ts = strtotime($this->last_change); 
    1027                         if ($ts === -1 || $ts === false) {                              throw new PropelException("Unable to parse value of [last_change] as date/time value: " . var_export($this->last_change, true)); 
     1029                } elseif (!is_int($this->market_created_at)) { 
     1030                                                $ts = strtotime($this->market_created_at); 
     1031                        if ($ts === -1 || $ts === false) {                              throw new PropelException("Unable to parse value of [market_created_at] as date/time value: " . var_export($this->market_created_at, true)); 
    10281032                        } 
    10291033                } else { 
    1030                         $ts = $this->last_change; 
     1034                        $ts = $this->market_created_at; 
     1035                } 
     1036                if ($format === null) { 
     1037                        return $ts; 
     1038                } elseif (strpos($format, '%') !== false) { 
     1039                        return strftime($format, $ts); 
     1040                } else { 
     1041                        return date($format, $ts); 
     1042                } 
     1043        } 
     1044 
     1045         
     1046        public function getMarketUpdatedAt($format = 'Y-m-d H:i:s') 
     1047        { 
     1048 
     1049                if ($this->market_updated_at === null || $this->market_updated_at === '') { 
     1050                        return null; 
     1051                } elseif (!is_int($this->market_updated_at)) { 
     1052                                                $ts = strtotime($this->market_updated_at); 
     1053                        if ($ts === -1 || $ts === false) {                              throw new PropelException("Unable to parse value of [market_updated_at] as date/time value: " . var_export($this->market_updated_at, true)); 
     1054                        } 
     1055                } else { 
     1056                        $ts = $this->market_updated_at; 
    10311057                } 
    10321058                if ($format === null) { 
     
    22102236        }  
    22112237         
    2212         public function setLastChange($v) 
     2238        public function setMarketCreatedAt($v) 
    22132239        { 
    22142240 
    22152241                if ($v !== null && !is_int($v)) { 
    22162242                        $ts = strtotime($v); 
    2217                         if ($ts === -1 || $ts === false) {                              throw new PropelException("Unable to parse date/time value for [last_change] from input: " . var_export($v, true)); 
     2243                        if ($ts === -1 || $ts === false) {                              throw new PropelException("Unable to parse date/time value for [market_created_at] from input: " . var_export($v, true)); 
    22182244                        } 
    22192245                } else { 
    22202246                        $ts = $v; 
    22212247                } 
    2222                 if ($this->last_change !== $ts) { 
    2223                         $this->last_change = $ts; 
    2224                         $this->modifiedColumns[] = MarketPeer::LAST_CHANGE; 
     2248                if ($this->market_created_at !== $ts) { 
     2249                        $this->market_created_at = $ts; 
     2250                        $this->modifiedColumns[] = MarketPeer::MARKET_CREATED_AT; 
     2251                } 
     2252 
     2253        }  
     2254         
     2255        public function setMarketUpdatedAt($v) 
     2256        { 
     2257 
     2258                if ($v !== null && !is_int($v)) { 
     2259                        $ts = strtotime($v); 
     2260                        if ($ts === -1 || $ts === false) {                              throw new PropelException("Unable to parse date/time value for [market_updated_at] from input: " . var_export($v, true)); 
     2261                        } 
     2262                } else { 
     2263                        $ts = $v; 
     2264                } 
     2265                if ($this->market_updated_at !== $ts) { 
     2266                        $this->market_updated_at = $ts; 
     2267                        $this->modifiedColumns[] = MarketPeer::MARKET_UPDATED_AT; 
    22252268                } 
    22262269 
     
    24312474                        $this->url = $rs->getString($startcol + 82); 
    24322475 
    2433                         $this->last_change = $rs->getDate($startcol + 83, null); 
    2434  
    2435                         $this->created_at = $rs->getTimestamp($startcol + 84, null); 
    2436  
    2437                         $this->updated_at = $rs->getTimestamp($startcol + 85, null); 
     2476                        $this->market_created_at = $rs->getTimestamp($startcol + 83, null); 
     2477 
     2478                        $this->market_updated_at = $rs->getTimestamp($startcol + 84, null); 
     2479 
     2480                        $this->created_at = $rs->getTimestamp($startcol + 85, null); 
     2481 
     2482                        $this->updated_at = $rs->getTimestamp($startcol + 86, null); 
    24382483 
    24392484                        $this->resetModified(); 
     
    24412486                        $this->setNew(false); 
    24422487 
    2443                                                 return $startcol + 86;  
     2488                                                return $startcol + 87;  
    24442489                } catch (Exception $e) { 
    24452490                        throw new PropelException("Error populating Market object", $e); 
     
    29002945                                break; 
    29012946                        case 83: 
    2902                                 return $this->getLastChange(); 
     2947                                return $this->getMarketCreatedAt(); 
    29032948                                break; 
    29042949                        case 84: 
     2950                                return $this->getMarketUpdatedAt(); 
     2951                                break; 
     2952                        case 85: 
    29052953                                return $this->getCreatedAt(); 
    29062954                                break; 
    2907                         case 85
     2955                        case 86
    29082956                                return $this->getUpdatedAt(); 
    29092957                                break; 
     
    30013049                        $keys[81] => $this->getBuildingPermit(), 
    30023050                        $keys[82] => $this->getUrl(), 
    3003                         $keys[83] => $this->getLastChange(), 
    3004                         $keys[84] => $this->getCreatedAt(), 
    3005                         $keys[85] => $this->getUpdatedAt(), 
     3051                        $keys[83] => $this->getMarketCreatedAt(), 
     3052                        $keys[84] => $this->getMarketUpdatedAt(), 
     3053                        $keys[85] => $this->getCreatedAt(), 
     3054                        $keys[86] => $this->getUpdatedAt(), 
    30063055                ); 
    30073056                return $result; 
     
    32693318                                break; 
    32703319                        case 83: 
    3271                                 $this->setLastChange($value); 
     3320                                $this->setMarketCreatedAt($value); 
    32723321                                break; 
    32733322                        case 84: 
     3323                                $this->setMarketUpdatedAt($value); 
     3324                                break; 
     3325                        case 85: 
    32743326                                $this->setCreatedAt($value); 
    32753327                                break; 
    3276                         case 85
     3328                        case 86
    32773329                                $this->setUpdatedAt($value); 
    32783330                                break; 
     
    33673419                if (array_key_exists($keys[81], $arr)) $this->setBuildingPermit($arr[$keys[81]]); 
    33683420                if (array_key_exists($keys[82], $arr)) $this->setUrl($arr[$keys[82]]); 
    3369                 if (array_key_exists($keys[83], $arr)) $this->setLastChange($arr[$keys[83]]); 
    3370                 if (array_key_exists($keys[84], $arr)) $this->setCreatedAt($arr[$keys[84]]); 
    3371                 if (array_key_exists($keys[85], $arr)) $this->setUpdatedAt($arr[$keys[85]]); 
     3421                if (array_key_exists($keys[83], $arr)) $this->setMarketCreatedAt($arr[$keys[83]]); 
     3422                if (array_key_exists($keys[84], $arr)) $this->setMarketUpdatedAt($arr[$keys[84]]); 
     3423                if (array_key_exists($keys[85], $arr)) $this->setCreatedAt($arr[$keys[85]]); 
     3424                if (array_key_exists($keys[86], $arr)) $this->setUpdatedAt($arr[$keys[86]]); 
    33723425        } 
    33733426 
     
    34603513                if ($this->isColumnModified(MarketPeer::BUILDING_PERMIT)) $criteria->add(MarketPeer::BUILDING_PERMIT, $this->building_permit); 
    34613514                if ($this->isColumnModified(MarketPeer::URL)) $criteria->add(MarketPeer::URL, $this->url); 
    3462                 if ($this->isColumnModified(MarketPeer::LAST_CHANGE)) $criteria->add(MarketPeer::LAST_CHANGE, $this->last_change); 
     3515                if ($this->isColumnModified(MarketPeer::MARKET_CREATED_AT)) $criteria->add(MarketPeer::MARKET_CREATED_AT, $this->market_created_at); 
     3516                if ($this->isColumnModified(MarketPeer::MARKET_UPDATED_AT)) $criteria->add(MarketPeer::MARKET_UPDATED_AT, $this->market_updated_at); 
    34633517                if ($this->isColumnModified(MarketPeer::CREATED_AT)) $criteria->add(MarketPeer::CREATED_AT, $this->created_at); 
    34643518                if ($this->isColumnModified(MarketPeer::UPDATED_AT)) $criteria->add(MarketPeer::UPDATED_AT, $this->updated_at); 
     
    36573711                $copyObj->setUrl($this->url); 
    36583712 
    3659                 $copyObj->setLastChange($this->last_change); 
     3713                $copyObj->setMarketCreatedAt($this->market_created_at); 
     3714 
     3715                $copyObj->setMarketUpdatedAt($this->market_updated_at); 
    36603716 
    36613717                $copyObj->setCreatedAt($this->created_at); 
  • trunk/lib/model/om/BaseMarketPeer.php

    r460 r477  
    1414 
    1515         
    16         const NUM_COLUMNS = 86
     16        const NUM_COLUMNS = 87
    1717 
    1818         
     
    270270 
    271271         
    272         const LAST_CHANGE = 'market.LAST_CHANGE'; 
     272        const MARKET_CREATED_AT = 'market.MARKET_CREATED_AT'; 
     273 
     274         
     275        const MARKET_UPDATED_AT = 'market.MARKET_UPDATED_AT'; 
    273276 
    274277         
     
    284287         
    285288        private static $fieldNames = array ( 
    286                 BasePeer::TYPE_PHPNAME => array ('Id', 'ProviderId', 'Reference', 'Agency', 'AgencyCity', 'AgencyAgent', 'AgencyPhone', 'AgencyMail', 'NatureId', 'TypeId', 'Active', 'Exclusivity', 'MandatNumber', 'MandatComment', 'MandatStartDate', 'MandatEndDate', 'AvailableDate', 'Compromise', 'CompromiseDate', 'ReducedCosts', 'KeysInAgency', 'Busy', 'Price', 'LandTax', 'Costs', 'AgencyFees', 'Parts', 'Level', 'Levels', 'Lastlevel', 'PrivateGarden', 'Caves', 'Carparks', 'CarparksOut', 'CarparksBasement', 'State', 'Quiet', 'Exposition', 'View', 'Kitchen', 'Bathrooms', 'Wcs', 'Rooms', 'LivingroomSurface', 'TotalSurface', 'GardenSurface', 'TerraceSurface', 'Comment', 'CommentPrivate', 'Building', 'Sector', 'DistrictId', 'Address1', 'Address2', 'Zipcode', 'City', 'CityInsee', 'StreetInsee', 'StandingType', 'Era', 'HeadingType', 'HotWater', 'Custodian', 'Park', 'Garden', 'Swimmingpool', 'Tennis', 'Lift', 'LegalStatus', 'HouseKind', 'HouseName', 'HousingName', 'LotNum', 'Environnement', 'Configuration', 'Vegetation', 'Access', 'CadastreReference', 'Assainissement', 'Cos', 'Shon', 'BuildingPermit', 'Url', 'LastChange', 'CreatedAt', 'UpdatedAt', ), 
    287                 BasePeer::TYPE_COLNAME => array (MarketPeer::ID, MarketPeer::PROVIDER_ID, MarketPeer::REFERENCE, MarketPeer::AGENCY, MarketPeer::AGENCY_CITY, MarketPeer::AGENCY_AGENT, MarketPeer::AGENCY_PHONE, MarketPeer::AGENCY_MAIL, MarketPeer::NATURE_ID, MarketPeer::TYPE_ID, MarketPeer::ACTIVE, MarketPeer::EXCLUSIVITY, MarketPeer::MANDAT_NUMBER, MarketPeer::MANDAT_COMMENT, MarketPeer::MANDAT_START_DATE, MarketPeer::MANDAT_END_DATE, MarketPeer::AVAILABLE_DATE, MarketPeer::COMPROMISE, MarketPeer::COMPROMISE_DATE, MarketPeer::REDUCED_COSTS, MarketPeer::KEYS_IN_AGENCY, MarketPeer::BUSY, MarketPeer::PRICE, MarketPeer::LAND_TAX, MarketPeer::COSTS, MarketPeer::AGENCY_FEES, MarketPeer::PARTS, MarketPeer::LEVEL, MarketPeer::LEVELS, MarketPeer::LASTLEVEL, MarketPeer::PRIVATE_GARDEN, MarketPeer::CAVES, MarketPeer::CARPARKS, MarketPeer::CARPARKS_OUT, MarketPeer::CARPARKS_BASEMENT, MarketPeer::STATE, MarketPeer::QUIET, MarketPeer::EXPOSITION, MarketPeer::VIEW, MarketPeer::KITCHEN, MarketPeer::BATHROOMS, MarketPeer::WCS, MarketPeer::ROOMS, MarketPeer::LIVINGROOM_SURFACE, MarketPeer::TOTAL_SURFACE, MarketPeer::GARDEN_SURFACE, MarketPeer::TERRACE_SURFACE, MarketPeer::COMMENT, MarketPeer::COMMENT_PRIVATE, MarketPeer::BUILDING, MarketPeer::SECTOR, MarketPeer::DISTRICT_ID, MarketPeer::ADDRESS1, MarketPeer::ADDRESS2, MarketPeer::ZIPCODE, MarketPeer::CITY, MarketPeer::CITY_INSEE, MarketPeer::STREET_INSEE, MarketPeer::STANDING_TYPE, MarketPeer::ERA, MarketPeer::HEADING_TYPE, MarketPeer::HOT_WATER, MarketPeer::CUSTODIAN, MarketPeer::PARK, MarketPeer::GARDEN, MarketPeer::SWIMMINGPOOL, MarketPeer::TENNIS, MarketPeer::LIFT, MarketPeer::LEGAL_STATUS, MarketPeer::HOUSE_KIND, MarketPeer::HOUSE_NAME, MarketPeer::HOUSING_NAME, MarketPeer::LOT_NUM, MarketPeer::ENVIRONNEMENT, MarketPeer::CONFIGURATION, MarketPeer::VEGETATION, MarketPeer::ACCESS, MarketPeer::CADASTRE_REFERENCE, MarketPeer::ASSAINISSEMENT, MarketPeer::COS, MarketPeer::SHON, MarketPeer::BUILDING_PERMIT, MarketPeer::URL, MarketPeer::LAST_CHANGE, MarketPeer::CREATED_AT, MarketPeer::UPDATED_AT, ), 
    288                 BasePeer::TYPE_FIELDNAME => array ('id', 'provider_id', 'reference', 'agency', 'agency_city', 'agency_agent', 'agency_phone', 'agency_mail', 'nature_id', 'type_id', 'active', 'exclusivity', 'mandat_number', 'mandat_comment', 'mandat_start_date', 'mandat_end_date', 'available_date', 'compromise', 'compromise_date', 'reduced_costs', 'keys_in_agency', 'busy', 'price', 'land_tax', 'costs', 'agency_fees', 'parts', 'level', 'levels', 'lastlevel', 'private_garden', 'caves', 'carparks', 'carparks_out', 'carparks_basement', 'state', 'quiet', 'exposition', 'view', 'kitchen', 'bathrooms', 'wcs', 'rooms', 'livingroom_surface', 'total_surface', 'garden_surface', 'terrace_surface', 'comment', 'comment_private', 'building', 'sector', 'district_id', 'address1', 'address2', 'zipcode', 'city', 'city_insee', 'street_insee', 'standing_type', 'era', 'heading_type', 'hot_water', 'custodian', 'park', 'garden', 'swimmingpool', 'tennis', 'lift', 'legal_status', 'house_kind', 'house_name', 'housing_name', 'lot_num', 'environnement', 'configuration', 'vegetation', 'access', 'cadastre_reference', 'assainissement', 'cos', 'shon', 'building_permit', 'url', 'last_change', 'created_at', 'updated_at', ), 
    289                 BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85,
     289                BasePeer::TYPE_PHPNAME => array ('Id', 'ProviderId', 'Reference', 'Agency', 'AgencyCity', 'AgencyAgent', 'AgencyPhone', 'AgencyMail', 'NatureId', 'TypeId', 'Active', 'Exclusivity', 'MandatNumber', 'MandatComment', 'MandatStartDate', 'MandatEndDate', 'AvailableDate', 'Compromise', 'CompromiseDate', 'ReducedCosts', 'KeysInAgency', 'Busy', 'Price', 'LandTax', 'Costs', 'AgencyFees', 'Parts', 'Level', 'Levels', 'Lastlevel', 'PrivateGarden', 'Caves', 'Carparks', 'CarparksOut', 'CarparksBasement', 'State', 'Quiet', 'Exposition', 'View', 'Kitchen', 'Bathrooms', 'Wcs', 'Rooms', 'LivingroomSurface', 'TotalSurface', 'GardenSurface', 'TerraceSurface', 'Comment', 'CommentPrivate', 'Building', 'Sector', 'DistrictId', 'Address1', 'Address2', 'Zipcode', 'City', 'CityInsee', 'StreetInsee', 'StandingType', 'Era', 'HeadingType', 'HotWater', 'Custodian', 'Park', 'Garden', 'Swimmingpool', 'Tennis', 'Lift', 'LegalStatus', 'HouseKind', 'HouseName', 'HousingName', 'LotNum', 'Environnement', 'Configuration', 'Vegetation', 'Access', 'CadastreReference', 'Assainissement', 'Cos', 'Shon', 'BuildingPermit', 'Url', 'MarketCreatedAt', 'MarketUpdatedAt', 'CreatedAt', 'UpdatedAt', ), 
     290                BasePeer::TYPE_COLNAME => array (MarketPeer::ID, MarketPeer::PROVIDER_ID, MarketPeer::REFERENCE, MarketPeer::AGENCY, MarketPeer::AGENCY_CITY, MarketPeer::AGENCY_AGENT, MarketPeer::AGENCY_PHONE, MarketPeer::AGENCY_MAIL, MarketPeer::NATURE_ID, MarketPeer::TYPE_ID, MarketPeer::ACTIVE, MarketPeer::EXCLUSIVITY, MarketPeer::MANDAT_NUMBER, MarketPeer::MANDAT_COMMENT, MarketPeer::MANDAT_START_DATE, MarketPeer::MANDAT_END_DATE, MarketPeer::AVAILABLE_DATE, MarketPeer::COMPROMISE, MarketPeer::COMPROMISE_DATE, MarketPeer::REDUCED_COSTS, MarketPeer::KEYS_IN_AGENCY, MarketPeer::BUSY, MarketPeer::PRICE, MarketPeer::LAND_TAX, MarketPeer::COSTS, MarketPeer::AGENCY_FEES, MarketPeer::PARTS, MarketPeer::LEVEL, MarketPeer::LEVELS, MarketPeer::LASTLEVEL, MarketPeer::PRIVATE_GARDEN, MarketPeer::CAVES, MarketPeer::CARPARKS, MarketPeer::CARPARKS_OUT, MarketPeer::CARPARKS_BASEMENT, MarketPeer::STATE, MarketPeer::QUIET, MarketPeer::EXPOSITION, MarketPeer::VIEW, MarketPeer::KITCHEN, MarketPeer::BATHROOMS, MarketPeer::WCS, MarketPeer::ROOMS, MarketPeer::LIVINGROOM_SURFACE, MarketPeer::TOTAL_SURFACE, MarketPeer::GARDEN_SURFACE, MarketPeer::TERRACE_SURFACE, MarketPeer::COMMENT, MarketPeer::COMMENT_PRIVATE, MarketPeer::BUILDING, MarketPeer::SECTOR, MarketPeer::DISTRICT_ID, MarketPeer::ADDRESS1, MarketPeer::ADDRESS2, MarketPeer::ZIPCODE, MarketPeer::CITY, MarketPeer::CITY_INSEE, MarketPeer::STREET_INSEE, MarketPeer::STANDING_TYPE, MarketPeer::ERA, MarketPeer::HEADING_TYPE, MarketPeer::HOT_WATER, MarketPeer::CUSTODIAN, MarketPeer::PARK, MarketPeer::GARDEN, MarketPeer::SWIMMINGPOOL, MarketPeer::TENNIS, MarketPeer::LIFT, MarketPeer::LEGAL_STATUS, MarketPeer::HOUSE_KIND, MarketPeer::HOUSE_NAME, MarketPeer::HOUSING_NAME, MarketPeer::LOT_NUM, MarketPeer::ENVIRONNEMENT, MarketPeer::CONFIGURATION, MarketPeer::VEGETATION, MarketPeer::ACCESS, MarketPeer::CADASTRE_REFERENCE, MarketPeer::ASSAINISSEMENT, MarketPeer::COS, MarketPeer::SHON, MarketPeer::BUILDING_PERMIT, MarketPeer::URL, MarketPeer::MARKET_CREATED_AT, MarketPeer::MARKET_UPDATED_AT, MarketPeer::CREATED_AT, MarketPeer::UPDATED_AT, ), 
     291                BasePeer::TYPE_FIELDNAME => array ('id', 'provider_id', 'reference', 'agency', 'agency_city', 'agency_agent', 'agency_phone', 'agency_mail', 'nature_id', 'type_id', 'active', 'exclusivity', 'mandat_number', 'mandat_comment', 'mandat_start_date', 'mandat_end_date', 'available_date', 'compromise', 'compromise_date', 'reduced_costs', 'keys_in_agency', 'busy', 'price', 'land_tax', 'costs', 'agency_fees', 'parts', 'level', 'levels', 'lastlevel', 'private_garden', 'caves', 'carparks', 'carparks_out', 'carparks_basement', 'state', 'quiet', 'exposition', 'view', 'kitchen', 'bathrooms', 'wcs', 'rooms', 'livingroom_surface', 'total_surface', 'garden_surface', 'terrace_surface', 'comment', 'comment_private', 'building', 'sector', 'district_id', 'address1', 'address2', 'zipcode', 'city', 'city_insee', 'street_insee', 'standing_type', 'era', 'heading_type', 'hot_water', 'custodian', 'park', 'garden', 'swimmingpool', 'tennis', 'lift', 'legal_status', 'house_kind', 'house_name', 'housing_name', 'lot_num', 'environnement', 'configuration', 'vegetation', 'access', 'cadastre_reference', 'assainissement', 'cos', 'shon', 'building_permit', 'url', 'market_created_at', 'market_updated_at', 'created_at', 'updated_at', ), 
     292                BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86,
    290293        ); 
    291294 
    292295         
    293296        private static $fieldKeys = array ( 
    294                 BasePeer::TYPE_PHPNAME => array ('Id' => 0, 'ProviderId' => 1, 'Reference' => 2, 'Agency' => 3, 'AgencyCity' => 4, 'AgencyAgent' => 5, 'AgencyPhone' => 6, 'AgencyMail' => 7, 'NatureId' => 8, 'TypeId' => 9, 'Active' => 10, 'Exclusivity' => 11, 'MandatNumber' => 12, 'MandatComment' => 13, 'MandatStartDate' => 14, 'MandatEndDate' => 15, 'AvailableDate' => 16, 'Compromise' => 17, 'CompromiseDate' => 18, 'ReducedCosts' => 19, 'KeysInAgency' => 20, 'Busy' => 21, 'Price' => 22, 'LandTax' => 23, 'Costs' => 24, 'AgencyFees' => 25, 'Parts' => 26, 'Level' => 27, 'Levels' => 28, 'Lastlevel' => 29, 'PrivateGarden' => 30, 'Caves' => 31, 'Carparks' => 32, 'CarparksOut' => 33, 'CarparksBasement' => 34, 'State' => 35, 'Quiet' => 36, 'Exposition' => 37, 'View' => 38, 'Kitchen' => 39, 'Bathrooms' => 40, 'Wcs' => 41, 'Rooms' => 42, 'LivingroomSurface' => 43, 'TotalSurface' => 44, 'GardenSurface' => 45, 'TerraceSurface' => 46, 'Comment' => 47, 'CommentPrivate' => 48, 'Building' => 49, 'Sector' => 50, 'DistrictId' => 51, 'Address1' => 52, 'Address2' => 53, 'Zipcode' => 54, 'City' => 55, 'CityInsee' => 56, 'StreetInsee' => 57, 'StandingType' => 58, 'Era' => 59, 'HeadingType' => 60, 'HotWater' => 61, 'Custodian' => 62, 'Park' => 63, 'Garden' => 64, 'Swimmingpool' => 65, 'Tennis' => 66, 'Lift' => 67, 'LegalStatus' => 68, 'HouseKind' => 69, 'HouseName' => 70, 'HousingName' => 71, 'LotNum' => 72, 'Environnement' => 73, 'Configuration' => 74, 'Vegetation' => 75, 'Access' => 76, 'CadastreReference' => 77, 'Assainissement' => 78, 'Cos' => 79, 'Shon' => 80, 'BuildingPermit' => 81, 'Url' => 82, 'LastChange' => 83, 'CreatedAt' => 84, 'UpdatedAt' => 85, ), 
    295                 BasePeer::TYPE_COLNAME => array (MarketPeer::ID => 0, MarketPeer::PROVIDER_ID => 1, MarketPeer::REFERENCE => 2, MarketPeer::AGENCY => 3, MarketPeer::AGENCY_CITY => 4, MarketPeer::AGENCY_AGENT => 5, MarketPeer::AGENCY_PHONE => 6, MarketPeer::AGENCY_MAIL => 7, MarketPeer::NATURE_ID => 8, MarketPeer::TYPE_ID => 9, MarketPeer::ACTIVE => 10, MarketPeer::EXCLUSIVITY => 11, MarketPeer::MANDAT_NUMBER => 12, MarketPeer::MANDAT_COMMENT => 13, MarketPeer::MANDAT_START_DATE => 14, MarketPeer::MANDAT_END_DATE => 15, MarketPeer::AVAILABLE_DATE => 16, MarketPeer::COMPROMISE => 17, MarketPeer::COMPROMISE_DATE => 18, MarketPeer::REDUCED_COSTS => 19, MarketPeer::KEYS_IN_AGENCY => 20, MarketPeer::BUSY => 21, MarketPeer::PRICE => 22, MarketPeer::LAND_TAX => 23, MarketPeer::COSTS => 24, MarketPeer::AGENCY_FEES => 25, MarketPeer::PARTS => 26, MarketPeer::LEVEL => 27, MarketPeer::LEVELS => 28, MarketPeer::LASTLEVEL => 29, MarketPeer::PRIVATE_GARDEN => 30, MarketPeer::CAVES => 31, MarketPeer::CARPARKS => 32, MarketPeer::CARPARKS_OUT => 33, MarketPeer::CARPARKS_BASEMENT => 34, MarketPeer::STATE => 35, MarketPeer::QUIET => 36, MarketPeer::EXPOSITION => 37, MarketPeer::VIEW => 38, MarketPeer::KITCHEN => 39, MarketPeer::BATHROOMS => 40, MarketPeer::WCS => 41, MarketPeer::ROOMS => 42, MarketPeer::LIVINGROOM_SURFACE => 43, MarketPeer::TOTAL_SURFACE => 44, MarketPeer::GARDEN_SURFACE => 45, MarketPeer::TERRACE_SURFACE => 46, MarketPeer::COMMENT => 47, MarketPeer::COMMENT_PRIVATE => 48, MarketPeer::BUILDING => 49, MarketPeer::SECTOR => 50, MarketPeer::DISTRICT_ID => 51, MarketPeer::ADDRESS1 => 52, MarketPeer::ADDRESS2 => 53, MarketPeer::ZIPCODE => 54, MarketPeer::CITY => 55, MarketPeer::CITY_INSEE => 56, MarketPeer::STREET_INSEE => 57, MarketPeer::STANDING_TYPE => 58, MarketPeer::ERA => 59, MarketPeer::HEADING_TYPE => 60, MarketPeer::HOT_WATER => 61, MarketPeer::CUSTODIAN => 62, MarketPeer::PARK => 63, MarketPeer::GARDEN => 64, MarketPeer::SWIMMINGPOOL => 65, MarketPeer::TENNIS => 66, MarketPeer::LIFT => 67, MarketPeer::LEGAL_STATUS => 68, MarketPeer::HOUSE_KIND => 69, MarketPeer::HOUSE_NAME => 70, MarketPeer::HOUSING_NAME => 71, MarketPeer::LOT_NUM => 72, MarketPeer::ENVIRONNEMENT => 73, MarketPeer::CONFIGURATION => 74, MarketPeer::VEGETATION => 75, MarketPeer::ACCESS => 76, MarketPeer::CADASTRE_REFERENCE => 77, MarketPeer::ASSAINISSEMENT => 78, MarketPeer::COS => 79, MarketPeer::SHON => 80, MarketPeer::BUILDING_PERMIT => 81, MarketPeer::URL => 82, MarketPeer::LAST_CHANGE => 83, MarketPeer::CREATED_AT => 84, MarketPeer::UPDATED_AT => 85, ), 
    296                 BasePeer::TYPE_FIELDNAME => array ('id' => 0, 'provider_id' => 1, 'reference' => 2, 'agency' => 3, 'agency_city' => 4, 'agency_agent' => 5, 'agency_phone' => 6, 'agency_mail' => 7, 'nature_id' => 8, 'type_id' => 9, 'active' => 10, 'exclusivity' => 11, 'mandat_number' => 12, 'mandat_comment' => 13, 'mandat_start_date' => 14, 'mandat_end_date' => 15, 'available_date' => 16, 'compromise' => 17, 'compromise_date' => 18, 'reduced_costs' => 19, 'keys_in_agency' => 20, 'busy' => 21, 'price' => 22, 'land_tax' => 23, 'costs' => 24, 'agency_fees' => 25, 'parts' => 26, 'level' => 27, 'levels' => 28, 'lastlevel' => 29, 'private_garden' => 30, 'caves' => 31, 'carparks' => 32, 'carparks_out' => 33, 'carparks_basement' => 34, 'state' => 35, 'quiet' => 36, 'exposition' => 37, 'view' => 38, 'kitchen' => 39, 'bathrooms' => 40, 'wcs' => 41, 'rooms' => 42, 'livingroom_surface' => 43, 'total_surface' => 44, 'garden_surface' => 45, 'terrace_surface' => 46, 'comment' => 47, 'comment_private' => 48, 'building' => 49, 'sector' => 50, 'district_id' => 51, 'address1' => 52, 'address2' => 53, 'zipcode' => 54, 'city' => 55, 'city_insee' => 56, 'street_insee' => 57, 'standing_type' => 58, 'era' => 59, 'heading_type' => 60, 'hot_water' => 61, 'custodian' => 62, 'park' => 63, 'garden' => 64, 'swimmingpool' => 65, 'tennis' => 66, 'lift' => 67, 'legal_status' => 68, 'house_kind' => 69, 'house_name' => 70, 'housing_name' => 71, 'lot_num' => 72, 'environnement' => 73, 'configuration' => 74, 'vegetation' => 75, 'access' => 76, 'cadastre_reference' => 77, 'assainissement' => 78, 'cos' => 79, 'shon' => 80, 'building_permit' => 81, 'url' => 82, 'last_change' => 83, 'created_at' => 84, 'updated_at' => 85, ), 
    297                 BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85,
     297                BasePeer::TYPE_PHPNAME => array ('Id' => 0, 'ProviderId' => 1, 'Reference' => 2, 'Agency' => 3, 'AgencyCity' => 4, 'AgencyAgent' => 5, 'AgencyPhone' => 6, 'AgencyMail' => 7, 'NatureId' => 8, 'TypeId' => 9, 'Active' => 10, 'Exclusivity' => 11, 'MandatNumber' => 12, 'MandatComment' => 13, 'MandatStartDate' => 14, 'MandatEndDate' => 15, 'AvailableDate' => 16, 'Compromise' => 17, 'CompromiseDate' => 18, 'ReducedCosts' => 19, 'KeysInAgency' => 20, 'Busy' => 21, 'Price' => 22, 'LandTax' => 23, 'Costs' => 24, 'AgencyFees' => 25, 'Parts' => 26, 'Level' => 27, 'Levels' => 28, 'Lastlevel' => 29, 'PrivateGarden' => 30, 'Caves' => 31, 'Carparks' => 32, 'CarparksOut' => 33, 'CarparksBasement' => 34, 'State' => 35, 'Quiet' => 36, 'Exposition' => 37, 'View' => 38, 'Kitchen' => 39, 'Bathrooms' => 40, 'Wcs' => 41, 'Rooms' => 42, 'LivingroomSurface' => 43, 'TotalSurface' => 44, 'GardenSurface' => 45, 'TerraceSurface' => 46, 'Comment' => 47, 'CommentPrivate' => 48, 'Building' => 49, 'Sector' => 50, 'DistrictId' => 51, 'Address1' => 52, 'Address2' => 53, 'Zipcode' => 54, 'City' => 55, 'CityInsee' => 56, 'StreetInsee' => 57, 'StandingType' => 58, 'Era' => 59, 'HeadingType' => 60, 'HotWater' => 61, 'Custodian' => 62, 'Park' => 63, 'Garden' => 64, 'Swimmingpool' => 65, 'Tennis' => 66, 'Lift' => 67, 'LegalStatus' => 68, 'HouseKind' => 69, 'HouseName' => 70, 'HousingName' => 71, 'LotNum' => 72, 'Environnement' => 73, 'Configuration' => 74, 'Vegetation' => 75, 'Access' => 76, 'CadastreReference' => 77, 'Assainissement' => 78, 'Cos' => 79, 'Shon' => 80, 'BuildingPermit' => 81, 'Url' => 82, 'MarketCreatedAt' => 83, 'MarketUpdatedAt' => 84, 'CreatedAt' => 85, 'UpdatedAt' => 86, ), 
     298                BasePeer::TYPE_COLNAME => array (MarketPeer::ID => 0, MarketPeer::PROVIDER_ID => 1, MarketPeer::REFERENCE => 2, MarketPeer::AGENCY => 3, MarketPeer::AGENCY_CITY => 4, MarketPeer::AGENCY_AGENT => 5, MarketPeer::AGENCY_PHONE => 6, MarketPeer::AGENCY_MAIL => 7, MarketPeer::NATURE_ID => 8, MarketPeer::TYPE_ID => 9, MarketPeer::ACTIVE => 10, MarketPeer::EXCLUSIVITY => 11, MarketPeer::MANDAT_NUMBER => 12, MarketPeer::MANDAT_COMMENT => 13, MarketPeer::MANDAT_START_DATE => 14, MarketPeer::MANDAT_END_DATE => 15, MarketPeer::AVAILABLE_DATE => 16, MarketPeer::COMPROMISE => 17, MarketPeer::COMPROMISE_DATE => 18, MarketPeer::REDUCED_COSTS => 19, MarketPeer::KEYS_IN_AGENCY => 20, MarketPeer::BUSY => 21, MarketPeer::PRICE => 22, MarketPeer::LAND_TAX => 23, MarketPeer::COSTS => 24, MarketPeer::AGENCY_FEES => 25, MarketPeer::PARTS => 26, MarketPeer::LEVEL => 27, MarketPeer::LEVELS => 28, MarketPeer::LASTLEVEL => 29, MarketPeer::PRIVATE_GARDEN => 30, MarketPeer::CAVES => 31, MarketPeer::CARPARKS => 32, MarketPeer::CARPARKS_OUT => 33, MarketPeer::CARPARKS_BASEMENT => 34, MarketPeer::STATE => 35, MarketPeer::QUIET => 36, MarketPeer::EXPOSITION => 37, MarketPeer::VIEW => 38, MarketPeer::KITCHEN => 39, MarketPeer::BATHROOMS => 40, MarketPeer::WCS => 41, MarketPeer::ROOMS => 42, MarketPeer::LIVINGROOM_SURFACE => 43, MarketPeer::TOTAL_SURFACE => 44, MarketPeer::GARDEN_SURFACE => 45, MarketPeer::TERRACE_SURFACE => 46, MarketPeer::COMMENT => 47, MarketPeer::COMMENT_PRIVATE => 48, MarketPeer::BUILDING => 49, MarketPeer::SECTOR => 50, MarketPeer::DISTRICT_ID => 51, MarketPeer::ADDRESS1 => 52, MarketPeer::ADDRESS2 => 53, MarketPeer::ZIPCODE => 54, MarketPeer::CITY => 55, MarketPeer::CITY_INSEE => 56, MarketPeer::STREET_INSEE => 57, MarketPeer::STANDING_TYPE => 58, MarketPeer::ERA => 59, MarketPeer::HEADING_TYPE => 60, MarketPeer::HOT_WATER => 61, MarketPeer::CUSTODIAN => 62, MarketPeer::PARK => 63, MarketPeer::GARDEN => 64, MarketPeer::SWIMMINGPOOL => 65, MarketPeer::TENNIS => 66, MarketPeer::LIFT => 67, MarketPeer::LEGAL_STATUS => 68, MarketPeer::HOUSE_KIND => 69, MarketPeer::HOUSE_NAME => 70, MarketPeer::HOUSING_NAME => 71, MarketPeer::LOT_NUM => 72, MarketPeer::ENVIRONNEMENT => 73, MarketPeer::CONFIGURATION => 74, MarketPeer::VEGETATION => 75, MarketPeer::ACCESS => 76, MarketPeer::CADASTRE_REFERENCE => 77, MarketPeer::ASSAINISSEMENT => 78, MarketPeer::COS => 79, MarketPeer::SHON => 80, MarketPeer::BUILDING_PERMIT => 81, MarketPeer::URL => 82, MarketPeer::MARKET_CREATED_AT => 83, MarketPeer::MARKET_UPDATED_AT => 84, MarketPeer::CREATED_AT => 85, MarketPeer::UPDATED_AT => 86, ), 
     299                BasePeer::TYPE_FIELDNAME => array ('id' => 0, 'provider_id' => 1, 'reference' => 2, 'agency' => 3, 'agency_city' => 4, 'agency_agent' => 5, 'agency_phone' => 6, 'agency_mail' => 7, 'nature_id' => 8, 'type_id' => 9, 'active' => 10, 'exclusivity' => 11, 'mandat_number' => 12, 'mandat_comment' => 13, 'mandat_start_date' => 14, 'mandat_end_date' => 15, 'available_date' => 16, 'compromise' => 17, 'compromise_date' => 18, 'reduced_costs' => 19, 'keys_in_agency' => 20, 'busy' => 21, 'price' => 22, 'land_tax' => 23, 'costs' => 24, 'agency_fees' => 25, 'parts' => 26, 'level' => 27, 'levels' => 28, 'lastlevel' => 29, 'private_garden' => 30, 'caves' => 31, 'carparks' => 32, 'carparks_out' => 33, 'carparks_basement' => 34, 'state' => 35, 'quiet' => 36, 'exposition' => 37, 'view' => 38, 'kitchen' => 39, 'bathrooms' => 40, 'wcs' => 41, 'rooms' => 42, 'livingroom_surface' => 43, 'total_surface' => 44, 'garden_surface' => 45, 'terrace_surface' => 46, 'comment' => 47, 'comment_private' => 48, 'building' => 49, 'sector' => 50, 'district_id' => 51, 'address1' => 52, 'address2' => 53, 'zipcode' => 54, 'city' => 55, 'city_insee' => 56, 'street_insee' => 57, 'standing_type' => 58, 'era' => 59, 'heading_type' => 60, 'hot_water' => 61, 'custodian' => 62, 'park' => 63, 'garden' => 64, 'swimmingpool' => 65, 'tennis' => 66, 'lift' => 67, 'legal_status' => 68, 'house_kind' => 69, 'house_name' => 70, 'housing_name' => 71, 'lot_num' => 72, 'environnement' => 73, 'configuration' => 74, 'vegetation' => 75, 'access' => 76, 'cadastre_reference' => 77, 'assainissement' => 78, 'cos' => 79, 'shon' => 80, 'building_permit' => 81, 'url' => 82, 'market_created_at' => 83, 'market_updated_at' => 84, 'created_at' => 85, 'updated_at' => 86, ), 
     300                BasePeer::TYPE_NUM => array (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86,
    298301        ); 
    299302 
     
    514517                $criteria->addSelectColumn(MarketPeer::URL); 
    515518 
    516                 $criteria->addSelectColumn(MarketPeer::LAST_CHANGE); 
     519                $criteria->addSelectColumn(MarketPeer::MARKET_CREATED_AT); 
     520 
     521                $criteria->addSelectColumn(MarketPeer::MARKET_UPDATED_AT); 
    517522 
    518523                $criteria->addSelectColumn(MarketPeer::CREATED_AT);