/**
* Displays a particular model.
* @param integer $id the ID of the model to be displayed
*/
public function actionView($id)
{
$criteria = new CDbCriteria();
$criteria->condition = 'province_id=' . $id;
$district = new CActiveDataProvider(District::model(), array('criteria' => $criteria));
$this->render('view', array('model' => $this->loadModel($id), 'district' => $district));
}
public static function getLocation($ward_id, $district_id, $province_id)
{
$ward_type = null;
$ward_name = null;
$district_type = null;
$district_name = null;
$province_type = null;
$province_name = null;
if (isset($ward_id)) {
$ward = Ward::model()->findByPk($ward_id);
if ($ward) {
$ward_type = $ward->type;
$ward_name = $ward->name;
}
}
if (isset($district_id)) {
$district = District::model()->findByPk($district_id);
if ($district) {
$district_type = $district->type;
$district_name = $district->name;
}
}
if (isset($province_id)) {
$province = Province::model()->findByPk($province_id);
if ($province) {
$province_type = $province->type;
$province_name = $province->name;
}
}
return $ward_type . " " . $ward_name . ", " . $district_type . " " . $district_name . ", " . $province_type . " " . $province_name;
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Notices();
$model->setScenario('create');
//int_r($_FILES);exit;
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
$path = Yii::app()->basePath . '/../uploads';
if (!is_dir($path)) {
mkdir($path);
}
if (isset($_POST['Notices'])) {
$model->attributes = $_POST['Notices'];
$model->user_id = Yii::app()->User->Id;
$user = User::model()->findByPk(Yii::app()->User->Id);
$state = State::model()->findByAttributes(array('statecode' => $user->statecode));
$dist = District::model()->findByAttributes(array('distcode' => $user->distcode));
$est = Establishments::model()->findByAttributes(array('id' => $user->est_id));
$model->state = $state->statename;
$model->district_court_complex = $dist->distname;
$model->establishment = $est->est_name;
$model->notice_date = date("Y-m-d H:i:s", time());
$user = User::model()->findByPk(Yii::app()->User->Id);
$model->judge_name = $user->judge;
$court_no = CourtT::model()->findAllByAttributes(array('judge_id' => $user->judge_id));
$court = '';
foreach ($court_no as $i) {
$court = $i['court_no'];
break;
}
$model->court = $court;
if ($model->validate($_POST['Notices'])) {
//exit("ASd");
if (@(!empty($_FILES['Notices']['name']['pdf_file']))) {
$model->pdf_file = $_POST['Notices']['pdf_file'];
$model->pdf_file = CUploadedFile::getInstance($model, 'pdf_file');
//$filename = time() . '_' . str_replace(' ', '_', strtolower($model->pdf_file));
if ($_POST['Notices']['notice_type'] == "Advertisment") {
$type = 1;
} elseif ($_POST['Notices']['notice_type'] == "Sale Notices") {
$type = 2;
} else {
$type = 3;
}
$filename = $type . "-" . str_replace(' ', '_', $_POST['Notices']['case_type']) . "-" . date("d-m-Y_H:i:s", time()) . ".pdf";
$model->pdf_file->saveAs($path . '/' . $filename);
$model->pdf_file = $filename;
$model->created = date("Y-m-d H:i:s", time());
$model->notice_date = date("Y-m-d H:i:s", strtotime($model->notice_date));
$model->appear_date = date("Y-m-d H:i:s", strtotime($model->appear_date));
}
}
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
public static function getDistrict($id)
{
$value = District::model()->findByAttributes(array('id' => $id));
if (empty($value->title)) {
return 'Not set';
} else {
return $value->title;
}
}
public function getDropdown()
{
global $dataDropdown;
$dataDropdown = array();
$parents = District::model()->findALl('t.status=1');
foreach ($parents as $parent) {
$dataDropdown[$parent->id] = $parent->name;
}
return $dataDropdown;
}
/**
* 获取地区
*/
public function actionGetDistrict()
{
$city_id = intval($this->_gets->getPost('city_id'));
$district = District::model()->findAll(array('select' => array('id', 'name'), 'condition' => 'city_id=:city_id', 'params' => array(':city_id' => $city_id)));
$options = '';
if (!empty($district)) {
foreach ($district as $val) {
$options .= "<option value='{$val['id']}'>{$val['name']}</option>";
}
}
echo $options;
}
public function actionLoadDistricts()
{
$data = District::model()->findAll('province=:province', array(':province' => (int) $_POST['province']));
$data = CHtml::listData($data, 'id', 'name');
$district = (int) $_POST['district'];
echo "<option value=''>Chọn quận/huyện</option>";
foreach ($data as $value => $name) {
if ($value == $district) {
echo CHtml::tag('option', array('value' => $value, 'selected' => 'selected'), CHtml::encode($name), true);
} else {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
}
public function actionInputPharmacy()
{
$this->checkLogin();
$ward = Ward::model()->findAll();
$district = District::model()->findAll();
$province = Province::model()->findAll();
$this->render('inputPharmacy', array('ward' => $ward, 'district' => $district, 'province' => $province));
}
<div class="form">
<?php
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'complex-form', 'enableAjaxValidation' => false));
?>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($model);
?>
<?php
echo $form->dropDownListControlGroup($model, 'state', CHtml::listData(State::model()->findAll(array('order' => 'statecode ASC')), 'statecode', 'statename'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('site/dynamicdistrict1'), 'update' => '#Complex_district'), 'empty' => 'Select State'), array('span' => 5));
$dist = CHtml::listData(District::model()->findAllByAttributes(array('statecode' => $model->state), array('order' => 'distname ASC')), 'distcode', 'distname');
?>
<?php
echo $form->dropDownListControlGroup($model, 'district', $dist, array());
?>
<?php
//echo $form->textFieldControlGroup($model,'type',array('span'=>5,'maxlength'=>45));
?>
<?php
echo $form->dropDownListControlGroup($model, 'type', array('TC' => 'Taluka Court Complex', 'DC' => 'District Court Complex'), array());
?>
<?php
echo $form->textFieldControlGroup($model, 'name', array('span' => 5, 'maxlength' => 245));
?>
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = District::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionUpdateDistricts()
{
$data = District::model()->findAll('idCity=:idCity', array(':idCity' => (int) $_POST['idCity']));
$data = CHtml::listData($data, 'idDistrict', 'name');
echo "<option value=''>Select District</option>";
foreach ($data as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
public function getDistrictLinks($rubr,$module = 'catalog')
{
$districts = District::model()->findAll(array('condition'=>'city_id=:city_id','params'=>array(':city_id'=>$this->id)));
$links = '';
if($districts)
{
foreach ($districts as $district)
{
if((mb_strpos($district->district_name, 'район', 0, 'UTF-8') !== false) && (mb_strpos($district->district_name, 'микрорайон', 0, 'UTF-8') === false))
{
$url = Yii::app()->createAbsoluteUrl('/'.$module.'/catalog/district', array('city'=>$this->url, 'url'=>$rubr->url, 'district'=>'rayon'));
$links .= '<a class="parentCategoryElement" href="'.$url.'">'.$rubr->title.' по районам города</a>';
break;
}
}
foreach ($districts as $district)
{
if(mb_strpos($district->district_name, 'микрорайон', 0, 'UTF-8') !== false )
{
$url = Yii::app()->createAbsoluteUrl('/'.$module.'/catalog/district', array('city'=>$this->url, 'url'=>$rubr->url, 'district'=>'mikrorayon'));
$links .= '<a class="parentCategoryElement" href="'.$url.'">'.$rubr->title.' по микрорайонам города</a>';
break;
}
}
foreach ($districts as $district)
{
if(mb_strpos($district->district_name, 'округ', 0, 'UTF-8') !== false )
{
$url = Yii::app()->createAbsoluteUrl('/'.$module.'/catalog/district', array('city'=>$this->url, 'url'=>$rubr->url, 'district'=>'okrug'));
$links .= '<a class="parentCategoryElement" href="'.$url.'">'.$rubr->title.' по округам</a>';
break;
}
}
}
if($module == 'catalog'){
$metros = Metro::model()->find(array('condition'=>'city_id=:city_id','params'=>array(':city_id'=>$this->id)));
if($metros)
{
$url = Yii::app()->createAbsoluteUrl('/'.$module.'/catalog/district', array('city'=>$this->url, 'url'=>$rubr->url, 'district'=>'metro'));
$links .= '<a class="parentCategoryElement" href="'.$url.'">'.$rubr->title.' по станциям метро</a>';
}
}
return $links;
}
public function actionGetMapHouse()
{
$result = array();
if (empty($_POST)) {
$result['IsError'] = true;
$result['Message'] = '数据接收失败';
} else {
$result['IsError'] = false;
//根据条件查询地图
$criteria = new CDbCriteria();
// $criteria->join = 'join city_id as b on b.id = t.city_id';
// $criteria->join .= ' join propertyType_id as c on c.id = t.propertyType_id';
/* 排序
* <span data-value="1">价格：从高到低</span>
<span data-value="2">价格：从低到高</span>
<span data-value="3">日期：从后到前</span>
<span data-value="4">日期：从前到后</span>
*/
if ($_POST['orderby'] == 1) {
$criteria->order = 't.lp_dol desc';
} else {
if ($_POST['orderby'] == 2) {
$criteria->order = 't.lp_dol asc';
} else {
if ($_POST['orderby'] == 3) {
$criteria->order = 't.yr_built asc';
} else {
if ($_POST['orderby'] == 4) {
$criteria->order = 't.yr_built desc';
} else {
$criteria->order = 't.id desc';
}
}
}
}
//city_id
if (!empty($_POST['country']) && trim($_POST['country']) != 'undefined') {
$criteria->addCondition("t.city_id = :city_id");
$criteria->params += array(':city_id' => intval($_POST['country']));
}
//district_id
if (!empty($_POST['district']) && trim($_POST['district']) != 'undefined') {
$criteria->addCondition("t.district_id = :district_id");
$criteria->params += array(':district_id' => intval($_POST['district']));
}
//卫生间数量 1-5
if (!empty($_POST['housebaths']) && intval($_POST['housebaths']) > 0) {
$criteria->addCondition("t.toilet_num = :toilet_num");
$criteria->params += array(':toilet_num' => intval($_POST['housebaths']));
}
//土地面积
if (!empty($_POST['houseground'])) {
$ground = explode(',', $_POST['houseground']);
$minGround = intval($ground[0]);
$maxGround = intval($ground[1]);
if ($minGround != 0 || $maxGround != 0) {
if ($maxGround > $minGround) {
$criteria->addCondition("t.depth*t.front_ft <= :maxGround");
$criteria->params += array(':maxGround' => $maxGround);
}
$criteria->addCondition("t.depth*t.front_ft >= :minGround");
$criteria->params += array(':minGround' => $minGround);
}
}
//价格区间
if (!empty($_POST['houseprice'])) {
$price = explode(',', $_POST['houseprice']);
$minPrice = intval($price[0]);
$maxPrice = intval($price[1]);
if ($maxPrice != 0 || $minPrice != 0) {
if ($maxPrice > $minPrice) {
$criteria->addCondition("t.lp_dol <= :maxPrice");
$criteria->params += array(':maxPrice' => $maxPrice);
}
$criteria->addCondition("t.lp_dol >= :minPrice");
$criteria->params += array(':minPrice' => $minPrice);
}
}
//房型
if (!empty($_POST['houseroom']) && intval($_POST['houseroom']) > 0) {
$houseroom = intval($_POST['houseroom']);
if ($houseroom == '6') {
$criteria->addCondition("t.br_plus >= :bedroom_num");
} else {
if ($houseroom > 0) {
$criteria->addCondition("t.br_plus = :bedroom_num");
}
}
$criteria->params += array(':br_plus' => $houseroom);
}
//房屋类型
if (!empty($_POST['housetype']) && intval($_POST['housetype']) != 0) {
if ($_POST['housetype'] == 1) {
$criteria->addCondition('type_own1_out="Detached"');
} elseif ($_POST['housetype'] == 2) {
$criteria->addCondition('type_own1_out="Townhouse" or type_own1_out="Att∕Row∕Twnhouse" or type_own1_out="Triplex" or type_own1_out="Fourplex" or type_own1_out="Multiplex"');
} elseif ($_POST['housetype'] == 3) {
$criteria->addCondition('lp_dol>3000000');
} elseif ($_POST['housetype'] == 4) {
$criteria->addCondition('type_own1_out="Semi-Detached" or type_own1_out="Link" or type_own1_out="Duplex"');
} elseif ($_POST['housetype'] == 5) {
$criteria->addCondition('type_own1_out="Cottage" or type_own1_out="Rural Resid"');
} elseif ($_POST['housetype'] == 6) {
$criteria->addCondition('type_own1_out="Farm"');
} elseif ($_POST['housetype'] == 7) {
$criteria->addCondition('type_own1_out="Vacant Land"');
} elseif ($_POST['housetype'] == 8) {
$criteria->addCondition('type_own1_out="Mobile/Trailer" or type_own1_out="Det W/Com Elements" or type_own1_out="Store W/Apt/offc"');
}
// $criteria->addCondition("t.propertyType_id = :propertyType_id");
// $criteria->params += array(':propertyType_id' => intval($_POST['housetype']));
}
//根据地区名字搜索
if (!empty($_POST['city']) && trim($_POST['city']) != '州名/市名(中英)') {
$city = trim($_POST['city']);
$criteria->addCondition("t.addr like '%" . $city . "%' OR b.pinyin like '%" . $city . "%' OR b.englishName like '%" . $city . "%'");
}
//建造年份
if (!empty($_POST['houseyear'])) {
$year = explode(',', $_POST['houseyear']);
$minYear = intval($year[0]);
$maxYear = intval($year[1]);
if ($maxYear != 0 || $minYear != 0) {
if ($maxYear > $minYear) {
$criteria->addCondition("t.yr <= :maxYear");
$criteria->params += array(':maxYear' => $maxYear);
}
$criteria->addCondition("t.yr >= :minYear");
$criteria->params += array(':minYear' => $minYear);
}
}
$house = House::model()->findAll($criteria);
//经纬度范围
if ((empty($_POST['city']) || trim($_POST['city']) == '州名/市名(中英)') && empty($_POST['country']) && !empty($_POST['city'])) {
if (!empty($house)) {
$bound = explode(',', $_POST['bounds']);
foreach ($house as $key => $val) {
$jingweidu = actionGetCodeAddress2($val->country . $val->community . $val->addr);
if (floatval($val->latitude) >= floatval($bound[0]) && floatval($jingweidu['lat']) <= floatval($bound[2]) && floatval($jingweidu['lng']) >= floatval($bound[1]) && floatval($jingweidu['lng']) <= floatval($bound[3])) {
} else {
unset($house[$key]);
}
}
}
}
$count = count($house);
//数据重组
if (!empty($house)) {
$result['Message'] = '成功';
$result['Data']['AreaHouseCount'] = array();
$result['Data']['MapHouseList'] = array();
foreach ($house as $key => $val) {
$jingweidu = actionGetCodeAddress2($val->country . $val->community . $val->addr);
$mapHouseList = array();
$mapHouseList['Beds'] = $val->br_plus;
$mapHouseList['Baths'] = $val->bath_tot;
$mapHouseList['Kitchen'] = $val->kit_plus;
$mapHouseList['GeocodeLat'] = $jingweidu['lat'];
$mapHouseList['GeocodeLng'] = $jingweidu['lng'];
$mapHouseList['Address'] = $val->addr;
$mapHouseList['Price'] = $val->lp_dol;
$mapHouseList['Id'] = $val->id;
$propertyType = PropertyType::model()->findByPk($val->propertyType_id);
$mapHouseList['HouseType'] = !empty($propertyType) ? $propertyType->name : '';
$countryInfo = City::model()->findByPk($val->city_id);
$mapHouseList['CountryName'] = !empty($countryInfo) ? $countryInfo->name : '';
$mapHouseList['Country'] = $val->city_id;
$mapHouseList['Money'] = 'CAD';
$area2Name = District::model()->findByPk($val->district_id);
$mapHouseList['Area2Name'] = !empty($area2Name) ? $area2Name->name : '';
$mapHouseList['CoverImg'] = !empty($val->house_image) ? $val->house_image : 'uploads/201501/29cd77e5f187df554a1ff9facdc190e2.jpg';
$mapHouseList['BuildYear'] = $val->construction_year;
$result['Data']['MapHouseList'][] = $mapHouseList;
//数据总数拼装
if (!empty($countryInfo)) {
$provinceInfo = Province::model()->findByPk($countryInfo->province_id);
}
if (intval($_POST['zoom']) < 10 && intval($_POST['zoom']) >= 6) {
$result['Data']['AreaHouseCount'][$val->city_id]['Count']['NameCn'] = $val['name'];
$result['Data']['AreaHouseCount'][$val->city_id]['Count']['HouseCount'] += 1;
$result['Data']['AreaHouseCount'][$val->city_id]['Count']['GeocodeLat'] = !empty($countryInfo) ? $countryInfo->lat : '';
$result['Data']['AreaHouseCount'][$val->city_id]['Count']['GeocodeLng'] = !empty($countryInfo) ? $countryInfo->lnt : '';
$result['Data']['AreaHouseCount'][$val->city_id]['Count']['MaxZoom'] = 2;
$result['Data']['AreaHouseCount'][$val->city_id]['List'][] = $mapHouseList;
} else {
if (intval($_POST['zoom']) < 6) {
if (!empty($provinceInfo)) {
$result['Data']['AreaHouseCount'][$provinceInfo->id]['Count']['NameCn'] = $val['name'];
$result['Data']['AreaHouseCount'][$provinceInfo->id]['Count']['HouseCount'] += 1;
$result['Data']['AreaHouseCount'][$provinceInfo->id]['Count']['GeocodeLat'] = $provinceInfo->lat;
$result['Data']['AreaHouseCount'][$provinceInfo->id]['Count']['GeocodeLng'] = $provinceInfo->lnt;
$result['Data']['AreaHouseCount'][$provinceInfo->id]['Count']['MaxZoom'] = 2;
$result['Data']['AreaHouseCount'][$provinceInfo->id]['List'][] = $mapHouseList;
}
}
}
}
} else {
$result['IsError'] = true;
$result['Message'] = '无数据';
}
}
echo json_encode($result);
}
<div class="row">
<?php
echo $form->label($model, 'en_name');
?>
<?php
echo $form->textField($model, 'en_name', array('maxlength' => 255));
?>
</div>
<div class="row">
<?php
echo $form->label($model, 'district_id');
?>
<?php
echo $form->dropDownList($model, 'district_id', GxHtml::listDataEx(District::model()->findAllAttributes(null, true)), array('prompt' => Yii::t('app', 'All')));
?>
</div>
<div class="row buttons">
<?php
echo GxHtml::submitButton(Yii::t('app', 'Search'));
?>
</div>
<?php
$this->endWidget();
?>
</div><!-- search-form -->
public function actionAjaxGetDistricts()
{
$city_id = Yii::app()->request->getPost('city_id');
$district_list = array();
if (!empty($city_id)) {
$district_list = District::model()->findAll('city_id=:city_id', array(':city_id' => $city_id));
} else {
$district_list = District::model()->findAll();
}
echo CJSON::encode(array('data' => $district_list));
}
echo $form->textField($model, 'ar_name', array('maxlength' => 255));
?>
<?php
echo $form->error($model, 'ar_name');
?>
</div><!-- row -->
<div class="row">
<?php
echo $form->labelEx($model, 'country_id');
?>
<?php
echo $form->dropDownList($model, 'country_id', GxHtml::listDataEx(Country::model()->findAllAttributes(null, true)));
?>
<?php
echo $form->error($model, 'country_id');
?>
</div><!-- row -->
<label><?php
echo GxHtml::encode($model->getRelationLabel('districts'));
?>
</label>
<?php
echo $form->checkBoxList($model, 'districts', GxHtml::encodeEx(GxHtml::listDataEx(District::model()->findAllAttributes(null, true)), false, true));
?>
<?php
echo GxHtml::submitButton(Yii::t('app', 'Save'));
$this->endWidget();
?>
</div><!-- form -->
echo $form->labelEx($model, 'place_id');
?>
<?php
echo $form->dropDownList($model, 'place', CHtml::listData(Place::model()->findAll(), 'id', 'other_names'), array('prompt' => 'None'));
?>
<?php
echo $form->error($model, 'place_id');
?>
</div>-->
<div class="row">
<?php
echo $form->labelEx($model, 'district_id');
?>
<?php
echo $form->dropDownList($model, 'district', CHtml::listData(District::model()->findAll(), 'id', 'name'), array('prompt' => 'None'));
?>
<?php
echo $form->error($model, 'district_id');
?>
</div>
<div class="row">
<?php
echo $form->labelEx($model, 'image');
?>
<?php
// echo $form->textField($model, 'image', array('size' => 60, 'maxlength' => 60));
echo CHtml::activeFileField($model, 'image');
echo $form->error($model, 'image');
?>
/**
* 房源列表
*/
public function actionIndex()
{
Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . '/css/house.css');
$city_id = Yii::app()->request->getQuery('cd1', 0);
$district_id = Yii::app()->request->getQuery('cd2', 0);
$investType_id = Yii::app()->request->getQuery('cd3', 0);
$propertyType_id = Yii::app()->request->getQuery('cd4', 0);
$total_price = Yii::app()->request->getQuery('cd5', 0);
$house_area = Yii::app()->request->getQuery('cd6', 0);
$land_area = Yii::app()->request->getQuery('cd7', 0);
$bedroom_num = Yii::app()->request->getQuery('cd8', 0);
$construction_year = Yii::app()->request->getQuery('cd9', 0);
$prop_featx_out = Yii::app()->request->getQuery('cd10', 0);
$time_sort = Yii::app()->request->getQuery('time_sort', 'DESC');
$price_sort = Yii::app()->request->getQuery('price_sort');
$diy_word = null;
$city_list = City::model()->findAll(array('order' => 'id ASC'));
if (!empty($city_id)) {
$district_list = District::model()->findAll('city_id=:city_id', array(':city_id' => $city_id));
} else {
$district_list = District::model()->findAll();
}
$investType_list = InvestType::model()->findAll();
$propertyType_list = PropertyType::model()->findAll();
//按搜索条件查询房源信息
$criteria = new CDbCriteria();
if (!empty($city_id)) {
$criteria->addCondition('city_id=' . $city_id);
}
if (!empty($district_id)) {
$criteria->addCondition('district_id=' . $district_id);
}
if (!empty($propertyType_id)) {
if ($propertyType_id == 1) {
$criteria->addCondition('type_own1_out="Detached"');
} elseif ($propertyType_id == 2) {
$criteria->addCondition('type_own1_out="Townhouse" or type_own1_out="Att∕Row∕Twnhouse" or type_own1_out="Triplex" or type_own1_out="Fourplex" or type_own1_out="Multiplex"');
} elseif ($propertyType_id == 3) {
$criteria->addCondition('lp_dol>3000000');
} elseif ($propertyType_id == 4) {
$criteria->addCondition('type_own1_out="Semi-Detached" or type_own1_out="Link" or type_own1_out="Duplex"');
} elseif ($propertyType_id == 5) {
$criteria->addCondition('type_own1_out="Cottage" or type_own1_out="Rural Resid"');
} elseif ($propertyType_id == 6) {
$criteria->addCondition('type_own1_out="Farm"');
} elseif ($propertyType_id == 7) {
$criteria->addCondition('type_own1_out="Vacant Land"');
} elseif ($propertyType_id == 8) {
$criteria->addCondition('type_own1_out="Mobile/Trailer" or type_own1_out="Det W/Com Elements" or type_own1_out="Store W/Apt/offc"');
}
}
if (!empty($total_price)) {
if (!empty(self::$searchData['cd5'][$total_price]['min'])) {
$criteria->addCondition('lp_dol>' . self::$searchData['cd5'][$total_price]['min']);
}
if (!empty(self::$searchData['cd5'][$total_price]['max'])) {
$criteria->addCondition('lp_dol<=' . self::$searchData['cd5'][$total_price]['max']);
}
}
if (!empty($house_area)) {
if (!empty(self::$searchData['cd6'][$house_area]['min'])) {
$criteria->addCondition('sqft>' . self::$searchData['cd6'][$house_area]['min']);
}
if (!empty(self::$searchData['cd6'][$house_area]['max'])) {
$criteria->addCondition('sqft<=' . self::$searchData['cd6'][$house_area]['max']);
}
}
if (!empty($land_area)) {
if (!empty(self::$searchData['cd7'][$land_area]['min'])) {
$criteria->addCondition('depth*front_ft>' . self::$searchData['cd7'][$land_area]['min']);
}
if (!empty(self::$searchData['cd7'][$land_area]['max'])) {
$criteria->addCondition('depth*front_ft<=' . self::$searchData['cd7'][$land_area]['max']);
}
}
if (!empty($bedroom_num)) {
if ($bedroom_num <= 5) {
$criteria->addCondition('br_plus=' . $bedroom_num);
} else {
$criteria->addCondition('br_plus>=' . $bedroom_num);
}
}
if (!empty($construction_year)) {
if (!empty(self::$searchData['cd9'][$construction_year]['min'])) {
$criteria->addCondition('yr_built>' . self::$searchData['cd9'][$construction_year]['min']);
}
if (!empty(self::$searchData['cd9'][$construction_year]['max'])) {
$criteria->addCondition('yr_built<=' . self::$searchData['cd9'][$construction_year]['max']);
}
}
if (!empty($prop_featx_out)) {
$criteria->addCondition('prop_feat1_out="' . $prop_featx_out . '"');
}
$criteria->order = 'id DESC';
if (!empty($time_sort)) {
$criteria->order = 'pix_updt ' . $time_sort;
}
if (!empty($price_sort)) {
$criteria->order = 'lp_dol ' . $price_sort;
}
$count = House::model()->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = 10;
$pager->applyLimit($criteria);
$house_list = House::model()->findAll($criteria);
$collection_list = array();
if ($this->_account['userId']) {
$collect_model = Collect::model()->find('user_id=:user_id', array(':user_id' => $this->_account['userId']));
if (!empty($collect_model)) {
$collection_list = explode(',', $collect_model->collection);
}
}
$data = array('cd1' => $city_id, 'cd2' => $district_id, 'cd3' => $investType_id, 'cd4' => $propertyType_id, 'cd5' => $total_price, 'cd6' => $house_area, 'cd7' => $land_area, 'cd8' => $bedroom_num, 'cd9' => $construction_year, 'cd10' => $prop_featx_out, 'time_sort' => $time_sort, 'price_sort' => $price_sort, 'diy_price' => json_encode($diy_price), 'city_list' => $city_list, 'district_list' => $district_list, 'investType_list' => $investType_list, 'propertyType_list' => $propertyType_list, 'count' => $count, 'house_list' => $house_list, 'collection_list' => $collection_list, "pages" => $pager);
$this->render('index', $data);
}
/**
* 房源列表
*/
public function actionIndex()
{
Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . '/css/house.css');
$city_id = Yii::app()->request->getQuery('cd1', 0);
$district_id = Yii::app()->request->getQuery('cd2', 0);
//used to be Region search. Change it to municipality search
$investType_id = Yii::app()->request->getQuery('cd3', 0);
$propertyType_id = Yii::app()->request->getQuery('cd4', 0);
$total_price = Yii::app()->request->getQuery('cd5', 0);
$house_area = Yii::app()->request->getQuery('cd6', 0);
$land_area = Yii::app()->request->getQuery('cd7', 0);
$bedroom_num = Yii::app()->request->getQuery('cd8', 0);
$construction_year = Yii::app()->request->getQuery('cd9', 0);
$prop_featx_out = Yii::app()->request->getQuery('cd10', 0);
$prop_featx_out2 = Yii::app()->request->getQuery('cd11', 0);
$prop_featx_out3 = Yii::app()->request->getQuery('cd12', 0);
$prop_featx_out_2 = Yii::app()->request->getQuery('cd12_2', 0);
$prop_featx_out_3 = Yii::app()->request->getQuery('cd12_3', 0);
$prop_featx_out_4 = Yii::app()->request->getQuery('cd12_4', 0);
$prop_featx_out_5 = Yii::app()->request->getQuery('cd12_5', 0);
$type = Yii::app()->request->getQuery('type', 'sale');
$bath_tot = Yii::app()->request->getQuery('cd13', 0);
$style = Yii::app()->request->getQuery('cd14', 0);
$comp_pts = Yii::app()->request->getQuery('cd15', 0);
$gar_spaces = Yii::app()->request->getQuery('cd16', 0);
$bsmt1_out = Yii::app()->request->getQuery('cd17', 0);
$pool = Yii::app()->request->getQuery('cd18', 0);
$time_sort = Yii::app()->request->getQuery('time_sort', 'DESC');
$price_sort = Yii::app()->request->getQuery('price_sort');
$type = Yii::app()->request->getQuery('type');
$diy_word = null;
//$city_list = City::model()->findAll(array('order'=>'id ASC'));
$city_list = City::model()->findAll(array('condition' => 'avail=1', 'order' => 'id ASC'));
//$province_list = Province::model()->findAll(array('condition'=>'avail=1','order'=>'id ASC'));
if (!empty($city_id)) {
$district_list = District::model()->findAll('city_id=:city_id', array(':city_id' => $city_id));
} else {
$district_list = District::model()->findAll();
}
$investType_list = InvestType::model()->findAll();
$propertyType_list = PropertyType::model()->findAll();
//按搜索条件查询房源信息
$criteria = new CDbCriteria();
//VOW limits
$criteria->addCondition('src != "VOW"');
//Search By Sale or Lease Type
//$criteria->addCondition('s_r ="Sale"');
if ($type == "sale") {
$criteria->addCondition('s_r = "Sale"');
} elseif ($type == "rent") {
$criteria->addCondition('s_r = "Lease"');
}
//省份
//if(!empty($city_id)) $criteria->addCondition('area!=""');
if (!empty($city_id)) {
$criteria->addCondition('city_id=' . $city_id);
}
//地区
if (!empty($district_id)) {
$criteria->addCondition('t.municipality ="' . $district_id . '"');
}
//挂牌时间
if (!empty($investType_id)) {
if ($investType_id == 1) {
//数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 1 DAY) <= date(pix_updt)');
} elseif ($investType_id == 2) {
//查询7数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(pix_updt)');
} elseif ($investType_id == 3) {
//查询1月数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(pix_updt)');
} elseif ($investType_id == 4) {
//查询三月数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 90 DAY) <= date(pix_updt)');
}
}
if (!empty($prop_featx_out)) {
if ($prop_featx_out == 1) {
$criteria->addCondition('prop_feat1_out like "%Waterfront%" or prop_feat2_out like "%Waterfront%" or prop_feat3_out like "%Waterfront%" or prop_feat4_out like "%Waterfront%" or prop_feat5_out like "%Waterfront%" or prop_feat6_out like "%Waterfront%" ');
} elseif ($prop_featx_out == 2) {
$criteria->addCondition('prop_feat1_out like "%Pond%" or prop_feat2_out like "%Pond%" or prop_feat3_out like "%Pond%" or prop_feat4_out like "%Pond%" or prop_feat5_out like "%Pond%" or prop_feat6_out like "%Pond%" ');
} elseif ($prop_featx_out == 3) {
$criteria->addCondition('prop_feat1_out like "%Stream%" or prop_feat2_out like "%Stream%" or prop_feat3_out like "%Stream%" or prop_feat4_out like "%Stream%" or prop_feat5_out like "%Stream%" or prop_feat6_out like "%Stream%" ');
} elseif ($prop_featx_out == 4) {
$criteria->addCondition('prop_feat1_out like "%River%" or prop_feat2_out like "%River%" or prop_feat3_out like "%River%" or prop_feat4_out like "%River%" or prop_feat5_out like "%River%" or prop_feat6_out like "%River%" ');
} elseif ($prop_featx_out == 5) {
$criteria->addCondition('prop_feat1_out like "%Lake%" or prop_feat2_out like "%Lake%" or prop_feat3_out like "%Lake%" or prop_feat4_out like "%Lake%" or prop_feat5_out like "%Lake%" or prop_feat6_out like "%Lake%" ');
} elseif ($prop_featx_out == 6) {
$criteria->addCondition('prop_feat1_out like "%Marina%" or prop_feat2_out like "%Marina%" or prop_feat3_out like "%Marina%" or prop_feat4_out like "%Marina%" or prop_feat5_out like "%Marina%" or prop_feat6_out like "%Marina%" ');
}
}
if (!empty($prop_featx_out2)) {
if ($prop_featx_out2 == 1) {
$criteria->addCondition('prop_feat1_out like "%Treed%" or prop_feat2_out like "%Treed%" or prop_feat3_out like "%Treed%" or prop_feat4_out like "%Treed%" or prop_feat5_out like "%Treed%" or prop_feat6_out like "%Treed%" ');
} elseif ($prop_featx_out2 == 2) {
$criteria->addCondition('prop_feat1_out like "%Wooded%" or prop_feat2_out like "%Wooded%" or prop_feat3_out like "%Wooded%" or prop_feat4_out like "%Wooded%" or prop_feat5_out like "%Wooded%" or prop_feat6_out like "%Wooded%" ');
} elseif ($prop_featx_out2 == 3) {
$criteria->addCondition('prop_feat1_out like "%Grnbelt%" or prop_feat2_out like "%Grnbelt%" or prop_feat3_out like "%Grnbelt%" or prop_feat4_out like "%Grnbelt%" or prop_feat5_out like "%Grnbelt%" or prop_feat6_out like "%Grnbelt%" ');
} elseif ($prop_featx_out2 == 4) {
$criteria->addCondition('prop_feat1_out like "%Conserv%" or prop_feat2_out like "%Conserv%" or prop_feat3_out like "%Conserv%" or prop_feat4_out like "%Conserv%" or prop_feat5_out like "%Conserv%" or prop_feat6_out like "%Conserv%" ');
} elseif ($prop_featx_out2 == 5) {
$criteria->addCondition('prop_feat1_out like "%Ravine%" or prop_feat2_out like "%Ravine%" or prop_feat3_out like "%Ravine%" or prop_feat4_out like "%Ravine%" or prop_feat5_out like "%Ravine%" or prop_feat6_out like "%Ravine%" ');
}
}
//$prop_featx_out3==>学校 1 prop_feat1_out like "%School%" or prop_feat2_out like "%School%" or prop_feat3_out like "%School%" or prop_feat4_out like "%School%" or prop_feat5_out like "%School%" or prop_feat6_out like "%School%"
//$prop_featx_out_2==>医院 1 prop_feat1_out like "%Hospital%" or prop_feat2_out like "%Hospital%" or prop_feat3_out like "%Hospital%" or prop_feat4_out like "%Hospital%" or prop_feat5_out like "%Hospital%" or prop_feat6_out like "%Hospital%"
//$prop_featx_out_3==>公共交通 1 prop_feat1_out like "%Public Transit%" or prop_feat2_out like "%Public Transit%" or prop_feat3_out like "%Public Transit%" or prop_feat4_out like "%Public Transit%" or prop_feat5_out like "%Public Transit%" or prop_feat6_out like "%Public Transit%"
//$prop_featx_out_4==>高尔夫球场 1 prop_feat1_out like "%Golf%" or prop_feat2_out like "%Golf%" or prop_feat3_out like "%Golf%" or prop_feat4_out like "%Golf%" or prop_feat5_out like "%Golf%" or prop_feat6_out like "%Golf%"
//$prop_featx_out_5==>图书馆 1 prop_feat1_out like "%Library%" or prop_feat2_out like "%Library%" or prop_feat3_out like "%Library%" or prop_feat4_out like "%Library%" or prop_feat5_out like "%Library%" or prop_feat6_out like "%Library%"
if (!empty($prop_featx_out3)) {
$criteria->addCondition('prop_feat1_out like "%School%" or prop_feat2_out like "%School%" or prop_feat3_out like "%School%" or prop_feat4_out like "%School%" or prop_feat5_out like "%School%" or prop_feat6_out like "%School%" ');
}
if (!empty($prop_featx_out_2)) {
$criteria->addCondition('prop_feat1_out like "%Hospital%" or prop_feat2_out like "%Hospital%" or prop_feat3_out like "%Hospital%" or prop_feat4_out like "%Hospital%" or prop_feat5_out like "%Hospital%" or prop_feat6_out like "%Hospital%"');
}
if (!empty($prop_featx_out_3)) {
$criteria->addCondition('prop_feat1_out like "%Public Transit%" or prop_feat2_out like "%Public Transit%" or prop_feat3_out like "%Public Transit%" or prop_feat4_out like "%Public Transit%" or prop_feat5_out like "%Public Transit%" or prop_feat6_out like "%Public Transit%"');
}
if (!empty($prop_featx_out_4)) {
$criteria->addCondition('prop_feat1_out like "%Golf%" or prop_feat2_out like "%Golf%" or prop_feat3_out like "%Golf%" or prop_feat4_out like "%Golf%" or prop_feat5_out like "%Golf%" or prop_feat6_out like "%Golf%"');
}
if (!empty($prop_featx_out_5)) {
$criteria->addCondition('prop_feat1_out like "%Library%" or prop_feat2_out like "%Library%" or prop_feat3_out like "%Library%" or prop_feat4_out like "%Library%" or prop_feat5_out like "%Library%" or prop_feat6_out like "%Library%"');
}
//物业类型
if (!empty($propertyType_id)) {
$criteria->addCondition('propertyType_id="' . $propertyType_id . '"');
}
if (strpos($total_price, '-') !== false) {
$price = explode('-', $total_price);
$minPrice = intval($price[0]) * 10000;
$maxPrice = intval($price[1]) * 10000;
if ($maxPrice != 0 || $minPrice != 0) {
if ($maxPrice > $minPrice) {
$criteria->addCondition('lp_dol <' . $maxPrice);
}
$criteria->addCondition('lp_dol >=' . $minPrice);
}
}
//房屋面积
if (!empty($house_area)) {
if ($house_area == 1) {
$criteria->addCondition('house_area<700 and house_area > 1');
} elseif ($house_area == 2) {
$criteria->addCondition('house_area>=700 and house_area<1100');
} elseif ($house_area == 3) {
$criteria->addCondition('house_area>=1100 and house_area<1500');
} elseif ($house_area == 4) {
$criteria->addCondition('house_area>=1500 and house_area<2000');
} elseif ($house_area == 5) {
$criteria->addCondition('house_area>=2000 and house_area<2500');
} elseif ($house_area == 6) {
$criteria->addCondition('house_area>=2500 and house_area<3000');
} elseif ($house_area == 7) {
$criteria->addCondition('house_area>=3000 and house_area<3500');
} elseif ($house_area == 8) {
$criteria->addCondition('house_area>=3500 and house_area<4000');
} elseif ($house_area == 9) {
$criteria->addCondition('house_area>=4000');
}
}
//土地面积
if (!empty($land_area)) {
if ($land_area == 1) {
$criteria->addCondition('land_area<2000 and land_area > 100');
} elseif ($land_area == 2) {
$criteria->addCondition('land_area>=2000 and land_area<4000');
} elseif ($land_area == 3) {
$criteria->addCondition('land_area>=4000 and land_area<6000');
} elseif ($land_area == 4) {
$criteria->addCondition('land_area>=6000 and land_area<12000');
} elseif ($land_area == 5) {
$criteria->addCondition('land_area>=12000 and land_area<20000');
} elseif ($land_area == 6) {
$criteria->addCondition('land_area>=20000 and land_area<43560');
} elseif ($land_area == 7) {
$criteria->addCondition('land_area>=43560');
}
}
if (!empty($bedroom_num)) {
if ($bedroom_num <= 5) {
$criteria->addCondition('br>' . $bedroom_num);
} else {
$criteria->addCondition('br>=' . $bedroom_num);
}
}
if (!empty($construction_year)) {
if (!empty(self::$searchData['cd9'][$construction_year]['min'])) {
$criteria->addCondition('yr_built>' . self::$searchData['cd9'][$construction_year]['min']);
}
if (!empty(self::$searchData['cd9'][$construction_year]['max'])) {
$criteria->addCondition('yr_built<=' . self::$searchData['cd9'][$construction_year]['max']);
}
}
if (!empty($bath_tot)) {
$criteria->addCondition('bath_tot>"' . $bath_tot . '"');
}
if (!empty($style)) {
if ($style == "1") {
$criteria->addCondition('style="Bungalow" or style="Bungalow-Raised" or style="Raised-Bungalow"');
} elseif ($style == "2") {
$criteria->addCondition('style="1 1/2 Storey"');
} elseif ($style == "3") {
$criteria->addCondition('style="2-Storey"');
} elseif ($style == "4") {
$criteria->addCondition('style="2 1/2 Storey"');
} elseif ($style == "5") {
$criteria->addCondition('style="3-Storey"');
}
}
if (!empty($comp_pts)) {
if ($comp_pts == "1") {
$criteria->addCondition('comp_pts="S"');
} elseif ($comp_pts == "2") {
$criteria->addCondition('comp_pts="N"');
} elseif ($comp_pts == "3") {
$criteria->addCondition('comp_pts="E"');
} elseif ($comp_pts == "4") {
$criteria->addCondition('comp_pts="W"');
}
}
if (!empty($gar_spaces)) {
$criteria->addCondition('gar_spaces >"' . $gar_spaces . '"');
}
if (!empty($bsmt1_out)) {
$criteria->addCondition('bsmt1_out="' . $bsmt1_out . '"');
}
if (!empty($pool)) {
if ($pool == "1") {
//$criteria->addCondition('pool="Abv" or pool="Grnd" or pool="Indoor" or pool="Inground"');
$criteria->addCondition('pool like "%pool%"');
} elseif ($pool == "2") {
$criteria->addCondition('pool="" or pool="None"');
}
}
#$criteria->order = 'id DESC';
$criteria->order = 'city_id ASC,lp_dol DESC';
if (!empty($time_sort)) {
$criteria->order = 'pix_updt ' . $time_sort . ', city_id ASC,lp_dol DESC';
}
if (!empty($price_sort)) {
$criteria->order = 'lp_dol ' . $price_sort;
}
$criteria->with = array('mname', 'propertyType', 'city');
$count = House::model()->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = 10;
$pager->applyLimit($criteria);
$house_list = House::model()->findAll($criteria);
//generate cookie list for previous and next page
foreach ($house_list as $val) {
//generate ml_num for cookielist
$ml_list = $ml_list . "," . $val->ml_num;
}
$listcookie = "fzd_houselist";
if (!isset($_COOKIE[$listcookie])) {
setcookie($listcookie, "", time() - 3600);
}
setcookie($listcookie, $ml_list, time() + 86400 * 30, "/");
//end of adding cookie
$collection_list = array();
if ($this->_account['userId']) {
$collect_model = Collect::model()->find('user_id=:user_id', array(':user_id' => $this->_account['userId']));
if (!empty($collect_model)) {
$collection_list = explode(',', $collect_model->collection);
}
}
$data = array('cd1' => $city_id, 'cd2' => $district_id, 'cd3' => $investType_id, 'cd4' => $propertyType_id, 'cd5' => $total_price, 'cd6' => $house_area, 'cd7' => $land_area, 'cd8' => $bedroom_num, 'cd9' => $construction_year, 'cd10' => $prop_featx_out, 'cd11' => $prop_featx_out2, 'cd12' => $prop_featx_out3, 'cd12_2' => $prop_featx_out_2, 'cd12_3' => $prop_featx_out_3, 'cd12_4' => $prop_featx_out_4, 'cd12_5' => $prop_featx_out_5, 'cd13' => $bath_tot, 'cd14' => $style, 'cd15' => $comp_pts, 'cd16' => $gar_spaces, 'cd17' => $bsmt1_out, 'cd18' => $pool, 'time_sort' => $time_sort, 'price_sort' => $price_sort, 'diy_price' => json_encode($diy_price), 'city_list' => $city_list, 'district_list' => $district_list, 'investType_list' => $investType_list, 'propertyType_list' => $propertyType_list, 'count' => $count, 'house_list' => $house_list, 'collection_list' => $collection_list, "pages" => $pager, "type" => $type);
$this->render('index', $data);
}
/**
* 取用户组列表
* @param $type
*/
protected function _groupList($type = 'user')
{
switch ($type) {
case 'user':
return AdminGroup::model()->findAll();
break;
case 'subject':
return Subject::model()->findAll();
break;
case 'city':
return City::model()->findAll();
break;
case 'district':
return District::model()->findAll();
break;
case 'investType':
return InvestType::model()->findAll();
break;
case 'propertyType':
return PropertyType::model()->findAll();
break;
case 'house':
return House::model()->findAll();
break;
case 'match':
return Match::model()->findAll();
break;
}
}
public function actionDynamicdistrict()
{
//print_r($_POST);exit;
$data = District::model()->findAll('statecode=:statecode', array(':statecode' => $_POST['Establishments']['statecode']));
$data = CHtml::listData($data, 'distcode', 'distname');
foreach ($data as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
public function actionDynamicdistrict3()
{
//print_r($_POST);exit;
$data = District::model()->findAll('states_id=:id', array(':id' => $_POST['state']));
$data = CHtml::listData($data, 'id', 'name');
echo CHtml::tag('option', array('value' => ''), 'Select District', true);
foreach ($data as $value => $name) {
echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true);
}
}
<?php
$cr=new CDbCriteria;
$cr->condition = 'city_id=:city_id';
$cr->params = array(':city_id'=>$this->city->id);
$cr->order = 'district_name';
$districts = District::model()->findAll($cr);
if($districts)
{
echo '<div class="row">
<div class="col-lg-8 col-lg-offset-1 col-md-8 col-md-offset-1 col-sm-8 col-sm-offset-1 col-xs-12">
<h2 class="org_title" style="padding-left:26px;margin-bottom:26px;">'.$model->title .' по микрорайонам '.$this->city->rodpad.'</h2>
<div class="card">
<div class="card-body card-padding">
<div class="row">';
foreach ($districts as $district)
{
if(mb_strpos($district->district_name, 'микрорайон', 0, 'UTF-8') !== false)
{
$query = new Orgs(null);
$query->active()
->with(array(
'images',
'city',
));
$query->applyCategoriesWithSub($model);
$cr=new CDbCriteria;
$cr->distinct = true; // предотвращает повтор объявлений на странице
if($this->city->id)
/**
* 房源列表
*/
public function actionIndex()
{
Yii::app()->clientScript->registerCssFile(Yii::app()->theme->baseUrl . '/css/house.css');
$city_id = Yii::app()->request->getQuery('cd1', 0);
$district_id = Yii::app()->request->getQuery('cd2', 0);
$investType_id = Yii::app()->request->getQuery('cd3', 0);
$propertyType_id = Yii::app()->request->getQuery('cd4', 0);
$total_price = Yii::app()->request->getQuery('cd5', 0);
$house_area = Yii::app()->request->getQuery('cd6', 0);
$land_area = Yii::app()->request->getQuery('cd7', 0);
$bedroom_num = Yii::app()->request->getQuery('cd8', 0);
$construction_year = Yii::app()->request->getQuery('cd9', 0);
$prop_featx_out = Yii::app()->request->getQuery('cd10', 0);
$prop_featx_out2 = Yii::app()->request->getQuery('cd11', 0);
$prop_featx_out3 = Yii::app()->request->getQuery('cd12', 0);
$bath_tot = Yii::app()->request->getQuery('cd13', 0);
$style = Yii::app()->request->getQuery('cd14', 0);
$comp_pts = Yii::app()->request->getQuery('cd15', 0);
$gar_spaces = Yii::app()->request->getQuery('cd16', 0);
$bsmt1_out = Yii::app()->request->getQuery('cd17', 0);
$pool = Yii::app()->request->getQuery('cd18', 0);
$time_sort = Yii::app()->request->getQuery('time_sort', 'DESC');
$price_sort = Yii::app()->request->getQuery('price_sort');
$diy_word = null;
$city_list = City::model()->findAll(array('order' => 'id ASC'));
if (!empty($city_id)) {
$district_list = District::model()->findAll('city_id=:city_id', array(':city_id' => $city_id));
} else {
$district_list = District::model()->findAll();
}
$investType_list = InvestType::model()->findAll();
$propertyType_list = PropertyType::model()->findAll();
//按搜索条件查询房源信息
$criteria = new CDbCriteria();
//省份
if (!empty($city_id)) {
$criteria->addCondition('area!=""');
}
//地区
if (!empty($district_id)) {
if ($district_id == 1) {
$criteria->addCondition('area="Toronto"');
} elseif ($district_id == 2) {
$criteria->addCondition('area="Durham"');
} elseif ($district_id == 3) {
$criteria->addCondition('area="Peel"');
} elseif ($district_id == 4) {
$criteria->addCondition('area="Halton"');
} elseif ($district_id == 5) {
$criteria->addCondition('area="York"');
}
}
//挂牌时间
if (!empty($investType_id)) {
if ($investType_id == 1) {
//查询一周数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(pix_updt)');
} elseif ($investType_id == 2) {
//查询一月数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(pix_updt)');
} elseif ($investType_id == 3) {
//查询三月数据
$criteria->addCondition('DATE_SUB(CURDATE(), INTERVAL 90 DAY) <= date(pix_updt)');
}
}
if (!empty($prop_featx_out)) {
if ($prop_featx_out == 1) {
$criteria->addCondition('prop_feat1_out like "%Waterfront%" or prop_feat2_out like "%Waterfront%" or prop_feat3_out like "%Waterfront%" or prop_feat4_out like "%Waterfront%" or prop_feat5_out like "%Waterfront%" or prop_feat6_out like "%Waterfront%" ');
} elseif ($prop_featx_out == 2) {
$criteria->addCondition('prop_feat1_out like "%Pond%" or prop_feat2_out like "%Pond%" or prop_feat3_out like "%Pond%" or prop_feat4_out like "%Pond%" or prop_feat5_out like "%Pond%" or prop_feat6_out like "%Pond%" ');
} elseif ($prop_featx_out == 3) {
$criteria->addCondition('prop_feat1_out like "%Stream%" or prop_feat2_out like "%Stream%" or prop_feat3_out like "%Stream%" or prop_feat4_out like "%Stream%" or prop_feat5_out like "%Stream%" or prop_feat6_out like "%Stream%" ');
} elseif ($prop_featx_out == 4) {
$criteria->addCondition('prop_feat1_out like "%River%" or prop_feat2_out like "%River%" or prop_feat3_out like "%River%" or prop_feat4_out like "%River%" or prop_feat5_out like "%River%" or prop_feat6_out like "%River%" ');
} elseif ($prop_featx_out == 5) {
$criteria->addCondition('prop_feat1_out like "%Lake%" or prop_feat2_out like "%Lake%" or prop_feat3_out like "%Lake%" or prop_feat4_out like "%Lake%" or prop_feat5_out like "%Lake%" or prop_feat6_out like "%Lake%" ');
} elseif ($prop_featx_out == 6) {
$criteria->addCondition('prop_feat1_out like "%Marina%" or prop_feat2_out like "%Marina%" or prop_feat3_out like "%Marina%" or prop_feat4_out like "%Marina%" or prop_feat5_out like "%Marina%" or prop_feat6_out like "%Marina%" ');
}
}
if (!empty($prop_featx_out2)) {
if ($prop_featx_out2 == 1) {
$criteria->addCondition('prop_feat1_out like "%Treed%" or prop_feat2_out like "%Treed%" or prop_feat3_out like "%Treed%" or prop_feat4_out like "%Treed%" or prop_feat5_out like "%Treed%" or prop_feat6_out like "%Treed%" ');
} elseif ($prop_featx_out2 == 2) {
$criteria->addCondition('prop_feat1_out like "%Wooded%" or prop_feat2_out like "%Wooded%" or prop_feat3_out like "%Wooded%" or prop_feat4_out like "%Wooded%" or prop_feat5_out like "%Wooded%" or prop_feat6_out like "%Wooded%" ');
} elseif ($prop_featx_out2 == 3) {
$criteria->addCondition('prop_feat1_out like "%Grnbelt%" or prop_feat2_out like "%Grnbelt%" or prop_feat3_out like "%Grnbelt%" or prop_feat4_out like "%Grnbelt%" or prop_feat5_out like "%Grnbelt%" or prop_feat6_out like "%Grnbelt%" ');
} elseif ($prop_featx_out2 == 4) {
$criteria->addCondition('prop_feat1_out like "%Conserv%" or prop_feat2_out like "%Conserv%" or prop_feat3_out like "%Conserv%" or prop_feat4_out like "%Conserv%" or prop_feat5_out like "%Conserv%" or prop_feat6_out like "%Conserv%" ');
} elseif ($prop_featx_out2 == 5) {
$criteria->addCondition('prop_feat1_out like "%Ravine%" or prop_feat2_out like "%Ravine%" or prop_feat3_out like "%Ravine%" or prop_feat4_out like "%Ravine%" or prop_feat5_out like "%Ravine%" or prop_feat6_out like "%Ravine%" ');
}
}
//
if (!empty($prop_featx_out3)) {
if ($prop_featx_out3 == 1) {
$criteria->addCondition('prop_feat1_out like "%School%" or prop_feat2_out like "%School%" or prop_feat3_out like "%School%" or prop_feat4_out like "%School%" or prop_feat5_out like "%School%" or prop_feat6_out like "%School%" ');
} elseif ($prop_featx_out3 == 2) {
$criteria->addCondition('prop_feat1_out like "%Hospital%" or prop_feat2_out like "%Hospital%" or prop_feat3_out like "%Hospital%" or prop_feat4_out like "%Hospital%" or prop_feat5_out like "%Hospital%" or prop_feat6_out like "%Hospital%" ');
} elseif ($prop_featx_out3 == 3) {
$criteria->addCondition('prop_feat1_out like "%Public Transit%" or prop_feat2_out like "%Public Transit%" or prop_feat3_out like "%Public Transit%" or prop_feat4_out like "%Public Transit%" or prop_feat5_out like "%Public Transit%" or prop_feat6_out like "%Public Transit%" ');
} elseif ($prop_featx_out3 == 4) {
$criteria->addCondition('prop_feat1_out like "%Park%" or prop_feat2_out like "%Park%" or prop_feat3_out like "%Park%" or prop_feat4_out like "%Park%" or prop_feat5_out like "%Park%" or prop_feat6_out like "%Park%" ');
} elseif ($prop_featx_out3 == 5) {
$criteria->addCondition('prop_feat1_out like "%Golf%" or prop_feat2_out like "%Golf%" or prop_feat3_out like "%Golf%" or prop_feat4_out like "%Golf%" or prop_feat5_out like "%Golf%" or prop_feat6_out like "%Golf%" ');
} elseif ($prop_featx_out3 == 6) {
$criteria->addCondition('prop_feat1_out like "%Library%" or prop_feat2_out like "%Library%" or prop_feat3_out like "%Library%" or prop_feat4_out like "%Library%" or prop_feat5_out like "%Library%" or prop_feat6_out like "%Library%" ');
}
}
//物业类型
if (!empty($propertyType_id)) {
$criteria->addCondition('propertyType_id="' . $propertyType_id . '"');
//if($propertyType_id==1){
//$criteria->addCondition('type_own1_out="Detached"');
//}
//elseif($propertyType_id==2){
//$criteria->addCondition('type_own1_out="Townhouse" or type_own1_out="Att∕Row∕Twnhouse" or type_own1_out="Triplex" or type_own1_out="Fourplex" or type_own1_out="Multiplex"');
//}
//elseif($propertyType_id==3){
//$criteria->addCondition('lp_dol>3000000');
//}
//elseif($propertyType_id==4){
//$criteria->addCondition('type_own1_out="Semi-Detached" or type_own1_out="Link" or type_own1_out="Duplex"');
//}
//elseif($propertyType_id==5){
//$criteria->addCondition('type_own1_out="Cottage" or type_own1_out="Rural Resid"');
//}
//elseif($propertyType_id==6){
//$criteria->addCondition('type_own1_out="Farm"');
//}
//elseif($propertyType_id==7){
//$criteria->addCondition('type_own1_out="Vacant Land"');
//}
//elseif($propertyType_id==8){
//$criteria->addCondition('type_own1_out="Mobile/Trailer" or type_own1_out="Det W/Com Elements" or type_own1_out="Store W/Apt/offc"');
//}
}
//挂牌价格
if (!empty($total_price)) {
if ($total_price == 1) {
$criteria->addCondition('lp_dol<300000');
} elseif ($total_price == 2) {
$criteria->addCondition('lp_dol>=300000 and lp_dol<500000');
} elseif ($total_price == 3) {
$criteria->addCondition('lp_dol>500000 and lp_dol<1000000');
} elseif ($total_price == 4) {
$criteria->addCondition('lp_dol>1000000 and lp_dol<1500000');
} elseif ($total_price == 5) {
$criteria->addCondition('lp_dol>1500000 and lp_dol<3000000');
} elseif ($total_price == 6) {
$criteria->addCondition('lp_dol>3000000');
}
}
//房屋面积
if (!empty($house_area)) {
if ($house_area == 1) {
$criteria->addCondition('sqft<700');
} elseif ($house_area == 2) {
$criteria->addCondition('sqft>700 and sqft<1100');
} elseif ($house_area == 3) {
$criteria->addCondition('sqft>1100 and sqft<1500');
} elseif ($house_area == 4) {
$criteria->addCondition('sqft>1500 and sqft<2000');
} elseif ($house_area == 5) {
$criteria->addCondition('sqft>2000 and sqft<2500');
} elseif ($house_area == 6) {
$criteria->addCondition('sqft>2500 and sqft<3000');
} elseif ($house_area == 7) {
$criteria->addCondition('sqft>3000 and sqft<3500');
} elseif ($house_area == 8) {
$criteria->addCondition('sqft>3500 and sqft<4000');
} elseif ($house_area == 9) {
$criteria->addCondition('sqft>4000');
}
}
//土地面积
if (!empty($land_area)) {
if ($land_area == 1) {
$criteria->addCondition('depth*front_ft<1000');
} elseif ($land_area == 2) {
$criteria->addCondition('depth*front_ft>=1000 and depth*front_ft<2000');
} elseif ($land_area == 3) {
$criteria->addCondition('depth*front_ft>=2000 and depth*front_ft<3000');
} elseif ($land_area == 4) {
$criteria->addCondition('depth*front_ft>=3000 and depth*front_ft<4000');
} elseif ($land_area == 5) {
$criteria->addCondition('depth*front_ft>=4000 and depth*front_ft<5000');
} elseif ($land_area == 6) {
$criteria->addCondition('depth*front_ft>=5000 and depth*front_ft<6000');
} elseif ($land_area == 7) {
$criteria->addCondition('depth*front_ft>6000');
}
}
if (!empty($bedroom_num)) {
if ($bedroom_num <= 5) {
$criteria->addCondition('br=' . $bedroom_num);
} else {
$criteria->addCondition('br>=' . $bedroom_num);
}
}
if (!empty($construction_year)) {
if (!empty(self::$searchData['cd9'][$construction_year]['min'])) {
$criteria->addCondition('yr_built>' . self::$searchData['cd9'][$construction_year]['min']);
}
if (!empty(self::$searchData['cd9'][$construction_year]['max'])) {
$criteria->addCondition('yr_built<=' . self::$searchData['cd9'][$construction_year]['max']);
}
}
if (!empty($bath_tot)) {
$criteria->addCondition('bath_tot>"' . $bath_tot . '"');
}
if (!empty($style)) {
if ($style == "1") {
$criteria->addCondition('style="Bungalow" or style="Bungalow-Raised" or style="Raised-Bungalow"');
} elseif ($style == "2") {
$criteria->addCondition('style="1 1/2 Storey"');
} elseif ($style == "3") {
$criteria->addCondition('style="2-Storey"');
} elseif ($style == "4") {
$criteria->addCondition('style="2 1/2 Storey"');
} elseif ($style == "5") {
$criteria->addCondition('style="3-Storey"');
}
}
if (!empty($comp_pts)) {
if ($comp_pts == "1") {
$criteria->addCondition('comp_pts="S"');
} elseif ($comp_pts == "2") {
$criteria->addCondition('comp_pts="N"');
} elseif ($comp_pts == "3") {
$criteria->addCondition('comp_pts="E"');
} elseif ($comp_pts == "4") {
$criteria->addCondition('comp_pts="W"');
}
}
if (!empty($gar_spaces)) {
$criteria->addCondition('gar_spaces >"' . $gar_spaces . '"');
}
if (!empty($bsmt1_out)) {
$criteria->addCondition('bsmt1_out="' . $bsmt1_out . '"');
}
if (!empty($pool)) {
if ($pool == "1") {
$criteria->addCondition('pool="Abv" or pool="Grnd" or pool="Indoor" or pool="Inground"');
} elseif ($pool == "2") {
$criteria->addCondition('pool="" or pool="None"');
}
}
$criteria->order = 'id DESC';
if (!empty($time_sort)) {
$criteria->order = 'pix_updt ' . $time_sort;
}
if (!empty($price_sort)) {
$criteria->order = 'lp_dol ' . $price_sort;
}
$criteria->with = array('mname', 'propertyType');
$count = House::model()->count($criteria);
$pager = new CPagination($count);
$pager->pageSize = 10;
$pager->applyLimit($criteria);
$house_list = House::model()->findAll($criteria);
$collection_list = array();
if ($this->_account['userId']) {
$collect_model = Collect::model()->find('user_id=:user_id', array(':user_id' => $this->_account['userId']));
if (!empty($collect_model)) {
$collection_list = explode(',', $collect_model->collection);
}
}
$data = array('cd1' => $city_id, 'cd2' => $district_id, 'cd3' => $investType_id, 'cd4' => $propertyType_id, 'cd5' => $total_price, 'cd6' => $house_area, 'cd7' => $land_area, 'cd8' => $bedroom_num, 'cd9' => $construction_year, 'cd10' => $prop_featx_out, 'cd11' => $prop_featx_out2, 'cd12' => $prop_featx_out3, 'cd13' => $bath_tot, 'cd14' => $style, 'cd15' => $comp_pts, 'cd16' => $gar_spaces, 'cd17' => $bsmt1_out, 'cd18' => $pool, 'time_sort' => $time_sort, 'price_sort' => $price_sort, 'diy_price' => json_encode($diy_price), 'city_list' => $city_list, 'district_list' => $district_list, 'investType_list' => $investType_list, 'propertyType_list' => $propertyType_list, 'count' => $count, 'house_list' => $house_list, 'collection_list' => $collection_list, "pages" => $pager);
$this->render('index', $data);
}
public function getRows($pq)
{
$rows = $pq->find("table[bgcolor='#ffccff'] tr[bgcolor='#ccffff']");
$n = count($rows);
echo 'Jumlah propinsi: ' . $n . " \n";
$count = 0;
foreach ($rows as $value) {
$count++;
$row = pq($value);
$kolom_provinsi = $row->find('td:eq(1) > a');
$nama_provinsi = $kolom_provinsi->text();
$link_provinsi = str_replace(' ', '%20', self::NomorNetKodePosBaseUrl . $kolom_provinsi->attr('href')) . '&perhal=1000';
echo sprintf("Memproses propinsi %d dari %d\n", $count, $n);
echo sprintf("Propinsi: %s Link: %s\n", $nama_provinsi, $link_provinsi);
$province = Province::model()->findByAttributes(array('name' => $nama_provinsi));
if (!$province instanceof Province) {
$province = new Province();
$province->name = $nama_provinsi;
if (!$province->save()) {
throw new CException('Cannot save province');
}
}
$countdistrict = 0;
$pqDist = phpQuery::newDocumentHtml($this->getContents($link_provinsi));
$rowsDist = $pqDist->find("table[bgcolor='#ffccff'] tr[bgcolor='#ccffff']");
$nDist = count($rowsDist);
$countDist = 0;
foreach ($rowsDist as $valueDist) {
$countDist++;
$rowDist = pq($valueDist);
switch ($rowDist->find('td:eq(2)')->text()) {
case 'Kota':
$tipeDist = 'kota';
break;
default:
case 'Kab.':
$tipeDist = 'kabupaten';
break;
}
$kolomDist = $rowDist->find('td:eq(3) > a');
$namaDist = $kolomDist->text();
$linkDist = str_replace(' ', '%20', self::NomorNetKodePosBaseUrl . $kolomDist->attr('href')) . '&perhal=1000';
echo sprintf("Memproses distrik " . $province->name . " %d dari %d\n", $countDist, $nDist);
echo sprintf("Distrik: %s Link: %s\n", $namaDist, $linkDist);
$distrik = District::model()->findByAttributes(array('name' => $namaDist, 'province_id' => $province->id, 'type' => $tipeDist));
if (!$distrik instanceof District) {
$distrik = new District();
$distrik->name = $namaDist;
$distrik->type = $tipeDist;
$distrik->province_id = $province->id;
if (!$distrik->save()) {
throw new CException('Cannot save district');
}
}
$pqZone = phpQuery::newDocumentHtml($this->getContents($linkDist));
$rowsZone = $pqZone->find("table[bgcolor='#ffccff'] tr[bgcolor='#ccffff']");
$nZone = count($rowsZone);
$countZone = 0;
foreach ($rowsZone as $valueZone) {
$countZone++;
$rowZone = pq($valueZone);
$kolomZone = $rowZone->find('td:eq(4) > a');
$namaZone = $kolomZone->text();
$linkZone = str_replace(' ', '%20', self::NomorNetKodePosBaseUrl . $kolomZone->attr('href')) . '&perhal=1000';
echo sprintf("Memproses zone %d dari %d\n", $countZone, $nZone);
echo sprintf("zone: %s Link: %s\n", $namaZone, $linkZone);
$new_zone = false;
$zone = Zone::model()->findByAttributes(array('name' => $namaZone, 'district_id' => $distrik->id));
if (!$zone instanceof Zone) {
$zone = new Zone();
$zone->name = $namaZone;
$zone->active = 1;
$zone->district_id = $distrik->id;
if (!$zone->save()) {
throw new CException('Cannot save Zone');
}
$new_zone = true;
}
echo 'sukses saving zone' . "\n";
$countArea = 0;
$pqArea = phpQuery::newDocumentHtml($this->getContents($linkZone));
$rowsArea = $pqArea->find("table[bgcolor='#ffccff'] tr[bgcolor='#ccffff']");
$nArea = count($rowsArea);
// Let's speed up things a bit
$trans = Yii::app()->db->beginTransaction();
foreach ($rowsArea as $valueArea) {
$countArea++;
$rowArea = pq($valueArea);
$kolomArea = $rowArea->find('td:eq(2) > a');
$kolomKodePos = $rowArea->find('td:eq(1)');
$namaArea = $kolomArea->text();
$kodePos = $kolomKodePos->text();
$linkKodePos = str_replace(' ', '%20', self::NomorNetKodePosBaseUrl . $kolomArea->attr('href')) . '&perhal=1000';
$area = $new_zone ? null : Area::model()->findByAttributes(array('name' => $namaArea, 'zone_id' => $zone->id));
if (!$area instanceof Area) {
$area = new Area();
$area->name = $namaArea;
$area->postcode = $kodePos;
$area->zone_id = $zone->id;
if (!$area->save()) {
throw new CException('Cannot save area');
}
}
echo 'Sukses Saving Code Post' . "/n kode pos adalah " . $area->postcode . "\n";
}
$trans->commit();
}
}
}
}
?>
<div id="select_state" style="display:none;">
<label>Select State</label>
<?php
echo $form->dropDownList($model, 'state_id', CHtml::listData(States::model()->findAll(array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/dynamicdistrict3'), 'update' => '#User_district_id', 'data' => array('role' => 'js:document.getElementById("User_role").value', 'state' => 'js:this.value')), 'empty' => 'Select State'), array('span' => 5));
?>
</div>
<div id="select_district" style=";display:none;" >
<label>Select District</label>
<?php
//echo $form->dropDownList($model,'district_id',CHtml::listData(District::model()->findAllByAttributes(array('states_id'=>$model->state_id),array('order' => 'name ASC')), 'id', 'name'),array('empty'=>'---Select State first---','span'=>5));
?>
<?php
echo $form->dropDownList($model, 'district_id', CHtml::listData(District::model()->findAllByAttributes(array('states_id' => $model->state_id), array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/masters'), 'update' => '#User_master_id', 'data' => array('role' => 'js:document.getElementById("User_role").value', 'district' => 'js:this.value')), 'empty' => 'Select District'), array('span' => 5));
?>
</div>
<?php
echo $form->dropDownListControlGroup($model, 'master_id', array(), array('empty' => '---Select Role first---', 'span' => 5));
?>
<?php
echo $form->textFieldControlGroup($model, 'name', array('span' => 5, 'maxlength' => 45));
?>
<?php
echo $form->textFieldControlGroup($model, 'email', array('span' => 5, 'maxlength' => 45));
?>
<div style="float:left;width:200px;" >
<?php
echo $form->labelEx($model, 'state_id');
?>
<?php
echo $form->dropDownList($model, 'state_id', CHtml::listData(States::model()->findAllByPk(array(19, 7, 32), array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/dynamicdistrict2'), 'update' => '#Court_district_id'), 'empty' => 'Select State'), array('span' => 5));
?>
</div>
<div style="width:200px;" >
<?php
echo $form->labelEx($model, 'district_id');
?>
<?php
echo $form->dropDownList($model, 'district_id', CHtml::listData(District::model()->findAllByAttributes(array('states_id' => $model->state_id), array('order' => 'name ASC')), 'id', 'name'), array('span' => 13));
?>
</div>
<?php
echo $form->dropDownListControlGroup($model, 'type', array('District court' => 'District court', 'Taluka court' => 'Taluka court'), array('span' => 5));
?>
<?php
echo $form->textFieldControlGroup($model, 'name', array('span' => 5, 'maxlength' => 145));
?>
<div class="form-actions">
<?php
echo TbHtml::submitButton($model->isNewRecord ? 'Create' : 'Save', array('color' => TbHtml::BUTTON_COLOR_PRIMARY, 'size' => TbHtml::BUTTON_SIZE_LARGE));
?>
</div>
<?php
$this->breadcrumbs = array(Yii::t('app', 'Business Directory') => array('/directory/business'), Yii::t('app', 'Manage'));
if (!isset($this->menu) || $this->menu === array()) {
$this->menu = array(array('label' => Yii::t('app', 'List All'), 'url' => array('/directory/business')), array('label' => Yii::t('app', 'Add New'), 'url' => array('create')), array('label' => Yii::t('app', 'Manage All')), array('label' => Yii::t('app', 'All Categories'), 'url' => array('/directory/categories')), array('label' => Yii::t('app', 'Create New Category'), 'url' => array('/directory/categories/create')), array('label' => Yii::t('app', 'Manage All Categories'), 'url' => array('/directory/categories/manage')));
}
?>
<h1> <?php
echo Yii::t('app', 'Manage');
?>
<?php
echo Yii::t('app', 'Business Directory');
?>
</h1>
<?php
if (count($model->search()->data)) {
$this->widget('zii.widgets.grid.CGridView', array('id' => 'business-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array('page.title', 'phone', 'email', 'website', array('name' => 'district_id', 'value' => 'isset($data->district->name)?$data->district->name:"N/A"', 'filter' => CHtml::listData(District::model()->findAll(), 'id', 'name')), array('class' => 'CButtonColumn'))));
} else {
echo Yii::t('app', 'No results found!');
}
<?php
$this->breadcrumbs = array('Youtubes' => array('admin'), 'Manage');
$this->menu = array(array('label' => 'Manage', 'url' => array('admin'), 'active' => true, 'icon' => 'icon-home'), array('label' => 'New', 'url' => array('create'), 'active' => true, 'icon' => 'icon-file'), array('label' => '', 'class' => 'search-button', 'url' => '#', 'active' => true, 'icon' => 'icon-search search-button'));
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('youtube-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
Yii::app()->clientScript->registerScript('re-install-date-picker', "\nfunction reinstallDatePicker(id, data) {\n \$('#datepicker1').datepicker();\n \$('#datepicker2').datepicker();\n}\n");
?>
<div class="search-form" style="display:none">
<?php
$this->renderPartial('_search', array('model' => $model));
?>
</div><!-- search-form -->
<?php
$this->widget('bootstrap.widgets.TbGridView', array('id' => 'youtube-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array(array('name' => 'id', 'type' => 'raw', 'value' => '$data->id', 'htmlOptions' => array('style' => "text-align:left;width:80px;", 'title' => 'ID')), 'youtube_id', array('name' => 'district', 'type' => 'raw', 'value' => 'District::getDistrict($data->district)', 'filter' => CHtml::activeDropDownList($model, 'district', CHtml::listData(District::model()->findAll(array('condition' => '', "order" => "title")), 'id', 'title'), array('empty' => 'All')), 'htmlOptions' => array('style' => "text-align:left;width:150px;", 'title' => 'District')), array('name' => 'thana', 'type' => 'raw', 'value' => 'Thana::getThana($data->thana)', 'filter' => CHtml::activeDropDownList($model, 'thana', CHtml::listData(Thana::model()->findAll(array('condition' => '', "order" => "title")), 'id', 'title'), array('empty' => 'All')), 'htmlOptions' => array('style' => "text-align:left;width:150px;", 'title' => 'Thana')), array('name' => 'published', 'header' => "Status", 'value' => '$data->published?Yii::t(\'app\',\'Active\'):Yii::t(\'app\', \'Inactive\')', 'filter' => array('' => Yii::t('app', 'All'), '0' => Yii::t('app', 'Inactive'), '1' => Yii::t('app', 'Active')), 'htmlOptions' => array('style' => "text-align:center;")), array('name' => 'featured', 'value' => '$data->featured?Yii::t(\'app\',\'Yes\'):Yii::t(\'app\', \'No\')', 'filter' => array('' => Yii::t('app', 'All'), '0' => Yii::t('app', 'No'), '1' => Yii::t('app', 'Yes')), 'htmlOptions' => array('style' => "text-align:center;")), array('name' => 'created_on', 'value' => 'date("F j, Y, g:i A", strtotime($data->created_on))', 'filter' => $this->widget('zii.widgets.jui.CJuiDatePicker', array('model' => $model, 'attribute' => 'created_on', 'htmlOptions' => array('id' => 'datepicker2', 'size' => '10'), 'i18nScriptFile' => 'jquery.ui.datepicker-en.js', 'defaultOptions' => array('showOn' => 'focus', 'dateFormat' => 'yy-mm-dd', 'showOtherMonths' => true, 'selectOtherMonths' => true, 'changeMonth' => true, 'changeYear' => true, 'showButtonPanel' => false)), true), 'htmlOptions' => array('style' => "text-align:center;")), array('class' => 'bootstrap.widgets.TbButtonColumn'))));
/**
* @return string the District text display for the current account
*/
public function getDistrictText()
{
$accountTypeRecord = District::model()->findByAttributes(array('id' => $this->district_id));
return $accountTypeRecord->name;
}
