<?php  include '../Libs/nocheck.php'; ?>
<?php  include '../include/top.html'; 

	$mamulcode = "Rankup_budongsan_mamul"; 
	$gaesucode = "Rankup_budongsan_gaesu"; 

	include '../Libs/page1.php';

	$scale1 = 10;	

	$start_q1 = $scale1 * ($cpage1 - 1); 

	$start_q2 = $scale1 * ($cpage2 - 1);	

	$pre_gaesu = "select * from $gaesucode";
	$pre_gaesu = mysqli_query($connect,$pre_gaesu);
	$pre_gaesu = mysqli_fetch_array($pre_gaesu);

	$pre_su = ceil($pre_gaesu[pre]/6);	

	
	switch($type)
	{
		case "hot":
			$typename = "Urgente";
			$order = "and mamultype = '$type'";
			break;
		
		case "chu":
			$typename = "Recomendada";
			$order = "and (mamultype = 'hot' or mamultype = '$type')";
			break;
		
		case "pre":
			$typename = "Premium";
			$order = "and (mamultype = 'hot' or mamultype = 'chu' or mamultype = '$type')";
			break;
		
		case "spe":
			$typename = "Especial";
			$order = "and (mamultype = 'hot' or mamultype = 'chu' or mamultype = 'pre' or mamultype = '$type')";
			break;
		
	}
	
	$now_date = date("Y-m-d");


/***********************************************************************************/
			$cc=explode("-",$_GET['area1']);
		$ee=explode("-",$_GET['area2']);
		
		$ar1=($cc[2])?"and address2 like '%$cc[2]%'":"";
		$ar1.=($ee[2])?"and address2 like '%$ee[2]%'":"";
		
		
		$mamul_sel = "select * from $mamulcode where mamultype='$type' $ar1 and expiry >= '$now_date' and gong='Y' order by updexpiry desc, no desc limit $pre_gaesu[pre]";
		
	   
		$mamul_sel = mysqli_query($connect,$mamul_sel);
		
/**************************************************************************************/


/*********************************************************************************************/

//      $mamul_Lsel = "select * from $mamulcode where expiry >= NOW() $order $ar1 and gong='Y' order by updexpiry desc, no desc limit $start_q1, $scale1";
		$mamul_Lsel = "select * from $mamulcode where expiry >= NOW() $order $ar1 and gong='Y' order by wdate desc, no desc limit $start_q1, $scale1";

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

		$mamul_LAll = "select count(no) from $mamulcode where expiry >= NOW() $order $ar1 and gong='Y'";
		$mamul_LAll = mysqli_query($connect,$mamul_LAll);
		$mamul_LAll = mysqli_fetch_array($mamul_LAll);
		
/*********************************************************************************************/


/*********************************************************************************************************/
	if($hahaha == 'sangsearch')
	{
		//&area1=$area1&area2=$area2&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk
			$cc=explode("-",$_GET['area1']);
		$ee=explode("-",$_GET['area2']);
		
		$ar1=($cc[2])?"and address2 like '%$cc[2]%'":"";
		$ar1.=($ee[2])?"and address2 like '%$ee[2]%'":"";
		
		if(!$area2_haha)
		{
			$area2_haha = $area2;
		}
		
		$area1_1 = explode("-",$area1);		
		$area2_1 = explode("-",$area2_haha);
		
		$area2_1 = " $area2_1[2]";		

		$addresseses1 =  $area1_1[2];
		$addresseses2 =  $area2_1; 

		$jongru_1 = explode("-",$jongru);			
		
		
		//$sangsearch1  = ($area1[2])?"and address2 like '%$addresseses1%' or address2 like '%$addresseses2%'":"";
		
		$sangsearch1 .= ($jongru[2])?"and gubun1='$jongru_1[2]'":"";
		$sangsearch1 .= ($jongru2)?"and gubun2='$jongru2'":"";
		$sangsearch1 .= ($searchkkk)?"and id like '%$searchkkk%'":"";
        if($searchjongru=="")
        {}else{
				$sangsearch1 .= ($searchjongru && $searchjongru!="" && $searchjongru=="Y")?"and jointype='Y' ":"and jointype='N' ";
        		$sangsearch1 .= ($searchjongru && $searchjongru!="" && $searchjongru=="N")?"and jointype='N' ":"and jointype='N' ";
              }  
        
       
		$mamul_Lsel = "select * from $mamulcode where gong='Y' $ar1 $sangsearch1 order by updexpiry desc, no desc limit $start_q1, $scale1";
		//echo $mamul_Lsel;
		$mamul_Lsel = mysqli_query($connect,$mamul_Lsel);
		
		$mamul_LAll = "select count(no) from $mamulcode where  gong='Y' $ar1 $sangsearch1";	
		$mamul_LAll = mysqli_query($connect,$mamul_LAll);
		$mamul_LAll = mysqli_fetch_Array($mamul_LAll);
	}
   
/********************************************************************************************************/


