<?
  require('./lib.php');

  mb_http_output('SJIS');
  mb_internal_encoding('SJIS');
  header('Content-type: text/html; charset=Shift_JIS');

  #ini_set('session.use_cookies', 0);
  #session_cache_limiter('nocache');
  session_start();

  $PMakerCode    = $_REQUEST['MakerCode'];
  $PCarCode      = $_REQUEST['CarCode'];
  $PCategoryCode = $_REQUEST['CategoryCode'];
  $PKeyword      = $_REQUEST['Keyword'];
  $Page          = $_REQUEST['Page'];
  $SID           = $_REQUEST['SID'];

  $RecPerPage = 6;     #1ページあたりの表示件数
  if(!$Page) $Page = 1;

  $Keyword = str_replace('，',',',$Keyword);
  $Keyword = str_replace('/' ,',',$Keyword);
  $Keyword = str_replace('／',',',$Keyword);
  $Keyword = str_replace(' ' ,',',$Keyword);
  $Keyword = str_replace('　',',',$Keyword);
  $Keyword_UTF = $Keyword;


  #---データベースに接続する
  require("config.php");
  $con =mysql_connect(HOST,USER,PASS)
        or die("接続できません");
  $result1 = mysql_select_db(DBNAME,$con)
        or die("データベースがありません");

  #---商品テーブルから指定された検索条件に合致するデータを読み込む
  $syohin = array();
  $sql = "SELECT SyohinNo, MakerCode, MakerName, CarCode, CarName, SyohinName, Kakaku, Photo1 FROM t_syohin ";
  $where = "";
  if($PMakerCode){
     $PMakerCode = str_pad($_REQUEST['MakerCode'],3,0,STR_PAD_LEFT);
     $where = $where . "MakerCode = '" . $PMakerCode . "' ";
  }
  if($PCarCode){
     if($where){$where = $where . "AND ";}
     $where = $where . "CarCode = '" . $PCarCode . "' ";
  }
  if($PCategoryCode){
     if($where){$where = $where . "AND ";}
     $where = $where . "(Catgry1Code = '" . $PCategoryCode . "' ";
     $where = $where . "OR ";
     $where = $where . "Catgry2Code = '" . $PCategoryCode . "') ";
  }
  if($PKeyword){
     $PKeyword = mb_convert_encoding($PKeyword,'EUC-JP','SJIS');
     if($where){$where = $where . "AND ";}
     $where = $where . "(SyohinName LIKE '%" . $PKeyword . "%'";
     $where = $where . "OR ";
     $where = $where . " CarName = '%" . $PKeyword . "%'";
     $where = $where . "OR ";
     $where = $where . " Setumei = '%" . $PKeyword . "%')";
  }

  if($where){$sql = $sql . "WHERE " . $where;}
  $result = mysql_query($sql,$con);
  $syohin_max = mysql_num_rows($result);
  while($row = mysql_fetch_assoc($result))
  {
    $SyohinNo   = $row[SyohinNo];
    $SyohinName = mb_convert_encoding($row[SyohinName],'SJIS','EUC-JP');
    $MakerCode  = $row[MakerCode];
    $MakerName  = mb_convert_encoding($row[MakerName],'SJIS','EUC-JP');
    $CarCode    = $row[CarCode];
    $CarName    = mb_convert_encoding($row[CarName],'SJIS','EUC-JP');
    $Kakaku     = $row[Kakaku];
    $Photo1     = $row[Photo1];

    array_push($syohin,compact('SyohinNo','SyohinName','MakerCode','MakerName','CarCode','CarName','Kakaku','Photo1'));

  }


  #---パラメータの名称を取得する
  if($PMakerCode){
    $sql = "SELECT MakerName FROM m_maker ";
    $sql = $sql . "WHERE MakerCode = '" . $PMakerCode . "'";
    $result = mysql_query($sql,$con);
    $row = mysql_fetch_assoc($result);
    $PMakerName = mb_convert_encoding($row[MakerName],'SJIS','EUC-JP');
  }

  if($PCarCode){
    $sql = "SELECT CarName FROM m_car ";
    $sql = $sql . "WHERE MakerCode = '" . $PMakerCode . "' ";
    $sql = $sql . "AND CarCode = '" . $PCarCode . "' ";
    $result = mysql_query($sql,$con);
    $row = mysql_fetch_assoc($result);
    $PCarName = mb_convert_encoding($row[CarName],'SJIS','EUC-JP');
  }
  if($PCategoryCode){
    $sql = "SELECT CategoryName FROM m_category ";
    $sql = $sql . "WHERE CategoryCode = '" . $PCategoryCode . "' ";
    $result = mysql_query($sql,$con);
    $row = mysql_fetch_assoc($result);
    $PCategoryName = mb_convert_encoding($row[CategoryName],'SJIS','EUC-JP');
  }

  
  mysql_close($con);


  #-----ページ表示用開始レコードと終了レコード計算 -----------------
  $s_rec = ($Page-1) * $RecPerPage;
  $e_rec = $s_rec + $RecPerPage - 1;
  if($e_rec >= $syohin_max) $e_rec = $syohin_max - 1;
  $maxpage = (int)($syohin_max / $RecPerPage);
  if($maxpage * $rec_p_page < $syohin_max) $maxpage++;
  if($Page > $maxpage) $Page = $maxpage;

