<div class="row"> <?php echo $form->labelEx($model,'weight'); ?> <?php echo $form->textField($model,'weight'); ?> <?php echo $form->error($model,'weight'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'sexual_orientation'); ?> <?php echo $form->dropDownList($model,'sexual_orientation',Anketa::$getSexOr,array('empty'=>'Выбрать..')); ?> <?php echo $form->error($model,'sexual_orientation'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'location'); ?> <?php echo $form->dropDownList($model,'location',Anketa::getCities(), array('empty'=>'выберите город')) ?> <?php echo $form->error($model,'location'); ?> </div> <? /* <div class="row"> <?php echo $form->labelEx($model,'icq'); ?> <?php echo $form->textField($model,'icq'); ?> <?php echo $form->error($model,'icq'); ?> </div> <div class="row"> <?php echo $form->labelEx($model,'phone'); ?> <?php echo $form->textField($model,'phone'); ?> <?php echo $form->error($model,'phone'); ?> </div>
<b class="hd">Возраст</b> <?php echo $form->dropDownList($model, 'agefrom', $ages, array('empty' => 'не указан')); ?> </div> <div class="item item-rht"> <b class="hd"> </b> <?php echo $form->dropDownList($model, 'ageto', $ages, array('empty' => 'не указан')); ?> </div> </div> <div class="row big-sel nuclear"> <b class="hd">Откуда</b> <?php echo $form->dropDownList($model, 'location', Anketa::getCities(), array('empty' => 'выберите город', 'class' => 'mainselect')); ?> </div> </div> <div class="row nucelar"> <input type="submit" value="Искать!" class="but" /> </div> <?php $this->endWidget(); ?> </div> <div class="search enter"> <div class="headline">Вход на сайт</div> <?php $model = new LoginForm(); ?>
public function actionCities() { $cities = Anketa::getCities(); $cities = $cities['Города России:']; //$cities = $cities['Две столицы:']; $cmd = Yii::app()->db->createCommand('SELECT count(id) FROM anketa where location LIKE :city'); // $delCmd = Yii::app()->db->createCommand('DELETE FROM anketa WHERE sexual_orientation = 1 AND id < 503777 AND location LIKE :city LIMIT :limit'); // $cmdcity = Yii::app()->db->createCommand('INSERT IGNORE INTO anketa_in_city SELECT id FROM anketa where location LIKE :city'); $result = array(); $sum = 0; foreach ($cities as $city) { $result[$city] = $cmd->queryScalar(array(':city' => "%{$city}%")); // $cmdcity->execute(array(':city'=>"%$city%")); // if ($result[$city] > 70) { // $delCmd->bindValue(':limit', intval($result[$city] * 0.7), PDO::PARAM_INT); // $delCmd->bindValue(':city',"%$city%" , PDO::PARAM_STR); // $delCmd->execute(); // echo $city; // } $sum += $result[$city]; } array_multisort($result); // foreach ($result as $k=>$v) { // if ($v<15) $q[] = "UPDATE anketa SET location = '$k' WHERE location LIKE '%Саратов%' LIMIT 13;"; // } // echo implode('<br>',$q); die(); print_r($result); echo '<br>Total: ' . $sum; exit; }