<?
require $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";

$tableName = "board_from";
$order_by ="order by no desc,reg_date desc";

include "include_where.php";

//페이지 수 알기.
if ($page && $num) $page = ceil($page / 2);
if($pageTmp) $page= $pageTmp;
if(!$pageCount) $pageCount = 10;

$show_one_page      = $pageCount;
$show_view_page     = 7;
$page     = ( $page ) ? $page : 1;
$offset   = ($page-1)*$show_one_page;
//$order_by ="order by sortNum,no desc,reg_date desc";



  $total_count  = get_db("SELECT count(*) FROM $tableName where is_delete = 'N' $where");
  $query_limit  = "limit $offset,$show_one_page";

  $QUERY_PAGE  = "SELECT *,(select no from board_chuchun where module_no=a.no and module_name='$tableName' and uid_fk='$sessionIDX') as voted_chk FROM $tableName as a where is_delete = 'N' $where $order_by $query_limit";

  $total_page   = ceil( $total_count / $show_one_page);
  $more_next_page = $page+1;
  $viewlist     = ( !$total_count ) ? "" : Get_viewpage5($page,$total_count,$show_one_page,$show_view_page,$url_tail);
  $start_num    = $total_count - $offset;  //
  $result= mysql_query($QUERY_PAGE,$db_con);

  if(!$result) {
    error("DB_ERROR");
    exit;
  }
  $total = mysql_affected_rows();

  if(!$total)
  {
    $BRD_LIST = "<div class='post' style='text-align:center;'>情報がありません。</div>";
  }
  else
  {
    for($i=0; $i<$total; $i++)
    {
      unset($NUM_IMG,$New_icon,$total_c,$COMMENT_LIST);
      //$Num = ($total_count-$offset) - $i;
      $row = mysql_fetch_array($result);
      $Num = $row[no];
			$editorNum = $Num;
			if($editorNum == 1) $editorNum=10000;
      $regdate = substr($row[reg_date],0,10);
      $regdateArr = explode("-",$regdate);
			//hit
			if($Num){
			 $queryhit = "update $tableName set hit = hit+1 where no='$Num'";
			 $hitresult = mysql_query($queryhit, $db_con);
			}

			$hit_count = $row[hit]+1;

      if($regdate == $today){$New_icon="<font color=orange><b>NEW</b></font>";}

      if($row[is_notice] =='Y') $is_notice_chk="[お知らせ]";
      else $is_notice_chk="";

      if($row[is_secret] =='Y') $is_secret_chk="<font color=red>[관리자만 보임]</font>";
      else $is_secret_chk="";
			$tmp_subject = stripslashes($row[subject]);
			$SUBJECT_SUMMARY = utf8_cutstr($tmp_subject,15,$tail="...");

      $RESULT_CONTENT = $row[contents];
      $RESULT_CONTENT = stripslashes($RESULT_CONTENT);
      //$RESULT_CONTENT=preg_replace("/ style=([^\"\']+) /"," ",$RESULT_CONTENT); // style=border:0... 따옴표가 없을때
      //$RESULT_CONTENT=preg_replace("/ style=(\"|\')?([^\"\']+)(\"|\')?/","",$RESULT_CONTENT); // style="border:0..." 따옴표 있을때 style='width:100%;max-width:650px;'

      $RESULT_CONTENT = preg_replace("/ height:(\"|\')?([^\"\']+)(\"|\')?;/","",$RESULT_CONTENT);
      $RESULT_CONTENT = preg_replace("/ width:(\"|\')?([^\"\']+)(\"|\')?;/","",$RESULT_CONTENT);

      $RESULT_CONTENT=preg_replace("/ height=(\"|\')?\d+(\"|\')?/","",$RESULT_CONTENT);
      $RESULT_CONTENT=preg_replace("/ width=(\"|\')?\d+(\"|\')?/","width='100%'",$RESULT_CONTENT);

      //더보기 버튼
      $BTN_CONTENT_MORE ="<a  onclick='chkSummary($Num);' class='more' style='cursor:pointer;'> ......もっと見る</a>";

      $RESULT_CONTENT_SUMMARY = utf8_cutstr($RESULT_CONTENT,480,$tail=$BTN_CONTENT_MORE);

			//글쓴이 이미지 색상
			$tmp_img= get_imgColor($row[user_no]);
			$m_img_big =$tmp_img[0];
			$m_color = $tmp_img[1];

      //댓글
     if(!$cm_pageCount) $cm_pageCount =4;
     $cm_show_one_page      = $cm_pageCount;
     $cm_show_view_page     = 5;
     $cm_page     = ( $cm_page ) ? $cm_page : 1;
     $cm_offset   = ($cm_page-1)*$cm_show_one_page;
     $cm_query_limit  = "limit $cm_offset,$cm_show_one_page";
     $cm_QUERY_TOTAL = "SELECT count(*) FROM board_comment WHERE module_name='".$tableName."' and module_no='".$Num."' ";
     $cm_QUERY  = "SELECT * FROM board_comment WHERE module_name='".$tableName."' and module_no='".$Num."' ORDER BY reg_date desc,idx desc $cm_query_limit";
     $cm_total_count  = get_db($cm_QUERY_TOTAL);
     $cm_results= mysql_query($cm_QUERY,$db_con);
     $cm_total_c = mysql_affected_rows();

     $cm_total_page   = ceil( $cm_total_count / $cm_show_one_page);
     $cm_start_num    = $cm_total_count - $cm_offset;
     $cm_more_next_page = $cm_page+1;
     $viewMore     = ($cm_pageCount >=$cm_total_count) ? "" : "<a href='javascript:fnMore($Num,\"$tableName\");' class='btn_cla".$Num."' id='$cm_more_next_page' data-total='$cm_total_page'><div class='pagination033' id='btnMore'><img src='/images/sub/sub_pagbar_more_02.png'/></div></a>";

      for($k=0; $k<$cm_total_c; $k++)
     {
       $rows = mysql_fetch_array($cm_results);
       $regdate_comm = substr($rows[reg_date],0,10);
       $regdateArr_comm = explode("-",$regdate_comm);
			 //댓글 이미지 색상
				$tmp_img= get_imgColor($rows[user_no]);
				$replyImg =$tmp_img[0];
				$replyColor = $tmp_img[1];
       if($rows[user_no] == $sessionIDX || $sessionLevel==15) $img_del = "<a href='javascript: commnet_del($rows[idx]);' style='margin:3px;'><img src='../images/sub/icon_del.jpg' alt='del' /></a>";
       else $img_del ="";

       $COMMENT_LIST .="
       <div class='mv_date_tit' id='vi".$rows[idx]."'>
          <div class='mvdate_tit_le nobody02' style='background-color:".$replyColor.";overflow: hidden; position: relative;'>$replyImg</div>
         <div class='mvdate_tit_ri'>$rows[user_name] <span class='mvis_date'>$regdateArr_comm[0].$regdateArr_comm[1].$regdateArr_comm[2]</span>$img_del<h2 class='font_nomal' style='word-break:break-all;'>$rows[content]</h2></div>
        </div>
       ";
     }

      if($row[voted_chk]){
        $voted_img_tail = "on";
        $voted_count_color = "#FF4D06";
      }else{
        $voted_img_tail = "off";
        $voted_count_color = "#838383";
      }
		//수정버튼
		if($row[user_no] == $sessionIDX || $sessionLevel==15){
			$btn_modify="
			<div class='le'>
						<ul>
						<li class='mv_but'>
							<input type='button'  class='cancel' value='削除' onclick='board_del($Num)'>
							<input type='button'  class='cancel' id='btn_form_close".$Num."' value='キャンセル' onclick='modifyform($Num,2)' style='display:none;'>
							<input type='button' class='submitIn' id='btn_form_open".$Num."'  value='修正' onclick='modifyform($Num,1)'>
							<input type='button' class='submitIn' id='btn_modify".$Num."' value='修正' onclick='modify_ok($Num,$page)' style='display:none;'>
						</li>
						</ul>
					</div>
			";
		}else{
			$btn_modify="";
		}

		//첨부파일 시작
		$res = "select file_name,original_name,file_type from files where module_no = '$Num' and module_name='$tableName' order by no";
		$results= mysql_query($res,$db_con);
		$rows = mysql_fetch_array($results);
		//파일 유무체크
		$is_file_exist = file_exists("./files/from/".$rows[file_name]);
		if ($is_file_exist) {
			if($rows[file_type] == 'JPG' ||$rows[file_type] == 'jpg' ||$rows[file_type] == 'peg' || $rows[file_type] == 'gif' || $rows[file_type] == 'png' || $rows[file_type] == 'bmp')
			{
				$img_size = GetImageSize($_SERVER['DOCUMENT_ROOT']."/files/from/".$rows[file_name]);
				$x = $img_size[0];
				$y = $img_size[1];

				if($x < 450)
				{
					$widthX = $x;
				}
				else
				{
					$widthX = "100%";
				}

				$NUM_IMG = "<img src='/files/from/$rows[file_name]' width='$widthX'></br></br>";
			}
			else if($rows[file_type] == 'wmv' || $rows[file_type] == 'asf' || $rows[file_type] == 'mov' || $rows[file_type] == 'mp4')
			{
				$NUM_IMG = "	<div style='width:100%;text-align:center'><video id='movLink1' src='/files/from/".$rows[file_name]."' style='width:80%;height:30%' controls style='display:none;' controlsList = 'nodownload' >このブラウザでは再生できません.</video></div>";
				$NUM_IMGS = "	<div style='width:100%;text-align:center'><video id='movLink2' style='display:none;' src='/files/from/".$rows[file_name]."' style='width:80%;height:30%' controls style='display:none;' controlsList = 'nodownload' >このブラウザでは再生できません.</video></div>";
			}
		}else{
			$NUM_IMG="";
		}
		//첨부파일 끝

    $BRD_LIST .="
    <div class='post02' id='post".$Num."'>
      <div class='btn_top'>
      <div style='position:relative; left:0; top:0px; z-index:5; margin-right:0px;'><a href='javascript:chklist($Num);'><img id='listBtn".$Num."' src='../images/sub/icon_arr_more.jpg' /></a></div>
      </div>

      <div class='mv_date_tit'>
        <div class='mvdate_tit_le nobody01' style='background-color:".$m_color.";overflow: hidden; position: relative;'>$m_img_big</div>
        <div class='mvdate_tit_ri font_bold'>$row[user_name] <span class='mvis_date'>$regdateArr[0].$regdateArr[1].$regdateArr[2]</span><br/>
        <span  id='subject".$Num."'>$row[subject]</span>
				<span  id='modifySubject".$Num."'  style='display:none;' class='mvCom_tit_ri' ><input type='text' value='$row[subject]' id='lname".$Num."' style='width:97%'></span>
				$is_secret_chk
        </div>

      </div>

      <div  id='list".$Num."' class='post_del'>
        <p id='summary_$Num' class='line_h23px padding_b_40 imgSize'>$NUM_IMG $RESULT_CONTENT</p>
				<p id='modify_$Num' class='line_h23px padding_b_40' style='display:none;'><textarea cols='60' id='editor".$editorNum."' name='contents".$Num."' rows='10'>$RESULT_CONTENT</textarea>
					<script type='text/javascript'>
						CKEDITOR.replace('editor".$editorNum."',
						{
						language: 'ja',
						enterMode	: Number(2),
						//uiColor: '#9AB8F3',

						filebrowserUploadUrl: './editor_upload.php?type=Files',
						filebrowserImageUploadUrl: './editor_upload.php?type=Images',

						});
					</script>
				</p>
        <div class='movie_icon02'>

          <div class='le'>
            <ul>
            <li><img src='../images/sub/icon_mv_comt.png' /><span id='comment_num".$Num."'> $row[reply_count]</span></li>
            <li id='voted_color_".$Num."' style='color:".$voted_count_color.";'><a href='javascript: content_like($Num,\"$tableName\",$sessionLevel);' class='li_like'><img  id='voted_img".$Num."' src='../images/sub/icon_mv_like_".$voted_img_tail.".png' /></a><span id='voted_number".$Num."' style='color:".$voted_count_color.";'>$row[voted_count]</span>名</li>
            </ul>
          </div>
          <div class='ri'>
            <ul>
            <li> クリック <span class='icon_txt'> $hit_count</span></li>
            </ul>
          </div>

        </div>
				$btn_modify

      </div>

    </div>

    <!-- 코멘트 글쓰기 리스트-->
    <div  id='area".$Num."' class='movieBig02 '>
     <div class='post02'>
      <form  name='form' method='post' action='javascript: commentok($Num,\"$tableName\");'>
      <div class='mv_date_tit'>
     	 <div class='mvCom_cot_le nobody01' style='height:43px; background-color:".$_SESSION[S_COLOR].";overflow: hidden; position: relative;'>$_SESSION[S_IMG_B]</div>
     	 <div class='mvCom_cot_ri'><textarea id='comment".$Num."' name='comment' placeholder='' style='height:43px;' onclick='$(this).height(60);'></textarea></div>
      </div>

      <div class='mv_input_but'>
       <ul>
        <li class='mv_txt'>’".$SUBJECT_SUMMARY."’に対するコメントを登録できます。</li>
        <li class='mv_but'><input type='submit' class='submitIn' value='コメント登録'> </li>
       </ul>
      </div>
      </form>
      <div id='com_new".$Num."'></div>
      $COMMENT_LIST
       <div id='com_li".$Num."'></div>
      $viewMore

     </div>
    </div>

    ";

  }
}

?>
        <div class="con_right">
        <?=$BRD_LIST?>
        <div class="pagination02">
            <?=$viewlist?>
        </div>
        </div>