getRcpNo_from_Keywords()
Keywords Array -> ";
var_dump( $key_arr );
print "
";
*/
//-- BAD+93BAD+FC97—VˆÚˆÂBAD+DE82BAD+C58DBAD+DE97BAD+BF8CBAD+9FBAD+8DBAD+F597pBAD+82BAD+A982BAD+E78CBAD+9FBAD+8D
//- BAD+83XBAD+83yBAD+81[BAD+83XBAD+8BBAD+E690BAD+D882BAD+E88EBAD+9EBAD+82BAD+CD83BAD+8BBAD+81[BAD+83v
for($i=0;$iquery($sql);
$sql_term = "";
$alias_arr = "";
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
if(!empty($row['mtr_alias'])){
$alias_arr[] = $row['mtr_alias'];
}
}
if(!empty($alias_arr)){
$sql_term = "";
for($p=0;$pquery($sql);
//- BAD+8DiBAD+82BAD+E88DBAD+9EBAD+82BAD+DD8CBAD+9FBAD+8DBAD+F597pBAD+82BAD+C98DBAD+A189BAD+F182BAD+CC53QLBAD+82BAD+F095BAD+DB91BAD+B682BAD+B582BAD+C482BAD+A882BAD+B182
$rcp_list['pre_sql']['alias'][] = $sql;
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['alias'][] = $row['rcp_no'];
}
$wrk_rcp_no_arr = $rcp_no_arr['alias'];
}//- BAD+83GBAD+83CBAD+83BAD+8ABAD+83ABAD+83XBAD+91BAD+B68DBAD+DD8EBAD+9EBAD+82BAD+CC8FBAD+88BAD+97BAD+9DBAD+8F4997
//- BAD+93BAD+FC97—VˆÚˆÂBAD+DE82BAD+C58DBAD+DE97BAD+BF8CBAD+9FBAD+8DBAD+F597pBAD+82BAD+A982BAD+E791OBAD+95BAD+FB88BAD+EA92vBAD+82BAD+C58CBAD+9FBAD+8D
$sql = "";
$sql.= "SELECT * FROM contents_data_bsc_mtr_gnr_s ";
$sql_input_term_like = sprintf(" mtr_nm like '%s%%' ",$key_arr[$i]);
$sql.= sprintf(" WHERE %s and rcp_no is not null and mtr_s_dlt = 0 Group by rcp_no",$sql_input_term_like);
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['keywords'][] = $row['rcp_no'];
}
//- aliasBAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182BAD+C66BeywordsBAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182BAD+CC83}BAD+81[BAD+83WBAD+81iorBAD+8FF08CBAD+8F816A
if(!empty($wrk_rcp_no_arr) && !empty($rcp_no_arr['keywords'])){
$wrk_rcp_no_arr = array_merge($wrk_rcp_no_arr,$rcp_no_arr['keywords']);
}elseif(empty($wrk_rcp_no_arr) && !empty($rcp_no_arr['keywords'])){
$wrk_rcp_no_arr = $rcp_no_arr['keywords'];
}
//- BAD+94zBAD+97BAD+F192lBAD+82BAD+CC8FdBAD+95BAD+A182BAD+F08DBAD+ED8FBAD+9CBAD+82BAD+B581AindexBAD+82BAD+CC94BAD+F282BAD+D182BAD+F092BAD+BC82
$tmp_wrk_rcp_no_arr = array_unique($wrk_rcp_no_arr);
$wrk_rcp_no_arr = "";
$k = 0;
foreach($tmp_wrk_rcp_no_arr as $key => $val){
$wrk_rcp_no_arr[$k] = $val;
$k++;
}
//--- BAD+83BAD+8CBAD+83VBAD+83sBAD+96BAD+BC82BAD+A982BAD+E78CBAD+9FBAD+8DBAD+F581iBAD+83tBAD+83BAD+89BAD+83OBAD+8E77BAD+92BAD+E88EBAD+9EBAD+82BAD+CC82BAD+DD81j
if('rcp' == $type){
//- BAD+93BAD+FC97—VˆÚˆÂBAD+DE82BAD+C583BAD+8CBAD+83VBAD+83sBAD+96BAD+BC82BAD+A982BAD+E78CBAD+9FBAD+8D
$sql_input_term_like_all = "";
$sql = "";
$sql.= "SELECT * FROM contents_data_bsc_r_new ";
$sql_input_term_like_all = sprintf(" rcp_nm like '%%%s%%' ",$key_arr[$i]);
$sql.= sprintf(" WHERE %s ",$sql_input_term_like_all);
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['rcp_nm'][] = $row['uniq_id'];
}
//- BAD+8DiBAD+82BAD+E88DBAD+9EBAD+82BAD+DD8CBAD+9FBAD+8DBAD+F597pBAD+82BAD+C98DBAD+A189BAD+F182BAD+CC53QLBAD+82BAD+F095BAD+DB91BAD+B682BAD+B582BAD+C482BAD+A882BAD+B182
$rcp_list['pre_sql']['rcp_nm'][] = $sql;
//- wrkBAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182BAD+C672cp_nmBAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182BAD+CC83}BAD+81[BAD+83WBAD+81iorBAD+8FF08CBAD+8F816A
if(!empty($wrk_rcp_no_arr) && !empty($rcp_no_arr['rcp_nm'])){
$wrk_rcp_no_arr = array_merge($wrk_rcp_no_arr,$rcp_no_arr['rcp_nm']);
}elseif(empty($wrk_rcp_no_arr) && !empty($rcp_no_arr['rcp_nm'])){
$wrk_rcp_no_arr = $rcp_no_arr['rcp_nm'];
}
//- BAD+94zBAD+97BAD+F192lBAD+82BAD+CC8FdBAD+95BAD+A182BAD+F08DBAD+ED8FBAD+9CBAD+82BAD+B581AindexBAD+82BAD+CC94BAD+F282BAD+D182BAD+F092BAD+BC82
$tmp_wrk_rcp_no_arr = "";
$tmp_wrk_rcp_no_arr = array_unique($wrk_rcp_no_arr);
$wrk_rcp_no_arr = "";
$k = 0;
foreach($tmp_wrk_rcp_no_arr as $key => $val){
$wrk_rcp_no_arr[$k] = $val;
$k++;
}
//- BAD+93BAD+FC97—VˆÚˆÂBAD+DE82BAD+C583BAD+8CBAD+83VBAD+83sBAD+96BAD+BC82BAD+A982BAD+C882BAD+A982BAD+E78CBAD+9FBAD+8D
$sql_input_term_like_all_kana = "";
$sql = "";
$sql.= "SELECT * FROM contents_data_bsc_r_new ";
$sql_input_term_like_all_kana = sprintf(" rcp_nm_kana like '%%%s%%' ",$key_arr[$i]);
$sql.= sprintf(" WHERE %s ",$sql_input_term_like_all_kana);
//print $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['rcp_nm_kana'][] = $row['uniq_id'];
}
//- BAD+8DiBAD+82BAD+E88DBAD+9EBAD+82BAD+DD8CBAD+9FBAD+8DBAD+F597pBAD+82BAD+C98DBAD+A189BAD+F182BAD+CC53QLBAD+82BAD+F095BAD+DB91BAD+B682BAD+B582BAD+C482BAD+A882BAD+B182
$rcp_list['pre_sql']['rcp_nm_kana'][] = $sql;
//- wrkBAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182BAD+C672cp_nm_kanaBAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182BAD+CC83}BAD+81[BAD+83WBAD+81iorBAD+8FF08CBAD+8F816A
if(!empty($wrk_rcp_no_arr) && !empty($rcp_no_arr['rcp_nm_kana'])){
$wrk_rcp_no_arr = array_merge($wrk_rcp_no_arr,$rcp_no_arr['rcp_nm_kana']);
}elseif(empty($wrk_rcp_no_arr) && !empty($rcp_no_arr['rcp_nm_kana'])){
$wrk_rcp_no_arr = $rcp_no_arr['rcp_nm_kana'];
}
//- BAD+94zBAD+97BAD+F192lBAD+82BAD+CC8FdBAD+95BAD+A182BAD+F08DBAD+ED8FBAD+9CBAD+82BAD+B581AindexBAD+82BAD+CC94BAD+F282BAD+D182BAD+F092BAD+BC82
$tmp_wrk_rcp_no_arr = "";
$tmp_wrk_rcp_no_arr = array_unique($wrk_rcp_no_arr);
$wrk_rcp_no_arr = "";
$k = 0;
foreach($tmp_wrk_rcp_no_arr as $key => $val){
if(empty($val)){continue;}
$wrk_rcp_no_arr[$k] = $val;
$k++;
}
}//- BAD+83BAD+8CBAD+83VBAD+83sBAD+96BAD+BC8CBAD+9FBAD+8DBAD+F58FIBAD+97
$res_rcp_no_arr[] = $wrk_rcp_no_arr;
}//- ŒOž®’ÜBAD+82BAD+B282BAD+C682BAD+CC8FBAD+88BAD+97BAD+9DBAD+8F4997
//- BAD+8CBAD+8BBAD+89BAD+CA94zBAD+97BAD+F182 and BAD+8FF08CBAD+8F82C5BAD+83}BAD+81[BAD+83W(BAD+89BAD+FC8FCBAD+8DBAD+CF29
if('1' < count($res_rcp_no_arr)){
$wrk_a = $res_rcp_no_arr[0];
$wrk_b = $res_rcp_no_arr[1];
}else{
$res_arr = $res_rcp_no_arr[0];
}
for($x=1;$x $val){
if(empty($val)){continue;}
$res_arr[$k] = $val;
$k++;
}
//print "
array_uniqued -> ";
//var_dump($res_arr);
return $res_arr;
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Main()
//-
//- Main(BAD+8EE5BAD+8DBAD+DE97BAD+BF29 BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- main
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Main($db,$main,$rcp_list){
$tmp_key = "";
$rcp_no_arr = "";
$key_1 = sprintf("%d",substr($main,0,1));
$key_2 = sprintf("%d",substr($main,1,2));
$tmp_key .= sprintf(" mtr_class_1 = %s " , $key_1);
if($key_2 == '0' || !$key_2){
// $tmp_key .= " and (mtr_class_2 = 0 or mtr_class_2 is null) ";
}else{
$tmp_key .= sprintf(" and mtr_class_2 = %s " , $key_2);
}
$sql = "select * from contents_data_bsc_mtr_gnr";
$sql.= sprintf(" Where %s",$tmp_key);
$res = $db->query($sql);
$sql_terms = "";
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$tmp_term = explode("|",$row['mtr_alias']);
if(substr($tmp_term[0],-1) == ":"){
$tmp_term[0] = substr($tmp_term[0],0,-1);
}
$tmp_term[0] = sprintf("%s:%s:%s",$tmp_term[0],$row['mtr_nm'],$row['mtr_nm_kana']);
$tmp_arr[] = explode(":",$tmp_term[0]);
if(!empty($tmp_term[1])){
$not_tmp_arr[] = explode(":",$tmp_term[1]);
}
}
//- BAD+8CBAD+9FBAD+8DBAD+F591BAD+CE8FBAD+DB8FBAD+F08CBAD+8F82F0BAD+8DBAD+EC90
if(is_array($tmp_arr)){
//var_dump($tmp_arr);
foreach($tmp_arr as $key => $val){
//print "key -> ".$key;
//print "
val -> ".$val."
";
foreach($val as $veget){
//print "
veget -> ".$veget."
";
if(empty($veget)){continue;}
$veget_arr[] = $veget;
}
}
//var_dump($veget_arr);
$list_ing = array_unique($veget_arr);
//var_dump($list_ing);
/*
for($t=0;$t $val){
foreach($val as $not_veget){
if(empty($not_veget)){continue;}
$not_veget_arr[] = $not_veget;
}
}
$not_list_ing = array_unique($not_veget_arr);
/*
for($t=0;$t
getRcpNo_from_Main() sql -> ";
//print $sql;
//exit;
//- pre_sqlBAD+82BAD+D695BAD+DB91
$rcp_list['pre_sql']['add_main'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['add_main'][] = $row['rcp_no'];
}
return $rcp_no_arr['add_main'];
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Kind()
//-
//- Kind(BAD+8EEDBAD+97BAD+DE29 BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- main
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Kind($db,$kind,$rcp_list){
if(!empty($kind) && '0' != $kind){
$sql = "SELECT * FROM contents_data_bsc_r_knd_s ";
$sql.= sprintf(" WHERE r_knd_no = %s and r_knd_dlt = 0 ",$kind);
$sql.= " GROUP BY rcp_no";
//- pre_sqlBAD+82BAD+D695BAD+DB91
// $rcp_list['pre_sql']['add_kind'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['add_kind'][] = $row['rcp_no'];
}
return $rcp_no_arr['add_kind'];
}
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Menu()
//-
//- MenuBAD+83eBAD+81[BAD+83uBAD+83BAD+8B(BAD+95\¦BAD+8FE382BAD+CD83WBAD+83BAD+83BAD+83BAD+93BAD+83BAD+8B) BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- main
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Menu($db,$genre,$rcp_list){
if(!empty($genre) && '0' != $genre){
$sql = "SELECT * FROM contents_data_bsc_r_menu_s ";
$sql.= sprintf(" WHERE r_menu_no = %s and r_menu_dlt = 0 ",$genre);
$sql.= " GROUP BY rcp_no";
//- pre_sqlBAD+82BAD+D695BAD+DB91
// $rcp_list['pre_sql']['add_kind'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['genre'][] = $row['rcp_no'];
}
return $rcp_no_arr['genre'];
}
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Cook()
//-
//- Cook(BAD+92BAD+B297BAD+9DBAD+95BAD+FB96@) BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- main
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Cook($db,$cook,$rcp_list){
if(!empty($cook) && '0' != $cook){
$sql = "SELECT * FROM contents_data_bsc_r_cook_mtd_s ";
$sql.= sprintf(" WHERE r_cook_mtd_no = %s and r_cook_mtd_dlt = 0 ",$cook);
$sql.= " GROUP BY rcp_no";
//- pre_sqlBAD+82BAD+D695BAD+DB91
// $rcp_list['pre_sql']['add_cook'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['add_cook'][] = $row['rcp_no'];
}
}
return $rcp_no_arr['add_cook'];
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Cal()
//-
//- Cal(BAD+83JBAD+83BAD+8DBAD+83BAD+8ABAD+81[) BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- cal
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Cal($db,$cal,$rcp_list){
// switch($terms['calorie']){
switch($cal){
case "1":
$where = " R.rcp_crl < 100 ";
break;
case "7":
$where = sprintf(" R.rcp_crl >= %d ",(($cal - 1) * 100));
break;
default:
$where = sprintf(" R.rcp_crl >= %d and R.rcp_crl < %d ",(($cal - 1) * 100),($cal * 100));
break;
}
$sql = "Select R.* ";
$sql .= "From contents_data_bsc_r_new R ";
$sql .= " Where ";
$sql .= $where;
$sql .= " Order by rcp_crl ASC";
//- pre_sqlBAD+82BAD+D695BAD+DB91
$rcp_list['pre_sql']['cal'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
/*
$line = array(
'rcp_no' => $row['uniq_id'],
'rcp_nm' => $row['rcp_nm'],
'rcp_time' => $row['rcp_time'],
'rcp_num' => $row['rcp_num'],
'rcp_crl' => $row['rcp_crl']
);
*/
$list_cal[] = $row['uniq_id'];
}
return $list_cal;
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Style()
//-
//- Style(BAD+83XBAD+83^BAD+83CBAD+83BAD+8B) BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- style
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Style($db,$style,$rcp_list){
$where = sprintf(" r_style_no = %s and r_style_dlt = 0 ",$style);
$sql = "";
$sql .= "Select * ";
$sql .= "From contents_data_bsc_r_style_s ";
$sql .= "Where ";
$sql .= $where;
$sql .= "and rcp_no is not NULL and r_style_dlt = 0 ";
$sql .= "Group by rcp_no ";
//- pre_sqlBAD+82BAD+D695BAD+DB91
$rcp_list['pre_sql']['style'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_arr[] = $row['rcp_no'];
// $rcp_key .= sprintf("%s,",$row['rcp_no']);
}
return $rcp_arr;
}
?>