}
db::insertQuery("update courses set CourseName = '" . $courseName . "', websiteName = '" . $websitename . "', Code = '" . $courseCode . "', Type = '" . $courseType . "', deleted = '0' where CourseID = '" . $courseID . "'");
golog("Updated {$courseID}");
//dlog("Updated $courseID Type P","sync");
}
$locationTotal++;
}
$coursedata = db::runQuery("select * from courses");
db::insertQuery("update events set enrolmentOpen = '0', processed = '0', active = '0'");
golog("Set all events to processing and non active");
dlog("Marking all events as not open, not processed and not active.", "sync");
foreach ($coursedata as $course) {
$courseType = $course['Type'];
$courseID = intval($course['CourseID']);
$url = axcelerate_get_url() . "/api/course/instances?type=" . $courseType . "&id=" . $courseID;
$courses = getAXData($url);
if ($courseID == "9137") {
//var_dump($url);
//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);
function axcelerate_getInvoice($invoiceID)
{
$contactVars = array('invoiceID' => $invoiceID);
$contactVars = array();
$url = axcelerate_get_url() . "/api/accounting/invoice/" . $invoiceID;
return getAXData($url, $contactVars);
}
