ILIAS  release_10 Revision v10.1-43-ga1241a92c2f
Public Member Functions | Static Public Member Functions | Private Attributes
ilLTIDataConnector Class Reference
+ Inheritance diagram for ilLTIDataConnector:
+ Collaboration diagram for ilLTIDataConnector:

Public Member Functions

 __construct ()
 ilLTIDataConnector constructor. More...
 
 loadPlatform (Platform|ilLTIPlatform $platform)
 Load platform object. More...
 
 loadGlobalToolConsumerSettings (ilLTIPlatform $platform)
 Load tool consumer settings. More...
 
 lookupRecordIdByGlobalSettingsAndRefId (ilLTIPlatform $platform)
 Load extended tool consumer object with ILIAS extension. More...
 
 saveGlobalToolConsumerSettings (ilLTIPlatform $platform)
 Save platform object. More...
 
 saveToolConsumerILIAS (ilLTIPlatform $platform)
 Save extended tool consumer object with ILIAS extensions. More...
 
 deleteGlobalToolConsumerSettings (ilLTIPlatform $platform)
 Delete global tool consumer settings. More...
 
 deleteToolConsumer (DataConnectorPlatform $platform)
 Delete tool consumer object. More...
 
 getGlobalToolConsumerSettings ()
 Get global consumer settings. More...
 
 getToolConsumers ()
 
 loadContext (Context $context)
 Load context object. More...
 
 saveContext (Context $context)
 Save context object. More...
 
 deleteContext (Context $context)
 Delete context object. More...
 
 loadResourceLink (ResourceLink $resourceLink)
 Load resource link object. More...
 
 saveResourceLink (ResourceLink $resourceLink)
 Save resource link object. More...
 
 deleteResourceLink (ResourceLink $resourceLink)
 Delete resource link object. More...
 
 getUserResultSourcedIDsResourceLink (ResourceLink $resourceLink, bool $localOnly, ?IdScope $idScope)
 Get array of user objects. More...
 
 loadPlatformNonce (PlatformNonce $nonce)
 Get array of shares defined for this resource link. More...
 
 savePlatformNonce (PlatformNonce $nonce)
 Save nonce object. More...
 
 loadResourceLinkShareKey (ResourceLinkShareKey $shareKey)
 Load resource link share key object. More...
 
 saveResourceLinkShareKey (ResourceLinkShareKey $shareKey)
 Save resource link share key object. More...
 
 deleteResourceLinkShareKey (ResourceLinkShareKey $shareKey)
 Delete resource link share key object. More...
 
 loadUserResult (User $userresult)
 Load user object. More...
 
 saveUserResult (User $userresult)
 Save user object. More...
 
 deleteUser (DataConnectorUser $user)
 Delete user object. More...
 
 lookupResourcesForUserObjectRelation (int $a_ref_id, string $a_lti_user, int $a_ext_consumer, ilDateTime $since=null)
 Lookup resources for user object relation. More...
 
 lookupResourcesForAllUsersSinceDate (ilDateTime $since)
 

Static Public Member Functions

static getDataConnector (mixed $db=null, string $dbTableNamePrefix='', string $type='')
 

Private Attributes

ilLogger $logger = null
 
ilDBInterface $database
 

Detailed Description

Definition at line 31 of file class.ilLTIDataConnector.php.

Constructor & Destructor Documentation

◆ __construct()

ilLTIDataConnector::__construct ( )

ilLTIDataConnector constructor.

Definition at line 40 of file class.ilLTIDataConnector.php.

References $DIC, ilLoggerFactory\getLogger(), and ILIAS\Repository\logger().

41  {
42  global $DIC;
43  $this->database = $DIC->database();
44 
45  $this->logger = ilLoggerFactory::getLogger('ltis');
46  $this->db = null;
47  $this->dbTableNamePrefix = "";
48  }
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:90
$DIC
global $DIC
Definition: shib_login.php:25
+ Here is the call graph for this function:

Member Function Documentation

◆ deleteContext()

ilLTIDataConnector::deleteContext ( Context  $context)

Delete context object.

Parameters
Context$contextContext object
Returns
boolean True if the Context object was successfully deleted

Definition at line 1031 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1031  : bool
1032  {
1033  $ilDB = $this->database;
1034 
1035  // Delete any outstanding share keys for resource links for this context
1036  $query = 'DELETE sk ' .
1037  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . ' sk ' .
1038  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON sk.resource_link_pk = rl.resource_link_pk ' .
1039  'WHERE rl.context_pk = %s';
1040  $types = array("integer");
1041  $values = array($context->getRecordId());
1042  $ilDB->manipulateF($query, $types, $values);
1043 
1044  // Delete any users in resource links for this context
1045  $query = 'DELETE u ' .
1046  "FROM {$this->dbTableNamePrefix}" . DataConnector::USER_RESULT_TABLE_NAME . ' u ' .
1047  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON u.resource_link_pk = rl.resource_link_pk ' .
1048  'WHERE rl.context_pk = %s';
1049  $types = array("integer");
1050  $values = array($context->getRecordId());
1051  $ilDB->manipulateF($query, $types, $values);
1052 
1053  // Update any resource links for which this consumer is acting as a primary resource link
1054  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' prl ' .
1055  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON prl.primary_resource_link_pk = rl.resource_link_pk ' .
1056  'SET prl.primary_resource_link_pk = null, prl.share_approved = null ' .
1057  'WHERE rl.context_pk = %s';
1058  $types = array("integer");
1059  $values = array($context->getRecordId());
1060  $ilDB->manipulateF($query, $types, $values);
1061 
1062  // Delete any resource links for this consumer
1063  $query = 'DELETE rl ' .
1064  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ' .
1065  'WHERE rl.context_pk = %s';
1066  $types = array("integer");
1067  $values = array($context->getRecordId());
1068  $ilDB->manipulateF($query, $types, $values);
1069 
1070  // Delete context
1071  $query = 'DELETE c ' .
1072  "FROM {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ' .
1073  'WHERE c.context_pk = %s';
1074  $types = array("integer");
1075  $values = array($context->getRecordId());
1076  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1077  if ($ok) {
1078  $context->initialize();
1079  }
1080 
1081  return $ok;
1082  }
$context
$context
Definition: webdav.php:31

◆ deleteGlobalToolConsumerSettings()

ilLTIDataConnector::deleteGlobalToolConsumerSettings ( ilLTIPlatform  $platform)

Delete global tool consumer settings.

Definition at line 670 of file class.ilLTIDataConnector.php.

References $database, $ilDB, ilLTIPlatform\getExtConsumerId(), and ilLTIPlatform\initialize().

Referenced by ilLTIPlatform\deleteGlobalToolConsumerSettings().

670  : bool
671  {
672  $ilDB = $this->database;
673 
674  $query = 'DELETE FROM lti_ext_consumer WHERE id = %s';
675  $types = array("integer");
676  $values = array($platform->getExtConsumerId());
677  $ilDB->manipulateF($query, $types, $values);
678 
679  $query = 'DELETE FROM lti_ext_consumer_otype WHERE consumer_id = %s';
680  $types = array("integer");
681  $values = array($platform->getExtConsumerId());
682  $ilDB->manipulateF($query, $types, $values);
683 
684  $query = 'DELETE FROM lti2_consumer WHERE ext_consumer_id = %s';
685  $types = array("integer");
686  $values = array($platform->getExtConsumerId());
687  $ilDB->manipulateF($query, $types, $values);
688 
689  // delete all assigned lti consumers
690  $platform->initialize();
691  return true;
692  }
ilLTIPlatform\initialize
initialize()
Initialise the platform.
Definition: class.ilLTIPlatform.php:111
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ deleteResourceLink()

ilLTIDataConnector::deleteResourceLink ( ResourceLink  $resourceLink)

Delete resource link object.

Parameters
ResourceLink$resourceLinkResource_Link object
Returns
boolean True if the resource link object was successfully deleted

