FROM
cdr
WHERE
(`src` = ' . $ext . ' OR `dst` = ' . $ext . ')
AND
(`src` LIKE "0%" OR `dst` LIKE "0%" OR `src` LIKE "+%" OR `dst` LIKE "+%")
GROUP BY `number`
ORDER BY `start` DESC
LIMIT 5;
';
$results = $cdb->query($sql);
$calls = $results->fetchAll(PDO::FETCH_ASSOC);
// Generate lookup table
$count = 0;
foreach ($calls as $call) {
$calls_hist_json .= ($count++ > 0 ? ',' : '') . '{ "cid": "' . lookupNumber($call['number']) . '", "number": "' . $call['number'] . '", "start": "' . $call['start'] . '", "end": "' . $call['end'] . '" }';
}
function lookupNumber($number)
{
// Inefficient! Should probably do a single DB lookup "IN (xxx,xxx,xxx)" then match within PHP.
global $ciddb;
if ($ciddb == null) {
$ciddbhost = '148.251.46.243';
$ciddbport = '3306';
$ciddbuser = '******';
$ciddbpass = '******';
$ciddbschema = 'lalrorg_live_civicrm';
$ciddb = new PDO('mysql:host=' . $ciddbhost . ';port=' . $ciddbport . ';dbname=' . $ciddbschema . ';charset=utf8', $ciddbuser, $ciddbpass);
$ciddb->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$ciddb->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
}
echo asset_url('assets/i/ajax-loader.gif');
?>
" alt="..." />
<p class="sms-to-phone hide"><?php
echo $message[0]['contact'];
?>
</p>
<p class="from-phone hide"><?php
echo $phoneNumbers[0];
?>
</p>
</div>
<span class="phone-number">
<?php
if ($address_book) {
echo lookupNumber($message['caller']);
} else {
echo $message['caller'];
}
?>
</span>
</td>
<td class="message-content message-details-link" style="overflow: visible; white-space: normal">
<?php
echo $message['body'];
?>
</td>
<td>
<?php
if ($message['num_media'] > 0) {
foreach ($message['media'] as $media) {
echo $message[0]['contact'];
?>
</p>
<p class="from-phone hide"><?php
echo $phoneNumbers[0];
?>
</p>
</div>
<span class="phone-number">
<a href="<?php
echo site_url("p/messages/?to=" . urlencode($message[0]['contact']));
?>
" style="text-decoration:none" >
<?php
if ($address_book) {
echo lookupNumber($message[0]['contact']);
} else {
echo $message[0]['contact'];
}
?>
</a>
</span>
</td>
<td class="message-content">
<span class="transcript"><?php
echo $message[0]['body'];
?>
</span>
</td>
<td>
<?php