Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
acceptqp.php	4.4 KB	-rw-rw-r--
assignUserMenu.php	12.78 KB	-rw-rw-r--
assignmod.php	19.91 KB	-rw-rw-r--
availableqp.php	7.95 KB	-rw-rw-r--
changePwd.php	8.54 KB	-rw-rw-r--
deggrpCreation.php	2.84 KB	-rw-rw-r--
degreeCreation.php	4.07 KB	-rw-rw-r--
displayTempDet.php	8.07 KB	-rwxr-xr-x
eligibleQpSetter.php	4.09 KB	-rw-rw-r--
error_log.php	755 B	-rw-rw-r--
forgetPassword.php	4.62 KB	-rw-r--r--
generateBill.php	17.53 KB	-rw-r--r--
getTeacherlists.php	954 B	-rw-rw-r--
guidelines.php	578 B	-rw-rw-r--
login.php	18.9 KB	-rw-rw-r--
modupdqp.php	12.15 KB	-rw-rw-r--
prepareQpNew.php	19.1 KB	-rw-rw-r--
preparethqp.php	27.17 KB	-rw-rw-r--
qpbankdet.php	1.47 KB	-rw-rw-r--
qplog.php	938 B	-rw-rw-r--
qpsummary.php	6.91 KB	-rw-rw-r--
qptran.php	4.15 KB	-rw-rw-r--
registration.php	25.35 KB	-rw-rw-r--
saveAbstractForm.php	6.83 KB	-rw-rw-r--
select-final-qp.php	9.02 KB	-rw-rw-r--
selectqpsetter.php	58.98 KB	-rw-rw-r--
sendGridMail.php	1.72 KB	-rw-rw-r--
sendzohomail.php	1.46 KB	-rw-rw-r--
subjectCretion.php	8.58 KB	-rw-rw-r--
subqnwise.php	1.46 KB	-rw-rw-r--
teacherentry.php	10.29 KB	-rw-rw-r--
updqppattern.php	9.56 KB	-rw-rw-r--
uploadqp.php	10.22 KB	-rw-rw-r--
usertype.php	5.02 KB	-rw-rw-r--
viewQPScr.php	18.03 KB	-rw-r--r--
wordFile.php	1.32 KB	-rw-rw-r--

Code Editor : subjectCretion.php

<?php
	function getdeggrpsubject($aobj_context){
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data['db'];
    
        $query="SELECT fdeggrp as `key`, fdeggrp as `value`, concat(fdescpn, ' ', '[',fdeggrp,']') as `label` FROM tdvs_deggrp order by fdescpn";
         
        $result = $aobj_context->mobj_db->GetAll($query);
	
        if($result)
        {
        echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
        }
        else
        {
        $arr['msg'] = 'No Data found';
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 	
        }
	}

function getboardTosubject($aobj_context){
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data['db'];

$qry="select *from masboard where fboardname <> '' ";
		$result = $aobj_context->mobj_db->GetAll($qry);

if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success"); 
            return;	
        }else{
            $arr['msg'] = 'Something went wrong try again later';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
            return;	
        }

}
	function getDegreesTosubject($aobj_context){
	
		$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data['db'];
        $deggrp = $aobj_context->mobj_data['deggrp'];

$query = "select distinct fdegree as `key`, fdegree as `value`, 
                concat(fdescpn, ' ', '[',fdegree,']') as `label` from degree 
                where ifnull(fdegree, '') <> '' order by fdescpn";

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

// $query1 = "update tdvs_masqp set fexamno='{$data['examno']}', fsubname='{$data['subname']}', 
            //            fboard='{$data['board']}', fdeggrp='{$data['deggrp']}', fssubname='',
            //            fsmaxmarks='{$data['valmax']}'
            //            where fqpcode = '{$data['qpcode']}'";
            // $result1 = $aobj_context->mobj_db->Execute($query1);

}else{

$qry = "select fsubcode from subject where fqpcode = '{$data['qpcode']}' 
                and fsubcode = '{$data['subcode']}' and fdegree = '{$data['degree']}'";
			
            $res = $aobj_context->mobj_db->GetRow($qry);

if(count($res) > 0){
                $arr['msg'] = 'Subject code already created for this degree and qpcode';
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
                return;	
            }

$query = "insert into subject(fdegree, fexamno, fsubcode, fsubname, fsubshort, fqpcode, fboard, fvalmax, fssubname)
                    values('{$data['degree']}', '{$data['examno']}', '{$data['subcode']}', '{$data['subname']}', '{$data['subshort']}', 
					'{$data['qpcode']}', '{$data['board']}', '{$data['valmax']}', '')";
				 
            $result = $aobj_context->pobj_db->Execute($query);

// $query1 = "insert into tdvs_masqp(fexamno, fsubname, fqpcode, fboard, fdeggrp, fssubname,fsmaxmarks)
            //         values('{$data['examno']}', '{$data['subname']}', '{$data['qpcode']}', '{$data['board']}', '{$data['deggrp']}', 
			// 		'{$data['subshort']}','{$data['valmax']}')";
            // $result1 = $aobj_context->mobj_db->Execute($query1);
        }

