db = cs4_open();
//******************************//
//お気に入りレシピランキング取得//
//******************************//
//- ランキングデータ配列取得(週間)
$ranking_list = get_RankingData($this->db, '0', RANK_PERIOD_WEEKLY ,'', 10 );
$start_date = $ranking_list[1]['period_start'];
$tmp_start_arr = explode(" ",$start_date);
$start_ymd_arr = explode("-",$tmp_start_arr[0]);
$start_period = sprintf("%d月%d日〜",$start_ymd_arr[1],$start_ymd_arr[2]);
$end_period = date("n月j日",mktime(0,0,0,$start_ymd_arr[1],$start_ymd_arr[2] + 6,$start_ymd_arr[0]));
$str_period = sprintf("%s%s",$start_period,$end_period);
// テンプレート読み込み
$template =& loadTemplate( $p );
//- ranking
if(!empty($ranking_list)){
$template->setCurrentBlock('__RankingPeriod__');
$template->setVariable('split_date',$str_period);
$template->parseCurrentBlock();
//for($i=1;$i< (count($ranking_list) + 1);$i++){
for($i=1;$i< 2;$i++){
if(('i' == $p['carrier'] && '2' == $p['version']) || ('v' == $p['carrier'] && '3' == $p['version']) || ('e' == $p['carrier'] && '3' == $p['version']) || ('w' == $p['carrier']) || ('g' == $p['carrier'])){
$thumbnail_path = sprintf("%s/%s_n-thm.jpg",IMG_DIR_RECIPE,$ranking_list[$i]['rcp_no']);
if(file_exists($thumbnail_path) && (3 >= $ranking_list[$i]['rank'])){
$template->setCurrentBlock('__ImageLink__');
$template->setVariable('image_id',$ranking_list[$i]['rcp_no']);
$template->parseCurrentBlock();
}
}
$template->setCurrentBlock('__List__');
$template->setVariable('rank',$ranking_list[$i]['rank']);
if(!empty($ranking_list[$i]['rcp_kind'])){
$template->setVariable('rcp_kind',sprintf("・%s",$ranking_list[$i]['rcp_kind']));
}
$template->setVariable('rcp_no',$ranking_list[$i]['rcp_no']);
$template->setVariable('title',$ranking_list[$i]['rcp_nm']);
$template->parseCurrentBlock();
}
}
//******************************//
// 人気ダイエットランキング取得 //
//******************************//
//DB接続
$db = DB::connect(constant('KTY_DSN'));
if(DB::isError($db)){
echo "DB接続エラー:".DB::errorMessage($db)."\n";
exit;
}
$where = " d.dlt_flg = 0 and d.uniq_id = u.set_id";
$group = " u.set_id ";
$from = " contents_data_kty_diet_set_users u, contents_data_kty_diet_set d";
$order = " num desc ";
$sql = " select u.set_id, count( u.set_id ) as num, d.set_name,d.date ";
$sql .= sprintf(" from %s where %s group by %s order by %s",$from,$where,$group,$order);
$res = $db->query($sql);
if(DB::isError($res)){
echo "クエリの送信が失敗しました。
";
exit;
}
//件数取得
$num = $res->numRows();
$i = 0;
while($row = $res->fetchRow(DB_FETCHMODE_ASSOC)){
$array[set_id][$i] = $row['set_id'];
$array[num][$i] = $row['num'];
$array[set_name][$i]= $row['set_name'];
$array[date][$i] = $row['date'];
$i++;
}
if(!empty($num)){
for($i=0;$i<1;$i++){
//文字列置換
if('' != $array['date'][$i]){
$ymd = str_replace('-','.',substr($array['date'][$i],0,10));
}
$template->setCurrentBlock('__diet_list__');
$template->setVariable('rank',$i + 1);
$template->setVariable('uniq_id',$array['set_id'][$i]);
$template->setVariable('set_name',$array['set_name'][$i]);
$template->setVariable('date',$ymd);
$template->parseCurrentBlock();
}
}else{
$template->hideBlock('__diet_list__');
}
//******************************//
// 隣の晩ごはんランキング //
//******************************//
$where = " v.post_id = c.uniq_id ";
$order = " v.poll desc";
$from = " contents_data_tonari_vote v ,contents_data_tonari_contribute c";
$sql = "select v.post_id,v.poll,c.post_date, c.post_no, c.post_title, c.uniq_id, c.user_nm ";
$sql .= sprintf(" from %s where %s order by %s",$from,$where,$order);
$res = $db->query($sql);
if(DB::isError($res)){
echo "クエリの送信が失敗しました。
";
exit;
}
$i = 0;
while($row2 = $res->fetchRow(DB_FETCHMODE_ASSOC)){
$array2[uniq_id][$i] = $row2['uniq_id'];
$array2[title][$i] = $row2['post_title'];
$array2[post_no][$i] = $row2['post_no'];
$array2[user_nm][] = $row2['user_nm'];
$i ++;
}
if(!empty($num)){
for($i=0;$i<1;$i++){
if($i == 0){
$master = $array2[user_nm][$i];
$master_no = $array2['post_no'][$i];
}
$template->setCurrentBlock('__tonari_list__');
$template->setVariable('p_uniq_id',$array2['uniq_id'][$i]);
$template->setVariable('p_title',$array2['title'][$i]);
$template->setVariable('p_nick_nm',$array2[user_nm][$i]);
$template->parseCurrentBlock();
}
}else{
$template->hideBlock('__tonari_list__');
}
//******************************//
// 達人の晩ごはん取得 //
//******************************//
/*
//2006.08.25 J.Nikaido 一時的に削除
if(!empty($master)){
$template->setCurrentBlock('__pro_list__');
$template->setVariable('master',$master);
$template->setVariable('master_no',$master_no);
$template->parseCurrentBlock();
}else{
$template->hideBlock('__pro_list__');
}
*/
$template->show();
//DB開放
$db->disconnect();
cs4_close($this->db);
}
ranking_top( $p );
?>