Gecko [ 122.154.134.11 ]

Name	Size	Permission
bootstrap	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
install	[ DIR ]	drwxr-xr-x
manual	[ DIR ]	drwxr-xr-x
check.php	9.96 KB	-rw-r--r--
check00.php	9.49 KB	-rwxr-xr-x
check00_2.php	8.21 KB	-rwxr-xr-x
check_2.php	8.63 KB	-rw-r--r--
css.css	1.06 KB	-rwxr-xr-x
default.php	252 B	-rwxr-xr-x
index.php	246 B	-rwxr-xr-x
menu.php	2.38 KB	-rwxr-xr-x
menu_mobile.php	734 B	-rwxr-xr-x
permission.php	8.22 KB	-rwxr-xr-x
person.php	16.4 KB	-rwxr-xr-x
repor00t_1.php	8.19 KB	-rwxr-xr-x
report_1.php	8.49 KB	-rw-r--r--
report_1_mobile.php	5.09 KB	-rwxr-xr-x
report_2.php	8.05 KB	-rwxr-xr-x
report_3.php	6.55 KB	-rwxr-xr-x
report_4y.php	7.61 KB	-rwxr-xr-x
time_inc.php	4.76 KB	-rwxr-xr-x

Code Editor : report_4y.php

<link rel="stylesheet" type="text/css" href="./modules/work/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="./modules/work/bootstrap/css/bootstrap.css">
<script src="./modules/work/bootstrap/js/bootstrap.js"></script>
<script src="./modules/work/bootstrap/js/bootstrap.min.js"></script>
<link rel="stylesheet" type="text/css" href="css/mm_training.css">

if (document.getElementsByTagName != null){
var txtheadTags = document.getElementsByTagName('head');
if (txtheadTags.length > 0){
var str=txtheadTags[0].innerHTML;
txt += str; // str.replace(/funChkLoad();/ig, ” “);
}
}
//txt += 'nn';
if (printReady != null){
txt += printReady.innerHTML;
}
//txt +='nn';
var printWin = window.open();
printWin.document.open();
printWin.document.write(txt);
printWin.document.close();
printWin.print();
}
// –>
</script>

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
if(!($_SESSION['login_status']<=5)){
exit();
}

//แปลงรูปแบบ date
if(isset($_GET['datepicker'])){
$f1_date=$_GET['datepicker']-543; 
$thai_year=$f1_date+543;
$start_date=$f1_date."-01-01";
$end_date=$f1_date."-12-31";
    
}
else{
$f1_date=date('Y');
$start_date=$f1_date."-01-01";
$end_date=$f1_date."-12-31";
$thai_year=$f1_date+543;
}

echo "<br />";

?>
    
<div class="container">
  <div class="panel panel-default"  >
      <div class="panel-heading"><h3 class="panel-title"><b>การปฏิบัติราชการในรอบปี พ.ศ.<?php echo $thai_year;?></b></h3></div>
<?php

$currentYear = date('Y')+543;
    ?>
      <div class="panel-body" >
        <form id='frm1' name='frm1' class="form-horizontal">
        <div class="row">
            <div class="col-md-10 text-left">
                <ul class="nav nav-pills">
                    <li role="presentation" class=""><a >รายงาน 5 ปีย้อนหลัง</a></li>
                <?php 
    $i=0;
    $y=$f1_date+543;
    while($i<5){
         $active="";
        if($y==($currentYear-$i)) $active="active";
        ?>
                  <li role="presentation" class="<?=$active?>"><a href="?option=work&task=report_4y&datepicker=<?=$currentYear-$i?>"><?=$currentYear-$i?></a></li>
        <?php $i++;}?>
                </ul>
            </div>
            
       </div>
        </form>
          </div>
      <table class="table table-hover table-striped table-condensed table-responsive">
          <thead >
<?php
//ส่วนรายละเอียด

$sql_post = "select * from  person_position";
$dbquery_post = mysqli_query($connect,$sql_post);
While ($result_post = mysqli_fetch_array($dbquery_post)){
$position_ar[$result_post['position_code']]=$result_post['position_name'];
}

$sql_name = "select * from person_main order by department,position_code,person_order";
$dbquery_name = mysqli_query($connect,$sql_name);
While ($result_name = mysqli_fetch_array($dbquery_name)){
		$person_id = $result_name['person_id'];
		$prename=$result_name['prename'];
		$name= $result_name['name'];
		$surname = $result_name['surname'];
		$position_code = $result_name['position_code'];
$full_name_ar[$person_id]="$prename$name&nbsp;&nbsp;$surname";
$position_code_ar[$person_id]=$position_code;
}

$sql_work = "select distinct work_main.person_id from work_main left join person_main on work_main.person_id=person_main.person_id where work_main.work_date between '$start_date' and '$end_date' order by person_main.department, person_main.position_code, person_main.person_order";

