<?
	// 初期設定ファイルの読み込み
//	session_cache_limiter("public");
//	XXXXXXXXXXXXX();

//	$download_flg = 1;

// 共通関数の移動 2009/02 ccc
include_once("/var/www/crmlib/initLibCar.php");
// include_once("/var/www/html/pdc/lib4310/initLibCar.php");
// include_once("/var/www/html/pdc/lib4310/initLibCarTEST9.php");

	$conn = OCILogon( DBUSER, DBPASS, DBNAME);

	/* SQL の作成 */
	$class = $_GET["class"];
	$flg = $_GET["flg"];
	
	if ( empty( $class )){
		$sql  = "SELECT * from option_product_open_tbl where model_name = '" . $_GET["id"] . "'";
		$sql = OCIParse($conn, $sql);
		OCIExecute($sql, OCI_DEFAULT);
		//OCIFetchInto($sql, &$arr, OCI_ASSOC);
		OCIFetchInto($sql, $arr, OCI_ASSOC);
		
		if ( empty( $flg )){
			$bname = "PRODUCT_IMAGE";
			$filetype = $arr["PRODUCT_IMAGE_TYPE"];
			$filename = "image";
			$imageSize = $arr["PRODUCT_IMAGE_SIZE"];
		} else {
			$bname = "PRODUCT_IMAGE_LARGE";
			$filetype = $arr["PRODUCT_IMAGE_LARGE_TYPE"];
			$filename = "image";
			$imageSize = $arr["PRODUCT_IMAGE_LARGE_SIZE"];
		}
	} else if ( $class == 1 ){
		$sql  = "SELECT * from option_class_mst where option_class_id = " . $_GET["id"];
		$sql = OCIParse($conn, $sql);
		OCIExecute($sql, OCI_DEFAULT);
		//OCIFetchInto($sql, &$arr, OCI_ASSOC);
		OCIFetchInto($sql, $arr, OCI_ASSOC);
		
		$bname = "TOP_IMAGE";
		$filetype = $arr["TOP_IMAGE_TYPE"];
		$filename = "image";
		$imageSize = $arr["TOP_IMAGE_SIZE"];
	} else if ( $class == 2 ){
		$sql  = "SELECT * from option_subclass_mst where option_class_id = " . $_GET["id"] . " and option_subclass_no = " . $_GET["no"];
		$sql = OCIParse($conn, $sql);
		OCIExecute($sql, OCI_DEFAULT);
		//OCIFetchInto($sql, &$arr, OCI_ASSOC);
		OCIFetchInto($sql, $arr, OCI_ASSOC);
		
		$bname = "TOP_IMAGE";
		$filetype = $arr["TOP_IMAGE_TYPE"];
		$filename = "image";
		$imageSize = $arr["TOP_IMAGE_SIZE"];
	}
//	  Header の出力
	header("Content-Type: " . $filetype );
	header("Content-Description: $filename");
//	  header("Content-Disposition: attachment; filename=$filename");

//	  ファイル本体の出力
	if ( !empty( $imageSize )){
		echo $arr[$bname]->load();
	} else {
		XXXXXXXX( "./img/nonImage.gif" );
	}
//print count( $arr["PRODUCT_IMAGE"] );
	OCIFreeStatement($sql);
	OCILogoff($conn);
?>