
<?php

//=====商品陳列ページ=====

//概略…商品をカテゴリ別に陳列して販売する。商品毎に注文ポタンを付け、ショッピングカートに商品情報を送り、フォームメールにて商品の注文を受ける。

//=====管理画面===========

//概略…商品データの登録・修正・削除・表示場所の移動ができる。又、受注メール管理画面において、商品の発送処理等が可能。



//共通設定ファイルを読み込み

include("./conf.php");



//スーパーグローバル変数対策

if(!isset($PATH_TRANSLATED)){

    $path = dirname($_SERVER["PATH_TRANSLATED"]).$up_dir;

}else{

    $path = dirname($PATH_TRANSLATED).$up_dir;

}

if(!isset($PHP_SELF)){ $PHP_SELF = $_SERVER["PHP_SELF"]; }

if(!isset($mode)){

    if($_POST['mode']){

        $mode = $_POST['mode'];

    }else{

        $mode = $_GET['mode'];

    }

}

if(!isset($kanri_flag)){

    if($_POST['kanri_flag']){

        $kanri_flag = $_POST['kanri_flag'];

    }else{

        $kanri_flag = $_GET['kanri_flag'];

    }

}

if(!isset($kind)){

    if($_POST['kind']){

        $kind = $_POST['kind'];

    }else{

        $kind = $_GET['kind'];

    }

}

if(!isset($action)){

    if($_POST['action']){

        $action = $_POST['action'];

    }else{

        $action = $_GET['action'];

    }

}

if(!isset($password)){

    if($_POST['password']){

        $password = $_POST['password'];

    }else{

        $password = $_GET['password'];

    }

}

if(!isset($code)){ $code = $_POST['code']; }

if(!isset($g_name)){ $g_name = $_POST['g_name']; }

if(!isset($weight)){ $weight = $_POST['weight']; }

if(!isset($fname)){ $fname = $_POST['fname']; }

if(!isset($fname2)){ $fname2 = $_POST['fname2']; }

if(!isset($fname3)){ $fname3 = $_POST['fname3']; }

if(!isset($fname4)){ $fname4 = $_POST['fname4']; }

if(!isset($price)){ $price = $_POST['price']; }

if(!isset($expl)){ $expl = $_POST['expl']; }

if(!isset($g_amount)){ $g_amount = $_POST['g_amount']; }

if(!isset($button)){ $button = $_POST['button']; }

if(!isset($fname_del)){ $fname_del = $_POST['fname_del']; }

if(!isset($fname2_del)){ $fname2_del = $_POST['fname2_del']; }

if(!isset($fname3_del)){ $fname3_del = $_POST['fname3_del']; }

if(!isset($fname4_del)){ $fname4_del = $_POST['fname4_del']; }

if(!isset($upfile)){ $upfile = $_FILES['upfile']['tmp_name']; }

if(!isset($upfile_name)){ $upfile_name = $_FILES['upfile']['name']; }

if(!isset($upfile2)){ $upfile2 = $_FILES['upfile2']['tmp_name']; }

if(!isset($upfile2_name)){ $upfile2_name = $_FILES['upfile2']['name']; }

if(!isset($upfile3)){ $upfile3 = $_FILES['upfile3']['tmp_name']; }

if(!isset($upfile3_name)){ $upfile3_name = $_FILES['upfile3']['name']; }

if(!isset($upfile4)){ $upfile4 = $_FILES['upfile4']['tmp_name']; }

if(!isset($upfile4_name)){ $upfile4_name = $_FILES['upfile4']['name']; }

if(!isset($e_code)){

    if($_POST['e_code']){

        $e_code = $_POST['e_code'];

    }else{

        $e_code = $_GET['e_code'];

    }

}

if(!isset($pline)){ $pline = $_POST['pline']; }



if(!$kind){ $kind = 0; }

?>



<HTML>

<HEAD>

    <META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=Shift_JIS">

    <TITLE><?php echo $shop_title ?></TITLE>

    <STYLE TYPE="text/css">

    <!--

    :link     {

            Color : blue ;

            Text-Decoration : UnderLine

        }

    :active     {

            Color : blue ;

            Text-Decoration : UnderLine

        }

    :visited     {

            Color : blue ;

            Text-Decoration : UnderLine

        }

    A:hover     {

            Color : blue ;

            Text-Decoration : None

        }

    -->

    </STYLE>

</HEAD>

<BODY>

<CENTER>

<IMG SRC="shop_title.gif" WIDTH="345" HEIGHT="53" ALIGN="BOTTOM" BORDER="0">



<?php

//データベースに接続

if($db_passwd){

    $sql_str = "user=" . $db_user . " password=" . $db_passwd . " dbname=" . $db_name;

}else{

    $sql_str = "user=" . $db_user . " dbname=" . $db_name;

}

$d_base = pg_connect($sql_str) or die("接続エラー");



