/**
  * testFindField method
  *
  * @return void
  */
 public function testFindField()
 {
     $this->loadFixtures('User');
     $TestModel = new User();
     $TestModel->id = 1;
     $result = $TestModel->field('user');
     $this->assertEquals('mariano', $result);
     $result = $TestModel->field('User.user');
     $this->assertEquals('mariano', $result);
     $TestModel->id = false;
     $result = $TestModel->field('user', array('user' => 'mariano'));
     $this->assertEquals('mariano', $result);
     $TestModel->order = null;
     $result = $TestModel->field('COUNT(*) AS count', true);
     $this->assertEquals(4, $result);
     $result = $TestModel->field('COUNT(*)', true);
     $this->assertEquals(4, $result);
 }
Esempio n. 2
0
 /**
  * ブログ記事を取得する
  *
  * @param array $options
  * @return array
  * @access protected
  */
 protected function _getBlogPosts($options = array())
 {
     // listCountの処理 (num が優先)
     // TODO num に統一する
     if (!empty($options['listCount'])) {
         if (empty($options['num'])) {
             $options['num'] = $options['listCount'];
         }
     }
     // named の 処理
     $named = array();
     if (!empty($this->request->params['named'])) {
         $named = $this->request->params['named'];
     }
     if (!empty($named['direction'])) {
         $options['direction'] = $named['direction'];
         unset($named['direction']);
     }
     if (!empty($named['num'])) {
         $options['num'] = $named['num'];
         unset($named['num']);
     }
     if (!empty($named['page'])) {
         $options['page'] = $named['page'];
         unset($named['page']);
     }
     if (!empty($named['sort'])) {
         $options['sort'] = $named['sort'];
         unset($named['sort']);
     }
     $_conditions = array();
     if (!empty($this->request->params['named'])) {
         if (!empty($options['conditions'])) {
             $_conditions = array_merge($options['conditions'], $this->request->params['named']);
         } else {
             $_conditions = $this->request->params['named'];
         }
     } elseif (!empty($options['conditions'])) {
         $_conditions = $options['conditions'];
     }
     unset($options['conditions']);
     $_conditions = array_merge(array('category' => null, 'tag' => null, 'year' => null, 'month' => null, 'day' => null, 'id' => null, 'keyword' => null, 'author' => null), $_conditions);
     $options = array_merge(array('direction' => $this->blogContent['BlogContent']['list_direction'], 'num' => $this->blogContent['BlogContent']['list_count'], 'page' => 1, 'sort' => 'posts_date'), $options);
     extract($options);
     $expects = array('BlogContent', 'BlogCategory', 'User', 'BlogTag');
     $conditions = array('BlogPost.blog_content_id' => $this->contentId);
     // カテゴリ条件
     if ($_conditions['category']) {
         $category = $_conditions['category'];
         $categoryId = $this->BlogCategory->field('id', array('BlogCategory.blog_content_id' => $this->contentId, 'BlogCategory.name' => $category));
         if ($categoryId === false) {
             $categoryIds = '';
         } else {
             $categoryIds = array(0 => $categoryId);
             // 指定したカテゴリ名にぶら下がる子カテゴリを取得
             $catChildren = $this->BlogCategory->children($categoryId);
             if ($catChildren) {
                 $catChildren = Hash::extract($catChildren, '{n}.BlogCategory.id');
                 $categoryIds = am($categoryIds, $catChildren);
             }
         }
         $conditions['BlogPost.blog_category_id'] = $categoryIds;
     }
     // タグ条件
     if ($_conditions['tag']) {
         $tag = $_conditions['tag'];
         if (!is_array($tag)) {
             $tag = array($tag);
         }
         foreach ($tag as $key => $value) {
             $tag[$key] = urldecode($value);
         }
         $tags = $this->BlogPost->BlogTag->find('all', array('conditions' => array('BlogTag.name' => $tag), 'recursive' => 1));
         if (isset($tags[0]['BlogPost'][0]['id'])) {
             $ids = Hash::extract($tags, '{n}.BlogPost.{n}.id');
             $conditions['BlogPost.id'] = $ids;
         } else {
             return array();
         }
     }
     // キーワード条件
     if ($_conditions['keyword']) {
         $keyword = $_conditions['keyword'];
         if (preg_match('/\\s/', $keyword)) {
             $keywords = explode("\\s", $keyword);
         } else {
             $keywords = array($keyword);
         }
         foreach ($keywords as $key => $value) {
             $keywords[$key] = urldecode($value);
             $conditions['or'][]['BlogPost.name LIKE'] = '%' . $value . '%';
             $conditions['or'][]['BlogPost.content LIKE'] = '%' . $value . '%';
             $conditions['or'][]['BlogPost.detail LIKE'] = '%' . $value . '%';
         }
     }
     // 年月日条件
     if ($_conditions['year'] || $_conditions['month'] || $_conditions['day']) {
         $year = $_conditions['year'];
         $month = $_conditions['month'];
         $day = $_conditions['day'];
         $db = ConnectionManager::getDataSource($this->BlogPost->useDbConfig);
         $datasouce = strtolower(preg_replace('/^Database\\/Bc/', '', $db->config['datasource']));
         switch ($datasouce) {
             case 'mysql':
             case 'csv':
                 if ($year) {
                     $conditions["YEAR(BlogPost.posts_date)"] = $year;
                 }
                 if ($month) {
                     $conditions["MONTH(BlogPost.posts_date)"] = $month;
                 }
                 if ($day) {
                     $conditions["DAY(BlogPost.posts_date)"] = $day;
                 }
                 break;
             case 'postgres':
                 if ($year) {
                     $conditions["date_part('year',BlogPost.posts_date) = "] = $year;
                 }
                 if ($month) {
                     $conditions["date_part('month',BlogPost.posts_date) = "] = $month;
                 }
                 if ($day) {
                     $conditions["date_part('day',BlogPost.posts_date) = "] = $day;
                 }
                 break;
             case 'sqlite':
                 if ($year) {
                     $conditions["strftime('%Y',BlogPost.posts_date)"] = $year;
                 }
                 if ($month) {
                     $conditions["strftime('%m',BlogPost.posts_date)"] = sprintf('%02d', $month);
                 }
                 if ($day) {
                     $conditions["strftime('%d',BlogPost.posts_date)"] = sprintf('%02d', $day);
                 }
                 break;
         }
     }
     //author条件
     if ($_conditions['author']) {
         $author = $_conditions['author'];
         App::uses('User', 'Model');
         $user = new User();
         $userId = $user->field('id', array('User.name' => $author));
         $conditions['BlogPost.user_id'] = $userId;
     }
     if ($_conditions['id']) {
         $conditions["BlogPost.no"] = $_conditions['id'];
         $expects[] = 'BlogComment';
         $this->BlogPost->hasMany['BlogComment']['conditions'] = array('BlogComment.status' => true);
         $num = 1;
     }
     unset($_conditions['author']);
     unset($_conditions['category']);
     unset($_conditions['tag']);
     unset($_conditions['keyword']);
     unset($_conditions['year']);
     unset($_conditions['month']);
     unset($_conditions['day']);
     unset($_conditions['id']);
     unset($_conditions['page']);
     unset($_conditions['num']);
     unset($_conditions['sort']);
     unset($_conditions['direction']);
     if ($_conditions) {
         // とりあえず BlogPost のフィールド固定
         $conditions = array_merge($conditions, $this->postConditions(array('BlogPost' => $_conditions)));
     }
     // プレビューの場合は公開ステータスを条件にしない
     if (!$this->preview) {
         $conditions = array_merge($conditions, $this->BlogPost->getConditionAllowPublish());
     }
     $this->BlogPost->expects($expects, false);
     $order = "BlogPost.{$sort} {$direction}";
     // 毎秒抽出条件が違うのでキャッシュしない
     $this->paginate = array('conditions' => $conditions, 'fields' => array(), 'order' => $order, 'limit' => $num, 'recursive' => 1, 'cache' => false);
     return $this->paginate('BlogPost');
 }