if($result){
            $arr['msg'] = "Saved Successfully";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
            return;	
        }else{
            $arr['msg'] = 'Something went wrong try again later';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
            return;	
        }
    }

function getSubjectDetails($aobj_context){
  
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data['db'];
    
        // $query = "select ifnull(m.fdeggrp, '')as fdeggrp, ifnull(s.fboard, '')as fboard, 
        //         ifnull(s.fdegree, '')as fdegree, ifnull(s.fexamno, '')as fexamno, 
        //         ifnull(s.fsubcode, '')as fsubcode, ifnull(s.fsubname, '')as fsubname,
        //         ifnull(s.fsubshort, '')as fsubshort, ifnull(s.fqpcode, '')as fqpcode, 
        //         ifnull(s.fvalmax, '')as fvalmax
        //         from subject s inner join tdvs_masqp m on
        //         m.fqpcode = s.fqpcode 
        //         group by fsubcode, fexamno, fdegree
        //         order by fexamno desc";
				$query = "SELECT ifnull(s.fboard, '')as fboard,ifnull(s.fdegree, '')as fdegree,ifnull(s.fexamno, '')as fexamno,
							ifnull(s.fsubcode, '')as fsubcode,ifnull(s.fsubname, '')as fsubname,ifnull(s.fsubshort, '')as fsubshort,
							ifnull(s.fqpcode, '')as fqpcode,ifnull(s.fvalmax, '')as fvalmax,ifnull(d.fdeggrp, '')as fdeggrp
							FROM subject s INNER JOIN degree d ON s.fdegree=d.fdegree AND s.fexamno=d.fexamno
							where fqpcode <> ''
							group by fsubcode, fexamno, fdegree
							order by fexamno desc";
			
        $result = $aobj_context->mobj_db->GetAll($query);

$query1 = "delete from subject where 
                  fexamno='{$exam}' 
                  and fqpcode='{$qpcode}' 
                  and fsubcode='{$subcode}'
                  and fdegree='{$degree}'";
				
        $result1 = $aobj_context->mobj_db->Execute($query1);

if($result1){
             $arr['msg'] = 'Deleted Successfully';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
            return;	
        }else{
            $arr['msg'] = 'Something went wrong try again later';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
            return;	
        }
	}

function updateSubjectCreationData($aobj_context){
		$qpcode=$aobj_context->mobj_data['qpcode'];
      	$examno=$aobj_context->mobj_data['examno'];
		$degree=$aobj_context->mobj_data['degree'];

$query = "SELECT s.fboard,s.fdegree,s.fexamno,s.fsubcode,s.fsubname,s.fsubshort,s.fqpcode,s.fvalmax,d.fdeggrp
		          FROM subject s INNER JOIN degree d ON s.fdegree=d.fdegree AND s.fexamno=d.fexamno 
                  WHERE s.fdegree = '{$degree}' AND s.fexamno='{$examno}' AND fqpcode='{$qpcode}'";
		$res=$aobj_context->mobj_db->GetRow($query);
	
		if($res){
			// $arr['qpcode']=$res;
			// $arr['degree']=$result;
		   echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success"); 
		   return;	
	   }else{
		   $arr['msg'] = 'Something went wrong try again later';
		   echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
		   return;	
	   }
	}
	?>

${this.title}

Code Editor : subjectCretion.php