ikan Uploader :
Directory : /var/www/html/shardahospital_old.org/hbackup/application/models/
Upload File : |
| Current File : /var/www/html/shardahospital_old.org/hbackup/application/models/Payment_model.php |
<?php
Class Payment_Model extends CI_Model{
protected $table_name = 'SH_PaymentOrders';
protected $primary_key = 'OrderID';
protected $order_by = 'OrderDate';
protected $fields = 'OrderID, OrderItemType, OrderItemName, OrderItemID, OrderAmount, OrderCurrencyCode,
OrderPatientName, OrderPatientAddress, OrderPatientCity, OrderPatientState, OrderPatientZip, OrderPatientCountry,
OrderPatientMobile, OrderPatientEmail, OrderDate, OrderTID, OrderPaymentStatus, OrderSource';
Public function __construct()
{
parent::__construct();
}
function get_order($id){
return $this->db->get_where($this->table_name, array($this->primary_key => $id))->row_array();
}
public function get_TID($order_id){
$this->db->select('OrderTID');
return $this->db->get_where($this->table_name, array('OrderID' => $order_id))->row_array();
}
public function get_orders($fields = '', $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('OrderPaymentStatus', $status);
}
if (count($where)) {
$this->db->where($where);
}
$Query = $this->db->get($this->table_name);
$result = $Query->result_array();
$Query->free_result();
return $result;
}
public function insert_order($data){
$data['OrderDate'] = $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 delete_order($id) {
$this->db->where($this->primary_key, $id);
return $this->db->delete($this->table_name);
}
public function update_order($order_id,$data){
$data['UpdationDate'] = date('Y-m-d H:i:s');
$this->db->where($this->primary_key, $order_id);
return $this->db->update($this->table_name, $data);
}
public function is_unique_id($order_id){
$this->db->limit(1);
$this->db->select($this->primary_key);
$query = $this->db->get_where($this->table_name, array($this->primary_key => $order_id));
if($query->num_rows()>0){
return 0;
}
else{
return 1;
}
}
/*
* Function : getallrecords
*/
function getallrecords($fields = '*', $where = array(), $tbl_name='sh_vanbooking'){
if ($fields != '') {
$this->db->select($fields);
}
else{
$this->db->select($this->fields);
}
if (count($where)) {
$this->db->where($where);
}
$this->db->where('status', '1');
$this->db->where('is_deleted', '0');
$Query = $this->db->get($tbl_name);
$result = $Query->row_array();
$Query->free_result();
return $result;
}
/*
* Function : updatebookingorder
*/
public function updatebookingorder($data, $id, $key='id') {
$data['modifiedon'] = date('Y-m-d H:i:s');
$this->db->where($key, $id);
return $this->db->update('sh_vanbooking', $data);
}
/*
* Function : inserttransactiodetails
*/
public function inserttransactiodetails($tbl_name='sh_payment_transactions', $data){
$data['createdon'] = $data['modifiedon'] = date('Y-m-d H:i:s');
$success = $this->db->insert($tbl_name, $data);
//echo $this->db->last_query(); die;
if ($success) {
return $this->db->insert_id();
} else {
return FALSE;
}
}
}
?>
Kontol Shell Bypass