Example #1
0
 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);
 }
Example #2
0
    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();
Example #3
0
                $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();
Example #4
0
// 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();
Example #5
0
File: keys.php Project: ixtel/tsugi
}
$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();
Example #6
0
        <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();
Example #7
0
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();