public static function refreshAccessToken()
{
$tableName = MGh::tableName();
$gh_ids = Yii::$app->db->createCommand("SELECT gh_id FROM {$tableName}")->queryColumn();
foreach ($gh_ids as $gh_id) {
Yii::$app->wx->clearGh();
Yii::$app->wx->setGhId($gh_id);
//U::W(['old', $gh_id, Yii::$app->wx->getAccessToken()]);
Yii::$app->wx->getAccessToken(true);
//U::W(['new', $gh_id, Yii::$app->wx->getAccessToken()]);
}
}
public function getGh()
{
if ($this->_gh !== null) {
return $this->_gh;
}
if (empty($this->_gh_id) && empty($this->_appid)) {
U::W(debug_backtrace());
U::D("gh_id and appid can can not be empty at the same time!");
}
$db = \Yii::$app->db;
$tableName = \app\models\MGh::tableName();
if (!empty($this->_gh_id)) {
$command = $db->createCommand("SELECT * FROM {$tableName} WHERE gh_id=:gh_id", [':gh_id' => $this->_gh_id]);
} else {
$command = $db->createCommand("SELECT * FROM {$tableName} WHERE appid=:appid", [':appid' => $this->_appid]);
}
//$db->beginCache(YII_DEBUG ? 10 : 3600);
$row = $command->queryOne();
//$db->endCache();
if ($row === false) {
U::D("no exists in db!, gh_id={$this->_gh_id}, appid={$this->_appid}");
}
$this->_gh = $row;
return $row;
}
