<?php
class AppLaporanFormasiCalonMhsBaru extends Database {

   protected $mSqlFile= 'module/Laporan_formasi_calon_mhs_baru/business/applaporanformasicalonmhsbaru.sql.php';

   function __construct($connectionNumber=0) {
      parent::__construct($connectionNumber);
      
   }
   
   function GetRekapMhsBaru($tahunMasuk,$semsMasuk,$jalur,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_rekap_mhs_baru'], array('%'.$semsMasuk.'%',
                                                                           '%'.$tahunMasuk.'%',
                                                                         '%'.$jalur.'%',
                                                                           '%'.$jenjang.'%'));
      //print_r($this->GetLastError());
      return $result;
   }
   

   function GetJenjangAkademik(){
      $result=$this->Open($this->mSqlQueries['get_jenjang_akademik'],array());
      return $result;
   }
   
   
   function GetJalurMasuk(){
      $result=$this->Open($this->mSqlQueries['get_jalur_masuk'],array());
      return $result;
   }
   
  
   function GetTahunMasuk(){
      $result=$this->Open($this->mSqlQueries['get_tahun_masuk'],array());
      return $result;
   }
   
   function GetSemesterMasuk(){
      $dataSemester[0]['id']="GANJIL";
      $dataSemester[0]['name']="GANJIL";
      $dataSemester[1]['id']="GENAP";
      $dataSemester[1]['name']="GENAP";
      return $dataSemester;
   }
   
   function GetPeriodeAktif(){
      $result=$this->Open($this->mSqlQueries['get_periode_aktif'],array());
      return $result[0]['nama'];
   }
   
   function GetTahunPeriodeAktif(){
      $result=$this->Open($this->mSqlQueries['get_tahun_periode_aktif'],array());
      return $result[0]['tahun'];
   }
   
//===DO===
}
?>
