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 : saveUserSetup.php

<?php
	function saveUserSetupdata($aobj_context){
		session_start();
		$funivcode = $aobj_context->mobj_data['FUNIVCODE'];
		$College_Code = $aobj_context->mobj_data['collcode'];
		$usrname= ($aobj_context->mobj_data["id"]);
		$pws   	= ($aobj_context->mobj_data["password"]);
		$mob    = ($aobj_context->mobj_data["mobileno"]);
		$email  = ($aobj_context->mobj_data["emailid"]);
		$name  = ($aobj_context->mobj_data["name"]);
		$screen  = ($aobj_context->mobj_data["add"]);
		$usertype  = ($aobj_context->mobj_data["usertype"]);
		
		$user = explode('-', $usrname);
	
		if($funivcode == "055"){
				$uType = $usertype;
		}else{
			$uType = 17;
		}
		
		if($screen == 'add')
		{

$qry="SELECT fuser FROM col_masuser where fuser='{$usrname}'";
			$result = $aobj_context->mobj_db->GetRow($qry);
			
            if($result['fuser']==$usrname){
				
			$query = "update col_masuser set fpassword = '{$pws}',femail= '{$email}',fmobileno = '{$mob}',fname = '{$name}'
					  where fcollcode = '{$College_Code}' and  fuser='{$result['fuser']}'";
				
				
			}else{
				$query = "INSERT INTO col_masuser (fcollcode, fuser, fpassword, fusertype, fmobileno,fname,femail)
			              VALUES ('{$College_Code}', '{$user[1]}', '{$pws}', '{$user[0]}', '{$mob }','{$name}','{$email}' )";
			}

$res = $aobj_context->mobj_db->Execute($query);
		}else
		{ 
			 
			$query = "update col_masuser set fpassword = '{$pws}'
			where college_code = '{$College_Code}' and email_id = '{$email}' and fmob = '{$mob}' and  user_type='{$uType}
			and sysusr = '{$usrname}'";

// $query = "update col_masuser set fpassword = '{$pws}',
			// email_id = '{$email}', fmob = '{$mob}', user_type='{$uType}'
			// where college_code = '{$College_Code}'
			// and sysusr = '{$usrname}'";
			$res = $aobj_context->mobj_db->Execute($query);
		}
	
		if($res)
		{
			if($funivcode == '049' || $funivcode == '097' || $funivcode == 'P005' || $funivcode == 'P006')
			{	
				$query = "INSERT ignore INTO masteach (FCOLLCODE, FTEACHCODE, FTEACHNAME, FMOBILE,FEMAIL)
				VALUES ('{$College_Code}', '{$usrname}', '{$name}', '{$mob}','{$email}')";
				$res1 = $aobj_context->mobj_db->Execute($query);
	
			}
	
			if($funivcode == '097' || $funivcode == 'P005' || $funivcode == 'P006')
			{
	
				if($funivcode == '097')
				{
					$query = "INSERT ignore INTO user_rights (college_code, ref_s_sysdb_code, module_type, module_id, group_id, is_view, is_view_group_records, is_view_dep_records, is_view_all_records, is_add, is_edit, is_edit_group_records, is_edit_dep_records, is_edit_all_records, is_del, is_del_group_records, is_del_dep_records, is_del_all_records)
						SELECT s.college_Code,s.internal_code,module_type, module_id, group_id, is_view, is_view_group_records, is_view_dep_records, is_view_all_records, is_add, is_edit, is_edit_group_records, is_edit_dep_records, is_edit_all_records, is_del, is_del_group_records, is_del_dep_records, is_del_all_records FROM s_sysdb s, user_rights r
						WHERE s.user_type = '17' 
						and r.ref_s_sysdb_code = '33897'
						AND s.sysusr = '{$usrname}'";
					$res1 = $aobj_context->mobj_db->Execute($query);
				}else if($funivcode == 'P005')
				{
					$query = "INSERT ignore INTO user_rights (college_code, ref_s_sysdb_code, module_type, module_id, group_id, is_view, is_view_group_records, is_view_dep_records, is_view_all_records, is_add, is_edit, is_edit_group_records, is_edit_dep_records, is_edit_all_records, is_del, is_del_group_records, is_del_dep_records, is_del_all_records)
						SELECT s.college_Code,s.internal_code,module_type, module_id, group_id, is_view, is_view_group_records, is_view_dep_records, is_view_all_records, is_add, is_edit, is_edit_group_records, is_edit_dep_records, is_edit_all_records, is_del, is_del_group_records, is_del_dep_records, is_del_all_records FROM s_sysdb s, user_rights r
						WHERE s.user_type = '17' 
						and r.ref_s_sysdb_code = '33891'
						AND s.sysusr = '{$usrname}'";
					$res1 = $aobj_context->mobj_db->Execute($query);
				}else if($funivcode == 'P006')
				{
					$query = "INSERT ignore INTO user_rights (college_code, ref_s_sysdb_code, module_type, module_id, group_id, is_view, is_view_group_records, is_view_dep_records, is_view_all_records, is_add, is_edit, is_edit_group_records, is_edit_dep_records, is_edit_all_records, is_del, is_del_group_records, is_del_dep_records, is_del_all_records)
						SELECT s.college_Code,s.internal_code,module_type, module_id, group_id, is_view, is_view_group_records, is_view_dep_records, is_view_all_records, is_add, is_edit, is_edit_group_records, is_edit_dep_records, is_edit_all_records, is_del, is_del_group_records, is_del_dep_records, is_del_all_records FROM s_sysdb s, user_rights r
						WHERE s.user_type = '17' 
						and r.ref_s_sysdb_code = '33898'
						AND s.sysusr = '{$usrname}'";
					$res1 = $aobj_context->mobj_db->Execute($query);
				}
	
				$query = "INSERT ignore INTO logisys3_comexam.pushstud 
				(FUNIVCODE, FREGNO, FDEGREE, FCOLLCODE, FNAME, FMOBILE, FEMAIL, FUSERTYPE)
				select '{$funivcode}',FTEACHCODE, '{$funivcode}','{$funivcode}',FTEACHNAME, FMOBILE,FEMAIL,'600' 
				from masteach where ifnull(fdeleted,'') <> 'T'";
				$res1 = $aobj_context->mobj_db->Execute($query);
			
				
			}
	
			$rdata = "Updated Successfully.";
			print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success"));
			return $rdata;
		}
		else
		{
			$rdata = "No Updation / Add..!";
			print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure"));  
			return $rdata;			
		}			
	}	
	
	function userLoginDet($aobj_context){

$funivcode = $aobj_context->mobj_data['univcode'];
		$College_Code = $aobj_context->mobj_data['collcode'];

$query="SELECT *FROM col_masuser where fcollcode='{$College_Code}'";
		$res = $aobj_context->mobj_db->GetAll($query);

if($res){
            echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success");
            return;
        }else{
            $arr['msg'] = "Something Went Wrong";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
            return;
        }
	}