if(($action == "edit") && ($password == $passwd)){

    //モード切替リンクを表示

    echo "<FORM ACTION=./order.php METHOD=POST>\n";

    echo "<INPUT TYPE=HIDDEN NAME=password VALUE=$passwd>\n";

    echo "<INPUT TYPE=HIDDEN NAME=kind VALUE=$kind>\n";

    echo "<P><TABLE BORDER=0 CELLSPACING=1 WIDTH=400 BGCOLOR=#666666><TR>\n";

    echo "<td align=center WIDTH=50% BGCOLOR=#FFFFFF><B>商品管理</B></td><td align=center WIDTH=50% BGCOLOR=#FFFFFF><input type=submit value=受注管理></td></TR></TABLE></FORM>\n";

}

//カテゴリを表示

echo "<P><TABLE BORDER=0><TR>\n";

if($action == "view"){

    echo "<TD><A HREF='JavaScript:history.back();' onMouseOver=this.style.color='red' onMouseOut=this.style.color='blue'>元のページへ戻る</A></TD>\n";

}else{

    if(($action == "edit") && ($password == $passwd)){

        echo "<TD COLSPAN=$cat_num><B>［商品管理画面］</B>カテゴリ：" . $category[$kind] . "</TD>";

    }else{

        for($i=0;$i<$cat_num;$i++){

            if($kind == $i){

                echo "<TD>" . $category[$i] . "</TD>";

            }else{

                echo "<TD><A HREF=$PHP_SELF?action=$action&kind=$i onMouseOver=this.style.color='red' onMouseOut=this.style.color='blue'>" . $category[$i] . "</A></TD>";

            }

            if($i < $cat_num - 1){

                echo "<TD>&nbsp;</TD>";

            }

        }

    }

}

echo "</TR></TABLE>\n";

//送料サービス表示

if($soryo_free > 0){

    $soryo_free = number_format($soryo_free);

    echo "<BR><FONT SIZE=4 COLOR='blue'><B>" . $soryo_free . "</B></FONT>円以上のお買い上げで、送料無料サービス致します。\n";

}

echo "</P>\n";



