%PDF- <> %âãÏÓ endobj 2 0 obj <> endobj 3 0 obj <>/ExtGState<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI] >>/Annots[ 28 0 R 29 0 R] /MediaBox[ 0 0 595.5 842.25] /Contents 4 0 R/Group<>/Tabs/S>> endobj ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<>endobj 2 0 obj<> endobj 2 0 obj<>endobj 2 0 obj<>es 3 0 R>> endobj 2 0 obj<> ox[ 0.000000 0.000000 609.600000 935.600000]/Fi endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream
<?php class Microsite_model extends CI_Model { public function __construct() { parent::__construct(); } /* * Function: deleteCourse * Description : delete course details */ public function deleteRecord($id, $field_name= 'id', $tbl_name = 'su_microsite') { $this->db->where($field_name, $id); $data = array(); $data = array('is_deleted'=> '1','status'=>'0', 'modifiedon'=>date('Y-m-d h:i:s')); if (!$this->db->update($tbl_name, $data)) { log_message('error', print_r($this->db->error(), true)); show_error(lang('database_error')); } } /* * Function : removeSpecialChars */ function removeSpecialChars($post) { $newArray = array(); foreach($post as $key=>$string) { //$string = preg_replace('/[^a-zA-Z0-9_ -]/s','',$string); $string = str_replace( array( '\'', '"', ',' , ';','—','’','~','!','@','#','#','^','*', '|'), ' ', $string); $newArray[$key] = $string; } return $newArray; } /* * Function : getRecords * Description : Get all courses details */ function getRecords($tbl_name='su_microsite', $microsite_id = NULL, $condition_array) { $this->db->select('*'); $this->db->from($tbl_name); $this->db->where('is_deleted', '0'); if($microsite_id>0){ $this->db->where('id', $microsite_id); } foreach($condition_array as $key=>$val){ $this->db->where($key, $val); } $queryResult = $this->db->get(); //echo $this->db->last_query(); die; if ($microsite_id >0) { return $queryResult->row_array(); } else { return $queryResult->result_array(); } } /* * Function: setRecordDetails * Description : set course details */ function setRecordDetails($post, $tbl_name = 'su_microsite') { $post['page_url'] = str_replace(array(' ','.','/','&'),'-',strtolower($post['page_url'])); // Replace space with - unset($post['submit']); // Remove Special Character $post = $this->removeSpecialChars($post); if($post['banner_image']=='') { $post['banner_image'] = $post['old_image']; } if($tbl_name == 'su_microsite'){ if($post['logo_image']=='') { $post['logo_image'] = $post['old_logo_image']; } if($post['outer_logo_image']=='') { $post['outer_logo_image'] = $post['old_outer_logo_image']; } $post['page_key'] = base64_encode(serialize(array('page_url'=>$post['page_url'],'admin_id'=>$post['admin_id'],'logo_image'=>$post['logo_image'],'outer_logo_image'=>$post['outer_logo_image']))); } if ($post['edit'] > 0) { $this->db->where('id', $post['edit']); unset($post['edit']); unset($post['id']); unset($post['old_image']); unset($post['old_logo_image']); unset($post['old_outer_logo_image']); if (!$this->db->update($tbl_name, $post)) { print_r($this->db->error()); log_message('error', print_r($this->db->error(), true)); show_error(lang('database_error')); } } else { unset($post['edit']); unset($post['id']); if (!$this->db->insert($tbl_name, $post)) { print_r($this->db->error()); log_message('error', print_r($this->db->error(), true)); show_error(lang('database_error')); } } } }