public static function Create_($massive)
{
$model = new Analytics();
$model->id_campaigns = $massive[5];
$model->id_user = $massive[6];
$model->link = $massive[0];
$model->date = $massive[1];
$model->date_post = time();
if ($model->save()) {
return $model->id;
} else {
return false;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Analytics::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'id_campaigns' => $this->id_campaigns, 'date' => $this->date, 'link' => $this->link, 'date_post' => $this->date_post, 'id_user' => $this->id_user]);
//$query->andFilterWhere(['like', 'informations', $this->informations]);
return $dataProvider;
}
public function actionCron()
{
$client_id = '746431818850-sddh6at9g6o18hbmi82rh13tu2mi3pbg.apps.googleusercontent.com';
$client_secret = 'mz1lOoqB9oslvGZVhoT6KS-V';
$redirect_uri = 'http://insol.madeforpets.com.ua/cron';
$account_id = 'ga:114815562';
session_start();
$_SESSION['oauth_access_token'] = 'ya29.jAK-QzSp8fb_ou3CxnTp2SY_WEZ5aQF5JjxNmu9kpan_C0roaG6I1nFVGlOQJXL94MAU';
$ga = new GoogleAnalyticsAPI();
$ga->auth->setClientId($client_id);
$ga->auth->setClientSecret($client_secret);
$ga->auth->setRedirectUri($redirect_uri);
if (isset($_GET['force_oauth'])) {
$_SESSION['oauth_access_token'] = null;
}
if (!isset($_SESSION['oauth_access_token']) && !isset($_GET['code'])) {
// Go get the url of the authentication page, redirect the client and go get that token!
$url = $ga->auth->buildAuthUrl();
header("Location: " . $url);
}
if (!isset($_SESSION['oauth_access_token']) && isset($_GET['code'])) {
$auth = $ga->auth->getAccessToken($_GET['code']);
if ($auth['http_code'] == 200) {
$accessToken = $auth['access_token'];
$refreshToken = $auth['refresh_token'];
$tokenExpires = $auth['expires_in'];
$tokenCreated = time();
// For simplicity of the example we only store the accessToken
// If it expires use the refreshToken to get a fresh one
$_SESSION['oauth_access_token'] = $accessToken;
} else {
die("Sorry, something wend wrong retrieving the oAuth tokens");
}
}
if (!empty($_SESSION['oauth_access_token'])) {
$ga->setAccessToken($_SESSION['oauth_access_token']);
$ga->setAccountId($account_id);
// Set the default params. For example the start/end dates and max-results
$defaults = array('start-date' => '2016-01-01', 'end-date' => 'today');
$ga->setDefaultQueryParams($defaults);
$params = array('metrics' => 'ga:pageviews,ga:sessionDuration', 'dimensions' => 'ga:pagePath,ga:date,ga:fullReferrer', 'sort' => '-ga:date');
$visits = $ga->query($params);
}
$data = $visits['rows'];
if (isset($data)) {
// проверка на пустоту массива
$mass = $data;
for ($i = 0; $i < count($mass); $i++) {
$result = $this->find_($mass[$i][0]);
if (!($result === false)) {
$id = $this->find_id($mass[$i][0]);
if ($id != '') {
$models = Campaigns::Get_info($id);
$mass[$i][] = (int) $id;
$mass[$i][] = $models->id_user;
}
$new[] = $mass[$i];
}
}
}
for ($i = 0; $i < count($new); $i++) {
$models = Analytics::Get_info($new[$i][1], $new[$i][5]);
if ($models == '') {
$create_ = Analytics::Create_($new[$i]);
if ($create_ != false) {
$create_detail_ = Detail::Create_($new[$i], $create_);
}
} else {
$check_detail = Detail::Get_info($models->id, $new[$i][2]);
if ($check_detail == '') {
$create_detail_ = Detail::Create_($new[$i], $models->id);
} else {
$update_detail_ = Detail::Update_($new[$i], $models->id);
}
}
}
return $this->render('cron', ['data' => $data]);
}
/**
* Finds the Analytics model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Analytics the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Analytics::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