if($action == "regist"){

    //処理の分岐

    if($button == "修正" && $kind){

        if(!$weight){ $weight = 0; }

        if(!$price){ $price = 0; }

        if(!$g_amount){ $g_amount = 0; }

        //ここから書き込みデータの調整

        $price = str_replace(",", "",$price); //桁区切りのコンマ対策

        //在庫数の制限

        if($g_amount > 999){ $g_amount = 999; }

        //画像の削除指定があれば、削除。

        if($fname_del > 0){

            unlink(".".$up_dir.$fname);

        }

        if($fname2_del > 0){

            unlink(".".$up_dir.$fname2);

        }

        if($fname3_del > 0){

            unlink(".".$up_dir.$fname3);

        }

        if($fname4_del > 0){

            unlink(".".$up_dir.$fname4);

        }

        //画像のアップロード処理

        if(is_uploaded_file($upfile)){

            $imagesize = getimagesize($upfile); //画像の属性を取得

            switch($imagesize[2]){

                case 1:

                    $out = $e_code . ".gif";

                    break;

                case 2:

                    $out = $e_code . ".jpg";

                    break;

                case 3:

                    $out = $e_code . ".png";

                    break;

                default:

                    unlink($upfile);

            }

            if($out){

                $sendpath = $path.$out;

                if(move_uploaded_file($upfile, $sendpath)){

                    chmod($sendpath,0666);

                    $fname = $out;

                }

            }

        }

        //画像のアップロード処理2

        if(is_uploaded_file($upfile2)){

            $imagesize2 = getimagesize($upfile2); //画像の属性を取得

            switch($imagesize2[2]){

                case 1:

                    $out2 = $e_code . "-2.gif";

                    break;

                case 2:

                    $out2 = $e_code . "-2.jpg";

                    break;

                case 3:

                    $out2 = $e_code . "-2.png";

                    break;

                default:

                    unlink($upfile2);

            }

            if($out2){

                $sendpath2 = $path.$out2;

                if(move_uploaded_file($upfile2, $sendpath2)){

                    chmod($sendpath2,0666);

                    $fname2 = $out2;

                }

            }

        }

        //画像のアップロード処理3

        if(is_uploaded_file($upfile3)){

            $imagesize3 = getimagesize($upfile3); //画像の属性を取得

            switch($imagesize3[2]){

                case 1:

                    $out3 = $e_code . "-3.gif";

                    break;

                case 2:

                    $out3 = $e_code . "-3.jpg";

                    break;

                case 3:

                    $out3 = $e_code . "-3.png";

                    break;

                default:

                    unlink($upfile3);

            }

            if($out3){

                $sendpath3 = $path.$out3;

                if(move_uploaded_file($upfile3, $sendpath3)){

                    chmod($sendpath3,0666);

                    $fname3 = $out3;

                }

            }

        }

        //画像のアップロード処理4

        if(is_uploaded_file($upfile4)){

            $imagesize4 = getimagesize($upfile4); //画像の属性を取得

            switch($imagesize4[2]){

                case 1:

                    $out4 = $e_code . "-4.gif";

                    break;

                case 2:

                    $out4 = $e_code . "-4.jpg";

                    break;

                case 3:

                    $out4 = $e_code . "-4.png";

                    break;

                default:

                    unlink($upfile4);

            }

            if($out4){

                $sendpath4 = $path.$out4;

                if(move_uploaded_file($upfile4, $sendpath4)){

                    chmod($sendpath4,0666);

                    $fname4 = $out4;

                }

            }

        }

        //アップデート

            $sql = "update " . $g_table . " set kind = " . $kind . ",g_name = '" . $g_name . "',weight = " . $weight . ",fname = '" . $fname . "',fname2 = '" . $fname2 . "',fname3 = '" . $fname3 . "',fname4 = '" . $fname4 . "',price = " . $price . ",expl = '" . $expl . "',g_amount = " . $g_amount . " where code = " . $e_code;

            pg_query($d_base, $sql) or die("データ更新エラー");

    }elseif($button == "削除"){

        if($e_code){

            //画像の削除処理

            $sql = "select * from " . $g_table . " where code = " . $code;

            $result = pg_query($d_base, $sql) or die("データ抽出エラー");

            $arr = pg_fetch_array($result, 0); //検索結果の一行分を配列に格納

            $fname = $arr['fname'];

            $fname2 = $arr['fname2'];

            unlink(".".$up_dir.$fname);

             unlink(".".$up_dir.$fname2);

            //該当データを削除

            $sql = "delete from " . $g_table . " where code = " . $e_code;

            pg_query($d_base, $sql) or die("データ削除エラー");

        }

    }else{

        if($kind && $g_name){

            $code = time(); //アクセス時の秒数

            if(!$weight){ $weight = 0; }

            if(!$price){ $price = 0; }

            if(!$g_amount){ $g_amount = 0; }

            //ここから書き込みデータの調整

            $g_name = str_replace(" ", "&nbsp;",$g_name); //空白対策

            $g_name = str_replace("　", "&nbsp;",$g_name);

            $price = str_replace(",", "&#44;",$price); //桁区切りのコンマ対策

            //在庫数の制限

            if($g_amount > 999){ $g_amount = 999; }

            //画像のアップロード処理

            if(is_uploaded_file($upfile)){

                $imagesize = getimagesize($upfile); //画像の属性を取得

                switch($imagesize[2]){

                    case 1:

                        $out = $code . ".gif";

                        break;

                    case 2:

                        $out = $code . ".jpg";

                        break;

                    case 3:

                        $out = $code . ".png";

                        break;

                    default:

                        unlink($upfile);

                }

                if($out){

                    $sendpath = $path.$out;

                    if(move_uploaded_file($upfile, $sendpath)){

                        chmod($sendpath,0666);

                        $fname = $out;

                    }

                }

            }

            //画像のアップロード処理2

            if(is_uploaded_file($upfile2)){

                $imagesize2 = getimagesize($upfile2); //画像の属性を取得

                switch($imagesize2[2]){

                    case 1:

                        $out2 = $code . "-2.gif";

                        break;

                    case 2:

                        $out2 = $code . "-2.jpg";

                        break;

                    case 3:

                        $out2 = $code . "-2.png";

                        break;

                    default:

                        unlink($upfile2);

                }

                if($out2){

                    $sendpath2 = $path.$out2;

                    if(move_uploaded_file($upfile2, $sendpath2)){

                        chmod($sendpath2,0666);

                        $fname2 = $out2;

                    }

                }

            }

            //画像のアップロード処理3

            if(is_uploaded_file($upfile3)){

                $imagesize3 = getimagesize($upfile3); //画像の属性を取得

                switch($imagesize3[2]){

                    case 1:

                        $out3 = $code . "-3.gif";

                        break;

                    case 2:

                        $out3 = $code . "-3.jpg";

                        break;

                    case 3:

                        $out3 = $code . "-3.png";

                        break;

                    default:

                        unlink($upfile3);

                }

                if($out3){

                    $sendpath3 = $path.$out3;

                    if(move_uploaded_file($upfile3, $sendpath3)){

                        chmod($sendpath3,0666);

                        $fname3 = $out3;

                    }

                }

            }

            //画像のアップロード処理4

            if(is_uploaded_file($upfile4)){

                $imagesize4 = getimagesize($upfile4); //画像の属性を取得

                switch($imagesize4[2]){

                    case 1:

                        $out4 = $code . "-4.gif";

                        break;

                    case 2:

                        $out4 = $code . "-4.jpg";

                        break;

                    case 3:

                        $out4 = $code . "-4.png";

                        break;

                    default:

                        unlink($upfile4);

                }

                if($out4){

                    $sendpath4 = $path.$out4;

                    if(move_uploaded_file($upfile4, $sendpath4)){

                        chmod($sendpath4,0666);

                        $fname4 = $out4;

                    }

                }

            }

            //新規書き込み

            $sql = "insert into " . $g_table . " values ($code, $kind, '$g_name', $weight, '$fname', '$fname2', '$fname3', '$fname4', $price, '$expl', $g_amount)";

            pg_query($d_base, $sql) or die("データ登録エラー");

        }

    }

    echo "<META HTTP-EQUIV=refresh CONTENT=0;URL=$PHP_SELF?kind=$kind>\n";

    exit;

}

