<?php
	include("../init1_db.php");

$PAGE_TITLE = "スゴろく";
$index_flag = 1 ;

$DEBUG = 1 ;


$wheresql	= 	" where bkn_disp_flag = 1 and ( ( bkn_flag10 = 1 ) or ( bkn_start_date is null or ( bkn_flag10=1 or ( bkn_start_date <= '$cond4' and bkn_end_date >= '$cond4' ) ) ) ) ";
$wheresql	.= 	" and bkca_id=14 ";
// $wk_fieldname2	=	" bkn_no desc , bkn_rsv3 desc , bkn_id";
$wk_fieldname2	=	" bkn_rsv3 desc , bkn_no desc , bkn_id";

$no	=	func_sanitaze( func_parm_get( 'no' ) , 2 ) ;

$week	=	func_sanitaze( func_parm_get( 'week' ) , 2 ) ;
$week_flag	=	0 ;
if( $week )
{
	$key	=	array_search( $week , $DEF_UTTY_WEEK2 ) ;
	if( $key!==false )
	{
		$week_flag	=	$key ;
		$PAGE_TITLE	.=	"[" ;
		$PAGE_TITLE	.=	$DEF_UTTY_WEEK[$key] ;
		$PAGE_TITLE	.=	"]" ;
	}
	else
		$week = "";
}
$get_field	=	"bkn_id ," ;
$get_field	.=	"bkn_name ," ;
$get_field	.=	"bkn_memo1 ," ;
$get_field	.=	"bkn_memo2 ," ;
$get_field	.=	"bkn_memo3 ," ;
$get_field	.=	"bkn_memo4 ," ;
$get_field	.=	"bkn_memo5 ," ;
$get_field	.=	"bkn_memo6 ," ;
$get_field	.=	"bkn_memo7 ," ;
$get_field	.=	"bkn_memo8 ," ;
$get_field	.=	"bkn_memo9 ," ;
$get_field	.=	"bkn_memo10 ," ;
$get_field	.=	"bkn_img1 ," ;
$get_field	.=	"bkn_img2 ," ;
$get_field	.=	"bkn_img3 ," ;
$get_field	.=	"bkn_img4 ," ;
$get_field	.=	"bkn_img5 ," ;
$get_field	.=	"bkn_img6 ," ;
$get_field	.=	"bkn_img7 ," ;
$get_field	.=	"bkn_img8 ," ;
$get_field	.=	"bkn_img9 ," ;
$get_field	.=	"bkn_img10 ," ;
$get_field	.=	"bkn_img11 ," ;
$get_field	.=	"bkn_img12 ," ;
$get_field	.=	"bkn_img13 ," ;
$get_field	.=	"bkn_img14 ," ;
$get_field	.=	"bkn_img15 ," ;
$get_field	.=	"bkn_img16 ," ;
$get_field	.=	"bkn_img17 ," ;
$get_field	.=	"bkn_img18 ," ;
$get_field	.=	"bkn_img19 ," ;
$get_field	.=	"bkn_img20 ," ;
$get_field	.=	"bkn_memo_title1 ," ;
$get_field	.=	"bkn_memo_title2 ," ;
$get_field	.=	"bkn_memo_title3 ," ;
$get_field	.=	"bkn_memo_title4 ," ;
$get_field	.=	"bkn_memo_title5 ," ;
$get_field	.=	"bkn_memo_title6 ," ;
$get_field	.=	"bkn_memo_title7 ," ;
$get_field	.=	"bkn_memo_title8 ," ;
$get_field	.=	"bkn_memo_title9 ," ;
$get_field	.=	"bkn_link_url1 ," ;
$get_field	.=	"bkn_link_url2 ," ;
$get_field	.=	"bkn_link_url3 ," ;
$get_field	.=	"bkn_link_url4 ," ;
$get_field	.=	"bkn_link_url5 ," ;
$get_field	.=	"bkn_link_url6 ," ;
$get_field	.=	"bkn_link_url7 ," ;
$get_field	.=	"bkn_link_url8 ," ;
$get_field	.=	"bkn_link_url9 ," ;
$get_field	.=	"bkn_link_url_title1 ," ;
$get_field	.=	"bkn_link_url_title2 ," ;
$get_field	.=	"bkn_link_url_title3 ," ;
$get_field	.=	"bkn_link_url_title4 ," ;
$get_field	.=	"bkn_link_url_title5 ," ;
$get_field	.=	"bkn_link_url_title6 ," ;
$get_field	.=	"bkn_link_url_title7 ," ;
$get_field	.=	"bkn_link_url_title8 ," ;
$get_field	.=	"bkn_link_url_title9 ," ;
$get_field	.=	"bkn_pdf1 ," ;
$get_field	.=	"bkn_pdf2 ," ;
$get_field	.=	"bkn_pdf_title1 ," ;
$get_field	.=	"bkn_pdf_title2 ," ;
$get_field	.=	"bkn_flag3 ," ;
$get_field	.=	"bkn_rand ," ;
$get_field	.=	"bkn_rsv3 , " ;
$get_field	.=	"bkn_rsv5 " ;

