public function getKeyOptionsByUserId($id)
{
$keyOptions = array();
$keyOptions[""] = "None";
$allKeyConnections = KeyConnections::find()->where(['owner' => $id])->all();
foreach ($allKeyConnections as $connection) {
if ($connection->text != "") {
$keyOptions[$connection->text] = $connection->name . " - " . $connection->text;
}
}
return $keyOptions;
}
/**
* Creates a new KeyConnections model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new KeyConnections();
if ($model->load(Yii::$app->request->post())) {
$model->owner = Yii::$app->user->identity->id;
//Check if key already exists. If so, just redirect.
if (KeyConnections::find()->where(['text' => $model->text, 'owner' => $model->owner])->exists()) {
return $this->redirect(Yii::$app->request->referrer);
}
$date = new \DateTime();
$model->timestamp = $date->getTimestamp();
if ($model->save(false)) {
return $this->redirect(Yii::$app->request->referrer);
}
}
return $this->render('create', ['model' => $model]);
}
$endMonth = intval(date('m'));
$endYear = intval(date('Y'));
$startMonth = $endMonth;
$startYear = $endYear - 1;
//Draw our graph.
$data = getTweetsForIntervalByUsernameAsArray($user, $startMonth, $startYear, $endMonth, $endYear);
$graph = new GraphWrapper("tweetsOverYear", $data, 'date', ['numTweets'], 'date', ['Tweets']);
echo $graph->getChart();
echo "<br/>";
echo "<p class='lead'>Keys</p>";
echo "<br/>";
$model = new KeyConnections();
echo $this->render('/key-connections/_form', ['model' => $model]);
$userId = User::find()->where(['username' => $user])->one()->id;
//Draw our keys.
$dataProvider = new ActiveDataProvider(['query' => KeyConnections::find()->where(['owner' => $userId])]);
echo GridView::widget(['dataProvider' => $dataProvider, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'name', 'text', ['class' => 'yii\\grid\\ActionColumn', 'controller' => 'key-connections']]]);
?>
</div>
</div>
<?php
class GraphWrapper
{
private $data;
public function hasKey($key)
{
return KeyConnections::find()->where(['owner' => $this->id, 'text' => $key])->exists();
}
