ikan Uploader :
Directory : /var/www/html/wireout.org/application/modules/admin/models/
Upload File : |
| Current File : /var/www/html/wireout.org/application/modules/admin/models/School_model.php |
<?php
class School_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
/*
* Function : deleteRecords
* Description : Delete Record
*/
public function deleteRecords($id, $field_name= 'id', $tbl_name='tbl_schools')
{
$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: setSchoolDetails
* Description : set schools details
*/
function setSchoolDetails($post)
{
$post['school_url'] = valid_seo_friendly_url($post['school_url']); // Replace space with -
$post['id'] = $post['edit'];
unset($post['edit']);
$post['overview'] = seo_friendly_url($post['overview']); // Replace space with
$post['highlights'] = seo_friendly_url($post['highlights']); // Replace space with
if ($post['id'] > 0) {
$this->db->where('id', $post['id']);
unset($post['id']);
if($post['school_image']=='') { $post['school_image'] = $post['old_image']; }
unset($post['old_image']);
if (!$this->db->update('tbl_schools', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
} else {
if (!$this->db->insert('tbl_schools', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : getSchools
* Description : Get all schools details
*/
function getSchools( $school_id = NULL, $limit=0) {
$this->db->select('id, school_name, school_url, school_code, highlights, discipline_type,school_tagline, overview,seo_keywords, about_schools,seo_description, seo_title, school_stats, display_order, school_image,general_brochure,custom, status');
$this->db->order_by('display_order', 'asc');
$this->db->order_by('school_name', 'asc');
$this->db->where('is_deleted', '0');
if($school_id>0){
$this->db->where('id', $school_id);
}
if($limit>0){
$this->db->limit($limit);
}
$queryResult = $this->db->get('tbl_schools');
if ($school_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getRecords
* Description : Get all table records
*/
// function getRecords( $id = NULL, $tbl_name='tbl_schools')
// {
// $this->db->select('id, name, description, slug, programme_type, display_order, discipline_image');
// $this->db->order_by('display_order', 'asc');
// $this->db->where('status', '1');
// $this->db->where('is_deleted', '0');
// if($id>0){
// $this->db->where('id', $id);
// }
// $queryResult = $this->db->get($tbl_name);
// if ($id >0) {
// return $queryResult->row_array();
// } else {
// return $queryResult->result_array();
// }
// }
}
Kontol Shell Bypass