?>
</div>
<div id="bodyPan">
<p class="toptextpadding">
</p>
<p class="toptextpadding">Cafe Name: <span><?php
echo $cafe_name;
?>
</span></p>
<p class="toptextpadding">Total Screens Live:<span><?php
echo mysql_num_rows($result);
?>
</span></p>
<p class="toptextpadding">Registered Screens: <span><?php
echo $cafe_details->getCafeScreensCount($cafe_user_id);
?>
</span></p>
<p class="toptextpadding">
<table id="hor-minimalist-b" summary="Employee Pay Sheet">
<thead>
<tr>
<th scope="col">Mac Id</th>
<th scope="col">Cafe Id</th>
<th scope="col">Screen Resolution</th>
<th scope="col">Hits</th>
<th scope="col">Start Time</th>
<th scope="col">Last Time</th>
<th scope="col">Date</th>
//getting cafeid of the corresponding city
$result_cafe = $cafe_details->getCafeIdByCityId($row['city']);
//reset to counter zero
$screen_count_act = 0;
$screen_count_reg = 0;
$today_count = 0;
$day1_count = 0;
$day2_count = 0;
$day3_count = 0;
$day4_count = 0;
while ($row = mysql_fetch_array($result_cafe)) {
$cafe_user_id = $cafe_details->getCafeUIDByCafeId($row['id']);
if ($cafe_user_id) {
$reg_terminals = $cafe_details->getScreenReg($row['id']);
$screen_count_reg = $screen_count_reg + intval($reg_terminals);
$caf_scr_act = $cafe_details->getCafeScreensCount($cafe_user_id);
$screen_count_act = $screen_count_act + $caf_scr_act;
$today_count = $today_count + $cafe_trac->getLiveScrCountTodayByCafeUID($cafe_user_id);
$day1_count = $day1_count + $cafe_trac->getLiveScrCountByCafeUID($cafe_user_id, $day1);
$day2_count = $day2_count + $cafe_trac->getLiveScrCountByCafeUID($cafe_user_id, $day2);
$day3_count = $day3_count + $cafe_trac->getLiveScrCountByCafeUID($cafe_user_id, $day3);
$day4_count = $day4_count + $cafe_trac->getLiveScrCountByCafeUID($cafe_user_id, $day4);
}
}
echo '<tr>';
echo '<td>' . $city_name . '</td>';
echo '<td>' . $screen_count_reg . '</td>';
echo '<td>' . $screen_count_act . '</td>';
echo '<td>' . $day4_count . '</td>';
echo '<td>' . $day3_count . '</td>';
echo '<td>' . $day2_count . '</td>';
