function render_page()
{
global $ss;
scripts_i18n();
page_head();
echo '<div id="main">';
echo '<h2>' . __('Latest visitors') . '</h2>';
$page_size = 20;
$offset = isset($_GET['offset']) ? abs(intval($_GET['offset'])) : 0;
$query = "SELECT * FROM `{$ss->tables['visits']}` ORDER BY `date` DESC, `start_time` DESC LIMIT {$offset},{$page_size}";
$visits = array();
if ($result = $ss->query($query)) {
while ($assoc = @mysql_fetch_assoc($result)) {
$visits[] = $assoc;
}
}
$ua = new SimpleStatsUA();
echo '<table id="paths" class="center wide" data-offset="' . $offset . '" data-page_size="' . $page_size . '"><thead>';
echo '<tr><th colspan="2" class="left">' . __('IP Address') . '/' . __('Pages');
echo '<th>' . __('Time');
echo '<th>' . __('Browser');
echo '<th>' . __('Operating system');
echo '<th>' . __('Country');
echo '<tbody>';
foreach ($visits as $visit) {
$start_ts = strtotime($visit['date'] . ' ' . $visit['start_time']);
$hits = explode("\n", $visit['resource']);
$dy_label = strftime('%d %b', $start_ts);
$start_ts = date('H:i', $start_ts);
$full_ua = $ss->options['log_user_agents'] && !empty($visit['user_agent']) ? $visit['user_agent'] : '';
if ($visit['browser'] == 0) {
$browser_name = '';
} elseif ($visit['browser'] == 1) {
$browser_name = __('(Robot)');
} else {
$browser_name = $ua->browser_name_from_id($visit['browser']);
}
$robot_class = $visit['browser'] == 1 ? ' bot' : '';
$title = $full_ua ? ' title="' . htmlspecialchars($full_ua) . '"' : '';
echo "<tr class='visit-header{$robot_class}'>";
echo '<td colspan="2" class="left">' . htmlspecialchars($visit['remote_ip']);
echo '<td>' . $dy_label . '</td>';
echo "<td class='ua'{$title}>" . htmlspecialchars($browser_name) . ' ' . htmlspecialchars($visit['version']);
echo '<td>' . htmlspecialchars($ua->platform_name_from_id($visit['platform']));
echo '<td>' . htmlspecialchars(country_name($visit['country'])) . '</tr>';
$row = 0;
foreach ($hits as $hit) {
if (empty($hit)) {
continue;
}
@(list($time, $resource) = explode(' ', $hit, 2));
// dump the seconds part of the time
$time = substr($time, 0, 5);
$r = htmlspecialchars($resource);
echo '<tr class="hit">';
echo '<td colspan="2" class="left"><a href="' . $r . '" class="goto">→</a> ' . filter_link(array('resource' => $resource), $resource) . "<td>{$time}";
if ($row == 0 && !empty($visit['referrer'])) {
echo '<td colspan="3" class="right">';
if (!empty($visit['search_terms'])) {
echo filter_link(array('search_terms' => $visit['search_terms']), $visit['search_terms']);
} else {
echo filter_link(array('domain' => $visit['domain']), $visit['domain']);
}
echo ' <a href="' . htmlspecialchars($visit['referrer']) . '" rel="external noreferrer" class="goto ext">→</a>';
} else {
echo '<td colspan="3"> ';
}
echo '</tr>';
$row++;
}
}
echo '</table>';
echo '<nav class="center wide hide-if-no-js"><a class="ajax" style="display:block; padding: 5px" id="load-more">— ' . __('more') . ' —</a></nav>';
echo '</div>';
page_foot();
}
<div class="col-sm-8 append-icon"> <?php echo customer_name($lead->customer)->name; ?> </div> </div> </div> </div> <div class="row"> <div class="col-sm-12"> <div class="form-group"> <label class="col-sm-4 control-label"><i class="fa fa-map-marker"></i>Address</label> <div class="col-sm-8 append-icon"> <?php echo $lead->address;?><br/> <?php echo city_name($lead->city_id)->name; ?><br/> <?php echo state_name($lead->state_id)->name; ?><br/> <?php echo country_name($lead->country_id)->name; ?> </div> </div> </div> </div> <div class="row"> <div class="col-sm-12"> <div class="form-group"> <label class="col-sm-4 control-label"><i class="fa fa-user-plus"></i>Salesperson</label> <div class="col-sm-8 append-icon"> <?php echo $this->staff_model->get_user($lead->salesperson_id)->first_name.' '.$this->staff_model->get_user($lead->salesperson_id)->last_name; ?> </div> </div>
function get_value_label($field, $key)
{
global $ua;
if (!$key) {
return __('Unknown');
}
if ($field == 'country') {
return country_name($key);
}
if ($field == 'browser') {
return $ua->browser_name_from_id($key);
}
if ($field == 'platform') {
return $ua->platform_name_from_id($key);
}
return $key;
}
