public function executeGetUserData(sfWebRequest $request)
{
$this->authorizeUser();
$params = $request->getGetParameters();
$sOrder = intval($params['iSortCol_0']);
if ($params['bSortable_' . $sOrder] != "true") {
$sOrder = 0;
}
$search_string = false;
if (isset($params['sSearch']) && strlen($params['sSearch']) > 2) {
$search_string = $params['sSearch'];
$s = '%' . strtolower($search_string) . '%';
$sql_params = array($s, $s, $s, $s);
}
$aaData = array();
$mhr_users = array();
$totalDisplayRecords = 0;
if ($search_string) {
foreach (GcrInstitutionTable::getInstitutions() as $institution) {
$institution_name = '<a href="' . $institution->getAppUrl() . '" target="_blank">' . $institution->getFullName() . '</a>';
$sql = 'select * from ' . $institution->getShortName() . '.mhr_usr ' . 'where deleted < 1 and id > 1 and (lower(firstname) like ? or lower(lastname) like ? or lower(email) like ? or lower(username) like ?)';
$mhr_users = $institution->gcQuery($sql, $sql_params);
if ($mhr_users && count($mhr_users) > 0) {
foreach ($mhr_users as $mhr_user) {
$fullname = trim($mhr_user->lastname) . ', ' . trim($mhr_user->firstname);
$fullname_url = '<a href="' . $institution->getAppUrl() . 'user/view?id=' . $mhr_user->id . '" target="_blank">' . trim($mhr_user->lastname) . ', ' . trim($mhr_user->firstname) . '</a>';
$username = trim($mhr_user->username);
$username_url = '<a href="/account/view?eschool=' . $institution->getShortName() . '&user='******'" target="_blank">' . $username . '</a>';
$email = trim($mhr_user->email);
$user_data = array($fullname_url, $username_url, $email, $institution_name, $mhr_user->lastaccess);
switch ($sOrder) {
case 1:
$key = $username;
break;
case 2:
$key = $email;
break;
case 3:
$key = $institution_name;
break;
case 4:
$key = $mhr_user->lastaccess;
break;
default:
$key = $fullname;
}
$aaData[strtolower($key)] = $user_data;
}
}
}
$totalDisplayRecords = count($aaData);
ksort($aaData);
$aaData = array_values($aaData);
if ($params['sSortDir_0'] == 'desc') {
$aaData = array_reverse($aaData);
}
if (isset($params['iDisplayStart']) && $params['iDisplayLength'] != '-1') {
$aaData = array_slice($aaData, $params['iDisplayStart'], $params['iDisplayLength']);
}
}
$this->getResponse()->setHttpHeader('Content-type', 'application/json');
$output = array("sEcho" => intval($params['sEcho']), "iTotalRecords" => count($aaData), "iTotalDisplayRecords" => $totalDisplayRecords, "aaData" => $aaData);
return $this->renderText(json_encode($output));
}
<input type="text" name="edit_commission_rate" id="edit_commission_rate" value="" />
</fieldset>
</form>
</div>
<div style="display:none" id="create-dialog-form" title="Create New Commission">
<p class="validateTips">Select the platform where users exist, and the catalog where those users may purchase courses at the specified commission rate, paid to the selected platform.</p>
<form id="createCommissionForm" name="createCommissionForm" action="<?php
print GcrEschoolTable::getHome()->getUrl() . '/homeadmin/createCommission';
?>
" method="POST">
<fieldset>
<label for="institution">Platform: </label>
<select id="institution" name="institution" style="width:95%">
<?php
foreach (GcrInstitutionTable::getInstitutions() as $institution) {
print "<option value={$institution->getShortName()}>{$institution->getFullName()} ({$institution->getShortName()})</option>";
}
?>
</select>
<label for="institution">Catalog: </label>
<select id="eschool" name="eschool" style="width:95%">
<?php
foreach (GcrEschoolTable::getEschools() as $eschool) {
print "<option value={$eschool->getShortName()}>{$eschool->getFullName()} ({$eschool->getShortName()})</option>";
}
?>
</select>
<label for="commission_rate">Commission Rate %: </label>
<input type="text" name="commission_rate" id="commission_rate" value="" />
</fieldset>
?>
<h2>GlobalClassroom Accounting Administration</h2>
Platform:
<select id="platformAccountSelector" style="max-width: 400px">
<script type="text/javascript">
jQuery('#platformAccountSelector').change(function ()
{
document.location.href = '<?php
print $CFG->current_app->getUrl();
?>
/account/view?eschool=' + jQuery(this).val();
});
</script>
<?php
$institutions = GcrInstitutionTable::getInstitutions();
foreach ($institutions as $institution) {
$sn = $institution->getShortName();
print '<option';
if ($sn == $app->getShortName()) {
print ' selected=selected';
}
print ' value="' . $sn . '">' . $institution->getFullName() . ' (' . $sn . ')</option>';
}
?>
</select>
<br />
<?php
} else {
?>
<h1><?php
