ikan Uploader :
Directory : /var/www/html/shardahospital_old.org/application/controllers/
Upload File : |
| Current File : /var/www/html/shardahospital_old.org/application/controllers/Blogs_16_7.php |
<?php
error_reporting(0);
defined('BASEPATH') OR exit('No direct script access allowed');
class Blogs extends CI_Controller {
function __construct() {
parent::__construct();
$this->load->model('blog_model', 'blog');
$this->load->model('news_model', 'news');
$this->load->model('department_model', 'department');
$this->load->model('patient_story_model', 'patient_story');
$this->load->model('doctor_model', 'doctor');
$this->load->model('appointment_model', 'appointment');
$this->load->model('enquiry_model', 'enquiry');
$this->load->library('session');
$this->load->model('Pagination_model',"pgn");
}
public function index($id=0)
{
if(!$id){
//$this->view_blog();
$this->pages();
}
else{
$this->view_blog_article($id);
}
}
public function book_apk(){
extract($_POST);
$data = array();
$success = '';
$error_msg = '';
$post=$this->input->post();
$newurl = $post['urlnew'];
if((!empty($post['RequestPatientName'])) and (!empty($post['RequestPatientMobile'])) and (!empty($post['RequestDepartment']))) {
$this->form_validation->set_rules('RequestPatientName', 'Patient Name', 'required|trim|alpha_numeric_spaces');
$this->form_validation->set_rules('RequestPatientMobile', 'Patient Mobile Number', 'trim|required|numeric|min_length[10]');
$this->form_validation->set_rules('RequestDepartment', 'Department', 'required');
$querys = $this->db->query("select `RequestPatientMobile` from `SH_AppointmentRequests` where `RequestPatientMobile`='".$RequestPatientMobile."'");
$num = $querys->num_rows();
if($num=='0'){
$insert_data = array(
'RequestDoctor' => $post['RequestDoctor'],
'RequestPatientName' => $post['RequestPatientName'],
'RequestPatientMobile' => $post['RequestPatientMobile'],
'RequestDepartment' => $post['RequestDepartment'],
'RequestDate' => date('Y-m-d H:i:s')
);
//print_r($insert_data);
$success = $this->appointment->insert_appointment_request($insert_data);
if($success){
$data['succmsg'] = "<font color='#006600'>Your detail has been submited.</font>";
echo "<font color='#006600'>Your detail has been submited</font>";?>
<script> setTimeout(function() {
window.location = "<?php echo base_url().'blogs/'.$newurl;?>";
}, 1000 );
</script>
<?php
}
}
else {
echo "<font color='#990000'>Contact no already exist.</font>";
}
} else {
echo "<font color='#990000'>Please Fill all Information.</font>";
}
}
public function get_enquiry(){
$data = array();
$success = '';
$error_msg = '';
$post=$this->input->post();
if((!empty($post['patient_name'])) and (!empty($post['email_id'])) and (!empty($post['phone_no'])) and (!empty($post['enquiry_msg']))) {
$this->form_validation->set_rules('EnquiryName', 'Patient Name', 'trim|alpha_numeric_spaces');
$this->form_validation->set_rules('EnquiryEmail', 'Patient EmailID', 'trim|required|valid_email');
$this->form_validation->set_rules('EnquiryPhone', 'Patient Phone No.', 'trim|required|numeric');
$this->form_validation->set_rules('EnquiryMessage', 'Enquiry Message', 'trim|htmlspecialchars|required|alpha_numeric_spaces');
$regex = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/';
if(preg_match($regex,$post['email_id'])) {
$enq_no = $this->db->query("select `EnquiryEmail` from `SH_Enquiries` where EnquiryEmail='".$post['email_id']."'");
$NUM = $enq_no->num_rows();
$newurl = $post['urls'];
if($NUM=='0'){
$insert_data = array(
'EnquiryName' => $post['patient_name'],
'EnquiryEmail' => $post['email_id'],
'EnquiryPhone' => $post['phone_no'],
'EnquiryMessage' => $post['enquiry_msg']
);
$success = $this->enquiry->insert_enquiry($insert_data);
if($success){
echo "<font color='#006600'>Enquiry has been submited</font>";?>
<script> setTimeout(function() {
window.location = "<?php echo base_url().'blogs/'.$newurl;?>";
}, 1000 );
</script>
<?php
unset($newurl);
}
}
else {
echo "<font color='#990000'>Email Id already exist.</font>";
}
} else { echo "<font color='#990000'>Invalid Email Id.</font>";}
} else {
echo "<font color='#990000'>Please Fill all Information.</font>";
}
}
public function pages()
{
$data = array();
/************ paging *************/
$allblogrecord = $this->pgn->allblogrecord();
$baseurl = base_url().$this->router->class.'/'.'pages';
$paging=array();
$paging['base_url'] = $baseurl;
$paging['total_rows'] = $allblogrecord;
$paging['per_page'] = 5;
$paging['uri_segment']= 3;
$paging['num_links'] = 2;
$paging['first_link'] = 'First';
$paging['first_link'];
$paging['first_tag_open'] = '<li>';
$paging['first_tag_close'] = '</li>';
$paging['num_tag_open'] = '<li>';
$paging['num_tag_close'] = '</li>';
$paging['prev_link'] = 'Prev';
$paging['prev_tag_open'] = '<li>';
$paging['prev_tag_close'] = '</li>';
$paging['next_link'] = 'Next';
$paging['next_tag_open'] = '<li>';
$paging['next_tag_close'] = '</li>';
$paging['last_link'] = 'Last';
$paging['last_tag_open'] = '<li>';
$paging['last_tag_close'] = '</li>';
$paging['cur_tag_open'] = '<li class="active"><a href="javascript:void(0);">';
$paging['cur_tag_close'] = '</a></li>';
$this->pagination->initialize($paging);
/*********************** next pagination ******************************/
$data['limit'] = $paging['per_page'];
$data['number_page'] = $paging['per_page'];
$data['offset'] = ($this->uri->segment(3)) ? $this->uri->segment(3):'0';
$data['nav'] = $this->pagination->create_links();
$CI = &get_instance();
$this->db2 = $CI->load->database('db2', TRUE);
$data['feature_blog'] = $this->db2->query("SELECT *
FROM `wp_posts` AS p
INNER JOIN `wp_postmeta` AS pm1 ON p.id = pm1.post_id
INNER JOIN `wp_postmeta` AS pm2 ON pm1.meta_value = pm2.post_id
AND pm2.meta_key = '_wp_attached_file'
AND pm1.meta_key = '_thumbnail_id'
ORDER BY p.id DESC LIMIT ".$data['offset'].",".$data['limit']."
")->result_array();
$data['readnews'] = $this->news->get_news($id=0);
$data['departments_list'] = $this->db->query("select `DepartmentID`,`DepartmentName` from `SH_Departments` where status='A' order by DepartmentType ASC")->result_array();
$data['category'] = $this->db2->query("SELECT
ID,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.name!='NULL' and term.name!='Uncategorized' and name!='mymenu'
GROUP BY term.name ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id Limit 0,4")->result_array();
$data['category2'] = $this->db2->query("SELECT
ID,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.name!='NULL' and term.name!='Uncategorized' and name!='mymenu'
GROUP BY term.name ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id Limit 4,20")->result_array();
$data['latest_blog'] = $this->db2->query("SELECT *
FROM `wp_posts` AS p
INNER JOIN `wp_postmeta` AS pm1 ON p.id = pm1.post_id
INNER JOIN `wp_postmeta` AS pm2 ON pm1.meta_value = pm2.post_id
AND pm2.meta_key = '_wp_attached_file'
AND pm1.meta_key = '_thumbnail_id' where pm1.meta_value!=''
ORDER BY p.id DESC LIMIT 0,10")->result_array();
$data['special_cat'] = $this->db2->query("select * from `wp_terms` where slug IN ('ophthalmology','child-care')")->result_array();
/***************** Starting **********/
$data['special_first'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='child-care'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id")->result_array();
/************* Second **********/
$data['special_second'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='ophthalmology'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id")->result_array();
/************** END **************/
$this->load->view('blogs',$data);
}
public function blogcategory($search)
{
$data = array();
/********************** page *******************/
$allblogcategory = $this->pgn->allblogcategory($search);
$baseurl = base_url().'blogcategory'.'/'.$search;
$paging=array();
$paging['base_url'] = $baseurl;
$paging['total_rows'] = $allblogcategory;
$paging['per_page'] = 5;
$paging['uri_segment']= 3;
$paging['num_links'] = 2;
$paging['first_link'] = 'First';
$paging['first_link'];
$paging['first_tag_open'] = '<li>';
$paging['first_tag_close'] = '</li>';
$paging['num_tag_open'] = '<li>';
$paging['num_tag_close'] = '</li>';
$paging['prev_link'] = 'Prev';
$paging['prev_tag_open'] = '<li>';
$paging['prev_tag_close'] = '</li>';
$paging['next_link'] = 'Next';
$paging['next_tag_open'] = '<li>';
$paging['next_tag_close'] = '</li>';
$paging['last_link'] = 'Last';
$paging['last_tag_open'] = '<li>';
$paging['last_tag_close'] = '</li>';
$paging['cur_tag_open'] = '<li class="active"><a href="javascript:void(0);">';
$paging['cur_tag_close'] = '</a></li>';
$this->pagination->initialize($paging);
$data['limit'] = $paging['per_page'];
$data['number_page'] = $paging['per_page'];
$data['offset'] = ($this->uri->segment(3)) ? $this->uri->segment(3):'0';
$data['nav'] = $this->pagination->create_links();
/********* end ***********************/
$CI = &get_instance();
$this->db2 = $CI->load->database('db2', TRUE);
if(!empty($search)) {
$data['feature_blog'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='".$search."'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id LIMIT ".$data['offset'].",".$data['limit']."")->result_array();
}
/*********************************** END *******************/
$data['category'] = $this->db2->query("SELECT
ID,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.name!='NULL' and term.name!='Uncategorized' and name!='mymenu'
GROUP BY term.name ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id Limit 0,4")->result_array();
$data['category2'] = $this->db2->query("SELECT
ID,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.name!='NULL' and term.name!='Uncategorized' and name!='mymenu'
GROUP BY term.name ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id Limit 4,20")->result_array();
$data['latest_blog'] = $this->db2->query("SELECT *
FROM `wp_posts` AS p
INNER JOIN `wp_postmeta` AS pm1 ON p.id = pm1.post_id
INNER JOIN `wp_postmeta` AS pm2 ON pm1.meta_value = pm2.post_id
AND pm2.meta_key = '_wp_attached_file'
AND pm1.meta_key = '_thumbnail_id' where pm1.meta_value!=''
ORDER BY p.id DESC LIMIT 0,10")->result_array();
$data['readnews'] = $this->news->get_news($id=0);
/***************************/
$data['special_first'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='child-care'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id")->result_array();
/************* Second **********/
$data['special_second'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='ophthalmology'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id")->result_array();
/********************** END **********************/
$data['special_cat'] = $this->db2->query("select * from `wp_terms` where slug IN ('ophthalmology','child-care')")->result_array();
$this->load->view('blogcategory',$data);
}
public function view_blog_article($title)
{
$data = array();
$_SESSION['title'] = $title;
if($title){
$CI = &get_instance();
$this->db2 = $CI->load->database('db2', TRUE);
$data['blog'] = $this->db2->query("SELECT
p1.*,
wm2.meta_value
FROM
wp_posts p1
LEFT JOIN
wp_postmeta wm1
ON (
wm1.post_id = p1.id
AND wm1.meta_value IS NOT NULL
AND wm1.meta_key = '_thumbnail_id'
)
LEFT JOIN
wp_postmeta wm2
ON (
wm1.meta_value = wm2.post_id
AND wm2.meta_key = '_wp_attached_file'
AND wm2.meta_value IS NOT NULL
)
WHERE p1.post_name='".$title."'
AND p1.post_type='post'
ORDER BY
p1.post_date DESC")->result_array();
/********************** special category ****************/
$data['special_first'] = $this->db2->query("SELECT
p1.*,
wm2.meta_value
FROM
wp_posts p1
LEFT JOIN
wp_postmeta wm1
ON (
wm1.post_id = p1.id
AND wm1.meta_value IS NOT NULL
AND wm1.meta_key = '_thumbnail_id'
)
LEFT JOIN
wp_postmeta wm2
ON (
wm1.meta_value = wm2.post_id
AND wm2.meta_key = '_wp_attached_file'
AND wm2.meta_value IS NOT NULL
)
WHERE p1.post_name='child-care'
AND p1.post_type='post'
ORDER BY
p1.post_date DESC")->result_array();
/****************** END ****************************/
$data['latest_blog'] = $this->db2->query("SELECT *
FROM `wp_posts` AS p
INNER JOIN `wp_postmeta` AS pm1 ON p.id = pm1.post_id
INNER JOIN `wp_postmeta` AS pm2 ON pm1.meta_value = pm2.post_id
AND pm2.meta_key = '_wp_attached_file'
AND pm1.meta_key = '_thumbnail_id' where pm1.meta_value!=''
ORDER BY p.id DESC LIMIT 0,10")->result_array();
$data['ses'] = $_SESSION['title'];
$data['readnews'] = $this->news->get_news($id=0);
$data['departments_list'] = $this->db->query("select `DepartmentID`,`DepartmentName` from `SH_Departments` where status='A' order by DepartmentType ASC")->result_array();
$data['category'] = $this->db2->query("SELECT
ID,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.name!='NULL' and term.name!='Uncategorized' and name!='mymenu' and p.post_status='publish'
GROUP BY term.name ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id Limit 0,4")->result_array();
$data['category2'] = $this->db2->query("SELECT
ID,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.name!='NULL' and term.name!='Uncategorized' and name!='mymenu'
GROUP BY term.name ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id Limit 4,20")->result_array();
$data['special_cat'] = $this->db2->query("select * from `wp_terms` where slug IN ('ophthalmology','child-care')")->result_array();
/***************************/
$data['special_first'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='child-care'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id")->result_array();
/************* Second **********/
$data['special_second'] = $this->db2->query("SELECT
ID,
post_title,
post_name,
post_content,
post_date,
category_name,
category_slug,
category_id,
CONCAT( '".$uploadDir."','/', thumb.meta_value) as thumbnail,
post_type
FROM (
SELECT p.ID,
p.post_title,
p.post_name,
p.post_content,
p.post_date,
p.post_type,
MAX(CASE WHEN pm.meta_key = '_thumbnail_id' then pm.meta_value ELSE NULL END) as thumbnail_id,
term.name as category_name,
term.slug as category_slug,
term.term_id as category_id
FROM wp_posts as p
LEFT JOIN wp_postmeta as pm ON ( pm.post_id = p.ID)
LEFT JOIN wp_term_relationships as tr ON tr.object_id = p.ID
LEFT JOIN wp_terms as term ON tr.term_taxonomy_id = term.term_id
where term.slug='ophthalmology'
GROUP BY p.ID ORDER BY p.post_date DESC
) as post
LEFT JOIN wp_postmeta AS thumb
ON thumb.meta_key = '_wp_attached_file'
AND thumb.post_id = post.thumbnail_id")->result_array();
/***********************end************/
$this->load->view('blog_article',$data);
}
}
}
Kontol Shell Bypass