if( $no && is_numeric( $no ) )
{
	$stmt = "SELECT ";
	$stmt .= $get_field ;
	$stmt .= "FROM t_backnumber $wheresql and " ;
	$stmt .= "bkn_id=" ;
	$stmt .= $no ;
	$sth = dbRunSql( $stmt ) ;
	$j = @mysqli_num_rows ( $sth ) ;
	if( $j > 0 )
	{
		$data	= mysqli_fetch_array( $sth , MYSQLI_ASSOC ) ;
	}
	$rinf = dbFreeResult( $sth ) ;
}
if( !$data['bkn_id'] )
{
	$stmt = "SELECT ";
	$stmt .= $get_field ;
	$stmt .= "FROM t_backnumber $wheresql " ;
	if( $week_flag )
	{
		$stmt .= " and bkn_flag3=" ;
		$stmt .= $week_flag ;
	}
	$stmt .= " order by " ;
	$stmt .= $wk_fieldname2 ;
	$stmt .= " limit 0,1 " ;
	$sth = dbRunSql( $stmt ) ;
	$j = @mysqli_num_rows ( $sth ) ;
	if( $j > 0 )
	{
		$data	= mysqli_fetch_array( $sth , MYSQLI_ASSOC ) ;
	}
	$rinf = dbFreeResult( $sth ) ;
}
?>
<!doctype html>
<html class="no-js" lang="ja">
    <head>
        <meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="format-detection" content="telephone=no" />
<meta name="robots" content="INDEX,FOLLOW" />
<meta http-equiv="imagetoolbar" content="no" />
<meta name="Keywords" content="<?php print $CHAR_KEYWORD;?>" />
<meta name="Description" content="<?php print $CHAR_DESCRIPTION;?>" />
<meta http-equiv="expires" content="sat, 1 Jan 2000 00:00:00 GMT" />
<meta http-equiv="cache-control" content="no-store, no-cache, must-revalidate, max-age=0" />
<meta http-equiv="cache-control" content="post-check=0, pre-check=0" />
<meta http-equiv="pragma" content="no-cache" />
<base href="<?php print $HOME_URL ; ?>sugoroku/">
<title><?php print $PAGE_TITLE." | ".$SITE_NAME ; ?></title>
<link rel="shortcut icon" href="<?php print $CHAR_FAVICON;?>" />

		<!-- ========================= CSS here ========================= -->
		<link rel="stylesheet" href="../css/bootstrap-5.0.0-alpha-1.min.css">
    <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous">
        <link rel="stylesheet" href="../css/LineIcons.2.0.css">
		<link rel="stylesheet" href="../css/animate.css">
		<link rel="stylesheet" href="../css/slider-pro.css">
		<link rel="stylesheet" href="../assets/js/slick/slick-theme.css">
		<link rel="stylesheet" href="../assets/js/slick/slick.css">
		<link rel="stylesheet" href="../css/main.css">
		<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.2.0/magnific-popup.min.css">
<?php
if( $DEBUG )
{
	include( "../common/accesslog.php" ) ;
}
?>
    </head>
    <body class="subbody" oncontextmenu="return false;">
        <!--[if lte IE 9]>
            <p class="browserupgrade">You are using an <strong>outdated</strong> browser. Please <a href="https://browsehappy.com/">upgrade your browser</a> to improve your experience and security.</p>
        <![endif]-->
<?php include("../common/header.php"); ?>
        
 <div class="sub_main2">
<nav aria-label="breadcrumb">
          <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="../">TOP</a></li>
            <li class="breadcrumb-item"><a href="./">スゴろくTOP</a></li>
            <li class="breadcrumb-item active" aria-current="page"><?php print $PAGE_TITLE ; ?></li>
          </ol>
        </nav>

<section class="module">
<div class="container">
	<div class="row">
		<div class="col-lg-8 col-xl-9 offset-lg-4 offset-xl-3">
