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>';
}
