</div>
        
                <div id="myModaledit<?php 
        echo $i;
        ?>
" class="reveal-modal small" data-reveal>
            <a class="close-reveal-modal">&#215;</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 {
Exemplo n.º 2
0
<?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>&nbsp;(" . sectohr($secs) . "&nbsp;/&nbsp;" . sectohr($secs_ot) . ")";
        ?>
</td>
                        <td><b><?php 
        echo $tot_count + $tot_count_ot . "</b>&nbsp;(" . $tot_count . "&nbsp;/&nbsp;" . $tot_count_ot . ")";
        ?>
</td>
                        <td><b><?php 
        echo $tot_work_units + $tot_work_units_ot . "</b>&nbsp;(" . $tot_work_units . "&nbsp;/&nbsp;" . $tot_work_units_ot . ")";
        ?>
</td>
                        <td><b><?php 
        echo round(($tot_work_units + $tot_work_units_ot) / $secs * 28800, 2) . "</b>&nbsp;(" . round($tot_work_units / $secs * 28800, 2) . "&nbsp;/&nbsp;" . 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>";