View difference between Paste ID: QMwXH5FK and sDSEtvuR
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";