Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.pgetadm.php	3.61 KB	-rw-r--r--
PrintAdmissionOrderstudent.php	9.51 KB	-rwxrwxrwx
PrintAdmissionOrderstudent_ru....	11.26 KB	-rwxrwxrwx
acuapplicationFormPGReport.php	26.02 KB	-rwxr-xr-x
add-course.php	5.63 KB	-rwxrwxrwx
admissionorderPGReport.php	15.91 KB	-rwxrwxrwx
admissionordertest.php	356 B	-rwxrwxrwx
app-status.php	2.87 KB	-rwxrwxrwx
applicationFormPGReport.php	43.11 KB	-rwxrwxrwx
bcuapplicationFormPGReport.php	50.46 KB	-rwxrwxrwx
cancelSeat.php	4.51 KB	-rwxrwxrwx
casual-seat-allot.php	16.88 KB	-rwxrwxrwx
category.php	2.95 KB	-rwxrwxrwx
data.json	1.98 KB	-rwxrwxrwx
degree.php	11.73 KB	-rwxrwxrwx
feestr.php	5.7 KB	-rwxrwxrwx
forgot-password.php	2.77 KB	-rwxrwxrwx
generatestudentlistreport.php	11.34 KB	-rwxrwxrwx
getSavedData.php	13.67 KB	-rwxrwxrwx
getSavedData_old_12102019.php	5 KB	-rwxrwxrwx
hallticket.php	7.61 KB	-rwxrwxrwx
leaddetmail.php	2.09 KB	-rwxr-xr-x
login.php	1.21 KB	-rwxrwxrwx
logout.php	44 B	-rwxrwxrwx
option-entry-cr.php	4.76 KB	-rwxrwxrwx
option-entry.php	9.11 KB	-rwxrwxrwx
option-entryPrint.php	9.34 KB	-rwxrwxrwx
printadmissionorder.php	1.38 KB	-rwxrwxrwx
printhostelfeereport.php	11.84 KB	-rwxrwxrwx
report_ra_Notice_Boaed_Chart.p...	9.79 KB	-rwxrwxrwx
report_ra_invigilator_dairy.ph...	9.61 KB	-rwxrwxrwx
reportadm_admission_ticket.php	14.66 KB	-rwxrwxrwx
reprint.php	707 B	-rwxrwxrwx
resetpassword.php	783 B	-rwxrwxrwx
saveApplication.php	24.33 KB	-rwxrwxrwx
saveApplication_BACKUP_15072.p...	48.01 KB	-rwxrwxrwx
saveApplication_BASE_15072.php	23.61 KB	-rwxrwxrwx
saveApplication_LOCAL_15072.ph...	24.27 KB	-rwxrwxrwx
saveApplication_REMOTE_15072.p...	23.67 KB	-rwxrwxrwx
saveApplication_old_12102019.p...	14.67 KB	-rwxrwxrwx
seat-allot.php	9.18 KB	-rwxrwxrwx
seat_allotment_summary.php	8.42 KB	-rwxrwxrwx
sendGridMail.php	1.47 KB	-rwxrwxrwx
sendMobEmailOTP.php	1.41 KB	-rwxrwxrwx
sendsmsapi.php	760 B	-rwxrwxrwx
signin.php	1.24 KB	-rwxrwxrwx
signup.php	1.21 KB	-rwxrwxrwx
validateRegno.php	3.12 KB	-rwxrwxrwx
vkuapplicationFormPGReport cop...	36.61 KB	-rwxrwxrwx
vkuapplicationFormPGReport.php	24.17 KB	-rwxrwxrwx
vkuapplicationFormPGReportOld....	39.28 KB	-rwxrwxrwx

Code Editor : getSavedData.php

<?php

