4lessBAD+8E64BAD+97lBAD+83eBAD+81[BAD+83uBAD+83BAD+8BBAD+82BAD+C582BAD+CD82BAD+C882BAD+A282BAD+CC82BAD+C544B.phpBAD+8ABAD+D690BAD+94BAD+82BAD+C58FBAD+88BAD+97BAD+9D
$_db = DB::connect(constant('KTY_DSN'));
if(DB::isError($_db)){
echo "DBBAD+90BAD+DA91BAD+B183GBAD+83BAD+89BAD+81[:".DB::errorMessage($_db)."\n";
exit;
}
//---------------------------------------------------------------------------
//- Function getRcpNo_from_Keywords()
//-
//- Keywords BAD+82 Add_keywords BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- keywords
//- &rcp_list(BAD+8E51BAD+8FC693nBAD+82BAD+B529
//- type : rcp (BAD+83BAD+8CBAD+83VBAD+83sBAD+96BAD+BC91BAD+CE8FBAD+DB8EBAD+9EBAD+8E77BAD+92BAD+E829 | null (default:BAD+8DBAD+DE97BAD+BF8CBAD+9FBAD+8DBAD+F597pBAD+82BAD+CC82BAD+DD91BAD+CE8FBAD+DB29
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_Keywords($db,$keywords,$rcp_list,$type = ''){
$keywords = mb_convert_kana($keywords, "KVs");
$key_arr = explode(" ",$keywords);
$rcp_no_arr = array();
/*
print "
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($i == '1'){
//print "
Alias -> ";
//var_dump($alias_arr);
//}
if(!empty($alias_arr)){
$sql_term = "";
for($p=0;$p";
//print $sql;
//}
$res = $db->query($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'];
//if($i == '1'){
//print "
Alias -> ";
//var_dump($rcp_no_arr['alias']);
//exit;
//}
}//- 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);
//if($i == '1'){
//print $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']['keywords'][] = $sql;
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['keywords'][] = $row['rcp_no'];
}
//print "
Keywords -> ";
//var_dump($rcp_no_arr['keywords']);
//- 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);
//if($i == '1'){
//print $sql;
//}
$res = $db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr['rcp_nm'][] = $row['uniq_id'];
}
//if($i == '1'){
//print "
Recipe _name -> ";
//var_dump($rcp_no_arr['rcp_nm']);
//exit;
//}
//- 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++;
}
//print "
Merged -> ";
//var_dump($wrk_rcp_no_arr);
//- 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
//print "
now key -> ".$key_arr[$i]."
";
//print "
Merged -> ";
//var_dump($wrk_rcp_no_arr);
$res_rcp_no_arr[] = $wrk_rcp_no_arr;
//print "
Count of res_rcp_no_arr = keyword count -> ";
//print count($res_rcp_no_arr);
}//- ŒOž®’ÜBAD+82BAD+B282BAD+C682BAD+CC8FBAD+88BAD+97BAD+9DBAD+8F4997
//print "
[ Array ] res_rcp_no_arr -> ";
//var_dump($res_rcp_no_arr);
//- 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_IngID()
//-
//- IngID(BAD+8DBAD+DE97BAD+BF49D) BAD+82BAD+A982BAD+E783BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97BAD+F18EBAD+E693
//---------------------------------------------------------------------------
//- BAD+88BAD+F890BAD+94BAD+81Fdb_resource
//- ing_id
//-
//- BAD+96BAD+DF82BAD+E892lBAD+81FBAD+83BAD+8CBAD+83VBAD+83sBAD+94BAD+D48DBAD+86BAD+94zBAD+97
//---------------------------------------------------------------------------
function getRcpNo_from_IngID($ing_id,$start="",$limit=""){
global $_db;
$tmp_key = "";
$rcp_no_arr = "";
if(is_array($ing_id)){
foreach($ing_id as $key => $val){
$tmp_key .= sprintf(" mtr_no = %s and " , trim($val) );
}
}else{
$tmp_key .= sprintf(" mtr_no = %s and " , trim($ing_id));
}
$tmp_key .= ' mtr_gnr_dlt = 0 ';
$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] = str_replace(":","','",$tmp_term[0]);
$line = array(
'alias' => $tmp_term[0]
);
$list_main[] = $line;
}
for($t=0;$t
getRcpNo_from_Main() sql -> ";
//print $sql;
$res = $_db->query($sql);
while($row=$res->fetchRow(DB_FETCHMODE_ASSOC)){
$rcp_no_arr[] = $row['rcp_no'];
}
/*
var_dump($rcp_no_arr);
print "
----------------------------
";
*/
return $rcp_no_arr;
}
//---------------------------------------------------------------------------
//- 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_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 "0":
$where = " R.rcp_crl <= 100 ";
break;
case "901":
$where = sprintf(" R.rcp_crl >= %d ",$cal);
break;
default:
$where = sprintf(" R.rcp_crl >= %d and R.rcp_crl < %d ",$cal,$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;
}
?>