ikan Uploader :
Directory : /var/www/html/shardahospital.org/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/application/models/Health_library_model.php |
<?php
Class Health_Library_Model extends CI_Model{
protected $table_name = 'SH_HealthLibrary';
protected $primary_key = 'HealthConditionID';
protected $order_by = 'HealthConditionPriorityOrder DESC, HealthConditionTitle ASC';
protected $fields_detail = 'HealthConditionID, LEFT(`HealthConditionTitle`,1) as Alpha, HealthConditionTitle, HealthConditionCommonName, HealthConditionDepartment,
HealthConditionOverview, HealthConditionSymptoms, HealthConditionCauses, HealthConditionTreatment,
HealthConditionRelatedConditions, HealthConditionSearchTags, HealthConditionThumbnail, HealthConditionBanner,
HealthConditionPriorityOrder, HealthConditionPageURL, SH_HealthLibrary.Status';
protected $fields_summary = 'HealthConditionID, HealthConditionTitle, HealthConditionOverview,
HealthConditionThumbnail, HealthConditionPageURL';
Public function __construct()
{
parent::__construct();
}
function get_health_condition($id){
return $this->db->get_where($this->table_name, array($this->primary_key => $id))->row_array();
}
function get_health_condition_by_slug($slug){
return $this->db->get_where($this->table_name, array('HealthConditionPageURL' => $slug))->row_array();
}
function get_health_condition_id($slug){
$this->db->select('HealthConditionID');
return $this->db->get_where($this->table_name, array('HealthConditionPageURL' => $slug))->row_array();
}
function get_health_condition_by_name($name){
return $this->db->get_where($this->table_name, array('HealthConditionTitle' => $name))->result_array();
}
function get_related_health_conditions($id, $status = ''){
$this->db->select('A.*');
$this->db->where('B.HealthCondition', $id);
if ($status != '') {
$this->db->where('A.Status', $status);
}
$this->db->join($this->table_name.' B', 'FIND_IN_SET(A.HealthConditionID, B.HealthConditionRelatedCondition)!=0');
$this->db->from($this->table_name.' A');
$Query = $this->db->get();
/* $this->db->select(A.*);
$this->db->where('B.HealthCondition', $id);
$this->db->where('FIND_IN_SET(A.HealthConditionID, B.HealthConditionRelatedCondition)!=',0);
$this->db->from($this->table.' B'); */
$Query = $this->db->get();
$result = $Query->result_array();
$Query->free_result();
return $result;
// select A.* from $this->table_name A, $this->table_name B where B.HealthConditionID=$id AND FIND_IN_SET(A.HealthConditionID, B.HealthConditionRelatedCondition);
}
function get_first_chars(){
$Query = $this->db->query('Select DISTINCT LEFT(`HealthConditionTitle`,1) as `alpha` from SH_HealthLibrary');
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function get_health_conditions_by_alphabet($alpha='A'){
$Query = $this->db->query('Select * from SH_HealthLibrary where LEFT(`HealthConditionTitle`,1)="'.$alpha.'"');
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function get_distinct_alpha(){
$this->db->select('LEFT(`HealthConditionTitle`,1)');
$this->db->distinct();
$query = $this->db->get('SH_HealthLibrary');
$result = $query->result_array();
$query->free_result();
return $result;
}
//get all health conditions
function get_health_conditions($fields = '', $department_id = '', $condition_id = '', $where = array(), $order_by = '', $status = '',$distinct=''){
if ($fields != '') {
$this->db->select($fields);
}
else{
$this->db->select($this->fields_detail);
}
if($order_by != ''){
$this->db->order_by($order_by);
}
else{
$this->db->order_by($this->order_by);
}
if ($status != '') {
$this->db->where('A.Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
if($department_id){
$this->db->where('FIND_IN_SET('.$department_id.', HealthConditionDepartment)!=',0);
}
if($condition_id){
$this->db->where('FIND_IN_SET('.$condition_id.', HealthConditionService)!=',0);
}
// $this->db->join('SH_Departments', 'SH_Departments.DepartmentID='.$this->table_name.'.HealthConditionDepartment');
// $this->db->join('SH_HealthCondition', 'SH_HealthCondition.HealthConditionID='.$this->table_name.'.HealthConditionCondition');
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function get_health_conditions_summary($fields = '', $department_id = '', $condition_id = '', $where = array(), $order_by = '', $status = ''){
if ($fields != '') {
$this->db->select($fields);
}
else{
$this->db->select($this->fields_summary);
}
if($order_by != ''){
$this->db->order_by($order_by);
}
else{
$this->db->order_by($this->order_by);
}
if ($status != '') {
$this->db->where('A.Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
if($department_id){
$this->db->where('FIND_IN_SET('.$department_id.', HealthConditionDepartment)!=',0);
}
if($condition_id){
$this->db->where('FIND_IN_SET('.$condition_id.', HealthConditionService)!=',0);
}
// $this->db->join('SH_Departments', 'SH_Departments.DepartmentID='.$this->table_name.'.HealthConditionDepartment');
// $this->db->join('SH_HealthCondition', 'SH_HealthCondition.HealthConditionID='.$this->table_name.'.HealthConditionCondition');
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function insert_health_condition($data){
$data['CreationDate'] = $data['UpdationDate'] = date('Y-m-d H:i:s');
$success = $this->db->insert($this->table_name, $data);
if ($success) {
return $this->db->insert_id();
} else {
return FALSE;
}
}
public function update_health_condition($data, $id) {
$data['UpdationDate'] = date('Y-m-d H:i:s');
$this->db->where($this->primary_key, $id);
return $this->db->update($this->table_name, $data);
}
public function delete_health_condition($id) {
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->table_name);
}
}
?>
Kontol Shell Bypass