<? 

  /***
  * Core-base class untuk mengimplementasikan tabel kategori.
  * 
  ***/
  include_once(APPPATH."/models/Core.php");

  class BeritaModel extends Core{ 

	var $query;
    /**
    * Class constructor.
    **/
    function __construct()
	{
      	  
      	  $this->Core(); 
    }
	
	function insert()
	{
		/*Auto-generate primary key(s) by next max value (integer) */
		$this->setField("BERITA_ID", $this->getNextId("BERITA_ID","berita")); 
		
		$str = "INSERT INTO berita
				(
					BERITA_ID, NAMA, TANGGAL, KETERANGAN, STATUS_AKTIF, LAST_CREATE_USER, LAST_CREATE_DATE
				)
				VALUES(
					".$this->getField("BERITA_ID").",
					'".$this->getField("NAMA")."',
					".$this->getField("TANGGAL").",
					'".$this->getField("KETERANGAN")."',
					'".$this->getField("STATUS_AKTIF")."',
					'".$this->getField("LAST_CREATE_USER")."',
					".$this->getField("LAST_CREATE_DATE")."
				)
		"; 
		$this->id = $this->getField("BERITA_ID");
		$this->query = $str;
		return $this->execQuery($str);
    }

    function update()
	{
		/*Auto-generate primary key(s) by next max value (integer) */
		$str = "UPDATE berita
				SET
					NAMA				= '".$this->getField("NAMA")."',
					TANGGAL 			= ".$this->getField("TANGGAL").",
					KETERANGAN 			= '".$this->getField("KETERANGAN")."',
					STATUS_AKTIF 		= '".$this->getField("STATUS_AKTIF")."',
					LAST_UPDATE_USER	= '".$this->getField("LAST_UPDATE_USER")."',
					LAST_UPDATE_DATE	= ".$this->getField("LAST_UPDATE_DATE")."
				WHERE BERITA_ID = ".$this->getField("BERITA_ID")."
				"; 
				$this->query = $str;
		return $this->execQuery($str);
    }

    function uploadFile()
	{
		/*Auto-generate primary key(s) by next max value (integer) */
		$str = "UPDATE berita 
				SET
				  	LINK_FILE			= '".$this->getField("LINK_FILE")."'
				WHERE BERITA_ID 		= ".$this->getField("BERITA_ID")."
				"; 
				$this->query = $str;
		return $this->execQuery($str);
    }
	
	function updateFormatDynamis()
	{
		$str = "
				UPDATE ".$this->getField("TABLE")."
				SET
					   ".$this->getField("FIELD")." = '".$this->getField("FIELD_VALUE")."'
				WHERE ".$this->getField("FIELD_ID")." = '".$this->getField("FIELD_VALUE_ID")."'
			 "; 
		$this->query = $str;
		return $this->execQuery($str);
    }
	
	function delete()
	{
        $str = "DELETE FROM berita WHERE 
                BERITA_ID = '".$this->getField("BERITA_ID")."'"; 
				  
		$this->query = $str;
        return $this->execQuery($str);
    }

    /** 
    * Cari record berdasarkan array parameter dan limit tampilan 
    **/ 
	function selectByParams($paramsArray=array(),$limit=-1,$from=-1,$statement="", $order="")
	{
		$str = "SELECT 
					BERITA_ID, NAMA, KETERANGAN, STATUS_AKTIF, TANGGAL, LINK_FILE
 				FROM berita A
				WHERE 1 = 1
			"; 
		
		foreach($paramsArray as $key => $val) 
		{
		    $str .= " AND $key = '$val' ";
		}
		
		$str .= $statement." ".$order;
		$this->query = $str;
		return $this->selectLimit($str,$limit,$from); 
    }
    
	function selectByParamsDashboard($paramsArray=array(),$limit=-1,$from=-1,$statement="", $order="")
	{
		$str = "SELECT 
					BERITA_ID, NAMA, KETERANGAN, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(KETERANGAN, '<p>', ''), '</p>', ''), '&ndash;', '-'), '<br>', ''), '<br.', ''), '<br />', '') KETERANGAN_FORMAT, STATUS_AKTIF, TANGGAL, LINK_FILE
					, ambil_post_slug(A.NAMA) POST_SLUG
 				FROM berita A
				WHERE 1 = 1
			"; 
		
		foreach($paramsArray as $key => $val) 
		{
		    $str .= " AND $key = '$val' ";
		}
		
		$str .= $statement." ".$order;
		$this->query = $str;
		return $this->selectLimit($str,$limit,$from); 
    }
    
    /** 
    * Hitung jumlah record berdasarkan parameter (array). 
    **/ 
	function getCountByParams($paramsArray=array(), $statement="")
	{
		$str = "SELECT COUNT(1) AS ROWCOUNT 
				FROM berita A
				WHERE 1 = 1 ".$statement; 
		
		foreach($paramsArray as $key => $val) 
		{
		    $str .= " AND $key = '$val' ";
		}

		$this->query = $str;
		$this->select($str); 
		if($this->firstRow()) 
			return $this->getField("ROWCOUNT"); 
		else 
			return 0; 
    }

  } 
?>