?>
<tr class='<?php
echo $class;
?>
'><td><b><?php
echo $x;
?>
</b></td><td><?php
$startDay = $ssbArr['startDate'];
$getDateDiff = mysql_query("SELECT DATEDIFF(now(),'{$startDay}') AS DiffDate");
$arrDate = mysql_fetch_assoc($getDateDiff);
// echo $arrDate['DiffDate']+1;
$beginday = date($startDay);
$lastday = date("Y-m-d");
if ($beginday != $lastday) {
echo $numOfDays = getBusinessDays($beginday, $lastday);
} else {
echo $numOfDays = 1;
}
?>
</td><td><?php
echo $ssbArr['ssbID'];
?>
</td><td class="custsubname"><?php
echo $ssbArr['custSubName'];
?>
</td>
<td><?php
echo $ssbArr['queue'];
?>
</td><td><?php
echo $x;
?>
</b></td><td><?php
$startDay = $ssbArr['startDate'];
$beginday = date($startDay);
$lastday = date("Y-m-d");
//$getDateDiff=mysql_query("SELECT DATEDIFF(now(),'$startDay') AS DiffDate");
//$arrDate=mysql_fetch_assoc($getDateDiff);
//echo $arrDate['DiffDate']+1;
/*$beginday=date($startDay);
$lastday=date("Y-m-d");
//echo $lastday;
$nr_work_days = getWorkingDays($beginday,$lastday);
echo $nr_work_days;*/
if ($beginday != $lastday) {
echo getBusinessDays($beginday, $lastday);
} else {
echo 1;
}
?>
</td><td><?php
echo $ssbArr['ssbID'];
$queryStat = "SELECT * FROM openssbtime WHERE ssbID = '{$ssbArr['ssbID']}' and owner='{$ssbArr['owner']}'";
$resultStat = mysql_query($queryStat);
if (mysql_num_rows($resultStat) == 0) {
?>
<img src="images/addTime.png" height="12px" width="12px" onmouseover="showTime(<?php
echo $x;
?>
)" onmouseout="hideTime(<?php
