public function search($location, $limit, $offset = 0, $query = null, $cat1 = null, $cat2 = null, $cat3 = null, $cat4 = null, $cat5 = null, $addtionalData = null)
{
logfire('restaurant cat2', $cat2);
if (empty($cat2) || $cat2 == 'Any' || $cat2 == 'ALL') {
$cat2 = null;
}
// temp fix for the router
$cat1 = $cat3;
$cat3 = null;
if (empty($cat1) || $cat1 == 'Any' || $cat1 == 'ALL' || $cat1 == 25) {
$cat1 = null;
}
$select = parent::search($location, $limit, $offset, $query, $cat1, $cat2, $cat3, $cat4, $cat5, $addtionalData);
if ($cat1 == null) {
$keys = '';
foreach ($this->getCat1Array() as $key => $value) {
if (empty($keys)) {
$keys = $key;
} else {
$keys .= ',' . $key;
}
}
$select->where('cat1 in (' . $keys . ')');
}
//echo $select;
return $select;
}
public function search($location, $limit, $offset = 0, $query = null, $cat1 = null, $cat2 = null, $cat3 = null, $cat4 = null, $cat5 = null, $addtionalData = null)
{
$orginalCat1 = $cat1;
if ($cat1 == $this->_cat1All) {
$cat1 = null;
}
$select = parent::search($location, $limit, $offset, $query, $cat1, $cat2, $cat3, $cat4, $cat5, $addtionalData);
if ($orginalCat1 == $this->_cat1All) {
logfire('sdfsdfsdfdsfdsfs', sizeof($this->getCat1Array()));
$keys = '';
foreach ($this->getCat1Array() as $key => $value) {
if (empty($keys)) {
$keys = $key;
} else {
$keys .= ',' . $key;
}
}
$select->where('cat1 in (' . $keys . ')');
}
logfire('job select', $select);
return $select;
}
public function search($location, $limit, $offset = 0, $query = null, $cat1 = null, $cat2 = null, $cat3 = null, $cat4 = null, $cat5 = null, $addtionalData = null)
{
if ($cat1 == 22) {
$cat1 = null;
}
logfire('realstatesearch cat2', $cat2);
if (empty($cat2) || $cat2 == 'Any' || $cat2 == 'ALL') {
$cat2 = null;
}
if (empty($cat3) || $cat3 == 'Any' || $cat3 == 'ALL') {
$cat3 = null;
}
$select = parent::search($location, $limit, $offset, $query, $cat1, $cat2, $cat3, $cat4, $cat5, $addtionalData);
// TODO price;
foreach ($addtionalData as $key => $value) {
logfire($key, $value);
}
if (!empty($addtionalData['min']) && $addtionalData['min'] != 'Any' && $addtionalData['min'] != 'ALL') {
$select->where('a.priceCalculate >= ?', $addtionalData['min']);
}
if (!empty($addtionalData['max']) && $addtionalData['max'] != 'Any' && $addtionalData['max'] != 'ALL') {
$select->where('a.priceCalculate <= ?', $addtionalData['max']);
}
if (empty($cat1)) {
$keys = '';
foreach ($this->getCat1Array() as $key => $value) {
if (empty($keys)) {
$keys = $key;
} else {
$keys .= ',' . $key;
}
}
$select->where('cat1 in (' . $keys . ')');
}
//echo $select;
return $select;
}
public function search($location, $limit, $offset = 0, $query = null, $cat1 = null, $cat2 = null, $cat3 = null, $cat4 = null, $cat5 = null, $addtionalData = null)
{
logfire('realstatesearch cat2', $cat2);
if (empty($cat2)) {
$cat2 = 630;
}
if ($cat3 == 631 || $cat3 == 639) {
$cat3 = null;
}
$select = parent::search($location, $limit, $offset, $query, $cat1, $cat2, $cat3, $cat4, $cat5, $addtionalData);
// TODO price;
foreach ($addtionalData as $key => $value) {
logfire($key, $value);
}
if ($addtionalData['bed'] != '' && $addtionalData['bed'] != 'Any' && $addtionalData['bed'] != 'ALL') {
if ($addtionalData['bed'] == 100) {
$select->where('i.rooms >= 6');
} else {
$select->where('i.rooms = ?', $addtionalData['bed']);
}
}
if ($addtionalData['cars'] != '' && $addtionalData['cars'] != 'Any' && $addtionalData['cars'] != 'ALL') {
if ($addtionalData['cars'] == 100) {
$select->where('i.parking >= 6');
} else {
$select->where('i.parking = ?', $addtionalData['cars']);
}
}
if ($addtionalData['bath'] != '' && $addtionalData['bath'] != 'Any' && $addtionalData['bath'] != 'ALL') {
if ($addtionalData['bath'] == 100) {
$select->where('i.baths >= 6');
} else {
$select->where('i.baths = ?', $addtionalData['bath']);
}
}
if (!empty($addtionalData['min']) && $addtionalData['min'] != 'Any' && $addtionalData['min'] != 'ALL') {
$select->where('a.priceCalculate >= ?', $addtionalData['min']);
}
if (!empty($addtionalData['max']) && $addtionalData['max'] != 'Any' && $addtionalData['max'] != 'ALL') {
$select->where('a.priceCalculate <= ?', $addtionalData['max']);
}
/*
if ($cat3 == 631||$cat3 == 639)
{
$keys = '';
foreach($this->getCat3Array($cat2, false) as $key=>$value)
{
if (empty($keys))
{
$keys = $key;
}
else
{
$keys .= ','.$key;
}
}
$select->where('cat3 in ('.$keys.')');
}
*/
//echo $select;
return $select;
}
public function actionLocation()
{
$cat = Yii::app()->getRequest()->getQuery('cat');
$bname = Yii::app()->getRequest()->getQuery('keyword');
$catname = Category::model()->getCategoryName($cat);
if ($cat == 'all' || empty($catname)) {
$query = "SELECT * \n\t\t\t\t\t\tFROM `mm_business` \n\t\t\t\t\t\tWHERE `business_name` LIKE '%" . $bname . "%' \n\t\t\t\t\t\tORDER BY `business_name` LIMIT 10";
} else {
$query = "SELECT * \n\t\t\t\t\tFROM `mm_business` \n\t\t\t\t\tWHERE `business_name` LIKE '%" . $bname . "%'\n\t\t\t\t\tAND\t`business_category` LIKE '" . $catname . "'";
}
$command = Yii::app()->db->createCommand($query);
$result = $command->queryAll();
$model = new Business('search');
$model->unsetAttributes();
// clear any
$model->business_name = $bname;
$model->business_category = $catname;
//send model object for search
$this->render('index', array('dataProvider' => $model->search(), 'model' => $model));
/*
$dataProvider=new CArrayDataProvider($result, array(
'sort'=>false,
'keyField'=>'id', //this is what will be considered your key field
'pagination'=>array(
'pageSize'=>30, //eureka! you can configure your pagination from here
),
));
//echo '<pre>'; var_dump($pp); die();
$this->render('index',array(
'dataProvider'=>$dataProvider,
));*/
//throw new CHttpException(404,'The requested page does not exist.');
}
