* INCLUSIONE SPECIFICA PER PAYPAL
*/
if (file_exists(ROOT_DIR . '/browsing/paypal/paypal_conf.inc.php')) {
require_once ROOT_DIR . '/browsing/paypal/paypal_conf.inc.php';
$paypal_allowed = TRUE;
}
$today_date = today_dateFN();
$providerId = DataValidator::is_uinteger($_GET['provider']);
$courseId = DataValidator::is_uinteger($_GET['course']);
$instanceId = DataValidator::is_uinteger($_GET['instance']);
$studentId = DataValidator::is_uinteger($_GET['student']);
$testerInfoAr = $common_dh->get_tester_info_from_id($providerId, 'AMA_FETCH_ASSOC');
if (!AMA_Common_DataHandler::isError($testerInfoAr)) {
$provider_name = $testerInfoAr[1];
$tester = $testerInfoAr[10];
$tester_dh = AMA_DataHandler::instance(MultiPort::getDSN($tester));
$currentTesterId = $newTesterId;
$GLOBALS['dh'] = $tester_dh;
$dh = $tester_dh;
/*
* GESTIONE LOG
*/
$logStr = "";
$log_file = ROOT_DIR . '/browsing/paypal/' . PAYPAL_IPN_LOG;
$logFd = fopen($log_file, "a");
$fpx = fopen($log_file, 'a');
$debug = 1;
if ($debug == 1) {
fwrite($fpx, "INIZIO processo Confirm \n");
fwrite($fpx, "Student: {$studentId} \n");
}
require_once ROOT_DIR . '/include/module_init.inc.php';
$self = whoami();
require_once 'include/browsing_functions.inc.php';
$courseInstances = array();
$serviceProviders = $userObj->getTesters();
/**
* change the two below call to active to let the closed
* instances completely disappear from the HTML table
*/
if (count($serviceProviders) == 1) {
$provider_dh = AMA_DataHandler::instance(MultiPort::getDSN($serviceProviders[0]));
// $courseInstances = $provider_dh->get_course_instances_active_for_this_student($userObj->getId());
$courseInstances = $provider_dh->get_course_instances_for_this_student($userObj->getId(), true);
} else {
foreach ($serviceProviders as $Provider) {
$provider_dh = AMA_DataHandler::instance(MultiPort::getDSN($Provider));
// $courseInstances_provider = $provider_dh->get_course_instances_active_for_this_student($userObj->getId());
$courseInstances_provider = $provider_dh->get_course_instances_for_this_student($userObj->getId(), true);
$courseInstances = array_merge($courseInstances, $courseInstances_provider);
}
}
if (!AMA_DataHandler::isError($courseInstances)) {
/**
* @author giorgio 23/apr/2015
*
* filter course instance that are associated to a level of service having nonzero
* value in isPublic, so that all instances of public courses will not be shown here
*/
$courseInstances = array_filter($courseInstances, function ($courseInstance) {
if (is_null($courseInstance['tipo_servizio'])) {
$courseInstance['tipo_servizio'] = DEFAULT_SERVICE_TYPE;
protected static function fillAddressBook(ADALoggableUser $userObj, $user_types_Ar = array())
{
$user_type = $userObj->getType();
$common_dh = $GLOBALS['common_dh'];
$dh = $GLOBALS['dh'];
// this tells get_users_by_type method to get nome, cognome....
$retrieve_extended_data = true;
if (!is_array($user_types_Ar[$user_type]) || empty($user_types_Ar[$user_type])) {
return FALSE;
}
switch ($user_type) {
case AMA_TYPE_ADMIN:
/*
* Ottieni tutti i practitioner, gli autori e gli switcher da tutti i
* tester
*/
// FIXME: differisce dagli altri casi !!!
$users[] = $common_dh->get_users_by_type($user_types_Ar[AMA_TYPE_ADMIN], $retrieve_extended_data);
if (AMA_Common_DataHandler::isError($users)) {
// Gestione errore
}
break;
case AMA_TYPE_SWITCHER:
/*
* Ottieni tutti i practitioner e gli utenti dal suo tester
*/
$tester = $userObj->getDefaultTester();
$tester_dh = AMA_DataHandler::instance(MultiPort::getDSN($tester));
$tester_info_Ar = $common_dh->get_tester_info_from_pointer($tester);
$tester_name = $tester_info_Ar[1];
$users[$tester_name] = $tester_dh->get_users_by_type($user_types_Ar[AMA_TYPE_SWITCHER], $retrieve_extended_data);
if (AMA_Common_DataHandler::isError($users)) {
$users[$tester_name] = array();
}
/*
* Ottiene tutti i practitioner presenti sul tester
*/
// $practitioners_Ar = $tester_dh->get_users_by_type(array(AMA_TYPE_TUTOR), $retrieve_extended_data);
// if(AMA_DataHandler::isError($practitioners_Ar) || !is_array($practitioners_Ar)) {
// $practitioners_Ar = array();
// }
/*
* Ottiene tutti gli utenti che hanno richiesto un servizio sul tester
* e che sono in attesa di assegnamento ad un practitioner
*/
// $users_Ar = $tester_dh->get_registered_students_without_tutor();
// if(AMA_DataHandler::isError($users_Ar) || !is_array($users_Ar)) {
// $users_Ar = array();
// }
// $users[$tester_name] = array_merge($practitioners_Ar, $users_Ar);
break;
case AMA_TYPE_TUTOR:
/*
* Ottieni lo switcher del suo tester, gli utenti con i quali è in relazione,
* eventualmente gli altri practitioner sul suo tester
*/
$tester = $userObj->getDefaultTester();
$tester_dh = AMA_DataHandler::instance(MultiPort::getDSN($tester));
$tester_info_Ar = $common_dh->get_tester_info_from_pointer($tester);
$tester_name = $tester_info_Ar[1];
if (in_array(AMA_TYPE_STUDENT, $user_types_Ar[$user_type])) {
/*
* STUDENTS
*/
// $users[$tester_name] = $tester_dh->get_list_of_tutored_users($userObj->id_user);
if (!$userObj->isSuper()) {
$students_Ar = $tester_dh->get_list_of_tutored_unique_users($userObj->id_user);
} else {
$students_Ar = $tester_dh->get_users_by_type(array(AMA_TYPE_STUDENT), $retrieve_extended_data);
}
// $users[$tester_name] = $tester_dh->get_users_by_type($user_types_Ar[AMA_TYPE_TUTOR], $retrieve_extended_data);
if (AMA_DataHandler::isError($students_Ar) || !is_array($students_Ar)) {
$students_Ar = array();
}
} else {
$students_Ar = array();
}
if (in_array(AMA_TYPE_TUTOR, $user_types_Ar[$user_type])) {
/*
* TUTORS
*/
$tutors_Ar = $tester_dh->get_users_by_type(array(AMA_TYPE_TUTOR), $retrieve_extended_data);
if (AMA_DataHandler::isError($tutors_Ar) || !is_array($tutors_Ar)) {
$tutors_Ar = array();
}
} else {
$tutors_Ar = array();
}
if (in_array(AMA_TYPE_SWITCHER, $user_types_Ar[$user_type])) {
/*
* SWITCHERS
*/
$switchers_Ar = $tester_dh->get_users_by_type(array(AMA_TYPE_SWITCHER), $retrieve_extended_data);
if (AMA_DataHandler::isError($switchers_Ar) || !is_array($switchers_Ar)) {
$switchers_Ar = array();
}
} else {
$switchers_Ar = array();
}
$users[$tester_name] = array_merge($tutors_Ar, $students_Ar, $switchers_Ar);
break;
case AMA_TYPE_STUDENT:
/*
* Se sono all'interno di un tester, vedo solo i practitioner di questo
* tester con i quali sono in relazione
* Se sono nella home dell'utente, vedo tutti i practitioner di tutti i
* tester con i quali sono in relazione
*
* Come faccio a capirlo qui? posso Verificare che sess_selected_tester == ADA_DEFAULT_TESTER
*/
if (MultiPort::isUserBrowsingThePublicTester()) {
// home di user o navigazione nei contenuti pubblici
$testers = $userObj->getTesters();
foreach ($userObj->getTesters() as $tester) {
if ($tester != ADA_PUBLIC_TESTER or count($testers) == 1) {
$tester_dh = AMA_DataHandler::instance(MultiPort::getDSN($tester));
$tester_info_Ar = $common_dh->get_tester_info_from_pointer($tester);
$tester_name = $tester_info_Ar[1];
$tutors_Ar = $tester_dh->get_tutors_for_student($userObj->getId());
if (AMA_DataHandler::isError($tutors_Ar) || !is_array($tutors_Ar)) {
$tutors_Ar = array();
}
$tutors_Ar = array_unique($tutors_Ar, SORT_REGULAR);
$switcher_Ar = $tester_dh->get_users_by_type(array(AMA_TYPE_SWITCHER), $retrieve_extended_data);
if (AMA_DataHandler::isError($switcher_Ar) || !is_array($switcher_Ar)) {
$switcher_Ar = array();
}
/*
* OTHER STUDENTS RELATED TO USER
*/
$subscribed_instances = $tester_dh->get_id_course_instances_for_this_student($userObj->getId());
$students_Ar = $tester_dh->get_unique_students_for_course_instances($subscribed_instances);
if (AMA_DataHandler::isError($students_Ar) || !is_array($students_Ar)) {
$students_Ar = array();
}
/*
foreach ($subscribed_instances as $subscribed_instance) {
$subscribed_instance_id = $subscribed_instance['id_istanza_corso'];
$students_Ar = array_merge($tester_dh->get_students_for_course_instance($subscribed_instance_id));
}
*
*/
$users[$tester_name] = array_merge($tutors_Ar, $switcher_Ar, $students_Ar);
}
}
} else {
$tester = $_SESSION['sess_selected_tester'];
$tester_info_Ar = $common_dh->get_tester_info_from_pointer($tester);
$tester_name = $tester_info_Ar[1];
$tester_dh = AMA_DataHandler::instance(MultiPort::getDSN($tester));
/*
* GET TUTORS OF TESTER
*/
$tutors_Ar = $tester_dh->get_tutors_for_student($userObj->getId());
if (AMA_DataHandler::isError($tutors_Ar) || !is_array($tutors_Ar)) {
$tutors_Ar = array();
}
$tutors_Ar = array_unique($tutors_Ar, SORT_REGULAR);
/*
* GET SWITCHER OF TESTER
*/
$switcher_Ar = $tester_dh->get_users_by_type(array(AMA_TYPE_SWITCHER), $retrieve_extended_data);
if (AMA_DataHandler::isError($switcher_Ar) || !is_array($switcher_Ar)) {
$switcher_Ar = array();
}
/*
* OTHER STUDENTS RELATED TO USER
*/
$subscribed_instances = $tester_dh->get_id_course_instances_for_this_student($userObj->getId());
$students_Ar = $tester_dh->get_unique_students_for_course_instances($subscribed_instances);
if (AMA_DataHandler::isError($students_Ar) || !is_array($students_Ar)) {
$students_Ar = array();
}
$users[$tester_name] = array_merge($tutors_Ar, $switcher_Ar, $students_Ar);
}
break;
case AMA_TYPE_AUTHOR:
default:
return FALSE;
}
return $users;
}
/**
* calls and sets the parent instance method, and if !MULTIPROVIDER
* checks if module_login_providers table is in the provider db.
*
* If found, use the provider DB else use the common
*
* @param string $dsn
*/
static function instance($dsn = null)
{
if (!MULTIPROVIDER && is_null($dsn)) {
$dsn = MultiPort::getDSN($GLOBALS['user_provider']);
}
$theInstance = parent::instance($dsn);
if (is_null(self::$dbToUse)) {
self::$dbToUse = AMA_Common_DataHandler::instance();
if (!MULTIPROVIDER && !is_null($dsn)) {
// must check if passed $dsn has the module login tables
// execute this dummy query, if result is not an error table is there
$sql = 'SELECT NULL FROM `' . self::$PREFIX . 'providers`';
// must use AMA_DataHandler because we are not able to
// query AMALoginDataHandelr in this method!
$ok = AMA_DataHandler::instance($dsn)->getOnePrepared($sql);
if (!AMA_DB::isError($ok)) {
self::$dbToUse = $theInstance;
}
}
}
return $theInstance;
}
function get_subscription($id_user)
{
/*
* troppo lenta....
*/
// versione che cicla sulle iscrizioni ad un servizio
$common_dh = $GLOBALS['common_dh'];
// servizio
$service_courseAr = $common_dh->get_service_implementors();
// corso
foreach ($service_courseAr as $service_implementor) {
$id_service = $service_implementor['id_servizio'];
$id_course = $service_implementor['id_corso'];
//tester
$providerId = get_tester_for_service($id_service);
$provider_dataHa = $common_dh->get_tester_info_from_id($id_tester);
$provider_pointer = $provider_dataHa[11];
$provider_dsn = Multiport::getDSN($provider_pointer);
if ($provider_dsn != null) {
$provider_dh = AMA_DataHandler::instance($provider_dsn);
// istanze per corso
$all_instance = $provider_dh->get_course_instance_for_this_student_and_course_model($id_user, $id_course);
//...
}
}
}
public static function findImplementor($implementorId)
{
$common_dh = $GLOBALS['common_dh'];
//$provider_dataHa = $common_dh->get_tester_info_from_id($id_provider);
$provider_dataHa = $common_dh->get_tester_info_from_id_course($implementorId);
if (AMA_DataHandler::isError($provider_dataHa)) {
// ?
} else {
$provider_dsn = Multiport::getDSN($provider_dataHa['puntatore']);
if ($provider_dsn != null) {
$provider_dh = AMA_DataHandler::instance($provider_dsn);
if (AMA_DataHandler::isError($provider_dh)) {
return $provider_dh;
} else {
$courseAr = $provider_dh->get_course($implementorId);
if (AMA_DataHandler::isError($courseAr)) {
// continue
$courseAr = array();
$courseAr['id_course'] = $implementorId;
} else {
if (!isset($courseAr['id_nodo_iniziale'])) {
$courseAr['id_nodo_iniziale'] = 0;
}
$id_start_node = $courseAr['id_nodo_iniziale'];
$id_desc = $implementorId . "_" . $id_start_node;
$user_level = "999";
$nodeHa = $provider_dh->get_node_info($id_desc);
if (AMA_DataHandler::isError($nodeHa)) {
// continue
$nodeHa = array();
$nodeHa['text'] = NULL;
}
}
}
}
}
$serviceImplementorObj = new Service_implementor($provider_dataHa, $courseAr, $nodeHa);
return $serviceImplementorObj;
}
if (AMA_Common_DataHandler::isError($tester_infoAr)) {
$errObj = new ADA_Error($tester_infoAr);
} else {
$testersAr = array();
$tester_dataAr = array(array(translateFN('id'), $tester_infoAr[0]), array(translateFN('Nome'), $tester_infoAr[1]), array(translateFN('Ragione Sociale'), $tester_infoAr[2]), array(translateFN('Indirizzo'), $tester_infoAr[3]), array(translateFN('Città'), $tester_infoAr[4]), array(translateFN('Provincia'), $tester_infoAr[5]), array(translateFN('Nazione'), $tester_infoAr[6]), array(translateFN('Telefono'), $tester_infoAr[7]), array(translateFN('E-mail'), $tester_infoAr[8]), array(translateFN('Descrizione'), $tester_infoAr[11]), array(translateFN('Responsabile'), $tester_infoAr[9]), array(translateFN('Puntatore al database'), $tester_infoAr[10]));
//$tester_data = BaseHtmlLib::tableElement('',array(),$tester_dataAr);
$tester_data = AdminModuleHtmlLib::displayTesterInfo($id_tester, $tester_dataAr);
$services_dataAr = $common_dh->get_info_for_tester_services($id_tester);
if (AMA_Common_DataHandler::isError($services_dataAr)) {
$errObj = new ADA_Error($services_dataAr);
} else {
$tester_services = AdminModuleHtmlLib::displayServicesOnThisTester($id_tester, $services_dataAr);
}
$tester_dsn = MultiPort::getDSN($tester_infoAr[10]);
if ($tester_dsn != NULL) {
$tester_dh = AMA_DataHandler::instance($tester_dsn);
$users_on_this_tester = $tester_dh->count_users_by_type(array(AMA_TYPE_STUDENT, AMA_TYPE_AUTHOR, AMA_TYPE_TUTOR, AMA_TYPE_SWITCHER, AMA_TYPE_ADMIN));
if (AMA_DataHandler::isError($users_on_this_tester)) {
$errObj = new ADA_Error($users_on_this_tester);
} else {
$users_list_link = CDOMElement::create('div', 'id:tester_users');
$users_list_link->addChild(new CText(translateFN('Numero di utenti presenti sul tester: ') . $users_on_this_tester));
$link = CDOMElement::create('a', 'href:list_users.php?id_tester=' . $id_tester);
$link->addChild(new CText(translateFN('Lista utenti')));
$users_list_link->addChild($link);
}
}
}
} else {
/*
* non e' stato passato id_tester
/**
*
* @param $id_course_instance
* @return array
*/
private function _get_last_accessFN($id_course_instance = "", $provider_dh, $return_dateonly = true)
{
// if used by student before entering a course, we must pass the DataHandler
if ($provider_dh == NULL) {
$provider_dh = $GLOBALS['dh'];
}
//$error = $GLOBALS['error'];
// $debug = $GLOBALS['debug'];
$sess_id_user = $_SESSION['sess_id_user'];
if (!isset($this->id_user)) {
$id_user = $sess_id_user;
} else {
$id_user = $this->id_user;
}
if ($id_course_instance) {
$last_visited_node = $provider_dh->get_last_visited_nodes($id_user, $id_course_instance, 10);
/*
* vito, 10 ottobre 2008: $last_visited_node è Array([0]=>Array([id_nodo], ...))
*/
if (!AMA_DB::isError($last_visited_node) && is_array($last_visited_node) && isset($last_visited_node[0])) {
$last_visited_time = $return_dateonly ? AMA_DataHandler::ts_to_date($last_visited_node[0]['data_uscita']) : $last_visited_node[0]['data_uscita'];
return array($last_visited_node[0]['id_nodo'], $last_visited_time);
} else {
return "-";
}
} else {
/*
* Sara, 2/07/2014
* return the last access between all instances course
*/
$serviceProviders = $this->getTesters();
if (!empty($serviceProviders) && is_array($serviceProviders)) {
$i = 0;
foreach ($serviceProviders as $Provider) {
$provider_dh = AMA_DataHandler::instance(MultiPort::getDSN($Provider));
$courseInstances_provider = $provider_dh->get_course_instances_for_this_student($this->getId());
if (AMA_DataHandler::isError($courseInstances_provider)) {
$courseInstances_provider = new ADA_Error($courseInstances_provider);
} else {
$istance_testerAr[$i] = array('istances' => $courseInstances_provider, 'provider' => $Provider);
}
$i++;
}
}
if (!empty($istance_testerAr)) {
$Max = 0;
$id_nodo = null;
foreach ($istance_testerAr as $istanceTs) {
$courseInstancesAr = $istanceTs['istances'];
$pointer = $istanceTs['provider'];
$tester = AMA_DataHandler::instance(MultiPort::getDSN($pointer));
foreach ($courseInstancesAr as $courseInstance) {
$id_instance = $courseInstance['id_istanza_corso'];
$last_access = $tester->get_last_visited_nodes($id_user, $id_instance, 10);
if (!AMA_DB::isError($last_access) && is_array($last_access) && count($last_access)) {
$last_accessAr = array($last_access[0]['id_nodo'], $last_access[0]['data_uscita']);
if ($last_accessAr[1] > $Max) {
$id_nodo = $last_accessAr[0];
$Max = $last_accessAr[1];
}
}
}
}
$Last_accessAr = array(0 => $id_nodo, 1 => $Max);
return $Last_accessAr;
} else {
return "-";
}
}
}
public function disconnect()
{
parent::disconnect();
self::$instance = NULL;
}
/**
* checks if the passed object type and id are coming from the public tester.
* If true sets the needed GLOBALS['dh'] session variables accordingly.
*
* @param string $objType either 'course' or 'node'
* @param string $objID object id to be checked and loaded if need be
*
* return true if invalid has to be set to true on the caller
*/
function checkAndSetPublicTester($objType, $objID)
{
$common_dh = $GLOBALS['common_dh'];
if ($objType !== 'course' || is_null($objID)) {
$tmp_id_course = isset($_REQUEST['id_course']) ? DataValidator::is_uinteger($_REQUEST['id_course']) : false;
if ($tmp_id_course === false) {
$tmp_id_course = isset($_REQUEST['id_node']) ? substr($_REQUEST['id_node'], 0, strpos($_REQUEST['id_node'], '_')) : false;
}
if ($tmp_id_course === false) {
$tmp_id_course = isset($_SESSION['sess_id_course']) ? DataValidator::is_uinteger($_SESSION['sess_id_course']) : false;
}
if ($tmp_id_course === false) {
$tmp_id_course = isset($_SESSION['sess_id_node']) ? substr($_SESSION['sess_id_node'], 0, strpos($_SESSION['sess_id_node'], '_')) : false;
}
} else {
$tmp_id_course = $objID;
}
if ($tmp_id_course !== false) {
// get the tester for the passed id_course
$tester_infoAr = $common_dh->get_tester_info_from_id_course($tmp_id_course);
// get the service info for the passed id_course
$service_inforAr = $common_dh->get_service_type_info_from_course($tmp_id_course);
// check that the tester is valid and is the public one and
// check that the service is valid and is a public one
if (!AMA_DB::isError($tester_infoAr) && is_array($tester_infoAr) && isset($tester_infoAr['puntatore']) && $tester_infoAr['puntatore'] == ADA_PUBLIC_TESTER && !AMA_DB::isError($service_inforAr) && is_array($service_inforAr) && isset($service_inforAr['isPublic']) && intval($service_inforAr['isPublic']) !== 0) {
// save the dh, if a restrore is needed afterwards
$olddh = $GLOBALS['dh'];
// load the dh
$dh = AMA_DataHandler::instance(MultiPort::getDSN($tester_infoAr['puntatore']));
if (!AMA_DB::isError($dh)) {
// check the object
if ($objType == 'node') {
$dataHa = $dh->get_node_info($objID);
if (AMA_DB::isError($dataHa) || !is_array($dataHa)) {
$retval = true;
// restore the saved datahandler
$GLOBALS['dh'] = $olddh;
} else {
$retval = false;
// set the datahandler
$GLOBALS['dh'] = $dh;
$_SESSION['sess_id_node'] = $objID;
$_SESSION['sess_id_course'] = $tmp_id_course;
}
} else {
if ($objType == 'course') {
// set the datahandler
$GLOBALS['dh'] = $dh;
$sess_courseObj = read_course($objID);
if (AMA_DB::isError($sess_courseObj) || !$sess_courseObj instanceof Course) {
$retval = true;
// restore the saved datahandler
$GLOBALS['dh'] = $olddh;
} else {
$retval = false;
$_SESSION['sess_courseObj'] = $sess_courseObj;
$_SESSION['sess_id_course'] = $objID;
}
}
}
}
}
}
return isset($retval) ? $retval : true;
}
public static function log_report($pointer = NULL, $Services_Type = NULL)
{
$log_dataAr = array();
$common_dh = $GLOBALS['common_dh'];
$filedArray = array('nome', 'ragione_sociale');
if (isset($pointer)) {
$testers_list = $common_dh->get_tester_info_from_pointer($pointer);
if (!AMA_DB::isError($testers_list)) {
$tester_name = $testers_list[1];
$tester = $pointer;
$tester_dsn = self::getDSN($tester);
if ($tester_dsn != null) {
$tester_dh = AMA_DataHandler::instance($tester_dsn);
$result = $tester_dh->tester_log_report($tester_name, null);
if (!AMA_DB::isError($result)) {
$result['provider'] = $tester_name;
$log_dataAr[$tester] = $result;
}
}
}
} else {
$testers_list = $common_dh->get_all_testers($filedArray);
if (!AMA_DB::isError($testers_list)) {
foreach ($testers_list as $testerAr) {
$tester_name = $testerAr['nome'];
$tester = $testerAr['puntatore'];
$tester_dsn = self::getDSN($tester);
if ($tester_dsn != null) {
$tester_dh = AMA_DataHandler::instance($tester_dsn);
$result = $tester_dh->tester_log_report($tester_name, $Services_Type);
if (!AMA_DB::isError($result)) {
$result['provider'] = $tester_name;
$log_dataAr[$tester] = $result;
}
}
}
}
}
return $log_dataAr;
}
/**
* Sets the terminated status for the passed courseId and courseInstanceId
* It is usually called from user.php when the user has a subscried status
* and the subscription_date + duration_subscription is in the past.
*
* @param number $courseId
* @param number $courseInstanceId
*
* @return AMA_Error on error or true on success
*
* @access public
*
* @author giorgio 03/apr/2015
*/
public function setTerminatedStatusForInstance($courseId, $courseInstanceId)
{
$common_dh = $GLOBALS['common_dh'];
require_once ROOT_DIR . '/switcher/include/Subscription.inc.php';
$s = new Subscription($this->getId(), $courseInstanceId);
$s->setSubscriptionStatus(ADA_STATUS_TERMINATED);
$s->setStartStudentLevel(null);
// null means no level update
// search the provider of the current iteration course
$courseProv = $common_dh->get_tester_info_from_id_course($courseId);
if (!AMA_DB::isError($courseProv) && is_array($courseProv) && isset($courseProv['puntatore'])) {
// save the datahandler
$savedDH = $GLOBALS['dh'];
// set the datahandler to be used
$GLOBALS['dh'] = AMA_DataHandler::instance(MultiPort::getDSN($courseProv['puntatore']));
// update the subscription
$retval = Subscription::updateSubscription($s);
// restore the datahandler
$GLOBALS['dh'] = $savedDH;
$GLOBALS['dh']->disconnect();
}
return isset($retval) ? $retval : null;
}
