コード例 #1
0
 /**
  * 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));
 }
コード例 #2
0
ファイル: HomeController.php プロジェクト: rocketyang/yii2
 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;
 }
コード例 #3
0
ファイル: CronController.php プロジェクト: ph7pal/wedding
 /**
  * 根据地区woeid获取雅虎天气
  * 获取woeid http://sugg.us.search.yahoo.net/gossip-gl-location/?appid=weather&output=xml&command=地名(如香港)
  * 匹配规则:preg_match('/woeid=(\d+)\&amp;lon=.*?\&amp;lat=.*?\&amp;s=.*?\&amp;c=.*?\&amp;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/>';
 }
コード例 #4
0
ファイル: Area.php プロジェクト: WalkerDi/mama
 public static function getList()
 {
     $model = Area::model();
     $command = $model->getDbConnection()->CreateCommand();
     $tableName = $model->tableName();
     return $command->select()->from($tableName)->order('create_time DESC')->queryAll();
 }
コード例 #5
0
ファイル: AreaController.php プロジェクト: kuldeepro/playwin
 public function loadModel($id)
 {
     $model = Area::model()->findByPk($id);
     if ($model === null) {
         throw new CHttpException(404, 'The requested page does not exist.');
     }
     return $model;
 }
コード例 #6
0
ファイル: Area.php プロジェクト: aantonw/dcourier.system
 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;
 }
コード例 #7
0
ファイル: CommonAction.php プロジェクト: zwq/unpei
 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);
         }
     }
 }
コード例 #8
0
ファイル: MemberService.php プロジェクト: bfyang5130/zzl
 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;
 }
コード例 #9
0
ファイル: LogisticsService.php プロジェクト: zwq/unpei
 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;
 }
コード例 #10
0
ファイル: UserController.php プロジェクト: bfyang5130/zzl
 /**
  * 地区联动
  */
 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);
     }
 }
コード例 #11
0
ファイル: OutAreaWidget.php プロジェクト: xPashaNx/diet
 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 . " не найдена.";
     }
 }
コード例 #12
0
 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;
 }
コード例 #13
0
ファイル: _form.php プロジェクト: jackycgq/advanced
    <?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'));
?>
コード例 #14
0
ファイル: ARArea.php プロジェクト: jackycgq/advanced
 public static function model($className = __CLASS__)
 {
     return parent::model($className);
 }
コード例 #15
0
ファイル: Order.php プロジェクト: lhfcainiao/basic
 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;
 }
コード例 #16
0
 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));
 }
コード例 #17
0
ファイル: _form.php プロジェクト: zwq/unpei
<?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>
コード例 #18
0
      <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;
コード例 #19
0
ファイル: addadress.php プロジェクト: zwq/unpei
                             }
                        }')));
$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>
コード例 #20
0
ファイル: Item.php プロジェクト: lhfcainiao/basic
 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;
 }
コード例 #21
0
ファイル: _view.php プロジェクト: lhfcainiao/basic
<?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')));
コード例 #22
0
ファイル: _form.php プロジェクト: seekermain/forms
<?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>
コード例 #23
0
ファイル: SearchController.php プロジェクト: rocketyang/yii2
 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));
 }
コード例 #24
0
ファイル: Zone.php プロジェクト: aantonw/dcourier.system
 /**
  *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;
 }
コード例 #25
0
ファイル: PromitdealerController.php プロジェクト: zwq/unpei
 public function showCity($id)
 {
     $model = Area::model()->find("id=:id", array(":id" => $id));
     return $model['name'];
 }
コード例 #26
0
ファイル: add.php プロジェクト: zwq/unpei
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();
コード例 #27
0
ファイル: RegistrationController.php プロジェクト: zwq/unpei
 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);
         }
     }
 }
コード例 #28
0
ファイル: index.php プロジェクト: zwq/unpei
                <?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));
    ?>
コード例 #29
0
ファイル: index.php プロジェクト: zwq/unpei
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>

コード例 #30
0
ファイル: CommonController.php プロジェクト: zwq/unpei
 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);
     }
 }