/*** * 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, '
', ''), '
', ''), '–', '-'), '