tbl_area->find("del_flg='0' and view_flg='0'","view_num asc , id asc");
$area_tag =<<<_EOF_
_EOF_;
//トピックスジャンル取得
$cate = $c->tbl_category->find("del_flg='0' and view_flg='0'","view_num asc , id asc");
$cate_tag =<<<_EOF_
_EOF_;
//ツアージャンル取得
$t_cate = $c->tbl_t_category->find("del_flg='0' and view_flg='0'","view_num asc , id asc");
$tcate_tag =<<<_EOF_
_EOF_;
//ツアー一覧を取得
$tour_list = $c->tbl_tour->find( "del_flg='0' and view_flg='0' and top_flg='0'" , "view_num desc" , 8 );
foreach( $tour_list as $val ){
//エリアとカテゴリの取得
$area = $c->tbl_area->findone( "id='{$val["area"]}' and del_flg='0'" );
$cat = $c->tbl_t_category->findone( "id='{$val["category"]}' and del_flg='0'" );
$date = preg_replace("/-/" , "." , $val["date"]);
//ガイド
if( $val["guide_id"] ){
$guide = $c->tbl_guide->findone("id='{$val["guide_id"]}'");
$guide_name = $guide["title"];
$guide_image = $guide["images"];
}else{
$guide_name = $val["name"];
$guide_image = $val["guide_image"];
}
$tour .=<<<_EOF_
_EOF_;
}
//トピックス一覧を取得
$topics_list = $c->tbl_topics->find( "del_flg='0' and view_flg='0' and top_flg='0'" , "date desc" , 8 );
foreach( $topics_list as $val ){
//エリアとカテゴリの取得
$area = $c->tbl_area->findone( "id='{$val["area"]}' and del_flg='0'" );
$cat = $c->tbl_category->findone( "id='{$val["category"]}' and del_flg='0'" );
$date = preg_replace("/-/" , "." , $val["date"]);
//ガイド
if( $val["writer_id"] ){
$writer = $c->tbl_writer->findone("id='{$val["writer_id"]}'");
$writer_name = $writer["title"];
$writer_image = $writer["images"];
}else{
$writer_name = $val["author"];
$writer_image = $val["authorimg"];
}
$topics .=<<<_EOF_
_EOF_;
}
$c->set("tour" , $tour);
$c->set("topics" , $topics);
$c->set("area" , $area_tag);
$c->set("topics_category" , $cate_tag);
$c->set("tour_category" , $tcate_tag);
}
?>
TOP｜OSAKA旅めがね
Make Friends!
個性豊かな旅めがねFriendsと繋がる！
▼ 旅めがねフレンズが発見！
Today's OsakaInstagram ▼
