<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;
}
