`
<script type="text/javascript">
function category(cid)
{
if(cid !="")
{ $('#process').show('slow');
$.post('<?php echo BASEDIR ?>/ajax.php',{action:'search_subcategory_by_category_for_advsearch','cid':cid}, function(data)
{
$('#process').hide('fast');
// $('#process');
$("#scid").html(data);
}
);
}
}
function subcategory(scid)
{
if(scid!='')
{ $('#process2').show('slow');
$.post('<?=BASEDIR?>/ajax.php',{action:'select_template_by_subcategory_for_refine','scid':scid},function (data)
{
$('#process2').hide('fast');
$("#specification").html(data); });
}
}
</script>
<div class="lftpanel">
<div class="fl"><img src="<?=BASEDIR?>/images/browse_left.jpg" width="7" height="36" /></div>
<div class="brow_bg">Refine Your Search</div>
<div class="fl"><img src="<?=BASEDIR?>/images/browse_right.jpg" width="7" height="36" /></div>
<div class="cb"></div>
<div class="lft_cate_block">
<div class="pdng10lft pdng10top">
<form name="advSearch" id="advSearch" action="<?=BASEDIR?>/advance_search_result_redirect.php" method="get">
<table border="0" cellpadding="0" cellspacing="0" class="refine_tbl">
<tr>
<td>Title :</td>
</tr>
<tr>
<td><input type="text" name="title" id="title" class="input_srch_small" style="width:192px !important;" value=""></td>
</tr>
<tr>
<td>Price Range :</td>
</tr>
<tr>
<td><input name="price_start" id="price_start" type="text" class="input_srch_small" onblur="if(this.value=='') this.value='Minimum'" onfocus="if(this.value=='Minimum') this.value=''" value="Minimum"/><div class="to">To</div><input name="price_end" id="price_end" type="text" class="input_srch_small" onblur="if(this.value=='') this.value='Maximum'" onfocus="if(this.value=='Maximum') this.value=''" value="Maximum"/></td>
</tr>
<tr>
<td>Category :</td>
</tr>
<tr>
<td><select name="cid" id="cid" class="select_srch_small02" onChange="category(this.value)">
<option value="">Any</option>
<?php
$categoriesAsearch = select("cname,cid","category","where status = 1 order by cname ASC");
while($categorySubHead = mysql_fetch_object($categoriesAsearch))
{
if($cid !='')
{
$sel=selected($categorySubHead->cid,$cid);
}
elseif($_REQUEST['cid'])
{
$sel=selected($categorySubHead->cid,$_REQUEST['cid']);
}
?>
<option value="<?=$categorySubHead->cid;?>" <?=$sel?>><?=$categorySubHead->cname;?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td> <div id="process" name="process" style="display:none;text-align:center;"><img src="<?=BASEDIR?>/images/process.gif" ></div></td>
</tr>
<tr>
<td>Sub Category :</td>
</tr>
<tr>
<td><select name="scid" id="scid" class="select_srch_small02" onChange="subcategory(this.value)">
<option value="">Any</option>
<?php
$brandId=select("*","sub_category","where cid='".$cid."' and status = 1 GROUP BY scid");
if(mysql_num_rows($brandId)>0)
{
while($brandIdVal=mysql_fetch_object($brandId))
{
if($scid !='')
{
$sel=selected($brandIdVal->scid,$scid);
}
elseif($_REQUEST['scid'])
{
$sel=selected($brandIdVal->scid,$_REQUEST['scid']);
}
?>
<option value="<?=$brandIdVal->scid;?>" <?=$sel?> ><?=$brandIdVal->name;?></option>
<?php
}
}
else
{
?>
<option value="" >No Sub Category</option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>Location :</td>
</tr>
<tr>
<td>
<?php $locationsSubHead = select("location_id,name","location","where status = 1 order by name ASC"); ?>
<select name="location_id" id="location_id" class="select_srch_small02">
<option value="">Entire Malaysia</option>
<?php while($locationSubHead = mysql_fetch_object($locationsSubHead))
{
if($location_id !='')
{
$sel=selected($locationSubHead->location_id,$location_id);
}
elseif($_REQUEST['location_id'])
{
$sel=selected($locationSubHead->location_id,$_REQUEST['location_id']);
}
?>
<option value="<?=$locationSubHead->location_id;?>" <?=$sel?>><?=$locationSubHead->name;?></option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td> <div id="process2" name="process2" style="display:none;text-align:center;"><img src="<?=BASEDIR?>/images/process.gif" ></div></td>
</tr>
<tr >
<td> <table id="specification">
<?php
$template_id1 = selectfetch("template_id","specification_template","where cid = '".$cid."' and scid = '".$scid."' and status = 1 and tmp_type = 1");
$template_id2 = selectfetch("template_id","specification_template","where cid = '".$cid."' and scid = '".$scid."' and status = 1 and tmp_type = 2");
$specification1=select("DISTINCT spec_category_id","group_specificationjauction","where template_id='".$template_id1->template_id."' GROUP BY spec_id");
$specification2=select("DISTINCT spec_category_id","group_specificationjauction","where template_id='".$template_id2->template_id."' GROUP BY spec_id");
if(mysql_num_rows($specification1)>0)
{
while($specificationVal=mysql_fetch_object($specification1))
{
$cat = selectfetch("*","specification_category","where spec_category_id='".$specificationVal->spec_category_id."' and status = 1");
?>
<tr><td>
<input name="spec_category_id1[]" id="spec_category_id1[]" type="hidden" value="<?=$cat->spec_category_id?>">
<input type="hidden" id="template_id1" name="template_id1" value="<?=$template_id1->template_id?>">
</td></tr>
<?php
$atriTemp = select("spec_attribute_id","group_specificationjauction","where template_id='".$template_id1->template_id."' and spec_category_id = '".$specificationVal->spec_category_id."' GROUP BY spec_id");
if(mysql_num_rows($atriTemp)>0)
{
while($atriTempVal=mysql_fetch_object($atriTemp))
{
$alrt = selectfetch("*","specification_attribute","where spec_attribute_id='".$atriTempVal->spec_attribute_id."' and status = 1");
?>
<tr>
<td><?=$alrt->name;?> : <input name="spec_attribute_id1[]" id="spec_attribute_id1[]" type="hidden" value="<?=$alrt->spec_attribute_id?>" ></td>
</tr>
<tr>
<td>
<select class="select_srch_small02" name="spec_attribute_val1[]" id="spec_attribute_val1">
<option value="">Any</option>
<?php $attribute_value = select("*","specification_attribute_value","where spec_attribute_id = '".$alrt->spec_attribute_id."' and spec_category_id ='".$specificationVal->spec_category_id."' ");
while($value = mysql_fetch_object($attribute_value))
{
?>
<option value="<?=$value->value_id?>"><?=$value->name?></option>
<?php
}?>
</select>
</td>
</tr>
<?php
}
}
}
}
if(mysql_num_rows($specification2)>0)
{
while($specificationVal=mysql_fetch_object($specification2))
{
$cat = selectfetch("*","specification_category","where spec_category_id='".$specificationVal->spec_category_id."' and status = 1");
?>
<tr></td>
<input name="spec_category_id2[]" id="spec_category_id2[]" type="hidden" value="<?=$cat->spec_category_id?>">
<input type="hidden" id="template_id2" name="template_id2" value="<?=$template_id2->template_id?>">
</td></tr>
<?php
$atriTemp = select("spec_attribute_id","group_specificationjauction","where template_id='".$template_id2->template_id."' and spec_category_id = '".$specificationVal->spec_category_id."' GROUP BY spec_id");
if(mysql_num_rows($atriTemp)>0)
{
while($atriTempVal=mysql_fetch_object($atriTemp))
{
$alrt = selectfetch("*","specification_attribute","where spec_attribute_id='".$atriTempVal->spec_attribute_id."' and status = 1");
?>
<tr>
<td><?=$alrt->name;?> : <input name="spec_attribute_id2[]" id="spec_attribute_id2[]" type="hidden" value="<?=$alrt->spec_attribute_id?>" ></td>
</tr>
<tr>
<td>
<select class="select_srch_small02" name="spec_attribute_val2[]" id="spec_attribute_val2">
<option value="">Any</option>
<?php $attribute_value2 = select("*","specification_attribute_value","where spec_attribute_id = '".$atriTempVal->spec_attribute_id."' and spec_category_id ='".$specificationVal->spec_category_id."' ");
while($value2 = mysql_fetch_object($attribute_value2))
{
?>
<option value="<?=$value2->value_id?>"><?=$value2->name?></option>
<?php
}?>
</select>
</td>
</tr>
<?php
}
}
}
}
?>
</table></td></tr>
<td align="center"> </td>
</tr>
<tr>
<td align="center"><input type="submit" value="Refine" class="send_btn fn" style="cursor:pointer"></td>
</tr>
<tr>
<td align="center"></td>
</tr>
</table>
</form>
</div>
<div class="cb"></div>
</div>
<div class="cb"></div>
<div class="innerrgtga lga">
<div class="featued_block" style="width:235px;">
<div class="featued_block_heading">Sponsored Showcase
</div>
<!--jcarousel-->
<ul >
<?php
$nowDate = date("Y-m-d");
$fetAds = select("ps.pid","premium_services ps,products p","where ps.ps_cid = 4 and ps.start_date <= '$nowDate' and ps.end_date >= '$nowDate' and p.pid = ps.pid and p.status = 1 order by ps.ps_id DESC limit 0,12");
$countFetAds = mysql_num_rows($fetAds);
if($countFetAds >0)
{
while($fetads = mysql_fetch_object($fetAds))
{
$product = selectfetch("title,price,pid,scid","products","where pid = '".$fetads->pid."' and status_store = 1 and status = 1");
//print_r($product);
$productImage = selectfetch("img_name","photo_album","where pid = '".$product->pid."' and cover_photo = 1");
if($productImage->img_name=='')
{
$productImage = selectfetch("img_name","photo_album","where pid = '".$product->pid."'");
}
$productTitle = stripslashes(str_replace(" ","-",$product->title));
$productTitle = stripslashes(str_replace("/","~",$productTitle));
$productTitle = stripslashes(str_replace("?","",$productTitle));
$enpid = base64_encode($product->pid);
$hrefAdsdetail = href('product_detail.php','title='.$productTitle.'&pid='.$enpid);
//---------Price/Salary/Rent-------------//
$scid = $product->scid;
if($scid!='')
{
$price_id = selectfetch("price_id","price_subcategory","where scid= $scid");
if($price_id->price_id !='')
{
$priceName = selectfetch("name","price","where price_id = $price_id->price_id");
$price = $priceName->name;
}
else
{
$price = 'Price';
}
}
else
{
$price = 'Price';
}
//---------Price/Salary/Rent-------------//
?>
<li><div class="featured_img_block">
<div class="fea_img_div">
<?php $ps = selectfetch("end_date","premium_services","where pid = '".$product->pid."' and ps_cid = 2");
$cutentDate = strtotime(date("Y-m-d"));
$endDate = strtotime($ps->end_date);
if($endDate > $cutentDate)
{ ?>
<div class="urgent"></div>
<?php
}
?>
<a href="<?=$hrefAdsdetail?>"><?php if($productImage->img_name !=''){ ?><img src="<?=BASEDIR?>/uploads/product/index/<?=$productImage->img_name?>" /><?php }else{ ?><img src="<?=BASEDIR?>/images/images.jpg" width="113" height="101" /><?php } ?></a></div>
<div class="fea_cate_name"><?=substr($product->title,'0','13');?></div>
<p class="offer">RM <?=number_format($product->price, 2, '.', '');?></p>
</div></li>
<?php
}
}
else
{
?>
<li><div class="featured_img_block">
<div class="fea_img_div"><img src="<?=BASEDIR?>/images/noproduct.jpg" width="113" height="101" /></div>
<div class="fea_cate_name">No Featured Product </div>
<p class="offer"></p>
</div></li>
<?php
}
?>
</ul>
<!--jcarousel close-->
<div class="cb"></div>
</div></div>
<!--featured panel start-->
<!--featured panel end-->
</div>
`