/** * Displays a particular model. * @param integer $id the ID of the model to be displayed */ public function actionView($id) { $criteria = new CDbCriteria(); $criteria->condition = 'zone_id=' . $id; $area = new CActiveDataProvider(Area::model(), array('criteria' => $criteria)); $this->render('view', array('model' => $this->loadModel($id), 'area' => $area)); }
public function actionGet_route() { $criteria = new CDbCriteria(); $criteria->limit = 8; $area = Area::model()->findAll($criteria); $html = '<ul class="local_trip_pro" id="local_trip_content_list" data-blockid="recommend_localjoin">'; for ($j = 0; $j < count($area); $j++) { if ($j) { $html .= '<li class="local_trip_pro_li wq_clearfix hide" data-content="lj' . $j . '" style="display:none;">'; } else { $html .= '<li class="local_trip_pro_li wq_clearfix" data-content="lj' . $j . '">'; } $criteria1 = new CDbCriteria(); $criteria1->condition = "(style & 4) !=0"; $criteria1->addCondition('area ="' . $area[$j]->name . '"', 'AND'); $criteria1->limit = 3; $route = Route::model()->findAll($criteria1); for ($i = 0; $i < count($route); $i++) { if ($i) { $html .= '<a class="local_trip_right img_slide_animte_wrapper" href="'; } else { $html .= '<a class="local_trip_left_l img_slide_animte_wrapper" href="'; } if ($i) { $html .= '#" target="_blank"> <img class="local_trip_img_s img_slide_animte first_page" src="' . $route[$i]->source . '" data-original="' . $route[$i]->source . '" style="display: block;"> <span class="local_trip_mask_s"></span> <span class="local_trip_txt_s" title="' . $route[$i]->name . '">' . $route[$i]->name . '</span>' . '<span class="local_trip_price_s font_size12"><span class="font_size16">' . $route[$i]->price . '</span>元/人起</span></a>'; } else { $html .= '#" target="_blank"> <img class="local_trip_img_l img_slide_animte first_page" alt=" ' . $route[$i]->name . '" src="' . $route[$i]->source . '" data-original="' . $route[$i]->source . '" style="display: block;"> <span class="local_trip_mask_l"></span> <span class="local_trip_bl"></span><span class="local_trip_txt_l" title="' . $route[$i]->name . '">' . $route[$i]->name . '</span>' . '<span class="local_trip_price_l font_size14 font_color_orange"><span class="font_size28">' . $route[$i]->price . '</span>元/人起</span></a>'; } } $html .= '</li>'; } $html .= '</ul>'; echo $html; }
/** * 根据地区woeid获取雅虎天气 * 获取woeid http://sugg.us.search.yahoo.net/gossip-gl-location/?appid=weather&output=xml&command=地名(如香港) * 匹配规则:preg_match('/woeid=(\d+)\&lon=.*?\&lat=.*?\&s=.*?\&c=.*?\&country_woeid/si', $_return,$match); * 获取天气:https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.media.weather%20where%20woeid%20in(12523356%2C90717580%2C20069923)&format=json&env=http%3A%2F%2Fdatatables.org%2Falltables.env&callback= */ public function actionWeather() { ini_set('memory_limit', '256M'); ini_set('max_execution_time', '1800'); $areas = Area::model()->findAll(array('select' => 'woeid', 'condition' => 'woeid>0 AND theorder=3')); $woeids = array_keys(CHtml::listData($areas, 'woeid', '')); $woeidsStr = join(',', $woeids); $dir = Yii::app()->basePath . '/runtime/weather'; $totalDir = $dir . '/total.log'; zmf::createUploadDir($dir); $start = microtime(true); if ($woeidsStr != '') { $url = "https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.media.weather%20where%20woeid%20in({$woeidsStr})&format=json&env=http%3A%2F%2Fdatatables.org%2Falltables.env"; $json = zmf::curlget($url); file_put_contents($totalDir, $json); } $dataArr = CJSON::decode($json, true); $data = $dataArr['query']; if (!$data) { exit('Failed'); } $results = $data['results']['result']; $detailDir = $dir . '/detail/'; zmf::createUploadDir($detailDir); foreach ($results as $result) { if ($result['location']['woeid']) { $_dir = $detailDir . $result['location']['woeid'] . '.log'; file_put_contents($_dir, CJSON::encode($result)); } } echo microtime(true) - $start . '--<br/>'; }
public static function getList() { $model = Area::model(); $command = $model->getDbConnection()->CreateCommand(); $tableName = $model->tableName(); return $command->select()->from($tableName)->order('create_time DESC')->queryAll(); }
public function loadModel($id) { $model = Area::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public static function getPostCode($area) { if (is_numeric($area)) { return $area; } $area = Area::model()->find('name=:name', array(':name' => $area)); if (is_null($area)) { return null; } return $area->postcode; }
public function Dynamicdistrict() { if ($_GET["city"]) { $data = Area::model()->findAll("parent_id=:parent_id", array(":parent_id" => $_GET["city"])); $data = CHtml::listData($data, "id", "name"); echo CHtml::tag("option", array("value" => ''), '请选择地区', true); foreach ($data as $value => $name) { echo CHtml::tag("option", array("value" => $value), CHtml::encode($name), true); } } }
public static function saveProAddress(UserProudctAddress $userprodaddress, $user_id) { $_POST['UserProudctAddress']['province'] = 'xx'; $_POST['UserProudctAddress']['city'] = 'xx'; $_POST['UserProudctAddress']['area'] = 'xx'; $_POST['UserProudctAddress']['sysaddress'] = 'xx'; if (isset($_POST['province'])) { $_POST['UserProudctAddress']['province'] = $_POST['province']; $provincename = Province::model()->find("provinceID=:proid", array(":proid" => $_POST['UserProudctAddress']['province'])); if ($provincename) { $_POST['UserProudctAddress']['sysaddress'] = $provincename->province; } } if (isset($_POST['city'])) { $_POST['UserProudctAddress']['city'] = $_POST['city']; $cityname = City::model()->find("cityID=:cityid", array(":cityid" => $_POST['UserProudctAddress']['city'])); if ($cityname) { $_POST['UserProudctAddress']['sysaddress'] .= $cityname->city; } } if (isset($_POST['area'])) { $_POST['UserProudctAddress']['area'] = $_POST['area']; $areaname = Area::model()->find("areaID=:areaid", array(":areaid" => $_POST['UserProudctAddress']['area'])); if ($areaname) { $_POST['UserProudctAddress']['sysaddress'] .= $areaname->area; } } $_POST['UserProudctAddress']['user_id'] = $user_id; $userprodaddress->setAttributes($_POST['UserProudctAddress']); foreach ((array) $_POST['UserProudctAddress'] as $key => $value) { if (trim($value) == '') { $userprodaddress->addError($key, "字段不能为空"); break; } } if (!$userprodaddress->getErrors()) { $userprodaddress->setAttribute('addtime', time()); $userprodaddress->setAttribute('addip', Yii::app()->request->userHostAddress); if ($userprodaddress->validate()) { if ($userprodaddress->isNewRecord) { $result = $userprodaddress->save(); } else { $result = $userprodaddress->update(); } if (!$result) { $userprodaddress->addError("realname", "更新失败"); } } else { $userprodaddress->addError("realname", "更新失败"); } } return $userprodaddress; }
public static function getarea($params) { if ($params['p'] != 0) { $provinceinfo = Area::model()->findByPk($params['p']); if ($provinceinfo) { $address .= $provinceinfo['Name']; if ($params['c'] != 0) { $cityinfo = Area::model()->findByPk($params['c']); if ($cityinfo) { $address .= ' ' . $cityinfo['Name']; if ($params['a'] != 0) { $areainfo = Area::model()->findByPk($params['a']); $address .= ' ' . $areainfo['Name']; } } } } } else { $address = '全国'; } return $address; }
/** * 地区联动 */ public function actionUpdateDistricts() { $areastring = "area_"; $data = Yii::app()->cache->get($areastring . (int) $_POST['idCity']); if (!$data) { $dataArea = Area::model()->findAll('father=:idCity', array(':idCity' => (int) $_POST['idCity'])); if (!$dataArea) { $dataArea = City::model()->findAll('cityID=:idCity', array(':idCity' => (int) $_POST['idCity'])); if (!$dataArea) { $dataArea = Province::model()->findAll('provinceID=:idCity', array(':idCity' => (int) $_POST['idCity'])); $data = CHtml::listData($dataArea, 'provinceID', 'province'); } else { $data = CHtml::listData($dataArea, 'cityID', 'city'); } } else { $data = CHtml::listData($dataArea, 'areaID', 'area'); } Yii::app()->cache->set($areastring . (int) $_POST['idCity'], $data); } echo "<option value=''>选择区域</option>"; foreach ($data as $value => $name) { echo CHtml::tag('option', array('value' => $value), CHtml::encode($name), true); } }
public function run() { if ($area = Area::model()->findByAttributes(array('name' => $this->name))) { if ($blocks = $area->blocks) { if ($this->reverse) { $blocks = array_reverse($blocks); } foreach ($blocks as $block) { if ($block->view) { $view = $block->view; } else { $view = $this->defaultBlockView; } if ($this->getViewFile($view)) { $this->render($view, array('block' => $block)); } else { echo $view . " - несуществующий вид блока!"; } } } } else { echo "Область вывода " . $this->name . " не найдена."; } }
public function actionGetcity() { if (!Yii::app()->request->isAjaxRequest) { exit; } $city = Yii::app()->request->getParam("city"); $criteria = new CDbCriteria(); $criteria->select = "ID, Name"; if (empty($city)) { $criteria->addCondition("t.Grade = 1"); } else { $criteria->addCondition("t.ParentID = {$city}"); $criteria->addCondition("t.Grade = 2"); } $model = Area::model()->findAll($criteria); $data = array(); foreach ($model as $key => $val) { $data[$key] = array(); $data[$key]['ID'] = $val['ID']; $data[$key]['Name'] = $val['Name']; } echo json_encode($data); exit; }
<?php $state_data = Area::model()->findAll("grade=:grade", array(":grade" => 1)); $state = CHtml::listData($state_data, "id", "name"); $s_default = $model->isNewRecord ? '' : $model->state; echo CHtml::dropDownList('AddressResult[state]', $s_default, $state, array('empty' => '请选择省份', 'ajax' => array('type' => 'GET', 'url' => CController::createUrl('dynamiccities'), 'update' => '#AddressResult_city', 'data' => 'js:"AddressResult_state="+jQuery(this).val()'))); //empty since it will be filled by the other dropdown $c_default = $model->isNewRecord ? '' : $model->city; if (!$model->isNewRecord) { $city_data = Area::model()->findAll("parent_id=:parent_id", array(":parent_id" => $model->state)); $city = CHtml::listData($city_data, "id", "name"); } $city_update = $model->isNewRecord ? array() : $city; echo CHtml::dropDownList('AddressResult[city]', $c_default, $city_update, array('empty' => '请选择城市', 'ajax' => array('type' => 'GET', 'url' => CController::createUrl('dynamicdistrict'), 'update' => '#AddressResult_district', 'data' => 'js:"AddressResult_city="+jQuery(this).val()'))); $d_default = $model->isNewRecord ? '' : $model->district; if (!$model->isNewRecord) { $district_data = Area::model()->findAll("parent_id=:parent_id", array(":parent_id" => $model->city)); $district = CHtml::listData($district_data, "id", "name"); } $district_update = $model->isNewRecord ? array() : $district; echo CHtml::dropDownList('AddressResult[district]', $d_default, $district_update, array('empty' => '请选择地区')); ?> <?php echo $form->textFieldRow($model, 'zipcode', array('class' => 'span2')); ?> </div> <?php echo $form->textFieldRow($model, 'address', array('class' => 'span5')); ?>
public static function model($className = __CLASS__) { return parent::model($className); }
public function showDetailAddress($model) { $data['receiver_country'] = $model->receiver_country; foreach (array('state', 'city', 'district') as $value) { $data['receiver_' . $value] = Area::model()->findByPk($model->{'receiver_' . $value})->name; } $data['receiver_address'] = $model->receiver_address; $detail_address = implode(' ', $data); return $detail_address; }
public function actionGetChildAreas($parent_id) { $areas = Area::model()->findAllByAttributes(array('parent_id' => $parent_id)); $areasData = CHtml::listData($areas, 'area_id', 'name'); echo json_encode(CMap::mergeArray(array('0' => ''), $areasData)); }
<?php $state_data = Area::model()->findAll("Grade=:grade", array(":grade" => 1)); $state = CHtml::listData($state_data, "ID", "Name"); $s_default = $organ->isNewRecord ? '' : $organ->Province; echo Chtml::dropDownList('Organ[Province]', $organ->Province, $state, array('class' => 'easyui-validatebox width90 select', 'id' => 'province', 'empty' => '请选择省份', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->createUrl('/admin/Dynamiccities'), 'update' => '#city', 'data' => 'js:"province="+jQuery(this).val()'))); //empty since it will be filled by the other dropdown $c_default = $organ->isNewRecord ? '' : $organ->City; if (!$organ->isNewRecord) { $city_data = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $organ->Province)); $city = CHtml::listData($city_data, "ID", "Name"); } $city_update = $organ->isNewRecord ? array() : $city; echo Chtml::dropDownList('Organ[City]', $organ->City, $city_update, array('class' => 'width90 select', 'id' => 'city', 'empty' => '请选择城市', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->createUrl('/admin/dynamicdistrict'), 'update' => '#area', 'data' => 'js:"city="+jQuery(this).val()'))); $d_default = $organ->isNewRecord ? '' : $organ->Area; if (!$organ->isNewRecord) { $district_data = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $organ->City)); $district = CHtml::listData($district_data, "ID", "Name"); } $district_update = $organ->isNewRecord ? array() : $district; echo Chtml::dropDownList('Organ[Area]', $organ->Area, $district_update, array('class' => 'width90 select', 'id' => 'area', 'empty' => '请选择地区')); $data = array(); for ($i = 1; $i <= 255; $i++) { $data[$i] = $i; } echo $form->dropDownListRow($organ, 'Sort', $data); ?> <div class="form-actions"> <?php $this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'submit', 'type' => 'primary', 'label' => $model->isNewRecord ? '创建' : '保存')); ?> </div>
<td ><?php echo $row->name; ?> </td> <td><?php echo $row->rank; ?> </td> <td><?php echo $row->price; ?> </td> <td> <?php $areas = Area::model()->findAllByAttributes(array('grade' => 2)); $area = CHtml::listData($areas, "area_id", "name"); print_r($area[$row->city]); ?> </td> <td><?php echo $row->address; ?> </td> <td><?php echo $row->recommendation === 1 ? '是' : '否'; ?> </td> <td> <select id="checkSelect_<?php echo $row->id;
} }'))); $c_default = $model->isNewRecord ? '' : $search['city']; if (!$model->isNewRecord) { $city_data = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $search['province'])); $city = CHtml::listData($city_data, "ID", "Name"); } $city_update = $model->isNewRecord ? array() : $city; echo CHtml::dropDownList('JpdReceiveAddress[City]', $c_default, $city_update, array('empty' => '请选择市', 'class' => 'width114 select', 'style' => 'width:100px', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/dynamicdistrict', 'data' => 'js:"city="+jQuery(this).val()', 'success' => 'function(data){ $("#JpdReceiveAddress_District").html(data); if($("#JpdReceiveAddress_State").attr("area")) $("#JpdReceiveAddress_District").val($("#JpdReceiveAddress_State").attr("area")); }'))); $d_default = $model->isNewRecord ? '' : $search['area']; if (!$model->isNewRecord) { $district_data = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $search['city'])); $district = CHtml::listData($district_data, "ID", "Name"); } $district_update = $model->isNewRecord ? array() : $district; echo CHtml::dropDownList('JpdReceiveAddress[District]', $d_default, $district_update, array('empty' => '请选择区', 'style' => 'width:100px', 'class' => 'width114 select')); ?> <?php echo $form->error($model, Province, array('style' => 'color:red')); ?> <?php echo $form->error($model, City, array('style' => 'color:red')); ?> <?php echo $form->error($model, Area, array('style' => 'color:red')); ?> </div>
public function getAreas() { $areasData = array(); $areas = Area::model()->findAllByAttributes(array('grade' => 0)); $areasData[] = CMap::mergeArray(array('0' => ''), CHtml::listData($areas, 'area_id', 'name')); foreach (array('country', 'state') as $area) { $areas = Area::model()->findAllByAttributes(array('parent_id' => $this->{$area})); $areasData[] = CMap::mergeArray(array('0' => ''), CHtml::listData($areas, 'area_id', 'name')); } return $areasData; }
<?php /** * Created by PhpStorm. * author: shuai.du@jago-ag.cn * Date: 3/6/14 * Time: 9:40 AM */ $data = Category::model()->findAllByAttributes(array('category_id' => $model->category_id)); $props = json_decode($model->props_name); $str = ''; foreach ($props as $prop) { if (is_array($prop)) { foreach ($prop as $value) { $str .= $value . '; '; } } else { $str .= $prop . '; '; } } $country = Area::model()->findAllByPk($model->country); $state = Area::model()->findAllByPk($model->state); $city = Area::model()->findAllByPk($model->city); $this->widget('bootstrap.widgets.TbDetailView', array('data' => $model, 'attributes' => array(array('name' => 'category_id', 'value' => $data[0]['name']), 'title', 'stock', 'min_number', 'price', 'currency', array('name' => 'props_name', 'value' => $str), 'desc', 'shipping_fee', array('name' => Yii::t('backend', '是否展示'), 'value' => $model->showIsShow($model->is_show), 'filter' => array('0' => 'NO', '1' => 'Yes')), array('name' => Yii::t('backend', '是否促销'), 'value' => $model->showIsPromote($model->is_show)), array('name' => Yii::t('backend', '是否新的'), 'value' => $model->showIsNew($model->is_show)), array('name' => Yii::t('backend', '是否热销'), 'value' => $model->showIsHot($model->is_show)), array('name' => Yii::t('backend', '是否最好的'), 'value' => $model->showIsBest($model->is_show)), 'click_count', 'wish_count', 'review_count', array('name' => 'deal_count'), array('name' => 'create_time', 'value' => date("Y年m月d日 H:i:s", $model->create_time + 8 * 3600)), array('name' => 'update_time', 'value' => date("Y年m月d日 H:i:s", $model->update_time + 8 * 3600)), 'language', array('name' => 'country', 'value' => $country[0]['name']), array('name' => 'state', 'value' => $state[0]['name']), array('name' => 'city', 'value' => $city[0]['name']), 'title1', 'Keywords', 'description')));
<?php /* @var $this DocumentsController */ /* @var $model Documents */ /* @var $form CActiveForm */ $area_checkbox = Area::model()->findAll(); if ($model->isNewRecord) { $city_checkbox = City::model()->findAllByAttributes(array('area_id' => $area_checkbox[0]->id)); } else { $city_checkbox = City::model()->findAllByAttributes(array('area_id' => $model->area)); } ?> <div class="box"> <div class="box-content"> <div class="text-center"> <h3 class="page-header">Форма заявки <?php echo Yii::app()->getBaseUrl(true); ?> </h3> <p class="note">Поля отмеченные <span class="required">*</span> обязательны для заполнения.</p> </div> <?php if (!$model->isNewRecord) { ?> <div class="form-group col-sm-6"> <label class="control-label required"><?php echo $model->getAttributeLabel('id'); ?> </label>
public function actionRoute() { $area = Area::model()->findAll(); $continent = Continent::model()->findAll(); $boat = Boat::model()->findAll(); $this->g_area = $area; $this->g_continent = $continent; $company = Company::model()->findAll(); $this->g_company = $company; $s_data = $_GET['d']; $s_company = $_GET['c']; $s_area = $_GET['a']; $s_days = $_GET['days']; if (strstr($s_data, '请选择')) { $s_data = '全部'; } if (strstr($s_company, '请选择')) { $s_company = '全部'; } if (strstr($s_area, '请选择')) { $s_area = '全部'; } $year = date("Y"); $month = date('n'); $arr = array(); for ($i = $month; $i <= 12; $i++) { array_push($arr, $year . '年' . $i . '月'); } $year += 1; for ($i = 1; $i <= 12; $i++) { array_push($arr, $year . '年' . $i . '月'); } $criteria = new CDbCriteria(); if ($s_company != '全部') { $criteria->addCondition("company = '{$s_company}' ", 'AND'); } if ($s_data != '全部') { $d = str_replace('年', '-', $s_data); $d = str_replace('月', '', $d); $criteria->addCondition(" start_time >= '{$d}' and start_time < " . '"' . $d . '-40"', 'AND'); } if ($s_area != '全部') { $criteria->addCondition("area = '{$s_area}' or continent = '{$s_area}' ", 'AND'); } if ($s_days != '全部') { if ($s_days == 3) { $criteria->addCondition("days <= {$s_days}", 'AND'); } else { if ($s_days == 11) { $criteria->addCondition("days >= {$s_days}", 'AND'); } else { $criteria->addCondition("days = {$s_days}", 'AND'); } } } $page = 0; if (isset($_GET['page'])) { $page = $_GET['page']; } $count = Route::model()->count($criteria); $criteria->limit = 10; $criteria->offset = $page * $criteria->limit; $result = Route::model()->findAll($criteria); $schedule = array(); # $item = str_replace(',', ' and id = ', $item); # $item = ' id = '.$item; # $c = new CDbCriteria; # $c->condition = $item; # $c->order = 'day asc'; # $c->select = 'title'; # $r = Schedule::model()->findAll($c); # array_push($schedule, $r); //echo '<meta charset="UTF-8">'; //echo $criteria->condition; //var_dump($result); $this->render('index', array('s_data' => $s_data, 's_company' => $s_company, 's_area' => $s_area, 'area' => $area, 'continent' => $continent, 'company' => $company, 'data' => $arr, 'result' => $result, 'count' => $count, 'page' => $page, 'limit' => $criteria->limit, 's_days' => $s_days, 'schedule' => $schedule)); }
/** *belum tentu dipakai : * * @param type $province * @param type $district * @param type $postal */ public static function getZoneIdOrDistrictId($province, $district, $postal) { if (empty($postal)) { $criteria = new CDbCriteria(); $criteria->select = 't.id'; $criteria->join = 'JOIN district ON t.district_id = district.id JOIN province ON province.id = district.province_id'; $criteria->addSearchCondition('district.name', $district, true, 'AND'); $criteria->addSearchCondition('province.name', $province, true, 'AND'); $criteria->limit = 1; $builder = new CDbCommandBuilder(Yii::app()->db->Schema); $command = $builder->createFindCommand('zone', $criteria); $zone_id = $command->queryAll(); } else { $zone_id = Area::model()->findByAttributes(array('postcode' => $postal)); } print_r($zone_id); exit; }
public function showCity($id) { $model = Area::model()->find("id=:id", array(":id" => $id)); return $model['name']; }
echo Yii::app()->createUrl('/pap/logistics/index'); ?> " class="color_blue" style="font-weight:400">返回列表</a> </span> </p> <div style="margin-left:2px"> <div class="target_list"> <p class="m-top m_left20"><span class="color_red">*</span><span>公司名称:</span> <input type="text" class="input input3 width200" maxlength="20" id="name" value="<?php echo $datas['LogisticsCompany']; ?> "></p> <p class="m-top m_left20"><span class="color_red">*</span><span>发货地址:</span> <?php $pdata = Area::model()->findAll("Grade=:grade", array(":grade" => 1)); $state = CHtml::listData($pdata, "ID", "Name"); echo CHtml::dropDownList('Province', '', $state, array('class' => 'width118 select', 'empty' => '请选择省份', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/dynamiccities', 'data' => 'js:"province="+jQuery(this).val()', 'success' => 'function(data){ $("#City").html(data); $("<option value=' . '' . '>全部</option>").prependTo("#City"); $("#City option:eq(0)").attr("selected","selected"); if($("#City").val()!="") { $("#City").change(); }else{ $("#Area").empty(); $("<option value=' . '' . '>全部</option>").prependTo("#Area"); } }'))); echo CHtml::dropDownList('City', '', array(), array('class' => 'width118 select', 'empty' => '请选择城市', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/dynamicdistrict', 'data' => 'js:"city="+jQuery(this).val()', 'success' => 'function(data){ $("#Area").empty();
public function actionDynamicdistrict() { $Profile_city = !empty($_GET['Profile_city']) ? ${$_GET}['Profile_city'] : $_POST['Profile_city']; if ($Profile_city) { $data = Area::model()->findAll("parent_id=:parent_id", array(":parent_id" => $Profile_city)); $data = CHtml::listData($data, "id", "name"); foreach ($data as $value => $name) { echo CHtml::tag("option", array("value" => $value), CHtml::encode($name), true); } } }
<?php $state_data = Area::model()->findAll("Grade=:grade", array(":grade" => 1)); $state = CHtml::listData($state_data, "ID", "Name"); $s_default = $province; echo CHtml::dropDownList('State', $s_default, $state, array('empty' => '请选择省', 'class' => ' select', 'style' => 'width:100px;margin-left:5px', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/dynamiccities', 'data' => 'js:"province="+jQuery(this).val()', 'success' => 'function(data){ $("#City").html(data); $("<option value=' . '' . '>请选择市</option>").prependTo("#City"); if($("#State").attr("city")!="undefied"){ $("#City").val($("#State").attr("city")); }else{ $("#City option:eq(0)").attr("selected","selected"); } }'))); $c_default = $city ? $city : ''; if ($province) { $city_data = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $province)); $citylists = CHtml::listData($city_data, "ID", "Name"); } echo CHtml::dropDownList('City', $city, $citylists, array('empty' => '请选择市', 'class' => 'width114 select', 'style' => 'width:100px', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/dynamicdistrict', 'data' => 'js:"city="+jQuery(this).val()'))); ?> <input type="submit" class="submit" value="查询" id="search"> </form> </div> <div class="float_r sp_xianshi"> <ul> <?php if ($type == 1) { ?> <li><a href="<?php echo Yii::app()->createUrl('servicer/uniondealer/index', array('type' => 2)); ?>
echo CHtml::textField('keywords', $search['keywords'], array('class' => 'width260 input', 'func' => 's')); ?> </div> <div style="clear:both"></div> </div> <div class="ccc"> <div class="aaa"><label>地区:</label></div> <div style="float:left"> <?php $province_data = Area::model()->findAll("grade=:grade", array(":grade" => 1)); $province = CHtml::listData($province_data, "id", "name"); ?> <?php echo CHtml::dropDownList('dprovince', $search['province'], $province, array('class' => 'width118 select', 'empty' => '请选择省', 'ajax' => array('type' => 'GET', 'url' => Yii::app()->request->baseUrl . '/common/dynamiccity', 'update' => '#dcity', 'data' => 'js:"province="+jQuery(this).val()'))); if ($search['province']) { $city_data = Area::model()->findAll("parent_id=:parent_id", array(":parent_id" => $search['province'])); $city = CHtml::listData($city_data, "id", "name"); } $city_update = $search['province'] ? $city : array(); echo CHtml::dropDownList('dcity', $search['city'], $city_update, array('class' => 'width118 select', 'empty' => '请选择市')); ?> </div> <div style="clear:both"></div> </div> </div>
public function actionDynamicarea() { if ($_GET["province"]) { $city = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $_GET["province"])); foreach ($city as $ci) { $data = Area::model()->findAll("ParentID=:parent_id", array(":parent_id" => $ci->ID)); $data = CHtml::listData($data, "ID", "Name"); break; } echo json_encode($data); } }