Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
phpmailer	[ DIR ]	drwxrwxrwx
.htaccess	602 B	-rwxr-xr-x
ApplicationReport.php	11.81 KB	-rwxrwxrwx
CreateUser.php	5.23 KB	-rwxrwxrwx
appForm.php	23.31 KB	-rwxrwxrwx
applicationFormReportPOSTOFFIC...	19.32 KB	-rwxrwxrwx
applicationStatus.php	6.84 KB	-rwxrwxrwx
applicationStatus_31012018.php	2.94 KB	-rwxrwxrwx
cManualMailer.php	1.52 KB	-rwxrwxrwx
caccesscontext.php	1.24 KB	-rwxrwxrwx
candidate_list.php	54.71 KB	-rwxrwxrwx
cappcontext.php	2.66 KB	-rwxrwxrwx
ceckFile.php	1.12 KB	-rwxrwxrwx
cmailer.php	6.83 KB	-rwxrwxrwx
code39.php	6.38 KB	-rwxrwxrwx
coutput.php	1.76 KB	-rwxrwxrwx
crequestbroker.php	2.49 KB	-rwxrwxrwx
csessions.php	514 B	-rwxrwxrwx
cuser.php	3.41 KB	-rwxrwxrwx
customappcontext.php	2.35 KB	-rwxrwxrwx
download.php	5.65 KB	-rwxrwxrwx
dropdown.php	844 B	-rwxrwxrwx
everifyMc.php	6.36 KB	-rwxrwxrwx
feehead.php	1.51 KB	-rwxrwxrwx
format.php	7.43 KB	-rwxrwxrwx
fpdf_protection.php	5.61 KB	-rwxrwxrwx
getdata.php	1.06 KB	-rwxrwxrwx
getnumword.php	7.15 KB	-rwxrwxrwx
home.html	14.48 KB	-rwxrwxrwx
json.php	33.2 KB	-rwxrwxrwx
login.php	1.88 KB	-rwxrwxrwx
mc-verify.php	6.65 KB	-rwxrwxrwx
mregistry.php	4.55 KB	-rwxrwxrwx
mregistry_31012018.php	2.65 KB	-rwxrwxrwx
report_appstatus.php	6.42 KB	-rwxrwxrwx
report_verificationlist.php	4.99 KB	-rwxrwxrwx
reportapplicationform.php	19.59 KB	-rwxrwxrwx
reportapplicationform_old.php	28 KB	-rwxrwxrwx
rotation.php	596 B	-rwxrwxrwx
sendGridMail.php	1.29 KB	-rwxrwxrwx
servfee.php	1.38 KB	-rwxrwxrwx
servicedet.php	1.6 KB	-rwxrwxrwx
stringspliter.php	693 B	-rwxrwxrwx
student.php	25.37 KB	-rwxrwxrwx
verifiedlistReport.php	7 KB	-rwxrwxrwx

Code Editor : appForm.php

<?php

