/public_html/includes/sejururi/tara_new.php

<div id="NEW-destinatie">

<?php function afisare_div($rowl, $link, $id_zona, $id_localitate, $sitepath_parinte, $tara, $zona) {

$tipuri=array(); ?>

<div class="localitate">

  <div class="readmore" onclick="location.href='<?php echo $link; ?>';">&raquo; toate hotelurile din <?php echo $rowl['denumire']; ?></div>

  <h3><a href="<?php echo $link; ?>" class="link vtip" title="Sejur <?php echo $rowl['denumire']; ?>"><?php echo $rowl['denumire']; ?></a></h3>

  <div class="left">

    <img src="<?php echo $sitepath_parinte.'thumb_localitate/'.$rowl['poza1']; ?>" width="240" height="100" alt="<?php echo $rowl['denumire'].' din '.$zona.' - '.ucwords($tara); ?>" onclick="location.href='<?php echo $link; ?>';" />

  </div>

  <div class="right">

  <?php $id_tara=get_id_tara($tara); $tipuri=get_tiputi_oferte('', $id_localitate, $id_zona, $id_tara, '', '');

    if(sizeof($tipuri)>0) { ?>

   <!-- <span class="titlu"> <?php echo $rowl['denumire']; ?></span>-->

    <?php foreach($tipuri as $key_t=>$value_t) {

        $link_t=$GLOBALS['sitepath_class'].'oferte-'.fa_link($value_t['denumire']).'/'.$_REQUEST['tari'].'/'.fa_link($zona).'/'.fa_link($rowl['denumire']).'/'; ?>

    <a href="<?php echo $link_t; ?>" class="link-red" title="<?php echo $value_t['denumire'].' '.$rowl['denumire']; ?>"><strong><?php echo $value_t['denumire'].' '.$rowl['denumire']; ?></strong></a>

    <?php }

    } ?>

  </div>

  <div class="clear"></div>

</div>

<?php }

$zone_apare_dreapta='nu';

$selZ="select 

zone.id_zona,

zone.denumire,

zone.apare_dreapta

from

oferte 

inner join hoteluri on oferte.id_hotel = hoteluri.id_hotel

inner join localitati on hoteluri.locatie_id = localitati.id_localitate 

inner join zone on localitati.id_zona = zone.id_zona 

inner join tari on zone.id_tara = tari.id_tara

where

oferte.valabila = 'da' and hoteluri.tip_unitate <> 'Circuit'

and tari.id_tara = '".$id_tara."'

Group by zone.id_zona

Order by zone.apare_dreapta, zone.denumire ";


$queZ=mysql_query($selZ) or die(mysql_error());

$nr_z=mysql_num_rows($queZ);

