$cafe_act = new CafeActivation(); $cafe_mgmt = new CafeMgmt(); /* * get yesterdays d */ $yesterday = $_REQUEST['date']; //date("Y-m-d",mktime(0,0,0,date("m") ,date("d")-1,date("Y"))); /* * gettingvalues in result array */ $result = $cafe_act->getInstalledCafe($yesterday); $num = mysql_num_rows($result); ?> <h4>Number of screens Installed today: <?php echo $num; ?> </h4><table width="973" border="1"><tr><td>Cafe Id</td><td>Mac Id</td><td>Installed By</td><td>Time</td></tr> <?php while ($row = mysql_fetch_array($result)) { echo ' <tr>'; echo ' <td>' . $row['cafe_id'] . '</td>'; echo '<td>' . $row['mac_id'] . '</td> '; echo ' <td>' . $cafe_mgmt->getEmUserName($row['employee_id']) . '</td>'; echo '<td>' . $row['time'] . '</td>'; echo '</tr>'; } ?>
?> <body> <div id="topPan"><div id="ImgPan"><a href="index.html"><img src="../images/logo.gif" title="Coporate Profiles" alt="Coporate Profiles" width="201" height="52" border="0" /></a></div> <?php include "nav_bar.php"; ?> </div> <div id="bodyPan"> <p class="toptextpadding">Details of <?php echo $city_name; ?> </p> <p class="toptextpadding"> List of Employees in this city </p> <p class="toptextpadding"> <?php while ($row = mysql_fetch_array($emp_rs)) { echo $cafe_mgmt->getEmUserName($row['user_id']); } ?> </p> <p class="more"><a href="#">read more</a></p> </div> <?php include "../templates/footer.php"; ?>