<?php
while ($row = mysql_fetch_array($result)) {
//var_dump($row);
$result_rs = $cafe_details->getAllDetailsOfCafeByCafeUID($row['cafe_id']);
$rm = mysql_fetch_array($result_rs);
if ($rm or $rm['cafe_name']) {
$cname = $rm['cafe_name'];
} else {
$cname = $row['cafe_id'];
}
//var_dump($rm);
echo '<tr>';
echo '<td>' . $cname . '</td>';
echo '<td>' . $rm['first_name'] . ' ' . $rm['last_name'] . '</td>';
echo '<td>' . $rm['office_phone'] . '</td>';
echo '<td>' . $rm['address'] . ',' . $cafe_details->getCityName($rm['city']) . ',' . $cafe_details->getStateName($rm['state']) . '</td>';
echo '</tr>';
}
?>
</table>
<p class="toptextpadding"> </p>
<p class="toptextpadding">Corporate Profiles is a free, tableless, W3C-compliant web design layout by Template World. This template has been tested and proven compatible with all major bresult_rsser environments and operating systems. You are free to modify the design to suit your tastes in any way you like. We only ask you to not remove <span>"Design by Template World"</span> and the link http://www.templateworld.com from the footer of the template.</p>
<p class="toptextpadding">If you are interested in seeing more of our free web template designs feel free to visit our website, Template World. We intend to add at least 25 new free templates in the coming month.</p>
<p class="more"><a href="#">read more</a></p>
</div>
<div id="bodyMiddlePan"></div>
<?php
include "../templates/footer.php";
?>
}
}
//checking status
//$check = checkStatus($rows['cafe_id']);
if ($flag == 1) {
$img_url = '../images/notok.JPG';
} else {
$img_url = '../images/ok.JPG';
}
while ($row = mysql_fetch_array($result_cafe)) {
echo '<tr>';
echo '<td>' . $row['cafe_name'] . '</td>';
echo '<td>' . $row['first_name'] . ' ' . $row['last_name'] . '</td>';
echo '<td>' . $row['office_phone'] . '</td>';
echo '<td>' . $row['address'] . '</td>';
echo '<td>' . $cafe_details->getCityName($row['city']) . '</td>';
echo '<td>' . $cafe_details->getStateName($row['state']) . '</td>';
echo '<td>' . $row['terminals'] . '</td>';
echo '<td>' . $registered_screens . '</td>';
echo '<td>';
?>
<img src="<?php
echo $img_url;
?>
" width="51" height="47" alt="Ok"></td>
<?php
echo '<td>' . '<a href="view_details.php?cafe_id=' . $row['id'] . '">View</a>' . '</td>';
echo '</tr>';
}
}
?>
echo $row['state'];
?>
"><?php
echo $cafe_details->getStateName($row['state']);
?>
</option>
</select></div>
</div>
<div><img src="../images/spacer.gif" alt="" width="1" height="10" /></div>
<div>
<div id="citydiv"><select name="city">
<option value="<?php
echo $row['city'];
?>
"><?php
echo $cafe_details->getCityName($row['city']);
?>
</option>
</select></div>
</div>
</div>
<div class="form1_div3">
<div class="txt6">Country</div>
<div><img src="../images/spacer.gif" alt="" width="1" height="15" /></div>
<div class="txt6"> Postal Code </div>
<div><img src="../images/spacer.gif" alt="" width="1" height="15" /></div>
<div class="txt6"> Area</div>
</div>
<div class="form1_div4">
<div>
<select name="country" onChange="getState(this.value)"><option value="1"><?php
<table width="764" border="1">
<tr>
<td width="90">User Id</td>
<td width="87">Name</td>
<td width="90">City</td>
<td width="134">Department</td>
<td width="110">Role</td>
<td width="83">View Details</td>
</tr>
<?php
while ($rows = mysql_fetch_array($rs_employee)) {
$role_id = $cafe_mgmt->getEmUserRoleId($rows['id']);
echo '<tr>';
echo '<td>' . $rows['user_name'] . '</td>';
echo '<td>' . $rows['first_name'] . ' ' . $rows['last_name'] . '</td>';
echo '<td>' . $cafe_details->getCityName($rows['address_city']) . '</td>';
echo '<td>' . $rows['department'] . '</td>';
echo '<td>' . $cafe_mgmt->getEmRoleName($role_id) . '</td>';
echo '<td><a href="emp_details.php?user_id=' . $rows['id'] . '">View Details</a></td>';
echo '</tr>';
}
?>
</table>
</center>
<p class="toptextpadding"><a href="create_employee.php">Create Employee</a>
<p class="toptextpadding"><a href="assign_employee.php">Assign Employee</a>
</p>
<p class="toptextpadding"> </p>
</div>
<?php
include "../templates/footer.php";
echo $day2;
?>
</td>
<td width="65"> <?php
echo $day1;
?>
</td>
<td width="65"> <?php
echo $today;
?>
</td>
<td width="159">View Details</td>
</tr>
<?php
while ($row = mysql_fetch_array($city_result)) {
$city_name = $cafe_details->getCityName($row['city']);
$city_url = '<a href="city_details.php?city_id=' . $row['city'] . '">View</a>';
//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']);
<?php include "../templates/header_session.php"; include "../templates/header.php"; $city_id = $_GET['city_id']; //including classes include '../classes/CafeDetails.php'; include '../classes/CafeMgmt.php'; //creating objects $cafe_details = new CafeDetails(); $cafe_mgmt = new CafeMgmt(); //gettting city name $city_name = $cafe_details->getCityName($city_id); $emp_rs = $cafe_mgmt->getListOfEmpByCity($city_id); ?> <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
