69 lines
2.2 KiB
PHP
69 lines
2.2 KiB
PHP
<?php
|
|
include("app/koneksi.php");
|
|
$key=$_POST['key'];
|
|
if ($key=='cnerr') {
|
|
$username=$_POST['username'];
|
|
$d=pg_query("SELECT COALESCE(log_err,0),id FROM data_user WHERE nama='$username'");
|
|
while($r=pg_fetch_array($d)) {$j=$r[0];$k=$r[1];}
|
|
if (isset($k)) {
|
|
if ($j==5) {} else {
|
|
$t=$j+1;
|
|
pg_query("UPDATE data_user SET log_err=$t WHERE nama='$username'");
|
|
if ($t==5) {
|
|
$nw=date('Y-m-d H:i:s');
|
|
pg_query("UPDATE data_user SET tanggal_lock='$nw' WHERE nama='$username'");
|
|
}
|
|
echo $t;
|
|
}
|
|
} else {
|
|
echo 'tahu';
|
|
}
|
|
} else
|
|
if ($key=='ckerr') {
|
|
$username=$_POST['username'];
|
|
$d=pg_query("SELECT COALESCE(log_err,0) FROM data_user WHERE nama='$username'");
|
|
while($r=pg_fetch_array($d)) {$j=$r[0];}
|
|
echo $j;
|
|
} else
|
|
if ($key=='cuerr') {
|
|
$username=$_POST['username'];
|
|
pg_query("UPDATE data_user SET log_err=NULL WHERE nama='$username'");
|
|
} else
|
|
if ($key=='clerr') {
|
|
$username=$_POST['username'];
|
|
$d1=pg_query("SELECT tanggal_lock FROM data_user WHERE nama='$username'");
|
|
while($r1=pg_fetch_array($d1)) {$j1=$r1[0];}
|
|
$datevvv = date_create($j1);
|
|
date_add($datevvv, date_interval_create_from_date_string('1 hours'));
|
|
$k1=date_format($datevvv, 'Y-m-d H:i:s');
|
|
$start = strtotime(date('Y-m-d H:i:s'));
|
|
$end = strtotime($k1);
|
|
$totaltime = ($end - $start) ;
|
|
$hours = intval($totaltime / 3600);
|
|
$seconds_remain = ($totaltime - ($hours * 3600));
|
|
$minutes = intval($seconds_remain / 60);
|
|
$seconds = ($seconds_remain - ($minutes * 60));
|
|
echo $minutes.':'.$seconds;
|
|
|
|
} else
|
|
if ($key=='cmerr') {
|
|
$username=$_POST['username'];
|
|
$d2=pg_query("SELECT tanggal_lock FROM data_user WHERE nama='$username'");
|
|
while($r2=pg_fetch_array($d2)) {$j2=$r2[0];}
|
|
$datevvv2 = date_create($j2);
|
|
date_add($datevvv2, date_interval_create_from_date_string('1 hours'));
|
|
$k2=date_format($datevvv2, 'Y-m-d H:i:s');
|
|
$start = strtotime(date('Y-m-d H:i:s'));
|
|
$end = strtotime($k2);
|
|
$totaltime = ($end - $start) ;
|
|
$hours = intval($totaltime / 3600);
|
|
$seconds_remain = ($totaltime - ($hours * 3600));
|
|
$minutes = intval($seconds_remain / 60);
|
|
$seconds = ($seconds_remain - ($minutes * 60));
|
|
echo $minutes.':'.$seconds;
|
|
} else
|
|
if ($key=='akerr') {
|
|
$username=$_POST['username'];
|
|
pg_query("UPDATE data_user SET log_err=NULL,tanggal_lock=NULL WHERE nama='$username'");
|
|
}
|
|
?>
|