function userDeleteData($aobj_context){
		$funivcode = $aobj_context->mobj_data['FUNIVCODE'];
		$College_Code = $aobj_context->mobj_data['collcode'];
		$usrname= ($aobj_context->mobj_data["id"]);
		$pws   	= ($aobj_context->mobj_data["password"]);
		$mob    = ($aobj_context->mobj_data["mobileno"]);
		$email  = ($aobj_context->mobj_data["emailid"]);
		$name  = ($aobj_context->mobj_data["name"]);
		$screen  = ($aobj_context->mobj_data["add"]);
		$usertype  = ($aobj_context->mobj_data["usertype"]);

$qry="DELETE FROM col_masuser WHERE fuser='{$usrname}'";
		$res = $aobj_context->mobj_db->Execute($qry);

if($res){
			$arr['msg'] = "Successfully Deleted";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
            return;
        }else{
            $arr['msg'] = "Something Went Wrong";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
            return;
        }
	
	}

function userTypeData($aobj_context){
		$collcode=$aobj_context->mobj_data['collcode'];

$qry = "SELECT CONCAT(fusertype,'-',fdescpn) AS `key`, CONCAT(fusertype,'-',fdescpn)AS `value`, CONCAT(fusertype,'-',fdescpn)AS `label`  FROM col_usertype";
		$res=$aobj_context->mobj_db->GetAll($qry);

}
?>

${this.title}

Code Editor : saveUserSetup.php