//管理画面表示

if(($action == "edit") && ($password == $passwd)){

    $kanri_flag = 1; //管理モード

    if(!$e_code){

        echo "<TABLE BORDER=0 CELLSPACING=1 WIDTH=600>\n";

        echo "<form action=$PHP_SELF method=POST>\n";

        echo "<TR><TD WIDTH=50%><P ALIGN=RIGHT>\n";

        echo "<INPUT TYPE=HIDDEN NAME=action VALUE=edit>\n";

        echo "<INPUT TYPE=HIDDEN NAME=password VALUE=" . $passwd . ">\n";

        echo "<INPUT TYPE=HIDDEN NAME=kind VALUE=" . $kind . ">\n";

        echo "<INPUT TYPE=HIDDEN NAME=e_code VALUE=1>\n";

        echo "<INPUT TYPE=SUBMIT NAME=Submit VALUE=新規商品を登録する></TD></FORM>\n";

        echo "<form action=$PHP_SELF method=POST>\n";

        echo "<TD WIDTH=50%>\n";

        echo "<INPUT TYPE=SUBMIT NAME=Submit VALUE=ログアウト></TD></TR></TABLE></FORM>\n";

    }else{

        //商品データ登録・修正画面を表示

        echo "<form action=$PHP_SELF method=POST ENCTYPE=multipart/form-data>\n";

        echo "<INPUT TYPE=HIDDEN NAME=kind VALUE=$kind>\n";

        echo "<TABLE BORDER=0 CELLSPACING=1 WIDTH=600 BGCOLOR=#666666>\n";

        if($e_code > 1){

            echo "<CAPTION><P><B>＜データ修正＞</B></CAPTION>\n";

            $sql = "select * from " . $g_table . " where code = " . $e_code; 

            $result = pg_query($d_base, $sql) or die("データ抽出エラー");

            $arr = pg_fetch_array($result, 0); //検索結果の一行分の各値を配列に格納

            $code = $arr['code'];

            $kind2 = $arr['kind'];

            $g_name = $arr['g_name'];

            $weight = $arr['weight'];

            $fname = $arr['fname'];

            $fname2 = $arr['fname2'];

            $fname3 = $arr['fname3'];

            $fname4 = $arr['fname4'];

            $price = $arr['price'];

            $expl = $arr['expl'];

            $g_amount = $arr['g_amount'];



            echo "<input type=hidden name=action value=regist>\n";

            echo "<input type=hidden name=e_code value=\"$code\">\n";

            echo "<tr><td align=right BGCOLOR=#CCFFFF>商品コード</td><td colspan=2 BGCOLOR=#FFFFFF>" . $rcode . "（変更不可）</td></tr>\n";

        }else{

            echo "<CAPTION><P><B>＜新規登録＞</B></CAPTION>\n";

            echo "<input type=hidden name=action value=regist>\n";

            echo "<tr><td align=right BGCOLOR=#CCFFFF>商品コード</td><td colspan=2 BGCOLOR=#FFFFFF>自動取得</td></tr>\n";

        }

        echo "<tr><td align=right WIDTH=17% BGCOLOR=#CCFFFF>商品カテゴリ</td><td colspan=2 BGCOLOR=#FFFFFF><SELECT NAME=kind>";

        for($i=0;$i<$cat_num;$i++){

            echo "<OPTION VALUE=". $i . (($i == $kind2) ? ' SELECTED' : '') . ">" . $category[$i] . "</OPTION>";

        }

        echo "</SELECT> <FONT SIZE=2 COLOR=#CC0000> *新規登録の場合は必ず商品カテゴリを選択して下さい。</FONT></td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>商品名</td><td colspan=2 BGCOLOR=#FFFFFF><input type=text size=50 name=g_name value=\"$g_name\"></td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>重さ</td><td colspan=2 BGCOLOR=#FFFFFF><input type=text size=10 name=weight value=\"$weight\">g</td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>商品画像１</td><td colspan=2 BGCOLOR=#FFFFFF>";

        if($fname && file_exists("$path$fname")){

            $size = getimagesize("$path$fname");

            $img_w=$size[0];

            $img_h=$size[1];

            if($img_w > $w_max2 || $img_h > $h_max2){

                $w_ritu = $w_max2 / $img_w;

                $h_ritu = $h_max2 / $img_h;

                ($w_ritu < $h_ritu) ? $key = $w_ritu : $key = $h_ritu;

                $width = (int) $img_w * $key;

                $height = (int) $img_h * $key;

                echo "<A HREF=.$up_dir$fname TARGET=_blank><img src=.$up_dir$fname WIDTH=" . $width . " HEIGHT=" . $height . " ALT=拡大画像を見る></A>";

            }else{

                echo "<img src=.$up_dir$fname border=0>";

            }

            echo "<input type=hidden name=fname value=\"$fname\"><INPUT TYPE=CHECKBOX NAME=fname_del VALUE=1>削除";

        }else{

            echo "登録 <INPUT TYPE=file NAME=upfile SIZE=20><FONT SIZE=2 COLOR=#CC0000> *GIF、JPG、PNG画像のみ有効。</FONT>";

        }

        echo "</td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>商品画像２</td><td colspan=2 BGCOLOR=#FFFFFF>";

        if($fname2 && file_exists("$path$fname2")){

            $size = getimagesize("$path$fname2");

            $img_w=$size[0];

            $img_h=$size[1];

            if($img_w > $w_max2 || $img_h > $h_max2){

                $w_ritu = $w_max2 / $img_w;

                $h_ritu = $h_max2 / $img_h;

                ($w_ritu < $h_ritu) ? $key = $w_ritu : $key = $h_ritu;

                $width = (int) $img_w * $key;

                $height = (int) $img_h * $key;

                echo "<A HREF=.$up_dir$fname2 TARGET=_blank><img src=.$up_dir$fname2 WIDTH=" . $width . " HEIGHT=" . $height . " ALT=拡大画像を見る></A>";

            }else{

                echo "<img src=.$up_dir$fname2 border=0>";

            }

            echo "<input type=hidden name=fname2 value=\"$fname2\"><INPUT TYPE=CHECKBOX NAME=fname2_del VALUE=1>削除";

        }else{

            echo "登録 <INPUT TYPE=file NAME=upfile2 SIZE=20><FONT SIZE=2 COLOR=#CC0000> *GIF、JPG、PNG画像のみ有効。</FONT>";

        }

        echo "</td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>商品画像３</td><td colspan=2 BGCOLOR=#FFFFFF>";

        if($fname3 && file_exists("$path$fname3")){

            $size = getimagesize("$path$fname3");

            $img_w=$size[0];

            $img_h=$size[1];

            if($img_w > $w_max2 || $img_h > $h_max2){

                $w_ritu = $w_max2 / $img_w;

                $h_ritu = $h_max2 / $img_h;

                ($w_ritu < $h_ritu) ? $key = $w_ritu : $key = $h_ritu;

                $width = (int) $img_w * $key;

                $height = (int) $img_h * $key;

                echo "<A HREF=.$up_dir$fname3 TARGET=_blank><img src=.$up_dir$fname3 WIDTH=" . $width . " HEIGHT=" . $height . " ALT=拡大画像を見る></A>";

            }else{

                echo "<img src=.$up_dir$fname3 border=0>";

            }

            echo "<input type=hidden name=fname3 value=\"$fname3\"><INPUT TYPE=CHECKBOX NAME=fname3_del VALUE=1>削除";

        }else{

            echo "登録 <INPUT TYPE=file NAME=upfile3 SIZE=20><FONT SIZE=2 COLOR=#CC0000> *GIF、JPG、PNG画像のみ有効。</FONT>";

        }

        echo "</td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>商品画像４</td><td colspan=2 BGCOLOR=#FFFFFF>";

        if($fname4 && file_exists("$path$fname4")){

            $size = getimagesize("$path$fname4");

            $img_w=$size[0];

            $img_h=$size[1];

            if($img_w > $w_max2 || $img_h > $h_max2){

                $w_ritu = $w_max2 / $img_w;

                $h_ritu = $h_max2 / $img_h;

                ($w_ritu < $h_ritu) ? $key = $w_ritu : $key = $h_ritu;

                $width = (int) $img_w * $key;

                $height = (int) $img_h * $key;

                echo "<A HREF=.$up_dir$fname4 TARGET=_blank><img src=.$up_dir$fname4 WIDTH=" . $width . " HEIGHT=" . $height . " ALT=拡大画像を見る></A>";

            }else{

                echo "<img src=.$up_dir$fname4 border=0>";

            }

            echo "<input type=hidden name=fname4 value=\"$fname4\"><INPUT TYPE=CHECKBOX NAME=fname4_del VALUE=1>削除";

        }else{

            echo "登録 <INPUT TYPE=file NAME=upfile4 SIZE=20><FONT SIZE=2 COLOR=#CC0000> *GIF、JPG、PNG画像のみ有効。</FONT>";

        }

        echo "</td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>提供価格</td><td colspan=2 BGCOLOR=#FFFFFF><input type=text size=15 name=price value=\"$price\">円（税込総額）</td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>商品説明</td><td colspan=2 BGCOLOR=#FFFFFF><textarea name=expl rows=3 cols=60>" . $expl . "</textarea></td></tr>\n";

        echo "<tr><td align=right BGCOLOR=#CCFFFF>在庫数</td><td colspan=2 BGCOLOR=#FFFFFF><input type=text size=10 name=g_amount value=\"$g_amount\"></td></tr>\n";

        echo "</TABLE>\n";

        echo "<TABLE BORDER=0 CELLSPACING=1 WIDTH=600>\n";

        echo "<TR><TD WIDTH=17%></TD><TD WIDTH=30%>\n";

        if($e_code > 1){

            echo "<input type=submit name=button value=修正> <input type=submit name=button value=削除></td></form>\n";

        }else{

            echo "<input type=submit value=登録> <input type=reset value=リセット></td></form>\n";

        }

        echo "<td><form action=$PHP_SELF method=POST><input type=submit value=ログアウト></td></tr>\n";

        echo "</table></form>\n";

    }

}

