$sql = "SELECT c. *\r\n\t\t\t\t\t\tFROM contact_phone AS c\r\n\t\t\t\t\t\tLEFT JOIN (\r\n\t\t\t\t\t\t\t\tSELECT contact_phone.contact_phone_id\r\n\t\t\t\t\t\t\t\tFROM contact_phone\r\n\t\t\t\t\t\t\t\tLEFT JOIN `call` ON ( call.contact_phone_id = contact_phone.contact_phone_id )\r\n\t\t\t\t\t\t\t\tLEFT JOIN outcome ON ( call.outcome_id = outcome.outcome_id )\r\n\t\t\t\t\t\t\t\tWHERE contact_phone.case_id = '{$case_id}'\r\n\t\t\t\t\t\t\t\tAND outcome.tryagain =0\r\n\t\t\t\t\t\t\t ) AS l ON l.contact_phone_id = c.contact_phone_id\r\n\t\t\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t\t(\r\n\t\t\t\t\t\t SELECT contact_phone_id\r\n\t\t\t\t\t\t FROM `call`\r\n\t\t\t\t\t\t WHERE call_attempt_id = '{$ca}'\r\n\t\t\t\t\t\t AND outcome_id NOT IN (15,18)\r\n\t\t\t\t\t\t) as ca on ca.contact_phone_id = c.contact_phone_id\r\n\t\t\t\t\t\tWHERE c.case_id = '{$case_id}'\r\n\t\t\t\t\t\tAND l.contact_phone_id IS NULL\r\n\t\t\t\t\t\tAND ca.contact_phone_id IS NULL\r\n\t\t\t\t\t\torder by c.priority ASC";
}
$rs = $db->GetRow($sql);
if (!empty($rs)) {
$contact_phone_id = $rs['contact_phone_id'];
if (!isset($rs['respondent_id'])) {
$sql = "SELECT respondent_id\r\n\t\t\t\t\t\t\tFROM respondent\r\n\t\t\t\t\t\t\tWHERE case_id = {$case_id}";
$respondent_id = $db->GetOne($sql);
} else {
$respondent_id = $rs['respondent_id'];
}
$call_id = get_call($operator_id, $respondent_id, $contact_phone_id, true);
}
}
if (!is_respondent_selection($operator_id)) {
$data = get_limesurvey_url($operator_id);
} else {
$data = get_respondentselection_url($operator_id, true, true);
}
//use second interface
xhtml_object($data, "main-content", "embeddedobject content");
?>
</div>
</div>
<?php
xhtml_foot();
//if ($db->HasFailedTrans()){ print "<p>FAILED AT END of index</p>"; exit();}
$db->CompleteTrans();
<ul><li><a href="?page=clients.php"><?php
echo T_("Add clients");
?>
</a></li>
<li><a href="?page=clientquestionnaire.php"><?php
echo T_("Assign clients to forms");
?>
</a></li></ul></li>
<li><h3><?php
echo T_("System setup");
?>
</h3>
<ul><li><a href="?page=pagesetup.php"><?php
echo T_("Page setup");
?>
</a></li>
<li><a href="?page=testconfig.php"><?php
echo T_("Test configuration");
?>
</a></li></ul></li>
</ul>
</div>
<?php
$page = "testconfig.php";
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
print "<div id='main'>";
xhtml_object($page, "mainobj");
print "</div>";
xhtml_foot();
print T_("VoIP") . " " . T_("Disabled");
?>
<i class="fa fa-toggle-off pull-right" style="font-size:1.5em !important; margin-right:20px;"></i></span></a></li>
<?php
}
?>
</ul>
</div>
<!-- Main page container -->
<?php
$page = "questionnairelist.php";
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
?>
<div class="mainbar" id=" "><?php
xhtml_object($page, ' ');
?>
</div>
<div class="clearfix"></div>
</div>
<script src="../include/jquery/jquery.min.js"></script>
<script src="../include/bootstrap/js/bootstrap.min.js"></script>
<script type="text/javascript" src="../js/admin.js"></script>
</body>
</html>
$sql = "SELECT o.description as des, o.outcome_id, count( c.case_id ) as count\r\n\t\t\t\tFROM `case` AS c, `outcome` AS o\r\n\t\t\t\tWHERE c.questionnaire_id = '{$questionnaire_id}'\r\n\t\t\t\tAND c.current_outcome_id = o.outcome_id\r\n\t\t\t\tGROUP BY o.outcome_id";
$rs = $db->GetAll($sql);
if (!empty($rs)) {
translate_array($rs, array("des"));
xhtml_table($rs, array("des", "count"), array(T_("Outcome"), T_("Count")), "tclass", array("des" => "Complete"), array("count"));
} else {
print "<p class='alert alert-info'>" . T_("No outcomes recorded for this questionnaire") . "</p>";
}
print "</br><a href=\"?qsid={$qsid}\" class=\"btn btn-default btn-block btn-lime\">" . T_("View summary results") . "</a></div></div>";
}
if (isset($_GET['qsid'])) {
$qsid = intval($_GET['qsid']);
$page = LIME_URL . "admin/admin.php?action=browse&sid={$qsid}";
} else {
$page = '';
}
if ($page) {
?>
<div class="col-lg-10 pull-right" id=" " style="height:820px;">
<?php
xhtml_object($page, ' ', "full");
?>
</div>
<?php
}
}
} else {
print "<p class='alert alert-danger'>" . T_("You are not a valid client") . "</p>";
}
xhtml_foot();
<?php
if (TAB_INFO) {
?>
<div class="tabbertab <?php
if (DEFAULT_TAB == 'info' && !$appointment || DEFAULT_TAB_APPOINTMENT == 'info' && $appointment) {
print "tabbertabdefault";
}
?>
">
<h2><?php
echo T_("Info");
?>
</h2>
<div id="div-info" class="tabberdiv"><?php
xhtml_object("info.php", "main-info");
?>
</div>
</div>
<?php
}
?>
</div>
</div>
<?php
xhtml_foot();
if ($process_function == false) {
//search area
print "<div id='searcharea'><label for='search'>" . T_("Search") . ":</label><input type='text' id='search' name='search'/> <span id='searchclick'>" . T_("Click here to search (or press enter)") . "</span></div>";
//coding
print "<div class='header' id='header'>";
if ($code_id == false) {
display_codes($work_unit_id, $operator_id, $cdata[0]);
} else {
display_all_codes($code_id, true, $work_unit_id);
}
print "</div>";
} else {
if (is_callable($process_function)) {
call_user_func($process_function, $cell_id, $cdata[0], $work_unit_id);
} else {
print "<p>" . T_("Error: Cannot execute process function:") . " {$process_function}</p>";
}
}
print "<input type='hidden' name='work_unit_id' value='{$work_unit_id}'/></div>";
print "</form>";
}
print "</div>";
print "<div id='workhistory'>";
xhtml_object("workhistory.php", "work-history");
print "<div id='performance'>";
xhtml_object("performance.php", "performancetab");
print "</div>";
} else {
p(T_("No operator"), "p");
}
xhtml_foot();
