mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); include_once("/JSON.php"); $json = new Services_JSON(); $id = ($aobj_context->mobj_data["id"]); $coll_code = ($aobj_context->mobj_data["coll_code"]); $FMODULE = ($aobj_context->mobj_data["FMODULE"]); $lstr_param = stripslashes($aobj_context->mobj_data["cds_details"]); $mobj_jsondata = $json->decode($lstr_param); $larr_cds_data = get_object_vars($mobj_jsondata); for( $i = 0; $i < count($larr_cds_data); $i++ ) { $update_cond=''; if($larr_cds_data[$i]->cds_reset==1 || $larr_cds_data[$i]->cds_reset=='1') { $update_cond=",FSTATUS= '' and FDATE='0000-00-00'"; } $Update_into_cds_data="update colldeg set FYEAR='{$larr_cds_data[$i]->cds_year}', FACTIVE='{$larr_cds_data[$i]->is_active}' {$update_cond} where FDEGREE='{$larr_cds_data[$i]->cds_degree}' and FCOLLCODE='{$coll_code}' and FMODULE='{$larr_cds_data[$i]->cds_module}'"; // echo $Update_into_cds_data; $lobj_update_into_cds_details = $aobj_context->mobj_db->Execute($Update_into_cds_data); } if($lobj_update_into_cds_details) { $rdata = "Updated Successfully"; print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,0,"success")); return $rdata; } else { $rdata = "Updation Failed."; print_r($aobj_context->mobj_output->ToJSONEnvelope($rdata,-1,"Failure")); return $rdata; } } function getCollegeDegreeStatus($aobj_context) { require_once(dirname(__FILE__)."\SalCompClass.php"); $check_type_obj=new SalCompClass($aobj_context); $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $internal_code=$aobj_context->mobj_data["internal_code"]; $module_name=$aobj_context->mobj_data["module_name"]; $college_code=trim($aobj_context->mobj_data["FCOLLCODE"]); $degree_code=$aobj_context->mobj_data["FDEGREE"]; $College_data_header=""; $College_data_header.=" "; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $College_data_header.=""; $cond=''; if($degree_code!='') $cond= " and FDEGREE='{$degree_code}'"; //echo $College_data_header; die(); $get_names="select FDEGREE,FMODULE,FACTIVE,FYEAR,FEXAMTYPE,FSTATUS,FDATE from colldeg where FCOLLCODE='{$college_code}' {$cond} "; $lobj_get_names = $aobj_context->mobj_db->getAll($get_names); $k=0; $id=1; foreach($lobj_get_names as $key=>$val) { if($k%2==0) $class='tbl_row'; else $class='tbl_row1'; $cds_active_is_selected=($val['FACTIVE']==1)?'checked':''; $cds_year=$val['FYEAR']; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $college_data_details.=""; $k++; $id++; } $arr['html']=$College_data_header.$college_data_details."

College Degree Status
Degree	Module	Active	Year	Status	Date	Reset
{$val[FDEGREE]}	{$val[FMODULE]}			{$val['FSTATUS']}	{$val['FDATE']}

"; $arr['table_data']=$lobj_get_names; echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); } function autocompletephp($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $q = $aobj_context->mobj_data["part"]; //$lstr_qry = "select FCOLLNAME as value from college where FCOLLNAME like '%{$q}%'"; $lstr_qry = "select FCOLLCODE as value from college where FCOLLCODE like '%{$q}%'"; $lobj_rs = $aobj_context->mobj_db->GetAll($lstr_qry); if(!empty($lobj_rs)) echo json_encode($lobj_rs); } ?>