<?php 

include '../Libs/nocheck.php';

include '../include/top.html';

include "../Libs/PAGE_Function.php";


$Get_next = "areagu=$areagu&areaguname=$areaguname&areadongname=$areadongname&areadong=$areadong&areadong2name=$areadong2name&areadong2=$areadong2&hahaha=$hahaha&type=$type&mamuljoinsss=$mamuljoinsss&area1=$area1&area2=$area2&jongru=$jongru&searchjongru=$searchjongru&searchkkk=$searchkkk&x=$x&y=$y";


	$areacode = "Rankup_budongsan_area";

	$mamulcode = "Rankup_budongsan_mamul";

	$gubuncode = "Rankup_budongsan_gubuns";//tabla de division	

	$gaesucode = "Rankup_budongsan_gaesu";


	$nor_gaesu = "select * from $gaesucode";


	$nor_gaesu = mysqli_query($connect,$nor_gaesu);

	$nor_gaesu = mysqli_fetch_array($nor_gaesu);		


	$cpage1 = (empty($cpage1))?1:$cpage1;//  numero de pagina-si el primero no existe valor para que sea pagina 1, 1 vuelta

	$scale1 = $nor_gaesu[nor];// cantidad que va a aparecer record

	$start_q1 = Page_View1($cpage1, $scale1);// numero de pagina que va a buscar el primero

	$pagenum = 10;// cantidad de pagina que se va a presentar abajo


	$area_sel1 = "select * from $areacode where type=1 and sel='Y' order by rank asc";

	$area_sel1 = mysqli_query($connect,$area_sel1);

	$area_All1 = mysqli_num_rows($area_sel1);		


	$area_sellist = "select * from $mamulcode where gong='Y' order by wdate desc, expiry desc, updexpiry desc limit $start_q1, $scale1";

	//print $area_sellist;

	$area_sellist = mysqli_query($connect,$area_sellist);


	$area_sellistAll = "select count(no) from $mamulcode where gong='Y'";

	$area_sellistAll = mysqli_query($connect,$area_sellistAll);

	$area_sellistAll = mysqli_fetch_array($area_sellistAll);

	
	$area_All1nanum = ceil($area_All1/8);	

/***************************************cuando hace clic ciudad*****************************************************************/	

	if($areagu)

	{

		$area_sel2 = "select * from $areacode where no=$areagu";

		$area_sel2 = mysqli_query($connect,$area_sel2);

		$area_Row2 = mysqli_fetch_array($area_sel2);

		
		$area_sel2_1 = "select * from $areacode where pre_no='$area_Row2[pre_no]$area_Row2[no]|' order by rank asc";

		//print $area_sel2_1;

		$area_sel2_1 = mysqli_query($connect,$area_sel2_1);

		$area_All2_1 = mysqli_num_rows($area_sel2_1);


		$area_All2_1nanum = ceil($area_All2_1/3);//Columnas en que se muestran los municipios


		$area_sellist = "select * from $mamulcode where address2 like '%$areaguname%' and gong='Y' order by wdate desc, expiry desc, updexpiry desc limit $start_q1, $scale1";

		$area_sellist = mysqli_query($connect,$area_sellist);


		$area_sellistAll = "select count(no) from $mamulcode where address2 like '%$areaguname%' and gong='Y'";

		$area_sellistAll = mysqli_query($connect,$area_sellistAll);

		$area_sellistAll = mysqli_fetch_array($area_sellistAll);

	}

/*****************************************cuando hace clic ciudad******************************************************************/


