Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
Tickets.php	7.03 KB	-rw-rw-r--
attendance.php	3.07 KB	-rwxr-xr-x
commandb.php	412 B	-rwxr-xr-x
database.php	476 B	-rwxr-xr-x
examapp.php	3.19 KB	-rwxr-xr-x
examapp_iframe.php	1.1 KB	-rwxr-xr-x
examtimetable.php	2.85 KB	-rwxr-xr-x
hallticket.php	3.1 KB	-rwxr-xr-x
helpDesk.php	1.12 KB	-rwxr-xr-x
iamarks.php	3.12 KB	-rwxr-xr-x
login.php	703 B	-rwxr-xr-x
logout.php	212 B	-rwxr-xr-x
practicaltimetable.php	3.21 KB	-rwxr-xr-x
profile.php	2.19 KB	-rwxr-xr-x
results.php	1.58 KB	-rwxr-xr-x

Code Editor : Tickets.php

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

function loaduniversities($aobj_context){
    $univcode = $aobj_context->mobj_data["univcode"];
 
    $query = "select funivcode,funivname from logisys3_comexam.dbname where fdeleted='F'";

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

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

function raiseTicket($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    include("error_log.php");
    $univcode = $aobj_context->mobj_data["univcode"];
    $userid = $aobj_context->mobj_data["userid"];
    $collcode = $aobj_context->mobj_data["collcode"];
    $usertype = $aobj_context->mobj_data["usertype"];
    $client = $aobj_context->mobj_data["client"];
    $slno = $aobj_context->mobj_data["slno"];
    $module = $aobj_context->mobj_data["module"];
    $priority = $aobj_context->mobj_data["priority"];
    $option = $aobj_context->mobj_data["option"];
    $subject = $aobj_context->mobj_data["subject"];
    $remarks = $aobj_context->mobj_data["remarks"];
    $ticketfile = $_FILES['file']['name'];
    $fileExt = pathinfo($ticketfile, PATHINFO_EXTENSION);
    $tempfile=$_FILES['file']['tmp_name'];

if($slno==""){
        $query = "INSERT INTO logisys3_comexam.tickets 
                (FCLIENT, FMODULE, FPRIORITY, FOPTIONTYP, FSUBJECT, FREMARKS, FUPDUSER, FUPDDATE, FDELETED) 
                VALUES 
                ('{$client}', '{$module}', '{$priority}', '{$option}', '{$subject}', '{$remarks}', '{$userid}', 
                NOW(), 'F')";

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

}else{ 
        $query = "UPDATE logisys3_comexam.tickets 
                SET FMODULE = '{$module}',
                    FCLIENT = '{$client}', 
                    FPRIORITY = '{$priority}', 
                    FOPTIONTYP = '{$option}', 
                    FSUBJECT = '{$subject}', 
                    FREMARKS = '{$remarks}', 
                    FUPDUSER = '{$userid}', 
                    FUPDDATE = NOW() 
                WHERE FSLNO = '{$slno}'";

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

}

$last_inserted_id = $aobj_context->pobj_db->Insert_ID();

if(file_exists($tempfile)){
        $s3 = S3Client::factory(
        array(
            'credentials' => array(
                'key' => IAM_KEY,
                'secret' => IAM_SECRET
            ),
            'version' => "latest",
            'region'  => 'ap-south-1'
        ));
    
        try {

if($slno==""){
            $filename=$last_inserted_id.".".$fileExt;

}else{
                $filename=$slno.".".$fileExt;
            }
            $folder =$univcode."/correction_doc/".$filename;

$s3->putObject(['Bucket' => "correction-document", 'Key' => $folder, 'SourceFile' => $tempfile]);
            if($slno==""){
                $slnocond="fslno='{$last_inserted_id}' and";
            }else{
                $slnocond="fslno='{$slno}' and";
            }

$upload="update logisys3_comexam.tickets set FUPLOADS='{$folder}' where $slnocond FCLIENT='{$client}'";

$uploadresult = $aobj_context->pobj_db->Execute($upload);
               
        }catch(S3Exception $e) {
            $arr['msg'] = 'Failed to upload';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
            return;
        }
    }
    if($result){
        $arr['msg'] = "Tikcet Raised";
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success");
        return;
    }else{
        $arr['msg'] = 'Failed to Raise Ticket';
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure"); 
        return;
    }
}

function loadtickets($aobj_context){
    $univcode = $aobj_context->mobj_data["univcode"];
    $userid = $aobj_context->mobj_data["userid"];
    $collcode = $aobj_context->mobj_data["collcode"];
    $usertype = $aobj_context->mobj_data["usertype"];
    $type = $aobj_context->mobj_data["type"];

if($type=="view"){
        $typecond="IFNULL(FASSINGDUSER, 'Not Assigned') AS FASSINGDUSER,
        IFNULL(DATE_FORMAT(FASSINGDDATE, '%d/%m/%Y'), 'Not Assigned') AS FASSINGDDATE,";
    }else{
        $typecond="FASSINGDUSER,FASSINGDDATE,";
    }
    $query = "select FSLNO,DATE_FORMAT(FUPDDATE, '%d/%m/%Y') AS FUPDDATE,FCLIENT,db.funivname,
                FMODULE,FPRIORITY,FOPTIONTYP,FSUBJECT,FREMARKS,FUPLOADS,
                $typecond
                IFNULL(FSTATUS, 'Not Assigned') AS FSTATUS  
                from logisys3_comexam.tickets t inner join logisys3_comexam.dbname db 
                on db.funivcode=t.fclient where t.fdeleted='F' and t.FUPDUSER='{$userid}'";
                
    $result = $aobj_context->pobj_db->GetAll($query);

$queryempl = "select femplcode,femplname from logisys3_oums.masempl where fdeptcode='unc' and fdeleted='F' and femplstat='T'";
  
    $resulempl = $aobj_context->pobj_db->GetAll($queryempl);

if($result){
        if($type=="view"){
            $arr['tickets'] = $result;
        }else{
            $arr['employe'] = $resulempl;
            $arr['tickets'] = $result;
        }
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
        return;
    }else
        $arr['msg'] = "Tickets data found";
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
        return;
    }

// function loademploye($aobj_context){
    //     $univcode = $aobj_context->mobj_data["univcode"];
     
        
    //     if($result){
    //         echo $aobj_context->mobj_output->ToJSONEnvelope($result, 0, "success");
    //         return;
    //     }else{
    //         $arr['msg'] = "Tickets data found";
    //         echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
    //         return;
    //     }
    // }

${this.title}

Code Editor : Tickets.php