Definition at line 1285 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1285  : bool
1286  {
1287  $ilDB = $this->database;
1288 
1289  // Delete any outstanding share keys for resource links for this consumer
1290  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . ' ' .
1291  'WHERE (resource_link_pk = %s)';
1292  $types = array("integer");
1293  $values = array($resourceLink->getRecordId());
1294  $ok = $ilDB->manipulateF($query, $types, $values);
1295 
1296  // Delete users
1297  if ($ok) {
1298  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1299  'WHERE (resource_link_pk = %s)';
1300  $types = array("integer");
1301  $values = array($resourceLink->getRecordId());
1302  $ok = $ilDB->manipulateF($query, $types, $values);
1303  }
1304 
1305  // Update any resource links for which this is the primary resource link
1306  if ($ok) {
1307  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' ' .
1308  'SET primary_resource_link_pk = NULL ' .
1309  'WHERE (primary_resource_link_pk = %s)';
1310  $types = array("integer");
1311  $values = array($resourceLink->getRecordId());
1312  $ok = $ilDB->manipulateF($query, $types, $values);
1313  }
1314 
1315  // Delete resource link
1316  if ($ok) {
1317  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' ' .
1318  'WHERE (resource_link_pk = %s)';
1319  $types = array("integer");
1320  $values = array($resourceLink->getRecordId());
1321  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1322  }
1323 
1324  if ($ok) {
1325  $resourceLink->initialize();
1326  }
1327 
1328  return $ok;
1329  }

◆ deleteResourceLinkShareKey()

ilLTIDataConnector::deleteResourceLinkShareKey ( ResourceLinkShareKey  $shareKey)

Delete resource link share key object.

Parameters
ResourceLinkShareKey$shareKeyResource link share key object
Returns
boolean True if the resource link share key object was successfully deleted

Definition at line 1546 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1546  : bool
1547  {
1548  $ilDB = $this->database;
1549 
1550  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . " WHERE share_key_id = %s";
1551  $types = array("text");
1552  $values = array($shareKey->getId());
1553  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1554 
1555  if ($ok) {
1556  $shareKey->initialize();
1557  }
1558 
1559  return $ok;
1560  }

◆ deleteToolConsumer()

ilLTIDataConnector::deleteToolConsumer ( DataConnectorPlatform  $platform)

Delete tool consumer object.

Parameters
Platform$platformConsumer object
Returns
boolean True if the tool consumer object was successfully deleted

Definition at line 699 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

699  : bool
700  {
701  $ilDB = $this->database;
702 
703  // Delete any nonce values for this consumer
704  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::NONCE_TABLE_NAME . ' WHERE consumer_pk = %s';
705  $types = array("integer");
706  $values = array($platform->getRecordId());
707  $ilDB->manipulateF($query, $types, $values);
708 
709  // Delete any outstanding share keys for resource links for this consumer
710  $query = 'DELETE sk ' .
711  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . ' sk ' .
712  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON sk.resource_link_pk = rl.resource_link_pk ' .
713  'WHERE rl.consumer_pk = %s';
714  $types = array("integer");
715  $values = array($platform->getRecordId());
716  $ilDB->manipulateF($query, $types, $values);
717 
718  // Delete any outstanding share keys for resource links for contexts in this consumer
719  $query = 'DELETE sk ' .
720  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . ' sk ' .
721  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON sk.resource_link_pk = rl.resource_link_pk ' .
722  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ON rl.context_pk = c.context_pk ' .
723  'WHERE c.consumer_pk = %s';
724  $types = array("integer");
725  $values = array($platform->getRecordId());
726  $ilDB->manipulateF($query, $types, $values);
727 
728  // Delete any users in resource links for this consumer
729  $query = 'DELETE u ' .
730  "FROM {$this->dbTableNamePrefix}" . DataConnector::USER_RESULT_TABLE_NAME . ' u ' .
731  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON u.resource_link_pk = rl.resource_link_pk ' .
732  'WHERE rl.consumer_pk = %s';
733  $types = array("integer");
734  $values = array($platform->getRecordId());
735  $ilDB->manipulateF($query, $types, $values);
736 
737  // Delete any users in resource links for contexts in this consumer
738  $query = 'DELETE u ' .
739  "FROM {$this->dbTableNamePrefix}" . DataConnector::USER_RESULT_TABLE_NAME . ' u ' .
740  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON u.resource_link_pk = rl.resource_link_pk ' .
741  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ON rl.context_pk = c.context_pk ' .
742  'WHERE c.consumer_pk = %s';
743  $types = array("integer");
744  $values = array($platform->getRecordId());
745  $ilDB->manipulateF($query, $types, $values);
746 
747  // Update any resource links for which this consumer is acting as a primary resource link
748  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' prl ' .
749  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON prl.primary_resource_link_pk = rl.resource_link_pk ' .
750  'SET prl.primary_resource_link_pk = NULL, prl.share_approved = NULL ' .
751  'WHERE rl.consumer_pk = %s';
752  $types = array("integer");
753  $values = array($platform->getRecordId());
754  $ilDB->manipulateF($query, $types, $values);
755 
756  // Update any resource links for contexts in which this consumer is acting as a primary resource link
757  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' prl ' .
758  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ON prl.primary_resource_link_pk = rl.resource_link_pk ' .
759  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ON rl.context_pk = c.context_pk ' .
760  'SET prl.primary_resource_link_pk = NULL, prl.share_approved = NULL ' .
761  'WHERE c.consumer_pk = %s';
762  $types = array("integer");
763  $values = array($platform->getRecordId());
764  $ilDB->manipulateF($query, $types, $values);
765 
766  // Delete any resource links for this consumer
767  $query = 'DELETE rl ' .
768  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ' .
769  'WHERE rl.consumer_pk = %s';
770  $types = array("integer");
771  $values = array($platform->getRecordId());
772  $ilDB->manipulateF($query, $types, $values);
773 
774  // Delete any resource links for contexts in this consumer
775  $query = 'DELETE rl ' .
776  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' rl ' .
777  "INNER JOIN {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ON rl.context_pk = c.context_pk ' .
778  'WHERE c.consumer_pk = %s';
779  $types = array("integer");
780  $values = array($platform->getRecordId());
781  $ilDB->manipulateF($query, $types, $values);
782 
783  // Delete any contexts for this consumer
784  $query = 'DELETE c ' .
785  "FROM {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ' .
786  'WHERE c.consumer_pk = %s';
787  $types = array("integer");
788  $values = array($platform->getRecordId());
789  $ilDB->manipulateF($query, $types, $values);
790 
791  // Delete consumer
792  $query = 'DELETE c ' .
793  "FROM {$this->dbTableNamePrefix}" . DataConnector::PLATFORM_TABLE_NAME . ' c ' .
794  'WHERE c.consumer_pk = %s';
795  $types = array("integer");
796  $values = array($platform->getRecordId());
797  $ilDB->manipulateF($query, $types, $values);
798 
799  // if ($ok) {
800  $platform->initialize();
801  // }
802 
803  return true;
804  }

◆ deleteUser()

ilLTIDataConnector::deleteUser ( DataConnectorUser  $user)

Delete user object.

Parameters
User$userUser object
Returns
boolean True if the user object was successfully deleted

Definition at line 1665 of file class.ilLTIDataConnector.php.

References $database, Vendor\Package\$e, $ilDB, and ILIAS\Repository\logger().

1665  : bool
1666  {
1667  $ilDB = $this->database;
1668 
1669  $query = 'DELETE from ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1670  'WHERE user_pk = ' . $ilDB->quote($user->getRecordId(), 'integer');
1671 
1672  $ok = false;
1673  try {
1674  $ilDB->manipulate($query);
1675  $user->initialize();
1676  $ok = true;
1677  } catch (ilDatabaseException $e) {
1678  $this->logger->error((string) $e);
1679  }
1680  return $ok;
1681  }
+ Here is the call graph for this function:

◆ getDataConnector()

static ilLTIDataConnector::getDataConnector ( mixed  $db = null,
string  $dbTableNamePrefix = '',
string  $type = '' 
)
static

Definition at line 1746 of file class.ilLTIDataConnector.php.

Referenced by ilLTITool\__construct(), and ilLTIPlatform\__construct().

1746  : ilLTIDataConnector
1747  {
1748  $dataConnector = new ilLTIDataConnector();
1749  return $dataConnector;
1750  }
+ Here is the caller graph for this function:

◆ getGlobalToolConsumerSettings()

ilLTIDataConnector::getGlobalToolConsumerSettings ( )

Get global consumer settings.

Returns
[]

Definition at line 810 of file class.ilLTIDataConnector.php.

References $database, $ilDB, $res, and ilDBConstants\FETCHMODE_OBJECT.

810  : array
811  {
812  $ilDB = $this->database;
813 
814  $platforms = array();
815  $query = 'SELECT * from lti_ext_consumer ';
816  $res = $ilDB->query($query);
817  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
818  $platform = new ilLTIPlatform(null, $this);
819  $platform->setExtConsumerId((int) $row->id);
820  $platform->setTitle($row->title);
821  $platform->setDescription($row->description);
822  $platform->setPrefix($row->prefix);
823  $platform->setLanguage($row->user_language);
824  $platform->setRole((int) $row->role);
825  $platform->setActive((bool) $row->active);
826  $platforms[] = $platform;
827  }
828  return $platforms;
829  }
$res
$res
Definition: ltiservices.php:69
ilLTIPlatform
LTI provider for LTI launch.
Definition: class.ilLTIPlatform.php:32

