function showCommunicationTable($message = '') { $headers[] = array('link' => setSessionParamsHref(array('page' => 'sysadmin.sms'), Language::linkSms()), 'label' => Language::linkSms()); $headers[] = array('link' => '', 'label' => Language::labelSMSCommunicationTable()); $returnStr = $this->showSmsHeader($headers); //CONTENT $returnStr .= $message; $urid = loadvar('selurid', 0); $returnStr .= $this->displayInterviewerDropDown('sysadmin.sms.communication', $urid); $communication = new Communication(); if ($urid > 0) { $list = $communication->getAllUserCommunication($urid); //getAllUserQueries($urid); $hnidTexts = array(); if (sizeof($list) > 0) { $returnStr .= '<br/><table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered">'; $returnStr .= '<tr><th>' . Language::labelSMSCommunicationTableHnid() . '</th><th>' . Language::labelSMSCommunicationTableTs() . '</th><th>' . Language::labelSMSCommunicationTableDataType() . '</th><th>' . Language::labelSMSCommunicationTableInsertTs() . '</th><th>' . Language::labelSMSCommunicationTableReceived() . '</th><th>' . Language::labelSMSCommunicationTableReceivedTs() . '</th><th>' . Language::labelSMSCommunicationTableDirection() . '</th><th>' . Language::labelSMSCommunicationTableFileName() . '</th></tr>'; foreach ($list as $item) { $returnStr .= '<tr><td>'; $hnidTexts[$item['hnid']] = cutOffString('SQL:<br/>' . $communication->decryptAndUncompress($item['sqlcode']), 800); $returnStr .= '<a title="' . Language::linkEditTooltip() . '" onclick="$(\'#hnid' . $item['hnid'] . '\').modal(\'show\');"><span class="glyphicon glyphicon-eye-open"></span></a>'; $returnStr .= ' <a title="' . Language::linkRemoveTooltip() . '" href="' . setSessionParams(array('page' => 'sysadmin.sms.communication.remove', 'hnid' => $item['hnid'])) . '&selurid=' . $urid . '"><span class="glyphicon glyphicon-remove"></span></a>'; $returnStr .= ' ' . $item['hnid'] . '</td>'; $returnStr .= '<td>' . $item['ts'] . '</td>'; $returnStr .= '<td>' . $item['datatype'] . '</td>'; $returnStr .= '<td>' . $item['insertts'] . '</td>'; $returnStr .= '<td>' . $item['received'] . '</td>'; $returnStr .= '<td>' . $item['receivedts'] . '</td>'; $returnStr .= '<td>' . $item['direction'] . '</td>'; $returnStr .= '<td>' . $item['filename'] . '</td>'; $returnStr .= '</tr>'; } $returnStr .= '</table>'; //modal forms foreach ($hnidTexts as $key => $text) { $returnStr .= $this->showModalForm('hnid' . $key, $text); } } else { $returnStr .= "<br/><br/>" . $this->displayInfo(Language::labelSMSCommunicationTableNoneFound()); } } // $returnStr .= '<input type="submit" class="btn btn-default" value="Update all interviewer laptops"/>'; // $returnStr .= '</form>'; $returnStr .= '</form>'; //END CONTENT $returnStr .= '</p></div> </div>'; //container and wrap $returnStr .= $this->showBottomBar(); $returnStr .= $this->showFooter(false); return $returnStr; }