function showUsersList($users) { $returnStr = ''; $returnStr .= "<form id=refreshform method=post>"; $returnStr .= '<input type=hidden name=page value="sysadmin.users">'; $returnStr .= '<input type=hidden name="usertype" id="usertype_hidden">'; $returnStr .= "</form>"; $usertypes = array(-1 => Language::labelAll(), USER_INTERVIEWER => Language::labelInterviewer(), USER_NURSE => Language::labelNurse(), USER_SUPERVISOR => Language::labelSupervisor(), USER_TRANSLATOR => Language::labelTranslator(), USER_RESEARCHER => Language::labelResearcher(), USER_SYSADMIN => Language::labelSysadmin(), USER_TESTER => Language::labelTester()); $usertype = loadvar('usertype', USER_INTERVIEWER); $returnStr .= Language::labelUserFilter() . $this->displaySelectFromArray($usertypes, $usertype, 'usertype'); $returnStr .= "<script type='text/javascript'>"; $returnStr .= '$( document ).ready(function() { $("#usertype").change(function (e) { $("#usertype_hidden").val(this.value); $("#refreshform").submit(); }); })'; $returnStr .= "</script>"; if (sizeof($users) > 0) { $returnStr .= $this->displayDataTablesScripts(array("colvis", "rowreorder")); $returnStr .= "<script type='text/javascript'>\n \$(document).ready(function(){\n \$('#usertable').dataTable(\n {\n \"iDisplayLength\": " . sizeof($users) . ",\n dom: 'C<\"clear\">lfrtip',\n paginate: false,\n colVis: {\n activate: \"mouseover\",\n exclude: [ 0 ]\n }\n } \n ); \n });</script>\n "; // $returnStr .= $this->displayPopoverScript(); $returnStr .= '<br/><br/><table id="usertable" class="table table-striped table-bordered pre-scrollable table-condensed table-hover">'; $returnStr .= '<thead><tr><th></td><th>' . Language::labelUserUserName() . '</th><th>' . Language::labelUserUserNameName() . '</th><th>' . Language::labelUserUserType() . '</th></tr></thead>'; $returnStr .= '<tbody>'; $usertypes = array(USER_INTERVIEWER => Language::labelInterviewer(), USER_NURSE => Language::labelNurse(), USER_SUPERVISOR => Language::labelSupervisor(), USER_TRANSLATOR => Language::labelTranslator(), USER_RESEARCHER => Language::labelResearcher(), USER_SYSADMIN => Language::labelSysadmin(), USER_TESTER => Language::labelTester()); foreach ($users as $user) { $returnStr .= '<tr><td>'; $content = '<a id="' . $user->getUrid() . '_edit" title="' . Language::linkEditTooltip() . '" href="' . setSessionParams(array('page' => 'sysadmin.users.edituser', 'urid' => $user->getUrid())) . '"><span class="glyphicon glyphicon-edit"></span></a>'; $content .= ' <a id="' . $user->getUrid() . '_copy" title="' . Language::linkCopyTooltip() . '" href="' . setSessionParams(array('page' => 'sysadmin.users.copyuser', 'urid' => $user->getUrid())) . '" ' . confirmAction(language::messageCopyUser($user->getName()), 'COPY') . '><span class="glyphicon glyphicon-copyright-mark"></span></a>'; $content .= ' <a id="' . $user->getUrid() . '_remove" title="' . Language::linkRemoveTooltip() . '" href="' . setSessionParams(array('page' => 'sysadmin.users.removeuser', 'urid' => $user->getUrid())) . '" ' . confirmAction(language::messageRemoveUser($user->getName()), 'REMOVE') . '><span class="glyphicon glyphicon-remove"></span></a>'; $returnStr .= '<a rel="popover" id="' . $user->getUrid() . '_popover" data-placement="right" data-html="true" data-toggle="popover" data-trigger="hover" href="' . setSessionParams(array('page' => 'sysadmin.users.edituser', 'urid' => $user->getUrid())) . '"><span class="glyphicon glyphicon-hand-right"></span></a>'; $returnStr .= '<td>' . $user->getUsername() . '</td><td>' . $user->getName() . '</td>'; $returnStr .= '<td>' . $usertypes[$user->getUserType()] . '</td></tr>'; $returnStr .= $this->displayPopover("#" . $user->getUrid() . '_popover', $content); } $returnStr .= '</tbody>'; $returnStr .= '</table><br/><br/>'; } else { $returnStr .= "<br/><br/>" . $this->displayWarning(Language::messageNoUsersYet()); } return $returnStr; }
case "IssueCorrectiveWrit": IssueCorrectiveWrit(); case "GroupIssueWrit": GroupIssueWrit(); case "GroupCancelWrit": GroupCancelWrit(); case "selectPossibleTransferWrits": selectPossibleTransferWrits(); case "selectArrearTransferWrits": selectArrearTransferWrits(); case "transferAction": transferAction(); case "ArrearTransferAction": ArrearTransferAction(); case "confirmAction": confirmAction(); case "recalculate": recalculate(); case "calculate": calculate(); case "Prior_Corrective_Writ": Prior_Corrective_Writ(); case "Next_Corrective_Writ": Next_Corrective_Writ(); } function selectPersonWrt() { $query = "DROP TABLE IF EXISTS temp_sum_item_writs2"; PdoDataAccess::runquery($query); $qry = " CREATE TEMPORARY TABLE temp_sum_item_writs2 AS\n select sum(w.value) sumValue ,w.writ_id , w.writ_ver, w.staff_id\n\t\t\t\tfrom writ_salary_items w\n\t\t\t\t\tjoin staff s on(w.staff_id=s.staff_id)\n\t\t\t\t\tjoin persons p on(p.PersonID=? AND s.PersonID=p.PersonID)\n group by writ_id , writ_ver, staff_id"; PdoDataAccess::runquery($qry, array($_GET["Q0"]));
function getRespondentActionButtons($respondentOrHousehold, $refpage) { $content = ''; if ($respondentOrHousehold->hasFinalCode() && $respondentOrHousehold->isCompleted()) { //if not completed: can still be assigned to different iwer $content = $this->displayInfo(Language::labelSupervisorFinalCodeAssigned()); } else { if ($respondentOrHousehold instanceof Household) { // $content .= '<form method="post">'; // $content .= setSessionParamsPost(array('page' => 'supervisor.interviewer.respondent.reassign', 'primkey' => $respondentOrHousehold->getPrimkey())); $users = new Users(); $users = $users->getUsersBySupervisor($_SESSION['URID']); // $content .= $this->displayUsers($users, $respondentOrHousehold->getUrid()); // $content .= '<br/>'; // $content .= '<input type="submit" class="btn btn-default" value="Reassign"/>'; // $content .= '</form>'; $content .= $this->showActionBar(Language::labelSupervisorAssignToInterviewer(), $this->displayUsers($users, $respondentOrHousehold->getUrid(), 'uridsel', false, true), 'Reassign', setSessionParamsPost(array('page' => 'supervisor.interviewer.household.reassign', 'primkey' => $respondentOrHousehold->getPrimkey())), confirmAction('Are you sure you want to reassign this household? Make sure the intervier data for this household has been uploaded, otherwise data wil be lost! Type YES to continue.', 'YES')); if (!$respondentOrHousehold->hasFinalCode()) { $content .= $this->showActionBar(Language::labelSupervisorAssignFinalStatus(), $this->displayFinalStatusCodesSelect($respondentOrHousehold->getUrid()), 'Set status', setSessionParamsPost(array('page' => 'supervisor.interviewer.household.contact.setstatus', 'primkey' => $respondentOrHousehold->getPrimkey())), confirmAction('Are you sure you want to reassign this household? Type YES to continue.', 'YES')); } } else { if (!$respondentOrHousehold->hasFinalCode()) { $content .= $this->showActionBar(Language::labelSupervisorAssignFinalStatus(), $this->displayFinalStatusCodesSelect($users, $respondentOrHousehold->getUrid()), 'Set status', setSessionParamsPost(array('page' => 'supervisor.interviewer.household.respondent.contact.setstatus', 'primkey' => $respondentOrHousehold->getPrimkey())), confirmAction('Are you sure you want to assign a final status code to this respondent? Type YES to continue.', 'YES')); } else { $content = $this->displayInfo(Language::labelSupervisorFinalCodeAssigned()); } } } //NEEDS VALIDATION? if ($respondentOrHousehold instanceof Respondent) { if ($respondentOrHousehold->needsValidation()) { $beforeText = '<button type="button" class="btn btn-warning" data-toggle="modal" data-target="#myModal">' . Language::labelSupervisorCheckAnswers() . '</button>'; $content .= ' <!-- Modal --> <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span><span class="sr-only">Close</span></button> <h4 class="modal-title" id="myModalLabel">' . Language::labelSupervisorCheckRespondentAnswers() . '</h4> </div> <div class="modal-body"> <table> <thead><tr><th>' . Language::labelSupervisorCheckRespondentQuestion() . '</th><th>' . Language::labelSupervisorCheckRespondentAnswer() . '</th></tr></thead> <tbody>'; $validationQuestions = Language::validationQuestions(); $survey = new Survey(2); foreach ($validationQuestions as $question) { $var = $survey->getVariableDescriptiveByName(getBasicName($question)); $content .= '<tr><td>' . $question . ': ' . $var->getDescription() . '</td><td>'; $content .= '</td></tr>'; } $content .= '</tbody></table>'; // $content .= json_encode($survey); $content .= ' </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">' . Language::buttonClose() . '</button> </div> </div> </div> </div> '; $content .= $this->showActionBar(Language::labelSupervisorCheckRespondentValidate(), $this->displayValidationStatus(Language::optionsSupervisorValidation(), $respondentOrHousehold->getUrid(), 'validationsel', false, $beforeText), 'Set validation status', setSessionParamsPost(array('page' => 'supervisor.interviewer.household.respondent.setvalidation', 'primkey' => $respondentOrHousehold->getPrimkey()))); } } return $content; }
function showImport($content = "") { $returnStr = $this->showToolsHeader(Language::headerToolsImporter()); $returnStr .= $this->displayComboBox(); $returnStr .= $content; $returnStr .= "<form id=refreshform method=post>"; $returnStr .= '<input type=hidden name=page value="sysadmin.tools.import">'; $returnStr .= '<input type=hidden name="' . SMS_POST_IMPORTTYPE . '" id="' . SMS_POST_IMPORTTYPE . '_hidden" value="">'; $returnStr .= "</form>"; $returnStr .= '<form method="post" enctype="multipart/form-data">'; $returnStr .= setSessionParamsPost(array('page' => 'sysadmin.tools.importres')); $returnStr .= '<span class="label label-default">' . Language::labelToolsImportSettings() . '</span>'; $returnStr .= '<div class="well well-sm">'; $returnStr .= '<table>'; $sel = array(IMPORT_TYPE_BLAISE => "", IMPORT_TYPE_MMIC => "", IMPORT_TYPE_NUBIS => ""); if (loadvar(SMS_POST_IMPORTTYPE) != "") { $sel[loadvar(SMS_POST_IMPORTTYPE)] = "SELECTED"; } $returnStr .= '<tr><td>' . Language::labelToolsImportType() . "</td>\n <td><select onchange='document.getElementById(\"" . SMS_POST_IMPORTTYPE . "_hidden\").value=this.value; document.getElementById(\"refreshform\").submit();' class='selectpicker show-tick' name='" . SETTING_IMPORT_TYPE . "'>" . ' <option ' . $sel[IMPORT_TYPE_NUBIS] . ' value=' . IMPORT_TYPE_NUBIS . '>' . Language::labelToolsImportTypeNubis() . '</option> <option ' . $sel[IMPORT_TYPE_MMIC] . ' value=' . IMPORT_TYPE_MMIC . '>' . Language::labelToolsImportTypeMMIC() . '</option> </select></td> </tr>'; $returnStr .= '<tr><td>' . Language::labelToolsImportTarget() . '</td> <td><select class="selectpicker show-tick" name="' . SETTING_IMPORT_AS . '"> <option value=' . IMPORT_TARGET_ADD . '>' . Language::labelToolsImportTargetAdd() . '</option> <option value=' . IMPORT_TARGET_REPLACE . '>' . Language::labelToolsImportTargetReplace() . '</option>'; $returnStr .= '</select></td> </tr>'; $returnStr .= '</table>'; $returnStr .= '</div>'; if (loadvar(SMS_POST_IMPORTTYPE) == IMPORT_TYPE_MMIC) { $returnStr .= '<span class="label label-default">' . Language::labelToolsImportDatabase() . '</span>'; $returnStr .= '<div class="well well-sm">'; $returnStr .= '<table>'; $returnStr .= '<tr><td>' . Language::labelDatabaseServer() . '</td><td><input class="form-control" type=text name="' . SETTING_IMPORT_SERVER . '" placeholder="localhost" /></td></tr>'; $returnStr .= '<tr><td>' . Language::labelDatabaseName() . '</td><td><input class="form-control" type=text name="' . SETTING_IMPORT_DATABASE . '" value="" /></td></tr>'; $returnStr .= '<tr><td>' . Language::labelDatabaseUsername() . '</td><td><input class="form-control" type=text name="' . SETTING_IMPORT_USER . '" value="" /></td></tr>'; $returnStr .= '<tr><td>' . Language::labelDatabasePassword() . '</td><td><input class="form-control" type=password name="' . SETTING_IMPORT_PASSWORD . '" /></td></tr>'; $returnStr .= '<tr><td>' . Language::labelDatabaseTablename() . '</td><td><input class="form-control" type=text name="' . SETTING_IMPORT_TABLE . '" value="" /></td></tr>'; $returnStr .= '</table>'; $returnStr .= '</div>'; } else { $returnStr .= '<span class="label label-default">' . Language::labelToolsImportFile() . '</span>'; $returnStr .= '<div class="well well-sm">'; //$returnStr .= "<textarea placeholder='Paste contents of export file here' class='form-control' style='min-width: 300px; width: 100%; min-height: 300px;' name='" . SETTING_IMPORT_TEXT . "'></textarea>"; $returnStr .= '<div style="position:relative;"><a class="btn btn-primary" href="javascript:;">' . Language::buttonBrowse() . ' <input type="file" style="position:absolute;z-index:2;top:0;left:0;filter: alpha(opacity=0);-ms-filter:\'progid:DXImageTransform.Microsoft.Alpha(Opacity=0)\';opacity:0;background-color:transparent;color:transparent;" name="' . SETTING_IMPORT_TEXT . '" size="40" onchange=\'$("#upload-file-info").html($(this).val());\'> </a> <span class="label label-info" id="upload-file-info"></span></div>'; $returnStr .= '</div>'; } $returnStr .= '<input type="submit" class="btn btn-default" ' . confirmAction(language::messageImportSurvey(), 'IMPORT') . ' value="' . Language::buttonImport() . '"/>'; $returnStr .= '</form>'; //END CONTENT $returnStr .= '</p></div> </div>'; //container and wrap $returnStr .= $this->showBottomBar(); $returnStr .= $this->showFooter(false); return $returnStr; }
function showSurveyData($message = '') { echo ' <ol class="breadcrumb"> <li><a href="?page=surveys">Surveys</a></li> <li><a href="?page=survey">' . $this->survey->getName($_SESSION['language']) . '</a></li> <li class="active">' . 'Data' . '</li> </ol>'; echo '<div class="well" style="background: white;">'; echo $message; echo 'Number of records: '; $db = $this->survey->getDatabase(); echo $db->count(); echo '<br/><br/>'; echo '<div class="list-group">'; echo '<a href="?page=survey.data.truncate" class="list-group-item" ' . confirmAction('Are you sure you want to truncate the data? Type \\\'TRUNCATE\\\' to continue.', 'TRUNCATE') . '>Truncate data</a>'; echo '<a href="?page=survey.data.stata" class="list-group-item">Export to stata</a>'; echo '<a href="?page=survey.data.csv" class="list-group-item">Export to csv</a>'; echo '</div>'; }