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

<?php
function viewpresealallot($aobj_context)
{

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);

$fdeptt = $aobj_context->mobj_data["fdeptt"];
    $collcode = $aobj_context->mobj_data["collcode"];

$query = "select * from entseatallot where fdegree = '{$fdeptt}' and fcollcode = '{$collcode}'";
    $res =  $aobj_context->mobj_db->GetAll($query);

if($res){
    
      $arr['msg']="Students started paying. you cant change";
      echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed");
      return;
    }

$query1 = "select round(ifnull(s.fentmarks,0)/2,2) as fent50, 
    round(ifnull(s.feffper,0)/2,2) as fdeg50, round((ifnull(s.feffper,0) + ifnull(s.fentmarks,0))/2,2) as ffinalper,
    s.ftotmax, s.fappno,s.fregno,s.fname,s.fhk,s.fcategory,s.fspcat,s.fentmarks,
    s.ftotsec,s.frank,s1.fallotquota,s1.fallotcoll,s1.fallotcatcode
    from entcandlist s inner join entoptions o on s.fappno = o.fappno and s.fdegree = o.fdegree
    left join entcandlist_new s1 on 
    s.fappno = s1.fappno 
    and s.fdegree = s1.fdegree
    and s.fregno = s1.fregno 
    and s1.fallotcoll = o.fcollcode
    where s.fdegree = '{$fdeptt}'
    and o.fcollcode = '{$collcode}'
    and ifnull(s.freject,'') <> 'T'
    order by LPAD(s.frank,4,'0000')";
    // var_dump($query1);
    // die();
     $result1 =  $aobj_context->mobj_db->GetAll($query1);

$html = '<table border = "1" style = "text-align:center;border: 1px solid black;
     border-collapse: collapse;border-spacing: 2px;">
        <thead >
        <tr>
          <th style = "width:5%;text-align:center;"> Sl. No. </th>
          <th style = "width:5%;text-align:center;"> App. No. </th>
          <th style = "width:5%;text-align:center;"> Reg. No. </th>
          <th style = "width:10%;text-align:center;"> Name</th>
          <th style = "width:5%;text-align:center;"> HK </th>
          <th style = "width:5%;text-align:center;"> Applied Cat. </th>
          <th style = "width:5%;text-align:center;"> Special Quota </th>
          <th style = "width:5%;text-align:center;"> Uni. Marks </th>
          <th style = "width:5%;text-align:center;"> Ent. marks </th>
          <th style = "width:5%;text-align:center;"> Deg.(50%)  </th>
          <th style = "width:5%;text-align:center;"> Ent.(50%)  </th>
          <th style = "width:5%;text-align:center;"> Tot. % </th>
          <th style = "width:5%;text-align:center;"> Rank </th>
          <th style = "width:15%;text-align:center;"> Cat. </th>
          <th style = "width:15%;text-align:center;"> Quota </th>
          <th style = "width:5%;text-align:center;"> Action </th>
        </tr>
        </thead>
        <tbody>
              ';
    $i  =1;

$cat = '<option value = "">--Select--</option>
    <option>GM</option>
    <option>CAT-I</option>
    <option>IIA</option>
    <option>IIB</option>
    <option>IIIA</option>
    <option>IIIB</option>
    <option>SC</option>
    <option>ST</option>
    <option>PH</option>
    <option value = "NSS">NSS/NCC/SPORTS</option>
    <option value = "EX" >EX-SERVICEMAN</option>
    ';

$opt = '<option value = "">--Select--</option>
    <option>General Quota *</option>
    <option>371(J)</option>';

foreach($result1 as $value){

$regno = $value['fregno'];
      $fappno = $value['fappno'];

$html .= "<tr>
      <td>$i</td>
      <td id='appno_$regno' style = 'padding:2px;'>".$value['fappno']."</td>
      <td style = 'padding:2px;'>".$value['fregno']."</td>
      <td style = 'text-align:left;padding:2px;'>".$value['fname']."</td>
      <td>".$value['fhk']."</td>
      <td>".$value['fcategory']."</td>
      <td>".$value['fspcat']."</td>
      <td>".$value['ftotsec']."/".$value['ftotmax']."</td>
      <td>".$value['fentmarks']."</td>
      <td>".$value['fdeg50']."</td>
      <td>".$value['fent50']."</td>      
      <td>".$value['ffinalper']."</td>
      <td>".$value['frank']."</td>
      <td><select id='catcode_$regno' class='form-control'>".$cat."</select></td>
      <td><select id='quta_$regno' class='form-control'>".$opt."</select></td>
      <td><button
      type='button'
      class='btn btn-primary waves-effect'
      onclick=\"savepresealallot('{$regno}')\"
    >
      Save
    </button></td>
      </tr>";
      $i++;
    }

