Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
acceptqp.php	4.45 KB	-rw-rw-r--
addqptrancenter.php	2.13 KB	-rw-rw-r--
assignUserMenu.php	12.78 KB	-rw-rw-r--
assignmod.php	37.61 KB	-rw-rw-r--
availableqp.php	7.95 KB	-rw-rw-r--
changePwd.php	8.62 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	21.27 KB	-rw-r--r--
getTeacherlists.php	954 B	-rw-rw-r--
guidelines.php	578 B	-rw-rw-r--
login.php	19.3 KB	-rw-rw-r--
mapTeachersQbms.php	3.88 KB	-rw-rw-r--
modupdqp.php	17.15 KB	-rw-rw-r--
prepareQpNew.php	19.1 KB	-rw-rw-r--
preparethqp.php	30.91 KB	-rw-rw-r--
qpbankdet.php	1.47 KB	-rw-rw-r--
qpdaylog.php	433 B	-rw-rw-r--
qpfootnote.php	4.61 KB	-rw-rw-r--
qplog.php	938 B	-rw-rw-r--
qpmodreport.php	6.23 KB	-rw-rw-r--
qpsummary.php	6.9 KB	-rw-rw-r--
qptran.php	24.32 KB	-rw-rw-r--
registration.php	25.41 KB	-rw-rw-r--
saveAbstractForm.php	6.83 KB	-rw-rw-r--
select-final-qp.php	10.17 KB	-rw-rw-r--
selectqpsetter.php	59.35 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.83 KB	-rw-rw-r--
uploadPassword.php	805 B	-rw-rw-r--
uploadqp.php	10.22 KB	-rw-rw-r--
usertype.php	5.14 KB	-rw-rw-r--
viewQPScr.php	18.14 KB	-rw-r--r--
wordFile.php	1.32 KB	-rw-rw-r--

Code Editor : updqppattern.php

<?php
    require_once(_DIR_."/../../aws/aws-autoloader.php");
    use Aws\S3\S3Client;
    use Aws\S3\Exception\S3Exception;

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

function getQpDegree($aobj_context){
        $deggrp = $aobj_context->mobj_data['deggrp'];

if($deggrp === "All"){
            $deggrpcnd = "ifnull(fdeggrp, '') <> ''";
        }else{
            $deggrpcnd = "fdeggrp = '{$deggrp}'";
        }

$query="select ifnull(fdegree,'') as fdegree, concat(fdescpn, ' [', fdegree, ']') as fdescpn
        from degree 
        where {$deggrpcnd}
        group by fdegree";
        // var_dump($query);die();
        $result = $aobj_context->mobj_db->GetAll($query);

if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
        } else {
            $arr['msg']="Failed to load degree";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
        }
    }

function getUploadQpPatternDetails($aobj_context){
        $db = $aobj_context->mobj_data["db"];
        $board = $aobj_context->mobj_data["board"];
        $deggrp = $aobj_context->mobj_data["deggrp"];
        $qpcode = $aobj_context->mobj_data["qpcode"];
        $sem = $aobj_context->mobj_data["sem"];
        $status = $aobj_context->mobj_data["status"];

if($qpcode == "All"){
            $qpcnd = "";
        }else{
            $qpcnd = "and s.fqpcode = '{$qpcode}'";
        }

if($sem == "All"){
            $semcnd = "";
        }else{
            $semcnd = "and d.fexamno='{$sem}'";
        }

if($status === "pending"){
            $statuscnd = "and ifnull(s.FQPPATREN, '') = ''";
        }else if($status === "uploaded"){
             $statuscnd = "and (ifnull(s.FQPPATREN, '') <> ''
                           or ifnull(s.FSCHPATTERN, '') <> '' 
                           or ifnull(s.FQPSYLLABUS, '') <> '')";
        }else{
            $statuscnd = "";
        }

$query = "select distinct ifnull(fqpcode, '')as fqpcode, 
                  concat(s.fsubname, ' - ', s.fsubshort) as fsubname, 
                  ifnull(FSUBSHORT, '')as FSUBSHORT, 
                  ifnull(FQPPATREN, '')as FQPPATREN, 
                  ifnull(FQPSYLLABUS, '')as FQPSYLLABUS, 
                  ifnull(FSCHPATTERN, '')as FSCHPATTERN, 
                  fboard,ifnull(s.ftempcode,'')as ftempcode
                  from subject s inner join degree d on s.fdegree = d.fdegree and s.fexamno = d.fexamno
                  inner join deggrp dg on d.fdeggrp = dg.fdeggrp
                  where d.fdeggrp = '{$deggrp}'
                  and ifnull(s.fqpcode,'') <> ''
                {$qpcnd} {$semcnd} {$statuscnd}
                group by s.fqpcode";
                //   if($db ==='reva'){
                    // var_dump($query);die();
                //   }
        $result = $aobj_context->mobj_db->GetAll($query);
        
        
        $que = "select DISTINCT ftempcode from tdvs_qptemphead";
        $res = $aobj_context->mobj_db->GetAll($que);

