#!/usr/bin/perl


#2003/JULY   by toshi@abuu.co.jp
#大塚刷毛様・Topics と 新製品のご案内 の表示CGI

use Fcntl;
use DB_File;

require 'ohtsuka.pl';
require 'jcode.pl';
require 'cgi-lib.pl';
&ReadParse(*in);


$ID = $in{'id'};
$DB = $in{'db'};  #1/2/3

if ($DB eq '') { &Error('●入力エラー','使用方法が違います。'); }

if ($ID eq '') {
tie(%DB, DB_File, $ALL_NEW_DB[$DB], O_RDONLY, 0644)
   or &Error('●サーバーエラー',"$NEW_3TYPE{$DB}のDB $ALL_NEW_DB[$DB] がオープンできません。");
@DATA = values %DB;
untie %DB;
@tmp = map {(split /$DELIMITER/)[0]} @DATA;
@DATA = @DATA[sort {$tmp[$b] <=> $tmp[$a]} 0 .. $#tmp];
$DATA_LINE = @DATA[0];
&jcode'convert(*DATA_LINE,'sjis');
@data2 = split(/$DELIMITER/,$DATA_LINE);
 }
else {
tie(%DB, DB_File, $ALL_NEW_DB[$DB], O_RDONLY, 0644)
    or &Error('●サーバーエラー',"$NEW_3TYPE{$DB}のDB $ALL_NEW_DB[$DB] がオープンできません。");
    if (!$DB{$ID})   {  untie %DB;  &Error('●データ無し',"該当する$NEW_3TYPE{$DB}用のデータがありません。");  }
    $DATA = $DB{$ID};
untie %DB;
&jcode'convert(*DATA,'sjis');
@data2 = split(/$DELIMITER/,$DATA);
 }


&PrintConType;

#---------------------------------------------------------
if ($data2[1] eq 'A')   {

    if ($data2[11] eq '')   {  $data2[11] = $NO_IMG227_URL;  }
    if ($data2[12] eq '')   {  $data2[12] = $NO_IMG227_URL;  }

print << "END_OF_HTML";

<HTML>
<HEAD>
<!--file: template1.html -->
<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<TITLE>$data2[3]</TITLE>
<style type="text/css">
<!--
.footer {
  BACKGROUND-ATTACHEMENT: fixed;
  BACKGROUND-REPEAT: repeat-xy;
  BACKGROUND-IMAGE: url($CGI_IMG_DIR/footer_b.gif);
  BACKGROUND-COLOR: #ffffff; <SPAN CLASS="sml"></SPAN>
}
.sml {
font:10px/14px "sans serif";
text-decoration:none;
color:#5E5C6A;
}
.color {
font:10px/14px "sans serif";
text-decoration:none;
color:#00518b;
}
.title {
font:bold 12px/13px "sans serif";
text-decoration:none;
font-weight: bold;
color:#663333;
}
.title2 {
font:bold 12px/13px "sans serif";
text-decoration:none;
color:#D74D4F;
}
-->
</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF" LEFTMARGIN="0" TOPMARGIN="12" MARGINWIDTH="0" MARGINHEIGHT="12">
<table width="480" border="0" cellspacing="0" cellpadding="4">
  <tr>
    <td><table width="100%" border="0" cellpadding="4" cellspacing="0">
        <tr>
          <td class="footer" align="left"><SPAN CLASS="title">$data2[3]</SPAN></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td><table border="0" cellspacing="0" cellpadding="2" bgcolor="#CCCCCC">
        <tr>
          <td align="center">
                    <!-- 背景白のテーブル、外枠のグレーからの余白量はこの下の4と更に下の4で決まっている--->
            <table width="100%" border="0" cellspacing="0" cellpadding="4" bgcolor="#FFFFFF">
              <tr>
                <td valign="top">
                  <!--下段（特色）テーブルの始まり--->
                  <table border="0" cellspacing="0" cellpadding="2">
                    <tr>
                      <td valign="top"><table border="0" cellspacing="0" cellpadding="4">
                          <tr>
                            <td valign="top"><SPAN CLASS="title2">$data2[4]</SPAN></td>
                          </tr>
                          <tr>
                            <td valign="top"><img src="$UP_IMG_DIR/$data2[5]" width="209"></td>
                          </tr>
                          <tr>
                            <td valign="top"><SPAN CLASS="sml">$data2[6]</SPAN></td>
                          </tr>
                        </table></td>
                      <td rowspan="2" valign="top"> <table border="0" cellspacing="0" cellpadding="4">
                          <tr>
                            <td valign="top" valign="top"><img src="$UP_IMG_DIR/$data2[11]" width="227"></td>
                          </tr>
                          <tr>
                            <td valign="top"><img src="$UP_IMG_DIR/$data2[12]" width="227"></td>
                          </tr>
                        </table></td>
                    </tr>
                    <tr>
                      <td valign="top">
                        <!--下の下段（箇条書き）テーブルの始まり--->
                        <table border="0" cellspacing="0" cellpadding="4">

END_OF_HTML

@ALL_KTXT = ($data2[7],$data2[8],$data2[9],$data2[10]);
for  ($i = 0; $i <= 3; ++$i)   {
   if ($ALL_KTXT[$i] ne '')   {
print << "END_OF_HTML";
<tr>
<td valign="top"><span class="color">●</SPAN></td>
<td valign="top"><span class="color">$ALL_KTXT[$i]</SPAN></td>
</tr>
END_OF_HTML
   }
}

print << "END_OF_HTML";

</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body></html>

END_OF_HTML

exit(0);

}


#---------------------------------------------------------
elsif ($data2[1] eq 'B')   {

    if ($data2[11] eq '')   {  $data2[11] = $NO_IMG170_URL;  }
    if ($data2[12] eq '')   {  $data2[12] = $NO_IMG129_URL;  }
    if ($data2[13] eq '')   {  $data2[13] = $NO_IMG129_URL;  }

print << "END_OF_HTML";

<HTML>
<HEAD>
<!--file: dtemplate2.html -->
<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<TITLE>$data2[3]</TITLE>
<style type="text/css">
<!--
.footer {
  BACKGROUND-ATTACHEMENT: fixed;
  BACKGROUND-REPEAT: repeat-xy;
  BACKGROUND-IMAGE: url($CGI_IMG_DIR/footer_b.gif);
  BACKGROUND-COLOR: #ffffff; <SPAN CLASS="sml"></SPAN>
}
.sml {
font:10px/14px "sans serif";
text-decoration:none;
color:#5E5C6A;
}
.color {
font:10px/14px "sans serif";
text-decoration:none;
color:#00518b;
}
.title {
font:bold 12px/13px "sans serif";
text-decoration:none;
font-weight: bold;
color:#663333;
}
.title2 {
font:bold 12px/13px "sans serif";
text-decoration:none;
color:#D74D4F;
}
-->
</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF" LEFTMARGIN="0" TOPMARGIN="12" MARGINWIDTH="0" MARGINHEIGHT="12">
<table width="480" border="0" cellspacing="0" cellpadding="4">
          <tr>
            <td><table width="100%" border="0" cellpadding="4" cellspacing="0">
                <tr>
                  <td class="footer" align="left"><SPAN CLASS="title">$data2[3]</SPAN></td>
                </tr>
              </table></td>
          </tr>
          <tr>
            <td><table border="0" cellspacing="0" cellpadding="2" bgcolor="#CCCCCC">
                <tr>
                  <td align="center">
                    <!-- 背景白のテーブル、外枠のグレーからの余白量はこの下の4と更に下の4で決まっている--->
                    <table width="100%" border="0" cellspacing="0" cellpadding="4" bgcolor="#FFFFFF">
                      <tr>
                        <td>
                          <!--下段（特色）テーブルの始まり--->
                          <table border="0" cellspacing="0" cellpadding="2">
                            <tr>
                              <td><table border="0" cellspacing="0" cellpadding="4">
                                  <tr>
                                    <td valign="top"><SPAN CLASS="title2">$data2[4]</span></td>
                                  </tr>
                                  <tr>
 
                            <td valign="top"><img src="$UP_IMG_DIR/$data2[5]" width="266"></td>
                                  </tr>
                                  <tr>
 
                            <td valign="top"><SPAN CLASS="sml">$data2[6]</SPAN></td>
                                  </tr>
                                </table></td>
                              <td rowspan="2" valign="top"> <table border="0" cellspacing="0" cellpadding="4">
                          <tr>
                            <td valign="top"><img src="$UP_IMG_DIR/$data2[11]" width="170"></td>
                          </tr>
                        </table></td>
                            </tr>
                            <tr>
                              <td valign="top">
                                <!--下の下段（箇条書き）テーブルの始まり--->

                        <table border="0" cellspacing="0" cellpadding="4">

END_OF_HTML

@ALL_KTXT = ($data2[7],$data2[8],$data2[9],$data2[10]);
for  ($i = 0; $i <= 3; ++$i)   {
   if ($ALL_KTXT[$i] ne '')   {
print << "END_OF_HTML";
<tr>
<td valign="top"><span class="color">●</SPAN></td>
<td valign="top"><span class="color">$ALL_KTXT[$i]</SPAN></td>
</tr>
END_OF_HTML
   }
}

print << "END_OF_HTML";

 </table>
<table border="0" cellspacing="0" cellpadding="4">
<tr>
<td><img src="$UP_IMG_DIR/$data2[12]" width="129"></td>
<td><img src="$UP_IMG_DIR/$data2[13]" width="129"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>

END_OF_HTML

exit(0);

}


