public function up()
{
$this->createTable('splatfest', ['id' => $this->primaryKey(), 'region_id' => $this->integer()->notNull(), 'name' => $this->string(64)->notNull(), 'start_at' => 'TIMESTAMP(0) WITH TIME ZONE NOT NULL', 'end_at' => 'TIMESTAMP(0) WITH TIME ZONE NOT NULL']);
$this->addForeignKey('fk_splatfest_1', 'splatfest', 'region_id', 'region', 'id');
$jp = Region::findOne(['key' => 'jp'])->id;
$this->batchInsert('splatfest', ['region_id', 'name', 'start_at', 'end_at'], [[$jp, 'ごはん vs パン', '2015-06-13 18:00:00+09', '2015-06-14 18:00:00+09'], [$jp, '赤いきつね vs 緑のたぬき', '2015-07-03 15:00:00+09', '2015-07-04 15:00:00+09'], [$jp, 'レモンティー vs ミルクティー', '2015-07-25 15:00:00+09', '2015-07-26 15:00:00+09'], [$jp, 'キリギリス vs アリ', '2015-08-22 12:00:00+09', '2015-08-23 12:00:00+09'], [$jp, 'ボケ vs ツッコミ', '2015-09-12 12:00:00+09', '2015-09-13 12:00:00+09'], [$jp, 'イカ vs タコ', '2015-10-10 09:00:00+09', '2015-10-11 09:00:00+09'], [$jp, '愛 vs おカネ', '2015-10-31 09:00:00+09', '2015-11-01 09:00:00+09'], [$jp, '山の幸 vs 海の幸', '2015-11-21 12:00:00+09', '2015-11-22 12:00:00+09'], [$jp, '赤いきつね vs 緑のたぬき', '2015-12-26 09:00:00+09', '2015-12-27 09:00:00+09']]);
}
public function actionUpdate($region, $number)
{
$transaction = Yii::$app->db->beginTransaction();
if (!($region = Region::findOne(['key' => $region]))) {
printf("Unknown region: %s\n", $region);
return 1;
}
if (!($fest = Splatfest::findOne(['region_id' => $region->id, '[[order]]' => $number]))) {
printf("Unknown number: %s (region = %s)\n", $number, $region->key);
return 1;
}
printf("Target #%d (Region=%s, Number=%d)\n", $fest->id, $region->key, $fest->order);
$alpha = SplatfestTeam::findOne(['fest_id' => $fest->id, 'team_id' => 1]);
$bravo = SplatfestTeam::findOne(['fest_id' => $fest->id, 'team_id' => 2]);
if (!$alpha || !$bravo || $alpha->color_hue === null || $bravo->color_hue === null) {
printf(" > Team information is not ready\n");
return 1;
}
printf(" > cleanup ...\n");
SplatfestBattleSummary::deleteAll(['fest_id' => $fest->id]);
$this->createBattleSummaryTmpTimestamp($fest);
$this->createBattleSummaryTmpTable('tmp_summary_a', $fest, $alpha->color_hue, $bravo->color_hue);
$this->createBattleSummaryTmpTable('tmp_summary_b', $fest, $bravo->color_hue, $alpha->color_hue);
$this->createBattleSummary($fest);
$transaction->commit();
return 0;
}
public function safeUp()
{
$regionNA = Region::findOne(['key' => 'na'])->id;
$this->batchInsert('timezone', ['identifier', 'name', 'order', 'region_id'], [['America/St_Johns', 'North America (Newfoundland)', 10001, $regionNA], ['America/Halifax', 'North America (AT)', 10002, $regionNA], ['America/Regina', 'North America (Saskatchewan)', 10003, $regionNA]]);
$newOrder = ['America/St_Johns', 'America/Halifax', 'America/New_York', 'America/Chicago', 'America/Regina', 'America/Denver', 'America/Phoenix', 'America/Los_Angeles', 'America/Anchorage', 'America/Adak', 'Pacific/Honolulu'];
$order = 20 + count($newOrder);
foreach (array_reverse($newOrder) as $ident) {
$this->update('timezone', ['order' => $order--], ['identifier' => $ident]);
}
}
public function actionDeleteRegion($region_id, $user_id)
{
$user = User::findOne($user_id);
$region = Region::findOne($region_id);
if (!$user) {
throw new NotFoundHttpException('Данный пользователь не существует.');
}
$user->unlinkRegion($region_id);
$user->save();
}
public function up()
{
$this->createTable('team', ['id' => 'INTEGER NOT NULL PRIMARY KEY', 'name' => 'VARCHAR(8) NOT NULL', 'leader' => 'VARCHAR(8) NOT NULL']);
$this->batchInsert('team', ['id', 'name', 'leader'], [[1, 'Alpha', 'Callie'], [2, 'Bravo', 'Marie']]);
$this->createTable('splatfest_team', ['fest_id' => 'INTEGER NOT NULL', 'team_id' => 'INTEGER NOT NULL', 'name' => 'VARCHAR(32) NOT NULL', 'color_hue' => 'INTEGER NULL']);
$this->addPrimaryKey('pk_splatfest_team', 'splatfest_team', ['fest_id', 'team_id']);
$this->addForeignKey('fk_splatfest_team_1', 'splatfest_team', 'fest_id', 'splatfest', 'id');
$this->addForeignKey('fk_splatfest_team_2', 'splatfest_team', 'team_id', 'team', 'id');
$jp = Region::findOne(['key' => 'jp'])->id;
$this->batchInsert('splatfest_team', ['fest_id', 'team_id', 'name', 'color_hue'], [[$this->fest($jp, 7), 1, '愛', 332], [$this->fest($jp, 7), 2, 'おカネ', 34], [$this->fest($jp, 8), 1, '山の幸', 346], [$this->fest($jp, 8), 2, '海の幸', 166], [$this->fest($jp, 9), 1, '赤いきつね', 335], [$this->fest($jp, 9), 2, '緑のたぬき', 155]]);
}
public function up()
{
$this->execute('ALTER TABLE {{timezone}} ADD COLUMN [[region_id]] INTEGER');
$this->addForeignKey('fk_timezone_1', 'timezone', 'region_id', 'region', 'id');
// Japan
$this->update('timezone', ['region_id' => Region::findOne(['key' => 'jp'])->id], ['identifier' => 'Asia/Tokyo']);
// Europe/Oceania
$this->update('timezone', ['region_id' => Region::findOne(['key' => 'eu'])->id], ['or like', 'identifier', ['Etc/UTC', 'Europe/%', 'Australia/%'], false]);
// North America
$this->update('timezone', ['region_id' => Region::findOne(['key' => 'na'])->id], ['or like', 'identifier', ['America/%', 'Pacific/Honolulu'], false]);
$this->execute('ALTER TABLE {{timezone}} ALTER COLUMN [[region_id]] SET NOT NULL');
}
public function up()
{
$this->execute('ALTER TABLE {{splatfest}} ADD COLUMN [[order]] INTEGER');
$transaction = \Yii::$app->db->beginTransaction();
$jp = Region::findOne(['key' => 'jp'])->id;
$jpStarts = ['2015-06-13 18:00:00+09', '2015-07-03 15:00:00+09', '2015-07-25 15:00:00+09', '2015-08-22 12:00:00+09', '2015-09-12 12:00:00+09', '2015-10-10 09:00:00+09', '2015-10-31 09:00:00+09', '2015-11-21 12:00:00+09', '2015-12-26 09:00:00+09'];
foreach ($jpStarts as $i => $startAt) {
$this->update('splatfest', ['order' => $i + 1], ['region_id' => $jp, 'start_at' => $startAt]);
}
$transaction->commit();
$this->execute('ALTER TABLE {{splatfest}} ALTER COLUMN [[order]] SET NOT NULL');
$this->createIndex('ix_splatfest_1', 'splatfest', ['region_id', 'order'], true);
}
public function getRegionName()
{
return Region::findOne(['id' => $this->region_id])->title;
}
/**
* Finds the Region model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Region the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Region::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
public function actionMapa($location_id)
{
$location = \app\models\Region::findOne($location_id);
$places = Place::find(['location_id' => $location_id])->all();
return $this->render('mapa', ['location' => $location, 'places' => $places]);
}
public function actionExample()
{
$UrRecords = Ur::findOne(1);
$RegionRecords = [Region::findOne(2), Region::findOne(3)];
$extraColumns = [];
// extra columns to be saved to the many to many table
$unlink = true;
// unlink tags not in the list
$delete = true;
// delete unlinked tags
$UrRecords->linkAll('RegionRecords', $RegionRecords, $extraColumns, $unlink, $delete);
$UrRecords->save();
// var_dump($UrRecords);
// exit;
}
