05 씨스톡 입력된 종가 데이터로 이동평균선 그리기

https://www.moayo.net/p-moayo-21027 (짧은주소)

1) 200일 이동평균선 공식

-200일 이동평균선 = (최근 200일간 종가의 합) / 200 2) 로딩부담에 대한 문제점 -10년 데이터를 업데이트하려면 많은 부담이 됨 -write_avg.php -write_avg_ok.php 3) 차트에 이평선 적용하기

-http://cstock.co.kr/program.php?p_code=stockindex&p=read_sox

write_avg.php (스킨이되는 페이지)

<?
if(!$stock_sdate)$stock_sdate=date("Y-m-d",time()-(24*60*60*32));//30일전
if(!$stock_edate)$stock_edate=date("Y-m-d",time()-(24*60*60*1));
if(!$avg_sum)$avg_sum="200:p_int14";//기본이평선

//종목정보호출
$csql="  select * from {$table[program_id]}{$p_code}_cat where 1";
$csql.=" and use_yn='y'";
$csql.=" and level=1";
$csql.=" order by dep_code asc, ord_code asc";
$cresult=mysql_query($csql,$dbcon);
while($crow=mysql_fetch_array($cresult)){
  $olist.="
  <option value='$crow[value]'>[".$crow[value]."] $crow[title]</option>";
}

?>
<script>
function WRITE(){
  var form=document.form;
  var src="<?=$_SERVER[PHP_SELF]?>?v=p&p_code=<?=$p_code?>&p=write_avg_ok&stock_code="+form.stock_code.value+"&stock_sdate="+form.stock_sdate.value+"&stock_edate="+form.stock_edate.value+"&avg_sum="+form.avg_sum.value;
  if(!writeSubmit(form)){//자동으로 걸러 주는 함수
    return;
  }

  $('#bar_div').show();

  window.open(src,"i_history_insert");//아이프레임으로 열기

}

</script>

<?=ADMIN_TITLE_MAIN("평균선 업데이트","")?>
<form name="form" method="post" action="<?=$_SERVER[PHP_SELF]?>" enctype="multipart/form-data" style="margin:0">
<input type="hidden" name="focus_no" value="<?=$focus_no?>">
<input type="hidden" name="key_code" value="<?=$key_code?>">
<input type="hidden" name="skey_code" value="<?=$skey_code?>">
<input type="hidden" name="p_code" value="<?=$p_code?>">
<input type="hidden" name="p" value="<?=$p?>"><?//페이지?>
<input type="hidden" name="cn" value="<?=$cn?>"><?//페이지번호?>
<input type="hidden" name="t" value="<?=$t?>"><?//타입?>
<input type="hidden" name="v" value="<?=$v?>"><?//보여지는방법?>
<input type="hidden" name="r" value="<?=$r?>"><?//리사이즈?>
<input type="hidden" name="m" value="<?=$m?>"><?//모달?>
<input type="hidden" name="h" value="<?=$h?>"><?//헤더?>
<input type="hidden" name="s" value="<?=$s?>"><?//검색?>
<input type="hidden" name="l" value="<?=$l?>"><?//리스트?>
<input type="hidden" name="rp" value="<?=$rp?>"><?//리턴받는페이지?>
<input type="hidden" name="freload" value="<?=$freload?>"><?//리로드하는 여부?>
<input type="hidden" name="pageNum" value="<?=$pageNum?>"><?//페이지넘?>
<input type="hidden" name="search1" value="<?=$search1?>">
<input type="hidden" name="search2" value="<?=$search2?>">
<input type="hidden" name="search3" value="<?=$search3?>">
<input type="hidden" name="search4" value="<?=$search4?>">
<input type="hidden" name="search5" value="<?=$search5?>">
<!-- 기본적으로 넘어가야 하는 hidden값 -->

