<?php
//html ver
define('USER','SYSTEM');
define('PASS','toybox');
define("DB","");

$iset=array("select"=>1,"insert"=>2,"update"=>3,"delete"=>4);
$show=FALSE;

function make_sql($cate,$highlows,$item,$maker,$serial,$price){
   $category = array("","item_deji","item_kaden","item_pc","item_ofice","item_cdvd");
   $hg = array("<=",">="); 
   $fr=FALSE;
   if($cate==0){
       $table_all=TRUE;
	$table="TB";
    }else{
	$table=$category[$cate];
    }
    
    $sql="select * from ".$table;
   if($item != NULL){
	$fr=TRUE;
	$item=str_replace('ĄĄ',' ',$item);
	$buf=ereg_replace('[[:space:]]',"%' OR ITEM_NAME LIKE '%",$item);
	$sql = $sql." where "."ITEM_NAME LIKE '%".$buf."%' ";
   }
   if($maker != NULL){
       if($fr){
	   $sql = $sql." AND ";
	}else{
	    $fr=TRUE;
	    $sql=$sql." where ";
	}
	$maker=str_replace('ĄĄ',' ',$maker);
	$buf=ereg_replace('[[:space:]]',"%' OR ITEM_MAKER LIKE '%",$maker);
	$sql = $sql." ITEM_MAKER LIKE '%".$buf."%' ";
    }
    if($serial != NULL){
	if($fr){
	    $sql=$sql." AND ";
	}else{
	    $fr=TRUE;
	    $sql=$sql." where ";
	}
	$serial=str_replace('ĄĄ',' ',$serial);
	$buf=ereg_replace('[[:space:]]',"' OR ITEM_NUMBER = '",$serial);
	$sql = $sql."ITEM_NUMBER = '".$buf."' ";
    }
    if($price != NULL){
	if($fr){
	    $sql=$sql." AND ";

	}else{
	    $fr=TRUE;
	    $sql=$sql." where ";
	}
	$price=str_replace('ĄĄ',' ',$price);
	$buf=ereg_replace('[[:space:]]'," OR ITEM_PRICE $hg[$highlows] ",$price);
	$sql = $sql."ITEM_PRICE ".$hg[$highlows]." ".$buf." ";
    }
    /*
    if($fr){
	$sql=$sql." AND ";
    }else{
	$sql=$sql." where ";
    }
    $sql=$sql." ct <= 10";
    */
    if($table_all){
	for($i=1;$i<count($category);$i++){
	    $tmp=$tmp.str_replace('TB',$category[$i],$sql);
	    if($i%(count($category)-1)!=0){
		$tmp=$tmp." UNION  ";
	    }
	}
	$sql=$tmp;
    }
    $fr=FALSE;
    return $sql;    
}

function select_data($sql){
    $con=oci_connect(USER,PASS,DB);
    $stmt=oci_parse($con,$sql);
    if(!oci_execute($stmt,OCI_DEFAULT)){
	echo "oi! select\n";
	return;
    }
    //oci_commit($con);

	$ros=oci_fetch_all($stmt,$res);
	return array($ros,$res);
	oci_close($con);
}
?>