◆ getToolConsumers()

ilLTIDataConnector::getToolConsumers ( )
Returns
[]

Definition at line 839 of file class.ilLTIDataConnector.php.

References $database, $ilDB, and $res.

839  : array
840  {
841  $ilDB = $this->database;
842  $platforms = array();
843  $query = 'SELECT consumer_pk, name, consumer_key256, consumer_key, secret, lti_version, ' .
844  'consumer_name, consumer_version, consumer_guid, ' .
845  'profile, tool_proxy, settings, protected, enabled, ' .
846  'enable_from, enable_until, last_access, created, updated, ' .
847  'title, description, prefix, user_language, role, local_role_always_member, default_skin ' .
848  'FROM lti2_consumer, lti_ext_consumer ' .
849  'WHERE lti_ext_consumer.id = consumer_pk';
850 
851  // $sql = 'SELECT consumer_pk, consumer_key, consumer_key, name, secret, lti_version, consumer_name, consumer_version, consumer_guid, ' .
852  // 'profile, tool_proxy, settings, ' .
853  // 'protected, enabled, enable_from, enable_until, last_access, created, updated ' .
854  // "FROM {$this->dbTableNamePrefix}" . Tool\DataConnector\DataConnector::CONSUMER_TABLE_NAME . ' ' .
855  // 'ORDER BY name';
856  // $rsConsumers = mysql_query($sql);
857  // if ($rsConsumers) {
858  // while ($row = mysql_fetch_object($rsConsumers)) {
859  $res = $ilDB->query($query);
860  // if ($rsConsumer) {
861  while ($row = $ilDB->fetchObject($res)) {
862  // $platform = new Tool\Platform($row->consumer_key, $this); //ACHTUNG: FEHLER IN BIBLIOTHEK; $row->consumer_key ist i.d.R. null
863  $platform = new ilLTIPlatform(null, $this);
864  $platform->setRecordId(intval($row->consumer_pk));
865  $platform->name = $row->name;
866  $platform->secret = $row->secret;
867  $platform->ltiVersion = $row->lti_version;
868  $platform->consumerName = $row->consumer_name;
869  $platform->consumerVersion = $row->consumer_version;
870  $platform->consumerGuid = $row->consumer_guid;
871  $platform->profile = json_decode($row->profile);
872  $platform->toolProxy = $row->tool_proxy;
873  $settings = unserialize($row->settings);
874  if (!is_array($settings)) {
875  $settings = array();
876  }
877  $platform->setSettings($settings);
878  $platform->protected = (intval($row->protected) === 1);
879  $platform->enabled = (intval($row->enabled) === 1);
880  $platform->enableFrom = null;
881  if (!is_null($row->enable_from)) {
882  $platform->enableFrom = strtotime($row->enable_from);
883  }
884  $platform->enableUntil = null;
885  if (!is_null($row->enable_until)) {
886  $platform->enableUntil = strtotime($row->enable_until);
887  }
888  $platform->lastAccess = null;
889  if (!is_null($row->last_access)) {
890  $platform->lastAccess = strtotime($row->last_access);
891  }
892  $platform->created = strtotime($row->created);
893  $platform->updated = strtotime($row->updated);
894  //ILIAS specific
895  $platform->setTitle($row->title);
896  $platform->setDescription($row->description);
897  $platform->setPrefix($row->prefix);
898  $platform->setLanguage($row->user_language);
899  $platform->setRole($row->role);
900  // local_role_always_member
901  // default_skin
902  $platform->setKey($row->consumer_key256);//ACHTUNG: hier müsste evtl. consumer_key sein
903  $platforms[] = $platform;
904  }
905  // mysql_free_result($rsConsumers);
906  // }
907 
908  return $platforms;
909  }
$res
$res
Definition: ltiservices.php:69
ilLTIPlatform
LTI provider for LTI launch.
Definition: class.ilLTIPlatform.php:32

◆ getUserResultSourcedIDsResourceLink()

ilLTIDataConnector::getUserResultSourcedIDsResourceLink ( ResourceLink  $resourceLink,
bool  $localOnly,
?IdScope  $idScope 
)

Get array of user objects.

Obtain an array of User objects for users with a result sourcedId. The array may include users from other resource links which are sharing this resource link. It may also be optionally indexed by the user ID of a specified scope.

Parameters
ResourceLink$resourceLinkResource link object
boolean$localOnlyTrue if only users within the resource link are to be returned (excluding users sharing this resource link)
IdScope$idScopeScope value to use for user IDs
Returns
array Array of User objects

Definition at line 1340 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1344  : array {
1345  $ilDB = $this->database;
1346 
1347  $users = array();
1348 
1349  // if ($localOnly) {
1350  // $query = 'SELECT u.user_pk, u.lti_result_sourcedid, u.lti_user_id, u.created, u.updated ' .
1351  // "FROM {$this->dbTableNamePrefix}" . Tool\DataConnector\DataConnector::USER_RESULT_TABLE_NAME . ' AS u ' .
1352  // "INNER JOIN {$this->dbTableNamePrefix}" . Tool\DataConnector\DataConnector::RESOURCE_LINK_TABLE_NAME . ' AS rl ' .
1353  // 'ON u.resource_link_pk = rl.resource_link_pk ' .
1354  // "WHERE (rl.resource_link_pk = %d) AND (rl.primary_resource_link_pk IS NULL)",
1355  // $resourceLink->getRecordId());
1356  // } else {
1357  // $query = 'SELECT u.user_pk, u.lti_result_sourcedid, u.lti_user_id, u.created, u.updated ' .
1358  // "FROM {$this->dbTableNamePrefix}" . Tool\DataConnector\DataConnector::USER_RESULT_TABLE_NAME . ' AS u ' .
1359  // "INNER JOIN {$this->dbTableNamePrefix}" . Tool\DataConnector\DataConnector::RESOURCE_LINK_TABLE_NAME . ' AS rl ' .
1360  // 'ON u.resource_link_pk = rl.resource_link_pk ' .
1361  // 'WHERE ((rl.resource_link_pk = %d) AND (rl.primary_resource_link_pk IS NULL)) OR ' .
1362  // '((rl.primary_resource_link_pk = %d) AND (share_approved = 1))',
1363  // $resourceLink->getRecordId(), $resourceLink->getRecordId());
1364  // }
1365  // $rsUser = mysql_query($sql);
1366  // if ($rsUser) {
1367  // while ($row = $ilDB->fetchObject($rsUser)) {
1368  // $user = Tool\User::fromResourceLink($resourceLink, $row->lti_user_id);
1369  // $user->setRecordId(intval($row->user_pk));
1370  // $user->ltiResultSourcedId = $row->lti_result_sourcedid;
1371  // $user->created = strtotime($row->created);
1372  // $user->updated = strtotime($row->updated);
1373  // if (is_null($idScope)) {
1374  // $users[] = $user;
1375  // } else {
1376  // $users[$user->getId($idScope)] = $user;
1377  // }
1378  // }
1379  // }
1380 
1381  return $users;
1382  }

◆ loadContext()

ilLTIDataConnector::loadContext ( Context  $context)

Load context object.

Parameters
Context$contextContext object
Returns
boolean True if the context object was successfully loaded

Definition at line 947 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

947  : bool
948  {
949  $ilDB = $this->database;
950  $ok = false;
951  if (!empty($context->getRecordId())) {
952  $query = 'SELECT context_pk, consumer_pk, lti_context_id, settings, created, updated ' .
953  "FROM {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' ' .
954  'WHERE (context_pk = %s)';
955  $types = array("integer");
956  $values = array($context->getRecordId());
957  } else {
958  $query = 'SELECT context_pk, consumer_pk, lti_context_id, settings, created, updated ' .
959  "FROM {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' ' .
960  'WHERE (consumer_pk = %s) AND (lti_context_id = %s)';
961  $types = array("integer", "text");
962  $values = array($context->getPlatform()->getRecordId(), $context->ltiContextId);
963  }
964  $rs_context = $ilDB->queryF($query, $types, $values);
965  if ($rs_context) {
966  $row = $ilDB->fetchObject($rs_context);
967  if ($row) {
968  $context->setRecordId(intval($row->context_pk));
969  $context->setPlatformId(intval($row->consumer_pk));
970  $context->ltiContextId = $row->lti_context_id;
971  $settings = json_decode($row->settings);
972  if (!is_array($settings)) {
973  $settings = array();
974  }
975  $context->setSettings($settings);
976  $context->created = strtotime($row->created);
977  $context->updated = strtotime($row->updated);
978  $ok = true;
979  }
980  }
981 
982  return $ok;
983  }
$context
$context
Definition: webdav.php:31

