ceil($total_pages – $range/2)) {
$start = $total_pages – $curpage + (ceil($curpage – ($range – 1)));
} else {
$start = ceil($curpage – ($range-1)/2)>1 ? ceil($curpage – ($range-1)/2) : 1;
}
if ($total_pages > $range)
$end = $start + $range – 1;
else
$end = $total_pages;
$pages = range($start, $end ? $end : 1);
$next = $curpage + 1;
$prev = $curpage – 1;
$first_group = 1;
$last_group = $start + $range;
$prev = $prev >= 1 ? $prev : null;
$next = $next <= $total_pages ? $next : null;
$first_group = ceil($curpage - ($range - 1)/2) > 1 ? $first_group : null;
$last_group = $last_group <= $total_pages ? $last_group : null;
return array(
'total_pages' => $total_pages,
‘curpage’ => $curpage,
‘pages’ => $pages,
‘prev’ => $prev,
‘next’ => $next,
‘first_group’ => $first_group,
‘last_group’ => $last_group,
‘offset’ => $offset,
‘limit’ => $perpage,
);
}
}
//プライスの配列
$price_array = array(‘open’=>”Open Price”,’1000’=>’~1,000円’,’2000’=>’~2,000円’,’3000’=>’~3,000円’,’4000’=>’~4,000円’,’5000’=>’~5,000円’,’10000’=>’~10,000円’,’over’=>’10,000円以上’);
//値の取得
if(empty($_REQUEST[‘price’])){
$price = ”;
}else{
$price = $_REQUEST[‘price’];
}
if($_REQUEST[‘c_flg’]==1 or empty($_REQUEST[‘c_flg’])){
$c_flg = “1”;
$c_class_1 = ‘ class=”on”‘;
$c_class_2 = ”;
}else{
$c_flg = $_REQUEST[‘c_flg’];
$c_class_1 = ”;
$c_class_2 = ‘ class=”on”‘;
}
if(empty($_REQUEST[‘pa’])){
$get_page = 1;
}else{
$get_page = $_REQUEST[‘pa’];
}
//価格設定の情報取得
function ProductInfoPriceGet($price,$c_flg,$get_page){
// 表示件数
$size = 20;
if($get_page==1 or empty($get_page)){
$p_page = $size*0;
}else{
$p_page = ($get_page-1)*$size;
}
//over対策
if(!empty($price)){
if($price==’over’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN 10001 AND 100000 “;
}elseif($price==’open’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price=’0′”;
}elseif($price==’10000′){
$s_price = $price-4999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}else{
$s_price = $price-999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}
}else{
$where = ” WHERE genre_list.exhibition_flg=’0′ “;
}
if($c_flg==1 or empty($c_flg)){
$order = ” ORDER BY genre_list.sale_date DESC”;
}else{
$order = ” ORDER BY CAST(product_info.unit_price AS SIGNED) DESC”;
}
$sql = “SELECT * FROM product_info INNER JOIN genre_list ON product_info.id=genre_list.id”.$where.$order.” LIMIT “.$p_page.”,”.$size;
$result = mysql_query($sql);
$data = array();
while($row = mysql_fetch_array($result)){
$data[] = $row;
}
return $data;
}
//価格のトータルカウントの取得
function ProductInfoPriceCntGet($price){
//over対策
if(!empty($price)){
if($price==’over’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN 10001 AND 100000 “;
}elseif($price==’open’){
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price=’0′”;
}elseif($price==’10000′){
$s_price = $price-4999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}else{
$s_price = $price-999;
$where = ” WHERE genre_list.exhibition_flg=’0′ AND product_info.tax_price BETWEEN “.$s_price.” AND “.$price.” “;
}
}else{
$where = ” WHERE genre_list.exhibition_flg=’0′ “;
}
$sql = “SELECT COUNT(*) AS cnt FROM product_info INNER JOIN genre_list ON product_info.id=genre_list.id”.$where;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
return $row[‘cnt’];
}
//ここで一覧取得
$price_data = ProductInfoPriceGet($price,$c_flg,$get_page);
$price_cnt = ProductInfoPriceCntGet($price);
//ページャー作成
$params[‘total’] = $price_cnt; //全件数(DBからselectするが、ここでは仮に代入)
if ($get_page) {
$params[‘curpage’] = $get_page;
} else {
$params[‘curpage’] = 1;
}
$params[‘perpage’] = 20; //1ページの表示件数
$params[‘range’] = 3; //1ページの表示ブロック数
/////////////////
// ページャー //
/////////////////
$pager = Pager::getPager($params[‘total’], $params[‘curpage’], $params[‘perpage’], $params[‘range’]);
//ページカウント
if(!empty($price_data)){
if($get_page==1){
$p_p = 1;
$p_n = 20;
}else{
$p_p = (20*$get_page)-20;
$p_n = (20*$get_page);
}
}else{
$price_cnt = 0;
$p_p = 0;
$p_n = 0;
}
/**********************/
/* URLの生成を行う */
/**********************/
if(empty($price)){
$url_new = “./”;
$url_ka = “./?c_flg=2″;
}else{
$url_new = “./?price=”.$price;
$url_ka = “./?price=”.$price.”&c_flg=2″;
}
?>
>
<< 前に戻る | << 前に戻る | << 前に戻る | << 前に戻る | =$price_cnt;?>件中/=$p_p;?>件~=$p_n;?>件 | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> | 次に進む >> |
$privalue){
$ex_sale_time = explode(“-“,$privalue[‘sale_date’]);
?>
=$privalue['catch_copy'];?>
‘); ‘); ‘); ‘); ‘); =ceil($s_cnt)){ ‘); ‘); ‘); ‘); ‘); ‘); ‘); ‘); ‘);
<< 前に戻る
}else{
print(‘
<< 前に戻る
}
}else{
if(empty($c_flg)){
print(‘
<< 前に戻る
}else{
print(‘
<< 前に戻る
}
}
}else{
print(‘
<< 前に戻る
} echo “\n”; ?>=$price_cnt;?>
件中/
=$p_p;?>
件~
=$p_n;?>
件
if(empty($price)){
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}else{
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}
}else{
if(empty($price)){
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}else{
if(empty($c_flg)){
print(‘
次に進む >>
}else{
print(‘
次に進む >>
}
}
}
}else{
print(‘
次に進む >>
} echo “\n”; ?>