ikan Uploader :
Directory : /var/www/html/www.shardaevents.com/application/models/
Upload File : |
| Current File : /var/www/html/www.shardaevents.com/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();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
if ($limit !== null && $start !== null) {
$query = $db2->get($tbl_name,$limit, $start);
} else {
$query = $db2->get($tbl_name);
}
//echo $db2->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();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
$db2->where_in($where_key, $where_in);
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
//$db2->order_by('display_order', 'asc');
$query = $db2->get($tbl_name);
//echo $db2->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();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
$query = $db2->get($tbl_name);
//echo $db2->last_query(); die;
return $query->row_array();
}
/*
* Function : registrationCount
*/
public function registrationCount($tbl_name = 'patient_registration')
{
$db2 = $this->load->database('readerdb', TRUE);
$result = $db2->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();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
$db2->order_by('country_name', 'asc');
$query = $db2->get($tbl_name);
return $query->result_array();
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'tbl_schools', $col = ' * ', $condition='')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
$query = $db2->get($tbl_name);
return $query->result_array();
}
public function saveinfo($tbl_name='', $post)
{
$this->db->insert($tbl_name, $post);
//echo $db2->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: getAllUpcomingEventsRecords
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllUpcomingEventsRecords($id='', $condition = '', $limit=NULL, $start=NULL)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
$tomorrow = date('Y-m-d',strtotime($date1 . "+5 days"));
$db2->where('tbl_event_date_time.start_date>'.strtotime($tomorrow));
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
$db2->where('tbl_event_master.verified_iqac', '1');
//$db2->limit(30);
if ($limit !='') {
//echo $limit.','. $start; die;
$query = $db2->get('tbl_event_master',$limit, $start);
} else {
$query = $db2->get('tbl_event_master');
}
#echo $db2->last_query(); die;
return $query->result_array();
}
/*
* Function: getAllPastEventsRecords
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getAllPastEventsRecords($id='', $condition = '', $limit=NULL, $start=NULL)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
$yesterday = date('Y-m-d',strtotime($date1 . "-1 days"));
$db2->where('tbl_event_date_time.end_date<'.strtotime($yesterday));
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
$db2->where('tbl_event_master.verified_iqac', '1');
//$db2->limit(30);
if ($limit !='') {
//echo $limit.','. $start; die;
$query = $db2->get('tbl_event_master',$limit, $start);
} else {
$query = $db2->get('tbl_event_master');
}
#echo $db2->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)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('tbl_event_master.id,tbl_event_master.campus_id,tbl_event_master.event_title,tbl_event_master.event_slug,tbl_event_master.categories,tbl_event_master.event_details,tbl_event_master.banner_image,tbl_event_master.upload_report,tbl_event_master.upload_1,tbl_event_master.objective_of_event,tbl_event_master.target_audiences,tbl_event_master.media_coverage,tbl_event_master.organizing_school,tbl_event_master.organizing_departments,tbl_event_master.convener_details,coordinator_details,event_budget, 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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
//$db2->limit(30);
$db2->order_by('tbl_event_date_time.start_date', 'desc');
if ($limit !='') {
//echo $limit.','. $start; die;
$query = $db2->get('tbl_event_master',$limit, $start);
//echo $db2->last_query(); die;
} else {
$query = $db2->get('tbl_event_master');
}
//echo $db2->last_query();
return $query->result_array();
}
public function getAllEventsLikeRecords($id='', $condition = '', $limit=NULL, $start=NULL, $keyword=NULL)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
if(!empty($keyword)){
$db2->like('tbl_event_master.event_slug',$keyword);
$db2->or_like('tbl_event_master.event_title',$keyword);
$db2->or_like('tbl_event_master.event_details',$keyword);
}
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
//$db2->limit(30);
$db2->order_by('tbl_event_date_time.start_date', 'desc');
if ($limit !='') {
//echo $limit.','. $start; die;
$query = $db2->get('tbl_event_master',$limit, $start);
//echo $db2->last_query(); die;
} else {
$query = $db2->get('tbl_event_master');
}
//echo $db2->last_query();
return $query->result_array();
}
// public function getAllEventsRecords($id='', $condition = '')
// {
// $db2->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');
// $db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
// $db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
// if($id>0){
// $db2->where('tbl_event_master.id', $id);
// }
// if(!empty($condition)){
// foreach($condition as $key=>$val){
// $db2->like($key, $val);
// }
// }
// $db2->where('tbl_event_master.is_deleted', '0');
// $db2->where('tbl_event_master.status', '4');
// $db2->limit(30);
// //$db2->get('tbl_event_master',$limit,$start);
// $query = $db2->get('tbl_event_master');
// //echo $db2->last_query();die;
// return $query->result_array();
// }
/*
* Function: getSingleEventDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getSingleEventDetails($id='', $condition = '')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
$db2->join('tbl_event_organizer_contactinfo', 'tbl_event_organizer_contactinfo.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_event_location_details', 'tbl_event_location_details.event_id = tbl_event_master.id', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
$query = $db2->get('tbl_event_master');
//echo $db2->last_query();die;
return $query->row_array();
}
/*
* Function : getAllCategoryList
*/
public function getAllCategoryList()
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select("count(tbl_event_master.id) as total, tbl_category.category_name ");
$db2->join('tbl_event_master', 'tbl_event_master.categories = tbl_category.id', 'left');
$db2->where('tbl_category.is_deleted', '0');
$db2->where('tbl_category.status', '1');
$db2->group_by('category_name');
$db2->having('count(tbl_event_master.id)>', 0);
$db2->limit('20');
$query = $db2->get('tbl_category');
//echo $db2->last_query();die;
$results = array();
foreach($query->result_array() as $row) {
$results[$row['category_name']] = $row;
}
return $results;
//return $query->result_array();
}
/*
* Function : getAllTagList
*/
public function getAllTagList()
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('count(tbl_event_master.id) as total, tbl_tags.tag_name');
$db2->join('tbl_event_master', 'tbl_event_master.tags = tbl_tags.id', 'left');
$db2->where('tbl_tags.is_deleted', '0');
$db2->where('tbl_tags.status', '1');
$db2->group_by('tag_name');
$db2->having('count(tbl_event_master.id)>', 0);
$db2->limit('20');
$query = $db2->get('tbl_tags');
//echo $db2->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(){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('*');
$db2->from('tbl_event_report');
$db2->where('status','1');
}
public function getAlldata($id){
$db2 = $this->load->database('readerdb', TRUE);
$db2->select("tbl_event_report.id,tbl_event_report.event_id,tbl_event_report.report,tbl_event_report.verified_dm,tbl_event_master.*");
$db2->join('tbl_event_report', 'tbl_event_report.event_id = tbl_event_master.id');
$db2->where('tbl_event_master.id',$id);
$query = $db2->get('tbl_event_master');
//echo $db2->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 : getTotalAllEventsCount
*/
public function getTotalAllEventsCount($id='', $condition = '')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
$db2->where('tbl_event_master.verified_iqac', '1');
//$db2->limit($limit,$offset);
//$db2->limit(300);
$query = $db2->get('tbl_event_master');
//echo $db2->last_query();die;
return $query->num_rows();
}
/*
* Function : getTotalEventsCount
*/
public function getTotalEventsCount($id='', $condition = '')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
$db2->where('tbl_event_master.verified_iqac', '1');
//$db2->limit($limit,$offset);
$db2->limit(300);
$query = $db2->get('tbl_event_master');
//echo $db2->last_query();die;
return $query->num_rows();
}
/*
* Function : getTotalEventsLikeCount
*/
public function getTotalEventsLikeCount($id='', $condition = '', $keyword='')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->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');
$db2->join('tbl_event_date_time', 'tbl_event_date_time.event_id = tbl_event_master.id', 'left');
$db2->join('tbl_schools', 'tbl_schools.id = tbl_event_master.organizing_school', 'left');
if($id>0){
$db2->where('tbl_event_master.id', $id);
}
if(!empty($condition)){
foreach($condition as $key=>$val){
$db2->like($key, $val);
}
}
if(!empty($keyword)){
$db2->like('tbl_event_master.event_slug',$keyword);
$db2->or_like('tbl_event_master.event_title',$keyword);
$db2->or_like('tbl_event_master.event_details',$keyword);
}
$db2->where('tbl_event_master.is_deleted', '0');
$db2->where('tbl_event_master.status', '4');
$db2->where('tbl_event_master.verified_iqac', '1');
//$db2->limit($limit,$offset);
$db2->limit(300);
$query = $db2->get('tbl_event_master');
//echo $db2->last_query();die;
return $query->num_rows();
}
}
Kontol Shell Bypass