?>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS">
<title>検索商品一覧</title>
<link href="../style.css" rel="stylesheet" type="text/css">

<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>

<?
  if($syohin_max == 0){
     echo "<script>";
     echo "alert('該当するデータはありません。')";
     echo "location.href = './index.php";
     echo "</script>";
  }
?>

<style type="text/css">
<!--
a:hover {
	color: #3399FF;
}
-->
</style>

</head>

<body bgcolor="#6C757F" link="#003399" vlink="#3366CC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

  <table width=820 BORDER=0 align="center" cellpadding=0 cellspacing=0>
    <tr>
      <td rowspan=2><img src="../images/CONTENTS_01_01.gif" width=5 height=186 alt=""></td>
      <td colspan=7><img src="../images/CONTENTS_01_02.gif" width=809 height=156 alt=""></td>
      <td rowspan=2><img src="../images/CONTENTS_01_03.gif" width=6 height=186 alt=""></td>
    </tr>
    <tr>
      <td><img src="../images/CONTENTS_01_04.gif" width=119 height=30 alt=""></td>
      <td><a href="http://www.agras.co.jp/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','../images/CONTENTS_02_05.gif',1)"><img src="../images/CONTENTS_01_05.gif" name="Image11" width="126" height="30" border="0"></a></td>
      <td><a href="http://www.agras.co.jp/newparts/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image12','','../images/CONTENTS_02_06.gif',1)"><img src="../images/CONTENTS_01_06.gif" name="Image12" width="136" height="30" border="0"></a></td>
      <td><img src="../images/CONTENTS_03_07.gif" width=118 height=30 alt=""></td>
      <td><a href="http://www.agras.co.jp/ad/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image13','','../images/CONTENTS_02_08.gif',1)"><img src="../images/CONTENTS_01_08.gif" name="Image13" width="145" height="30" border="0"></a></td>
      <td><a href="http://www.agras.co.jp/company/" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image14','','../images/CONTENTS_02_09.gif',1)"><img src="../images/CONTENTS_01_09.gif" name="Image14" width="128" height="30" border="0"></a> </td>
      <td><img src="../images/CONTENTS_01_10.gif" width=37 height=30 alt=""></td>
    </tr>
    <tr>
      <td colspan=9><img src="../images/CONTENTS_01_11.gif" width=820 height=15 alt=""></td>
    </tr>
  </table>

