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 global tool consumer settings in consumer. More... | |
| lookupRecordIdByGlobalSettingsAndRefId (ilLTIPlatform $platform) | |
| Lookup record id for global settings and ref_id. More... | |
| saveGlobalToolConsumerSettings (ilLTIPlatform $platform) | |
| Save lti_ext_consumer. 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) | |
| Load nonce object. 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.
41 {
42 global $DIC;
43 $this->database = $DIC->database();
44
46 $this->db = null;
47 $this->dbTableNamePrefix = "";
48 }
static getLogger(string $a_component_id)
Get component logger.
Definition: class.ilLoggerFactory.php:89
References $DIC, ILIAS\Repository\database(), ilLoggerFactory\getLogger(), and ILIAS\Repository\logger().
Here is the call graph for this function:
Member Function Documentation
◆ deleteContext()
| ilLTIDataConnector::deleteContext | ( | Context | $context | ) |
Delete context object.
- Parameters
-
Context $context Context object
- Returns
- boolean True if the Context object was successfully deleted
Definition at line 1031 of file class.ilLTIDataConnector.php.
1031 : bool
1032 {
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 }
◆ deleteGlobalToolConsumerSettings()
| ilLTIDataConnector::deleteGlobalToolConsumerSettings | ( | ilLTIPlatform | $platform | ) |
Delete global tool consumer settings.
Definition at line 670 of file class.ilLTIDataConnector.php.
670 : bool
671 {
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 }
References $database, $ilDB, ilLTIPlatform\getExtConsumerId(), and ilLTIPlatform\initialize().
Referenced by ilLTIPlatform\deleteGlobalToolConsumerSettings().
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 $resourceLink Resource_Link object
- Returns
- boolean True if the resource link object was successfully deleted
Definition at line 1285 of file class.ilLTIDataConnector.php.
1285 : bool
1286 {
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 $shareKey Resource 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.
1546 : bool
1547 {
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 }
References $ilDB.
◆ deleteToolConsumer()
| ilLTIDataConnector::deleteToolConsumer | ( | DataConnectorPlatform | $platform | ) |
Delete tool consumer object.
- Parameters
-
Platform $platform Consumer object
- Returns
- boolean True if the tool consumer object was successfully deleted
Definition at line 699 of file class.ilLTIDataConnector.php.
699 : bool
700 {
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 $user User object
- Returns
- boolean True if the user object was successfully deleted
Definition at line 1665 of file class.ilLTIDataConnector.php.
1665 : bool
1666 {
1668
1669 $query = 'DELETE from ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1671
1672 $ok = false;
1673 try {
1674 $ilDB->manipulate($query);
1675 $user->initialize();
1676 $ok = true;
1679 }
1680 return $ok;
1681 }
References Vendor\Package\$e, $ilDB, and ILIAS\Repository\logger().
Here is the call graph for this function:
◆ getDataConnector()
|
static |
Definition at line 1746 of file class.ilLTIDataConnector.php.
Referenced by ilLTIPlatform\__construct(), and ilLTITool\__construct().
Here is the caller graph for this function:
◆ getGlobalToolConsumerSettings()
| ilLTIDataConnector::getGlobalToolConsumerSettings | ( | ) |
Get global consumer settings.
- Returns
- \ilLTIPlatform[]
Definition at line 810 of file class.ilLTIDataConnector.php.
810 : array
811 {
813
814 $platforms = array();
815 $query = 'SELECT * from lti_ext_consumer ';
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 }
References $database, $ilDB, $res, and ilDBConstants\FETCHMODE_OBJECT.
◆ getToolConsumers()
| ilLTIDataConnector::getToolConsumers | ( | ) |
- Returns
- \ilLTIPlatform[]
Definition at line 839 of file class.ilLTIDataConnector.php.
839 : array
840 {
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)) {
860 // if ($rsConsumer) {
862 // $platform = new Tool\Platform($row->consumer_key, $this); //ACHTUNG: FEHLER IN BIBLIOTHEK; $row->consumer_key ist i.d.R. null
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 }
◆ 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 $resourceLink Resource link object boolean $localOnly True if only users within the resource link are to be returned (excluding users sharing this resource link) IdScope $idScope Scope value to use for user IDs
- Returns
- array Array of User objects
Definition at line 1340 of file class.ilLTIDataConnector.php.
1344 : array {
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 $context Context object
- Returns
- boolean True if the context object was successfully loaded
Definition at line 947 of file class.ilLTIDataConnector.php.
947 : bool
948 {
950 $ok = false;
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");
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 }
◆ loadGlobalToolConsumerSettings()
| ilLTIDataConnector::loadGlobalToolConsumerSettings | ( | ilLTIPlatform | $platform | ) |
Load global tool consumer settings in consumer.
- Parameters
-
ilLTIPlatform $platform
- Returns
- bool
Definition at line 200 of file class.ilLTIDataConnector.php.
200 : bool
201 {
203
204 $query = 'SELECT * from lti_ext_consumer where id = ' . $ilDB->quote($platform->getExtConsumerId(), 'integer');
207 $platform->setTitle($row->title);
208 $platform->setDescription($row->description);
209 $platform->setPrefix($row->prefix);
210 $platform->setLanguage($row->user_language);
213 return true;
214 }
215 return false;
216 }
setDescription(string $description)
Definition: class.ilLTIPlatform.php:186
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().
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 $platform Platform object
- Returns
- boolean True if the tool consumer object was successfully loaded
Definition at line 58 of file class.ilLTIDataConnector.php.
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 ';
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) {
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
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 }
from(FileStream $stream)
Definition: GdImageToStreamTrait.php:49
References $id, $res, ILIAS\Repository\database(), ILIAS\ResourceStorage\Flavour\Machine\DefaultMachines\from(), ilLTIPlatform\setExtConsumerId(), and ilLTIPlatform\setRefId().
Here is the call graph for this function:
◆ loadPlatformNonce()
| ilLTIDataConnector::loadPlatformNonce | ( | PlatformNonce | $nonce | ) |
Load nonce object.
- Parameters
-
PlatformNonce $nonce Nonce object
- Returns
- boolean True if the nonce object was successfully loaded
Definition at line 1425 of file class.ilLTIDataConnector.php.
1425 : bool
1426 {
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 }
References $ilDB.
◆ loadResourceLink()
| ilLTIDataConnector::loadResourceLink | ( | ResourceLink | $resourceLink | ) |
Load resource link object.
- Parameters
-
ResourceLink $resourceLink Resource_Link object
- Returns
- boolean True if the resource link object was successfully loaded
Definition at line 1093 of file class.ilLTIDataConnector.php.
1093 : bool
1094 {
1096
1097 $ok = false;
1098 $id = $resourceLink->getRecordId();
1099 $rid = 0;
1100 $cid = 0;
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");
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 }
References $database, $id, $ilDB, and ILIAS\Repository\logger().
Here is the call graph for this function:
◆ loadResourceLinkShareKey()
| ilLTIDataConnector::loadResourceLinkShareKey | ( | ResourceLinkShareKey | $shareKey | ) |
Load resource link share key object.
- Parameters
-
ResourceLinkShareKey $shareKey Resource_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.
1481 : bool
1482 {
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 }
◆ loadUserResult()
| ilLTIDataConnector::loadUserResult | ( | User | $userresult | ) |
Load user object.
- Parameters
-
User $userresult User object
- Returns
- boolean True if the user object was successfully loaded
Definition at line 1572 of file class.ilLTIDataConnector.php.
1572 : bool
1573 {
1575 $id = $userresult->getRecordId();
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 . ' ' .
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 . ' ' .
1588 }
1589
1591
1592 $ok = false;
1593 try {
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 }
1606 }
1607 return $ok;
1608 }
References Vendor\Package\$e, $id, $ilDB, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\Repository\logger().
Here is the call graph for this function:
◆ lookupRecordIdByGlobalSettingsAndRefId()
| ilLTIDataConnector::lookupRecordIdByGlobalSettingsAndRefId | ( | ilLTIPlatform | $platform | ) |
Lookup record id for global settings and ref_id.
- Parameters
-
ilLTIPlatform $platform
- Returns
- int|null
Definition at line 314 of file class.ilLTIDataConnector.php.
314 : ?int
315 {
316 $db = $this->database;
317
318 $query = 'SELECT consumer_pk from lti2_consumer ' .
321 $res = $db->query($query);
323 return (int) $row->consumer_pk;
324 }
325 return null;
326 }
quote($value, string $type)
References $database, $res, ilDBConstants\FETCHMODE_OBJECT, ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\getRefId(), and ilDBInterface\quote().
Referenced by ilLTIPlatform\fromGlobalSettingsAndRefId().
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.
1726 : array
1727 {
1728 $db = $this->database;
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') . ' ' .
1737 $res = $db->query($query);
1738
1739 $results = [];
1741 $results[$row->id . '__' . $row->lti_user_id][] = $row->resource_link_pk . '__' . $row->ref_id;
1742 }
1744 }
get(int $a_format, string $a_format_str='', string $a_tz='')
get formatted date
Definition: class.ilDateTime.php:477
References $res, $results, ilDBConstants\FETCHMODE_OBJECT, ilDateTime\get(), ilLoggerFactory\getLogger(), and IL_CAL_DATETIME.
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.
1696 : array {
1697 $db = $this->database;
1698
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');
1710 $resource_links = [];
1711 try {
1712 $res = $db->query($query);
1714 $resource_links[] = $row->resource_link_pk;
1715 }
1718 }
1719 return $resource_links;
1720 }
Referenced by ilLTIAppEventListener\handleOutcomeWithoutLP().
Here is the caller graph for this function:
◆ saveContext()
| ilLTIDataConnector::saveContext | ( | Context | $context | ) |
Save context object.
- Parameters
-
Context $context Context object
- Returns
- boolean True if the context object was successfully saved
Definition at line 990 of file class.ilLTIDataConnector.php.
990 : bool
991 {
993
994 $time = time();
995 $now = date("{$this->dateFormat} {$this->timeFormat}", $time);
996 //old: $settingsValue = serialize($context->getSettings());
997 $settingsValue = json_encode($context->getSettings());
999 $platform_pk = $context->getPlatform()->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");
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");
1017 }
1018 $ok = (bool) $ilDB->manipulateF($query, $types, $values);
1019 if ($ok) {
1020 $context->updated = $time;
1021 }
1022
1023 return $ok;
1024 }
◆ saveGlobalToolConsumerSettings()
| ilLTIDataConnector::saveGlobalToolConsumerSettings | ( | ilLTIPlatform | $platform | ) |
Save lti_ext_consumer.
Definition at line 474 of file class.ilLTIDataConnector.php.
474 : bool
475 {
477
479 // create
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 ' .
506 $ilDB->manipulate($query);
507 return true;
508 }
509 }
References $database, $ilDB, ilLTIPlatform\getActive(), ilLTIPlatform\getDescription(), ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\getLanguage(), ilLTIPlatform\getPrefix(), ilLTIPlatform\getRole(), ilLTIPlatform\getTitle(), and ilLTIPlatform\setExtConsumerId().
Referenced by ilLTIPlatform\saveGlobalToolConsumerSettings().
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 $nonce Nonce object
- Returns
- boolean True if the nonce object was successfully saved
Definition at line 1457 of file class.ilLTIDataConnector.php.
1457 : bool
1458 {
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 }
References $ilDB.
◆ saveResourceLink()
| ilLTIDataConnector::saveResourceLink | ( | ResourceLink | $resourceLink | ) |
Save resource link object.
- Parameters
-
ResourceLink $resourceLink Resource_Link object
- Returns
- boolean True if the resource link object was successfully saved
Definition at line 1176 of file class.ilLTIDataConnector.php.
1176 : bool
1177 {
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();
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);
1269 // $this->logger->logStack();
1272
1273 if ($ok) {
1274 $resourceLink->updated = $time;
1275 }
1276
1277 return $ok;
1278 }
References $database, $id, $ilDB, ilLogLevel\DEBUG, and ILIAS\Repository\logger().
Here is the call graph for this function:
◆ saveResourceLinkShareKey()
| ilLTIDataConnector::saveResourceLinkShareKey | ( | ResourceLinkShareKey | $shareKey | ) |
Save resource link share key object.
- Parameters
-
ResourceLinkShareKey $shareKey Resource 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.
1521 : bool
1522 {
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 }
References $ilDB.
◆ saveToolConsumerILIAS()
| ilLTIDataConnector::saveToolConsumerILIAS | ( | ilLTIPlatform | $platform | ) |
Save extended tool consumer object with ILIAS extensions.
- Parameters
-
ilLTIPlatform $platform Consumer object
- Returns
- boolean True if the tool consumer object was successfully saved
Definition at line 516 of file class.ilLTIDataConnector.php.
516 : bool
517 {
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
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 }
References $database, $id, $ilDB, ilLTIPlatform\getExtConsumerId(), ilLTIPlatform\getRefId(), and ilLTIPlatform\getTitle().
Referenced by ilLTIPlatform\saveLTI().
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 $user User object
- Returns
- boolean True if the user object was successfully saved
Definition at line 1615 of file class.ilLTIDataConnector.php.
1615 : bool
1616 {
1618
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( ' .
1638 ')';
1639 } else {
1640 $query = 'UPDATE ' . $this->dbTableNamePrefix . DataConnector::USER_RESULT_TABLE_NAME . ' ' .
1644 }
1645
1647
1648 $ok = false;
1649 try {
1650 $ilDB->manipulate($query);
1651 $userresult->updated = $time;
1652 $ok = true;
1654 $this->logger->error($e->getMessage());
1655 }
1656
1657 return $ok;
1658 }
References Vendor\Package\$e, $ilDB, and ILIAS\Repository\logger().
Here is the call graph for this function:
Field Documentation
◆ $database
|
private |
Definition at line 35 of file class.ilLTIDataConnector.php.
Referenced by deleteContext(), deleteGlobalToolConsumerSettings(), deleteResourceLink(), deleteToolConsumer(), getGlobalToolConsumerSettings(), getToolConsumers(), loadContext(), loadGlobalToolConsumerSettings(), loadResourceLink(), lookupRecordIdByGlobalSettingsAndRefId(), saveContext(), saveGlobalToolConsumerSettings(), saveResourceLink(), and saveToolConsumerILIAS().
◆ $logger
|
private |
Definition at line 33 of file class.ilLTIDataConnector.php.
The documentation for this class was generated from the following file:
- components/ILIAS/LTIProvider/classes/class.ilLTIDataConnector.php
