<?php
class AppLaporanHeregistrasi extends Database {

	protected $mSqlFile= 'module/laporan_heregistrasi/business/applaporanheregistrasi.sql.php';

	function __construct($connectionNumber=0) {
		parent::__construct($connectionNumber);
		
	}
	
	function GetDataRekapHeregistrasi($periode,$jalur,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_data_rekap_heregistrasi'], array('%'.$tanggal.'%',
                                                                                 '%'.$periode.'%',
                                                                                 '%'.$jalur.'%',
                                                                                 '%'.$tanggal.'%',
                                                                                 '%'.$periode.'%',
                                                                                 '%'.$jalur.'%',
                                                                                '%'.$jenjang.'%'));

      echo 1; die;
      print($this->GetLastError());
      return $result;
   }
   
   function GetExcelRekapHeregistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_excel_rekap_heregistrasi'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetDataPrintLaporanHeregistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_print_laporan_heregistrasi'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetRekapHeregistrasi($periode,$jalur,$jk,$tanggal,$jenjang){      
      $result =$this->Open($this->mSqlQueries['get_rekap'], array('%'.$periode.'%','%'.$jalur.'%','%'.$jk.'%','%'.$tanggal.'%','%'.$jenjang.'%'));
      #print($this->GetLastError());
      return $result;
   }
   
   function GetTotalRekapHeregistrasi($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 GetTanggalHeregistrasiByPeriode($id){
      $result=$this->Open($this->mSqlQueries['get_tanggal_heregistrasi_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===

}
?>
