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

<?php 
function getQpTemplateDet($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data["univcode"];
    
    $query = "select ftempcode, ftempname, ftempdesc 
    from tdvs_qptemphead 
    where ifnull(fdeleted,'') <> 'T'
    group by ftempcode";

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

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

function deleteTemplateCode($aobj_context){
	$univcode = $aobj_context->mobj_data["univcode"];
	$tempcode = $aobj_context->mobj_data["tempcode"];

$sltQry = "select ftempcode from tdvs_masqp where ftempcode='{$tempcode}'";
	$res = $aobj_context->mobj_db->GetAll($sltQry);

if(count($res) === 0){
		$query = "delete from tdvs_qptempdetl where ftempcode='{$tempcode}'";
		$result = $aobj_context->mobj_db->Execute($query);

$query = "delete from tdvs_qptemphead where ftempcode='{$tempcode}'";
		$result = $aobj_context->mobj_db->Execute($query);
	}
	
	if($result){
		$arr['msg'] = 'Deleted Successfully';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success");
	} else {
		$arr['msg'] = 'Something Went wrong';
		echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure");
	}
}

function tempCodeDet($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data["univcode"];
	$ftempcode = $aobj_context->mobj_data["ftempcode"];
    
    $query = "select ifnull(ftempcode,'') as ftempcode,
    ifnull(ftempname,'') as ftempname,
    ifnull(ftempdesc,'') as ftempdesc,
    ifnull(ftempmax,'') as ftempmax,
    ifnull(ftotmandqn,'') as ftotmandqn,
    ifnull(fpartcode,'') as fpartcode,
    ifnull(fpartdesc,'') as fpartdesc,
    ifnull(fmaxqn,'') as fmaxqn,
    ifnull(fmandqn,'') as fmandqn,
    ifnull(fmaxmarks,'') as fmaxmarks,
    ifnull(fminqn,'') as fminqn
    from tdvs_qptemphead where ftempcode = '{$ftempcode}'";
    
    $result = $aobj_context->mobj_db->GetAll($query);

$que = "select ifnull(ftempcode, '') as ftempcode,
    ifnull(fpartcode, '') as fpartcode,
    ifnull(fqncode, '') as fqncode,
    ifnull(fqnno, '') as fqnno,
    ifnull(fqndesc, '') as fqndesc,
    ifnull(fqnlevel, '') as fqnlevel,
    ifnull(fqnparent, '') as fqnparent,
    ifnull(fmaxmarks, '') as fmaxmarks,
    ifnull(fsubqp, '') as fsubqp,
    ifnull(fsubmaxqn, '') as fsubmaxqn,
    ifnull(fsubmandqn, '') as fsubmandqn,
    ifnull(fqnord, '') as fqnord 
    from tdvs_qptempdetl where ftempcode = '{$ftempcode}'
    order by fqnord";
    
    $res = $aobj_context->mobj_db->GetAll($que);
    
    $sumarr = array_map('transform', $result);

$arr["ftempcode"] = $result[0]['ftempcode'];
    $arr["ftempname"] = $result[0]['ftempname'];
    $arr["ftempdesc"] = $result[0]['ftempdesc'];
    $arr["ftempmax"] = $result[0]['ftempmax'];
    $arr["ftotmandqn"] = $result[0]['ftotmandqn'];
    $arr["detlength"] = count($res) > 0 ? "T" : "F";
    $arr['sumarr'] = $sumarr;
    $arr['sumarrdet']=$res;

if(count($result) > 0)
    {
        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 transform($el) {
    return [
        'partcode' => $el['fpartcode'],
        'partdescp' => $el['fpartdesc'],
        'maxqns' => $el['fmaxqn'],
        'mandqns' => $el['fmandqn'],
        'maxmarks' => $el['fmaxmarks'],
        'minqns' => $el['fminqn']
    ];
}

function checkTempCode($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data["univcode"];
	$ftempcode = $aobj_context->mobj_data["ftempcode"];
    
    $query = "select * from tdvs_qptemphead where ftempcode = '{$ftempcode}'";

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

function save_tempcode($aobj_context){
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);
    $univcode = $aobj_context->mobj_data["univcode"];
    $tempcode = $aobj_context->mobj_data["tempcode"];
    $sumdata = json_decode($aobj_context->mobj_data["sumdata"], true);
    $delrows = json_decode($aobj_context->mobj_data["delrows"], true);
    $tempname = $aobj_context->mobj_data["tempname"];
    $tempdesc = $aobj_context->mobj_data["tempdesc"];
    $tempmaxmarks = $aobj_context->mobj_data["tempmaxmarks"];
    $tempmandqns = $aobj_context->mobj_data["tempmandqns"];
    $template_obj = '';

foreach($delrows as $data){
        $deleteData = "delete from tdvs_qptemphead 
        where ftempcode = '${tempcode}' and fpartcode='{$data['partcode']}'";

$res1 = $aobj_context->mobj_db->Execute($deleteData);
    }

foreach($sumdata as $val){
        $template_obj .= "('{$tempcode}', '{$tempname}', '{$tempdesc}', '{$val['partcode']}', '{$val['partdescp']}', '{$val['maxqns']}', '{$val['mandqns']}',
        '{$val['maxmarks']}', '{$tempmaxmarks}', '{$tempmandqns}', '{$val['minqns']}'),";
    }
    $template_obj = rtrim($template_obj, ',');
    
    $sltQry = "insert into tdvs_qptemphead (ftempcode, ftempname,
    ftempdesc, fpartcode, fpartdesc,fmaxqn,fmandqn,
    fmaxmarks,ftempmax,ftotmandqn,fminqn) values
    {$template_obj}
    ON DUPLICATE KEY UPDATE
    fpartcode = VALUES(fpartcode), 
    fpartdesc = VALUES(fpartdesc),
    fmaxqn = VALUES(fmaxqn), 
    fmandqn = VALUES(fmandqn),
    fmaxmarks = VALUES(fmaxmarks)";
    
    $res = $aobj_context->mobj_db->Execute($sltQry);

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

$sltQry = "INSERT INTO tdvs_qptempdetl (ftempcode, fpartcode, fqncode, fqnno, fqnlevel, fqnparent, fmaxmarks, fsubqp, fsubmaxqn, fsubmandqn, fqnord)
	values
	${template_obj}
	ON DUPLICATE KEY UPDATE
	  fqnno = VALUES(fqnno),
	  fqndesc = VALUES(fqndesc),
	  fqnlevel = VALUES(fqnlevel),
	  fqnparent = VALUES(fqnparent),
	  fmaxmarks = VALUES(fmaxmarks),
	  fsubqp = VALUES(fsubqp),
	  fsubmaxqn = VALUES(fsubmaxqn),
	  fsubmandqn = VALUES(fsubmandqn),
	  fqnord = VALUES(fqnord)";
    
    $res = $aobj_context->mobj_db->Execute($sltQry);

${this.title}

Code Editor : displayTempDet.php