Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.api.php	3.61 KB	-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--
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 : getEmpAttListSummary.php

<?php

include("sys_connect.php");

if(!isset($_GET["emplcode"]) || !isset($_GET["month"]) || !isset($_GET["year"])
|| $_GET["emplcode"] == "" || $_GET["month"] == "" || $_GET["year"] == "" ){
    echo json_encode(array("msg" => "Invalid Params", "error_code" => -1));
    die();    
}
$emplcode = $_GET["emplcode"];
$month = $_GET["month"];
$year = $_GET["year"];

$deptcode = $_GET["deptcode"];
$usertype = $_GET["usertype"];
$cond = "";
if(strtoupper($usertype) == 'ADMIN') {
    $cond = "and e.fdeptcode = '{$deptcode}'";
} else {
    $cond = "and e.frepthead = '{$emplcode}' and e.femplcode <> '{$emplcode}'";
}

$query = "select a.fdeptcode, d.fdeptshrt as fdeptname, a.femplcode, 
e.femplname, a.fattnstat, sum(if(a.fattnstat = 'PR', 1, 0)) as fprcount, 
sum(if(a.fattnstat = 'AB', 1, 0)) as fabcount, 
sum(if(a.fattnstat = 'CL', 1, 0)) as fclcount
from attendance a inner join masempl e on a.femplcode = e.femplcode
inner join masdept d on e.fdeptcode = d.fdeptcode
where year(fattndate) = '{$year}' and month(fattndate) = '{$month}' {$cond}
group by e.fdeptcode, a.femplcode";
// var_dump($query);
$myres = mysqli_query($mycon, $query);
$mycnt = mysqli_num_rows($myres);
if($mycnt > 0) {
    $res = [];
    $i = 0;
    while($row = mysqli_fetch_assoc($myres)){
        $res[$i] = $row;
        $i++;
    }
    echo json_encode(array("error_code" => 0, 'data' => $res ));
}
else {
    echo json_encode(array("error_code" => -1, 'data'=> [], 'msg' => "Data Not found!!!" ));
}

${this.title}

Code Editor : getEmpAttListSummary.php