ikan Uploader :
Directory : /var/www/html/www.shardaevents.com/application/models/
Upload File : |
| Current File : /var/www/html/www.shardaevents.com/application/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();
$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);
}
}
$db2->group_by('school_id');
if ($limit !== null && $start !== null) {
$query = $db2->get($tbl_name,$limit, $start);
} else {
$query = $db2->get($tbl_name);
}
//echo $db2->last_query(); die;
$resutls = array();
foreach($query->result_array() as $row){
$resutls[$row['school_id']] = $row['total'];
}
return $resutls;
}
/*
* Function : getRecordsByGroup
*/
public function getRecordsByGroup($tbl_name='', $col = '*', $condition=null, $group_by_column='school_id')
{
$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);
}
}
$db2->group_by($group_by_column);
$query = $db2->get($tbl_name);
//echo $db2->last_query(); die;
$resutls = array();
foreach($query->result_array() as $row){
$resutls[$row[$group_by_column]] = $row['total'];
}
return $resutls;
}
/*
* 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 : getAllGrievanceHistoryRecords
*/
public function getAllGrievanceHistoryRecords($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);
}
}
$dateCond = 'now()-interval 3 month';
$db2->where('lastUpdationDate >=', $dateCond, FALSE);
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 : getAllRecords
*/
public function getAllMonthlyRecords($tbl_name, $col = ' * ', $condition=null, $order_by = 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);
}
}
$db2->where('MONTH(regDate)', date('m'));
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get($tbl_name);
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;
return $query->result_array();
}
/*
* 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 : getSingleRecordObj
*/
public function getSingleRecordObj($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();
}
/*
* Function : getInteraction
*/
public function getInteraction($cond = '', $betweenDate = '')
{
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($cond)) {
foreach($cond as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') >='$from_date'");
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') <='$to_date'");
}
$db2->group_by('mentor_id');
$query = $db2->select("mentor_id, count(*)as total")->get('tbl_create_counselling');
//echo $db2->last_query(); die;
$resp = $query->result_array();
$results = array();
foreach( $resp as $val){
$results[$val['mentor_id']] = $val['total'];
}
return $results;
}
/*
* Function : getMenteeStats
*/
public function getMenteeStats($cond = '')
{
$db2 = $this->load->database('readerdb', TRUE);
if(!empty($cond)) {
foreach($cond as $key=>$val) {
$db2->where($key, $val);
}
}
$db2->group_by('mentor_id');
$query = $db2->select("mentor_id, count(*)as total")->get('tbl_mentee');
//echo $db2->last_query(); die;
$results = array();
foreach($query->result_array() as $val) {
$results[$val['mentor_id']] = $val['total'];
}
return $results;
}
/*
* Function : getMissInteraction
*/
public function getMissInteraction($umid='')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('status', '1');
$db2->where('is_deleted', '0');
$today = date('Y-m-d h:i:s');
$db2->where("DATE_FORMAT(next_appointment, '%Y-%m-%d') <= NOW()");
$db2->where_not_in('counselling_status','3');
$db2->where('mentor_id', $umid);
$db2->order_by('createdon', 'asc');
$query = $db2->select("*")->get('tbl_create_counselling');
//echo $db2->last_query();die;
return $query->result_array();
}
/*
* Function : getUpInteraction
*/
public function getUpInteraction($umid='')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('status', '1');
$db2->where('is_deleted', '0');
$db2->where("DATE_FORMAT(next_appointment, '%Y-%m-%d') >= NOW()");
$db2->where('mentor_id', $umid);
$db2->order_by('next_appointment', 'asc');
$query = $db2->select("*")->get('tbl_create_counselling');
//echo $db2->last_query();die;
return $query->result_array();
}
/*
* Function : getAllNonAcademicComplaintsRecords
*/
public function getAllInteraction($condition=null, $createdon='', $betweenDate = '')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('tbl_create_counselling.is_deleted', '0');
if(!empty($createdon)){
$db2->where("DATE_FORMAT(createdon, '%Y-%m-%d') <= '$createdon'");
}
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='from_date' || $key=='to_date') {
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') >='$val'");
} else {
$db2->where($key, $val);
}
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') >='$from_date'");
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') <='$to_date'");
}
$db2->order_by('tbl_create_counselling.createdon', 'asc');
$query = $db2->join('tbl_mentee', 'tbl_mentee.id = tbl_create_counselling.mente_id');
$query = $db2->join('tbl_admin', 'tbl_admin.id = tbl_create_counselling.mentor_id');
$query = $db2->select("tbl_create_counselling.id,tbl_create_counselling.issue_type, tbl_create_counselling.point_covered, tbl_create_counselling.critically_level, tbl_create_counselling.next_appointment, tbl_create_counselling.school_id,tbl_create_counselling.department_id,tbl_create_counselling.createdon,tbl_create_counselling.mentor_id, tbl_create_counselling.counselling_status , tbl_mentee.full_name, tbl_admin.first_name,tbl_admin.last_name")->get('tbl_create_counselling');
//echo $db2->last_query();die;
return $query->result_array();
}
/*
* Function : getAllVideo
*/
public function getAllVideo($condition=null, $createdon='', $betweenDate = '')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('tbl_library_master.is_deleted', '0');
if(!empty($createdon)){
$db2->where("DATE_FORMAT(createdon, '%Y-%m-%d') <= '$createdon'");
}
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='from_date' || $key=='to_date') {
$db2->where("DATE_FORMAT(tbl_library_master.createdon,'%m/%d/%Y') >='$val'");
} else {
$db2->where($key, $val);
}
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$db2->where("DATE_FORMAT(tbl_library_master.createdon,'%m/%d/%Y') >='$from_date'");
$db2->where("DATE_FORMAT(tbl_library_master.createdon,'%m/%d/%Y') <='$to_date'");
}
$db2->order_by('tbl_library_master.createdon', 'asc');
$query = $db2->join('tbl_campus', 'tbl_campus.id = tbl_library_master.campus_id');
$query = $db2->join('tbl_admin', 'tbl_admin.id = tbl_library_master.author_id');
$query = $db2->select("tbl_library_master.*, , tbl_campus.campus_name, tbl_admin.first_name,tbl_admin.last_name")->get('tbl_library_master');
//echo $db2->last_query();die;
return $query->result_array();
}
/*
* Function : getAllMentorInteraction
*/
public function getAllMentorInteraction($condition=null, $createdon='', $betweenDate = '')
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->where('tbl_create_counselling.is_deleted', '0');
if(!empty($createdon)){
$db2->where("DATE_FORMAT(createdon, '%Y-%m-%d') <= '$createdon'");
}
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
if(!empty($betweenDate))
{
$from_date = $betweenDate['from_date'];
$to_date = $betweenDate['to_date'];
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') >='$from_date'");
$db2->where("DATE_FORMAT(tbl_create_counselling.createdon,'%m/%d/%Y') <='$to_date'");
}
$db2->order_by('tbl_create_counselling.createdon', 'asc');
$query = $db2->join('tbl_mentee', 'tbl_mentee.id = tbl_create_counselling.mente_id');
$query = $db2->join('tbl_admin', 'tbl_admin.id = tbl_create_counselling.mentor_id');
$query = $db2->select("tbl_create_counselling.id,tbl_create_counselling.issue_type, tbl_create_counselling.point_covered, tbl_create_counselling.critically_level, tbl_create_counselling.next_appointment, tbl_create_counselling.school_id,tbl_create_counselling.department_id,tbl_create_counselling.createdon, tbl_create_counselling.status, tbl_mentee.full_name, tbl_admin.first_name,tbl_admin.last_name")->get('tbl_create_counselling');
//echo $db2->last_query();die;
return $query->result_array();
}
/*
* Function : validatelogin
*/
public function validatelogin($tbl_name, $col = ' * ', $condition= array())
{
$time = time();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
if($key=='password'){
$db2->where($key, md5($val));
} else {
$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 : occupationlist
*/
public function occupationlist($tbl_name = 'sh_occupation', $col = ' * ')
{
$time = time();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
$db2->order_by('title', 'asc');
$query = $db2->get($tbl_name);
return $query->result_array();
}
/*
* Function : getAllDoctorsProfile
*/
public function getAllDoctorsProfile($tbl_name = 'doctors_master', $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);
}
}
$db2->order_by('dr_name', 'asc');
$query = $db2->get($tbl_name);
return $query->result_array();
}
/*
* Function : getCommon2Query
*/
public function getCommon2Query($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);
echo $db2->last_query(); die;
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;
}
public function updateProfile($post)
{
$array = array(
'name' => $post['name'],
'phone' => $post['phone'],
'email' => $post['email']
);
if (trim($post['pass']) != '') {
$array['password'] = md5($post['pass']);
}
$this->db->where('id', $post['id']);
$this->db->update('users_public', $array);
}
/*
* 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: getRegisterationDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getRegisterationDetails($id)
{
$db2 = $this->load->database('readerdb', TRUE);
if($id>0){
$db2->select('patient_registration.*,present_address_master.registration_id,present_address_master.house_no,present_address_master.area,present_address_master.country, present_address_master.state, present_address_master.district, present_address_master.taluk, present_address_master.pincode, permanent_address_master.registration_id,permanent_address_master.permanent_house_no,permanent_address_master.permanent_area,permanent_address_master.permanent_country, permanent_address_master.permanent_state, permanent_address_master.permanent_district, permanent_address_master.permanent_taluk, permanent_address_master.permanent_pincode,passport_information.passport_number, passport_information.passport_issue_date, passport_information.passport_expiry_date, passport_information.personal_phone_no,visa_number,visa_issue_date,visa_expiry_date,date_of_arrival,attendant_name,attendant_passport_number,attendant_passport_issue_date,attendant_passport_expiry_date,attendant_personal_phone_no,attendant_visa_number,attendant_visa_issue_date,attendant_visa_expiry_date,attendant_date_of_arrival');
$db2->join('permanent_address_master', 'permanent_address_master.registration_id = patient_registration.id', 'left');
$db2->join('present_address_master', 'present_address_master.registration_id = patient_registration.id', 'left');
$db2->join('passport_information', 'passport_information.registration_id = patient_registration.id', 'left');
$db2->join('visa_information', 'visa_information.registration_id = patient_registration.id', 'left');
$db2->join('attendant_passport_information', 'attendant_passport_information.registration_id = patient_registration.id', 'left');
$db2->join('attendant_visa_information', 'attendant_visa_information.registration_id = patient_registration.id', 'left');
$db2->where('patient_registration.id', $id);
$db2->limit(1);
$query = $db2->get('patient_registration');
//echo $db2->last_query();die;
return $query->row_array();
}
}
/*
* 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;
}
/*
* Function: getSchoolList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getSchoolList($tbl_name='su_schools', $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);
}
}
//$db2->order_by('id', 'asc');
$query = $db2->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row['school_name'];
}
return $results;
}
/*
* Function: getDepartmentList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getDepartmentList($tbl_name='su_departments', $col = ' * ', $condition=null)
{
$db2 = $this->load->database('readerdb', TRUE);
$time = time();
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
//$db2->order_by('id', 'asc');
$query = $db2->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row['name'];
}
return $results;
}
/*
* Function: getFullDepartmentList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getFullDepartmentList($tbl_name='su_departments', $col = ' * ', $condition=null)
{
$db2 = $this->load->database('readerdb', TRUE);
$time = time();
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
//$db2->order_by('id', 'asc');
$query = $db2->get($tbl_name);
$results = array();
foreach($query->result_array() as $row) {
$results[$row['id']] = $row;
}
return $results;
}
/*
* Function: getGrievanceList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getCommonIdArray($tbl_name='tbl_schools', $col = ' * ', $condition=null)
{
$db2 = $this->load->database('readerdb', TRUE);
$time = time();
$db2->select($col);
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
//$db2->order_by('id', 'asc');
$query = $db2->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)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('status', '1');
$db2->where('is_deleted', '0');
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$db2->where($key, $val);
}
}
$query = $db2->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)
{
$db2 = $this->load->database('readerdb', TRUE);
$time = time();
$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->num_rows();
}
// Function for deletion
public function deleterecords($tbl_name, $id){
if($tbl_name!='' && $id>0){
$sql_query=$this->db->where('id', $id)->delete($tbl_name);
}
}
/*
* Function : getAllDigitsNumber
*/
public function getAllDigitsNumber($number)
{
$no_of_digit = 7;
$length = strlen((string)$number);
for($i = $length;$i<$no_of_digit;$i++)
{
$number = '0'.$number;
}
return $number;
}
/*
* Function : getschoolID
*/
public function getschoolID($name_value)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id,school_name, school_code');
$db2->where('is_deleted', '0');
$db2->where('status', '1');
$db2->where('school_name', $name_value);
$query = $db2->get('tbl_schools');
$results = array();
$row = $query->row_array();
$results = $row['id'];
return $results;
}
/*
* Function : getdepartmentID
*/
public function getdepartmentID($name_value)
{
$db2 = $this->load->database('readerdb', TRUE);
$db2->select('id,department_name');
$db2->where('is_deleted', '0');
$db2->where('status', '1');
$db2->where('department_name', $name_value);
$query = $db2->get('tbl_departments');
$results = array();
$row = $query->row_array();
$results = $row['id'];
return $results;
}
/*
* Function: getCommonstatsArray
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getCommonstatsArray($tbl_name='tbl_stats_master', $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);
}
}
//$db2->order_by('id', 'asc');
$query = $db2->get($tbl_name);
$menteesArray = $query->result_array();
$results = array();
foreach($menteesArray as $val) {
$results[$val['admin_id']] = $val;
}
return $results;
}
/*
* Function : getAPIResponse
* Description : send request and get response in JSON format
* Date: 19 Oct 2020
* Created By: Amit Verma
*/
function getAPIResponse($post)
{
$url = 'https://slotbooking.sharda.ac.in/mentorapi/getCommonDetails';
if (!empty($url) && !empty($post)) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, http_build_query($post));
$response = curl_exec($ch);
}
//print_r($response); die;
return $response;
}
/*
* Function : getAllComonInList
*/
public function getAllComonInListwithdaterange($tbl_name, $col = ' * ', $condition=null, $order_by = NULL, $where_in='',$date_from=NULL,$date_to=NULL)
{
$time = time();
$db2 = $this->load->database('readerdb', TRUE);
$db2->select($col);
$db2->where('is_deleted', '0');
if($where_in!=''){
$db2->where_in('grievance_type', $where_in);
}
if(!empty($condition))
{
foreach($condition as $key=>$val) { if($val<>'99') {
$db2->where($key, $val);
}
}
}
if(!empty($date_from) && !empty($date_to))
{
$db2->where('regDate >=', $date_from);
$db2->where('regDate <', $date_to);
//$db2->where("regDate BETWEEN '$date_from' AND '$date_to'");
}
if(!empty($order_by))
{
foreach($order_by as $key=>$val) {
$db2->order_by($key, $val);
}
}
$query = $db2->get($tbl_name);
//echo $db2->last_query(); die;
return $query->result_array();
}
}
Kontol Shell Bypass