Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- include'koneksi/koneksi.php';
- $nik=$_SESSION['nik'];
- $rate='100000'; //fix
- $sql="SELECT * from m_overtime Where STAFF_NIK='$nik' AND OVERTIME_APPSTATUS_HRD='Approved'";
- echo "<br/>jalankan sql:$sql";
- $sql1=mysql_query($sql);
- $totaljam=0;
- while ($data=mysql_fetch_array($sql1)) {
- $start=date("H:i:s",strtotime($data['OVERTIME_START']));
- $end=date("H:i:s",strtotime($data['OVERTIME_END']));
- echo "<br>start: $start | end:$end";
- $strStart = $start;
- $strEnd = $end ;
- $dteStart = new DateTime($strStart);
- $dteEnd = new DateTime($strEnd);
- $dteDiff = $dteStart->diff($dteEnd);
- $showJam=$dteDiff->format("%H:%I"); //salah
- echo "<br>show jam:$showJam ";
- $jam= (int) $dteDiff->format("%H");
- echo "<br> jam:$jam ";
- $totaljam+=$jam;
- echo "<br>total jam:$totaljam";
- }
- $total=$totaljam * $rate;
- echo "<br> total: $total ";
- $nama=$data['STAFF_NAME'];
- echo "total jam :".sprintf("%02s:%02s", $totaljam, 0);
- echo "<hr/> =============== end";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement