DEWATA [ login.easenup.in ]

Name	Size	Permission
auth_validate.php	385 B	-rw-r--r--
class.getdata.php	17.17 KB	-rw-r--r--
class.validdata.php	512 B	-rw-r--r--
flash_messages.php	1.74 KB	-rw-r--r--
flash_modal.php	4 KB	-rw-r--r--
footer.php	2.92 KB	-rw-r--r--
formvalidator.php	14.76 KB	-rw-r--r--
header.php	11.85 KB	-rw-r--r--
menu.php	2.49 KB	-rw-r--r--

Code Editor : class.getdata.php

<?PHP

//require_once '../config/config.php';
class GetData
{
     private $dd;

function __construct()
    {
   
     
       
    }

/////////filter/////////////////////

public function getsubjectlist(){
    $db = getDbInstance();                        
$subjects = $db->getOne("assign_subject", "SubjectId", null);

//var_dump($subjects);
$str_arr = explode (",",$subjects['SubjectId']);

$select = array('s.SubjectId','s.SubjectName','s.SubjectCode');  
$db->where ("s.SubjectId",$str_arr, 'in');

$data = $db->get("Subject s", null, $select);
echo json_encode($data);
}

public function getsubject(){
    $db = getDbInstance(); 
    $db->orderBy("SubjectId","Desc");                       
$select = array('SubjectId','SubjectName','SubjectCode');
$db->where("IsActive", "1"); 
$data = $db->get("subject", null, $select);
echo json_encode($data);
}

public function GetPaperCode($semester){
    $db = getDbInstance();
    $db->groupBy ("semester");  
        $db->orderBy("neppaperid","Desc");                       
$select = array('neppaperid', 'nepid', 'semester', 'year', 'coursecode', 'papertitle', 'type', 'credits', 'teachhours', 'IsActive');
$db->where("IsActive", "1"); 
$db->where("semester", $semester);
$data = $db->get("nep_papers", null, $select);
echo json_encode($data);
}

public function GetBatchlist($semester){
    $db = getDbInstance();
    $db->groupBy ("Semester"); 
     $db->orderBy("BatchId","Desc");                         
$select = array('BatchId','CollegeId','BatchName','BatchCode','BatchHead','BatchDesc','BatchTiming','Subject','Semester','IsActive');
$db->where("IsActive", "1"); 
$db->where("Semester", $semester);
$data = $db->get("batch", null, $select);
echo json_encode($data);
}

public function GetPaperViceUnitList($papercode){
    $db = getDbInstance(); 
     $db->orderBy("nepunitid","Desc");                        
$select = array('nepunitid','nepid', 'neppaperid', 'nepdetailid', 'coursecode', 'unit', 'topic', 'nooflecture', 'nooftutorial', 'noofpractical', 'IsActive');
$db->where("IsActive", "1");
$db->where("coursecode", $papercode);
$data = $db->get("nep_units", null, $select);
echo json_encode($data);
}

public function getCommanminimumCMSList($Subject){
    $db = getDbInstance();  
      $db->orderBy("nm.nepid","Desc");                        
$select = array('nm.subjectcode','nm.subjectid','nm.nepid');
$db->where("nm.subjectid", $Subject); 
$data = $db->get("nep_master nm", null, $select);
echo json_encode($data);
}
 ///Use get data by id
    
public  function getProgram($CollegeId)
{
$db = getDbInstance();

$select = array('ProgramId','CollegeId','ProgramCode','ProgramName','ProgramDesc');
$db->where("IsActive", "1");
$db->where("CollegeId", $CollegeId);
//$db->where('SubjectCode', Array($subject2,$subject3), 'NOT IN');
$db->orderBy("ProgramId","Asc");
$data = $db->get("program", null, $select);
echo json_encode($data);
 
 
}

public  function getDesignation($college)
{
$db = getDbInstance();                          
$select = array('DesignationId','UniversityId','CollegeId','DesignationName','DesignationCode','DesignationType');
$db->where("IsActive", "1");
$db->where("CollegeId", $college);
$db->orwhere("CollegeId", '0');
//$db->where('SubjectCode', Array($subject2,$subject3), 'NOT IN');
$db->orderBy("DesignationId","Asc");
$data = $db->get("designation", null, $select);
echo json_encode($data);

}

public  function getCourseByProgramId($CollegeId,$programid)
{
$db = getDbInstance();  
$select = array('CourseId','CollegeId','FacultyId','ProgramCode','CourseName','CourseId','CourseDesc','CoursePrefix','CourseIndex','CourseFee');
$db->where("IsActive", "1");
$db->where(["ProgramCode", $programid],["CollegeId", $CollegeId]);
$db->orderBy('CourseId','Asc');
$data=$db->get('course',null, $select);
echo json_encode($data);

}

public  function getSubjectByCourseId($CourseId)
{
$db = getDbInstance();  
$select = array('SubjectId','CollegeId','FacultyId','ProgramCode','CourseId','SubjectName','SubjectCode','SubjectDesc','MinorSubject','PracticalFee','Credit');
$db->where("IsActive", "1");
$db->where("CourseId", $CourseId);
$db->orderBy('SubjectId','Asc');
$data=$db->get('subject',null, $select);
echo json_encode($data);

}
public  function getSubjectByFacultyId($FacultyId)
{
$db = getDbInstance();  
$select = array('SubjectId','CollegeId','FacultyId','ProgramCode','CourseId','SubjectName','SubjectCode','SubjectDesc','MinorSubject','PracticalFee','Credit');
$db->where("IsActive", "1");
$db->where("FacultyId", $FacultyId);
$db->orderBy('SubjectId','Asc');
$data=$db->get('subject',null, $select);
echo json_encode($data);

}

public function getSessionByCollegeId($CollegeId){
    $db=getDbInstance();
    $select=array('s.SessionId','cs.CollegeId','s.SessionCode','s.SessionName','s.SessionDesc');
    $db->where('IsActive','1');
    $db->where('cs.CollegeId',$CollegeId);
    $db->orderBy('s.SessionId','Asc');
    $db->join('collegesession cs','cs.SessionId=s.SessionId','left');
    $data=$db->get('session s',null, $select);
    echo json_encode($data);

}
public function getclgmembershipID($CollegeId,$UniversityId){
    $db=getDbInstance();
    $select=array('MembershipId','UniversityId','CollegeId','qualification','joindate','experience','first_name','middle_name','last_name','email_id','member_photo','dob','father_name','mother_name','member_gender','birth_place','nationality','mother_tongue','member_category','member_religion');
    $db->where('IsActive','1');
     $db->where('CollegeId',$CollegeId);
    $db->orWhere('UniversityId',$UniversityId);
    $db->orderBy('MembershipId','Asc');
    $data=$db->get('clgmembership',null, $select);
    echo json_encode($data);

}
 public function getCollegeByUniversityID($university){
    $db=getDbInstance();
    $select=array('CollegeId','UniversityCode','CollegeCode','CollegeName','CollegeDesc');
    $db->where('IsActive','1');
    $db->where('UniversityCode',$university);
    $db->orderBy('CollegeId','Asc');
    $data=$db->get('college',null, $select);
    echo json_encode($data);

}
 //////////////////get college

public function getCollege(){
    $db = getDbInstance();                        
$select = array('CollegeId','CollegeName','CollegeCode');
$db->where("IsActive", "1"); 
$db->orderBy("CollegeId","Asc");
wherecollege($db);
$data = $db->get("college", null, $select);
echo json_encode($data);
 }

public function getUniversity(){
   $db = getDbInstance();                         
$select = array('UniversityId','UniversityName');
$db->where("IsActive", "1");
$db->orderBy("UniversityId","Asc");
$data = $db->get("university", null, $select);
echo json_encode($data);
 }
public function getPrograms(){
   $db = getDbInstance();                         
$select = array('ProgramId','ProgramName');
$db->where("IsActive", "1");
$db->orderBy("ProgramId","Asc");
$data = $db->get("program", null, $select);
echo json_encode($data);
 }
 public function getCourse($program){
   $db = getDbInstance();                         
$select = array('CourseId','ProgramId','CourseCode','CourseName');
$db->where('ProgramId',$program);
$db->where("IsActive", "1");
$db->orderBy("CourseId","Asc");
$data = $db->get("course", null, $select);

echo json_encode($data);
 }
 public function getsemesteryear($course){
 $db = getDbInstance(); 
 $select = array('s.SemesterId','s.SemesterName','s.SemesterCode');
$db->join("coursesemester cs", "cs.SemesterId=s.SemesterId", "Left");
$db->where("cs.IsActive", "1");
//$db->joinWhere("course co", "co.CourseId=cs.CourseId",$course);
$db->where("cs.CourseId", $course);
$db->orderBy("s.SemesterId","Asc");
$subjects = $db->get("semesteryear s", null, $select);
//echo "Last executed query was ". $db->getLastQuery();
 echo json_encode($subjects);
 }

public function getmajorsubject1tfacultywise($course){
     $db = getDbInstance(); 
  $select = array('s.SubjectId','f.FacultyId','f.FacultyName','f.FacultyCode','s.SubjectName','s.SubjectCode');
      $db->join("Faculty f", "f.FacultyId=s.FacultyId", "Left");
$db->where("s.IsActive", "1");
$db->where("s.CourseId", $course);
//$db->where("s.FacultyId", $faculty);
//$db->where('s.SubjectCode', Array($subject1,$subject2,$subject3), 'NOT IN');
$db->orderBy("s.FacultyId","Asc");
$db->orderBy("s.SubjectId","Asc");
$subjects = $db->get("Subject s", null, $select);
echo "Last executed query was ". $db->getLastQuery();
 echo json_encode($subjects);
}
public function getmajorsubject2facultywise($course,$faculty,$subject1){
     $db = getDbInstance(); 
  $select = array('s.SubjectId','f.FacultyId','f.FacultyName','f.FacultyCode','s.SubjectName','s.SubjectCode');
      $db->join("Faculty f", "f.FacultyId=s.FacultyId", "Left");
$db->where("s.IsActive", "1");
$db->where("s.CourseId", $course);
$db->where("s.FacultyId", $faculty);
$db->where('s.SubjectCode', Array($subject1), 'NOT IN');
$db->orderBy("s.FacultyId","Asc");
$db->orderBy("s.SubjectId","Asc");
$subjects = $db->get("Subject s", null, $select);
 echo json_encode($subjects);
}
public function getmajorsubject3facultywise($course,$faculty,$subject1,$subject2){
    $db = getDbInstance();  
  $select = array('s.SubjectId','f.FacultyId','f.FacultyName','f.FacultyCode','s.SubjectName','s.SubjectCode');
      $db->join("Faculty f", "f.FacultyId=s.FacultyId", "Left");
$db->where("s.IsActive", "1");
$db->where("s.CourseId", $course);
if($course=='B.A.'){
$db->where("s.FacultyId", $faculty,"!=");
}
$db->where('s.SubjectCode', Array($subject1,$subject2), 'NOT IN');
$db->orderBy("s.FacultyId","Asc");
$db->orderBy("s.SubjectId","Asc");
$subjects = $db->get("Subject s", null, $select);
 echo json_encode($subjects);
}
public function getmajorsubject1($course){
 $db = getDbInstance();                       
$select = array('sub.SubjectId','sub.SubjectName','cs.CourseId');
$db->join('subject sub','sub.SubjectId=cs.SubjectId','left');
$db->where("cs.IsActive", "1");
$db->where("cs.CourseId", $course);
//$db->where('SubjectCode', Array($subject2,$subject3), 'NOT IN');
$db->orderBy("cs.CourseSubjectId","Asc");
$data = $db->get("CourseSubject cs", null, $select);
 echo json_encode($data);

}
public function getmajorsubject2($course,$subject1){
      $db = getDbInstance();                          
$select = array('sub.SubjectId','sub.SubjectName','cs.CourseId');
$db->join('subject sub','sub.SubjectId=cs.SubjectId','left');
$db->where("cs.IsActive", "1");
$db->where("cs.CourseId", $course);
$db->where('cs.SubjectId', Array($subject1), 'NOT IN');
$db->orderBy("cs.CourseSubjectId","Asc");
$data = $db->get("CourseSubject cs", null, $select);
 echo json_encode($data);
}
public function getmajorsubject3($course,$subject1,$subject2){
       $db = getDbInstance();                         
$select = array('sub.SubjectId','sub.SubjectName','cs.CourseId');
$db->join('subject sub','sub.SubjectId=cs.SubjectId','left');
$db->where("cs.IsActive", "1");
$db->where("cs.CourseId", $course);
$db->where('cs.SubjectId', Array($subject1,$subject2), 'NOT IN');
$db->orderBy("cs.CourseSubjectId","Asc");
$data = $db->get("CourseSubject cs", null, $select);
 echo json_encode($data);
}
public function getminorsubject($course,$subject1,$subject2,$subject3){
      $db = getDbInstance();                          
$select = array('sub.SubjectId','sub.SubjectName','cs.CourseId');
$db->join('subject sub','sub.SubjectId=cs.SubjectId','left');
$db->where("cs.IsActive", "1");
$db->where("cs.CourseId", $course);
$db->where('cs.SubjectId', Array($subject1,$subject2,$subject3), 'NOT IN');
$db->orderBy("cs.CourseSubjectId","Asc");
$data = $db->get("CourseSubject cs", null, $select);
 echo json_encode($data);
}

public function getminorsubjectfacultywise($subject1,$subject2,$subject3){
    $db = getDbInstance();  
  $select = array('s.SubjectId','f.FacultyId','f.FacultyName','f.FacultyCode','s.SubjectName','s.SubjectCode');
      $db->join("Faculty f", "f.FacultyId=s.FacultyId", "Left");
$db->where("s.IsActive", "1");
$db->where('s.SubjectCode', Array($subject1,$subject2,$subject3), 'NOT IN');
$db->orderBy("s.FacultyId","Asc");
$db->orderBy("s.SubjectId","Asc");
$subjects = $db->get("Subject s", null, $select);
 echo json_encode($subjects);
}

public function collegeByProgram($college){
    $db=getDbInstance();   
$db->Where('cp.CollegeId',$college);
$db->Where('cp.Status',1);
$db->join('program p',"p.ProgramId=cp.ProgramId","Right");

$data=$db->get("courseprogram cp",null,'cp.CollegeId,p.ProgramName,p.ProgramId,p.ProgramCode'  );
echo json_encode($data);
}

public function courseByProgram($college,$program){
    $db=getDbInstance();   
$db->Where('cc.CollegeId',$college);
$db->Where('cc.ProgramId',$program);
$db->Where('cc.Status',1);
$db->join('course c',"c.CourseId=cc.CourseId","Right");

$data=$db->get("collegecourse cc",null,'cc.CollegeId,c.CourseName,c.CourseId,c.CourseCode'  );
echo json_encode($data);
}

public function GetCourseCollegeList($college){
    $db=getDbInstance();   
$db->Where('cc.CollegeId',$college);
$db->Where('cc.Status',1);
$db->join('course c',"c.CourseId=cc.CourseId","Right");

$data=$db->get("collegecourse cc",null,'cc.CollegeId,c.CourseName,c.CourseId,c.CourseCode'  );
echo json_encode($data);
}

public function getCollegeByCourseList($college){
    $db=getDbInstance();   
$db->Where('cc.CollegeId',$college);

$db->Where('cc.Status',1);
$db->join('course c',"c.CourseId=cc.CourseId","Right");

$data=$db->get("collegecourse cc",null,'cc.CollegeId,c.CourseName,c.CourseId,c.CourseCode'  );
echo json_encode($data);
}

public function SemesterByCourse($college,$course){
    $db=getDbInstance();   
$db->Where('cs.CollegeId',$college);
$db->Where('cs.CourseId',$course);
$db->Where('cs.IsActive',1);
$db->join('semesteryear sy',"sy.SemesterId=cs.SemesterId","left");
$data=$db->get("coursesemester cs",null,'cs.CollegeId,cs.CourseId,sy.SemesterId,sy.SemesterName,sy.SemesterCode,cs.IsActive'  );
echo json_encode($data);
}

public function GetCollegeNoticeAndnews($college){
    $db->getDbInstance();
    $select = array('CollegeId','PMessage','PStatus','PNotice','EMessage','EStatus','ENotice','Cookiee');
    $db->where('IsActive', 1);
    $db->where('CollegeId',$college);
    $data=$db->get('setting',null,$select);
    echo json_encode($data);

}

public function Getcoursesetting($college,$course,$semester){
    $db->getDbInstance();
    $select=array('CollegeId','CourseId','SemesterId','Subject1','Subject2','Subject3','Subject4','Subject5','Subject6','FormFee','TutionFee','CoursePrefix','CourseIndex');
    $db->where('IsActive',1);
    $db->where('CollegeId',$college);
    $db->Where('CourseId',$course);
    $db->where('SemesterId',$semester);
    $data=$db->get('coursesetting',null,$select);
    echo json_encode($data);
}
public function GetMinorSubject1($program,$university){
    $db->getDbInstance();
    $select=array('UniversityId','ProgramId','MinorSubjectName','MinorSubjectCode','MinorSubjectDesc','Credit');
    $db->where('IsActive',1);
    $db->where('UniversityId',$university);
    $db->Where('ProgramId',$program);   
    $data=$db->get('subjectminor',null,$select);
    echo json_encode($data);
}

// public function GetVocationalSubject($course,$semester){
//     $db->getDbInstance();
//     $select=array();
//     $db->where('IsActive',1);
   
//     $db->Where('CourseId',$course);
//     $db->where('SemesterId',$semester);
//     $data=$db->get('',null,$select);
//     echo json_encode($data);
// }
// public function GetCurriculamSubject($course,$semester){
//     $db->getDbInstance();
//     $select=array();
//     $db->where('IsActive',1);
   
//     $db->Where('CourseId',$course);
//     $db->where('SemesterId',$semester);
//     $data=$db->get('',null,$select);
//     echo json_encode($data);
// }
// public function GetFormFeeByRegistration(){
//     $db->getDbInstance();
//     $select=array('','','','','','','','','','','');
//     $db->where('IsActive',1);
   
//     $data=$db->get('',null,$select);
//     echo json_encode($data);
// }

// public function GetAdmissionFeeByRegistration(){
//     $db->getDbInstance();
//     $select=array('','','','','','','','','','','');
//     $db->where('IsActive',1);
   
//     $data=$db->get('',null,$select);
//     echo json_encode($data);
// }

// public function GetCollegeNavigation(){
//     $db->getDbInstance();
//     $select=array('','','','','','','','','','','');
//     $db->where('IsActive',1);
   
//     $data=$db->get('',null,$select);
//     echo json_encode($data);
// }

// public function GetCollegeHomelink(){
//     $db->getDbInstance();
//     $select=array('','','','','','','','','','','');
//     $db->where('IsActive',1);
   
//     $data=$db->get('',null,$select);
//     echo json_encode($data);
// }

public function GetFormStep($college,$course,$semester){
    $db->getDbInstance();
    $select=array('sf.CollegeId','sf.CourseId','sf.SemesterId','s.StepName','s.StepCode');
    $db->join('step s','s.StepId=sf.StepName','LEFT');
    $db->where('Status',1);   
    $data=$db->get('stepform sf',null,$select);
    echo json_encode($data);
}

}

${this.title}

Code Editor : class.getdata.php