Changeset 455

Show
Ignore:
Timestamp:
11/17/08 17:12:11 (2 months ago)
Author:
arnaud
Message:

Bourse : schema + libs - Ajout champs supplémentaires

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/config/schema.xml

    r446 r455  
    24712471    <column required="false" name="agency"                                  type="varchar" size="100"/> 
    24722472    <column required="false" name="agency_city"                             type="varchar" size="100"/> 
     2473    <column required="false" name="agency_agent"                            type="varchar" size="100"/> 
     2474    <column required="false" name="agency_phone"                            type="varchar" size="100"/> 
     2475    <column required="false" name="agency_mail"                             type="varchar" size="100"/> 
    24732476    <column required="true" name="nature_id"                       type="integer" size="11"/> 
    24742477    <foreign-key foreignTable="market_nature"> 
    …… 
    25202523    <column required="false" name="building"                            type="varchar" size="100"/> 
    25212524    <column required="false" name="sector"                               type="varchar" size="100"/> 
     2525    <column required="false" name="district_id"                type="integer" size="11"/> 
     2526    <foreign-key foreignTable="apidistrict"> 
     2527      <reference local="district_id" foreign="id"/> 
     2528    </foreign-key> 
    25222529    <column required="false" name="address1"           type="varchar" size="100"/> 
    25232530    <column required="false" name="address2"           type="varchar" size="100"/> 

  • trunk/lib/model/map/MarketMapBuilder.php

    r444 r455  
    199199                $tMap->addColumn('URL', 'Url', 'string', CreoleTypes::VARCHAR, false, 160); 
    200200 
    201                 $tMap->addColumn('LAST_CHANGE', 'LastChange', 'int', CreoleTypes::TIMESTAMP, false, null); 
    202  
    203201                $tMap->addColumn('CREATED_AT', 'CreatedAt', 'int', CreoleTypes::TIMESTAMP, false, null); 
    204202 

  • trunk/lib/model/om/BaseMarket.php

    r444 r455  
    339339         
    340340        protected $url; 
    341  
    342  
    343          
    344         protected $last_change; 
    345341 
    346342 
    …… 
    10181014 
    10191015         
    1020         public function getLastChange($format = 'Y-m-d H:i:s') 
    1021         { 
    1022  
    1023                 if ($this->last_change === null || $this->last_change === '') { 
    1024                         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)); 
    1028                         } 
    1029                 } else { 
    1030                         $ts = $this->last_change; 
    1031                 } 
    1032                 if ($format === null) { 
    1033                         return $ts; 
    1034                 } elseif (strpos($format, '%') !== false) { 
    1035                         return strftime($format, $ts); 
    1036                 } else { 
    1037                         return date($format, $ts); 
    1038                 } 
    1039         } 
    1040  
    1041          
    10421016        public function getCreatedAt($format = 'Y-m-d H:i:s') 
    10431017        { 
    …… 
    22102184        }  
    22112185         
    2212         public function setLastChange($v) 
    2213         { 
    2214  
    2215                 if ($v !== null && !is_int($v)) { 
    2216                         $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)); 
    2218                         } 
    2219                 } else { 
    2220                         $ts = $v; 
    2221                 } 
    2222                 if ($this->last_change !== $ts) { 
    2223                         $this->last_change = $ts; 
    2224                         $this->modifiedColumns[] = MarketPeer::LAST_CHANGE; 
    2225                 } 
    2226  
    2227         }  
    2228          
    22292186        public function setCreatedAt($v) 
    22302187        { 
    …… 
    24312388                        $this->url = $rs->getString($startcol + 82); 
    24322389 
    2433                         $this->last_change = $rs->getTimestamp($startcol + 83, null); 
    2434  
    2435                         $this->created_at = $rs->getTimestamp($startcol + 84, null); 
    2436  
    2437                         $this->updated_at = $rs->getTimestamp($startcol + 85, null); 
     2390                        $this->created_at = $rs->getTimestamp($startcol + 83, null); 
     2391 
     2392                        $this->updated_at = $rs->getTimestamp($startcol + 84, null); 
    24382393 
    24392394                        $this->resetModified(); 
    …… 
    24412396                        $this->setNew(false); 
    24422397 
    2443                                                 return $startcol + 86;  
     2398                                                return $startcol + 85;  
    24442399                } catch (Exception $e) { 
    24452400                        throw new PropelException("Error populating Market object", $e); 
    …… 
    29002855                                break; 
    29012856                        case 83: 
    2902                                 return $this->getLastChange(); 
     2857                                return $this->getCreatedAt(); 
    29032858                                break; 
    29042859                        case 84: 
    2905                                 return $this->getCreatedAt(); 
    2906                                 break; 
    2907                         case 85: 
    29082860                                return $this->getUpdatedAt(); 
    29092861                                break; 
    …… 
    30012953                        $keys[81] => $this->getBuildingPermit(), 
    30022954                        $keys[82] => $this->getUrl(), 
    3003                         $keys[83] => $this->getLastChange(), 
    3004                         $keys[84] => $this->getCreatedAt(), 
    3005                         $keys[85] => $this->getUpdatedAt(), 
     2955                        $keys[83] => $this->getCreatedAt(), 
     2956                        $keys[84] => $this->getUpdatedAt(), 
    30062957                ); 
    30072958                return $result; 
    …… 
    32693220                                break; 
    32703221                        case 83: 
    3271                                 $this->setLastChange($value); 
     3222                                $this->setCreatedAt($value); 
    32723223                                break; 
    32733224                        case 84: 
    3274                                 $this->setCreatedAt($value); 
    3275                                 break; 
    3276                         case 85: 
    32773225                                $this->setUpdatedAt($value); 
    32783226                                break; 
    …… 
    33673315                if (array_key_exists($keys[81], $arr)) $this->setBuildingPermit($arr[$keys[81]]); 
    33683316                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]]); 
     3317                if (array_key_exists($keys[83], $arr)) $this->setCreatedAt($arr[$keys[83]]); 
     3318                if (array_key_exists($keys[84], $arr)) $this->setUpdatedAt($arr[$keys[84]]); 
    33723319        } 
    33733320 
    …… 
    34603407                if ($this->isColumnModified(MarketPeer::BUILDING_PERMIT)) $criteria->add(MarketPeer::BUILDING_PERMIT, $this->building_permit); 
    34613408                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); 
    34633409                if ($this->isColumnModified(MarketPeer::CREATED_AT)) $criteria->add(MarketPeer::CREATED_AT, $this->created_at); 
    34643410                if ($this->isColumnModified(MarketPeer::UPDATED_AT)) $criteria->add(MarketPeer::UPDATED_AT, $this->updated_at); 
    …… 
    36563602 
    36573603                $copyObj->setUrl($this->url); 
    3658  
    3659                 $copyObj->setLastChange($this->last_change); 
    36603604 
    36613605                $copyObj->setCreatedAt($this->created_at); 

  • trunk/lib/model/om/BaseMarketPeer.php

    r444 r455  
    1414 
    1515         
    16         const NUM_COLUMNS = 86; 
     16        const NUM_COLUMNS = 85; 
    1717 
    1818         
    …… 
    270270 
    271271         
    272         const LAST_CHANGE = 'market.LAST_CHANGE'; 
    273  
    274          
    275272        const CREATED_AT = 'market.CREATED_AT'; 
    276273 
    …… 
    284281         
    285282        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, ) 
     283                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', 'CreatedAt', 'UpdatedAt', ), 
     284                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::CREATED_AT, MarketPeer::UPDATED_AT, ), 
     285                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', 'created_at', 'updated_at', ), 
     286                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, ) 
    290287        ); 
    291288 
    292289         
    293290        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, ) 
     291                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, 'CreatedAt' => 83, 'UpdatedAt' => 84, ), 
     292                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::CREATED_AT => 83, MarketPeer::UPDATED_AT => 84, ), 
     293                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, 'created_at' => 83, 'updated_at' => 84, ), 
     294                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, ) 
    298295        ); 
    299296 
    …… 
    513510 
    514511                $criteria->addSelectColumn(MarketPeer::URL); 
    515  
    516                 $criteria->addSelectColumn(MarketPeer::LAST_CHANGE); 
    517512 
    518513                $criteria->addSelectColumn(MarketPeer::CREATED_AT);