</div> <div id="myModaledit<?php echo $i; ?> " class="reveal-modal small" data-reveal> <a class="close-reveal-modal">×</a> </div> <?php $i++; } ?> <tr style="background-color: #f2f2f2;"> <td colspan="6" align="right">Total</td> <td><?php echo $tot_time = sectohr($secs); //=timelength($secs);//date("h:i:s",$tot_time); ?> </td> <td><?php echo $tot_count; ?> </td> <td><?php echo $tot_work_units; ?> </td> <td colspan="3"></td> </tr> <?php } else {
<?php session_start(); require_once '../classes/db.class.php'; require_once '../includes/time_calc.php'; $conn = new db(); $dbcon = $conn->dbConnect(); $user_id = $_SESSION['sda_id']; $date = $_POST['date']; $secs = 0; $query = "SELECT time FROM user_tasks_ot WHERE date='{$date}' AND user_id='{$user_id}'"; $result = $conn->runsql($query, $dbcon); if (mysqli_num_rows($result)) { while ($result_row = mysqli_fetch_object($result)) { $secs += strtotime($result_row->time) - strtotime("00:00:00"); } $remain_secs = 57600 - $secs; $remain_hrs = sectohr($remain_secs); } else { $remain_hrs = "16:00:00"; $remain_secs = "57600"; } $json_result[0] = $remain_hrs; $json_result[1] = $remain_secs; echo json_encode($json_result);
} if ($secs) { echo "<td><span class='success'>"; echo sectohr($secs); $tot_sec += $secs; echo "</span></td>"; } else { echo "<td>-</td>"; } $secs = 0; } else { echo "<td></td>"; } } echo "<td>"; if ($tot_sec) { echo sectohr($tot_sec); } else { echo "-"; } echo "</td></tr>"; } } } } } ?> <tr> <td></td> </tr> </table>
$secs_ot += strtotime($result_row_ot->time) - strtotime("00:00:00"); $tot_work_units_ot += $result_row_ot->wu; } echo $i % 2 == 0 ? "<tr id='data_row_even' align=center>" : "<tr id='data_row_odd' align=center>"; ?> <td><?php echo $i++; ?> </td> <td><?php echo $user_array[$user]; ?> </td> <td><b><?php echo sectohr($secs + $secs_ot) . "</b> (" . sectohr($secs) . " / " . sectohr($secs_ot) . ")"; ?> </td> <td><b><?php echo $tot_count + $tot_count_ot . "</b> (" . $tot_count . " / " . $tot_count_ot . ")"; ?> </td> <td><b><?php echo $tot_work_units + $tot_work_units_ot . "</b> (" . $tot_work_units . " / " . $tot_work_units_ot . ")"; ?> </td> <td><b><?php echo round(($tot_work_units + $tot_work_units_ot) / $secs * 28800, 2) . "</b> (" . round($tot_work_units / $secs * 28800, 2) . " / " . round($tot_work_units_ot / $secs * 28800, 2) . ")"; ?> </td>
$daily_target_temp_in_wu_array = explode(",", $daily_target_temp_in_wu); $daily_target_temp_in_wu_in_per_array = explode(",", $daily_target_temp_in_wu_in_per); $user_wu_tot_array = explode(",", $user_wu_tot); $wu_avg_array = explode(",", $wu_avg); $tot_wu_array = explode(",", $tot_wu); $tot_time_array = explode(",", $tot_time); $max = $max + 50; echo "<table>"; echo "<tr>"; echo "<td>Task list</td>"; echo "<td>Daily target</td>"; echo "<td>Daily target(in WU)</td>"; echo "<td>Daily target(%)</td>"; echo "<td>Work units(tot)</td>"; echo "<td>Total time</td>"; echo "<td>Per day WU(pro)</td>"; echo "<td>Per day WU(in %)</td>"; echo "</tr>"; for ($kkk = 0; $kkk < sizeof($task_list_array); $kkk++) { echo "<tr>"; echo "<td>" . $task_list_array[$kkk] . "</td>"; echo "<td>" . $daily_target_temp_array[$kkk] . "</td>"; echo "<td>" . $daily_target_temp_in_wu_array[$kkk] . "</td>"; echo "<td>" . $daily_target_temp_in_wu_in_per_array[$kkk] . "</td>"; echo "<td>" . $tot_wu_array[$kkk] . "</td>"; echo "<td>" . sectohr($tot_time_array[$kkk]) . "</td>"; echo "<td>" . $user_wu_tot_array[$kkk] . "</td>"; echo "<td>" . $wu_avg_array[$kkk] . "</td>"; echo "</tr>"; } echo "</table>";