◆ loadGlobalToolConsumerSettings()

ilLTIDataConnector::loadGlobalToolConsumerSettings ( ilLTIPlatform  $platform)

Load tool consumer settings.

Parameters
ilLTIPlatform$platform
Returns
bool Load global tool consumer settings in consumer
Parameters
ilLTIPlatform$platform
Returns
bool

Definition at line 200 of file class.ilLTIDataConnector.php.

References $database, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\setActive(), ilLTIPlatform\setDescription(), ilLTIPlatform\setLanguage(), ilLTIPlatform\setPrefix(), ilLTIPlatform\setRole(), and ilLTIPlatform\setTitle().

Referenced by ilLTIPlatform\fromExternalConsumerId().

200  : bool
201  {
202  $ilDB = $this->database;
203 
204  $query = 'SELECT * from lti_ext_consumer where id = ' . $ilDB->quote($platform->getExtConsumerId(), 'integer');
205  $res = $ilDB->query($query);
206  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
207  $platform->setTitle($row->title);
208  $platform->setDescription($row->description);
209  $platform->setPrefix($row->prefix);
210  $platform->setLanguage($row->user_language);
211  $platform->setRole((int) $row->role);
212  $platform->setActive((bool) $row->active);
213  return true;
214  }
215  return false;
216  }
ilLTIPlatform\setActive
setActive(bool $value)
Definition: class.ilLTIPlatform.php:237
$res
$res
Definition: ltiservices.php:69
ilLTIPlatform\setRole
setRole(int $role_id)
Definition: class.ilLTIPlatform.php:247
ilLTIPlatform\setDescription
setDescription(string $description)
Definition: class.ilLTIPlatform.php:186
ilLTIPlatform\setLanguage
setLanguage(string $lang)
Definition: class.ilLTIPlatform.php:227
ilLTIPlatform\setTitle
setTitle(string $title)
Definition: class.ilLTIPlatform.php:175
ilLTIPlatform\setPrefix
setPrefix(string $prefix)
Definition: class.ilLTIPlatform.php:196
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ loadPlatform()

ilLTIDataConnector::loadPlatform ( Platform|ilLTIPlatform  $platform)

Load platform object.

Parameters
Platform$platformPlatform object
Returns
boolean True if the tool consumer object was successfully loaded

Definition at line 58 of file class.ilLTIDataConnector.php.

References $id, $res, ILIAS\ResourceStorage\Flavour\Machine\DefaultMachines\from(), ilLTIPlatform\setExtConsumerId(), and ilLTIPlatform\setRefId().

58  : bool
59  {
60 
61  $ok = false;
62  $allowMultiple = false;
63  $id = $platform->getRecordId();
64  $query = 'SELECT consumer_pk, name, consumer_key, secret, ' .
65  'platform_id, client_id, deployment_id, public_key, ' .
66  'lti_version, signature_method, consumer_name, consumer_version, consumer_guid, ' .
67  'profile, tool_proxy, settings, protected, enabled, ' .
68  'enable_from, enable_until, last_access, created, updated, ext_consumer_id, ref_id ' .
69  'FROM lti2_consumer WHERE ';
70  if (!is_null($id)) {
71  $query .= 'consumer_pk = %s';
72  $types = array('integer');
73  $values = array($id);
74  } elseif (!empty($platform->platformId)) {
75  if (empty($platform->clientId)) {
76  $allowMultiple = true;
77  $query .= '(platform_id = %s)';
78  $types = array('text');
79  $values = array($platform->platformId);
80  } elseif (empty($platform->deploymentId)) {
81  $allowMultiple = true;
82  $query .= '(platform_id = %s) AND (client_id = %s)';
83  $types = array('text','text');
84  $values = array($platform->platformId, $platform->clientId);
85  } else {
86  $query .= '(platform_id = %s) AND (client_id = %s) AND (deployment_id = %s)';
87  $types = array('text','text','text');
88  $values = array($platform->platformId, $platform->clientId, $platform->deploymentId);
89  }
90  } elseif (!empty($platform->getKey())) {
91  $key = $platform->getKey();
92  $query .= 'consumer_key = %s';
93  $types = array('text');
94  $values = array($key);
95  } else {
96  return false;
97  }
98  // $ok = $this->executeQuery($sql, $stmt);
99  // if ($ok) {
100  // $rsConsumer = $stmt->get_result();
101  // $ok = $rsConsumer !== false;
102  // if ($ok) {
103  // $row = $rsConsumer->fetch_object();
104  // $ok = $row && ($allowMultiple || is_null($rsConsumer->fetch_object()));
105  // }
106  // }
107  // if ($ok) {
108  $res = $this->database->queryF($query, $types, $values);
109  while ($row = $this->database->fetchObject($res)) {
110  $platform->setRecordId(intval($row->consumer_pk));
111  $platform->name = $row->name;
112  $platform->setkey((string) $row->consumer_key);
113  $platform->secret = $row->secret;
114  $platform->platformId = $row->platform_id;
115  $platform->clientId = $row->client_id;
116  $platform->deploymentId = $row->deployment_id;
117  $platform->rsaKey = $row->public_key;
118  $platform->ltiVersion = isset($row->lti_version) ? LtiVersion::from($row->lti_version) : LtiVersion::V1;
119  $platform->signatureMethod = $row->signature_method;
120  $platform->consumerName = $row->consumer_name;
121  $platform->consumerVersion = $row->consumer_version;
122  $platform->consumerGuid = $row->consumer_guid;
123  $platform->profile = json_decode((string) $row->profile);
124  $platform->toolProxy = $row->tool_proxy;
125  $settings = json_decode($row->settings, true);
126  if (!is_array($settings)) {
127  $settings = @unserialize($row->settings); // check for old serialized setting
128  }
129  if (!is_array($settings)) {
130  $settings = array();
131  }
132  $platform->setSettings($settings);
133  $platform->protected = (intval($row->protected) === 1);
134  $platform->enabled = (intval($row->enabled) === 1);
135  $platform->enableFrom = null;
136  if (!is_null($row->enable_from)) {
137  $platform->enableFrom = strtotime($row->enable_from);
138  }
139  $platform->enableUntil = null;
140  if (!is_null($row->enable_until)) {
141  $platform->enableUntil = strtotime($row->enable_until);
142  }
143  $platform->lastAccess = null;
144  if (!is_null($row->last_access)) {
145  $platform->lastAccess = strtotime($row->last_access);
146  }
147  $platform->created = strtotime($row->created);
148  $platform->updated = strtotime($row->updated);
149  //ILIAS specific
150  // Fix for ILIAS: Change method param type to union type Platform | ilLTIPlatform
151  // Then check if $platform is ilLTIPlatform
152  if ($platform instanceof ilLTIPlatform) {
153  $platform->setExtConsumerId(intval($row->ext_consumer_id));
154  $platform->setRefId((int) $row->ref_id);
155  }
156  // if ($platform->setTitle) $platform->setTitle($row->title);
157  // if ($platform->setDescription) $platform->setDescription($row->description);
158  // if ($platform->setPrefix) $platform->setPrefix($row->prefix);
159  // if ($platform->setPrefix) $platform->setLanguage($row->user_language);
160  // if ($platform->setPrefix) $platform->setRole($row->role);
161  // local_role_always_member
162  // default_skin
163  $this->fixPlatformSettings($platform, false);
164  $ok = true;
165  }
166 
167  return $ok;
168  }
$res
$res
Definition: ltiservices.php:69
ilLTIPlatform
LTI provider for LTI launch.
Definition: class.ilLTIPlatform.php:32
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24
+ Here is the call graph for this function:

◆ loadPlatformNonce()

ilLTIDataConnector::loadPlatformNonce ( PlatformNonce  $nonce)

Get array of shares defined for this resource link.

Parameters
ResourceLink$resourceLinkResource_Link object
Returns
array Array of ResourceLinkShare objects Load nonce object.
Parameters
PlatformNonce$nonceNonce object
Returns
boolean True if the nonce object was successfully loaded

