/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new College();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['College'])) {
$model->attributes = $_POST['College'];
if ($model->save()) {
$this->redirect(array('view', 'id' => $model->id));
}
}
$this->render('create', array('model' => $model));
}
/**
* @todo 利用上面获取得的相关信息，把其写入文件或数据库，当然写入数据库之前要建立数据库
*
* 结构如下：
*
* CREATE TABLE `college` (
* `id` int(11) NOT NULL AUTO_INCREMENT,
* `name` varchar(200) NOT NULL COMMENT '高校名称',
* `type` int(11) NOT NULL COMMENT '高校类型',
* `province` int(11) NOT NULL COMMENT '高校所在省份',
* `homepage` varchar(200) NOT NULL COMMENT '高校主页\r\n',
* PRIMARY KEY (`id`),
* KEY `province` (`province`)
* ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
*
*注意：这里只是Yii版的范例，如果需要使用，则需要对应修改一下下面的代码
*/
public static function generateCollegesInfo($output = 'file')
{
$str = '';
//获取网址
$urls = self::getCollegesLocation();
foreach ($urls as $province => $url) {
/**获取provinceID*/
$criteria = new CDbCriteria();
$criteria->addSearchCondition('region', $province);
$region = Region::model()->find($criteria);
// UtilHelper::dump($region->attributes);
$provinceID = $region->id;
// UtilHelper::dump($province.'-=-'.$provinceID);
foreach ($url as $k => $v) {
$type = $k;
// UtilHelper::dump($province.'-'.$k.'=>'.$v);
$colleges = self::getColleges($v);
// UtilHelper::dump($colleges);
foreach ($colleges as $name => $homepage) {
/**在这里把要写入数据库的信息写入文件**/
$str .= $province . "\t" . $type . "\t" . $name . "\t" . $homepage . "\r\n";
$college = new College();
$college->province = $provinceID;
$college->type = $type;
$college->name = $name;
$college->homepage = $homepage;
if ($college->save()) {
echo 'yes-' . $college->id . '<br />';
} else {
echo CHtml::errorSummary($college);
}
}
}
}
if ($output == 'file') {
$fp = fopen('./public/colleges.txt', 'w+');
fwrite($fp, $str);
fclose($fp);
}
}
public function actionTest4()
{
$filename = './public/highscholls.txt';
$school = file($filename);
$school = array_map('check', $school);
// foreach ($school as $k=>$v)
// {
//// $school = str_replace($ufo, '',str_replace("\r", '',str_replace("\n", '', $v),$v),$v);
//
//// $school[$k] = str_replace("\r", '',str_replace("\n", '', $v),$v);
// if (intval($v)||trim($v) == ''||trim($v)==' '||trim($v) ==' '||strpos(' ', $v))
// {
// unset($school[$k]);
// }
// }
$school = array_chunk($school, 2);
foreach ($school as $value) {
// $todo[$value[1]] = $value[0];
$province = $value[0];
$name = $value[1];
echo $province;
echo $name;
/**获取provinceID*/
$criteria = new CDbCriteria();
$criteria->addSearchCondition('region', $province);
$region = Region::model()->find($criteria);
UtilHelper::dump($region->attributes);
$provinceID = $region->id;
$type = College::COLLEGE_TYPE_GAOZHONG;
$college = new College();
$college->province = $provinceID;
$college->type = $type;
$college->name = $name;
if ($college->isNewRecord && $college->save()) {
echo 'yes-' . $college->id . '<br />';
} else {
echo CHtml::errorSummary($college);
}
}
// UtilHelper::dump($todo);
}
