static function find($search_id)
{
$found_site = '';
$sites = Sites::getAll();
foreach ($sites as $site) {
// $site_id = $site->getId();
if ($id === $search_id) {
$found_site = $site;
print_r($found_site);
return $found_site;
}
}
}
//setting up connection to our database
$DB = new PDO($server, $username, $password);
//Throw an exception when an error is encountered in the query
$DB->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$DB->exec("SET NAMES 'utf8'");
} catch (Exception $e) {
echo "Could not connect to the database";
exit;
}
$app = new Silex\Application();
$app["debug"] = true;
$app->register(new Silex\Provider\TwigServiceProvider(), array('twig.path' => __DIR__ . '/../../views'));
use Symfony\Component\HttpFoundation\Request;
Request::enableHttpMethodParameterOverride();
/**
* Routing to twig templete views
*/
$app->get("/", function () use($app) {
return $app['twig']->render('index.html.twig', array('sites' => Sites::getAll()));
});
$app->get('/site/{id}', function ($id) use($app) {
$sites = Sites::getAll();
function name($sites, $id)
{
$id = $id - 1;
return $sites[$id];
}
$sites = name($sites, $id);
return $app['twig']->render('site.html.twig', array('sites' => $sites, 'analytics' => ReturnedAnalytics::getAll($id)));
});
return $app;
// Read the generated client_secrets.p12 key.
$cred = new Google_Auth_AssertionCredentials($service_account_email, array(Google_Service_Analytics::ANALYTICS_READONLY), $key);
$client->setAssertionCredentials($cred);
if ($client->getAuth()->isAccessTokenExpired()) {
$client->getAuth()->refreshTokenWithAssertion($cred);
}
return $analytics;
}
/**
* Get Analytics API instance
*/
$analytics = getService($google_account['email'], $google_account['key']);
/**
* Gets objects from the site table
*/
$site_details = Sites::getAll();
$site_details_length = sizeof($site_details);
if ($site_details_length <= 0) {
trigger_error('Size of site_details_length must be greater than zero', E_USER_NOTICE);
error_log($today . "The sites tables has return zero sites from the database \n", 3, __DIR__ . "/../../log/error.log");
exit;
}
echo "*******************" . "\n";
echo "* total sites : " . $site_details_length . " *" . "\n";
echo "*******************" . "\n";
/**
* Query the Analytics data.
* date, source, medium,channel_grouping, device_category, landing_page_path, sessions,
* transactions, transaction_revenue, page_views, bounces, session_duration, hits, total_events,
* unique_events, users, entrances, exits
*/