Definition at line 1425 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1425  : bool
1426  {
1427  $ilDB = $this->database;
1428 
1429  $ok = true;
1430 
1431  // Delete any expired nonce values
1432  $now = date("{$this->dateFormat} {$this->timeFormat}", time());//PRÜFEN UK
1433  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::NONCE_TABLE_NAME . " WHERE expires <= %s";
1434  $types = array("timestamp");
1435  $values = array($now);
1436  $ilDB->manipulateF($query, $types, $values);
1437  // Load the nonce
1438  $query = "SELECT value AS T FROM {$this->dbTableNamePrefix}" . DataConnector::NONCE_TABLE_NAME . ' WHERE (consumer_pk = %s) AND (value = %s)';
1439  $types = array("integer", "text");
1440  $values = array($nonce->getPlatform()->getRecordId(), $nonce->getValue());
1441  $rs_nonce = $ilDB->queryF($query, $types, $values);
1442  if ($rs_nonce) {
1443  $row = $ilDB->fetchObject($rs_nonce);
1444  if (!$row) {
1445  $ok = false;
1446  }
1447  }
1448 
1449  return $ok;
1450  }

◆ loadResourceLink()

ilLTIDataConnector::loadResourceLink ( ResourceLink  $resourceLink)

Load resource link object.

Parameters
ResourceLink$resourceLinkResource_Link object
Returns
boolean True if the resource link object was successfully loaded

Definition at line 1093 of file class.ilLTIDataConnector.php.

References $database, $id, $ilDB, and ILIAS\Repository\logger().

1093  : bool
1094  {
1095  $ilDB = $this->database;
1096 
1097  $ok = false;
1098  $id = $resourceLink->getRecordId();
1099  $rid = 0;
1100  $cid = 0;
1101  if (!is_null($id)) {
1102  $query = 'SELECT resource_link_pk, context_pk, consumer_pk, lti_resource_link_id, settings, primary_resource_link_pk, share_approved, created, updated ' .
1103  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' ' .
1104  'WHERE (resource_link_pk = %s)';
1105  $types = array("integer");
1106  $values = array($id);
1107  } elseif (!is_null($resourceLink->getContext())) {
1108  $rid = $resourceLink->getId();
1109  $cid = $resourceLink->getContext()->getRecordId();
1110  $query = 'SELECT resource_link_pk, context_pk, consumer_pk, lti_resource_link_id, settings, primary_resource_link_pk, share_approved, created, updated ' .
1111  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' r ' .
1112  'WHERE (r.lti_resource_link_id = %s) AND ((r.context_pk = %s) OR (r.consumer_pk IN (' .
1113  'SELECT c.consumer_pk ' .
1114  "FROM {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' c ' .
1115  'WHERE (c.context_pk = %s))))';
1116  $types = array("text", "integer", "integer");
1117  $values = array($rid, $cid, $cid);
1118  } else {
1119  $id = $resourceLink->getPlatform()->getRecordId();
1120  $rid = $resourceLink->getId();
1121  $query = 'SELECT r.resource_link_pk, r.context_pk, r.consumer_pk, r.lti_resource_link_id, r.settings, r.primary_resource_link_pk, r.share_approved, r.created, r.updated ' .
1122  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' r LEFT OUTER JOIN ' .
1123  $this->dbTableNamePrefix . DataConnector::CONTEXT_TABLE_NAME . ' c ON r.context_pk = c.context_pk ' .
1124  ' WHERE ((r.consumer_pk = %s) OR (c.consumer_pk = %s)) AND (lti_resource_link_id = %s)';
1125  $types = array("integer", "integer", "text");
1126  $values = array($id, $id, $rid);
1127  }
1128  $this->logger->debug("loadResourceLink id = " . $id . " rid =" . $rid . " cid =" . $cid . " query = " . $query);
1129  $rsContext = $ilDB->queryF($query, $types, $values);
1130  if ($rsContext) {
1131  $row = $ilDB->fetchObject($rsContext);
1132  if ($row) {
1133  $resourceLink->setRecordId(intval($row->resource_link_pk));
1134  if (!is_null($row->context_pk)) {
1135  $resourceLink->setContextId(intval($row->context_pk));
1136  } else {
1137  $resourceLink->setContextId(null);
1138  }
1139  if (!is_null($row->consumer_pk)) {
1140  $resourceLink->setPlatformId(intval($row->consumer_pk));
1141  } else {
1142  $resourceLink->setPlatformId(null);
1143  }
1144  //$resourceLink->title = $row->title;
1145  $resourceLink->ltiResourceLinkId = $row->lti_resource_link_id;
1146  $settings = json_decode($row->settings, true);
1147  if (!is_array($settings)) {
1148  $settings = @unserialize($row->settings); // check for old serialized setting
1149  }
1150  if (!is_array($settings)) {
1151  $settings = array();
1152  }
1153  $resourceLink->setSettings($settings);
1154  if (!is_null($row->primary_resource_link_pk)) {
1155  $resourceLink->primaryResourceLinkId = intval($row->primary_resource_link_pk);
1156  } else {
1157  $resourceLink->primaryResourceLinkId = null;
1158  }
1159  $resourceLink->shareApproved = (is_null($row->share_approved)) ? null : (intval($row->share_approved) === 1);
1160  $resourceLink->created = strtotime($row->created);
1161  $resourceLink->updated = strtotime($row->updated);
1162  } else {
1163  $ok = false;
1164  }
1165  }
1166 
1167 
1168  return $ok;
1169  }
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24
+ Here is the call graph for this function:

◆ loadResourceLinkShareKey()

ilLTIDataConnector::loadResourceLinkShareKey ( ResourceLinkShareKey  $shareKey)

Load resource link share key object.

Parameters
ResourceLinkShareKey$shareKeyResource_Link share key object
Returns
boolean True if the resource link share key object was successfully loaded

Definition at line 1481 of file class.ilLTIDataConnector.php.

References $database, $id, and $ilDB.

1481  : bool
1482  {
1483  $ilDB = $this->database;
1484 
1485  $ok = false;
1486 
1487  // Clear expired share keys
1488  $now = date("{$this->dateFormat} {$this->timeFormat}", time());
1489  $query = "DELETE FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . " WHERE expires <= '%s'";
1490  $types = array("timestamp");
1491  $values = array($now);
1492  $ilDB->manipulateF($query, $types, $values);
1493 
1494  // Load share key
1495  // $id = mysql_real_escape_string($shareKey->getId());//ACHTUNG UK utf8
1496  $id = $shareKey->getId();
1497  $query = 'SELECT resource_link_pk, auto_approve, expires ' .
1498  "FROM {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . ' ' .
1499  "WHERE share_key_id = %s";
1500  $types = array("text");
1501  $values = array($id);
1502  $rsShareKey = $ilDB->queryF($query, $types, $values);
1503  if ($rsShareKey) {
1504  $row = $ilDB->fetchObject($rsShareKey);
1505  if ($row && (intval($row->resource_link_pk) === $shareKey->resourceLinkId)) {
1506  $shareKey->autoApprove = (intval($row->auto_approve) === 1);
1507  $shareKey->expires = strtotime($row->expires);
1508  $ok = true;
1509  }
1510  }
1511 
1512  return $ok;
1513  }
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24

◆ loadUserResult()

ilLTIDataConnector::loadUserResult ( User  $userresult)

Load user object.

Parameters
User$userresultUser object
Returns
boolean True if the user object was successfully loaded

Definition at line 1572 of file class.ilLTIDataConnector.php.

References $database, Vendor\Package\$e, $id, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\logger().

1572  : bool
1573  {
1574  $ilDB = $this->database;
1575  $id = $userresult->getRecordId();
1576  if (!is_null($id)) {
1577  $query = 'SELECT user_pk, resource_link_pk, lti_user_id, lti_result_sourcedid, created, updated ' .
1578  'FROM ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1579  'WHERE user_pk = ' . $ilDB->quote($id, 'integer');
1580  } else {
1581  $rid = $userresult->getResourceLink()->getRecordId();
1582  $uid = $userresult->getId(IdScope::IdOnly);
1583 
1584  $query = 'SELECT user_pk, resource_link_pk, lti_user_id, lti_result_sourcedid, created, updated ' .
1585  'FROM ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1586  'WHERE resource_link_pk = ' . $ilDB->quote($rid, 'integer') . ' ' .
1587  'AND lti_user_id = ' . $ilDB->quote($uid, 'text');
1588  }
1589 
1590  $this->logger->debug('Loading user with query: ' . $query);
1591 
1592  $ok = false;
1593  try {
1594  $res = $ilDB->query($query);
1595  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
1596  $userresult->setRecordId((int) $row->user_pk);
1597  $userresult->setResourceLinkId((int) $row->resource_link_pk);
1598  $userresult->ltiUserId = (string) $row->lti_user_id;
1599  $userresult->ltiResultSourcedId = (string) $row->lti_result_sourcedid;
1600  $userresult->created = strtotime($row->created);
1601  $userresult->updated = strtotime($row->updated);
1602  $ok = true;
1603  }
1604  } catch (ilDatabaseException $e) {
1605  $this->logger->error((string) $e);
1606  }
1607  return $ok;
1608  }
$res
$res
Definition: ltiservices.php:69
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24
+ Here is the call graph for this function:

