MINI SHELL

Server : Apache/2.2.2 (Fedora)
System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686
User : apache ( 48)
PHP Version : 5.2.9
Disable Function : NONE
Directory :  /proc/self/root/home/pathumthani_integration/integration/application/indicator/back/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Current File : //proc/self/root/home/pathumthani_integration/integration/application/indicator/back/index.php
<? session_start() ; 
#START
###### This Program is copyright Sapphire Research and Development co.,ltd ########
$ApplicationName	= "demo1";
$module_code 		= "demo1"; 
$process_id			= "demo1";
$VERSION 				= "1";
$BypassAPP 			= true;

//$_SESSION[secid];
	###################################################################
	## COMPETENCY  MANAGEMENT SUPPORTING SYSTEM
	###################################################################
	## Version :		20090703.001 (Created/Modified; Date.RunNumber)
	## Created Date :		2009-07-03 09:49
	## Created By :		MR.TANAPAT TABOONDEE
	## E-mail :			
	## Tel. :			
	## Company :		Sappire Research and Development Co.,Ltd. (C)All Right Reserved
	###################################################################
	## Version :		20090703.002
	## Modified Detail :		˹ѧÊ×ͤÓÊÑè§
	## Modified Date :		2009-07-03 09:49
	## Modified By :		MR.TANAPAT TABOONDEE
###################################################################


set_time_limit(0) ; 
if ( $_SESSION[siteid]   != ""){ 
	# $_SESSION[reportsecid]
} 
if ($xsiteid == ""){ $xsiteid = $_SESSION[siteid]  ;    $xxsiteid = $xsiteid  ; } 

if ($loginid != ""){   $xxsiteid = $loginid  ; } 
if ($_SESSION[reportsecid] == "cmss-otcsc" ){
	########### ok 
} ### END if ($_SESSION[reportsecid] == "cmss-otcsc" ){
//
/*echo "<pre>";
print_r($_SESSION);
*/
//if($xsiteid != ""){ $xsiteid = $xsiteid;}else{ $xsiteid = "5006";}; // ¡Ã³Õ·´Êͺã¹à¤Ã×èͧ

$cmss_master = "cmss_master" ; 
$lead_general = "general";
$view_general = "view_general";
$now_dbname = "cmss_". $xxsiteid ; 

include("../../config/config_epm.inc.php");
//include("../../common/common_competency.inc.php");

//include("../../common/class_create_temp.php");
//$time_start = getmicrotime();

$arrIdUser = explode(".",$session_username);// µÇÃǨÊͺÇèÒà»ç¹¡Òà login ¨Ò¡à¢µÁÑéÂ
$numCheck = $arrIdUser[1];
	if($numCheck != ""){
		$print_t = "Y";
		$id = $xsiteid;
		$xcol = 0;
		$Disp = "aumphur";
		$action="province";
}

ob_start();
$Disp=$_REQUEST[Disp];
$siteid=$_REQUEST[id];                
$addrid=$_REQUEST[addrid];   
	$month = array("","Á¡ÃÒ¤Á", "¡ØÁÀҾѹ¸ì", "ÁÕ¹Ò¤Á", "àÁÉÒ¹", "¾ÄÉÀÒ¤Á", "ÁԶعÒ¹", "¡Ã¡®Ò¤Á", "ÊÔ§ËÒ¤Á", "¡Ñ¹ÂÒ¹", "µØÅÒ¤Á", "¾ÄȨԡÒ¹", "¸Ñ¹ÇÒ¤Á");
	$dd = date("j")   ; 
	$mm1 = date("n")  ; 
	$mm =  $month[$mm1] ; 
	$yy = date("Y") + 543 ; 
	$nowdd = " $dd $mm  $yy "  ; 
	$view_general = "view_general" ; 

$getdepid = $depid ;



?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../hr3/libary/style.css" type="text/css" rel="stylesheet">
<link href="../hr3/hr_report/images/style.css" type="text/css" rel="stylesheet">
<link href="../hr3/hr_report/images/style.css" type="text/css" rel="stylesheet" />
<link href="../libary/style.css" type="text/css" rel="stylesheet">
<link href="../hr_report/images/style.css" type="text/css" rel="stylesheet">
<title>ÃкººÑ¹·Ö¡Ë¹Ñ§Ê×ͤÓÊÑè§áÅкѭªÕṺ</title>
<script language="javascript">
function mOvr(src,clrOver){ 
	if (!src.contains(event.fromElement)) src.bgColor = clrOver; 
} 

