
<?php

//=====受注情報管理ページ=====

//概略…受注情報の一覧表示、及び事後処理の管理ができる。



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

include("./conf.php");



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

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

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($pline)){ $pline = $_POST['pline']; }

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

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

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

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

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

?>



<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 == "regist"){

    if($del_flag){ //データ削除

        $sql = "delete from " . $h_table . " where order_id = " . $order_id;

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

    }else{

        //アップデート

        $sql = "update " . $h_table . " set hassoubi = '" . $hassoubi . "',memo = '" . $memo . "' where order_id = " . $order_id;

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

    }

}



//管理画面表示

if($password == $passwd){

    $kanri_flag = 1; //管理モードフラグ

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

    echo "<FORM ACTION=./goods.php METHOD=POST>\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 "<TABLE BORDER=0 CELLSPACING=1 WIDTH=400 BGCOLOR=#666666><TR>\n";

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

    echo "<form action=goods.php method=POST><INPUT TYPE=HIDDEN NAME=kind VALUE=$kind><input type=submit value=ログアウト></form>\n";



    //発注データを抽出

    $sql = "select * from " . $h_table . " order by order_id DESC";

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

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

    if($row > 0){

        if($pline == ""){

            $p_line = 0;

        }else{

            $p_line = $pline;

        }

        $end_data = $row - 1;

        $page_end = $p_line + ($page_view - 1);

        if($page_end >= $end_data){ $page_end = $end_data; }

        for($i=$p_line; $i<=$page_end; $i++){

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

            $order_id = $arr['order_id'];

            $name = $arr['name'];

            $hacchubi = $arr['hacchubi'];

            $order_list = $arr['order_list'];

            $sum = $arr['sum'];

            $soryo_price = $arr['soryo_price'];

            $daibiki_price = $arr['daibiki_price'];

            $sogokei = $arr['sogokei'];

            $shiharai = $arr['shiharai'];

            $pcode = $arr['pcode'];

            $address = $arr['address'];

            $email = $arr['email'];

            $comment = $arr['comment'];

            $name2 = $arr['name2'];

            $pcode2 = $arr['pcode2'];

            $address2 = $arr['address2'];

            $noshi = $arr['noshi'];

            $noshi2 = $arr['noshi2'];

            $hassoubi = $arr['hassoubi'];

            $memo = $arr['memo'];



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

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

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

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

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

            echo "<TR><TH WIDTH=15% BGCOLOR=#CCFFCC><FONT SIZE=2>オーダーID</FONT></TH><TH WIDTH=25% BGCOLOR=#CCFFCC><FONT SIZE=2>受注日</FONT></TH><TH COLSPAN=3 BGCOLOR=#CCFFCC><FONT SIZE=2>注文内容</FONT></TH></TR>\n";

            echo "<TR><TD BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

            echo $order_id;

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

            echo "<TD BGCOLOR=#FFFFFF><P ALIGN=CENTER><FONT SIZE=2>\n";

            echo $hacchubi;

            echo "</FONT></TD><TD COLSPAN=7 BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

            echo $order_list;

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

            echo "<TR><TH WIDTH=15% BGCOLOR=#CCFFCC><FONT SIZE=2>価格合計</FONT></TH><TH WIDTH=25% BGCOLOR=#CCFFCC><FONT SIZE=2>送料</FONT></TH><TH WIDTH=20% BGCOLOR=#CCFFCC><FONT SIZE=2>代引手数料</FONT></TH><TH WIDTH=20% BGCOLOR=#CCFFCC><FONT SIZE=2>総合計</FONT></TH><TH WIDTH=20% BGCOLOR=#CCFFCC><FONT SIZE=2>支払方法</FONT></TH></TR>\n";

            echo "<TR><TD BGCOLOR=#FFFFFF><P ALIGN=RIGHT><FONT SIZE=2>\n";

            echo number_format($sum) . "円";

            echo "</FONT></TD><TD BGCOLOR=#FFFFFF><P ALIGN=RIGHT><FONT SIZE=2>\n";

            if($soryo_price){

                echo number_format($soryo_price) . "円";

            }else{

                echo "－円";

            }

            echo "</FONT></TD><TD BGCOLOR=#FFFFFF><P ALIGN=RIGHT><FONT SIZE=2>\n";

            if($daibiki_price){

                echo number_format($daibiki_price) . "円";

            }else{

                echo "－円";

            }

            echo "</FONT></TD><TD BGCOLOR=#FFFFFF><P ALIGN=RIGHT><FONT SIZE=2>\n";

            echo number_format($sogokei) . "円";

            echo "</FONT></TD><TD BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

            echo $shiharai;

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

            echo "<TR><TH WIDTH=15% BGCOLOR=#CCFFCC><FONT SIZE=2>注文者</FONT></TH><TH COLSPAN=2 BGCOLOR=#CCFFCC><FONT SIZE=2>住所</FONT></TH><TH COLSPAN=2 BGCOLOR=#CCFFCC><FONT SIZE=2>E-mail</FONT></TH></TR>\n";

            echo "<TR><TD BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

            echo $name;

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

            echo "<TD COLSPAN=2 BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

            if($pcode){

                echo "〒" . $pcode . " ";

            }

            echo $address;

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

            echo "<TD COLSPAN=2 BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

            echo "<A HREF=mailto:$email onMouseOver=this.style.color='red' onMouseOut=this.style.color='blue'>" . $email . "</A>";

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

            if($comment){

                echo "<TR><TH WIDTH=15% BGCOLOR=#CCFFCC><FONT SIZE=2>コメント</FONT></TH><TD COLSPAN=4 BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

                echo $comment;

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

            }

            if($name2){

                echo "<TR><TH WIDTH=15% BGCOLOR=#FFCCCC><FONT SIZE=2>発送先</FONT></TH><TH COLSPAN=2 BGCOLOR=#FFCCCC><FONT SIZE=2>住所</FONT></TH><TH BGCOLOR=#FFCCCC><FONT SIZE=2>のし</FONT></TH><TH BGCOLOR=#FFCCCC><FONT SIZE=2>のし説明</FONT></TH></TR>\n";

                echo "<TR><TD BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

                echo $name2;

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

                echo "<TD COLSPAN=2 BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

                if($pcode2){

                    echo "〒" . $pcode2 . " ";

                }

                echo $address2;

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

                echo "<TD BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

                echo $noshi;

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

                echo "<TD BGCOLOR=#FFFFFF><FONT SIZE=2>\n";

                if($noshi2){

                    echo $noshi2;

                }else{

                    echo "－";

                }

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

            }

            echo "<TR><TH WIDTH=15% BGCOLOR=#CCFFFF><FONT SIZE=2>発送処理</FONT></TH><TD COLSPAN=4 BGCOLOR=#FFFFFF>\n";

            echo "<FONT SIZE=2>発送日：<input type=text size=14 name=hassoubi value=\"$hassoubi\"> メモ：\n";

            echo "<input type=text size=25 name=memo value=\"$memo\"> <INPUT TYPE=CHECKBOX NAME=del_flag VALUE=1>受注データ削除 <input type=submit name=button value=送信>";

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

        }

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

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

        //「前のページ」ボタンを表示

        if($page_end >= $page_view){

            $page_count = floor($page_end / $page_view);

            $prev_line = ($page_count - 1) * $page_view;

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

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

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

            echo "<input type=submit value=前のページ>\n";

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

        }else{

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

        }

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

        //「次のページ」ボタンを表示

        $next_line = $page_end + 1;

        if($page_end != $end_data){

            print "<form method=Post action=$PHP_SELF>\n";

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

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

            echo "<input type=submit value=次のページ>\n";

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

        }else{

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

        }

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

    }else{

        echo "<P><FONT COLOR='red'>※注文メールはございません。※</FONT></P>\n";

    }

}

?>



</CENTER>

</BODY>

</HTML>