{$g_main1}
{$pc_com}
| 品名 |
{$row["s_name"]} |
| 品番 |
{$row["s_code"]}{$row["c_code"]} |
| サイズ |
{$s_size} |
| 素材 |
{$s_sozai} |
| 詳細 |
{$detail} |
| 納期 |
{$nouki} |
| 送料 |
{$send} |
| 定価 |
{$teika} |
| 価格 |
{$price} |
";
return $str;
}
/*------------------------------------------------------------
商品オプション
------------------------------------------------------------*/
function search_option($row,$flg) {
if ($row["option_name".$flg]=="") {
return;
}
$array = explode("//",$row["s_option".$flg]);
$list=<<
{$row["option_name".$flg]} |
|
HTML;
return $list;
}
/*------------------------------------------------------------
パンくずリスト
------------------------------------------------------------*/
function pankuzu() {
$sql = "select * from shouhin_tb where s_code=? group by s_code";
$stmt = exec_sql($sql,array("s_code"=>$_GET["n"]));
if ($stmt->rowCount()<=0) {
return;
}
$rows=db_to_html($stmt->fetch(PDO::FETCH_ASSOC));
$sname = $rows["s_name"];
$sql = "select category,s_id,hierarchy,o_id from s_category_tb,category_tb ".
"where sc_id = s_id and ss_id = '".$rows["s_id"]."'";
$stmt = query_sql($sql);
if ($stmt->rowCount()<=0) {
return;
}
//複数カテゴリに対応
while($row=db_to_html($stmt->fetch(PDO::FETCH_ASSOC))) {
$rowc = $row;
$tmp = array();
$tmp[] = "
".$row["category"]." > ";
//親をサーチ
while ($rowc["hierarchy"]>1) {
$rowc = get_pdo("category_tb","*",array("s_id"=>$rowc["o_id"]));
$tmp[] = "
".$rowc["category"]." > ";
}
//配列を逆にする
$pan = array_reverse($tmp);
$list[] = implode("",$pan).$sname;
}
$str = implode("
",$list);
return "
トップ > ".$str;
}
/*------------------------------------------------------------
属性
------------------------------------------------------------*/
function get_zokusei($row) {
$ssl = SSL;
$zaiko_flg = FALSE;
//属性なし
if ($row["tate"]==="" && $row["yoko"]==="") {
return only_zaiko($row);
}
//属性がある
$stmt = query_sql("select * from zokusei_tb where o_id='".$row["s_id"]."' order by z_id");
while($rowz=db_to_html($stmt->fetch(PDO::FETCH_ASSOC))) {
$code[$rowz["z_type"]][$rowz["z_id"]] = $rowz["z_code"];
$name[$rowz["z_type"]][$rowz["z_id"]] = $rowz["z_name"];
}
//在庫の確認
$stmt = query_sql("select * from zaiko_tb where oz_id='".$row["s_id"]."' order by z_id");
while($rowa=db_to_html($stmt->fetch(PDO::FETCH_ASSOC))) {
$zaiko[$rowa["t_id"]][$rowa["y_id"]] = $rowa["zaiko"];
if ($rowa["zaiko"]==="" || $rowa["zaiko"]>0) {
$zaiko_flg = TRUE;
}
}
if ($row["yoko"]==="") { //1次元
$str=<<
{$row["tate"]} |
HTML;
if ($row["z_disp"]=="select") { //select表示
$str.=" |
HTML;
}
else { //テーブル表
$str=<<
HTML;
}
$str.=<<
-
HTML;
return $str;
}
//2次元
$str=<<
| {$row["tate"]}/{$row["yoko"]} |
HTML;
if ($row["z_disp"]=="select") {
$str.=" |
HTML;
}
else { //2次元テーブル
$str=<<
| ";
}
if ($zaiko_flg) { //在庫あり
$str.=<<
HTML;
return $str;
}
/*------------------------------------------------------------
属性なし 単品在庫の場合
------------------------------------------------------------*/
function only_zaiko($row) {
$ssl = SSL;
//単品在庫がない
if ($row["zaiko"]!=='' && $row["zaiko"]<1) {
$str=<<