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.64 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	5.15 KB	-rw-rw-r--
studentia.php	4.94 KB	-rw-rw-r--
studentprofile.php	6.87 KB	-rw-rw-r--
studentsubject.php	5.15 KB	-rw-rw-r--

Code Editor : studentia.php

<?php

function getStudSubIa($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;
	$res = [];
	$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 fcsubcode as fsubcode,fvalmax from subject where fdegree = '{$fdegree}'
				and fexamno = '{$semvalue}'
				and fintass = 'T'
				and fesubcode = '{$val['subcode']}'";
				// var_dump($query);
				// die();
				$res3 = $aobj_context->mobj_db->getRow($query);
				$fsubcode = $res3['fsubcode'];
				$fvalmax = $res3['fvalmax'];
				if($res3)
				{
					if($val['marks'] <= $fvalmax)
					{
						if($val['rtype'] == 'I')
						{
							$query = "INSERT INTO estudia (fregno, fcollcode, fecollcode, fdegree, fedegree, fdegname, 
							fsem, fsubcode, fesubcode, fsubname, fmarks,frtype, fcreateddate)
							VALUES ('{$val['regno']}','{$collcode}','{$val['collcode']}','{$fdegree}','{$val['degcode']}','{$val['degname']}',
							'{$semvalue}','{$fsubcode}','{$val['subcode']}','{$val['subname']}','{$val['marks']}','{$val['rtype']}',now()
							)";
					
							$result = $aobj_context->mobj_db->Execute($query);

}
						else if($val['rtype'] == 'U')
						{
							$query = "update estudia set 
							fmarks = '{$val['marks']}', 
							frtype = '{$val['rtype']}',
							fupdateddate = now()
							where fregno = '{$val['regno']}' 
							and fsubcode = '{$fsubcode}'";
							//var_dump($query);
							$result = $aobj_context->mobj_db->Execute($query);

if($result)
							{
								$res['status'] = "T";
								$res['regno'] = $val['regno'];
								$res['degcode'] = $val['degcode'];
								$res['subcode'] = $val['subcode'];
								$res['iatype'] = $val['iatype'];
								$res['msg'] = "Updated Successfully";
								$succes++;
							}else
							{
								$res['status'] = "F";
								$res['regno'] = $val['regno'];
								$res['degcode'] = $val['degcode'];
								$res['subcode'] = $val['subcode'];
								$res['iatype'] = $val['iatype'];
								$res['msg'] = "Updatedtion Failed";
								$error++;
							}
						}
					}else
					{
						$res['status'] = "F";
						$res['regno'] = $val['regno'];
						$res['degcode'] = $val['degcode'];
						$res['subcode'] = $val['subcode'];
						$res['iatype'] = $val['iatype'];
						$res['msg'] = "Subject Max Marks Not Mached";
						$error++;
					}

}else
				{
					$res['status'] = "F";
					$res['regno'] = $val['regno'];
					$res['degcode'] = $val['degcode'];
					$res['subcode'] = $val['subcode'];
					$res['iatype'] = $val['iatype'];
					$res['msg'] = "Subject Master Not Mached";
					$error++;
				}
			}
			else
			{
				$res['status'] = "F";
				$res['regno'] = $val['regno'];
				$res['degcode'] = $val['degcode'];
				$res['subcode'] = $val['subcode'];
				$res['iatype'] = $val['iatype'];
				$res['msg'] = "College Master Not Mached";
				$error++;
			}
		}else
		{
			$res['status'] = "F";
			$res['regno'] = $val['regno'];
			$res['degcode'] = $val['degcode'];
			$res['subcode'] = $val['subcode'];
			$res['iatype'] = $val['iatype'];
			$res['msg'] = "Degree Master Not Mached";
			$error++;
		}
		$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 : studentia.php