//var_dump($courses); } foreach ($courses as $singlecourse) { $courseID = db::esc($singlecourse->ID); $instanceID = db::esc($singlecourse->INSTANCEID); $locationDataName = db::esc($singlecourse->LOCATION); $startDateTime = db::esc($singlecourse->STARTDATE); $endDateTime = db::esc($singlecourse->FINISHDATE); $courseData = date("Y-m-d", strtotime("" . $startDateTime . "")); //NEDS TO BE DATE OF START DATE $cost = db::esc($singlecourse->COST); $maxparticipants = db::esc($singlecourse->MAXPARTICIPANTS); $totalParticipants = db::esc($singlecourse->PARTICIPANTS); $totalParticipantsVacancy = db::esc($singlecourse->PARTICIPANTVACANCY); $enrolmentOpen = db::esc($singlecourse->ENROLMENTOPEN); golog("Syncing {$instanceID}. EO: {$enrolmentOpen}"); //echo $enrolmentOpen."<br>"; if ($totalParticipantsVacancy <= 0) { $enrolmentOpen = 0; //echo($instanceID); //echo("<br>"); } $locationID = getLocationIDfromDataName($locationDataName); $instance = db::runQuery("select * from events where instanceID = '{$instanceID}'"); if ($instance) { if ($enrolmentOpen == 1) { db::insertQuery("update events set courseID = '{$courseID}', locationID = '{$locationID}', startDateTime = '{$startDateTime}', endDateTime = '{$endDateTime}', courseDate = '{$courseData}', cost = '{$cost}', maxparticipants = '{$maxparticipants}', totalParticipants = '{$totalParticipants}', totalParticipantsVacancy = '{$totalParticipantsVacancy}', enrolmentOpen = '{$enrolmentOpen}', updated = now(), processed = '1', active = '1' where instanceID = '{$instanceID}'"); } else { db::insertQuery("update events set courseID = '{$courseID}', locationID = '{$locationID}', startDateTime = '{$startDateTime}', endDateTime = '{$endDateTime}', courseDate = '{$courseData}', cost = '{$cost}', maxparticipants = '{$maxparticipants}', totalParticipants = '{$totalParticipants}', totalParticipantsVacancy = '{$totalParticipantsVacancy}', enrolmentOpen = '{$enrolmentOpen}', updated = now(), processed = '1', active = '0' where instanceID = '{$instanceID}'"); if (!$instance['enrolmentOpen'] == $enrolmentOpen) { db::insertQuery("insert into log (type,message,instanceID) values('sync','Istance Enrolment Closed','{$instanceID}')");
function getLocationIDfromDataName($locationDataName) { if (isset($_SESSION["" . $locationDataName . ""])) { golog("Cached location " . $locationDataName); return $_SESSION["" . $locationDataName . ""]; } else { golog("Query location " . $locationDataName); $locationDataName = db::esc($locationDataName); $location = db::runQuery("select * from locations where data_location = '{$locationDataName}'"); if ($location) { $_SESSION["" . $locationDataName . ""] = $location[0]['ID']; return $location[0]['ID']; } else { db::insertQuery("insert into locations (LocationName, data_location) values('{$locationDataName}','{$locationDataName}')"); $locationID = db::runQuery("SELECT LAST_INSERT_ID() as ID"); $_SESSION["" . $locationDataName . ""] = $locationID[0]['ID']; return $locationID[0]['ID']; } } }