public static function pagedAuto($sql, $query_parms, $searchfields, $orderfields = false, $view = false, $params = false) { global $PDOX; $newsql = Table::pagedQuery($sql, $query_parms, $searchfields, $orderfields, $params); //echo("<pre>\n$newsql\n</pre>\n"); $rows = $PDOX->allRowsDie($newsql, $query_parms); Table::pagedTable($rows, $searchfields, $orderfields, $view, $params); }
header('Location: ' . $CFG->wwwroot . '/login.php'); return; } $query_parms = false; $searchfields = array("membership_id", "context_id", "user_id", "role", "role_override", "created_at", "updated_at", "email", "displayname", "user_key"); $sql = "SELECT membership_id AS Membership, context_id AS Context, M.user_id as User, \n role, role_override, M.created_at, M.updated_at, email, displayname, user_key\n FROM {$CFG->dbprefix}lti_membership as M\n JOIN {$CFG->dbprefix}lti_user AS U ON M.user_id = U.user_id\n WHERE context_id = :CID"; $query_parms = array(":CID" => $_REQUEST['context_id']); if (!isAdmin()) { die("Fix this"); $sql .= "\nWHERE R.user_id = :UID"; $query_parms = array(":UID" => $_SESSION['id']); } $newsql = Table::pagedQuery($sql, $query_parms, $searchfields); // echo("<pre>\n$newsql\n</pre>\n"); $rows = $PDOX->allRowsDie($newsql, $query_parms); $newrows = array(); foreach ($rows as $row) { $newrow = $row; $newrows[] = $newrow; } $OUTPUT->header(); $OUTPUT->bodyStart(); $OUTPUT->topNav(); $OUTPUT->flashMessages(); ?> <p> <a href="index.php" class="btn btn-default">View Contexts</a> </p> <?php Table::pagedTable($newrows, $searchfields); $OUTPUT->footer();
$msg = "result_id=" . $row['result_id'] . "\n" . "grade=" . $row['grade'] . " updated=" . $row['updated_at'] . "\n" . "server_grade=" . $row['server_grade'] . " retrieved=" . $row['retrieved_at'] . "\n" . "error=" . $server_grade; echo "Problem Updating Grade: " . session_safe_id() . " " . $msg; error_log("Problem Updating Grade: " . session_id() . "\n" . $msg . "\n" . "service=" . $row['service'] . " sourcedid=" . $row['sourcedid']); echo "\nProblem Retrieving Grade - Please take a screen shot of this page.\n"; echo "</pre>\n"; $newrow['note'] .= " Problem Updating Server Grade"; } } $newrows[] = $newrow; } // Make the grades percentages $showrows = array(); foreach ($newrows as $row) { $g = $row['grade'] * 100.0; $row['grade'] = sprintf("%1.1f", $g); $showrows[] = $row; } Table::pagedTable($showrows, $searchfields, $orderfields); } if ($summary_sql !== false) { Table::pagedAuto($summary_sql, $query_parms, $searchfields, $orderfields); } if ($class_sql !== false) { if ($link_info !== false) { echo "<p>Results for " . $link_info['title']; echo ' (<a href="maint.php?link_id=' . $link_id . '" target="_new">Maintenance tasks</a>)' . "</p>\n"; } Table::pagedAuto($class_sql, $query_parms, $searchfields); } $OUTPUT->footer();
// In the top frame, we use cookies for session. define('COOKIE_SESSION', true); require_once "../../config.php"; require_once $CFG->dirroot . "/pdo.php"; require_once $CFG->dirroot . "/lib/lms_lib.php"; use Tsugi\UI\Table; header('Content-Type: text/html; charset=utf-8'); session_start(); if (!isAdmin()) { $_SESSION['login_return'] = getUrlFull(__FILE__) . "/index.php"; header('Location: ' . $CFG->wwwroot . '/login.php'); return; } $query_parms = false; $searchfields = array("context_id", "key_id", "title", "created_at", "updated_at"); $sql = "SELECT context_id, title, key_id AS key_value, created_at, updated_at\n FROM {$CFG->dbprefix}lti_context"; $newsql = Table::pagedQuery($sql, $query_parms, $searchfields); // echo("<pre>\n$newsql\n</pre>\n"); $rows = $PDOX->allRowsDie($newsql, $query_parms); $newrows = array(); foreach ($rows as $row) { $newrow = $row; $newrows[] = $newrow; } $OUTPUT->header(); $OUTPUT->bodyStart(); $OUTPUT->topNav(); $OUTPUT->flashMessages(); Table::pagedTable($newrows, $searchfields, false, "membership.php"); $OUTPUT->footer();
} $OUTPUT->header(); $OUTPUT->bodyStart(); $OUTPUT->topNav(); $OUTPUT->flashMessages(); ?> <h1>LTI Keys</h1> <p> <a href="index.php" class="btn btn-default">View Key Requests</a> </p> <?php if (count($newrows) < 1) { ?> <p> You have no IMS LTI 1.1 Keys for this system. </p> <?php } else { Table::pagedTable($newrows, $searchfields, false, "key-detail.php"); } if (isAdmin()) { ?> <p> <a href="key-add.php" class="btn btn-default">Add Key</a> </p> <?php } ?> <?php $OUTPUT->footer();
<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button> <input type="submit" id="request_save" class="btn btn-primary" value="Submit Request"> </div> </form> </div><!-- /.modal-content --> </div><!-- /.modal-dialog --> </div><!-- /.modal --> <?php } if (count($newrows) < 1) { ?> <p> This server hosts various tools that can be integrated into a learning system using the IMS Learning Tools Interoperability standard. You can use this page to request access to this service. </p> <?php } else { Table::pagedTable($newrows, $searchfields, false, "request-detail.php"); } if ($goodsession) { ?> <p> <button type="button" class="btn btn-default" onclick="$('#request').modal();return false;">New Key Request</button> </p> <?php } ?> <?php $OUTPUT->footer();
foreach ($rows as $row) { $newrow = $row; $newrow['secret'] = '****'; $newrows[] = $newrow; } $OUTPUT->header(); $OUTPUT->bodyStart(); $OUTPUT->topNav(); $OUTPUT->flashMessages(); ?> <h1>LTI Keys</h1> <p> <a href="index.php" class="btn btn-default">View Key Requests</a> </p> <?php if (count($newrows) < 1) { ?> <p> You have no IMS LTI 1.1 Keys for this system. </p> <?php } else { $extra_buttons = array("Insert New Key" => "key-add.php"); Table::pagedTable($newrows, $searchfields, false, "key-detail.php", false, $extra_buttons); } if (isAdmin()) { } ?> <?php $OUTPUT->footer();