Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
apitest.php	1.61 KB	-rw-rw-r--
attendaceSEE.php	2.61 KB	-rwxr-xr-x
caccesscontext.php	1.28 KB	-rwxr-xr-x
cappcontext.php	2.71 KB	-rwxr-xr-x
coutput.php	1.84 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	548 B	-rwxr-xr-x
cuser.php	3.53 KB	-rwxr-xr-x
downloadStudHalltiket.php	2.53 KB	-rw-rw-r--
downloadStudPhoto.php	416 B	-rw-rw-r--
ePRTimetable.php	2.68 KB	-rwxr-xr-x
eRoomAllotmentData.php	2.88 KB	-rwxr-xr-x
eThTimetable.php	2.64 KB	-rwxr-xr-x
edegree.php	2.5 KB	-rwxr-xr-x
esubject.php	4.31 KB	-rwxr-xr-x
genToken.php	790 B	-rw-rw-r--
getexamevent.php	3.41 KB	-rwxr-xr-x
json.php	34.52 KB	-rwxr-xr-x
jssstuMarksAPI.php	2.21 KB	-rw-r--r--
mregistry.php	1.87 KB	-rwxr-xr-x
profile.php	938 B	-rwxr-xr-x
sduvaldata.php	2.57 KB	-rw-r--r--
studentExamFee.php	7.53 KB	-rw-rw-r--
studentResults.php	4.94 KB	-rw-rw-r--
studentia.php	4.5 KB	-rw-rw-r--
studentprofile.php	6.87 KB	-rw-rw-r--
studentsubject.php	5.15 KB	-rw-rw-r--

Code Editor : studentsubject.php

<?php

