CHIEFSOFT\ameye
122 lines
3.4 KiB
PHP
122 lines
3.4 KiB
PHP
<?php
|
|
|
|
namespace App\Controllers;
|
|
|
|
class Home extends BaseController
|
|
{
|
|
protected $db;
|
|
public $con_name = 'default';
|
|
|
|
|
|
public function index()
|
|
{
|
|
return view('welcome_message');
|
|
}
|
|
|
|
public function home2()
|
|
{
|
|
$data = [];
|
|
return $this->sitePage("home", $data);
|
|
}
|
|
|
|
|
|
private function sitePage($curr_page, $data)
|
|
{
|
|
return view('main/header') . view('main/home') . view('main/footer');
|
|
}
|
|
|
|
public function home()
|
|
{
|
|
|
|
$siteData = [];
|
|
$out = $this->APIcall('GET', 'https://blogdata.chiefsoft.net/blogdata/chiefsoft', []); // https://blogdata.chiefsoft.net/
|
|
$siteData['blogdata'] = $out['payload']['blogdata'];
|
|
|
|
$data = array();
|
|
|
|
$data["blog_featured"] = $siteData['blogdata'][0];
|
|
$data["blog_array"] = array_slice($siteData['blogdata'], 0, 7); // $siteData['blogdata'];
|
|
|
|
|
|
return view('site/home', $data);
|
|
}
|
|
|
|
public function about()
|
|
{
|
|
$data = array();
|
|
$this->renderSitePage('about', $data);
|
|
}
|
|
|
|
public function services()
|
|
{
|
|
$data = array();
|
|
$this->renderSitePage('services', $data);
|
|
}
|
|
|
|
public function contact()
|
|
{
|
|
$data = array();
|
|
$this->renderSitePage('contact', $data);
|
|
}
|
|
|
|
public function blog()
|
|
{
|
|
// $data = array();
|
|
// $this->db = \Config\Database::connect($this->con_name);
|
|
//
|
|
// try {
|
|
// $mysql = "SELECT id, post_title, post_content,post_date,comment_count FROM wp_posts WHERE post_type='post' AND post_status = 'publish' ORDER BY post_date DESC LIMIT 9";
|
|
//
|
|
//
|
|
// $mysql = "SELECT p1.id AS id, 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_status='publish'
|
|
// AND p1.post_type='post'
|
|
// ORDER BY p1.post_date DESC LIMIT 9";
|
|
//
|
|
//
|
|
//
|
|
// $query = $this->db->query($mysql);
|
|
//
|
|
// $row = $query->getResultArray();
|
|
// // print_r( $row );
|
|
// // $r = $this->db->query($mysql);
|
|
// $data["blog_array"] = $row;
|
|
// } catch (Exception $ex) {
|
|
//
|
|
// }
|
|
|
|
// featured
|
|
// try {
|
|
// $mysql = "SELECT id, post_title, post_content,post_date,comment_count
|
|
// FROM wp_posts WHERE post_type='post' AND post_status = 'publish' AND id = 263";
|
|
// $query = $this->db->query($mysql);
|
|
//
|
|
// $rowF = $query->getResultArray();
|
|
// // print_r( $rowF );
|
|
// // $r = $this->db->query($mysql);
|
|
// $data["blog_featured"] = $rowF[0];
|
|
// } catch (Exception $ex) {
|
|
//
|
|
// }
|
|
$data = array();
|
|
$siteData = [];
|
|
try {
|
|
$out = $this->APIcall('GET', 'https://blogdata.chiefsoft.net/blogdata/chiefsoft', []); // https://blogdata.chiefsoft.net/
|
|
$siteData['blogdata'] = $out['payload']['blogdata'];
|
|
|
|
$data["blog_featured"] = $siteData['blogdata'][0];
|
|
$data["blog_array"] = array_slice($siteData['blogdata'], 0, 7); // $siteData['blogdata'];
|
|
} catch (Exception $ex) {
|
|
|
|
}
|
|
|
|
$this->renderSitePage('blog', $data);
|
|
}
|
|
|
|
}
|