function getStudentDetl($aobj_context)
{  
    
    $appno = trim($aobj_context->mobj_data['appno']);
    include('ceckFile.php');

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
	$query = "SELECT st.fappno, DATE_FORMAT(fappdate,'%d/%m/%Y') AS fappdate, st.fregno, fname, 
    fdegree, c.fcollname, fcategory, ftotal, fpaystatus, s.fservname, 
    DATE_FORMAT(fdob,'%d/%m/%Y') AS fdob, st.fmobile, st.femail, faddr1, faddr2, faddr3, faddr4, 
    fverifystatus, fverifyremarks,control.fsunivcode 
    FROM control, servtran st 
	INNER JOIN servtype s ON s.fservcode =  st.fservcode 
	INNER JOIN college c on st.fcollcode = c.fcollcode
    WHERE  st.fappno='{$appno}'";

$result = $aobj_context->mobj_db->GetRow($query);  //Runs the query provided and puts the first row of data into an array then frees the result set.
    //$result = $results[0];
    //$html .="<div><h1>Hello...</h1>";
    $FUNIVCODE = $result['fsunivcode'];
	$html .="<div class='row'>
    <div class='col-lg-12 col-md-12 col-sm-12 col-xs-12  m-b--50'>
        <div class='card'>
            <div class='header1 bg-cyan'>
                <h2>
                    Application Form
                </h2>
            </div>
            
            <div class='body'>														
            <form class='form-horizontal'>
                <div style='margin-left:-10px;'>
                	<div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                        <label class='pull-left'  for='Application Number'>App. No.</label>
                    </div>
                    <div class='col-sm-4 col-md-2' style='margin-right: 100px;'>
                        <div class='form-group'>
                            <div class='form-line'>
                            	<input  id='appno1' type='text' value='{$result['fappno']}' class='form-control' disabled>
                            </div>            
                        </div>                   
                    </div>                   
                </div>                        
                <div class='row clearfix'>
                        <div class='col-md-offset-2 col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left' for='App. Date'>App. Date</label>
                        </div>
                        <div class='col-sm-4 col-md-2'>
                            <div class='form-group'>
                                <div class='form-line'>
                                    <input type='text' class='form-control' id='date' value='{$result['fappdate']}' disabled>
                                </div>
                            </div>
                        </div>
                    </div>
                        <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left m-l--10' for='Candidate Name'>Candidate Name</label>
                        </div>
                        <div class='col-sm-4 col-md-4'>
                            <div class='form-group'>
                                <div class='form-line m-l--10'>
                                    <input type='text' class='form-control' id='fname' value='{$result['fname']}' disabled>
                                </div>
                            </div>
                        </div>
                    	
                   
                    <div class='row clearfix'>
                        <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left' for='Register Number'>Register Number</label>
                        </div>
                        <div class='col-sm-4 col-md-2'>
                            <div class='form-group'>
                                <div class='form-line'>
                                    <input type='text' class='form-control' id='regno' value='{$result['fregno']}' disabled>
                                </div>
                            </div>
                        </div>
                    </div>
                   
	                   <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left m-l--10' for='college'>College </label>
                        </div>
                        <div class='col-sm-4 col-md-4'>
                            <div class='form-group'>
                                <div class='form-line m-l--10'>
                                    <input type='text' class='form-control' id='college' value='{$result['fcollname']}' disabled>
                                </div>
                            </div>
                        </div>
                    	
                
                    <div class='row clearfix'>
                        <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left' for='Category'>Category </label>
                        </div>
                        <div class='col-sm-4 col-md-2'>
                            <div class='form-group'>
                                <div class='form-line'>
                                    <input type='text' class='form-control ' id='category' value='{$result['fcategory']}' disabled>
                                </div>
                            </div>
                        </div>
                    </div>
                        <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left m-l--10' for='Degree'>Degree </label>
                        </div>
                        <div class='col-sm-4 col-md-4'>
                            <div class='form-group'>
                                <div class='form-line m-l--10'>
                                    <input type='text' class='form-control' id='degree' value='{$result['fdegree']}' disabled>
                                </div>
                            </div>
                        </div>
                
                     <div class='row clearfix'>
                        <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                            <label class='pull-left' for='Date of Birth'> Date of Birth</label>
                        </div>
                        <div class='col-sm-4 col-md-2'>
                            <div class='form-group'>
                                <div class='form-line'>
                                    <input type='text' class='form-control' id='dob' value='{$result['fdob']}' disabled>
                                </div>
                            </div>
                        </div>
                    </div>

<div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                        <label class='pull-left m-l--15' for='Postal Address'>Postal Address  </label>
                    </div>
                    <div class='col-sm-4 col-md-4'>
                        <div class='form-group'>
                            <div class='form-line m-l--10 m-b-5'>
                                <input type='text' class='form-control' id='postal1' value='{$result['faddr1']}' disabled>
                            </div>
                        </div>
                        <div class='form-group'>
                            <div class='form-line m-l--10 m-b-5'>
                                <input type='text' class='form-control' id='postal2' value='{$result['faddr2']}' disabled>
                            </div>
                        </div>
                        <div class='form-group'>
                            <div class='form-line m-l--10 m-b-5'>
                                <input type='text' class='form-control' id='postal3' value='{$result['faddr3']}' disabled>
                            </div>
                        </div>
                        <div class='form-group'>
                            <div class='form-line m-l--10 m-b-5'>
                                <input type='text' class='form-control' id='postal4' value='{$result['faddr4']}' disabled>
                            </div>
                        </div>
                    </div>

<div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label' style='margin-right: 5px;'>
                        <label class='pull-left' for='Mobile No.'> Mobile No.</label>
                    </div>
                    <div class='col-sm-4 col-md-2'>
                        <div class='form-group'>
                            <div class='form-line'>
                                <input type='text' class='form-control' id='mobile' value='{$result['fmobile']}' disabled>
                            </div>
                        </div>
                    </div>

<div class='col-sm-4 col-md-8'>
                        
                    </div>
                    <div class='col-sm-4 col-md-3'>
                        <div class='form-group'>
                            <div class='form-line'>                        
                            </div>
                        </div>
                    </div>
                               
                    <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                        <label class='pull-left m-l--15' for='Email Id'> Email Id </label>
                    </div>
                    <div class='col-sm-4 col-md-4' style='margin-right: 250px;'>
                        <div class='form-group'>
                            <div class='form-line m-l--10 m-b-5'>
                                <input type='text' class='form-control' id='email' value='{$result['femail']}' disabled>
                            </div>
                        </div>
                    </div>

<div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label'>
                    <label class='pull-left m-l--15' for=' Applicationfor'> Application for</label>
                </div>
                <div class='col-sm-4 col-md-4' style='margin-right: 250px;'>
                    <div class='form-group'>
                        <div class='form-line m-l--10 m-b-5'>
                        	<input type='text' class='form-control' id=' applicationfor' value='{$result['fservname']}' disabled>
                        </div>
                    </div>
                </div>
                   
                <div class='row clearfix'>
                    <div class='col-lg-2 col-md-2 col-sm-4 col-xs-5 form-control-label' style='margin-right: 5px;'>
                        <label class='pull-left' for='amount'>Total amount  </label>
                    </div>
                    <div class='col-sm-4 col-md-2'>
                        <div class='form-group'>
                            <div class='form-line m-l--5'>
                            	<input type='text' class='form-control' id='amount' value='{$result['ftotal']}' disabled>
                            </div>
                        </div>
                    </div>
                </div>";

$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); 
    $query = "SELECT ifnull(fverifystatus,'') as fverifystatus,fsem, fregno,fpath,fappno
    FROM servdoc sd 
    WHERE fappno='{$appno}'";
    $result1 = $aobj_context->mobj_db->GetAll($query); //Runs the query provided and puts the entire result set into a nested array then frees the result set.

