ikan Uploader :
Directory : /var/www/html/shardahospital.org/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital.org/application/models/Medical_package_model.php |
<?php
Class Medical_Package_Model extends CI_Model{
protected $table_name = 'SH_MedicalPackages';
protected $primary_key = 'MedicalPackageID';
protected $order_by = 'MedicalPackagePriorityOrder DESC';
protected $fields_detail = 'MedicalPackageID, MedicalPackageTitle, MedicalPackageDescription, MedicalPackageExcerpt,
MedicalPackagePrice, MedicalPackageBanner, MedicalPackagePriorityOrder, MedicalPackagePageURL, Status';
protected $fields_summary = 'MedicalPackageID, MedicalPackageTitle, MedicalPackageDescription,
MedicalPackageBanner, MedicalPackagePageURL';
Public function __construct()
{
parent::__construct();
}
function get_medical_package($id){
return $this->db->get_where($this->table_name, array($this->primary_key => $id))->row_array();
}
function get_medical_package_by_slug($slug){
return $this->db->get_where($this->table_name, array('MedicalPackagePageURL' => $slug))->row_array();
}
function get_medical_package_by_name($name){
return $this->db->get_where($this->table_name, array('MedicalPackageTitle' => $name))->result_array();
}
function get_medical_package_id($slug){
$this->db->select('MedicalPackageID');
return $this->db->get_where($this->table_name, array('MedicalPackagePageURL' => $slug))->row_array();
}
function get_medical_packages($fields = '', $condition_id = '', $where = array(), $order_by = '',$limit='', $status = ''){
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('Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
if($limit){
$this->db->limit(4);
}
if($condition_id){
$this->db->where('FIND_IN_SET($condition_id, MedicalPackageService)!=',0);
}
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
/************************** medical package *****/
function get_medical_detail($fields = '', $condition_id = '', $where = array(), $order_by = '', $status = ''){
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('Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
if($condition_id){
$this->db->where('FIND_IN_SET($condition_id, MedicalPackageService)!=',0);
}
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
/****** end ***/
function get_medical_packages_summary($fields = '', $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($limit){
$this->db->limit(4);
}
if ($status != '') {
$this->db->where('Status', $status);
}
if (count($where)) {
$this->db->where($where);
}
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
function insert_medical_package($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_medical_package($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_medical_package($id) {
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->table_name);
}
/********medical payment user record ************/
function get_payment_detail(){
$Query = $this->db->order_by('PaymentOrderID','DESC');
$Query = $this->db->get('SH_PaymentOrders');
$result = $Query->result_array();
//print_r($result);
return $result;
}
public function delete_pay($id) {
//echo "==PP==".$id;
$this->db->where('PaymentOrderID', $id);
return $this->db->delete('sh_paymentOrders');
}
}
?>
Kontol Shell Bypass