PageRenderTime 50ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/public_html/includes/cazari/cazare_zona.php

https://bitbucket.org/ocaziituristice/ocaziituristice.ro
PHP | 175 lines | 161 code | 12 blank | 2 comment | 85 complexity | a2f213e34f5d5bbcbd4191bc8e20a6d9 MD5 | raw file
    

  1. <?php  $den_zona=ucwords($zona);
    2. 

  2. $selTara="select denumire, steag from tari where id_tara = '".$id_tari."' ";
    3. 

  3. $queTara=mysql_query($selTara) or die(mysql_error());
    4. 

  4. $rowTara=mysql_fetch_array($queTara);
    5. 

  5. @mysql_free_result($queTara);
    6. 

  6. $den_tara=$rowTara['denumire']; ?>
    7. 

  7. <h1 class="blue">Cazari <? echo $den_tip.' '.$den_zona.' '.$rowTara['denumire']; ?></h1>
    8. 

  8. <p><? if(!isset($_POST['tip_relevanta']) && !isset($_POST['tip_stele']) && !isset($_POST['tip_pret'])) echo "Ordonate aleator"; else echo "Ordonare dupa ".$_POST['den_ord']; ?> pentru ofertele din <?php echo ucwords($zona); ?></p>
    9. 

  9. 

  10. <?php $sel3="SELECT
    11. 

  11. articole_seo.titlu_articol_seo,
    12. 

  12. articole_seo.descriere_articol_seo
    13. 

  13. FROM
    14. 

  14. articole_seo
    15. 

  15. WHERE
    16. 

  16. articole_seo.activ =  'da' AND
    17. 

  17. articole_seo.tip_oferta =  'sejur' AND ";
    18. 

  18. if($tip) $sel3=$sel3." articole_seo.id_tematica =  '$id_tip' AND "; else $sel3=$sel3." articole_seo.id_tematica = '0' AND ";
    19. 

  19. $sel3=$sel3."
    20. 

  20. articole_seo.id_tara = '$id_tari'  AND
    21. 

  21. articole_seo.id_zona = '$id_zone'  AND
    22. 

  22. articole_seo.id_localitate = '0'  AND
    23. 

  23. articole_seo.id_hotel = '0' "; 
    24. 

    25. 

  25. $que3=mysql_query($sel3) or die(mysql_error());
    26. 

  26. if(mysql_num_rows($que3)>'0') {
    27. 

  27. $row3=mysql_fetch_array($que3);
    28. 

  28. @mysql_free_result($que3);
    29. 

  29. ?>
    30. 

  30. <div class="text-dreapta">
    31. 

  31.     <h2 class="green"><? echo $row3['titlu_articol_seo']; ?></h2>
    32. 

  32.     <?php echo remove_special_characters(nl2br($row3["descriere_articol_seo"])); ?>
    33. 

  33. </div>    
    34. 

  34. <?  } ?>
    35. 

  35. 

  36. <br class="clear" />
    37. 

  37. 

  38. <div class="ordonare" align="right">
    39. 

  39.     <table cellspacing="0">
    40. 

  40.         <tr>
    41. 

  41.             <td><span class="red">Ordoneaza dupa:</span></td>
    42. 

  42.             <td>
    43. 

  43.                 <form name="ord_pret" id="ord_pret" method="post" action=""> 
    44. 

  44.                   <input type="hidden" name="tip_pret" value="<?php if(!isset($_POST['tip_pret'])) echo 'desc'; elseif(isset($_POST['tip_pret']) && $_POST['tip_pret']=='desc') echo 'asc'; else echo 'desc'; ?>" />
    45. 

  45.                   <input type="hidden" name="den_ord" value="pret <?php if(!isset($_POST['tip_pret'])) echo 'descedent'; elseif(isset($_POST['tip_pret']) && $_POST['tip_pret']=='desc') echo 'ascedent'; else echo 'descedent'; ?>" />
    46. 

  46.                   <?php if(!isset($_POST['tip_pret'])) { ?>
    47. 

  47.                   <a href="#" onclick="$('#loader').show(); document.ord_pret.submit();" class="initial" title="Pret Descendent">Pret</a> 
    48. 

  48. 				  <?php } else { ?> <a href="#" onclick="$('#loader').show(); document.ord_pret.submit();" class="selected" title="Pret <?php if(isset($_POST['tip_pret']) && $_POST['tip_pret']=='desc') echo 'Ascedent'; else echo 'Descendent'; ?>"><?php if(isset($_POST['tip_pret']) && $_POST['tip_pret']=='desc') { ?><img src="/images/spacer.gif" class="asc" /> <?php } else { ?><img src="/images/spacer.gif" class="desc" /><?php } ?> Pret</a><?php } ?>
    49. 

  49. <?php if($_REQUEST['transport'] && $_REQUEST['transport']<>'toate') { ?> <input type="hidden" name="transport" value="<?php echo $_REQUEST['transport']; ?>" /><?php } ?>
    50. 

  50. <?php if($_REQUEST['stele'] && $_REQUEST['stele']<>'toate') { ?> <input type="hidden" name="stele" value="<?php echo $_REQUEST['stele']; ?>" /><?php } ?>
    51. 

  51. <?php if($_REQUEST['masa'] && $_REQUEST['masa']<>'toate') { ?> <input type="hidden" name="masa" value="<?php echo $_REQUEST['masa']; ?>" /><?php } ?>
    52. 

  52. <?php if($_REQUEST['localitate_plecare']) { ?> <input type="hidden" name="localitate_plecare" value="<?php echo $_REQUEST['localitate_plecare']; ?>" /><?php } ?>
    53. 

  53.                 </form>
    54. 

  54.             </td>
    55. 

  55.             <?php if(!$_REQUEST['stele']) { ?><td> | </td>
    56. 

  56.             <td>
    57. 

  57.                 <form name="ord_stele" id="ord_stele" method="post" action="">
    58. 

  58.                   <input type="hidden" name="tip_stele" value="<?php if(!isset($_POST['tip_stele'])) echo 'desc'; elseif(isset($_POST['tip_stele']) && $_POST['tip_stele']=='desc') echo 'asc'; else echo 'desc'; ?>" />
    59. 

  59.                   <input type="hidden" name="den_ord" value="nr. stele <?php if(!isset($_POST['tip_stele'])) echo 'descedent'; elseif(isset($_POST['tip_stele']) && $_POST['tip_stele']=='desc') echo 'ascedent'; else echo 'descedent'; ?>" />
    60. 

  60.                   <?php if(!isset($_POST['tip_stele'])) { ?>
    61. 

  61.                   <a onclick="$('#loader').show(); document.ord_stele.submit();" class="initial" title="Numar stele Descendent">Numar stele</a>
    62. 

  62.                   <?php } else { ?> <a href="#" onclick="$('#loader').show(); document.ord_stele.submit();" class="selected" title="Numar stele <?php if(isset($_POST['tip_stele']) && $_POST['tip_stele']=='desc') echo 'Ascedent'; else echo 'Descendent'; ?>"><?php if(isset($_POST['tip_stele']) && $_POST['tip_stele']=='desc') { ?><img src="/images/spacer.gif" class="asc" /> <?php } else { ?><img src="/images/spacer.gif" class="desc" /><?php } ?> Numar stele</a><?php } ?>
    63. 

  63.  <?php if($_REQUEST['transport'] && $_REQUEST['transport']<>'toate') { ?> <input type="hidden" name="transport" value="<?php echo $_REQUEST['transport']; ?>" /><?php } ?>
    64. 

  64. 

  65. <?php if($_REQUEST['stele'] && $_REQUEST['stele']<>'toate') { ?> <input type="hidden" name="stele" value="<?php echo $_REQUEST['stele']; ?>" /><?php } ?>
    66. 

  66. <?php if($_REQUEST['masa'] && $_REQUEST['masa']<>'toate') { ?> <input type="hidden" name="masa" value="<?php echo $_REQUEST['masa']; ?>" /><?php } ?>
    67. 

  67. <?php if($_REQUEST['localitate_plecare']) { ?> <input type="hidden" name="localitate_plecare" value="<?php echo $_REQUEST['localitate_plecare']; ?>" /><?php } ?>                  
    68. 

  68.                 </form>            
    69. 

  69.             </td>
    70. 

  70.             <?php } ?>
    71. 

  71.             <td> | </td>
    72. 

  72.             <!--<td>
    73. 

  73. 

  74.                 <form name="ord_relevanta" id="ord_relevanta" method="post" action="">
    75. 

  75.                   <input type="hidden" name="tip_relevanta" value="<?php if(!isset($_POST['tip_relevanta'])) echo 'desc'; elseif(isset($_POST['tip_stele']) && $_POST['tip_relevanta']=='desc') echo 'asc'; else echo 'desc'; ?>" />
    76. 

  76.                   <input type="hidden" name="den_ord" value="relevanta <?php if(!isset($_POST['tip_relevanta'])) echo 'descedent'; elseif(isset($_POST['tip_relevanta']) && $_POST['tip_relevanta']=='desc') echo 'ascedent'; else echo 'descedent'; ?>" />
    77. 

  77.                   <?php if(!isset($_POST['tip_relevanta'])) { ?>
    78. 

  78.                   <a onclick="$('#loader').show(); document.ord_relevanta.submit();" class="initial" title="Relevanta Descendent">Relevanta</a>
    79. 

  79.                   <?php } else { ?> <a href="#" onclick="$('#loader').show(); document.ord_relevanta.submit();" class="selected" title="Relevanta <?php if(isset($_POST['tip_stele']) && $_POST['tip_relevanta']=='desc') echo 'Ascedent'; else echo 'Descendent'; ?>"><?php if(isset($_POST['tip_relevanta']) && $_POST['tip_relevanta']=='desc') { ?><img src="/images/spacer.gif" class="asc" /> <?php } else { ?><img src="/images/spacer.gif" class="desc" /><?php } ?> Relevanta</a><?php } ?>
    80. 

  80.  <?php if($_REQUEST['transport'] && $_REQUEST['transport']<>'toate') { ?> <input type="hidden" name="transport" value="<?php echo $_REQUEST['transport']; ?>" /><?php } ?>
    81. 

  81. <?php if($_REQUEST['stele'] && $_REQUEST['stele']<>'toate') { ?> <input type="hidden" name="stele" value="<?php echo $_REQUEST['stele']; ?>" /><?php } ?>
    82. 

  82. <?php if($_REQUEST['masa'] && $_REQUEST['masa']<>'toate') { ?> <input type="hidden" name="masa" value="<?php echo $_REQUEST['masa']; ?>" /><?php } ?>
    83. 

  83. <?php if($_REQUEST['localitate_plecare']) { ?> <input type="hidden" name="localitate_plecare" value="<?php echo $_REQUEST['localitate_plecare']; ?>" /><?php } ?>                 
    84. 

  84.                 </form>            
    85. 

  85.             </td>-->
    86. 

  86.             <td>
    87. 

  87.                 <form name="ord_implicita" id="ord_implicita" method="post" action="">
    88. 

  88.                 <?php if(isset($_POST['tip_relevanta']) || (isset($_POST['tip_stele']) && !$_REQUEST['stele']) || isset($_POST['tip_pret'])) { ?>
    89. 

  89.                 <a onclick="$('#loader').show(); document.ord_implicita.submit();" class="initial" title="Ordonare implicita">Ordonare implicita</a>
    90. 

  90.                 <?php } else { ?>
    91. 

  91.                 <a onclick="$('#loader').show(); document.ord_implicita.submit();" class="selected" title="Ordonare implicita">Ordonare implicita</a>
    92. 

  92.                 <?php } ?>
    93. 

  93.  <?php if($_REQUEST['transport'] && $_REQUEST['transport']<>'toate') { ?> <input type="hidden" name="transport" value="<?php echo $_REQUEST['transport']; ?>" /><?php } ?>
    94. 

  94. <?php if($_REQUEST['stele'] && $_REQUEST['stele']<>'toate') { ?> <input type="hidden" name="stele" value="<?php echo $_REQUEST['stele']; ?>" /><?php } ?>
    95. 

  95. <?php if($_REQUEST['masa'] && $_REQUEST['masa']<>'toate') { ?> <input type="hidden" name="masa" value="<?php echo $_REQUEST['masa']; ?>" /><?php } ?>
    96. 

  96. <?php if($_REQUEST['localitate_plecare']) { ?> <input type="hidden" name="localitate_plecare" value="<?php echo $_REQUEST['localitate_plecare']; ?>" /><?php } ?>               
    97. 

  97.                 </form>            
    98. 

  98.             </td>    
    99. 

  99.         </tr>
    100. 

  100.     </table>
    101. 

  101. </div>
    102. 

  102. 

  103. <?php $oferte=new AFISARE_SEJUR();
    104. 

  104. $oferte->set_oferte_pagina(10);
    105. 

  105. if($_REQUEST['tip']) $oferte->setTipOferta($_REQUEST['tip']);
    106. 

  106. $oferte->setTari($_REQUEST['tari']);
    107. 

  107. $oferte->setZone($_REQUEST['zone']);
    108. 

  108. $oferte->set_cazare('da');
    109. 

  109. if($_POST['tip_pret']) $oferte->setOrdonarePret($_POST['tip_pret']);
    110. 

  110. if($_POST['tip_stele'] && !$_REQUEST['stele']) $oferte->setOrdonareStele($_POST['tip_stele']);
    111. 

  111. if($_POST['tip_relevanta']) $oferte->setOrdonareRelevanta($_POST['tip_relevanta']);
    112. 

  112. if($_REQUEST['transport'] && $_REQUEST['transport']<>'toate') $oferte->setTransport($_REQUEST['transport']);
    113. 

  113. if($_REQUEST['stele'] && $_REQUEST['stele']<>'toate') $oferte->setStele($_REQUEST['stele']);
    114. 

  114. if($_REQUEST['masa'] && $_REQUEST['masa']<>'toate') $oferte->setMasa($_REQUEST['masa']);
    115. 

  115. if($_REQUEST['localitate_plecare']) $oferte->setLocalitatiPlecare($_REQUEST['localitate_plecare']);
    116. 

  116. $oferte->paginare(); ?>
    117. 

  117. 

  118. <br class="clear" /><br />
    119. 

  119. 

  120. <?php $loc_f=get_localitate_cazare($iduri,'',$id_zone,$id_tari,'');
    121. 

  121. if(sizeof($loc_f)>1) {
    122. 

  122. $total = sizeof($loc_f);
    123. 

  123. $linii = 0;
    124. 

  124. $linii = floor($total/3);
    125. 

  125. if(fmod($total,3)!=0) $linii++;
    126. 

  126. //echo $linii; ?>
    127. 

  127. <div class="countrydivcontainer">
    128. 

  128.   <h2 class="red">Destinatii</h2>
    129. 

  129.   <ul class="tabLink">
    130. 

  130. <?php $rand = 1;
    131. 

  131. $coloana = 1;
    132. 

  132. 

  133. $tarile = array(); 
    134. 

  134. foreach($loc_f as $key=>$value) {
    135. 

  135. 	$tarile[$rand][$coloana]=$value['denumire'];
    136. 

  136. 	$rand++;
    137. 

  137. 	if($rand>$linii) { $rand = 1; $coloana++; }
    138. 

  138. }
    139. 

  139. //print_r($tarile);
    140. 

  140. foreach($tarile as $key => $value) { 
    141. 

  141. 	for($j=1; $j<=4; $j++) { ?>
    142. 

  142. 	<li><?php if($value[$j]) { ?><a href="<?php echo $link_pag.fa_link($value[$j]); ?>/" title="Oferte cazare <? echo $value[$j]; ?>"><? echo $value[$j]; ?></a><?php } ?></li>
    143. 

  143. <? }
    144. 

  144. } ?>
    145. 

  145.   </ul>
    146. 

  146.   <br class="clear" />
    147. 

  147. </div>
    148. 

  148. <?php }
    149. 

  149. 

  150. $sel4="SELECT
    151. 

  151. articole_seo.titlu_articol_seo,
    152. 

  152. articole_seo.descriere_articol_seo
    153. 

  153. FROM
    154. 

  154. articole_seo
    155. 

  155. WHERE
    156. 

  156. articole_seo.activ =  'da' AND
    157. 

  157. articole_seo.tip_oferta =  'cazare' AND ";
    158. 

  158. if($tip) $sel4=$sel4." articole_seo.id_tematica =  '$id_tip' AND "; else $sel4=$sel4." articole_seo.id_tematica = '0' AND ";
    159. 

  159. $sel4=$sel4."
    160. 

  160. articole_seo.id_tara = '$id_tari'  AND
    161. 

  161. articole_seo.id_zona = '$id_zone'  AND
    162. 

  162. articole_seo.id_localitate = '0'  AND
    163. 

  163. articole_seo.id_hotel = '0' "; 
    164. 

    165. 

  165. $que4=mysql_query($sel4) or die(mysql_error());
    166. 

  166. if(mysql_num_rows($que4)>'0') {
    167. 

  167. $row4=mysql_fetch_array($que4);
    168. 

  168. @mysql_free_result($que4);
    169. 

  169. ?>
    170. 

  170. <div class="text-dreapta">
    171. 

  171.     <h2 class="green"><? echo $row4['titlu_articol_seo']; ?></h2>
    172. 

  172.     <?php echo remove_special_characters(nl2br($row4["descriere_articol_seo"])); ?>
    173. 

  173. </div>    
    174. 

  174. <?  } ?>
    175. 

  175. <div class="spacer"><img src="/images/spacer.gif" width="1" height="6" alt="" /></div>
    176.