<?php
class AppLaporanRegistrasi extends Database {

	protected $mSqlFile= 'module/laporan_registrasi/business/applaporanregistrasi.sql.php';

	function __construct($connectionNumber=0) {
		parent::__construct($connectionNumber);
		#$this->SetDebugOn();
	}
   
   /*function GetDataRekapRegistrasi($periode,$jalur,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_data_rekap_registrasi'], array('%'.$tanggal.'%',
                                                                                 '%'.$periode.'%',
                                                                                 '%'.$jalur.'%',
                                                                                 '%'.$tanggal.'%',
                                                                                 '%'.$periode.'%',
                                                                                 '%'.$jalur.'%',
                                                                                '%'.$jenjang.'%'));
       #print($this->GetLastError());
      return $result;
   }*/
   
   function GetDataRekapRegistrasi($periode_reg,$tanggal,$jalur,$jenjang,$tahun_masuk){      
      $result =$this->Open($this->mSqlQueries['get_data_rekap_registrasi'], array('%'.$periode_reg.'%',
                                                                                 '%'.$tanggal.'%',
                                                                                 '%'.$jalur.'%',
                                                                                 '%'.$tahun_masuk.'%',
                                                                                 '%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetExcelRekapRegistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_excel_rekap_registrasi'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetRekapRegistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_rekap'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetTotalRekapRegistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_total_rekap'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetDataPrintLaporanRegistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_print_laporan_registrasi'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetTanggalRegistrasiByPeriode($id){
      $result=$this->Open($this->mSqlQueries['get_tanggal_registrasi_by_periode'],array('%'.$id.'%'));
      return $result;
      #print($this->GetLastError());
   }
   
   function GetJenjangAkademik(){
      $result=$this->Open($this->mSqlQueries['get_jenjang_akademik'],array());
      return $result;
   }
   
   function GetNamaJenjang($id){
      $result=$this->Open($this->mSqlQueries['get_nama_jenjang'],array($id));
      return $result;
   }
   
   function GetJalurMasuk(){
      $result=$this->Open($this->mSqlQueries['get_jalur_masuk'],array());
      return $result;
   }
   
   function GetNamaJalur($id){
      $result=$this->Open($this->mSqlQueries['get_nama_jalur'],array($id));
      return $result;
   }

   function GetPeriodeAktif(){
      $result=$this->Open($this->mSqlQueries['get_periode_aktif'],array());
      return $result;
   }
   
   function GetDataPeriode(){
      $result=$this->Open($this->mSqlQueries['get_data_periode'], array());
      return $result;
   }
   
   function GetNamaPeriode($id){
      $result=$this->Open($this->mSqlQueries['get_nama_periode'], array($id));
      return $result;
   }
   
   function GetNamaTanggal($id){
      $result=$this->Open($this->mSqlQueries['get_nama_tanggal'], array($id));
      return $result;
   }

//===DO===

}
?>
