$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();