Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
acceptqp.php	3.43 KB	-rw-r--r--
assignUserMenu.php	12.78 KB	-rw-r--r--
assignmod.php	18.62 KB	-rw-r--r--
availableqp.php	7.74 KB	-rw-r--r--
changePwd.php	4.07 KB	-rw-r--r--
deggrpCreation.php	2.84 KB	-rw-r--r--
degreeCreation.php	4.07 KB	-rw-r--r--
displayTempDet.php	8.07 KB	-rwxr-xr-x
eligibleQpSetter.php	3.92 KB	-rw-r--r--
error_log.php	755 B	-rw-r--r--
getTeacherlists.php	954 B	-rw-r--r--
guidelines.php	578 B	-rw-r--r--
login.php	16.78 KB	-rw-r--r--
modupdqp.php	10.68 KB	-rw-r--r--
prepareQpNew.php	19.1 KB	-rw-r--r--
preparethqp.php	27.17 KB	-rw-r--r--
qpbankdet.php	1.45 KB	-rw-r--r--
qplog.php	938 B	-rw-r--r--
qpsummary.php	7.04 KB	-rw-r--r--
registration.php	21.67 KB	-rw-r--r--
saveAbstractForm.php	6.83 KB	-rw-r--r--
select-final-qp.php	8.84 KB	-rw-r--r--
selectqpsetter.php	41.03 KB	-rw-r--r--
sendGridMail.php	1.72 KB	-rw-r--r--
subjectCretion.php	8.58 KB	-rw-r--r--
subqnwise.php	1.46 KB	-rw-r--r--
teacherentry.php	7.9 KB	-rw-r--r--
updqppattern.php	9.11 KB	-rw-r--r--
uploadqp.php	8.91 KB	-rw-r--r--
usertype.php	3.43 KB	-rw-r--r--
viewQPScr.php	17.78 KB	-rw-r--r--

Code Editor : selectqpsetter.php

<?php
 function getSelectedQpSetters($aobj_context){
 $deggrp = $aobj_context->mobj_data["deggrp"];
 $board = $aobj_context->mobj_data["board"];
 $qpcode = $aobj_context->mobj_data["qpcode"];
 $type = $aobj_context->mobj_data["type"];

if($board === "All"){
            $boardCond = "";
            $boardcon= "";
        }else{
            $boardCond = "and qp.fboard = '{$board}'";
            $boardcon = "and s.fboard = qp.fboard";
        }

$query="select fyear, fexamtype from deggrp where fdeggrp = '{$deggrp}'";
 $row = $aobj_context->mobj_db->GetRow($query);
 
 $fyear = $row['fyear'];
 $fexamtype = $row['fexamtype'];
 
 $query = "select m.fteachcode, m.fteachname, m.fmobile, m.femail, qp.fyear, qp.fexamtype,
 count(fset)as totalsets,
 sum(if(ifnull(fqpfilepath, '')<>'',1,0)) as setsdone,
 if(count(fset)='0', 0, sum(if(ifnull(fqpfilepath, '')='',1,0))) as setspending,
 ifnull(qp.fstatus, 'F') as status, ifnull(qp.fnoqp,'1') as fnoqp, 
 if(ifnull(flastdate,'') = '','', date_format(flastdate,'%d/%m/%Y')) as flastdate,
 ifnull(qp.femailstatus,'') as femailstatus,
 ifnull(qp.fmaxqn, '')as fmaxqn, 
 ifnull(qp.fpretype, '')as fpretype
 from masteach m inner join qpseter qp on m.fteachcode=qp.fteachcode
 inner join (select distinct fqpcode, fsubname from subject where ifnull(fqpcode,'') <> '') s on s.fqpcode = qp.fqpcode and s.fqpcode='{$qpcode}'
 left join qpseterdet q 
 on q.fqpcode = qp.fqpcode and q.fteachcode = qp.fteachcode and q.ftype = qp.ftype
 $boardcon
 where qp.fqpcode='{$qpcode}' $boardCond
 and qp.fqpcode in(select distinct s.fqpcode from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno
 where d.fdeggrp = '{$deggrp}')
 and ifnull(qp.fstatus, 'F') = 'T'
 and qp.ftype='{$type}' and qp.fyear='2222' and qp.fexamtype='2'
 group by m.fteachcode";
 // var_dump($query);die();
 $result = $aobj_context->mobj_db->GetAll($query);

$query1 = "select fqpcode, count(distinct ifnull(fset,0))as available
 from qpseterdet
 where fqpcode='{$qpcode}' and ifnull(fdeleted, '') <> 'T'
 and ifnull(FFINALPAPER, '') = ''
				 and ifnull(fmodqpdate,'') <> ''
 and ftype='{$type}'";
 $result1 = $aobj_context->mobj_db->GetRow($query1);
 
 if($result1){
 $arr['data'] = $result;
 $arr['avl'] = $result1;
 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
 } else {
 $arr['msg'] = 'No data Found';
 echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
 }
 }

