= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 GROUP BY blog_sel, blog_ym ORDER BY blog_sel DESC ")->all(); $cats = DB::query(" SELECT blog_cat, COUNT(*) AS blog_cnt FROM blog WHERE (blog_st IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 GROUP BY blog_cat ORDER BY blog_cat ")->all(); $blog_cnt = 0; foreach($cats as $cat) { $blog_cnt += $cat['blog_cnt']; } if($sel['d'] !== '') { $is_match = false; foreach($dates as $date) { $is_match = $sel['d'] == $date['blog_sel']; if($is_match) { break; } } if(!$is_match) $sel['d'] = ''; } if(!ctype_digit($sel['i'])) $sel['i'] = ''; if($sel['d'] && !$sel['i']) { $sel['i'] = DB::query(" SELECT blog_id FROM blog WHERE ".($sel['c'] ? 'blog_cat = '.$sel['c'].' AND' : '')." DATE_FORMAT(blog_date, '%Y-%m') = :blog_sel AND (blog_st = IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed = IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 ORDER BY blog_id DESC LIMIT 0, 1 ")->one(array(':blog_sel' => $sel['d'])); } if($sel['i']) { $row = DB::query(" SELECT *, DATE_FORMAT(blog_date, '%Y年%m月%d日') AS blog_date FROM blog WHERE blog_id = :blog_id AND (blog_st = IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed = IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 ")->row(array(':blog_id' => $sel['i'])); } //初期ページは最新の記事 if(empty($row)) { $row = DB::query(" SELECT *, DATE_FORMAT(blog_date, '%Y-%m') AS blog_sel, DATE_FORMAT(blog_date, '%Y年%m月%d日') AS formatted_blog_date FROM blog WHERE ".($sel['c'] ? 'blog_cat = '.$sel['c'].' AND' : '')." (blog_st IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 ORDER BY blog_date DESC, blog_id DESC LIMIT 0, 1 ")->row(); if($row) { $sel['d'] = $row['blog_sel']; $sel['i'] = $row['blog_id']; } } if($row) { $tmp = DB::query(" SELECT blog_id FROM blog WHERE ".($sel['c'] ? 'blog_cat = '.$sel['c'].' AND' : '')." DATE_FORMAT(blog_date, '%Y-%m') = :blog_sel AND (blog_st = IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed = IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 ORDER BY blog_date DESC, blog_id DESC ")->all(array(':blog_sel' => $sel['d'])); $list = array(); foreach($tmp as $t) { $list[] = $t['blog_id']; } $pos = array_search($sel['i'], $list); if($pos !== false) { $stmt = DB::query(" SELECT blog_id, blog_title, DATE_FORMAT(blog_date, '%Y-%m') AS blog_sel, DATE_FORMAT(blog_date, '%Y年%m月%d日') AS blog_date FROM blog WHERE ".($sel['c'] ? 'blog_cat = '.$sel['c'].' AND' : '')." DATE_FORMAT(blog_date, '%Y-%m') = :blog_sel AND blog_id = :blog_id AND (blog_st = IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed = IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 "); if($pos > 0) { $first = $stmt->row(array(':blog_sel' => $sel['d'], ':blog_id' => $list[0])); $prev = $stmt->row(array(':blog_sel' => $sel['d'], ':blog_id' => $list[$pos - 1])); } if($pos < count($list) - 1) { $last = $stmt->row(array(':blog_sel' => $sel['d'], ':blog_id' => $list[count($list) - 1])); $next = $stmt->row(array(':blog_sel' => $sel['d'], ':blog_id' => $list[$pos + 1])); } } } $newest = DB::query(" SELECT blog_id, DATE_FORMAT(blog_date, '%Y年%m月%d日') AS formatted_blog_date, blog_cat, blog_title FROM blog WHERE (blog_st IS NULL OR blog_st <= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND (blog_ed IS NULL OR blog_ed >= DATE_FORMAT(NOW(), '%Y-%m-%d')) AND blog_delflg = 0 ORDER BY blog_date DESC, blog_id DESC LIMIT 0, 5 ")->all(); ?> <? if(!empty($row)): ?>