Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
AdmLogin.php	714 B	-rw-r--r--
addStudToCls.php	19.78 KB	-rw-r--r--
admdet.php	1.06 KB	-rw-r--r--
assignUserMenu.php	14.91 KB	-rw-r--r--
attEntryDaywise.php	11.03 KB	-rw-r--r--
caccesscontext.php	1.33 KB	-rwxr-xr-x
cappcontext.php	3.76 KB	-rw-r--r--
cdegree.php	4.54 KB	-rw-r--r--
cgetclsdepts.php	1.65 KB	-rw-r--r--
clogin.php	4.31 KB	-rw-r--r--
cmenus.php	2.46 KB	-rw-r--r--
constants.php	818 B	-rw-r--r--
coutput.php	1.84 KB	-rw-r--r--
crequestbroker.php	2.49 KB	-rw-r--r--
csessions.php	548 B	-rw-r--r--
csubject.php	5.75 KB	-rw-r--r--
cuser.php	3.53 KB	-rw-r--r--
cuserType.php	1.86 KB	-rw-r--r--
degreeResultSheet.php	3.82 KB	-rw-r--r--
degreeWise_IA_Report.php	4.79 KB	-rw-r--r--
deletecreatedclass.php	779 B	-rw-r--r--
duringExam.php	2.7 KB	-rw-r--r--
editclass.php	1.06 KB	-rw-r--r--
error_log.php	749 B	-rw-r--r--
getDegSemSubDetnew.php	8.55 KB	-rw-r--r--
getnumword.php	7.45 KB	-rwxr-xr-x
guidelines.php	578 B	-rw-r--r--
iamarksentry.php	6.92 KB	-rw-r--r--
json.php	34.52 KB	-rw-r--r--
jwt.php	13.16 KB	-rw-r--r--
login.php	8.01 KB	-rw-r--r--
marks_entry_qnWise.php	14.01 KB	-rw-r--r--
mregistry.php	21.88 KB	-rw-r--r--
practicalMark.php	28.2 KB	-rw-r--r--
preparethqp.php	23.68 KB	-rw-r--r--
protected.php	661 B	-rw-r--r--
savePassword.php	1.31 KB	-rw-r--r--
saveUserSetup.php	7.46 KB	-rw-r--r--
saveclsdets.php	2.27 KB	-rw-r--r--
sendGridMail.php	1.72 KB	-rw-r--r--
sendsmsapi_onex_new.php	4.19 KB	-rw-r--r--
student.php	61.41 KB	-rw-r--r--
studentsem.php	3.79 KB	-rw-r--r--
subject_Details.php	8.92 KB	-rw-r--r--
updateclass.php	583 B	-rw-r--r--
uploadStudentPhoto.php	2.15 KB	-rw-r--r--
uploadphotoofstud.php	1.84 KB	-rw-r--r--
userRightDetails.php	1.39 KB	-rw-r--r--

Code Editor : attEntryDaywise.php

<?php
function loaddayteachname($aobj_context)
{
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$collcode = $aobj_context->mobj_data["collcode"];
    $funivcode = $aobj_context->mobj_data['univcode'];

$usertype = $aobj_context->mobj_data['usertype'];
    $usr = $aobj_context->mobj_data['user'];

$cnd = '';
    
    if($usertype == "T")
    {
        $cnd = "and m.fteachcode = '{$usr}'";
    }

if($funivcode == "097"){
        $cnd1="order by fteachname";
    }else{
        $cnd1=""; 
    }
	
	$query = "select distinct ifnull(at.fteachcode,'') as `key`,
	          ifnull(at.fteachcode,'') as `value`,
			  CONCAT(ifnull(m.FTEACHNAME,''),'[',ifnull(at.fteachcode,''),']') as label
			  from attclass at
			  inner join masteach m on at.fteachcode = m.fteachcode
			  where at.fcollcode = '{$collcode}' {$cnd} {$cnd1}";

$result = $aobj_context->mobj_db->GetAll($query);
	
	if($result)
	{
		echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
	}
	else
	{
		$data['msg'] = 'Faile to load';
		echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
	}
}

function loadclassnameday($aobj_context)
{
    $collcode = $aobj_context->mobj_data['collcode'];
	$usertype =$aobj_context->mobj_data['usertype'];
    $usr = $aobj_context->mobj_data['user'];
	$teachcode = $aobj_context->mobj_data["teachcode"];
	
    $cnd = '';
    
    if($usertype == 'T')
    {
        $cnd = "and fteachcode = '{$usr}'";   
    }

$query="  select ifnull(fclassid,'') as `key`, ifnull(fclassid,'') as `value`,
              CONCAT(ifnull(fclassname,''),'[',ifnull(fclassid,''),']') as label  from
              attclass where fteachcode = '{$teachcode}' and fcollcode = '{$collcode}' and ifnull(fdeleted,'') <> 'T'{$cnd}";

function viewattendanceentry($aobj_context){
   
    $fclassid = $aobj_context->mobj_data["clsnames"];
    $period = $aobj_context->mobj_data["period"];
    $noofclass = $aobj_context->mobj_data["noofcls"];
    $date = $aobj_context->mobj_data["date"];
    $collcode = $aobj_context->mobj_data['collcode'];
    $fsort = $aobj_context->mobj_data["sort"];

$query = "select * from attclass where fclassid = '{$fclassid}'
    and ifnull(fblock,'') = 'T'";
	
    $res1 = $aobj_context->mobj_db->GetRow($query);
    if($res1)
    {
        $data="Attendace Entry Bloked Contact Admin. Reason: ".$res1['fblockremarks'];
        echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
        return;

}else
    {

}

if($fsort == "fname"){
        $cond = "s.fname";
    }elseif($fsort == "fregno"){
        $cond = "a.fregno";
    }
    $query = "select ifnull(a.FDEGREE,'') as fdegree,
    ifnull(a.FEXAMNO,'') as fexamno,ifnull(a.fregno,'') as fregno,ifnull(s.FNAME,'') as fname, ifnull(ad.FPRESENT,'') as fpresent 
    from attendsum a inner join student s on s.FREGNO = a.FREGNO 
    and s.fcollcode = a.fcollcode and s.fdegree = a.fdegree 
    left join attend_det ad on ad.fregno = a.fregno and ad.FSUBCODE = a.FSUBCODE 
    and ad.FCLASSID = a.FCLASSID and ad.fdegree = a.fdegree 
    and ad.fexamno = a.fexamno 
    and ad.fcollcode = a.fcollcode and ad.FDATE = '{$date}'
    and ad.FPERIOD = '{$period}' and ad.FNOCLASS = '{$noofclass}' and ad.FCOLLCODE = '{$collcode}'
    where a.fclassid = '{$fclassid}'
    group by fregno
    order by $cond";

$lobj_get_data = $aobj_context->mobj_db->GetAll($query);

if($lobj_get_data)
        {	
            echo $aobj_context->mobj_output->ToJSONEnvelope($lobj_get_data,0,"success"); 
            return;
        }
        else
        {
            $data="not found";
            echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
            return;
        }          
}

function saveattendanceentry($aobj_context){

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $fclassid = $aobj_context->mobj_data["cls"];
    $period = $aobj_context->mobj_data["period"];
    $syllabus = $aobj_context->mobj_data["syllabus"];
    $noofclass = $aobj_context->mobj_data["noofcls"];
    $date = $aobj_context->mobj_data["dates"];
    $collcode = $aobj_context->mobj_data['collcode'];
	$univcode = $aobj_context->mobj_data['univcode'];
	$usr = $aobj_context->mobj_data['usr'];
	$sort = $aobj_context->mobj_data['sort'];
	$teach = $aobj_context->mobj_data['teach'];
    $data = $aobj_context->mobj_data["data"];
    $array = json_decode($data,true);

$query = "select fblock, ifnull(fblockremarks, '')as fremarks from attclass 
              where fteachcode='{$teach}' and fcollcode='{$collcode}' and fclassid='{$fclassid}'";
			
    $blkres = $aobj_context->mobj_db->GetRow($query);
    if($blkres['fblock']=='T'){
      if($blkres['fremarks'] == ''||$blkres['fremarks']=='null'){
        $arr['msg'] = "Blocked";
      }else{
        $arr['msg'] = $blkres['fremarks'];
      }
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
      return;
    }

foreach($array as $key => $value){

$reg = $value['fregno'];
    $str = "ATTENDANCE ENTRY DAYWISE: USER : $usr, COLLCODE: $collcode, REGNO : $reg, CLASSID : $fclassid, DATE : $date";
    $remark = $str;
    $enttype = "ATTCD";

$query = "INSERT INTO attend_det (FCOLLCODE, FDEGREE, FEXAMNO, FSUBCODE, FREGNO, FDATE, FPERIOD, FNOCLASS, FPRESENT,FCLASSID,FUPDUSER,FCREATEDATE,fsyllabus,FTEACHCODE,FSECTION)
    select s.fcollcode,s.fdegree,a.fexamno,a.fsubcode,s.fregno,'{$date}','{$period}','{$noofclass}','{$value['fpresent']}','{$fclassid}','{$usr}',NOW(),'{$syllabus}',a.fteachcode,a.FSECTION
    from student s 
    inner join attendsum a on s.fcollcode = a.fcollcode
    and s.fdegree = a.fdegree  
    where a.fclassid = '{$fclassid}'
    and a.fclassid = '{$fclassid}'
    and s.fregno = '{$value['fregno']}'
    on DUPLICATE KEY UPDATE FPRESENT = '{$value['fpresent']}', FNOCLASS='{$noofclass}', FUPDDATE = NOW()";

$lobj_get_data = $aobj_context->mobj_db->Execute($query);

}
    if($lobj_get_data)
        {	
            $arr['msg'] = "Successfully Saved";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
            return;
        }
        else
        {
        
            if(empty($array)){
                $arr['msg']="Already Saved"; 
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
                return;
            }else{
                $arr['msg']="Failed to Save";
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
                return;
            }
          
        }          
}

$cnd = '';
    if($usertype== 'T')
    {
        $cnd = "and at.fteachcode = '{$usr}'";   
    }

$query = "select concat(at.fteachcode,' - ',m.FTEACHNAME) as fteach,
     ifnull(ad.fclassid,'') as fclassid,ifnull(at.fclassname,'') as fclassname,ifnull(at.fteachcode,'') as fteachcode,
    ifnull(m.FTEACHNAME,'') as fteachname,
    ifnull(ad.fperiod,'') as fperiod,ifnull(ad.fnoclass,'') as fnoclass,ifnull(fdate,'') as fdate,
    sum(if(ad.fpresent = 'P','1',0)) as pcnt,sum(if(ad.fpresent = 'A','1',0)) as acnt
    from attend_det ad
    inner join attclass at on at.fclassid = ad.fclassid
    inner join masteach m on m.FTEACHCODE = at.fteachcode
    where ad.fcollcode = '{$college_code}' 
    $cnd 
    and at.fteachcode between '{$fromteach}' and '{$toteach}'
    group by ad.FDATE,ad.fclassid,ad.FPERIOD,ad.FNOCLASS
    order by at.fteachcode,ad.FDATE";
   
    $lobj_get_data = $aobj_context->mobj_db->GetAll($query);

function deleteAddstudentry($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$fclassid = $aobj_context->mobj_data["clsid"];
    $fperiod = $aobj_context->mobj_data["period"];
    $fnoclass = $aobj_context->mobj_data["noofcls"];
    $fdate = $aobj_context->mobj_data["date"];
	$collcode = $aobj_context->mobj_data["collcode"];

$query = "delete from attend_det
    where FPERIOD = '{$fperiod}' and FNOCLASS = '{$fnoclass}' 
    and FCLASSID = '{$fclassid}' and fdate = '{$fdate}'
     and fcollcode='{$collcode}'";
	
    $lobj_get_data = $aobj_context->mobj_db->Execute($query);

if($lobj_get_data)
        {	
			$data="Successfully Deleted";
            echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
            return;
        }
        else
        {
            $data="not found";
            echo $aobj_context->mobj_output->ToJSONEnvelope($data,-1,"failure"); 
            return;
        }          
}

function modifyAddstudentry($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$fteachcode = $aobj_context->mobj_data["teachcode"];
    $fclassid = $aobj_context->mobj_data["clsid"];
    $fperiod = $aobj_context->mobj_data["period"];
    $fnoclass = $aobj_context->mobj_data["noofcls"];
    $fdate = $aobj_context->mobj_data["date"];
	$collcode = $aobj_context->mobj_data["collcode"];

$query = "select ifnull(a.FDEGREE,'') as fdegree,
    ifnull(a.FEXAMNO,'') as fexamno,ifnull(a.fregno,'') as fregno,
    ifnull(s.FNAME,'') as fname, ifnull(ad.FPRESENT,'') as fpresent,
    ifnull(ad.fsyllabus,'') as fsyllabus 
    from attendsum a inner join student s on s.FREGNO = a.FREGNO 
    and s.fcollcode = a.fcollcode and s.fdegree = a.fdegree 
    left join attend_det ad on ad.fregno = a.fregno and ad.FSUBCODE = a.FSUBCODE 
    and ad.FCLASSID = a.FCLASSID and ad.fdegree = a.fdegree 
    and ad.fexamno = a.fexamno 
    and ad.fcollcode = a.fcollcode and ad.FDATE = date_format(str_to_date('{$fdate}','%d/%m/%Y'),'%Y-%m-%d')
    and ad.FPERIOD = '{$fperiod}' and ad.FNOCLASS = '{$fnoclass}' and ad.FCOLLCODE = '{$collcode}'
    where a.fclassid = '{$fclassid}'
    order by a.fregno,s.fname";

$lobj_get_data = $aobj_context->mobj_db->GetAll($query);

${this.title}

Code Editor : attEntryDaywise.php