if($result){
            $arr['data']= $result;
            $arr['temp'] = $res;
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
        }else{
            $arr['msg'] = 'Failed to get the data';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }

function uploadQpPattern($aobj_context){
        include("error_log.php");
        $data = json_decode($aobj_context->mobj_data["data"], true);
        $univcode = $aobj_context->mobj_data["univcode"];
        $userid = $aobj_context->mobj_data["userid"];
        $syllabusFile = $_FILES['syllabusFile'];
        $qpFile = $_FILES['qpFile'];
        $schemeFile = $_FILES['schemeFile'];

$date = date("Ymdhis");
        
        try {
            $s3 = S3Client::factory(
                array(
                    'credentials' => array(
                        'key' => IAM_KEY,
                        'secret' => IAM_SECRET
                    ),
                    'version' => "latest",
                    'region'  => 'ap-south-1'
            ));
            
            if($qpFile['tmp_name'] !== null){
                $qpfileExt = pathinfo($qpFile['name'], PATHINFO_EXTENSION);
                
                $key = $univcode.'/'.'pattern/'.$date.'_'.$data['fqpcode'].'_pattern'.'.'.$qpfileExt;
                $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $key, 'SourceFile' => $qpFile['tmp_name']]);

$query = "update subject set fqppatren='{$key}',
                          ftempcode='{$data['ftempcode']}',
                          fqpdate=now(), fuserid='{$userid}'
                          where fqpcode = '{$data['fqpcode']}'";

// var_dump($query);die();     
                $result = $aobj_context->mobj_db->Execute($query);
            }
            if($schemeFile['tmp_name'] !== null){
                $schemeFileExt = pathinfo($schemeFile['name'], PATHINFO_EXTENSION);
                $key = $univcode.'/'.'scheme/'.$date.'_'.$data['fqpcode'].'_scheme'.'.'.$schemeFileExt;;
                $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $key, 'SourceFile' => $schemeFile['tmp_name']]);

$query = "update subject set fschpattern='{$key}',
                          ftempcode='{$data['ftempcode']}',
                          fqpdate=now(), fuserid='{$userid}'
                          where fqpcode = '{$data['fqpcode']}'";

$result = $aobj_context->mobj_db->Execute($query);
            }
            if($syllabusFile['tmp_name'] !== null){
                $syllabusFileExt = pathinfo($syllabusFile['name'], PATHINFO_EXTENSION);
                $key = $univcode.'/'.'syllabus/'.$date.'_'.$data['fqpcode'].'_syllabus'.'.'.$syllabusFileExt;;
                $s3->putObject(['Bucket' => "qp-scheme", 'Key' => $key, 'SourceFile' => $syllabusFile['tmp_name']]);

$syllabusFileExt = pathinfo($syllabusFile['name'], PATHINFO_EXTENSION);
                $query = "update subject set fqpsyllabus='{$key}',
                          ftempcode='{$data['ftempcode']}',
                          fqpdate=now(), fuserid='{$userid}'
                          where fqpcode = '{$data['fqpcode']}'";

$result = $aobj_context->mobj_db->Execute($query);
            }

$query = "update subject set
                    ftempcode='{$data['ftempcode']}',
                    fqpdate=now(), fuserid='{$userid}'
                    where fqpcode = '{$data['fqpcode']}'";

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

// var_dump($query);die();
            if($result){
                $remarks = "uploaded qppattern and syllabus pattern file against qpcode ".$data['qpcode'];
                $res = error_logs($aobj_context, $univcode, $remarks, '', "Upload QP Pattern and Syllabus Pattern", $userid, $userid);

$arr['msg'] = 'File uploaded';
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "Success");
            }else{
                $arr['msg'] = 'Failed to upload';
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
                return;
            }
            
        } catch (S3Exception $e) {
            $arr['msg'] = 'Failed to upload';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
            return;
        }
    }

${this.title}

Code Editor : updqppattern.php