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