Clearance Sale ".$d_ko['項目en']."
"; echo 'Click on the logo to jump to that brand`s product. | ||||
'; // } for($i=1;$i<10;$i++){ if ($d_ko[M.$i]=="") break; echo ' | '; if ($i%5==4&&$i!=1) echo " | |||
Back to Sale Homepage
'; echo "";
$i=1;
//echo $d_ko[M.$i];
while($d_ko[M.$i]!=""){
$sql ="select * from T_TQ where メーカー like '".$d_ko[M.$i]."' and 項目2 like '".$d_ko['項目2']."' order by 品番,カラー, ID ;";
$resc= odbc_exec($db_id,$sql);
for ($ci=1;$ci<12;$ci++) {$caid[$ci]=0; $ccaid[$ci]=0;}
$d = odbc_fetch_array($resc);
while($d[ID]!=""){
for ($ci=1;$ci<12;$ci++){
$cii="P-".$ci;
if ($d[$cii]!="") $caid[$ci]=1;
}
$d = odbc_fetch_array($resc);
}
odbc_free_result($resc);
$cac=1;
//for ($ci=1;$ci<12;$ci++) echo $caid[$ci];
for ($ci=1;$ci<12;$ci++) if($caid[$ci]==1) $ccaid[$cac++]=$ci;
$cac--;
//echo $cac;;
//for ($ci=1;$ci<12;$ci++) echo $ccaid[$ci];
/////////////// カタログ数 $cac ID $ccaid
$mkname[Butterfly]="Butterfly";
$mkname[Nittaku]="Nittaku";
$mkname[TSP]="TSP";
$mkname[Yasaka]="Yasaka";
$mkname[MIZUNO]="Mizuno";
$mkname[JUIC]="JUIC";
$mkname[DARKER]="DARKER";
$mkname[VI]="Victas";
$sql ="select * from T_meka where (mekaID like '".$d_ko[M.$i]."');";
$res= odbc_exec($db_id,$sql);
$mk = odbc_fetch_array($res);
$sql ="select * from T_koumoku where (項目 like '".$d_ko[項目]."');";
$tres= odbc_exec($db_id,$sql);
$fo = odbc_fetch_array($tres);
$sql ="select * from T_TQ where メーカー like '".$d_ko[M.$i]."' and 項目2 like '".$d_ko['項目2']."' order by 品番,カラー, ID ;";
$res= odbc_exec($db_id,$sql);
//odbc_result_all($res);
$old_hid=1;
$d = odbc_fetch_array($res);
while($d[ID]!=""){
if($old_hid==1){
$coln=3+$cac;
echo "
"; // echo ' // 品 番 // 品 名 // 販売価格'; for ($ci=0;$ci<$cac;$ci++){ $sql ="select * from T_katarogu where P like 'P-".$ccaid[$ci+1]."' ;"; $rescc= odbc_exec($db_id,$sql); $dc = odbc_fetch_array($rescc); $cfname="../../photo/catalog/".$dc['カタログ名']."/thumb.gif"; $curl="../Catalog/".$dc['カタログ名']."/thumb01.html"; $dc2[$ci+1]=$dc['カタログ名']; echo '
'; } echo '
"; } } $i++; } //$d_mk[ID]!="" }//start echo"
";
?>
"; // echo ' // 品 番 // 品 名 // 販売価格'; for ($ci=0;$ci<$cac;$ci++){ $sql ="select * from T_katarogu where P like 'P-".$ccaid[$ci+1]."' ;"; $rescc= odbc_exec($db_id,$sql); $dc = odbc_fetch_array($rescc); $cfname="../../photo/catalog/".$dc['カタログ名']."/thumb.gif"; $curl="../Catalog/".$dc['カタログ名']."/thumb01.html"; $dc2[$ci+1]=$dc['カタログ名']; echo '
'; } echo '
- ';
}
$fname = "../../photo/sale/".$d[品番]."_b.jpg";
$fname3 = "../../photo/sale/".$d[品番]."_s.jpg";
if (file_exists($fname)){
if (!file_exists($fname3)){
$size = getimagesize($fname);
if (!file_exists($fname3)){
$iimage = imagecreatefromjpeg($fname);
if ($size[0] > $size[1]){
$ix =150; echo $iy = (int)($ix * ((double)$size[1]/$size[0]));
} else {
$iy =150; echo $ix = (int)($iy * ((double)$size[0]/$size[1]));
}
$oimage = imagecreatetruecolor($ix,$iy);
imagecopyresampled($oimage,$iimage,0,0,0,0,$ix,$iy,$size[0],$size[1]);
imagejpeg($oimage,$fname3,100);
}
}
}
if ($d[品番]!=$old_hid){
echo "
- ";
if (file_exists($fname3)) {echo"
";} if (!file_exists($fname3)) {echo"
";} echo "".$d[NAME]."
"; echo "".$d[品番]."
"; $ps_name[2]="要御見積もり
"; $ps_name[3]="オープン価格
"; $ps_name[4]="オープン価格
"; if ($d[PS]==3||$d[PS]==2||$d[PS]==4) echo "".$ps_name[$d[PS]].""; else if ($d[PS]==1){ echo " \\".number_format($d[税込価格])." --> \\".number_format($d[特価])." " ;} else echo "\\".number_format($d[税込価格]).""; // for ($ci=1;$ci<=$cac;$ci++){ // if ($d['P-'.$ccaid[$ci]]=="") // echo ""; // else { // $lp=(int)($d['P-'.$ccaid[$ci]]/10)+1; // //if ($lp<10) $lp="0".$lp; // //$lname="../Page_Top_JAPANESE/MAIL_ORDER/Maker_Catalog/".$dc2[$ci]."/".$dc2[$ci]."_".$lp.".html"; // if ($d['P-'.$ccaid[$ci]]<10) // $lname="../Catalog/".$dc2[$ci]."/P00".$d['P-'.$ccaid[$ci]].".html"; // elseif ($d['P-'.$ccaid[$ci]]<100) // $lname="../Catalog/".$dc2[$ci]."/P0".$d['P-'.$ccaid[$ci]].".html"; // else // $lname="../Catalog/".$dc2[$ci]."/P0".$d['P-'.$ccaid[$ci]].".html"; // echo " P ".$d['P-'.$ccaid[$ci]].""; // } // } echo " ";
$old_hid = $d[品番];
}
$d = odbc_fetch_array($res);
if($d[ID]==""){
echo "
"; } } $i++; } //$d_mk[ID]!="" }//start echo"