7 * LICENSE: This source file is licensed under the terms of the GNU General Public License.
9 * @package Magic3 Framework
10 * @author 平田直毅(Naoki Hirata) <naoki@aplo.co.jp>
11 * @copyright Copyright 2006-2012 Magic3 Project.
12 * @license http://www.gnu.org/copyleft/gpl.html GPL License
13 * @version SVN: $Id: s_blog_archiveDb.php 4752 2012-03-14 04:42:10Z fishbone $
14 * @link http://www.magic3.org
16 require_once($gEnvManager->getDbPath() . '/baseDb.php');
18 class s_blog_archiveDb extends BaseDb
23 * @param timestamp $now 現在日時(現在日時より未来の投稿日時の記事は取得しない)
24 * @param string $langId 言語
25 * @param array $rows 取得データ
28 function getAllEntry($now, $langId, &$rows)
30 $initDt = $this->gEnv->getInitValueOfTimestamp();
32 $queryStr = 'SELECT be_regist_dt FROM blog_entry ';
33 $queryStr .= 'WHERE be_deleted = false '; // 削除されていない
34 $queryStr .= 'AND be_status = ? ';
35 $queryStr .= 'AND be_language_id = ? ';
36 $queryStr .= 'AND be_regist_dt <= ? '; // 投稿日時が現在日時よりも過去のものを取得
39 $queryStr .= 'AND (be_active_start_dt = ? OR (be_active_start_dt != ? AND be_active_start_dt <= ?)) ';
40 $queryStr .= 'AND (be_active_end_dt = ? OR (be_active_end_dt != ? AND be_active_end_dt > ?)) ';
42 $queryStr .= 'ORDER BY be_regist_dt desc';
43 $retValue = $this->selectRecords($queryStr, array(2, $langId, $now, $initDt, $initDt, $now, $initDt, $initDt, $now), $rows);// 「公開」(2)データを取得