Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxr-xr-x
.htaccess	602 B	-rwxr-xr-x
appForm.php	20.98 KB	-rwxr-xr-x
appForm_22022018.php	20.63 KB	-rwxr-xr-x
applicationFormReportPOSTOFFIC...	19.27 KB	-rwxr-xr-x
applicationFormReportSBM.php	31.97 KB	-rwxr-xr-x
applicationFormReportSBM_21022...	31.63 KB	-rwxr-xr-x
applicationFormReportSBM_29102...	31.93 KB	-rwxr-xr-x
applicationStatus.php	2.94 KB	-rwxr-xr-x
cManualMailer.php	1.52 KB	-rwxr-xr-x
caccesscontext.php	1.24 KB	-rwxr-xr-x
candidate_list.php	54.71 KB	-rwxr-xr-x
cappcontext.php	2.67 KB	-rwxr-xr-x
changeExmCntr.php	4.62 KB	-rwxr-xr-x
changeExmCntrReport.php	10.03 KB	-rwxr-xr-x
cmailer.php	6.83 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
coutput.php	1.76 KB	-rwxr-xr-x
createUser.php	2.05 KB	-rwxr-xr-x
crequestbroker.php	2.49 KB	-rwxr-xr-x
csessions.php	514 B	-rwxr-xr-x
cuser.php	3.41 KB	-rwxr-xr-x
customappcontext.php	2.35 KB	-rwxr-xr-x
dropdown.php	844 B	-rwxr-xr-x
editApplication.php	12.13 KB	-rwxr-xr-x
feehead.php	1.51 KB	-rwxr-xr-x
format.php	7.43 KB	-rwxr-xr-x
fpdf_protection.php	5.61 KB	-rwxr-xr-x
getdata.php	1.06 KB	-rwxr-xr-x
getnumword.php	7.15 KB	-rwxr-xr-x
home.html	14.48 KB	-rwxr-xr-x
json.php	33.72 KB	-rwxr-xr-x
login.php	1.76 KB	-rwxr-xr-x
mregistry.php	5.45 KB	-rwxr-xr-x
re_rigistration.php	7.83 KB	-rwxr-xr-x
re_rigistration_10042018_BEFOR...	6.98 KB	-rwxr-xr-x
re_rigistration_24042018.php	7.14 KB	-rwxr-xr-x
re_rigistration_27042018.php	7.18 KB	-rwxr-xr-x
re_rigistration_old_15042019.p...	7.59 KB	-rwxr-xr-x
reportApproveList.php	8.09 KB	-rwxr-xr-x
reportApproveList_18072018.php	8.04 KB	-rwxr-xr-x
report_appstatus.php	5.91 KB	-rwxr-xr-x
report_hall_ticket.php	11.31 KB	-rwxr-xr-x
reportapplicationform - Copy.p...	19.59 KB	-rwxr-xr-x
reportapplicationform.php	23.92 KB	-rwxr-xr-x
rotation.php	596 B	-rwxr-xr-x
saveApplication.php	16.4 KB	-rwxr-xr-x
saveApplication_21022018.php	8.99 KB	-rwxr-xr-x
saveApplication_mohan.php	9.04 KB	-rwxr-xr-x
saveRerigistration.php	11.72 KB	-rwxr-xr-x
saveRerigistration_03052018.ph...	10.87 KB	-rwxr-xr-x
saveRerigistration_10052018.ph...	11.12 KB	-rwxr-xr-x
servfee.php	1.38 KB	-rwxr-xr-x
servicedet.php	1.6 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
student.php	24.46 KB	-rwxr-xr-x
updateFeeDet.php	1.66 KB	-rwxr-xr-x

Code Editor : changeExmCntr.php

