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

<?php
    function getAvailableQp($aobj_context){
        $db = $aobj_context->mobj_data["db"];
        $data = json_decode($aobj_context->mobj_data["data"], true);
        $deggrp = $data['deggrp'];
        $board = $data['board'];

$data['sem'] === "All" ? $sem = "" : $sem = "and s.fexamno='{$data['sem']}'";
        $data['degree'] === "All" ? $degree = "" : $degree = "and s.fdegree='{$data['degree']}'";
        $data['qpcode'] === "All" ? $qpcode = "" : $qpcode = "and s.fqpcode='{$data['qpcode']}'";
        $data['avl'] === "" || $data['avl'] === NULL ? $avilQPLess = "" : $avilQPLess = "having available < '{$data['avl']}'";

if($db === 'reva'){
           $cnd = "and ifnull(fmodqpupd, '')<>''";
        }else{
            $cnd = "";
        }

$query = "select s.fdegree, s.fexamno, s.fqpcode, 
                  concat(s.fsubshort,' - ',s.fsubname, ' [',s.fqpcode, ']') as fsubname,                 
                  ifnull(q.fset, '0') as fset, 
                  ifnull(q.available, '0')as available, 
                  ifnull(q.used, '0')as used,
                  s.fsubshort,s.FELIGQP 
                  from subject s 
                  inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
                  inner join deggrp dg on dg.fdeggrp = d.fdeggrp
                  left join (select fqpcode,count(fset) as fset, 
                  sum(case when ifnull(FFINALPAPER, '') = '' then 1 else 0 end) as available,
                  sum(case when ifnull(FFINALPAPER, '') = 'T' then 1 else 0 end) as used
                  from qpseterdet where ifnull(fqpfilepath,'') <> '' {$cnd}
                  group by fqpcode) q on s.fqpcode = q.fqpcode 
                  where ifnull(s.fdeleted, '') <> 'T'
                  and dg.fdeggrp='{$deggrp}' {$sem} {$degree} {$qpcode}
                  and ifnull(s.fqpcode,'') <> ''
                  group by s.fqpcode 
                  {$avilQPLess}";

//   var_dump($query);die();

// $query = "select s.fdegree, s.fexamno, s.fdeggrp, q.fqpcode,
        //         count(q.fset) as fset, 
        //         concat(s.fsubshort,' - ',s.fsubname) as fsubname, 
        //         sum(case when ifnull(q.FFINALPAPER, '') = '' then 1 else 0 end)as available, 
        //         sum(case when ifnull(q.FFINALPAPER, '') = 'T' then 1 else 0 end)as used,
        //         s.fsubshort,s.FELIGQP
        //         from qpseterdet q inner join (select distinct s.fdegree, s.fexamno, s.fqpcode, s.fsubname, 
        //         s.fsubshort, dg.fdeggrp,ifnull(s.FELIGQP,'F')as FELIGQP from subject s 
        //         inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
        //         inner join deggrp dg on dg.fdeggrp = d.fdeggrp		
        //         where ifnull(fqpcode,'') <> '' 
        //         {$degree} and dg.fdeggrp='{$deggrp}' {$sem}
        //         group by fqpcode) s on s.fqpcode = q.fqpcode 
        //         where ifnull(fqpfilepath, '')<>'' {$qpcode}  and ifnull(fdeleted, '') <> 'T'
        //         group by fqpcode {$avilQPLess}";

$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");
            return;
        }

}

function viewDetailedAvailableQp($aobj_context){
        $univcode = $aobj_context->mobj_data["univcode"];
        $data = json_decode($aobj_context->mobj_data["data"], true);
        $fdeggrp = $data['fdeggrp'];
        $fdegree = $data['fdegree'];
        $fexamno = $data['fexamno'];
        $fqpcode = $data['fqpcode'];

$query = "select  s.fdegree, s.fdeggrp, s.fexamno, q.fteachcode, m.fteachname, concat(s.fsubshort,' - ',s.fsubname, ' [',s.fqpcode, ']') as fsubname, 
                  s.fsubshort, q.fqpcode, fset, fyear, fexamtype,
                  concat(fyear,' / ',fexamtype) fyears,
                  if(ifnull(q.fqpfilepath, '')<>'', 'Yes', 'No')as fqpupdstatus,
                  date_format(q.fqpdtme, '%d/%m/%Y %h:%m:%s')as fqpdtme,
                  if(ifnull(q.fmodqpupd, '') <> '', 'Yes', 'No')as fmodstatus,
                  date_format(q.fmodqpdate, '%d/%m/%Y %h:%m:%s')as fmodtme,
                  if(ifnull(q.ffinalpaper, '') = 'T', 'Used', '')as used,
                  date_format(q.ffinalpaperdate, '%d/%m/%Y %h:%m:%s')as ffinalpaperdate,
                  ifnull(q.fteachcode,'') as fteachcode
                  from qpseterdet q
                  inner join (
                  select distinct s.fdegree, s.fexamno, s.fqpcode, s.fsubname, s.fsubshort, dg.fdeggrp from subject s 
                  inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
                  inner join deggrp dg on dg.fdeggrp = d.fdeggrp		
                  where ifnull(fqpcode,'') <> '' 
                  and s.fdegree='{$fdegree}' and dg.fdeggrp='{$fdeggrp}' and s.fexamno='{$fexamno}'
                  group by fqpcode)s on s.fqpcode = q.fqpcode 
                  inner join masteach m on m.fteachcode = q.fteachcode
                  where ifnull(fqpfilepath, '')<>'' and q.fqpcode='{$fqpcode}'
                  and ifnull(q.fdeleted, '') <> 'T'";

$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");
            return;
        }

}

$query = "select s.fqpcode, 
                  concat(group_concat(distinct s.fsubshort),' - ',s.fsubname, ' - ',s.fssubname, ' [',s.fqpcode, ']') as fsubname
                  from subject s 
                  inner join degree d on d.fdegree = s.fdegree and d.fexamno = s.fexamno
                  inner join deggrp dg on dg.fdeggrp = d.fdeggrp
                  left join (select fqpcode,count(fset) as fset, 
                  sum(case when ifnull(FFINALPAPER, '') = '' then 1 else 0 end) as available,
                  sum(case when ifnull(FFINALPAPER, '') = 'T' then 1 else 0 end) as used
                  from qpseterdet where ifnull(fqpfilepath,'') <> ''
                  group by fqpcode) q on s.fqpcode = q.fqpcode 
                  where ifnull(s.fdeleted, '') <> 'T'
                  and dg.fdeggrp='{$deggrp}' {$cnd}
                  and ifnull(s.fqpcode,'') <> ''
                  group by s.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 : availableqp.php