ikan Uploader :
Directory : /var/www/html/agusttya.com/application/modules/admin/models/
Upload File : |
| Current File : /var/www/html/agusttya.com/application/modules/admin/models/Common_model.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Common_Model extends CI_Model{
/*
* Function : getAllRecordsGroupBy
*/
public function getAllRecordsGroupBy($tbl_name, $col = '*', $condition=null, $order_by = NULL, $limit=NULL, $start=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->group_by('school_id');
if ($limit !== null && $start !== null) {
$query = $this->db->get($tbl_name,$limit, $start);
} else {
$query = $this->db->get($tbl_name);
}
//echo $this->db->last_query(); die;
$resutls = array();
foreach($query->result_array() as $row){
$resutls[$row['school_id']] = $row['total'];
}
return $resutls;
}
/*
* Function : getAllRecords
*/
public function getAllRecords($tbl_name, $col = ' * ', $condition=null, $order_by = NULL,$limit=NULL, $start=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);
}
}
if ($limit !== null && $start !== null) {
$query = $this->db->get($tbl_name,$limit, $start);
} else {
$query = $this->db->get($tbl_name);
}
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : getAllModuleList
*/
public function getAllModuleList($tbl_name, $col = ' * ', $condition=null, $where_in=NULL, $where_key = 'id')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$this->db->where_in($where_key, $where_in);
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
//$this->db->order_by('display_order', 'asc');
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* 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 : validatelogin
*/
public function validatelogin($tbl_name, $col = ' * ', $condition= array())
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='password'){
$this->db->where($key, md5($val));
} else {
$this->db->where($key, $val);
}
}
}
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row_array();
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_schools', $col = ' * ', $condition='')
{
$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);
return $query->result_array();
}
public function saveinfo($tbl_name='', $post)
{
$this->db->insert($tbl_name, $post);
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));
}
}
/*
* Function: removeAllItems
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function removeAllItems($table_name="", $user_id, $col_name = 'user_id'){
if($user_id>0){
$this->db->where($col_name, $user_id);
$this->db->delete($table_name);
return true;
}
}
/*
* Function: encryptpassword
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
function encryptpassword($plainText)
{
$base64 = base64_encode($plainText);
$base64url = strtr($base64, '+/=', '-_,');
return $base64url;
}
/*
* Function: decryptpassword
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
function decryptpassword($plainText)
{
$base64url = strtr($plainText, '-_,', '+/=');
$base64 = base64_decode($base64url);
return $base64;
}
public function getCommonIdArray($tbl_name='tbl_schools', $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);
}
}
//$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: getCommonSingleRecord
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getCommonSingleRecord($tbl_name='tbl_schools', $col = ' * ', $condition=null)
{
$this->db->select($col);
$this->db->where('status', '1');
$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);
$results = array();
$results = $query->row_array();
return $results;
}
public function getAllRecordscount($tbl_name, $col = ' * ', $condition=null, $order_by = NULL,$limit=NULL, $start=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);
}
}
if ($limit !== null && $start !== null) {
$query = $this->db->get($tbl_name,$limit, $start);
} else {
$query = $this->db->get($tbl_name);
}
//echo $this->db->last_query(); die;
return $query->num_rows();
}
// Function for deletion
public function deleterecords($tbl_name, $id, $field='id'){
if($tbl_name!='' && $id>0){
$sql_query=$this->db->where($field, $id)->delete($tbl_name);
}
}
/*
* Function : deleteRecords
* Description : Delete Record
*/
public function deleteRecordstmp($id, $field_name= 'id', $tbl_name)
{
$this->db->where($field_name, $id);
$data = array();
$data = array('is_deleted'=> '1','status'=>'0');
if (!$this->db->update($tbl_name, $data)) {
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
/*
* Function: setCourseDetails
* Description : set banner details
*/
function setBanners($post)
{
$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_banners', $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_banners', $post)) {
print_r($this->db->error());
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
/*
* Function : getBanners
* Description : Get all banners
*/
function getBanners($banner_id = NULL, $tbl_name = 'tbl_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 : 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 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 : getSections
* Description : Get all sections details
*/
function getSections($tbl_name='tbl_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();
}
}
}
Kontol Shell Bypass