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

<?php
    function saveTeacherDetails($aobj_context){
        $data = json_decode($aobj_context->mobj_data["data"], true);
        $type = $aobj_context->mobj_data["type"];
        $teachcode = $data['teachcode'];
        $name = $data['name'];
        $dob = $data['dob'];
        $email = $data['email'];
        $mobile = $data['mobile'];
        $college = $data['college'];
        $examiner = $data['examiner'];
        $fcollname = $data['fcollname'];
        $mascolcond = "";
        $tdvscolcond = "";
        $mascolcond1 = "";
        $mascolcond2 = "";
        $tdvscolcond1 = "";
        $tdvscolcond2 = "";

if($college == 'OTHR'){
            $mascolcond = ",fcollname = '{$fcollname}'";
            $tdvscolcond = ",fcollege = '{$fcollname}'";
            $mascolcond1 = ",fcollname";
            $mascolcond2 = ",'{$fcollname}'";
            $tdvscolcond1 = ",fcollege";
            $tdvscolcond2 = ",'{$fcollname}'";
        }
        
        if($type === "update"){
            $query1 = "update masteach set fteachname='{$name}', 
                       fdob=date_format(str_to_date('{$dob}', '%d/%m/%Y'),'%Y-%m-%d'), 
                       fmobile='{$mobile}', femail='{$email}', fcollcode='{$college}', 
                       fexaminer='{$examiner}' $mascolcond
                       where fteachcode='{$teachcode}'";
            $res1 = $aobj_context->mobj_db->Execute($query1);

$query2 = "update tdvs_masteach set fteachname='{$name}', 
                       fdob=date_format(str_to_date('{$dob}', '%d/%m/%Y'),'%Y-%m-%d'), 
                       fmobile='{$mobile}', femail='{$email}', fcollcode='{$college}', 
                       fexaminer='{$examiner}' $tdvscolcond
                       where fteachcode='{$teachcode}'";
            $res2 = $aobj_context->mobj_db->Execute($query2);

if($res1 && $res2){
                $arr['msg'] = "Updated successfully";
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
                return; 
            }else{
                $arr['msg'] = "Failed to update";
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
                return;
            }

}else if($type === "insert"){

$query = "select * from masteach where fteachcode='{$teachcode}' 
            and ifnull(fteachcode,'') <> '' and ifnull(FDELETED,'F') <> 'T'";
            $res = $aobj_context->mobj_db->GetAll($query);

if(count($res) > 0){
                $arr['msg'] = "Teacher code already exist";
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
                return; 
            }

$query0 = "select * from masteach where fmobile='{$mobile}'
            and ifnull(FDELETED,'F') <> 'T'";
            $res0 = $aobj_context->mobj_db->GetAll($query0);

if(count($res0) > 0){
                $arr['msg'] = "Mobile number already exist";
                echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
                return; 
            }

$code = "";
            if($teachcode === ""){
                $code = $mobile;
            }else{
                $code = $teachcode;
            }

$query1 = "insert into masteach(fteachcode, fteachname, fdob, fmobile, 
                     femail, fcollcode, fexaminer $mascolcond1)
                      values('{$code}', '{$name}', date_format(str_to_date('{$dob}', '%d/%m/%Y'),'%Y-%m-%d'), 
                      '{$mobile}', '{$email}', '{$college}', '{$examiner}' $mascolcond2)";
            
                    //   var_dump($query1);die();
            $res1 = $aobj_context->mobj_db->Execute($query1);
            $fteachCode = $aobj_context->mobj_db->Insert_id();
            
            $query2 = "insert into tdvs_masteach(fteachcode, fteachname, fdob, fmobile, femail, 
                      fcollcode, fexaminer $tdvscolcond1)
                      values('{$code}', '{$name}', date_format(str_to_date('{$dob}', '%d/%m/%Y'),'%Y-%m-%d'), 
                      '{$mobile}', '{$email}', '{$college}', '{$examiner}' $tdvscolcond2)";
            
            $res2 = $aobj_context->mobj_db->Execute($query2);
            
            if($teachcode === ""){
                $query4 = "update  masteach set fteachcode='{$fteachCode}' 
                           where fteachcode = '{$code}'";
                $res4 = $aobj_context->mobj_db->Execute($query4);

$query5 = "update  tdvs_masteach set fteachcode='{$fteachCode}' 
                           where fteachcode = '{$code}'";
                $res5 = $aobj_context->mobj_db->Execute($query5);

if($res5){
                    $arr['msg'] = "Teacher code {$fteachCode} created successfully";
                    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
                    return; 
                }else{
                    $arr['msg'] = "Failed to update";
                    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
                    return;
                }
            }else{
                if($res1 && $res2){
                    $arr['msg'] = "Updated successfully";
                    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
                    return; 
                }else{
                    $arr['msg'] = "Failed to update";
                    echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
                    return;
                }
            }
        }
    }

function getCollegeDetails($aobj_context){
        $query = "select fcollcode, concat(fcollname, ' [',fcollcode,']')as fcollname from college where ifnull(fcollcode, '')<>'';";
        $res = $aobj_context->mobj_db->GetAll($query);

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

function getTeacherDetails($aobj_context){
        $query = "select fteachcode, ifnull(fteachname, '')as fteachname, 
            ifnull(date_format(fdob,'%d/%m/%Y'), '')as fdob, 
            ifnull(m.fmobile, '')as fmobile, ifnull(m.femail, '')as femail,
            (case when(m.fcollcode = 'OTHR')then m.fcollname
            else concat(c.fcollname, ' [',c.fcollcode,']') end)as fcollname, ifnull(fexaminer, ''),
            ifnull(fexaminer, '')as fexaminer
            from masteach m 
            left join college c on c.fcollcode = m.fcollcode 
            where ifnull(fteachcode, '')<>''
            and ifnull(m.FDELETED,'F') = 'F' order by fteachname";
        $res = $aobj_context->mobj_db->GetAll($query);

function getTeachDet($aobj_context){
        $teachcode = $aobj_context->mobj_data["teachcode"];

$query = "select fteachcode, ifnull(fteachname, '')as fteachname, 
                  ifnull(date_format(fdob,'%d/%m/%Y'), '')as fdob, 
                  ifnull(m.fmobile, '')as fmobile, ifnull(m.femail, '')as femail,
                  c.fcollcode, 
                  concat(c.fcollname, ' [',c.fcollcode,']')as fcollname, ifnull(fexaminer, '')as fexaminer 
                  from masteach m inner join college c on c.fcollcode = m.fcollcode 
                  where ifnull(fteachcode, '')<>'' 
                  and fteachcode='{$teachcode}'";
        $res = $aobj_context->mobj_db->GetRow($query);

if(count($res) > 0){
            $arr['msg'] = "$code already exists";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, -1, "failure"); 
            return;
        }
    }

function deleteTeachData($aobj_context){
        $teachcode = $aobj_context->mobj_data["teachcode"];
        $usertype = $aobj_context->mobj_data["usertype"];
        $fusercode = $aobj_context->mobj_data["fusercode"];
        $fmobile = $aobj_context->mobj_data["fmobile"];
        
        $query = "select * from masteach  
                where fteachcode='{$teachcode}'";
        
        $res = $aobj_context->mobj_db->GetRow($query);

if(count($res) != 0){
            $delquery = "update masteach set FDELETED ='T'
                where fteachcode='{$teachcode}'";
        
            $delres = $aobj_context->mobj_db->Execute($delquery);
        }

$que = "select * from qp_masteach where fregno = '{$teachcode}'";
        $qpres = $aobj_context->mobj_db->GetRow($que);

if(count($qpres) != 0){
            $delqp = "delete from qp_masuser
                    where fregno='{$teachcode}' and fmobileno = '{$fmobile}'";
            
            $delqp = $aobj_context->mobj_db->Execute($delqp);
        }

if($delqp || $delres){
            $arr['msg'] = "Successfully Deleted";
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr, 0, "success"); 
        }else{
            $arr['msg'] = "Something went wrong try later";
            echo $aobj_context->mobj_output->ToJSONEnvelope($result, -1, "failure"); 
            return;
        }
    }
?>

${this.title}

Code Editor : teacherentry.php