function checkTemplateCode($aobj_context){
        $updtype = $aobj_context->mobj_data["updtype"];
        $type = $aobj_context->mobj_data["type"];
        $qpcode = $aobj_context->mobj_data["qpcode"];
        $data = $aobj_context->req_body;

$query = "select ifnull(FQPPATREN,'') as FQPPATREN, ifnull(ftempcode,'') as ftempcode, ifnull(fonlineqp, '')as fonlineqp from subject 
                  where fqpcode = '{$qpcode}'";
        $res = $aobj_context->mobj_db->GetRow($query);

if($updtype == "upload"){
            $msg = 'QP Pattren and Syllabus not found for this QP Code '.$qpcode;
        }else if($updtype == "online"){
            $msg = 'Template not found for this QP Code '.$qpcode;
        }

if($res){
            echo $aobj_context->mobj_output->ToJSONEnvelope($res, 0, "success");
        }else{
            $arr['msg'] = $msg;
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
            return;
        }
    }

function saveQpsetterDetails($aobj_context){
        include("/var/www/html/collportal/src/sendGridMail.php");
        include("/var/www/html/collportal/src/error_log.php");
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
        $univcode = $aobj_context->mobj_data["univcode"];
        $mob = $aobj_context->mobj_data["mob"];
        $user = $aobj_context->mobj_data["user"];
        $deggrp = $aobj_context->mobj_data["deggrp"];
        $board = $aobj_context->mobj_data["board"];
        $qpcode = $aobj_context->mobj_data["qpcode"];
        $collcode = $aobj_context->mobj_data["collcode"];
        $mobile = $aobj_context->mobj_data["mobile"];
        $type = $aobj_context->mobj_data["type"];
        $table = json_decode($aobj_context->mobj_data["data"], true);

$qry_examdate = "select fexamdate from qpset_deggrp 
                         where fdeggrp='{$deggrp}'";
        $res_examdate = $aobj_context->mobj_db->GetRow($qry_examdate);
        $examdate = $res_examdate['fexamdate'];

$sub_qry = "select fdegree, fexamno, fsubcode from subject where fqpcode = '{$qpcode}'"; 
        $res_sub_qry = $aobj_context->mobj_db->GetRow($sub_qry);

$csub_qry = "select fcsubcode, fvalmax from subject where 
                    fdegree = '{$res_sub_qry['fdegree']}' and fexamno = '{$res_sub_qry['fexamno']}' 
                    and fsubcode = '{$res_sub_qry['fsubcode']}' and fonlineqp = 'T'";

$cres_sub_qry = $aobj_context->mobj_db->GetRow($csub_qry);

if($type === 'MCQ'){
            $typeCnd = "and ifnull(fonlineqp, '') = 'T'";
        }else{
            $typeCnd = "";
        }

$query = "select ifnull(FQPPATREN,'') as FQPPATREN, ifnull(ftempcode, '')as ftempcode from subject 
                  where fqpcode = '{$qpcode}' $typeCnd";
        $res = $aobj_context->mobj_db->GetRow($query);

$tempcode = $res["ftempcode"];

foreach ($table as $value) {
            $fteachcode = $value['fteachcode'];
            $totalsets = intval($value['totalsets']);
            $assigned = intval($value['fassign']);

$query = "update qpseter set fappointed = '{$value['status']}', fappointdate = now(),
                      fappointuser = '{$value['fmobile']}', femailstatus = '{$value['emailstatus']}', 
                      fpretype = '{$value['fpretype']}', flastdate = date_format(str_to_date('{$value['flastdate']}', '%d/%m/%Y'), '%Y-%m-%d')
                      where fteachcode = '{$fteachcode}'
                      and fqpcode = '{$qpcode}' and ftype='{$type}' 
                      and fyear='{$value['fyear']}' and fexamtype='{$value['fexamtype']}'";
            $result = $aobj_context->mobj_db->Execute($query);

for($i = $totalsets+1; $i <= $totalsets+$assigned; $i++){
 $query = "insert into qpseterdet (fyear, fexamtype, fqpcode, fteachcode, fset, ftype, 
 fpretype, ftempcode, fexamdate, fmaxmarks, fmaxqn, fcreatedate, fcreateuser)
 values('{$value['fyear']}', '{$value['fexamtype']}', '{$qpcode}', '{$fteachcode}', {$i}, '{$type}', 
 '{$value['fpretype']}', '{$tempcode}', '{$examdate}', 
 '{$cres_sub_qry['fvalmax']}', '{$value['fmaxqn']}', now(), '{$user}')";
 $result = $aobj_context->mobj_db->Execute($query);

if($type === 'MCQ'){
                    $qry = "insert ignore into mcqqp (fyear, fexamtype, fqpcode, fteachcode, fnoqp, fexamdate, fcreatedate)
                            values('{$value['fyear']}', '{$value['fexamtype']}', '{$qpcode}', '{$fteachcode}', '{$i}', '{$examdate}', now())";
                    $res = $aobj_context->mobj_db->Execute($qry);

}
            }
            
        }

