<?
/*************************************************************
ファイル名：bbs_function.php
--------------------------------------------------------------
内　容：BBS共通関数ファイル
--------------------------------------------------------------
作成者：亘
作成日：2005.01.31
--------------------------------------------------------------
備　考：
**************************************************************/

/*************************************************************
BBS用レシピ一覧を作成する
--------------------------------------------------------------
引　数：
    $db
    $p['uid']
--------------------------------------------------------------
戻り値：表示用HTML
**************************************************************/
function bbs_get_rcplist($db,$p)
{
	
    //- key(検索キー)をセット
    switch($p['mode']){
    	
        case "words":
            $keywords = mb_convert_kana($p['keywords'], "KVs");
            $key_arr = explode(" ",$keywords);
            foreach($key_arr as $key){
                if(empty($key)){continue;}

                //-- レシピ名から検索(部分一致)
                //-- *返す配列のレシピIDのkeyはマージのために 'uniq_id' -> 'rcp_no'に置換
                $where = sprintf(" rcp_nm like '%%%s%%' ",$key);

                $ret = cs4_select($db,"bsc_r_new",$where);

                $line = array();
                while($row = cs4_fetch_row($ret)){
                    foreach($row as $k => $value){
                        $tmp[$k] = $value;
                    }
                    $line = array(
                                'rcp_no' => $tmp['uniq_id'],
                                'rcp_nm' => $tmp['rcp_nm'],
                                'rcp_time' => $tmp['rcp_time'],
                                'rcp_num' => $tmp['rcp_num']
                            );
                    $list_rcp[] = $line;
                }

                $where = sprintf(" mtr_nm = '%s' ",$key);
                $ret = cs4_select($db,"bsc_mtr_gnr_s",$where);

                $line = array();
                while($row = cs4_fetch_row($ret)){
                    foreach($row as $k => $value){
                        $tmp[$k] = $value;
                    }
                    $line = array(
                                'rcp_no' => $tmp['rcp_no'],
                                'mtr_nm' => $tmp['mtr_nm']
                            );
                    $list_mtr[] = $line;
                }

                //-- 2テーブルからヒットしたレシピをマージする
                $rcp_list = array_merge_recursive($list_rcp,$list_mtr);

            }
            break;
        case "quick":
            $where = sprintf(" pdc_no = %s ",$pdc_no);
            $ret = cs4_select($db,"bsc_p_pdc",$where);
            break;
        case "ing":
            $where = sprintf(" pdc_no = %s ",$pdc_no);
            $ret = cs4_select($db,"bsc_p_pdc",$where);
            break;

    }

    return $rcp_list;
    
}

/*************************************************************
--------------------------------------------------------------
--------------------------------------------------------------
**************************************************************/
function get_rcp_list_gnr($db,$p){

    $where = "";

    switch($p['mode']){

        // ジャンル指定
        case 'genre':

            $where = " rcp_dlt=0 and rcp_gnr!=29000000";

        break;

    }

    $ret = cs4_select($db,"bsc_r_new",$where);

    $tmp = array();

    $i=0;

    while($row = cs4_fetch_row($ret)){
        foreach($row as $key => $val){
            $tmp[$i][$key] = $val;
        }
        $i++;
    }

}

/*************************************************************
selectで使用する単位一覧HTMLを作成
--------------------------------------------------------------
引　数：なし
--------------------------------------------------------------
戻り値：表示用HTML
**************************************************************/
function get_select_unit(){
	
	$select_unit = "";
	$select_unit .= "<option value=\"1\">g</option>";
	$select_unit .= "<option value=\"2\">ml</option>";
	$select_unit .= "<option value=\"3\">カップ</option>";
	$select_unit .= "<option value=\"4\">杯</option>";
	$select_unit .= "<option value=\"5\">適量</option>";
	$select_unit .= "<option value=\"6\">少々</option>";
	$select_unit .= "<option value=\"7\">個</option>";
	$select_unit .= "<option value=\"8\">本</option>";
	$select_unit .= "<option value=\"9\">片</option>";
	$select_unit .= "<option value=\"10\">切</option>";
	$select_unit .= "<option value=\"11\">袋</option>";
	$select_unit .= "<option value=\"12\">cc</option>";
	$select_unit .= "<option value=\"13\">把</option>";
	
	return $select_unit;
}

/*************************************************************
デフォルト値のセットされたSELECTを作成する関数(材料単位用)
--------------------------------------------------------------
引　数：nameで使用する文字列
		デフォルト値
		valueと文字列の配列
		$arr = array(
					1 => "g",
					2 => "ml",
					3 => "本"
				);
--------------------------------------------------------------
戻り値：表示用HTML
**************************************************************/
function bbs_create_select($name,$default,$arr){

	$list = "";
	$list .= "<select name=\"p[".$name."]\">\n";

/*
if(constant('BBS_DEBUG_MODE')){
print "<br>name => ".$name;
print "<br>default => ".$default;
}
*/
	foreach($arr as $key => $val){
/*
if(constant('BBS_DEBUG_MODE')){
print "<br>key => ".$key;
print "<br>val => ".$val;
}
*/

        if($name == "unit" && ($key == "4" || $key == "5")){continue;}

		$checked = "";
		if($key == $default){
			$checked = " selected";
		}
		
		$list .= "<option value=\"".$key."\"".$checked.">".$val."\n";
		
	}
	$list .= "</select><br />\n";
	
	return $list;
}

/*************************************************************
selectで使用する単位配列
--------------------------------------------------------------
引　数：なし
--------------------------------------------------------------
戻り値：表示用HTML
**************************************************************/
function get_select_unit_arr($all=0){
	
	$select_unit_arr = array(
		1	=> "g",
		2	=> "ml",
		3	=> "杯",
//		4	=> "適量",
//		5	=> "少々",
		6	=> "個",
		7	=> "本",
		8	=> "片",
		9	=> "切",
		10	=> "袋",
		11	=> "cc",
		12	=> "把"
		
	);
    if($all){
        $select_unit_arr[4] = "適量";
        $select_unit_arr[5] = "少々";
    }
	
	return $select_unit_arr;
}

?>