?>
<table width=900 cellpadding=0 cellspacing=0 border=0 align=center>
<tr>
<td width=170 align=center valign=top background='../images/left_bg.gif'><?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>
             <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 > Ver venta > <b><?php echo $typename?></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><table cellpadding=1 cellspacing=1 align='center' border='0'>
						<?php for($i=0; $i<$pre_su; $i++){?>
						<tr bgcolor=ffffff>						
						<?php for($j=0; $j<6; $j++){
								
								$mamul_sel_Row = mysqli_fetch_array($mamul_sel);

								switch($mamul_sel_Row[gubun1])
								{
									case 'Habitacional':
										$image = "<img src=../images/photo_default_house.gif border='0' width='90' height='60'>";
										break;

									case 'Industrial':
										$image = "<img src=../images/photo_default_business.gif border='0' width='90' height='60'>";
										break;

									case 'Terreno':
										$image = "<img src=../images/photo_default_area.gif border='0' width='90' height='60'>";
										break;

									case 'Comercial':
										$image = "<img src=../images/photo_default_shop.gif border='0' width='90' height='60'>";
										break;

								}		
								
								//----------------------------------------//

							if(stristr($mamul_sel_Row[address1],"/"))
							{
								$area = explode("/",$mamul_sel_Row[address1]);
								$area_sido		= explode("-",$area[0]);
								$area_gugun	= explode("-",$area[1]);
								$area_dong	= explode("-",$area[2]);							

								$address = $area_sido[2]." ".$area_gugun[2];
							}
							else
							{
								$dongdong = explode(" ",$mamul_sel_Row[address1]);
								
								$address = $dongdong[0]." ".$dongdong[1];
							}

							//-----------------------------------------//		
								
								
								?>
						<td valign='top'>
									<table cellpadding=0 cellspacing=1 border='0' width='113' align='center'>
									<?php 
									
									if(!$mamul_sel_Row[no])
									{
										echo "<td align='center' valign='top'><table cellpadding=3 cellspacing=1 width=90 border='0' bgcolor='dddddd'>
									<tr>
									<td bgcolor='ffffff'><img src='../images/photo_default_90_60.gif' border='0'></td></tr></table></td>";	
									}
									else
									{?>
									<tr>
									<td align='center' valign='top'>
									<table cellpadding=3 cellspacing=1 width=90 border='0' bgcolor='dddddd'>
									<tr>
									<td bgcolor='ffffff'>
									<a href='../realty/realty_detail.html?abcde=<?php echo $mamul_sel_Row[stamps]?>&aabb=<?php echo $mamul_sel_Row[gubun1]?>'><?php echo ($mamul_sel_Row[image1])?"<img src='../PEG/main_center/$mamul_sel_Row[image1]' border='0' width='90' height='60'>":"$image"?></a></td></tr></table></td>
									<td rowspan='2'  background='../images/dot2.gif' width='3'></td>
									</tr>
									<tr><td height='2'></td></tr>
									<tr>
									<td class=tdheight align='center'>
									<font class='wine'>
									[<?php echo substr($mamul_sel_Row[gubun2],0,10)."".$mamul_sel_Row[type]?>]</font>
									<br><a href='../realty/realty_detail.html?abcde=<?php echo $mamul_sel_Row[stamps]?>&aabb=<?php echo $mamul_sel_Row[gubun1]?>'><?php echo $address?></a></td>
									</tr>
									<tr><td height='3'></td></tr>

									<?php }?>
									</table></td>
						<?php }?>
						</tr>
						<?php }?>
						</table>
			</td>
			</tr>
			<tr><td height='10'></td></tr>
            <tr><td align="center">
            				<div id="Rectangulo_home_abajo" ></div>
							<script>
							var rec_aba	= new mostrar_baners();
							rec_aba.crear('Rectangulo_home_abajo','16','3','rec_aba');
							</script><br/>
            </td></tr>
			<tr><td align=center>
						<table cellpadding=0 cellspacing=0 border='0'  WIDTH=695 align='center'>
						<tr>
						<td colspan='9' height='25'><img src='../images/icon08.gif' align='absmiddle'>Total: <b><?php echo $mamul_LAll[0]?></b> Ventas 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='60' 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>
						<td width='70' background='../images/board_bg.gif'><font class='black'>Fecha</td>
						<!--<td background='../images/board_bg.gif'><font class='black'> </td>-->
						<td width='40'  background='../images/board_bg.gif'><font class='black'>Visitas</td>
						</tr>
					<?php for($i=0; $i<$mamul_Lsel_Row = mysqli_fetch_array($mamul_Lsel); $i++){
					
							$membertype = ($mamul_Lsel_Row[jointype] == 'Y')?"Inmob.":"Particular";
							$hot_wdate = explode(" ",$mamul_Lsel_Row[wdate]);	
							
							//-----------------------------------------//

							if(stristr($mamul_Lsel_Row[address1],"/"))
							{
								$area = explode("/",$mamul_Lsel_Row[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(" ",$mamul_Lsel_Row[address1]);
								
								$address = $dongdong[0]." ".$dongdong[1]." ".$dongdong[2];
							}

							//-----------------------------------------//		
							
							
							//----------------------------------------------------------------------------//

							if($mamul_Lsel_Row[expiry] > $item_view)
							{
								if($mamul_Lsel_Row[itemcheck] == 'Y')
								{
									$itemimage = " <img src='../images/icon_hot.gif' border=0 align='absmiddle'>";
								}
								else
								{
									$itemimage = "";
								}


								if($mamul_Lsel_Row[boldcheck] == 'Y')
								{
									$boldstart = "<font class='text_bold'><b>";
									$boldend = "</b></font>";
								}
								else
								{
									$boldstart = "<font color='666666'>";
									$boldend = "</font>";
								}									
									
							}
							else
							{
									$itemimage = "";
									$boldstart = "<font color='555555'>";
									$boldend = "</font>";
							}

							$namesss = explode("-",$mamul_Lsel_Row[name]);
							$brsel = ($namesss[0] != "" || $namesss[0]!=null)?" ":"";
							$nameview =$brsel."<font class='gray_s'>[".$mamul_Lsel_Row[gubun2]."]</font> ";

							//----------------------------------------------------------------------------//	


?>
						<tr>
						<td height='30'>&nbsp;<a href='../realty/realty_detail.html?abcde=<?php echo $mamul_Lsel_Row[stamps]?>&aabb=<?php echo $mamul_Lsel_Row[gubun1]?>'><?php echo $boldstart?><?php echo $address;?><?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 $mamul_Lsel_Row[type]?><?php echo $boldend?></td>
                        <td align='center'><?php echo $boldstart?><?php echo $mamul_Lsel_Row[pyong]?> m&sup2;<?php echo $boldend?></td>

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

						<td align='center'><?php echo $boldstart?><?php echo $membertype?><?php echo $boldend?></td>

						<td align='center'><?php echo $boldstart?><?php 
                         $fecha=explode("-",$hot_wdate[0]);
                         echo $fecha[2]."-".$fecha[1]."-".$fecha[0];
                      
                        
                        ?><?php echo $boldend?></td>

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

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

						</tr>
						<tr><td height='1' background='../images/dot.gif' colspan='9'></td></tr>
					<?php }?>
						<Tr>
						<!--**********************************************************************************-->
						<td colspan=8 bgcolor=ffffff align=center height='50'>
						<?php //Division de paginas 2
							$pagenum = 10;
							if($mamul_LAll[0]%$scale1)
							{
								$tpage = intval($mamul_LAll[0]/$scale1) + 1;
							}
							else
							{
								$tpage = intval($mamul_LAll[0]/$scale1);
							}

							$startpage = $pagenum*intval(($cpage1-1)/$pagenum)+1;
							
							$tempendpage = $startpage + $pagenum - 1;
							if($tempendpage > $tpage)
							{
								$endpage = $tpage;
							}
							else
							{
								$endpage = $tempendpage;
							}

							$end = ceil($mamul_LAll[0]/$scale1);

							if($cpage1 != 1)				{				
								echo "<a href='$PHP_SELF?cpage1=1&cpage2=$cpage2&type=$type&hahaha=$hahaha&area1=$area1&area2=$area2_haha&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk'><img src=../images/first_icon.gif border=0 align=absmiddle></a> ";
							}				
								
							if($startpage > 1)
							{
								$tempnum = $startpage - 1;
								echo "<a href='$PHP_SELF?cpage1=$tempnum&cpage2=$cpage2&type=$type&hahaha=$hahaha&area1=$area1&area2=$area2_haha&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk'><img src=../images/back_icon.gif border=0 align=absmiddle></a> ";
							}

							for($j=$startpage; $j<=$endpage; $j++)
							{
								if($j == $cpage1)
								{
									echo "<font color=F3790C><b>$j</b></font> ";	
								}
								else
								{
									echo "<a href='$PHP_SELF?cpage1=$j&cpage2=$cpage2&type=$type&hahaha=$hahaha&area1=$area1&area2=$area2_haha&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk' class='black'>$j</a> ";
								}
							}
							if($endpage < $tpage)
							{
								$tempnum = $endpage + 1;
								echo " <a href='$PHP_SELF?cpage1=$tempnum&cpage2=$cpage2&type=$type&hahaha=$hahaha&area1=$area1&area2=$area2_haha&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk'><img src=../images/next_icon.gif align=absmiddle border=0></a>";
							}

							if($cpage1 != $end && $mamul_LAll[0] > $scale1)
							{
								echo "&nbsp;<a href='$PHP_SELF?cpage1=$end&cpage2=$cpage2&type=$type&hahaha=$hahaha&area1=$area1&area2=$area2_haha&jongru=$jongru&jongru2=$jongru2&searchkkk=$searchkkk'><img src=../images/last_icon.gif border=0 align=absmiddle></a>";
							}
						?></td>
					<!--****************************************************************************-->
						</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' ?>