function getSavedData($aobj_context)
{
  $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
  session_start();
  
  $fappno = $aobj_context->mobj_data["fappno"];
  $db = $aobj_context->mobj_data["db"];

$query = "select fappno, fmobileno, 
  ifnull(fname,'') as fname, 
  ifnull(fphotopath,'') as fphotopath, ifnull(fgender,'') as fgender, 
  date_format(ifnull(fdob,''), '%d/%m/%Y') as fdob, ifnull(ffatname,'') as ffatname,
  ifnull(ffatocc,'') as ffatocc, ifnull(fmotname, '') as fmotname, 
  ifnull(fmotocc, '') as fmotocc, ifnull(fnational, '') as fnational, 
  ifnull(fcategory,'') as fcategory, 
  ifnull(fpmregno,'') as fpmregno, ifnull(fincome,'') as fincome, 
  ifnull(fbpl,'') as fbpl, ifnull(fkarstudy,'') as fkarstudy, 
  ifnull(faadharno,'') as faadharno, ifnull(fsslcregno,'') as fsslcregno, 
  ifnull(fpermadd1,'') as fpermadd1, ifnull(fpermadd2,'') as fpermadd2, 
  ifnull(fpermadd3,'') as fpermadd3, ifnull(fpermadd4,'') as fpermadd4, 
  ifnull(fpermdist,'') as fpermdist, ifnull(fpermstate,'') as fpermstate, 
  ifnull(fpermpin,'') as fpermpin, ifnull(fcurradd1,'') as fcurradd1, 
  ifnull(fcurradd2,'') as fcurradd2, ifnull(fcurradd3,'') as fcurradd3, 
  ifnull(fcurradd4,'') as fcurradd4, ifnull(fcurrdist,'') as fcurrdist, 
  ifnull(fcurrstate,'') as fcurrstate, ifnull(fcurrpin,'') as fcurrpin, 
  ifnull(femail,'') as femail, ifnull(fkashmir,'') as fkashmir, 
  ifnull(fhk,'') as fhk, ifnull(fjk,'') as fjk, ifnull(frural,'') as frural, 
  ifnull(fkannada,'') as fkannada, ifnull(fbcue,'') as fbcue, 
  ifnull(fbcuetype,'') as fbcuetype, ifnull(fsports,'') as fsports, 
  ifnull(fculture,'') as fculture, ifnull(fncc,'') as fncc, 
  ifnull(fnss,'') as fnss, ifnull(fdefence,'') as fdefence,
  ifnull(fpdp,'') as fpdp,ifnull(fcof,'') as fcof,ifnull(fcoh,'') as fcoh,
  ifnull(fcovid,'') as fcovid,
  ifnull(fgah,'') as fgah,ifnull(fkanm,'') as fkanm, 
  ifnull(funikar,'') as funikar,
  ifnull(fchilsuid,'') as fchilsuid,
  ifnull(fjks,'') as fjks,
  ifnull(fscouts,'') as fscouts,
  ifnull(fhandicap,'') as fhandicap, ifnull(fqdegree,'') as fqdegree, 
  ifnull(FQCOMBCODE,'') as fcombcode, ifnull(fquniv,'') as fquniv, ifnull(fqyear,'') as fqyear, 
  ifnull(fqmonth,'') as fqmonth, ifnull(fqregno,'') as fqregno, 
  ifnull(fqclass,'') as fqclass, ifnull(fqmaxmarks,'') as fqmaxmarks, 
  ifnull(fqsecmarks,'') as fqsecmarks, ifnull(fqpercentage,'') as fqpercentage, 
  ifnull(flang1,'') as flang1, ifnull(flang1mm,'') as flang1mm, 
  ifnull(flang1ms,'') as flang1ms, ifnull(flang2,'') as flang2, 
  ifnull(flang2mm,'') as flang2mm, ifnull(flang2ms,'') as flang2ms, 
  ifnull(fpgdegree,'') as fpgdegree, ifnull(fpgqdegree,'') as fpgqdegree, 
  ifnull(fpgunivtype,'') as fpgunivtype, ifnull(fpgqclass,'') as fpgqclass, 
  ifnull(fpguniv,'') as fpguniv, ifnull(fpgyear,'') as fpgyear, 
  ifnull(fpgmonth,'') as fpgmonth, ifnull(fpgregno,'') as fpgregno, 
  ifnull(fpgmaxmarks,'') as fpgmaxmarks, ifnull(fpgsecmarks,'') as fpgsecmarks, 
  ifnull(fothexam,'') as fothexam, ifnull(fsponsor,'') as fsponsor, 
  ifnull(fothinfo,'') as fothinfo, ifnull(fdocattest,'') as fdocattest,
  ifnull(fpaystatus,'') as fpaystatus,ifnull(fmngetexam,'') as fmngetexam,
  ifnull(fmngexamname,'') as fmngexamname, ifnull(fmngrank,'') as fmngrank,ifnull(fwrkexp,'') as fwrkexp,
  ifnull(fwrkexppath,'') as fwrkexppath,
  ifnull(FQCOLLEGE,'') as FQCOLLEGE,
  ifnull(FLANMM,'') as FLANMM, ifnull(freligion,'') as freligion, ifnull(fmotherton,'') as fmotherton,
  ifnull(fbloodgrp,'') as fbloodgrp, ifnull(fsubcaste,'') as fsubcaste, ifnull(fincomerdno,'') as fincomerdno,
  ifnull(fcasterdno,'') as fcasterdno, ifnull(fhkrdno,'') as fhkrdno, ifnull(fexservice,'') as fexservice,
  ifnull(foutstud,'') as foutstud, ifnull(fselfsupsch,'') as fselfsupsch,
  ifnull(FLANMO,'') as FLANMO, fappstatus,ifnull(funivstud,'') as funivstud,
  ifnull(fdocvrfloc,'') as fdocvrfloc,
  ifnull(fgardname,'') as fgardname,ifnull(fgardocc,'') as fgardocc,
  ifnull(fgirlchild,'') as fgirlchild,ifnull(fsevenkar,'') as fsevenkar,
  ifnull(fkashmig,'') as fkashmig,ifnull(fjkstud,'') as fjkstud,
  ifnull(fruralten,'') as fruralten,ifnull(fkantem,'') as fkantem,
  ifnull(fsonbcu,'') as fsonbcu,ifnull(fstudbu,'') as fstudbu,
  ifnull(finkar,'') as finkar,ifnull(fkarout,'') as fkarout,
  ifnull(fbuautclg,'') as fbuautclg,ifnull(fbiopuc,'') as fbiopuc,
  ifnull(fmathpuc,'') as fmathpuc,ifnull(fsponrcand,'') as fsponrcand,
  ifnull(fstudtype,'') as fstudtype
  from entstudadm where fappno = '{$fappno}'";
  //
  $result1 = $aobj_context->mobj_db->GetRow($query);
  // var_dump($result1);

if(!$result1 && gettype($result1) == 'boolean'){

$arr['msg'] = "Error while fetching data";
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
    return;
  }

$query = "";
  if($result1['fpaystatus'] == 'success')
  {
    $query = "select fheadcode,famount as fmaxfee from entfeedetl where fappno = '{$fappno}'
    order by fheadcode";
  }
  else 
  {
    $count = 1;
    
    $query ="select fheadcode, fmaxfee from admfeestr 
    where fdegree ='PGET' 
    and fcatcode = '{$result1['fcategory']}' and fcombcode = 'PGET' and fexamno = 'A'
    and date_format(now(), '%Y-%m-%d') between fadmfeesdate and fadmfeeedate
    order by fheadcode";
  }
  //var_dump($query);
  $result2 = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
  left join entprevmarks pm
  on cd.fdegree = pm.fdegree
  and cd.fsubcode = pm.fsubcode
  and ifnull(pm.fcombcode,'') NOT IN ('lan', 'TOT')
  where pm.fappno = '{$fappno}'
  group by cd.fdegree, cd.fsubcode";
  $result3 = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
  left join entprevmarks pm
  on cd.fcombcode = pm.fcombcode
  and cd.fsubcode = pm.fsubcode
  and ifnull(pm.fcombcode,'') = 'lan'
  where pm.fappno = '{$fappno}'";
  $reslan = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
  left join entprevmarks pm
  on cd.fcombcode = pm.fcombcode
  and cd.fsubcode = pm.fsubcode
  and ifnull(pm.fcombcode,'') = 'TOT'
  where pm.fappno = '{$fappno}'";
  $restotsem = $aobj_context->mobj_db->GetAll($query);

$query ="select fdoctype,ifnull(fpath,'') as fpath from entstuddoc where fappno = '{$fappno}'";
  $result4 = $aobj_context->mobj_db->GetAll($query);

$query ="select fheadcode,famount as fmaxfee from entfeedetl where fappno = '{$fappno}'
  order by fheadcode";
  $result5 = $aobj_context->mobj_db->GetAll($query);

if(count($result1) > 0) {
    $arr['student'] = $result1;
    $arr['db'] = $db;
    $arr['feedetl'] = $result2;
    $arr['optsub'] = $result3;
    $arr['reslan'] = $reslan;
    $arr['restotsem'] = $restotsem;
    $arr['studoc'] = $result4;
    $arr['studtotfee'] = $result5;
    $arr['ackvfd'] = $result1['fappstatus'];
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
    return;
  }
  else {

if($fappno != "") {

$query = "select fappno, fmobileno, 
        ifnull(fname,'') as fname, 
        ifnull(fphotopath,'') as fphotopath, ifnull(fgender,'') as fgender, 
        date_format(ifnull(fdob,''), '%d/%m/%Y') as fdob, ifnull(ffatname,'') as ffatname,
        ifnull(ffatocc,'') as ffatocc, ifnull(fmotname, '') as fmotname, 
        ifnull(fmotocc, '') as fmotocc, ifnull(fnational, '') as fnational, 
        ifnull(fcategory,'') as fcategory, 
        ifnull(fpmregno,'') as fpmregno, ifnull(fincome,'') as fincome, 
        ifnull(fbpl,'') as fbpl, ifnull(fkarstudy,'') as fkarstudy, 
        ifnull(faadharno,'') as faadharno, ifnull(fsslcregno,'') as fsslcregno, 
        ifnull(fpermadd1,'') as fpermadd1, ifnull(fpermadd2,'') as fpermadd2, 
        ifnull(fpermadd3,'') as fpermadd3, ifnull(fpermadd4,'') as fpermadd4, 
        ifnull(fpermdist,'') as fpermdist, ifnull(fpermstate,'') as fpermstate, 
        ifnull(fpermpin,'') as fpermpin, ifnull(fcurradd1,'') as fcurradd1, 
        ifnull(fcurradd2,'') as fcurradd2, ifnull(fcurradd3,'') as fcurradd3, 
        ifnull(fcurradd4,'') as fcurradd4, ifnull(fcurrdist,'') as fcurrdist, 
        ifnull(fcurrstate,'') as fcurrstate, ifnull(fcurrpin,'') as fcurrpin, 
        ifnull(femail,'') as femail, ifnull(fkashmir,'') as fkashmir, 
        ifnull(fhk,'') as fhk, ifnull(fjk,'') as fjk, ifnull(frural,'') as frural, 
        ifnull(fkannada,'') as fkannada, ifnull(fbcue,'') as fbcue, 
        ifnull(fbcuetype,'') as fbcuetype, ifnull(fsports,'') as fsports, 
        ifnull(fculture,'') as fculture, ifnull(fncc,'') as fncc, 
        ifnull(fnss,'') as fnss, ifnull(fdefence,'') as fdefence,
        ifnull(fpdp,'') as fpdp,ifnull(fcof,'') as fcof,ifnull(fcoh,'') as fcoh,
        ifnull(fcovid,'') as fcovid,
        ifnull(fgah,'') as fgah,ifnull(fkanm,'') as fkanm, 
        ifnull(funikar,'') as funikar,
        ifnull(fchilsuid,'') as fchilsuid,
        ifnull(fjks,'') as fjks,
        ifnull(fscouts,'') as fscouts,
        ifnull(fhandicap,'') as fhandicap, ifnull(fqdegree,'') as fqdegree, 
        ifnull(FQCOMBCODE,'') as fcombcode, ifnull(fquniv,'') as fquniv, ifnull(fqyear,'') as fqyear, 
        ifnull(fqmonth,'') as fqmonth, ifnull(fqregno,'') as fqregno, 
        ifnull(fqclass,'') as fqclass, ifnull(fqmaxmarks,'') as fqmaxmarks, 
        ifnull(fqsecmarks,'') as fqsecmarks, ifnull(fqpercentage,'') as fqpercentage, 
        ifnull(flang1,'') as flang1, ifnull(flang1mm,'') as flang1mm, 
        ifnull(flang1ms,'') as flang1ms, ifnull(flang2,'') as flang2, 
        ifnull(flang2mm,'') as flang2mm, ifnull(flang2ms,'') as flang2ms, 
        ifnull(fpgdegree,'') as fpgdegree, ifnull(fpgqdegree,'') as fpgqdegree, 
        ifnull(fpgunivtype,'') as fpgunivtype, ifnull(fpgqclass,'') as fpgqclass, 
        ifnull(fpguniv,'') as fpguniv, ifnull(fpgyear,'') as fpgyear, 
        ifnull(fpgmonth,'') as fpgmonth, ifnull(fpgregno,'') as fpgregno, 
        ifnull(fpgmaxmarks,'') as fpgmaxmarks, ifnull(fpgsecmarks,'') as fpgsecmarks, 
        ifnull(fothexam,'') as fothexam, ifnull(fsponsor,'') as fsponsor, 
        ifnull(fothinfo,'') as fothinfo, ifnull(fdocattest,'') as fdocattest,
        ifnull(fpaystatus,'') as fpaystatus,ifnull(fmngetexam,'') as fmngetexam,
        ifnull(fmngexamname,'') as fmngexamname, ifnull(fmngrank,'') as fmngrank,ifnull(fwrkexp,'') as fwrkexp,
        ifnull(fwrkexppath,'') as fwrkexppath,
        ifnull(FQCOLLEGE,'') as FQCOLLEGE,
        ifnull(FLANMM,'') as FLANMM, ifnull(freligion,'') as freligion, ifnull(fmotherton,'') as fmotherton,
        ifnull(fbloodgrp,'') as fbloodgrp, ifnull(fsubcaste,'') as fsubcaste, ifnull(fincomerdno,'') as fincomerdno,
        ifnull(fcasterdno,'') as fcasterdno, ifnull(fhkrdno,'') as fhkrdno, ifnull(fexservice,'') as fexservice,
        ifnull(foutstud,'') as foutstud, ifnull(fselfsupsch,'') as fselfsupsch,
        ifnull(FLANMO,'') as FLANMO, fappstatus,ifnull(funivstud,'') as funivstud,
        ifnull(fdocvrfloc,'') as fdocvrfloc,
        ifnull(fgardname,'') as fgardname,ifnull(fgardocc,'') as fgardocc,
        ifnull(fgirlchild,'') as fgirlchild,ifnull(fsevenkar,'') as fsevenkar,
        ifnull(fkashmig,'') as fkashmig,ifnull(fjkstud,'') as fjkstud,
        ifnull(fruralten,'') as fruralten,ifnull(fkantem,'') as fkantem,
        ifnull(fsonbcu,'') as fsonbcu,ifnull(fstudbu,'') as fstudbu,
        ifnull(finkar,'') as finkar,ifnull(fkarout,'') as fkarout,
        ifnull(fbuautclg,'') as fbuautclg,ifnull(fbiopuc,'') as fbiopuc,
        ifnull(fmathpuc,'') as fmathpuc,ifnull(fsponrcand,'') as fsponrcand
        from entstudadm_bkp_07122020 where fappno = '{$fappno}'";
        //
        $result1 = $aobj_context->mobj_db->GetRow($query);
        $query ="select fheadcode, fmaxfee from admfeestr 
        where fdegree ='PGET' 
        and fcatcode = '{$result1['fcategory']}' and fcombcode = 'PGET' and fexamno = 'A'
        and date_format(now(), '%Y-%m-%d') between fadmfeesdate and fadmfeeedate
        order by fheadcode";

$result2 = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
        left join entprevmarks pm
        on cd.fdegree = pm.fdegree
        and cd.fsubcode = pm.fsubcode
        and ifnull(pm.fcombcode,'') NOT IN ('lan', 'TOT')
        where pm.fappno = '{$fappno}'
        group by cd.fdegree, cd.fsubcode";
        $result3 = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
        left join entprevmarks pm
        on cd.fcombcode = pm.fcombcode
        and cd.fsubcode = pm.fsubcode
        and ifnull(pm.fcombcode,'') = 'lan'
        where pm.fappno = '{$fappno}'";
        $reslan = $aobj_context->mobj_db->GetAll($query);

$query ="select concat(cd.fsubcode,'-',cd.fsubname) as subname,pm.* from entprevcomb cd
        left join entprevmarks pm
        on cd.fcombcode = pm.fcombcode
        and cd.fsubcode = pm.fsubcode
        and ifnull(pm.fcombcode,'') = 'TOT'
        where pm.fappno = '{$fappno}'";
        $restotsem = $aobj_context->mobj_db->GetAll($query);

$query ="select fdoctype,ifnull(fpath,'') as fpath from entstuddoc where fappno = '{$fappno}'";
        $result4 = $aobj_context->mobj_db->GetAll($query);
        if(count($result1) > 0) {
          $arr['student'] = $result1;
          $arr['feedetl'] = $result2;
          $arr['optsub'] = $result3;
          $arr['reslan'] = $reslan;
          $arr['db'] = $db;
          $arr['restotsem'] = $restotsem;
          $arr['studoc'] = $result4;
          $arr['ackvfd'] = $result1['fappstatus'];

echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
          return;
        }
    }

$arr['msg'] = "No data found";
    echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
    return;
  }

}

${this.title}

Code Editor : getSavedData.php