function mOut(src,clrIn){ 
	if (!src.contains(event.toElement)) src.bgColor = clrIn; 
} 
	function hideSearch( my_id ){
		if( document.getElementById( my_id ).style.display == "none" ){
			document.getElementById( my_id ).style.display = "block";
			document.getElementById( "IM_"+my_id ).src = "img/folder-explorer-32x32.png";
			document.getElementById( "IM_"+my_id ).title = "«è͹¡Òäé¹ËÒ";
		}else{
			document.getElementById( my_id ).style.display = "none";
			document.getElementById( "IM_"+my_id ).src = "img/folder-explorer-32x32.png";
		document.getElementById( "IM_"+my_id ).title = "áÊ´§¡Òäé¹ËÒ";
		}
	}
	
	function demoDeleteConfirm(index_name,url)
	{
		if(confirm("Â×¹Âѹź  \"" + index_name+"\""))
		{
			window.location = url;
		}
	}
	
	function editConfirm(url)
	{
		window.location = url;
	}
	
</script>
<style type="text/css">
<!--
A:link {
	FONT-SIZE: 12px;color: #000000;	FONT-FAMILY: Tahoma,  "Microsoft Sans Serif";TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:visited {
	FONT-SIZE: 12px; COLOR: #000000; FONT-FAMILY: Tahoma,  "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:active {
	FONT-SIZE: 12px; COLOR: #014d5f; FONT-FAMILY: Tahoma,  "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
A:hover {
	FONT-SIZE: 12px; COLOR: #f3960b; FONT-FAMILY: Tahoma,  "Microsoft Sans Serif"; TEXT-DECORATION: underline;FONT-WEIGHT: bold;
}
-->
</style>
<script type="text/javascript">
document.write('<style type="text/css">.tabber{display:none;}<\/style>');
</script>
<script language=JavaScript> 

function CheckIsIE() 
{ 
if (navigator.appName.toUpperCase() == 'MICROSOFT INTERNET EXPLORER') { return true;} 
else { return false; } 
} 


function PrintThisPage() 
{ 

if (CheckIsIE() == true) 
{ 
parent.iframe1.focus(); 
parent.iframe1.print(); 
} 
else 
{ 
window.frames['iframe1'].focus(); 
window.frames['iframe1'].print(); 
} 

} 

 
</script> 
	 <script language="JavaScript">
function Conf(object) {
if (confirm("á¹èã¨ÇèÒ¨Ðź¢éÍÁÙÅ")==true) {
return true;
}
return false;
}



 </script>

</head>
<body>
<? include("header.php"); ?>
  <?


######### ÊÓËÃѺ ¹Óàʹ͵͹Ê觧ҹ ########
if($_SESSION['xsiteid'] == ''){
  $_SESSION['xsiteid'] = $_GET['xsiteid'];
  $proDigi = substr($_GET['xsiteid'],0,2);
}else{
  $proDigi = substr($_SESSION['xsiteid'],0,2);
}
####################################




function dateFormat($value,$type){
			if($type=="engthai"){
			
				$day = explode("-",$value);
				$date = $day[2].'-'.$day[1].'-'.($day[0]+543);			
					
			}else if($type=="thaieng"){
			
				$day = explode("-",$value);
				$date = ($day[2]-543).'-'.$day[1].'-'.$day[0];
				
			}else if($type=="thaidot"){
			
				$Month = array("", "Á.¤.", "¡.¾.", "ÁÕ.¤.", "àÁ.Â.", "¾.¤.", "ÁÔ.Â.", "¡.¤.", "Ê.¤.", "¡.Â.", "µ.¤.", "¾.Â.", "¸.¤.");
				$day = explode("-",$value);
				$Y = $day[0];
				$m = $day[1];
				if($m<10){
					$m = str_replace("0","",$m);
				}
				$d = $day[2]*1;
				$date = $d.' '.$Month[$m].' '.($Y+543);
				
			}else if($type==""){
			
				$date = explode("-",$value);
				
			}
			
			return $date;
		}
		
	function searchReplace($key="", $data = ""){
	/*	$arrS = explode(" ",$key);
		$replace = array();
		foreach($arrS as $value){
				$replace[] = '<span style="background:#FFCC99;">'.$value.'</span>';
		}*/
		$replace = '<span style="background:#FFCC99;">'.$key.'</span>';
		$data_replace = str_replace($key,$replace,$data);
		$data_replace = str_replace("Êӹѡ§Ò¹à¢µ¾×é¹·Õè¡ÒÃÈÖ¡ÉÒ", "ʾ·. ", $data_replace);
		$data_replace = str_replace("âçàÃÕ¹", "Ã.Ã. ", $data_replace);
		return $data_replace;
	}
	if($_GET['letter_id_del']){
		mysql_query("DELETE FROM command_letter_attach WHERE letter_id='".$_GET['letter_id_del']."' ");
		mysql_query("DELETE FROM command_letter WHERE letter_id='".$_GET['letter_id_del']."' ");
	}

if($_GET['action'] == "delete")
{
	$runid=$_GET['runid'];

	$sql = "DELETE FROM indicator WHERE runid='$runid' ";
	//echo $sql;
	//exit();

	$ret = mysql_db_query($db_name,$sql);
	print"<meta http-equiv=\"refresh\" content=\"0;URL=index.php\">\n";
}	

if($_GET['p'] == ''){
//$time_start = getmicrotime();
 
	
	/*$strSQL = "SELECT
						command_letter.letter_code,
						command_letter.letter_date,
						command_letter.letter_code2,
						command_letter.letter_name,
						command_letter.letter_id,
						command_letter.secid,
						(IF ( command_letter.letter_type=1, 'àÅ×è͹', 'ÂéÒÂ' ) ) AS LetterType,
						(SELECT COUNT(command_letter_attach.attach_id) FROM command_letter_attach WHERE command_letter_attach.letter_id=command_letter.letter_id) AS CountOfAttach,
						eduarea.secname
					FROM command_letter
					Inner Join eduarea ON command_letter.secid = eduarea.secid
					"; //echo $strSQL;*/
					/*$strSQL = "SELECT
										command_letter.letter_code,
										command_letter.letter_code2,
										command_letter.letter_date,
										command_letter.letter_name,
										command_letter.letter_id,
										command_letter.secid,
										command_letter_type.letter_type_name AS LetterType,
										command_letter.letter_type,
										command_letter.dateadd,
										command_letter.letter_by,
										command_letter.letter_status,
										(
											SELECT
												COUNT(command_letter_attach.attach_id)
											FROM
												command_letter_attach
											WHERE
												command_letter_attach.letter_id=command_letter.letter_id
										) AS CountOfAttach,
										eduarea.secname
									FROM
										command_letter
										Inner Join command_letter_type ON command_letter.letter_type = command_letter_type.letter_type
										Inner Join eduarea ON command_letter.secid = eduarea.secid
										*/
										
										$strSQL = "SELECT i.*,f.freq_name FROM indicator i left join indicator_frequency f on i.upd_freq=f.runid";					//echo $strSQL;
										//exit();
										/*
									";
					//Bebin Search
					if($_GET['b_search'] != ""){
						$strSQL .= " WHERE command_letter.letter_id != '' ";
						
						if($_GET['letter_name_search'] != ""){
							$strSQL .= " AND command_letter.letter_name  LIKE('%".$_GET['letter_name_search']."%')  ";
						}
						if($_GET['letter_secname_search'] != ""){
							$strSQL .= " AND eduarea.secname  LIKE('%".$_GET['letter_secname_search']."%')  ";
						}
						if($_GET['LetterType_search'] != ""){
							$strSQL .= " AND  command_letter.letter_type  = '".$_GET['LetterType_search']."' ";
						}
						if($_GET['letter_code_search'] != "" || $_GET['letter_code2_search'] != ""){
							$strSQL .= " AND  (command_letter.letter_code  LIKE ('%".$_GET['letter_code_search']."%') AND  command_letter.letter_code2  LIKE ('%".$_GET['letter_code2_search']."%') ) ";
						}
						if($_GET['name_search']){
						
						   $sql_check = "SELECT letter_id FROM command_letter_attach WHERE firstname LIKE '%".$_GET['name_search']."%' ";
						   $query_check = mysql_query($sql_check);
						   while($rows_check = mysql_fetch_array($query_check)){
						     $arr_id[] = $rows_check['letter_id'];
						   }
						   $str_id = @implode(",",$arr_id);
						
						  $strSQL .= " AND command_letter.letter_id IN(".$str_id.")  ";
						  $arr_id = '';
						}
						if($_GET['letter_surname_search']){
						
						   $sql_check = "SELECT letter_id FROM command_letter_attach WHERE surname LIKE '%".$_GET['letter_surname_search']."%' ";
						   $query_check = mysql_query($sql_check);
						   while($rows_check = mysql_fetch_array($query_check)){
						     $arr_id[] = $rows_check['letter_id'];
						   }
						   $str_id = @implode(",",$arr_id);
						
						  $strSQL .= " AND command_letter.letter_id IN(".$str_id.")  ";
						  $arr_id = '';
						}
						if($_GET['date_order'] != ''){
						  $arr_start = explode("/",$_GET['date_order']);
						  $date_start = ($arr_start[2] - 543)."-".$arr_start[1]."-".$arr_start[0];
						  $strSQL .= " AND letter_date >= '$date_start' ";
						}
						if($_GET['date_order2'] != ''){
						  $arr_end = explode("/",$_GET['date_order2']);
						  $date_end = ($arr_end[2] - 543)."-".$arr_end[1]."-".$arr_end[0];
						  $strSQL .= " AND letter_date <= '$date_end' ";
						}
						
						//###sak###
						if($_GET['sum_action'] != '')
						{
							if($_GET['sum_action'] != 'sum_no_check')
							{
								$strSQL .= " AND not letter_status in (1,2) ";	
							}
							elseif($_GET['sum_action'] != 'sum_check')
							{
								$strSQL .= " AND letter_status in (1,2) ";	
							}
							else
							{
								$strSQL .= " AND letter_status = '".$_GET['sum_action']."' ";	
							}
						}


						//
					}
					//End Search
					//Bebin Order
					$strSQL .= "ORDER BY	command_letter.letter_code2 ASC, command_letter.letter_code ASC";
					//End Order
					//echo $strSQL;
					*/
	$rsConn = mysql_query($strSQL);
	$Rows = mysql_num_rows($rsConn);
	
	//$time_e 	= getmicrotime();
	//$stime		= number_format($time_e - $time_start,12);
?>
<table width="100%" border="0" cellspacing="5" cellpadding="0">
  <tr>
    <td width="51%" align="left">&nbsp;</td>
    <td width="49%" align="right">
	<!--[ <strong><a href="book_insert.php">à¾ÔèÁ˹ѧÊ×ͤÓÊÑè§</a></strong> ]-->
	<!--<a href="javascript:popupaddnew();" style="color:#3399CC" ><img id="IM_tb_seearch" src="img/folder-explorer-32x32.png" align="absmiddle"/><strong>¤é¹ËÒ</strong></a>--></td>
  </tr>
    <tr>
    <td colspan="2" align="right">
	
	
<?php
if($_GET['b_search'] == ''){
  include "exsumary.php";
}  
?>	
<br>
<br>
	
	
		</td>
  </tr>
  <tr>
    <td colspan="2">
	
<?php
	if($_GET['b_search']){
?>	
	<table width="100%" border="0" cellpadding="0" cellspacing="2" bgcolor="#E6E6E6" align="center" style="border:1px solid #5595CC;">
	<tr align="right">
	<td >
	
		<strong>¤é¹ËÒ¤ÓÇèÒ</strong>
		&nbsp; <?php echo ($_GET['letter_code_search'] != "" || $_GET['letter_code2_search'] != "")?'"'.$_GET['letter_code_search'].'/'.$_GET['letter_code2_search'].'"':"";?>
		&nbsp; <?php echo ($_GET['letter_secname_search'] != "")?'"'.$_GET['letter_secname_search'].'"':"";?>
		&nbsp; <?php echo ($_GET['letter_name_search'] != "")?'"'.$_GET['letter_name_search'].'"':"";?>
		&nbsp;
	<?php
		$strSQL_letter_type = "SELECT * FROM command_letter_type  WHERE  letter_type='".$_GET['LetterType_search']."' ";
		$rsConn_letter_type = mysql_query($strSQL_letter_type);
		$Result_letter_type = mysql_fetch_assoc($rsConn_letter_type);
		echo ($_GET['LetterType_search'] != "")?'"'.$Result_letter_type['letter_type_name'].'"':"";
	
	?>	</td>
</tr>
<tr align="right">
	<td height="20">
	ÃÒ¡ÒÃ˹ѧÊ×ͤÓÊÑ觷Ñé§ÊÔé¹ <strong><?=number_format($Rows)?></strong> ÃÒ¡ÒÃ
	(ãªéàÇÅÒ㹡ÒûÃÐÁÇżšè͹¡ÒÃáÊ´§ÇÔ¹Ò·Õ)&nbsp;</td>
</tr>
</table>
    <strong>
    <?=$stime?>
    </strong>    <?php
}
?></td>
  </tr>
  <tr>
    <td colspan="2">
<table width="100%" border="0">
  <tr>
    <td width="65%"  align="left">
	
<?php
	 	$rsConn = mysql_query($strSQL);
		$all_row = mysql_num_rows($rsConn);
		$board_row_per_page = 10;
		$total_page = ceil($all_row/$board_row_per_page);
		$page = ($_GET['page'])?$_GET['page']:1;
		$page = ($page > $total_page)?$total_page:$page;
		$page = ($page <= 0)?1:$page;
		$limit_start = ($page==1)?0:(($page*$board_row_per_page)-$board_row_per_page);
		$limit_end = $board_row_per_page;
		if($View==''){
			$strSQL .= " LIMIT ".$limit_start.", ".$limit_end;
			$num = $limit_start ;
		}
		
		if(isset($cols)&&isset($sort)){
			$solink="&cols=$cols&sort=$sort";
		}
		
		$text_search =  ($_GET['b_search'])?"b_search=¤é¹ËÒ&letter_code_search=".$_GET['letter_code_search']."&letter_code2_search=".$_GET['letter_code2_search']."&letter_name_search=".$_GET['letter_name_search']."&letter_secname_search=".$_GET['letter_secname_search']."&LetterType_search=".$_GET['LetterType_search']."&name_search=".$_GET['name_search']."&letter_surname_search=".$_GET['letter_surname_search']."&date_order=".$_GET['date_order']."&date_order2=".$_GET['date_order2']:"";
		$prev_page = $page - 1; $prev_page = ($prev_page <= 1)?1:$prev_page;
		$prev = "self.location='".$PHP_SELF."?".$text_search."&search=$search&page=$prev_page$link$solink'";
		$next_page = $page + 1; $next_page = ($next_page >= $total_page)?$total_page:$next_page;
		$next = "self.location='".$PHP_SELF."?".$text_search."&search=$search&page=$next_page$link$solink'";
		
		$prev_Tenpage=$page-$board_row_per_page;$prev_Tenpage=($prev_Tenpage<= 1)?1:$prev_Tenpage;
		$prevTen = "self.location='".$PHP_SELF."?".$text_search."&search=$search&page=$prev_Tenpage$link$solink'";
		$nextTenPage=$page+$board_row_per_page;$next_TenPage=($next_TenPage >= $total_page)?$total_page:$next_TenPage;
		$nextTen = "self.location='".$PHP_SELF."?".$text_search."&search=$search&page=$nextTenPage$link$solink'";
	?>
	<? if($View==""){$Klink="?".$text_search."&View=All"; $CSh="¢éÍÁÙÅ·Ñé§ËÁ´"; $Klink2="?".$text_search."&View=";}else{$Klink="?".$text_search."&View=";$CSh="¢éÍÁÙÅ ".$board_row_per_page." ÃÒ¡ÒÃÅèÒÊØ´";$Klink2="?".$text_search."&View=All";}?>
	·Ñé§ËÁ´ <b> <font color="#CC0000">
	<?=number_format($all_row);?>
	</font> </b> ÃÒ¡ÒÃ
	<? if($View==""){?>
	áºè§à»ç¹ <b><font color="#0033CC">
	<?=number_format($total_page);?>
	</font></b> ˹éÒ
	<? }?>
	&nbsp;&nbsp;<a href="<?=$Klink?>"><img src="img/Search-Add.gif" alt="<?=$CSh?>" width="16" height="16" border="0" /></a>&nbsp;&nbsp;&nbsp;&nbsp;
		  <? if($View==''){?>
			<?  if($page==1){?>
			<img src="img/page_div_icon/xFirst.gif" />
			<? }else{?>
			<img src="img/page_div_icon/First.gif" align="absmiddle" border="0" width="10" height="12"  onclick="<?=$prevTen;?>" onMouseOver="style.cursor='hand';"/>
			<? }?>
	&nbsp;
	<?  if($page==1){?>
	<img src="img/page_div_icon/xPrevious.gif" />
	<? }else{?>
	<img src="img/page_div_icon/Previous.gif" align="absmiddle" border="0" width="7" height="12"  onclick="<?=$prev;?>" onMouseOver="style.cursor='hand';"/>
	<? }?>
	<?php
	$board_link_num = $board_row_per_page;
	$ii = 1;
	if ( $board_link_num > $total_page ){
		$loop_page = $total_page;
	
	} else {
		$bx = ceil($board_link_num / 2);
		$pp = $page - $bx;
		$pn = $page + $bx;
		$loop_page = $pn;
		$ii = $pp;
		if ( $total_page <= $loop_page ) {
			$loop_page = $total_page;
			$ii = $loop_page - ($board_link_num -1);
		}
		if ( $ii < 1 ) {
			$ii = 1;
			$loop_page = $ii + ($board_link_num -1);
		}
	}
	
	for($i=$ii;$i<=$loop_page;$i++){
		if ( $i==$page || !$page ) {
			$txt = "<b>$i</b>";
		} else {
			$txt = $i;
	
		}
	?>
	<a href="<?=$PHP_SELF;?>?Sort=<?=$Sort;?>&search=<?=$search?>&<?=$text_search?>&page=<?=$i;?>"><?=$txt;?>
	</a>
	<?
	} # for
	?>
	<? if($page==$loop_page){?>
	<img src="img/page_div_icon/xNext.gif" />
	<? }else{?>
	<img src="img/page_div_icon/Next.gif" align="absmiddle" border="0" width="7" height="12" onClick="<?=$next;?>" onMouseOver="style.cursor='hand';"/>
	<? }?>
	&nbsp;
	<? if($page==$loop_page){?>
	<img src="img/page_div_icon/xLast.gif" />

	<? }else{?>
	<img src="img/page_div_icon/Last.gif" align="absmiddle" border="0" width="10" height="12" onClick="<?=$nextTen;?>" onMouseOver="style.cursor='hand';"/>
	<? } }#End View=
		?>	</td>
    <td width="35%" align="right"><strong><a href="insert_master.php">
      <input type="button" name="btn_" value= "à¾ÔèÁµÑǪÕéÇÑ´" onclick="window.location='insert_master.php';"/>
    </a></strong></td>
	    </tr>
</table>



<?php
if($_GET['b_search'] == ''){
?>
	<table border="0" width="100%" cellspacing="1" cellpadding="2" bgcolor="black" align="center" style="margin-top:5px; margin-bottom:5px;">
      <tr bgcolor="#A3B2CC" align="center" >
        <td width="40" rowspan="2"><strong>ÅӴѺ</strong></td>
        <td rowspan="2"><strong>µÑǪÕéÇÑ´</strong></td>
        <td width="100" height="24" rowspan="2"><strong>áËÅ觢éÍÁÙÅ/<br />˹èǧҹ<br />·ÕèÃѺ¼Ô´ªÍº</strong></td>
        <td height="24" colspan="5"><strong>¢éÍÁÙżšÒôÓà¹Ô¹§Ò¹Âé͹ËÅѧ <br />
        áÅлѨ¨ØºÑ¹»Õ ¾.È. <?=date('Y')+543?></strong></td>
		<td width="50" height="24" rowspan="2" ><strong></strong><strong>¤ÇÒÁ¶Õè㹡Òà update <br />¢éÍÁÙÅ</strong></td>
		<td width="100" height="24" rowspan="2" ><strong></strong><strong>ËÁÒÂà˵Ø</strong></td>
		<td width="40" height="24" rowspan="2" ><strong>¨Ñ´¡ÒÃ</strong></td>
        </tr>
      <tr bgcolor="#A3B2CC" align="center" >

          <?
			$strSQL_Year = "select  substring(date_format(now(),'%Y')+543,3,2)  from dual";
			$rsConn_Year = mysql_query($strSQL_Year);
			$yy = "";
			$yy_global="";
			while ( $Result = mysql_fetch_array($rsConn_Year) ) {
				$yy = $Result[0];
			}
			$yy="";
			$yy = $yy=="" ? date("Y")+543:$yy;
			//echo date("Y")+543;
			//exit();
			$yy_global = $yy;

?>
	 
        <td width="50" height="24"> <strong><?= $yy-4?></strong></td>
		<td width="50"><strong><?= $yy-3?></strong></td>
		<td width="50"><strong><?= $yy-2?></strong></td>
		<td width="50"><strong><?= $yy-1?></strong></td>
		<td width="50"><strong>
		
		  <?= $yy?>
		</strong></td>
		</tr>
<?
if($_GET['debug']=="on"){echo $strSQL; }

	$rsConn = mysql_query($strSQL);
	//echo "<br>num rows:".mysql_num_rows($rsConn);
	
	while ( $Result = mysql_fetch_assoc($rsConn) ) {
		$intA += 1;
		$color = ( $intA % 2 == 0 ) ? "#DDDDDD" : "#EFEFEF" ;
		$rowNumb = ($intA+($board_link_num*$page)-$board_link_num);
		/*
		$SQL = "SELECT COUNT(doc_id) AS CountOfDoc FROM command_letter_file WHERE letter_id='".$Result['letter_id']."'";
		$Conn = mysql_query($SQL);
		$Row = mysql_fetch_object($Conn);
		
		$SQL_check_file = "SELECT COUNT(doc_id) AS CountOfDoc FROM command_letter_check_file WHERE letter_id='".$Result['letter_id']."'";
		$Conn_check_file = mysql_query($SQL_check_file);
		$Row_check_file = mysql_fetch_object($Conn_check_file);
		
		$SQL2 = "SELECT COUNT(doc_id) AS CountOfDoc FROM command_letter_attach_file WHERE letter_id='".$Result['letter_id']."'";
		$Conn2 = mysql_query($SQL2);
		$Row2 = mysql_fetch_object($Conn2);
		*/
?>
      <tr align="center" bgcolor="<?=$color?>" onmouseover="this.style.backgroundColor='#dbf2ae'" onmouseout="this.style.backgroundColor='<?=$color?>'">
        <td><?=$rowNumb?></td>
        <td>
		  <div align="left">
		    <?=$Result['index_name'] ?>
	      </div></td>
        <td>&nbsp;<?=$Result['source'] ?>		</td>
		          <?
		    //$index_name = $Result['index_name'];
			//$source = $Result['source'];
			//$remark = $Result['remark'];
			
			//$strSQL_Point = "select  y_text, if((1+point)=1,point,format(point,4)) as avgpoint,upd_freq as cnt_upd_freq from operator where trim(index_name)='$index_name' and source='$source' and remark='$remark' group by y_text,upd_freq order by y_text desc limit 5";
			$runid = $Result[runid];//from table indicator
			$strsql_point = " select * from indicator i inner join indicator_detail id on i.runid = id.indicator_id";
			$strsql_point .= " where i.runid = '$runid'";
			$strsql_point .= " order by id.y_text desc limit 5";
			
			$rsConn_Point = mysql_query($strsql_point);
			//echo $strsql_point;
			//exit();
			$i=0;
			
			unset($point);
			
			$yyyy=$yy_global;
			$sum_cnt_upd_freq=0;
			$arr = array();
			
			while ( $ResPoint = mysql_fetch_array($rsConn_Point)) {
				$sum_cnt_upd_freq=$ResPoint['upd_freq'];
				$yyyy=$yy_global;
				$arr[$ResPoint[y_text]] =  $ResPoint[score];
			}
			//$yy_global = "";
			
			
?>
		 <td align="center"><?=$arr[$yyyy-4]?>	</td>
		 <td align="center"><?=$arr[$yyyy-3] ?></td>
		 <td align="center"><?=$arr[$yyyy-2] ?></td>
		 <td align="center"><?=$arr[$yyyy-1] ?></td>
		 <td align="center"><?=$arr[$yyyy] ?></td>
        <td align="left">
		  <div align="center">
		    <?=$Result[freq_name] ?>	
	      </div></td>
		<td align="left"><?=$Result[remark] ?></td>
			<?
			$url_delete = "?action=delete&runid=".$Result[runid];
			$url_update = "insert_master.php?action=update&runid=".$Result[runid];
			?>
		<td align="left"><a href="javascript:editConfirm('<?=$url_update?>')"><img src="img/b_edit.png"></img></a>
		<a href="javascript:demoDeleteConfirm('<?=$Result[index_name]?>','<?=$url_delete?>')"><img src="img/b_drop.png"></img></a></td>
		
      </tr>
<?
	}
?>
    </table>
<br />
<?php
}else{

   $rsConn = mysql_query($strSQL);
	while ( $Result = mysql_fetch_assoc($rsConn) ) {
		$intA += 1;
		$color = ( $intA % 2 == 0 ) ? "#DDDDDD" : "#EFEFEF" ;
		$rowNumb = ($intA+($board_link_num*$page)-$board_link_num);
		
		$SQL = "SELECT COUNT(doc_id) AS CountOfDoc FROM command_letter_file WHERE letter_id='".$Result['letter_id']."'";
		$Conn = mysql_query($SQL);
		$Row = mysql_fetch_object($Conn);
		
		$SQL_check_file = "SELECT COUNT(doc_id) AS CountOfDoc FROM command_letter_check_file WHERE letter_id='".$Result['letter_id']."'";
		$Conn_check_file = mysql_query($SQL_check_file);
		$Row_check_file = mysql_fetch_object($Conn_check_file);
		
		$SQL2 = "SELECT COUNT(doc_id) AS CountOfDoc FROM command_letter_attach_file WHERE letter_id='".$Result['letter_id']."'";
		$Conn2 = mysql_query($SQL2);
		$Row2 = mysql_fetch_object($Conn2);
		
?>
<br>
<br>

<table width="700" border="0" cellspacing="0" cellpadding="3">
  <tr>
    <td><a href="?p=show_detail&letter_id=<?=$Result['letter_id']?>"><font color="#0000FF"><b>¤ÓÊÑè§àÅ¢·Õè  <?=searchReplace($_GET['letter_code_search'],$Result['letter_code'])."/".searchReplace($_GET['letter_code2_search'],$Result['letter_code2'])?></b></font></a></td>
  </tr>
  <tr>
    <td>
	<?=searchReplace($_GET['letter_name_search'],$Result['letter_name'])?>
	
	</td>
  </tr>
  <tr>
    <td>
	<font color="#009900">
	<strong>˹èǧҹ :</strong> 
	<?=searchReplace($_GET['letter_secname_search'],$Result['secname'])?>
	&nbsp;&nbsp;&nbsp;<strong>ÊÑè§ ³ Çѹ·Õè :</strong> 
	<?=($Result['letter_date']!="")?dateFormat($Result['letter_date'],"thaidot"):"-";?>
	</font>	</td>
  </tr>
</table>
<table width="700" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td><hr size="1" style="border-color:#CCCCCC;"></td>
  </tr>
</table>

<?php
		
	}//end while	

}
?>	
	
	
	
	
	
	
	
	</td>
  </tr>
  <tr>
    <td height="18" colspan="2">&nbsp;</td>
  </tr>
</table>
<?php
}else{
  include $_GET[p].".php";
 
}
?>
<p>&nbsp; </p>
</body>
</html>

Anon7 - 2021