ikan Uploader :
Directory : /var/www/html/shardawelfarefoundation.org/application/modules/admin/models/
Upload File : |
| Current File : /var/www/html/shardawelfarefoundation.org/application/modules/admin/models/Happenings_model.php |
<?php
class Happenings_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
/*
* Function : deleteRecords
* Description : Delete Records
*/
public function deleteRecords($id, $field_name= 'id', $tbl_name = 'tbl_happenings')
{
$this->db->where($field_name, $id);
$data = array();
$data = array('is_deleted'=> '1','status'=>'0','updated'=>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 : getSchools
* Description : Get all schools details
*/
function getSchools( $school_id = NULL)
{
$this->db->select('id, school_name, school_url, school_code, display_order, 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);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('tbl_schools');
if ($school_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getAllSections
* Description : Get all sections details
*/
function getAllSections($tbl_name='tbl_happenings_sections', $limit = NULL)
{
$this->db->select('*');
$this->db->where('is_deleted', '0');
if ($limit != NULL) {
$this->db->limit($limit);
}
$queryResult = $this->db->get($tbl_name);
return $queryResult->result_array();
}
/*
* Function : getSections
* Description : Get all sections details
*/
function getSections($tbl_name, $sections_id = NULL, $limit = NULL)
{
$this->db->select('*');
$this->db->where('status', '1');
$this->db->where('is_deleted', '0');
if($sections_id>0){
$this->db->where('id', $sections_id);
}
if ($limit != NULL) {
$this->db->limit($limit);
}
$queryResult = $this->db->get($tbl_name);
if ($sections_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getHappenings
* Description : Get all happening details
*/
function getHappenings( $happening_id = NULL, $limit = NULL)
{
$this->db->select('*');
$this->db->where('is_deleted', '0');
if($happening_id>0){
$this->db->where('id', $happening_id);
}
$this->db->order_by('news_date', 'desc');
$this->db->order_by('display_order', 'asc');
if ($limit != NULL) {
$this->db->limit($limit);
}
$queryResult = $this->db->get('tbl_happenings');
if ($happening_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : setHappenings
*/
function setSections($post)
{
$post['slug'] = str_replace(' ','-',$post['slug']); // Replace space with -
unset($post['submit']);
if ($post['id'] > 0) {
$this->db->where('id', $post['id']);
unset($post['edit']);
unset($post['id']);
if (!$this->db->update('tbl_happenings_sections', $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_happenings_sections', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : setHappenings
*/
function setHappenings($post)
{
$post['slug'] = str_replace(' ','-',$post['slug']); // Replace space with -
unset($post['submit']);
if($post['happening_image']=='') { $post['happening_image'] = $post['old_image']; }
unset($post['old_image']);
if($post['pdf_name']=='') { $post['pdf_name'] = $post['old_pdf']; }
unset($post['old_pdf']);
if($post['pdf_name1']=='') { $post['pdf_name1'] = $post['old_pdf1']; }
unset($post['old_pdf1']);
if($post['pdf_name2']=='') { $post['pdf_name2'] = $post['old_pdf2']; }
unset($post['old_pdf2']);
$post['school_id'] = implode(',',$post['school_id']);
if ($post['id'] > 0) {
$this->db->where('id', $post['id']);
unset($post['edit']);
unset($post['id']);
$post['updated'] = date('Y-m-d');
if (!$this->db->update('tbl_happenings', $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']);
$post['created'] = date('Y-m-d');
if (!$this->db->insert('tbl_happenings', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : getSectionsList
*/
function getSectionsList($tbl_name)
{
$sectionArray = $this->getSections($tbl_name);
$response = array();
foreach($sectionArray as $section)
{
$response['section'][$section['id']] = $section['section_name'];
$response['type'][$section['id']] = $section['section_type'];
}
return $response;
}
// Function for deletion
public function delete_records($tbl_name, $id){
if($tbl_name!='' && $id>0){
$sql_query=$this->db->where('id', $id)->delete($tbl_name);
}
}
}
Kontol Shell Bypass