5) || ($g_code == "")) return; if($grp_condition != "") $grp_condition .= " OR "; $grp_condition .= "(GroupCode = '" . $g_code . "')"; //クラスインスタンス作成 $class_sql = new class_MySQL; $sql = "SELECT GroupCode FROM TM_Group WHERE PCode = $g_code ORDER BY DispOrder"; $class_sql->sql_query($sql); while($row = $class_sql->sql_fetch()){ $grp_condition = make_group_condition($row['GroupCode'], $level+1, $grp_condition); } return $grp_condition; } function get_max_page($sql_condi, $s_mode) { //クラスインスタンス作成 $class_sql = new class_MySQL; if($sql_condi == ""){ $sql_condi = "SeqNo = 0"; } if($s_mode == "re1"){ $sql = "SELECT COUNT(*) AS AA FROM T_Recommend" . " LEFT JOIN TM_Item ON T_Recommend.ItemCode=TM_Item.ItemCode" . " WHERE T_Recommend.ItemCode IS NOT NULL"; }else{ $sql = "SELECT COUNT(*) AS AA FROM TM_Item WHERE $sql_condi"; } $class_sql->sql_query($sql); if($row = $class_sql->sql_fetch()){ $data_no = $row["AA"]; }else{ $data_no = 0; } $max_page = $data_no / 10; if($data_no % 10){ $max_page += 1; } return floor($max_page); } function disp_page_index($max_page, $now_page) { if($max_page < 1) return; echo "Page : "; if($now_page > 1){ $page = $now_page - 1; echo "前 -"; } for($page = 1 ; $page <= $max_page ; $page += 1){ if($page > 1){ echo "-"; } if($page == $now_page){ echo "[ $page ]"; }else{ echo " $page "; } } if($now_page < $max_page){ $page = $now_page + 1; echo "- 次"; } echo ""; } function disp_item_one_page($sql_condi, $disp_order, $page, $tax_rasio, $s_mode) { //クラスインスタンス作成 $class_sql = new class_MySQL; if($sql_condi == ""){ $sql_condi = "SeqNo = 0"; } $max_clm_no = 2; $clm_no = 0; $line_no = 0; if($s_mode == "re1"){ $sql = "SELECT TM_Item.* FROM T_Recommend" . " LEFT JOIN TM_Item ON T_Recommend.ItemCode=TM_Item.ItemCode" . " WHERE T_Recommend.ItemCode IS NOT NULL ORDER BY T_Recommend.DispOrder"; }else{ $sql = "SELECT * FROM TM_Item WHERE $sql_condi"; if($disp_order != ""){ $sql .= " ORDER BY " . $disp_order; }else{ $sql .= " ORDER BY DispOrder"; } } $max_data_no = $page * 10; $min_data_no = $max_data_no - 10; $data_no = 0; $class_sql->sql_query($sql); while($row = $class_sql->sql_fetch()){ $price = $row["RegularPrice"]; $price_d = $row["DiscountPrice"]; $price_tax = $row["RegularPriceTax"]; $price_d_tax = $row["DiscountPriceTax"]; if($price_tax == 0) continue; if($price_d_tax == 0) continue; $item_name = $row["ItemName"]; if(($item_name == "新しい商品") || ($item_name == "")) continue; $data_no += 1; if($data_no > $max_data_no) break; if($data_no <= $min_data_no) continue; if($clm_no == 0){ //echo ""; echo ""; } echo ""; $item_seq = $row["SeqNo"]; $group_code = $row["GroupCode"]; $item_code = $row["ItemCode"]; $maker_code = $row["MakerCode"]; // $maker_item_code = $row["MakerItemCode"]; $color1 = $row["Color1"]; $color2 = $row["Color2"]; $color3 = $row["Color3"]; $color4 = $row["Color4"]; $color5 = $row["Color5"]; $color6 = $row["Color6"]; $type1 = $row["Type1"]; // $order = $row["DispOrder"]; // $discount_rasio = $row["DiscountRasio"]; $carriage = $row["Carriage"]; $size_w = $row["SizeW"]; $size_h = $row["SizeH"]; $size_d = $row["SizeD"]; $size_len = $row["SizeLen"]; $size_ht = $row["SizeHT"]; $size_r = $row["SizeR"]; $weight = $row["Weight"]; $size_disp = $row["SizeDisp"]; $pic_url_s = stripslashes($row["PictureS"]); // $pic_url_1 = stripslashes($row["Picture1"]); // $pic_url_2 = stripslashes($row["Picture2"]); // $pic_url_3 = stripslashes($row["Picture3"]); // $pic_url_4 = stripslashes($row["Picture4"]); // $pic_url_5 = stripslashes($row["Picture5"]); // $pic_tytle_1 = $row["PicTytle1"]; // $pic_tytle_2 = $row["PicTytle2"]; // $pic_tytle_3 = $row["PicTytle3"]; // $pic_tytle_4 = $row["PicTytle4"]; // $pic_tytle_5 = $row["PicTytle5"]; $comment_s = $row["CommentS"]; // $comment_l = $row["CommentL"]; $comment_s = str_replace("\r\n", "
", $comment_s); // $comment_l = str_replace("\r\n", "
", $comment_l); //税込み価格 $price_tax_s = get_num_string_3sp($price_tax); $price_d_tax_s = get_num_string_3sp($price_d_tax); echo <<
$item_name
$item_name EOT; if($carriage != ""){ echo ""; } if($size_w > 0){ echo ""; } if($size_d > 0){ echo ""; } if($size_len > 0){ echo ""; } if($size_h > 0){ echo ""; } if($size_ht > 0){ echo ""; } if($size_r > 0){ echo ""; } if($weight > 0){ $weight_mod = $weight % 1000; if($weight_mod == 0){ $weight_s = sprintf("%d" ,$weight / 1000); }else{ $weight_s = sprintf("%.1f" ,$weight / 1000); } echo ""; } if($size_disp != ""){ echo ""; } echo <<
販売価格(税込)¥$price_d_tax_s
定価(税込)¥$price_tax_s
送料(税込)¥$carriage
$size_w ㎜
奥行き$size_d ㎜
長さ$size_len ㎜
高さ$size_h ㎜
総高さ$size_ht ㎜
直径$size_r ㎜
重さ$weight_s Kg
$size_disp
$comment_s
- 詳 細 -
商品番号:$item_code
EOT; $clm_no += 1; if($clm_no == $max_clm_no){ $clm_no = 0; echo ""; //}else{ // echo ""; } $line_no += 1; } if($clm_no > 0){ //カラム数揃ってない場合 while($clm_no < $max_clm_no){ echo " "; $clm_no += 1; } echo ""; } if($line_no == 0){ //1行もデータがない場合 echo ""; while($clm_no < $max_clm_no){ echo " "; $clm_no += 1; } echo ""; } //echo ""; } require("./admin/common.php"); //クラスファイル取り込み require_once("./admin/my_sql.php"); session_start(); $my_page_parts = pathinfo($_SERVER["PHP_SELF"]); $my_page = $my_page_parts['basename']; $search_words = "七福市,和家具,りーふ,家具"; if(isset($_GET["s_mode"])){ $s_mode = $_GET["s_mode"]; }else{ $s_mode = ""; } if(isset($_GET["g_id"])){ $g_id = $_GET["g_id"]; }else{ $g_id = ""; } if($g_id == ""){ if(isset($_GET["group_id"])){ $group_id = $_GET["group_id"]; }else{ $group_id = ""; } }else{ $group_id = $g_id; } if(isset($_GET["condition"])){ $condition = $_GET["condition"]; }else{ $condition = ""; } if(isset($_GET["disp_order"])){ $disp_order = $_GET["disp_order"]; }else{ $disp_order = ""; } if(isset($_GET["page"])){ $cur_page = $_GET["page"]; }else{ $cur_page = ""; } $title = "家具 和家具 家具の七福市 高級家具"; if($group_id != ""){ //クラスインスタンス作成 $class_sql = new class_MySQL; //アクセスカウンター更新 //$sql = "SELECT AccessDate,top,result,item_detail FROM T_Access"; $now_date_str = "'" . date( 'Y-m-d' ) . "'"; $sql = "SELECT AccessDate FROM T_Access WHERE AccessDate = " . $now_date_str; $class_sql->sql_query($sql); if($row = $class_sql->sql_fetch()){ $sql = "UPDATE T_Access SET result = result + 1 WHERE AccessDate = " . $now_date_str; }else{ $sql = "INSERT INTO T_Access (AccessDate,top,result,item_detail) VALUES (" . $now_date_str . ",0,1,0)"; } $class_sql->sql_query($sql); $class_sql->sql_query("SELECT GroupName,Tytle,KeyWord FROM TM_Group WHERE GroupCode = '$group_id'"); if($row = $class_sql->sql_fetch()){ $title = $row["GroupName"]; $grp_title = $row["Tytle"]; if($grp_title !=""){ $title .= $grp_title; } $search_words = $row["KeyWord"]; } } if($s_mode == "re1"){ $title = "和家具 家具の七福市 激安"; $search_words = "和家具,家具,七福市,高級家具,安売"; } $description = "和家具 家具の七福市 " . $grp_title . " (株)りーふ の通販サイト"; require('header.php'); ?>
$max_page)){ echo ""; echo ""; }else{ disp_page_index($max_page, $cur_page); disp_item_one_page($sql_condi, $disp_order, $cur_page, $tax_rasio, $s_mode); disp_page_index($max_page, $cur_page); } ?>
該当商品ありません。
"; echo "トップ