<?php 	
class m_tarif2012 {	
	var $db_host;
	var $db_user;
	var $db_pass;
    var $allFields = array();
	var $strDBError       = "";
    var $intRow        = 0;

	public function getAllFields(){
		$sql="select kode_tindakan,kode_gruptindakan,nama_tindakan,tarif,jasa_sarana,jasa_pelayanan from m_tarif2012 order by kode_tindakan ";	
		$res = $db->query($sql);
		$allFields=array();
		foreach($res->fetchAll() as $val) {
			array_push($allFields,$val);
		}
		return $allFields;			
	}
	public function getAllFieldsById($id){
		$sql="select * from m_tarif2012 where kode_tindakan='$id' order by kode_tindakan";	
		$res = $db->query($sql);
		$allFields=array();
		$allFields = $res->fetchAll()[0];
		return $allFields;			
	}	
	public function updateAkun($id,$namaakun,$parent,$jasa_sarana,$jasa_pelayanan,$tarif){
		$strSQL	="update m_tarif2012 set nama_tindakan='$namaakun',jasa_sarana='$jasa_sarana',jasa_pelayanan='$jasa_pelayanan',tarif='$tarif' where kode_tindakan='$id'";
		$resQuery        = $db->query($strSQL);
		if ($resQuery ) {
		  $this->intRow  = mysql_affected_rows();
		  return true;
		} else {
		  $this->strDBError   = mysqli_error($connect);
		  return false;
		}
	}	

	public function insertAkun($id,$namaakun,$parent,$jasa_sarana,$jasa_pelayanan,$tarif){
		$strSQL	="insert into m_tarif2012(kode_tindakan,nama_tindakan,kode_gruptindakan,jasa_sarana,jasa_pelayanan,tarif) values('$id','$namaakun','$parent','$jasa_sarana','$jasa_pelayanan','$tarif') ";
		$resQuery        = $db->query($strSQL);
		if ($resQuery ) {
		  $this->intRow  = mysql_affected_rows();
		  return true;
		} else {
		  $this->strDBError   = mysqli_error($connect);
		  return false;
		}
	}	

	public function db_connect(){
		$conn = mysql_connect($this->db_host, $this->db_user, $this->db_pass); 
		if($conn) {
			mysql_select_db($this->db_database, $conn);
		} 
		return $conn;
	}
		
	public function db_disconnect(){
		mysqli_close();
	}
} 
?>