if($result1)
    {
        $i=1;
        $z=0;
        $html .="<div class='header'>
                <h4 class='m-t--10 m-b--10'>
                Documents Uploaded Details
                </h4>
            </div>
        <div class='row'><div class='col-md-12'><table id='mainTable' class='table table-striped table-condensed table-bordered'>
                        <thead>
                            <tr class='bg-cyan' style = 'text-align:center'>
                                <th style = 'text-align:center'>Sl.<br>No.</th>
                                <th style = 'text-align:center'>Document<br></th>
                                <th style = 'text-align:center'>Upload by <br>Candidate</th>
                                <th style = 'text-align:center'>University <br>Document</th>
                                <th style = 'text-align:center'>View Both</th>
                                <th style = 'text-align:center'>verification <br> (caseworker)</th>";
                                if($_SESSION['usertype'] == 'adm')
                                    $html .="<th style = 'text-align:center'>Verified by <br>Reg. Eva.</th>";
                                $html .="</tr>
                        </thead>
                        <tbody>";
         $semarr = "";
        foreach($result1 as $key => $value)
        {
            //MC_003_901A0006_C_2016_1.pdf
            $res = checkDocument("{$FUNIVCODE}","{$value['fregno']}","{$value['fsem']}");
            // var_dump($res);
            $sem = array("A"=>"I SEMESTER / YEAR", "B"=>"II SEMESTER / YEAR", "C"=>"III SEMESTER / YEAR", "D"=>"IV SEMESTER / YEAR", "E"=>"V SEMESTER / YEAR", "F"=>"VI SEMESTER / YEAR", "Degree Certificate"=>"Degree Certificate");
            $html .="<tr>";
            
            $html .="<td>
                    <span><center>{$i}</center></span>
                    </td>";
            $html .="<td>
                    {$sem[$value['fsem']]}
                    </td>";
            $html .="<td>
            <center><a href = 'https://university-marks-cards.s3.ap-south-1.amazonaws.com/{$FUNIVCODE}/stud_upd/{$value['fpath']}' target='_blank'>Click Here</a></center>
                    </td>";
            $uni_url = "https://kuvempu-university-marks-card-verification.s3.ap-south-1.amazonaws.com/".$res[0];
            $stud_url = "https://university-marks-cards.s3.ap-south-1.amazonaws.com/{$FUNIVCODE}/stud_upd/{$value['fpath']}";
            if($res)
            {            
                $html .="<td>
                <center><a href = '{$uni_url}' target = '_blank' >Click Here</a></center>
                    </td>";
                $semarr .=$value['fsem']."*";
            }else
            {
                $z++;
                $html .="<td>
                No Details Found
                    </td>";
            }     
            $finurl = "http://universitysolutions.in/ibm/displayMarksCards.php?org_url={$uni_url}&upload_url={$stud_url}";
            
            $html .="<td>
            <center><a href = '{$finurl}' target = '_blank' >Click Here</a></center>
            </td>";

$cnd = "";
            if($_SESSION['usertype'] == 'adm')
            {
                $cnd = "disabled"; 
            }
            $Verified=($value['fverifystatus']=="Verified") ? "selected" : "";
            $pending=($value['fverifystatus']=="pending") ? "selected" : "";
            $html .="<td>
                <input type = 'hidden' id = 'sem_{$i}' value = '{$value['fsem']}'>
                <select $cnd id='status_$i' class='form-control show-tick'>
                <option value=''>-select-</option>
                <option value='Verified' {$Verified} >verified and found correct</option>
                <option value='pending' {$pending} >Document Not Found Correct</option>
                
            </td>";
            if($_SESSION['usertype'] == 'adm')
            {
                $html .="<td>
                <center><input type='checkbox' class='custom-control-input' id='re_{$i}' name='example1'>
                    <label class='custom-control-label' for='re_{$i}'></label></center>
                </td>";   
            }        
            $html .="</tr>";
            $i++;
        }
        $html .= "</tbody></table> 
        <input type = 'hidden' id = 'semarr' value = '{$semarr}'>
        <input type = 'hidden' id = 'semcnt' value = '{$z}'>
        <input type = 'hidden' id = 'univcode' value = '{$FUNIVCODE}'>
        </div></div>";
    }
                   
    $html .= "<div class=' form-control-label'>";
    if($_SESSION['usertype'] == 'adm')
    {
        $html .= "<div class='row clearfix'style='display: flex;'>
        <center>
        <div class=''>
        <label class='pull-left' for='status'>Update Status</label>
        <select id='status1' class='form-control show-tick' '>
                <option value=''>-select-</option>
                <option value='pending'>Pending</option>
                <option value='Verified'>Verified and Send Mail</option>
            </select>
        </div>
        </center>";
    }
                $html .= "
                <input type = 'hidden' id = 'totmc' value = '{$i}'>
                                <input type = 'hidden' id = 'userlog' value = '{$_SESSION['usertype']}'>
                                </div>                
                <div class='row'>
                    <center>
                        <div class=''>
                        <button type='button' class='btn btn-primary' onclick='saveChanges()'>Save</button>
                        </div>
                    </center>
                </div>

