ikan Uploader :
Directory : /var/www/html/shardadiagnostics.in/application/modules/admin/models/
Upload File : |
| Current File : /var/www/html/shardadiagnostics.in/application/modules/admin/models/Prescription_model.php |
<?php
date_default_timezone_set("Asia/Kolkata");
class Prescription_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function deleteProduct($id)
{
$this->db->trans_begin();
$this->db->where('id', $id);
if (!$this->db->delete('health_advisor')) {
log_message('error', print_r($this->db->error(), true));
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
show_error(lang('database_error'));
} else {
$this->db->trans_commit();
}
}
public function productsCount($search_title = null, $category = null)
{
if ($search_title != null) {
$search_title = trim($this->db->escape_like_str($search_title));
$this->db->where("(prescription_requests.mobile_number LIKE '%$search_title%')");
}
return $this->db->count_all_results('prescription_requests');
}
public function getProducts($limit, $page, $search_title = null, $orderby = null, $category = null, $to_date, $from_date)
{
if ($search_title != null) {
$search_title = trim($this->db->escape_like_str($search_title));
$this->db->where("(prescription_requests.mobile_number LIKE '%$search_title%')");
}
if ($orderby !== null) {
$ord = explode('=', $orderby);
if (isset($ord[0]) && isset($ord[1])) {
$this->db->order_by('prescription_requests.' . $ord[0], $ord[1]);
}
} else {
$this->db->order_by('id', 'desc');
}
if ($category != null) {
$this->db->where('type', $category);
}
if ($vendor != null) {
$this->db->where('vendor_id', $vendor);
}
if ($to_date != null) {
$this->db->where('created_on>=', $to_date);
}
if ($from_date != null) {
$this->db->where('created_on<=', $from_date);
}
$this->db->where('verify_status', '1');
if(!$query = $this->db->select('id,full_name,mobile_number,created_on,prescription,vendor_id,call_response')->get('prescription_requests' , $limit, $page)){
log_message('error', print_r($this->db->error(), true));
}
//print_r($from_date);die;
//echo$qqq=$this->db->last_query(); die;
return $query->result();
}
public function getAllProducts(){
$this->db->where('shop_categorie', '2');
$query = $this->db->select('id,name,email,contact,company,message')->get('feedback');
return $query->result();
}
public function numShopProducts()
{
return $this->db->count_all_results('health_advisor');
}
public function getVendor($id)
{
$this->db->select('vendors.name as vendor_name');
$this->db->where('vendors.id', $id);
$query = $this->db->get('vendors');
if ($query->num_rows() > 0) {
return $query->result();
} else {
return false;
}
}
public function productStatusChange($id, $to_status)
{
$this->db->where('id', $id);
$result = $this->db->update('prescription_requests', array('verify_status' => $to_status));
return $result;
}
public function setResponse($post)
{
//print_r($post);
$id=$post['id'];
$this->db->trans_begin();
$is_update = false;
$history=array();
if ( $id > 0) {
if($post['history']!=''){
$history=explode(",",$post['history']);
}
array_push($history,$post['call_response']);
//print_r($history);
$call_response=serialize($history);
//echo $call_response;die;
$this->db->where('id', $id);
if(!$result = $this->db->update('prescription_requests', array('call_response' => $call_response,'modified_on' => date('Y-m-d h:i:s')))){
print_r($this->db->error());die;
log_message('error', print_r($this->db->error(), true));
}
//echo $qqq=$this->db->last_query();die;
return $result;
}
}
}
Kontol Shell Bypass