<?php
if( $data['bkn_name'] )
{
		$week_flag	=	$data['bkn_flag3'] ;
		$week		=	$DEF_UTTY_WEEK2[$week_flag] ;
?>
			<div class="sugoroku-main">
				<div class="sugoroku-header">
                    <h3 class="h3 text-center"><img src="../images/sugoroku/icon1.svg" width="70">&nbsp;&nbsp;今週の放送</h3>
				</div>
                        <ul class="sugoroku-youbi-menu">
                            <li class="mon<?php print ( $week == "mon" ? " active" : "" ) ; ?>"><a href="./info.php?week=mon">月<span>曜日</span></a></li>
                            <li class="tue<?php print ( $week == "tue" ? " active" : "" ) ; ?>"><a href="./info.php?week=tue">火<span>曜日</span></a></li>
                            <li class="wed<?php print ( $week == "wed" ? " active" : "" ) ; ?>"><a href="./info.php?week=wed">水<span>曜日</span></a></li>
                            <li class="thu<?php print ( $week == "thu" ? " active" : "" ) ; ?>"><a href="./info.php?week=thu">木<span>曜日</span></a></li>
                            <li class="fri<?php print ( $week == "fri" ? " active" : "" ) ; ?>"><a href="./info.php?week=fri">金<span>曜日1</span></a></li>
                            <li class="fri2<?php print ( $week == "fri2" ? " active" : "" ) ; ?>"><a href="./info.php?week=fri2">金<span>曜日2</span></a></li>
                        </ul>
				<div class="sugoroku-main-inner">
                            <h2 class="title"><span class="weektag<?php print ( $week ? " ".$week : "" ) ; ?>"><?php print $DEF_UTTY_WEEK[$week_flag] ; ?></span><?php print $data['bkn_name'] ; ?>（<?php print (int)substr( $data['bkn_rsv3'] , 5 , 2 )."月".(int)substr( $data['bkn_rsv3'] , 8 , 2 )."日" ; ?>）</h2>
<?php
					if( $data['bkn_img1'] )
					{
						$img	=	$UPIMG_PATH."backnumber/".$data['bkn_rand']."/".$data['bkn_img1'] ;
?>
					<div class="sugoroku-main-img">
                                <img src="<?php print $img ; ?>" alt="<?php print $data['bkn_name'] ; ?>" class="img-responsive">
					</div>
<?php
					}
?>
                            <ul class="sugoroku-main-program">
<?php
//					for( $i=2 ; $i<=6 ; $i++ )
					for( $i=2 ; $i<=9 ; $i++ )
					{
						if( $data['bkn_memo_title'.$i] || $data['bkn_img'.$i] || $data['bkn_memo'.$i] )
						{
							$img	=	"" ;
							if( $data['bkn_img'.$i] )
								$img	=	$UPIMG_PATH."backnumber/".$data['bkn_rand']."/".$data['bkn_img'.$i] ;
?>
                                <li>
                                    <div class="row">
                                        <div class="col-md-<?php print ( $img ? "6" : "12" ) ; ?> order-md-last">
                                            <h4 class="text-orange"><?php print ( $data['bkn_memo_title'.$i] ? $data['bkn_memo_title'.$i] : "" ) ; ?></h4>
                                            <p class="mt-3">
<?php
//									print nl2br( func_non_entity( $data['bkn_memo'.$i] ) ) ;
									$wk	=	func_non_entity( $data['bkn_memo'.$i] ) ;
									$wk	=	str_replace( "https://www.fujikyu.co.jp/fujisannohi-223/" , "<a href=\"https://www.fujikyu.co.jp/fujisannohi-223/\" target=\"_blank\">https://www.fujikyu.co.jp/fujisannohi-223/</a>" , $wk ) ;
									print nl2br( $wk ) ;
?>
                                            </p>
                                        </div>
<?php
							if( $img )
							{
?>
                                        <div class="col-md-6 order-md-first">
                                        <a href="<?php print $img ; ?>" class="boxer" data-gallery="gallery"><img src="<?php print $img ; ?>" alt="<?php print $data['bkn_memo_title'.$i] ; ?>" class="img-responsive"></a>
                                        </div>
<?php
							}
?>
                                    </div>
                                </li>
<?php
						}
					}
?>
                           </ul>
<?php
					if( $data['bkn_memo10'] )
					{
?>
							<div class="row">
								<div class="col-sm-12">
<?php
									$wk	=	func_non_entity( $data['bkn_memo10'] ) ;
									$wk	=	str_replace( "<img src=\"" , "<img class=\"img-responsive img-responsive-center\" src=\"" , $wk ) ;
									print nl2br( $wk ) ;
?>
								</div>
							</div><!--row -->
<?php
					}
					if( $data['bkn_pdf1'] || $data['bkn_pdf2'] )
					{
?>
							<div class="row">
								<div class="col-sm-12">
<?php
						if( $data['bkn_pdf1'] )
						{
							$link_s	=	$UPIMG_PATH."backnumber/".$data['bkn_rand']."/".$data['bkn_pdf1'];
							$file	= 	$updir_path."backnumber/".$data['bkn_rand']."/".$data['bkn_pdf1'];
							if( file_exists ( $file ) )
							{
?>
				            <p class="indent pull-left"><span class="icon-download"></span>&nbsp;&nbsp;<a href="<?php print $link_s ; ?>" target="_blank" class="grey-text btn btn-primary3 "><i class="fa fa-file-pdf-o"></i>&nbsp;&nbsp;<?php print ( $data['bkn_pdf_title1'] ? $data['bkn_pdf_title1'] : "関連ファイル" ); ?></a></p>
<?php
							}
						}
						if( $data['bkn_pdf2'] )
						{
							$link_s	=	$UPIMG_PATH."backnumber/".$data['bkn_rand']."/".$data['bkn_pdf2'];
							$file	= 	$updir_path."backnumber/".$data['bkn_rand']."/".$data['bkn_pdf2'];
							if( file_exists ( $file ) )
							{
?>
				            <p class="indent pull-left"><span class="icon-download"></span>&nbsp;&nbsp;<a href="<?php print $link_s ; ?>" target="_blank" class="grey-text btn btn-primary3 "><i class="fa fa-file-pdf-o"></i>&nbsp;&nbsp;<?php print ( $data['bkn_pdf_title2'] ? $data['bkn_pdf_title2'] : "関連ファイル" ); ?></a></p>
<?php
							}
						}
?>
								</div>
							</div><!--row -->
<?php
					}
?>
<?php
					if( $data['bkn_img11'] )
					{
						$img	=	$UPIMG_PATH."backnumber/".$data['bkn_rand']."/".$data['bkn_img11'] ;
?>
					<div class="sugoroku-main-img">
                                <img src="<?php print $img ; ?>" alt="<?php print $data['bkn_name'] ; ?>" class="img-responsive">
					</div>
<?php
					}
?>
<?php
					$arr1	=	array() ;
					$arr2	=	array() ;
					if( $data['bkn_memo1'] )
						$arr1	=	explode( "^^" , $data['bkn_memo1'] ) ;
					if( $data['bkn_rsv5'] )
						$arr2	=	explode( "^^" , $data['bkn_rsv5'] ) ;

?>
                            <ul class="sugoroku-main-program">
<?php
					for( $i=0 ; $i<5 ; $i++ )
					{
						$ii = $i + 12 ;
						if( $arr1[$i] || $arr2[$i] || $data['bkn_img'.$ii] )
						{
							$img	=	"" ;
							if( $data['bkn_img'.$i] )
								$img	=	$UPIMG_PATH."backnumber/".$data['bkn_rand']."/".$data['bkn_img'.$ii] ;
?>
                                <li>
                                    <div class="row">
                                        <div class="col-md-<?php print ( $img ? "6" : "12" ) ; ?> order-md-last">
                                            <h4 class="text-orange"><?php print (  $arr1[$i] ?  $arr1[$i] : "" ) ; ?></h4>
                                            <p class="mt-3">
<?php
									print nl2br( func_non_entity( $arr2[$i] ) ) ;
?>
                                            </p>
                                        </div>
<?php
							if( $img )
							{
?>
                                        <div class="col-md-6 order-md-first">
                                        <a href="<?php print $img ; ?>" class="popup-image" data-gallery="gallery"><img src="<?php print $img ; ?>" alt="<?php print  $arr1[$i] ; ?>" class="img-responsive"></a>
                                        </div>
<?php
							}
?>
                                    </div>
                                </li>
<?php
						}
					}
					unset( $arr1 ) ;
					unset( $arr2 ) ;
?>
                           </ul>
<?php
		$disp_id	=	$data['bkn_id'] ;
	if( $DEBUG )
	{
		include( "./sub_backnumber_count.php" );
	}
?>

				</div>
			</div>
			<div class="mt-5">
				<div class="bside">
					<div class="pastnews_area">
						<div class="bside_title_text">
                                <h2 class="title font-alt">Back Number</h2>
                                <p class="title_lead">バックナンバー</p>
						</div>
                            <ul class="news_detail_list">
<?php
	$wheresql	= 	" where bkn_disp_flag = 1 and ( ( bkn_flag10 = 1 ) or ( bkn_start_date is null or ( bkn_flag10=1 or ( bkn_start_date <= '$cond4' and bkn_end_date >= '$cond4' ) ) ) ) ";
	$wheresql	.= 	" and bkca_id=14 ";
	$wk_fieldname2	=	" bkn_rsv3 desc , bkn_no desc , bkn_id";

	$stmt = "SELECT ";
	$stmt .= "bkn_id , ";
	$stmt .= "bkn_name , ";
	$stmt .= "bkn_img1 , ";
	$stmt .= "bkn_jump_url , ";
	$stmt .= "bkn_flag9 , ";
	$stmt .= "bkn_rsv3 ,";
	$stmt .= "bkn_rand ";
	$stmt .= "FROM t_backnumber $wheresql " ;
	$stmt .= " and bkn_flag2=0 " ;
	$stmt .= " and bkn_flag3=" ;
	$stmt .= $week_flag ;
	$stmt .= " order by $wk_fieldname2  limit 12" ;
	$sth = dbRunSql( $stmt ) ;
	$j = @mysqli_num_rows ( $sth ) ;

	for( $i=0 ; $i<$j ; $i++ )
	{
		$row	=	mysqli_fetch_object( $sth ) ;

		$link_s		=	"" ;
		$target_s	=	"" ;
		if( $row->bkn_jump_url )
		{
			$link_s		=	$row->bkn_jump_url ;
			$target_s	=	( $row->bkn_flag9==1 ? " target=\"_blank\"" : "" ) ;
		}
		else
			$link_s		=	"./info.php?no=".$row->bkn_id."#week" ;
?>
                            <li><a href="<?php print $link_s ; ?>"<?php print $target_s ; ?> class="bn_list">
<?php
			if( $row->bkn_img1 )
			{
				$img	=	$UPIMG_PATH."backnumber/".$row->bkn_rand."/".$row->bkn_img1 ;
?>
                            <div class="bn_list_img"><img src="<?php print $img ; ?>" alt="<?php print $row->bkn_name ; ?>" class="img-responsive"></div>
<?php
			}
?>
                            <div class="bn_list_info"><span class="date"><?php print str_replace( "/" , "." , $row->bkn_rsv3 ) ; ?></span><?php print $row->bkn_name ; ?></div></a></li>
<?php
		unset( $row ) ;
	}
	$rinf = dbFreeResult( $sth ) ;
?>
                        </ul>
                        
					</div>
				</div>
				<div class="text-center mt-5 mb-5">
					<a href="./backnumber.php?week=<?php print ( $week ? $week : "" ) ; ?>" class="btn btn-download btn-lg">バックナンバー</a>
				</div>
			</div>
<?php
}
else
{
?>
<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<?php
}
unset( $data ) ;
?>
		</div>
	</div>
