private function getIsOldWinIkalogAsAtTheTime($t) { if (!preg_match('/^([0-9a-f]{7,})_/', $this->version, $match)) { // なんかおかしい return false; } $ikalog = IkalogVersion::findOneByRevision($match[1]); if (!$ikalog) { // 知らない WinIkaLog だった return false; } if (empty($ikalog->winikalogVersions)) { // なぜか WinIkaLog のリリースされてないリビジョンっぽい(たぶん新しすぎて認識できてない) return $this->getIsOldCliIkalogAsAtTheTimeImpl($ikalog, $t); } $thisWinIkaLog = $ikalog->winikalogVersions[0]; if (static::$latestWinIkaLog === null) { static::$latestWinIkaLog = WinikalogVersion::find()->andWhere(['<=', '{{winikalog_version}}.[[build_at]]', date('Y-m-d H:i:sP', $t)])->orderBy('{{winikalog_version}}.[[build_at]] DESC')->limit(1)->one(); } if (static::$latestWinIkaLog->id === $thisWinIkaLog->id) { // これより新しいバージョンは存在しない return false; } $diff = $t - strtotime($thisWinIkaLog->build_at); return $diff >= 21 * 86400; }
public function actionUpdateWinikalog() { $htmlPath = Yii::getAlias('@app/runtime/ikalog/winikalog.html'); $list = $this->parseWinikalogHtml($htmlPath); $transaction = Yii::$app->db->beginTransaction(); foreach ($list as $winInfo) { $ikalog = IkalogVersion::findOneByRevision($winInfo->revision); if (!$ikalog) { continue; } if (!($winikalog = WinikalogVersion::findOne(['revision_id' => $ikalog->id]))) { echo "New WinIkaLog " . $winInfo->revision . " found.\n"; $winikalog = new WinikalogVersion(); $winikalog->revision_id = $ikalog->id; $winikalog->build_at = date('Y-m-d H:i:sO', $winInfo->at); $winikalog->save(); } } $transaction->commit(); }
/** * @return \yii\db\ActiveQuery */ public function getWinikalogVersions() { return $this->hasMany(WinikalogVersion::className(), ['revision_id' => 'id']); }