/***************************************cuando hace clic colonia********************************************************************/	

	if($areadong)

	{

		$area_sel3 = "select * from $areacode where no=$areadong";

		$area_sel3 = mysqli_query($connect,$area_sel3);

		$area_Row3 = mysqli_fetch_array($area_sel3);


		$areadongname = "$areadongname";		


		$area_sel3_1 = "select * from $areacode where pre_no='$area_Row3[pre_no]$area_Row3[no]|' order by rank asc";

		$area_sel3_1 = mysqli_query($connect,$area_sel3_1);

		$area_All3_1 = mysqli_num_rows($area_sel3_1);


		$area_All3_1nanum = ceil($area_All3_1/3);


		$area_sellist = "select * from $mamulcode where address2 like '%$areaguname%' and address2 like '%$areadongname%' and gong='Y' order by wdate desc, updexpiry desc, no desc limit $start_q1, $scale1";		

		$area_sellist = mysqli_query($connect,$area_sellist);


		$area_sellistAll = "select count(no) from $mamulcode where address2 like '%$areaguname%' and address2 like '%$areadongname%' and gong='Y'";

		$area_sellistAll = mysqli_query($connect,$area_sellistAll);

		$area_sellistAll = mysqli_fetch_array($area_sellistAll);


		//--------------------------------------------------cuando hace clic barrio ----------------------------------------------------------------//


		if($areadong2)

		{

			$area_sel4 = "select * from $areacode where no=$areadong2";

			$area_sel4 = mysqli_query($connect,$area_sel4);

			$area_Row4 = mysqli_fetch_array($area_sel4);			


			$areadongname = "$areadongname";

			//$areadong2name = explode("",$areadong2name);

			//$areadong2name = "$areadong2name[0]";

			$areadong2name = "$areadong2name";


			$area_sel4_1 = "select * from $areacode where pre_no='$area_Row3[pre_no]$area_Row3[no]|' order by rank asc";

			$area_sel4_1 = mysqli_query($connect,$area_sel4_1);

			$area_All4_1 = mysqli_num_rows($area_sel4_1);


			$area_All4_1nanum = ceil($area_All4_1/7);


			$area_sellist = "select * from $mamulcode where address2 like '%$areaguname%' and address2 like '%$areadongname%' and address2 like '%$areadong2name%' and gong='Y' order by wdate desc, updexpiry desc, no desc limit $start_q1, $scale1";		

			$area_sellist = mysqli_query($connect,$area_sellist);


			$area_sellistAll = "select count(no) from $mamulcode where address2 like '%$areaguname%' and address2 like '%$areadongname%' and address2 like '%$areadong2name%' and gong='Y'";

			$area_sellistAll = mysqli_query($connect,$area_sellistAll);

			$area_sellistAll = mysqli_fetch_array($area_sellistAll);

		}

		//---------------------------------------------------cuando hace clic barrio---------------------------------------------------------//


	}

/***************************************cuando hace clic colonia********************************************************************/	


?>

<script type="text/javascript">


	function oculta(){

		var tabla=document.getElementById("municipios");

		if(tabla.style.display=="")

		{

		tabla.style.display="none";

		}else{

		     	tabla.style.display="";

			 }

	}

	function oculta2(){

		var tabla2=document.getElementById("municipios2");

		if(tabla2.style.display=="")

		{

		tabla2.style.display="none";

		}else{

		     	tabla2.style.display="";

			 }

	}

</script>

<table width=900 cellpadding=0 cellspacing=0 border=0 align=center>

<tr>

<td width=170 align=center valign=top bgcolor='F7F7F2'><?php  include '../include/left.html'?></td>

