Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
.admin-src.php	3.61 KB	-rw-r--r--
AdmissionListReportExcel.php	13.85 KB	-rwxrwxrwx
ApplicationFeeSumExcel1.php	7.43 KB	-rwxrwxrwx
ApplicationFeeSummary.php	10.14 KB	-rwxrwxrwx
ApplicationFeeSummaryExcel.php	2.93 KB	-rwxrwxrwx
ApplicationReport.php	10.32 KB	-rwxrwxrwx
Applicationfeereport.php	8.72 KB	-rwxrwxrwx
Collegewise_SeatAllotedList.ph...	11.13 KB	-rwxrwxrwx
Degreewise_Adm_Fee_Collected.p...	7.66 KB	-rwxrwxrwx
Degreewise_SeatAllotedList.php	12.09 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_all...	11.18 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_cre...	19.46 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_cre...	17.58 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_cre...	17.83 KB	-rwxrwxrwx
Degreewise_SeatAllotedList_fin...	17.11 KB	-rwxrwxrwx
PrintDocumentVerification.php	28.13 KB	-rwxrwxrwx
SeatMatrixReport.php	24.02 KB	-rwxrwxrwx
admList.php	1.11 KB	-rwxrwxrwx
admconfirmation.php	4.43 KB	-rwxrwxrwx
admissionFeeSummaryReportExcel...	9.64 KB	-rwxrwxrwx
admissionfeedetails.php	1.61 KB	-rw-rw-r--
admissionfeereport.php	11.59 KB	-rw-rw-r--
admissionstatusreport.php	12.62 KB	-rwxrwxrwx
admorder_ru.php	4.4 KB	-rw-r--r--
applicationFormReportBank.php	11.91 KB	-rw-rw-r--
applicationview.php	4.11 KB	-rwxrwxrwx
changepasswordadmin.php	1.12 KB	-rwxrwxrwx
collegedegree.php	1.92 KB	-rwxrwxrwx
collegedetails.php	2.49 KB	-rwxrwxrwx
create-user.php	4.66 KB	-rwxrwxrwx
documentverification.php	15.69 KB	-rwxrwxrwx
dudseatallot.php	6.11 KB	-rw-rw-r--
getnumword.php	9.1 KB	-rw-rw-r--
loadadmhostelfeedetails.php	2.16 KB	-rw-r--r--
loadhostelfeedetails.php	4.6 KB	-rw-r--r--
presealallot.php	7.58 KB	-rw-rw-r--
provisionsellist.php	1.58 KB	-rw-rw-r--
provisionsellistReport.php	13.78 KB	-rw-rw-r--
provisionsellistReportDownload...	14.94 KB	-rw-rw-r--
report_merit_list.php	6.82 KB	-rwxrwxrwx
rostertable.php	490 B	-rwxrwxrwx
saveApplication.php	19.13 KB	-rwxrwxrwx
savevacantseats.php	2.57 KB	-rw-r--r--
seat_alloted_seatmatrix.php	11.34 KB	-rwxrwxrwx
seatmatrix.php	8.57 KB	-rwxrwxrwx
signin.php	846 B	-rwxrwxrwx
viewpresealallot2.php	8.17 KB	-rw-r--r--

Code Editor : loadhostelfeedetails.php

