$mkname[Butterfly]="Butterfly";
$mkname[Nittaku]="Nittaku";
$mkname[TSP]="TSP";
$mkname[Yasaka]="Yasaka";
$mkname[MIZUNO]="Mizuno";
$mkname[JUIC]="JUIC";
$mkname[DARKER]="DARKER";
$mkname[VI]="Victas";
if (!$db_id = odbc_connect('sale_zaiko_TQ','','')) {exit(0); } else {
$sql ="select * from T_meka where (mekaID like '".$_GET[mk]."');";
$res= odbc_exec($db_id,$sql);
$mk = odbc_fetch_array($res);
$sql ="select * from T_TQ where (メーカー like '".$_GET[mk]."') and (品番 like '".$_GET[hid]."') order by COLOR, ID ;";
$res= odbc_exec($db_id,$sql);
//odbc_result_all($res);
$ncolor=$nsize=0;
for ($i=0;$i<1000;$i++){
$d[$i] = odbc_fetch_array($res);
if ($d[$i]['COLOR']=="") $d[$i]['COLOR']="-";
if ($d[$i]['サイズ']=="") $d[$i]['サイズ']="-";
if ($d[$i]['数1']=="") $d[$i]['数1']=0;
if ($d[$i]['数2']=="") $d[$i]['数2']=0;
$d[$i]['数']=$d[$i]['数1']+$d[$i]['数2'];
//---------------<カート表組み対応各色別サイズの取得>--------------------------
$dt[$d[$i]['COLOR']].="".$d[$i]['サイズ']."\t";
//------------------------------------------------------------------
if ($d[$i][ID]=="") break;
//$d[$i]['特価']=$d[$i]['定価']; //////// 特価がないので
$mf=0;
for ($j=0;$j<$ncolor;$j++)
if ($acolor[$j]==$d[$i]['COLOR']) $mf =1;
if ($mf==0) $acolor[$ncolor++]=$d[$i]['COLOR'];
// if($d[$i]['サイズ']!="-"){ $mf=0; } else { $mf=1; } //サイズ=空白データへの対処
if($d[$i]['サイズ']!="**"){ $mf=0; } else { $mf=1; }
for ($j=0;$j<$nsize;$j++)
if ($asize[$j]==$d[$i]['サイズ']) $mf =1;
if ($mf==0) $asize[$nsize++]=$d[$i]['サイズ'];
}
for ($j=0;$j<$i;$j++) {
$suu[$d[$j]['サイズ']][$d[$j]['COLOR']]=$d[$j]['数'];
// echo $j.$d[$j]['サイズ']." ".$d[$j]['COLOR']."dsds".$suu["$d[$j]['サイズ']"]["$d[$j]['COLOR']"]."
";
}
$dt_cnt=count($dt);
$sql ="select * from T_koumoku where (項目2 like '".$d[0][項目2]."');";
$tres= odbc_exec($db_id,$sql);
$fo = odbc_fetch_array($tres);
?>
$dt_cnt=count($dt);
$sql ="select * from T_koumoku where (項目 like '".$d[0][項目]."');";
$tres= odbc_exec($db_id,$sql);
$fo = odbc_fetch_array($tres);
$fname = "../../photo/sale/".$d[0][品番]."_b.jpg";
$fname2 = "../../photo/sale/".$d[0][品番]."_m.jpg";
echo '
';
echo '';
echo '';
echo 'Clearance Item - '.$mk['メーカー'].'';
echo ''.$d[0]['NAME'].'';
echo '';
echo ' | ';
echo '
';
echo '';
echo '';
if (file_exists($fname)){
if (!file_exists($fname2)){
$size = getimagesize($fname);
if (!file_exists($fname2)){
$iimage = imagecreatefromjpeg($fname);
if ($size[0] > $size[1]){
$ix =500; echo $iy = (int)($ix * ((double)$size[1]/$size[0]));
} else {
$iy =400; 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,$fname2,100);
}
}
echo '';
echo '![Product Photo - '.$d[0][NAME].'](.$fname2.) ';
}
echo '
|
As this is clearance item, product change/refund or size change is not possible. .
Please be aware that clearance sale items include older stock. These items color may already faded. |