session_start();
require("./admin/common.php");
//クラスファイル取り込み
require_once("./admin/my_sql.php");
//クラスインスタンス作成
$class_sql = new class_MySQL;
$one_clm_w = 360;
$comment_clm_w = 260;
$item_seq = $_GET["seq"];
$ret_url = $_GET["rpage"];
$s_mode = $_GET["s_mode"];
$ret_page = $_GET["page"];
if($s_mode == "new"){
$s_mode = "";
}
if($item_seq == ""){
$item_seq = $_SESSION['item_seq'];
}else{
$_SESSION['item_seq'] = $item_seq;
}
if($ret_url == ""){
$ret_url = $_SESSION['ret_url'];
}
if($ret_url == ""){
$ret_url = $site_url;
}
//$sql = "SELECT AccessDate,top,result,item_detail FROM T_Access";
$now_date_str = "'" . date( 'Y-m-d' ) . "'";
$sql = "SELECT item_detail FROM T_Access WHERE AccessDate = " . $now_date_str;
$class_sql->sql_query($sql);
if($row = $class_sql->sql_fetch()){
$group_code = $row["item_detail"];
$sql = "UPDATE T_Access SET item_detail = item_detail + 1 WHERE AccessDate = " . $now_date_str;
}else{
$sql = "INSERT INTO T_Access (AccessDate,top,result,item_detail) VALUES (" . $now_date_str . ",0,0,1)";
}
$class_sql->sql_query($sql);
if($item_seq != ""){
$sql = "SELECT * FROM TM_Item WHERE SeqNo=$item_seq";
$class_sql->sql_query($sql);
if($row = $class_sql->sql_fetch()){
$group_code = $row["GroupCode"];
$item_code = $row["ItemCode"];
$maker_code = $row["MakerCode"];
// $maker_item_code = $row["MakerItemCode"];
$item_name = $row["ItemName"];
$description = "家具の七福市:" . $item_name;
$color1 = $row["Color1"];
$color2 = $row["Color2"];
$color3 = $row["Color3"];
$color4 = $row["Color4"];
$color5 = $row["Color5"];
$color6 = $row["Color6"];
$type1 = $row["Type1"];
$search_words = $row["SearchWords"];
$search_words = str_replace(" ", ",", $search_words);
$search_words = str_replace(" ", ",", $search_words);
$title = $row["Title"];
// $title .= " 家具 和家具 家具の七福市 高級家具";
$order = $row["DispOrder"];
$price = $row["RegularPrice"];
$price_d = $row["DiscountPrice"];
$price_tax = $row["RegularPriceTax"];
$price_d_tax = $row["DiscountPriceTax"];
$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);
if(($pic_url_1 == "") && ($pic_url_2 == "") && ($pic_url_3 == "")){
$pic_url_1 = $pic_url_s;
$pic_tytle_1 = $item_name;
}
if($pic_url_1 == ""){
$pic_tytle_1 = "";
}
if($pic_url_2 == ""){
$pic_tytle_2 = "";
}
if($pic_url_3 == ""){
$pic_tytle_3 = "";
}
}
}
$my_page_parts = pathinfo($_SERVER["PHP_SELF"]);
$my_page = $my_page_parts['basename'];
// $s_mode = $_GET["s_mode"];
$group_id = $_GET["group_id"];
$condition = $_GET["condition"];
$disp_order = $_GET["disp_order"];
$cur_page = $_GET["page"];
$search_words = "七福市,家具,りーふ,高級家具," . $item_name;
$description = "和家具、" . $item_name . " ・ (株)りーふ の通販サイト";
require('header.php');
?>