◆ lookupRecordIdByGlobalSettingsAndRefId()

ilLTIDataConnector::lookupRecordIdByGlobalSettingsAndRefId ( ilLTIPlatform  $platform)

Load extended tool consumer object with ILIAS extension.

Parameters
Platform$platformPlatform object
Returns
boolean True if the tool consumer object was successfully loaded Lookup record id for global settings and ref_id
Parameters
ilLTIPlatform$platform
Returns
int|null

Definition at line 314 of file class.ilLTIDataConnector.php.

References $database, $res, ilDBConstants\FETCHMODE_OBJECT, ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\getRefId(), and ilDBInterface\quote().

Referenced by ilLTIPlatform\fromGlobalSettingsAndRefId().

314  : ?int
315  {
316  $db = $this->database;
317 
318  $query = 'SELECT consumer_pk from lti2_consumer ' .
319  'WHERE ext_consumer_id = ' . $db->quote($platform->getExtConsumerId(), 'integer') . ' ' .
320  'AND ref_id = ' . $db->quote($platform->getRefId(), 'integer');
321  $res = $db->query($query);
322  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
323  return (int) $row->consumer_pk;
324  }
325  return null;
326  }
$res
$res
Definition: ltiservices.php:69
ilDBInterface\quote
quote($value, string $type)
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ lookupResourcesForAllUsersSinceDate()

ilLTIDataConnector::lookupResourcesForAllUsersSinceDate ( ilDateTime  $since)
Parameters
\ilDateTime$since
Returns
array<string, string[]>

Definition at line 1726 of file class.ilLTIDataConnector.php.

References $database, $res, $results, ilDBConstants\FETCHMODE_OBJECT, ilDateTime\get(), ilLoggerFactory\getLogger(), and IL_CAL_DATETIME.

1726  : array
1727  {
1728  $db = $this->database;
1729  $logger = ilLoggerFactory::getLogger('ltis');
1730 
1731  $query = 'select lti_user_id, rl.resource_link_pk, ec.id, ref_id ' .
1732  'from lti2_resource_link rl join lti2_user_result ur on rl.resource_link_pk = ur.resource_link_pk ' .
1733  'join lti2_consumer c on rl.consumer_pk = c.consumer_pk ' .
1734  'join lti_ext_consumer ec on ext_consumer_id = ec.id ' .
1735  'where c.enabled = ' . $db->quote(1, 'integer') . ' ' .
1736  'and rl.updated > ' . $db->quote($since->get(IL_CAL_DATETIME), 'timestamp');
1737  $res = $db->query($query);
1738 
1739  $results = [];
1740  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
1741  $results[$row->id . '__' . $row->lti_user_id][] = $row->resource_link_pk . '__' . $row->ref_id;
1742  }
1743  return $results;
1744  }
ilDateTime\get
get(int $a_format, string $a_format_str='', string $a_tz='')
get formatted date
Definition: class.ilDateTime.php:463
$res
$res
Definition: ltiservices.php:69
IL_CAL_DATETIME
const IL_CAL_DATETIME
Definition: class.ilDateTime.php:7
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:90
$results
$results
Definition: save_question_post_data.php:8
+ Here is the call graph for this function:

◆ lookupResourcesForUserObjectRelation()

ilLTIDataConnector::lookupResourcesForUserObjectRelation ( int  $a_ref_id,
string  $a_lti_user,
int  $a_ext_consumer,
ilDateTime  $since = null 
)

Lookup resources for user object relation.

Parameters
int$a_ref_id
string$a_lti_user
int$a_ext_consumer
ilDateTime | null$since
Returns
int[]

Definition at line 1691 of file class.ilLTIDataConnector.php.

References $database, Vendor\Package\$e, $res, ilDBConstants\FETCHMODE_OBJECT, and ilLoggerFactory\getLogger().

1696  : array {
1697  $db = $this->database;
1698 
1699  $logger = ilLoggerFactory::getLogger('ltis');
1700 
1701  $query = 'select rl.resource_link_pk ' .
1702  'from lti2_user_result ur join lti2_resource_link rl on rl.resource_link_pk = ur.resource_link_pk ' .
1703  'join lti2_consumer c on rl.consumer_pk = c.consumer_pk ' .
1704  'join lti_ext_consumer ec on c.ext_consumer_id = ec.id ' .
1705  'where c.enabled = ' . $db->quote(1, 'integer') . ' ' .
1706  'and ref_id = ' . $db->quote($a_ref_id, 'integer') . ' ' .
1707  'and ur.lti_user_id = ' . $db->quote($a_lti_user, 'text') . ' ' .
1708  'and ec.id = ' . $db->quote($a_ext_consumer, 'integer');
1709  $logger->debug($query);
1710  $resource_links = [];
1711  try {
1712  $res = $db->query($query);
1713  while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
1714  $resource_links[] = $row->resource_link_pk;
1715  }
1716  } catch (ilDatabaseException $e) {
1717  $logger->error('Query execution failed with message: ' . $e->getMessage());
1718  }
1719  return $resource_links;
1720  }
$res
$res
Definition: ltiservices.php:69
ilLoggerFactory\getLogger
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:90
ilLogger\debug
debug(string $message, array $context=[])
Definition: class.ilLogger.php:54
ilLogger\error
error(string $message, array $context=[])
Definition: class.ilLogger.php:74
+ Here is the call graph for this function:

◆ saveContext()

ilLTIDataConnector::saveContext ( Context  $context)

Save context object.

Parameters
Context$contextContext object
Returns
boolean True if the context object was successfully saved

Definition at line 990 of file class.ilLTIDataConnector.php.

References $database, $id, and $ilDB.

990  : bool
991  {
992  $ilDB = $this->database;
993 
994  $time = time();
995  $now = date("{$this->dateFormat} {$this->timeFormat}", $time);
996  //old: $settingsValue = serialize($context->getSettings());
997  $settingsValue = json_encode($context->getSettings());
998  $id = $context->getRecordId();
999  $platform_pk = $context->getPlatform()->getRecordId();
1000  if (empty($id)) {
1001  $context->setRecordId($ilDB->nextId(DataConnector::CONTEXT_TABLE_NAME));
1002  $id = $context->getRecordId();
1003  $context->created = $time;
1004  //Check remove context_pk, add type
1005  $query = "INSERT INTO {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME .
1006  ' (context_pk, consumer_pk, lti_context_id, settings, created, updated) ' .
1007  'VALUES (%s, %s, %s, %s, %s, %s)';
1008  $types = array("integer", "integer", "text", "text", "timestamp", "timestamp");
1009  $values = array($id, $platform_pk, $context->ltiContextId, $settingsValue, $now, $now);
1010  } else {
1011  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::CONTEXT_TABLE_NAME . ' SET ' .
1012  'lti_context_id = %s, settings = %s, ' .
1013  'updated = %s' .
1014  'WHERE (consumer_pk = %s) AND (context_pk = %s)';
1015  $types = array("text", "text", "timestamp", "integer", "integer");
1016  $values = array($context->ltiContextId, $settingsValue, $now, $platform_pk, $id);
1017  }
1018  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1019  if ($ok) {
1020  $context->updated = $time;
1021  }
1022 
1023  return $ok;
1024  }
$context
$context
Definition: webdav.php:31
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24

◆ saveGlobalToolConsumerSettings()

ilLTIDataConnector::saveGlobalToolConsumerSettings ( ilLTIPlatform  $platform)

Save platform object.

Parameters
Platform$platformConsumer object
Returns
bool True if the tool consumer object was successfully saved Save lti_ext_consumer

Definition at line 474 of file class.ilLTIDataConnector.php.

References $database, $ilDB, ilLTIPlatform\getActive(), ilLTIPlatform\getDescription(), ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\getLanguage(), ilLTIPlatform\getPrefix(), ilLTIPlatform\getRole(), ilLTIPlatform\getTitle(), and ilLTIPlatform\setExtConsumerId().

Referenced by ilLTIPlatform\saveGlobalToolConsumerSettings().