function getStudentSubject($aobj_context)
{ 
	$data_json = file_get_contents("php://input");
	$data = json_decode($data_json,true);
    
	if($_SERVER['PHP_AUTH_USER'] == 'revaapiuser' && $_SERVER['PHP_AUTH_PW'] == 'reva@124')
	{

}else
	{
		$arry='Unauthorized User';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

if(count($data) <=0)	
	{
		$arry='Kindaly Pass Data';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arry,-1,"Failure");
		return;
	}

$i = 0;
	$resrayy = [];
	$error = 0;
	$succes = 0;
	$sem=["1"=>"A","2"=>"B","3"=>"C","4"=>"D","5"=>"E","6"=>"F","7"=>"G","8"=>"H","9"=>"I","10"=>"J"];
	foreach($data as $val)
    {
	
		$query = "select fdegree,FMEYEAR,FMEEXAMTYP from degree where fedegcode = '{$val['degcode']}' and fexamno = 'A'";
		$res1 = $aobj_context->mobj_db->getRow($query);
		$fdegree = $res1['fdegree'];
		$year = $res1['FMEYEAR'];
		$examtype = $res1['FMEEXAMTYP'];
		
		if($res1)
		{
			$semvalue = $sem[$val['sem']];
			$query = "select fcollcode from college where fecollcode = '{$val['collcode']}'";
			$res2 = $aobj_context->mobj_db->getRow($query);
			$collcode = $res2['fcollcode'];
			if($res2)
			{
				
				$query = "select fsubcode from subject where fdegree = '{$fdegree}'
				and fexamno = '{$semvalue}'
				and fesubcode = '{$val['subcode']}'";
				// var_dump($query);
				// die();
				$res3 = $aobj_context->mobj_db->getRow($query);
				$fsubcode = $res3['fsubcode'];
				if($res3)
				{
					if($fsubcode == '')
					{
						$res['status'] = "F";
						$res['logisysextid'] = $val['logisysextid'];
						$res['msg'] = "Subject Code cant be Empty";
						$error++;
					}else
					{

if($val['rtype'] == 'I')
						{
							$query = "INSERT ignore INTO estudsub (flogid,fregno,fcollcode,fdegree,fsubcode,fecollcode,fcollname,fdegcode, fdegname, fsem, fesubcode, fsubname, fatten, frtype,fcreateddate)
							VALUES ('{$val['logisysextid']}','{$val['regno']}','{$collcode}','{$fdegree}','{$fsubcode}','{$val['collcode']}',
							'{$val['collname']}','{$val['degcode']}',
							'{$val['degname']}','{$semvalue}',
							'{$val['subcode']}','{$val['subname']}',
							'{$val['attend']}','{$val['rtype']}',now())";
							$result = $aobj_context->mobj_db->Execute($query);

$query = "insert ignore into candsum(fregno,fdegree,fexamno,fcollcode,fappeara,fyear,fexamtype,ffreshexam,fstype) 
							select fregno,fdegree,fsem,fcollcode,'A','{$year}','{$examtype}','A','E' from estudsub where fregno = '{$val['regno']}'";
							$result1 = $aobj_context->mobj_db->Execute($query);

$query = "insert ignore into canddet(fregno,fdegree,fexamno,fcollcode,fsubcode,fyear,fexamtype,fstype) 
							select fregno,fdegree,fsem,fcollcode,fsubcode,'{$year}','{$examtype}','E' from estudsub where fregno = '{$val['regno']}'";
							$result1 = $aobj_context->mobj_db->Execute($query);

if($result && $result1)
							{
								$res['status'] = "T";
								$res['logisysextid'] = $val['logisysextid'];
								$res['msg'] = "Inserted Successfully";
								$succes++;
							}else
							{
								$res['status'] = "F";
								$res['logisysextid'] = $val['logisysextid'];
								$res['msg'] = "Insertion Failed";
								$error++;
							}

}else if($val['rtype'] == 'U')
						{
							$query = "select fsubcode,fesubcode,fsubname From estudsub 
							where flogid = '{$val['logisysextid']}'
							and fregno = '{$val['regno']}'";
							$res2 = $aobj_context->mobj_db->getRow($query);
							$oldsubcode = $res2['fsubcode'];
							
							$upd = "update estudsub set fesubcode = '{$val['subcode']}',fsubname = '{$val['subname']}',
							fsubcode = '{$fsubcode}'
							where flogid = '{$val['logisysextid']}'
							and fregno = '{$val['regno']}'";
							$result = $aobj_context->mobj_db->Execute($upd);

$upd1 = "update canddet set fsubcode = '{$fsubcode}'
							where fregno = '{$val['regno']}'
							and fsubcode = '{$oldsubcode}'";

$result = $aobj_context->mobj_db->Execute($upd1);
							
							if($result)
							{
								$res['status'] = "T";
								$res['logisysextid'] = $val['logisysextid'];
								$res['msg'] = "Updated Successfully";
								$succes++;
							}else
							{
								$res['status'] = "F";
								$res['logisysextid'] = $val['logisysextid'];
								$res['msg'] = "Updatedtion Failed";
								$error++;
							}

}
					}
				}else 
				{
					$res['status'] = "F";
					$res['logisysextid'] = $val['logisysextid'];
					$res['msg'] = "Subject Master Not Mached";
					$error++;
				}
			}else 
			{
				$res['status'] = "F";
				$res['logisysextid'] = $val['logisysextid'];
				$res['msg'] = "College Master Not Mached";
				$error++;
			}
		}else
		{
			$res['status'] = "F";
			$res['logisysextid'] = $val['logisysextid'];
			$res['msg'] = "Degree Master Not Mached";
			$error++;
		}
		// var_dump($res);
		// die();
		$i++;
		array_push($resrayy,$res);
    }

$msg = "success";
	if($succes >'0' && $error == '0')
	{
		$msg = "success";
	}else if($error>'0' && $succes == '0')
	{
		$msg  = "Failure";
	}else if($succes >'0' && $error>'0')
	{
		$msg = "Partial";
	}

$arry['resdata'] = $resrayy;
	echo $aobj_context->mobj_output->ToJSONEnvelope($arry,0,$msg);
	return;
	
}

${this.title}

Code Editor : studentsubject.php