"); $date_string = ''; $fromdate = gmdate("Y-m-d",$in); $todate = gmdate("Y-m-d",$out); $date = $todate; $date1 = str_replace('-', '/', $date); $todate = date('Y-m-d',strtotime($date1 . "+1 days")); $date = $fromdate; $date1 = str_replace('-', '/', $date); $fromdate = date('Y-m-d',strtotime($date1 . "+1 days")); $sql = "SELECT (5 * (DATEDIFF('$todate', '$fromdate') DIV 7) + MID('0123455501234445012333450122234501101234000123450', 7 * WEEKDAY('$fromdate') + WEEKDAY('$todate') + 1, 1)) * 8.5 AS TotalResolutionTimeBusinessDays "; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($result)) { $corehours = $row['TotalResolutionTimeBusinessDays']; } ?>

Summary Chart

UNIX_TIMESTAMP(DATE_FORMAT('$fromdate','%Y-%m-%d')) and e.zef_in < UNIX_TIMESTAMP(DATE_FORMAT('$todate','%Y-%m-%d')) group by u.usr_name "; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($result)) { $name = $row['alias']; $time_spent = $row['time_spent']; $needed_time = $row['needed_time']; $diff = $row['diff']; echo ""; } ?>

Name	Total Hours	Core Working Hours	Difference
$name	$time_spent	$needed_time	$diff

Detailed Summary

UNIX_TIMESTAMP(DATE_FORMAT('$fromdate','%Y-%m-%d')) and e.zef_in < UNIX_TIMESTAMP(DATE_FORMAT('$todate','%Y-%m-%d')) group by u.usr_name "; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($result)) { $name = $row['name']; $alias = $row['alias']; echo ""; $names[] = $name; } ?> UNIX_TIMESTAMP(DATE_FORMAT('$fromdate','%Y-%m-%d')) and e.zef_in < UNIX_TIMESTAMP(DATE_FORMAT('$todate','%Y-%m-%d')) group by p.pct_name "; $result = mysqli_query($conn, $sql); $totalforreport = 0; while ($row = mysqli_fetch_array($result)) { $projecttotal = $row['project_total']; $project = $row['project']; echo ""; foreach ($names as $name) { $sqla = "select ROUND(SUM(e.zef_time) / 3600, 1) as 'totaltime' from kimai15_zef e inner join kimai15_usr u on e.zef_usrID=u.usr_ID inner join kimai15_pct p on e.zef_pctID=p.pct_ID where e.zef_in > UNIX_TIMESTAMP(DATE_FORMAT('$fromdate','%Y-%m-%d')) and e.zef_in < UNIX_TIMESTAMP(DATE_FORMAT('$todate','%Y-%m-%d')) and p.pct_name = '$project' and u.usr_name = '$name' group by p.pct_name;"; $result1 = mysqli_query($conn, $sqla); $total = 0; if (mysqli_num_rows($result1) != 0) { while ($row = mysqli_fetch_array($result1)) { $time = $row['totaltime']; echo ""; } } else { echo ""; } } echo ""; echo ""; $totalforreport = $totalforreport + $projecttotal; } ?> UNIX_TIMESTAMP(DATE_FORMAT('$fromdate','%Y-%m-%d')) and e.zef_in < UNIX_TIMESTAMP(DATE_FORMAT('$todate','%Y-%m-%d')) and u.usr_name = '$name' group by u.usr_name;"; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($result)) { $time = $row['totaltime']; echo ""; } } echo ""; ?> $corehours"; $totalcorehours = $totalcorehours + $corehours; } echo ""; ?> UNIX_TIMESTAMP(DATE_FORMAT('$fromdate','%Y-%m-%d')) and e.zef_in < UNIX_TIMESTAMP(DATE_FORMAT('$todate','%Y-%m-%d')) and u.usr_name = '$name' group by u.usr_name;"; $result = mysqli_query($conn, $sql); while ($row = mysqli_fetch_array($result)) { $time = $row['totaltime'] - $corehours; echo ""; } } $difference = $totalforreport - $totalcorehours; echo ""; ?>

Project Name	$alias	TOTAL
$project	$time		$projecttotal
TOTAL	$time	$totalforreport
Core Working Hours	$totalcorehours
Difference	$time	$difference