app/Customize/Controller/TopController.php line 28

Open in your IDE?
  1. <?php
  3. /*
  4.  * This file is part of EC-CUBE
  5.  *
  6.  * Copyright(c) EC-CUBE CO.,LTD. All Rights Reserved.
  7.  *
  8.  * http://www.ec-cube.co.jp/
  9.  *
  10.  * For the full copyright and license information, please view the LICENSE
  11.  * file that was distributed with this source code.
  12.  */
  14. namespace Customize\Controller;
  16. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  17. use Symfony\Component\Routing\Annotation\Route;
  18. use Eccube\Controller\AbstractController;
  19. use Doctrine\DBAL\Configuration;
  20. use Doctrine\DBAL\DriverManager;
  22. class TopController extends AbstractController
  23. {
  24.     /**
  25.      * @Route("/", name="homepage")
  26.      * @Template("index.twig")
  27.      */
  28.     public function index()
  29.     {
  30.         $config = new Configuration();
  31.         $connectionParams = array(
  32.             'dbname' => 'yasashiite_wp',
  33.             'user' => 'yasashiite_wp',
  34.             'password' => 'r8iMjLJWZD.4YRb',
  35.             'host' => 'localhost',
  36.             'port' => 3306,
  37.             'charset' => 'utf8',
  38.             'driver' => 'pdo_mysql',
  39.         );
  41.         // 接続
  42.         $conn = DriverManager::getConnection($connectionParams, $config);
  43.         $posts = $this->getPosts($conn);
  44.         // echo "<div style='display:none;>";
  45.         // print_r($posts);
  46.         // echo "</div>";
  47.         $specialPosts = $this->getPosts($conn,4,8);
  48.         // print_r($specialPosts);
  49.         $termsQb = $conn->createQueryBuilder();
  50.         $terms = $termsQb
  51.             ->select('*')
  52.             ->from('yt_term_taxonomy','tt')
  53.             ->join('tt','yt_terms','t','tt.term_id = t.term_id')
  54.             ->where('tt.taxonomy = "category"')
  55.             ->execute()
  56.             ->fetchAll()
  57.         ;
  59.         return [
  60.             'Posts' => $posts,
  61.             'Terms' => $terms,
  62.             'SpecialPosts' => $specialPosts,
  63.         ];
  64.     }
  66.     
  68.     private function getPosts($conn, $limit = 5, $category = null){
  69.             $postsQb = $conn->createQueryBuilder();
  70.             $postsResults = $postsQb
  71.                 ->select('*')
  72.                 ->from('yt_posts','p')
  73.                 ->join('p','yt_term_relationships','r','p.id = r.object_id')
  74.                 ->join('r','yt_term_taxonomy','tt','r.term_taxonomy_id = tt.term_taxonomy_id')
  75.                 ->join('tt','yt_terms','t','tt.term_id = t.term_id')
  76.                 ->leftJoin('p','yt_postmeta','pm','p.id = pm.post_id AND pm.meta_key = "_thumbnail_id"')
  77.                 ->where('p.post_status = "publish"')
  78.                 ->andWhere('p.post_type = "post"')
  79.                 ->orderBy('p.post_date',"DESC")
  80.                 ->execute()
  81.                 ->fetchAll()
  82.             ;
  83.             $posts = [];
  84.             foreach($postsResults as $key => $post){
  85.                 $post['terms'][] = [
  86.                     'term_id' => $post['term_id'],
  87.                     'name' => $post['name'],
  88.                     'taxonomy' => $post['taxonomy'],
  89.                     'slug' => $post['slug']
  90.                 ];
  91.                 // echo ($key - 1);
  92.                 if($key != 0 && $post['ID'] == $posts[array_key_last($posts)]['ID']){
  93.                     $posts[array_key_last($posts)]['terms'][] = $post['terms'][0];
  94.                 }else{
  95.                     if(isset($post['meta_value']) && !empty($post['meta_value'])){
  96.                         $postMetaQb = $conn->createQueryBuilder();
  97.                         $postMetaResults = $postMetaQb
  98.                             ->select('*')
  99.                             ->from('yt_posts','p')
  100.                             ->where('p.ID = :metavalue')
  101.                             ->setParameter('metavalue',$post['meta_value'])
  102.                             ->execute()
  103.                             ->fetchAll()
  104.                             ;
  105.                             // print_r($postMetaResults);
  106.                         if(isset($postMetaResults[0]['guid'])){
  107.                             $post['thumbnail'] = $postMetaResults[0]['guid'];
  108.                         }else{
  109.                             $post['thumbnail'] = $this->get_first_image($post['post_content']);
  110.                         }
  111.                     }else{
  112.                         $post['thumbnail'] = $this->get_first_image($post['post_content']);
  113.                     }
  114.                     $posts[] = $post;
  115.                 }
  116.             }
  117.             if($category != null){
  118.                 $feature_posts = [];
  119.                 foreach($posts as $key => $post){
  120.                     $has_category = false;
  121.                     foreach($post['terms'] as $term){
  122.                         if($term['term_id'] == $category) $has_category = true;
  123.                         if($has_category) break;
  124.                     }
  125.                     if($has_category) $feature_posts[] = $post;
  126.                 }
  127.                 return array_slice($feature_posts,0,$limit);
  128.             }
  129.             return array_slice($posts,0,$limit);
  130.     }
  132.     private function get_first_image($content) {
  133.         $first_img = '/column/img/common/no_image.png';
  134.         preg_match_all('/<img.+?src=[\'"]([^\'"]+)[\'"].*>/i', $content, $matches);
  135.         if(isset($matches[1][0])){
  136.           $first_img = $matches[1][0];
  137.         }
  138.         return $first_img;
  139.     }
  140. }