public static function onContentPrepare()
{
// get database connection
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Select all records.
// Order it by the ordering field.
$query->select($db->quoteName('TeamReportNaam', 'CompName'));
$query->from($db->quoteName('#__knvb_api_team'));
// Reset the query using our newly populated query object.
$db->setQuery($query);
// De database execute is tbv van de regelstellen
$db->execute();
// get the count
$my_count = $db->getNumRows();
if ($my_count < 1) {
jimport('joomla.application.module.helper');
$module = JModuleHelper::getModule('mod_knvbapi2');
$moduleParams = new JRegistry();
$moduleParams->loadString($module->params);
$apikey = $moduleParams->get('apikey');
$baseUrl = $moduleParams->get('dataserviceurl');
$vereniging = $moduleParams->get('vereniging');
$url = $baseUrl . '/initialisatie/' . $vereniging;
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$a = curl_exec($curl);
curl_close($curl);
$json = json_decode($a);
$var = $json->List;
$session_id = $var[0]->PHPSESSID;
function Apicallteam($baseUrl, $url, $session_id, $apikey, $parameters)
{
#hash berekenen
$hash = md5($apikey . '#' . $url . '#' . $session_id);
$curl_url = $baseUrl . $url . $parameters . "&PHPSESSID=" . $session_id . '&hash=' . $hash;
$curl = curl_init();
curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $curl_url, CURLOPT_USERAGENT => 'cURL Request pw', CURLOPT_COOKIESESSION => true));
// echo $curl_url.'<br>';
$resp = curl_exec($curl);
curl_close($curl);
return $resp;
}
// NULL is om de warning missing argument te onderdrukkens
$data = Apicallteam($baseUrl, "/competities", $session_id, $apikey, NULL);
$json = json_decode($data, true);
// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
$json = $json['List'];
foreach ($json as $item) {
$query = "INSERT INTO `#__knvb_api_team`\n (`CompName`\n , `ClassName`\n , `PouleName`\n , `District`\n , `CompId`\n , `ClassId`\n , `PouleId`\n , `CompType`\n , `TeamId`\n , `TeamAanduiding`\n , `TeamReportNaam`\n , `metStand`\n , `Perioden`)\n VALUES ('" . $item['CompName'] . "'\n , '" . $item['ClassName'] . "'\n , '" . $item['PouleName'] . "'\n ,'" . $item['District'] . "'\n ,'" . $item['CompId'] . "'\n ,'" . $item['ClassId'] . "'\n ,'" . $item['PouleId'] . "'\n ,'" . $item['CompType'] . "'\n ,'" . $item['TeamId'] . "'\n ,'" . $item['TeamAanduiding'] . "'\n ,'" . $item['TeamReportNaam'] . "'\n ,'" . $item['metStand'] . "'\n ,'" . $item['Perioden'] . "')";
// Set the query using our newly populated query object and execute it.
$db->setQuery($query);
$db->execute();
}
} else {
$db->setQuery($query);
$column = $db->loadColumn();
// print_r($column);
}
}
$var = $json->List;
$session_id = $var[0]->PHPSESSID;
function Apicallteam($baseUrl, $url, $session_id, $apikey, $parameters)
{
#hash berekenen
$hash = md5($apikey . '#' . $url . '#' . $session_id);
$curl_url = $baseUrl . $url . $parameters . "&PHPSESSID=" . $session_id . '&hash=' . $hash;
$curl = curl_init();
curl_setopt_array($curl, array(CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => $curl_url, CURLOPT_USERAGENT => 'cURL Request pw', CURLOPT_COOKIESESSION => true));
// echo $curl_url.'<br>';
$resp = curl_exec($curl);
curl_close($curl);
return $resp;
}
// NULL is om de warning missing argument te onderdrukkens
$data = Apicallteam($baseUrl, "/competities", $session_id, $apikey, NULL);
$json = json_decode($data, true);
// var_dump($data);
// define event array
$event1 = array('CompName' => $json->CompName, 'ClassName' => $json->owner->ClassName, 'PouleName' => $json->owner->PouleName);
$event2 = '"' . implode(array($event1['CompName'], $event1['ClassName'], $event1['PouleName']), '","') . '"';
// connect to database
$database_connect = mysql_select_db('MY DATABASE', $connect);
if (!$database_connect) {
die('Could not connect - database connection failed: ' . mysql_error());
}
// Insert $event array into database
$db_insert = mysql_query("INSERT INTO events (id, owner_name, owner_cat, owner_id, event_name, event_description, start_time, end_time, location, venue_street, venue_city, venue_state, venue_zip, venue_country, venue_lat, venue_long, venue_id, privacy, updated_time)\n\tVALUES ({$event2})");
if (!$db_insert) {
die('Could not connect - event data insert failed: ' . mysql_error());
}