$dbquery_work = mysqli_query($connect,$sql_work);
$num_rows=mysqli_num_rows($dbquery_work);

if($num_rows<1){
echo "<div align='center'><font color='#CC0000' size='3'>ไม่มีรายการ</font></div>";
echo exit();
}
//echo  "<table width='98%' border='0' align='center'>";
echo "<Tr  align='center'><Th width='50'>ที่</Th>";
echo "  <Th>ชื่อ</Th>
        <Th>ตำแหน่ง</Th>
        <Th width='40' bgcolor='#CCFFFF'>มา</Th>
        <Th width='40'>ไปราชการ</Th>
        <Th width='40' bgcolor='#CCFFFF'>ลาป่วย</Th>
        <Th width='40'>ลากิจ</Th>
        <Th width='40' bgcolor='#CCFFFF'>ลาพักผ่อน</Th>
        <Th width='40'>ลาคลอด</Th>
        <Th width='40' bgcolor='#CCFFFF'>ลาอื่นๆ</Th>
        <Th width='40'>มาสาย</Th>
        <Th width='40' bgcolor='#CCFFFF'>ไม่มา</Th>
        </Tr>";
?>
          </thead>
          <tbody>
<?php
$N=1;
While ($result_work = mysqli_fetch_array($dbquery_work)){
		$person_id = $result_work['person_id'];
		
						if(($N%2) == 0)
						$color="#FFFFC";
						else  	$color="#FFFFFF";
						
$work_1_sum=0; $work_2_sum=0; $work_3_sum=0;	$work_4_sum=0;	$work_5_sum=0;	$work_6_sum=0;	$work_7_sum=0;	$work_8_sum=0;	$work_9_sum=0;		
	
			$sql = "select  work from work_main where person_id='$person_id' and work_date between '$start_date' and '$end_date' ";
			$dbquery= mysqli_query($connect,$sql);
			While ($result = mysqli_fetch_array($dbquery)){
			if($result['work']==1){
			$work_1_sum=$work_1_sum+1;
			}
			else if($result['work']==2){
			$work_2_sum=$work_2_sum+1;
			
			}
			else if($result['work']==3){
			$work_3_sum=$work_3_sum+1;
			}			
			else if($result['work']==4){
			$work_4_sum=$work_4_sum+1;
			}			
			else if($result['work']==5){
			$work_5_sum=$work_5_sum+1;
			}			
			else if($result['work']==6){
			$work_6_sum=$work_6_sum+1;
			}			
			else if($result['work']==7){
			$work_7_sum=$work_7_sum+1;
			}			
			else if($result['work']==8){
			$work_8_sum=$work_8_sum+1;
			}			
			else if($result['work']==9){
			$work_9_sum=$work_9_sum+1;
			}			
			}

echo "<tr >";
echo "<td align='center'>$N</td><td>";
if(isset($full_name_ar[$person_id])){
echo "<a href='modules/work/report_3.php?person_id=$person_id&start_date=$start_date&end_date=$end_date' target='_blank'>$full_name_ar[$person_id]</a>";
}
else{
echo "<a href='modules/work/report_3.php?person_id=$person_id&start_date=$start_date&end_date=$end_date' target='_blank'>ไมมีรายชื่อ($person_id)</a>";
}
echo"</td>";
echo "<td>";
	if(isset($position_ar[$position_code_ar[$person_id]])){
	echo $position_ar[$position_code_ar[$person_id]];
	}
echo "</td>";
if($work_1_sum==0){
$work_1_sum="";
}
if($work_2_sum==0){
$work_2_sum="";
}
if($work_3_sum==0){
$work_3_sum="";
}
if($work_4_sum==0){
$work_4_sum="";
}
if($work_5_sum==0){
$work_5_sum="";
}
if($work_6_sum==0){
$work_6_sum="";
}
if($work_7_sum==0){
$work_7_sum="";
}
if($work_8_sum==0){
$work_8_sum="";
}
if($work_9_sum==0){
$work_9_sum="";
}

echo "<td align='center' bgcolor='#CCFFFF'>$work_1_sum</td><td align='center'>$work_2_sum</td><td align='center' bgcolor='#CCFFFF'>$work_3_sum</td><td align='center'>$work_4_sum</td><td align='center' bgcolor='#CCFFFF'>$work_5_sum</td><td align='center'>$work_6_sum</td><td align='center' bgcolor='#CCFFFF'>$work_7_sum</td><td align='center'>$work_8_sum</td><td align='center' bgcolor='#CCFFFF'>$work_9_sum</td>";
echo "</tr>";
$N++;
}
echo "</tbody>";
echo "</table>";
?>

</div>
    </div>

</div>

${this.title}

Code Editor : report_4y.php