if($nr_z>1) { ?>

<h1 class="blue" style="float:left;"><?php echo ucwords($tara); ?></h1>

  

  <ul class="NEW-socials" style="float:right; margin-bottom:0">

    <li><a href="http://www.facebook.com/sharer.php?u=<?php echo $sitepath.substr($_SERVER['REQUEST_URI'],1); ?>?ref=facebook" class="NEW-facebook-24" target="_blank">Facebook</a></li>

    <li><a href="http://twitter.com/home?status=<?php echo $sitepath.substr($_SERVER['REQUEST_URI'],1); ?>?ref=twitter" class="NEW-twitter-24" target="_blank">Twitter</a></li>

    <li></li>

	<li style="width:70px;"><div class="g-plusone"></div></li>

    <?php /*?><li><div class="fb-like" data-send="false" data-layout="button_count" data-width="100" data-show-faces="false"></div></li><?php */?>

  </ul>

  

  <br class="clear" />

  <div class="Hline"></div>

  

  <div class="pad10 clearfix">



  <?php $tipuri=get_tiputi_oferte('', '', '', $id_tara, '', '');

	if(sizeof($tipuri)>0) { ?>

    <div class="NEW-chn-oferta-red custom-links">

    <?php foreach($tipuri as $key_t=>$value_t) {

		$link_t=$sitepath.'oferte-'.fa_link($value_t['denumire']).'/'.$_REQUEST['tari'].'/'; ?>

      <a href="<?php echo $link_t; ?>" title="<?php echo $value_t['denumire'].' '.ucwords($tara); ?>"><?php echo $value_t['denumire'].' '.ucwords($tara); ?></a>

      <?php } ?>

      <br class="clear" />

    </div>

  <?php } ?>

  

  <br />

<div class="half-left">  

<?php 

while($rowZ=mysql_fetch_array($queZ)) {

$id_zona=$rowZ['id_zona'];

$zona=$rowZ['denumire'];

if($zone_apare_dreapta<>$rowZ['apare_dreapta'] && $rowZ['apare_dreapta']=='da') { echo '</div> <div class="half-right">'; $zone_apare_dreapta=$rowZ['apare_dreapta']; } ?>

<h2 class="green"><?php echo $zona; ?></h2>

<?php $selL="select

localitati.id_localitate,

localitati.denumire,

localitati.poza1,

localitati.poza2,

count(oferte.id_oferta) as nr_oferte

from

oferte 

inner join hoteluri on oferte.id_hotel = hoteluri.id_hotel

inner join localitati on hoteluri.locatie_id = localitati.id_localitate 

inner join zone on localitati.id_zona = zone.id_zona 

inner join tari on zone.id_tara = tari.id_tara

where

oferte.valabila = 'da'

and hoteluri.tip_unitate <> 'Circuit'

and tari.id_tara = '".$id_tara."'

and zone.id_zona = '".$id_zona."'

Group by localitati.id_localitate

Order by nr_oferte DESC, localitati.denumire ";

$queL=mysql_query($selL) or die(mysql_error());

while($rowl=mysql_fetch_array($queL)) {

$id_localitate=$rowl['id_localitate'];

$link=$sitepath.'sejur-'.$_REQUEST['tari'].'/'.fa_link($rowZ['denumire']).'/'.fa_link($rowl['denumire']).'/';

 afisare_div($rowl, $link, $id_zona, $id_localitate, $sitepath_parinte, $tara, $zona);  

 } @mysql_free_result($queL); ?>

 <br class="clear" />

<?php } ?>

</div>

<?php } else {

$rowZ=mysql_fetch_array($queZ);

$id_zona=$rowZ['id_zona'];

$zona=$rowZ['denumire']; ?>

<h1 class="blue" style="float:left;"><?php echo $rowZ['denumire'].' '.ucwords($tara); ?></h1>

  

  <ul class="NEW-socials" style="float:right; margin-bottom:0">

    <li><a href="http://www.facebook.com/sharer.php?u=<?php echo $sitepath.substr($_SERVER['REQUEST_URI'],1); ?>?ref=facebook" class="NEW-facebook-24" target="_blank">Facebook</a></li>

    <li><a href="http://twitter.com/home?status=<?php echo $sitepath.substr($_SERVER['REQUEST_URI'],1); ?>?ref=twitter" class="NEW-twitter-24" target="_blank">Twitter</a></li>

    <li></li>

	<li style="width:70px;"><div class="g-plusone"></div></li>

    <?php /*?><li><div class="fb-like" data-send="false" data-layout="button_count" data-width="100" data-show-faces="false"></div></li><?php */?>

  </ul>

  

  <br class="clear" />

  <div class="Hline"></div>

  

  <div class="pad10 clearfix">



  <?php $tipuri=get_tiputi_oferte('', '', $id_zona, $id_tara, '', '');

	if(sizeof($tipuri)>0) { ?>

    <div class="NEW-chn-oferta-red custom-links">

    <?php foreach($tipuri as $key_t=>$value_t) {

		$link_t=$sitepath.'oferte-'.fa_link($value_t['denumire']).'/'.$_REQUEST['tari'].'/'.fa_link($rowZ['denumire']).'/'; ?>

      <a href="<?php echo $link_t; ?>" title="<?php echo $value_t['denumire'].' '.$rowZ['denumire'].'-'.ucwords($tara); ?>"><?php echo $value_t['denumire'].' '.$rowZ['denumire'].'-'.ucwords($tara); ?></a>

      <?php } ?>

      <br class="clear" />

    </div>

  <?php } ?>

  <br />



<div class="half-left">

<?php $localitate_apare_dreapta='nu';

$selL="select

localitati.id_localitate,

localitati.denumire,

localitati.poza1,

localitati.poza2,

count(oferte.id_oferta) as nr_oferte,

localitati.apare_dreapta

from

oferte 

inner join hoteluri on oferte.id_hotel = hoteluri.id_hotel

inner join localitati on hoteluri.locatie_id = localitati.id_localitate 

inner join zone on localitati.id_zona = zone.id_zona 

inner join tari on zone.id_tara = tari.id_tara

where

oferte.valabila = 'da'

and hoteluri.tip_unitate <> 'Circuit'

and tari.id_tara = '".$id_tara."'

and zone.id_zona = '".$id_zona."'

Group by localitati.id_localitate

Order by localitati.apare_dreapta, nr_oferte DESC, localitati.denumire ";

$queL=mysql_query($selL) or die(mysql_error());

while($rowl=mysql_fetch_array($queL)) {

if($localitate_apare_dreapta<>$rowl['apare_dreapta'] && $rowl['apare_dreapta']=='da') { echo '</div> <div class="half-right">'; $localitate_apare_dreapta=$rowl['apare_dreapta']; }

$id_localitate=$rowl['id_localitate'];

$link=$sitepath.'sejur-'.$_REQUEST['tari'].'/'.fa_link($rowZ['denumire']).'/'.fa_link($rowl['denumire']).'/';

afisare_div($rowl, $link, $id_zona, $id_localitate, $sitepath_parinte, $tara, $zona); ?>

  <?php } @mysql_free_result($queL); ?>

 </div>

 <br class="clear" />

 <?php } @mysql_free_result($queZ); ?>

</div>

  

</div>

<br class="clear" />