<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="10" background="cart_images/image_1_b.jpg"></td>
    <td width="800" valign="top" background="cart_images/image_1_j.jpg" bgcolor="#FFFFFF"><table width="800" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td><img src="cart_images/image_1_c.jpg" width="800" height="60"></td>
        </tr>
        <tr> 
          <td><img src="cart_images/image_1_g.jpg" width="800" height="55"></td>
        </tr>
      </table>
      <div align="center"> 
        <table width="560" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td bgcolor="#FFFFFF"><div align="center"> 
                <table width="520" border="0" cellspacing="0" cellpadding="3">
                  <tr> 
                    <td bgcolor="#CCCCCC"><b>検索商品一覧</b><font size="-2"><br>
                        <font size="-2">
                        <? if($PMakerCode){ ?>
                          メーカー:<? echo $PMakerName;?>&nbsp;&nbsp;
                        <? }else{ ?>
                          メーカー：指定なし&nbsp;&nbsp;
                        <? } ?>
                        <? if($PCarCode){ ?>
                          車種:<? echo $PCarName;?>&nbsp;&nbsp;
                        <? }else{ ?>
                          車種：指定なし&nbsp;&nbsp;
                        <? } ?>
                        <? if($PCategoryCode){ ?>
                          パーツカテゴリー:<? echo $PCategoryName;?>&nbsp;&nbsp;
                        <? }else{ ?>
                          パーツカテゴリー：指定なし&nbsp;&nbsp;
                        <? } ?>
                        <? if($PKeyword){ ?>
                          キーワード:<? echo $PKeyword;?>&nbsp;&nbsp;
                        <? }else{ ?>
                          キーワード：指定なし&nbsp;&nbsp;
                        <? } ?>
                        </font>
                      </td>
                    </tr>
                  </table>

                  <table width="520" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td align="right"><img src="../top_contents_image/no_image.gif" width="2" height="10"></td>
                    </tr>
                    <tr>
                      <td align="center">[
                        <? if($Page > 9){ ?>
                          <a href="#" onclick="document.sendform.Page.value='<? echo $Page - 9;?>';
                                               document.sendform.submit();">&nbsp;&lt;&lt;&nbsp;</a>/
                        <? } ?> 
                        <? $s = $Page - 4;
                           $e = $Page + 4;
                           if($s < 1){
                              $s = 1;
                              $e = 9;
                           }
                           if($e > $maxpage) $e = $maxpage;
                           for($i = $s ; $i <= $e ; $i++){?>
                               <? if($i != $s){ ?>/<? } ?>
                               <? if($i == $Page){?>
                                 <b>&nbsp;<? echo $i;?>&nbsp;</b>
                               <? }else{ ?>
                                 <a href="#" onclick="document.sendform.Page.value='<? echo $i;?>';
                                                      document.sendform.submit();">&nbsp;<? echo $i;?>&nbsp;</a>
                               <? } ?>
                           <? } ?>
                           <? if($e < $maxpage){ ?>
                             /<a href="#" onclick="document.sendform.Page.value='<? echo $Page + 9;?>';
                                                   document.sendform.submit();">&nbsp;&gt;&gt;&nbsp;</a>
                           <? } ?>
                      ]</td>
                    </tr>
                    <tr>
                      <td><img src="../top_contents_image/no_image.gif" width="2" height="10"></td>
                    </tr>
                  </table>

                  <table width="520" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td bgcolor="#333333"><table width="520" border="0" cellpadding="2" cellspacing="1">
                        <tbody>
                          <tr align="center">
                            <td width="72"><font color="#ffffff" size="3">写真</font></td>
                            <td width="89"><font color="#ffffff" size="3">車種</font></td>
                            <td width="166"><font color="#ffffff" size="3">商品名</font></td>
                            <td width="115"><font color="#ffffff" size="3">価格</font></td>
                            <td width="52"> <font color="#ffffff" size="3">詳細</font></td>
                          </tr>
                          <? for($i=$s_rec;$i<=$e_rec;$i++){ ?>
                            <tr align="center" bgcolor="#E6E6E6">
                              <td><font size="2">
                                <? if($syohin[$i]['Photo1'] && file_exists('../parts_img/' . $syohin[$i]['Photo1'])){?>
                                  <img src="../parts_img/<? echo $syohin[$i]['Photo1']?>" width="70">
                                <? }else{ ?>
                                  <img src="../parts_img/no_img.jpg" width="70">
                                <? } ?>
                              </font></td>
                              <td><font size="2"><? echo $syohin[$i]['CarName'];?></font></td>
                              <td bgcolor="#E6E6E6" align="left"><font color="#CC0000" size="2"><? echo $syohin[$i]['SyohinName'];?></font></td>
                              <td><font size="2">\<? echo number_format($syohin[$i]['Kakaku']);?><br>
                               （税込\<? echo number_format((int)($syohin[$i]['Kakaku']*1.05+0.5));?>）</font><br>
                              </td>
                              <td><font color="#0000FF" size="3">

                                  <a href="syosai.php?SyohinNo=<? echo $syohin[$i]['SyohinNo'];?>&MakerCode=<? echo $PMakerCode;?>&CarCode=<? echo $PCarCode;?>&CategoryCode=<? echo $PCategoryCode;?>&Keyword=<? echo $PKeyword;?>&Page=<? echo $Page;?>">
                                  <font size="-2">詳細</font></a></font>
                              </td>
                            </tr>
                            <tr align="center">
                              <td colspan="5" bgcolor="#ffffff"><font size="2">&nbsp;</font></td>
                            </tr>
                          <? } ?>
                        </tbody>
                      </table></td>
                    </tr>
                  </table>
                  <table width="520" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td><img src="../top_contents_image/no_image.gif" width="2" height="10"></td>
                    </tr>
                    <tr>
                      <td align="center">[
                        <? if($Page > 9){ ?>
                          <a href="#" onclick="document.sendform.Page.value='<? echo $Page - 9;?>';document.sendform.submit();">&nbsp;&lt;&lt;&nbsp;</a>/
                        <? } ?>
                        <? $s = $Page - 4;
                          $e = $Page + 4;
                          if($s < 1){
                             $s = 1;
                             $e = 9;
                          }
                          if($e > $maxpage) $e = $maxpage;
                          for($i = $s ; $i <= $e ; $i++){?>
                            <? if($i != $s){ ?>/<? } ?>
                            <? if($i == $Page){?>
                              <b>&nbsp;<? echo $i;?>&nbsp;</b>
                            <? }else{ ?>
                              <a href="#" onclick="document.sendform.Page.value='<? echo $i;?>';document.sendform.submit();">&nbsp;<? echo $i;?>&nbsp;</a>
                            <? } ?>
                          <? } ?>
                          <? if($e < $maxpage){ ?>
                            /<a href="#" onclick="document.sendform.Page.value='<? echo $Page + 9;?>';document.sendform.submit();">&nbsp;&gt;&gt;&nbsp;</a>
                          <? } ?>
                        ]</td>
                    </tr>
                    <tr>
                      <td><img src="../top_contents_image/no_image.gif" width="2" height="25"></td>
                    </tr>
                    <tr>
                      <td align="center">[ <a href="index.php">検索トップページへ戻る</a> ]</td>
                    </tr>
                    <tr>
                      <td>　</td>
                    </tr>
                  </table>
                </div></td>
              </tr>
            </table>
          </div></td>
        </tr>
      </table>
    </div></td>
    <td width="10" background="cart_images/image_1_d.jpg"><img src="cart_images/no_image.gif" width="10" height="2"></td>
  </tr>
</table>
<map name="Map">
  <area shape="rect" coords="160,156,288,184" href="index2.html">
</map>
<form name=sendform method=post>
  <input type=hidden name=MakerCode value="<? echo $PMakerCode;?>">
  <input type=hidden name=CarCode value="<? echo $PCarCode;?>">
  <input type=hidden name=CategoryCode value="<? echo $PCategoryCode;?>">
  <input type=hidden name=Keyword value="<? echo $PKeyword;?>">
  <input type=hidden name=Page value="<? echo $Page;?>">
</form>

</body>
</html>