Example #1
0
 protected function afterSave()
 {
     if (Yii::app() instanceof CConsoleApplication) {
         return;
     }
     $isAdmin = Yii::app()->user->checkRole(User::ROLE_DELEGATE);
     //处理代表和主办
     foreach (array('organizer', 'delegate') as $attribute) {
         $attributeId = $attribute . '_id';
         $oldValues = array_values(CHtml::listData($this->{$attribute}, $attributeId, $attributeId));
         $newValues = array_values((array) $this->{$attribute . 's'});
         sort($oldValues);
         sort($newValues);
         if ($oldValues != $newValues) {
             $modelName = 'Competition' . ucfirst($attribute);
             foreach ($oldValues as $value) {
                 if (!in_array($value, $newValues) && $isAdmin) {
                     $modelName::model()->deleteAllByAttributes(array('competition_id' => $this->id, $attributeId => $value));
                 }
             }
             foreach ($newValues as $value) {
                 if (!in_array($value, $oldValues)) {
                     $model = new $modelName();
                     $model->competition_id = $this->id;
                     $model->{$attribute . '_id'} = $value;
                     $model->save();
                 }
             }
         }
     }
     //处理赛程
     $schedules = $this->schedules;
     if (!empty($schedules['start_time'])) {
         Schedule::model()->deleteAllByAttributes(array('competition_id' => $this->id));
         foreach ($schedules['start_time'] as $key => $startTime) {
             if (empty($startTime) || !isset($schedules['end_time'][$key]) || empty($schedules['end_time'][$key])) {
                 continue;
             }
             $model = new Schedule();
             $model->competition_id = $this->id;
             $model->start_time = strtotime($startTime);
             $model->end_time = strtotime($schedules['end_time'][$key]);
             $model->day = $schedules['day'][$key];
             $model->stage = $schedules['stage'][$key];
             $model->event = $schedules['event'][$key];
             $model->group = $schedules['group'][$key];
             $model->round = $schedules['round'][$key];
             $model->format = $schedules['format'][$key];
             $model->number = intval($schedules['number'][$key]);
             $model->cut_off = intval($schedules['cut_off'][$key]);
             $model->time_limit = intval($schedules['time_limit'][$key]);
             $model->save(false);
         }
     }
     //处理地址
     $oldLocations = $this->location;
     foreach ($this->locations as $key => $value) {
         if (isset($oldLocations[$key])) {
             $location = $oldLocations[$key];
         } else {
             $location = new CompetitionLocation();
             $location->competition_id = $this->id;
             $location->location_id = $key;
         }
         $location->attributes = $value;
         $location->save(false);
     }
     if ($this->isOld()) {
         $this->old->save(false);
     }
 }