if ($result) {
            $arr['msg'] = 'Qp setter selected successfully';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
            return;
        }else
        {
            $arr['msg'] = 'Failed to update';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
        }

// $qry="select fyear, fexamtype from deggrp where fdeggrp = '{$deggrp}'";
        // $row = $aobj_context->mobj_db->GetRow($qry);
    
        // $fyear = $row['fyear'];
        // $fexamtype = $row['fexamtype'];
        
        // $date = date('Y-m-d H:i:s');
        // $onldate = date('d-m-Y');

// $cond = '';
        // if($univcode == '030'){
        //     $cond = ',fqpsettermail';
        // }

// $unishort = "select funivname, ffolder, pdf_logo_path $cond  from control";
        // $resunishort = $aobj_context->mobj_db->GetRow($unishort);
    
        // $univname = $resunishort['funivname'];
        // $univshort = strtoupper($resunishort['ffolder']);
        // $logopath = $resunishort['pdf_logo_path'];
        // $fqpsettermail = $resunishort['fqpsettermail'];

// if($res['FQPPATREN'] == '')
        // {
        //     $arr['msg'] = 'QP Pattren and Syllabus not uploaded for QP Code '.$subj;
        //     echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
        //     return;
        // }

// $query1 = "select distinct s.fdegree,s.fqpcode,s.fsubname,dg.fexamdate,d.fexamname,d.fdescpn,s.fsubshort  
        // from subject s 
        // inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno
        // inner join qpset_deggrp dg on dg.fdeggrp = d.fdeggrp
        // where fqpcode = '{$subj}'";

// $res1 = $aobj_context->mobj_db->GetRow($query1);
    
        // $fdegree = $res1['fdegree'];
        // $fqpcode = $res1['fqpcode'];
        // $fsubname = $res1['fsubname'];
        // $fexamdate = $res1['fexamdate'];
        // $fexamnmae = $res1['fexamname'];
        // $fdescpn = $res1['fdescpn'];
        // $fsubshort = $res1['fsubshort'];

// $truearray = array();
        // $falsearray = array();
        // $qparray = array();
        
        // foreach ($table as $k => $v) {

//     $lastdate = $v['flastdate'];
        //     $teachcode = $v['status'];
        //     $fnoqp = $v['fnoqp'];
        //     $fteachcode = $v['fteachcode'];
        //     $fteachname = $v['fteachname'];

