Advertisement
GWibisono

kita coba debug part 2

Jan 31st, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.        include'koneksi/koneksi.php';
  2.               $nik=$_SESSION['nik'];
  3.               $rate='100000'; //fix
  4. $sql="SELECT  * from m_overtime Where STAFF_NIK='$nik' AND OVERTIME_APPSTATUS_HRD='Approved'";
  5. echo "<br/>jalankan sql:$sql";
  6.                $sql1=mysql_query($sql);
  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. 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. echo "<br>  jam:$jam ";
  22.     $totaljam+=$jam;
  23. echo "<br>total  jam:$totaljam";
  24. }
  25.     $total=$totaljam * $rate;
  26.   echo "<br>  total: $total ";
  27.     $nama=$data['STAFF_NAME'];
  28.          echo "total jam :".sprintf("%02s:%02s", $totaljam, 0);
  29. echo "<hr/> =============== end";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement