Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
ultGetMenus.php	2.36 KB	-rwxr-xr-x
ultLogin.php	3.17 KB	-rwxr-xr-x
ultNotification.php	1.05 KB	-rwxr-xr-x
ultProfile.php	1.73 KB	-rwxr-xr-x
ultRegistration.php	4.82 KB	-rwxr-xr-x
ultRoomDet.php	1.98 KB	-rw-rw-r--
uniliteAPI1.php	11.3 KB	-rwxr-xr-x
uniliteAPI1_17032021.php	9.33 KB	-rwxr-xr-x

Code Editor : ultProfile.php

<?php

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

$fregno = $aobj_context->mobj_data['regno'];
    $univcode = $aobj_context->mobj_data['univcode'];
    $url = "https://university-student-photos.s3.ap-south-1.amazonaws.com/";

$query = "select fteachcode,fteachname,fdegndesc,fgender,fqual,fscale,
	date_format(fdob,'%d/%m/%y') as fdob,t.femail,t.fmobile,t.fphone,t.fpanno,
	ifnull(fstatus,'pending') as fstatus,date_format(now(),'%d/%m/%y') as fdate,
	date_format(flogdate,'%d/%m/%y') as flogdate, 
	faddr1,faddr2,faddr3,faddr4,
	concat(timestampdiff( year, fdoc, now()), ' yr., ', 
	timestampdiff( month, fdoc, now()) % 12, ' mon.') as fexp,
	ffulltime,fpermanent,fphoto,fremarks,
	date_format(fdoa,'%d/%m/%y') as doj,
    t.fifsccode,t.faccno,t.faadharno,
    concat(c.fcollname,', ',c.ftown) as college
    from masteach t inner join masdegn des on des.fdegncode=t.fdegncode
    inner join college c on t.fcollcode = c.fcollcode 
	where  ifnull(fstatus,'') <> 'retired'
	and t.fteachcode = '{$fregno}'";

$result = $aobj_context->pobj_db->GetRow($query);

$query = "select m.fexamno, m.fboard, t.fqpcode, m.fsubname, fdegreerange as fdegrees 
		from teachsub t inner join masqp m
		on t.fqpcode = m.fqpcode where t.fteachcode = '{$fregno}'
		order by m.fboard, m.fexamno, t.fqpcode";
    $result_sub = $aobj_context->pobj_db->GetAll($query);

if(count($result) > 0)
    {   
        $arr['studProfile'] = $result;
        $arr['valsub'] = $result_sub;
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
    }
    else
    {
        $arr['msg'] = 'Profile Not found';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
    }
}

${this.title}

Code Editor : ultProfile.php