PHP Country::find方法代碼示例

 /**
  * @param array $input
  * @param Affiliate $affiliate
  *
  * @return array
  */
 private function getLicensePaymentDetails(array $input, Affiliate $affiliate)
 {
     $country = Country::find($input['country_id']);
     $data = ['firstName' => $input['first_name'], 'lastName' => $input['last_name'], 'email' => $input['email'], 'number' => $input['card_number'], 'expiryMonth' => $input['expiration_month'], 'expiryYear' => $input['expiration_year'], 'cvv' => $input['cvv'], 'billingAddress1' => $input['address1'], 'billingAddress2' => $input['address2'], 'billingCity' => $input['city'], 'billingState' => $input['state'], 'billingPostcode' => $input['postal_code'], 'billingCountry' => $country->iso_3166_2, 'shippingAddress1' => $input['address1'], 'shippingAddress2' => $input['address2'], 'shippingCity' => $input['city'], 'shippingState' => $input['state'], 'shippingPostcode' => $input['postal_code'], 'shippingCountry' => $country->iso_3166_2];
     $card = new CreditCard($data);
     return ['amount' => $affiliate->price, 'card' => $card, 'currency' => 'USD', 'returnUrl' => URL::to('license_complete'), 'cancelUrl' => URL::to('/')];
 }

 public function actionIndex()
 {
     $query = Country::find();
     $pagination = new Pagination(['defaultPageSize' => 5, 'totalCount' => $query->count()]);
     $countries = $query->orderBy('name')->offset($pagination->offset)->limit($pagination->limit)->all();
     return $this->render('index', ['countries' => $countries, 'pagination' => $pagination]);
 }

 public function actionTest()
 {
     $result = Country::find()->orderBy('population DESC')->all();
     //獲取全部
     //var_dump($result);exit();
     return $this->render('test', ['result' => $result]);
 }

 public function getCountries()
 {
     $ret = [];
     foreach (Country::find()->all() as $cc) {
         $ret[$cc->key] = $cc->id;
     }
     return $ret;
 }

 public function actionIndex()
 {
     $country = new Country();
     echo PRE;
     $query = Country::find();
     $pagination = new Pagination(['defaultPageSize' => 5, 'totalCount' => $query->count()]);
     $countries = $query->orderBy('name')->offset($pagination->offset)->limit($pagination->limit)->all();
 }

 public function actionIndex()
 {
     $query = Country::find();
     //$query = Country::find()->andWhere(['code'=>'AU']);
     //初始化分頁
     $pagination = new Pagination(['pageSize' => 2, 'totalCount' => $query->count()]);
     $countries = $query->orderBy('name')->offset($pagination->offset)->limit($pagination->limit)->all();
     return $this->render('index', ['countries' => $countries, 'pagination' => $pagination]);
 }

 public function convertInputForOmnipay($input)
 {
     $data = ['firstName' => $input['first_name'], 'lastName' => $input['last_name'], 'number' => $input['card_number'], 'expiryMonth' => $input['expiration_month'], 'expiryYear' => $input['expiration_year'], 'cvv' => $input['cvv']];
     if (isset($input['country_id'])) {
         $country = Country::find($input['country_id']);
         $data = array_merge($data, ['billingAddress1' => $input['address1'], 'billingAddress2' => $input['address2'], 'billingCity' => $input['city'], 'billingState' => $input['state'], 'billingPostcode' => $input['postal_code'], 'billingCountry' => $country->iso_3166_2, 'shippingAddress1' => $input['address1'], 'shippingAddress2' => $input['address2'], 'shippingCity' => $input['city'], 'shippingState' => $input['state'], 'shippingPostcode' => $input['postal_code'], 'shippingCountry' => $country->iso_3166_2]);
     }
     return $data;
 }

 public function actionCountry()
 {
     $countries = Country::find()->orderBy('name desc')->all();
     echo \yii\helpers\Json::encode($countries);
     $countryUs = Country::findOne('US');
     echo '<br />' . \yii\helpers\Json::encode($countryUs);
     $countryUs->name = 'U.S.A.';
     echo $countryUs->save() ? '  OK' : '  False';
 }

 public function getState(Request $req)
 {
     $country = Country::find($req->id);
     $state = state::where('country_code', $country->code)->get();
     $html = '<option value="" selected>Choose Option</option>';
     foreach ($state as $states) {
         $html .= '<option value="' . $states->id . '">' . $states->name . '</option>';
     }
     echo $html;
 }

 public function getAttack($playerHash, $countryIdFrom, $countryIdTo)
 {
     $from = Country::find($countryIdFrom);
     /** @var $from Country */
     $to = Country::find($countryIdTo);
     $player = Player::getByHash($playerHash);
     if ($from->isOwnedBy($player)) {
         Action::attack($from, $to);
     }
 }

 public static function sender()
 {
     //todo: move to database
     switch (Auth::user()->user_id) {
         default:
         case 4916903:
             return new self(['first_name' => 'osu!store', 'last_name' => '', 'street' => 'Room 304, Build 700 Nishijin 7-7-1', 'city' => 'Sawara', 'state' => 'Fukuoka', 'zip' => '814-0002', 'country' => Country::find('JP'), 'phone' => '+819064201305']);
         case 2:
             return new self(['first_name' => 'osu!store', 'last_name' => '', 'street' => 'Nishi-Ooi 4-21-3 Birdie House A', 'city' => 'Shinagawa', 'state' => 'Tokyo', 'zip' => '140-0015', 'country' => Country::find('JP'), 'phone' => '+818013811430']);
     }
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Country::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['population' => $this->population]);
     $query->andFilterWhere(['like', 'code', $this->code])->andFilterWhere(['like', 'name', $this->name]);
     return $dataProvider;
 }

 /**
  * Updates an existing Address model.
  * If update is successful, the browser will be redirected to the 'view' page.
  * @param integer $id
  * @return mixed
  */
 public function actionUpdate($id)
 {
     $model = $this->findModel($id);
     $countries = ArrayHelper::map(Country::find()->all(), 'country_id', 'country');
     $cities = ArrayHelper::map(City::find()->all(), 'city_id', 'city');
     if ($model->load(Yii::$app->request->post()) && $model->save()) {
         return $this->redirect(['view', 'id' => $model->address_id]);
     } else {
         return $this->render('update', ['model' => $model, 'countries' => $countries, 'cities' => $cities]);
     }
 }

 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Country::find();
     $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSizeLimit' => [10, 100]], 'sort' => ['defaultOrder' => ['name' => SORT_ASC]]]);
     $params = $this->processParams($params);
     if (!($this->load($params) && $this->validate())) {
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id]);
     $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'code', $this->code]);
     return $dataProvider;
 }

 /**
  * Lists all CountryData models.
  * @return mixed
  */
 public function actionIndex()
 {
     $model = Country::find()->all();
     $file = Yii::$app->basePath . '/data/BP-各國能源具體數據-20151206.xlsx';
     $PHPExcel = \PHPExcel_IOFactory::load($file);
     $sheet = $PHPExcel->getSheet(5);
     // 讀取第一個工作表(編號從 0 開始)
     $highestRow = $sheet->getHighestRow();
     // 取得總行數
     $highestColumm = $sheet->getHighestColumn();
     // 取得總列數
     // $years = 2014-1965+1;
     // for($row = 4; $row <= $highestRow; $row++){
     //   $org = array();
     //   $country = null;
     //   $data_key = null;
     //   $data_value = null;
     //   $flag = true;
     // // $row = 5;
     //   for ($column = 0; $column <= $years; $column++) {
     //     $column_name = \PHPExcel_Cell::stringFromColumnIndex($column);
     //     $val = (string)$sheet->getCell($column_name.$row)->getValue();
     //     if($column == 0){
     //       if($val == "US"){
     //         $val = "United States";
     //       }
     //       if($val == "Trinidad & Tobago"){
     //         $val = "Trinidad and Tobago";
     //       }
     //       $country_model = Country::find()->where([
     //           'name_english' => $val,
     //       ])->one();
     //       if(!isset($country_model->id)){
     //         $country = null;
     //         continue;
     //       }else{
     //         $country = $country_model->id;
     //       }
     //     }
     //     if($column >=1 && trim($val)!="" && $country){
     //       $model = new CountryData();
     //       $model->country_id = $country;
     //       $model->data_key = "oil_consumption_barrels";
     //       $model->data_value = $val;
     //       $y = 1965 + $column - 1;
     //       $model->data_version = (string)$y;
     //       $model->save();
     //     }
     //   }
     // }
     return $this->render('index', ['model' => $model]);
 }