Changeset 460

Show
Ignore:
Timestamp:
11/20/08 19:14:41 (2 months ago)
Author:
arnaud
Message:

Catalogue PDF : français / anglais, mentions légales, possibilité en-tête différents

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/apps/intranet/modules/catalog/actions/actions.class.php

    r215 r460  
    149149        } 
    150150         
    151         $this->showname = $this->getUser()->getSubscriber(); 
    152151         
    153152    //Headers 

  • trunk/apps/intranet/modules/catalog/templates/printSuccess.php

    r182 r460  
    77define('AGENCE_ADR2',$agency->getAddress2()); 
    88define('AGENCE_CITY',$agency->getPostalCode().' '.$agency->getCity()); 
    9 define('AGENCE_TEL' ,'Tel. '.$agency->getTel()); 
    10 define('AGENCE_FAX' ,'Fax. '.$agency->getFax()); 
     9define('AGENCE_TEL' ,ucfirst(__('phone')).' : '.$agency->getTel()); 
     10define('AGENCE_FAX' ,ucfirst(__('fax')).' : '.$agency->getFax()); 
    1111define('AGENCE_MAIL',$agency->getMail()); 
    1212define('AGENCE_URL',$agency->getUrl()); 
    …… 
    3232  { 
    3333    /* logo */ 
    34     $this->Image(LOGO_URL, 10, 10, 40); 
     34    global $LOGO_SIZE; 
     35    if($LOGO_SIZE && $LOGO_SIZE > 1000) 
     36      $this->Image(AGENCE_IMG, 10, 10, 190); 
     37    elseif($LOGO_SIZE && $LOGO_SIZE < 1000) 
     38      $this->Image(AGENCE_IMG, 10, 10, (($LOGO_SIZE*3)/22)); 
     39    else 
     40      $this->Image(AGENCE_IMG, 10, 10, 40); 
     41       
    3542    /* Agence */ 
    36     $this->SetFont('Vera','B',10); 
    37     $this->SetTextColor(0,0,0); 
    38     $this->Cell(0,5,AGENCE_NAME,0,0,'R'); 
    39     $this->Ln(4); 
    40     $this->SetFont('Vera','',10); 
    41     $this->Cell(0,5,AGENCE_ADR1,0,0,'R'); 
    42     $this->Ln(4); 
    43     if(AGENCE_ADR2) { 
    44       $this->Cell(0,5,AGENCE_ADR2,0,0,'R'); 
     43    if(!$LOGO_SIZE || ($LOGO_SIZE && $LOGO_SIZE < 1000)): 
     44      $this->SetFont('Vera','B',10); 
     45      $this->SetTextColor(0,0,0); 
     46      $this->Cell(0,5,AGENCE_NAME,0,0,'R'); 
    4547      $this->Ln(4); 
    46     } 
    47     $this->Cell(0,5,AGENCE_CITY,0,0,'R'); 
    48     $this->Ln(4); 
    49     $this->Cell(0,5,AGENCE_TEL,0,0,'R'); 
    50     $this->Ln(4); 
    51     $this->Cell(0,5,AGENCE_FAX,0,0,'R'); 
    52     $this->Ln(4); 
    53     $this->Cell(0,5,AGENCE_MAIL,0,0,'R'); 
     48      $this->SetFont('Vera','',10); 
     49      $this->Cell(0,5,AGENCE_ADR1,0,0,'R'); 
     50      $this->Ln(4); 
     51      if(AGENCE_ADR2) { 
     52        $this->Cell(0,5,AGENCE_ADR2,0,0,'R'); 
     53        $this->Ln(4); 
     54      } 
     55      $this->Cell(0,5,AGENCE_CITY,0,0,'R'); 
     56      $this->Ln(4); 
     57      $this->Cell(0,5,AGENCE_TEL,0,0,'R'); 
     58      $this->Ln(4); 
     59      $this->Cell(0,5,AGENCE_FAX,0,0,'R'); 
     60      $this->Ln(4); 
     61      $this->Cell(0,5,AGENCE_MAIL,0,0,'R'); 
     62    endif; 
    5463  } 
    5564 
    …… 
    6877    //Infos non contractuelles 
    6978    $this->Ln(10); 
    70     $this->SetFont('Vera','',10); 
     79    $this->SetFont('Vera','',9); 
    7180    $this->SetTextColor(0,0,0); 
    72     $this->MultiCell(0,8,ucfirst(__('not contractual information - Not to throw on the public highway'))."\n".ucfirst(__('inclusive Agency fees - Printed by our care')),0,'C'); 
     81    $this->Cell(0,8,ucfirst(__('agency fees included')).' - '.ucfirst(__('not contractual information')).' - '.ucfirst(__('please do not litter on public way')).' - '.ucfirst(__('printed with care')),0,0,'C'); 
     82    $this->Ln(5); 
     83    $this->Cell(0,8,(sfContext::getInstance()->getUser()->getSubscriber()->getAgency()->getSiretNum() ? ucfirst(__('siret')).' : '.sfContext::getInstance()->getUser()->getSubscriber()->getAgency()->getSiretNum() : null).(sfContext::getInstance()->getUser()->getSubscriber()->getAgency()->getCaisseGarantieNum() ? ' - Garantie : '.sfContext::getInstance()->getUser()->getSubscriber()->getAgency()->getCaisseGarantieNum() : null).(sfContext::getInstance()->getUser()->getSubscriber()->getAgency()->getCarteProfessionnelleNum() ? ' - CP : '.sfContext::getInstance()->getUser()->getSubscriber()->getAgency()->getCarteProfessionnelleNum() : null),0,0,'C'); 
    7384  } 
    7485} 

  • trunk/apps/intranet/modules/print/templates/_catalogue.php

    r194 r460  
    77$line=0; 
    88$coo_x = 10; 
    9 $coo_y = 40; 
     9$coo_y = 45; 
    1010$pdf->setX(10); 
    11 if($showname): 
    12   $pdf->SetFont('Vera','B',10); 
    13   $pdf->setY(30); 
    14   $pdf->Cell(0,12,"Catalogue proposé par ".sfContext::getInstance()->getUser()->getSubscriber()); 
    15 endif; 
    16 $pdf->setY(40); 
     11$pdf->setY(43); 
    1712$pdf->SetLeftMargin(10); 
    1813foreach ($sales as $sale): 
    …… 
    2924      $pdf->AddPage(); 
    3025      $coo_x = 10; 
    31       $coo_y = 40; 
     26      $coo_y = 43; 
    3227      $pdf->SetX(10); 
    3328      $pdf->SetY(40); 
    …… 
    5045      if($img_l>0): 
    5146        if($img_h<=75)://round((40 - ($img_l/100*40))/2) 
    52           $pdf->Image($img_path, $coo_x, $coo_y, 40, null, 'JPG'); 
     47          $pdf->Image($img_path, $coo_x, $coo_y, 40, null); 
    5348        else: 
    54           $pdf->Image($img_path, $coo_x, $coo_y, null, 30, 'JPG'); 
     49          $pdf->Image($img_path, $coo_x, $coo_y, null, 30); 
    5550        endif; 
    5651      endif; 
    …… 
    6560  $pdf->SetLeftMargin($coo_x); 
    6661  $pdf->SetFont('Vera', '', 9); 
    67   $pdf->Cell(20,10,'Réf. '.$sale->getId(),0,0); 
     62  $pdf->Cell(20,10,ucfirst(__('ref')).' '.$sale->getId(),0,0); 
    6863  if($sale->getEstate()->getParts()>0) $pdf->Cell(20,10,$sale->getEstate()->getPartsName(),0,0,'R'); 
    6964  elseif($sale->getEstate()->getSurfaceHabitable()>'0') $pdf->Cell(20,10,$sale->getEstate()->getSurfaceHabitable().'m²',0,0,'R'); 

  • trunk/apps/intranet/modules/print/templates/_catalogueline.php

    r182 r460  
    99$coo_y = 50; 
    1010$pdf->setX(10); 
    11 if($contact->getId()){ 
    12         $pdf->SetFont('Arial','B',10); 
    13         $pdf->setY(35); 
    14         $pdf->Cell(0,12,"Sélection personnalisée à l'attention de : ".$contact.". (Par ".sfContext::getInstance()->getUser()->getSubscriber().")"); 
    15 } 
    16 elseif($showname){ 
    17         $pdf->SetFont('Vera','B',10); 
    18         $pdf->setY(35); 
    19         $pdf->Cell(0,12,"Catalogue par ".sfContext::getInstance()->getUser()->getSubscriber()); 
    20 } 
    2111$pdf->setY(40); 
    2212$pdf->SetLeftMargin(10); 
    …… 
    8171        $pdf->setX($coo_x+42); 
    8272        $pdf->SetFont('Vera','B',9); 
    83         $pdf->Cell(20,10,'Réf. '.$sale->getId(),0,0); 
     73        $pdf->Cell(20,10,ucfirst(__('ref')).' '.$sale->getId(),0,0); 
    8474        $pdf->SetFont('Vera','B',12); 
    8575        $pdf->SetTextColor(0,103,179); 
    …… 
    8878        $pdf->SetTextColor(0,0,0); 
    8979        $pdf->SetFont('Vera','B',9); 
    90         if($sale->getEstate()->getParts()) $infos = $sale->getEstate()->getParts().' piÚce(s) - '; else $infos = ''; 
     80        if($sale->getEstate()->getParts()) $infos = $sale->getEstate()->getPartsName(); else $infos = ''; 
    9181        if($sale->getEstate()->getSurfaceHabitable()!='0') $pdf->Cell(0,10,$infos.$sale->getEstate()->getSurfaceHabitable().'m²',0,0,'R'); 
    9282        $pdf->Ln(10); 
    …… 
    9787        if($sale->getEstate()->getSector()) 
    9888    $description_1 .= $sale->getEstate()->getSector().', '; 
    99     if($sale->getEstate()->getCommentMarketing()) 
    100     $description_1 .= $sale->getEstate()->getCommentMarketing(); 
     89    if($sf_user->getCulture()=='en_GB') 
     90      $description_1 .= $sale->getEstate()->getCommentMarketingEn(); 
     91    else 
     92      $description_1 .= $sale->getEstate()->getCommentMarketing(); 
    10193        $description = substr($description_1,0,230); 
    10294        if(strlen($description_1)>230) $description.=' ...'; 
    103         $pdf->MultiCell(0, 4,preg_replace("/(\r\n|\n|\r)/", " ",$description)); 
     95        $pdf->MultiCell(0, 4,preg_replace("/(\r\n|\n|\r)/", " ",$description)."\n"); 
    10496        $pdf->setX($coo_x+40); 
    10597        $pdf->SetY($coo_y+32); 

  • trunk/config/schema.xml

    r455 r460  
    25352535    <column required="false" name="standing_type"      type="varchar" size="100"/> 
    25362536    <column required="false" name="era"                type="varchar" size="100"/> 
    2537     <column required="false" name="heading_type"          type="varchar" size="100"/> 
     2537    <column required="false" name="heading_type"         type="varchar" size="100"/> 
    25382538    <column required="false" name="hot_water"          type="varchar" size="100"/> 
    25392539    <column required="false" name="custodian"          type="boolean" default="0"/> 
    …… 
    25422542    <column required="false" name="swimmingpool"       type="boolean" default="0"/> 
    25432543    <column required="false" name="tennis"             type="boolean" default="0"/> 
    2544     <column required="false" name="lift"                      type="boolean" default="0"/> 
    2545     <column required="false" name="legal_status"          type="varchar" size="100"/> 
     2544    <column required="false" name="lift"                     type="boolean" default="0"/> 
     2545    <column required="false" name="legal_status"         type="varchar" size="100"/> 
    25462546    <column required="false" name="house_kind"         type="varchar" size="100"/> 
    25472547    <column required="false" name="house_name"         type="varchar" size="100"/> 
    2548     <column required="false" name="housing_name"          type="varchar" size="100"/> 
     2548    <column required="false" name="housing_name"         type="varchar" size="100"/> 
    25492549    <column required="false" name="lot_num"            type="varchar" size="100"/> 
    25502550    <column required="false" name="environnement"            type="varchar" size="100"/> 
    25512551    <column required="false" name="configuration"            type="varchar" size="100"/> 
    25522552    <column required="false" name="vegetation"         type="varchar" size="100"/> 
    2553     <column required="false" name="access"                  type="varchar" size="100"/> 
     2553    <column required="false" name="access"                 type="varchar" size="100"/> 
    25542554    <column required="false" name="cadastre_reference" type="varchar" size="100"/> 
    25552555    <column required="false" name="assainissement"     type="varchar" size="100"/> 
    25562556    <column required="false" name="cos"                type="integer" size="11"/> 
    2557     <column required="false" name="shon"                                  type="integer" size="11"/> 
     2557    <column required="false" name="shon"                                 type="integer" size="11"/> 
    25582558    <column required="false" name="building_permit"        type="boolean" default="0"/> 
    2559     <column required="false" name="url"                   type="varchar" size="160"/> 
     2559    <column required="false" name="url"                    type="varchar" size="160"/> 
     2560    <column required="false" name="last_change"        type="date"/> 
    25602561    <column required="false" name="created_at"         type="timestamp"/> 
    25612562    <column required="false" name="updated_at"         type="timestamp"/> 

  • trunk/lib/model/Estate.php

    r413 r460  
    5353    if($this->getSector()) 
    5454    $Texte .= $this->getSector().', '; 
    55     if($this->getCommentMarketing()) 
    56     $Texte .= $this->getCommentMarketing(); 
     55    if(sfContext::getInstance()->getUser()->getCulture()=='en_GB') 
     56      $Texte .= $this->getCommentMarketingEn(); 
     57    else 
     58      $Texte .= $this->getCommentMarketing(); 
    5759 
    5860    if ( strlen($Texte) > $nbcar && (0!=$nbcar) )  

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

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

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

    r455 r460  
    339339         
    340340        protected $url; 
     341 
     342 
     343         
     344        protected $last_change; 
    341345 
    342346 
    …… 
    10141018 
    10151019         
     1020        public function getLastChange($format = 'Y-m-d') 
     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         
    10161042        public function getCreatedAt($format = 'Y-m-d H:i:s') 
    10171043        { 
    …… 
    21842210        }  
    21852211         
     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         
    21862229        public function setCreatedAt($v) 
    21872230        { 
    …… 
    23882431                        $this->url = $rs->getString($startcol + 82); 
    23892432 
    2390                         $this->created_at = $rs->getTimestamp($startcol + 83, null); 
    2391  
    2392                         $this->updated_at = $rs->getTimestamp($startcol + 84, null); 
     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); 
    23932438 
    23942439                        $this->resetModified(); 
    …… 
    23962441                        $this->setNew(false); 
    23972442 
    2398                                                 return $startcol + 85;  
     2443                                                return $startcol + 86;  
    23992444                } catch (Exception $e) { 
    24002445                        throw new PropelException("Error populating Market object", $e); 
    …… 
    28552900                                break; 
    28562901                        case 83: 
     2902                                return $this->getLastChange(); 
     2903                                break; 
     2904                        case 84: 
    28572905                                return $this->getCreatedAt(); 
    28582906                                break; 
    2859                         case 84: 
     2907                        case 85: 
    28602908                                return $this->getUpdatedAt(); 
    28612909                                break; 
    …… 
    29533001                        $keys[81] => $this->getBuildingPermit(), 
    29543002                        $keys[82] => $this->getUrl(), 
    2955                         $keys[83] => $this->getCreatedAt(), 
    2956                         $keys[84] => $this->getUpdatedAt(), 
     3003                        $keys[83] => $this->getLastChange(), 
     3004                        $keys[84] => $this->getCreatedAt(), 
     3005                        $keys[85] => $this->getUpdatedAt(), 
    29573006                ); 
    29583007                return $result; 
    …… 
    32203269                                break; 
    32213270                        case 83: 
     3271                                $this->setLastChange($value); 
     3272                                break; 
     3273                        case 84: 
    32223274                                $this->setCreatedAt($value); 
    32233275                                break; 
    3224                         case 84: 
     3276                        case 85: 
    32253277                                $this->setUpdatedAt($value); 
    32263278                                break; 
    …… 
    33153367                if (array_key_exists($keys[81], $arr)) $this->setBuildingPermit($arr[$keys[81]]); 
    33163368                if (array_key_exists($keys[82], $arr)) $this->setUrl($arr[$keys[82]]); 
    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]]); 
     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]]); 
    33193372        } 
    33203373 
    …… 
    34073460                if ($this->isColumnModified(MarketPeer::BUILDING_PERMIT)) $criteria->add(MarketPeer::BUILDING_PERMIT, $this->building_permit); 
    34083461                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); 
    34093463                if ($this->isColumnModified(MarketPeer::CREATED_AT)) $criteria->add(MarketPeer::CREATED_AT, $this->created_at); 
    34103464                if ($this->isColumnModified(MarketPeer::UPDATED_AT)) $criteria->add(MarketPeer::UPDATED_AT, $this->updated_at); 
    …… 
    36023656 
    36033657                $copyObj->setUrl($this->url); 
     3658 
     3659                $copyObj->setLastChange($this->last_change); 
    36043660 
    36053661                $copyObj->setCreatedAt($this->created_at); 

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

    r455 r460  
    1414 
    1515         
    16         const NUM_COLUMNS = 85; 
     16        const NUM_COLUMNS = 86; 
    1717 
    1818         
    …… 
    270270 
    271271         
     272        const LAST_CHANGE = 'market.LAST_CHANGE'; 
     273 
     274         
    272275        const CREATED_AT = 'market.CREATED_AT'; 
    273276 
    …… 
    281284         
    282285        private static $fieldNames = array ( 
    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, ) 
     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, ) 
    287290        ); 
    288291 
    289292         
    290293        private static $fieldKeys = array ( 
    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, ) 
     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, ) 
    295298        ); 
    296299 
    …… 
    510513 
    511514                $criteria->addSelectColumn(MarketPeer::URL); 
     515 
     516                $criteria->addSelectColumn(MarketPeer::LAST_CHANGE); 
    512517 
    513518                $criteria->addSelectColumn(MarketPeer::CREATED_AT);