//個別商品データを表示

if($action == "view" && $e_code){

    $sql = "select * from " . $g_table . " where code = '" . $e_code . "'";

    $result = pg_query($d_base, $sql) or die("データ抽出エラー");

    $row = pg_numrows($result); //検索結果の行数を取得

    if($row > 0){

        $arr = pg_fetch_array($result, 0); //検索結果の一行分を配列に格納

        $kind = $arr['kind'];

        echo "<FORM ACTION=$PHP_SELF METHOD=POST>\n";

        echo "<INPUT TYPE=hidden NAME=action VALUE=edit>\n";

        echo "<INPUT TYPE=hidden NAME=e_code VALUE=" . $arr['code'] . ">\n";

        echo "<TABLE BORDER=0 CELLSPACING=1 WIDTH=650 BGCOLOR=#666666>\n";

        echo "<TR><TD WIDTH=10% BGCOLOR=#CCFFCC><FONT SIZE=2>カテゴリ</FONT></TD><TD WIDTH=30% BGCOLOR='white'>" . $category[$kind] . "</TD>\n";

        //商品画像

        $rowspan = 7;

        if($kanri_flag){ $rowspan++; }

        if($zaiko_kanri){ $rowspan++; }

        echo "<TD BGCOLOR='white' ROWSPAN=$rowspan VALIGN=TOP><P ALIGN=CENTER>";

        //画像１

        $fname = $arr['fname'];

        $g_flag = 0;



?>



<SCRIPT language="JavaScript">

<!--

function syasin(mySrc){

    document.pic.src=mySrc;

}



function moto(){

    document.pic.src="<?php echo "." . $up_dir . $fname; ?>";

}

//-->

</SCRIPT>



<?php



        if($fname && file_exists("$path$fname")){

            $size = getimagesize("$path$fname");

            $img_w=$size[0];

            $img_h=$size[1];

            if($img_w > $w_max){

                $w_ritu = $w_max / $img_w;

                $width = (int) $img_w * $w_ritu;

                $height = (int) $img_h * $w_ritu;

                echo "<img src=.$up_dir$fname WIDTH=" . $width . " HEIGHT=" . $height . " border=0 name=pic>";

            }else{

                echo "<img src=.$up_dir$fname border=0 name=pic>";

            }

            echo "<BR><BR>";

            //画像２

            $fname2 = $arr['fname2'];

            if($fname2 && file_exists("$path$fname2")){

                $g_flag++;

                $size = getimagesize("$path$fname2");

                $img_w=$size[0];

                $img_h=$size[1];

                if($img_w > $w_max2){

                    $w_ritu = $w_max2 / $img_w;

                    $width = (int) $img_w * $w_ritu;

                    $height = (int) $img_h * $w_ritu;

                    echo "<A HREF=JavaScript:void() onMouseOver=syasin('." . $up_dir . $fname2 . "') onMouseOut=moto()><img src=.$up_dir$fname2 WIDTH=" . $width . " HEIGHT=" . $height . " BORDER=0></A>";

                }else{

                    echo "<img src=.$up_dir$fname2 border=0>";

                }

            }

            //画像３

            $fname3 = $arr['fname3'];

            if($fname3 && file_exists("$path$fname3")){

                $g_flag++;

                $size = getimagesize("$path$fname3");

                $img_w=$size[0];

                $img_h=$size[1];

                if($img_w > $w_max2){

                    $w_ritu = $w_max2 / $img_w;

                    $width = (int) $img_w * $w_ritu;

                    $height = (int) $img_h * $w_ritu;

                    echo " <A HREF=JavaScript:void() onMouseOver=syasin('." . $up_dir . $fname3 . "') onMouseOut=moto()><img src=.$up_dir$fname3 WIDTH=" . $width . " HEIGHT=" . $height . " border=0></A>";

                }else{

                    echo " <img src=.$up_dir$fname3 border=0>";

                }

            }

            //画像４

            $fname4 = $arr['fname4'];

            if($fname4 && file_exists("$path$fname4")){

                $g_flag++;

                $size = getimagesize("$path$fname4");

                $img_w=$size[0];

                $img_h=$size[1];

                if($img_w > $w_max2){

                    $w_ritu = $w_max2 / $img_w;

                    $width = (int) $img_w * $w_ritu;

                    $height = (int) $img_h * $w_ritu;

                    echo " <A HREF=JavaScript:void() onMouseOver=syasin('." . $up_dir . $fname4 . "') onMouseOut=moto()><img src=.$up_dir$fname4 WIDTH=" . $width . " HEIGHT=" . $height . " border=0></A>";

                }else{

                    echo " <img src=.$up_dir$fname4 border=0>";

                }

            }

            if($g_flag){

                echo "<BR><FONT SIZE=2 COLOR='blue'>▲マウスオーバーで画像が切り替わります▲</FONT>\n";

            }

        }else{

            echo "<img src=./printing.gif border=0>";

        }

        echo "</TD></TR>\n";

        echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>商品コード</FONT></TD><TD BGCOLOR='white'>" . $arr['code'] . "</TD></TR>\n";

        echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>商品名</FONT></TD><TD BGCOLOR='white'><FONT COLOR='blue'><B>" . $arr['g_name'] . "</B></FONT>";

        if($action == 'edit' && $password == $passwd){

            echo "　<INPUT TYPE=hidden NAME=password VALUE=\"$passwd\"><INPUT TYPE=SUBMIT VALUE=訂正>";

        }

        echo "</TD></TR></FORM>\n";

        echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>重さ</FONT></TD><TD BGCOLOR='white'>";

        if($arr['weight']){

            echo number_format($arr['weight']) . "g";

        }else{

            echo "－";

        }

        echo "</TD></TR>\n";

        echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>価格</FONT></TD><TD BGCOLOR='white'>";

        if($arr['price']){

            echo "<FONT SIZE=4 COLOR='red'><B>" . number_format($arr['price']) . "</B></FONT>円<FONT SIZE=2>（税込）</FONT>";

        }else{

            echo "－";

        }

        echo "</TD></TR>\n";

        echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>商品説明</FONT></TD><TD BGCOLOR='white'>";

        if($arr['expl']){

            $expl2 = nl2br($arr['expl']);

            echo "<FONT SIZE=2>" . $expl2 . "</FONT>";

        }else{

            echo "－";

        }

        echo "</TD></TR>\n";

        echo "<FORM ACTION=$php_path METHOD=POST>\n";

        echo "<INPUT TYPE=hidden NAME=action VALUE=regist>\n";

        echo "<INPUT TYPE=hidden NAME=code VALUE=" . $arr['code'] . ">\n";

        echo "<INPUT TYPE=hidden NAME=goods VALUE=" . $arr['g_name'] . ">\n";

        echo "<INPUT TYPE=hidden NAME=weight VALUE=" . $arr['weight'] . ">\n";

        echo "<INPUT TYPE=hidden NAME=price VALUE=" . $arr['price'] . ">\n";

        if($zaiko_kanri){

            if($arr['g_amount'] > 0){

                echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>在庫数</FONT></TD><TD BGCOLOR='white'>" . $arr['g_amount'] . "</FONT></TD></TR>";

                echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>注文</FONT></TD><TD BGCOLOR='white'><SELECT NAME=amount>";

                if($arr['g_amount'] > 99){

                    $g_amount = 99;

                }else{

                    $g_amount = $arr['g_amount'];

                }

                for($j=1;$j<=$g_amount;$j++){

                    echo "<OPTION VALUE=$j>" . $j . "</OPTION>";

                }

                echo "</SELECT>";

                echo " <INPUT TYPE=SUBMIT VALUE=カートに入れる>";

            }else{

                echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>在庫数</FONT></TD><TD BGCOLOR='white'><FONT COLOR='red'>在庫切れ</FONT>";

            }

        }else{

            echo "<TR><TD BGCOLOR=#CCFFCC><FONT SIZE=2>注文</FONT></TD><TD BGCOLOR='white'><SELECT NAME=amount>";

            for($j=1;$j<100;$j++){

                echo "<OPTION VALUE=$j>" . $j . "</OPTION>";

            }

            echo "</SELECT>";

            echo " <INPUT TYPE=SUBMIT VALUE=カートに入れる>";

        }

        echo "</TD></TR></TABLE></FORM>\n";

        echo "</TD>\n";

        

        echo "</TD></TR></TABLE>\n";

    }else{

        echo "<P><FONT COLOR='red'>※該当の商品はございません。※</FONT></P>\n";

    }

}else{

    //商品データを表示

    if($kind){

        $sql = "select * from " . $g_table . " where kind = " . $kind . " order by " . $kijun . " " . $junjo;

    }else{

        $sql = "select * from " . $g_table . " order by " . $kijun . " " . $junjo;

    }

    $result = pg_query($d_base, $sql) or die("データ抽出エラー");

    $row = pg_numrows($result); //検索結果の行数を取得

    if($row > 0){

        echo "<TABLE BORDER=0 CELLSPACING=1 WIDTH=650 BGCOLOR=#666666>\n";

        echo "<TR><TD WIDTH=15% BGCOLOR=#CCFFCC><P ALIGN=CENTER>画像</TD><TD BGCOLOR=#CCFFCC><P ALIGN=CENTER>カテゴリ</TD><TD BGCOLOR=#CCFFCC><P ALIGN=CENTER>商品名<FONT COLOR='blue'>（詳細）</FONT></TD><TD BGCOLOR=#CCFFCC><P ALIGN=CENTER>価格</TD><TD BGCOLOR=#CCFFCC><P ALIGN=CENTER>在庫数</TD></TR>";

        for($i=0; $i<$row; $i++){

            $arr = pg_fetch_array($result, $i); //検索結果の一行分を配列に格納



            echo "<FORM ACTION=$PHP_SELF METHOD=POST>\n";

            echo "<INPUT TYPE=hidden NAME=action VALUE=edit>\n";

            echo "<INPUT TYPE=hidden NAME=kind VALUE=\"$kind\">\n";

            echo "<INPUT TYPE=hidden NAME=e_code VALUE=" . $arr['code'] . ">\n";

            echo "<TR><TD BGCOLOR='white'>\n";

            //商品画像

            $fname = $arr['fname'];

            if($fname && file_exists("$path$fname")){

                $size = getimagesize("$path$fname");

                $img_w=$size[0];

                $img_h=$size[1];

                if($img_w > $w_max2 || $img_h > $h_max2){

                    $w_ritu = $w_max2 / $img_w;

                    $h_ritu = $h_max2 / $img_h;

                    ($w_ritu < $h_ritu) ? $key = $w_ritu : $key = $h_ritu;

                    $width = (int) $img_w * $key;

                    $height = (int) $img_h * $key;

                    echo "<img src=.$up_dir$fname WIDTH=" . $width . " HEIGHT=" . $height . " border=0>";

                }else{

                    echo "<img src=.$up_dir$fname border=0>";

                }

            }

            echo "</TD><TD BGCOLOR='white'><FONT SIZE=2>\n";

            //カテゴリ

            $kind2 = $arr['kind'];

            echo $category[$kind2];

            echo "</FONT></TD><TD BGCOLOR='white'>\n";

            //商品名

            echo "<A HREF=$PHP_SELF?action=view&e_code=" . $arr['code'] . "&kanri_flag=$kanri_flag onMouseOver=this.style.color='red' onMouseOut=this.style.color='blue'><B>" . $arr['g_name'] . "</B></A>";

            if($action == 'edit' && $password == $passwd){

                echo "　<INPUT TYPE=hidden NAME=password VALUE=\"$passwd\"><INPUT TYPE=SUBMIT VALUE=訂正>";

            }

            echo "</TD><TD BGCOLOR='white'>\n";

            //価格

            if($arr['price'] > 0){

                echo number_format($arr['price']) . "円";

            }else{

                echo "<P ALIGN=CENTER>－";

            }

            echo "</TD><TD BGCOLOR='white'>\n";

            //在庫数

            if($arr['g_amount'] > 0){

                echo number_format($arr['g_amount']) . "個";

            }else{

                echo "<P ALIGN=CENTER>－";

            }

            echo "</TD>";

            echo "</TR></FORM>\n";

        }

        echo "</TABLE>\n";

    }else{

        echo "<P><FONT COLOR='red'>※該当の商品はございません。※</FONT></P>\n";

    }

}

echo "<P><TABLE BORDER=0 WIDTH=600>\n";

echo "<TR><TD ALIGN=CENTER>\n";

if($kanri_flag){

    echo "&nbsp;</TD>\n";

}else{

    echo "<form action=$php_path method=POST>\n";

    echo "<input type=submit value=カートの中身を見る></TD></form>\n";

}

echo "</TR></TABLE></P>\n";

if(!$kanri_flag){

    echo "<HR>\n";

    echo "<form action=$PHP_SELF method=POST>\n";

    echo "<input type=hidden name=action value=edit>\n";

    echo "<input type=hidden name=kind value=$kind>\n";

    echo " パスワード：<input type=password size=5 name=password>\n";

    echo " <input type=submit value=管理>\n";

    echo "</form>\n";

}

?>



</CENTER>

</BODY>

</HTML>