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"; |