$html .= '</tbody></table>';
 
  if($result1){
    
    $data['studdata'] = $result1;
    $data['html'] = $html;

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

}

function savepresealallot($aobj_context)
{
  $appno = $aobj_context->mobj_data["appno"];
  $quta = $aobj_context->mobj_data["quta"];
  $catcode = $aobj_context->mobj_data["catcode"];
  $coll = $aobj_context->mobj_data["coll"];
  $regno = $aobj_context->mobj_data["regno"];
  $fdeptt = $aobj_context->mobj_data["fdeptt"];
  
  if($_SESSION['USERNAME'] == NULL || $_SESSION['USERNAME'] == '')
	{
		$arr = "Please login";
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"error"); 
		return;
	}

$user = $_SESSION['USERNAME'];

$query = "select * from entcandlist_new where fappno = '{$appno}'
and  fregno = '{$regno}'
and fdegree = '{$fdeptt}'
and fallotcoll = '{$coll}'";
$rs1 = $aobj_context->mobj_db->GetRow($query);

if($catcode =='' && $quta == ''){
  $qyery1 = "delete from entcandlist_new
  where  fappno = '{$appno}'
  and  fregno = '{$regno}'
  and fdegree = '{$fdeptt}'
  and fallotcoll = '{$coll}'";
  $rst2 = $aobj_context->mobj_db->Execute($qyery1);
  //var_dump($qyery1);
}
else if($rs1)
{
  $qyery1 = "update entcandlist_new set fallotquota = '{$quta}', fallotcoll = '{$coll}', 
  fallotcatcode = '{$catcode}',
  fmoduser = '{$user}', 
  fmoddate = now()
  where  fappno = '{$appno}'
  and  fregno = '{$regno}'
  and fdegree = '{$fdeptt}'";
  $rst2 = $aobj_context->mobj_db->Execute($qyery1);
}
else
{

$insert = "insert into entcandlist_new(fdegree, fappno, fregno, fname, fcategory, fspcat, funiv, fhk, funivstud1, fqdegree, fqregno1, famo, fbmo, fcmo, fdmo, femo, ffmo, famm, fbmm, fcmm, fdmm, femm, ffmm, fdegree1, fappno1, fqregno, funivstud, fregno1, fnoatta, fnoattb, fnoattc, fnoattd, fnoatte, fnoattf, fentmarks, fmaxmarksa, fmarksa, fmaxmarksb, fmarksb, fmaxmarksc, fmarksc, fmaxmarksd, fmarksd, fmaxmarkse, fmarkse, fmaxmarksf, fmarksf, ftotsec, ftotmax, fototsec, fototmax, fnoatt, fper, foper, feffper, fper3, fper2, fper1, frank, fallotquota, fallotcoll, fallotcatcode, fmoduser, fmoddate, freject)
  select  fdegree, fappno, fregno, fname, fcategory, fspcat, funiv, fhk, funivstud1, fqdegree, fqregno1, famo, fbmo, fcmo, fdmo, femo, ffmo, famm, fbmm, fcmm, fdmm, femm, ffmm, fdegree1, fappno1, fqregno, funivstud, fregno1, fnoatta, fnoattb, fnoattc, fnoattd, fnoatte, fnoattf, fentmarks, fmaxmarksa, fmarksa, fmaxmarksb, fmarksb, fmaxmarksc, fmarksc, fmaxmarksd, fmarksd, fmaxmarkse, fmarkse, fmaxmarksf, fmarksf, ftotsec, ftotmax, fototsec, fototmax, fnoatt, fper, foper, feffper, fper3, fper2, 
  fper1, frank, '{$quta}', '{$coll}', '{$catcode}', '{$user}', now(), freject 
  from entcandlist
  where fappno = '{$appno}'
  and  fregno = '{$regno}'
  and fdegree = '{$fdeptt}'";
  $rst2 = $aobj_context->mobj_db->Execute($insert);
}

if($rst2)
 {	
   $success_msg= "Updated Successfully";
   echo $aobj_context->mobj_output->ToJSONEnvelope($success_msg,0,"success"); 
 }	
 else
 {	
   $error_msg = "Some Failure as occured";
   echo $aobj_context->mobj_output->ToJSONEnvelope($error_msg,-1,"error"); 
 }

}
?>

${this.title}

Code Editor : presealallot.php