<td valign=top align=right >

	<table cellpadding='0' cellspacing='0' border='0' width='720'>

	<tr><td height='25'><div class="stlTitulo" style="float:right">

            	<div style="border:0px solid blue; width:445px; text-align:right; margin-top:2px;">	

                <img src='../images/icon02.gif'>Inicio > Ventas > <b>Todas las regiones</b>

             	</div>

             </div></td></tr>

	<tr><td height='1' bgcolor='dddddd'></td></tr>

	<tr><td height='10'></td></tr>

	<tr><td>

	<?php  //include "../include/search_sell.html"; ?>

	</td>

	</tr>

	<Tr><td height='10'></td></tr>

	<tr>

	<td align=center valign=top>

		<table cellpadding=0 cellspacing=0 width=600 border=0 align='center'>

		<tr><td><img src='../images/sell_area_bg01.gif'></td></tr>

		<tr><td background='../images/sell_area_bg02.gif'>

			<table border=0 align='center' width=600 align='center'>

			<?php for($i=0; $i<$area_All1nanum; $i++){?>

			<tr>

			<?php for($j=0; $j<8; $j++){

							
			$area_Row1 = mysqli_fetch_array($area_sel1);

									
			if(!$area_Row1[no]){ break; }?>

			<td><img src='../images/icon10.gif' align='absmiddle'><a href='./realty_area.html?areagu=<?php echo $area_Row1[no]?>&areaguname=<?php echo $area_Row1[name]?>'><font color='668B92'><b><?php echo $area_Row1[name]?></b></font></a></td>

			<?php }?>

			</tr>

			<?php }?>

			</table>

		</td>						

		</tr>	

		<tr><td><img src='../images/sell_area_bg03.gif'></td></tr>

		<tr><td background='../images/sell_area_bg04.gif'>

		<table cellpadding=1 cellspacing=1 align='center' width=620 border=0>


		<!--***************************buscar colonia*****************************************-->

		<?php if($areagu){?>

		<tr>

		<td><img src='../images/icon09.gif' align='absmiddle'><B><?php echo $area_Row2[name]?> </B> > <a href="#" onclick="oculta();">Minimizar Municipios</a></td>

		</tr>		

		<tr>

		<td><div id="municipios">

			<table border='0' width='620'>							

			<?php for($i=0; $i<$area_All2_1nanum; $i++){?>

			<tr bgcolor='ffffff'>

			<?php for($j=0; $j<3; $j++){ //Columnas en que se muestran los municipios

									
			$area_Row2_1 = mysqli_fetch_array($area_sel2_1);

			if(!$area_Row2_1[no]){ break; }	?>

									
			<?

				//  cuando hace busqueda favofita por area de domicilio, area de domicilio se dividido por colonia ,barrio Y condicion de busqueda se inclye colonia , barrio 

				//  tiene que dividirlos

				//$area_Row2_1[name]

				if($area_Row2_1[name] != "") $guname_temp = str_replace("Ciudad","Ciudad ",$area_Row2_1[name]); // = ejemplo de ciudad

				else $guname_temp = $area_Row2_1[name];

			?>

			<td><img src='../images/icon05.gif'><a href='./realty_area.html?areaguname=<?php echo $areaguname?>&areadongname=<?php echo $guname_temp ?>&areadong=<?php echo $area_Row2_1[no]?>'><?php echo $guname_temp ?></a> </td>

			<?php }?>

			</tr>

			<?php }?>

			</table></div>

		</td>

		</tr>

		<?php }?>

		<!--**************************************buscar colonia***************************************************-->


        <!--**************************************buscar barrio***************************************************-->

		<?php if($areadong){?>

		<tr>

		<td><img src='../images/icon09.gif' align='absmiddle'><B><?php echo $area_Row3[name]?> </B> > <a href="#" onclick="oculta2();">Minimizar Municipios</a></td>

		</tr>		

		<tr>

		<td>

			<div id="municipios2">

			<table border='0' width='620'>		

			<?php for($i=0; $i<$area_All3_1nanum; $i++){?>

			<tr bgcolor='ffffff'>

			<?php for($j=0; $j<3; $j++){

						
			$area_Row3_1 = mysqli_fetch_array($area_sel3_1);

			if(!$area_Row3_1[no]){ break; }		?>


			<td><img src='../images/icon05.gif'><a href='./realty_area.html?areaguname=<?php echo $areaguname?>&areadongname=<?php echo $areadongname?>&areadong=<?php echo $areadong?>&areadong2name=<?php echo $area_Row3_1[name]?>&areadong2=<?php echo $area_Row3_1[no]?>'><?php echo $area_Row3_1[name]?></a></td>

			<?php }?>

			</tr>

			<?php }?>

			</table></div>

		</td>

		</tr>						

		<!--*********************************buscar barrio ****************************************************-->

		<?php }?>

		</table>

	</td>

	</tr>

	<tr><td><img src='../images/sell_area_bg05.gif'></td></tr></table></td></tr>

	<Tr><td height='10'></td></tr>

	<tr>

	<td>

		<table cellpadding=0 cellspacing=0 border='0'  WIDTH=695 align='center'>

		<tr><td height='25' colspan='9'><img src='../images/icon08.gif' align='absmiddle'>Total de <b><?php echo $area_sellistAll[0]?> ventas </b>Registradas.</td></tr>

		<tr>

		<td colspan='9' height='2' bgcolor='917E64'></td></tr>

		<tr align=center bgcolor=eeeeee>

		<td width='170' height='27'><font class='black'>Direcci&oacute;n</td>

		<td width='150' background='../images/board_bg.gif'><font class='black'>Tipo</td>

		<td width='80' background='../images/board_bg.gif'><font class='black'>Operaci&oacute;n</td>

		<td width='60' background='../images/board_bg.gif'><font class='black'>Dimensi&oacute;n</td>

		<td width='95' background='../images/board_bg.gif'><font class='black'>Precio</td>

		<td width='50' background='../images/board_bg.gif'><font class='black'>Socio</td>

		<? if($cpage1==1) { ?>

		<td width='70' background='../images/board_bg.gif'><font class='black'>Registrado</td>

		<? } ?>

		</tr>

		<?php for($i=0; $i<$area_sellistRow = mysqli_fetch_array($area_sellist); $i++){

				
				$join_wdate = explode(" ",$area_sellistRow[wdate]);


				//-----------------dividir domicilio por cada metodo-----------------------//


							if(stristr($area_sellistRow[address1],"/"))

							{

								$area = explode("/",$area_sellistRow[address1]);

								$area_sido		= explode("-",$area[0]);

								$area_gugun	= explode("-",$area[1]);

								$area_dong	= explode("-",$area[2]);							


								$address = $area_sido[2]." ".$area_gugun[2]." ".$area_dong[2];

							}

							else

							{

								$dongdong = explode(" ",$area_sellistRow[address1]);

								
								$address = $dongdong[1]." ".$dongdong[2]." ".$dongdong[3];

							}


				//---------------dividir domicilio por cada metodo-----------------------//	

							
			//--------------------------------------dividir item de negrita------------------------------------//


				if($area_sellistRow[expiry] > $item_view)

				{

					if($area_sellistRow[itemcheck] == 'Y')

					{

						$itemimage = " <img src='../images/icon_hot.gif' border=0 align='absmiddle'>";

					}

					else

					{

						$itemimage = "";

					}


					if($area_sellistRow[boldcheck] == 'Y')

					{

						$boldstart = "<font class='text_bold'><b>";

						$boldend = "</b></font>";

					}

					else

					{

						$boldstart = "<font color='555555'>";

						$boldend = "</font>";

					}									

									
				}

				else

				{

						$itemimage = "";

						$boldstart = "<font color='555555'>";

						$boldend = "</font>";

				}


				$namesss = explode("-",$area_sellistRow[name]);

				$brsel = ($namesss[0] != "" || $namesss[0]!=null)?" ":"";

				$nameview =$brsel."<font class='gray_s'>[".$area_sellistRow[gubun2]."]</font> ";


		//--------------------------------------dividir item de negrita------------------------------------//	?>

		<tr>

		<td height='30'>&nbsp;<a href='./realty_detail.html?aabb=<?php echo $area_sellistRow[gubun1]?>&abcde=<?php echo $area_sellistRow[stamps]?>'><?php echo $boldstart?><?php echo $area_sellistRow[address1]?><?php echo $itemimage?><?php echo $boldend?></a></td>

		<td align="center"><?php echo $boldstart?><?php echo $nameview?><?php echo $boldend?></td>

		<td align='center'><?php echo $boldstart?><?php echo $area_sellistRow[type]?><?php echo $boldend?></td>

		<td align='center'><?php echo $boldstart?><?php echo $area_sellistRow[pyong]?><?php echo $boldend?> m&sup2;</td>

		<td align='center'><?php echo $boldstart?>$ <?php echo number_format($area_sellistRow[sell])?>  <?php echo $boldend?></td>

		<td align='center'><?php echo $boldstart?><?php echo ($area_sellistRow[jointype] == 'Y')?"Inmob":"Particular"?><?php echo $boldend?></td>		

		<td align='center'><?php echo $boldstart?><?php echo $join_wdate[0]?><?php echo $boldend?></td>

		<!--<td width='75' align='center'><?php echo $boldstart?><?php echo $area_sellistRow[expiry]?><?php echo $boldend?></td>-->

		<!-- <td align='center'><?php echo $boldstart?><?php echo $area_sellistRow[visit]?><?php echo $boldend?></td> -->

		</tr>

		<tr><td height='1' background='../images/dot.gif' colspan='9'></td></tr>

		<?php }?>

		<Tr>

		<!--**********************************repartir pagina de registro de articulo numero 1************************************-->

		<td colspan=8 bgcolor=ffffff align=center height='50'>

		<?php //2 termino particion de pagina 2

			$iamge1 = "";

			$iamge2 = "";

			$iamge3 = "";

			$iamge4 = "";


			echo Page_View2($scale1, $cpage1, $area_sellistAll[0], $pagenum, $Get_next, $image1, $image2, $image3, $image4); //formacion que se va a aparecer pagina

			// termino particion de pagina 2

						?></td>

		<!--********************************repartir pagina de registro de articulo numero 1*******************************************-->

		</tr>

		</table>

	</td>

	</tr>

	</table>

</td>

</tr>

</table>

<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">

</script>

<script type="text/javascript">

_uacct = "UA-4174254-2";

urchinTracker();

</script>

</body><?php  include  '../include/bottom.html' ?>