<?php
class AppIntegrasiDataSia extends Database {

	protected $mSqlFile= 'module/integrasi_data/business/appintegrasidatasia.sql.php';

	function __construct($connectionNumber=1) {
		parent::__construct($connectionNumber);
		#$this->SetDebugOn();
	}
   
# Do Add Data Begin
   function DoAddMahasiswaToSia($arrData)
   {
      $result = $this->Execute($this->mSqlQueries['do_add_mahasiswa_to_sia'],($arrData)); 
      //print_r($arrData);
      //print($this->GetLastError());exit;
      return $result;
   }
   
   function DoAddOrangTuaMahasiswaToSia($arrData)
   {
      //print_r($arrData);
      $result = $this->Execute($this->mSqlQueries['do_add_ortu_mahasiswa_to_sia'],($arrData));
      //print($this->GetLastError());
      return $result;
   }
   function DoInsertJatahSks($arrData)
   {
      $result = $this->Execute($this->mSqlQueries['do_insert_jatah_sks'],($arrData));
      return $result;
   }

   function DoInsertRegistrasi($arrData)
   {
      $result = $this->Execute($this->mSqlQueries['do_insert_registrasi'],($arrData));
      return $result;
   }
   function DoInsertStatusBayar($arrData)
   {
      $result = $this->Execute($this->mSqlQueries['do_insert_mahasiswa_status_bayar'],($arrData));
      #print($this->GetLastError());
      return $result;
   }
# Do Add Data End

#Check data Begin
   function CheckSemesterProdi($arrData){
      $result=$this->Open($this->mSqlQueries['get_cek_semester_prodi'],$arrData);
      return $result[0]['SEMPID'];
   }
   
#Check data End

}
?>