474  : bool
475  {
476  $ilDB = $this->database;
477 
478  if (!$platform->getExtConsumerId()) {
479  // create
480  $new_id = $ilDB->nextId('lti_ext_consumer');
481  $query = 'INSERT INTO lti_ext_consumer (title, description, prefix, user_language, role, id, active) ' .
482  'VALUES (%s, %s, %s, %s, %s, %s, %s)';
483  $types = ["text", "text", "text", "text", "integer", "integer", 'integer'];
484  $values = [
485  $platform->getTitle(),
486  $platform->getDescription(),
487  $platform->getPrefix(),
488  $platform->getLanguage(),
489  $platform->getRole(),
490  $new_id,
491  $platform->getActive()
492  ];
493  $ilDB->manipulateF($query, $types, $values);
494  $platform->setExtConsumerId($new_id);
495  return true;
496  } else {
497  // update
498  $query = 'update lti_ext_consumer set ' .
499  'title = ' . $ilDB->quote($platform->getTitle(), 'text') . ', ' .
500  'description = ' . $ilDB->quote($platform->getDescription(), 'text') . ', ' .
501  'prefix = ' . $ilDB->quote($platform->getPrefix(), 'text') . ', ' .
502  'user_language = ' . $ilDB->quote($platform->getLanguage(), 'text') . ', ' .
503  'role = ' . $ilDB->quote($platform->getRole(), 'integer') . ', ' .
504  'active = ' . $ilDB->quote((int) $platform->getActive(), 'integer') . ' ' .
505  'where id = ' . $ilDB->quote($platform->getExtConsumerId(), 'integer');
506  $ilDB->manipulate($query);
507  return true;
508  }
509  }
ilLTIPlatform\setExtConsumerId
setExtConsumerId(int $a_id)
Definition: class.ilLTIPlatform.php:150
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ savePlatformNonce()

ilLTIDataConnector::savePlatformNonce ( PlatformNonce  $nonce)

Save nonce object.

Parameters
PlatformNonce$nonceNonce object
Returns
boolean True if the nonce object was successfully saved

Definition at line 1457 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1457  : bool
1458  {
1459  $ilDB = $this->database;
1460 
1461  $expires = date("{$this->dateFormat} {$this->timeFormat}", $nonce->expires);
1462  $query = "INSERT INTO {$this->dbTableNamePrefix}" . DataConnector::NONCE_TABLE_NAME . " (consumer_pk, value, expires) VALUES (%s, %s, %s)";
1463  $types = array("integer", "text", "timestamp");
1464  $values = array($nonce->getPlatform()->getRecordId(), $nonce->getValue(), $expires);
1465  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1466 
1467  return $ok;
1468  }

◆ saveResourceLink()

ilLTIDataConnector::saveResourceLink ( ResourceLink  $resourceLink)

Save resource link object.

Parameters
ResourceLink$resourceLinkResource_Link object
Returns
boolean True if the resource link object was successfully saved

Definition at line 1176 of file class.ilLTIDataConnector.php.

References $database, $id, $ilDB, ilLogLevel\DEBUG, and ILIAS\Repository\logger().

1176  : bool
1177  {
1178  $ilDB = $this->database;
1179 
1180  if (is_null($resourceLink->shareApproved)) {
1181  $approved = null;
1182  } elseif ($resourceLink->shareApproved) {
1183  $approved = '1';
1184  } else {
1185  $approved = '0';
1186  }
1187  if (empty($resourceLink->primaryResourceLinkId) || $resourceLink->primaryResourceLinkId == '0') {
1188  $primaryResourceLinkId = null;//'NULL';
1189  $resourceLink->primaryResourceLinkId = null; //Bug in 7: 0 instead of null
1190  } else {
1191  $primaryResourceLinkId = strval($resourceLink->primaryResourceLinkId);
1192  }
1193  $time = time();
1194  $now = date("{$this->dateFormat} {$this->timeFormat}", $time);
1195  $settingsValue = serialize($resourceLink->getSettings());
1196  if (!is_null($resourceLink->getContext())) {
1197  // $platformId = null;
1198  $platformId = strval($resourceLink->getPlatform()->getRecordId());
1199  $contextId = strval($resourceLink->getContext()->getRecordId());
1200  } elseif (!is_null($resourceLink->getContextId())) {
1201  // $platformId = null;
1202  $platformId = strval($resourceLink->getPlatform()->getRecordId());
1203  $contextId = strval($resourceLink->getContextId());
1204  } else {
1205  $platformId = strval($resourceLink->getPlatform()->getRecordId());
1206  $contextId = null;
1207  }
1208  $id = $resourceLink->getRecordId();
1209  if (empty($id)) {
1210  $resourceLink->setRecordId($ilDB->nextId(DataConnector::RESOURCE_LINK_TABLE_NAME));
1211  $id = $resourceLink->getRecordId();
1212  $resourceLink->created = $time;
1213  $query = "INSERT INTO {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' (resource_link_pk, consumer_pk, context_pk, ' .
1214  'lti_resource_link_id, settings, primary_resource_link_pk, share_approved, created, updated) ' .
1215  'VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)';
1216  $types = array("integer",
1217  "integer",
1218  "integer",
1219  "text",
1220  "text",
1221  "integer",
1222  "integer",
1223  "timestamp",
1224  "timestamp"
1225  );
1226  $values = array($id,
1227  $platformId,
1228  $contextId,
1229  $resourceLink->getId(),
1230  $settingsValue,
1231  $primaryResourceLinkId,
1232  $approved,
1233  $now,
1234  $now
1235  );
1236  } elseif (!is_null($contextId)) {
1237  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' SET ' .
1238  'consumer_pk = %s, lti_resource_link_id = %s, settings = %s, ' .
1239  'primary_resource_link_pk = %s, share_approved = %s, updated = %s ' .
1240  'WHERE (context_pk = %s) AND (resource_link_pk = %s)';
1241  $types = array("integer", "text", "text", "integer", "integer", "timestamp", "integer", "integer");
1242  $values = array($platformId,
1243  $resourceLink->getId(),
1244  $settingsValue,
1245  $primaryResourceLinkId,
1246  $approved,
1247  $now,
1248  $contextId,
1249  $id
1250  );
1251  } else {
1252  $query = "UPDATE {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_TABLE_NAME . ' SET ' .
1253  'context_pk = %s, lti_resource_link_id = %s, settings = %s, ' .
1254  'primary_resource_link_pk = %s, share_approved = %s, updated = %s ' .
1255  'WHERE (consumer_pk = %s) AND (resource_link_pk = %s)';
1256  $types = array("integer", "text", "text", "integer", "integer", "timestamp", "integer", "integer");
1257  $values = array($contextId,
1258  $resourceLink->getId(),
1259  $settingsValue,
1260  $primaryResourceLinkId,
1261  $approved,
1262  $now,
1263  $platformId,
1264  $id
1265  );
1266  }
1267  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1268  $this->logger->debug('Update resource link with query: ' . $query);
1269  // $this->logger->logStack();
1270  $this->logger->dump($values, ilLogLevel::DEBUG);
1271  $this->logger->dump($ok, ilLogLevel::DEBUG);
1272 
1273  if ($ok) {
1274  $resourceLink->updated = $time;
1275  }
1276 
1277  return $ok;
1278  }
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24
+ Here is the call graph for this function:

◆ saveResourceLinkShareKey()

ilLTIDataConnector::saveResourceLinkShareKey ( ResourceLinkShareKey  $shareKey)

Save resource link share key object.

Parameters
ResourceLinkShareKey$shareKeyResource link share key object
Returns
boolean True if the resource link share key object was successfully saved

Definition at line 1521 of file class.ilLTIDataConnector.php.

References $database, and $ilDB.

1521  : bool
1522  {
1523  $ilDB = $this->database;
1524 
1525  if ($shareKey->autoApprove) {
1526  $approve = 1;
1527  } else {
1528  $approve = 0;
1529  }
1530  $expires = date("{$this->dateFormat} {$this->timeFormat}", $shareKey->expires);
1531  $query = "INSERT INTO {$this->dbTableNamePrefix}" . DataConnector::RESOURCE_LINK_SHARE_KEY_TABLE_NAME . ' ' .
1532  '(share_key_id, resource_link_pk, auto_approve, expires) ' .
1533  "VALUES (%s, %s, %s, %s)";
1534  $types = array("text", "integer", "integer", "timestamp");
1535  $values = array($shareKey->getId(), $shareKey->resourceLinkId, $approve, $expires);
1536  $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1537 
1538  return $ok;
1539  }

◆ saveToolConsumerILIAS()

ilLTIDataConnector::saveToolConsumerILIAS ( ilLTIPlatform  $platform)

Save extended tool consumer object with ILIAS extensions.