//     $spldate = explode('/',$lastdate);
        //     $flastdate = $spldate[2]."-".$spldate[1]."-".$spldate[0];
            
        //     if($univcode == '030'){
        //         $teachDet = "select concat(ifnull(FTITLE,''), ' ',ifnull(fteachname, ''))as fteachname, 
        //                 ifnull(fcollname, '')as fcollname
        //                 from masteach 
        //                 where fteachcode = '{$fteachcode}'";
        //     }else{
        //         $teachDet = "select concat(ifnull(m.FTITLE,''), ' ',ifnull(m.fteachname, ''))as fteachname, 
        //                 ifnull(m.fcollname, '')as fcollname, d.fdegncode, 
        //                 ifnull(d.fdegndesc, '')as fdegndesc
        //                 from masteach m inner join masdegn d on d.fdegncode = m.fdegncode 
        //                 where fteachcode = '{$fteachcode}'";
        //     }         
        //     $teachDet1 = $aobj_context->mobj_db->GetRow($teachDet);
            
        //     $teachname = $teachDet1['fteachname'];
        //     $colladd = $teachDet1['fcollname'];
        //     $degn = $teachDet1['fdegndesc'];
        
        //     if($v['status'] == 'F' )
        //     {   
            
        //         $query = "update qpseter set fappointed = 'F', fappointdate = now(),
        //         fappointuser = '{$mob}', femailstatus = 'F'
        //         where fteachcode = '{$fteachcode}'
        //         and fqpcode = '{$subj}' and fyear = '{$fyear}' 
        //         and fexamtype = '{$fexamtype}' and ftype='{$type}'"; 
                
        //         $result = $aobj_context->mobj_db->Execute($query);
            
        //         $remarks = "Teacher ". $fteachcode. " removed for the Qp Code ".$fqpcode." Removed User: ".$mob;
        //         $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile);
        //         $resp = true;
        //     }else if($v['status' ] == 'T')
        //     {

//         $query = "update qpseter set fappointed = 'T', fappointdate = '{$date}', femailstatus = '{$v['emailstatus']}', 
        //                 fappointuser = '{$mob}', fnoqp = '{$fnoqp}', ffrommdate= now(), flastdate = '{$flastdate}', 
        //                 fmaxqn='{$v['fmaxqn']}', fpretype='{$v['fpretype']}'
        //                 where fteachcode = '{$fteachcode}'
        //                 and fqpcode = '{$subj}' and fyear = '{$fyear}' and fexamtype = '{$fexamtype}'
        //                 and ftype='{$type}'";
                    
        //         $result = $aobj_context->mobj_db->Execute($query);
                
        //         $remarks = "Teacher ". $fteachcode. " Added for the Qp Code ".$fqpcode." No. of Sets: ".$fnoqp." Last Date: ".$flastdate;

//         $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile);

//         if($type === 'MCQ'){
        //             $qry_examdate = "select fexamdate from qpset_deggrp 
        //                             where fyear='{$fyear}' and fexamtype='{$fexamtype}' and fdeggrp='{$deggrp}'";
        //             $res_examdate = $aobj_context->mobj_db->GetRow($qry_examdate);
        //             $examdate_res = $res_examdate['fexamdate'];

//             $sub_qry = "select fdegree, fexamno, fsubcode from subject where fqpcode = '{$subj}'"; 
        //             $res_sub_qry = $aobj_context->mobj_db->GetRow($sub_qry);

//             $csub_qry = "select fcsubcode, fvalmax from subject where 
        //                         fdegree = '{$res_sub_qry['fdegree']}' and fexamno = '{$res_sub_qry['fexamno']}' 
        //                         and fsubcode = '{$res_sub_qry['fsubcode']}' and fonlineqp = 'T'";
        
        //             $cres_sub_qry = $aobj_context->mobj_db->GetRow($csub_qry);

// for($i = 1; $i <= $fnoqp; $i++) {
 // $query = "insert into qpseterdet (fqpcode, fyear, fexamtype, 
 // fteachcode, fexamdate, fmaxmarks, fmaxqn, fcreatedate, fcreateuser, fset, ftype, fpretype, ftempcode)
 // values('{$subj}', '{$fyear}', '{$fexamtype}', 
 // '{$fteachcode}', '{$examdate_res}', '{$cres_sub_qry['fvalmax']}', 
 // '{$v['fmaxqn']}', now(), '{$mobile}', '{$i}', '{$type}', '{$v['fpretype']}', '{$tempcode}')
 // on duplicate key update fmaxmarks='{$cres_sub_qry['fvalmax']}', fexamdate='{$examdate_res}',
 // fmaxqn='{$v['fmaxqn']}', fqpduser='{$mobile}', fqpdtme=now(), fpretype='{$v['fpretype']}', ftempcode='{$tempcode}'";
 // $result = $aobj_context->mobj_db->Execute($query);

