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, '

', ''), '

', ''), '–', '-'), '
', ''), '', '') 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; } } ?>