SHOW:
|
|
- or go back to the newest paste.
| 1 | include'koneksi/koneksi.php'; | |
| 2 | $nik=$_SESSION['nik']; | |
| 3 | - | $rate='100.000'; |
| 3 | + | $rate='100000'; //fix |
| 4 | - | $sql1=mysql_query("SELECT * from m_overtime Where STAFF_NIK='$nik' AND OVERTIME_APPSTATUS_HRD='Approved'");
|
| 4 | + | $sql="SELECT * from m_overtime Where STAFF_NIK='$nik' AND OVERTIME_APPSTATUS_HRD='Approved'"; |
| 5 | - | |
| 5 | + | echo "<br/>jalankan sql:$sql"; |
| 6 | $sql1=mysql_query($sql); | |
| 7 | - | while ($data=mysql_fetch_array($sql1)) {
|
| 7 | + | $totaljam=0; |
| 8 | while ($data=mysql_fetch_array($sql1)) {
| |
| 9 | $start=date("H:i:s",strtotime($data['OVERTIME_START']));
| |
| 10 | $end=date("H:i:s",strtotime($data['OVERTIME_END']));
| |
| 11 | - | |
| 11 | + | echo "<br>start: $start | end:$end"; |
| 12 | $strStart = $start; | |
| 13 | $strEnd = $end ; | |
| 14 | $dteStart = new DateTime($strStart); | |
| 15 | $dteEnd = new DateTime($strEnd); | |
| 16 | $dteDiff = $dteStart->diff($dteEnd); | |
| 17 | ||
| 18 | $showJam=$dteDiff->format("%H:%I"); //salah
| |
| 19 | echo "<br>show jam:$showJam "; | |
| 20 | $jam= (int) $dteDiff->format("%H");
| |
| 21 | - | $jam=$dteDiff->format("%H:%I");
|
| 21 | + | echo "<br> jam:$jam "; |
| 22 | $totaljam+=$jam; | |
| 23 | echo "<br>total jam:$totaljam"; | |
| 24 | } | |
| 25 | $total=$totaljam * $rate; | |
| 26 | - | $total=$totaljam*100000; |
| 26 | + | echo "<br> total: $total "; |
| 27 | $nama=$data['STAFF_NAME']; | |
| 28 | echo "total jam :".sprintf("%02s:%02s", $totaljam, 0);
| |
| 29 | echo "<hr/> =============== end"; |