//                 $remarks = "Teacher ". $fteachcode. " set for the Qp Code ".$fqpcode;
        //                 $res = error_logs($aobj_context, $univcode, $remarks, $collcode, "QP Setter", $mobile, $mobile);
        //             }
        //         }

//         if($v['emailstatus'] == 'T'){
        //             $fteach = $v['fteachcode'];
        //         }else{
        //             $fteach = '';
        //         }

//         if($fteach === ''){

// }else{
 // $email = "select femail,fmobile from masteach where fteachcode = '{$fteach}'";
 // }
 
 // $emailres = $aobj_context->mobj_db->GetRow($email);
 
 // $emailid = $emailres['femail'];
 // $mobile = $emailres['fmobile'];
 
 // if($type !== "MCQ"){
 // for($i = 1; $i <= $fnoqp; $i++) {
 // $query = "INSERT ignore INTO qpseterdet (fyear, fexamtype, fqpcode, fteachcode, fset, ftype, fpretype, ftempcode)
 // values('{$fyear}','{$fexamtype}','{$subj}','{$fteachcode}','{$i}', 'THEORY', '{$v['fpretype']}', '{$tempcode}')
 // on duplicate key update fpretype='{$v['fpretype']}', ftempcode='{$tempcode}'";
 // $result = $aobj_context->mobj_db->Execute($query);

//         if($univcode == "051"){
        //             $logo_path = "img/dyp_elogo.jpeg";
        //         }else if($univcode == "030"){
        //             $logo_path = $logopath;
        //         }

// if($univcode == '030'){
 // $logo = "https://universitysolutions.in/".$resunishort['ffolder']. '/'.$logopath;
 // }else{
 // $logo = "https://college.universitysolutions.in/".$resunishort['ffolder']. '/'.$logo_path;
 // }
 
 // if($univcode=="030" || $univcode=="098" || $univcode=="040"){
 // $message="<html>";
 // $message.="<body>";
 // $message.="<style>";		
 // $message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; 
 // font-family: Verdana, Arial, Helvetica, sans-serif;}";	
 // $message.="</style>";
 // $message.="<center><img src='{$logo}' height='100px' width='200px'/></center>";
 // $message.="
 // STRICTLY CONFIDENTIAL ";

// if($univcode!="040")
 // {
 // $message.="
 // From";
 // $message.="
 // Dr. Beena G";
 // $message.="
 // Controller of Examinations";
 // $message.="Date.:"." $onldate "."";
 // }

// $message.="To, ";
 // $message.=""."$teachname"." ";

// // $message.=""."$teachname".", ";
 // if($degn != ""){
 // $message.=""."$degn".", ";
 // }
 
 // // if($colladd != ""){
 // // $message.=""."$colladd".", ";
 // // }

// $message.="
 // Dear Sir/Madam,";
 
 // $message.="
 // Subject: Appointment as Question Paper setter for "." $univname"." of "."$fexamdate"."";

// $message.="
 // On the directions of the Vice-Chancellor, I am pleased to inform you of your appointment as 
 // the Question paper setter for the following course. All question papers are expected to be received on 
 // or before "."$lastdate"." ";

// $message .= "
 // Please note that the QP portal will get auto disabled after the lastdate.";
 
 // $message.="
 // The details are as follows:";