</div>
                </form>
            </div>
        </div>
    </div>
    </div>";

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

function saveVerificationDetails($aobj_context)
{
    include("sendGridMail.php");
    include('ceckFile.php');
    if(!isset($_SESSION['username'])) {
        $arr = 'Session Expired Login again';
        echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
    }
    $appno = trim($aobj_context->mobj_data['appno']);
    $remarks = trim($aobj_context->mobj_data['remarks']);
    $status = trim($aobj_context->mobj_data['status']);
    $email = trim($aobj_context->mobj_data['email']);
    $regno = trim($aobj_context->mobj_data['regno']);
    $semcnt = trim($aobj_context->mobj_data['semcnt']);
    $statusarr = trim($aobj_context->mobj_data['statusarr']);
    $userlog = trim($aobj_context->mobj_data['userlog']);
    
    $db = trim($aobj_context->mobj_data['db']);
    $db_arr = array("kus" => "logisys3_kus", "kusdde" => "logisys3_kusd");
    if($db == 'kus')
        $univcode = '003';

if($db == 'kusdde')
        $univcode = '003D';

$semarr = explode('*',$semarr);
    
    $user = $_SESSION['username'];
    if($userlog == 'adm')
    {
        $update_status = "update servtran set fverifyuser = '{$user}', 
        fverifystatus = '{$status}', fverifyremarks = '$remarks', 
        fverifydate = NOW() where fappno = '{$appno}'";
        //var_dump($update_status);
        $result = $aobj_context->mobj_db->Execute($update_status);
        if($result)
        {
            if($status == 'Verified')
            {
                $sem = array("A"=>"I SEMESTER", "B"=>"II SEMESTER", "C"=>"III SEMESTER", "D"=>"IV SEMESTER", "E"=>"V SEMESTER", "F"=>"VI SEMESTER", "Degree Certificate"=>"Degree Certificate");

$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.="<p style='font-size:12px; font-family: Verdana, Arial, Helvetica, sans-serif'>Dear Candidate,</p></br>
                <p>The documents submitted by you for genuineness verification are verified 
                and found to be GENUINE as per the records of the University. 
                For any further clarification please contact office of the Registrar (Evaluation), 
                Kuvempu University. </p><br>
                ";
                
                $message.="<table style='width:70%;border: 1px solid black;border-collapse: collapse'>";
                $message.="<tr style = 'border: 1px solid black;'>
                <th style = 'border: 1px solid black;'>Sl. No.</th>
                <th style = 'border: 1px solid black;'>Semester</th>
                <th style = 'border: 1px solid black;'>Download</th>
                </tr>";
                $i = 1;
                $query = "select fsem,fpath, fregno from servdoc where fappno = '{$appno}'";
                $result = $aobj_context->mobj_db->Execute($query);
                foreach($result as $vale)
                {
                    
                    $fpath = $vale['fpath'];
                    $semcode = $vale['fsem'];
                        $message.="<tr>
                        <td style = 'text-align:center;border: 1px solid black;'>
                            $i
                        </td>
                        <td style = 'border: 1px solid black;'>
                        $sem[$semcode]
                        </td>";
                        $res = checkDocument("{$univcode}","{$vale['fregno']}","{$vale['fsem']}");
                        
                        $message.="<td style = 'border: 1px solid black;'> <a href = 'https://universitysolutions.in/ibm/app.php?a=everifyUserDoc&filenm=$fpath&univcode=$univcode&appno=$appno&sem=$semcode&db=$db' target='_blank'>Click Here</a></td></br>";
                        // if($res) {
                        //     $message.="<td style = 'border: 1px solid black;'> <a href = 'https://universitysolutions.in/ibm/app.php?a=everifyMC&fregno=$regno&sem=$semcode&univcode=$univcode&appno=$appno&db=$db' target='_blank'>Click Here</a></td></br>";
                        // }
                        // else {
                        //     $message.="<td style = 'border: 1px solid black;'> <a href = 'https://universitysolutions.in/ibm/app.php?a=everifyUserDoc&filenm=$fpath&univcode=$univcode&appno=$appno&sem=$semcode&db=$db' target='_blank'>Click Here</a></td></br>";        
                        // }
                        $i++; 
                        $message.="<tr>";  
                    
                }
                  
                $message.="</table>";
                $message.="</br>";			
                $message.="</body>";
                $message.="</html>";
                $subject="KUSUNI - Genuineness Verification";
                
                $res = sendGridMail($email, $subject, $message);
            }
            $arr = '';
            echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success");  
            return;
        }
        else
        {
            $arr = '';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
        }

}else
    {
        $semarr = explode('*',$statusarr);
        
        foreach($semarr as $vale)
        {
            
            $fsemarr = explode('_',$vale);

if($fsemarr[0] != "")
            {
                $upd = "update servdoc set  fverifystatus = '{$fsemarr[1]}',
                fverifiedby = '{$user}', fverifieddate = now()
                where fappno = '{$appno}' 
                and fsem = '{$fsemarr[0]}'";
                
                $result = $aobj_context->mobj_db->Execute($upd);
                
            }    
        }
        if($result)
        {
            if($result)
            {
                $arr = '';
                echo $aobj_context->mobj_output->ToJSONEnvelope($res,0,"success");  
                return;
            }
            else
            {
                $arr = '';
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure"); 
            } 
        }
    }
    
}

${this.title}

Code Editor : appForm.php