ikan Uploader :
Directory : /var/www/html/agusttya.com/blog/application/models/
Upload File : |
| Current File : /var/www/html/agusttya.com/blog/application/models/Home_Model.php |
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
Class Home_Model extends CI_Model{
/*
* 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 : getAllCategoryWiseBlogList
*/
public function getAllCategoryWiseBlogList($tbl_name, $col = ' * ', $condition=null, $where_in=NULL)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$wArray = explode(',',$where_in);
if(!empty($wArray))
{ $wIn = array();
foreach($wArray as $val) {
$wIn[] = "category_id IN( $val )";
}
$finalQuery = implode(' OR ', $wIn);
$this->db->where($finalQuery);
}
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$this->db->order_by('blog_date', 'RANDOM');
$query = $this->db->get($tbl_name,3, 0);
//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;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row;
}
return $results;
}
/*
* 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 : registrationCount
*/
public function registrationCount($tbl_name = 'patient_registration')
{
$result = $this->db->query("SELECT id FROM ".$tbl_name." where is_deleted='0'");
return $result->num_rows();
}
/*
* Function : countrylist
*/
public function countrylist($tbl_name = 'su_country', $col = ' * ')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$this->db->order_by('country_name', 'asc');
$query = $this->db->get($tbl_name);
return $query->result_array();
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_blogs', $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);
//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: getAllPopularBlogRecords
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllPopularBlogRecords($id='', $condition = '')
{
$this->db->select('tbl_blogs.*');
if($id>0){
$this->db->where('tbl_blogs.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->like($key, $val);
}
}
$this->db->where('tbl_blogs.hit_count>0');
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blogs.status', '1');
$this->db->limit(10);
//$this->db->get('tbl_event_master',$limit,$start);
$this->db->order_by('tbl_blogs.hit_count', 'desc');
$query = $this->db->get('tbl_blogs');
//echo $this->db->last_query();die;
return $query->result_array();
}
/*
* Function: getRegisterationDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllEventsBannerRecords($id='', $condition = '', $limit=NULL, $start=NULL, $image=NULL)
{
$this->db->select('tbl_blogs.*');
if($id>0){
$this->db->where('tbl_blogs.id', $id);
}
if($image>0){
$this->db->where('tbl_blogs.blog_image<>""');
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->where($key, $val);
}
}
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blogs.status', '1');
$this->db->order_by('tbl_blogs.blog_date', 'desc');
if ($limit !='') {
//echo $limit.','. $start; die;
$query = $this->db->get('tbl_blogs',$limit, $start);
} else {
$query = $this->db->get('tbl_blogs');
}
//echo $this->db->last_query();
return $query->result_array();
}
/*
* Function: getRegisterationDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllEventsRecords($id='', $condition = '', $limit=NULL, $start=NULL)
{
$this->db->select('tbl_blogs.*');
if($id>0){
$this->db->where('tbl_blogs.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->like($key, $val);
}
}
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blogs.status', '1');
$this->db->order_by('tbl_blogs.blog_date', 'desc');
if ($limit !='') {
//echo $limit.','. $start; die;
$query = $this->db->get('tbl_blogs',$limit, $start);
} else {
$query = $this->db->get('tbl_blogs');
}
//echo $this->db->last_query();
return $query->result_array();
}
/*
* Function: getSingleEventDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getSingleEventDetails($id='', $condition = '')
{
$this->db->select('tbl_blogs.*');
// $this->db->select('tbl_event_master.*, tbl_schools.school_name,tbl_event_date_time.start_date,tbl_event_date_time.start_time, tbl_event_date_time.end_date,tbl_event_date_time.end_time,tbl_event_date_time.time_zone,tbl_event_location_details.venue_name,tbl_event_organizer_contactinfo.contact_name,tbl_event_organizer_contactinfo.phone,tbl_event_organizer_contactinfo.email,tbl_event_organizer_contactinfo.website_url');
// $this->db->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
// $this->db->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
// $this->db->join('tbl_event_organizer_contactinfo', 'tbl_event_organizer_contactinfo.event_id = tbl_event_master.id', 'left');
// $this->db->join('tbl_event_location_details', 'tbl_event_location_details.event_id = tbl_event_master.id', 'left');
if($id>0){
$this->db->where('tbl_blogs.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->like($key, $val);
}
}
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blogs.status', '1');
$query = $this->db->get('tbl_blogs');
//echo $this->db->last_query();die;
return $query->row_array();
}
/*
* Function : getAllCategoryList
*/
public function getAllCategorySlugs()
{
$this->db->select("count(tbl_blogs.id) as total, tbl_blog_category.slug");
$this->db->join('tbl_blogs', 'tbl_blogs.category_id = tbl_blog_category.id', 'left');
$this->db->where('tbl_blog_category.is_deleted', '0');
$this->db->where('tbl_blog_category.status', '1');
$this->db->group_by('slug');
$this->db->having('count(tbl_blogs.id)>', 0);
$this->db->limit('20');
$query = $this->db->get('tbl_blog_category');
//echo $this->db->last_query();die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['slug']] = $row;
}
return $results;
//return $query->result_array();
}
/*
* Function : getAllCategoryList
*/
public function getAllCategoryList()
{
$this->db->select("count(tbl_blogs.id) as total, tbl_blog_category.category_name");
$this->db->join('tbl_blogs', 'tbl_blogs.category_id = tbl_blog_category.id', 'left');
$this->db->where('tbl_blog_category.is_deleted', '0');
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blog_category.status', '1');
$this->db->group_by('category_name');
$this->db->having('count(tbl_blogs.id)>', 0);
$this->db->limit('20');
$query = $this->db->get('tbl_blog_category');
//echo $this->db->last_query();die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['category_name']] = $row;
}
return $results;
//return $query->result_array();
}
/*
* Function : getAllTagSlugList
*/
public function getAllTagSlugList()
{
$this->db->select('count(tbl_blogs.id) as total,tbl_blog_tags.slug');
$this->db->join('tbl_blogs', 'tbl_blogs.tag_id = tbl_blog_tags.id', 'left');
$this->db->where('tbl_blog_tags.is_deleted', '0');
$this->db->where('tbl_blog_tags.status', '1');
$this->db->group_by('slug');
$this->db->having('count(tbl_blogs.id)>', 0);
$this->db->limit('20');
$query = $this->db->get('tbl_blog_tags');
//echo $this->db->last_query();die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['slug']] = $row;
}
return $results;
//return $query->result_array();
}
/*
* Function : getAllTagList
*/
public function getAllTagList()
{
$this->db->select('count(tbl_blogs.id) as total, tbl_blog_tags.tag_name');
$this->db->join('tbl_blogs', 'tbl_blogs.tag_id = tbl_blog_tags.id', 'left');
$this->db->where('tbl_blog_tags.is_deleted', '0');
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blog_tags.status', '1');
$this->db->group_by('tag_name');
$this->db->having('count(tbl_blogs.id)>', 0);
$this->db->limit('20');
$query = $this->db->get('tbl_blog_tags');
//echo $this->db->last_query();die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['tag_name']] = $row;
}
return $results;
//return $query->result_array();
}
// get rows from tbl_event_reports
public function getRows(){
$this->db->select('*');
$this->db->from('tbl_event_report');
$this->db->where('status','1');
}
public function getAlldata($id){
$this->db->select("tbl_event_report.id,tbl_event_report.event_id,tbl_event_report.report,tbl_event_report.verified_dm,tbl_event_master.*");
$this->db->join('tbl_event_report', 'tbl_event_report.event_id = tbl_event_master.id');
$this->db->where('tbl_event_master.id',$id);
$query = $this->db->get('tbl_event_master');
//echo $this->db->last_query(); die;
$results = array();
$row = $query->row_array();
foreach ($query->result() as $row)
{
$results['id']=$row->id;
$results['event_id']=$row->event_id;
$results['report']=$row->report;
$results['verified_dm']=$row->verified_dm;
}
//print_r($results);die;
return $results;
}
/*
* Function : set_counter
*
*/
public function set_counter($id)
{
if($id>0)
{
$sql = "UPDATE tbl_blogs SET hit_count = hit_count + 1 WHERE id = ".$id;
$this->db->query($sql);
}
}
public function getCount($id='', $condition = '')
{
$this->db->select('tbl_blogs.*');
// $this->db->select('tbl_event_master.*, tbl_schools.school_name,tbl_event_date_time.start_date,tbl_event_date_time.start_time, tbl_event_date_time.end_date,tbl_event_date_time.end_time');
// $this->db->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
// $this->db->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$this->db->where('tbl_blogs.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$this->db->like($key, $val);
}
}
$this->db->where('tbl_blogs.is_deleted', '0');
$this->db->where('tbl_blogs.status', '1');
//$this->db->limit($limit,$offset);
$query = $this->db->get('tbl_blogs');
//echo $this->db->last_query();die;
return $query->num_rows();
}
}
Kontol Shell Bypass