function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$keyword = $requests['keyword'];
$category = $requests['category'];
$orderby = $requests['orderby'];
$page = $requests['page'];
// ----------
$page_size = 20;
$this->set('inc_navi', fetch_inc_navi("h"));
$this->set('category_disp', do_review_review_add_category_disp());
$this->set('category', $category);
$this->set('keyword', $keyword);
$this->set('orderby', $orderby);
list($result, $is_prev, $is_next, $total_num, $start_num, $end_num) = db_review_search_result4keyword_category($keyword, $category, $orderby, $page, $page_size);
$this->set('result', $result);
$this->set("is_prev", $is_prev);
$this->set("is_next", $is_next);
$this->set("page", $page);
$this->set("total_num", $total_num);
$this->set('start_num', $start_num);
$this->set('end_num', $end_num);
return 'success';
}
function execute($requests)
{
$u = $GLOBALS['AUTH']->uid();
// --- リクエスト変数
$keyword = $requests['keyword'];
$category_id = $requests['category_id'];
$page = $requests['page'];
$search_flag = $requests['search_flag'];
// ----------
$page_size = 10;
//固定
$this->set('inc_navi', fetch_inc_navi("h"));
$this->set('category_disp', do_review_review_add_category_disp());
$this->set('category_id', $category_id);
$this->set('keyword', $keyword);
if ($search_flag) {
if (empty($keyword) || empty($category_id)) {
if (empty($keyword)) {
$err_msg[] = 'キーワードを入力してください';
}
if (empty($category_id)) {
$err_msg[] = 'カテゴリを選択してください';
}
} else {
list($search_result, $page, $pages, $total_num) = do_review_add_search_result($keyword, $category_id, $page);
}
}
$this->set('search_result', $search_result);
$this->set('page', $page);
$this->set('is_prev', (bool) ($pages && $page > 1));
$this->set('is_next', (bool) ($pages && $page < $pages));
$this->set('err_msg', $err_msg);
$start_num = ($page - 1) * $page_size + 1;
$end_num = $page * $page_size;
if ($page_size > count($search_result)) {
$end_num = ($page - 1) * $page_size + count($search_result);
}
$this->set('total_num', $total_num);
$this->set('start_num', $start_num);
$this->set('end_num', $end_num);
return 'success';
}
function p_h_review_add_category_disp()
{
return do_review_review_add_category_disp();
}
function db_review_clip_list_h_review_clip_list4c_member_id($c_member_id, $page, $page_size = 30)
{
$sql = "SELECT * FROM c_review AS cr, c_review_clip AS crc" . " WHERE crc.c_review_id = cr.c_review_id" . " AND c_member_id = ?" . " ORDER BY crc.r_datetime";
$params = array(intval($c_member_id));
$list = db_get_all_page($sql, $page, $page_size, $params);
//カテゴリの表示名を取得
$category_disp = do_review_review_add_category_disp();
//$lstに書き込み数 + カテゴリ名 を追加
foreach ($list as $key => $value) {
$list[$key]['write_num'] = db_review_count_c_review_comment4c_review_id($value['c_review_id']);
$list[$key]['category_disp'] = $category_disp[$value['c_review_category_id']];
}
$sql = "SELECT COUNT(*) FROM c_review_clip WHERE c_member_id = ?";
$params = array(intval($c_member_id));
$total_num = db_get_one($sql, $params);
if ($total_num != 0) {
$total_page_num = ceil($total_num / $page_size);
if ($page >= $total_page_num) {
$next = false;
} else {
$next = true;
}
if ($page <= 1) {
$prev = false;
} else {
$prev = true;
}
}
$start_num = ($page - 1) * $page_size + 1;
$end_num = ($page - 1) * $page_size + $page_size > $total_num ? $total_num : ($page - 1) * $page_size + $page_size;
return array($list, $prev, $next, $total_num, $start_num, $end_num);
}