<?php
function getStudDet($aobj_context){
  
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
  
  $examno = $aobj_context->mobj_data["examno"];
  $degfrm = $aobj_context->mobj_data["degfrm"];
  $degto = $aobj_context->mobj_data["degto"];  
  $appfrm = $aobj_context->mobj_data["appfrm"];
  $appto = $aobj_context->mobj_data["appto"];
  $collfrm = $aobj_context->mobj_data["collfrom"];
  $collto = $aobj_context->mobj_data["collto"];
  
  if($degto == "")
    $degto = $degfrm;
  if($appto == "")
    $appto = $appfrm;
  if($collto == "")
    $collto = $collfrm;

if($examno == 'A'){
    $query = "select s.fappno as id,s.fdegree,d.fdescpn,s.fexamno,d.fexamname,fcollcode,fname 
    from studadm s
    inner join degree d on d.fdegree=s.fdegree and d.fexamno=s.fexamno
    where s.fdegree between '$degfrm' and '$degto' 
    and fcollcode between '$collfrm' and '$collto' 
    and fappno between '$appfrm' and'$appto' and s.fexamno='$examno'";
  }else{
    $query = "select s.fregno as id,s.fappno,s.fdegree,d.fdescpn,s.fexamno,d.fexamname,fcollcode,fname 
    from studadm s
    inner join degree d on d.fdegree=s.fdegree and d.fexamno=s.fexamno
    where s.fdegree between '$degfrm' and '$degto'      
    and fappno between '$appfrm' and'$appto' and s.fexamno='$examno' 
    and fcollcode between '$collfrm' and '$collto'
    group by s.fregno";
  }
  var_dump($query);
  die();
  $result = $aobj_context->mobj_db->GetAll($query);
  if($result){
    echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
  }else{
    echo $aobj_context->mobj_output->ToJSONEnvelope($result,1,"failure"); 
  }
}

function updateNewCntrDet($aobj_context){
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
  $newCntrDet = json_decode($_POST["newCntr"],true);
  // var_dump($newCntrDet);

foreach($newCntrDet as $item){

$rQry = "select fregno,fcollcode from studadm where fregno = '".$item['fregno']."' and fdegree= '".$item['fdegree']."'";
    $res = $aobj_context->mobj_db->getRow($rQry);
    $fregno = $res['fregno'];
    $foldcollcode = $res['fcollcode'];
// var_dump($rQry);
// die();
    //====insert old collcode into cntrchange tbl bfr updation of other tbls====//
    $iQry = "insert into cntrchange (fdegree,fcollcode,fexamno,fappno,fmodifydate,fmodifyuser) 
      values('".$item['fdegree']."','$foldcollcode','".$item['fexmno']."','".$item['fappno']."',now(),'".$_SESSION['USER']."')";
    $iRes = $aobj_context->mobj_db->Execute($iQry);
// var_dump($iQry);
// die();
    if(!$iRes){
      $data='Something Went Wrong, please check the details entered';
      $arr['message']= $data;    
      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,1,"failure");
      return;
    }

if($item['fexmno'] == 'A'){
      //--upadte for 1st year/fresher--//
      $rows_affectedu = 1;
    }
    else{
      //--update except 1st year/freshers--//
      $qry = "update student set fnewcollcode = '".$item['fnewcollcode']."' 
      where fdegree = '".$item['fdegree']."' and fregno ='$fregno'";
      $results = $aobj_context->mobj_db->Execute($qry);
      // var_dump($qry);
      // die();
      $regcandsum_upd = "update regcandsum set fcollcode = '".$item['fnewcollcode']."' 
      where fdegree = '".$item['fdegree']."' and fexamno = '".$item['fexmno']."' and fregno ='$fregno'";
      $results_upd = $aobj_context->mobj_db->Execute($regcandsum_upd);
      // var_dump($regcandsum_upd);
      // die();
      $rows_affectedu = $aobj_context->mobj_db->affected_rows();
    }
    if($rows_affectedu >= 0){

//---increment fslno val to avoid duplicate key entry---//
      $slnoQry = "select right(concat('0000',ifnull(max(FSLNO),0)+01),4) as fslno 
      from studadm 
      where fdegree='".$item['fdegree']."' and fcollcode='".$item['fnewcollcode']."' and fexamno='".$item['fexmno']."'";
      $slnoRes = $aobj_context->mobj_db->getRow($slnoQry);
      $slnoCunt = $slnoRes['fslno'];
      // var_dump($slnoQry);
      $studadm_upd="update studadm set fslno='{$slnoCunt}',fcollcode= '".$item['fnewcollcode']."' 
      where FAPPNO='".$item['fappno']."'";
      $result = $aobj_context->mobj_db->Execute($studadm_upd);

$options_upd = "update options set fslno='{$slnoCunt}',FCOLLCODE = '".$item['fnewcollcode']."'
      where fappno = '".$item['fappno']."' ";
      $result=$aobj_context->mobj_db->Execute($options_upd);
// var_dump($options_upd);
// die();
    }
  }

if($result){
    $data = "Uploaded Successfully. $rows_affectedu Records Updated";
    echo $aobj_context->mobj_output->ToJSONEnvelope($data,0,"success"); 
    return;
  } 
  else{
    $data = "Error while updating";
    echo $aobj_context->mobj_output->ToJSONEnvelope($data,1,"error"); 
    return;
  }
}
?>

${this.title}

Code Editor : changeExmCntr.php