Example #2
0
 public function actionCompetition()
 {
     $provinces = CHtml::listData(Region::getRegionsByPid(1), 'id', 'name_zh');
     $cities = Yii::app()->db->cache(86400)->createCommand()->select('*')->from('region')->where('pid>1')->order('id')->queryAll();
     $allCities = array();
     foreach ($cities as $city) {
         if (!isset($allCities[$city['pid']])) {
             $allCities[$city['pid']] = array();
         }
         $allCities[$city['pid']][$city['id']] = $city['name_zh'];
     }
     $cities = $allCities;
     $db = Yii::app()->db;
     $db->createCommand()->truncateTable('old_competition');
     $oldEvents = $db->createCommand()->select('*')->from('cubingchina_mf8.比赛项目')->order('项目顺序')->queryAll();
     $oldEvents = array_combine(array_map(function ($event) {
         return $event['项目顺序'];
     }, $oldEvents), $oldEvents);
     $oldCompetitions = $db->createCommand()->select('*')->from('cubingchina_mf8.比赛事件')->order('比赛id')->queryAll();
     foreach ($oldCompetitions as $oldCompetition) {
         $competition = new Competition();
         //基本信息
         $competition->name_zh = str_replace(' ', '', $oldCompetition['比赛名称']);
         $competition->date = strtotime($oldCompetition['比赛日期']);
         if ($oldCompetition['天数'] > 1) {
             $competition->end_date = $competition->date + 86400 * ($oldCompetition['天数'] - 1);
         }
         $competition->reg_end = $competition->date - 86400;
         $competition->old_competition_id = $oldCompetition['比赛id'];
         //地点
         $location = new CompetitionLocation();
         $detected = false;
         $address = $oldCompetition['地址'] . $oldCompetition['比赛名称'];
         foreach ($provinces as $provinceId => $province) {
             if (strpos($address, $province) !== false) {
                 $location->province_id = $provinceId;
                 $location->city_id = $this->_cityId;
                 foreach ($cities[$provinceId] as $cityId => $city) {
                     if (mb_strlen($city, 'utf-8') > 2) {
                         $city = mb_substr($city, 0, -1, 'utf-8');
                     }
                     if (strpos($address, $city) !== false) {
                         $location->city_id = $cityId;
                         break;
                     }
                 }
                 $detected = true;
                 break;
             }
         }
         if (!$detected) {
             $location->province_id = $this->_provinceId;
             $location->city_id = $this->_cityId;
         }
         $location->venue_zh = $oldCompetition['地址'];
         $competition->location = array($location);
         if ($oldCompetition['是否wca']) {
             $competition->type = Competition::TYPE_WCA;
             $wcaCompetitions = Competitions::model()->findAllByAttributes(array('countryId' => 'China', 'year' => date('Y', $competition->date), 'month' => date('m', $competition->date), 'day' => date('d', $competition->date)));
             $wcaCompetition = null;
             if (count($wcaCompetitions) == 1) {
                 $wcaCompetition = $wcaCompetitions[0];
             } else {
                 foreach ($wcaCompetitions as $value) {
                     if (strpos($value->website, '=' . $competition->old_competition_id) !== false) {
                         $wcaCompetition = $value;
                         break;
                     }
                 }
             }
             if ($wcaCompetition !== null) {
                 $competition->name = $wcaCompetition->name;
                 $competition->wca_competition_id = $wcaCompetition->id;
                 $location->venue = $wcaCompetition->venueDetails . ', ' . $wcaCompetition->venueAddress;
             }
         } else {
             $competition->type = Competition::TYPE_OTHER;
         }
         //代表和主办
         $oldComp = new OldCompetition();
         $oldComp->id = $oldCompetition['比赛id'];
         $oldComp->delegate_zh = OldCompetition::generateInfo($this->makeInfo($oldCompetition['监督代表']));
         $organizer = $this->makeInfo($oldCompetition['主办方']);
         if ($oldCompetition['主办电邮']) {
             $organizer[0]['email'] = $oldCompetition['主办电邮'];
         }
         $oldComp->organizer_zh = OldCompetition::generateInfo($organizer);
         $oldComp->save(false);
         //项目
         $events = array();
         $resultEvents = $db->createCommand()->select('*')->from('cubingchina_mf8.比赛成绩')->leftJoin('cubingchina_mf8.比赛项目', '比赛项目.项目id=比赛成绩.项目id')->where('比赛成绩.事件id=' . $oldCompetition['比赛id'])->group('比赛成绩.项目id, 比赛成绩.第N轮')->queryAll();
         if ($resultEvents !== array()) {
             foreach ($resultEvents as $value) {
                 $eventName = $value['项目名'];
                 $event = isset($this->_eventsMap[$eventName]) ? $this->_eventsMap[$eventName] : 'funny';
                 if (!isset($events[$event])) {
                     $events[$event] = array('round' => 0, 'fee' => 0);
                 }
                 $events[$event]['round']++;
             }
         }
         if ($events === array() && $competition->wca_competition_id !== '') {
             $resultEvents = Results::model()->findAllByAttributes(array('competitionId' => $competition->wca_competition_id), array('group' => 'eventId,roundId'));
             if ($resultEvents !== array()) {
                 foreach ($resultEvents as $value) {
                     $event = $value->eventId;
                     if (!isset($events[$event])) {
                         $events[$event] = array('round' => 0, 'fee' => 0);
                     }
                     $events[$event]['round']++;
                 }
             }
         }
         if ($events === array()) {
             for ($i = 0; $i < strlen($oldCompetition['比赛项目']); $i++) {
                 if ($oldCompetition['比赛项目'][$i]) {
                     $eventName = $oldEvents[$i + 1]['项目名'];
                     $event = isset($this->_eventsMap[$eventName]) ? $this->_eventsMap[$eventName] : 'funny';
                     $events[$event] = array('round' => 1, 'fee' => 0);
                 }
             }
         }
         $competition->events = $events;
         $competition->handleEvents();
         $ret = $competition->save(false);
         $location->competition_id = $competition->id;
         $location->save(false);
     }
 }
Example #3
0
 public function getLocation()
 {
     return CompetitionLocation::model()->with('province', 'city')->findByAttributes(array('competition_id' => $this->competition_id, 'location_id' => $this->location_id));
 }