%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'));
}
}
}
}