<?php
function loadhostelfeedetails($aobj_context)
{
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    $univcode = $aobj_context->mobj_data["univcode"];
  
    $query1 = "select fname, fmobileno, fappno, fpaystatus, fcreatedate, IFNULL(fpayid, ' ') as fpayid FROM 
	  entstudadm where fmobileno = '{$_SESSION['MOBILE']}'";
    //var_dump($query1);
    $result1 =  $aobj_context->mobj_db->GetAll($query1);
    
    $hotstal = 'T'; 
    
    // $arr['msg']="Last Date is over";
    // echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed");
    // return;

$fappno = $result1[0]['fappno'];
   
    $query2 = "SELECT IFNULL(ead.fname,'') AS fname,
    IFNULL(eal.fappno,'') AS fappno,
    IFNULL(eal.fallotno,'') AS fallotno,
    IFNULL(eal.fregno,'') AS fregno,
    IFNULL(eal.fpaymentstatus,'') AS fpaymentstatus,
    IFNULL(ead.fcategory,'') AS fcategory,
    IFNULL(ec.fcollname,'') AS fcollname,
    IFNULL(eal.fdegree,'') AS fdegree,
    IFNULL(eal.fpamount,'') AS famount,
    ifnull(eal.fquota,'') as fquota,
    ifnull(fstudfrom,'') as fstudfrom 
    FROM entseatallot eal 
    INNER JOIN entstudadm ead ON eal.fappno = ead.fappno
    INNER JOIN entoptdeg ede ON eal.fappno = ede.fappno 
    AND ede.fdegree = eal.fdegree
    INNER JOIN entdeg d ON eal.fdegree = d.fdegree 
    INNER JOIN entcoll ec ON eal.fcollcode = ec.fcollcode
    WHERE IFNULL(eal.fpaymentstatus,'') = 'success'
    and eal.fallotround = '2'
    AND eal.fappno = '{$fappno}'";

//    var_dump($query2);
  $result2 = $aobj_context->mobj_db->GetRow($query2);

$query3 = "select ifnull(fbankname,'') as fbankname, ifnull(faccno,'') as faccno,
      ifnull(fifsc,'') as fifsc,      
      ifnull(fbranch,'') as fbranch,
      ifnull(fpaymentstatus,'') as fpaymentstatus,
      fappno 
      from entstudhostel
      where fappno = '{$fappno}'";

$result3 = $aobj_context->mobj_db->GetRow($query3);

$arr['stud'] = $result2;
      $arr['bank'] = $result3;
      $arr['hotstal'] = $hotstal;

if($result2){
    echo $aobj_context->mobj_output->TOJSONEnvelope($arr,0,"success");
    return;
  }
  else{
    $arr['msg']="Failed to load";
    echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed");
    return;
  }

}

function savebankdetails($aobj_context)
{
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
   
    $univcode = $aobj_context->mobj_data["univcode"];
    $bankname = $aobj_context->mobj_data["bankname"];
    $accno = $aobj_context->mobj_data["accno"];
    $ifsc = $aobj_context->mobj_data["ifsc"];
    $branch = $aobj_context->mobj_data["branch"];
    $appno = $aobj_context->mobj_data["appno"];
    $fmobile = $_SESSION['MOBILE'];
    $famount = $aobj_context->mobj_data["famount"];

if($fmobile == '')
  {
    $data = 'Login and try again';    
    echo $aobj_context->mobj_output->TOJSONEnvelope($data,-1,"failed");
    return;
  }

$query = "select * From entstudhostel where fmobileno = '{$fmobile}'";
    $res = $aobj_context->mobj_db->GetRow($query);
    if($res)
    {

$upd = "update entstudhostel set 
      fbankname = '{$bankname}',
      faccno = '{$accno}',
      fifsc = '{$ifsc}',
      fbranch = '{$branch}'
      where fappno = '{$appno}'";
      $result = $aobj_context->mobj_db->Execute($upd);

}else
    {
      $query = "insert into entstudhostel (fappno,fmobileno,fregno,fname,fcategory,fcollcode,fdegree,famount,
      fbankname,faccno,fifsc,fbranch,fcreateddate) 
      SELECT 
      IFNULL(eal.fappno,'') AS fappno,
      '{$fmobile}',
      IFNULL(eal.fregno,'') AS fregno,
      IFNULL(ead.fname,'') AS fname,
      IFNULL(ead.fcategory,'') AS fcategory,
      IFNULL(eal.fcollcode,'') AS fcollcode,
      IFNULL(eal.fdegree,'') AS fdegree,
      '{$famount}',
      '{$bankname}',
      '{$accno}',
      '{$ifsc}',
      '{$branch}',
      now()
      FROM entseatallot eal 
      INNER JOIN entstudadm ead ON eal.fappno = ead.fappno
      INNER JOIN entoptdeg ede ON eal.fappno = ede.fappno 
      AND ede.fdegree = eal.fdegree
      INNER JOIN entdeg d ON eal.fdegree = d.fdegree 
      INNER JOIN entcoll ec ON eal.fcollcode = ec.fcollcode
      WHERE IFNULL(ead.fpaystatus,'') = 'success'
      AND eal.fappno = '{$appno}'";
      $result = $aobj_context->mobj_db->Execute($query);
    }

if($result){

$query = "select * From entstudhostel where fmobileno = '{$fmobile}'";
    $res = $aobj_context->mobj_db->GetRow($query);

$data['fhostalid'] = $res['fhostalid'];  
    echo $aobj_context->mobj_output->TOJSONEnvelope($data,0,"success");
    return;
  }
  else{
    $data = 'Failed save';    
    echo $aobj_context->mobj_output->TOJSONEnvelope($data,-1,"failed");
    return;
  }

}

${this.title}

Code Editor : loadhostelfeedetails.php