ikan Uploader :
Directory : /var/www/html/shardahospital.org/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/application/models/Department_model.php |
<?php
Class Department_Model extends CI_Model{
protected $table_name = 'SH_Departments';
protected $primary_key = 'DepartmentID';
protected $order_by = 'DepartmentPriorityOrder DESC, DepartmentType ASC';
protected $fields_detail = 'DepartmentID, DepartmentName, DepartmentTypeTitle, DepartmentOverview,
DepartmentInfrastructure, DepartmentFacilities, DepartmentServices, DepartmentAchievements,
DepartmentHighlights, DepartmentThumbnail, DepartmentIcon, DepartmentBanner, DepartmentPriorityOrder,
DepartmentPageURL,DepartmentRating, SH_Departments.Status as Status';
protected $fields_summary = 'DepartmentID, DepartmentName, DepartmentTypeTitle, DepartmentOverview,
DepartmentThumbnail, DepartmentIcon, DepartmentBanner, DepartmentPageURL';
Public function __construct()
{
parent::__construct();
}
function get_Department($id){
return $this->db->get_where($this->table_name, array($this->primary_key => $id))->row_array();
}
function get_banner_by_slug($slug){
return $this->db->get_where('SH_coe_banner_master', array('coe_id' => $slug))->result_array();
}
function get_Department_by_slug($slug){
return $this->db->get_where($this->table_name, array('DepartmentPageURL' => $slug))->row_array();
}
function get_Department_by_name($name){
return $this->db->get_where($this->table_name, array('DepartmentName' => $name))->result_array();
}
function get_department_id($slug){
$this->db->select('DepartmentID');
return $this->db->get_where($this->table_name, array('DepartmentPageURL' => $slug))->row_array();
}
function get_department_list($order_by='', $status='', $DepartmentID=''){
$this->db->select('DepartmentID,DepartmentName');
if($order_by != ''){
$this->db->order_by($order_by);
}
else{
$this->db->order_by($this->order_by);
}
if ($status != '') {
$this->db->where('Status', $status);
}
if ($DepartmentID != '') {
$this->db->where('DepartmentID', $DepartmentID);
}
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
//echo $this->db->last_query();die;
return $result;
}
function get_sub_departments($id){
$this->db->select('DepartmentID');
$this->db->where('DepartmentParentID',$id);
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function get_departments($fields = '', $type = array(), $parent_id = '', $where = array(), $order_by = '', $status = 'A'){
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($this->table_name.'.Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
if(count($type)>0){
$this->db->where_in('DepartmentTypeTitle',$type);
}
if($parent_id!= ''){
$this->db->where('DepartmentParentID',$parent_id);
}
$this->db->join('SH_DepartmentTypes', 'SH_DepartmentTypes.DepartmentTypeID='.$this->table_name.'.DepartmentType');
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
//echo $this->db->last_query(); die();
return $result;
}
function get_departments_summary($fields = '', $type=array(), $parent_id='', $where = array(), $order_by = '', $limit='', $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($limit){
$this->db->limit(10);
}
if ($status != '') {
$this->db->where($this->table_name.'.Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
if(count($type)){
$this->db->where_in('DepartmentTypeTitle',$type);
}
if($parent_id!= ''){
$this->db->where('DepartmentParentID',$parent_id);
}
$this->db->join('SH_DepartmentTypes', 'SH_DepartmentTypes.DepartmentTypeID='.$this->table_name.'.DepartmentType');
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function insert_department($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_department($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 has_dependency($id){
$children = $this->db->get_where($this->table_name, array('DepartmentParentID' => $id), 1)->result_array();
if(count($children)){
return true;
}
$doctor = $this->db->get_where('SH_DoctorProfile', array('DoctorDepartment' => $id), 1)->result_array();
if(count($doctor)){
return true;
}
$health_condition = $this->db->get_where('SH_HealthLibrary', array('HealthConditionDepartment' => $id), 1)->result_array();
if(count($doctor)){
return true;
}
$patient_story = $this->db->get_where('SH_PatientStories', array('PatientStoryDepartment' => $id), 1)->result_array();
if(count($doctor)){
return true;
}
return false;
}
public function delete_department($id) {
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->table_name);
}
/*public function viewhome(){
$this->db->select('*');
$this->db->from('sh_banner');
$this->db->order_by("bid","desc");
$jadat = $this->db->get()->result_array();
return $jadat;
}*/
}
?>
Kontol Shell Bypass