ikan Uploader :
Directory : /var/www/html/shardadiagnostics.in/application/modules/vendor/models/
Upload File : |
| Current File : /var/www/html/shardadiagnostics.in/application/modules/vendor/models/Lead_model.php |
<?php
class Lead_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function getOneProduct($id, $vendor_id)
{
$this->db->where('id', $id);
$this->db->where('vendor_id', $vendor_id);
$query = $this->db->get('products');
if ($query->num_rows() > 0) {
return $query->row_array();
} else {
return false;
}
}
public function getLeads($limit, $page, $vendor_id)
{
die('hello');
$this->db->order_by('id', 'desc');
$this->db->where('vendor_id', $vendor_id);
$query = $this->db->select('id,full_name,mobile_number,email_id,prescription,description,verify_status')->get('prescription_requests', $limit, $page);
//echo $this->db->last_query();die;
return $query->result();
}
public function productsCount($vendor_id)
{
$this->db->where('vendor_id', $vendor_id);
return $this->db->count_all_results('prescription_requests');
}
public function setLead($post)
{
$this->db->trans_begin();
$post['created_on'] = date('Y-m-d h:i:s');
$post['verify_status'] = '1';
if (!$query=$this->db->insert('prescription_requests', $post)) {
print_r($this->db->error());die;
log_message('error', print_r($this->db->error(), true));
}
//echo $this->db->last_query();die;
$id = $this->db->insert_id();
return $id;
}
public function deleteProduct($id)
{
$this->db->trans_begin();
$this->db->where('id', $id);
$this->db->where('vendor_id', $vendor_id);
if (!$this->db->delete('products')) {
log_message('error', print_r($this->db->error(), true));
} else {
$this->db->where('for_id', $id);
if (!$this->db->delete('products_translations')) {
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 getTranslations($id)
{
$this->db->where('for_id', $id);
$query = $this->db->get('products_translations');
$arr = array();
foreach ($query->result() as $row) {
$arr[$row->abbr]['title'] = $row->title;
$arr[$row->abbr]['tag_line'] = $row->tag_line;
$arr[$row->abbr]['fasting_time'] = $row->fasting_time;
$arr[$row->abbr]['reporting_time'] = $row->reporting_time;
$arr[$row->abbr]['gender'] = $row->gender;
$arr[$row->abbr]['recommended_for'] = $row->recommended_for;
$arr[$row->abbr]['total_tests'] = $row->total_tests;
$arr[$row->abbr]['precautions'] = $row->precautions;
$arr[$row->abbr]['basic_description'] = $row->basic_description;
$arr[$row->abbr]['description'] = $row->description;
$arr[$row->abbr]['price'] = $row->price;
$arr[$row->abbr]['includes'] = $row->includes;
$arr[$row->abbr]['sample_type'] = $row->sample_type;
$arr[$row->abbr]['old_price'] = $row->old_price;
}
return $arr;
}
}
Kontol Shell Bypass