Parameters
ilLTIPlatform$platformConsumer object
Returns
boolean True if the tool consumer object was successfully saved

Definition at line 516 of file class.ilLTIDataConnector.php.

References $database, $id, $ilDB, ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\getRefId(), and ilLTIPlatform\getTitle().

Referenced by ilLTIPlatform\saveLTI().

516  : bool
517  {
518  $ilDB = $this->database;
519 
520  $id = $platform->getRecordId();
521  $key = $platform->getKey();
522  $protected = ($platform->protected) ? 1 : 0;
523  $enabled = ($platform->enabled) ? 1 : 0;
524  $profile = (!empty($platform->profile)) ? json_encode($platform->profile) : null;
525  // $settingsValue = '{}';
526  $this->fixPlatformSettings($platform, true);
527  $settingsValue = json_encode($platform->getSettings());
528  $this->fixPlatformSettings($platform, false);
529  $time = time();
530  $now = date("{$this->dateFormat} {$this->timeFormat}", $time);
531  $from = null;
532  if (!is_null($platform->enableFrom)) {
533  $from = date("{$this->dateFormat} {$this->timeFormat}", $platform->enableFrom);
534  }
535  $until = null;
536  if (!is_null($platform->enableUntil)) {
537  $until = date("{$this->dateFormat} {$this->timeFormat}", $platform->enableUntil);
538  }
539  $last = null;
540  if (!is_null($platform->lastAccess)) {
541  $last = date($this->dateFormat, $platform->lastAccess);
542  }
543 
544  $platform->name = $platform->getTitle();//50UK
545  if (empty($id)) {
546  $platform->setRecordId($ilDB->nextId('lti2_consumer'));
547  $id = $platform->getRecordId();
548  $platform->created = $time;
549  $platform->updated = $time;
550 
551  // $query = "INSERT INTO {$this->dbTableNamePrefix}" . $this->CONSUMER_TABLE_NAME . ' (consumer_key256, consumer_key, name, ' .
552  $query = 'INSERT INTO lti2_consumer (consumer_key, name, ' .
553  'secret, lti_version, consumer_name, consumer_version, consumer_guid, profile, tool_proxy, settings, protected, enabled, ' .
554  'enable_from, enable_until, last_access, created, updated, consumer_pk, ext_consumer_id, ref_id, platform_id, client_id, deployment_id, public_key) ' .
555  'VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)';
556  $types = array("text",
557  "text",
558  "text",
559  "text",
560  "text",
561  "text",
562  "text",
563  "text",
564  "text",
565  "text",
566  "integer",
567  "integer",
568  "timestamp",
569  "timestamp",
570  "timestamp",
571  "timestamp",
572  "timestamp",
573  "integer",
574  'integer',
575  'integer',
576  "text",
577  "text",
578  "text",
579  "text"
580  );
581  $values = array($key,
582  $platform->name,
583  $platform->secret,
584  $platform->ltiVersion->value,
585  $platform->consumerName,
586  $platform->consumerVersion,
587  $platform->consumerGuid,
588  $profile,
589  $platform->toolProxy,
590  $settingsValue,
591  $protected,
592  $enabled,
593  $from,
594  $until,
595  $last,
596  $now,
597  $now,
598  $id,
599  $platform->getExtConsumerId(),
600  $platform->getRefId(),
601  (string) $platform->platformId,
602  $platform->clientId,
603  $platform->deploymentId,
604  $platform->rsaKey
605  );
606  $ilDB->manipulateF($query, $types, $values);
607  } else {
608  $platform->updated = $time;
609 
610  $query = 'UPDATE lti2_consumer SET ' .
611  'consumer_key = %s, name = %s, ' .
612  'secret= %s, lti_version = %s, consumer_name = %s, consumer_version = %s, consumer_guid = %s, ' .
613  'profile = %s, tool_proxy = %s, settings = %s, protected = %s, enabled = %s, ' .
614  'enable_from = %s, enable_until = %s, last_access = %s, updated = %s, ' .
615  'platform_id = %s, client_id = %s, deployment_id = %s, public_key = %s ' .
616  'WHERE consumer_pk = %s';
617  $types = array("text",
618  "text",
619  "text",
620  "text",
621  "text",
622  "text",
623  "text",
624  "text",
625  "text",
626  "text",
627  "integer",
628  "integer",
629  "timestamp",
630  "timestamp",
631  "timestamp",
632  "timestamp",
633  "text",
634  "text",
635  "text",
636  "text",
637  "integer"
638  );
639  $values = array($key,
640  $platform->name,
641  $platform->secret,
642  $platform->ltiVersion->value,
643  $platform->consumerName,
644  $platform->consumerVersion,
645  $platform->consumerGuid,
646  $profile,
647  $platform->toolProxy,
648  $settingsValue,
649  $protected,
650  $enabled,
651  $from,
652  $until,
653  $last,
654  $now,
655  $platform->platformId,
656  $platform->clientId,
657  $platform->deploymentId,
658  $platform->rsaKey,
659  $id
660  );
661  $ilDB->manipulateF($query, $types, $values);
662  }
663 
664  return true;
665  }
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:24
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ saveUserResult()

ilLTIDataConnector::saveUserResult ( User  $userresult)

Save user object.

Parameters
User$userUser object
Returns
boolean True if the user object was successfully saved

Definition at line 1615 of file class.ilLTIDataConnector.php.

References $database, Vendor\Package\$e, $ilDB, and ILIAS\Repository\logger().

1615  : bool
1616  {
1617  $ilDB = $this->database;
1618 
1619  $this->logger->info('Save user called with ' . $userresult->created);
1620 
1621  $time = time();
1622  $now = date($this->dateFormat . ' ' . $this->timeFormat, $time);
1623  if (is_null($userresult->created)) {
1624  // if (is_null($user->getRecordId())) {
1625  $userresult->setRecordId($ilDB->nextId($this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME));
1626  $userresult->created = $time;
1627  $rid = $userresult->getResourceLink()->getRecordId();
1628  $uid = $userresult->getId(IdScope::IdOnly);
1629  $query = 'INSERT INTO ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1630  '(user_pk,resource_link_pk,lti_user_id, lti_result_sourcedid, created, updated) ' .
1631  'VALUES( ' .
1632  $ilDB->quote($userresult->getRecordId(), 'integer') . ', ' .
1633  $ilDB->quote($rid, 'integer') . ', ' .
1634  $ilDB->quote($uid, 'text') . ', ' .
1635  $ilDB->quote($userresult->ltiResultSourcedId, 'text') . ', ' .
1636  $ilDB->quote($now, 'text') . ', ' .
1637  $ilDB->quote($now, 'text') .
1638  ')';
1639  } else {
1640  $query = 'UPDATE ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1641  'SET lti_result_sourcedid = ' . $ilDB->quote($userresult->ltiResultSourcedId, 'text') . ', ' .
1642  'updated = ' . $ilDB->quote($now, 'text') . ' ' .
1643  'WHERE user_pk = ' . $ilDB->quote($userresult->getRecordId(), 'integer');
1644  }
1645 
1646  $this->logger->debug('Saving user data with query: ' . $query);
1647 
1648  $ok = false;
1649  try {
1650  $ilDB->manipulate($query);
1651  $userresult->updated = $time;
1652  $ok = true;
1653  } catch (ilDatabaseException $e) {
1654  $this->logger->error($e->getMessage());
1655  }
1656 
1657  return $ok;
1658  }
+ Here is the call graph for this function:

Field Documentation

◆ $database

ilDBInterface ilLTIDataConnector::$database
private

Definition at line 35 of file class.ilLTIDataConnector.php.

Referenced by deleteContext(), deleteGlobalToolConsumerSettings(), deleteResourceLink(), deleteResourceLinkShareKey(), deleteToolConsumer(), deleteUser(), getGlobalToolConsumerSettings(), getToolConsumers(), getUserResultSourcedIDsResourceLink(), loadContext(), loadGlobalToolConsumerSettings(), loadPlatformNonce(), loadResourceLink(), loadResourceLinkShareKey(), loadUserResult(), lookupRecordIdByGlobalSettingsAndRefId(), lookupResourcesForAllUsersSinceDate(), lookupResourcesForUserObjectRelation(), saveContext(), saveGlobalToolConsumerSettings(), savePlatformNonce(), saveResourceLink(), saveResourceLinkShareKey(), saveToolConsumerILIAS(), and saveUserResult().

◆ $logger

ilLogger ilLTIDataConnector::$logger = null
private

Definition at line 33 of file class.ilLTIDataConnector.php.

The documentation for this class was generated from the following file: