ikan Uploader :
Directory : /var/www/html/new-ugenterprises.com/blog/application/models/
Upload File : |
| Current File : /var/www/html/new-ugenterprises.com/blog/application/models/Common_Model.php |
<?php
class Common_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function saveinfo($tbl_name='', $post)
{
$this->db->insert($tbl_name, $post);
//echo $this->db->last_query(); //die;
return $this->db->insert_id();
}
public function updateinfo($tbl_name='', $post, $field, $value)
{
$this->db->where($field, $value);
if (!$this->db->update($tbl_name, $post)) {
log_message('error', print_r($this->db->error(), true));
}
//echo $this->db->last_query(); die;
}
/*
* Function : getSingleRecord
*/
public function getSingleRecord($tbl_name, $col = ' * ', $condition=null)
{
$time = time();
$this->db->select($col);
// $this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row_array();
}
/*
* Function: getCommonIdArray
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getCommonIdArray($tbl_name='tbl_schools', $col = ' * ', $condition=null, $order_by=null)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
if(!empty($order_by))
{
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
//$this->db->order_by('id', 'asc');
$query = $this->db->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row;
}
return $results;
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_school_master', $col = ' * ', $condition='',$order_by='',$condition_like='')
{
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
// Like condition_like
if(!empty($condition_like))
{ $k=1;
foreach($condition_like as $key=>$val) {
$this->db->like($key, $val);
if($k>1) {
$this->db->or_like($key, $val);
}
$k++;
}
}
if(!empty($order_by))
{
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); //die;
return $query->result_array();
}
/*
* Function : deleteRecords
* Description : Delete Record
*/
public function deleteRecords($id, $field_name= 'id', $tbl_name)
{
$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 : deletenrecord
* Description : Delete Record
*/
public function deletenrecord($id, $field_name= 'id', $tbl_name)
{
$this->db->trans_begin();
$this->db->where($field_name, $id)->delete($tbl_name);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
show_error(lang('database_error'));
} else {
$this->db->trans_commit();
}
}
/*
* Function : updateRecords
* Description : Update Record
*/
public function updateRecords($tbl_name='su_consultancy', $id, $field_name= 'id')
{
$this->db->where($field_name, $id);
$data = array();
$data = array('approval'=> '1', 'status'=> '1','is_deleted'=> '0','approved_by'=>'Dean','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 : getCommonRecords
* Description : Get all table records
*/
function getCommonRecords( $id = NULL, $tbl_name='su_videos', $limit=0, $order_by='')
{
$this->db->select('*');
$this->db->where('is_deleted', '0');
if($id>0){
$this->db->where('id', $id);
}
if($order_by!='') {
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
if($limit>0){
$this->db->limit($limit);
}
$queryResult = $this->db->get($tbl_name);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function: setCourseDetails
* Description : set banner details
*/
function setBanners($post, $tbl_name='su_banners')
{
if($post['banner_url']!=''){
$post['banner_url'] = str_replace(' ','-',$post['banner_url']);
} // Replace space with -
if ($post['edit'] > 0) {
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['id']);
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'));
}
}
}
/*
* Function : getCourses
* Description : Get all courses details
*/
function getCourses( $course_id = NULL) {
$this->db->select('su_courses.id, course_name, programme_name,programme_type,course_description, course_url, course_code, su_courses.display_order, su_courses.status');
$this->db->from('su_courses');
$this->db->join('su_programme', 'su_courses.programme_type = su_programme.id');
$this->db->order_by('su_courses.display_order', 'asc');
$this->db->order_by('su_courses.course_name', 'asc');
$this->db->where('su_courses.is_deleted', '0');
if($course_id>0){
$this->db->where('su_courses.id', $course_id);
}
$queryResult = $this->db->get();
if ($course_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getBanners
* Description : Get all banners
*/
function getBanners($banner_id = NULL, $tbl_name = 'su_banners')
{
$this->db->select('*');
$this->db->order_by('display_order', 'asc');
$this->db->where('is_deleted', '0');
if($banner_id>0){
$this->db->where('id', $banner_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get($tbl_name);
if ($banner_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getWebSearchRecords
* Description : Get all records
*/
function getWebSearchRecords($tbl_name = 'su_search_records',$limit = NULL, $page = NULL)
{
$this->db->select('*');
$this->db->order_by('id', 'desc');
$this->db->where('delete_status', '0');
$queryResult = $this->db->get($tbl_name,$limit, $page);
return $queryResult->result_array();
}
/*
* Function : getSearchRecords
* Description : Get all records
*/
function getSearchRecords($tbl_name = 'su_website_search_tags',$limit = NULL, $page = NULL)
{
$this->db->order_by('su_website_search.title', 'asc');
$this->db->where('su_website_search_tags.is_deleted', '0');
$this->db->join('su_website_search', 'su_website_search.re_id = su_website_search_tags.search_id');
$queryResult = $this->db->select('su_website_search.title, su_website_search_tags.id, su_website_search_tags.tags, su_website_search_tags.search_id, su_website_search_tags.status')->get('su_website_search_tags', $limit, $page);
return $queryResult->result_array();
}
/*
* Function : getDeanDetailsArray
*/
public function getDeanDetailsArray($tbl_name = 'su_faculties', $school_id)
{
$this->db->select('id, name, school_id, email_id, contact_no, status');
$this->db->order_by('display_order', 'asc');
$this->db->where('is_deleted', '0');
if($school_id>0){
$this->db->where('school_id', $school_id);
}
$queryResult = $this->db->get($tbl_name);
if ($school_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : setRecords
* Description : Insert/Update the records based on id
*/
function setRecords($post, $tbl_name = 'NULL')
{
if ($post['edit'] > 0) {
$this->db->where('id', $post['edit']);
unset($post['edit']);
unset($post['id']);
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'));
}
return $id = $post['edit'];
} 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'));
}
return $id = $this->db->insert_id();
}
}
/*
* Function : getRecords
* Description : Get all table records
*/
function getRecords( $id = NULL, $tbl_name='su_videos', $order_by, $search_filter,$limit=NULL, $page=NULL)
{
$this->db->select('*');
if($order_by!=''){
foreach($order_by as $key=>$val)
{
$this->db->order_by($key,$val);
}
} else {
$this->db->order_by('display_order', 'asc');
}
$this->db->where('is_deleted', '0');
if($id>0){
$this->db->where('id', $id);
}
if(!empty($search_filter))
{
foreach($search_filter as $key=>$value){
$this->db->where($key, $value);
}
}
//$this->db->limit($limit);
$queryResult = $this->db->get($tbl_name,$limit, $page);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getAllRecords
* Description : Get all table records
*/
function getAllRecords($tbl_name='su_videos', $order_by, $search_filter, $key, $value)
{
$this->db->select('*');
if($order_by!=''){
$this->db->order_by($order_by);
} else {
$this->db->order_by('display_order', 'asc');
}
$this->db->where('is_deleted', '0');
if($key!='' && $value>0){
$this->db->where($key, $value);
}
if(!empty($search_filter))
{
foreach($search_filter as $key=>$value){
$this->db->where($key, $value);
}
}
//$this->db->limit($limit);
$queryResult = $this->db->get($tbl_name);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getCustomFiles
* Description : Get all table records
*/
function getCustomFiles( $id = NULL, $tbl_name='su_customfiles')
{
$this->db->select('*');
$this->db->where('is_deleted', '0');
if($id>0){
$this->db->where('id', $id);
}
$this->db->order_by('id', 'desc');
$queryResult = $this->db->get($tbl_name);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getDepartments
* Description : Get all Departments details
*/
function getDepartments( $school_id = NULL) {
$this->db->select('id,name,status');
$this->db->order_by('name', 'asc');
$this->db->where('is_deleted', '0');
$this->db->where('status', '1');
if($school_id>0){
$this->db->where('school_id', $school_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('su_departments');
return $queryResult->result_array();
}
/*
* Function : getRTDCDepartments
* Description : Get all RTDC Departments details
*/
function getRTDCDepartments( $school_id = NULL) {
$this->db->select('id,name,status');
$this->db->order_by('name', 'asc');
$this->db->where('is_deleted', '0');
$this->db->where('status', '1');
if($school_id>0){
$this->db->where('school_id', $school_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('su_rtdc');
return $queryResult->result_array();
}
/*
* Function : getIQACDepartments
* Description : Get all IQAC Departments details
*/
function getIQACDepartments( $school_id = NULL) {
$this->db->select('id,name,status');
$this->db->order_by('name', 'asc');
$this->db->where('is_deleted', '0');
$this->db->where('status', '1');
if($school_id>0){
$this->db->where('school_id', $school_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('su_iqac_departments');
return $queryResult->result_array();
}
/*
* 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('su_schools');
if ($school_id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getDisciplineRecords
* Description : Get all records
*/
function getDisciplineRecords( $discipline_id = NULL) {
$this->db->select('id, name,status');
$this->db->order_by('name', 'asc');
$this->db->where('is_deleted', '0');
if($discipline_id>0){
$this->db->where('id', $discipline_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('su_discipline');
if ($discipline_id >0) {
return $queryResult->row_array();
} else {
$resp = $queryResult->result_array();
$results = array();
foreach($resp as $val) {
$results[$val['id']] = $val;
}
return $results;
}
}
/*
* Function : getCourseRecords
* Description : Get all records
*/
function getCourseRecords( $course_id = NULL) {
$this->db->select('id, course_name,school_id,status');
$this->db->order_by('course_name', 'asc');
$this->db->where('is_deleted', '0');
if($course_id>0){
$this->db->where('id', $course_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('su_courses');
if ($course_id >0) {
return $queryResult->row_array();
} else {
$resp = $queryResult->result_array();
$results = array();
foreach($resp as $val) {
$results[$val['id']] = $val;
}
return $results;
}
}
/*
* Function : getProgrammeRecords
* Description : Get all records
*/
function getProgrammeRecords( $programme_id = NULL, $menu_id='1') {
$this->db->select('id, programme_name, status');
$this->db->order_by('programme_name', 'asc');
$this->db->where('is_deleted', '0');
$this->db->where('menu_id', $menu_id);
if($programme_id>0){
$this->db->where('id', $programme_id);
}
//$this->db->limit($limit);
$queryResult = $this->db->get('su_menu_programme');
if ($programme_id >0) {
return $queryResult->row_array();
} else {
$resp = $queryResult->result_array();
$results = array();
foreach($resp as $val) {
$results[$val['id']] = $val;
}
return $results;
}
}
/*
* Function : getSections
* Description : Get all sections details
*/
function getSections($tbl_name='su_happenings')
{
$this->db->select('*');
$this->db->order_by('id', 'asc');
$this->db->order_by('display_order', 'asc');
$this->db->where('status', '1');
$this->db->where('section', '7');
$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 : getEvents
* Description : Get all sections details
*/
function getEvents($tbl_name='su_eventdetails')
{
$this->db->select('*');
$this->db->order_by('id', 'asc');
$this->db->order_by('display_order', 'asc');
$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 : getRegistrationsMalawiRecords
* Description : Get all table records
*/
function getRegistrationsMalawiRecords( $id = NULL, $tbl_name='registrations', $search_array, $limit, $page, $search_like)
{
$this->db->select('*');
$this->db->order_by('id', 'desc');
if($id>0){
$this->db->where('id', $id);
}
if(!empty($search_array)) {
foreach($search_array as $key=>$val)
{
$this->db->where($key, $val);
}
}
// like search
if ($search_like != null) {
$search_like = trim($this->db->escape_like_str($search_like));
$this->db->where("(createdon LIKE '%$search_like%')");
}
$this->db->where('is_deleted', '0');
//$this->db->limit($limit);
$queryResult = $this->db->get($tbl_name,$limit, $page);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : getRegistrationsRecords
* Description : Get all table records
*/
function getRegistrationsRecords( $id = NULL, $tbl_name='registrations', $search_array, $limit, $page, $search_like)
{
$this->db->select('*');
$this->db->order_by('id', 'desc');
if($id>0){
$this->db->where('id', $id);
}
if(!empty($search_array)) {
foreach($search_array as $key=>$val)
{
$this->db->where($key, $val);
}
}
// like search
if ($search_like != null) {
$search_like = trim($this->db->escape_like_str($search_like));
$this->db->where("(created LIKE '%$search_like%')");
}
$this->db->where('is_deleted', '0');
//$this->db->limit($limit);
$queryResult = $this->db->get($tbl_name,$limit, $page);
if ($id >0) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
function getConsultancyRecords($tbl_name='su_videos', $whereCond = '', $limit=0, $order_by='')
{
$this->db->select('*');
$this->db->where('is_deleted', '0');
if(!empty($whereCond)){
foreach($whereCond as $key=>$val) {
$this->db->where($key, $val);
}
}
if($order_by!='') {
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
if($limit>0){
$this->db->limit($limit);
}
$queryResult = $this->db->get($tbl_name);
if (!empty($whereCond)) {
return $queryResult->row_array();
} else {
return $queryResult->result_array();
}
}
/*
* Function : updateRecords
* Description : Update Record
*/
public function updateCommonRecords($tbl_name='su_consultancy', $cond='', $data = '')
{
$this->db->where('id', $cond);
if (!$this->db->update($tbl_name, $data)) {
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
Kontol Shell Bypass