// $message.="
 // <table style='width: 100%;border: 1px solid'>
 // <tr style='border: 1px solid'>
 // <th style='width: 17%;text-align:left;border: 1px solid'>Program</th>
 // <th style='width: 33%;text-align:center;border: 1px solid'>"."$fdegree - $fdescpn"."</th>
 // <th style='width: 17%;text-align:left;border: 1px solid'>Semester</th>
 // <th style='width: 33%;text-align:center;border: 1px solid'>"."$fexamnmae"."</th>
 // </tr>
 // <tr>
 // <th style='width: 17%;text-align:left;border: 1px solid'>Course code</th>
 // <th style='width: 33%;text-align:center;border: 1px solid'>"."$fsubshort"."</th>
 // <th style='width: 17%;text-align:left;border: 1px solid'>Course Title</th>
 // <th style='width: 33%;text-align:center;border: 1px solid'>"."$fsubname"."</th>
 // </tr>
 // <tr>
 // <th style='width: 17%;text-align:left;border: 1px solid'>No. of sets</th>
 // <th style='width: 33%;text-align:center;border: 1px solid'>"."$fnoqp"."</th>
 // <th style='width: 17%;text-align:left;border: 1px solid'>To be submitted on or before</th>
 // <th style='width: 33%;text-align:center;border: 1px solid'>"."$lastdate"."</th>
 // </tr>
 // </table>
 // ";
 // if($univcode=="040")
 // {
 // $message.="
 // The question papers shall be prepared as per the template provided.";
 // }else
 // {
 // $message.="
 // The question papers must be prepared as per the template provided.";
 // }

// $message.="$fqpsettermail";
 
 // $message.="
 // The following details are attached:
 // <ul>
 // <li>Prescribed syllabus</li>
 // <li>Question paper pattern</li>
 // </ul>
 // ";

// if($univcode!="040" && $univcode!="030")
 // { 
 // $message.="Remuneration details:"." ";
 // $message.="
 // <table style='width: 70%'>
 // <tr style='text-align:center;border: 1px solid'>
 // <th style='width: 20%;border: 1px solid'>Sl No</th>
 // <th style='width: 60%;border: 1px solid'>Particulars</th>
 // <th style='width: 20%;border: 1px solid'>Remuneration (Rs)</th>
 // </tr>
 // <tr style='text-align:center'>
 // <th style='width: 20%;border: 1px solid'>1</th>
 // <th style='width: 60%;border: 1px solid'>Question Paper setting</th>
 // <th style='width: 20%;border: 1px solid'>700</th>
 // </tr>
 // <tr style='text-align:center'>
 // <th style='width: 20%;border: 1px solid'>2</th>
 // <th style='width: 60%;border: 1px solid'>Detailed solution, scheme of instruction</th>
 // <th style='width: 20%;border: 1px solid'>500</th>
 // </tr>
 // </table>
 // ";
 // }

// $message.="
 // The question paper needs to be prepared in the template provided and Submitted back as 
 // per the timeline ";

// if($univcode!="040")
 // {
 // $message.="
 // Note :";
 
 // $message.="
 // <ol>
 // 
 // <li>Kindly use font Calibri, size 12 as a standard font for all QP’s.</li>
 // <li>The QP submitted after the mentioned timeline will not be accepted.</li>
 // 
 // </ol>
 // ";
 // }

// $message.="
 // Registration Steps are : 
 // <ol>
 // <li style='color:red;'>State: Karnataka</li>
 // <li style='color:red;'>University : "."$univname"."</li>
 // <li style='color:red;'>Select user type as Teacher</li>
 // <li style='color:red;'>Enter Teacher code which is available in your mail</li>
 // <li style='color:red;'>Click Validate</li>
 // <li style='color:red;'>Fill details as: Enter your Email id and Password is your mobile number. Reenter the same password.</li>
 // <li style='color:red;'>Click Send OTP. You will receive the OTP on your mobile and email also.</li>
 // <li style='color:red;'>Enter OTP.</li>
 // <li style='color:red;'>After this for Login: your mobile number will be the user id and password.</li>
 // <li style='color:red;'>After Login in Question Paper setting Accept the Question Paper Request.</li>
 // <li style='color:red;'>You can see the Question Paper Pattern and Syllabus.</li>
 // <li style='color:red;'>Prepare the two separate word documents</li>
 // <ul>
 // <li style='color:red;'> Question Paper as per given pattern.</li>
 // <li style='color:red;'> Brief Answer Keys.</li>
 // </ul>
 // <li style='color:red;'>For Uploading the Question Paper, first upload the answer key then upload the question paper and click upload button. Repeat the same steps for uploading second set of question paper.</li>
 
 // </ol>
 // ";
 // // <li style='color:red;'>Update the Bank details.</li>