<table width="100%" class="twrite">
  <thead>
  <tr>
    <th width=100></th>
    <th></th>
  </tr>
  </thead>
  
  <tbody>
  <tr>
		<th>이평선</td>
		<td>
      <select name="avg_sum" itemname="평균선" s_required>
        <option value="">선택하세요</option>
        <option value="20:p_int11">20일이평선 단기</option>
        <option value="60:p_int12">60일이평선 중기</option>
        <option value="120:p_int13">120일이평선 장기</option>
        <option value="200:p_int14">200일이평선 장기</option>
        <!-- <option value="240:p_int15">240일이평선 장기</option> -->
      </select>
      <script>document.form.avg_sum.value="<?=$avg_sum?>"</script>
    </td>
  </tr>
  <tr>
		<th>종목선택</td>
		<td>
      <select name="stock_code" itemname="가상화폐" s_required>
        <option value="">선택하세요</option>
        <?=$olist?>
      </select>
      <script>document.form.stock_code.value="<?=$stock_code?>"</script>
    </td>
  </tr>
  <tr>
		<th>기간</th>
		<td>
      <input type="date" name="stock_sdate" value="<?=$stock_sdate?>" size=10 style="width:100px;" itemname="기간" s_required>부터
      ~
      <input type="date" name="stock_edate" value="<?=$stock_edate?>" size=10 style="width:100px;" itemname="기간" s_required>까지
    </td>
  </tr>

  </tbody>

  <tfoot>
  </tfoot>
</table>
</form>

<div class="divbutton">
  <input type="button" class="css_button" value="종가평균 업데이트하기" onclick="WRITE()">
</div>

<div id="bar_div" style="width:100%;background:#ffffff;display:none;">
  <div style="position:relative;"><div style="position:absolute;top:15px;left:200px;" id="bar_text"></div></div>
  <progress id="bar" max="100" min="0" value="0" style="width:100%;height:50px;"></progress>
</div>




<div style="width:100%;padding:3px;box-sizing:border-box;">
<iframe src="/default/none.php" id="i_history_insert" name="i_history_insert" style="width:100%;height:50px;" frameborder=0></iframe>
</div>

write_avg_ok.php (하나씩 업데이트하는 페이지)

<?
//$avg_sum="200:p_int14";
$AVG_SUM=explode(":",$avg_sum);
$AVG_SUM[0];//평균
$AVG_SUM[1];//필드명


$stock_count=60*24;//1일
$total_count=((strtotime($stock_edate)-strtotime($stock_sdate))/(24*60*60*1));//전체갯수
$total_count=$total_count*(24*60/$stock_count);


if(!$c)$c=0;
$stock_idate;//진행중인 날짜
if(!$stock_idate){
  if(date("Y-m-d")<=date("Y-m-d",strtotime($stock_edate))){//오늘일때 생략
    $stock_idate=date("Y-m-d");//값이 없으면 오늘날짜
  }else{
    $stock_idate="$stock_edate";//값이 없으면 시작날짜
  }
}

$stock_sdate;//까지날짜
$stock_edate;//시작날짜 (역순으로 기록되기 때문에)

if("$stock_sdate"<=$stock_idate&&$stock_idate<="$stock_edate"){//날짜 범주안에 있는경우
  $sql="  select * from $table[stockindex] where 1 ";
  $sql.=" and p_title='$stock_code'";
  //$sql.=" and ext3='y'";
  $sql.=" and wdate like '$stock_idate%'";
  $sql.=" order by wdate desc";
  $sql.=" limit 0,1";
  $result=mysql_query($sql,$dbcon);
  while($row=mysql_fetch_array($result)){
    $avg=avg_cal($row[p_title],date("Y-m-d",strtotime($row[wdate])),$AVG_SUM[0]);//종가 이평선
    $usql="update $table[stockindex] set {$AVG_SUM[1]}='$avg' where 1 and idx_code='$row[idx_code]'";
    mysql_query($usql,$dbcon);
  }

  $c++;

  $stock_idate=date("Y-m-d",strtotime($stock_idate)-($stock_count*60));
  $per100=number_format((@($c/$total_count)*100),2);

  if($per100=="100.00"){
    $bar_text="완료되었습니다";
  }else{
    $bar_text="{$per100}% 진행중입니다'";
  }

  echo "
  <script>
  parent.\$('#bar_text').html('{$per100}% 진행중입니다');
  parent.\$('#bar').val(".round($per100).");
  </script>
  ";


  echo "
  <script>
location.href='{$_SERVER[PHP_SELF]}?v=$v&p_code=$p_code&p=$p&stock_code=$stock_code&stock_sdate=$stock_sdate&stock_edate=$stock_edate&stock_idate=$stock_idate&avg_sum={$avg_sum}&c=$c'
  </script>
  ";
}else{
  echo "
  <script>
  parent.\$('#bar_div').hide();
  </script>
  ";
  echo "정상처리 되었습니다";
}


?>