</div>
</section>
<?php include("./aside.php"); ?>
</div>
<?php include("../common/footer.php"); ?>

        <!-- ========================= scroll-top ========================= -->
        <a href="#" class="scroll-top">
            <i class="fas fa-level-up-alt"></i>
        </a>

		<!-- ========================= JS here ========================= -->
		<script src="../assets/js/bootstrap.bundle-5.0.0.alpha-1-min.js"></script>
		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
		<script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.2.0/jquery.magnific-popup.min.js"></script>
		<script src="../assets/js/wow.min.js"></script>
		<script src="../assets/js/main.js"></script>
   <script src="../assets/js/jquery.matchHeight.js"></script>
   <script src="../assets/js/jquery.sliderPro.min.js"></script>
   <script src="../assets/js/slick/slick.js"></script>
   <script src="../js/jquery.fs.boxer.js"></script>
   <script>
      $(function() {
    $('.boxer').boxer();
    $('.weekprogram').matchHeight();
    $('.link_list_footer').matchHeight();
     $('.bn_list_info').matchHeight();     
  });
  $(function(){
$('.sugoroku-main-inner').magnificPopup({
type: 'image',
delegate: "a", 
gallery: {
    enabled: true, //ギャラリーを有効可
  },
zoom: {
enabled: true,
duration: 300,
easing: 'ease-in-out'
}
});
});
    </script>
<?php
func_array_unset() ;
/* データベースクローズ */
mysqli_close( $dbh ) ;
?>
    </body>
</html>
