/DEV/DISPLAY/modules/detail_annce_vente.php

<?php if($_global['dev'] == 1 && isset($_GET['cmt']) && $_GET['cmt'] == 'on') { ?>
  <!-- begin : <?php echo __FILE__; ?> -->
<?php } ?>
<?php

	// traitement
	include("../EXE/code.search.exe.php");
    
	include("modules/search_data.php");

	// annonce publiée ou expirée, mais pas inexistante
	if ($ads) {
    
        foreach ($chemin as $key => $value) {

  			// id de la ville
  			if ($value['lct_id'] != '') $lct_id = $value['lct_id'];

  			// nom du département
  			if ($value['lct_parent_name'] != '') $departement = clean_loc($value['lct_parent_name']);

  			// code postal du département
  			if ($value['lct_parent_post_code'] != '') $departement_post_code = clean_loc($value['lct_parent_post_code']);
   	        if (strlen($departement_post_code) == 3) {
   	            $departement_post_code = substr($departement_post_code, 0, 3);
   	        } else {
                $departement_post_code = substr($departement_post_code, 0, 2);
   	        }
            
  			// nom de la ville
  			if ($value['lct_name'] != '') $ville = clean_loc($value['lct_name']);

  			// code postal de la ville
  			if ($value['lct_post_code'] != '') $post_code = $value['lct_post_code'];

  			// nom de la ville formaté pour les urls
  			if (substr($value["lct_name"], 0, 5) == "PARIS") {
  				$link_city = "Paris"; // evite l'affichage des arrondissements de paris qui se sont produit au debut
  			} else if (substr($value["lct_name"], 0, 4) == "LYON") {
  				$link_city = "Lyon"; // evite l'affichage des arrondissements de lyon qui se sont produit au debut
  			} else {
  				$link_city = clean_loc_url($value['lct_name']);
  			}

        }
      
	}
   
   // annonce expirée (ie présente dans la liste des annonces non publiée)
   if (!$is_annonce_publiee && $is_annonce_inexistante) { // annonce inexistante (ie ni publiée ni expirée)

      log_404_refnat("detail");
      header("HTTP/1.0 404 Not Found");
      header("status: 404");
      include($_SERVER["DOCUMENT_ROOT"]."/404.php");
      die;

   } else {

      //echo "[annonce publiée]";       
      
      $agc_count = array("agc_rnt_count" => 0, "agc_sal_count" => 0);

      if (isset($ag["id"]) && !empty($ag["id"])) {
         
         $id_agence = $ag["id"];
         
         // les champs lzip, town et country sont récupérés depuis la table des agences et 
         // non depuis une annonce car on en a besoin pour former les urls de mini sites
         // agence (si ces infos sont absentes, ces liens ne sont pas générés).
         $sql = "
            SELECT   id_agence, id_agence AS id, id_presto, agc.agc_has_appmob as 2d_code,
                     agc.agc_post_code AS lzip, agc.agc_town_agency AS town, agc.agc_town_agency AS town_agency, agc.agc_country AS country,
                     agc.agc_is_powersite, agc.agc_powersite_url, agc.agc_is_phonemandatory4contact as is_phonemandatory4contact,
                     agc.agc_loc_id_0, agc.agc_loc_id_1, agc.agc_loc_id_2,
                     agc.agc_default_town_0, agc.agc_default_town_1, agc.agc_default_town_2,
                     (IF((adp.adp_rnt_count IS NULL), 0, adp.adp_rnt_count)) AS agc_rnt_count,
                     (IF((adp.adp_sal_count IS NULL), 0, adp.adp_sal_count)) AS agc_sal_count                     
            FROM T_AGENCY_AGC agc, T_AGENCY_DATA_PONDERING_ADP adp
            WHERE (id_agence = '".$id_agence."')
            AND   adp.adp_id_presto = agc.id_presto
         ";
         
         //echo "<hr>"; echo $sql; echo "<hr>";
         
         $agc_count = pdoquery($sql);
         
         //Recuperer le QRcode. Melissa 23/08/12. A debloquer quand validé
         if (USE_QRCODE_BDD) {
             $ag['2d_code'] = $agc_count[0]['2d_code'];
         }
         
         if (count($agc_count) > 0) {
            
            $ag_obj = $agc_count[0];
            
            $ag["hierarchy"] = array();
            for ($i=0; $i<3; $i++) {
               $ag["hierarchy"][] = array("lct_id" => $ag_obj["agc_loc_id_".$i], "lct_name" => $ag_obj["agc_default_town_".$i]);
            }
            
            //print_r($ag_obj);
            
            if (!isset($agency)) {
                $agency = array();
            }
            $agency['is_phonemandatory4contact'] = $ag_obj['is_phonemandatory4contact'];
            
            //print_r($agency);
            
         }
         
      }
      
   }
?>
<?php if($_global['dev'] == 1 && isset($_GET['cmt']) && $_GET['cmt'] == 'on') { ?>
  <!-- //end : <?php echo __FILE__; ?> -->
<?php } ?>