// $message.="
 // Portal Login details are as follows. ";
 // $message.="Portal Link: https://egov.universitysolutions.in/#/register"." ";
 // $message.="Teacher Code:"." $fteachcode"." ";
 // $message.="Mobile No.:"." $mobile"." ";

// if($univcode == "040")
 // {
 // $message.="
 // In case if you have any technical issues, Kindly call 7619186835 or revert to mail dyregistrar.evln@acu.edu.in ";

// $message.="
 // Thanking You,";

// $message.="
 // Yours Sincerely ";
 // }else
 // {
 // $message.="
 // In case if you have any technical issues, Kindly call 080-46966966,Ext.244 or revert to mail ru_qp.coe@reva.edu.in ";

// $message.="
 // Thanking You,";

// $message.="
 // Yours Sincerely ";
 // } 
 // $querySign = "select distinct s.fqpcode, d.fsignpath from degree d inner join subject s on 
 // s.fdegree = d.fdegree and s.fexamno = d.fexamno 
 // where s.fqpcode='{$fqpcode}' and ifnull(fsignpath,'')<>''";
 
 // $ressign = $aobj_context->mobj_db->GetRow($querySign);
 
 // $sign = $ressign['fsignpath'];
 // if($univcode == '030'){
 // $signpath = "https://universitysolutions.in/".$resunishort['ffolder']."/img/".$sign;
 // }else{
 // $signpath = "https://college.universitysolutions.in/".$resunishort['ffolder']."/img/".$sign;
 // }
 // if($sign!==NULL){
 // $message .= "<img src='{$signpath}' width='100' height='50'/>";
 // $message .= " ";
 // }

// if($univcode == "040")
 // {
 // $message.="
 // Registrar Evaluation "." $univname"." 
 // ";
 // }else
 // {
 // $message.="
 // Controller of Examinations "." $univname"." 
 // ";
 // }
 
 // $message.="</body>";
 // $message.="</html>";
 // }else{
 // $message="<html>";
 // $message.="<body>";
 // $message.="<style>";		
 // $message.=".mail_tbl td{text-align:left; padding:2px; font-size:12px; 
 // font-family: Verdana, Arial, Helvetica, sans-serif;}";	
 // $message.="</style>";
 // $message.="<center><img src='{$logo}' height='100px' width='200px'/></center>";
 // $message.="
 // CONFIDENTIAL";
 // $message.="
 // Ref.: DYPU/COE/AYU/2022-23/EP/C-041.";
 // $message.="Date.:"." $onldate "."";

// $message.="To, ";
 // $message.=""."$teachname".", ";
 // if($degn != ""){
 // $message.=""."$degn".", ";
 // }
 // if($colladd != ""){
 // $message.=""."$colladd".", ";
 // }
 // $message.="
 // Sub: Appointment as Question Paper Setter for the University Examination.";

// $message.="
 // Respected Sir / Madam,";

// $message.="
 // I am pleased to inform you that this university has appointed you as Question Paper Setter for the following course in ".$fexamnmae." ".$fdescpn."";
 
 // $message.="
 // <table style='width: 100%;border: 1px solid'><tr><th style='border: 1px solid'>Course Code</th>
 // <th style='border: 1px solid'>Course Name</th><th style='border: 1px solid'>Number of Question papers with Answer key</th></tr>
 // <tr style='text-align:center'><td style='border: 1px solid'>"."$fqpcode"."</td><td style='border: 1px solid'>"."$fsubname"."</td>
 // <td style='border: 1px solid'>"."$fnoqp"."</td></tr></table>";

// $message.="
 // Syllabus with Course Outcomes (CO) and Question Paper Pattern are provided. Kindly prepare question paper as per the requirements
 // of COs and Blooms Taxonomy (Preferably higher cognitive levels) and indicate them at the appropriate places in the question paper along with the marks allotted.";

// $message.="
 // Also share the brief answer key (All Sections) for all questions with proper mark split up.";

// $message.="
 // The Question paper and the answer key (All Sections) are to be uploaded only in the portal on or before "."$lastdate"."";
 
 // $message.="
 // Kindly submit your bank details at the portal.";

// $message.="
 // Kindly inform your acceptance within three days of the receipt of this communication ";

// $message.="Registration Steps are:";
 // $message.="1. State: Maharashtra";
 // $message.="2. University: D Y Patil University, Navi Mumbai";
 // $message.="3. Select user type as Teacher";
 // $message.="4. Enter Teacher code which is available in your mail";
 // $message.="5. Click Validate";
 // $message.="6. Fill details as: Enter your Email id and Password is your mobile number. Reenter the same password.";
 // $message.="7. Click Send OTP. You will receive the OTP on your mobile and email also.";
 // $message.="8. Enter OTP.";
 // $message.="9. After this for Login: your mobile number will be the user id and password.";
 // $message.="10. After Login in Question Paper setting Accept the Question Paper Request.";
 // $message.="11. You can see the Question Paper Pattern and Syllabus.";
 // $message.="12. Prepare the two separate word documents";
 // $message.= "<ul><li>Question Paper as per given pattern.</li><li>Brief Answer Keys.</li></ul>";
 // $message.="13. For Uploading the Question Paper, first upload the answer key then upload the question paper and click upload button. Repeat the same steps for uploading second set of question paper.";
 // $message.="14. Update the Bank details.";

// $message.="
 // Kindly call to 022-30965931/32 in case if you have any technical issues. ";

// $message.="
 // Thanking You,";

// $message.="
 // Yours Sincerely ";

// $querySign = "select distinct s.fqpcode, d.fsignpath from degree d inner join subject s on 
 // s.fdegree = d.fdegree and s.fexamno = d.fexamno 
 // where s.fqpcode='{$fqpcode}' and ifnull(fsignpath,'')<>''";

//             $ressign = $aobj_context->mobj_db->GetRow($querySign);
                    
        //             $sign = $ressign['fsignpath'];

//             $signpath = "https://college.universitysolutions.in/".$resunishort['ffolder']."/img/".$sign;

// if($sign!==NULL){
 // $message .= "<img src='{$signpath}' width='100' height='50'/>";
 // $message .= " ";
 // }
 // $message.="Controller of Examinations "."$univname"." 
 // Navi Mumbai
 // ";

// $message.="</body>";
 // $message.="</html>";
 // }
 // //Semester End Examination
 // $subject= strtoupper("$univname".": Appointment as Question Paper Setter for the University ".$fexamdate.""); 
 // $from = "";
 
 // $resp = sendGridMail($emailid,$subject,$message,$univcode); 
 
 // $qrySlt = "select fmobileno, fusertype from logisys3_comexam.masuser where fmobileno='{$mobile}'";
 // $resQrySlt = $aobj_context->mobj_db->GetRow($qrySlt);

//     $uType = $resQrySlt['fusertype'];
        //     $split = explode("*", $uType);
        //     foreach($split as $val){
        //         if($val!==""){
        //             $userType = $val."*";
        //         }
        //     }

//     if(count($resQrySlt)>0){
        //         if(strpos($uType, '600')===false){
        //             $qry = "update logisys3_comexam.masuser set fusertype=concat('$userType', '600') 
        //                     where funivcode='{$univcode}' and fmobileno='{$mobile}'";
        //             $resQry = $aobj_context->mobj_db->GetRow($qry);
        //         }
        //     }
        //     }

// }
        
        // if (!$resp) {
        //     $arr['msg'] = 'Updation Failed';
        //     echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
        //     return;
        // }else
        // {
        //     $arr['msg'] = 'Updated Success';
        //     echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"Udated Success"); 
        // }
    }

$query = "select q.fqpcode ,concat(s.fsubshort,'-',s.fsubname, ' [',q.fqpcode,']')as 					  fsubname from qpseter q inner join subject s 
                  on s.fqpcode = q.fqpcode inner join degree d 
                  on d.fdegree = s.fdegree and d.fexamno = s.fexamno 
                  where fdeggrp = '{$deggrp}' $cnd group by q.fqpcode";
        $result = $aobj_context->mobj_db->GetAll($query);

if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
        }else{
            $arr['msg'] = "No qp data found";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
            return;
        }
    }
?>

${this.title}

Code Editor : selectqpsetter.php